061114 21:48:29 [Note] /home/sbester/server/5.0/mysql-5.0-bk/mysql-5.0.30-linux-i686/bin/mysqld: ready for connections.
Version: '5.0.30-debug-log'  socket: '/tmp/mysql.sock'  port: 3306  yes
mysqld: handler.cc:798: int ha_rollback_trans(THD*, bool): Assertion `0' failed.
mysqld got signal 6;
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=8388572
read_buffer_size=1044480
max_used_connections=27
max_connections=80
threads_connected=4
It is possible that mysqld could use up to 
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 171709 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

thd=0xa1ecf38
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=0xbd1fd2e8, backtrace may not be correct.
Stack range sanity check OK, backtrace follows:
0x80dc01b handle_segfault + 417
0x83d10dd __pthread_sighandler + 173
0x8405ed1 __kill + 17
0x83ce9ab __pthread_raise + 27
0x84062a4 abort + 340
0x8401cf0 __assert_fail + 224
0x81a7d4a _Z17ha_rollback_transP3THDb + 216
0x81b310e _Z27convert_error_code_to_mysqliP3THD + 96
0x81b6442 _ZN11ha_innobase9write_rowEPc + 1172
0x814e2e4 _Z12write_recordP3THDP8st_tableP12st_copy_info + 1292
0x81517f8 _ZN13select_insert9send_dataER4ListI4ItemE + 366
0x8141e2b _Z8end_sendP4JOINP13st_join_tableb + 211
0x814074d _Z20evaluate_join_recordP4JOINP13st_join_tableiPc + 471
0x8140513 _Z10sub_selectP4JOINP13st_join_tableb + 209
0x814002b _Z9do_selectP4JOINP4ListI4ItemEP8st_tableP9Procedure + 783
0x812fe98 _ZN4JOIN4execEv + 6896
0x8130365 _Z12mysql_selectP3THDPPP4ItemP13st_table_listjR4ListIS1_ES2_jP8st_orderSB_S2_SB_mP13select_resultP18st_select_lex_unitP13st_sel + 617
0x812b5de _Z13handle_selectP3THDP6st_lexP13select_resultm + 302
0x80f58a4 _Z21mysql_execute_commandP3THD + 11198
0x821e835 _ZN13sp_instr_stmt9exec_coreEP3THDPj + 17
0x821e507 _ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instr + 389
0x821e6e1 _ZN13sp_instr_stmt7executeEP3THDPj + 277
0x821af39 _ZN7sp_head7executeEP3THD + 1415
0x821c5dc _ZN7sp_head17execute_procedureEP3THDP4ListI4ItemE + 1280
0x80f868b _Z21mysql_execute_commandP3THD + 22949
0x821e835 _ZN13sp_instr_stmt9exec_coreEP3THDPj + 17
0x821e507 _ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instr + 389
0x821e6e1 _ZN13sp_instr_stmt7executeEP3THDPj + 277
0x821af39 _ZN7sp_head7executeEP3THD + 1415
0x821b725 _ZN7sp_head15execute_triggerEP3THDPKcS3_P13st_grant_info + 547
0x822c52c _ZN19Table_triggers_list16process_triggersEP3THD14trg_event_type20trg_action_time_typeb + 180
0x814e387 _Z12write_recordP3THDP8st_tableP12st_copy_info + 1455
0x814ceec _Z12mysql_insertP3THDP13st_table_listR4ListI4ItemERS3_IS5_ES6_S6_15enum_duplicatesb + 2448
0x80f56b2 _Z21mysql_execute_commandP3THD + 10700
0x80fb64e _Z11mysql_parseP3THDPcj + 380
0x80f15e8 _Z16dispatch_command19enum_server_commandP3THDPcj + 1940
0x80f0e49 _Z10do_commandP3THD + 523
0x80effeb handle_one_connection + 909
0x83cbfb1 pthread_start_thread + 225
0x842680a __clone + 106
New value of fp=(nil) failed sanity check, terminating stack trace!
Please read http://dev.mysql.com/doc/mysql/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 0x68208060  is invalid pointer
thd->thread_id=73
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.