{"action":"created","issue":{"url":"https://api.github.com/repos/oar-team/oar/issues/11","labels_url":"https://api.github.com/repos/oar-team/oar/issues/11/labels{/name}","comments_url":"https://api.github.com/repos/oar-team/oar/issues/11/comments","events_url":"https://api.github.com/repos/oar-team/oar/issues/11/events","html_url":"https://github.com/oar-team/oar/issues/11","id":52661746,"number":11,"title":"Mysql bug with OAR 2.5.4","user":{"login":"npf","id":424014,"avatar_url":"https://avatars.githubusercontent.com/u/424014?v=3","gravatar_id":"","url":"https://api.github.com/users/npf","html_url":"https://github.com/npf","followers_url":"https://api.github.com/users/npf/followers","following_url":"https://api.github.com/users/npf/following{/other_user}","gists_url":"https://api.github.com/users/npf/gists{/gist_id}","starred_url":"https://api.github.com/users/npf/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/npf/subscriptions","organizations_url":"https://api.github.com/users/npf/orgs","repos_url":"https://api.github.com/users/npf/repos","events_url":"https://api.github.com/users/npf/events{/privacy}","received_events_url":"https://api.github.com/users/npf/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/oar-team/oar/labels/bug","name":"bug","color":"fc2929"},{"url":"https://api.github.com/repos/oar-team/oar/labels/g5k","name":"g5k","color":"c7def8"},{"url":"https://api.github.com/repos/oar-team/oar/labels/question","name":"question","color":"cc317c"}],"state":"open","locked":false,"assignee":{"login":"capitn","id":8918129,"avatar_url":"https://avatars.githubusercontent.com/u/8918129?v=3","gravatar_id":"","url":"https://api.github.com/users/capitn","html_url":"https://github.com/capitn","followers_url":"https://api.github.com/users/capitn/followers","following_url":"https://api.github.com/users/capitn/following{/other_user}","gists_url":"https://api.github.com/users/capitn/gists{/gist_id}","starred_url":"https://api.github.com/users/capitn/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/capitn/subscriptions","organizations_url":"https://api.github.com/users/capitn/orgs","repos_url":"https://api.github.com/users/capitn/repos","events_url":"https://api.github.com/users/capitn/events{/privacy}","received_events_url":"https://api.github.com/users/capitn/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/oar-team/oar/milestones/3","labels_url":"https://api.github.com/repos/oar-team/oar/milestones/3/labels","id":912358,"number":3,"title":"2.5.4-2","description":"milestone for the next release of the debian and centos packages for OAR 2.5.4","creator":{"login":"npf","id":424014,"avatar_url":"https://avatars.githubusercontent.com/u/424014?v=3","gravatar_id":"","url":"https://api.github.com/users/npf","html_url":"https://github.com/npf","followers_url":"https://api.github.com/users/npf/followers","following_url":"https://api.github.com/users/npf/following{/other_user}","gists_url":"https://api.github.com/users/npf/gists{/gist_id}","starred_url":"https://api.github.com/users/npf/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/npf/subscriptions","organizations_url":"https://api.github.com/users/npf/orgs","repos_url":"https://api.github.com/users/npf/repos","events_url":"https://api.github.com/users/npf/events{/privacy}","received_events_url":"https://api.github.com/users/npf/received_events","type":"User","site_admin":false},"open_issues":2,"closed_issues":0,"state":"open","created_at":"2014-12-22T16:03:16Z","updated_at":"2015-01-20T21:17:21Z","due_on":null,"closed_at":null},"comments":2,"created_at":"2014-12-22T15:57:26Z","updated_at":"2015-01-20T21:17:21Z","closed_at":null,"body":"Hello,\r\n\r\nWe have tried to update our OAR installation on the Luxembourg site of\r\nG5K last thursday, from 2.5.3 to 2.5.4, but we have encountered\r\nseveral problems and finally rolled back to 2.5.3.\r\n\r\nThe OAR server is installed in a debian squeeze VM. We use mysql\r\nversion 5.1.63-0+squeeze1, in a separated debian squeeze VM.\r\nThe frontend is running under debian wheezy.\r\n\r\nMy upgrade procedure looks like this:\r\n\r\n# Update the oar packages:\r\n\r\n@oar: sudo apt-get remove oar-admin\r\n@frontend,www,oar: sudo apt-get update\r\n@frontend,www,oar: sudo apt-get install $(dpkg -l | grep oar- | awk\r\n'{print $2}')\r\n\r\n# Update the OAR database\r\n\r\n@oar: sudo service oar-server stop\r\n@oar: oar-database --check\r\n@oar: oar-database --upgrade\r\n@oar: sudo service oar-server start\r\n\r\n\r\nThe web services (drawgantt, monika) are working correctly and the\r\nfrontend is fine.\r\n\r\nHowever, I've noticed strange errors in the logs emitted by the\r\nMetaSched component:\r\n\r\n* typing errors:\r\n\r\nArgument \"granduc-12.luxembourg.grid5000.fr\" isn't numeric in vec at\r\n/usr/lib/oar/oar_meta_sched line 342.\r\n\r\n* SQL errors:\r\n\r\nDBD::mysql::db do failed: You have an error in your SQL syntax; check\r\nthe manual that corresponds to your MySQL server version for the right\r\nsyntax to use near 'luxembourg.grid5000.\r\nfr),(53069,granduc-13.luxembourg.grid5000.fr),(53069,granduc' at line\r\n2 at /usr/share/perl5/OAR/IO.pm line 6270.\r\n\r\n* Locked tables and duplicated primary keys:\r\n\r\n[debug] [2014-11-20 10:24:47.133] [MetaSched] Starting Meta Scheduler\r\n[debug] [2014-11-20 10:24:47.136] [MetaSched] Retrieve information for\r\nalready scheduler reservations from database before flush (keep assign\r\nresources)\r\nDBD::mysql::db do failed: Can't execute the given command because you\r\nhave active locked tables or an active transaction at\r\n/usr/share/perl5/OAR/IO.pm line 6485.\r\nDBD::mysql::db do failed: Can't execute the given command because you\r\nhave active locked tables or an active transaction at\r\n/usr/share/perl5/OAR/IO.pm line 6486.\r\nDBD::mysql::db do failed: Duplicate entry '0' for key 'PRIMARY' at\r\n/usr/share/perl5/OAR/IO.pm line 6294.\r\n\r\n\r\nDBD::mysql::db do failed: Duplicate entry '53069' for key 'PRIMARY' at\r\n/usr/share/perl5/OAR/IO.pm line 6261.\r\nDBD::mysql::db do failed: You have an error in your SQL syntax; check\r\nthe manual that corresponds to your MySQL server version for the right\r\nsyntax to use near 'luxembourg.grid5000.\r\nfr),(53069,granduc-19.luxembourg.grid5000.fr),(53069,granduc' at line\r\n2 at /usr/share/perl5/OAR/IO.pm line 6270.\r\n\r\n\r\n[debug] [2014-11-20 10:27:17.210] [MetaSched] Begin processing of jobs\r\nto launch (start time <= 2014-11-20 10:27:17)\r\n[debug] [2014-11-20 10:27:17.213] [MetaSched] End processing of jobs to launch\r\nDBD::mysql::db do failed: Can't execute the given command because you\r\nhave active locked tables or an active transaction at\r\n/usr/share/perl5/OAR/IO.pm line 6372.\r\nDBD::mysql::db do failed: Can't execute the given command because you\r\nhave active locked tables or an active transaction at\r\n/usr/share/perl5/OAR/IO.pm line 6373.\r\nDBD::mysql::db do failed: Duplicate entry '53085' for key 'PRIMARY' at\r\n/usr/share/perl5/OAR/IO.pm line 6375.\r\nDBD::mysql::db do failed: Duplicate entry '53083-721' for key\r\n'PRIMARY' at /usr/share/perl5/OAR/IO.pm line 6380.\r\n\r\n\r\n\r\nAlso, after some stress tests, the queue was \"stalled\" and not\r\nrescheduled on new events (in example, jobs finishing before the end\r\nof their walltime).\r\nAt this point, I've exported the logs and a dump of the database, and\r\nI've rolled back to 2.5.3.\r\nI suspect that I've forgotten something, or done something wrong with\r\nthe database upgrade.\r\n\r\nAny idea / hint?\r\n\r\nThanks for your help,\r\n\r\nBest regards,\r\n\r\n-- Hyacinthe Cartiaux"},"comment":{"url":"https://api.github.com/repos/oar-team/oar/issues/comments/70735295","html_url":"https://github.com/oar-team/oar/issues/11#issuecomment-70735295","issue_url":"https://api.github.com/repos/oar-team/oar/issues/11","id":70735295,"user":{"login":"npf","id":424014,"avatar_url":"https://avatars.githubusercontent.com/u/424014?v=3","gravatar_id":"","url":"https://api.github.com/users/npf","html_url":"https://github.com/npf","followers_url":"https://api.github.com/users/npf/followers","following_url":"https://api.github.com/users/npf/following{/other_user}","gists_url":"https://api.github.com/users/npf/gists{/gist_id}","starred_url":"https://api.github.com/users/npf/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/npf/subscriptions","organizations_url":"https://api.github.com/users/npf/orgs","repos_url":"https://api.github.com/users/npf/repos","events_url":"https://api.github.com/users/npf/events{/privacy}","received_events_url":"https://api.github.com/users/npf/received_events","type":"User","site_admin":false},"created_at":"2015-01-20T21:17:21Z","updated_at":"2015-01-20T21:17:21Z","body":"Bug is actually fixed by a previous commit"}}