Red Hat Bugzilla – Bug 620267
mysql crash on UPDATE request
Last modified: 2013-07-02 23:32:29 EDT
When in send this request from php, phpMyAdmin or mysql-client, mysql server crash and I put the debugtrace found in my mysql.log
SQL query: UPDATE jos_sfc_offremploi SET id_oem = 1 WHERE id_oem = '1'
100801 23:49:43 - 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.
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 338317 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
stack_bottom = 0x7fd2a4180d98 thread_stack 0x40000
/usr/libexec/mysqld(mysql_update(THD*, TABLE_LIST*, List<Item>&, List<Item>&, Item*, unsigned int, st_order*, unsigned long long, enum_duplicates, bool)+0x497) [0x641df7]
/usr/libexec/mysqld(mysql_parse(THD*, char const*, unsigned int, char const**)+0x221) [0x5cb651]
/usr/libexec/mysqld(dispatch_command(enum_server_command, THD*, char*, unsigned int)+0xc9c) [0x5ccbac]
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0x7fd28c02af40 is an invalid pointer
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.
100801 23:49:44 mysqld_safe Number of processes running now: 0
100801 23:49:44 mysqld_safe mysqld restarted
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
100801 23:49:44 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
100801 23:49:45 InnoDB: Started; log sequence number 0 491822474
100801 23:49:45 [Note] Event Scheduler: Loaded 0 events
100801 23:49:45 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.48' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
It's really impossible to do anything with such a vague bug report. UPDATEs in general certainly don't crash mysql (else nobody would use it), so you need to provide enough information for somebody else to reproduce the problem and/or figure out what's special about this particular UPDATE. The mysql manual page linked from the crash printout is a good place to start trying to diagnose problems.
This message is a reminder that Fedora 13 is nearing its end of life.
Approximately 30 (thirty) days from now Fedora will stop maintaining
and issuing updates for Fedora 13. It is Fedora's policy to close all
bug reports from releases that are no longer maintained. At that time
this bug will be closed as WONTFIX if it remains open with a Fedora
'version' of '13'.
Package Maintainer: If you wish for this bug to remain open because you
plan to fix it in a currently maintained version, simply change the 'version'
to a later Fedora version prior to Fedora 13's end of life.
Bug Reporter: Thank you for reporting this issue and we are sorry that
we may not be able to fix it before Fedora 13 is end of life. If you
would still like to see this bug fixed and are able to reproduce it
against a later version of Fedora please change the 'version' of this
bug to the applicable version. If you are unable to change the version,
please add a comment here and someone will do it for you.
Although we aim to fix as many bugs as possible during every release's
lifetime, sometimes those efforts are overtaken by events. Often a
more recent Fedora release includes newer upstream software that fixes
bugs or makes them obsolete.
The process we are following is described here:
Fedora 13 changed to end-of-life (EOL) status on 2011-06-25. Fedora 13 is
no longer maintained, which means that it will not receive any further
security or bug fix updates. As a result we are closing this bug.
If you can reproduce this bug against a currently maintained version of
Fedora please feel free to reopen this bug against that version.
Thank you for reporting this bug and we are sorry it could not be fixed.