Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.1.4
-
None
Description
While working on a totally separate issue, I had this server running as a slave, and it was supposed to crash at some point. So it did, and after that all my attempts to restart it end up with this assertion failure.
I have attached my compressed datadir (mdev8074_elenst_comment.tar.gz, removed binary logs, relay logs etc. as they are unimportant). For me, to reproduce the failure, it's enough to start the server with all default options on this datadir.
Stack trace from 10.1 commit 46816996 |
150428 19:04:19 [Note] InnoDB: from the doublewrite buffer...
|
InnoDB: Doing recovery: scanned up to log sequence number 6547389
|
150428 19:04:19 [Note] InnoDB: Starting an apply batch of log records to the database...
|
InnoDB: Progress in percent: 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
|
InnoDB: Apply batch completed
|
2015-04-28 19:04:21 7f99bf4ad760 InnoDB: Assertion failure in thread 140298316076896 in file sync0sync.cc line 509
|
InnoDB: Failing assertion: mutex->magic_n == MUTEX_MAGIC_N
|
|
#5 0x00007f275bd2f3e0 in *__GI_abort () at abort.c:92
|
#6 0x00007f275eb9b680 in mutex_validate (mutex=0x7f275f99b940) at 10.1/storage/xtradb/sync/sync0sync.cc:509
|
#7 0x00007f275ec9f011 in mutex_enter_func (mutex=0x7f275f99b940, file_name=0x7f275f158eb0 "10.1/storage/xtradb/fil/fil0crypt.cc", line=2342) at 10.1/storage/xtradb/include/sync0sync.ic:257
|
#8 0x00007f275ec9f166 in pfs_mutex_enter_func (mutex=0x7f275f99b940, file_name=0x7f275f158eb0 "10.1/storage/xtradb/fil/fil0crypt.cc", line=2342) at 10.1/storage/xtradb/include/sync0sync.ic:379
|
#9 0x00007f275eca43a8 in fil_space_crypt_mark_space_closing (space=22) at 10.1/storage/xtradb/fil/fil0crypt.cc:2342
|
#10 0x00007f275eb3fcd6 in fil_wait_crypt_bg_threads (table=0x7f275b538178) at 10.1/storage/xtradb/row/row0mysql.cc:3276
|
#11 0x00007f275eb41b9b in row_drop_table_for_mysql (name=0x7f273fbc41b8 "tmp/#sql40c5_4_1", trx=0x7f275b461578, drop_db=false, nonatomic=true) at 10.1/storage/xtradb/row/row0mysql.cc:4113
|
#12 0x00007f275eb42b5e in row_mysql_drop_temp_tables () at 10.1/storage/xtradb/row/row0mysql.cc:4577
|
#13 0x00007f275eab5fcd in recv_recovery_rollback_active () at 10.1/storage/xtradb/log/log0recv.cc:3597
|
#14 0x00007f275eb93a09 in innobase_start_or_create_for_mysql () at 10.1/storage/xtradb/srv/srv0start.cc:2692
|
#15 0x00007f275ea2de0a in innobase_init (p=0x7f275b54f070) at 10.1/storage/xtradb/handler/ha_innodb.cc:4083
|
#16 0x00007f275e88175c in ha_initialize_handlerton (plugin=0x7f275b53c6e8) at 10.1/sql/handler.cc:512
|
#17 0x00007f275e6697c8 in plugin_initialize (tmp_root=0x7ffe91104ee0, plugin=0x7f275b53c6e8, argc=0x7f275f93e990, argv=0x7f275b41e6a0, options_only=false) at 10.1/sql/sql_plugin.cc:1403
|
#18 0x00007f275e66a39a in plugin_init (argc=0x7f275f93e990, argv=0x7f275b41e6a0, flags=2) at 10.1/sql/sql_plugin.cc:1676
|
#19 0x00007f275e58bdd7 in init_server_components () at 10.1/sql/mysqld.cc:5041
|
#20 0x00007f275e58cf18 in mysqld_main (argc=12, argv=0x7f275b41e6a0) at 10.1/sql/mysqld.cc:5631
|
#21 0x00007f275e582af0 in main (argc=12, argv=0x7ffe91105c28) at 10.1/sql/main.cc:25
|
The server was built on Wheezy 64bit as
cmake . -DCMAKE_BUILD_TYPE=Debug -DWITH_EMBEDDED_SERVER=ON && make
|
Here is my cmake configuration:
$ cmake -LA
|
-- Running cmake version 2.8.9
|
-- MariaDB 10.1.5
|
-- Packaging as: mariadb-10.1.5-Linux-x86_64
|
-- suffixes <.so;.a>
|
-- OPENSSL_INCLUDE_DIR = /usr/include
|
-- OPENSSL_LIBRARIES = /usr/lib/x86_64-linux-gnu/libssl.so
|
-- CRYPTO_LIBRARY = /usr/lib/x86_64-linux-gnu/libcrypto.so
|
-- OPENSSL_MAJOR_VERSION = 1
|
-- SSL_LIBRARIES = /usr/lib/x86_64-linux-gnu/libssl.so;/usr/lib/x86_64-linux-gnu/libcrypto.so;dl
|
-- checking for module 'liblz4'
|
-- package 'liblz4' not found
|
-- checking for module 'kytea'
|
-- package 'kytea' not found
|
-- checking for module 'libzmq'
|
-- package 'libzmq' not found
|
-- Configuring OQGraph
|
-- Boost version: 1.49.0
|
-- OQGraph OK
|
-- CONNECT: GCC: Some warnings disabled
|
-- Configuring done
|
-- Generating done
|
-- Build files have been written to: /home/elenst/git/10.1
|
-- Cache values
|
ACLOCAL_EXECUTABLE:FILEPATH=/usr/bin/aclocal
|
AIO_LIBRARY:FILEPATH=/usr/lib/x86_64-linux-gnu/libaio.so
|
AUTOCONF_EXECUTABLE:FILEPATH=/usr/bin/autoconf
|
AUTOHEADER_EXECUTABLE:FILEPATH=/usr/bin/autoheader
|
AUTOMAKE_EXECUTABLE:FILEPATH=/usr/bin/automake
|
BISON_EXECUTABLE:FILEPATH=/usr/bin/bison
|
BUILDNAME:STRING=ft-index Debug Linux-3.2.0-4-amd64 x86_64 GNU c++ 4.7.2
|
BUILD_TESTING:BOOL=OFF
|
BZR_EXECUTABLE:FILEPATH=/usr/bin/bzr
|
Boost_DIR:PATH=Boost_DIR-NOTFOUND
|
Boost_INCLUDE_DIR:PATH=/usr/include
|
Boost_LIBRARY_DIRS:FILEPATH=/usr/lib
|
CAT_EXECUTABLE:FILEPATH=/bin/cat
|
CMAKE_AR:FILEPATH=/usr/bin/ar
|
CMAKE_BUILD_TYPE:STRING=Debug
|
CMAKE_COLOR_MAKEFILE:BOOL=ON
|
CMAKE_CXX_COMPILER:FILEPATH=/usr/bin/c++
|
CMAKE_CXX_FLAGS:STRING=
|
CMAKE_CXX_FLAGS_DEBUG:STRING=-g
|
CMAKE_CXX_FLAGS_MINSIZEREL:STRING=-Os -DNDEBUG
|
CMAKE_CXX_FLAGS_RELEASE:STRING=-O3 -DNDEBUG
|
CMAKE_CXX_FLAGS_RELWITHDEBINFO:STRING=-O2 -g
|
CMAKE_C_COMPILER:FILEPATH=/usr/bin/gcc
|
CMAKE_C_FLAGS:STRING=
|
CMAKE_C_FLAGS_DEBUG:STRING=-g
|
CMAKE_C_FLAGS_MINSIZEREL:STRING=-Os -DNDEBUG
|
CMAKE_C_FLAGS_RELEASE:STRING=-O3 -DNDEBUG
|
CMAKE_C_FLAGS_RELWITHDEBINFO:STRING=-O2 -g
|
CMAKE_EXE_LINKER_FLAGS:STRING=
|
CMAKE_EXE_LINKER_FLAGS_DEBUG:STRING=
|
CMAKE_EXE_LINKER_FLAGS_MINSIZEREL:STRING=
|
CMAKE_EXE_LINKER_FLAGS_RELEASE:STRING=
|
CMAKE_EXE_LINKER_FLAGS_RELWITHDEBINFO:STRING=
|
CMAKE_EXPORT_COMPILE_COMMANDS:BOOL=OFF
|
CMAKE_INSTALL_PREFIX:PATH=/usr/local/mysql
|
CMAKE_LINKER:FILEPATH=/usr/bin/ld
|
CMAKE_MAKE_PROGRAM:FILEPATH=/usr/bin/make
|
CMAKE_MODULE_LINKER_FLAGS:STRING=
|
CMAKE_MODULE_LINKER_FLAGS_DEBUG:STRING=
|
CMAKE_MODULE_LINKER_FLAGS_MINSIZEREL:STRING=
|
CMAKE_MODULE_LINKER_FLAGS_RELEASE:STRING=
|
CMAKE_MODULE_LINKER_FLAGS_RELWITHDEBINFO:STRING=
|
CMAKE_NM:FILEPATH=/usr/bin/nm
|
CMAKE_OBJCOPY:FILEPATH=/usr/bin/objcopy
|
CMAKE_OBJDUMP:FILEPATH=/usr/bin/objdump
|
CMAKE_RANLIB:FILEPATH=/usr/bin/ranlib
|
CMAKE_SHARED_LINKER_FLAGS:STRING=
|
CMAKE_SHARED_LINKER_FLAGS_DEBUG:STRING=
|
CMAKE_SHARED_LINKER_FLAGS_MINSIZEREL:STRING=
|
CMAKE_SHARED_LINKER_FLAGS_RELEASE:STRING=
|
CMAKE_SHARED_LINKER_FLAGS_RELWITHDEBINFO:STRING=
|
CMAKE_SKIP_INSTALL_RPATH:BOOL=NO
|
CMAKE_SKIP_RPATH:BOOL=NO
|
CMAKE_STRIP:FILEPATH=/usr/bin/strip
|
CMAKE_TOKUDB_REVISION:STRING=0
|
CMAKE_USE_RELATIVE_PATHS:BOOL=OFF
|
CMAKE_VERBOSE_MAKEFILE:BOOL=FALSE
|
COMMUNITY_BUILD:BOOL=ON
|
CONNECT_WITH_LIBXML2:BOOL=ON
|
CONNECT_WITH_MYSQL:BOOL=ON
|
CONNECT_WITH_ODBC:BOOL=ON
|
CONNECT_WITH_XMAP:BOOL=ON
|
CRYPTO_LIBRARY:FILEPATH=/usr/lib/x86_64-linux-gnu/libcrypto.so
|
CURSES_CURSES_H_PATH:PATH=/usr/include
|
CURSES_CURSES_LIBRARY:FILEPATH=/usr/lib/x86_64-linux-gnu/libcurses.so
|
CURSES_EXTRA_LIBRARY:FILEPATH=CURSES_EXTRA_LIBRARY-NOTFOUND
|
CURSES_FORM_LIBRARY:FILEPATH=/usr/lib/x86_64-linux-gnu/libform.so
|
CURSES_HAVE_CURSES_H:FILEPATH=/usr/include/curses.h
|
CURSES_INCLUDE_PATH:FILEPATH=/usr/include
|
CURSES_LIBRARY:FILEPATH=/usr/lib/x86_64-linux-gnu/libcurses.so
|
CURSES_NCURSES_LIBRARY:FILEPATH=/usr/lib/x86_64-linux-gnu/libncurses.so
|
CYBOZU:BOOL=OFF
|
DISABLE_SHARED:BOOL=OFF
|
DTRACE:FILEPATH=DTRACE-NOTFOUND
|
ENABLED_LOCAL_INFILE:BOOL=OFF
|
ENABLED_PROFILING:BOOL=ON
|
ENABLE_DEBUG_SYNC:BOOL=ON
|
ENABLE_GCOV:BOOL=OFF
|
EVENT_LIBRARY:FILEPATH=/usr/lib/x86_64-linux-gnu/libevent.so
|
FORM_LIBRARY:FILEPATH=/usr/lib/x86_64-linux-gnu/libform.so
|
GETCONF:FILEPATH=/usr/bin/getconf
|
GIT_EXECUTABLE:FILEPATH=/usr/bin/git
|
GLIBTOOLIZE_EXECUTABLE:FILEPATH=GLIBTOOLIZE_EXECUTABLE-NOTFOUND
|
GRN_DEFAULT_DB_KEY:STRING=auto
|
GRN_DEFAULT_DOCUMENT_ROOT:PATH=/usr/local/mysql/share/groonga/html/admin
|
GRN_DEFAULT_DOCUMENT_ROOT_BASE:PATH=html/admin
|
GRN_DEFAULT_ENCODING:STRING=utf8
|
GRN_DEFAULT_MATCH_ESCALATION_THRESHOLD:STRING=0
|
GRN_DEFAULT_RELATIVE_DOCUMENT_ROOT:PATH=share/groonga/html/admin
|
GRN_EMBED:BOOL=ON
|
GRN_LOCK_TIMEOUT:STRING=10000000
|
GRN_LOCK_WAIT_TIME_NANOSECOND:STRING=1000000
|
GRN_LOG_PATH:FILEPATH=/usr/local/mysql/var/log/groonga/groonga.log
|
GRN_MECAB_CONFIG:FILEPATH=mecab-config
|
GRN_MECAB_CONFIG_ABSOLUTE_PATH:FILEPATH=GRN_MECAB_CONFIG_ABSOLUTE_PATH-NOTFOUND
|
GRN_STACK_SIZE:STRING=1024
|
GRN_WITH_DEBUG:BOOL=OFF
|
GRN_WITH_KYTEA:STRING=auto
|
GRN_WITH_LIBEVENT:STRING=auto
|
GRN_WITH_LIBSTEMMER:STRING=auto
|
GRN_WITH_LZ4:STRING=auto
|
GRN_WITH_LZO:BOOL=OFF
|
GRN_WITH_MECAB:STRING=auto
|
GRN_WITH_MESSAGE_PACK:STRING=auto
|
GRN_WITH_MRUBY:BOOL=OFF
|
GRN_WITH_NFKC:BOOL=ON
|
GRN_WITH_ZEROMQ:STRING=auto
|
GRN_WITH_ZLIB:BOOL=OFF
|
GROFF:FILEPATH=/usr/bin/groff
|
GROONGA_NORMALIZER_MYSQL_EMBED:BOOL=ON
|
GTAR_EXECUTABLE:FILEPATH=GTAR_EXECUTABLE-NOTFOUND
|
INSTALL_BINDIR:STRING=bin
|
INSTALL_DOCDIR:STRING=docs
|
INSTALL_DOCREADMEDIR:STRING=.
|
INSTALL_INCLUDEDIR:STRING=include/mysql
|
INSTALL_INFODIR:STRING=docs
|
INSTALL_LAYOUT:STRING=STANDALONE
|
INSTALL_LIBDIR:STRING=lib
|
INSTALL_MANDIR:STRING=man
|
INSTALL_MYSQLDATADIR:STRING=data
|
INSTALL_MYSQLSHAREDIR:STRING=share
|
INSTALL_MYSQLTESTDIR:STRING=mysql-test
|
INSTALL_PLUGINDIR:STRING=lib/plugin
|
INSTALL_SBINDIR:STRING=bin
|
INSTALL_SCRIPTDIR:STRING=scripts
|
INSTALL_SHAREDIR:STRING=share
|
INSTALL_SQLBENCHDIR:STRING=.
|
INSTALL_SUPPORTFILESDIR:STRING=support-files
|
INSTALL_SYSCONF2DIR:STRING=
|
INSTALL_SYSCONFDIR:STRING=
|
INSTALL_UNIX_ADDRDIR:STRING=/tmp/mysql.sock
|
Judy_INCLUDE_DIR:PATH=/usr/include
|
Judy_LIBRARIES:FILEPATH=/usr/lib/libJudy.so
|
LIBTOKUDB:STRING=tokufractaltree
|
LIBTOKUPORTABILITY:STRING=tokuportability
|
LIBTOOLIZE_EXECUTABLE:FILEPATH=/usr/bin/libtoolize
|
LIBXML2_INCLUDE_DIR:PATH=/usr/include/libxml2
|
LIBXML2_LIBRARIES:FILEPATH=/usr/lib/x86_64-linux-gnu/libxml2.so
|
LIBXML2_XMLLINT_EXECUTABLE:FILEPATH=LIBXML2_XMLLINT_EXECUTABLE-NOTFOUND
|
MANUFACTURER:STRING=Built from Source
|
MRN_DEFAULT_PARSER:STRING=TokenBigram
|
MRN_GROONGA_EMBED:BOOL=ON
|
MRN_GROONGA_NORMALIZER_MYSQL_EMBED:BOOL=ON
|
MYSQL_DATADIR:PATH=/usr/local/mysql/data
|
MYSQL_MAINTAINER_MODE:STRING=AUTO
|
MYSQL_PROJECT_NAME:STRING=MySQL
|
NOT_FOR_DISTRIBUTION:BOOL=OFF
|
NO_ALARM:BOOL=1
|
NROFF:FILEPATH=/usr/bin/nroff
|
ODBC_INCLUDE_DIR:PATH=/usr/include
|
ODBC_LIBRARY:FILEPATH=/usr/lib/x86_64-linux-gnu/libodbc.so
|
OPENSSL_INCLUDE_DIR:PATH=/usr/include
|
OPENSSL_LIBRARIES:FILEPATH=/usr/lib/x86_64-linux-gnu/libssl.so
|
OPENSSL_ROOT_DIR:PATH=/usr
|
PCREGREP_BUFSIZE:STRING=20480
|
PCRE_BUILD_PCREGREP:BOOL=ON
|
PCRE_BUILD_TESTS:BOOL=ON
|
PCRE_LINK_SIZE:STRING=2
|
PCRE_MATCH_LIMIT:STRING=10000000
|
PCRE_MATCH_LIMIT_RECURSION:STRING=MATCH_LIMIT
|
PCRE_NEWLINE:STRING=LF
|
PCRE_NO_RECURSE:BOOL=ON
|
PCRE_PARENS_NEST_LIMIT:STRING=250
|
PCRE_POSIX_MALLOC_THRESHOLD:STRING=10
|
PCRE_SHOW_REPORT:BOOL=OFF
|
PCRE_SUPPORT_BSR_ANYCRLF:BOOL=OFF
|
PCRE_SUPPORT_UNICODE_PROPERTIES:BOOL=ON
|
PKG_CONFIG_EXECUTABLE:FILEPATH=/usr/bin/pkg-config
|
PLUGIN_ARCHIVE:STRING=DYNAMIC
|
PLUGIN_ARIA:STRING=STATIC
|
PLUGIN_AUDIT_NULL:STRING=DYNAMIC
|
PLUGIN_AUTH_0X0100:STRING=DYNAMIC
|
PLUGIN_AUTH_PAM:STRING=DYNAMIC
|
PLUGIN_AUTH_SOCKET:STRING=DYNAMIC
|
PLUGIN_AUTH_TEST_PLUGIN:STRING=DYNAMIC
|
PLUGIN_BLACKHOLE:STRING=DYNAMIC
|
PLUGIN_CASSANDRA:STRING=DYNAMIC
|
PLUGIN_CONNECT:STRING=DYNAMIC
|
PLUGIN_CRACKLIB_PASSWORD_CHECK:STRING=DYNAMIC
|
PLUGIN_DAEMON_EXAMPLE:STRING=DYNAMIC
|
PLUGIN_DEBUG_KEY_MANAGEMENT:STRING=DYNAMIC
|
PLUGIN_DIALOG:STRING=DYNAMIC
|
PLUGIN_DIALOG_EXAMPLES:STRING=DYNAMIC
|
PLUGIN_EXAMPLE:STRING=DYNAMIC
|
PLUGIN_EXAMPLE_KEY_MANAGEMENT:STRING=DYNAMIC
|
PLUGIN_EXAMPLE_KEY_MANAGEMENT_PLUGIN:STRING=DYNAMIC
|
PLUGIN_FEDERATED:STRING=DYNAMIC
|
PLUGIN_FEDERATEDX:STRING=DYNAMIC
|
PLUGIN_FEEDBACK:STRING=STATIC
|
PLUGIN_FILE_KEY_MANAGEMENT:STRING=DYNAMIC
|
PLUGIN_FILE_KEY_MANAGEMENT_PLUGIN:STRING=DYNAMIC
|
PLUGIN_FTEXAMPLE:STRING=DYNAMIC
|
PLUGIN_HANDLERSOCKET:STRING=DYNAMIC
|
PLUGIN_INNOBASE:STRING=DYNAMIC
|
PLUGIN_LOCALES:STRING=DYNAMIC
|
PLUGIN_METADATA_LOCK_INFO:STRING=DYNAMIC
|
PLUGIN_MROONGA:STRING=DYNAMIC
|
PLUGIN_MYSQL_CLEAR_PASSWORD:STRING=DYNAMIC
|
PLUGIN_OQGRAPH:STRING=DYNAMIC
|
PLUGIN_PARTITION:STRING=STATIC
|
PLUGIN_PERFSCHEMA:STRING=STATIC
|
PLUGIN_QA_AUTH_CLIENT:STRING=DYNAMIC
|
PLUGIN_QA_AUTH_INTERFACE:STRING=DYNAMIC
|
PLUGIN_QA_AUTH_SERVER:STRING=DYNAMIC
|
PLUGIN_QUERY_CACHE_INFO:STRING=DYNAMIC
|
PLUGIN_QUERY_RESPONSE_TIME:STRING=DYNAMIC
|
PLUGIN_SEMISYNC_MASTER:STRING=DYNAMIC
|
PLUGIN_SEMISYNC_SLAVE:STRING=DYNAMIC
|
PLUGIN_SEQUENCE:STRING=STATIC
|
PLUGIN_SERVER_AUDIT:STRING=DYNAMIC
|
PLUGIN_SIMPLE_PASSWORD_CHECK:STRING=DYNAMIC
|
PLUGIN_SPHINX:STRING=DYNAMIC
|
PLUGIN_SPIDER:STRING=DYNAMIC
|
PLUGIN_SQL_ERRLOG:STRING=DYNAMIC
|
PLUGIN_TEST_SQL_DISCOVERY:STRING=DYNAMIC
|
PLUGIN_TOKUDB:STRING=DYNAMIC
|
PLUGIN_WSREP_INFO:STRING=DYNAMIC
|
PLUGIN_XTRADB:STRING=STATIC
|
READLINE_INCLUDE_DIR:PATH=/usr/include/readline
|
READLINE_LIBRARY:FILEPATH=/usr/lib/x86_64-linux-gnu/libreadline.so
|
SECURITY_HARDENED:BOOL=ON
|
TAR_EXECUTABLE:FILEPATH=/bin/tar
|
TMPDIR:PATH=
|
TOKUDB_DATA:FILEPATH=/home/elenst/git/10.1/storage/tokudb/ft-index/../tokudb.data
|
TOKU_DEBUG_PARANOID:BOOL=OFF
|
Thrift_INCLUDE_DIRS:PATH=Thrift_INCLUDE_DIRS-NOTFOUND
|
Thrift_LIBS:FILEPATH=Thrift_LIBS-NOTFOUND
|
USE_ARIA_FOR_TMP_TABLES:BOOL=ON
|
USE_BDB:BOOL=OFF
|
USE_GCOV:BOOL=OFF
|
USE_VALGRIND:BOOL=OFF
|
WITHOUT_SERVER:BOOL=OFF
|
WITH_ASAN:BOOL=OFF
|
WITH_ATOMIC_OPS:STRING=
|
WITH_EMBEDDED_SERVER:BOOL=ON
|
WITH_EXTRA_CHARSETS:STRING=all
|
WITH_FAST_MUTEXES:BOOL=OFF
|
WITH_INNODB_BZIP2:STRING=AUTO
|
WITH_INNODB_DISALLOW_WRITES:BOOL=ON
|
WITH_INNODB_LZ4:STRING=AUTO
|
WITH_INNODB_LZMA:STRING=AUTO
|
WITH_INNODB_LZO:STRING=AUTO
|
WITH_INNODB_SNAPPY:STRING=AUTO
|
WITH_JEMALLOC:STRING=auto
|
WITH_LIBWRAP:BOOL=OFF
|
WITH_MYSQLD_LDFLAGS:STRING=
|
WITH_PCRE:STRING=auto
|
WITH_PIC:BOOL=ON
|
WITH_READLINE:BOOL=OFF
|
WITH_SAFEMALLOC:STRING=AUTO
|
WITH_UNIT_TESTS:BOOL=ON
|
WITH_VALGRIND:BOOL=OFF
|
WITH_WSREP:BOOL=ON
|
WITH_ZLIB:STRING=system
|
XZ_SOURCE_DIR:FILEPATH=/home/elenst/git/10.1/storage/tokudb/ft-index/third_party/xz-4.999.9beta
|
ZLIB_INCLUDE_DIR:PATH=/usr/include
|
ZLIB_LIBRARY:FILEPATH=/usr/lib/x86_64-linux-gnu/libz.so
|
Attachments
Activity
Field | Original Value | New Value |
---|---|---|
Attachment | mdev8074_elenst_comment.tar.gz [ 37902 ] |
Description |
While working on a totally separate issue, I had this server running as a slave, and it was supposed to crash at some point. So it did, and after that all my attempts to restart it end up with this assertion failure. I have attached my compressed datadir (mdev8054_elenst_comment.tar.gz, removed binary logs, relay logs etc. as they are unimportant). For me, to reproduce the failure, it's enough to start the server with all default options on this datadir. {noformat:title=Stack trace from 10.1 commit 46816996} 150428 19:04:19 [Note] InnoDB: from the doublewrite buffer... InnoDB: Doing recovery: scanned up to log sequence number 6547389 150428 19:04:19 [Note] InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percent: 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 InnoDB: Apply batch completed 2015-04-28 19:04:21 7f99bf4ad760 InnoDB: Assertion failure in thread 140298316076896 in file sync0sync.cc line 509 InnoDB: Failing assertion: mutex->magic_n == MUTEX_MAGIC_N #5 0x00007f275bd2f3e0 in *__GI_abort () at abort.c:92 #6 0x00007f275eb9b680 in mutex_validate (mutex=0x7f275f99b940) at 10.1/storage/xtradb/sync/sync0sync.cc:509 #7 0x00007f275ec9f011 in mutex_enter_func (mutex=0x7f275f99b940, file_name=0x7f275f158eb0 "10.1/storage/xtradb/fil/fil0crypt.cc", line=2342) at 10.1/storage/xtradb/include/sync0sync.ic:257 #8 0x00007f275ec9f166 in pfs_mutex_enter_func (mutex=0x7f275f99b940, file_name=0x7f275f158eb0 "10.1/storage/xtradb/fil/fil0crypt.cc", line=2342) at 10.1/storage/xtradb/include/sync0sync.ic:379 #9 0x00007f275eca43a8 in fil_space_crypt_mark_space_closing (space=22) at 10.1/storage/xtradb/fil/fil0crypt.cc:2342 #10 0x00007f275eb3fcd6 in fil_wait_crypt_bg_threads (table=0x7f275b538178) at 10.1/storage/xtradb/row/row0mysql.cc:3276 #11 0x00007f275eb41b9b in row_drop_table_for_mysql (name=0x7f273fbc41b8 "tmp/#sql40c5_4_1", trx=0x7f275b461578, drop_db=false, nonatomic=true) at 10.1/storage/xtradb/row/row0mysql.cc:4113 #12 0x00007f275eb42b5e in row_mysql_drop_temp_tables () at 10.1/storage/xtradb/row/row0mysql.cc:4577 #13 0x00007f275eab5fcd in recv_recovery_rollback_active () at 10.1/storage/xtradb/log/log0recv.cc:3597 #14 0x00007f275eb93a09 in innobase_start_or_create_for_mysql () at 10.1/storage/xtradb/srv/srv0start.cc:2692 #15 0x00007f275ea2de0a in innobase_init (p=0x7f275b54f070) at 10.1/storage/xtradb/handler/ha_innodb.cc:4083 #16 0x00007f275e88175c in ha_initialize_handlerton (plugin=0x7f275b53c6e8) at 10.1/sql/handler.cc:512 #17 0x00007f275e6697c8 in plugin_initialize (tmp_root=0x7ffe91104ee0, plugin=0x7f275b53c6e8, argc=0x7f275f93e990, argv=0x7f275b41e6a0, options_only=false) at 10.1/sql/sql_plugin.cc:1403 #18 0x00007f275e66a39a in plugin_init (argc=0x7f275f93e990, argv=0x7f275b41e6a0, flags=2) at 10.1/sql/sql_plugin.cc:1676 #19 0x00007f275e58bdd7 in init_server_components () at 10.1/sql/mysqld.cc:5041 #20 0x00007f275e58cf18 in mysqld_main (argc=12, argv=0x7f275b41e6a0) at 10.1/sql/mysqld.cc:5631 #21 0x00007f275e582af0 in main (argc=12, argv=0x7ffe91105c28) at 10.1/sql/main.cc:25 {noformat} The server was built on Wheezy 64bit as {noformat} cmake . -DCMAKE_BUILD_TYPE=Debug -DWITH_EMBEDDED_SERVER=ON && make {noformat} Here is my cmake configuration: {noformat} $ cmake -LA -- Running cmake version 2.8.9 -- MariaDB 10.1.5 -- Packaging as: mariadb-10.1.5-Linux-x86_64 -- suffixes <.so;.a> -- OPENSSL_INCLUDE_DIR = /usr/include -- OPENSSL_LIBRARIES = /usr/lib/x86_64-linux-gnu/libssl.so -- CRYPTO_LIBRARY = /usr/lib/x86_64-linux-gnu/libcrypto.so -- OPENSSL_MAJOR_VERSION = 1 -- SSL_LIBRARIES = /usr/lib/x86_64-linux-gnu/libssl.so;/usr/lib/x86_64-linux-gnu/libcrypto.so;dl -- checking for module 'liblz4' -- package 'liblz4' not found -- checking for module 'kytea' -- package 'kytea' not found -- checking for module 'libzmq' -- package 'libzmq' not found -- Configuring OQGraph -- Boost version: 1.49.0 -- OQGraph OK -- CONNECT: GCC: Some warnings disabled -- Configuring done -- Generating done -- Build files have been written to: /home/elenst/git/10.1 -- Cache values ACLOCAL_EXECUTABLE:FILEPATH=/usr/bin/aclocal AIO_LIBRARY:FILEPATH=/usr/lib/x86_64-linux-gnu/libaio.so AUTOCONF_EXECUTABLE:FILEPATH=/usr/bin/autoconf AUTOHEADER_EXECUTABLE:FILEPATH=/usr/bin/autoheader AUTOMAKE_EXECUTABLE:FILEPATH=/usr/bin/automake BISON_EXECUTABLE:FILEPATH=/usr/bin/bison BUILDNAME:STRING=ft-index Debug Linux-3.2.0-4-amd64 x86_64 GNU c++ 4.7.2 BUILD_TESTING:BOOL=OFF BZR_EXECUTABLE:FILEPATH=/usr/bin/bzr Boost_DIR:PATH=Boost_DIR-NOTFOUND Boost_INCLUDE_DIR:PATH=/usr/include Boost_LIBRARY_DIRS:FILEPATH=/usr/lib CAT_EXECUTABLE:FILEPATH=/bin/cat CMAKE_AR:FILEPATH=/usr/bin/ar CMAKE_BUILD_TYPE:STRING=Debug CMAKE_COLOR_MAKEFILE:BOOL=ON CMAKE_CXX_COMPILER:FILEPATH=/usr/bin/c++ CMAKE_CXX_FLAGS:STRING= CMAKE_CXX_FLAGS_DEBUG:STRING=-g CMAKE_CXX_FLAGS_MINSIZEREL:STRING=-Os -DNDEBUG CMAKE_CXX_FLAGS_RELEASE:STRING=-O3 -DNDEBUG CMAKE_CXX_FLAGS_RELWITHDEBINFO:STRING=-O2 -g CMAKE_C_COMPILER:FILEPATH=/usr/bin/gcc CMAKE_C_FLAGS:STRING= CMAKE_C_FLAGS_DEBUG:STRING=-g CMAKE_C_FLAGS_MINSIZEREL:STRING=-Os -DNDEBUG CMAKE_C_FLAGS_RELEASE:STRING=-O3 -DNDEBUG CMAKE_C_FLAGS_RELWITHDEBINFO:STRING=-O2 -g CMAKE_EXE_LINKER_FLAGS:STRING= CMAKE_EXE_LINKER_FLAGS_DEBUG:STRING= CMAKE_EXE_LINKER_FLAGS_MINSIZEREL:STRING= CMAKE_EXE_LINKER_FLAGS_RELEASE:STRING= CMAKE_EXE_LINKER_FLAGS_RELWITHDEBINFO:STRING= CMAKE_EXPORT_COMPILE_COMMANDS:BOOL=OFF CMAKE_INSTALL_PREFIX:PATH=/usr/local/mysql CMAKE_LINKER:FILEPATH=/usr/bin/ld CMAKE_MAKE_PROGRAM:FILEPATH=/usr/bin/make CMAKE_MODULE_LINKER_FLAGS:STRING= CMAKE_MODULE_LINKER_FLAGS_DEBUG:STRING= CMAKE_MODULE_LINKER_FLAGS_MINSIZEREL:STRING= CMAKE_MODULE_LINKER_FLAGS_RELEASE:STRING= CMAKE_MODULE_LINKER_FLAGS_RELWITHDEBINFO:STRING= CMAKE_NM:FILEPATH=/usr/bin/nm CMAKE_OBJCOPY:FILEPATH=/usr/bin/objcopy CMAKE_OBJDUMP:FILEPATH=/usr/bin/objdump CMAKE_RANLIB:FILEPATH=/usr/bin/ranlib CMAKE_SHARED_LINKER_FLAGS:STRING= CMAKE_SHARED_LINKER_FLAGS_DEBUG:STRING= CMAKE_SHARED_LINKER_FLAGS_MINSIZEREL:STRING= CMAKE_SHARED_LINKER_FLAGS_RELEASE:STRING= CMAKE_SHARED_LINKER_FLAGS_RELWITHDEBINFO:STRING= CMAKE_SKIP_INSTALL_RPATH:BOOL=NO CMAKE_SKIP_RPATH:BOOL=NO CMAKE_STRIP:FILEPATH=/usr/bin/strip CMAKE_TOKUDB_REVISION:STRING=0 CMAKE_USE_RELATIVE_PATHS:BOOL=OFF CMAKE_VERBOSE_MAKEFILE:BOOL=FALSE COMMUNITY_BUILD:BOOL=ON CONNECT_WITH_LIBXML2:BOOL=ON CONNECT_WITH_MYSQL:BOOL=ON CONNECT_WITH_ODBC:BOOL=ON CONNECT_WITH_XMAP:BOOL=ON CRYPTO_LIBRARY:FILEPATH=/usr/lib/x86_64-linux-gnu/libcrypto.so CURSES_CURSES_H_PATH:PATH=/usr/include CURSES_CURSES_LIBRARY:FILEPATH=/usr/lib/x86_64-linux-gnu/libcurses.so CURSES_EXTRA_LIBRARY:FILEPATH=CURSES_EXTRA_LIBRARY-NOTFOUND CURSES_FORM_LIBRARY:FILEPATH=/usr/lib/x86_64-linux-gnu/libform.so CURSES_HAVE_CURSES_H:FILEPATH=/usr/include/curses.h CURSES_INCLUDE_PATH:FILEPATH=/usr/include CURSES_LIBRARY:FILEPATH=/usr/lib/x86_64-linux-gnu/libcurses.so CURSES_NCURSES_LIBRARY:FILEPATH=/usr/lib/x86_64-linux-gnu/libncurses.so CYBOZU:BOOL=OFF DISABLE_SHARED:BOOL=OFF DTRACE:FILEPATH=DTRACE-NOTFOUND ENABLED_LOCAL_INFILE:BOOL=OFF ENABLED_PROFILING:BOOL=ON ENABLE_DEBUG_SYNC:BOOL=ON ENABLE_GCOV:BOOL=OFF EVENT_LIBRARY:FILEPATH=/usr/lib/x86_64-linux-gnu/libevent.so FORM_LIBRARY:FILEPATH=/usr/lib/x86_64-linux-gnu/libform.so GETCONF:FILEPATH=/usr/bin/getconf GIT_EXECUTABLE:FILEPATH=/usr/bin/git GLIBTOOLIZE_EXECUTABLE:FILEPATH=GLIBTOOLIZE_EXECUTABLE-NOTFOUND GRN_DEFAULT_DB_KEY:STRING=auto GRN_DEFAULT_DOCUMENT_ROOT:PATH=/usr/local/mysql/share/groonga/html/admin GRN_DEFAULT_DOCUMENT_ROOT_BASE:PATH=html/admin GRN_DEFAULT_ENCODING:STRING=utf8 GRN_DEFAULT_MATCH_ESCALATION_THRESHOLD:STRING=0 GRN_DEFAULT_RELATIVE_DOCUMENT_ROOT:PATH=share/groonga/html/admin GRN_EMBED:BOOL=ON GRN_LOCK_TIMEOUT:STRING=10000000 GRN_LOCK_WAIT_TIME_NANOSECOND:STRING=1000000 GRN_LOG_PATH:FILEPATH=/usr/local/mysql/var/log/groonga/groonga.log GRN_MECAB_CONFIG:FILEPATH=mecab-config GRN_MECAB_CONFIG_ABSOLUTE_PATH:FILEPATH=GRN_MECAB_CONFIG_ABSOLUTE_PATH-NOTFOUND GRN_STACK_SIZE:STRING=1024 GRN_WITH_DEBUG:BOOL=OFF GRN_WITH_KYTEA:STRING=auto GRN_WITH_LIBEVENT:STRING=auto GRN_WITH_LIBSTEMMER:STRING=auto GRN_WITH_LZ4:STRING=auto GRN_WITH_LZO:BOOL=OFF GRN_WITH_MECAB:STRING=auto GRN_WITH_MESSAGE_PACK:STRING=auto GRN_WITH_MRUBY:BOOL=OFF GRN_WITH_NFKC:BOOL=ON GRN_WITH_ZEROMQ:STRING=auto GRN_WITH_ZLIB:BOOL=OFF GROFF:FILEPATH=/usr/bin/groff GROONGA_NORMALIZER_MYSQL_EMBED:BOOL=ON GTAR_EXECUTABLE:FILEPATH=GTAR_EXECUTABLE-NOTFOUND INSTALL_BINDIR:STRING=bin INSTALL_DOCDIR:STRING=docs INSTALL_DOCREADMEDIR:STRING=. INSTALL_INCLUDEDIR:STRING=include/mysql INSTALL_INFODIR:STRING=docs INSTALL_LAYOUT:STRING=STANDALONE INSTALL_LIBDIR:STRING=lib INSTALL_MANDIR:STRING=man INSTALL_MYSQLDATADIR:STRING=data INSTALL_MYSQLSHAREDIR:STRING=share INSTALL_MYSQLTESTDIR:STRING=mysql-test INSTALL_PLUGINDIR:STRING=lib/plugin INSTALL_SBINDIR:STRING=bin INSTALL_SCRIPTDIR:STRING=scripts INSTALL_SHAREDIR:STRING=share INSTALL_SQLBENCHDIR:STRING=. INSTALL_SUPPORTFILESDIR:STRING=support-files INSTALL_SYSCONF2DIR:STRING= INSTALL_SYSCONFDIR:STRING= INSTALL_UNIX_ADDRDIR:STRING=/tmp/mysql.sock Judy_INCLUDE_DIR:PATH=/usr/include Judy_LIBRARIES:FILEPATH=/usr/lib/libJudy.so LIBTOKUDB:STRING=tokufractaltree LIBTOKUPORTABILITY:STRING=tokuportability LIBTOOLIZE_EXECUTABLE:FILEPATH=/usr/bin/libtoolize LIBXML2_INCLUDE_DIR:PATH=/usr/include/libxml2 LIBXML2_LIBRARIES:FILEPATH=/usr/lib/x86_64-linux-gnu/libxml2.so LIBXML2_XMLLINT_EXECUTABLE:FILEPATH=LIBXML2_XMLLINT_EXECUTABLE-NOTFOUND MANUFACTURER:STRING=Built from Source MRN_DEFAULT_PARSER:STRING=TokenBigram MRN_GROONGA_EMBED:BOOL=ON MRN_GROONGA_NORMALIZER_MYSQL_EMBED:BOOL=ON MYSQL_DATADIR:PATH=/usr/local/mysql/data MYSQL_MAINTAINER_MODE:STRING=AUTO MYSQL_PROJECT_NAME:STRING=MySQL NOT_FOR_DISTRIBUTION:BOOL=OFF NO_ALARM:BOOL=1 NROFF:FILEPATH=/usr/bin/nroff ODBC_INCLUDE_DIR:PATH=/usr/include ODBC_LIBRARY:FILEPATH=/usr/lib/x86_64-linux-gnu/libodbc.so OPENSSL_INCLUDE_DIR:PATH=/usr/include OPENSSL_LIBRARIES:FILEPATH=/usr/lib/x86_64-linux-gnu/libssl.so OPENSSL_ROOT_DIR:PATH=/usr PCREGREP_BUFSIZE:STRING=20480 PCRE_BUILD_PCREGREP:BOOL=ON PCRE_BUILD_TESTS:BOOL=ON PCRE_LINK_SIZE:STRING=2 PCRE_MATCH_LIMIT:STRING=10000000 PCRE_MATCH_LIMIT_RECURSION:STRING=MATCH_LIMIT PCRE_NEWLINE:STRING=LF PCRE_NO_RECURSE:BOOL=ON PCRE_PARENS_NEST_LIMIT:STRING=250 PCRE_POSIX_MALLOC_THRESHOLD:STRING=10 PCRE_SHOW_REPORT:BOOL=OFF PCRE_SUPPORT_BSR_ANYCRLF:BOOL=OFF PCRE_SUPPORT_UNICODE_PROPERTIES:BOOL=ON PKG_CONFIG_EXECUTABLE:FILEPATH=/usr/bin/pkg-config PLUGIN_ARCHIVE:STRING=DYNAMIC PLUGIN_ARIA:STRING=STATIC PLUGIN_AUDIT_NULL:STRING=DYNAMIC PLUGIN_AUTH_0X0100:STRING=DYNAMIC PLUGIN_AUTH_PAM:STRING=DYNAMIC PLUGIN_AUTH_SOCKET:STRING=DYNAMIC PLUGIN_AUTH_TEST_PLUGIN:STRING=DYNAMIC PLUGIN_BLACKHOLE:STRING=DYNAMIC PLUGIN_CASSANDRA:STRING=DYNAMIC PLUGIN_CONNECT:STRING=DYNAMIC PLUGIN_CRACKLIB_PASSWORD_CHECK:STRING=DYNAMIC PLUGIN_DAEMON_EXAMPLE:STRING=DYNAMIC PLUGIN_DEBUG_KEY_MANAGEMENT:STRING=DYNAMIC PLUGIN_DIALOG:STRING=DYNAMIC PLUGIN_DIALOG_EXAMPLES:STRING=DYNAMIC PLUGIN_EXAMPLE:STRING=DYNAMIC PLUGIN_EXAMPLE_KEY_MANAGEMENT:STRING=DYNAMIC PLUGIN_EXAMPLE_KEY_MANAGEMENT_PLUGIN:STRING=DYNAMIC PLUGIN_FEDERATED:STRING=DYNAMIC PLUGIN_FEDERATEDX:STRING=DYNAMIC PLUGIN_FEEDBACK:STRING=STATIC PLUGIN_FILE_KEY_MANAGEMENT:STRING=DYNAMIC PLUGIN_FILE_KEY_MANAGEMENT_PLUGIN:STRING=DYNAMIC PLUGIN_FTEXAMPLE:STRING=DYNAMIC PLUGIN_HANDLERSOCKET:STRING=DYNAMIC PLUGIN_INNOBASE:STRING=DYNAMIC PLUGIN_LOCALES:STRING=DYNAMIC PLUGIN_METADATA_LOCK_INFO:STRING=DYNAMIC PLUGIN_MROONGA:STRING=DYNAMIC PLUGIN_MYSQL_CLEAR_PASSWORD:STRING=DYNAMIC PLUGIN_OQGRAPH:STRING=DYNAMIC PLUGIN_PARTITION:STRING=STATIC PLUGIN_PERFSCHEMA:STRING=STATIC PLUGIN_QA_AUTH_CLIENT:STRING=DYNAMIC PLUGIN_QA_AUTH_INTERFACE:STRING=DYNAMIC PLUGIN_QA_AUTH_SERVER:STRING=DYNAMIC PLUGIN_QUERY_CACHE_INFO:STRING=DYNAMIC PLUGIN_QUERY_RESPONSE_TIME:STRING=DYNAMIC PLUGIN_SEMISYNC_MASTER:STRING=DYNAMIC PLUGIN_SEMISYNC_SLAVE:STRING=DYNAMIC PLUGIN_SEQUENCE:STRING=STATIC PLUGIN_SERVER_AUDIT:STRING=DYNAMIC PLUGIN_SIMPLE_PASSWORD_CHECK:STRING=DYNAMIC PLUGIN_SPHINX:STRING=DYNAMIC PLUGIN_SPIDER:STRING=DYNAMIC PLUGIN_SQL_ERRLOG:STRING=DYNAMIC PLUGIN_TEST_SQL_DISCOVERY:STRING=DYNAMIC PLUGIN_TOKUDB:STRING=DYNAMIC PLUGIN_WSREP_INFO:STRING=DYNAMIC PLUGIN_XTRADB:STRING=STATIC READLINE_INCLUDE_DIR:PATH=/usr/include/readline READLINE_LIBRARY:FILEPATH=/usr/lib/x86_64-linux-gnu/libreadline.so SECURITY_HARDENED:BOOL=ON TAR_EXECUTABLE:FILEPATH=/bin/tar TMPDIR:PATH= TOKUDB_DATA:FILEPATH=/home/elenst/git/10.1/storage/tokudb/ft-index/../tokudb.data TOKU_DEBUG_PARANOID:BOOL=OFF Thrift_INCLUDE_DIRS:PATH=Thrift_INCLUDE_DIRS-NOTFOUND Thrift_LIBS:FILEPATH=Thrift_LIBS-NOTFOUND USE_ARIA_FOR_TMP_TABLES:BOOL=ON USE_BDB:BOOL=OFF USE_GCOV:BOOL=OFF USE_VALGRIND:BOOL=OFF WITHOUT_SERVER:BOOL=OFF WITH_ASAN:BOOL=OFF WITH_ATOMIC_OPS:STRING= WITH_EMBEDDED_SERVER:BOOL=ON WITH_EXTRA_CHARSETS:STRING=all WITH_FAST_MUTEXES:BOOL=OFF WITH_INNODB_BZIP2:STRING=AUTO WITH_INNODB_DISALLOW_WRITES:BOOL=ON WITH_INNODB_LZ4:STRING=AUTO WITH_INNODB_LZMA:STRING=AUTO WITH_INNODB_LZO:STRING=AUTO WITH_INNODB_SNAPPY:STRING=AUTO WITH_JEMALLOC:STRING=auto WITH_LIBWRAP:BOOL=OFF WITH_MYSQLD_LDFLAGS:STRING= WITH_PCRE:STRING=auto WITH_PIC:BOOL=ON WITH_READLINE:BOOL=OFF WITH_SAFEMALLOC:STRING=AUTO WITH_UNIT_TESTS:BOOL=ON WITH_VALGRIND:BOOL=OFF WITH_WSREP:BOOL=ON WITH_ZLIB:STRING=system XZ_SOURCE_DIR:FILEPATH=/home/elenst/git/10.1/storage/tokudb/ft-index/third_party/xz-4.999.9beta ZLIB_INCLUDE_DIR:PATH=/usr/include ZLIB_LIBRARY:FILEPATH=/usr/lib/x86_64-linux-gnu/libz.so {noformat} |
While working on a totally separate issue, I had this server running as a slave, and it was supposed to crash at some point. So it did, and after that all my attempts to restart it end up with this assertion failure. I have attached my compressed datadir (mdev8074_elenst_comment.tar.gz, removed binary logs, relay logs etc. as they are unimportant). For me, to reproduce the failure, it's enough to start the server with all default options on this datadir. {noformat:title=Stack trace from 10.1 commit 46816996} 150428 19:04:19 [Note] InnoDB: from the doublewrite buffer... InnoDB: Doing recovery: scanned up to log sequence number 6547389 150428 19:04:19 [Note] InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percent: 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 InnoDB: Apply batch completed 2015-04-28 19:04:21 7f99bf4ad760 InnoDB: Assertion failure in thread 140298316076896 in file sync0sync.cc line 509 InnoDB: Failing assertion: mutex->magic_n == MUTEX_MAGIC_N #5 0x00007f275bd2f3e0 in *__GI_abort () at abort.c:92 #6 0x00007f275eb9b680 in mutex_validate (mutex=0x7f275f99b940) at 10.1/storage/xtradb/sync/sync0sync.cc:509 #7 0x00007f275ec9f011 in mutex_enter_func (mutex=0x7f275f99b940, file_name=0x7f275f158eb0 "10.1/storage/xtradb/fil/fil0crypt.cc", line=2342) at 10.1/storage/xtradb/include/sync0sync.ic:257 #8 0x00007f275ec9f166 in pfs_mutex_enter_func (mutex=0x7f275f99b940, file_name=0x7f275f158eb0 "10.1/storage/xtradb/fil/fil0crypt.cc", line=2342) at 10.1/storage/xtradb/include/sync0sync.ic:379 #9 0x00007f275eca43a8 in fil_space_crypt_mark_space_closing (space=22) at 10.1/storage/xtradb/fil/fil0crypt.cc:2342 #10 0x00007f275eb3fcd6 in fil_wait_crypt_bg_threads (table=0x7f275b538178) at 10.1/storage/xtradb/row/row0mysql.cc:3276 #11 0x00007f275eb41b9b in row_drop_table_for_mysql (name=0x7f273fbc41b8 "tmp/#sql40c5_4_1", trx=0x7f275b461578, drop_db=false, nonatomic=true) at 10.1/storage/xtradb/row/row0mysql.cc:4113 #12 0x00007f275eb42b5e in row_mysql_drop_temp_tables () at 10.1/storage/xtradb/row/row0mysql.cc:4577 #13 0x00007f275eab5fcd in recv_recovery_rollback_active () at 10.1/storage/xtradb/log/log0recv.cc:3597 #14 0x00007f275eb93a09 in innobase_start_or_create_for_mysql () at 10.1/storage/xtradb/srv/srv0start.cc:2692 #15 0x00007f275ea2de0a in innobase_init (p=0x7f275b54f070) at 10.1/storage/xtradb/handler/ha_innodb.cc:4083 #16 0x00007f275e88175c in ha_initialize_handlerton (plugin=0x7f275b53c6e8) at 10.1/sql/handler.cc:512 #17 0x00007f275e6697c8 in plugin_initialize (tmp_root=0x7ffe91104ee0, plugin=0x7f275b53c6e8, argc=0x7f275f93e990, argv=0x7f275b41e6a0, options_only=false) at 10.1/sql/sql_plugin.cc:1403 #18 0x00007f275e66a39a in plugin_init (argc=0x7f275f93e990, argv=0x7f275b41e6a0, flags=2) at 10.1/sql/sql_plugin.cc:1676 #19 0x00007f275e58bdd7 in init_server_components () at 10.1/sql/mysqld.cc:5041 #20 0x00007f275e58cf18 in mysqld_main (argc=12, argv=0x7f275b41e6a0) at 10.1/sql/mysqld.cc:5631 #21 0x00007f275e582af0 in main (argc=12, argv=0x7ffe91105c28) at 10.1/sql/main.cc:25 {noformat} The server was built on Wheezy 64bit as {noformat} cmake . -DCMAKE_BUILD_TYPE=Debug -DWITH_EMBEDDED_SERVER=ON && make {noformat} Here is my cmake configuration: {noformat} $ cmake -LA -- Running cmake version 2.8.9 -- MariaDB 10.1.5 -- Packaging as: mariadb-10.1.5-Linux-x86_64 -- suffixes <.so;.a> -- OPENSSL_INCLUDE_DIR = /usr/include -- OPENSSL_LIBRARIES = /usr/lib/x86_64-linux-gnu/libssl.so -- CRYPTO_LIBRARY = /usr/lib/x86_64-linux-gnu/libcrypto.so -- OPENSSL_MAJOR_VERSION = 1 -- SSL_LIBRARIES = /usr/lib/x86_64-linux-gnu/libssl.so;/usr/lib/x86_64-linux-gnu/libcrypto.so;dl -- checking for module 'liblz4' -- package 'liblz4' not found -- checking for module 'kytea' -- package 'kytea' not found -- checking for module 'libzmq' -- package 'libzmq' not found -- Configuring OQGraph -- Boost version: 1.49.0 -- OQGraph OK -- CONNECT: GCC: Some warnings disabled -- Configuring done -- Generating done -- Build files have been written to: /home/elenst/git/10.1 -- Cache values ACLOCAL_EXECUTABLE:FILEPATH=/usr/bin/aclocal AIO_LIBRARY:FILEPATH=/usr/lib/x86_64-linux-gnu/libaio.so AUTOCONF_EXECUTABLE:FILEPATH=/usr/bin/autoconf AUTOHEADER_EXECUTABLE:FILEPATH=/usr/bin/autoheader AUTOMAKE_EXECUTABLE:FILEPATH=/usr/bin/automake BISON_EXECUTABLE:FILEPATH=/usr/bin/bison BUILDNAME:STRING=ft-index Debug Linux-3.2.0-4-amd64 x86_64 GNU c++ 4.7.2 BUILD_TESTING:BOOL=OFF BZR_EXECUTABLE:FILEPATH=/usr/bin/bzr Boost_DIR:PATH=Boost_DIR-NOTFOUND Boost_INCLUDE_DIR:PATH=/usr/include Boost_LIBRARY_DIRS:FILEPATH=/usr/lib CAT_EXECUTABLE:FILEPATH=/bin/cat CMAKE_AR:FILEPATH=/usr/bin/ar CMAKE_BUILD_TYPE:STRING=Debug CMAKE_COLOR_MAKEFILE:BOOL=ON CMAKE_CXX_COMPILER:FILEPATH=/usr/bin/c++ CMAKE_CXX_FLAGS:STRING= CMAKE_CXX_FLAGS_DEBUG:STRING=-g CMAKE_CXX_FLAGS_MINSIZEREL:STRING=-Os -DNDEBUG CMAKE_CXX_FLAGS_RELEASE:STRING=-O3 -DNDEBUG CMAKE_CXX_FLAGS_RELWITHDEBINFO:STRING=-O2 -g CMAKE_C_COMPILER:FILEPATH=/usr/bin/gcc CMAKE_C_FLAGS:STRING= CMAKE_C_FLAGS_DEBUG:STRING=-g CMAKE_C_FLAGS_MINSIZEREL:STRING=-Os -DNDEBUG CMAKE_C_FLAGS_RELEASE:STRING=-O3 -DNDEBUG CMAKE_C_FLAGS_RELWITHDEBINFO:STRING=-O2 -g CMAKE_EXE_LINKER_FLAGS:STRING= CMAKE_EXE_LINKER_FLAGS_DEBUG:STRING= CMAKE_EXE_LINKER_FLAGS_MINSIZEREL:STRING= CMAKE_EXE_LINKER_FLAGS_RELEASE:STRING= CMAKE_EXE_LINKER_FLAGS_RELWITHDEBINFO:STRING= CMAKE_EXPORT_COMPILE_COMMANDS:BOOL=OFF CMAKE_INSTALL_PREFIX:PATH=/usr/local/mysql CMAKE_LINKER:FILEPATH=/usr/bin/ld CMAKE_MAKE_PROGRAM:FILEPATH=/usr/bin/make CMAKE_MODULE_LINKER_FLAGS:STRING= CMAKE_MODULE_LINKER_FLAGS_DEBUG:STRING= CMAKE_MODULE_LINKER_FLAGS_MINSIZEREL:STRING= CMAKE_MODULE_LINKER_FLAGS_RELEASE:STRING= CMAKE_MODULE_LINKER_FLAGS_RELWITHDEBINFO:STRING= CMAKE_NM:FILEPATH=/usr/bin/nm CMAKE_OBJCOPY:FILEPATH=/usr/bin/objcopy CMAKE_OBJDUMP:FILEPATH=/usr/bin/objdump CMAKE_RANLIB:FILEPATH=/usr/bin/ranlib CMAKE_SHARED_LINKER_FLAGS:STRING= CMAKE_SHARED_LINKER_FLAGS_DEBUG:STRING= CMAKE_SHARED_LINKER_FLAGS_MINSIZEREL:STRING= CMAKE_SHARED_LINKER_FLAGS_RELEASE:STRING= CMAKE_SHARED_LINKER_FLAGS_RELWITHDEBINFO:STRING= CMAKE_SKIP_INSTALL_RPATH:BOOL=NO CMAKE_SKIP_RPATH:BOOL=NO CMAKE_STRIP:FILEPATH=/usr/bin/strip CMAKE_TOKUDB_REVISION:STRING=0 CMAKE_USE_RELATIVE_PATHS:BOOL=OFF CMAKE_VERBOSE_MAKEFILE:BOOL=FALSE COMMUNITY_BUILD:BOOL=ON CONNECT_WITH_LIBXML2:BOOL=ON CONNECT_WITH_MYSQL:BOOL=ON CONNECT_WITH_ODBC:BOOL=ON CONNECT_WITH_XMAP:BOOL=ON CRYPTO_LIBRARY:FILEPATH=/usr/lib/x86_64-linux-gnu/libcrypto.so CURSES_CURSES_H_PATH:PATH=/usr/include CURSES_CURSES_LIBRARY:FILEPATH=/usr/lib/x86_64-linux-gnu/libcurses.so CURSES_EXTRA_LIBRARY:FILEPATH=CURSES_EXTRA_LIBRARY-NOTFOUND CURSES_FORM_LIBRARY:FILEPATH=/usr/lib/x86_64-linux-gnu/libform.so CURSES_HAVE_CURSES_H:FILEPATH=/usr/include/curses.h CURSES_INCLUDE_PATH:FILEPATH=/usr/include CURSES_LIBRARY:FILEPATH=/usr/lib/x86_64-linux-gnu/libcurses.so CURSES_NCURSES_LIBRARY:FILEPATH=/usr/lib/x86_64-linux-gnu/libncurses.so CYBOZU:BOOL=OFF DISABLE_SHARED:BOOL=OFF DTRACE:FILEPATH=DTRACE-NOTFOUND ENABLED_LOCAL_INFILE:BOOL=OFF ENABLED_PROFILING:BOOL=ON ENABLE_DEBUG_SYNC:BOOL=ON ENABLE_GCOV:BOOL=OFF EVENT_LIBRARY:FILEPATH=/usr/lib/x86_64-linux-gnu/libevent.so FORM_LIBRARY:FILEPATH=/usr/lib/x86_64-linux-gnu/libform.so GETCONF:FILEPATH=/usr/bin/getconf GIT_EXECUTABLE:FILEPATH=/usr/bin/git GLIBTOOLIZE_EXECUTABLE:FILEPATH=GLIBTOOLIZE_EXECUTABLE-NOTFOUND GRN_DEFAULT_DB_KEY:STRING=auto GRN_DEFAULT_DOCUMENT_ROOT:PATH=/usr/local/mysql/share/groonga/html/admin GRN_DEFAULT_DOCUMENT_ROOT_BASE:PATH=html/admin GRN_DEFAULT_ENCODING:STRING=utf8 GRN_DEFAULT_MATCH_ESCALATION_THRESHOLD:STRING=0 GRN_DEFAULT_RELATIVE_DOCUMENT_ROOT:PATH=share/groonga/html/admin GRN_EMBED:BOOL=ON GRN_LOCK_TIMEOUT:STRING=10000000 GRN_LOCK_WAIT_TIME_NANOSECOND:STRING=1000000 GRN_LOG_PATH:FILEPATH=/usr/local/mysql/var/log/groonga/groonga.log GRN_MECAB_CONFIG:FILEPATH=mecab-config GRN_MECAB_CONFIG_ABSOLUTE_PATH:FILEPATH=GRN_MECAB_CONFIG_ABSOLUTE_PATH-NOTFOUND GRN_STACK_SIZE:STRING=1024 GRN_WITH_DEBUG:BOOL=OFF GRN_WITH_KYTEA:STRING=auto GRN_WITH_LIBEVENT:STRING=auto GRN_WITH_LIBSTEMMER:STRING=auto GRN_WITH_LZ4:STRING=auto GRN_WITH_LZO:BOOL=OFF GRN_WITH_MECAB:STRING=auto GRN_WITH_MESSAGE_PACK:STRING=auto GRN_WITH_MRUBY:BOOL=OFF GRN_WITH_NFKC:BOOL=ON GRN_WITH_ZEROMQ:STRING=auto GRN_WITH_ZLIB:BOOL=OFF GROFF:FILEPATH=/usr/bin/groff GROONGA_NORMALIZER_MYSQL_EMBED:BOOL=ON GTAR_EXECUTABLE:FILEPATH=GTAR_EXECUTABLE-NOTFOUND INSTALL_BINDIR:STRING=bin INSTALL_DOCDIR:STRING=docs INSTALL_DOCREADMEDIR:STRING=. INSTALL_INCLUDEDIR:STRING=include/mysql INSTALL_INFODIR:STRING=docs INSTALL_LAYOUT:STRING=STANDALONE INSTALL_LIBDIR:STRING=lib INSTALL_MANDIR:STRING=man INSTALL_MYSQLDATADIR:STRING=data INSTALL_MYSQLSHAREDIR:STRING=share INSTALL_MYSQLTESTDIR:STRING=mysql-test INSTALL_PLUGINDIR:STRING=lib/plugin INSTALL_SBINDIR:STRING=bin INSTALL_SCRIPTDIR:STRING=scripts INSTALL_SHAREDIR:STRING=share INSTALL_SQLBENCHDIR:STRING=. INSTALL_SUPPORTFILESDIR:STRING=support-files INSTALL_SYSCONF2DIR:STRING= INSTALL_SYSCONFDIR:STRING= INSTALL_UNIX_ADDRDIR:STRING=/tmp/mysql.sock Judy_INCLUDE_DIR:PATH=/usr/include Judy_LIBRARIES:FILEPATH=/usr/lib/libJudy.so LIBTOKUDB:STRING=tokufractaltree LIBTOKUPORTABILITY:STRING=tokuportability LIBTOOLIZE_EXECUTABLE:FILEPATH=/usr/bin/libtoolize LIBXML2_INCLUDE_DIR:PATH=/usr/include/libxml2 LIBXML2_LIBRARIES:FILEPATH=/usr/lib/x86_64-linux-gnu/libxml2.so LIBXML2_XMLLINT_EXECUTABLE:FILEPATH=LIBXML2_XMLLINT_EXECUTABLE-NOTFOUND MANUFACTURER:STRING=Built from Source MRN_DEFAULT_PARSER:STRING=TokenBigram MRN_GROONGA_EMBED:BOOL=ON MRN_GROONGA_NORMALIZER_MYSQL_EMBED:BOOL=ON MYSQL_DATADIR:PATH=/usr/local/mysql/data MYSQL_MAINTAINER_MODE:STRING=AUTO MYSQL_PROJECT_NAME:STRING=MySQL NOT_FOR_DISTRIBUTION:BOOL=OFF NO_ALARM:BOOL=1 NROFF:FILEPATH=/usr/bin/nroff ODBC_INCLUDE_DIR:PATH=/usr/include ODBC_LIBRARY:FILEPATH=/usr/lib/x86_64-linux-gnu/libodbc.so OPENSSL_INCLUDE_DIR:PATH=/usr/include OPENSSL_LIBRARIES:FILEPATH=/usr/lib/x86_64-linux-gnu/libssl.so OPENSSL_ROOT_DIR:PATH=/usr PCREGREP_BUFSIZE:STRING=20480 PCRE_BUILD_PCREGREP:BOOL=ON PCRE_BUILD_TESTS:BOOL=ON PCRE_LINK_SIZE:STRING=2 PCRE_MATCH_LIMIT:STRING=10000000 PCRE_MATCH_LIMIT_RECURSION:STRING=MATCH_LIMIT PCRE_NEWLINE:STRING=LF PCRE_NO_RECURSE:BOOL=ON PCRE_PARENS_NEST_LIMIT:STRING=250 PCRE_POSIX_MALLOC_THRESHOLD:STRING=10 PCRE_SHOW_REPORT:BOOL=OFF PCRE_SUPPORT_BSR_ANYCRLF:BOOL=OFF PCRE_SUPPORT_UNICODE_PROPERTIES:BOOL=ON PKG_CONFIG_EXECUTABLE:FILEPATH=/usr/bin/pkg-config PLUGIN_ARCHIVE:STRING=DYNAMIC PLUGIN_ARIA:STRING=STATIC PLUGIN_AUDIT_NULL:STRING=DYNAMIC PLUGIN_AUTH_0X0100:STRING=DYNAMIC PLUGIN_AUTH_PAM:STRING=DYNAMIC PLUGIN_AUTH_SOCKET:STRING=DYNAMIC PLUGIN_AUTH_TEST_PLUGIN:STRING=DYNAMIC PLUGIN_BLACKHOLE:STRING=DYNAMIC PLUGIN_CASSANDRA:STRING=DYNAMIC PLUGIN_CONNECT:STRING=DYNAMIC PLUGIN_CRACKLIB_PASSWORD_CHECK:STRING=DYNAMIC PLUGIN_DAEMON_EXAMPLE:STRING=DYNAMIC PLUGIN_DEBUG_KEY_MANAGEMENT:STRING=DYNAMIC PLUGIN_DIALOG:STRING=DYNAMIC PLUGIN_DIALOG_EXAMPLES:STRING=DYNAMIC PLUGIN_EXAMPLE:STRING=DYNAMIC PLUGIN_EXAMPLE_KEY_MANAGEMENT:STRING=DYNAMIC PLUGIN_EXAMPLE_KEY_MANAGEMENT_PLUGIN:STRING=DYNAMIC PLUGIN_FEDERATED:STRING=DYNAMIC PLUGIN_FEDERATEDX:STRING=DYNAMIC PLUGIN_FEEDBACK:STRING=STATIC PLUGIN_FILE_KEY_MANAGEMENT:STRING=DYNAMIC PLUGIN_FILE_KEY_MANAGEMENT_PLUGIN:STRING=DYNAMIC PLUGIN_FTEXAMPLE:STRING=DYNAMIC PLUGIN_HANDLERSOCKET:STRING=DYNAMIC PLUGIN_INNOBASE:STRING=DYNAMIC PLUGIN_LOCALES:STRING=DYNAMIC PLUGIN_METADATA_LOCK_INFO:STRING=DYNAMIC PLUGIN_MROONGA:STRING=DYNAMIC PLUGIN_MYSQL_CLEAR_PASSWORD:STRING=DYNAMIC PLUGIN_OQGRAPH:STRING=DYNAMIC PLUGIN_PARTITION:STRING=STATIC PLUGIN_PERFSCHEMA:STRING=STATIC PLUGIN_QA_AUTH_CLIENT:STRING=DYNAMIC PLUGIN_QA_AUTH_INTERFACE:STRING=DYNAMIC PLUGIN_QA_AUTH_SERVER:STRING=DYNAMIC PLUGIN_QUERY_CACHE_INFO:STRING=DYNAMIC PLUGIN_QUERY_RESPONSE_TIME:STRING=DYNAMIC PLUGIN_SEMISYNC_MASTER:STRING=DYNAMIC PLUGIN_SEMISYNC_SLAVE:STRING=DYNAMIC PLUGIN_SEQUENCE:STRING=STATIC PLUGIN_SERVER_AUDIT:STRING=DYNAMIC PLUGIN_SIMPLE_PASSWORD_CHECK:STRING=DYNAMIC PLUGIN_SPHINX:STRING=DYNAMIC PLUGIN_SPIDER:STRING=DYNAMIC PLUGIN_SQL_ERRLOG:STRING=DYNAMIC PLUGIN_TEST_SQL_DISCOVERY:STRING=DYNAMIC PLUGIN_TOKUDB:STRING=DYNAMIC PLUGIN_WSREP_INFO:STRING=DYNAMIC PLUGIN_XTRADB:STRING=STATIC READLINE_INCLUDE_DIR:PATH=/usr/include/readline READLINE_LIBRARY:FILEPATH=/usr/lib/x86_64-linux-gnu/libreadline.so SECURITY_HARDENED:BOOL=ON TAR_EXECUTABLE:FILEPATH=/bin/tar TMPDIR:PATH= TOKUDB_DATA:FILEPATH=/home/elenst/git/10.1/storage/tokudb/ft-index/../tokudb.data TOKU_DEBUG_PARANOID:BOOL=OFF Thrift_INCLUDE_DIRS:PATH=Thrift_INCLUDE_DIRS-NOTFOUND Thrift_LIBS:FILEPATH=Thrift_LIBS-NOTFOUND USE_ARIA_FOR_TMP_TABLES:BOOL=ON USE_BDB:BOOL=OFF USE_GCOV:BOOL=OFF USE_VALGRIND:BOOL=OFF WITHOUT_SERVER:BOOL=OFF WITH_ASAN:BOOL=OFF WITH_ATOMIC_OPS:STRING= WITH_EMBEDDED_SERVER:BOOL=ON WITH_EXTRA_CHARSETS:STRING=all WITH_FAST_MUTEXES:BOOL=OFF WITH_INNODB_BZIP2:STRING=AUTO WITH_INNODB_DISALLOW_WRITES:BOOL=ON WITH_INNODB_LZ4:STRING=AUTO WITH_INNODB_LZMA:STRING=AUTO WITH_INNODB_LZO:STRING=AUTO WITH_INNODB_SNAPPY:STRING=AUTO WITH_JEMALLOC:STRING=auto WITH_LIBWRAP:BOOL=OFF WITH_MYSQLD_LDFLAGS:STRING= WITH_PCRE:STRING=auto WITH_PIC:BOOL=ON WITH_READLINE:BOOL=OFF WITH_SAFEMALLOC:STRING=AUTO WITH_UNIT_TESTS:BOOL=ON WITH_VALGRIND:BOOL=OFF WITH_WSREP:BOOL=ON WITH_ZLIB:STRING=system XZ_SOURCE_DIR:FILEPATH=/home/elenst/git/10.1/storage/tokudb/ft-index/third_party/xz-4.999.9beta ZLIB_INCLUDE_DIR:PATH=/usr/include ZLIB_LIBRARY:FILEPATH=/usr/lib/x86_64-linux-gnu/libz.so {noformat} |
Status | Open [ 1 ] | In Progress [ 3 ] |
Component/s | Encryption [ 11200 ] | |
Component/s | Storage Engine - XtraDB [ 10135 ] | |
Fix Version/s | 10.1.5 [ 18813 ] | |
Fix Version/s | 10.1 [ 16100 ] | |
Resolution | Fixed [ 1 ] | |
Status | In Progress [ 3 ] | Closed [ 6 ] |
Affects Version/s | 10.1.4 [ 18400 ] | |
Affects Version/s | 10.1 [ 16100 ] |
Workflow | MariaDB v2 [ 60720 ] | MariaDB v3 [ 67184 ] |
Workflow | MariaDB v3 [ 67184 ] | MariaDB v4 [ 149108 ] |
commit 2f25c653ade1e73aa2b1aa77af9a4898bacb2330
Author: Jan Lindström <jan.lindstrom@mariadb.com>
Date: Wed May 6 14:09:10 2015 +0300
MDEV-8074: Failing assertion: mutex->magic_n == MUTEX_MAGIC_N in file sync0sync.cc line 508
Problem was that e.g. on crash recovery fil_space_crypt_close_tablespace
and fil_space_crypt_mark_space_closing access mutex that is not yet
initialized. Mutex is naturally initialized only if encryption is
configured.