[MDEV-5865] mariadb 5.5.36 crash on centos[5,6] container - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Cannot Reproduce
Affects Version/s: 5.5.36
Fix Version/s: 5.5.39
Component/s: None
Labels:
None
Environment:

Hide
Fully updated Centos 5 Openvz container, running on a fully updated Centos 6 Hardware Node.

# cat /proc/version
Linux version 2.6.32-042stab084.26 (root@rh6-build-x64) (gcc version 4.4.6 20120305 (Red Hat 4.4.6-4) (GCC) ) #1 SMP Mon Feb 17 21:00:14 MSK 2014

Show
Fully updated Centos 5 Openvz container, running on a fully updated Centos 6 Hardware Node. # cat /proc/version Linux version 2.6.32-042stab084.26 ( root@rh6-build-x64 ) (gcc version 4.4.6 20120305 (Red Hat 4.4.6-4) (GCC) ) #1 SMP Mon Feb 17 21:00:14 MSK 2014

Description

Occasionally we get this crash:

/var/log/messages-20140306.gz:Mar  5 12:33:12 rps-ppcdb03 mysqld: 140305 12:33:12 [Note] /usr/sbin/mysqld: Normal shutdown

/var/log/messages-20140306.gz:Mar  5 12:33:12 rps-ppcdb03 mysqld:

/var/log/messages-20140306.gz:Mar  5 12:33:12 rps-ppcdb03 mysqld: 140305 12:33:12 [Note] Event Scheduler: Purging the queue. 0 events

/var/log/messages-20140306.gz:Mar  5 12:33:13 rps-ppcdb03 mysqld: 140305 12:33:13  InnoDB: Starting shutdown...

/var/log/messages-20140306.gz:Mar  5 12:33:19 rps-ppcdb03 mysqld: 140305 12:33:19  InnoDB: Shutdown completed; log sequence number 3535957432197

/var/log/messages-20140306.gz:Mar  5 12:33:19 rps-ppcdb03 mysqld: 140305 12:33:19 [Note] /usr/sbin/mysqld: Shutdown complete

/var/log/messages-20140306.gz:Mar  5 12:33:19 rps-ppcdb03 mysqld:

/var/log/messages-20140306.gz:Mar  5 12:33:19 rps-ppcdb03 mysqld_safe: mysqld from pid file /var/lib/mysql/rps-ppcdb03.infinity.local.pid ended

/var/log/messages-20140306.gz:Mar  5 12:33:59 rps-ppcdb03 mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql

/var/log/messages-20140306.gz:Mar  5 12:33:59 rps-ppcdb03 mysqld: 140305 12:33:59 InnoDB: The InnoDB memory heap is disabled

/var/log/messages-20140306.gz:Mar  5 12:33:59 rps-ppcdb03 mysqld: 140305 12:33:59 InnoDB: Mutexes and rw_locks use GCC atomic builtins

/var/log/messages-20140306.gz:Mar  5 12:33:59 rps-ppcdb03 mysqld: 140305 12:33:59 InnoDB: Compressed tables use zlib 1.2.3

/var/log/messages-20140306.gz:Mar  5 12:33:59 rps-ppcdb03 mysqld: 140305 12:33:59 InnoDB: Using Linux native AIO

/var/log/messages-20140306.gz:Mar  5 12:33:59 rps-ppcdb03 mysqld: 140305 12:33:59 InnoDB: Initializing buffer pool, size = 14.0G

/var/log/messages-20140306.gz:Mar  5 12:34:00 rps-ppcdb03 mysqld: 140305 12:34:00 InnoDB: Completed initialization of buffer pool

/var/log/messages-20140306.gz:Mar  5 12:34:00 rps-ppcdb03 mysqld: 140305 12:34:00 InnoDB: highest supported file format is Barracuda.

/var/log/messages-20140306.gz:Mar  5 12:34:01 rps-ppcdb03 mysqld: 140305 12:34:01  InnoDB: Waiting for the background threads to start

