Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-17766

Mariadb fails when the table is deleted (Internal MariaDB error code: 1146)

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • 10.3.10
    • N/A
    • Galera
    • 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?

      Attachments

        Activity

          People

            jplindst Jan Lindström (Inactive)
            Fišer Dominik Fišer
            Votes:
            2 Vote for this issue
            Watchers:
            7 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.