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

innodb crashes on large update and it gets corrupted

    XMLWordPrintable

Details

    Description

      CREATE TABLE npadata (
        state varchar(2) NOT NULL DEFAULT '??',
        company varchar(30) DEFAULT NULL,
        ocn varchar(4) NOT NULL DEFAULT 'N/A',
        prefix_type varchar(10) DEFAULT NULL,
        ratecenter varchar(40) DEFAULT NULL,
        clli varchar(20) DEFAULT NULL,
        lata varchar(5) DEFAULT NULL,
        country varchar(2) DEFAULT NULL,
        wireless tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
        did bigint(20) UNSIGNED NOT NULL,
        lrn bigint(20) UNSIGNED DEFAULT NULL,
        port_type tinyint(4) UNSIGNED DEFAULT NULL,
        dnc tinyint(4) UNSIGNED DEFAULT NULL,
        reachable tinyint(4) UNSIGNED DEFAULT NULL,
        npa varchar(3) DEFAULT NULL,
        nxx varchar(3) DEFAULT NULL,
        xxxx varchar(4) DEFAULT NULL,
        tested tinyint(1) DEFAULT 0,
        lastchange date NOT NULL DEFAULT 'curdate()',
        PRIMARY KEY (did)
      )
      ALTER TABLE npadata
      ADD INDEX IDX_npadata3 (reachable, tested);
      

      I was executing:

      update npadata set tested=0, reachable=0 where reachable=1 or tested=1;


      and MariaDB crashed. When it restared this was in the log. I have no idea how to get my data working again. The table has 1.97BN records.

      2019-02-16 18:47:42 0 [ERROR] mysqld: Plugin 'ROCKSDB' already installed
      2019-02-16 18:47:42 0 [ERROR] mysqld: Plugin 'ROCKSDB_CFSTATS' already installed
      2019-02-16 18:47:42 0 [ERROR] mysqld: Plugin 'ROCKSDB_DBSTATS' already installed
      2019-02-16 18:47:42 0 [ERROR] mysqld: Plugin 'ROCKSDB_PERF_CONTEXT' already installed
      2019-02-16 18:47:42 0 [ERROR] mysqld: Plugin 'ROCKSDB_PERF_CONTEXT_GLOBAL' already installed
      2019-02-16 18:47:42 0 [ERROR] mysqld: Plugin 'ROCKSDB_CF_OPTIONS' already installed
      2019-02-16 18:47:42 0 [ERROR] mysqld: Plugin 'ROCKSDB_COMPACTION_STATS' already installed
      2019-02-16 18:47:42 0 [ERROR] mysqld: Plugin 'ROCKSDB_GLOBAL_INFO' already installed
      2019-02-16 18:47:42 0 [ERROR] mysqld: Plugin 'ROCKSDB_DDL' already installed
      2019-02-16 18:47:42 0 [ERROR] mysqld: Plugin 'ROCKSDB_SST_PROPS' already installed
      2019-02-16 18:47:42 0 [ERROR] mysqld: Plugin 'ROCKSDB_INDEX_FILE_MAP' already installed
      2019-02-16 18:47:42 0 [ERROR] mysqld: Plugin 'ROCKSDB_LOCKS' already installed
      2019-02-16 18:47:42 0 [ERROR] mysqld: Plugin 'ROCKSDB_TRX' already installed
      2019-02-16 18:47:42 0 [ERROR] mysqld: Plugin 'ROCKSDB_DEADLOCK' already installed
      2019-02-16 18:47:42 0 [Note] RocksDB: 2 column families found
      2019-02-16 18:47:42 0 [Note] RocksDB: Column Families at start:
      2019-02-16 18:47:42 0 [Note]   cf=default
      2019-02-16 18:47:42 0 [Note]     write_buffer_size=268435456
      2019-02-16 18:47:42 0 [Note]     target_file_size_base=33554432
      2019-02-16 18:47:42 0 [Note]   cf=__system__
      2019-02-16 18:47:42 0 [Note]     write_buffer_size=268435456
      2019-02-16 18:47:42 0 [Note]     target_file_size_base=33554432
      2019-02-16 18:47:42 0 [Note] RocksDB: Table_store: loaded DDL data for 1 tables
      2019-02-16 18:47:42 0 [Note] RocksDB: global statistics using get_sched_indexer_t indexer
      2019-02-16 18:47:42 0 [Note] MyRocks storage engine plugin has been successfully initialized.
      2019-02-16 18:47:42 0 [Note] InnoDB: Using Linux native AIO
      2019-02-16 18:47:42 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
      2019-02-16 18:47:42 0 [Note] InnoDB: Uses event mutexes
      2019-02-16 18:47:42 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
      2019-02-16 18:47:42 0 [Note] InnoDB: Number of pools: 1
      2019-02-16 18:47:42 0 [Note] InnoDB: Using SSE2 crc32 instructions
      2019-02-16 18:47:42 0 [Note] InnoDB: Initializing buffer pool, total size = 15G, instances = 8, chunk size = 128M
      2019-02-16 18:48:13 0 [Note] InnoDB: Completed initialization of buffer pool
      2019-02-16 18:48:13 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
      2019-02-16 18:48:13 0 [ERROR] InnoDB: Invalid redo log header checksum.
      2019-02-16 18:48:13 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
      2019-02-16 18:48:13 0 [Note] InnoDB: Starting shutdown...
      2019-02-16 18:48:14 0 [Warning] InnoDB: Failed to set memory to DODUMP: Invalid argument ptr 0x7fc2c0000000 size 134217728
      2019-02-16 18:48:14 0 [Warning] InnoDB: Failed to set memory to DODUMP: Invalid argument ptr 0x7fc280000000 size 2097152
      2019-02-16 18:48:16 0 [ERROR] Plugin 'InnoDB' init function returned error.
      2019-02-16 18:48:16 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
      2019-02-16 18:48:16 0 [Note] Plugin 'FEEDBACK' is disabled.
      2019-02-16 18:48:16 0 [ERROR] Unknown/unsupported storage engine: innodb
      2019-02-16 18:48:16 0 [ERROR] Aborting
      

      Attachments

        Issue Links

          Activity

            People

              marko Marko Mäkelä
              philip_38 Philip orleans
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.