/var/log/messages-20140306.gz:Mar  5 12:34:02 rps-ppcdb03 mysqld: 140305 12:34:02 Percona XtraDB (http://www.percona.com) 5.5.35-MariaDB-33.0 started; log sequence number 3535957432197

/var/log/messages-20140306.gz:Mar  5 12:34:02 rps-ppcdb03 mysqld: 140305 12:34:02 [Note] Plugin 'FEEDBACK' is disabled.

/var/log/messages-20140306.gz:Mar  5 12:34:02 rps-ppcdb03 mysqld: 140305 12:34:02 [Note] Server socket created on IP: '::'.

/var/log/messages-20140306.gz:Mar  5 12:34:02 rps-ppcdb03 mysqld: 140305 12:34:02 [Note] Event Scheduler: Loaded 0 events

/var/log/messages-20140306.gz:Mar  5 12:34:02 rps-ppcdb03 mysqld: 140305 12:34:02 [Note] /usr/sbin/mysqld: ready for connections.

/var/log/messages-20140306.gz:Mar  5 12:34:02 rps-ppcdb03 mysqld: Version: '5.5.35-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server

/var/log/messages-20140308.gz:Mar  7 07:17:42 rps-ppcdb03 mysqld: 140307  7:17:42  InnoDB: compressed page checksum mismatch (space 690739 page 153805): 3675315635 != 1653268225

/var/log/messages-20140308.gz:Mar  7 07:17:42 rps-ppcdb03 mysqld: 140307  7:17:42  InnoDB: Assertion failure in thread 140647849183552 in file buf0buf.c line 2792

/var/log/messages-20140308.gz:Mar  7 07:17:42 rps-ppcdb03 mysqld: InnoDB: Failing assertion: success

/var/log/messages-20140308.gz:Mar  7 07:17:42 rps-ppcdb03 mysqld: InnoDB: We intentionally generate a memory trap.

/var/log/messages-20140308.gz:Mar  7 07:17:42 rps-ppcdb03 mysqld: InnoDB: Submit a detailed bug report to http://bugs.mysql.com.

/var/log/messages-20140308.gz:Mar  7 07:17:42 rps-ppcdb03 mysqld: InnoDB: If you get repeated assertion failures or crashes, even

/var/log/messages-20140308.gz:Mar  7 07:17:42 rps-ppcdb03 mysqld: InnoDB: immediately after the mysqld startup, there may be

/var/log/messages-20140308.gz:Mar  7 07:17:42 rps-ppcdb03 mysqld: InnoDB: corruption in the InnoDB tablespace. Please refer to

/var/log/messages-20140308.gz:Mar  7 07:17:42 rps-ppcdb03 mysqld: InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html

/var/log/messages-20140308.gz:Mar  7 07:17:42 rps-ppcdb03 mysqld: InnoDB: about forcing recovery.

/var/log/messages-20140308.gz:Mar  7 07:17:42 rps-ppcdb03 mysqld: 140307  7:17:42 [ERROR] mysqld got signal 6 ;

/var/log/messages-20140308.gz:Mar  7 07:17:42 rps-ppcdb03 mysqld: This could be because you hit a bug. It is also possible that this binary

/var/log/messages-20140308.gz:Mar  7 07:17:42 rps-ppcdb03 mysqld: or one of the libraries it was linked against is corrupt, improperly built,

/var/log/messages-20140308.gz:Mar  7 07:17:42 rps-ppcdb03 mysqld: or misconfigured. This error can also be caused by malfunctioning hardware.

/var/log/messages-20140308.gz:Mar  7 07:17:42 rps-ppcdb03 mysqld:

/var/log/messages-20140308.gz:Mar  7 07:17:42 rps-ppcdb03 mysqld: To report this bug, see http://kb.askmonty.org/en/reporting-bugs

/var/log/messages-20140308.gz:Mar  7 07:17:42 rps-ppcdb03 mysqld:

/var/log/messages-20140308.gz:Mar  7 07:17:42 rps-ppcdb03 mysqld: We will try our best to scrape up some info that will hopefully help

/var/log/messages-20140308.gz:Mar  7 07:17:42 rps-ppcdb03 mysqld: diagnose the problem, but since we have already crashed,

/var/log/messages-20140308.gz:Mar  7 07:17:42 rps-ppcdb03 mysqld: something is definitely wrong and this may fail.

/var/log/messages-20140308.gz:Mar  7 07:17:42 rps-ppcdb03 mysqld:

/var/log/messages-20140308.gz:Mar  7 07:17:42 rps-ppcdb03 mysqld: Server version: 5.5.35-MariaDB

/var/log/messages-20140308.gz:Mar  7 07:17:42 rps-ppcdb03 mysqld: key_buffer_size=134217728

/var/log/messages-20140308.gz:Mar  7 07:17:42 rps-ppcdb03 mysqld: read_buffer_size=131072

/var/log/messages-20140308.gz:Mar  7 07:17:42 rps-ppcdb03 mysqld: max_used_connections=37

/var/log/messages-20140308.gz:Mar  7 07:17:42 rps-ppcdb03 mysqld: max_threads=1002

/var/log/messages-20140308.gz:Mar  7 07:17:42 rps-ppcdb03 mysqld: thread_count=10

/var/log/messages-20140308.gz:Mar  7 07:17:42 rps-ppcdb03 mysqld: It is possible that mysqld could use up to

/var/log/messages-20140308.gz:Mar  7 07:17:42 rps-ppcdb03 mysqld: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 2329316 K  bytes of memory

/var/log/messages-20140308.gz:Mar  7 07:17:42 rps-ppcdb03 mysqld: Hope that's ok; if not, decrease some variables in the equation.

/var/log/messages-20140308.gz:Mar  7 07:17:42 rps-ppcdb03 mysqld:

/var/log/messages-20140308.gz:Mar  7 07:17:42 rps-ppcdb03 mysqld: Thread pointer: 0x0x7feb21fb2000

/var/log/messages-20140308.gz:Mar  7 07:17:42 rps-ppcdb03 mysqld: Attempting backtrace. You can use the following information to find out

/var/log/messages-20140308.gz:Mar  7 07:17:42 rps-ppcdb03 mysqld: where mysqld died. If you see no messages after this, something went

/var/log/messages-20140308.gz:Mar  7 07:17:42 rps-ppcdb03 mysqld: terribly wrong...

/var/log/messages-20140308.gz:Mar  7 07:17:42 rps-ppcdb03 mysqld: stack_bottom = 0x7feb2116c080 thread_stack 0x48000

/var/log/messages-20140308.gz:Mar  7 07:17:43 rps-ppcdb03 mysqld: /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0xaa4e6e]

