search

cubieplayer / Cubian

Debian for Cubieboard
http://cubian.org
270 stars 49 forks source link

Starting MySQL database server: mysqld failed! #390

Open nahci13 opened 9 years ago

nahci13 commented 9 years ago

Hello! I installed "Cubian-desktop-x1-a20-hdmi" and update and upgraded. I can't installing mysql-server!

[ ok ] Stopping MySQL database server: mysqld. [FAIL] Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!

file "/var/log/mysql.err" is blank. I try to "apt-get remove --purge mysql-server mysql-server-5.5" and than new clean install, but not working too! I've tried every advice online but nothing is helping! Thanks to help me for fix this issue! Regards

michalliu commented 9 years ago

sry, it's a bug on desktop version, you need to put

auto lo
iface lo inet loopback

to /etc/network/interfaces

nahci13 commented 9 years ago

not work!

Setting up mysql-server-core-5.5 (5.5.38-0+wheezy1) ...
Setting up mysql-server-5.5 (5.5.38-0+wheezy1) ...
[ ok ] Stopping MySQL database server: mysqld.
100101  1:40:35 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
100101  1:40:35 [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.
100101  1:40:35 [Note] Plugin 'FEDERATED' is disabled.
100101  1:40:35 InnoDB: The InnoDB memory heap is disabled
100101  1:40:35 InnoDB: Mutexes and rw_locks use GCC atomic builtins
100101  1:40:35 InnoDB: Compressed tables use zlib 1.2.7
100101  1:40:35 InnoDB: Using Linux native AIO
100101  1:40:35 InnoDB: Initializing buffer pool, size = 128.0M
100101  1:40:35 InnoDB: Completed initialization of buffer pool
100101  1:40:35 InnoDB: highest supported file format is Barracuda.
100101  1:40:36  InnoDB: Waiting for the background threads to start
100101  1:40:37 InnoDB: 5.5.38 started; log sequence number 1595675
100101  1:40:40  InnoDB: Starting shutdown...
100101  1:40:42  InnoDB: Shutdown completed; log sequence number 1595675
[FAIL] Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
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
Setting up libhtml-template-perl (2.91-1) ...
Setting up mysql-client (5.5.38-0+wheezy1) ...
dpkg: dependency problems prevent configuration of mysql-server:
 mysql-server depends on mysql-server-5.5; however:
  Package mysql-server-5.5 is not configured yet.

dpkg: error processing mysql-server (--configure):
 dependency problems - leaving unconfigured
Errors were encountered while processing:
 mysql-server-5.5
 mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)
s-kostyuk commented 9 years ago

@nahci13, diagnose this problem precisely. Maybe, you need to create a database dump, delete old database, create the new one and restore data from dump. This helped to me in similar situation. http://kb.sp.parallels.com/en/6586

Sorry for my English

nahci13 commented 9 years ago

@ks-ua , Yes! Thank you! Just I add the option innodb_force_recovery to the [mysqld] section in /etc/my.cnf

[mysqld]
innodb_force_recovery = 4

and than:

# /etc/init.d/mysql restart

after work, change values 4 to 0 by default (normal startup without forced recovery) or remove the innodb_force_recovery option from the /etc/my.cnf file and restart mysqld

# /etc/init.d/mysql restart
s-kostyuk commented 9 years ago

@nahci13 glad to help :)

vapmaster commented 9 years ago

I have similar situation. Installed Cubian on Cubieboard A10. When tried to install mysql-server had this result: [FAIL] Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!

cubie@Cubian:~$ sudo apt-get install mysql-server
...
[ ok ] Stopping MySQL database server: mysqld.
150113 22:17:15 [Warning] Using unique option prefix key_buffer instead of key_b                                                                                                                      uffer_size is deprecated and will be removed in a future release. Please use the                                                                                                                       full name instead.
150113 22:17:15 [Warning] Using unique option prefix myisam-recover instead of m                                                                                                                      yisam-recover-options is deprecated and will be removed in a future release. Ple                                                                                                                      ase use the full name instead.
150113 22:17:15 [Note] Plugin 'FEDERATED' is disabled.
150113 22:17:15 InnoDB: The InnoDB memory heap is disabled
150113 22:17:15 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150113 22:17:15 InnoDB: Compressed tables use zlib 1.2.7
150113 22:17:15 InnoDB: Using Linux native AIO
150113 22:17:15 InnoDB: Initializing buffer pool, size = 128.0M
150113 22:17:15 InnoDB: Completed initialization of buffer pool
150113 22:17:15 InnoDB: highest supported file format is Barracuda.
150113 22:17:15  InnoDB: Waiting for the background threads to start
150113 22:17:16 InnoDB: 5.5.40 started; log sequence number 1595675
150113 22:17:16  InnoDB: Starting shutdown...
150113 22:17:17  InnoDB: Shutdown completed; log sequence number 1595675
[FAIL] Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
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
Setting up libhtml-template-perl (2.91-1) ...
dpkg: dependency problems prevent configuration of mysql-server:
 mysql-server depends on mysql-server-5.5; however:
  Package mysql-server-5.5 is not configured yet.

dpkg: error processing mysql-server (--configure):
 dependency problems - leaving unconfigured
Errors were encountered while processing:
 mysql-server-5.5
 mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)

File on path /var/run/mysqld/mysqld.sock is missing. Mysql logs in /var/log/ is empty. Please, help.

vapmaster commented 9 years ago

I installed Cubian-nano-x1-a10-hdmi.img instead of desktop version. The problem disappeared.

danfos commented 9 years ago

Something to try is to Disable InnoDB.

Not only good to (possibly) prevent these problems but also to reduce memory usage.