Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
10.3.10
-
Debian GNU/Linux 9.5 (stretch), galera cluster (wsrep_provider_version 25.3.24(r3825)), mariabackup
Description
We have a problem after upgrade to Mariadb 10.3.10 (from 10.2). We are deleting all tables in database each hour (it's demo database) and importing same tables again. Every few days mariadb fails totally. We are using galera cluster with mariabackup. One node failed.
Table schema is:
CREATE TABLE `shopio_vouchers_products` (
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
`vouchers_id` int(10) NOT NULL,
|
`products_id` int(10) NOT NULL,
|
PRIMARY KEY (`id`),
|
UNIQUE KEY `unique_ids` (`vouchers_id`,`products_id`),
|
KEY `products_id` (`products_id`),
|
CONSTRAINT `shopio_vouchers_products_ibfk_1` FOREIGN KEY (`products_id`) REFERENCES `shopio_products` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
CONSTRAINT `shopio_vouchers_products_ibfk_2` FOREIGN KEY (`vouchers_id`) REFERENCES `shopio_vouchers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
See log detail:
lis 19 00:00:11 server mysqld[26688]: 2018-11-19 0:00:11 14 [Warning] WSREP: BF applier failed to open_and_lock_tables: 1146, fatal: 0 wsrep = (exec_mode: 1 conflict_state: 0 seqno: 1876588494)
|
lis 19 00:00:11 server mysqld[26688]: 2018-11-19 0:00:11 14 [ERROR] Slave SQL: Error executing row event: 'Table 's_demo.shopio_vouchers_products' doesn't exist', Internal MariaDB error code: 1146
|
lis 19 00:00:11 server mysqld[26688]: 2018-11-19 0:00:11 14 [Warning] WSREP: RBR event 23 Update_rows_v1 apply warning: 1146, 1876588494
|
lis 19 00:00:11 server mysqld[26688]: 2018-11-19 0:00:11 14 [Warning] WSREP: Failed to apply app buffer: seqno: 1876588494, status: 1
|
lis 19 00:00:11 server mysqld[26688]: at galera/src/trx_handle.cpp:apply():353
|
lis 19 00:00:11 server mysqld[26688]: Retrying 2th time
|
lis 19 00:00:11 server mysqld[26688]: 2018-11-19 0:00:11 14 [Warning] WSREP: BF applier failed to open_and_lock_tables: 1146, fatal: 0 wsrep = (exec_mode: 1 conflict_state: 0 seqno: 1876588494)
|
lis 19 00:00:11 server mysqld[26688]: 2018-11-19 0:00:11 14 [ERROR] Slave SQL: Error executing row event: 'Table 's_demo.shopio_vouchers_products' doesn't exist', Internal MariaDB error code: 1146
|
lis 19 00:00:11 server mysqld[26688]: 2018-11-19 0:00:11 14 [Warning] WSREP: RBR event 23 Update_rows_v1 apply warning: 1146, 1876588494
|
lis 19 00:00:11 server mysqld[26688]: 2018-11-19 0:00:11 14 [Warning] WSREP: Failed to apply app buffer: seqno: 1876588494, status: 1
|
lis 19 00:00:11 server mysqld[26688]: at galera/src/trx_handle.cpp:apply():353
|
lis 19 00:00:11 server mysqld[26688]: Retrying 3th time
|
lis 19 00:00:11 server mysqld[26688]: 2018-11-19 0:00:11 14 [Warning] WSREP: BF applier failed to open_and_lock_tables: 1146, fatal: 0 wsrep = (exec_mode: 1 conflict_state: 0 seqno: 1876588494)
|
lis 19 00:00:11 server mysqld[26688]: 2018-11-19 0:00:11 14 [ERROR] Slave SQL: Error executing row event: 'Table 's_demo.shopio_vouchers_products' doesn't exist', Internal MariaDB error code: 1146
|
lis 19 00:00:11 server mysqld[26688]: 2018-11-19 0:00:11 14 [Warning] WSREP: RBR event 23 Update_rows_v1 apply warning: 1146, 1876588494
|
lis 19 00:00:12 server systemd[1]: mariadb.service: Main process exited, code=killed, status=6/ABRT
|
lis 19 00:00:12 server systemd[1]: mariadb.service: Unit entered failed state.
|
lis 19 00:00:12 server systemd[1]: mariadb.service: Failed with result 'signal'.
|
Any ideas what could be wrong?