/var/log/messages-20140308.gz:Mar  7 07:17:43 rps-ppcdb03 mysqld: /usr/sbin/mysqld(handle_fatal_signal+0x44c)[0x6dc37c]

/var/log/messages-20140308.gz:Mar  7 07:17:43 rps-ppcdb03 mysqld: /lib64/libpthread.so.0[0x7feb25173ca0]

/var/log/messages-20140308.gz:Mar  7 07:17:43 rps-ppcdb03 mysqld: /lib64/libc.so.6(gsignal+0x35)[0x7feb23ac12c5]

/var/log/messages-20140308.gz:Mar  7 07:17:43 rps-ppcdb03 mysqld: /lib64/libc.so.6(abort+0x110)[0x7feb23ac2d70]

/var/log/messages-20140308.gz:Mar  7 07:17:43 rps-ppcdb03 mysqld: /usr/sbin/mysqld[0x96a6d6]

/var/log/messages-20140308.gz:Mar  7 07:17:43 rps-ppcdb03 mysqld: /usr/sbin/mysqld[0x955232]

/var/log/messages-20140308.gz:Mar  7 07:17:43 rps-ppcdb03 mysqld: /usr/sbin/mysqld[0xa0c687]

/var/log/messages-20140308.gz:Mar  7 07:17:43 rps-ppcdb03 mysqld: /usr/sbin/mysqld[0xa10f7e]

/var/log/messages-20140308.gz:Mar  7 07:17:43 rps-ppcdb03 mysqld: /usr/sbin/mysqld[0x901ee8]

/var/log/messages-20140308.gz:Mar  7 07:17:43 rps-ppcdb03 mysqld: /usr/sbin/mysqld[0x8e6176]

