[MDEV-14019] Spider + binlog_format = ROW => CRASH - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: 10.2(EOL)
Fix Version/s: 10.2.14, 10.3.6
Component/s: Replication, Storage Engine - Spider
Labels:
None

Sprint:
10.2.12, 10.2.14

Description

When we create a table spider with binlog format = ROW (in local)

MySQL server has gone away

create many :

CREATE TABLE IF NOT EXISTS `master_value_double__62` (

  `id` int(20) NOT NULL AUTO_INCREMENT,

  `id_mysql_server` int(11) NOT NULL,

  `id_master_name` int(11) NOT NULL,

  `date` datetime NOT NULL,

  `value` double NOT NULL,

  PRIMARY KEY (`id`),

  UNIQUE KEY `id_mysql_server_62` (`id_mysql_server`,`id_master_name`,`date`),

  KEY `id_mysql_server__62` (`id_mysql_server`,`id_master_name`),

  KEY `date_62` (`date`,`id_mysql_server`,`id_master_name`),

  KEY `id_master_name__62` (`id_master_name`)

) ENGINE=ROCKSDB AUTO_INCREMENT=0 DEFAULT CHARSET=latin1;

create table spider :

CREATE TABLE IF NOT EXISTS `slave_value_int` (

`id_mysql_replication_thread` int(11) NOT NULL,

`id_slave_name` int(11) NOT NULL,

`date` datetime NOT NULL,

`value` bigint(20) unsigned NOT NULL,

PRIMARY KEY `id_mysql_replication_thread_slave_int` (`id_mysql_replication_thread`,`id_slave_name`,`date`),

KEY `id_mysql_replication_thread_slave__int` (`id_mysql_replication_thread`,`id_slave_name`),

KEY `date_int_slave` (`date`,`id_mysql_replication_thread`,`id_slave_name`),

KEY `id_slave_name_slave_int` (`id_slave_name`) )   DEFAULT CHARSET=latin1  ENGINE=SPIDER COMMENT='wrapper "mysql"'  PARTITION BY LIST (`id_mysql_replication_thread`)

     PARTITION pt1 VALUES IN (1) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__1"' ENGINE = SPIDER,

     PARTITION pt2 VALUES IN (2) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__2"' ENGINE = SPIDER,

     PARTITION pt3 VALUES IN (3) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__3"' ENGINE = SPIDER,

     PARTITION pt4 VALUES IN (4) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__4"' ENGINE = SPIDER,

     PARTITION pt5 VALUES IN (5) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__5"' ENGINE = SPIDER,

     PARTITION pt6 VALUES IN (6) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__6"' ENGINE = SPIDER,

     PARTITION pt7 VALUES IN (7) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__7"' ENGINE = SPIDER,

     PARTITION pt8 VALUES IN (8) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__8"' ENGINE = SPIDER,

     PARTITION pt9 VALUES IN (9) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__9"' ENGINE = SPIDER,

     PARTITION pt10 VALUES IN (10) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__10"' ENGINE = SPIDER,

     PARTITION pt11 VALUES IN (11) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__11"' ENGINE = SPIDER,

     PARTITION pt12 VALUES IN (12) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__12"' ENGINE = SPIDER,

     PARTITION pt13 VALUES IN (13) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__13"' ENGINE = SPIDER,

     PARTITION pt14 VALUES IN (14) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__14"' ENGINE = SPIDER,

     PARTITION pt15 VALUES IN (15) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__15"' ENGINE = SPIDER,

     PARTITION pt16 VALUES IN (16) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__16"' ENGINE = SPIDER,

     PARTITION pt17 VALUES IN (17) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__17"' ENGINE = SPIDER,

     PARTITION pt18 VALUES IN (18) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__18"' ENGINE = SPIDER,

     PARTITION pt19 VALUES IN (19) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__19"' ENGINE = SPIDER,

     PARTITION pt20 VALUES IN (20) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__20"' ENGINE = SPIDER,

     PARTITION pt21 VALUES IN (21) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__21"' ENGINE = SPIDER,

     PARTITION pt22 VALUES IN (22) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__22"' ENGINE = SPIDER,

     PARTITION pt23 VALUES IN (23) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__23"' ENGINE = SPIDER,

     PARTITION pt24 VALUES IN (24) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__24"' ENGINE = SPIDER,

     PARTITION pt25 VALUES IN (25) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__25"' ENGINE = SPIDER,

     PARTITION pt26 VALUES IN (26) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__26"' ENGINE = SPIDER,

     PARTITION pt27 VALUES IN (27) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__27"' ENGINE = SPIDER,

     PARTITION pt28 VALUES IN (28) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__28"' ENGINE = SPIDER,

     PARTITION pt29 VALUES IN (29) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__29"' ENGINE = SPIDER,

     PARTITION pt30 VALUES IN (30) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__30"' ENGINE = SPIDER,

     PARTITION pt31 VALUES IN (31) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__31"' ENGINE = SPIDER,

     PARTITION pt32 VALUES IN (32) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__32"' ENGINE = SPIDER,

     PARTITION pt33 VALUES IN (33) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__33"' ENGINE = SPIDER,

     PARTITION pt34 VALUES IN (34) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__34"' ENGINE = SPIDER,

     PARTITION pt35 VALUES IN (35) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__35"' ENGINE = SPIDER,

     PARTITION pt36 VALUES IN (36) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__36"' ENGINE = SPIDER,

     PARTITION pt37 VALUES IN (37) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__37"' ENGINE = SPIDER,

     PARTITION pt38 VALUES IN (38) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__38"' ENGINE = SPIDER,

     PARTITION pt39 VALUES IN (39) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__39"' ENGINE = SPIDER,

     PARTITION pt40 VALUES IN (40) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__40"' ENGINE = SPIDER,

     PARTITION pt41 VALUES IN (41) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__41"' ENGINE = SPIDER,

     PARTITION pt42 VALUES IN (42) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__42"' ENGINE = SPIDER,

     PARTITION pt43 VALUES IN (43) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__43"' ENGINE = SPIDER,

     PARTITION pt44 VALUES IN (44) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__44"' ENGINE = SPIDER,

     PARTITION pt45 VALUES IN (45) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__45"' ENGINE = SPIDER,

     PARTITION pt46 VALUES IN (46) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__46"' ENGINE = SPIDER,

     PARTITION pt47 VALUES IN (47) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__47"' ENGINE = SPIDER,

     PARTITION pt48 VALUES IN (48) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__48"' ENGINE = SPIDER,

     PARTITION pt49 VALUES IN (49) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__49"' ENGINE = SPIDER,

     PARTITION pt50 VALUES IN (50) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__50"' ENGINE = SPIDER,

     PARTITION pt51 VALUES IN (51) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__51"' ENGINE = SPIDER,

     PARTITION pt52 VALUES IN (52) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__52"' ENGINE = SPIDER,

     PARTITION pt53 VALUES IN (53) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__53"' ENGINE = SPIDER,

     PARTITION pt54 VALUES IN (54) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__54"' ENGINE = SPIDER,

     PARTITION pt55 VALUES IN (55) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__55"' ENGINE = SPIDER,

     PARTITION pt56 VALUES IN (56) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__56"' ENGINE = SPIDER,

     PARTITION pt57 VALUES IN (57) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__57"' ENGINE = SPIDER,

     PARTITION pt58 VALUES IN (58) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__58"' ENGINE = SPIDER,

     PARTITION pt59 VALUES IN (59) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__59"' ENGINE = SPIDER,

     PARTITION pt60 VALUES IN (60) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__60"' ENGINE = SPIDER,

     PARTITION pt61 VALUES IN (61) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__61"' ENGINE = SPIDER,

     PARTITION pt62 VALUES IN (62) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__62"' ENGINE = SPIDER

);

