Administrace komentářů

Ahoj,

na serveru mam Debian 5. Nedavno byla aktualizace, ktera aktualizovala MySQL. Bohuzel se aktualizace nepodarila. Kdyz spustim aktualizaci, MySQL se uz nespusti:

server:/# apt-get update
Cíl http://ftp.cz.debian.org lenny Release.gpg
Cíl http://ftp.cz.debian.org lenny/main Translation-cs
Ign http://ftp.cz.debian.org lenny/contrib Translation-cs
Ign http://ftp.cz.debian.org lenny/non-free Translation-cs
Cíl http://ftp.cz.debian.org lenny Release
Cíl http://www.debian-multimedia.org lenny Release.gpg
Cíl http://www.debian-multimedia.org lenny/main Translation-cs
Cíl http://www.debian-multimedia.org lenny Release
Ign http://ftp.cz.debian.org lenny/main Packages/DiffIndex
Ign http://ftp.cz.debian.org lenny/contrib Packages/DiffIndex
Ign http://ftp.cz.debian.org lenny/non-free Packages/DiffIndex
Cíl http://ftp.cz.debian.org lenny/main Packages
Cíl http://ftp.cz.debian.org lenny/contrib Packages
Cíl http://ftp.cz.debian.org lenny/non-free Packages
Cíl http://www.debian-multimedia.org lenny/main Packages/DiffIndex
Cíl http://security.debian.org lenny/updates Release.gpg
Ign http://security.debian.org lenny/updates/main Translation-cs
Ign http://security.debian.org lenny/updates/contrib Translation-cs
Ign http://security.debian.org lenny/updates/non-free Translation-cs
Cíl http://security.debian.org lenny/updates Release
Ign http://security.debian.org lenny/updates/main Packages/DiffIndex
Ign http://security.debian.org lenny/updates/contrib Packages/DiffIndex
Ign http://security.debian.org lenny/updates/non-free Packages/DiffIndex
Cíl http://security.debian.org lenny/updates/main Packages
Cíl http://security.debian.org lenny/updates/contrib Packages
Cíl http://security.debian.org lenny/updates/non-free Packages
Čtu seznamy balíků... Hotovo

server:/# apt-get upgrade
Čtu seznamy balíků... Hotovo
Vytvářím strom závislostí
Čtu stavové informace... Hotovo
0 aktualizováno, 0 nově instalováno, 0 k odstranění a 0 neaktualizováno.
2 instalováno nebo odstraněno pouze částečně.
Po této operaci bude na disku použito dalších 0B.
Chcete pokračovat [Y/n]? y
Nastavuji balík mysql-server-5.0 (5.0.51a-24+lenny2) ...
Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: chyba při zpracovávání mysql-server-5.0 (--configure):
 podproces post-installation script vrátil chybový status 1
dpkg: nesplněné závislosti zamezily konfiguraci balíku mysql-server:
 mysql-server závisí na mysql-server-5.0; avšak:
  Balík mysql-server-5.0 zatím není zkonfigurován.
dpkg: chyba při zpracovávání mysql-server (--configure):
 problém se závislostmi - nechávám nezkonfigurované
Při zpracování nastaly chyby:
 mysql-server-5.0
 mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)

server:/# /etc/init.d/mysql start
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
server:/#

V logu se objevi nasledujici:

