Beim Aufruf der Pleskseite erhalte ich folgende Fehlermeldung:
Dies liegt daran, dass der MySQL-Server nicht gestart ist. Er lässt sich auch nicht mehr starten
Im Syslog erhalte ich folgende Fehlermeldung
Ich verwende Debian mit Plesk 10
Könnt ihr mir bitte Helfen dieses Problem zu lösen
mit Freundlichen Grüßen
Arrow768
Code:
ERROR: PleskFatalException
Unable to connect to database: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
0: common_func.php3:150
psaerror(string 'Unable to connect to database: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)')
1: auth.php3:107
ERROR: PleskFatalException
Unable to connect to database: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
0: common_func.php3:150
psaerror(string 'Unable to connect to database: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)')
1: auth.php3:107
Dies liegt daran, dass der MySQL-Server nicht gestart ist. Er lässt sich auch nicht mehr starten
Code:
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed
Im Syslog erhalte ich folgende Fehlermeldung
Code:
mysqld: 120227 20:13:26InnoDB: Error: trying to access a stray pointer 0x80007f63bca83ff8
mysqld: InnoDB: buf pool start is at 0x7f63bca70000, end at 0x7f63bd270000
mysqld: InnoDB: Probable reason is database corruption or memory
mysqld: InnoDB: corruption. If this happens in an InnoDB database recovery, see
mysqld: InnoDB: http://dev.mysql.com/doc/refman/5.1/en/forcing-recovery.html
mysqld: InnoDB: how to force recovery.
mysqld: 120227 20:13:26 InnoDB: Assertion failure in thread 140066428552992 in file ../../../storage/innobase/include/buf0buf.ic line 264
mysqld: InnoDB: We intentionally generate a memory trap.
mysqld: InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
mysqld: InnoDB: If you get repeated assertion failures or crashes, even
mysqld: InnoDB: immediately after the mysqld startup, there may be
mysqld: InnoDB: corruption in the InnoDB tablespace. Please refer to
mysqld: InnoDB: http://dev.mysql.com/doc/refman/5.1/en/forcing-recovery.html
mysqld: InnoDB: about forcing recovery.
mysqld: 120227 20:13:26 - mysqld got signal 6 ;
mysqld: This could be because you hit a bug. It is also possible that this binary
mysqld: or one of the libraries it was linked against is corrupt, improperly built,
mysqld: or misconfigured. This error can also be caused by malfunctioning hardware.
mysqld: We will try our best to scrape up some info that will hopefully help diagnose
mysqld: the problem, but since we have already crashed, something is definitely wrong
mysqld: and this may fail.
mysqld:
mysqld: key_buffer_size=16777216
mysqld: read_buffer_size=131072
mysqld: max_used_connections=0
mysqld: max_threads=151
mysqld: threads_connected=0
mysqld: It is possible that mysqld could use up to
mysqld: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 346514 K
mysqld: bytes of memory
mysqld: Hope that's ok; if not, decrease some variables in the equation.
mysqld:
mysqld: thd: 0x0
mysqld: Attempting backtrace. You can use the following information to find out
mysqld: where mysqld died. If you see no messages after this, something went
mysqld: terribly wrong...
mysqld: stack_bottom = (nil) thread_stack 0x30000
mysqld: /usr/sbin/mysqld(my_print_stacktrace+0x29) [0x7f63c21fc829]
mysqld: /usr/sbin/mysqld(handle_segfault+0x404) [0x7f63c1f06b14]
mysqld: /lib/libpthread.so.0(+0xeff0) [0x7f63c1768ff0]
mysqld: /lib/libc.so.6(gsignal+0x35) [0x7f63c020b1b5]
mysqld: /lib/libc.so.6(abort+0x180) [0x7f63c020dfc0]
mysqld: /usr/sbin/mysqld(page_cur_search_with_match+0x938) [0x7f63c212f7d8]
mysqld: /usr/sbin/mysqld(btr_cur_search_to_nth_level+0x629) [0x7f63c20cc6a9]
mysqld: /usr/sbin/mysqld(btr_pcur_open_on_user_rec+0x64) [0x7f63c218a6a4]
mysqld: /usr/sbin/mysqld(+0x553e8f) [0x7f63c20e9e8f]
mysqld: /usr/sbin/mysqld(dict_load_sys_table+0x59) [0x7f63c20efe69]
mysqld: /usr/sbin/mysqld(dict_boot+0x944) [0x7f63c218b514]
mysqld: /usr/sbin/mysqld(innobase_start_or_create_for_mysql+0x11c2) [0x7f63c2164212]
mysqld: /usr/sbin/mysqld(+0x5257eb) [0x7f63c20bb7eb]
mysqld: /usr/sbin/mysqld(ha_initialize_handlerton(st_plugin_int*)+0x31) [0x7f63c20034e1]
mysqld: /usr/sbin/mysqld(+0x4fd702) [0x7f63c2093702]
mysqld: /usr/sbin/mysqld(plugin_init(int*, char**, int)+0x7d8) [0x7f63c2096c68]
mysqld: /usr/sbin/mysqld(+0x372a7d) [0x7f63c1f08a7d]
mysqld: /usr/sbin/mysqld(main+0x1ee) [0x7f63c1f0bdde]
mysqld: /lib/libc.so.6(__libc_start_main+0xfd) [0x7f63c01f7c8d]
mysqld: /usr/sbin/mysqld(+0x29b279) [0x7f63c1e31279]
mysqld: The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
mysqld: information that should help you find out what is causing the crash.
mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
/etc/init.d/mysql[5572]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
/etc/init.d/mysql[5572]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
/etc/init.d/mysql[5572]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
/etc/init.d/mysql[5572]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Ich verwende Debian mit Plesk 10
Könnt ihr mir bitte Helfen dieses Problem zu lösen
mit Freundlichen Grüßen
Arrow768