Bug #51231 | MySQL deamon crashes while executing mysqldump | ||
---|---|---|---|
Submitted: | 17 Feb 2010 7:49 | Modified: | 23 Aug 2010 17:57 |
Reporter: | Thomad Reitz | Email Updates: | |
Status: | No Feedback | Impact on me: | |
Category: | MySQL Server | Severity: | S1 (Critical) |
Version: | 5.1.43-community | OS: | Windows (XP SP2) |
Assigned to: | CPU Architecture: | Any |
[17 Feb 2010 7:49]
Thomad Reitz
[11 Mar 2010 6:43]
Sveta Smirnova
Thank you for the report. I assume this crashes every time when mysqldump trying to select from table users? Please correct me if I am wrong. Please also provide output of SHOW CREATE TABLE users, SHOW TABLE STATUS LIKE 'users' and CHECK TABLE users. Would be good if you could upload binary files of table users to our FTP server as described in "Files" section.
[11 Apr 2010 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".
[26 Apr 2010 12:06]
Thomad Reitz
Unfortunately I am unable to provide you with the data file. Here is the requested output: mysql> show create table users; +-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | users | CREATE TABLE `users` ( `id` int(11) NOT NULL auto_increment, `login` varchar(40) collate utf8_bin default NULL, `name` varchar(200) collate utf8_bin default NULL, `email` varchar(100) collate utf8_bin default NULL, `crypted_password` varchar(40) collate utf8_bin default NULL, `salt` varchar(40) collate utf8_bin default NULL, `created_at` datetime default NULL, `updated_at` datetime default NULL, `remember_token` varchar(500) collate utf8_bin default NULL, `remember_token_expires_at` datetime default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin | +-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) mysql> show table status like 'users'; +-------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------+----------+----------------+-------------------------+ | 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 | +-------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------+----------+----------------+-------------------------+ | users | InnoDB | 10 | Compact | 2 | 8192 | 16384 | 0 | 0 | 0 | 3 | 2010-02-17 14:08:27 | NULL | NULL | utf8_bin | NULL | | InnoDB free: 2627584 kB | +-------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------+----------+----------------+-------------------------+ 1 row in set (0.00 sec) mysql> check table users; +-------------+-------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-------------+-------+----------+----------+ | sonar.users | check | status | OK | +-------------+-------+----------+----------+ 1 row in set (0.02 sec)
[23 Jul 2010 17:57]
Valeriy Kravchuk
Please, check if this is still repeatable with a newer version, 5.1.49.
[23 Aug 2010 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".