(gdb) r Starting program: /opt/mysql-5.0.67/libexec/mysqld [Thread debugging using libthread_db enabled] [New Thread 0xb7cd46c0 (LWP 30589)] [New Thread 0xb7cd3b90 (LWP 30592)] [Thread 0xb7cd3b90 (LWP 30592) exited] 090116 14:34:55 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295 090116 14:34:55 [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 14:34:55 [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. [New Thread 0xb7cd3b90 (LWP 30593)] [New Thread 0xb599fb90 (LWP 30594)] [New Thread 0xb519eb90 (LWP 30595)] [New Thread 0xb499db90 (LWP 30596)] InnoDB: Log scan progressed past the checkpoint lsn 3 1888274402 090116 14:34:55 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 14:34:55 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 0xb3d0db90 (LWP 30597)] InnoDB: Starting in background the rollback of uncommitted transactions 090116 14:34:55 InnoDB: Rolling back trx with id 0 196173, 6 rows to undo [New Thread 0xb350cb90 (LWP 30598)] [New Thread 0xb2d0bb90 (LWP 30599)] Program received signal SIGSEGV, Segmentation fault. [Switching to Thread 0xb3d0db90 (LWP 30597)] 0x083a9c57 in data_write_sql_null (data=0xb5b4fc37 "", len=4294966010) at ./../include/data0data.ic:406 406 data[j] = '\0'; (gdb) bt full #0 0x083a9c57 in data_write_sql_null (data=0xb5b4fc37 "", len=4294966010) at ./../include/data0data.ic:406 j = 26629065 #1 0x083a9b94 in rec_set_nth_field_sql_null (rec=0xb5b4f72f "\200", n=6) at rem0rec.c:715 offset = 1288 #2 0x0832dfd5 in rec_set_nth_field (rec=0xb5b4f72f "\200", offsets=0xb3d0cb30, n=6, data=0xb6353c85, len=4294967295) at ./../include/rem0rec.ic:1232 data2 = (unsigned char *) 0x5
len2 = 0 #3 0x0832def5 in row_upd_rec_in_place (rec=0xb5b4f72f "\200", offsets=0xb3d0cb30, update=0xb6353cc8) at row0upd.c:457 upd_field = (upd_field_t *) 0xb6353cd8 new_val = (dfield_t *) 0xb6353ce0 n_fields = 3 i = 0 #4 0x083488b4 in btr_cur_update_in_place (flags=7, cursor=0xb63539c8, update=0xb6353cc8, cmpl_info=1, thr=0xb63538f8, mtr=0xb3d0cde8) at btr0cur.c:1497 index = (dict_index_t *) 0xb6354e68 block = (buf_block_t *) 0xb5ac6010 err = 10 rec = (rec_t *) 0xb5b4f72f "\200" roll_ptr = {high = 0, low = 0} trx = (trx_t *) 0xb635c868 was_delete_marked = 0 heap = (mem_heap_t *) 0x0 offsets_ = {100, 41, 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, 3016806404, 43, 0, 3057084456, 6, 3016809360, 3016805384, 138112465, 139945044, 3086596620, 3016805432, 138112328, 1, 3016805860, 3016805416, 3, 6, 3016809360, 3016805432, 138128372, 139945044, 0, 3016805448, 138112566, 139945044, 139945068, 3016805464, 138112519, 139945036, 10, 3016805528, 138117059, 139945036, 1, 513, 138055091, 0, 3047973024, 3016805544, 1024, 11, 2048, 0, 3057082392, 3057084440, 3056941416, 3016805576, 138112130, 3057084456, 139945024, 3016805608, 137550648, 3057084520, 2, 3057084520, 0} offsets = (ulint *) 0xb3d0cb30 #5 0x083490f7 in btr_cur_optimistic_update (flags=7, cursor=0xb63539c8, update=0xb6353cc8, cmpl_info=1, thr=0xb63538f8, mtr=0xb3d0cde8) at btr0cur.c:1582 index = (dict_index_t *) 0xb6354e68 page_cursor = (page_cur_t *) 0x839db92 err = 3016805736 page = (ib_page_t *) 0xb5b4c000 "{bE�" rec = (rec_t *) 0xb5b4f72f "\200" max_size = 3047969160 new_rec_size = 138009640 old_rec_size = 3016805736 new_entry = (dtuple_t *) 0x0 roll_ptr = {high = 3016805688, low = 0} trx = (trx_t *) 0x0 heap = (mem_heap_t *) 0xb6376828 reorganized = 0 i = 1 offsets = (ulint *) 0xb6376868 #6 0x0833370e in row_undo_mod_clust_low (node=0xb6353968, thr=0xb63538f8, mtr=0xb3d0cde8, mode=2) at row0umod.c:103 dummy_big_rec = (big_rec_t *) 0xb6353968 pcur = (btr_pcur_t *) 0xb63539c8 btr_cur = (btr_cur_t *) 0xb63539c8 err = 3016805800 success = 1 #7 0x083338d8 in row_undo_mod_clust (node=0xb6353968, thr=0xb63538f8) at row0umod.c:217 pcur = (btr_pcur_t *) 0xb63539c8 mtr = {state = 0, memo = {heap = 0x0, used = 8, data = "\002\000\000\000\020`��\000\000\000\000\002", '\0' , "h�5�\000\000\000\000\000\000\000\000\b\000\000\000\001\000\000\000\000\000\000\000\001", '\0' , base = {count = 0, start = 0x0, end = 0x0}, list = {prev = 0x0, next = 0x0}}, log = {heap = 0x0, used = 0, data = "*\000�T\v\000)\000\001\200\004\200\006\200\a\000\001���\001\000\004\000\004\200\000\177�\177�\177\000\000\000\000\000\000\000\000\205w\000\0 00\000\000\000\200\000\200\000\000\000\000\000\000\000\000\000\000 \000\000\000@\001\000\000\220�гh�г�m;\bTdW\b\f���\230�гHm;\b\001\000\000\000\000\001\200\004\200\006\200\a\200�\017\000@\001\000\000\220�г\230�г��;\bTdW\b\000\000\000\000��г6n;\bTdW\bldW\b��г\an;\b\a\000\000\000\a\000\000\000��г\006\222;\b,h6�,<5�\b\000\000\000\000\037\000\000(h6�\v\002\000\000"..., base = {count = 0, start = 0x2fe48, end = 0x0}, list = {prev = 0x419, next = 0x0}}, modifications = 0, n_log_recs = 0, log_mode = 21, start_lsn = {high = 1, low = 10}, end_lsn = {high = 0, low = 3056942206}, magic_n = 4278845440} err = 3056946792 success = 1 more_vers = 0 new_undo_no = {high = 0, low = 0} #8 0x083350b2 in row_undo_mod (node=0xb6353968, thr=0xb63538f8) at row0umod.c:761 found = 1 err = 10 #9 0x0832c918 in row_undo (node=0xb6353968, thr=0xb63538f8) at row0undo.c:284 err = 10 trx = (trx_t *) 0xb635c868 roll_ptr = {high = 1, low = 1409614096} locked_data_dict = 1 #10 0x0832cd5a in row_undo_step (thr=0xb63538f8) at row0undo.c:326 err = 10 node = (undo_node_t *) 0xb6353968 trx = (trx_t *) 0xb635c868 #11 0x0830b26c in que_thr_step (thr=0xb63538f8) at que0que.c:1190 node = (que_node_t *) 0xb6353968 old_thr = (que_thr_t *) 0xb63538f8 trx = (trx_t *) 0xb type = 10 #12 0x0830af5a in que_run_threads (thr=0xb63538f8) at que0que.c:1248 next_thr = (que_thr_t *) 0xb63538f8 cumul_resource = 0 loop_count = 25 #13 0x0835c3d2 in trx_rollback_or_clean_all_without_sess (arg=0xbf8e8db4) at trx0roll.c:537 heap = (mem_heap_t *) 0xb635ec28 fork = (que_fork_t *) 0xb635ec68 thr = (que_thr_t *) 0xb635ecf8 roll_node = (roll_node_t *) 0xb635ed68 trx = (trx_t *) 0xb635c868 table = (dict_table_t *) 0x0 rows_to_undo = 6 unit = 0x84e005c "" err = 0 #14 0xb7f984fb in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 No symbol table info available. #15 0xb7dace5e in clone () from /lib/tls/i686/cmov/libc.so.6 No symbol table info available.