| Bug #64680 | InnoDB: Assertion failure in thread **** in file row0sel.c line 2441 | ||
|---|---|---|---|
| Submitted: | 17 Mar 2012 23:50 | Modified: | 18 Dec 2012 19:43 |
| Reporter: | Konrad Pawlus | Email Updates: | |
| Status: | Can't repeat | Impact on me: | |
| Category: | MySQL Server: InnoDB storage engine | Severity: | S2 (Serious) |
| Version: | 5.5.21 | OS: | Linux (Ubuntu 10.4) |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | assertion failure, innodb | ||
[17 Mar 2012 23:50]
Konrad Pawlus
[18 Mar 2012 7:34]
Konrad Pawlus
I did reinstal mysql once again, using same data files I got som more info in log, pointing to some query: Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (2bbb9730): select visitstats0_.ID as ID3_, visitstats0_.VERSION as VERSION3_, visitstats0_.VENDOR_ID as VENDOR3_3_, visitstats0_.INFORMATION_TYPE as INFORMAT4_3_, visitstats0_.WEBSITE as WEBSITE3_, visitstats0_.PERIOD as PERIOD3_, visitstats0_.DATE as DATE3_, visitstats0_.CREATED_ON as CREATED8_3_, visitstats0_.TOTAL_VISITS as TOTAL9_3_, visitstats0_.PARTNERS_VISITS as PARTNERS10_3_, visitstats0_.PROSPECTS_VISITS as PROSPECTS11_3_, visitstats0_.CUSTOMERS_VISITS as CUSTOMERS12_3_, visitstats0_.OTHER_VISITS as OTHER13_3_, visitstats0_.ANONYMOUS_VISITS as ANONYMOUS14_3_, visitstats0_.TOTAL_TIME as TOTAL15_3_, visitstats0_.PARTNERS_TIME as PARTNERS16_3_, visitstats0_.PROSPECTS_TIME as PROSPECTS17_3_, visitstats0_.CUSTOMERS_TIME as CUSTOMERS18_3_, visitstats0_.OTHER_TIME as OTHER19_3_, visitstats0_.ANONYMOUS_TIME as ANONYMOUS20_3_ from SM_VISIT_STATS visitstats0_ where visitstats0_.VENDOR_ID='8d24361f-d1c2-4dc8-a300-449594b7d549' and visitstats0_.INFORMATION_TYPE='GENERAL' and visitstats0_.WEBSITE='test.pl' and visitstats0_. Connection ID (thread ID): 100 Status: NOT_KILLED I tried to recreate this table - but same issue ocures. Table create: CREATE TABLE `SM_VISIT_STATS` ( `ID` char(128) COLLATE utf8_polish_ci NOT NULL, `VERSION` int(11) NOT NULL, `VENDOR_ID` varchar(255) COLLATE utf8_polish_ci NOT NULL, `WEBSITE` varchar(255) COLLATE utf8_polish_ci NOT NULL, `PERIOD` varchar(255) COLLATE utf8_polish_ci NOT NULL, `DATE` datetime NOT NULL, `CREATED_ON` datetime NOT NULL, `TOTAL_VISITS` int(11) NOT NULL, `PARTNERS_VISITS` int(11) NOT NULL, `PROSPECTS_VISITS` int(11) NOT NULL, `CUSTOMERS_VISITS` int(11) NOT NULL, `ANONYMOUS_VISITS` int(11) NOT NULL, `TOTAL_TIME` bigint(20) NOT NULL, `PARTNERS_TIME` bigint(20) NOT NULL, `PROSPECTS_TIME` bigint(20) NOT NULL, `CUSTOMERS_TIME` bigint(20) NOT NULL, `ANONYMOUS_TIME` bigint(20) NOT NULL, `OTHER_VISITS` int(11) NOT NULL, `OTHER_TIME` bigint(20) NOT NULL, `INFORMATION_TYPE` varchar(255) COLLATE utf8_polish_ci NOT NULL, PRIMARY KEY (`ID`), UNIQUE KEY `VENDOR_ID` (`VENDOR_ID`,`INFORMATION_TYPE`,`WEBSITE`,`PERIOD`,`DATE`), KEY `FK_VISIT_STATS_VENDOR_ID` (`VENDOR_ID`), KEY `IDX_VISIT_STATS_UPSERT` (`VENDOR_ID`,`INFORMATION_TYPE`,`WEBSITE`,`PERIOD`,`DATE`), KEY `IDX_VISIT_STATS_LOAD` (`VENDOR_ID`,`INFORMATION_TYPE`,`PERIOD`,`DATE`), CONSTRAINT `FK_VISIT_STATS_VENDOR_ID` FOREIGN KEY (`VENDOR_ID`) REFERENCES `SM_VENDOR` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci
[25 Mar 2012 14:47]
Valeriy Kravchuk
Please, send the output of EXPLAIN for this query and the output of SHOW TABLE STATUS for the table.
[26 Apr 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".
[20 Nov 2012 18:02]
Marc O'Morain
I'm hitting the same issue. Here is the output from MySQL: https://gist.github.com/4119620 Here is the output of explain and show table status (the query also causes a disconnect I'm afraid) https://gist.github.com/4119629
[20 Nov 2012 18:38]
Marc O'Morain
I've tried poking at this bug. The crash happens when I do this:
SELECT * FROM `install_tracking_results` WHERE game_id IN (1, 2, 3) AND target_game_id = 2 AND segment_id = 'default_segment' AND category = 'clickthru' AND `install_tracking_results`.`source` IN ('test') AND (time BETWEEN 'D-2012-10-10' AND 'D-2012-10-13');
but not when I do this:
SELECT * FROM `install_tracking_results` WHERE game_id IN (1, 2, 3) AND target_game_id = 2 AND segment_id = 'default_segment' AND category = 'clickthru' AND `install_tracking_results`.`source` IN ('test') AND (time BETWEEN 'D-2012-10-10' AND 'D-2012-10-1');
(The change is that I removed the last character from the WHERE BETWEEN clause.
[18 Dec 2012 19:43]
Sveta Smirnova
Marc, thank you for the feedback. Your query crashes in version 5.5.28, but does not in 5.5.29. Please wait when this version is released and upgrade.