/var/log/messages-20140308.gz:Mar  7 07:17:43 rps-ppcdb03 mysqld: /usr/sbin/mysqld(_ZN7handler12ha_write_rowEPh+0xba)[0x6e14ea]

/var/log/messages-20140308.gz:Mar  7 07:17:43 rps-ppcdb03 mysqld: /usr/sbin/mysqld(_Z12write_recordP3THDP5TABLEP12st_copy_info+0x3a6)[0x566dd6]

/var/log/messages-20140308.gz:Mar  7 07:17:43 rps-ppcdb03 mysqld: /usr/sbin/mysqld(_ZN13select_insert9send_dataER4ListI4ItemE+0xbd)[0x5674ed]

/var/log/messages-20140308.gz:Mar  7 07:17:43 rps-ppcdb03 mysqld: /usr/sbin/mysqld[0x5b908a]

/var/log/messages-20140308.gz:Mar  7 07:17:43 rps-ppcdb03 mysqld: /usr/sbin/mysqld[0x5be0f5]

/var/log/messages-20140308.gz:Mar  7 07:17:43 rps-ppcdb03 mysqld: /usr/sbin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x124)[0x5be354]

/var/log/messages-20140308.gz:Mar  7 07:17:43 rps-ppcdb03 mysqld: /usr/sbin/mysqld[0x5be0f5]

/var/log/messages-20140308.gz:Mar  7 07:17:43 rps-ppcdb03 mysqld: /usr/sbin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x169)[0x5be399]

/var/log/messages-20140308.gz:Mar  7 07:17:43 rps-ppcdb03 mysqld: /usr/sbin/mysqld[0x5bea6d]

/var/log/messages-20140308.gz:Mar  7 07:17:43 rps-ppcdb03 mysqld: /usr/sbin/mysqld(_ZN4JOIN4execEv+0xa60)[0x5d2d20]

/var/log/messages-20140308.gz:Mar  7 07:17:43 rps-ppcdb03 mysqld: /usr/sbin/mysqld(_Z12mysql_selectP3THDPPP4ItemP10TABLE_LISTjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x1aa)[0x5d528a]

/var/log/messages-20140308.gz:Mar  7 07:17:43 rps-ppcdb03 mysqld: /usr/sbin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x2a4)[0x5d5e94]

/var/log/messages-20140308.gz:Mar  7 07:17:43 rps-ppcdb03 mysqld: /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x6583)[0x587cb3]

/var/log/messages-20140308.gz:Mar  7 07:17:43 rps-ppcdb03 mysqld: /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x1b1)[0x5888d1]

/var/log/messages-20140308.gz:Mar  7 07:17:43 rps-ppcdb03 mysqld: /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x16fb)[0x589fdb]

/var/log/messages-20140308.gz:Mar  7 07:17:43 rps-ppcdb03 mysqld: /usr/sbin/mysqld(_Z10do_commandP3THD+0xd2)[0x58a592]

/var/log/messages-20140308.gz:Mar  7 07:17:43 rps-ppcdb03 mysqld: /usr/sbin/mysqld(_Z24do_handle_one_connectionP3THD+0x143)[0x644543]

/var/log/messages-20140308.gz:Mar  7 07:17:43 rps-ppcdb03 mysqld: /usr/sbin/mysqld(handle_one_connection+0x4c)[0x64468c]

/var/log/messages-20140308.gz:Mar  7 07:17:43 rps-ppcdb03 mysqld: /lib64/libpthread.so.0[0x7feb2516b83d]

/var/log/messages-20140308.gz:Mar  7 07:17:43 rps-ppcdb03 mysqld: /lib64/libc.so.6(clone+0x6d)[0x7feb23b6603d]

/var/log/messages-20140308.gz:Mar  7 07:17:43 rps-ppcdb03 mysqld:

/var/log/messages-20140308.gz:Mar  7 07:17:43 rps-ppcdb03 mysqld: Trying to get some variables.

/var/log/messages-20140308.gz:Mar  7 07:17:43 rps-ppcdb03 mysqld: Some pointers may be invalid and cause the dump to abort.

/var/log/messages-20140308.gz:Mar  7 07:17:43 rps-ppcdb03 mysqld: Query (0x7fe706891018): is an invalid pointer

