Bug #20504 Crash when execute insert statement into INNODB table
Submitted: 16 Jun 2006 14:53 Modified: 19 Jun 2006 9:26
Reporter: Sveta Smirnova Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:5.0.23 OS:Windows (Window XP Pro SP2)
Assigned to: CPU Architecture:Any

[16 Jun 2006 14:53] Sveta Smirnova
Description:
If I start server (mysqld-debug) with --log-bin=logfilename option and try to insert data into INNODB table, server crashes.

Call stack:

 	mysqld-debug.exe!_crt_debugger_hook(int _Reserved=-1)  Line 62	C
 	mysqld-debug.exe!_invalid_parameter(const wchar_t * pszExpression=0x00953c78, const wchar_t * pszFunction=0x009540a4, const wchar_t * pszFile=0x009540b8, unsigned int nLine=78, unsigned int pReserved=0)  Line 86 + 0x7 bytes	C++
 	mysqld-debug.exe!_lseeki64(int fh=-1, __int64 pos=88, int mthd=0)  Line 78 + 0x7f bytes	C
>	mysqld-debug.exe!my_seek(int fd=-1, unsigned __int64 pos=88, int whence=0, int MyFlags=0)  Line 32 + 0x15 bytes	C
 	mysqld-debug.exe!my_b_fill(st_io_cache * info=0x010cdcf8)  Line 149 + 0x1b bytes	C
 	mysqld-debug.exe!MYSQL_LOG::write(THD * thd=0x02414318, st_io_cache * cache=0x010cdcf8, Log_event * commit_event=0x0427dfb4)  Line 1859 + 0x9 bytes	C++
 	mysqld-debug.exe!binlog_end_trans(THD * thd=0x02414318, st_io_cache * trans_log=0x010cdcf8, Log_event * end_ev=0x0427dfb4)  Line 98 + 0x16 bytes	C++
 	mysqld-debug.exe!MYSQL_LOG::log(THD * thd=0x02414318, unsigned __int64 xid=9)  Line 3016 + 0x11 bytes	C++
 	mysqld-debug.exe!ha_commit_trans(THD * thd=0x02414318, int all=0)  Line 713 + 0x33 bytes	C++
 	mysqld-debug.exe!ha_autocommit_or_rollback(THD * thd=0x02414318, int error=0)  Line 860 + 0xb bytes	C++
 	mysqld-debug.exe!mysql_insert(THD * thd=0x02414318, st_table_list * table_list=0x023d2340, List<Item> & fields={...}, List<List<Item> > & values_list={...}, List<Item> & update_fields={...}, List<Item> & update_values={...}, enum_duplicates duplic=DUP_ERROR, int ignore=0)  Line 578 + 0xd bytes	C++
 	mysqld-debug.exe!mysql_execute_command(THD * thd=0x02414318)  Line 3301 + 0x48 bytes	C++
 	mysqld-debug.exe!mysql_parse(THD * thd=0x02414318, char * inBuf=0x023d22c8, unsigned int length=25)  Line 5738 + 0x9 bytes	C++
 	mysqld-debug.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x02414318, char * packet=0x023c9fe1, unsigned int packet_length=26)  Line 1745 + 0x1d bytes	C++
 	mysqld-debug.exe!do_command(THD * thd=0x02414318)  Line 1531 + 0x31 bytes	C++
 	mysqld-debug.exe!handle_one_connection(void * arg=0x02414318)  Line 1174 + 0x9 bytes	C++
 	mysqld-debug.exe!pthread_start(void * param=0x023d2028)  Line 63 + 0x7 bytes	C
 	mysqld-debug.exe!_callthreadstart()  Line 293 + 0xf bytes	C
 	mysqld-debug.exe!_threadstart(void * ptd=0x010cd750)  Line 277	C
 	kernel32.dll!_BaseThreadStart@8()  + 0x37 bytes	

VC opens my_seek.c on line 32 "newpos=lseek(fd, pos, whence);"

How to repeat:
Start mysqld-debug.exe with option --log-bin=logfilename.
Connect to it and execute next statements:

CREATE TABLE t1 (id INT) ENGINE=INNODB;
INSERT INTO t1 VALUES (1);
[16 Jun 2006 14:57] Sveta Smirnova
VC++ Debug Library alert

Attachment: mybug_1.jpg (image/jpeg, text), 39.58 KiB.

[19 Jun 2006 9:26] Sveta Smirnova
Duplicates http://bugs.mysql.com/bug.php?id=18275