{"id":419,"date":"2012-12-11T20:54:25","date_gmt":"2012-12-11T16:54:25","guid":{"rendered":"http:\/\/elhana.ru\/?p=419"},"modified":"2016-07-02T15:57:58","modified_gmt":"2016-07-02T11:57:58","slug":"mysql-upgrade-error-start-failed","status":"publish","type":"post","link":"https:\/\/elhana.ru\/?p=419","title":{"rendered":"mysql upgrade error – start failed"},"content":{"rendered":"

Was upgrading today and got this:<\/p>\n

Setting up mysql-server-5.5 (5.5.28-0ubuntu0.12.10.1) ...\r\nstart: Job failed to start\r\ninvoke-rc.d: initscript mysql, action \"start\" failed.\r\ndpkg: error processing mysql-server-5.5 (--configure):\r\n subprocess installed post-installation script returned error exit status 1\r\n<\/pre>\n
yay, so it can’t start for some reason..
\n#tail -n 20 \/var\/log\/mysql\/error.log:<\/p>\n
121211 20:37:00 [Note] Plugin 'FEDERATED' is disabled.\r\n121211 20:37:00 InnoDB: The InnoDB memory heap is disabled\r\n121211 20:37:00 InnoDB: Mutexes and rw_locks use GCC atomic builtins\r\n121211 20:37:00 InnoDB: Compressed tables use zlib 1.2.7\r\n121211 20:37:00 InnoDB: Using Linux native AIO\r\n121211 20:37:00 InnoDB: Initializing buffer pool, size = 128.0M\r\n121211 20:37:00 InnoDB: Completed initialization of buffer pool\r\n121211 20:37:00 InnoDB: highest supported file format is Barracuda.\r\n121211 20:37:00  InnoDB: Operating system error number 22 in a file operation.\r\nInnoDB: Error number 22 means 'Invalid argument'.\r\nInnoDB: Some operating system error numbers are described at\r\nInnoDB: http:\/\/dev.mysql.com\/doc\/refman\/5.5\/en\/operating-system-error-codes.html\r\nInnoDB: File name .\/ib_logfile0\r\nInnoDB: File operation call: 'aio write'.\r\nInnoDB: Cannot continue operation.\r\n<\/pre>\n
Google says aio on tmpfs doesn’t work. I don’t want mysql to store it’s crap on my disk – it is just my desktop db and I don’t need it to be blazing fast and contribute to ssd wear.<\/p>\n
Solution in my case is innodb_use_native_aio = 0<\/strong> in my.cnf<\/p>\n","protected":false},"excerpt":{"rendered":"
Was upgrading today and got this: Setting up mysql-server-5.5 (5.5.28-0ubuntu0.12.10.1) … start: Job failed to start invoke-rc.d: initscript mysql, action “start” failed. dpkg: error processing mysql-server-5.5 (–configure): subprocess installed post-installation script returned error exit status 1 yay, so it can’t … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17],"tags":[21,18,20,19],"class_list":["post-419","post","type-post","status-publish","format-standard","hentry","category-linux","tag-aio","tag-mysql","tag-native","tag-tmpfs"],"_links":{"self":[{"href":"https:\/\/elhana.ru\/index.php?rest_route=\/wp\/v2\/posts\/419","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/elhana.ru\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/elhana.ru\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/elhana.ru\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/elhana.ru\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=419"}],"version-history":[{"count":5,"href":"https:\/\/elhana.ru\/index.php?rest_route=\/wp\/v2\/posts\/419\/revisions"}],"predecessor-version":[{"id":463,"href":"https:\/\/elhana.ru\/index.php?rest_route=\/wp\/v2\/posts\/419\/revisions\/463"}],"wp:attachment":[{"href":"https:\/\/elhana.ru\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=419"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/elhana.ru\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=419"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/elhana.ru\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=419"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}