1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
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
100
101
102
103
104
105
106
107
108
109
| Apr 20 15:05:30 dbase2 mysqld: InnoDB: Error: MySQL is trying to perform a consistent read
Apr 20 15:05:30 dbase2 mysqld: InnoDB: but the read view is not assigned!
Apr 20 15:05:30 dbase2 mysqld: TRANSACTION 0 869279488, ACTIVE 0 sec, process no 17815, OS thread id 140163627144960 starting index read, thread declared inside InnoDB 500
Apr 20 15:05:30 dbase2 mysqld: mysql tables in use 17, locked 16
Apr 20 15:05:30 dbase2 mysqld: MySQL thread id 1304928, query id 5272358470 192.168.1.4 web checking permissions
Apr 20 15:05:30 dbase2 mysqld: SELECT
Apr 20 15:05:30 dbase2 mysqld: torder.ordid,
Apr 20 15:05:30 dbase2 mysqld: torder.uid1,
Apr 20 15:05:30 dbase2 mysqld: UserName(torder.uid1, 0) AS uidname1,
Apr 20 15:05:30 dbase2 mysqld: torder.uid2,
Apr 20 15:05:30 dbase2 mysqld: UserName(torder.uid2, 0) AS uidname2,
Apr 20 15:05:30 dbase2 mysqld: torder.ordphone,
Apr 20 15:05:30 dbase2 mysqld: torder.ordphone2,
Apr 20 15:05:30 dbase2 mysqld: torder.ordtime,
Apr 20 15:05:30 dbase2 mysqld: DialStatus(torder.ordid) AS DialST,
Apr 20 15:05:30 dbase2 mysqld: torder.ordpretime,
Apr 20 15:05:30 dbase2 mysqld: torder.ordtermtime,
Apr 20 15:05:30 dbase2 mysqld: OrdTime1(torder.orgid2, torder.drvtime, torder.ordpretype, torder.ordredirecttime, torder.ordpretime, torder.ordconfirmtime, torder.ordreachtime, torder.ordwaytime, torder.statusid) drvtime,
Apr 20 15:05:30 dbase2 mysqld: torder.drvtime AS drvtime1,
Apr 20 15:05:30 dbase2 mysqld: torder.ordinputtime,
Apr 20 15:05:30 dbase2 mysqld: torder.ordredirecttime,
Apr 20 15:05:30 dbase2 mysqld: torder.ordclienttime,
Apr 20 15:05:30 dbase2 mysqld: torder.ordreac
Apr 20 15:05:30 dbase2 mysqld:
Apr 20 15:05:30 dbase2 mysqld: 120420 15:05:30 InnoDB: Assertion failure in thread 140163627144960 in file ../../../storage/innobase/row/row0sel.c line 3689
Apr 20 15:05:30 dbase2 mysqld: InnoDB: Failing assertion: 0
Apr 20 15:05:30 dbase2 mysqld: InnoDB: We intentionally generate a memory trap.
Apr 20 15:05:30 dbase2 mysqld: InnoDB: Submit a detailed bug report to [url]http://bugs.mysql.com[/url].
Apr 20 15:05:30 dbase2 mysqld: InnoDB: If you get repeated assertion failures or crashes, even
Apr 20 15:05:30 dbase2 mysqld: InnoDB: immediately after the mysqld startup, there may be
Apr 20 15:05:30 dbase2 mysqld: InnoDB: corruption in the InnoDB tablespace. Please refer to
Apr 20 15:05:30 dbase2 mysqld: InnoDB: [url]http://dev.mysql.com/doc/refman/5.1/en/forcing-recovery.html[/url]
Apr 20 15:05:30 dbase2 mysqld: InnoDB: about forcing recovery.
Apr 20 15:05:30 dbase2 mysqld: 120420 15:05:30 - mysqld got signal 6 ;
Apr 20 15:05:30 dbase2 mysqld: This could be because you hit a bug. It is also possible that this binary
Apr 20 15:05:30 dbase2 mysqld: or one of the libraries it was linked against is corrupt, improperly built,
Apr 20 15:05:30 dbase2 mysqld: or misconfigured. This error can also be caused by malfunctioning hardware.
Apr 20 15:05:30 dbase2 mysqld: We will try our best to scrape up some info that will hopefully help diagnose
Apr 20 15:05:30 dbase2 mysqld: the problem, but since we have already crashed, something is definitely wrong
Apr 20 15:05:30 dbase2 mysqld: and this may fail.
Apr 20 15:05:30 dbase2 mysqld:
Apr 20 15:05:30 dbase2 mysqld: key_buffer_size=536870912
Apr 20 15:05:30 dbase2 mysqld: read_buffer_size=262144
Apr 20 15:05:30 dbase2 mysqld: max_used_connections=101
Apr 20 15:05:30 dbase2 mysqld: max_threads=200
Apr 20 15:05:30 dbase2 mysqld: threads_connected=38
Apr 20 15:05:30 dbase2 mysqld: It is possible that mysqld could use up to
Apr 20 15:05:30 dbase2 mysqld: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 1040409 K
Apr 20 15:05:30 dbase2 mysqld: bytes of memory
Apr 20 15:05:30 dbase2 mysqld: Hope that's ok; if not, decrease some variables in the equation.
Apr 20 15:05:30 dbase2 mysqld:
Apr 20 15:05:30 dbase2 mysqld: thd: 0x7f7a649328d0
Apr 20 15:05:30 dbase2 mysqld: Attempting backtrace. You can use the following information to find out
Apr 20 15:05:30 dbase2 mysqld: where mysqld died. If you see no messages after this, something went
Apr 20 15:05:30 dbase2 mysqld: terribly wrong...
Apr 20 15:05:30 dbase2 mysqld: stack_bottom = 0x7f7a6334ce88 thread_stack 0x40000
Apr 20 15:05:30 dbase2 mysqld: /usr/sbin/mysqld(my_print_stacktrace+0x29) [0x7f7b233a4829]
Apr 20 15:05:30 dbase2 mysqld: /usr/sbin/mysqld(handle_segfault+0x404) [0x7f7b230aeb14]
Apr 20 15:05:30 dbase2 mysqld: /lib/libpthread.so.0(+0xef60) [0x7f7b22910f60]
Apr 20 15:05:30 dbase2 mysqld: /lib/libc.so.6(gsignal+0x35) [0x7f7b213b4165]
Apr 20 15:05:30 dbase2 mysqld: /lib/libc.so.6(abort+0x180) [0x7f7b213b6f70]
Apr 20 15:05:30 dbase2 mysqld: /usr/sbin/mysqld(row_search_for_mysql+0x1028) [0x7f7b232fc6c8]
Apr 20 15:05:30 dbase2 mysqld: /usr/sbin/mysqld(ha_innobase::index_read(unsigned char*, unsigned char const*, unsigned int, ha_rkey_function)+0x18f) [0x7f7b232641ef]
Apr 20 15:05:30 dbase2 mysqld: /usr/sbin/mysqld(handler::read_range_first(st_key_range const*, st_key_range const*, bool, bool)+0xbe) [0x7f7b231ad01e]
Apr 20 15:05:30 dbase2 mysqld: /usr/sbin/mysqld(handler::read_multi_range_next(st_key_multi_range**)+0x9e) [0x7f7b231a9cce]
Apr 20 15:05:30 dbase2 mysqld: /usr/sbin/mysqld(QUICK_RANGE_SELECT::get_next()+0x3d) [0x7f7b2318c6fd]
Apr 20 15:05:30 dbase2 mysqld: /usr/sbin/mysqld(+0x4682d5) [0x7f7b231a62d5]
Apr 20 15:05:30 dbase2 mysqld: /usr/sbin/mysqld(+0x3dc81a) [0x7f7b2311a81a]
Apr 20 15:05:30 dbase2 mysqld: /usr/sbin/mysqld(sub_select_cache(JOIN*, st_join_table*, bool)+0x67) [0x7f7b2311acb7]
Apr 20 15:05:30 dbase2 mysqld: /usr/sbin/mysqld(+0x3ddc60) [0x7f7b2311bc60]
Apr 20 15:05:30 dbase2 mysqld: /usr/sbin/mysqld(JOIN::exec()+0x4bf) [0x7f7b2313020f]
Apr 20 15:05:30 dbase2 mysqld: /usr/sbin/mysqld(mysql_select(THD*, Item***, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*)+0x142) [0x7f7b2312c622]
Apr 20 15:05:30 dbase2 mysqld: /usr/sbin/mysqld(handle_select(THD*, st_lex*, select_result*, unsigned long)+0x174) [0x7f7b23131f24]
Apr 20 15:05:30 dbase2 mysqld: /usr/sbin/mysqld(+0x37edfa) [0x7f7b230bcdfa]
Apr 20 15:05:30 dbase2 mysqld: /usr/sbin/mysqld(mysql_execute_command(THD*)+0x516) [0x7f7b230c0df6]
Apr 20 15:05:30 dbase2 mysqld: /usr/sbin/mysqld(mysql_parse(THD*, char const*, unsigned int, char const**)+0x3fb) [0x7f7b230c630b]
Apr 20 15:05:30 dbase2 mysqld: /usr/sbin/mysqld(dispatch_command(enum_server_command, THD*, char*, unsigned int)+0xb34) [0x7f7b230c6e54]
Apr 20 15:05:30 dbase2 mysqld: /usr/sbin/mysqld(do_command(THD*)+0xea) [0x7f7b230c7d3a]
Apr 20 15:05:30 dbase2 mysqld: /usr/sbin/mysqld(handle_one_connection+0x235) [0x7f7b230b9a25]
Apr 20 15:05:30 dbase2 mysqld: /lib/libpthread.so.0(+0x68ba) [0x7f7b229088ba]
Apr 20 15:05:30 dbase2 mysqld: /lib/libc.so.6(clone+0x6d) [0x7f7b2145102d]
Apr 20 15:05:30 dbase2 mysqld: Trying to get some variables.
Apr 20 15:05:30 dbase2 mysqld: Some pointers may be invalid and cause the dump to abort...
Apr 20 15:05:30 dbase2 mysqld: thd->query at 0x7f7a641f6010 is an invalid pointer
Apr 20 15:05:30 dbase2 mysqld: thd->thread_id=1304928
Apr 20 15:05:30 dbase2 mysqld: thd->killed=NOT_KILLED
Apr 20 15:05:30 dbase2 mysqld: The manual page at [url]http://dev.mysql.com/doc/mysql/en/crashing.html[/url] contains
Apr 20 15:05:30 dbase2 mysqld: information that should help you find out what is causing the crash.
Apr 20 15:05:31 dbase2 mysqld_safe: Number of processes running now: 0
Apr 20 15:05:31 dbase2 mysqld_safe: mysqld restarted
Apr 20 15:05:31 dbase2 mysqld: 120420 15:05:31 [Note] Plugin 'FEDERATED' is disabled.
Apr 20 15:05:31 dbase2 mysqld: InnoDB: Log scan progressed past the checkpoint lsn 18 651014811
Apr 20 15:05:31 dbase2 mysqld: 120420 15:05:31 InnoDB: Database was not shut down normally!
Apr 20 15:05:31 dbase2 mysqld: InnoDB: Starting crash recovery.
Apr 20 15:05:31 dbase2 mysqld: InnoDB: Reading tablespace information from the .ibd files...
Apr 20 15:05:32 dbase2 mysqld: InnoDB: Restoring possible half-written data pages from the doublewrite
Apr 20 15:05:32 dbase2 mysqld: InnoDB: buffer...
Apr 20 15:05:32 dbase2 mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 651019827
Apr 20 15:05:32 dbase2 mysqld: 120420 15:05:32 InnoDB: Starting an apply batch of log records to the database...
Apr 20 15:05:33 dbase2 mysqld: InnoDB: Progress in percents: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 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
Apr 20 15:05:33 dbase2 mysqld: InnoDB: Apply batch completed
Apr 20 15:05:33 dbase2 mysqld: InnoDB: Last MySQL binlog file position 0 30056617, file name /var/log/mysql/mysql-bin.000895
Apr 20 15:05:33 dbase2 mysqld: 120420 15:05:33 InnoDB: Started; log sequence number 18 651019827
Apr 20 15:05:33 dbase2 mysqld: 120420 15:05:33 [Note] Recovering after a crash using /var/log/mysql/mysql-bin
Apr 20 15:05:33 dbase2 mysqld: 120420 15:05:33 [Note] Starting crash recovery...
Apr 20 15:05:33 dbase2 mysqld: 120420 15:05:33 [Note] Crash recovery finished.
Apr 20 15:05:34 dbase2 mysqld: 120420 15:05:34 [Note] Event Scheduler: Loaded 0 events
Apr 20 15:05:34 dbase2 mysqld: 120420 15:05:34 [Note] /usr/sbin/mysqld: ready for connections.
Apr 20 15:05:34 dbase2 mysqld: Version: '5.1.49-3-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Debian) |