{"action":"created","issue":{"url":"https://api.github.com/repos/owncloud/updater/issues/331","repository_url":"https://api.github.com/repos/owncloud/updater","labels_url":"https://api.github.com/repos/owncloud/updater/issues/331/labels{/name}","comments_url":"https://api.github.com/repos/owncloud/updater/issues/331/comments","events_url":"https://api.github.com/repos/owncloud/updater/issues/331/events","html_url":"https://github.com/owncloud/updater/issues/331","id":151089456,"number":331,"title":"BrokenUpdaterRepair SQL issue","user":{"login":"PVince81","id":277525,"avatar_url":"https://avatars.githubusercontent.com/u/277525?v=3","gravatar_id":"","url":"https://api.github.com/users/PVince81","html_url":"https://github.com/PVince81","followers_url":"https://api.github.com/users/PVince81/followers","following_url":"https://api.github.com/users/PVince81/following{/other_user}","gists_url":"https://api.github.com/users/PVince81/gists{/gist_id}","starred_url":"https://api.github.com/users/PVince81/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/PVince81/subscriptions","organizations_url":"https://api.github.com/users/PVince81/orgs","repos_url":"https://api.github.com/users/PVince81/repos","events_url":"https://api.github.com/users/PVince81/events{/privacy}","received_events_url":"https://api.github.com/users/PVince81/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/owncloud/updater/labels/bug","name":"bug","color":"fc2929"},{"url":"https://api.github.com/repos/owncloud/updater/labels/sev1-critical","name":"sev1-critical","color":"e11d21"}],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/owncloud/updater/milestones/49","html_url":"https://github.com/owncloud/updater/milestones/9.0.2-current-maintenance","labels_url":"https://api.github.com/repos/owncloud/updater/milestones/49/labels","id":1632579,"number":49,"title":"9.0.2-current-maintenance","description":null,"creator":{"login":"MorrisJobke","id":245432,"avatar_url":"https://avatars.githubusercontent.com/u/245432?v=3","gravatar_id":"","url":"https://api.github.com/users/MorrisJobke","html_url":"https://github.com/MorrisJobke","followers_url":"https://api.github.com/users/MorrisJobke/followers","following_url":"https://api.github.com/users/MorrisJobke/following{/other_user}","gists_url":"https://api.github.com/users/MorrisJobke/gists{/gist_id}","starred_url":"https://api.github.com/users/MorrisJobke/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MorrisJobke/subscriptions","organizations_url":"https://api.github.com/users/MorrisJobke/orgs","repos_url":"https://api.github.com/users/MorrisJobke/repos","events_url":"https://api.github.com/users/MorrisJobke/events{/privacy}","received_events_url":"https://api.github.com/users/MorrisJobke/received_events","type":"User","site_admin":false},"open_issues":2,"closed_issues":11,"state":"open","created_at":"2016-03-09T09:57:29Z","updated_at":"2016-04-26T13:44:19Z","due_on":"2016-05-03T04:00:00Z","closed_at":null},"comments":7,"created_at":"2016-04-26T09:45:00Z","updated_at":"2016-04-26T14:02:46Z","closed_at":null,"body":"### Steps\r\n\r\n1. Setup owncloud-9.0.0.tar.bz2\r\n1. Go to admin page\r\n1. Set channel to \"daily\"\r\n1. Open updater\r\n1. Start update\r\n\r\n### Expected result\r\nUpdater runs fine\r\n\r\n### Actual result\r\nHangs on \"Updating core\", CPU is at 100%, log contains these:\r\n```\r\nSQLSTATE[08S01]: Communication link failure: 1153 Got a packet bigger than 'max_allowed_packet' bytes\\\",\\\"Code\\\":0,\\\"Trace\\\":\\\"#0 \\\\\\/srv\\\\\\/www\\\\\\/htdocs\\\\\\/owncloudtest\\\\\\/3rdparty\\\\\\/doctrine\\\\\\/dbal\\\\\\/lib\\\\\\/Doctrine\\\\\\/DBAL\\\\\\/DBALException.php(116): Doctrine\\\\\\\\DBAL\\\\\\\\Driver\\\\\\\\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\\\\\\\\DBAL\\\\\\\\Driver\\\\\\\\PDOException))\\\\n#1 \\\\\\/srv\\\\\\/www\\\\\\/htdocs\\\\\\/owncloudtest\\\\\\/3rdparty\\\\\\/doctrine\\\\\\/dbal\\\\\\/lib\\\\\\/Doctrine\\\\\\/DBAL\\\\\\/Connection.php(996): Doctrine\\\\\\\\DBAL\\\\\\\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\\\\\\\DBAL\\\\\\\\Driver\\\\\\\\PDOMySql\\\\\\\\Driver), Object(Doctrine\\\\\\\\DBAL\\\\\\\\Driver\\\\\\\\PDOException), 'INSERT INTO `oc...', Array)\\\\n#2 \\\\\\/srv\\\\\\/www\\\\\\/htdocs\\\\\\/owncloudtest\\\\\\/lib\\\\\\/private\\\\\\/db\\\\\\/connection.php(205): Doctrine\\\\\\\\DBAL\\\\\\\\Connection->executeUpdate('INSERT INTO `oc...', Array, Array)\\\\n#3 \\\\\\/srv\\\\\\/www\\\\\\/htdocs\\\\\\/owncloudtest\\\\\\/lib\\\\\\/private\\\\\\/db\\\\\\/adapter.php(93): OC\\\\\\\\DB\\\\\\\\Connection->executeUpdate('INSERT INTO `*P...', Array)\\\\n#4 \\\\\\/srv\\\\\\/www\\\\\\/htdocs\\\\\\/owncloudtest\\\\\\/lib\\\\\\/private\\\\\\/db\\\\\\/connection.php(243): OC\\\\\\\\DB\\\\\\\\Adapter->insertIfNotExist('*PREFIX*appconf...', Array, Array)\\\\n#5 \\\\\\/srv\\\\\\/www\\\\\\/htdocs\\\\\\/owncloudtest\\\\\\/lib\\\\\\/private\\\\\\/appconfig.php(158): OC\\\\\\\\DB\\\\\\\\Connection->insertIfNotExist('*PREFIX*appconf...', Array, Array)\\\\n#6 \\\\\\/srv\\\\\\/www\\\\\\/htdocs\\\\\\/owncloudtest\\\\\\/lib\\\\\\/private\\\\\\/allconfig.php(160): OC\\\\\\\\AppConfig->setValue('core', 'oc.integrityche...', '{\\\\\\\"core\\\\\\\":{\\\\\\\"EXTRA...')\\\\n#7 \\\\\\/srv\\\\\\/www\\\\\\/htdocs\\\\\\/owncloudtest\\\\\\/lib\\\\\\/private\\\\\\/integritycheck\\\\\\/checker.php(431): OC\\\\\\\\AllConfig->setAppValue('core', 'oc.integrityche...', '{\\\\\\\"core\\\\\\\":{\\\\\\\"EXTRA...')\\\\n#8 \\\\\\/srv\\\\\\/www\\\\\\/htdocs\\\\\\/owncloudtest\\\\\\/lib\\\\\\/private\\\\\\/integritycheck\\\\\\/checker.php(544): OC\\\\\\\\IntegrityCheck\\\\\\\\Checker->storeResults('core', Array)\\\\n#9 \\\\\\/srv\\\\\\/www\\\\\\/htdocs\\\\\\/owncloudtest\\\\\\/lib\\\\\\/private\\\\\\/integritycheck\\\\\\/checker.php(555): OC\\\\\\\\IntegrityCheck\\\\\\\\Checker->verifyCoreSignature()\\\\n#10 \\\\\\/srv\\\\\\/www\\\\\\/htdocs\\\\\\/owncloudtest\\\\\\/lib\\\\\\/private\\\\\\/repair\\\\\\/brokenupdaterrepair.php(96): OC\\\\\\\\IntegrityCheck\\\\\\\\Checker->runInstanceVerification()\\\\n#11 \\\\\\/srv\\\\\\/www\\\\\\/htdocs\\\\\\/owncloudtest\\\\\\/lib\\\\\\/private\\\\\\/repair\\\\\\/brokenupdaterrepair.php(102): OC\\\\\\\\Repair\\\\\\\\BrokenUpdaterRepair->recheckIntegrity()\\\\n#12 \\\\\\/srv\\\\\\/www\\\\\\/htdocs\\\\\\/owncloudtest\\\\\\/lib\\\\\\/private\\\\\\/repair.php(87): OC\\\\\\\\Repair\\\\\\\\BrokenUpdaterRepair->run()\\\\n#13 \\\\\\/srv\\\\\\/www\\\\\\/htdocs\\\\\\/owncloudtest\\\\\\/lib\\\\\\/private\\\\\\/updater.php(346): OC\\\\\\\\Repair->run()\\\\n#14 \\\\\\/srv\\\\\\/www\\\\\\/htdocs\\\\\\/owncloudtest\\\\\\/lib\\\\\\/private\\\\\\/updater.php(215): OC\\\\\\\\Updater->doUpgrade('9.0.1.3', '9.0.0.19')\\\\n#15 \\\\\\/srv\\\\\\/www\\\\\\/htdocs\\\\\\/owncloudtest\\\\\\/core\\\\\\/command\\\\\\/upgrade.php(246): OC\\\\\\\\Updater->upgrade()\\\\n#16 \\\\\\/srv\\\\\\/www\\\\\\/htdocs\\\\\\/owncloudtest\\\\\\/3rdparty\\\\\\/symfony\\\\\\/console\\\\\\/Command\\\\\\/Command.php(259): OC\\\\\\\\Core\\\\\\\\Command\\\\\\\\Upgrade->execute(Object(Symfony\\\\\\\\Component\\\\\\\\Console\\\\\\\\Input\\\\\\\\ArgvInput), Object(Symfony\\\\\\\\Component\\\\\\\\Console\\\\\\\\Output\\\\\\\\ConsoleOutput))\\\\n#17 \\\\\\/srv\\\\\\/www\\\\\\/htdocs\\\\\\/owncloudtest\\\\\\/core\\\\\\/command\\\\\\/base.php(158): Symfony\\\\\\\\Component\\\\\\\\Console\\\\\\\\Command\\\\\\\\Command->run(Object(Symfony\\\\\\\\Component\\\\\\\\Console\\\\\\\\Input\\\\\\\\ArgvInput), Object(Symfony\\\\\\\\Component\\\\\\\\Console\\\\\\\\Output\\\\\\\\ConsoleOutput))\\\\n#18 \\\\\\/srv\\\\\\/www\\\\\\/htdocs\\\\\\/owncloudtest\\\\\\/3rdparty\\\\\\/symfony\\\\\\/console\\\\\\/Application.php(840): OC\\\\\\\\Core\\\\\\\\Command\\\\\\\\Base->run(Object(Symfony\\\\\\\\Component\\\\\\\\Console\\\\\\\\Input\\\\\\\\ArgvInput), Object(Symfony\\\\\\\\Component\\\\\\\\Console\\\\\\\\Output\\\\\\\\ConsoleOutput))\\\\n#19 \\\\\\/srv\\\\\\/www\\\\\\/htdocs\\\\\\/owncloudtest\\\\\\/3rdparty\\\\\\/symfony\\\\\\/console\\\\\\/Application.php(192): Symfony\\\\\\\\Component\\\\\\\\Console\\\\\\\\Application->doRunCommand(Object(OC\\\\\\\\Core\\\\\\\\Command\\\\\\\\Upgrade), Object(Symfony\\\\\\\\Component\\\\\\\\Console\\\\\\\\Input\\\\\\\\ArgvInput), Object(Symfony\\\\\\\\Component\\\\\\\\Console\\\\\\\\Output\\\\\\\\ConsoleOutput))\\\\n#20 \\\\\\/srv\\\\\\/www\\\\\\/htdocs\\\\\\/owncloudtest\\\\\\/3rdparty\\\\\\/symfony\\\\\\/console\\\\\\/Application.php(123): Symfony\\\\\\\\Component\\\\\\\\Console\\\\\\\\Application->doRun(Object(Symfony\\\\\\\\Component\\\\\\\\Console\\\\\\\\Input\\\\\\\\ArgvInput), Object(Symfony\\\\\\\\Component\\\\\\\\Console\\\\\\\\Output\\\\\\\\ConsoleOutput))\\\\n#21 \\\\\\/srv\\\\\\/www\\\\\\/htdocs\\\\\\/owncloudtest\\\\\\/lib\\\\\\/private\\\\\\/console\\\\\\/application.php(145): Symfony\\\\\\\\Component\\\\\\\\Console\\\\\\\\Application->run(NULL, NULL)\\\\n#22 \\\\\\/srv\\\\\\/www\\\\\\/htdocs\\\\\\/owncloudtest\\\\\\/console.php(88): OC\\\\\\\\Console\\\\\\\\Application->run()\\\\n#23 \\\\\\/srv\\\\\\/www\\\\\\/htdocs\\\\\\/owncloudtest\\\\\\/occ(11): require_once('\\\\\\/srv\\\\\\/www\\\\\\/htdocs...')\\\\n#24 {main}\\\",\\\"File\\\":\\\"\\\\\\/srv\\\\\\/www\\\\\\/htdocs\\\\\\/owncloudtest\\\\\\/3rdparty\\\\\\/doctrine\\\\\\/dbal\\\\\\/lib\\\\\\/Doctrine\\\\\\/DBAL\\\\\\/Driver\\\\\\/AbstractMySQLDriver.php\\\",\\\"Line\\\":115}\",\"level\":3,\"time\":\"2016-04-26T09:36:13+00:00\",\"method\":\"--\",\"url\":\"--\",\"user\":\"--\"}\r\n```\r\n\r\napparently related to BrokenUpdaterRepair.\r\n\r\nWill attach the full log soon.\r\n"},"comment":{"url":"https://api.github.com/repos/owncloud/updater/issues/comments/214755438","html_url":"https://github.com/owncloud/updater/issues/331#issuecomment-214755438","issue_url":"https://api.github.com/repos/owncloud/updater/issues/331","id":214755438,"user":{"login":"PVince81","id":277525,"avatar_url":"https://avatars.githubusercontent.com/u/277525?v=3","gravatar_id":"","url":"https://api.github.com/users/PVince81","html_url":"https://github.com/PVince81","followers_url":"https://api.github.com/users/PVince81/followers","following_url":"https://api.github.com/users/PVince81/following{/other_user}","gists_url":"https://api.github.com/users/PVince81/gists{/gist_id}","starred_url":"https://api.github.com/users/PVince81/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/PVince81/subscriptions","organizations_url":"https://api.github.com/users/PVince81/orgs","repos_url":"https://api.github.com/users/PVince81/repos","events_url":"https://api.github.com/users/PVince81/events{/privacy}","received_events_url":"https://api.github.com/users/PVince81/received_events","type":"User","site_admin":false},"created_at":"2016-04-26T14:02:46Z","updated_at":"2016-04-26T14:02:46Z","body":"Can we move \"store __apps in data folder\" to 9.0.3 ? Running out of time and there are other updater issues that need adressing"}}