Bug #20504 Crash when execute insert statement into INNODB table
Submitted: 16 Jun 2006 16:53 Modified: 19 Jun 2006 11:26
Reporter: Sveta Smirnova
Status: Duplicate
Category:Server Severity:S1 (Critical)
Version:5.0.23 OS:Microsoft Windows (Window XP Pro SP2)
Assigned to: Target Version:

[16 Jun 2006 16: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 16:57] Sveta Smirnova
VC++ Debug Library alert

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

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