result : MySQL server has gone away

(was working perfectly in MariDB 10.1.*)

log :

Version: '10.2.9-MariaDB-10.2.9+maria~stretch-log'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution

2017-10-06  9:27:29 140398522464000 [ERROR] mysqld: Table './mysql/spider_tables' is marked as crashed and should be repaired

2017-10-06  9:27:29 140398522464000 [ERROR] mysqld: Table 'spider_tables' is marked as crashed and should be repaired

2017-10-06  9:27:29 140398522464000 [Warning] Checking table:   './mysql/spider_tables'

2017-10-06  9:27:29 140398522464000 [ERROR] Got an error from unknown thread, /home/buildbot/buildbot/build/mariadb-10.2.9/storage/myisam/ha_myisam.cc:1017

2017-10-06  9:27:29 140398522464000 [Warning] Recovering table: './mysql/spider_tables'

2017-10-06  9:27:29 140398522464000 [Note] Found 1 of 0 rows when repairing './mysql/spider_tables'

171006  9:28:27 [ERROR] mysqld got signal 11 ;

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.2.9-MariaDB-10.2.9+maria~stretch-log

key_buffer_size=134217728

read_buffer_size=2097152

max_used_connections=1

max_threads=102

thread_count=9

It is possible that mysqld could use up to

key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 759897 K  bytes of memory

Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x7faef80008c8

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 = 0x7fb1140eecc8 thread_stack 0x49000

/usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x55b80748a14e]

/usr/sbin/mysqld(handle_fatal_signal+0x3cd)[0x55b806f281ed]

/lib/x86_64-linux-gnu/libpthread.so.0(+0x110c0)[0x7fb1d69870c0]

/usr/sbin/mysqld(bitmap_bits_set+0x0)[0x55b80747f340]

/usr/sbin/mysqld(_Z8pack_rowP5TABLEPK9st_bitmapPhPKh+0x32)[0x55b807015f32]

/usr/sbin/mysqld(_ZN3THD16binlog_write_rowEP5TABLEbPKh+0x61)[0x55b806d63b51]

/usr/sbin/mysqld(_ZN20Write_rows_log_event27binlog_row_logging_functionEP3THDP5TABLEbPKhS5_+0xf)[0x55b806f32fef]

/usr/sbin/mysqld(+0x65c97f)[0x55b806f3197f]

/usr/sbin/mysqld(_ZN7handler12ha_write_rowEPh+0x12c)[0x55b806f31f8c]

/usr/lib/mysql/plugin/ha_spider.so(_Z20spider_insert_tablesP5TABLEP15st_spider_share+0x109)[0x7fb1c0c3ac09]

/usr/lib/mysql/plugin/ha_spider.so(_ZN9ha_spider6createEPKcP5TABLEP14HA_CREATE_INFO+0x6fd)[0x7fb1c0c8c1cd]

/usr/sbin/mysqld(_ZN7handler9ha_createEPKcP5TABLEP14HA_CREATE_INFO+0x38)[0x55b806f2fa08]

/usr/sbin/mysqld(+0xb84a18)[0x55b807459a18]

/usr/sbin/mysqld(_ZN7handler9ha_createEPKcP5TABLEP14HA_CREATE_INFO+0x38)[0x55b806f2fa08]

/usr/sbin/mysqld(_Z15ha_create_tableP3THDPKcS2_S2_P14HA_CREATE_INFOP34st_mysql_const_unsigned_lex_string+0x1d1)[0x55b806f302c1]

/usr/sbin/mysqld(_Z16rea_create_tableP3THDP34st_mysql_const_unsigned_lex_stringPKcS4_S4_P14HA_CREATE_INFOP7handlerb+0x9c)[0x55b806e4635c]

/usr/sbin/mysqld(+0x540ee1)[0x55b806e15ee1]

/usr/sbin/mysqld(_Z26mysql_create_table_no_lockP3THDPKcS2_P22Table_specification_stP10Alter_infoPbi+0xef)[0x55b806e1652f]

/usr/sbin/mysqld(_Z18mysql_create_tableP3THDP10TABLE_LISTP22Table_specification_stP10Alter_info+0x102)[0x55b806e166d2]

/usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x88b4)[0x55b806d96784]

/usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x28a)[0x55b806d96f2a]

/usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x1fb6)[0x55b806d99d86]

/usr/sbin/mysqld(_Z10do_commandP3THD+0x167)[0x55b806d9a6c7]

/usr/sbin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x25a)[0x55b806e60cea]

/usr/sbin/mysqld(handle_one_connection+0x3d)[0x55b806e60e5d]

