2020-11-15 17:26:28 0 [Note] WSREP: Loading provider /usr/lib64/galera/libgalera_smm.so initial position: 0a3943f2-1ac3-11eb-97aa-92f74ede43ba:71661382 2020-11-15 17:26:28 0 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/galera/libgalera_smm.so' 2020-11-15 17:26:28 0 [Note] WSREP: wsrep_load(): Galera 26.4.6(r1d8d67c) by Codership Oy loaded successfully. 2020-11-15 17:26:28 0 [Note] WSREP: CRC-32C: using 64-bit x86 acceleration. 2020-11-15 17:26:28 0 [Note] WSREP: Found saved state: 0a3943f2-1ac3-11eb-97aa-92f74ede43ba:71661283, safe_to_bootstrap: 0 2020-11-15 17:26:28 0 [Note] WSREP: GCache DEBUG: opened preamble: Version: 0 UUID: 00000000-0000-0000-0000-000000000000 Seqno: -1 - -1 Offset: -1 Synced: 0 2020-11-15 17:26:28 0 [Note] WSREP: Skipped GCache ring buffer recovery: could not determine history UUID. 2020-11-15 17:26:28 0 [Note] WSREP: Passing config to GCS: base_dir = /data/mysql/; base_host = xxx.yyy.zzz.37; base_port = 4567; 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 = /data/mysql/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = galera.cache; gcache.page_size = 128M; gcache.recover = yes; gcache.size = 5G; 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.version = 0; pc.announce_timeout = PT3S; pc.checksum = false; 2020-11-15 17:26:28 0 [Note] WSREP: Service thread queue flushed. 2020-11-15 17:26:28 0 [Note] WSREP: ####### Assign initial position for certification: 0a3943f2-1ac3-11eb-97aa-92f74ede43ba:71661283, protocol version: -1 2020-11-15 17:26:28 0 [Note] WSREP: GCache history reset: 00000000-0000-0000-0000-000000000000:0 -> 0a3943f2-1ac3-11eb-97aa-92f74ede43ba:71661283 2020-11-15 17:26:28 0 [Note] WSREP: Start replication 2020-11-15 17:26:28 0 [Note] WSREP: Connecting with bootstrap option: 0 2020-11-15 17:26:28 0 [Note] WSREP: Setting GCS initial position to 0a3943f2-1ac3-11eb-97aa-92f74ede43ba:71661283 2020-11-15 17:26:28 0 [Note] WSREP: protonet asio version 0 2020-11-15 17:26:28 0 [Note] WSREP: Using CRC-32C for message checksums. 2020-11-15 17:26:28 0 [Note] WSREP: backend: asio 2020-11-15 17:26:28 0 [Note] WSREP: gcomm thread scheduling priority set to other:0 2020-11-15 17:26:28 0 [Warning] WSREP: access file(/data/mysql//gvwstate.dat) failed(No such file or directory) 2020-11-15 17:26:28 0 [Note] WSREP: restore pc from disk failed 2020-11-15 17:26:28 0 [Note] WSREP: GMCast version 0 2020-11-15 17:26:28 0 [Note] WSREP: (5020dec6-a50a, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567 2020-11-15 17:26:28 0 [Note] WSREP: (5020dec6-a50a, 'tcp://0.0.0.0:4567') multicast: , ttl: 1 2020-11-15 17:26:28 0 [Note] WSREP: EVS version 1 2020-11-15 17:26:28 0 [Note] WSREP: gcomm: connecting to group 'cluster_name', peer 'xxx.yyy.zzz.35:,xxx.yyy.zzz.36:,xxx.yyy.zzz.37:' 2020-11-15 17:26:28 0 [Note] WSREP: (5020dec6-a50a, 'tcp://0.0.0.0:4567') Found matching local endpoint for a connection, blacklisting address tcp://xxx.yyy.zzz.37:4567 2020-11-15 17:26:28 0 [Note] WSREP: (5020dec6-a50a, 'tcp://0.0.0.0:4567') connection established to 96cf1e44-a1c7 tcp://xxx.yyy.zzz.36:4567 2020-11-15 17:26:28 0 [Note] WSREP: (5020dec6-a50a, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: 2020-11-15 17:26:28 0 [Note] WSREP: EVS version upgrade 0 -> 1 2020-11-15 17:26:28 0 [Note] WSREP: declaring 96cf1e44-a1c7 at tcp://xxx.yyy.zzz.36:4567 stable 2020-11-15 17:26:28 0 [Note] WSREP: PC protocol upgrade 0 -> 1 2020-11-15 17:26:28 0 [Note] WSREP: Node 96cf1e44-a1c7 state prim 2020-11-15 17:26:28 0 [Note] WSREP: view(view_id(PRIM,5020dec6-a50a,2) memb { 5020dec6-a50a,0 96cf1e44-a1c7,0 } joined { } left { } partitioned { }) 2020-11-15 17:26:28 0 [Note] WSREP: save pc into disk 2020-11-15 17:26:28 0 [Note] WSREP: discarding pending addr without UUID: tcp://xxx.yyy.zzz.35:4567 2020-11-15 17:26:28 0 [Note] WSREP: gcomm: connected 2020-11-15 17:26:28 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636 2020-11-15 17:26:28 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) 2020-11-15 17:26:28 0 [Note] WSREP: Opened channel 'cluster_name' 2020-11-15 17:26:28 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 2 2020-11-15 17:26:28 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 506df906-275f-11eb-b1b9-879cc16c6581 2020-11-15 17:26:28 1 [Note] WSREP: Starting rollbacker thread 1 2020-11-15 17:26:28 2 [Note] WSREP: Starting applier thread 2 2020-11-15 17:26:28 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 506df906-275f-11eb-b1b9-879cc16c6581 2020-11-15 17:26:28 0 [Warning] WSREP: Action message in non-primary configuration from member 1 2020-11-15 17:26:28 0 [Note] WSREP: STATE EXCHANGE: got state msg: 506df906-275f-11eb-b1b9-879cc16c6581 from 0 (node37) 2020-11-15 17:26:28 0 [Note] WSREP: STATE EXCHANGE: got state msg: 506df906-275f-11eb-b1b9-879cc16c6581 from 1 (node36) 2020-11-15 17:26:28 0 [Note] WSREP: Quorum results: version = 6, component = PRIMARY, conf_id = 1, members = 1/2 (joined/total), act_id = 71698496, last_appl. = 71698451, protocols = 2/10/4 (gcs/repl/appl), vote policy= 0, group UUID = 0a3943f2-1ac3-11eb-97aa-92f74ede43ba 2020-11-15 17:26:28 0 [Note] WSREP: Flow-control interval: [23, 23] 2020-11-15 17:26:28 0 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 71698497) 2020-11-15 17:26:28 2 [Note] WSREP: ####### processing CC 71698497, local, ordered 2020-11-15 17:26:28 2 [Note] WSREP: Process first view: 0a3943f2-1ac3-11eb-97aa-92f74ede43ba my uuid: 5020dec6-275f-11eb-a50a-f335a93b4aed 2020-11-15 17:26:28 2 [Note] WSREP: Server node37 connected to cluster at position 0a3943f2-1ac3-11eb-97aa-92f74ede43ba:71698497 with ID 5020dec6-275f-11eb-a50a-f335a93b4aed 2020-11-15 17:26:28 2 [Note] WSREP: Server status change disconnected -> connected 2020-11-15 17:26:28 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-11-15 17:26:28 2 [Note] WSREP: ####### My UUID: 5020dec6-275f-11eb-a50a-f335a93b4aed 2020-11-15 17:26:28 2 [Note] WSREP: Cert index reset to 00000000-0000-0000-0000-000000000000:-1 (proto: 10), state transfer needed: yes 2020-11-15 17:26:28 0 [Note] WSREP: Service thread queue flushed. 2020-11-15 17:26:28 2 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:-1, protocol version: -1 2020-11-15 17:26:28 2 [Note] WSREP: State transfer required: Group state: 0a3943f2-1ac3-11eb-97aa-92f74ede43ba:71698497 Local state: 0a3943f2-1ac3-11eb-97aa-92f74ede43ba:71661283 2020-11-15 17:26:28 2 [Note] WSREP: Server status change connected -> joiner 2020-11-15 17:26:28 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-11-15 17:26:28 0 [Note] WSREP: Joiner monitor thread started to monitor 2020-11-15 17:26:28 0 [Note] WSREP: Running: 'wsrep_sst_mariabackup --role 'joiner' --address 'xxx.yyy.zzz.37' --datadir '/data/mysql/' --parent '3507' --binlog '/data/mysql/master-bin' --mysqld-args --wsrep_start_position=0a3943f2-1ac3-11eb-97aa-92f74ede43ba:71661382' WSREP_SST: [INFO] Streaming with xbstream (20201115 17:26:29.200) WSREP_SST: [INFO] Using socat as streamer (20201115 17:26:29.202) WSREP_SST: [INFO] Evaluating timeout -k 310 300 socat -u TCP-LISTEN:4444,reuseaddr stdio | mbstream -x; RC=( ${PIPESTATUS[@]} ) (20201115 17:26:29.240) 2020-11-15 17:26:29 2 [Note] WSREP: Prepared SST request: mariabackup|xxx.yyy.zzz.37:4444/xtrabackup_sst//1 2020-11-15 17:26:29 2 [Note] WSREP: ####### IST uuid:0a3943f2-1ac3-11eb-97aa-92f74ede43ba f: 71661284, l: 71698497, STRv: 3 2020-11-15 17:26:29 2 [Note] WSREP: IST receiver addr using tcp://xxx.yyy.zzz.37:4568 2020-11-15 17:26:29 2 [Note] WSREP: Prepared IST receiver for 71661284-71698497, listening at: tcp://xxx.yyy.zzz.37:4568 2020-11-15 17:26:29 0 [Note] WSREP: Member 0.0 (node37) requested state transfer from 'node36'. Selected 1.0 (node36)(SYNCED) as donor. 2020-11-15 17:26:29 0 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 71698507) 2020-11-15 17:26:29 2 [Note] WSREP: Requesting state transfer: success, donor: 1 2020-11-15 17:26:29 0 [Note] WSREP: 1.0 (node36): State transfer to 0.0 (node37) complete. 2020-11-15 17:26:29 0 [Note] WSREP: Member 1.0 (node36) synced with group. WSREP_SST: [INFO] xtrabackup_ist received from donor: Running IST (20201115 17:26:29.995) WSREP_SST: [INFO] Galera co-ords from recovery: 0a3943f2-1ac3-11eb-97aa-92f74ede43ba:71661283 1 (20201115 17:26:29.999) WSREP_SST: [INFO] Total time on joiner: 0 seconds (20201115 17:26:30.002) WSREP_SST: [INFO] Removing the sst_in_progress file (20201115 17:26:30.004) 2020-11-15 17:26:30 3 [Note] WSREP: SST received 2020-11-15 17:26:30 3 [Note] WSREP: Server status change joiner -> initializing 2020-11-15 17:26:30 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-11-15 17:26:30 0 [Note] InnoDB: Using Linux native AIO 2020-11-15 17:26:30 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2020-11-15 17:26:30 0 [Note] InnoDB: Uses event mutexes 2020-11-15 17:26:30 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 2020-11-15 17:26:30 0 [Note] InnoDB: Number of pools: 1 2020-11-15 17:26:30 0 [Note] InnoDB: Using SSE2 crc32 instructions 2020-11-15 17:26:30 0 [Note] InnoDB: Initializing buffer pool, total size = 64G, instances = 8, chunk size = 128M 2020-11-15 17:26:31 0 [Note] WSREP: (5020dec6-a50a, 'tcp://0.0.0.0:4567') turning message relay requesting off 2020-11-15 17:26:32 0 [Note] InnoDB: Completed initialization of buffer pool 2020-11-15 17:26:32 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2020-11-15 17:26:33 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 4294967296 bytes 2020-11-15 17:26:33 0 [Note] InnoDB: Setting log file ./ib_logfile1 size to 4294967296 bytes 2020-11-15 17:26:33 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2020-11-15 17:26:33 0 [Note] InnoDB: New log files created, LSN=11344212187271 2020-11-15 17:26:37 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2020-11-15 17:26:37 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2020-11-15 17:26:37 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2020-11-15 17:26:37 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2020-11-15 17:26:37 0 [Note] InnoDB: Waiting for purge to start 2020-11-15 17:26:37 0 [Note] InnoDB: 10.4.17 started; log sequence number 11344212187660; transaction id 34214436014 2020-11-15 17:26:37 0 [Note] InnoDB: Loading buffer pool(s) from /data/mysql/ib_buffer_pool 2020-11-15 17:26:37 0 [Note] Plugin 'FEEDBACK' is disabled. 2020-11-15 17:26:37 0 [ERROR] mysqld: Plugin 'unix_socket' already installed 2020-11-15 17:26:37 0 [Note] Server socket created on IP: '::'. 2020-11-15 17:26:37 0 [Note] WSREP: wsrep_init_schema_and_SR (nil) 2020-11-15 17:26:37 0 [Note] WSREP: Server initialized 2020-11-15 17:26:37 0 [Note] WSREP: Server status change initializing -> initialized 2020-11-15 17:26:37 0 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-11-15 17:26:37 3 [Note] WSREP: Server status change initialized -> joined 2020-11-15 17:26:37 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-11-15 17:26:37 3 [Note] WSREP: Recovered position from storage: 0a3943f2-1ac3-11eb-97aa-92f74ede43ba:71661382 2020-11-15 17:26:37 15 [Note] WSREP: Starting applier thread 15 2020-11-15 17:26:37 18 [Note] WSREP: Starting applier thread 18 2020-11-15 17:26:37 32 [Note] WSREP: Starting applier thread 32 2020-11-15 17:26:37 38 [Note] WSREP: Starting applier thread 38 2020-11-15 17:26:37 43 [Note] WSREP: Starting applier thread 43 2020-11-15 17:26:37 47 [Note] WSREP: Starting applier thread 47 2020-11-15 17:26:37 31 [Note] WSREP: Starting applier thread 31 2020-11-15 17:26:37 39 [Note] WSREP: Starting applier thread 39 2020-11-15 17:26:37 11 [Note] WSREP: Starting applier thread 11 2020-11-15 17:26:37 21 [Note] WSREP: Starting applier thread 21 2020-11-15 17:26:37 44 [Note] WSREP: Starting applier thread 44 2020-11-15 17:26:37 34 [Note] WSREP: Starting applier thread 34 2020-11-15 17:26:37 36 [Note] WSREP: Starting applier thread 36 2020-11-15 17:26:37 20 [Note] WSREP: Starting applier thread 20 2020-11-15 17:26:37 30 [Note] WSREP: Starting applier thread 30 2020-11-15 17:26:37 14 [Note] WSREP: Starting applier thread 14 2020-11-15 17:26:37 27 [Note] WSREP: Starting applier thread 27 2020-11-15 17:26:37 33 [Note] WSREP: Starting applier thread 33 2020-11-15 17:26:37 19 [Note] WSREP: Starting applier thread 19 2020-11-15 17:26:37 45 [Note] WSREP: Starting applier thread 45 2020-11-15 17:26:37 23 [Note] WSREP: Starting applier thread 23 2020-11-15 17:26:37 48 [Note] WSREP: Starting applier thread 48 2020-11-15 17:26:37 40 [Note] WSREP: Starting applier thread 40 2020-11-15 17:26:37 24 [Note] WSREP: Starting applier thread 24 2020-11-15 17:26:37 35 [Note] WSREP: Starting applier thread 35 2020-11-15 17:26:37 41 [Note] WSREP: Starting applier thread 41 2020-11-15 17:26:37 16 [Note] WSREP: Starting applier thread 16 2020-11-15 17:26:37 13 [Note] WSREP: Starting applier thread 13 2020-11-15 17:26:37 37 [Note] WSREP: Starting applier thread 37 2020-11-15 17:26:37 22 [Note] WSREP: Starting applier thread 22 2020-11-15 17:26:37 28 [Note] WSREP: Starting applier thread 28 2020-11-15 17:26:37 25 [Note] WSREP: Starting applier thread 25 2020-11-15 17:26:37 12 [Note] WSREP: Starting applier thread 12 2020-11-15 17:26:37 26 [Note] WSREP: Starting applier thread 26 2020-11-15 17:26:37 17 [Note] WSREP: Starting applier thread 17 2020-11-15 17:26:37 42 [Note] WSREP: Starting applier thread 42 2020-11-15 17:26:37 46 [Note] WSREP: Starting applier thread 46 2020-11-15 17:26:37 49 [Note] WSREP: Starting applier thread 49 2020-11-15 17:26:37 29 [Note] WSREP: Starting applier thread 29 2020-11-15 17:26:37 3 [Note] WSREP: Recovered view from SST: id: 0a3943f2-1ac3-11eb-97aa-92f74ede43ba:65281020 status: primary protocol_version: 4 capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO final: no own_index: -1 members(1): 0: 96cf1e44-25ef-11eb-a1c7-62c2487e624e, node36 2020-11-15 17:26:37 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-11-15 17:26:37 51 [Note] WSREP: Recovered cluster id 0a3943f2-1ac3-11eb-97aa-92f74ede43ba 2020-11-15 17:26:38 0 [Note] Reading of all Master_info entries succeeded 2020-11-15 17:26:38 0 [Note] Added new Master_info '' to hash table 2020-11-15 17:26:38 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.4.17-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2020-11-15 17:26:38 3 [Note] WSREP: SST received: 0a3943f2-1ac3-11eb-97aa-92f74ede43ba:71661382 2020-11-15 17:26:38 0 [Note] WSREP: Joiner monitor thread ended with total time 10 sec 2020-11-15 17:26:38 2 [Note] WSREP: Resetting GCache seqno map due to seqno gap: 71661283..71661382 2020-11-15 17:26:38 2 [Note] WSREP: GCache history reset: 0a3943f2-1ac3-11eb-97aa-92f74ede43ba:0 -> 0a3943f2-1ac3-11eb-97aa-92f74ede43ba:71661382 2020-11-15 17:26:38 2 [Note] WSREP: Installed new state from SST: 0a3943f2-1ac3-11eb-97aa-92f74ede43ba:71661382 2020-11-15 17:26:38 2 [Note] WSREP: Receiving IST: 37115 writesets, seqnos 71661383-71698497 2020-11-15 17:26:38 0 [Note] WSREP: ####### IST applying starts with 71661383 2020-11-15 17:26:38 0 [Note] WSREP: ####### IST current seqno initialized to 71661284 2020-11-15 17:26:38 0 [Note] WSREP: Receiving IST... 0.0% ( 0/37214 events) complete. 2020-11-15 17:26:38 0 [Note] WSREP: Service thread queue flushed. 2020-11-15 17:26:38 0 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:71661382, protocol version: 5 2020-11-15 17:26:38 0 [Note] WSREP: IST preload starting at 71698452 2020-11-15 17:26:43 42 [ERROR] InnoDB: Conflicting lock on table: `web`.`locations` index: unique_locations that has lock RECORD LOCKS space id 32369 page no 588896 n bits 744 index unique_locations of table `web`.`locations` trx id 34214445724 lock_mode X locks rec but not gap Record lock, heap no 674 PHYSICAL RECORD: n_fields 3; compact format; info bits 0 0: len 4; hex 000087f6; asc ;; 1: len 5; hex 99a7df021c; asc ;; 2: len 4; hex 06052ba3; asc + ;; 2020-11-15 17:26:43 42 [ERROR] InnoDB: WSREP state: 2020-11-15 17:26:43 42 [ERROR] WSREP: Thread BF trx_id: 34214445731 thread: 42 seqno: 71665992 client_state: exec client_mode: high priority transaction_mode: executing applier: 1 toi: 0 local: 0 query: INSERT INTO locations ( pointer_id, km_offset, timestamp_from, timestamp_to, lat, lon, car_id, uicstation_id, position_count, utilized, km, delta_km) VALUES (9842,(SELECT current_km_offset FROM cars WHERE id=34806),'2020-11-15 10:59:14.0','2020-11-15 10:59:14.0','47.81687','13.063665',34806,'42494','1',1,33735,GREATEST(0,(SELECT ROUND(33735) - IFNULL(MAX(km),0) FROM (SELECT km FROM locations WHERE timestamp_from < '2020-11-15 10:59:14.0' AND car_id=34806 ORDER BY timestamp_from DESC LIMIT 1) x)))¥R±_ 2020-11-15 17:26:43 42 [ERROR] WSREP: Thread BF trx_id: 34214445724 thread: 21 seqno: 71666008 client_state: exec client_mode: high priority transaction_mode: committing applier: 1 toi: 0 local: 0 query: NULL 2020-11-15 17:26:43 0x7f5998762700 InnoDB: Assertion failure in file /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.17/storage/innobase/lock/lock0lock.cc line 687 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to https://jira.mariadb.org/ 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: https://mariadb.com/kb/en/library/innodb-recovery-modes/ InnoDB: about forcing recovery. 201115 17:26:43 [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.4.17-MariaDB-log key_buffer_size=134217728 read_buffer_size=131072 max_used_connections=0 max_threads=302 thread_count=48 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 795659 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7f58680009a8 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 = 0x7f5998761d20 thread_stack 0x49000 /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x56287e722ffe] /usr/sbin/mysqld(handle_fatal_signal+0x30f)[0x56287e1b49ef] sigaction.c:0(__restore_rt)[0x7f6b7556f6d0] :0(__GI_raise)[0x7f6b73843277] :0(__GI_abort)[0x7f6b73844968] /usr/sbin/mysqld(+0x5c2de8)[0x56287deacde8] /usr/sbin/mysqld(+0xaba93a)[0x56287e3a493a] /usr/sbin/mysqld(+0xabc144)[0x56287e3a6144] /usr/sbin/mysqld(+0xac3a30)[0x56287e3ada30] /usr/sbin/mysqld(+0xac3f23)[0x56287e3adf23] /usr/sbin/mysqld(+0xb2fe69)[0x56287e419e69] /usr/sbin/mysqld(+0xb30cd3)[0x56287e41acd3] /usr/sbin/mysqld(+0xb311a3)[0x56287e41b1a3] /usr/sbin/mysqld(+0xb4370f)[0x56287e42d70f] /usr/sbin/mysqld(+0xa83235)[0x56287e36d235] /usr/sbin/mysqld(_ZN7handler12ha_write_rowEPKh+0x2d0)[0x56287e1c02f0] /usr/sbin/mysqld(_ZN14Rows_log_event9write_rowEP14rpl_group_infob+0x235)[0x56287e2bc8c5] /usr/sbin/mysqld(_ZN20Write_rows_log_event11do_exec_rowEP14rpl_group_info+0x7d)[0x56287e2bcd2d] /usr/sbin/mysqld(_ZN14Rows_log_event14do_apply_eventEP14rpl_group_info+0x2dc)[0x56287e2b0cfc] /usr/sbin/mysqld(_Z18wsrep_apply_eventsP3THDP14Relay_log_infoPKvm+0x23d)[0x56287e126edd] /usr/sbin/mysqld(_ZN21Wsrep_applier_service15apply_write_setERKN5wsrep7ws_metaERKNS0_12const_bufferERNS0_14mutable_bufferE+0x9d)[0x56287e11275d] /usr/sbin/mysqld(+0xecf3cf)[0x56287e7b93cf] /usr/sbin/mysqld(_ZN5wsrep12server_state8on_applyERNS_21high_priority_serviceERKNS_9ws_handleERKNS_7ws_metaERKNS_12const_bufferE+0xf5)[0x56287e7b9ef5] /usr/sbin/mysqld(+0xee6de8)[0x56287e7d0de8] /usr/lib64/galera/libgalera_smm.so(+0x167560)[0x7f6b6bb30560] src/trx_handle.cpp:387(galera::TrxHandleSlave::apply(void*, wsrep_cb_status (*)(void*, wsrep_ws_handle const*, unsigned int, wsrep_buf const*, wsrep_trx_meta const*, bool*), wsrep_trx_meta const&, bool&))[0x7f6b6bb6849a] src/replicator_smm.cpp:504(galera::ReplicatorSMM::apply_trx(void*, galera::TrxHandleSlave&))[0x7f6b6bb7a447] src/gu_logger.hpp:96(gu::Logger::no_log(gu::LogLevel))[0x7f6b6bb7a9ef] src/replicator_str.cpp:1155(galera::ReplicatorSMM::recv_IST(void*))[0x7f6b6bb6e804] src/replicator_smm.cpp:396(galera::ReplicatorSMM::async_recv(void*))[0x7f6b6bb80f38] /usr/sbin/mysqld(_ZN5wsrep18wsrep_provider_v2611run_applierEPNS_21high_priority_serviceE+0xe)[0x56287e7d1c8e] /usr/sbin/mysqld(+0x83e9f2)[0x56287e1289f2] /usr/sbin/mysqld(_Z15start_wsrep_THDPv+0x35d)[0x56287e11cd3d] pthread_create.c:0(start_thread)[0x7f6b75567e25] /lib64/libc.so.6(clone+0x6d)[0x7f6b7390bbad] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7f6a2c02c93b): INSERT INTO locations ( pointer_id, km_offset, timestamp_from, timestamp_to, lat, lon, car_id, uicstation_id, position_count, utilized, km, delta_km) VALUES (9842,(SELECT current_km_offset FROM cars WHERE id=34806),'2020-11-15 10:59:14.0','2020-11-15 10:59:14.0','47.81687','13.063665',34806,'42494','1',1,33735,GREATEST(0,(SELECT ROUND(33735) - IFNULL(MAX(km),0) FROM (SELECT km FROM locations WHERE timestamp_from < '2020-11-15 10:59:14.0' AND car_id=34806 ORDER BY timestamp_from DESC LIMIT 1) x))) Connection ID (thread ID): 42 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=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on,rowid_filter=on,condition_pushdown_from_having=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 /data/mysql 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 0 unlimited bytes Max resident set unlimited unlimited bytes Max processes 514253 514253 processes Max open files 300000 300000 files Max locked memory 65536 65536 bytes Max address space unlimited unlimited bytes Max file locks unlimited unlimited locks Max pending signals 514253 514253 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: |/usr/libexec/abrt-hook-ccpp %s %c %p %u %g %t e %P %I %h