/var/log/messages-20140308.gz:Mar  7 07:17:43 rps-ppcdb03 mysqld: Connection ID (thread ID): 9030

/var/log/messages-20140308.gz:Mar  7 07:17:43 rps-ppcdb03 mysqld: Status: NOT_KILLED

/var/log/messages-20140308.gz:Mar  7 07:17:43 rps-ppcdb03 mysqld:

/var/log/messages-20140308.gz:Mar  7 07:17:43 rps-ppcdb03 mysqld: Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=off

/var/log/messages-20140308.gz:Mar  7 07:17:43 rps-ppcdb03 mysqld:

/var/log/messages-20140308.gz:Mar  7 07:17:43 rps-ppcdb03 mysqld: The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains

/var/log/messages-20140308.gz:Mar  7 07:17:43 rps-ppcdb03 mysqld: information that should help you find out what is causing the crash.

/var/log/messages-20140308.gz:Mar  7 07:17:44 rps-ppcdb03 mysqld_safe: Number of processes running now: 0

/var/log/messages-20140308.gz:Mar  7 07:17:44 rps-ppcdb03 mysqld_safe: mysqld restarted

/var/log/messages-20140308.gz:Mar  7 07:17:44 rps-ppcdb03 mysqld: 140307  7:17:44 InnoDB: The InnoDB memory heap is disabled

/var/log/messages-20140308.gz:Mar  7 07:17:44 rps-ppcdb03 mysqld: 140307  7:17:44 InnoDB: Mutexes and rw_locks use GCC atomic builtins

/var/log/messages-20140308.gz:Mar  7 07:17:44 rps-ppcdb03 mysqld: 140307  7:17:44 InnoDB: Compressed tables use zlib 1.2.3

/var/log/messages-20140308.gz:Mar  7 07:17:44 rps-ppcdb03 mysqld: 140307  7:17:44 InnoDB: Using Linux native AIO

/var/log/messages-20140308.gz:Mar  7 07:17:44 rps-ppcdb03 mysqld: 140307  7:17:44 InnoDB: Initializing buffer pool, size = 14.0G

/var/log/messages-20140308.gz:Mar  7 07:17:45 rps-ppcdb03 mysqld: 140307  7:17:45 InnoDB: Completed initialization of buffer pool

/var/log/messages-20140308.gz:Mar  7 07:17:45 rps-ppcdb03 mysqld: 140307  7:17:45 InnoDB: highest supported file format is Barracuda.

/var/log/messages-20140308.gz:Mar  7 07:17:45 rps-ppcdb03 mysqld: InnoDB: Log scan progressed past the checkpoint lsn 3540509391739

/var/log/messages-20140308.gz:Mar  7 07:17:45 rps-ppcdb03 mysqld: 140307  7:17:45  InnoDB: Database was not shut down normally!

/var/log/messages-20140308.gz:Mar  7 07:17:45 rps-ppcdb03 mysqld: InnoDB: Starting crash recovery.

/var/log/messages-20140308.gz:Mar  7 07:17:45 rps-ppcdb03 mysqld: InnoDB: Reading tablespace information from the .ibd files...

/var/log/messages-20140308.gz:Mar  7 07:17:56 rps-ppcdb03 mysqld: InnoDB: Restoring possible half-written data pages from the doublewrite

/var/log/messages-20140308.gz:Mar  7 07:17:56 rps-ppcdb03 mysqld: InnoDB: buffer...

/var/log/messages-20140308.gz:Mar  7 07:17:56 rps-ppcdb03 mysqld: InnoDB: Doing recovery: scanned up to log sequence number 3540509391749

/var/log/messages-20140308.gz:Mar  7 07:17:57 rps-ppcdb03 mysqld: InnoDB: 1 transaction(s) which must be rolled back or cleaned up

/var/log/messages-20140308.gz:Mar  7 07:17:57 rps-ppcdb03 mysqld: InnoDB: in total 7291 row operations to undo

/var/log/messages-20140308.gz:Mar  7 07:17:57 rps-ppcdb03 mysqld: InnoDB: Trx id counter is 2A7B5000

/var/log/messages-20140308.gz:Mar  7 07:17:57 rps-ppcdb03 mysqld: InnoDB: We removed now the InnoDB internal data dictionary entry

