Public bug reported: my former running mysql-5.5 database stopped working after the upgrade. what can I do?
root@server:~# service mysql start start: Job failed to start root@server:~# lsb_release -a No LSB modules are available. Distributor ID: Ubuntu Description: Ubuntu 14.04.3 LTS Release: 14.04 Codename: trusty root@server:~# apt-cache policy mysql-server-5.6 mysql-server-5.6: Installiert: 5.6.27-0ubuntu0.14.04.1 Installationskandidat: 5.6.27-0ubuntu0.14.04.1 Versionstabelle: *** 5.6.27-0ubuntu0.14.04.1 0 500 http://de.archive.ubuntu.com/ubuntu/ trusty-updates/universe amd64 Packages 500 http://security.ubuntu.com/ubuntu/ trusty-security/universe amd64 Packages 100 /var/lib/dpkg/status 5.6.16-1~exp1 0 500 http://de.archive.ubuntu.com/ubuntu/ trusty/universe amd64 Packages tail -f /var/log/mysql/mysql.log /var/log/mysql/error.log ==> /var/log/mysql/mysql.log <== ==> /var/log/mysql/error.log <== 2015-11-01 23:51:04 1457 [Note] Shutting down plugin 'CSV' 2015-11-01 23:51:04 1457 [Note] Shutting down plugin 'MEMORY' 2015-11-01 23:51:04 1457 [Note] Shutting down plugin 'MRG_MYISAM' 2015-11-01 23:51:04 1457 [Note] Shutting down plugin 'MyISAM' 2015-11-01 23:51:04 1457 [Note] Shutting down plugin 'sha256_password' 2015-11-01 23:51:04 1457 [Note] Shutting down plugin 'mysql_old_password' 2015-11-01 23:51:04 1457 [Note] Shutting down plugin 'mysql_native_password' 2015-11-01 23:51:04 1457 [Note] Shutting down plugin 'binlog' 2015-11-01 23:51:04 1457 [Note] /usr/sbin/mysqld: Shutdown complete 2015-11-01 23:54:49 2827 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 2015-11-01 23:54:49 2827 [Note] Plugin 'FEDERATED' is disabled. /usr/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13 - Permission denied) 2015-11-01 23:54:49 2827 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 2015-11-01 23:54:49 2827 [Note] InnoDB: Using atomics to ref count buffer pool pages 2015-11-01 23:54:49 2827 [Note] InnoDB: The InnoDB memory heap is disabled 2015-11-01 23:54:49 2827 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2015-11-01 23:54:49 2827 [Note] InnoDB: Memory barrier is not used 2015-11-01 23:54:49 2827 [Note] InnoDB: Compressed tables use zlib 1.2.8 2015-11-01 23:54:49 2827 [Note] InnoDB: Using Linux native AIO 2015-11-01 23:54:49 2827 [Note] InnoDB: Not using CPU crc32 instructions 2015-11-01 23:54:49 2827 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2015-11-01 23:54:49 2827 [Note] InnoDB: Completed initialization of buffer pool 2015-11-01 23:54:49 2827 [ERROR] InnoDB: ./ibdata1 can't be opened in read-write mode 2015-11-01 23:54:49 2827 [ERROR] InnoDB: The system tablespace must be writable! 2015-11-01 23:54:49 2827 [ERROR] Plugin 'InnoDB' init function returned error. 2015-11-01 23:54:49 2827 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2015-11-01 23:54:49 2827 [ERROR] Unknown/unsupported storage engine: InnoDB 2015-11-01 23:54:49 2827 [ERROR] Aborting 2015-11-01 23:54:49 2827 [Note] Binlog end 2015-11-01 23:54:49 2827 [Note] Shutting down plugin 'partition' 2015-11-01 23:54:49 2827 [Note] Shutting down plugin 'BLACKHOLE' 2015-11-01 23:54:49 2827 [Note] Shutting down plugin 'ARCHIVE' 2015-11-01 23:54:49 2827 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2015-11-01 23:54:49 2827 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2015-11-01 23:54:49 2827 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2015-11-01 23:54:49 2827 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2015-11-01 23:54:49 2827 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2015-11-01 23:54:49 2827 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2015-11-01 23:54:49 2827 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2015-11-01 23:54:49 2827 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2015-11-01 23:54:49 2827 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2015-11-01 23:54:49 2827 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2015-11-01 23:54:49 2827 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2015-11-01 23:54:49 2827 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2015-11-01 23:54:49 2827 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2015-11-01 23:54:49 2827 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2015-11-01 23:54:49 2827 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2015-11-01 23:54:49 2827 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2015-11-01 23:54:49 2827 [Note] Shutting down plugin 'INNODB_METRICS' 2015-11-01 23:54:49 2827 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2015-11-01 23:54:49 2827 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2015-11-01 23:54:49 2827 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2015-11-01 23:54:49 2827 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2015-11-01 23:54:49 2827 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2015-11-01 23:54:49 2827 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2015-11-01 23:54:49 2827 [Note] Shutting down plugin 'INNODB_CMPMEM' 2015-11-01 23:54:49 2827 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2015-11-01 23:54:49 2827 [Note] Shutting down plugin 'INNODB_CMP' 2015-11-01 23:54:49 2827 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2015-11-01 23:54:49 2827 [Note] Shutting down plugin 'INNODB_LOCKS' 2015-11-01 23:54:49 2827 [Note] Shutting down plugin 'INNODB_TRX' 2015-11-01 23:54:49 2827 [Note] Shutting down plugin 'CSV' 2015-11-01 23:54:49 2827 [Note] Shutting down plugin 'MEMORY' 2015-11-01 23:54:49 2827 [Note] Shutting down plugin 'MRG_MYISAM' 2015-11-01 23:54:49 2827 [Note] Shutting down plugin 'MyISAM' 2015-11-01 23:54:49 2827 [Note] Shutting down plugin 'sha256_password' 2015-11-01 23:54:49 2827 [Note] Shutting down plugin 'mysql_old_password' 2015-11-01 23:54:49 2827 [Note] Shutting down plugin 'mysql_native_password' 2015-11-01 23:54:49 2827 [Note] Shutting down plugin 'binlog' 2015-11-01 23:54:49 2827 [Note] /usr/sbin/mysqld: Shutdown complete 2015-11-01 23:54:50 2871 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 2015-11-01 23:54:50 2871 [Note] Plugin 'FEDERATED' is disabled. /usr/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13 - Permission denied) 2015-11-01 23:54:50 2871 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 2015-11-01 23:54:50 2871 [Note] InnoDB: Using atomics to ref count buffer pool pages 2015-11-01 23:54:50 2871 [Note] InnoDB: The InnoDB memory heap is disabled 2015-11-01 23:54:50 2871 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2015-11-01 23:54:50 2871 [Note] InnoDB: Memory barrier is not used 2015-11-01 23:54:50 2871 [Note] InnoDB: Compressed tables use zlib 1.2.8 2015-11-01 23:54:50 2871 [Note] InnoDB: Using Linux native AIO 2015-11-01 23:54:50 2871 [Note] InnoDB: Not using CPU crc32 instructions 2015-11-01 23:54:50 2871 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2015-11-01 23:54:50 2871 [Note] InnoDB: Completed initialization of buffer pool 2015-11-01 23:54:50 2871 [ERROR] InnoDB: ./ibdata1 can't be opened in read-write mode 2015-11-01 23:54:50 2871 [ERROR] InnoDB: The system tablespace must be writable! 2015-11-01 23:54:50 2871 [ERROR] Plugin 'InnoDB' init function returned error. 2015-11-01 23:54:50 2871 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2015-11-01 23:54:50 2871 [ERROR] Unknown/unsupported storage engine: InnoDB 2015-11-01 23:54:50 2871 [ERROR] Aborting 2015-11-01 23:54:50 2871 [Note] Binlog end 2015-11-01 23:54:50 2871 [Note] Shutting down plugin 'partition' 2015-11-01 23:54:50 2871 [Note] Shutting down plugin 'BLACKHOLE' 2015-11-01 23:54:50 2871 [Note] Shutting down plugin 'ARCHIVE' 2015-11-01 23:54:50 2871 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2015-11-01 23:54:50 2871 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2015-11-01 23:54:50 2871 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2015-11-01 23:54:50 2871 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2015-11-01 23:54:50 2871 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2015-11-01 23:54:50 2871 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2015-11-01 23:54:50 2871 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2015-11-01 23:54:50 2871 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2015-11-01 23:54:50 2871 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2015-11-01 23:54:50 2871 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2015-11-01 23:54:50 2871 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2015-11-01 23:54:50 2871 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2015-11-01 23:54:50 2871 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2015-11-01 23:54:50 2871 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2015-11-01 23:54:50 2871 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2015-11-01 23:54:50 2871 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2015-11-01 23:54:50 2871 [Note] Shutting down plugin 'INNODB_METRICS' 2015-11-01 23:54:50 2871 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2015-11-01 23:54:50 2871 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2015-11-01 23:54:50 2871 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2015-11-01 23:54:50 2871 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2015-11-01 23:54:50 2871 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2015-11-01 23:54:50 2871 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2015-11-01 23:54:50 2871 [Note] Shutting down plugin 'INNODB_CMPMEM' 2015-11-01 23:54:50 2871 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2015-11-01 23:54:50 2871 [Note] Shutting down plugin 'INNODB_CMP' 2015-11-01 23:54:50 2871 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2015-11-01 23:54:50 2871 [Note] Shutting down plugin 'INNODB_LOCKS' 2015-11-01 23:54:50 2871 [Note] Shutting down plugin 'INNODB_TRX' 2015-11-01 23:54:50 2871 [Note] Shutting down plugin 'CSV' 2015-11-01 23:54:50 2871 [Note] Shutting down plugin 'MEMORY' 2015-11-01 23:54:50 2871 [Note] Shutting down plugin 'MRG_MYISAM' 2015-11-01 23:54:50 2871 [Note] Shutting down plugin 'MyISAM' 2015-11-01 23:54:50 2871 [Note] Shutting down plugin 'sha256_password' 2015-11-01 23:54:50 2871 [Note] Shutting down plugin 'mysql_old_password' 2015-11-01 23:54:50 2871 [Note] Shutting down plugin 'mysql_native_password' 2015-11-01 23:54:50 2871 [Note] Shutting down plugin 'binlog' 2015-11-01 23:54:50 2871 [Note] /usr/sbin/mysqld: Shutdown complete 2015-11-01 23:54:51 2917 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 2015-11-01 23:54:51 2917 [Note] Plugin 'FEDERATED' is disabled. /usr/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13 - Permission denied) 2015-11-01 23:54:51 2917 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 2015-11-01 23:54:51 2917 [Note] InnoDB: Using atomics to ref count buffer pool pages 2015-11-01 23:54:51 2917 [Note] InnoDB: The InnoDB memory heap is disabled 2015-11-01 23:54:51 2917 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2015-11-01 23:54:51 2917 [Note] InnoDB: Memory barrier is not used 2015-11-01 23:54:51 2917 [Note] InnoDB: Compressed tables use zlib 1.2.8 2015-11-01 23:54:51 2917 [Note] InnoDB: Using Linux native AIO 2015-11-01 23:54:51 2917 [Note] InnoDB: Not using CPU crc32 instructions 2015-11-01 23:54:51 2917 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2015-11-01 23:54:51 2917 [Note] InnoDB: Completed initialization of buffer pool 2015-11-01 23:54:51 2917 [ERROR] InnoDB: ./ibdata1 can't be opened in read-write mode 2015-11-01 23:54:51 2917 [ERROR] InnoDB: The system tablespace must be writable! 2015-11-01 23:54:51 2917 [ERROR] Plugin 'InnoDB' init function returned error. 2015-11-01 23:54:51 2917 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2015-11-01 23:54:51 2917 [ERROR] Unknown/unsupported storage engine: InnoDB 2015-11-01 23:54:51 2917 [ERROR] Aborting 2015-11-01 23:54:51 2917 [Note] Binlog end 2015-11-01 23:54:51 2917 [Note] Shutting down plugin 'partition' 2015-11-01 23:54:51 2917 [Note] Shutting down plugin 'BLACKHOLE' 2015-11-01 23:54:51 2917 [Note] Shutting down plugin 'ARCHIVE' 2015-11-01 23:54:51 2917 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2015-11-01 23:54:51 2917 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2015-11-01 23:54:51 2917 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2015-11-01 23:54:51 2917 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2015-11-01 23:54:51 2917 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2015-11-01 23:54:51 2917 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2015-11-01 23:54:51 2917 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2015-11-01 23:54:51 2917 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2015-11-01 23:54:51 2917 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2015-11-01 23:54:51 2917 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2015-11-01 23:54:51 2917 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2015-11-01 23:54:51 2917 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2015-11-01 23:54:51 2917 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2015-11-01 23:54:51 2917 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2015-11-01 23:54:51 2917 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2015-11-01 23:54:51 2917 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2015-11-01 23:54:51 2917 [Note] Shutting down plugin 'INNODB_METRICS' 2015-11-01 23:54:51 2917 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2015-11-01 23:54:51 2917 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2015-11-01 23:54:51 2917 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2015-11-01 23:54:51 2917 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2015-11-01 23:54:51 2917 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2015-11-01 23:54:51 2917 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2015-11-01 23:54:51 2917 [Note] Shutting down plugin 'INNODB_CMPMEM' 2015-11-01 23:54:51 2917 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2015-11-01 23:54:51 2917 [Note] Shutting down plugin 'INNODB_CMP' 2015-11-01 23:54:51 2917 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2015-11-01 23:54:51 2917 [Note] Shutting down plugin 'INNODB_LOCKS' 2015-11-01 23:54:51 2917 [Note] Shutting down plugin 'INNODB_TRX' 2015-11-01 23:54:51 2917 [Note] Shutting down plugin 'CSV' 2015-11-01 23:54:51 2917 [Note] Shutting down plugin 'MEMORY' 2015-11-01 23:54:51 2917 [Note] Shutting down plugin 'MRG_MYISAM' 2015-11-01 23:54:51 2917 [Note] Shutting down plugin 'MyISAM' 2015-11-01 23:54:51 2917 [Note] Shutting down plugin 'sha256_password' 2015-11-01 23:54:51 2917 [Note] Shutting down plugin 'mysql_old_password' 2015-11-01 23:54:51 2917 [Note] Shutting down plugin 'mysql_native_password' 2015-11-01 23:54:51 2917 [Note] Shutting down plugin 'binlog' 2015-11-01 23:54:52 2917 [Note] /usr/sbin/mysqld: Shutdown complete ** Affects: mysql-5.6 (Ubuntu) Importance: Undecided Status: New -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.6 in Ubuntu. https://bugs.launchpad.net/bugs/1512178 Title: after upgrade to mysql-5.6 database stopped working To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.6/+bug/1512178/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs