Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
10.3.12
-
Ubuntu
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
- relates to
-
MDEV-13542 Crashing on a corrupted page is unhelpful
- Closed
-
MDEV-14425 Change the InnoDB redo log format to reduce write amplification
- Closed
-
MDEV-27449 Database crashes on startup InnoDB: Assertion failure in file ./storage/innobase/btr/btr0cur.cc line 297
- Closed