/var/log/messages-20140308.gz:Mar  7 07:17:57 rps-ppcdb03 mysqld: InnoDB: of table "tmp"."#sql332_2335_0".

/var/log/messages-20140308.gz:Mar  7 07:17:57 rps-ppcdb03 mysqld: InnoDB: Starting in background the rollback of uncommitted transactions

/var/log/messages-20140308.gz:Mar  7 07:17:57 rps-ppcdb03 mysqld: 140307  7:17:57  InnoDB: Rolling back trx with id 2A7A36EC, 7291 rows to undo

/var/log/messages-20140308.gz:Mar  7 07:17:57 rps-ppcdb03 mysqld:

/var/log/messages-20140308.gz:Mar  7 07:17:57 rps-ppcdb03 mysqld: InnoDB: Progress in percents: 1140307  7:17:57  InnoDB: Waiting for the background threads to start

/var/log/messages-20140308.gz:Mar  7 07:17:57 rps-ppcdb03 mysqld:  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

/var/log/messages-20140308.gz:Mar  7 07:17:57 rps-ppcdb03 mysqld: InnoDB: Rolling back of trx id 2A7A36EC completed

/var/log/messages-20140308.gz:Mar  7 07:17:57 rps-ppcdb03 mysqld: 140307  7:17:57  InnoDB: Rollback of non-prepared transactions completed

