Bug #56831 | 5.1.47-ndb-7.1.5 mysqld randomly crashing with segfault | ||
---|---|---|---|
Submitted: | 16 Sep 2010 23:16 | Modified: | 8 Sep 2016 5:58 |
Reporter: | Christian Ehmig | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | MySQL Cluster: Cluster (NDB) storage engine | Severity: | S1 (Critical) |
Version: | 5.1.47-ndb-7.1.5 | OS: | Linux (debian 2.6.26-2-amd64) |
Assigned to: | CPU Architecture: | Any | |
Tags: | crash on query, ndb tables, Signal 11 |
[16 Sep 2010 23:16]
Christian Ehmig
[17 Sep 2010 3:12]
Valeriy Kravchuk
Please, send the my.cnf file content.
[17 Sep 2010 8:44]
Christian Ehmig
my.cnf config file
Attachment: my.cnf (application/octet-stream, text), 4.62 KiB.
[17 Sep 2010 9:09]
Christian Ehmig
Is this issue maybe related to the enabled query cache? The query cache implementation differs for the ndb storage engine as query cache invalidation is a "distributed" task. I disabled the query cache for now and will reply if I see any improvements.
[17 Sep 2010 12:02]
Christian Ehmig
Currently the server in question is running 7 hours with no crash (query cache disabled). However, I have another strange thing which I forgot to mention, the processlist contains the following query: *************************** 2. row *************************** Id: 350 User: core Host: 10.20.56.11:39685 db: instruments Command: Query Time: 26355 State: Sending data Info: /* Core: www.godmode-trader.ch :: /js/core/chart/history.php :: - :: - :: Instrument_Filter_HistoryIntradayExt :: www02/15973 */ (SELECT value as open, MIN(value) as low, MAX(value) as high, SUBSTRING(MAX(CONCAT(UNIX_TIMESTAMP(`pk_datetime`), value)), 11) as close, MAX(UNIX_TIMESTAMP(`pk_datetime`)) as seconds FROM `27_quote_intraday_bid` WHERE `pfk_instrument_id`='134005' AND UNIX_TIMESTAMP(`pk_datetime`) < 1277510400 GROUP BY UNIX_TIMESTAMP(`pk_datetime`) DIV 60 ORDER BY seconds DESC LIMIT 0,1) UNION (SELECT value as open, MIN(value) as low, MAX(value) as high, SUBSTRING(MAX(CONCAT(UNIX_TIMESTAMP(`pk_datetime`), value)), 11) as close, MAX(UNIX_TIMESTAMP(`pk_datetime`)) as seconds FROM `27_quote_intraday_bid` WHERE `pfk_instrument_id`='134005' AND UNIX_TIMESTAMP(`pk_datetime`) >= '1277510400' AND UNIX_TIMESTAMP(`pk_datetime`) <= '1284698530' GROUP BY UNIX_TIMESTAMP(`pk_datetime`) DIV 60 ORDER BY seconds ASC) ORDER BY seconds ASC So in fact, this query was sent right after server startup and hangs since then in state "Sending data". Of course, it is not sending any data anywhere...
[8 Sep 2016 5:58]
MySQL Verification Team
This signal 11 crash was fixed somewhere around 7.1.12, not repeatable any more on any of the modern versions