Oct 16 14:52:53 ibookservice mysqld: 091016 14:52:53 - mysqld got signal 11 ; Oct 16 14:52:53 ibookservice mysqld: This could be because you hit a bug. It is also possible that this binary Oct 16 14:52:53 ibookservice mysqld: or one of the libraries it was linked against is corrupt, improperly built, Oct 16 14:52:53 ibookservice mysqld: or misconfigured. This error can also be caused by malfunctioning hardware. Oct 16 14:52:53 ibookservice mysqld: We will try our best to scrape up some info that will hopefully help diagnose Oct 16 14:52:53 ibookservice mysqld: the problem, but since we have already crashed, something is definitely wrong Oct 16 14:52:53 ibookservice mysqld: and this may fail. Oct 16 14:52:53 ibookservice mysqld: Oct 16 14:52:53 ibookservice mysqld: key_buffer_size=2147483648 Oct 16 14:52:53 ibookservice mysqld: read_buffer_size=131072 Oct 16 14:52:53 ibookservice mysqld: max_used_connections=8 Oct 16 14:52:53 ibookservice mysqld: max_threads=151 Oct 16 14:52:53 ibookservice mysqld: threads_connected=5 Oct 16 14:52:53 ibookservice mysqld: It is possible that mysqld could use up to Oct 16 14:52:53 ibookservice mysqld: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 2427265 K Oct 16 14:52:53 ibookservice mysqld: bytes of memory Oct 16 14:52:53 ibookservice mysqld: Hope that's ok; if not, decrease some variables in the equation. Oct 16 14:52:53 ibookservice mysqld: Oct 16 14:52:53 ibookservice mysqld: thd: 0x7fd348035900 Oct 16 14:52:53 ibookservice mysqld: Attempting backtrace. You can use the following information to find out Oct 16 14:52:53 ibookservice mysqld: where mysqld died. If you see no messages after this, something went Oct 16 14:52:53 ibookservice mysqld: terribly wrong... Oct 16 14:52:53 ibookservice mysqld: stack_bottom = 0x44c8d100 thread_stack 0x20000 Oct 16 14:52:53 ibookservice mysqld: /usr/sbin/mysqld(my_print_stacktrace+0x29) [0x7fd50438f819] Oct 16 14:52:53 ibookservice mysqld: /usr/sbin/mysqld(handle_segfault+0x36a) [0x7fd5040a744a] Oct 16 14:52:53 ibookservice mysqld: /lib/libpthread.so.0 [0x7fd503914a80] Oct 16 14:52:53 ibookservice mysqld: /lib/libc.so.6(memcpy+0xd2) [0x7fd502415f82] Oct 16 14:52:53 ibookservice mysqld: /usr/sbin/mysqld(String::append(char const*, unsigned int)+0x259) [0x7fd5040a25d9] Oct 16 14:52:53 ibookservice mysqld: /usr/sbin/mysqld(thd_security_context+0x1c4) [0x7fd504093d74] Oct 16 14:52:53 ibookservice mysqld: /usr/sbin/mysqld(innobase_mysql_print_thd+0x30) [0x7fd50424c630] Oct 16 14:52:53 ibookservice mysqld: /usr/sbin/mysqld(lock_print_info_all_transactions+0x2a1) [0x7fd50429f651] Oct 16 14:52:53 ibookservice mysqld: /usr/sbin/mysqld(srv_printf_innodb_monitor+0x17f) [0x7fd5042f1aaf] Oct 16 14:52:53 ibookservice mysqld: /usr/sbin/mysqld [0x7fd50425029b] Oct 16 14:52:53 ibookservice mysqld: /usr/sbin/mysqld(ha_show_status(THD*, handlerton*, ha_stat_type)+0x379) [0x7fd5041a25d9] Oct 16 14:52:53 ibookservice mysqld: /usr/sbin/mysqld(mysql_execute_command(THD*)+0xe19) [0x7fd5040b9209] Oct 16 14:52:53 ibookservice mysqld: /usr/sbin/mysqld(mysql_parse(THD*, char const*, unsigned int, char const**)+0x367) [0x7fd5040be0d7] Oct 16 14:52:53 ibookservice mysqld: /usr/sbin/mysqld(dispatch_command(enum_server_command, THD*, char*, unsigned int)+0xdce) [0x7fd5040beeae] Oct 16 14:52:53 ibookservice mysqld: /usr/sbin/mysqld(do_command(THD*)+0xe8) [0x7fd5040bf928] Oct 16 14:52:53 ibookservice mysqld: /usr/sbin/mysqld(handle_one_connection+0x22e) [0x7fd5040b1c9e] Oct 16 14:52:53 ibookservice mysqld: /lib/libpthread.so.0 [0x7fd50390cfc7] Oct 16 14:52:53 ibookservice mysqld: /lib/libc.so.6(clone+0x6d) [0x7fd5024685ad] Oct 16 14:52:53 ibookservice mysqld: Trying to get some variables. Oct 16 14:52:53 ibookservice mysqld: Some pointers may be invalid and cause the dump to abort... Oct 16 14:52:53 ibookservice mysqld: thd->query at 0x7fd348040200 is an invalid pointer Oct 16 14:52:53 ibookservice mysqld: thd->thread_id=1024 Oct 16 14:52:53 ibookservice mysqld: thd->killed=NOT_KILLED Oct 16 14:52:53 ibookservice mysqld: The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains Oct 16 14:52:53 ibookservice mysqld: information that should help you find out what is causing the crash. Oct 16 14:52:54 ibookservice mysqld_safe: Number of processes running now: 0 Oct 16 14:52:54 ibookservice mysqld_safe: mysqld restarted Oct 16 14:52:54 ibookservice mysqld: 091016 14:52:54 [Warning] option 'max_allowed_packet': unsigned value 2147483648 adjusted to 1073741824 Oct 16 14:52:54 ibookservice mysqld: 091016 14:52:54 [Note] Plugin 'FEDERATED' is disabled. Oct 16 14:52:54 ibookservice mysqld: InnoDB: Log scan progressed past the checkpoint lsn 18 890115021 Oct 16 14:52:54 ibookservice mysqld: 091016 14:52:54 InnoDB: Database was not shut down normally! Oct 16 14:52:54 ibookservice mysqld: InnoDB: Starting crash recovery. Oct 16 14:52:54 ibookservice mysqld: InnoDB: Reading tablespace information from the .ibd files... Oct 16 14:52:54 ibookservice mysqld: InnoDB: Restoring possible half-written data pages from the doublewrite Oct 16 14:52:54 ibookservice mysqld: InnoDB: buffer... Oct 16 14:52:55 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 895357440 Oct 16 14:52:55 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 900600320 Oct 16 14:52:55 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 905843200 Oct 16 14:52:55 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 911086080 Oct 16 14:52:55 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 916328960 Oct 16 14:52:56 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 921571840 Oct 16 14:52:56 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 926814720 Oct 16 14:52:56 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 932057600 Oct 16 14:52:56 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 937300480 Oct 16 14:52:57 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 942543360 Oct 16 14:52:57 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 947786240 Oct 16 14:52:57 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 953029120 Oct 16 14:52:58 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 958272000 Oct 16 14:52:58 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 963514880 Oct 16 14:52:58 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 968757760 Oct 16 14:52:59 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 974000640 Oct 16 14:52:59 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 979243520 Oct 16 14:52:59 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 984486400 Oct 16 14:53:00 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 989729280 Oct 16 14:53:00 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 994972160 Oct 16 14:53:00 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 1000215040 Oct 16 14:53:01 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 1005457920 Oct 16 14:53:01 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 1010700800 Oct 16 14:53:02 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 1015943680 Oct 16 14:53:02 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 1021186560 Oct 16 14:53:02 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 1026429440 Oct 16 14:53:03 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 1031672320 Oct 16 14:53:03 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 1036915200 Oct 16 14:53:04 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 1042158080 Oct 16 14:53:04 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 1047400960 Oct 16 14:53:04 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 1052643840 Oct 16 14:53:05 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 1057886720 Oct 16 14:53:05 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 1063129600 Oct 16 14:53:05 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 1057886720 Oct 16 14:53:05 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 1063129600 Oct 16 14:53:06 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 1068372480 Oct 16 14:53:06 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 1073615360 Oct 16 14:53:07 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 1078858240 Oct 16 14:53:07 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 1084101120 Oct 16 14:53:08 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 1089344000 Oct 16 14:53:08 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 1094586880 Oct 16 14:53:09 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 1099829760 Oct 16 14:53:09 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 1105072640 Oct 16 14:53:10 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 1110315520 Oct 16 14:53:10 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 1115558400 Oct 16 14:53:11 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 1120801280 Oct 16 14:53:12 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 1126044160 Oct 16 14:53:12 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 1131287040 Oct 16 14:53:13 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 1136529920 Oct 16 14:53:13 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 1141772800 Oct 16 14:53:14 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 1147015680 Oct 16 14:53:14 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 1152258560 Oct 16 14:53:15 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 1157501440 Oct 16 14:53:16 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 1162744320 Oct 16 14:53:16 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 1167987200 Oct 16 14:53:17 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 1173230080 Oct 16 14:53:17 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 1178472960 Oct 16 14:53:18 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 1183715840 Oct 16 14:53:19 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 1188958720 Oct 16 14:53:19 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 1194201600 Oct 16 14:53:20 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 1199444480 Oct 16 14:53:21 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 1204687360 Oct 16 14:53:21 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 1209930240 Oct 16 14:53:22 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 1215173120 Oct 16 14:53:23 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 1220416000 Oct 16 14:53:23 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 1225658880 Oct 16 14:53:24 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 1230901760 Oct 16 14:53:25 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 1236144640 Oct 16 14:53:26 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 1241387520 Oct 16 14:53:26 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 1246630400 Oct 16 14:53:27 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 1251873280 Oct 16 14:53:28 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 1257116160 Oct 16 14:53:29 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 1262359040 Oct 16 14:53:29 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 1267601920 Oct 16 14:53:30 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 1272844800 Oct 16 14:53:31 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 1278087680 Oct 16 14:53:31 ibookservice mysqld: InnoDB: Doing recovery: scanned up to log sequence number 18 1280447748 Oct 16 14:53:31 ibookservice mysqld: 091016 14:53:31 InnoDB: Starting an apply batch of log records to the database... Oct 16 14:55:01 ibookservice /USR/SBIN/CRON[19247]: (root) CMD (if [ -x /etc/munin/plugins/apt_all ]; then /etc/munin/plugins/apt_all update 7200 12 >/dev/null; elif [ -x /etc/munin/plugins/apt ]; then /etc/munin/plugins/apt update 7200 12 >/dev/null; fi) Oct 16 14:58:19 ibookservice mysqld: InnoDB: Progress in percents: 0 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 Oct 16 14:58:19 ibookservice mysqld: InnoDB: Apply batch completed Oct 16 14:58:20 ibookservice mysqld: 091016 14:58:20 InnoDB: Started; log sequence number 18 1280447748 Oct 16 14:58:20 ibookservice mysqld: 091016 14:58:20 [Note] Event Scheduler: Loaded 0 events Oct 16 14:58:20 ibookservice mysqld: 091016 14:58:20 [Note] /usr/sbin/mysqld: ready for connections. Oct 16 14:58:20 ibookservice mysqld: Version: '5.1.39-0.dotdeb.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Debian)