MySQL Forums
Forum List  »  Quality Assurance

mysql crash
Posted by: Anliker Daniel
Date: May 24, 2009 09:22AM

we use mysql for hosting with plesk control panel

nearly every time when plesk do the backup mysql crashes.

we use mysql from dotdeb on debian etch 4.0

--- 8< ---
john:~# dpkg -l |grep -i mysql
ii libmysqlclient15off 5.0.81-0.dotdeb.0 MySQL database client library
ii libmysqlclient16 5.1.34-0.dotdeb.0 MySQL database client library
ii mysql-client 5.1.34-0.dotdeb.1 MySQL database client (metapackage depending
ii mysql-client-5.1 5.1.34-0.dotdeb.0 MySQL database client binaries
ii mysql-common 5.1.34-0.dotdeb.1 MySQL database common files (e.g. /etc/mysql
ii mysql-server 5.1.34-0.dotdeb.1 MySQL database server (metapackage depending
ii mysql-server-5.1 5.1.34-0.dotdeb.0 MySQL database server binaries
ii php5-mysql 5.2.9-0.dotdeb.1 MySQL module for php5
--- 8< ---


error log:

-------------------------------<>-----------------------------------

090524 16:47:29 - mysqld got signal 11 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help diagnose
the problem, but since we have already crashed, something is definitely wrong
and this may fail.

key_buffer_size=157286400
read_buffer_size=1048576
max_used_connections=22
max_threads=500
threads_connected=21
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 1694693 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

thd: 0x116f1900
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0x442bc180 thread_stack 0x20000
/usr/sbin/mysqld(my_print_stacktrace+0x29) [0x882009]
/usr/sbin/mysqld(handle_segfault+0x346) [0x5d9ac6]
/lib/libpthread.so.0 [0x2b6bc7f5a410]
/lib/libunwind.so.7 [0x2b6bc8ca3ed0]
/lib/libunwind.so.7(_ULx86_64_is_signal_frame+0x44) [0x2b6bc8ca4534]
/lib/libunwind.so.7(_ULx86_64_step+0x41) [0x2b6bc8ca4831]
/usr/lib/libtcmalloc.so.0(GetStackTrace(void**, int, int)+0x12d) [0x2b6bc7d0b38d]
/usr/lib/libtcmalloc.so.0 [0x2b6bc7cf6522]
/usr/lib/libtcmalloc.so.0(__libc_malloc+0x1f5) [0x2b6bc7d0d4c5]
/usr/sbin/mysqld(my_malloc+0x32) [0x870022]
/usr/sbin/mysqld(alloc_root+0x7b) [0x8707eb]
/usr/sbin/mysqld(Item_func_like::fix_fields(THD*, Item**)+0x1f4) [0x567da4]
/usr/sbin/mysqld(Item_cond::fix_fields(THD*, Item**)+0x156) [0x568246]
/usr/sbin/mysqld(Item_cond::fix_fields(THD*, Item**)+0x156) [0x568246]
/usr/sbin/mysqld(setup_conds(THD*, TABLE_LIST*, TABLE_LIST*, Item**)+0x1a4) [0x627354]
/usr/sbin/mysqld(JOIN::prepare(Item***, TABLE_LIST*, unsigned int, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, st_select_lex*, st_select_lex_unit*)+0x392) [0x6461b2]
/usr/sbin/mysqld(mysql_select(THD*, Item***, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*)+0x6c1) [0x659131]
/usr/sbin/mysqld(handle_select(THD*, st_lex*, select_result*, unsigned long)+0x169) [0x6594d9]
/usr/sbin/mysqld [0x5e48fe]
/usr/sbin/mysqld(mysql_execute_command(THD*)+0x2e4c) [0x5ea16c]
/usr/sbin/mysqld(mysql_parse(THD*, char const*, unsigned int, char const**)+0x208) [0x5ed128]
/usr/sbin/mysqld(dispatch_command(enum_server_command, THD*, char*, unsigned int)+0x3e9) [0x5ed529]
/usr/sbin/mysqld(do_command(THD*)+0xe6) [0x5ee506]
/usr/sbin/mysqld(handle_one_connection+0x746) [0x5e1636]
/lib/libpthread.so.0 [0x2b6bc7f53f1a]
/lib/libc.so.6(__clone+0x72) [0x2b6bc8b295d2]
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0x11855410 = SELECT pages.uid,sys_domain.redirectTo,sys_domain.prepend_params
FROM pages,sys_domain
WHERE
pages.uid=sys_domain.pid
AND sys_domain.hidden=0
AND (sys_domain.domainName='www.virtours.ch/t3' OR sys_domain.domainName='www.virtours.ch/t3/') AND pages.deleted=0 AND pages.hidden=0 AND (pages.starttime<=1243176449) AND (pages.endtime=0 OR pages.endtime>1243176449) AND NOT(pages.t3ver_state=1) AND pages.doktype<200 AND (pages.fe_group='' OR pages.fe_group IS NULL OR pages.fe_group='0' OR (pages.fe_group LIKE '%,0,%' OR pages.fe_group LIKE '0,%' OR pages.fe_group LIKE '%,0' OR pages.fe_group='0') OR (pages.fe_group LIKE '%,-1,%' OR pages.fe_group LIKE '-1,%' OR pages.fe_group LIKE '%,-1' OR pages.fe_group='-1'))
LIMIT 1
thd->thread_id=31
thd->killed=NOT_KILLED
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
090524 16:47:29 mysqld_safe Number of processes running now: 0
090524 16:47:29 mysqld_safe mysqld restarted
090524 16:47:30 [Warning] The syntax '--log' is deprecated and will be removed in MySQL 7.0. Please use '--general_log'/'--general_log_file' instead.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
090524 16:47:30 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
090524 16:47:30 InnoDB: Started; log sequence number 0 27165427
090524 16:47:30 [Note] Event Scheduler: Loaded 0 events
090524 16:47:30 [Note] /usr/sbin/mysqld: ready for connections.

-------------------------------<>-----------------------------------


can anyone help me ?

Options: ReplyQuote


Subject
Views
Written By
Posted
mysql crash
3972
May 24, 2009 09:22AM
2501
May 24, 2009 11:16AM
2085
June 07, 2009 01:43PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.