Starting program: /opt/mysql-5.0.67/libexec/mysqld [Thread debugging using libthread_db enabled] [New Thread 0xb7c276c0 (LWP 27368)] [New Thread 0xb7c26b90 (LWP 27371)] [Thread 0xb7c26b90 (LWP 27371) exited] 090116 12:27:51 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295 090116 12:27:51 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295 /opt/mysql-5.0.67/libexec/mysqld: File '/opt/mysql-5.0.67/var/log/mysql/mysql.log' not found (Errcode: 13) 090116 12:27:51 [ERROR] Could not use /opt/mysql-5.0.67/var/log/mysql/mysql.log for logging (error 13). Turning logging off for the whole duration of the MySQL server process. To turn it on again: fix the cause, shutdown the MySQL server and restart it. InnoDB: !!!!!!!!!!!!!! UNIV_DEBUG switched on !!!!!!!!!!!!!!! [New Thread 0xb7c26b90 (LWP 27372)] [New Thread 0xb58e8b90 (LWP 27373)] [New Thread 0xb50e7b90 (LWP 27374)] [New Thread 0xb48e6b90 (LWP 27375)] InnoDB: Log scan progressed past the checkpoint lsn 3 1888274402 090116 12:27:51 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... InnoDB: Doing recovery: scanned up to log sequence number 3 1888277687 InnoDB: 1 transaction(s) which must be rolled back or cleaned up InnoDB: in total 6 row operations to undo InnoDB: Trx id counter is 0 196608 090116 12:27:51 InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percents: 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 InnoDB: Apply batch completed InnoDB: Last MySQL binlog file position 0 262363, file name /var/log/mysql/mysql-bin.000005 [New Thread 0xb3c56b90 (LWP 27376)] InnoDB: Starting in background the rollback of uncommitted transactions 090116 12:27:52 InnoDB: Rolling back trx with id 0 196173, 6 rows to undo [New Thread 0xb3455b90 (LWP 27377)] [New Thread 0xb2c54b90 (LWP 27378)] 090116 12:27:52InnoDB: Assertion failure in thread 3016059792 in file ./../include/rem0rec.ic line 1231 InnoDB: Failing assertion: !rec_offs_comp(offsets) InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.0/en/forcing-recovery.html InnoDB: about forcing recovery. InnoDB: Thread 3082974912 stopped in file os0sync.c line 586 Program received signal SIGSEGV, Segmentation fault. [Switching to Thread 0xb3c56b90 (LWP 27376)] 0x083b8d2e in rec_set_nth_field (rec=0xb5aa372f "\200", offsets=0xb3c55b10, n=6, data=0xb62b2685, len=4294967295) at ./../include/rem0rec.ic:1231 1231 ut_ad(!rec_offs_comp(offsets)); (gdb) bt full #0 0x083b8d2e in rec_set_nth_field (rec=0xb5aa372f "\200", offsets=0xb3c55b10, n=6, data=0xb62b2685, len=4294967295) at ./../include/rem0rec.ic:1231 data2 = (unsigned char *) 0x0 len2 = 0 #1 0x0833553b in row_upd_rec_in_place (rec=0xb5aa372f "\200", offsets=0xb3c55b10, update=0xb62b26c8) at row0upd.c:457 upd_field = (upd_field_t *) 0xb62b26d8 new_val = (dfield_t *) 0xb62b26e0 n_fields = 3 i = 0 #2 0x0834ef2b in btr_cur_update_in_place (flags=7, cursor=0xb62a5dc8, update=0xb62b26c8, cmpl_info=1, thr=0xb62a5cf8, mtr=0xb3c55dd8) at btr0cur.c:1497 index = (dict_index_t *) 0xb62b2f68 block = (buf_block_t *) 0xb5a0f6f0 err = 10 rec = (rec_t *) 0xb5aa372f "\200" roll_ptr = {high = 0, low = 0} trx = (trx_t *) 0xb62b0468 was_delete_marked = 0 heap = (mem_heap_t *) 0x0 offsets_ = {100, 41, 3047831343, 3056283496, 2147483679, 4, 10, 17, 2147483665, 18, 19, 2147483667, 2147483667, 26, 26, 26, 26, 37, 50, 2147483698, 55, 63, 2147483711, 68, 70, 70, 2147483718, 70, 70, 71, 72, 72, 72, 74, 85, 104, 112, 118, 2147483766, 2147483766, 2147483766, 118, 118, 2147483766, 126, 127, 3016055768, 138159702, 140067964, 140067988, 3016055784, 138159960, 140067956, 3056291864, 3016055848, 138216257, 140067956, 4096, 140067944, 138232567, 0, 0, 3016055832, 0, 0, 64, 13056, 3056291864, 0, 2, 3016055912, 138214980, 140067944, 1, 513, 138115482, 3056314472, 2, 3056314472, 1024, 11, 2048, 2147483648, 3056312344, 3056314392, 3056229736, 3016055960, 138209040, 3056314408, 140067944, 3056314472, 4, 4294967295, 7, 3016056008, 0, 1088, 0, 3016056008, 138203802} offsets = (ulint *) 0xb3c55b10 #3 0x0834f23d in btr_cur_optimistic_update (flags=7, cursor=0xb62a5dc8, update=0xb62b26c8, cmpl_info=1, thr=0xb62a5cf8, mtr=0xb3c55dd8) at btr0cur.c:1582 index = (dict_index_t *) 0xb62b2f68 page_cursor = (page_cur_t *) 0x1 err = 137818472 page = (ib_page_t *) 0xb5aa0000 "{bE�" rec = (rec_t *) 0xb5aa372f "\200" max_size = 3056281128 new_rec_size = 138202221 old_rec_size = 3056282152 new_entry = (dtuple_t *) 0xb5aa372f roll_ptr = {high = 640, low = 138201596} trx = (trx_t *) 0xb62b2a68 heap = (mem_heap_t *) 0xb62ba828 reorganized = 0 i = 4294967295 offsets = (ulint *) 0xb62ba868 #4 0x0833a38a in row_undo_mod_clust_low (node=0xb62a5d68, thr=0xb62a5cf8, mtr=0xb3c55dd8, mode=2) at row0umod.c:103 dummy_big_rec = (big_rec_t *) 0xb62a5d68 pcur = (btr_pcur_t *) 0xb62a5dc8 btr_cur = (btr_cur_t *) 0xb62a5dc8 err = 3016056200 success = 1 #5 0x0833a690 in row_undo_mod_clust (node=0xb62a5d68, thr=0xb62a5cf8) at row0umod.c:217 pcur = (btr_pcur_t *) 0xb62a5dc8 mtr = {state = 12231, memo = {heap = 0x0, used = 8, data = "\002\000\000\000����\000\000\000\000\002", '\0' , "h\000+�t\207\000\000\000\000\000\000\b\000\000\000\001\000\000\000\000\000\000\000\001", '\0' , "\001���", '\0' , base = {count = 0, start = 0x6af0, end = 0x0}, list = {prev = 0x0, next = 0x0}, buf_end = 0, magic_n = 375767}, log = {heap = 0x0, used = 0, data = "\030`ųu4=\b|DY\b\f���H`ų�%<\b\001\000\000\000\000\000\000\000�j\000\000\000\020\000\000@\001\000\000\220kųH`ų�B=\b|DY\b\000\000\000\000X`ųV&<\b|DY\b\224DY\bh`ųX'<\btDY\b\030P+��`ųA\003=\btDY\b\000\020\000\000hDY\b�B=\b\000\000\000\000\000\000\000\000\230`ų\000\000\000\000\000\000\000\000@\000\000\000\200;\000\000\030P+�\a\000\000\000\a\000\000\000�`ųj\037=\b,�,�,&+��`ų��<\b(�,�\000\037\000\000�j\000\000\a\000\000\000"..., base = {count = 1, start = 0x54050110, end = 0x0}, list = {prev = 0x2fe48, next = 0x0}, buf_end = 0, magic_n = 375767}, modifications = 0, n_log_recs = 0, log_mode = 21, start_lsn = {high = 1, low = 10}, end_lsn = {high = 0, low = 54551}, magic_n = 54551} err = 3056283496 success = 1 more_vers = 0 new_undo_no = {high = 0, low = 0} #6 0x0833b992 in row_undo_mod (node=0xb62a5d68, thr=0xb62a5cf8) at row0umod.c:761 found = 1 err = 10 #7 0x0833461b in row_undo (node=0xb62a5d68, thr=0xb62a5cf8) at row0undo.c:284 err = 10 trx = (trx_t *) 0xb62b0468 roll_ptr = {high = 1, low = 1409614096} locked_data_dict = 1 #8 0x08334763 in row_undo_step (thr=0xb62a5cf8) at row0undo.c:326 err = 10 node = (undo_node_t *) 0xb62a5d68 trx = (trx_t *) 0xb62b0468 #9 0x083154a3 in que_thr_step (thr=0xb62a5cf8) at que0que.c:1190 node = (que_node_t *) 0xb62a5d68 old_thr = (que_thr_t *) 0xb62a5cf8 trx = (trx_t *) 0xb type = 10 #10 0x083155fd in que_run_threads (thr=0xb62a5cf8) at que0que.c:1248 next_thr = (que_thr_t *) 0xb62a5cf8 cumul_resource = 0 loop_count = 25 #11 0x083603d7 in trx_rollback_or_clean_all_without_sess (arg=0xbffef4b4) at trx0roll.c:537 heap = (mem_heap_t *) 0xb62a5828 fork = (que_fork_t *) 0xb62a5868 thr = (que_thr_t *) 0xb62a58f8 roll_node = (roll_node_t *) 0xb62a5968 trx = (trx_t *) 0xb62b0468 table = (dict_table_t *) 0x0 rows_to_undo = 6 unit = 0x84fa538 "" err = 0 #12 0xb7eeb4fb in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 No symbol table info available. #13 0xb7cffe5e in clone () from /lib/tls/i686/cmov/libc.so.6 No symbol table info available.