/usr/sbin/mysqld(+0xb69331)[0x55b80743e331]

/lib/x86_64-linux-gnu/libpthread.so.0(+0x7494)[0x7fb1d697d494]

/lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7fb1d4c64aff]

Trying to get some variables.

Some pointers may be invalid and cause the dump to abort.

Query (0x7faef86d7200): CREATE TABLE IF NOT EXISTS `slave_value_int` (  `id_mysql_replication_thread` int(11) NOT NULL, `id_slave_name` int(11) NOT NULL, `date` datetime NOT NULL, `value` bigint(20) unsigned NOT NULL, PRIMARY KEY `id_mysql_replication_thread_slave_int` (`id_mysql_replication_thread`,`id_slave_name`,`date`), KEY `id_mysql_replication_thread_slave__int` (`id_mysql_replication_thread`,`id_slave_name`), KEY `date_int_slave` (`date`,`id_mysql_replication_thread`,`id_slave_name`), KEY `id_slave_name_slave_int` (`id_slave_name`) )   DEFAULT CHARSET=latin1  ENGINE=SPIDER COMMENT='wrapper "mysql"'  PARTITION BY LIST (`id_mysql_replication_thread`) (      PARTITION pt1 VALUES IN (1) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__1"' ENGINE = SPIDER,      PARTITION pt2 VALUES IN (2) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__2"' ENGINE = SPIDER,      PARTITION pt3 VALUES IN (3) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__3"' ENGINE = SPIDER,      PARTITION pt4 VALUES IN (4) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__4"' ENGINE = SPIDER,      PARTITION pt5 VALUES IN (5) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__5"' ENGINE = SPIDER,      PARTITION pt6 VALUES IN (6) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__6"' ENGINE = SPIDER,      PARTITION pt7 VALUES IN (7) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__7"' ENGINE = SPIDER,      PARTITION pt8 VALUES IN (8) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__8"' ENGINE = SPIDER,      PARTITION pt9 VALUES IN (9) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__9"' ENGINE = SPIDER,      PARTITION pt10 VALUES IN (10) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__10"' ENGINE = SPIDER,      PARTITION pt11 VALUES IN (11) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__11"' ENGINE = SPIDER,      PARTITION pt12 VALUES IN (12) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__12"' ENGINE = SPIDER,      PARTITION pt13 VALUES IN (13) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__13"' ENGINE = SPIDER,      PARTITION pt14 VALUES IN (14) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__14"' ENGINE = SPIDER,      PARTITION pt15 VALUES IN (15) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__15"' ENGINE = SPIDER,      PARTITION pt16 VALUES IN (16) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__16"' ENGINE = SPIDER,      PARTITION pt17 VALUES IN (17) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__17"' ENGINE = SPIDER,      PARTITION pt18 VALUES IN (18) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__18"' ENGINE = SPIDER,      PARTITION pt19 VALUES IN (19) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__19"' ENGINE = SPIDER,      PARTITION pt20 VALUES IN (20) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__20"' ENGINE = SPIDER,      PARTITION pt21 VALUES IN (21) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__21"' ENGINE = SPIDER,      PARTITION pt22 VALUES IN (22) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__22"' ENGINE = SPIDER,      PARTITION pt23 VALUES IN (23) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__23"' ENGINE = SPIDER,      PARTITION pt24 VALUES IN (24) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__24"' ENGINE = SPIDER,      PARTITION pt25 VALUES IN (25) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__25"' ENGINE = SPIDER,      PARTITION pt26 VALUES IN (26) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__26"' ENGINE = SPIDER,      PARTITION pt27 VALUES IN (27) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__27"' ENGINE = SPIDER,      PARTITION pt28 VALUES IN (28) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__28"' ENGINE = SPIDER,      PARTITION pt29 VALUES IN (29) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__29"' ENGINE = SPIDER,      PARTITION pt30 VALUES IN (30) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__30"' ENGINE = SPIDER,      PARTITION pt31 VALUES IN (31) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__31"' ENGINE = SPIDER,      PARTITION pt32 VALUES IN (32) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__32"' ENGINE = SPIDER,      PARTITION pt33 VALUES IN (33) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__33"' ENGINE = SPIDER,      PARTITION pt34 VALUES IN (34) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__34"' ENGINE = SPIDER,      PARTITION pt35 VALUES IN (35) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__35"' ENGINE = SPIDER,      PARTITION pt36 VALUES IN (36) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__36"' ENGINE = SPIDER,      PARTITION pt37 VALUES IN (37) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__37"' ENGINE = SPIDER,      PARTITION pt38 VALUES IN (38) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__38"' ENGINE = SPIDER,      PARTITION pt39 VALUES IN (39) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__39"' ENGINE = SPIDER,      PARTITION pt40 VALUES IN (40) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__40"' ENGINE = SPIDER,      PARTITION pt41 VALUES IN (41) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__41"' ENGINE = SPIDER,      PARTITION pt42 VALUES IN (42) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__42"' ENGINE = SPIDER,      PARTITION pt43 VALUES IN (43) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__43"' ENGINE = SPIDER,      PARTITION pt44 VALUES IN (44) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__44"' ENGINE = SPIDER,      PARTITION pt45 VALUES IN (45) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__45"' ENGINE = SPIDER,      PARTITION pt46 VALUES IN (46) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__46"' ENGINE = SPIDER,      PARTITION pt47 VALUES IN (47) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__47"' ENGINE = SPIDER,      PARTITION pt48 VALUES IN (48) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__48"' ENGINE = SPIDER,      PARTITION pt49 VALUES IN (49) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__49"' ENGINE = SPIDER,      PARTITION pt50 VALUES IN (50) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__50"' ENGINE = SPIDER,      PARTITION pt51 VALUES IN (51) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__51"' ENGINE = SPIDER,      PARTITION pt52 VALUES IN (52) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__52"' ENGINE = SPIDER,      PARTITION pt53 VALUES IN (53) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__53"' ENGINE = SPIDER,      PARTITION pt54 VALUES IN (54) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__54"' ENGINE = SPIDER,      PARTITION pt55 VALUES IN (55) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__55"' ENGINE = SPIDER,      PARTITION pt56 VALUES IN (56) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__56"' ENGINE = SPIDER,      PARTITION pt57 VALUES IN (57) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__57"' ENGINE = SPIDER,      PARTITION pt58 VALUES IN (58) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__58"' ENGINE = SPIDER,      PARTITION pt59 VALUES IN (59) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__59"' ENGINE = SPIDER,      PARTITION pt60 VALUES IN (60) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__60"' ENGINE = SPIDER,      PARTITION pt61 VALUES IN (61) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__61"' ENGINE = SPIDER,      PARTITION pt62 VALUES IN (62) COMMENT = 'host "127.0.0.1", database "pmacontrol", user "root", password "*****", table "slave_value_int__62"' ENGINE = SPIDER )

Connection ID (thread ID): 14

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=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on

The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains

information that should help you find out what is causing the crash.

Fri Oct  6 09:28:34 2017 PerconaFT recovery starting in env /data/mysql/data/

Fri Oct  6 09:28:34 2017 PerconaFT recovery scanning backward from 2512231

Fri Oct  6 09:28:34 2017 PerconaFT recovery bw_end_checkpoint at 2512231 timestamp 1507274884645524 xid 2512227 (bw_newer)

Fri Oct  6 09:28:34 2017 PerconaFT recovery bw_begin_checkpoint at 2512227 timestamp 1507274884582796 (bw_between)

Fri Oct  6 09:28:34 2017 PerconaFT recovery turning around at begin checkpoint 2512227 time 62728

Fri Oct  6 09:28:34 2017 PerconaFT recovery starts scanning forward to 2512231 from 2512227 left 4 (fw_between)

Fri Oct  6 09:28:34 2017 PerconaFT recovery closing 2 dictionaries

Fri Oct  6 09:28:34 2017 PerconaFT recovery making a checkpoint

Fri Oct  6 09:28:34 2017 PerconaFT recovery done

2017-10-06  9:28:34 140391535687872 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2017-10-06  9:28:34 140391535687872 [Note] InnoDB: Uses event mutexes

2017-10-06  9:28:34 140391535687872 [Note] InnoDB: Compressed tables use zlib 1.2.8

2017-10-06  9:28:34 140391535687872 [Note] InnoDB: Using Linux native AIO

2017-10-06  9:28:34 140391535687872 [Note] InnoDB: Number of pools: 1

2017-10-06  9:28:34 140391535687872 [Note] InnoDB: Using SSE2 crc32 instructions

2017-10-06  9:28:34 140391535687872 [Note] InnoDB: Initializing buffer pool, total size = 6G, instances = 8, chunk size = 128M

2017-10-06  9:28:34 140391535687872 [Note] InnoDB: Completed initialization of buffer pool

2017-10-06  9:28:34 140383512991488 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().

2017-10-06  9:28:34 140391535687872 [Note] InnoDB: Highest supported file format is Barracuda.

2017-10-06  9:28:34 140391535687872 [Note] InnoDB: Starting crash recovery from checkpoint LSN=117506347

2017-10-06  9:28:34 140391535687872 [Note] InnoDB: Last binlog file '/data/mysql/binlog/mariadb-bin.000003', position 193439986

2017-10-06  9:28:35 140391535687872 [Note] InnoDB: 128 out of 128 rollback segments are active.

2017-10-06  9:28:35 140391535687872 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"

2017-10-06  9:28:35 140391535687872 [Note] InnoDB: Creating shared tablespace for temporary tables

2017-10-06  9:28:35 140391535687872 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...

2017-10-06  9:28:35 140391535687872 [Note] InnoDB: File './ibtmp1' size is now 12 MB.

2017-10-06  9:28:35 140391535687872 [Note] InnoDB: Waiting for purge to start

2017-10-06  9:28:35 140391535687872 [Note] InnoDB: 5.7.19 started; log sequence number 117506356

2017-10-06  9:28:35 140383671211776 [Note] InnoDB: Loading buffer pool(s) from /data/mysql/data/ib_buffer_pool

2017-10-06  9:28:35 140391535687872 [Note] RocksDB: 2 column families found

2017-10-06  9:28:35 140391535687872 [Note] RocksDB: Column Families at start:

2017-10-06  9:28:35 140391535687872 [Note]   cf=default

2017-10-06  9:28:35 140391535687872 [Note]     write_buffer_size=67108864

2017-10-06  9:28:35 140391535687872 [Note]     target_file_size_base=67108864

2017-10-06  9:28:35 140391535687872 [Note]   cf=__system__

2017-10-06  9:28:35 140391535687872 [Note]     write_buffer_size=67108864

2017-10-06  9:28:35 140391535687872 [Note]     target_file_size_base=67108864

2017-10-06  9:28:35 140383671211776 [Note] InnoDB: Buffer pool(s) load completed at 171006  9:28:35

2017-10-06  9:28:35 140391535687872 [Note] RocksDB: Table_store: loaded DDL data for 744 tables

2017-10-06  9:28:35 140391535687872 [Note] RocksDB: global statistics using get_sched_indexer_t indexer

2017-10-06  9:28:35 140391535687872 [Note] MyRocks storage engine plugin has been successfully initialized.

2017-10-06  9:28:35 140391535687872 [Note] Plugin 'FEEDBACK' is disabled.

2017-10-06  9:28:35 140391535687872 [Note] Recovering after a crash using /data/mysql/binlog/mariadb-bin

2017-10-06  9:28:35 140391535687872 [Note] Starting crash recovery...

2017-10-06  9:28:35 140391535687872 [Note] Crash recovery finished.

Attachments

Issue Links

is duplicated by

MDEV-15699 CREATE TABLE for Spider table causes binlog-related crash

Closed

relates to

MDEV-14018 problem of lock on concurent insert (from spider i guees)

Confirmed

Activity

People

Assignee:: Jacob Mathew (Inactive)

Reporter:: Aurélien LEQUOY

Votes:: 1 Vote for this issue

Watchers:: 7 Start watching this issue

Dates

Created:: 2017-10-06 07:56

Updated:: 2018-05-03 16:49

Resolved:: 2018-03-13 23:50

Git Integration

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