Bug #17037 | handle_segfault on delete statement | ||
---|---|---|---|
Submitted: | 2 Feb 2006 13:23 | Modified: | 9 Mar 2006 14:31 |
Reporter: | Artem Prysyazhnuk | Email Updates: | |
Status: | No Feedback | Impact on me: | |
Category: | MySQL Server | Severity: | S1 (Critical) |
Version: | 5.0.18 | OS: | Linux (RHEL R3 (Kernel 2.6.15.1)) |
Assigned to: | CPU Architecture: | Any |
[2 Feb 2006 13:23]
Artem Prysyazhnuk
[2 Feb 2006 13:37]
Valeriy Kravchuk
Thank you for a problem report. Please, send the SHOW CREATE TABLE and SHOW TABLE STATUS results for the tables in that DELETE statement. Describe your upgrade procedure. Did you perform dump and restore, as recommended?
[2 Feb 2006 23:16]
Artem Prysyazhnuk
This delete statement execute from stored procedure. One table events_to_pres is temp and created in SP. CREATE TEMPORARY TABLE events_to_pres ( event_id int primary key ) ENGINE = MEMORY; Second table : CREATE TABLE `shedule` ( `event_id` int(11) NOT NULL auto_increment, `task_id` int(11) NOT NULL default '0', `event_user_id` int(11) NOT NULL default '0', `first_fail_event_id` int(11) NOT NULL default '-1', `fail_event_ord` int(11) NOT NULL default '0', `shost_id` int(11) NOT NULL default '0', `request_start_time` double NOT NULL default '-1', `prev_event_id` int(11) NOT NULL default '-1', `prev_request_start_time` double NOT NULL default '-1', `request_done_time` double NOT NULL default '-1', `response_time` double NOT NULL default '-1', `status` enum('skipped','wait','ok','error') NOT NULL default 'wait', `ext_status_id` int(11) NOT NULL default '-1', `size` int(11) NOT NULL default '-1', `check_backward_link` enum('true','false') NOT NULL default 'false', `notify_sent` enum('error_notify','recovery_notify','none') NOT NULL default 'none', PRIMARY KEY (`event_id`), KEY `task_id_time` (`task_id`,`request_start_time`), KEY `request_start_time` (`request_start_time`,`task_id`), KEY `request_start_time_3` (`request_start_time`,`prev_request_start_time`), KEY `status` (`status`), KEY `task_id` (`task_id`,`first_fail_event_id`), KEY `first_fail_event_id` (`first_fail_event_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 > Describe your upgrade procedure. rpm -Uhv Mysql-* mysql_fix_privilege_tables > Did you perform dump and restore, as recommended? Initially I not make full backup/restore. But after your post I make full dump for my database and restore it. After that problem raised again.
[2 Feb 2006 23:30]
Artem Prysyazhnuk
mysql> show table status like "shedule"; +---------+--------+---------+------------+--------+----------------+-------------+-------------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-------------------+----------+----------------+---------+ | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment | +---------+--------+---------+------------+--------+----------------+-------------+-------------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-------------------+----------+----------------+---------+ | shedule | MyISAM | 10 | Fixed | 576948 | 72 | 41540256 | 20266198323167231 | 43907072 | 0 | 220305231 | 2006-02-02 12:28:13 | 2006-02-02 17:29:50 | 2006-02-02 16:27:04 | latin1_swedish_ci | NULL | | | +---------+--------+---------+------------+--------+----------------+-------------+-------------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-------------------+----------+----------------+---------+ 1 row in set (0.00 sec)
[9 Feb 2006 14:31]
Valeriy Kravchuk
So, if you create these 2 tables in 5.0.18 and put some sample data in them you'll also get that crash, right? Please, try and inform about the results. Please, send also the results of select count(*) FROM shedule e LEFT JOIN events_to_pres p ON e.event_id = p.event_id WHERE p.event_id IS NULL AND e.event_id between from_id AND to_id and EXPLAIN for this statement (on original tables).
[10 Mar 2006 0: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".