server:/# cat /var/log/syslog
...
Sep 10 15:41:26 server mysqld[1800]: 090910 15:41:26 [Note] /usr/sbin/mysqld: norm^[-B▒ln▒ ukon▒en▒
Sep 10 15:41:26 server mysqld[1800]:
Sep 10 15:41:26 server mysqld[1800]: 090910 15:41:26  InnoDB: Starting shutdown...
Sep 10 15:41:28 server mysqld[1800]: 090910 15:41:28  InnoDB: Shutdown completed; log sequence number 0 623369
Sep 10 15:41:28 server mysqld[1800]: 090910 15:41:28 [Note] /usr/sbin/mysqld: ukon^[-B▒en▒ pr▒ce hotovo
Sep 10 15:41:28 server mysqld[1800]:
Sep 10 15:41:29 server mysqld_safe[14891]: ended
Sep 10 15:41:32 server mysqld_safe[14921]: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
Sep 10 15:41:32 server mysqld_safe[14921]: To do so, start the server, then issue the following commands:
Sep 10 15:41:32 server mysqld_safe[14921]: /usr/bin/mysqladmin -u root password 'new-password'
Sep 10 15:41:32 server mysqld_safe[14921]: /usr/bin/mysqladmin -u root -h server.server .server password 'new-password'
Sep 10 15:41:32 server mysqld_safe[14921]:
Sep 10 15:41:32 server mysqld_safe[14921]: Alternatively you can run:
Sep 10 15:41:32 server mysqld_safe[14921]: /usr/bin/mysql_secure_installation
Sep 10 15:41:32 server mysqld_safe[14921]:
Sep 10 15:41:32 server mysqld_safe[14921]: which will also give you the option of removing the test
Sep 10 15:41:32 server mysqld_safe[14921]: databases and anonymous user created by default.  This is
Sep 10 15:41:32 server mysqld_safe[14921]: strongly recommended for production servers.
Sep 10 15:41:32 server mysqld_safe[14921]:
Sep 10 15:41:32 server mysqld_safe[14921]: See the manual for more instructions.
Sep 10 15:41:32 server mysqld_safe[14921]:
Sep 10 15:41:32 server mysqld_safe[14921]: Please report any problems with the /usr/bin/mysqlbug script!
Sep 10 15:41:32 server mysqld_safe[14921]:
Sep 10 15:41:32 server mysqld_safe[14921]: The latest information about MySQL is available on the web at
Sep 10 15:41:32 server mysqld_safe[14921]: http://www.mysql.com
Sep 10 15:41:32 server mysqld_safe[14921]: Support MySQL by buying support/licenses at http://shop.mysql.com
Sep 10 15:41:32 server mysqld_safe[14990]: ERROR: 1046  Nebyla vybr^[-B▒na ▒▒dn▒ datab▒ze
Sep 10 15:41:32 server mysqld_safe[14990]: 090910 15:41:32 [ERROR] Aborting
Sep 10 15:41:32 server mysqld_safe[14990]:
Sep 10 15:41:33 server mysqld_safe[14990]: 090910 15:41:33 [Note] /usr/sbin/mysqld: ukon^[-B▒en▒ pr▒ce hotovo
Sep 10 15:41:33 server mysqld_safe[14990]:
Sep 10 15:41:34 server mysqld_safe[15076]: started
Sep 10 15:41:34 server mysqld[15079]: InnoDB: Error: pthread_create returned 12
Sep 10 15:41:34 server mysqld_safe[15085]: ended
Sep 10 15:41:48 server /etc/init.d/mysql[15235]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Sep 10 15:41:49 server /etc/init.d/mysql[15235]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
Sep 10 15:41:49 server /etc/init.d/mysql[15235]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Sep 10 15:41:49 server /etc/init.d/mysql[15235]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Sep 10 15:41:49 server /etc/init.d/mysql[15235]:
Sep 10 15:41:55 server mysqld_safe[15314]: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
Sep 10 15:41:55 server mysqld_safe[15314]: To do so, start the server, then issue the following commands:
Sep 10 15:41:55 server mysqld_safe[15314]: /usr/bin/mysqladmin -u root password 'new-password'
Sep 10 15:41:55 server mysqld_safe[15314]: /usr/bin/mysqladmin -u root -h server.server .server password 'new-password'
Sep 10 15:41:55 server mysqld_safe[15314]:
Sep 10 15:41:55 server mysqld_safe[15314]: Alternatively you can run:
Sep 10 15:41:55 server mysqld_safe[15314]: /usr/bin/mysql_secure_installation
Sep 10 15:41:55 server mysqld_safe[15314]:
Sep 10 15:41:55 server mysqld_safe[15314]: which will also give you the option of removing the test
Sep 10 15:41:55 server mysqld_safe[15314]: databases and anonymous user created by default.  This is
Sep 10 15:41:55 server mysqld_safe[15314]: strongly recommended for production servers.
Sep 10 15:41:55 server mysqld_safe[15314]:
Sep 10 15:41:55 server mysqld_safe[15314]: See the manual for more instructions.
Sep 10 15:41:55 server mysqld_safe[15314]:
Sep 10 15:41:55 server mysqld_safe[15314]: Please report any problems with the /usr/bin/mysqlbug script!
Sep 10 15:41:55 server mysqld_safe[15314]:
Sep 10 15:41:55 server mysqld_safe[15314]: The latest information about MySQL is available on the web at
Sep 10 15:41:55 server mysqld_safe[15314]: http://www.mysql.com
Sep 10 15:41:55 server mysqld_safe[15314]: Support MySQL by buying support/licenses at http://shop.mysql.com
Sep 10 15:41:55 server mysqld_safe[15383]: ERROR: 1046  Nebyla vybr^[-B▒na ▒▒dn▒ datab▒ze
Sep 10 15:41:55 server mysqld_safe[15383]: 090910 15:41:55 [ERROR] Aborting
Sep 10 15:41:55 server mysqld_safe[15383]:
Sep 10 15:41:55 server mysqld_safe[15383]: 090910 15:41:55 [Note] /usr/sbin/mysqld: ukon^[-B▒en▒ pr▒ce hotovo
Sep 10 15:41:55 server mysqld_safe[15383]:
Sep 10 15:41:56 server mysqld_safe[15469]: started
Sep 10 15:41:56 server mysqld[15472]: InnoDB: Error: pthread_create returned 12
Sep 10 15:41:56 server mysqld_safe[15478]: ended
Sep 10 15:42:11 server /etc/init.d/mysql[15628]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Sep 10 15:42:11 server /etc/init.d/mysql[15628]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
Sep 10 15:42:11 server /etc/init.d/mysql[15628]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Sep 10 15:42:11 server /etc/init.d/mysql[15628]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Sep 10 15:42:11 server /etc/init.d/mysql[15628]:
Sep 10 15:42:49 server mysqld_safe[15728]: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
Sep 10 15:42:49 server mysqld_safe[15728]: To do so, start the server, then issue the following commands:
Sep 10 15:42:49 server mysqld_safe[15728]: /usr/bin/mysqladmin -u root password 'new-password'
Sep 10 15:42:49 server mysqld_safe[15728]: /usr/bin/mysqladmin -u root -h server.server .server password 'new-password'
Sep 10 15:42:49 server mysqld_safe[15728]:
Sep 10 15:42:49 server mysqld_safe[15728]: Alternatively you can run:
Sep 10 15:42:49 server mysqld_safe[15728]: /usr/bin/mysql_secure_installation
Sep 10 15:42:49 server mysqld_safe[15728]:
Sep 10 15:42:49 server mysqld_safe[15728]: which will also give you the option of removing the test
Sep 10 15:42:49 server mysqld_safe[15728]: databases and anonymous user created by default.  This is
Sep 10 15:42:49 server mysqld_safe[15728]: strongly recommended for production servers.
Sep 10 15:42:49 server mysqld_safe[15728]:
Sep 10 15:42:49 server mysqld_safe[15728]: See the manual for more instructions.
Sep 10 15:42:49 server mysqld_safe[15728]:
Sep 10 15:42:49 server mysqld_safe[15728]: Please report any problems with the /usr/bin/mysqlbug script!
Sep 10 15:42:49 server mysqld_safe[15728]:
Sep 10 15:42:49 server mysqld_safe[15728]: The latest information about MySQL is available on the web at
Sep 10 15:42:49 server mysqld_safe[15728]: http://www.mysql.com
Sep 10 15:42:49 server mysqld_safe[15728]: Support MySQL by buying support/licenses at http://shop.mysql.com
Sep 10 15:42:50 server mysqld_safe[15797]: ERROR: 1046  Nebyla vybr^[-B▒na ▒▒dn▒ datab▒ze
Sep 10 15:42:50 server mysqld_safe[15797]: 090910 15:42:50 [ERROR] Aborting
Sep 10 15:42:50 server mysqld_safe[15797]:
Sep 10 15:42:50 server mysqld_safe[15797]: 090910 15:42:50 [Note] /usr/sbin/mysqld: ukon^[-B▒en▒ pr▒ce hotovo
Sep 10 15:42:50 server mysqld_safe[15797]:
Sep 10 15:42:51 server mysqld_safe[15883]: started
Sep 10 15:42:51 server mysqld[15886]: InnoDB: Error: pthread_create returned 12
Sep 10 15:42:51 server mysqld_safe[15892]: ended
Sep 10 15:43:06 server /etc/init.d/mysql[16042]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Sep 10 15:43:06 server /etc/init.d/mysql[16042]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
Sep 10 15:43:06 server /etc/init.d/mysql[16042]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Sep 10 15:43:06 server /etc/init.d/mysql[16042]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Sep 10 15:43:06 server /etc/init.d/mysql[16042]:
server:/var/log#

Zajimave je, ze po rebootu serveru MySQL bezproblemu nabehne. Nevite nekdo co s tim?
Ja uz nemam zadny napad.