When trying to mysqldump database after "create sequence", InnoDB asserts like below:
$ mysql --defaults-file=my.cnf -e 'create sequence test.a'
|
$ mysqlsqldump --defaults-file=my.cnf test > /dev/null
|
mysqldump: Couldn't execute 'UNLOCK TABLES': Lost connection to MySQL server during query (2013)
|
2017-05-24 7:42:23 140019178026496 [Note] /home/a/test1/_depot/10.3-14465/bin/mysqld: ready for connections.
|
Version: '10.3.1-MariaDB' socket: '/home/a/test1/mariadb-environs/m4-10.3~latest/dt/my.sock' port: 3306 MariaDB Server
|
2017-05-24 7:42:53 140019102463744 [ERROR] Transaction not registered for MariaDB 2PC, but transaction is active
|
2017-05-24 07:42:53 0x7f58bcdd3700 InnoDB: Assertion failure in file /home/buildbot/buildbot/build/storage/innobase/trx/trx0trx.cc line 1737
|
InnoDB: Failing assertion: UT_LIST_GET_LEN(trx->lock.trx_locks) == 0
|
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.7/en/forcing-innodb-recovery.html
|
InnoDB: about forcing recovery.
|
170524 7:42:53 [ERROR] mysqld got signal 6 ;
|
This could be because you hit a bug. It is also possible that this binary
|
or one of the libraries it was linked against is corrupt, improperly built,
|
or misconfigured. This error can also be caused by malfunctioning hardware.
|
|
To report this bug, see https://mariadb.com/kb/en/reporting-bugs
|
|
We will try our best to scrape up some info that will hopefully help
|
diagnose the problem, but since we have already crashed,
|
something is definitely wrong and this may fail.
|
|
Server version: 10.3.1-MariaDB
|
key_buffer_size=134217728
|
read_buffer_size=131072
|
max_used_connections=1
|
max_threads=153
|
thread_count=7
|
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467233 K bytes of memory
|
Hope that's ok; if not, decrease some variables in the equation.
|
|
Thread pointer: 0x7f58480009a8
|
Attempting backtrace. You can use the following information to find out
|
where mysqld died. If you see no messages after this, something went
|
terribly wrong...
|
stack_bottom = 0x7f58bcdd2ec0 thread_stack 0x49000
|
/home/a/test1/mariadb-environs/m4-10.3~latest/../_depot/m-tar/10.3-14465/bin/mysqld(my_print_stacktrace+0x2b)[0x5581a4bcd4db]
|
/home/a/test1/mariadb-environs/m4-10.3~latest/../_depot/m-tar/10.3-14465/bin/mysqld(handle_fatal_signal+0x4d5)[0x5581a4661af5]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x11630)[0x7f58c098e630]
|
/lib/x86_64-linux-gnu/libc.so.6(gsignal+0x9f)[0x7f58bff5a7ef]
|
/lib/x86_64-linux-gnu/libc.so.6(abort+0x16a)[0x7f58bff5c3ea]
|
/home/a/test1/mariadb-environs/m4-10.3~latest/../_depot/m-tar/10.3-14465/bin/mysqld(+0x4a2048)[0x5581a4409048]
|
/home/a/test1/mariadb-environs/m4-10.3~latest/../_depot/m-tar/10.3-14465/bin/mysqld(+0x9cfcf9)[0x5581a4936cf9]
|
/home/a/test1/mariadb-environs/m4-10.3~latest/../_depot/m-tar/10.3-14465/bin/mysqld(+0x9cff9a)[0x5581a4936f9a]
|
mysys/stacktrace.c:268(my_print_stacktrace)[0x5581a49371a7]
|
ut/ut0rbt.cc:459(rbt_eject_node(ib_rbt_node_t*, ib_rbt_node_t*) [clone .part.4])[0x5581a47c6bf1]
|
handler/ha_innodb.cc:4571(innobase_commit_low(trx_t*))[0x5581a47c6e8a]
|
handler/ha_innodb.cc:4707(innobase_commit_ordered_2(trx_t*, THD*))[0x5581a47d95f3]
|
handler/ha_innodb.cc:16526(ha_innobase::external_lock(THD*, int))[0x5581a47db4d5]
|
sql/ha_sequence.cc:320(ha_sequence::external_lock(THD*, int))[0x5581a4ba9205]
|
sql/handler.cc:5891(handler::ha_external_lock(THD*, int))[0x5581a466b00c]
|
sql/lock.cc:716(unlock_external(THD*, TABLE**, unsigned int))[0x5581a47252fb]
|
sql/lock.cc:428(mysql_unlock_tables(THD*, st_mysql_lock*, bool))[0x5581a47254ab]
|
sql/sql_base.cc:841(close_thread_tables(THD*))[0x5581a4474f87]
|
sql/sql_base.cc:2171(Locked_tables_list::unlock_locked_tables(THD*))[0x5581a44758da]
|
sql/sql_parse.cc:4979(mysql_execute_command(THD*))[0x5581a44c2d8c]
|
sql/sql_parse.cc:7912(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x5581a44c575a]
|
sql/sql_parse.cc:1817(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x5581a44c79ca]
|
sql/sql_parse.cc:1382(do_command(THD*))[0x5581a44c7f91]
|
sql/sql_connect.cc:1354(do_handle_one_connection(CONNECT*))[0x5581a45840ef]
|
sql/sql_connect.cc:1262(handle_one_connection)[0x5581a4584214]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ca)[0x7f58c09846ca]
|
/lib/x86_64-linux-gnu/libc.so.6(clone+0x5f)[0x7f58c002d0af]
|
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0x7f58480111b0): UNLOCK TABLES
|
Connection ID (thread ID): 10
|
Status: NOT_KILLED
|
|
Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on
|
|
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
|
information that should help you find out what is causing the crash.
|
Elena Stepanova
made changes -
Field |
Original Value |
New Value |
Labels
|
|
need_feedback
|
Elena Stepanova
made changes -
Status
|
Open
[ 1
]
|
Confirmed
[ 10101
]
|
Elena Stepanova
made changes -
Fix Version/s
|
|
10.3
[ 22126
]
|
Assignee
|
|
Michael Widenius
[ monty
]
|
Sergei Golubchik
made changes -
Component/s
|
|
Sequences
[ 14009
]
|
Sergei Golubchik
made changes -
Priority
|
Major
[ 3
]
|
Critical
[ 2
]
|
Michael Widenius
made changes -
issue.field.resolutiondate
|
2018-02-19 08:52:37.0
|
2018-02-19 08:52:37.662
|
Michael Widenius
made changes -
Fix Version/s
|
|
10.3.1
[ 22532
]
|
Fix Version/s
|
10.3
[ 22126
]
|
|
Resolution
|
|
Fixed
[ 1
]
|
Status
|
Confirmed
[ 10101
]
|
Closed
[ 6
]
|
Sergei Golubchik
made changes -
Workflow
|
MariaDB v3
[ 80908
]
|
MariaDB v4
[ 152210
]
|
{"report":{"fcp":1263.5,"ttfb":329.19999980926514,"pageVisibility":"visible","entityId":61490,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"d8d02c2c-f488-40e5-9d17-0ae402d7daa9","navigationType":0,"readyForUser":1357.6999998092651,"redirectCount":0,"resourceLoadedEnd":1677.1999998092651,"resourceLoadedStart":334.69999980926514,"resourceTiming":[{"duration":431.9000005722046,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":334.69999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":334.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":766.6000003814697,"responseStart":0,"secureConnectionStart":0},{"duration":431.8999996185303,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bv2/820016/12ta74/2380add21a9a1006587582385952de73/_/download/contextbatch/css/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":335,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":335,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":766.8999996185303,"responseStart":0,"secureConnectionStart":0},{"duration":434.30000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/s/e9b27a47da5fb0f74a35acd57e9847fb-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":335.19999980926514,"connectEnd":335.19999980926514,"connectStart":335.19999980926514,"domainLookupEnd":335.19999980926514,"domainLookupStart":335.19999980926514,"fetchStart":335.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":335.19999980926514,"responseEnd":769.5,"responseStart":769.5,"secureConnectionStart":335.19999980926514},{"duration":532.8000001907349,"initiatorType":"script","name":"https://jira.mariadb.org/s/c32eb0da7ad9831253f8397e6cc26afd-CDN/lu2bv2/820016/12ta74/2380add21a9a1006587582385952de73/_/download/contextbatch/js/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true","startTime":335.3999996185303,"connectEnd":335.3999996185303,"connectStart":335.3999996185303,"domainLookupEnd":335.3999996185303,"domainLookupStart":335.3999996185303,"fetchStart":335.3999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":335.3999996185303,"responseEnd":868.1999998092651,"responseStart":868.1999998092651,"secureConnectionStart":335.3999996185303},{"duration":536.5999994277954,"initiatorType":"script","name":"https://jira.mariadb.org/s/bc0bcb146314416123c992714ee00ff7-CDN/lu2bv2/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":335.6000003814697,"connectEnd":335.6000003814697,"connectStart":335.6000003814697,"domainLookupEnd":335.6000003814697,"domainLookupStart":335.6000003814697,"fetchStart":335.6000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":335.6000003814697,"responseEnd":872.1999998092651,"responseStart":872.1999998092651,"secureConnectionStart":335.6000003814697},{"duration":536.7000007629395,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":335.8999996185303,"connectEnd":335.8999996185303,"connectStart":335.8999996185303,"domainLookupEnd":335.8999996185303,"domainLookupStart":335.8999996185303,"fetchStart":335.8999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":335.8999996185303,"responseEnd":872.6000003814697,"responseStart":872.6000003814697,"secureConnectionStart":335.8999996185303},{"duration":537,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":336,"connectEnd":336,"connectStart":336,"domainLookupEnd":336,"domainLookupStart":336,"fetchStart":336,"redirectEnd":0,"redirectStart":0,"requestStart":336,"responseEnd":873,"responseStart":873,"secureConnectionStart":336},{"duration":582.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bv2/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":336.1000003814697,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":336.1000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":918.6000003814697,"responseStart":0,"secureConnectionStart":0},{"duration":537.3000001907349,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":336.30000019073486,"connectEnd":336.30000019073486,"connectStart":336.30000019073486,"domainLookupEnd":336.30000019073486,"domainLookupStart":336.30000019073486,"fetchStart":336.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":336.30000019073486,"responseEnd":873.6000003814697,"responseStart":873.6000003814697,"secureConnectionStart":336.30000019073486},{"duration":582.3000001907349,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bv2/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.css?jira.create.linked.issue=true","startTime":336.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":336.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":918.8000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":537.6999998092651,"initiatorType":"script","name":"https://jira.mariadb.org/s/719848dd97ebe0663199f49a3936487a-CDN/lu2bv2/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.js?jira.create.linked.issue=true&locale=en","startTime":336.6000003814697,"connectEnd":336.6000003814697,"connectStart":336.6000003814697,"domainLookupEnd":336.6000003814697,"domainLookupStart":336.6000003814697,"fetchStart":336.6000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":336.6000003814697,"responseEnd":874.3000001907349,"responseStart":874.3000001907349,"secureConnectionStart":336.6000003814697},{"duration":975.3999996185303,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":342.1000003814697,"connectEnd":342.1000003814697,"connectStart":342.1000003814697,"domainLookupEnd":342.1000003814697,"domainLookupStart":342.1000003814697,"fetchStart":342.1000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":342.1000003814697,"responseEnd":1317.5,"responseStart":1317.5,"secureConnectionStart":342.1000003814697},{"duration":1332.8000001907349,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":344.3999996185303,"connectEnd":344.3999996185303,"connectStart":344.3999996185303,"domainLookupEnd":344.3999996185303,"domainLookupStart":344.3999996185303,"fetchStart":344.3999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":344.3999996185303,"responseEnd":1677.1999998092651,"responseStart":1677.1999998092651,"secureConnectionStart":344.3999996185303},{"duration":407.5,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":933.3000001907349,"connectEnd":933.3000001907349,"connectStart":933.3000001907349,"domainLookupEnd":933.3000001907349,"domainLookupStart":933.3000001907349,"fetchStart":933.3000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":933.3000001907349,"responseEnd":1340.8000001907349,"responseStart":1340.8000001907349,"secureConnectionStart":933.3000001907349}],"fetchStart":1,"domainLookupStart":1,"domainLookupEnd":1,"connectStart":1,"connectEnd":1,"requestStart":125,"responseStart":330,"responseEnd":345,"domLoading":333,"domInteractive":1702,"domContentLoadedEventStart":1702,"domContentLoadedEventEnd":1750,"domComplete":2600,"loadEventStart":2600,"loadEventEnd":2600,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1679.1000003814697},{"name":"bigPipe.sidebar-id.end","time":1680},{"name":"bigPipe.activity-panel-pipe-id.start","time":1680.1999998092651},{"name":"bigPipe.activity-panel-pipe-id.end","time":1682.6000003814697},{"name":"activityTabFullyLoaded","time":1766.1000003814697}],"measures":[],"correlationId":"68758d675234fc","effectiveType":"4g","downlink":9.4,"rtt":0,"serverDuration":134,"dbReadsTimeInMs":29,"dbConnsTimeInMs":40,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}