/var/log/messages-20140308.gz:Mar  7 07:17:58 rps-ppcdb03 mysqld: 140307  7:17:58 Percona XtraDB (http://www.percona.com) 5.5.35-MariaDB-33.0 started; log sequence number 3540509391749

/var/log/messages-20140308.gz:Mar  7 07:17:58 rps-ppcdb03 mysqld: 140307  7:17:58 [Note] Plugin 'FEEDBACK' is disabled.

/var/log/messages-20140308.gz:Mar  7 07:17:58 rps-ppcdb03 mysqld: 140307  7:17:58 [Note] Server socket created on IP: '::'.

/var/log/messages-20140308.gz:Mar  7 07:17:58 rps-ppcdb03 mysqld: 140307  7:17:58  InnoDB: Error: table `tmp`.`#sql332_2335_0` does not exist in the InnoDB internal

/var/log/messages-20140308.gz:Mar  7 07:17:58 rps-ppcdb03 mysqld: InnoDB: data dictionary though MySQL is trying to drop it.

/var/log/messages-20140308.gz:Mar  7 07:17:58 rps-ppcdb03 mysqld: InnoDB: Have you copied the .frm file of the table to the

/var/log/messages-20140308.gz:Mar  7 07:17:58 rps-ppcdb03 mysqld: InnoDB: MySQL database directory from another database?

/var/log/messages-20140308.gz:Mar  7 07:17:58 rps-ppcdb03 mysqld: InnoDB: You can look for further help from

/var/log/messages-20140308.gz:Mar  7 07:17:58 rps-ppcdb03 mysqld: InnoDB: http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html

/var/log/messages-20140308.gz:Mar  7 07:17:58 rps-ppcdb03 mysqld: 140307  7:17:58 [Note] Event Scheduler: Loaded 0 events

/var/log/messages-20140308.gz:Mar  7 07:17:58 rps-ppcdb03 mysqld: 140307  7:17:58 [Note] /usr/sbin/mysqld: ready for connections.

/var/log/messages-20140308.gz:Mar  7 07:17:58 rps-ppcdb03 mysqld: Version: '5.5.35-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server

/var/log/messages-20140308.gz:Mar  7 16:18:49 rps-ppcdb03 mysqld: 140307 16:18:49 [Note] /usr/sbin/mysqld: Normal shutdown

/var/log/messages-20140308.gz:Mar  7 16:18:49 rps-ppcdb03 mysqld:

/var/log/messages-20140308.gz:Mar  7 16:18:49 rps-ppcdb03 mysqld: 140307 16:18:49 [Note] Event Scheduler: Purging the queue. 0 events

/var/log/messages-20140308.gz:Mar  7 16:18:49 rps-ppcdb03 mysqld: 140307 16:18:49  InnoDB: Starting shutdown...

/var/log/messages-20140308.gz:Mar  7 16:18:49 rps-ppcdb03 mysqld: 140307 16:18:49  InnoDB: Waiting for 5 pages to be flushed

/var/log/messages-20140308.gz:Mar  7 16:18:56 rps-ppcdb03 mysqld: 140307 16:18:56  InnoDB: Shutdown completed; log sequence number 3542850178602

/var/log/messages-20140308.gz:Mar  7 16:18:56 rps-ppcdb03 mysqld: 140307 16:18:56 [Note] /usr/sbin/mysqld: Shutdown complete

/var/log/messages-20140308.gz:Mar  7 16:18:56 rps-ppcdb03 mysqld:

/var/log/messages-20140308.gz:Mar  7 16:18:56 rps-ppcdb03 mysqld_safe: mysqld from pid file /var/lib/mysql/rps-ppcdb03.infinity.local.pid ended

/var/log/messages-20140308.gz:Mar  7 16:18:57 rps-ppcdb03 mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql

/var/log/messages-20140308.gz:Mar  7 16:18:57 rps-ppcdb03 mysqld: 140307 16:18:57 InnoDB: The InnoDB memory heap is disabled

/var/log/messages-20140308.gz:Mar  7 16:18:57 rps-ppcdb03 mysqld: 140307 16:18:57 InnoDB: Mutexes and rw_locks use GCC atomic builtins

/var/log/messages-20140308.gz:Mar  7 16:18:57 rps-ppcdb03 mysqld: 140307 16:18:57 InnoDB: Compressed tables use zlib 1.2.3

/var/log/messages-20140308.gz:Mar  7 16:18:57 rps-ppcdb03 mysqld: 140307 16:18:57 InnoDB: Using Linux native AIO

/var/log/messages-20140308.gz:Mar  7 16:18:57 rps-ppcdb03 mysqld: 140307 16:18:57 InnoDB: Initializing buffer pool, size = 14.0G

/var/log/messages-20140308.gz:Mar  7 16:18:58 rps-ppcdb03 mysqld: 140307 16:18:58 InnoDB: Completed initialization of buffer pool

/var/log/messages-20140308.gz:Mar  7 16:18:58 rps-ppcdb03 mysqld: 140307 16:18:58 InnoDB: highest supported file format is Barracuda.

/var/log/messages-20140308.gz:Mar  7 16:18:59 rps-ppcdb03 mysqld: 140307 16:18:59  InnoDB: Waiting for the background threads to start

/var/log/messages-20140308.gz:Mar  7 16:19:00 rps-ppcdb03 mysqld: 140307 16:19:00 Percona XtraDB (http://www.percona.com) 5.5.36-MariaDB-33.0 started; log sequence number 3542850178602

/var/log/messages-20140308.gz:Mar  7 16:19:00 rps-ppcdb03 mysqld: 140307 16:19:00 [Note] Plugin 'FEEDBACK' is disabled.

/var/log/messages-20140308.gz:Mar  7 16:19:00 rps-ppcdb03 mysqld: 140307 16:19:00 [Note] Server socket created on IP: '::'.

/var/log/messages-20140308.gz:Mar  7 16:19:00 rps-ppcdb03 mysqld: 140307 16:19:00 [Note] Event Scheduler: Loaded 0 events

/var/log/messages-20140308.gz:Mar  7 16:19:00 rps-ppcdb03 mysqld: 140307 16:19:00 [Note] /usr/sbin/mysqld: ready for connections.

/var/log/messages-20140308.gz:Mar  7 16:19:00 rps-ppcdb03 mysqld: Version: '5.5.36-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server

/var/log/messages-20140308.gz:Mar  7 16:21:47 rps-ppcdb03 mysqld: 140307 16:21:47 [Note] /usr/sbin/mysqld: Normal shutdown

/var/log/messages-20140308.gz:Mar  7 16:21:47 rps-ppcdb03 mysqld:

/var/log/messages-20140308.gz:Mar  7 16:21:47 rps-ppcdb03 mysqld: 140307 16:21:47 [Note] Event Scheduler: Purging the queue. 0 events

/var/log/messages-20140308.gz:Mar  7 16:21:47 rps-ppcdb03 mysqld: 140307 16:21:47  InnoDB: Starting shutdown...

/var/log/messages-20140308.gz:Mar  7 16:21:49 rps-ppcdb03 mysqld: 140307 16:21:49  InnoDB: Shutdown completed; log sequence number 3542850178612

/var/log/messages-20140308.gz:Mar  7 16:21:49 rps-ppcdb03 mysqld: 140307 16:21:49 [Note] /usr/sbin/mysqld: Shutdown complete

/var/log/messages-20140308.gz:Mar  7 16:21:49 rps-ppcdb03 mysqld:

/var/log/messages-20140308.gz:Mar  7 16:21:49 rps-ppcdb03 mysqld_safe: mysqld from pid file /var/lib/mysql/rps-ppcdb03.infinity.local.pid ended

/var/log/messages-20140308.gz:Mar  7 16:21:49 rps-ppcdb03 mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql

/var/log/messages-20140308.gz:Mar  7 16:21:49 rps-ppcdb03 mysqld: 140307 16:21:49 InnoDB: The InnoDB memory heap is disabled

/var/log/messages-20140308.gz:Mar  7 16:21:49 rps-ppcdb03 mysqld: 140307 16:21:49 InnoDB: Mutexes and rw_locks use GCC atomic builtins

/var/log/messages-20140308.gz:Mar  7 16:21:49 rps-ppcdb03 mysqld: 140307 16:21:49 InnoDB: Compressed tables use zlib 1.2.3

/var/log/messages-20140308.gz:Mar  7 16:21:49 rps-ppcdb03 mysqld: 140307 16:21:49 InnoDB: Using Linux native AIO

/var/log/messages-20140308.gz:Mar  7 16:21:49 rps-ppcdb03 mysqld: 140307 16:21:49 InnoDB: Initializing buffer pool, size = 14.0G

/var/log/messages-20140308.gz:Mar  7 16:21:50 rps-ppcdb03 mysqld: 140307 16:21:50 InnoDB: Completed initialization of buffer pool

/var/log/messages-20140308.gz:Mar  7 16:21:50 rps-ppcdb03 mysqld: 140307 16:21:50 InnoDB: highest supported file format is Barracuda.

/var/log/messages-20140308.gz:Mar  7 16:21:51 rps-ppcdb03 mysqld: 140307 16:21:51  InnoDB: Waiting for the background threads to start

/var/log/messages-20140308.gz:Mar  7 16:21:52 rps-ppcdb03 mysqld: 140307 16:21:52 Percona XtraDB (http://www.percona.com) 5.5.36-MariaDB-33.0 started; log sequence number 3542850178612

/var/log/messages-20140308.gz:Mar  7 16:21:52 rps-ppcdb03 mysqld: 140307 16:21:52 [Note] Plugin 'FEEDBACK' is disabled.

/var/log/messages-20140308.gz:Mar  7 16:21:52 rps-ppcdb03 mysqld: 140307 16:21:52 [Note] Server socket created on IP: '::'.

/var/log/messages-20140308.gz:Mar  7 16:21:52 rps-ppcdb03 mysqld: 140307 16:21:52 [Note] Event Scheduler: Loaded 0 events

/var/log/messages-20140308.gz:Mar  7 16:21:52 rps-ppcdb03 mysqld: 140307 16:21:52 [Note] /usr/sbin/mysqld: ready for connections.

/var/log/messages-20140308.gz:Mar  7 16:21:52 rps-ppcdb03 mysqld: Version: '5.5.36-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server

Another similar can be found on the attached file

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

log.txt
2014-03-14 19:07
23 kB
Yannis Kontekakis

Issue Links

relates to

MDEV-6002 mariadb 5.5.36 intermittent crashs on windows (after 10-15 minutes)

Closed

Activity

People

Assignee:: Jan Lindström (Inactive)

Reporter:: Yannis Kontekakis

Votes:: 1 Vote for this issue

Watchers:: 5 Start watching this issue

Dates

Created:: 2014-03-14 19:02

Updated:: 2014-07-22 21:10

Resolved:: 2014-07-22 21:10

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.