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]
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.