[debian-mysql] Bug#873752: mysql-server-5.5: After installation, mysql does not start.
Aki Tuomi
cmouse at cmouse.fi
Wed Aug 30 17:18:34 UTC 2017
Package: mysql-server-5.5
Version: 5.5.57-0+deb8u1
Severity: important
Dear Maintainer,
I am using docker and installed mysql server as part of our CI image. After CI image
has been completed, I execute it locally and try to do
service mysql start
which will eventually fail.
The only way forward is to rm -rf /var/lib/mysql/* and do mysqld --initialize and mysql_install_db
This bug is related to #838190
Logs show
170830 16:56:38 [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.
170830 16:56:38 [Note] Plugin 'FEDERATED' is disabled.
170830 16:56:38 InnoDB: The InnoDB memory heap is disabled
170830 16:56:38 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170830 16:56:38 InnoDB: Compressed tables use zlib 1.2.8
170830 16:56:38 InnoDB: Using Linux native AIO
170830 16:56:38 InnoDB: Initializing buffer pool, size = 128.0M
170830 16:56:38 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
170830 16:56:38 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
170830 16:56:38 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
170830 16:56:38 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
170830 16:56:38 InnoDB: Waiting for the background threads to start
170830 16:56:39 InnoDB: 5.5.57 started; log sequence number 0
170830 16:56:39 InnoDB: Starting shutdown...
170830 16:56:40 InnoDB: Shutdown completed; log sequence number 1595675
170830 16:56:40 [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.
170830 16:56:40 [Note] Plugin 'FEDERATED' is disabled.
170830 16:56:40 InnoDB: The InnoDB memory heap is disabled
170830 16:56:40 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170830 16:56:40 InnoDB: Compressed tables use zlib 1.2.8
170830 16:56:40 InnoDB: Using Linux native AIO
170830 16:56:40 InnoDB: Initializing buffer pool, size = 128.0M
170830 16:56:40 InnoDB: Completed initialization of buffer pool
170830 16:56:40 InnoDB: highest supported file format is Barracuda.
170830 16:56:40 InnoDB: Waiting for the background threads to start
170830 16:56:41 InnoDB: 5.5.57 started; log sequence number 1595675
ERROR: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE user ADD column Show_view_priv enum('N','Y') CHARACTER SET utf8 NOT ' at line 1
170830 16:56:41 [ERROR] Aborting
170830 16:56:41 InnoDB: Starting shutdown...
170830 16:56:42 InnoDB: Shutdown completed; log sequence number 1595675
170830 16:56:42 [Note] /usr/sbin/mysqld: Shutdown complete
170830 16:56:42 [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.
170830 16:56:42 [Note] Plugin 'FEDERATED' is disabled.
170830 16:56:42 InnoDB: The InnoDB memory heap is disabled
170830 16:56:42 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170830 16:56:42 InnoDB: Compressed tables use zlib 1.2.8
170830 16:56:42 InnoDB: Using Linux native AIO
170830 16:56:42 InnoDB: Initializing buffer pool, size = 128.0M
170830 16:56:42 InnoDB: Completed initialization of buffer pool
170830 16:56:42 InnoDB: highest supported file format is Barracuda.
170830 16:56:42 InnoDB: Waiting for the background threads to start
170830 16:56:43 InnoDB: 5.5.57 started; log sequence number 1595675
170830 16:56:43 InnoDB: Starting shutdown...
170830 16:56:44 InnoDB: Shutdown completed; log sequence number 1595675
170830 16:56:44 [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.
170830 16:56:44 [Note] Plugin 'FEDERATED' is disabled.
170830 16:56:44 InnoDB: The InnoDB memory heap is disabled
170830 16:56:44 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170830 16:56:44 InnoDB: Compressed tables use zlib 1.2.8
170830 16:56:44 InnoDB: Using Linux native AIO
170830 16:56:44 InnoDB: Initializing buffer pool, size = 128.0M
170830 16:56:44 InnoDB: Completed initialization of buffer pool
170830 16:56:44 InnoDB: highest supported file format is Barracuda.
170830 16:56:44 InnoDB: Waiting for the background threads to start
170830 16:56:45 InnoDB: 5.5.57 started; log sequence number 1595675
ERROR: 1050 Table 'plugin' already exists
170830 16:56:45 [ERROR] Aborting
170830 16:56:45 InnoDB: Starting shutdown...
170830 16:56:46 InnoDB: Shutdown completed; log sequence number 1595675
170830 16:56:46 [Note] /usr/sbin/mysqld: Shutdown complete
170830 17:05:42 [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.
170830 17:05:42 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Got error 140 from storage engine
170830 17:05:42 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
170830 17:05:42 InnoDB: The InnoDB memory heap is disabled
170830 17:05:42 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170830 17:05:42 InnoDB: Compressed tables use zlib 1.2.8
170830 17:05:42 InnoDB: Using Linux native AIO
170830 17:05:42 InnoDB: Initializing buffer pool, size = 128.0M
170830 17:05:42 InnoDB: Completed initialization of buffer pool
170830 17:05:42 InnoDB: highest supported file format is Barracuda.
170830 17:05:42 InnoDB: Waiting for the background threads to start
170830 17:05:43 InnoDB: 5.5.57 started; log sequence number 1595675
170830 17:05:43 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
170830 17:05:43 [Note] - '127.0.0.1' resolves to '127.0.0.1';
170830 17:05:43 [Note] Server socket created on IP: '127.0.0.1'.
170830 17:05:43 [ERROR] Fatal error: Can't open and lock privilege tables: Got error 140 from storage engine
-- System Information:
Debian Release: 8.9
APT prefers oldstable-updates
APT policy: (500, 'oldstable-updates'), (500, 'oldstable')
Architecture: amd64 (x86_64)
Kernel: Linux 4.4.0-93-generic (SMP w/8 CPU cores)
Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968)
Shell: /bin/sh linked to /bin/dash
Init: unable to detect
Versions of packages mysql-server-5.5 depends on:
ii adduser 3.113+nmu3
ii debconf [debconf-2.0] 1.5.56+deb8u1
ii initscripts 2.88dsf-59
ii libc6 2.19-18+deb8u10
ii libdbi-perl 1.631-3+b1
ii libgcc1 1:4.9.2-10
ii libstdc++6 4.9.2-10
ii lsb-base 4.1+Debian13+nmu1
ii mysql-client-5.5 5.5.57-0+deb8u1
ii mysql-common 5.5.57-0+deb8u1
ii mysql-server-core-5.5 5.5.57-0+deb8u1
ii passwd 1:4.2-3+deb8u4
ii perl 5.20.2-3+deb8u8
ii psmisc 22.21-2
ii zlib1g 1:1.2.8.dfsg-2+b1
Versions of packages mysql-server-5.5 recommends:
ii libhtml-template-perl 2.95-1
Versions of packages mysql-server-5.5 suggests:
pn mailx <none>
pn tinyca <none>
-- debconf information:
mysql-server/root_password: (password omitted)
mysql-server/root_password_again: (password omitted)
mysql-server-5.5/nis_warning:
mysql-server/error_setting_password:
mysql-server/password_mismatch:
mysql-server-5.5/really_downgrade: false
mysql-server/no_upgrade_when_using_ndb:
mysql-server-5.5/postrm_remove_databases: false
mysql-server-5.5/start_on_boot: true
More information about the pkg-mysql-maint
mailing list