crashing in innodb

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 mysql@lists.mysql.com.
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/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: crashing in innodb

Manoj Kumar writes:
> 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.
>

The above is a deliberate assert.

A fix was pushed yesterday, so it should be ok now.

--

Sincerely,

--
For technical support contracts, go to https://order.mysql.com/?ref=msmi
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB
/_/ /_/\_, /___/\___\_\___/ Fulltime Developer and Support Coordinator
<___/ www.mysql.com Larnaca, Cyprus

Want to swim with the dolphins? (April 14-16, 2004)
http://www.mysql.com/uc2004/


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org