Bug #24329 handler.cc:798: int ha_rollback_trans(THD*, bool): Assertion `0' failed.

• Submitted: 15 Nov 2006 5:43
• Modified: 15 Nov 2006 8:04
• Reporter: Shane Bester (Platinum Quality Contributor)
• Status: Duplicate
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 5.0.30-debug
• OS: Linux (suse 9.3 x86)
• CPU Architecture: Any
• Tags: assertion, crash, insert, trigger

[15 Nov 2006 5:43] Shane Bester

Description:
during some overnight stress tests involving inserting rows into innodb tables containing triggers, which call stored procedures, that perform many inserts, updates, deletes, in 3 concurrent threads, I encountered the following crash:

(shortened for readability - see attached file for complete error log)

handle_segfault + 417                                    
__pthread_sighandler + 173                               
__kill + 17                                              
__pthread_raise + 27                                     
abort + 340                                              
__assert_fail + 224                                      
_Z17ha_rollback_transP3THDb + 216                        
_Z27convert_error_code_to_mysqliP3THD + 96               
_ZN11ha_innobase9write_rowEPc + 1172                     
_Z12write_recordP3THDP8st_tableP12st_copy_info + 1292    
_ZN13select_insert9send_dataER4ListI4ItemE + 366         
_Z8end_sendP4JOINP13st_join_tableb + 211                 
_Z20evaluate_join_recordP4JOINP13st_join_tableiPc + 471  
_Z10sub_selectP4JOINP13st_join_tableb + 209              
_Z9do_selectP4JOINP4ListI4ItemEP8st_tableP9Procedure + 78
_ZN4JOIN4execEv + 6896                                   
_Z12mysql_selectP3THDPPP4ItemP13st_table_listjR4ListIS1_E
_Z13handle_selectP3THDP6st_lexP13select_resultm + 302    
_Z21mysql_execute_commandP3THD + 11198                   
_ZN13sp_instr_stmt9exec_coreEP3THDPj + 17                
_ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_
_ZN13sp_instr_stmt7executeEP3THDPj + 277                 
_ZN7sp_head7executeEP3THD + 1415                         
_ZN7sp_head17execute_procedureEP3THDP4ListI4ItemE + 1280 
_Z21mysql_execute_commandP3THD + 22949                   
_ZN13sp_instr_stmt9exec_coreEP3THDPj + 17                
_ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_
_ZN13sp_instr_stmt7executeEP3THDPj + 277                 
_ZN7sp_head7executeEP3THD + 1415                         
_ZN7sp_head15execute_triggerEP3THDPKcS3_P13st_grant_info 
_ZN19Table_triggers_list16process_triggersEP3THD14trg_eve
_Z12write_recordP3THDP8st_tableP12st_copy_info + 1455    
_Z12mysql_insertP3THDP13st_table_listR4ListI4ItemERS3_IS5
_Z21mysql_execute_commandP3THD + 10700                   
_Z11mysql_parseP3THDPcj + 380                            
_Z16dispatch_command19enum_server_commandP3THDPcj + 1940 
_Z10do_commandP3THD + 523                                
handle_one_connection + 909                              
pthread_start_thread + 225                               
__clone + 106                                            

How to repeat:
still need to make a testcase that doesn't contain private data.

Suggested fix:
.

[15 Nov 2006 5:45] MySQL Verification Team

full error

Attachment: crash1.txt (plain/text, text), 4.04 KiB.

[15 Nov 2006 5:45] MySQL Verification Team

my.cnf used

Attachment: my.cnf.txt (plain/text, text), 830 bytes.

[15 Nov 2006 8:04] Dmitry Lenev

Hi, Shane!

This is duplicate of bug#19565.

[15 Nov 2006 8:34] MySQL Verification Team

thanks, i missed that bug.  (i wish everybody would paste a stack trace so the searches and google would index it :)