Bug #38111 Assertion failed: save_errno, file .\ma_write.c, line 325

• Submitted: 14 Jul 2008 20:12
• Modified: 11 Aug 2008 17:30
• Reporter: Shane Bester (Platinum Quality Contributor)
• Status: Duplicate
• Category: MySQL Server: Maria storage engine
• Severity: S1 (Critical)
• Version: 5.1.25-maria-alpha-debug/6.0.6-maria
• OS: Windows
• Assigned to: Assigned Account
• CPU Architecture: Any

[14 Jul 2008 20:12] Shane Bester

Description:
got a crash and possible corruptions with inserts:

Version: '5.1.25-maria-alpha-debug'  socket: ''  port: 3306  Source distribution
Assertion failed: save_errno, file .\ma_write.c, line 325
080714 22:10:05 - mysqld got exception 0x80000003 ;

mysqld.exe!_NMSG_WRITE()[crt0msg.c:198]
mysqld.exe!abort()[abort.c:68]
mysqld.exe!_wassert()[assert.c:212]
mysqld.exe!maria_write()[ma_write.c:325]
mysqld.exe!ha_maria::write_row()[ha_maria.cc:968]
mysqld.exe!handler::ha_write_row()[handler.cc:4520]
mysqld.exe!write_record()[sql_insert.cc:1561]
mysqld.exe!mysql_insert()[sql_insert.cc:816]
mysqld.exe!mysql_execute_command()[sql_parse.cc:2956]
mysqld.exe!mysql_parse()[sql_parse.cc:5656]
mysqld.exe!dispatch_command()[sql_parse.cc:1131]
mysqld.exe!do_command()[sql_parse.cc:789]
mysqld.exe!handle_one_connection()[sql_connect.cc:1115]
mysqld.exe!pthread_start()[my_winthread.c:86]
mysqld.exe!_callthreadstart()[thread.c:295]
mysqld.exe!_threadstart()[thread.c:277]
kernel32.dll!BaseThreadStart()

thd->query at 00000000093F8DA0=insert ignore into `table28` set ... <cut>
thd->thread_id=89
thd->killed=NOT_KILLED
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
080714 22:10:10 [ERROR] Got error 175 when reading table '.\test\table41'
080714 22:10:10 [ERROR] Got error 175 when reading table '.\test\table41'

This is from the exact same build that i reported bug #38026 with.

How to repeat:
wait and see.

[14 Jul 2008 20:15] MySQL Verification Team

stack trace and table structure

Attachment: bug38111_preliminary_debug_info.txt (text/plain), 7.73 KiB.

[14 Jul 2008 21:49] MySQL Verification Team

testcase. import into mysql client.

Attachment: bug38111_testcase_1.sql (application/unknown, text), 3.53 KiB.

[15 Jul 2008 16:01] MySQL Verification Team

Thank you for the bug report.

thd: 0x338e4c8
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...
00A7F0D4    mysqld.exe!_NMSG_WRITE()[crt0msg.c:195]
00A6D71A    mysqld.exe!abort()[abort.c:44]
00A68342    mysqld.exe!_assert()[assert.c:306]
009E1978    mysqld.exe!maria_write()[ma_write.c:325]
009B9E86    mysqld.exe!ha_maria::write_row()[ha_maria.cc:967]
00473FB8    mysqld.exe!handler::ha_write_row()[handler.cc:5315]
00641D17    mysqld.exe!write_record()[sql_insert.cc:1580]
0063FB96    mysqld.exe!mysql_insert()[sql_insert.cc:833]
0065FA49    mysqld.exe!mysql_execute_command()[sql_parse.cc:2959]
006670DD    mysqld.exe!mysql_parse()[sql_parse.cc:5820]
0065C313    mysqld.exe!dispatch_command()[sql_parse.cc:1051]
0065BB2D    mysqld.exe!do_command()[sql_parse.cc:724]
00768047    mysqld.exe!handle_one_connection()[sql_connect.cc:1153]
008378BD    mysqld.exe!pthread_start()[my_winthread.c:86]
00A70A77    mysqld.exe!_threadstart()[thread.c:196]
7C80B713    kernel32.dll!GetModuleFileNameA()
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 033F20A0=insert into `table28` values (

null,
'a',
'a',

[29 Jul 2008 21:45] Omer Barnir

triage: setting tag to sr60beta

[11 Aug 2008 17:30] Sergei Golubchik

Fixed by the fix for bug#38135