crashing in innodb
"Manoj Kumar" <[email protected]>
| Newsgroups | gmane.comp.db.mysql.bugs |
|---|---|
| Message-ID | <[email protected]> |
Hi, I built the 4.1.2 from source tree (latest as on today ) on my Redhat-8 box. While running, mysqld crashes with the following set of queries: CREATE TABLE tt1 (col1 int(1))ENGINE=InnoDB; CREATE TABLE tt2 (col1 int(1),stamp TIMESTAMP,INDEX stamp_idx (stamp))ENGINE=InnoDB; insert into tt2 values (1, 20020204130000); SELECT col1 FROM tt1 UNION SELECT col1 FROM tt2 WHERE stamp < '20020204120000' GROUP BY col1; These queries are there in the innodb test case of mysql-test suite also. Because of this, even mysql-test suite fails to run the innodb test. Following is the output: 040123 13:46:02 InnoDB: Started; log sequence number 0 83356 mysqld: ready for connections. Version: '4.1.2-alpha' socket: '/var/lib/mysql/mysql.sock' port: 3306 InnoDB: Error: MySQL is trying to perform a SELECT InnoDB: but it has not locked any tables in ::external_lock()! TRANSACTION 0 4865, not started, process no 18249, OS thread id 1104206016, thre ad declared inside InnoDB 500 MySQL thread id 1, query id 8 localhost root Copying to tmp table SELECT col1 FROM tt1 UNION SELECT col1 FROM tt2 WHERE stamp < '20020204120000' G ROUP BY col1 040123 13:46:17InnoDB: Assertion failure in thread 1104206016 in file row0sel.c line 2785 InnoDB: Failing assertion: 0 InnoDB: We intentionally generate a memory trap. InnoDB: Send a detailed bug report to [email protected]. mysqld got signal 11; Thanks & Regards, Manoj -- MySQL Bugs Mailing List For list archives: http://lists.mysql.com/bugs To unsubscribe: http://lists.mysql.com/[email protected]