Bug #67707 | mysqld crash | ||
---|---|---|---|
Submitted: | 26 Nov 2012 9:26 | Modified: | 2 Feb 2013 14:35 |
Reporter: | Levente Farkas | Email Updates: | |
Status: | Duplicate | Impact on me: | |
Category: | MySQL Server | Severity: | S2 (Serious) |
Version: | mysql-5.1.66-1.el6_3.x86_64 | OS: | Linux (RHEL-6.3) |
Assigned to: | CPU Architecture: | Any |
[26 Nov 2012 9:26]
Levente Farkas
[26 Nov 2012 12:21]
Peter Laursen
Is there a scheduled backup/maintenance job or similar running at the time of the crash? Peter (not a MySQL/Oracle person?
[26 Nov 2012 12:51]
Levente Farkas
only this: /etc/init.d/httpd graceful 1 which is a apachectl graceful 1 which is according to man: graceful Gracefully restarts the Apache httpd daemon. If the daemon is not running, it is started. This differs from a normal restart in that currently open connections are not aborted. A side effect is that old log files will not be closed immediately. This means that if used in a log rotation script, a substantial delay may be necessary to ensure that the old log files are closed before processing them. This command automatically checks the configuration files as in configtest before initiating the restart to make sure Apache doesn’t die. This is equivalent to apachectl -k graceful.
[26 Nov 2012 12:53]
Levente Farkas
and there is a mod_python webapp which is the real user of mysql...
[27 Nov 2012 9:36]
MySQL Verification Team
I guess "SHOW FIELDS FROM `geo_all_region`" might be executed by mysqldump. So, the next logical step would be to- 1. does that query crash when execute manually? 2. show us output of SHOW CREATE TABLE `geo_all_region`;
[27 Nov 2012 11:11]
Levente Farkas
don't crash. mysql> SHOW CREATE TABLE `geo_all_region`; +----------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+ | View | Create View | character_set_client | collation_connection | +----------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+ | geo_all_region | CREATE ALGORITHM=UNDEFINED DEFINER=`fregatt`@`localhost` SQL SECURITY DEFINER VIEW `geo_all_region` AS select `rc`.`ID` AS `ID`,`rc`.`NAME` AS `NAME`,`rc`.`TYPE` AS `TYPE`,`rc`.`POLYGONS` AS `POLYGONS` from `geo_region_custom_ordered` `rc` union select `bp`.`ID` AS `ID`,`bp`.`NAME` AS `NAME`,`bp`.`TYPE` AS `TYPE`,`bp`.`POLYGONS` AS `POLYGONS` from `geo_region_bp` `bp` union select `town`.`ID` AS `ID`,`town`.`NAME` AS `NAME`,`town`.`TYPE` AS `TYPE`,`town`.`POLYGONS` AS `POLYGONS` from `geo_site_town` `town` union select `village`.`ID` AS `ID`,`village`.`NAME` AS `NAME`,`village`.`TYPE` AS `TYPE`,`village`.`POLYGONS` AS `POLYGONS` from `geo_site_village` `village` union select `county`.`ID` AS `ID`,`county`.`NAME` AS `NAME`,`county`.`TYPE` AS `TYPE`,`county`.`POLYGONS` AS `POLYGONS` from `geo_region_county` `county` | latin1 | latin1_swedish_ci | +----------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+ 1 row in set (0.00 sec)
[27 Nov 2012 19:36]
Sveta Smirnova
Thank you for the feedback. How this bug differs from bug #65971 which was filled by you and not fixed yet? Or did you just open new bug, because this was another view? Please explain.
[28 Dec 2012 1: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".
[28 Dec 2012 8:21]
Levente Farkas
probably it's the same
[2 Feb 2013 14:35]
Levente Farkas
does it fixed in 5.1.67?
[7 Jun 2013 7:57]
MySQL Verification Team
Bug #56971 was fixed "Noted in 5.1.69, 5.5.31, 5.6.11, 5.7.1 changelogs"