Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Fix
-
10.2.37
-
None
-
kvm-rpm-centos74-amd64-debug
Description
galera.galera_as_slave failed on BB 10.2 CS: SIGABRT: Assertion `(&(&LOCK_thd_data)>m_mutex)>count > 0 && pthread_equal(pthread_self(), (&(&LOCK_thd_data)>m_mutex)>thread)' failed in sql_class.cc on awake(killed_state).
It seems to be a sporadic issue.
|
10.2.37, afc5bac49d48b6fd13def25409642104b988de28, kvm-rpm-centos74-amd64-debug |
galera.galera_as_slave 'innodb' w2 [ fail ]
|
Test ended at 2021-02-08 20:25:39
|
|
|
CURRENT_TEST: galera.galera_as_slave
|
mysqltest: In included file "./include/wait_condition.inc":
|
included from /usr/share/mysql-test/suite/galera/t/galera_as_slave.test at line 26:
|
At line 43: query 'let $success= `$wait_condition`' failed with wrong errno 2013: 'Lost connection to MySQL server during query', instead of 0...
|
|
|
The result from queries just before the failure was:
|
connect node_2a, 127.0.0.1, root, , test, $NODE_MYPORT_2;
|
connection node_2;
|
START SLAVE;
|
connection node_1;
|
CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
|
INSERT INTO t1 VALUES(1);
|
connection node_2;
|
|
|
|
|
Server [mysqld.2 - pid: 11462, winpid: 11462, exit: 256] failed during test run
|
Server log from this test:
|
----------SERVER LOG START-----------
|
2021-02-08 20:25:27 140716219763008 [Warning] WSREP: option --wsrep-causal-reads is deprecated
|
2021-02-08 20:25:27 140716219763008 [Warning] WSREP: --wsrep-causal-reads=ON takes precedence over --wsrep-sync-wait=0. WSREP_SYNC_WAIT_BEFORE_READ is on
|
2021-02-08 20:25:27 140716219763008 [Note] /usr/sbin/mysqld (mysqld 10.2.37-MariaDB-debug-log) starting as process 11463 ...
|
2021-02-08 20:25:27 140716219763008 [Warning] Could not increase number of max_open_files to more than 1024 (request: 32186)
|
2021-02-08 20:25:27 140716219763008 [Warning] Changed limits: max_open_files: 1024 max_connections: 151 (was 151) table_cache: 421 (was 2000)
|
2021-02-08 20:25:27 140716219763008 [Warning] WSREP: wsrep_sst_receive_address is set to '127.0.0.1:16025' which makes it impossible for another host to reach this one. Please set it to the address which this node can be connected at by other cluster members.
|
2021-02-08 20:25:27 140716219763008 [Note] WSREP: Read nil XID from storage engines, skipping position init
|
2021-02-08 20:25:27 140716219763008 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/galera/libgalera_smm.so'
|
2021-02-08 20:25:27 140716219763008 [Note] WSREP: wsrep_load(): Galera 3.32(rf74c6d3) by Codership Oy <info@codership.com> loaded successfully.
|
2021-02-08 20:25:27 140716219763008 [Note] WSREP: CRC-32C: using "slicing-by-8" algorithm.
|
2021-02-08 20:25:27 140716219763008 [Warning] WSREP: Could not open state file for reading: '/dev/shm/var/2/mysqld.2/data//grastate.dat'
|
2021-02-08 20:25:27 140716219763008 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1, safe_to_bootstrap: 1
|
2021-02-08 20:25:27 140716219763008 [Note] WSREP: Passing config to GCS: base_dir = /dev/shm/var/2/mysqld.2/data/; base_host = 127.0.0.1; base_port = 16023; cert.log_conflicts = no; cert.optimistic_pa = yes; debug = no; evs.auto_evict = 0; evs.delay_margin = PT1S; evs.delayed_keep_period = PT30S; evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT15S; evs.join_retrans_period = PT1S; evs.max_install_timeouts = 3; evs.send_window = 4; evs.stats_report_period = PT1M; evs.suspect_timeout = PT5S; evs.user_send_window = 2; evs.view_forget_timeout = PT24H; gcache.dir = /dev/shm/var/2/mysqld.2/data/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /dev/shm/var/2/mysqld.2/data//galera.cache; gcache.page_size = 128M; gcache.recover = no; gcache.size = 10M; gcomm.thread_prio = ; gcs.fc_debug = 0; gcs.fc_factor = 1.0; gcs.fc_limit = 16; gcs.fc_master_slave = no; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = no; gmcast.segment = 0; gmcast.v
|
2021-02-08 20:25:27 140716219763008 [Note] WSREP: GCache history reset: 00000000-0000-0000-0000-000000000000:0 -> 00000000-0000-0000-0000-000000000000:-1
|
2021-02-08 20:25:27 140716219763008 [Note] WSREP: Assign initial position for certification: -1, protocol version: -1
|
2021-02-08 20:25:27 140716219763008 [Note] WSREP: wsrep_sst_grab()
|
2021-02-08 20:25:27 140716219763008 [Note] WSREP: Start replication
|
2021-02-08 20:25:27 140716219763008 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1
|
2021-02-08 20:25:27 140716219763008 [Note] WSREP: protonet asio version 0
|
2021-02-08 20:25:27 140716219763008 [Note] WSREP: Using CRC-32C for message checksums.
|
2021-02-08 20:25:27 140716219763008 [Note] WSREP: backend: asio
|
2021-02-08 20:25:27 140716219763008 [Note] WSREP: gcomm thread scheduling priority set to other:0
|
2021-02-08 20:25:27 140716219763008 [Warning] WSREP: access file(/dev/shm/var/2/mysqld.2/data//gvwstate.dat) failed(No such file or directory)
|
2021-02-08 20:25:27 140716219763008 [Note] WSREP: restore pc from disk failed
|
2021-02-08 20:25:27 140716219763008 [Note] WSREP: GMCast version 0
|
2021-02-08 20:25:27 140716219763008 [Note] WSREP: (c7ee4419, 'tcp://0.0.0.0:16023') listening at tcp://0.0.0.0:16023
|
2021-02-08 20:25:27 140716219763008 [Note] WSREP: (c7ee4419, 'tcp://0.0.0.0:16023') multicast: , ttl: 1
|
2021-02-08 20:25:27 140716219763008 [Note] WSREP: EVS version 0
|
2021-02-08 20:25:27 140716219763008 [Note] WSREP: gcomm: connecting to group 'my_wsrep_cluster', peer ''
|
2021-02-08 20:25:27 140716219763008 [Note] WSREP: start_prim is enabled, turn off pc_recovery
|
2021-02-08 20:25:27 140716219763008 [Note] WSREP: Node c7ee4419 state prim
|
2021-02-08 20:25:27 140716219763008 [Note] WSREP: view(view_id(PRIM,c7ee4419,1) memb {
|
c7ee4419,0
|
} joined {
|
} left {
|
} partitioned {
|
})
|
2021-02-08 20:25:27 140716219763008 [Note] WSREP: save pc into disk
|
2021-02-08 20:25:27 140716219763008 [Note] WSREP: gcomm: connected
|
2021-02-08 20:25:27 140716219763008 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636
|
2021-02-08 20:25:27 140716219763008 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0)
|
2021-02-08 20:25:27 140716219763008 [Note] WSREP: Opened channel 'my_wsrep_cluster'
|
2021-02-08 20:25:27 140716219763008 [Note] WSREP: Waiting for SST to complete.
|
2021-02-08 20:25:27 140716099880704 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1
|
2021-02-08 20:25:27 140716099880704 [Note] WSREP: Starting new group from scratch: c7ee7539-6a4b-11eb-a4db-aaacb0fba1c1
|
2021-02-08 20:25:27 140716099880704 [Note] WSREP: STATE_EXCHANGE: sent state UUID: c7ee7b13-6a4b-11eb-b7f1-2e3155dcee97
|
2021-02-08 20:25:27 140716099880704 [Note] WSREP: STATE EXCHANGE: sent state msg: c7ee7b13-6a4b-11eb-b7f1-2e3155dcee97
|
2021-02-08 20:25:27 140716099880704 [Note] WSREP: STATE EXCHANGE: got state msg: c7ee7b13-6a4b-11eb-b7f1-2e3155dcee97 from 0 (centos74-amd64)
|
2021-02-08 20:25:27 140716099880704 [Note] WSREP: Quorum results:
|
version = 6,
|
component = PRIMARY,
|
conf_id = 0,
|
members = 1/1 (joined/total),
|
act_id = 0,
|
last_appl. = -1,
|
protocols = 0/9/3 (gcs/repl/appl),
|
group UUID = c7ee7539-6a4b-11eb-a4db-aaacb0fba1c1
|
2021-02-08 20:25:27 140716099880704 [Note] WSREP: Flow-control interval: [16, 16]
|
2021-02-08 20:25:27 140716099880704 [Note] WSREP: Restored state OPEN -> JOINED (0)
|
2021-02-08 20:25:27 140716099880704 [Note] WSREP: Member 0.0 (centos74-amd64) synced with group.
|
2021-02-08 20:25:27 140716099880704 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 0)
|
2021-02-08 20:25:27 140716219447040 [Note] WSREP: REPL Protocols: 9 (4, 2)
|
2021-02-08 20:25:27 140716219447040 [Note] WSREP: New cluster view: global state: c7ee7539-6a4b-11eb-a4db-aaacb0fba1c1:0, view# 1: Primary, number of nodes: 1, my index: 0, protocol version 3
|
2021-02-08 20:25:27 140716219763008 [Note] WSREP: SST complete, seqno: 0
|
2021-02-08 20:25:27 140716219763008 [Note] Plugin 'SEQUENCE' is disabled.
|
2021-02-08 20:25:27 140716219763008 [Note] Plugin 'partition' is disabled.
|
2021-02-08 20:25:27 140716219763008 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!
|
2021-02-08 20:25:27 140716219763008 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
|
2021-02-08 20:25:27 140716219763008 [Note] InnoDB: Uses event mutexes
|
2021-02-08 20:25:27 140716219763008 [Note] InnoDB: Compressed tables use zlib 1.2.7
|
2021-02-08 20:25:27 140716219763008 [Note] InnoDB: Using Linux native AIO
|
2021-02-08 20:25:27 140716219763008 [Note] InnoDB: Number of pools: 1
|
2021-02-08 20:25:27 140716219763008 [Note] InnoDB: Using generic crc32 instructions
|
2021-02-08 20:25:27 140716219763008 [Note] InnoDB: Initializing buffer pool, total size = 8M, instances = 1, chunk size = 8M
|
2021-02-08 20:25:27 140716219763008 [Note] InnoDB: Completed initialization of buffer pool
|
2021-02-08 20:25:27 140716032349952 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
|
2021-02-08 20:25:27 140716219763008 [Note] InnoDB: Highest supported file format is Barracuda.
|
2021-02-08 20:25:27 140716219763008 [Note] InnoDB: 128 out of 128 rollback segments are active.
|
2021-02-08 20:25:27 140716219763008 [Note] InnoDB: Creating shared tablespace for temporary tables
|
2021-02-08 20:25:27 140716219763008 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
|
2021-02-08 20:25:27 140716219763008 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
|
2021-02-08 20:25:27 140716219763008 [Note] InnoDB: Waiting for purge to start
|
2021-02-08 20:25:27 140716219763008 [Note] InnoDB: 5.7.33 started; log sequence number 1628778
|
2021-02-08 20:25:27 140715940030208 [Note] InnoDB: Loading buffer pool(s) from /dev/shm/var/2/mysqld.2/data/ib_buffer_pool
|
2021-02-08 20:25:27 140715940030208 [Note] InnoDB: Buffer pool(s) load completed at 210208 20:25:27
|
2021-02-08 20:25:27 140716219763008 [Note] Plugin 'INNODB_SYS_DATAFILES' is disabled.
|
2021-02-08 20:25:27 140716219763008 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled.
|
2021-02-08 20:25:27 140716219763008 [Note] Plugin 'INNODB_MUTEXES' is disabled.
|
2021-02-08 20:25:27 140716219763008 [Note] Plugin 'INNODB_CMP' is disabled.
|
2021-02-08 20:25:27 140716219763008 [Note] Plugin 'INNODB_FT_DELETED' is disabled.
|
2021-02-08 20:25:27 140716219763008 [Note] Plugin 'INNODB_CMP_RESET' is disabled.
|
2021-02-08 20:25:27 140716219763008 [Note] Plugin 'INNODB_LOCK_WAITS' is disabled.
|
2021-02-08 20:25:27 140716219763008 [Note] Plugin 'INNODB_TABLESPACES_ENCRYPTION' is disabled.
|
2021-02-08 20:25:27 140716219763008 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled.
|
2021-02-08 20:25:27 140716219763008 [Note] Plugin 'FEEDBACK' is disabled.
|
2021-02-08 20:25:27 140716219763008 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled.
|
2021-02-08 20:25:27 140716219763008 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled.
|
2021-02-08 20:25:27 140716219763008 [Note] Plugin 'user_variables' is disabled.
|
2021-02-08 20:25:27 140716219763008 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled.
|
2021-02-08 20:25:27 140716219763008 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled.
|
2021-02-08 20:25:27 140716219763008 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled.
|
2021-02-08 20:25:27 140716219763008 [Note] Plugin 'INNODB_FT_CONFIG' is disabled.
|
2021-02-08 20:25:27 140716219763008 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled.
|
2021-02-08 20:25:27 140716219763008 [Note] Plugin 'INNODB_TABLESPACES_SCRUBBING' is disabled.
|
2021-02-08 20:25:27 140716219763008 [Note] Plugin 'INNODB_SYS_SEMAPHORE_WAITS' is disabled.
|
2021-02-08 20:25:27 140716219763008 [Warning] /usr/sbin/mysqld: unknown option '--loose-pam-debug'
|
2021-02-08 20:25:27 140716219763008 [Note] Server socket created on IP: '127.0.0.1'.
|
2021-02-08 20:25:27 140716219447040 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
|
2021-02-08 20:25:27 140716219447040 [Note] WSREP: Assign initial position for certification: 0, protocol version: 4
|
2021-02-08 20:25:27 140716116666112 [Note] WSREP: Service thread queue flushed.
|
2021-02-08 20:25:27 140716219447040 [Note] WSREP: GCache history reset: 00000000-0000-0000-0000-000000000000:0 -> c7ee7539-6a4b-11eb-a4db-aaacb0fba1c1:0
|
2021-02-08 20:25:27 140716219447040 [Note] WSREP: Synchronized with group, ready for connections
|
2021-02-08 20:25:27 140716219447040 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
|
2021-02-08 20:25:27 140716219763008 [Note] Reading of all Master_info entries succeeded
|
2021-02-08 20:25:27 140716219763008 [Note] Added new Master_info '' to hash table
|
2021-02-08 20:25:27 140716219763008 [Note] /usr/sbin/mysqld: ready for connections.
|
Version: '10.2.37-MariaDB-debug-log' socket: '/dev/shm/var/tmp/2/mysqld.2.sock' port: 16021 MariaDB Server
|
2021-02-08 20:25:27 140716108273408 [Note] WSREP: (c7ee4419, 'tcp://0.0.0.0:16023') connection established to c8270cf6 tcp://127.0.0.1:16026
|
2021-02-08 20:25:27 140716108273408 [Note] WSREP: (c7ee4419, 'tcp://0.0.0.0:16023') turning message relay requesting on, nonlive peers:
|
2021-02-08 20:25:28 140716108273408 [Note] WSREP: declaring c8270cf6 at tcp://127.0.0.1:16026 stable
|
2021-02-08 20:25:28 140716108273408 [Note] WSREP: Node c7ee4419 state prim
|
2021-02-08 20:25:28 140716108273408 [Note] WSREP: view(view_id(PRIM,c7ee4419,2) memb {
|
c7ee4419,0
|
c8270cf6,0
|
} joined {
|
} left {
|
} partitioned {
|
})
|
2021-02-08 20:25:28 140716108273408 [Note] WSREP: save pc into disk
|
2021-02-08 20:25:28 140716099880704 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 2
|
2021-02-08 20:25:28 140716099880704 [Note] WSREP: STATE_EXCHANGE: sent state UUID: c873e8f4-6a4b-11eb-91c3-6e30f3e19da3
|
2021-02-08 20:25:28 140716099880704 [Note] WSREP: STATE EXCHANGE: sent state msg: c873e8f4-6a4b-11eb-91c3-6e30f3e19da3
|
2021-02-08 20:25:28 140716099880704 [Note] WSREP: STATE EXCHANGE: got state msg: c873e8f4-6a4b-11eb-91c3-6e30f3e19da3 from 0 (centos74-amd64)
|
2021-02-08 20:25:28 140716099880704 [Note] WSREP: STATE EXCHANGE: got state msg: c873e8f4-6a4b-11eb-91c3-6e30f3e19da3 from 1 (centos74-amd64)
|
2021-02-08 20:25:28 140716099880704 [Note] WSREP: Quorum results:
|
version = 6,
|
component = PRIMARY,
|
conf_id = 1,
|
members = 1/2 (joined/total),
|
act_id = 0,
|
last_appl. = 0,
|
protocols = 0/9/3 (gcs/repl/appl),
|
group UUID = c7ee7539-6a4b-11eb-a4db-aaacb0fba1c1
|
2021-02-08 20:25:28 140716099880704 [Note] WSREP: Flow-control interval: [23, 23]
|
2021-02-08 20:25:28 140716219447040 [Note] WSREP: REPL Protocols: 9 (4, 2)
|
2021-02-08 20:25:28 140716219447040 [Note] WSREP: New cluster view: global state: c7ee7539-6a4b-11eb-a4db-aaacb0fba1c1:0, view# 2: Primary, number of nodes: 2, my index: 0, protocol version 3
|
2021-02-08 20:25:28 140716219447040 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
|
2021-02-08 20:25:28 140716219447040 [Note] WSREP: Assign initial position for certification: 0, protocol version: 4
|
2021-02-08 20:25:28 140716116666112 [Note] WSREP: Service thread queue flushed.
|
2021-02-08 20:25:29 140716099880704 [Note] WSREP: Member 1.0 (centos74-amd64) requested state transfer from '*any*'. Selected 0.0 (centos74-amd64)(SYNCED) as donor.
|
2021-02-08 20:25:29 140716099880704 [Note] WSREP: Shifting SYNCED -> DONOR/DESYNCED (TO: 0)
|
2021-02-08 20:25:29 140716219447040 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
|
2021-02-08 20:25:29 140715897763584 [Note] WSREP: Running: 'wsrep_sst_rsync --role 'donor' --address '127.0.0.1:16028/rsync_sst' --socket '/dev/shm/var/tmp/2/mysqld.2.sock' --datadir '/dev/shm/var/2/mysqld.2/data/' --defaults-file '/dev/shm/var/2/my.cnf' --defaults-group-suffix '.2' --gtid 'c7ee7539-6a4b-11eb-a4db-aaacb0fba1c1:0' --gtid-domain-id '0' --binlog 'mysqld-bin' --mysqld-args --defaults-group-suffix=.2 --defaults-file=/dev/shm/var/2/my.cnf --log-output=file --innodb --innodb-cmpmem --innodb-cmp-per-index --innodb-trx --innodb-locks --innodb-metrics --innodb-buffer-pool-stats --innodb-buffer-page --innodb-buffer-page-lru --innodb-sys-columns --innodb-sys-fields --innodb-sys-foreign --innodb-sys-foreign-cols --innodb-sys-indexes --innodb-sys-tables --innodb-sys-virtual --core-file --loose-debug-sync-timeout=300'
|
2021-02-08 20:25:29 140716219447040 [Note] WSREP: sst_donor_thread signaled with 0
|
2021-02-08 20:25:29 140715897763584 [Note] WSREP: Flushing tables for SST...
|
2021-02-08 20:25:29 140715897763584 [Note] WSREP: Provider paused at c7ee7539-6a4b-11eb-a4db-aaacb0fba1c1:0 (5)
|
2021-02-08 20:25:29 140715897763584 [Note] WSREP: Tables flushed.
|
WSREP_SST: [INFO] Preparing binlog files for transfer: (20210208 20:25:29.294)
|
mysqld-bin.000002
|
2021-02-08 20:25:30 140715897763584 [Note] WSREP: resuming provider at 5
|
2021-02-08 20:25:30 140715897763584 [Note] WSREP: Provider resumed.
|
2021-02-08 20:25:30 140716099880704 [Note] WSREP: 0.0 (centos74-amd64): State transfer to 1.0 (centos74-amd64) complete.
|
2021-02-08 20:25:30 140716099880704 [Note] WSREP: Shifting DONOR/DESYNCED -> JOINED (TO: 0)
|
2021-02-08 20:25:30 140716099880704 [Note] WSREP: Member 0.0 (centos74-amd64) synced with group.
|
2021-02-08 20:25:30 140716099880704 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 0)
|
2021-02-08 20:25:30 140716219447040 [Note] WSREP: Synchronized with group, ready for connections
|
2021-02-08 20:25:30 140716219447040 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
|
2021-02-08 20:25:30 140716108273408 [Note] WSREP: (c7ee4419, 'tcp://0.0.0.0:16023') turning message relay requesting off
|
2021-02-08 20:25:31 140716099880704 [Note] WSREP: 1.0 (centos74-amd64): State transfer from 0.0 (centos74-amd64) complete.
|
2021-02-08 20:25:31 140716099880704 [Note] WSREP: Member 1.0 (centos74-amd64) synced with group.
|
2021-02-08 20:25:33 140715889370880 [Note] Master connection name: '' Master_info_file: 'master.info' Relay_info_file: 'relay-log.info'
|
2021-02-08 20:25:33 140715889370880 [Note] 'CHANGE MASTER TO executed'. Previous state master_host='', master_port='3306', master_log_file='', master_log_pos='4'. New state master_host='127.0.0.1', master_port='16020', master_log_file='', master_log_pos='4'.
|
2021-02-08 20:25:33 140715888764672 [Note] WSREP: ready state reached
|
2021-02-08 20:25:33 140715888764672 [Note] Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log './mysqld-relay-bin.000001' position: 4
|
2021-02-08 20:25:33 140715889067776 [Note] Slave I/O thread: connected to master 'root@127.0.0.1:16020',replication started in log 'FIRST' at position 4
|
mysqld: /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.37/sql/sql_class.cc:1696: void THD::awake(killed_state): Assertion `(&(&LOCK_thd_data)->m_mutex)->count > 0 && pthread_equal(pthread_self(), (&(&LOCK_thd_data)->m_mutex)->thread)' failed.
|
210208 20:25:33 [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.2.37-MariaDB-debug-log
|
key_buffer_size=1048576
|
read_buffer_size=131072
|
max_used_connections=2
|
max_threads=153
|
thread_count=12
|
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 63104 K bytes of memory
|
Hope that's ok; if not, decrease some variables in the equation.
|
|
|
Thread pointer: 0x55b2e3d94070
|
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 = 0x7ffaf89054d0 thread_stack 0x49000
|
addr2line: Dwarf Error: Offset (950407281) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (31850752) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (3828713) greater than or equal to .debug_str size (133394).
|
addr2line: Dwarf Error: Offset (66453762) greater than or equal to .debug_str size (133394).
|
addr2line: Dwarf Error: Offset (6516329) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (3106628) greater than or equal to .debug_str size (133394).
|
addr2line: Dwarf Error: Offset (3706458) greater than or equal to .debug_str size (133394).
|
addr2line: Dwarf Error: Offset (3242708) greater than or equal to .debug_str size (133394).
|
addr2line: Dwarf Error: Offset (3147785) greater than or equal to .debug_str size (133394).
|
addr2line: Dwarf Error: Offset (1862285386) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (25509216) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (18547037) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (6579297) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (6516329) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (905304431) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (18547037) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (29426177) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (18547037) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (18547037) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (1105195) greater than or equal to .debug_str size (133394).
|
addr2line: Dwarf Error: Offset (18547037) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (18547037) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (659081290) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (648186430) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (3106628) greater than or equal to .debug_str size (133394).
|
addr2line: Dwarf Error: Offset (3106628) greater than or equal to .debug_str size (133394).
|
addr2line: Dwarf Error: Offset (2536309043) greater than or equal to .debug_str size (133394).
|
addr2line: Dwarf Error: Offset (949460372) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (497911297) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (1862355200) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Could not find abbrev number 3825.
|
addr2line: Dwarf Error: Offset (7173491) greater than or equal to .debug_str size (3950448).
|
mysys/stacktrace.c:172(my_print_stacktrace)[0x55b2da5792f9]
|
sql/signal_handler.cc:209(handle_fatal_signal)[0x55b2d9f1d541]
|
sigaction.c:0(__restore_rt)[0x7ffb0bccd5e0]
|
:0(__GI_raise)[0x7ffb0a1d91f7]
|
:0(__GI_abort)[0x7ffb0a1da8e8]
|
:0(__assert_fail_base)[0x7ffb0a1d2266]
|
:0(__GI___assert_fail)[0x7ffb0a1d2312]
|
addr2line: Dwarf Error: Offset (950407281) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (31850752) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (3828713) greater than or equal to .debug_str size (133394).
|
addr2line: Dwarf Error: Offset (66453762) greater than or equal to .debug_str size (133394).
|
/usr/sbin/mysqld(_ZN3THD5awakeE12killed_state+0xd1)[0x55b2d9d10edd]
|
addr2line: Dwarf Error: Offset (6516329) greater than or equal to .debug_str size (3950448).
|
sql/sql_class.h:4217(THD::awake(killed_state))[0x55b2d9eadba2]
|
addr2line: Dwarf Error: Offset (3106628) greater than or equal to .debug_str size (133394).
|
addr2line: Dwarf Error: Offset (3706458) greater than or equal to .debug_str size (133394).
|
addr2line: Dwarf Error: Offset (3242708) greater than or equal to .debug_str size (133394).
|
addr2line: Dwarf Error: Offset (3147785) greater than or equal to .debug_str size (133394).
|
addr2line: Dwarf Error: Offset (1862285386) greater than or equal to .debug_str size (3950448).
|
sql/wsrep_mysqld.cc:2765(wsrep_thd_awake)[0x55b2da0eb4ff]
|
addr2line: Dwarf Error: Offset (25509216) greater than or equal to .debug_str size (3950448).
|
handler/ha_innodb.cc:19783(_my_b_net_read)[0x55b2d9f2b31c]
|
sql/handler.cc:6327(ha_abort_transaction(THD*, THD*, char))[0x55b2d9eb8f78]
|
/usr/sbin/mysqld(_Z25wsrep_grant_mdl_exceptionP11MDL_contextP10MDL_ticketPK7MDL_key+0x5ca)[0x55b2d9eac0b8]
|
addr2line: Dwarf Error: Offset (18547037) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (6579297) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (6516329) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (905304431) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (18547037) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (29426177) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (18547037) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (18547037) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (1105195) greater than or equal to .debug_str size (133394).
|
addr2line: Dwarf Error: Offset (18547037) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (18547037) greater than or equal to .debug_str size (3950448).
|
/usr/sbin/mysqld(_ZNK8MDL_lock14can_grant_lockE13enum_mdl_typeP11MDL_contextb+0x13e)[0x55b2d9e451cc]
|
addr2line: Dwarf Error: Offset (659081290) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (648186430) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (3106628) greater than or equal to .debug_str size (133394).
|
addr2line: Dwarf Error: Offset (3106628) greater than or equal to .debug_str size (133394).
|
addr2line: Dwarf Error: Offset (2536309043) greater than or equal to .debug_str size (133394).
|
addr2line: Dwarf Error: Offset (949460372) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (497911297) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (1862355200) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Could not find abbrev number 3825.
|
addr2line: Dwarf Error: Offset (7173491) greater than or equal to .debug_str size (3950448).
|
sql/wsrep_thd.cc:829(wsrep_abort_thd(void*, void*, char))[0x55b2d9e463f9]
|
addr2line: Dwarf Error: Offset (1964447747) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (1964447747) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (1964447747) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (1684608003) greater than or equal to .debug_str size (3950448).
|
sql/wsrep_mysqld.cc:2062(wsrep_grant_mdl_exception(MDL_context*, MDL_ticket*, MDL_key const*))[0x55b2d9e46567]
|
addr2line: Dwarf Error: Offset (1201747494) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (1201747494) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (1201747494) greater than or equal to .debug_str size (3950448).
|
sql/mdl.cc:1592(MDL_lock::can_grant_lock(enum_mdl_type, MDL_context*, bool) const)[0x55b2d9e46c4e]
|
sql/mdl.cc:1923(MDL_context::try_acquire_lock_impl(MDL_request*, MDL_ticket**))[0x55b2d9cf2d8e]
|
sql/mdl.cc:2067(MDL_context::acquire_lock(MDL_request*, double))[0x55b2d9cf47d1]
|
sql/mdl.cc:2258(MDL_context::acquire_locks(I_P_List<MDL_request, I_P_List_adapter<MDL_request, &MDL_request::next_in_list, &MDL_request::prev_in_list>, I_P_List_counter, I_P_List_no_push_back<MDL_request> >*, double))[0x55b2d9cf59e4]
|
addr2line: Dwarf Error: Offset (950407281) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (31850752) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (2147683520) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (1201744920) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (2734883727) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (1201744920) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (2684553613) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (1201744921) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (2684553613) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (1201744921) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (6516329) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (6516329) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (6516329) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (2684553613) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (1201744921) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (2684553613) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (1201744921) greater than or equal to .debug_str size (3950448).
|
sql/sql_base.cc:3831(lock_table_names(THD*, DDL_options_st const&, TABLE_LIST*, TABLE_LIST*, unsigned long, unsigned int))[0x55b2d9de1491]
|
sql/sql_base.cc:4051(open_tables(THD*, DDL_options_st const&, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*))[0x55b2d9de27de]
|
sql/sql_base.cc:4880(open_and_lock_tables(THD*, DDL_options_st const&, TABLE_LIST*, bool, unsigned int, Prelocking_strategy*))[0x55b2d9d4f5af]
|
addr2line: Dwarf Error: Offset (3942842858) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (950407281) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (31850752) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (4211278330) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (4211278330) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (4194501786) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (2902655674) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (6516329) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (6516329) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (2634219970) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (1201747494) greater than or equal to .debug_str size (3950448).
|
sql/sql_base.h:500(mysql_create_table(THD*, TABLE_LIST*, Table_specification_st*, Alter_info*))[0x55b2d9d50c69]
|
sql/sql_table.cc:10984(Sql_cmd_create_table::execute(THD*))[0x55b2da030c47]
|
addr2line: Dwarf Error: Offset (7628147) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (3942842858) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (759668994) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (950407281) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (31850752) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (4211278330) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (759668994) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (4211278330) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (759668994) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (27362604) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (27362604) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (27362604) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (27362604) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (7628147) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (27362604) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (2542797623) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (2046831943) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (28542252) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (27362604) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (3242708) greater than or equal to .debug_str size (133394).
|
addr2line: Dwarf Error: Offset (3242708) greater than or equal to .debug_str size (133394).
|
addr2line: Dwarf Error: Offset (1684608003) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (2255815426) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (3106628) greater than or equal to .debug_str size (133394).
|
addr2line: Dwarf Error: Offset (3706458) greater than or equal to .debug_str size (133394).
|
addr2line: Dwarf Error: Offset (3242708) greater than or equal to .debug_str size (133394).
|
sql/sql_parse.cc:5994(mysql_execute_command(THD*))[0x55b2da03157a]
|
sql/sql_parse.cc:7764(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55b2d9caf98d]
|
sql/log_event.cc:5357(Query_log_event::do_apply_event(rpl_group_info*, char const*, unsigned int))[0x55b2d9cb5d83]
|
sql/log_event.cc:5036(Query_log_event::do_apply_event(rpl_group_info*))[0x55b2d9cb7839]
|
addr2line: Dwarf Error: Offset (950407281) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (31850752) greater than or equal to .debug_str size (3950448).
|
addr2line: Dwarf Error: Offset (25953132) greater than or equal to .debug_str size (133394).
|
addr2line: Dwarf Error: Offset (2967457) greater than or equal to .debug_str size (133394).
|
addr2line: Dwarf Error: Offset (25953132) greater than or equal to .debug_str size (133394).
|
addr2line: Dwarf Error: Offset (2967457) greater than or equal to .debug_str size (133394).
|
addr2line: Dwarf Error: Offset (25953132) greater than or equal to .debug_str size (133394).
|
addr2line: Dwarf Error: Offset (2967457) greater than or equal to .debug_str size (133394).
|
addr2line: Dwarf Error: Offset (25953132) greater than or equal to .debug_str size (133394).
|
addr2line: Dwarf Error: Offset (2967457) greater than or equal to .debug_str size (133394).
|
addr2line: Dwarf Error: Offset (2818769540) greater than or equal to .debug_str size (133394).
|
addr2line: Dwarf Error: Offset (759669114) greater than or equal to .debug_str size (133394).
|
addr2line: Dwarf Error: Offset (2818769540) greater than or equal to .debug_str size (133394).
|
addr2line: Dwarf Error: Offset (759669114) greater than or equal to .debug_str size (133394).
|
addr2line: Dwarf Error: Offset (2818769540) greater than or equal to .debug_str size (133394).
|
addr2line: Dwarf Error: Offset (759669114) greater than or equal to .debug_str size (133394).
|
addr2line: Dwarf Error: Offset (27919130) greater than or equal to .debug_str size (133394).
|
addr2line: Dwarf Error: Offset (2967457) greater than or equal to .debug_str size (133394).
|
addr2line: Dwarf Error: Offset (27919130) greater than or equal to .debug_str size (133394).
|
addr2line: Dwarf Error: Offset (2967457) greater than or equal to .debug_str size (133394).
|
addr2line: Dwarf Error: Offset (27919130) greater than or equal to .debug_str size (133394).
|
addr2line: Dwarf Error: Offset (2967457) greater than or equal to .debug_str size (133394).
|
sql/log_event.h:1454(Log_event::apply_event(rpl_group_info*))[0x55b2da530c36]
|
pthread_create.c:0(start_thread)[0x7ffb0bcc5e25]
|
/lib64/libc.so.6(clone+0x6d)[0x7ffb0a29c34d]
|
|
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0x55b2e06f5edb): CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB
|
|
|
Connection ID (thread ID): 17
|
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 https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains
|
information that should help you find out what is causing the crash.
|
Writing a core file...
|
Working directory at /dev/shm/var/2/mysqld.2/data
|
Resource Limits:
|
Limit Soft Limit Hard Limit Units
|
Max cpu time unlimited unlimited seconds
|
Max file size unlimited unlimited bytes
|
Max data size unlimited unlimited bytes
|
Max stack size 8388608 unlimited bytes
|
Max core file size unlimited unlimited bytes
|
Max resident set unlimited unlimited bytes
|
Max processes 4096 23142 processes
|
Max open files 1024 1024 files
|
Max locked memory 65536 65536 bytes
|
Max address space unlimited unlimited bytes
|
Max file locks unlimited unlimited locks
|
Max pending signals 23142 23142 signals
|
Max msgqueue size 819200 819200 bytes
|
Max nice priority 0 0
|
Max realtime priority 0 0
|
Max realtime timeout unlimited unlimited us
|
Core pattern: core
|
|
|
----------SERVER LOG END-------------
|
|
|
|
|
- found 'core.11463' (0/0)
|
|
|
Trying 'dbx' to get a backtrace
|
gdb not found, cannot get the stack trace
|
- deleting it, already saved 0
|
- saving '/dev/shm/var/2/log/galera.galera_as_slave-innodb/' to '/dev/shm/var/log/galera.galera_as_slave-innodb/'
|
|
Attachments
Issue Links
- relates to
-
-
- Closed
-
-
-
- Closed
-