Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Not a Bug
-
Affects Version/s: 5.5.33a
-
Fix Version/s: None
-
Component/s: None
-
Labels:
Description
Oct 4 14:25:21 tyrebase-galera01-pp mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended Oct 4 14:26:52 tyrebase-galera01-pp mysqld_safe: Starting mysqld daemon with databases from /home/mysql/data Oct 4 14:26:53 tyrebase-galera01-pp mysqld: 131004 14:26:53 [Warning] Using unique option prefix myisam_recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. Oct 4 14:26:53 tyrebase-galera01-pp mysqld: 131004 14:26:53 InnoDB: The InnoDB memory heap is disabled Oct 4 14:26:53 tyrebase-galera01-pp mysqld: 131004 14:26:53 InnoDB: Mutexes and rw_locks use GCC atomic builtins Oct 4 14:26:53 tyrebase-galera01-pp mysqld: 131004 14:26:53 InnoDB: Compressed tables use zlib 1.2.7 Oct 4 14:26:53 tyrebase-galera01-pp mysqld: 131004 14:26:53 InnoDB: Using Linux native AIO Oct 4 14:26:53 tyrebase-galera01-pp mysqld: 131004 14:26:53 InnoDB: Warning: io_setup() failed with EAGAIN. Will make 5 attempts before giving up. Oct 4 14:26:53 tyrebase-galera01-pp mysqld: InnoDB: Warning: io_setup() attempt 1 failed. Oct 4 14:26:53 tyrebase-galera01-pp mysqld: InnoDB: Warning: io_setup() attempt 2 failed. Oct 4 14:26:54 tyrebase-galera01-pp mysqld: InnoDB: Warning: io_setup() attempt 3 failed. Oct 4 14:26:54 tyrebase-galera01-pp mysqld: InnoDB: Warning: io_setup() attempt 4 failed. Oct 4 14:26:55 tyrebase-galera01-pp mysqld: InnoDB: Warning: io_setup() attempt 5 failed. Oct 4 14:26:55 tyrebase-galera01-pp mysqld: 131004 14:26:55 InnoDB: Error: io_setup() failed with EAGAIN after 5 attempts. Oct 4 14:26:55 tyrebase-galera01-pp mysqld: InnoDB: You can disable Linux Native AIO by setting innodb_use_native_aio = 0 in my.cnf Oct 4 14:26:55 tyrebase-galera01-pp mysqld: InnoDB: Warning: Linux Native AIO disabled because os_aio_linux_create_io_ctx() failed. To get rid of this warning you can try increasing system fs.aio-max-nr to 1048576 or larger or setting innodb_use_native_aio = 0 in my.cnf Oct 4 14:26:55 tyrebase-galera01-pp mysqld: 131004 14:26:55 InnoDB: Initializing buffer pool, size = 8.0G Oct 4 14:26:56 tyrebase-galera01-pp mysqld: 131004 14:26:56 InnoDB: Completed initialization of buffer pool Oct 4 14:26:56 tyrebase-galera01-pp mysqld: 131004 14:26:56 InnoDB: highest supported file format is Barracuda. Oct 4 14:26:56 tyrebase-galera01-pp mysqld: 131004 14:26:56 InnoDB: Waiting for the background threads to start Oct 4 14:26:57 tyrebase-galera01-pp mysqld: 131004 14:26:57 Percona XtraDB (http://www.percona.com) 5.5.33a-MariaDB-31.1 started; log sequence number 89826632242 Oct 4 14:26:57 tyrebase-galera01-pp mysqld: 131004 14:26:57 [Note] Plugin 'FEEDBACK' is disabled. Oct 4 14:26:57 tyrebase-galera01-pp mysqld: 131004 14:26:57 [Note] Server socket created on IP: '0.0.0.0'. Oct 4 14:26:57 tyrebase-galera01-pp mysqld: 131004 14:26:57 [Warning] 'user' entry 'root@node-sql-01' ignored in --skip-name-resolve mode. Oct 4 14:26:57 tyrebase-galera01-pp mysqld: 131004 14:26:57 [Warning] 'proxies_priv' entry '@ root@node-sql-01' ignored in --skip-name-resolve mode. Oct 4 14:26:57 tyrebase-galera01-pp mysqld: 131004 14:26:57 [Note] Event Scheduler: Loaded 0 events Oct 4 14:26:57 tyrebase-galera01-pp mysqld: 131004 14:26:57 [Note] /usr/sbin/mysqld: ready for connections. Oct 4 14:26:57 tyrebase-galera01-pp mysqld: Version: '5.5.33a-MariaDB-1~wheezy-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution Oct 4 14:26:58 tyrebase-galera01-pp /etc/mysql/debian-start[23683]: Upgrading MySQL tables if necessary. Oct 4 14:26:58 tyrebase-galera01-pp /etc/mysql/debian-start[23688]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored Oct 4 14:26:58 tyrebase-galera01-pp /etc/mysql/debian-start[23688]: Looking for 'mysql' as: /usr/bin/mysql Oct 4 14:26:58 tyrebase-galera01-pp /etc/mysql/debian-start[23688]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck Oct 4 14:26:58 tyrebase-galera01-pp /etc/mysql/debian-start[23688]: This installation of MySQL is already upgraded to 5.5.33a-MariaDB, use --force if you still need to run mysql_upgrade Oct 4 14:26:58 tyrebase-galera01-pp /etc/mysql/debian-start[23702]: Checking for insecure root accounts. Oct 4 14:26:58 tyrebase-galera01-pp /etc/mysql/debian-start[23707]: WARNING: mysql.user contains 3 root accounts without password! Oct 4 14:26:58 tyrebase-galera01-pp /etc/mysql/debian-start[23708]: Triggering myisam-recover for all MyISAM tables Oct 4 14:36:10 tyrebase-galera01-pp mysqld: /home/buildbot/buildbot/build/mariadb-5.5.33a/storage/tokudb/ft-index/portability/memory.cc:333 toku_xmalloc: Assertion `p' failed (errno=12) Oct 4 14:36:10 tyrebase-galera01-pp mysqld: : Cannot allocate memory Oct 4 14:36:10 tyrebase-galera01-pp mysqld: Backtrace: (Note: toku_do_assert=0x0x7f589f95c300) Oct 4 14:36:10 tyrebase-galera01-pp mysqld: /usr/lib/mysql/plugin/ha_tokudb.so(+0x132138)[0x7f589f95c138] Oct 4 14:36:10 tyrebase-galera01-pp mysqld: /usr/lib/mysql/plugin/ha_tokudb.so(+0x1322f7)[0x7f589f95c2f7] Oct 4 14:36:10 tyrebase-galera01-pp mysqld: /usr/lib/mysql/plugin/ha_tokudb.so(_Z12toku_xmallocm+0x158)[0x7f589f95ad18] Oct 4 14:36:10 tyrebase-galera01-pp mysqld: /usr/lib/mysql/plugin/ha_tokudb.so(_Z23mempool_malloc_from_omtPPN4toku3omtIPvS1_Lb0EEEP7mempoolmPS1_+0x79)[0x7f589f8e92d9] Oct 4 14:36:10 tyrebase-galera01-pp mysqld: /usr/lib/mysql/plugin/ha_tokudb.so(_Z7le_packP3ulePmPP9leafentryPPN4toku3omtIPvS7_Lb0EEEP7mempoolPS7_+0xa5)[0x7f589f930705] Oct 4 14:36:10 tyrebase-galera01-pp mysqld: /usr/lib/mysql/plugin/ha_tokudb.so(_Z23toku_le_garbage_collectP9leafentryPS0_PmPPN4toku3omtIPvS5_Lb0EEEP7mempoolPS5_RKNS4_ImmLb0EEERKNS4_I20referenced_xid_tuplePSF_Lb0EEESE_mPl+0x40f)[0x7f589f9324cf] Oct 4 14:36:10 tyrebase-galera01-pp mysqld: /usr/lib/mysql/plugin/ha_tokudb.so(+0xb7b45)[0x7f589f8e1b45] Oct 4 14:36:10 tyrebase-galera01-pp mysqld: /usr/lib/mysql/plugin/ha_tokudb.so(_Z23toku_bnc_flush_to_childP2ftP24ftnode_nonleaf_childinfoP6ftnodem+0x293)[0x7f589f8f6613] Oct 4 14:36:10 tyrebase-galera01-pp mysqld: /usr/lib/mysql/plugin/ha_tokudb.so(+0xb4c3b)[0x7f589f8dec3b] Oct 4 14:36:10 tyrebase-galera01-pp mysqld: /usr/lib/mysql/plugin/ha_tokudb.so(+0xb50f3)[0x7f589f8df0f3] Oct 4 14:36:10 tyrebase-galera01-pp mysqld: /usr/lib/mysql/plugin/ha_tokudb.so(+0x10cf3c)[0x7f589f936f3c] Oct 4 14:36:10 tyrebase-galera01-pp mysqld: /lib/x86_64-linux-gnu/libpthread.so.0(+0x6b50)[0x7f5c00b87b50] Oct 4 14:36:10 tyrebase-galera01-pp mysqld: /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7f5bff4aba7d] Oct 4 14:36:10 tyrebase-galera01-pp mysqld: Engine status: Oct 4 14:36:10 tyrebase-galera01-pp mysqld: BUILD_ID = 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: Env panic code: 12 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: Env panic string: /home/buildbot/buildbot/build/mariadb-5.5.33a/storage/tokudb/ft-index/portability/memory.cc:333 toku_xmalloc: Assertion `p' failed (errno=12) Oct 4 14:36:10 tyrebase-galera01-pp mysqld: Oct 4 14:36:10 tyrebase-galera01-pp mysqld: time of environment creation: Fri Oct 4 14:26:57 2013 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: time of engine startup: Fri Oct 4 14:26:57 2013 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: time now: Fri Oct 4 14:36:10 2013 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: db opens: 2823 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: db closes: 2787 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: num open dbs now: 35 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: max open dbs: 727 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: period, in ms, that recovery log is automatically fsynced: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: dictionary inserts: 4469546 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: dictionary inserts fail: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: dictionary deletes: 100 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: dictionary deletes fail: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: dictionary updates: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: dictionary updates fail: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: dictionary broadcast updates: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: dictionary broadcast updates fail: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: dictionary multi inserts: 123460683 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: dictionary multi inserts fail: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: dictionary multi deletes: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: dictionary multi deletes fail: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: dictionary updates multi: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: dictionary updates multi fail: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: le: max committed xr: 23 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: le: max provisional xr: 2 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: le: expanded: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: le: max memsize: 32978 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: checkpoint: period: 60 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: checkpoint: footprint: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: checkpoint: last checkpoint began : Fri Oct 4 14:34:55 2013 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: checkpoint: last complete checkpoint began : Fri Oct 4 14:34:55 2013 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: checkpoint: last complete checkpoint ended: Fri Oct 4 14:35:22 2013 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: checkpoint: last complete checkpoint LSN: 29681091 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: checkpoint: checkpoints taken : 8 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: checkpoint: checkpoints failed: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: checkpoint: waiters now: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: checkpoint: waiters max: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: checkpoint: non-checkpoint client wait on mo lock: 4 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: checkpoint: non-checkpoint client wait on cs lock: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: cachetable: miss: 1388 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: cachetable: miss time: 127560 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: cachetable: prefetches: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: cachetable: size current: 9459039314 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: cachetable: size limit: 17442459648 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: cachetable: size writing: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: cachetable: size nonleaf: 526214167 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: cachetable: size leaf: 8927764049 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: cachetable: size rollback: 5061098 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: cachetable: size cachepressure: 525997376 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: cachetable: evictions: 3428 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: cachetable: cleaner executions: 723 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: cachetable: cleaner period: 1 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: cachetable: cleaner iterations: 5 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: locktree: memory size: 5154614 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: locktree: memory size limit: 2113198592 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: locktree: number of times lock escalation ran: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: locktree: time spent running escalation (seconds): 0.000000 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: locktree: latest post-escalation memory size: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: locktree: number of locktrees open now: 38 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: locktree: number of pending lock requests: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: locktree: number of locktrees eligible for the STO: 17 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: locktree: number of times a locktree ended the STO early: 6 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: locktree: time spent ending the STO early (seconds): 0.000043 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: dictionary updates: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: dictionary broadcast updates: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: descriptor set: 1102 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: messages ignored by leaf due to msn: 83 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: total search retries due to TRY_AGAIN: 411 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: searches requiring more tries than the height of the tree: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: searches requiring more tries than the height of the tree plus three: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: leaf nodes flushed to disk (not for checkpoint): 2118 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: leaf nodes flushed to disk (not for checkpoint) (bytes): 426222080 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: leaf nodes flushed to disk (not for checkpoint) (uncompressed bytes): 427877484 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: leaf nodes flushed to disk (not for checkpoint) (seconds): 0.542134 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: nonleaf nodes flushed to disk (not for checkpoint): 276 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: nonleaf nodes flushed to disk (not for checkpoint) (bytes): 145920 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: nonleaf nodes flushed to disk (not for checkpoint) (uncompressed bytes): 85293 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: nonleaf nodes flushed to disk (not for checkpoint) (seconds): 0.059306 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: leaf nodes flushed to disk (for checkpoint): 2508 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: leaf nodes flushed to disk (for checkpoint) (bytes): 8031217664 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: leaf nodes flushed to disk (for checkpoint) (uncompressed bytes): 8030480317 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: leaf nodes flushed to disk (for checkpoint) (seconds): 7.000245 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: nonleaf nodes flushed to disk (for checkpoint): 372 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: nonleaf nodes flushed to disk (for checkpoint) (bytes): 832871936 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: nonleaf nodes flushed to disk (for checkpoint) (uncompressed bytes): 832746722 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: nonleaf nodes flushed to disk (for checkpoint) (seconds): 1.050986 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: nonleaf node partial evictions: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: nonleaf node partial evictions (bytes): 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: leaf node partial evictions: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: leaf node partial evictions (bytes): 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: leaf node full evictions: 3093 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: leaf node full evictions (bytes): 676521846 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: nonleaf node full evictions: 335 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: nonleaf node full evictions (bytes): 1658157 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: leaf nodes created: 3510 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: nonleaf nodes created: 348 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: leaf nodes destroyed: 6018 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: nonleaf nodes destroyed: 707 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: bytes of messages injected at root (all trees): 6336879734 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: bytes of messages flushed from h1 nodes to leaves: 6045807755 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: bytes of messages currently in trees (estimate): 291071979 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: messages injected at root: 114631255 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: broadcast messages injected at root: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: basements decompressed as a target of a query: 20 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: basements decompressed for prelocked range: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: basements decompressed for prefetch: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: basements decompressed for write: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: buffers decompressed as a target of a query: 274 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: buffers decompressed for prelocked range: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: buffers decompressed for prefetch: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: buffers decompressed for write: 4 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: pivots fetched for query: 411 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: pivots fetched for query (bytes): 312320 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: pivots fetched for query (seconds): 0.000544 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: pivots fetched for prefetch: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: pivots fetched for prefetch (bytes): 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: pivots fetched for prefetch (seconds): 0.000000 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: pivots fetched for write: 353 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: pivots fetched for write (bytes): 3464704 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: pivots fetched for write (seconds): 0.002646 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: basements fetched as a target of a query: 411 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: basements fetched as a target of a query (bytes): 411136 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: basements fetched as a target of a query (seconds): 0.000248 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: basements fetched for prelocked range: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: basements fetched for prelocked range (bytes): 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: basements fetched for prelocked range (seconds): 0.000000 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: basements fetched for prefetch: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: basements fetched for prefetch (bytes): 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: basements fetched for prefetch (seconds): 0.000000 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: basements fetched for write: 734 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: basements fetched for write (bytes): 55394816 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: basements fetched for write (seconds): 0.020069 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: buffers fetched as a target of a query: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: buffers fetched as a target of a query (bytes): 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: buffers fetched as a target of a query (seconds): 0.000000 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: buffers fetched for prelocked range: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: buffers fetched for prelocked range (bytes): 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: buffers fetched for prelocked range (seconds): 0.000000 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: buffers fetched for prefetch: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: buffers fetched for prefetch (bytes): 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: buffers fetched for prefetch (seconds): 0.000000 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: buffers fetched for write: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: buffers fetched for write (bytes): 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: buffers fetched for write (seconds): 0.000000 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: leaf compression to memory (seconds): 5.697197 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: leaf serialization to memory (seconds): 10.385861 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: leaf decompression to memory (seconds): 0.028298 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: leaf deserialization to memory (seconds): 0.081111 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: nonleaf compression to memory (seconds): 0.645868 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: nonleaf serialization to memory (seconds): 1.546849 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: nonleaf decompression to memory (seconds): 0.000436 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: nonleaf deserialization to memory (seconds): 0.001538 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: promotion: roots split: 243 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: promotion: leaf roots injected into: 4409369 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: promotion: h1 roots injected into: 31462605 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: promotion: injections at depth 0: 226 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: promotion: injections at depth 1: 87521288 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: promotion: injections at depth 2: 4549674 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: promotion: injections at depth 3: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: promotion: injections lower than depth 3: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: promotion: stopped because of a nonempty buffer: 68241671 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: promotion: stopped at height 1: 3115 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: promotion: stopped because the child was locked or not at all in memory: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: promotion: stopped because the child was not fully in memory: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt: promotion: stopped anyway, after locking the child: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt flusher: total nodes potentially flushed by cleaner thread: 191 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt flusher: height-one nodes flushed by cleaner thread: 191 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt flusher: height-greater-than-one nodes flushed by cleaner thread: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt flusher: nodes cleaned which had empty buffers: 1 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt flusher: nodes dirtied by cleaner thread: 116 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt flusher: max bytes in a buffer flushed by cleaner thread: 4192848 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt flusher: min bytes in a buffer flushed by cleaner thread: 43 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt flusher: total bytes in buffers flushed by cleaner thread: 185455099 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt flusher: max workdone in a buffer flushed by cleaner thread: 1220 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt flusher: min workdone in a buffer flushed by cleaner thread: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt flusher: total workdone in buffers flushed by cleaner thread: 2552 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt flusher: times cleaner thread tries to merge a leaf: 3 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt flusher: cleaner thread leaf merges in progress: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt flusher: cleaner thread leaf merges successful: 3 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt flusher: nodes dirtied by cleaner thread leaf merges: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt flusher: total number of flushes done by flusher threads or cleaner threads: 4639 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt flusher: number of in memory flushes: 4639 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt flusher: number of flushes that read something off disk: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt flusher: number of flushes that triggered another flush in child: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt flusher: number of flushes that triggered 1 cascading flush: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt flusher: number of flushes that triggered 2 cascading flushes: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt flusher: number of flushes that triggered 3 cascading flushes: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt flusher: number of flushes that triggered 4 cascading flushes: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt flusher: number of flushes that triggered 5 cascading flushes: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt flusher: number of flushes that triggered over 5 cascading flushes: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt flusher: leaf node splits: 1682 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt flusher: nonleaf node splits: 105 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt flusher: leaf node merges: 3 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt flusher: nonleaf node merges: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: brt flusher: leaf node balances: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: hot: operations ever started: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: hot: operations successfully completed: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: hot: operations aborted: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: hot: max number of flushes from root ever required to optimize a tree: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: txn: begin: 8485 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: txn: begin read only: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: txn: successful commits: 7966 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: txn: aborts: 515 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: logger: next LSN: 34214640 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: logger: ilock count: 34231026 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: logger: olock count: 38406 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: logger: swap count: 8193 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: logger: writes: 8193 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: logger: writes (bytes): 4062371134 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: logger: writes (uncompressed bytes): 4062371134 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: logger: writes (seconds): 4.703714 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: indexer: number of indexers successfully created: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: indexer: number of calls to toku_indexer_create_indexer() that failed: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: indexer: number of calls to indexer->build() succeeded: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: indexer: number of calls to indexer->build() failed: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: indexer: number of calls to indexer->close() that succeeded: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: indexer: number of calls to indexer->close() that failed: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: indexer: number of calls to indexer->abort(): 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: indexer: number of indexers currently in existence: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: indexer: max number of indexers that ever existed simultaneously: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: loader: number of loaders successfully created: 167 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: loader: number of calls to toku_loader_create_loader() that failed: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: loader: number of calls to loader->put() succeeded: 583759 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: loader: number of calls to loader->put() failed: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: loader: number of calls to loader->close() that succeeded: 166 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: loader: number of calls to loader->close() that failed: 1 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: loader: number of calls to loader->abort(): 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: loader: number of loaders currently in existence: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: loader: max number of loaders that ever existed simultaneously: 2 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: memory: number of malloc operations: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: memory: number of free operations: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: memory: number of realloc operations: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: memory: number of malloc operations that failed: 1 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: memory: number of realloc operations that failed: 572 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: memory: number of bytes requested: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: memory: number of bytes used (requested + overhead): 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: memory: number of bytes freed: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: memory: estimated maximum memory footprint: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: memory: mallocator version: 3.3.1-0-g9ef9d9e8c271cdf14f664b871a8f98c827714784 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: memory: mmap threshold: 4194304 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: filesystem: ENOSPC redzone state: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: filesystem: threads currently blocked by full disk: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: filesystem: number of operations rejected by enospc prevention (red zone): 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: filesystem: most recent disk full: Thu Jan 1 01:00:00 1970 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: filesystem: number of write operations that returned ENOSPC: 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: filesystem: fsync time: 116546683 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: filesystem: fsync count: 16796 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: Oct 4 14:36:10 tyrebase-galera01-pp mysqld: Memory usage: Oct 4 14:36:10 tyrebase-galera01-pp mysqld: Arena 0: Oct 4 14:36:10 tyrebase-galera01-pp mysqld: system bytes = 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: in use bytes = 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: Total (incl. mmap): Oct 4 14:36:10 tyrebase-galera01-pp mysqld: system bytes = 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: in use bytes = 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: max mmap regions = 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: max mmap bytes = 0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: 131004 14:36:10 [ERROR] mysqld got signal 6 ; Oct 4 14:36:10 tyrebase-galera01-pp mysqld: This could be because you hit a bug. It is also possible that this binary Oct 4 14:36:10 tyrebase-galera01-pp mysqld: or one of the libraries it was linked against is corrupt, improperly built, Oct 4 14:36:10 tyrebase-galera01-pp mysqld: or misconfigured. This error can also be caused by malfunctioning hardware. Oct 4 14:36:10 tyrebase-galera01-pp mysqld: Oct 4 14:36:10 tyrebase-galera01-pp mysqld: To report this bug, see http://kb.askmonty.org/en/reporting-bugs Oct 4 14:36:10 tyrebase-galera01-pp mysqld: Oct 4 14:36:10 tyrebase-galera01-pp mysqld: We will try our best to scrape up some info that will hopefully help Oct 4 14:36:10 tyrebase-galera01-pp mysqld: diagnose the problem, but since we have already crashed, Oct 4 14:36:10 tyrebase-galera01-pp mysqld: something is definitely wrong and this may fail. Oct 4 14:36:10 tyrebase-galera01-pp mysqld: Oct 4 14:36:10 tyrebase-galera01-pp mysqld: Server version: 5.5.33a-MariaDB-1~wheezy-log Oct 4 14:36:10 tyrebase-galera01-pp mysqld: key_buffer_size=4294967296 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: read_buffer_size=262144 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: max_used_connections=8 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: max_threads=302 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: thread_count=5 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: It is possible that mysqld could use up to Oct 4 14:36:10 tyrebase-galera01-pp mysqld: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 9224959 K bytes of memory Oct 4 14:36:10 tyrebase-galera01-pp mysqld: Hope that's ok; if not, decrease some variables in the equation. Oct 4 14:36:10 tyrebase-galera01-pp mysqld: Oct 4 14:36:10 tyrebase-galera01-pp mysqld: Thread pointer: 0x0x0 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: Attempting backtrace. You can use the following information to find out Oct 4 14:36:10 tyrebase-galera01-pp mysqld: where mysqld died. If you see no messages after this, something went Oct 4 14:36:10 tyrebase-galera01-pp mysqld: terribly wrong... Oct 4 14:36:10 tyrebase-galera01-pp mysqld: stack_bottom = 0x0 thread_stack 0x48000 Oct 4 14:36:10 tyrebase-galera01-pp mysqld: (my_addr_resolve failure: fork) Oct 4 14:36:10 tyrebase-galera01-pp mysqld: /usr/sbin/mysqld(my_print_stacktrace+0x2b) [0x7f5c0185924b] Oct 4 14:36:10 tyrebase-galera01-pp mysqld: /usr/sbin/mysqld(handle_fatal_signal+0x422) [0x7f5c01494552] Oct 4 14:36:10 tyrebase-galera01-pp mysqld: /lib/x86_64-linux-gnu/libpthread.so.0(+0xf030) [0x7f5c00b90030] Oct 4 14:36:10 tyrebase-galera01-pp mysqld: /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x35) [0x7f5bff403475] Oct 4 14:36:10 tyrebase-galera01-pp mysqld: /lib/x86_64-linux-gnu/libc.so.6(abort+0x180) [0x7f5bff4066f0] Oct 4 14:36:10 tyrebase-galera01-pp mysqld: /usr/lib/mysql/plugin/ha_tokudb.so(+0x13223b) [0x7f589f95c23b] Oct 4 14:36:10 tyrebase-galera01-pp mysqld: /usr/lib/mysql/plugin/ha_tokudb.so(+0x1322f7) [0x7f589f95c2f7] Oct 4 14:36:10 tyrebase-galera01-pp mysqld: /usr/lib/mysql/plugin/ha_tokudb.so(toku_xmalloc(unsigned long)+0x158) [0x7f589f95ad18] Oct 4 14:36:10 tyrebase-galera01-pp mysqld: /usr/lib/mysql/plugin/ha_tokudb.so(mempool_malloc_from_omt(toku::omt<void*, void*, false>**, mempool*, unsigned long, void**)+0x79) [0x7f589f8e92d9] Oct 4 14:36:10 tyrebase-galera01-pp mysqld: /usr/lib/mysql/plugin/ha_tokudb.so(le_pack(ule*, unsigned long*, leafentry**, toku::omt<void*, void*, false>**, mempool*, void**)+0xa5) [0x7f589f930705] Oct 4 14:36:10 tyrebase-galera01-pp mysqld: /usr/lib/mysql/plugin/ha_tokudb.so(toku_le_garbage_collect(leafentry*, leafentry**, unsigned long*, toku::omt<void*, void*, false>**, mempool*, void**, toku::omt<unsigned long, unsigned long, false> const&, toku::omt<referenced_xid_tuple, referenced_xid_tuple*, false> const&, toku::omt<unsigned long, unsigned long, false> const&, unsigned long, long*)+0x40f) [0x7f589f9324cf] Oct 4 14:36:10 tyrebase-galera01-pp mysqld: /usr/lib/mysql/plugin/ha_tokudb.so(+0xb7b45) [0x7f589f8e1b45] Oct 4 14:36:10 tyrebase-galera01-pp mysqld: /usr/lib/mysql/plugin/ha_tokudb.so(toku_bnc_flush_to_child(ft*, ftnode_nonleaf_childinfo*, ftnode*, unsigned long)+0x293) [0x7f589f8f6613] Oct 4 14:36:10 tyrebase-galera01-pp mysqld: /usr/lib/mysql/plugin/ha_tokudb.so(+0xb4c3b) [0x7f589f8dec3b] Oct 4 14:36:10 tyrebase-galera01-pp mysqld: /usr/lib/mysql/plugin/ha_tokudb.so(+0xb50f3) [0x7f589f8df0f3] Oct 4 14:36:10 tyrebase-galera01-pp mysqld: /usr/lib/mysql/plugin/ha_tokudb.so(+0x10cf3c) [0x7f589f936f3c] Oct 4 14:36:10 tyrebase-galera01-pp mysqld: /lib/x86_64-linux-gnu/libpthread.so.0(+0x6b50) [0x7f5c00b87b50] Oct 4 14:36:10 tyrebase-galera01-pp mysqld: /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d) [0x7f5bff4aba7d] Oct 4 14:36:10 tyrebase-galera01-pp mysqld: The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains Oct 4 14:36:10 tyrebase-galera01-pp mysqld: information that should help you find out what is causing the crash. Oct 4 14:36:11 tyrebase-galera01-pp mysqld_safe: Number of processes running now: 0 Oct 4 14:36:11 tyrebase-galera01-pp mysqld_safe: mysqld restarted Oct 4 14:36:11 tyrebase-galera01-pp mysqld: 131004 14:36:11 [Warning] Using unique option prefix myisam_recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. Oct 4 14:36:11 tyrebase-galera01-pp mysqld: 131004 14:36:11 InnoDB: The InnoDB memory heap is disabled Oct 4 14:36:11 tyrebase-galera01-pp mysqld: 131004 14:36:11 InnoDB: Mutexes and rw_locks use GCC atomic builtins Oct 4 14:36:11 tyrebase-galera01-pp mysqld: 131004 14:36:11 InnoDB: Compressed tables use zlib 1.2.7 Oct 4 14:36:11 tyrebase-galera01-pp mysqld: 131004 14:36:11 InnoDB: Using Linux native AIO Oct 4 14:36:11 tyrebase-galera01-pp mysqld: 131004 14:36:11 InnoDB: Warning: io_setup() failed with EAGAIN. Will make 5 attempts before giving up. Oct 4 14:36:11 tyrebase-galera01-pp mysqld: InnoDB: Warning: io_setup() attempt 1 failed. Oct 4 14:36:11 tyrebase-galera01-pp mysqld: InnoDB: Warning: io_setup() attempt 2 failed. Oct 4 14:36:12 tyrebase-galera01-pp mysqld: InnoDB: Warning: io_setup() attempt 3 failed. Oct 4 14:36:12 tyrebase-galera01-pp mysqld: InnoDB: Warning: io_setup() attempt 4 failed. Oct 4 14:36:13 tyrebase-galera01-pp mysqld: InnoDB: Warning: io_setup() attempt 5 failed. Oct 4 14:36:13 tyrebase-galera01-pp mysqld: 131004 14:36:13 InnoDB: Error: io_setup() failed with EAGAIN after 5 attempts. Oct 4 14:36:13 tyrebase-galera01-pp mysqld: InnoDB: You can disable Linux Native AIO by setting innodb_use_native_aio = 0 in my.cnf Oct 4 14:36:13 tyrebase-galera01-pp mysqld: InnoDB: Warning: Linux Native AIO disabled because os_aio_linux_create_io_ctx() failed. To get rid of this warning you can try increasing system fs.aio-max-nr to 1048576 or larger or setting innodb_use_native_aio = 0 in my.cnf Oct 4 14:36:13 tyrebase-galera01-pp mysqld: 131004 14:36:13 InnoDB: Initializing buffer pool, size = 8.0G Oct 4 14:36:14 tyrebase-galera01-pp mysqld: 131004 14:36:14 InnoDB: Completed initialization of buffer pool Oct 4 14:36:14 tyrebase-galera01-pp mysqld: 131004 14:36:14 InnoDB: highest supported file format is Barracuda. Oct 4 14:36:14 tyrebase-galera01-pp mysqld: InnoDB: The log sequence number in ibdata files does not match Oct 4 14:36:14 tyrebase-galera01-pp mysqld: InnoDB: the log sequence number in the ib_logfiles! Oct 4 14:36:14 tyrebase-galera01-pp mysqld: 131004 14:36:14 InnoDB: Database was not shut down normally! Oct 4 14:36:14 tyrebase-galera01-pp mysqld: InnoDB: Starting crash recovery. Oct 4 14:36:14 tyrebase-galera01-pp mysqld: InnoDB: Reading tablespace information from the .ibd files... Oct 4 14:36:14 tyrebase-galera01-pp mysqld: InnoDB: Restoring possible half-written data pages from the doublewrite Oct 4 14:36:14 tyrebase-galera01-pp mysqld: InnoDB: buffer... Oct 4 14:36:15 tyrebase-galera01-pp mysqld: InnoDB: Last MySQL binlog file position 0 89527186, file name /home/mysql/log/mariadb-bin.000292 Oct 4 14:36:15 tyrebase-galera01-pp mysqld: 131004 14:36:15 InnoDB: Waiting for the background threads to start Oct 4 14:36:16 tyrebase-galera01-pp mysqld: 131004 14:36:16 Percona XtraDB (http://www.percona.com) 5.5.33a-MariaDB-31.1 started; log sequence number 89840613172 Oct 4 14:36:16 tyrebase-galera01-pp mysqld: 131004 14:36:16 [Note] Plugin 'FEEDBACK' is disabled. Oct 4 14:36:16 tyrebase-galera01-pp mysqld: Fri Oct 4 14:36:16 2013 Tokudb recovery starting in env /home/mysql/data/ Oct 4 14:36:16 tyrebase-galera01-pp mysqld: Fri Oct 4 14:36:16 2013 Tokudb recovery scanning backward from 34211374 Oct 4 14:36:27 tyrebase-galera01-pp mysqld: Fri Oct 4 14:36:27 2013 Tokudb recovery bw_end_checkpoint at 30973324 timestamp 1380890122509303 xid 29681091 (bw_newer) Oct 4 14:36:31 tyrebase-galera01-pp mysqld: Fri Oct 4 14:36:31 2013 Tokudb recovery scanning backward from 34211374 at 29823374 (bw_between) Oct 4 14:36:31 tyrebase-galera01-pp mysqld: Fri Oct 4 14:36:31 2013 Tokudb recovery bw_begin_checkpoint at 29681091 timestamp 1380890095618809 (bw_between) Oct 4 14:36:31 tyrebase-galera01-pp mysqld: Fri Oct 4 14:36:31 2013 Tokudb recovery turning around at begin checkpoint 29681091 time 26890494 Oct 4 14:36:31 tyrebase-galera01-pp mysqld: Fri Oct 4 14:36:31 2013 Tokudb recovery starts scanning forward to 34211374 from 29681091 left 4530283 (fw_between) Oct 4 14:36:46 tyrebase-galera01-pp mysqld: Fri Oct 4 14:36:46 2013 Tokudb recovery scanning forward to 34211374 at 30084091 left 4127283 (fw_between) Oct 4 14:37:01 tyrebase-galera01-pp mysqld: Fri Oct 4 14:37:01 2013 Tokudb recovery scanning forward to 34211374 at 30500091 left 3711283 (fw_between) Oct 4 14:37:16 tyrebase-galera01-pp mysqld: Fri Oct 4 14:37:16 2013 Tokudb recovery scanning forward to 34211374 at 30875091 left 3336283 (fw_between) Oct 4 14:37:31 tyrebase-galera01-pp mysqld: Fri Oct 4 14:37:31 2013 Tokudb recovery scanning forward to 34211374 at 31244091 left 2967283 (fw_newer) Oct 4 14:37:46 tyrebase-galera01-pp mysqld: Fri Oct 4 14:37:46 2013 Tokudb recovery scanning forward to 34211374 at 31614091 left 2597283 (fw_newer) Oct 4 14:38:01 tyrebase-galera01-pp mysqld: Fri Oct 4 14:38:01 2013 Tokudb recovery scanning forward to 34211374 at 31952091 left 2259283 (fw_newer) Oct 4 14:38:16 tyrebase-galera01-pp mysqld: Fri Oct 4 14:38:16 2013 Tokudb recovery scanning forward to 34211374 at 32327091 left 1884283 (fw_newer) Oct 4 14:38:31 tyrebase-galera01-pp mysqld: Fri Oct 4 14:38:31 2013 Tokudb recovery scanning forward to 34211374 at 32681091 left 1530283 (fw_newer) Oct 4 14:38:46 tyrebase-galera01-pp mysqld: Fri Oct 4 14:38:46 2013 Tokudb recovery scanning forward to 34211374 at 33032091 left 1179283 (fw_newer) Oct 4 14:39:01 tyrebase-galera01-pp mysqld: Fri Oct 4 14:39:01 2013 Tokudb recovery scanning forward to 34211374 at 33404091 left 807283 (fw_newer) Oct 4 14:39:16 tyrebase-galera01-pp mysqld: Fri Oct 4 14:39:16 2013 Tokudb recovery scanning forward to 34211374 at 33754091 left 457283 (fw_newer) Oct 4 14:39:31 tyrebase-galera01-pp mysqld: Fri Oct 4 14:39:31 2013 Tokudb recovery scanning forward to 34211374 at 34083091 left 128283 (fw_newer) Oct 4 14:39:36 tyrebase-galera01-pp mysqld: Fri Oct 4 14:39:36 2013 Tokudb recovery has 4 live transactions Oct 4 14:39:37 tyrebase-galera01-pp mysqld: Fri Oct 4 14:39:37 2013 Tokudb recovery closing 38 dictionaries Oct 4 14:39:48 tyrebase-galera01-pp mysqld: Fri Oct 4 14:39:48 2013 Tokudb recovery making a checkpoint Oct 4 14:39:48 tyrebase-galera01-pp mysqld: Fri Oct 4 14:39:48 2013 Tokudb recovery done Oct 4 14:39:48 tyrebase-galera01-pp mysqld: 131004 14:39:48 [Note] Recovering after a crash using /home/mysql/log/mariadb-bin Oct 4 14:39:48 tyrebase-galera01-pp mysqld: 131004 14:39:48 [Note] Starting crash recovery... Oct 4 14:39:48 tyrebase-galera01-pp mysqld: 131004 14:39:48 [Note] Crash recovery finished. Oct 4 14:39:48 tyrebase-galera01-pp mysqld: 131004 14:39:48 [Note] Server socket created on IP: '0.0.0.0'. Oct 4 14:39:48 tyrebase-galera01-pp mysqld: 131004 14:39:48 [Warning] 'user' entry 'root@node-sql-01' ignored in --skip-name-resolve mode. Oct 4 14:39:48 tyrebase-galera01-pp mysqld: 131004 14:39:48 [Warning] 'proxies_priv' entry '@ root@node-sql-01' ignored in --skip-name-resolve mode. Oct 4 14:39:48 tyrebase-galera01-pp mysqld: 131004 14:39:48 [Note] Event Scheduler: Loaded 0 events Oct 4 14:39:48 tyrebase-galera01-pp mysqld: 131004 14:39:48 [Note] /usr/sbin/mysqld: ready for connections. Oct 4 14:39:48 tyrebase-galera01-pp mysqld: Version: '5.5.33a-MariaDB-1~wheezy-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution
Version Debian
kernel version: Linux node-sql-01 3.2.0-4-amd64 #1 SMP Debian 3.2.46-1+deb7u1 x86_64 GNU/Linux
[mysqld] user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock character_set_server = utf8 #LOMG collation_server = utf8_general_ci #LOMG port = 3306 basedir = /usr datadir = /home/mysql/data #LOMG tmpdir = /home/mysql/tmp #LOMG lc_messages_dir = /usr/share/mysql lc_messages = en_US skip-external-locking skip-name-resolve #LOMG # * Fine Tuning connect_timeout = 10 #LOMG wait_timeout = 28800 #LOMG max_allowed_packet = 16M #168M LOMG thread_cache_size = 128 sort_buffer_size = 16M #SVA bulk_insert_buffer_size = 1G #SVA /!\ can be high on small servers key_cache_block_size = 4096 #SVA # * MyISAM myisam_recover = BACKUP #open-files-limit = 2000 myisam_sort_buffer_size = 1G #SVA /!\ can be high on small servers concurrent_insert = 2 # * Query Cache Configuration # Cache only tiny result sets, so we can fit more in the query cache. query_cache_size = 128M #SVA #query_cache_type = DEMAND #for more write intensive # * Logging and Replication back_log = 128 #SVA #general_log_file = /home/mysql/log/mysql.log #general_log = 1 log_warnings = 2 slow_query_log = 1 slow_query_log_file = /home/mysql/log/mariadb-slow.log long_query_time = 10 #log_slow_rate_limit = 1000 log_slow_verbosity = query_plan #log-queries-not-using-indexes #log_slow_admin_statements server-id = 1 #report_host = master1 #auto_increment_increment = 2 #auto_increment_offset = 1 log_bin = /home/mysql/log/mariadb-bin log_bin_index = /home/mysql/log/mariadb-bin.index #sync_binlog = 1 expire_logs_days = 4 max_binlog_size = 100M # slaves #relay_log = /home/mysql/log/relay-bin #relay_log_index = /home/mysql/log/relay-bin.index #relay_log_info_file = /home/mysql/log/relay-bin.info #log_slave_updates #read_only #sql_mode = NO_ENGINE_SUBSTITUTION,TRADITIONAL # * InnoDB default_storage_engine = InnoDB innodb_log_file_size = 900M #SVA innodb_log_files_in_group = 4 innodb_file_per_table = 1 #SVA innodb_open_files = 4000 innodb_flush_method = O_DIRECT #SVA innodb_thread_concurrency = 128 #SVA innodb_flush_log_at_trx_commit = 2 #SVA innodb_buffer_pool_size = 8G innodb_io_capacity = 20000 innodb_log_buffer_size = 8M innodb_old_blocks_time = 1000 innodb_stats_on_metadata = off innodb_buffer_pool_instances = 4 innodb_max_dirty_pages_pct = 20 innodb_write_io_threads = 64 innodb_file_format=barracuda # * Security Features # chroot = /var/lib/mysql/ # ssl-ca=/etc/mysql/cacert.pem # ssl-cert=/etc/mysql/server-cert.pem # ssl-key=/etc/mysql/server-key.pem bind-address = 0.0.0.0 group_concat_max_len = 1M key_buffer_size = 4G max_connections = 300 max_heap_table_size = 256M max_sp_recursion_depth = 100 query_cache_size = 0 query_cache_limit = 512K read_buffer_size = 256K read_rnd_buffer_size = 512K table_definition_cache = 2000 table_open_cache = 2000 tmp_table_size = 256M # SVA : optimisation sous requetes et hash join grosses requeuquete qui pue #Per-test optimizations optimizer_switch='index_merge=on' optimizer_switch='index_merge_union=on' optimizer_switch='index_merge_sort_union=on' optimizer_switch='index_merge_intersection=on' optimizer_switch='index_merge_sort_intersection=off' optimizer_switch='index_condition_pushdown=on' optimizer_switch='derived_merge=on' optimizer_switch='derived_with_keys=on' optimizer_switch='firstmatch=off' optimizer_switch='loosescan=off' optimizer_switch='materialization=on' optimizer_switch='in_to_exists=on' optimizer_switch='semijoin=on' optimizer_switch='partial_match_rowid_merge=on' optimizer_switch='partial_match_table_scan=on' optimizer_switch='subquery_cache=off' optimizer_switch='mrr=on' optimizer_switch='mrr_cost_based=off' optimizer_switch='mrr_sort_keys=on' optimizer_switch='outer_join_with_cache=on' optimizer_switch='semijoin_with_cache=off' optimizer_switch='join_cache_incremental=on' optimizer_switch='join_cache_hashed=on' optimizer_switch='join_cache_bka=on' optimizer_switch='optimize_join_buffer_size=on' optimizer_switch='table_elimination=on' optimizer_switch='extended_keys=on' join_buffer_space_limit = 3072M join_buffer_size = 1536M join_cache_level = 6 mrr_buffer_size = 96M loose_tokudb_row_format = tokudb_fast loose_plugin-load=ha_tokudb.so
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
could you explain, what exactly one has to do to repeat the bug? my.cnf and the error log don't really help here.