| Autor |
Nachricht |
JSommer
Threadersteller
Dabei seit: 24.07.2003
Ort: Nordbayern
Alter: 47
Geschlecht: 
|
Verfasst Sa 21.02.2009 19:30
Titel mySQL-Server lässt sich nicht starten - alles probiert :( |
  |
|
Hi Leute, ich weiß nicht warum, aber mein mySQL-Server lässt sich einfach nichtmehr starten, ich bekomme immer die Fehlermeldung Can't connect to local MySQL server through socket - ich hab schon alles probiert, u.a. ln -s /var/run/mysqld/mysqld.sock /tmp/mysql.sock usw usw usw - wer hat eine Hilfe für mich - ggfls mit SkypeNummer und wir regeln das ambulant? Zeige mich dankbar 
Jürgen - Skype unter: jsommer_notebook
|
|
| |
  |
 |
Pixelpole
Dabei seit: 25.10.2004
Ort: Trier
Alter: 37
Geschlecht:
|
Verfasst Sa 21.02.2009 20:11
Titel
|
|
|
|
skype abschalten und dann mal starten
|
|
| |
|
|
|
Anzeige
|
|
|
bacon
Dabei seit: 24.10.2007
Ort: -
Alter: -
Geschlecht: -
|
Verfasst Sa 21.02.2009 20:22
Titel
|
|
|
!!! 
|
|
| |
|
|
JSommer
Threadersteller
Dabei seit: 24.07.2003
Ort: Nordbayern
Alter: 47
Geschlecht:
|
Verfasst Sa 21.02.2009 20:32
Titel
|
|
|
geht trotzdem nicht 
|
|
| |
|
|
JSommer
Threadersteller
Dabei seit: 24.07.2003
Ort: Nordbayern
Alter: 47
Geschlecht:
|
Verfasst So 22.02.2009 00:58
Titel
|
|
|
Hier die Log:
| Code: | Feb 21 23:38:36 h1406913 mysqld_safe[22431]: started
Feb 21 23:38:36 h1406913 mysqld[22435]: InnoDB: Log scan progressed past the checkpoint lsn 1 1610865653
Feb 21 23:38:36 h1406913 mysqld[22435]: 090221 23:38:36 InnoDB: Database was not shut down normally!
Feb 21 23:38:36 h1406913 mysqld[22435]: InnoDB: Starting crash recovery.
Feb 21 23:38:36 h1406913 mysqld[22435]: InnoDB: Reading tablespace information from the .ibd files...
Feb 21 23:38:36 h1406913 mysqld[22435]: InnoDB: Restoring possible half-written data pages from the doublewrite
Feb 21 23:38:36 h1406913 mysqld[22435]: InnoDB: buffer...
Feb 21 23:38:36 h1406913 mysqld[22435]: InnoDB: Doing recovery: scanned up to log sequence number 1 1610866963
Feb 21 23:38:36 h1406913 mysqld[22435]: 090221 23:38:36 InnoDB: Starting an apply batch of log records to the database...
Feb 21 23:38:36 h1406913 mysqld[22435]: InnoDB: Progress in percents: 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 090221 23:38:36 - mysqld got signal 11;
Feb 21 23:38:36 h1406913 mysqld[22435]: This could be because you hit a bug. It is also possible that this binary
Feb 21 23:38:36 h1406913 mysqld[22435]: or one of the libraries it was linked against is corrupt, improperly built,
Feb 21 23:38:36 h1406913 mysqld[22435]: or misconfigured. This error can also be caused by malfunctioning hardware.
Feb 21 23:38:36 h1406913 mysqld[22435]: We will try our best to scrape up some info that will hopefully help diagnose
Feb 21 23:38:36 h1406913 mysqld[22435]: the problem, but since we have already crashed, something is definitely wrong
Feb 21 23:38:36 h1406913 mysqld[22435]: and this may fail.
Feb 21 23:38:36 h1406913 mysqld[22435]:
Feb 21 23:38:36 h1406913 mysqld[22435]: key_buffer_size=0
Feb 21 23:38:36 h1406913 mysqld[22435]: read_buffer_size=131072
Feb 21 23:38:36 h1406913 mysqld[22435]: max_used_connections=0
Feb 21 23:38:36 h1406913 mysqld[22435]: max_connections=100
Feb 21 23:38:36 h1406913 mysqld[22435]: threads_connected=0
Feb 21 23:38:36 h1406913 mysqld[22435]: It is possible that mysqld could use up to
Feb 21 23:38:36 h1406913 mysqld[22435]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 217599 K
Feb 21 23:38:36 h1406913 mysqld[22435]: bytes of memory
Feb 21 23:38:36 h1406913 mysqld[22435]: Hope that's ok; if not, decrease some variables in the equation.
Feb 21 23:38:36 h1406913 mysqld[22435]:
Feb 21 23:38:36 h1406913 mysqld[22435]: thd=(nil)
Feb 21 23:38:36 h1406913 mysqld[22435]: Attempting backtrace. You can use the following information to find out
Feb 21 23:38:36 h1406913 mysqld[22435]: where mysqld died. If you see no messages after this, something went
Feb 21 23:38:36 h1406913 mysqld[22435]: terribly wrong...
Feb 21 23:38:36 h1406913 mysqld[22435]: Cannot determine thread, fp=0xb4d16388, backtrace may not be correct.
Feb 21 23:38:36 h1406913 mysqld[22435]: Stack range sanity check OK, backtrace follows:
Feb 21 23:38:36 h1406913 mysqld[22435]: 0x81f3811
Feb 21 23:38:36 h1406913 mysqld[22435]: 0x84144a8
Feb 21 23:38:36 h1406913 mysqld[22435]: 0x8414de6
Feb 21 23:38:36 h1406913 mysqld[22435]: 0x83d946d
Feb 21 23:38:36 h1406913 mysqld[22435]: 0x83db3af
Feb 21 23:38:36 h1406913 mysqld[22435]: 0x83c8311
Feb 21 23:38:36 h1406913 mysqld[22435]: 0x83f1460
Feb 21 23:38:36 h1406913 mysqld[22435]: 0x83364fe
Feb 21 23:38:36 h1406913 mysqld[22435]: 0xb7f30f3b
Feb 21 23:38:36 h1406913 mysqld[22435]: 0xb7d4cb6e
Feb 21 23:38:36 h1406913 mysqld[22435]: New value of fp=(nil) failed sanity check, terminating stack trace!
Feb 21 23:38:36 h1406913 mysqld[22435]: Please read http://dev.mysql.com/doc/mysql/en/using-stack-trace.html and follow instructions on how to resolve the stack trace. Resolved
Feb 21 23:38:36 h1406913 mysqld[22435]: stack trace is much more helpful in diagnosing the problem, so please do
Feb 21 23:38:36 h1406913 mysqld[22435]: resolve it
Feb 21 23:38:36 h1406913 mysqld[22435]: The manual page at http://www.mysql.com/doc/en/Crashing.html contains
Feb 21 23:38:36 h1406913 mysqld[22435]: information that should help you find out what is causing the crash.
Feb 21 23:38:36 h1406913 mysqld_safe[22441]: ended
Feb 21 23:38:50 h1406913 /etc/init.d/mysql[23619]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Feb 21 23:38:50 h1406913 /etc/init.d/mysql[23619]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
Feb 21 23:38:50 h1406913 /etc/init.d/mysql[23619]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Feb 21 23:38:50 h1406913 /etc/init.d/mysql[23619]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Feb 21 23:38:50 h1406913 /etc/init.d/mysql[23619]: |
|
|
| |
|
|
aUDIOfREAK
Dabei seit: 04.04.2002
Ort: Ansbach
Alter: 44
Geschlecht:
|
Verfasst So 22.02.2009 12:12
Titel
|
|
|
nutzt du zufällig mamp am mac und hast vielleicht mal deinen server nich anständig runter gefahren?
dann lösch mal im ordner tmp/mysql die dateien mysql.sock und mysql.pid und start die kiste neu.
|
|
| |
 |
|
willshedo
Dabei seit: 21.12.2005
Ort: Waldshut
Alter: 51
Geschlecht: -
|
Verfasst Fr 13.03.2009 16:46
Titel
|
|
|
Hi,
[url]http://www.apachefriends.org/f/viewtopic.php?t=23423&sid=eb0c0f2f4224f90bf52d60ab75c688d8[/url]
vielleicht ne Lösung dabei für dich...?
|
|
| |
|
|
| |
|
|
| Ähnliche Themen |
[MySql]Lost connection to MySQL server during query
[linux] ftp-dienst auf root-server starten
2 Server mit einer mySQL DB?
Kostenloser Server, Domain, MYSQL usw
file vom server löschen mit mysql
... Can't connect to local MySQL server through socket '/
|
|
Willkommen auf dem Portal für Mediengestalter
