[mysql@hvcwy0918 mysql]$ mysqld --debug &
[1] 4485
[mysql@hvcwy0918 mysql]$ 040603 15:34:23  Warning: Asked for 196608 thread stack, but got 126976
040603 15:34:24  InnoDB: Started; log sequence number 27 767687254
040603 15:34:24  mysql.user table is not updated to new password format; Disabling new password usage until mysql_fix_privilege_tables is run
mysqld: ready for connections.
Version: '4.1.2-alpha-debug'  socket: '/tmp/mysql.sock'  port: 3306

[mysql@hvcwy0918 mysql]$ InnoDB: Error: MySQL is trying to perform a SELECT
InnoDB: but it has not locked any tables in ::external_lock()!
TRANSACTION 0 16128, not started, process no 4497, OS thread id 36874, thread declared inside InnoDB 500
MySQL thread id 1, query id 4 localhost root Sending data
select         ps_partkey,         sum(ps_supplycost * ps_availqty) as value from         PARTSUPP,         SUPPLIER,         NATION where         ps_suppkey = s_suppkey         and s_nationkey = n_nationkey         and n_name = 'JORDAN' group by         ps_partkey having                 sum(ps_supp

040603 15:36:18InnoDB: Assertion failure in thread 36874 in file row0sel.c line 2779
InnoDB: Failing assertion: 0
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. See section 6.1 of
InnoDB: http://www.innodb.com/ibman.php about forcing recovery.
mysqld got signal 11;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help diagnose
the problem, but since we have already crashed, something is definitely wrong
and this may fail.

key_buffer_size=268435456
read_buffer_size=1044480
max_used_connections=1
max_connections=100
threads_connected=1
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 466543 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

thd=0x86a7200
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
Cannot determine thread, fp=0xbfe7e2d8, backtrace may not be correct.
Stack range sanity check OK, backtrace follows:
0x808fd02
0x82e3548
0x8197ecb
0x810f55f
0x810f9fc
0x810fba3
0x8102029
0x80cf4ed
0x80ce838
0x80ce4e3
0x80c4503
0x8077aa7
0x80745c2
0x8074f69
0x805dba1
0x805e606
0x810334b
0x8102a7d
0x80d185a
0x80c449b
0x80c4ab1
0x80c0fe4
0x809fafc
0x80a420f
0x809e73f
0x809df46
0x809d487
0x82e0cfc
0x831249a
New value of fp=(nil) failed sanity check, terminating stack trace!
Please read http://www.mysql.com/doc/en/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved
stack trace is much more helpful in diagnosing the problem, so please do
resolve it
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0x86ad9d8 = select         ps_partkey,         sum(ps_supplycost * ps_availqty) as value from         PARTSUPP,         SUPPLIER,         NATION where         ps_suppkey = s_suppkey         and s_nationkey = n_nationkey         and n_name = 'JORDAN' group by         ps_partkey having                 sum(ps_supplycost * ps_availqty) > (                         select                                 sum(ps_supplycost * ps_availqty) * 0.0001000000                         from                                 PARTSUPP,                                 SUPPLIER,                                 NATION                         where                                 ps_suppkey = s_suppkey                                 and s_nationkey = n_nationkey                                 and n_name = 'JORDAN')
thd->thread_id=1
The manual page at http://www.mysql.com/doc/en/Crashing.html contains
information that should help you find out what is causing the crash.

[1]+  Exit 1                  mysqld --debug