| *** championofcyrodi has joined #murano | 00:18 | |
| championofcyrodi | DBDuplicateEntry showing up in fuel 5.1 deployment. just delete the db entry or what? | 00:18 |
|---|---|---|
| championofcyrodi | DBDuplicateEntry: (IntegrityError) (1062, "Duplicate entry '0dc5c66d16b04d48b07c868cc195f46a-ost1_test-Murano_env01' for key 'tenant_id'") | 00:18 |
| *** openstack has joined #murano | 01:34 | |
| championofcyrodi | i should also say. I originally suffered from the bug in which the rabbitmq installation script was the rabbitmq script for nova. So I was getting connection refused for a while. | 01:55 |
| championofcyrodi | (because the userid & pw stored in murano.conf did not match. so i switched them to use the nova userid and password. then restarted the murano services. | 01:56 |
| championofcyrodi | on my 3 controllers running icehouse via fuel in HA mode. | 01:57 |
| *** lazy_prince has joined #murano | 02:15 | |
| *** lazy_prince has left #murano | 02:16 | |
| *** dsdf has joined #murano | 05:32 | |
| *** dsdf has quit IRC | 05:37 | |
| *** Miouge has joined #murano | 07:52 | |
| openstackgerrit | Ekaterina Chernova proposed stackforge/murano-dashboard: Use Form instead of one-step workflow https://review.openstack.org/144304 | 08:48 |
| openstackgerrit | Ekaterina Chernova proposed stackforge/murano-dashboard: Show reason of failure during package upload https://review.openstack.org/137004 | 08:49 |
| openstackgerrit | Ekaterina Chernova proposed stackforge/murano-dashboard: Use Form instead of one-step workflow https://review.openstack.org/144304 | 08:50 |
| openstackgerrit | Ekaterina Chernova proposed stackforge/murano-dashboard: Use Form instead of one-step workflow https://review.openstack.org/144304 | 09:49 |
| katyafervent | Hi championofcyrodi | 10:05 |
| katyafervent | are you getting this error during the deployment? | 10:06 |
| katyafervent | yes, you can try to clean environments table in 'murano' table. what DB are you using? | 10:06 |
| openstackgerrit | Ekaterina Chernova proposed stackforge/murano-specs: Add enable-category-management specification https://review.openstack.org/139630 | 10:23 |
| openstackgerrit | Filip Blaha proposed stackforge/murano: Functional tests for policy enforcement https://review.openstack.org/147515 | 10:27 |
| openstackgerrit | Dmytro Dovbii proposed stackforge/murano-agent: Fix typo in Murano Agent https://review.openstack.org/147808 | 10:35 |
| openstackgerrit | Dmytro Dovbii proposed stackforge/murano-agent: Fix typo in Murano Agent https://review.openstack.org/147808 | 10:37 |
| *** rvasilets_ has left #murano | 10:58 | |
| openstackgerrit | Filip Blaha proposed stackforge/murano: Functional tests for policy enforcement https://review.openstack.org/147515 | 12:14 |
| openstackgerrit | Dmytro Dovbii proposed stackforge/murano-agent: Fix 'is' statement to 'in' in Murano Agent https://review.openstack.org/147808 | 12:35 |
| championofcyrodi | katyafervent: Hi | 12:48 |
| championofcyrodi | Yes. This is occurring during deployment. | 12:49 |
| katyafervent | Do you have full traceback? could you please paste it to paste.openstack.org? | 12:49 |
| championofcyrodi | The INSERT statement is in the error, so I can identify the record marked as a dupllicate | 12:49 |
| championofcyrodi | sure. | 12:50 |
| championofcyrodi | http://paste.openstack.org/show/158249/ | 12:51 |
| katyafervent | Murano engine is responsible for the deployment | 12:51 |
| championofcyrodi | mysqldb | 12:51 |
| championofcyrodi | I understand. I need to leave my home and go to my work place. Be back in 15 minutes or so. | 12:52 |
| katyafervent | and it seems to me that it is not using database | 12:52 |
| katyafervent | do you see this error permanently? | 12:52 |
| katyafervent | championofcyrodi, lucky you, just 15 minutes to go to work :) | 12:53 |
| *** championofcyrod1 has joined #murano | 12:53 | |
| championofcyrodi | :) | 12:54 |
| *** championofcyrodi has quit IRC | 12:54 | |
| championofcyrod1 | the Duplicate entry error leads me to believe it has a database connection. However, the record was already in the environment table. | 13:30 |
| championofcyrod1 | katyafervent^ | 13:30 |
| slagun | championofcyrod1: hi! | 13:31 |
| championofcyrod1 | was wondering if it is possible that because murano rabbitmq server connection was down, database synchronization across the 3 instances did not work properly? | 13:31 |
| championofcyrod1 | slagun: hello! | 13:31 |
| slagun | from your stacktrace I see that you creating second environment with the same name | 13:31 |
| championofcyrod1 | interesting. I am using a diagnostic feature of the mirantis fuel 5.1 server. | 13:33 |
| championofcyrod1 | "health check" | 13:33 |
| championofcyrod1 | perhaps this is an issue with fuel then. | 13:33 |
| slagun | ost1_test-Murano_env01 looks like a name generated by test. Probably it hasn't cleaned up from previous run and doesn't use random names | 13:34 |
| championofcyrod1 | so would it be safe for me to manually remove the entry from the mysqldb? | 13:34 |
| championofcyrod1 | my concern is that there could be other foreign key relationships in the database w/ that entry. | 13:35 |
| slagun | you could delete them as well | 13:35 |
| slagun | from "sessions" table | 13:35 |
| championofcyrod1 | okay. I have removed the entry from the environment table... | 13:40 |
| championofcyrod1 | looking for the key 003e0811f5234e1f9886efb4f27827a4 in sessions table then... | 13:40 |
| championofcyrod1 | 'id' i guess... | 13:40 |
| slagun | environment_id | 13:40 |
| championofcyrod1 | ah found it... (the only entry) | 13:41 |
| championofcyrod1 | nvm, there are two.. it is one of two. | 13:41 |
| championofcyrod1 | interesting. there is no entry in the session table that matches the environment_id from the conflicting entry | 13:42 |
| championofcyrod1 | http://paste.openstack.org/show/158253/ | 13:43 |
| slagun | you need to 1) DELETE from session where environment_id = d2e71ba446294a4182b986ef12055488 2) DELETE from environment where ID = d2e71ba446294a4182b986ef12055488 | 13:43 |
| championofcyrod1 | "from session where environment_id = d2e71ba446294a4182b986ef12055488" does not exist | 13:44 |
| slagun | thats okay | 13:45 |
| championofcyrod1 | environment where ID = d2e71ba446294a4182b986ef12055488 does not exist either. | 13:46 |
| championofcyrod1 | sweet | 13:46 |
| championofcyrod1 | fixed! | 13:46 |
| championofcyrod1 | removing the entry environment WHERE id = '003e0811f5234e1f9886efb4f27827a4'; allowed the health check to successfully finish. | 13:47 |
| slagun | id = 003e0811f5234e1f9886efb4f27827a4 | 13:47 |
| slagun | yes | 13:47 |
| championofcyrod1 | How did you know the session table possibly had foreign key constraints? | 13:48 |
| championofcyrod1 | are the constraints objects in the mysqldb? | 13:48 |
| championofcyrod1 | ah... 'SHOW CREATE TABLE <table>; will show the SQL with constraint information. clever. | 13:49 |
| slagun | I know from https://github.com/stackforge/murano/blob/master/murano/db/models.py#L111 but those constraints are in MySQL so there should be a way to look up there | 13:49 |
| openstackgerrit | Ekaterina Chernova proposed stackforge/murano-specs: Add enable-category-management specification https://review.openstack.org/139630 | 13:50 |
| championofcyrod1 | so the environment table does not have a key constraint. but the session table does. | 13:50 |
| championofcyrod1 | CONSTRAINT `session_ibfk_1` FOREIGN KEY (`environment_id`) REFERENCES `environment` (`id`) | 13:51 |
| slagun | sessions reference environments. Environments reference nothing :) | 13:51 |
| championofcyrod1 | so it is likely that the environments is populated 1st. | 13:51 |
| slagun | this is a primary key constraint which is present in every table | 13:51 |
| championofcyrod1 | well thank you so much for your time. I will document this on my blog for others. Most of my googling only resulted in Ekaterina's posts about handling the exception with a custom murano exception. | 13:52 |
| slagun | I think this is just a bug in tests. Maybe random issue | 13:53 |
| championofcyrod1 | yes. it should cleanup the test records if they already exist. | 13:53 |
| *** Miouge_ has joined #murano | 13:56 | |
| *** Miouge has quit IRC | 13:59 | |
| *** Miouge_ is now known as Miouge | 13:59 | |
| openstackgerrit | Merged stackforge/murano-agent: Fix 'is' statement to 'in' in Murano Agent https://review.openstack.org/147808 | 14:24 |
| openstackgerrit | Ekaterina Chernova proposed stackforge/murano-dashboard: Add category management page https://review.openstack.org/147565 | 14:46 |
| openstackgerrit | Ekaterina Chernova proposed stackforge/python-muranoclient: Enable category management support https://review.openstack.org/147873 | 15:01 |
| openstackgerrit | Ekaterina Chernova proposed stackforge/murano-dashboard: Show reason of failure during package upload https://review.openstack.org/137004 | 15:08 |
| *** drupalmonkey has joined #murano | 15:20 | |
| openstackgerrit | Ondrej Vojta proposed stackforge/murano: Initial implementation of policy enforcement point https://review.openstack.org/142458 | 15:31 |
| openstackgerrit | Ekaterina Chernova proposed stackforge/murano-dashboard: Change application index default sort from 'created' to 'name' https://review.openstack.org/134647 | 16:03 |
| openstackgerrit | Merged stackforge/murano-dashboard: Fix catalog view in case no application uploaded https://review.openstack.org/143999 | 16:13 |
| *** Miouge has quit IRC | 16:19 | |
| *** Miouge has joined #murano | 16:21 | |
| *** drupalmonkey has quit IRC | 16:48 | |
| *** drupalmonkey has joined #murano | 16:50 | |
| *** Miouge has quit IRC | 18:00 | |
| *** Miouge has joined #murano | 18:17 | |
| *** stan_lagun has joined #murano | 21:23 | |
| *** slagun has quit IRC | 21:26 | |
| *** openstackgerrit has quit IRC | 23:19 | |
| *** openstackgerrit has joined #murano | 23:19 | |
| *** drupalmonkey has quit IRC | 23:48 | |
Generated by irclog2html.py 2.14.0 by Marius Gedminas - find it at mg.pov.lt!