Bug #19183 Mysqld crashes, then restarts
| Submitted: | 19 Apr 2006 5:11 | Modified: | 11 Jul 2006 15:15 |
|---|---|---|---|
| Reporter: | Mr Antoine | Email Updates: | |
| Status: | No Feedback | Impact on me: | |
| Category: | MySQL Server | Severity: | S2 (Serious) |
| Version: | 3.23.54 | OS: | Linux (Red Hat Linux release 7.2 (Enigm) |
| Assigned to: | CPU Architecture: | Any |
[19 Apr 2006 5:11]
Mr Antoine
[19 Apr 2006 8:28]
Valeriy Kravchuk
Thank you for a problem report. Can you send a dump of that table's data? Can you try to repeat with a newer version, 3.23.58? Your my.cnf file content may be also useful.
[19 Apr 2006 9:14]
Mr Antoine
Hi, Dump is available at : http://216.127.82.43/DbyTemps.Sql.gz my.cnf is available at : http://216.127.82.43/my.cnf.txt As this server is a production server, I can't try a new version ... Thank's
[19 Apr 2006 9:17]
Mr Antoine
Hi, mysqld just crashed again ... SQL request was : thd->query at 0x857d6c0 = SELECT id_mois , id_forfait FROM dby_temps WHERE id_inscrit = 9227 AND ((annee < 2006) OR ((annee = 2006) AND (id_mois <= 4))) ORDER BY annee DESC , id_mois DESC LIMIT 1
[2 May 2006 13:34]
Mr Antoine
Hi, Do you have any idea ? Antoine
[17 May 2006 21:46]
Valeriy Kravchuk
Please, sent the EXPLAIN SELECT id_mois , id_forfait FROM dby_temps WHERE id_inscrit = 9227 AND ((annee < 2006) OR ((annee = 2006) AND (id_mois <= 4))) ORDER BY annee DESC , id_mois DESC LIMIT 1\G results from your server. Even with your data, I'll be forced to check on 3.23.58, by the way.
[18 May 2006 4:21]
Mr Antoine
Hi, Explain is hereunder : mysql> EXPLAIN SELECT id_mois , id_forfait FROM dby_temps WHERE id_inscrit = 9227 AND ((annee < 2006) OR ((annee = 2006) AND (id_mois <= 4))) ORDER BY annee DESC , id_mois DESC LIMIT 1; +-----------+-------+---------------+---------+---------+------+------+----------------------------+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +-----------+-------+---------------+---------+---------+------+------+----------------------------+ | dby_temps | range | PRIMARY | PRIMARY | 12 | NULL | 5 | where used; Using filesort | +-----------+-------+---------------+---------+---------+------+------+----------------------------+ 1 row in set (0.00 sec) Thank's
[19 May 2006 4:00]
Mr Antoine
Hi, Do you thing upgrading to a new version should correct the problem ? Which version do you recommend ? Is that new version fully compatible with 3.23.54 ? How should I upgrade to that new version (it is a production server) Antoine
[11 Jun 2006 15:15]
Valeriy Kravchuk
> Do you thing upgrading to a new version should correct the problem ? I do not know for sure, but even if we'll verify a bug, bug fix will be made in the latest version. > Which version do you recommend ? Try 3.23.58. If the bug is still repeatable - try 4.0.27. > Is that new version fully compatible with 3.23.54 ? 3.23.58 is fully compatible. Try it and inform about the results. > How should I upgrade to that new version (it is a production server) Just stop server and install new binaries. Start server again. As usual, backup of all data will be useful before any upgrade (and without upgrades).
[11 Jul 2006 23:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.059 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
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.