[Bug 844113] New: MySQL (MariaDB) fails to start
https://bugzilla.novell.com/show_bug.cgi?id=844113 https://bugzilla.novell.com/show_bug.cgi?id=844113#c0 Summary: MySQL (MariaDB) fails to start Classification: openSUSE Product: openSUSE Factory Version: 13.1 Beta 1 Platform: x86 OS/Version: SUSE Other Status: NEW Severity: Major Priority: P5 - None Component: Other AssignedTo: bnc-team-screening@forge.provo.novell.com ReportedBy: lpwevers@gmail.com QAContact: qa-bugs@suse.de Found By: --- Blocker: --- User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:23.0) Gecko/20100101 Firefox/23.0 On a clean installation, MySQL fails to start. Error details are below: # systemctl status mysql.service mysql.service - LSB: Start the MySQL database server Loaded: loaded (/etc/init.d/mysql) Active: failed (Result: exit-code) since Fri 2013-10-04 18:37:05 CEST; 3min 52s ago Process: 26621 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE) Oct 04 18:36:35 mail mysql[26621]: Will update MySQL now, if you encounter any problems, please read following file: Oct 04 18:36:35 mail mysql[26621]: /usr/share/doc/packages/mariadb/README.SuSE Oct 04 18:36:35 mail mysql[26621]: Log files inconsistency, please merge following files manually: Oct 04 18:36:35 mail mysql[26621]: Running protected MySQL... Oct 04 18:37:05 mail mysql[26621]: error: /var/tmp/mysql-protected.rIJZeJ/mysql.sock file didn't appeared... Oct 04 18:37:05 mail mysql[26621]: Try checking "/var/log/mysql/mysqld-upgrade-run.log"... Oct 04 18:37:05 mail systemd[1]: mysql.service: control process exited, code=exited status=1 Oct 04 18:37:05 mail systemd[1]: Failed to start LSB: Start the MySQL database server. Oct 04 18:37:05 mail systemd[1]: Unit mysql.service entered failed state. So, checking /var/log/mysql/mysqld-upgrade-run.log I get: 131004 18:36:36 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 131004 18:36:36 InnoDB: The InnoDB memory heap is disabled 131004 18:36:36 InnoDB: Mutexes and rw_locks use GCC atomic builtins 131004 18:36:36 InnoDB: Compressed tables use zlib 1.2.8 131004 18:36:36 InnoDB: Using Linux native AIO 131004 18:36:36 InnoDB: Initializing buffer pool, size = 128.0M 131004 18:36:36 InnoDB: Completed initialization of buffer pool InnoDB: Error: log file ./ib_logfile0 is of different size 0 50331648 bytes InnoDB: than specified in the .cnf file 0 5242880 bytes! 131004 18:36:36 [ERROR] Plugin 'InnoDB' init function returned error. 131004 18:36:36 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 131004 18:36:36 [ERROR] Unknown/unsupported storage engine: InnoDB 131004 18:36:36 [ERROR] Aborting 131004 18:36:36 [Note] /usr/sbin/mysqld: Shutdown complete 131004 18:36:36 mysqld_safe mysqld from pid file /var/tmp/mysql-protected.rIJZeJ/mysqld.pid ended Reproducible: Always Steps to Reproduce: 1. Install MySQL 2. Start it 3. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=844113 https://bugzilla.novell.com/show_bug.cgi?id=844113#c Ye Yuan <yyuan@suse.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |yyuan@suse.com AssignedTo|bnc-team-screening@forge.pr |mhrusecky@suse.com |ovo.novell.com | -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=844113 https://bugzilla.novell.com/show_bug.cgi?id=844113#c1 Michal Hrusecky <mhrusecky@suse.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |INVALID --- Comment #1 from Michal Hrusecky <mhrusecky@suse.com> 2013-11-06 12:17:56 UTC --- Clean installation but old MySQL data folder. Looks like you are trying to change innodb_log_file_size. Looks like fix should be pretty simple: http://octathorpeweb.com/blog/2012/06/12/fixing-innodb-error-log-file-ib_log... -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
participants (1)
-
bugzilla_noreply@novell.com