innodb_buffer_pool_size=30G

转载

mob604756f04b77 2015-11-26 07:36:00

文章标签 mysql sql 3d linux html 文章分类 代码人生

Starting program: /usr/local/mysql-5.6.27-linux-glibc2.5-x86_64/bin/mysqld-debug --user=mysql --datadir=/usr/local/mysql/data1
[Thread debugging using libthread_db enabled]
2015-11-26 07:22:19 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-11-26 07:22:19 0 [Note] /usr/local/mysql-5.6.27-linux-glibc2.5-x86_64/bin/mysqld-debug (mysqld 5.6.27-debug) starting as process 3768 ...
2015-11-26 07:22:19 3768 [Note] Plugin 'FEDERATED' is disabled.
2015-11-26 07:22:19 3768 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-11-26 07:22:19 7ffff7d53720 InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!
2015-11-26 07:22:19 7ffff7d53720 InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!!
2015-11-26 07:22:19 3768 [Note] InnoDB: The InnoDB memory heap is disabled
2015-11-26 07:22:19 3768 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-11-26 07:22:19 3768 [Note] InnoDB: Memory barrier is not used
2015-11-26 07:22:19 3768 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-11-26 07:22:19 3768 [Note] InnoDB: Using Linux native AIO
2015-11-26 07:22:19 3768 [Note] InnoDB: Not using CPU crc32 instructions
2015-11-26 07:22:19 3768 [Note] InnoDB: Initializing buffer pool, size = 30.0G
InnoDB: mmap(4199546880 bytes) failed; errno 12
2015-11-26 07:22:19 7ffff7d53720  InnoDB: Assertion failure in thread 140737351333664 in file mem0dbg.cc line 680
InnoDB: Failing assertion: heap->magic_n == MEM_BLOCK_MAGIC_N
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.

Program received signal SIGABRT, Aborted.
0x0000003d9f6328a5 in raise () from /lib64/libc.so.6
Missing separate debuginfos, use: debuginfo-install glibc-2.12-1.80.el6.x86_64 libaio-0.3.107-10.el6.x86_64 libgcc-4.4.6-4.el6.x86_64 libstdc++-4.4.6-4.el6.x86_64 nss-softokn-freebl-3.12.9-11.el6.x86_64
(gdb) bt
#0  0x0000003d9f6328a5 in raise () from /lib64/libc.so.6
#1  0x0000003d9f634085 in abort () from /lib64/libc.so.6
#2  0x0000000000b3d593 in mem_heap_check (heap=0x19a5780)
    at /export/home/pb2/build/sb_0-16513091-1442592600.21/mysql-5.6.27/storage/innobase/mem/mem0dbg.cc:680
#3  0x0000000000c898af in mem_heap_free_func (heap=0x19a5780, 
    file_name=0x1059498 "/export/home/pb2/build/sb_0-16513091-1442592600.21/mysql-5.6.27/storage/innobase/buf/buf0buf.cc", line=1530)
    at /export/home/pb2/build/sb_0-16513091-1442592600.21/mysql-5.6.27/storage/innobase/include/mem0mem.ic:486
#4  0x0000000000c8995f in mem_free_func (ptr=0x19a57f8, 
    file_name=0x1059498 "/export/home/pb2/build/sb_0-16513091-1442592600.21/mysql-5.6.27/storage/innobase/buf/buf0buf.cc", line=1530)
    at /export/home/pb2/build/sb_0-16513091-1442592600.21/mysql-5.6.27/storage/innobase/include/mem0mem.ic:580
#5  0x0000000000c934a8 in buf_pool_free (n_instances=0)
    at /export/home/pb2/build/sb_0-16513091-1442592600.21/mysql-5.6.27/storage/innobase/buf/buf0buf.cc:1530
#6  0x0000000000c93f3b in buf_pool_init (total_size=32212254720, n_instances=8)
    at /export/home/pb2/build/sb_0-16513091-1442592600.21/mysql-5.6.27/storage/innobase/buf/buf0buf.cc:1489
#7  0x0000000000c0fb92 in innobase_start_or_create_for_mysql ()
    at /export/home/pb2/build/sb_0-16513091-1442592600.21/mysql-5.6.27/storage/innobase/srv/srv0start.cc:1969
#8  0x0000000000adc5e6 in innobase_init (p=0x1945300)
    at /export/home/pb2/build/sb_0-16513091-1442592600.21/mysql-5.6.27/storage/innobase/handler/ha_innodb.cc:3279
#9  0x00000000006246bc in ha_initialize_handlerton (plugin=0x1943090)
    at /export/home/pb2/build/sb_0-16513091-1442592600.21/mysql-5.6.27/sql/handler.cc:662
#10 0x00000000007e0341 in plugin_initialize (plugin=0x1943090)
---Type <return> to continue, or q <return> to quit---
    at /export/home/pb2/build/sb_0-16513091-1442592600.21/mysql-5.6.27/sql/sql_plugin.cc:1137
#11 0x00000000007e2e2b in plugin_init (argc=0x17f45d4, argv=0x1846d10, flags=0)
    at /export/home/pb2/build/sb_0-16513091-1442592600.21/mysql-5.6.27/sql/sql_plugin.cc:1431
#12 0x0000000000606dfc in init_server_components ()
    at /export/home/pb2/build/sb_0-16513091-1442592600.21/mysql-5.6.27/sql/mysqld.cc:4850
#13 0x000000000060a1b1 in mysqld_main (argc=5, argv=0x1846d10)
    at /export/home/pb2/build/sb_0-16513091-1442592600.21/mysql-5.6.27/sql/mysqld.cc:5447
#14 0x00000000005fa683 in main (argc=3, argv=0x7fffffffe428)
    at /export/home/pb2/build/sb_0-16513091-1442592600.21/mysql-5.6.27/sql/main.cc:25