Bug #21009 | mysql crashing on signal 11 | ||
---|---|---|---|
Submitted: | 12 Jul 2006 17:38 | Modified: | 17 Jul 2006 18:12 |
Reporter: | Koen Martens | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | MySQL Server | Severity: | S1 (Critical) |
Version: | 5.0.22 | OS: | FreeBSD (FreeBSD) |
Assigned to: | Sveta Smirnova | CPU Architecture: | Any |
Tags: | binary distribution, freebsd package, source distributen |
[12 Jul 2006 17:38]
Koen Martens
[14 Jul 2006 8:11]
Sveta Smirnova
Thank you for the report. Could you please provide structure of wp_posts table: output of SHOW CREATE TABLE wp_posts statement and approximate quantity of rows in wp_posts table?
[14 Jul 2006 8:32]
Koen Martens
Sure thing: CREATE TABLE `wp_posts` ( `ID` bigint(20) unsigned NOT NULL auto_increment, `post_author` int(4) NOT NULL default '0', `post_date` datetime NOT NULL default '0000-00-00 00:00:00', `post_date_gmt` datetime NOT NULL default '0000-00-00 00:00:00', `post_content` longtext NOT NULL, `post_title` text NOT NULL, `post_category` int(4) NOT NULL default '0', `post_excerpt` text NOT NULL, `post_status` enum('publish','draft','private','static','object') NOT NULL default 'publish', `comment_status` enum('open','closed','registered_only') NOT NULL default 'open', `ping_status` enum('open','closed') NOT NULL default 'open', `post_password` varchar(20) NOT NULL default '', `post_name` varchar(200) NOT NULL default '', `to_ping` text NOT NULL, `pinged` text NOT NULL, `post_modified` datetime NOT NULL default '0000-00-00 00:00:00', `post_modified_gmt` datetime NOT NULL default '0000-00-00 00:00:00', `post_content_filtered` text NOT NULL, `post_parent` int(11) NOT NULL default '0', `guid` varchar(255) NOT NULL default '', `menu_order` int(11) NOT NULL default '0', PRIMARY KEY (`ID`), KEY `post_name` (`post_name`), KEY `post_status` (`post_status`), KEY `post_author` (`post_author`), KEY `post_author_status` (`post_author`,`post_status`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 and mysql> select count(*) from wp_posts; +----------+ | count(*) | +----------+ | 416 | +----------+ 1 row in set (0.00 sec) thanks for looking into this!
[17 Jul 2006 18:12]
Sveta Smirnova
Thank you for your bug report. I can not repeat it using random generated data and last MySQL sources. But I can repeat it using MySQL 5.0.21. It looks like the bug has already fixed. If necessary, you can access the source repository and build the latest available version. More information about accessing the source trees is available at http://www.mysql.com/doc/en/Installing_source_tree.html