180301 13:49:42 [Warning] Aborted connection 12006871 to db: 'CommonDB' user: 'ferdev' host: '172.17.132.19' (Got an error reading communication packets) 180301 13:49:43 [Warning] Aborted connection 12006873 to db: 'unconnected' user: 'ferdev' host: '172.17.132.19' (Got an error reading communication packets) 180301 21:42:39 [Warning] Aborted connection 11977325 to db: 'FEROrders' user: 'recs_app' host: '172.21.127.47' (Got timeout reading communication packets) 180302 1:01:15 [Warning] Aborted connection 12040381 to db: 'entitlements_utf8' user: 'recs_app' host: '172.21.127.48' (Got timeout reading communication packets) 180302 12:58:24 [Warning] Aborted connection 12122224 to db: 'unconnected' user: 'recs_app' host: '172.17.189.64' (Got an error reading communication packets) 180302 12:58:26 [Warning] Aborted connection 12122217 to db: 'CommonDB' user: 'recs_app' host: '172.17.189.64' (Got an error reading communication packets) 180302 15:19:48 [Warning] Aborted connection 12074031 to db: 'FEROrders' user: 'recs_app' host: '172.21.127.44' (Got timeout reading communication packets) 180303 0:04:58 [Warning] Aborted connection 12137447 to db: 'entitlements_utf8' user: 'recs_app' host: '172.21.127.50' (Got timeout reading communication packets) 180303 1:03:57 [Warning] Aborted connection 11630656 to db: 'FEROrders' user: 'recs_app' host: '172.21.127.46' (Got timeout reading communication packets) 180303 11:17:18 [Warning] Aborted connection 12223698 to db: 'CommonDB' user: 'ferdev' host: '172.17.192.46' (Got an error reading communication packets) 180303 11:17:19 [Warning] Aborted connection 12223701 to db: 'unconnected' user: 'ferdev' host: '172.17.192.46' (Got an error reading communication packets) 180303 16:30:07 [Warning] Aborted connection 12220128 to db: 'entitlements_utf8' user: 'recs_app' host: '172.21.127.55' (Got timeout reading communication packets) 180305 8:14:16 [Warning] Aborted connection 12402035 to db: 'entitlements_utf8' user: 'recs_app' host: '172.21.127.44' (Got timeout reading communication packets) 180305 8:15:49 [Warning] Aborted connection 12402147 to db: 'entitlements_utf8' user: 'recs_app' host: '172.21.127.55' (Got timeout reading communication packets) 180305 8:37:09 [Warning] Aborted connection 12403792 to db: 'entitlements_utf8' user: 'recs_app' host: '172.21.127.54' (Got timeout reading communication packets) 180305 9:51:34 [Warning] Aborted connection 12397350 to db: 'FEROrders' user: 'recs_app' host: '172.21.127.48' (Got timeout reading communication packets) 180305 16:12:12 [Warning] Aborted connection 9819673 to db: 'unconnected' user: 'replication' host: '164.55.92.20' (Got an error writing communication packets) 180305 16:19:38 [Note] /home/fds/ferdb/mysql/bin/mysqld: Normal shutdown 180305 16:19:38 [Note] Event Scheduler: Purging the queue. 0 events 180305 16:19:38 [Note] Error reading relay log event: slave SQL thread was killed 180305 16:19:38 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013) 180305 16:19:38 [Note] Slave I/O thread killed while reading event 180305 16:19:38 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.001717', position 535359064 180305 16:19:38 InnoDB: Starting shutdown... 180305 16:19:42 InnoDB: Shutdown completed; log sequence number 5278305144101 180305 16:19:42 [Note] /home/fds/ferdb/mysql/bin/mysqld: Shutdown complete 180305 16:19:42 mysqld_safe mysqld from pid file /home/fds/ferdb/mysql/data/mysql.pid ended 2018-03-05 16:20:06 140693519959840 [Note] Using unique option prefix 'myisam-recover' is error-prone and can break in the future. Please use the full name 'myisam-recover-options' instead. 2018-03-05 16:20:06 140693519959840 [Warning] InnoDB: Using innodb_file_format is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html 2018-03-05 16:20:06 140693519959840 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-03-05 16:20:06 140693519959840 [Note] InnoDB: Uses event mutexes 2018-03-05 16:20:06 140693519959840 [Note] InnoDB: Compressed tables use zlib 1.2.3 2018-03-05 16:20:06 140693519959840 [Note] InnoDB: Using Linux native AIO 2018-03-05 16:20:06 140693519959840 [Note] InnoDB: Number of pools: 1 2018-03-05 16:20:06 140693519959840 [Note] InnoDB: Using SSE2 crc32 instructions 2018-03-05 16:20:06 140693519959840 [Note] InnoDB: Initializing buffer pool, total size = 10G, instances = 8, chunk size = 128M 2018-03-05 16:20:06 140693519959840 [Note] InnoDB: Completed initialization of buffer pool 2018-03-05 16:20:06 140680756922112 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-03-05 16:20:06 140693519959840 [Note] InnoDB: Highest supported file format is Barracuda. 2018-03-05 16:20:07 140693519959840 [Note] InnoDB: Upgrading redo log: 2*536870912 bytes; LSN=5278305144101 2018-03-05 16:20:07 140693519959840 [Note] InnoDB: Starting to delete and rewrite log files. 2018-03-05 16:20:07 140693519959840 [Note] InnoDB: Setting log file ./ib_logfile101 size to 536870912 bytes 2018-03-05 16:20:07 140693519959840 [Note] InnoDB: Setting log file ./ib_logfile1 size to 536870912 bytes 2018-03-05 16:20:07 140693519959840 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2018-03-05 16:20:07 140693519959840 [Note] InnoDB: New log files created, LSN=5278305144101 2018-03-05 16:20:07 140693519959840 [Note] InnoDB: Creating tablespace and datafile system tables. 2018-03-05 16:20:09 140693519959840 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-03-05 16:20:09 140693519959840 [Note] InnoDB: Creating sys_virtual system tables. 2018-03-05 16:20:09 140693519959840 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-03-05 16:20:09 140693519959840 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-03-05 16:20:09 140693519959840 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-03-05 16:20:09 140693519959840 [Note] InnoDB: Waiting for purge to start 2018-03-05 16:20:09 140693519959840 [Note] InnoDB: 5.7.20 started; log sequence number 0 2018-03-05 16:20:09 140693519959840 [Note] Plugin 'FEEDBACK' is disabled. 2018-03-05 16:20:09 140680591234816 [Note] InnoDB: Loading buffer pool(s) from /home/fds/ferdb/mysql_data/ib_buffer_pool 2018-03-05 16:20:09 140680591234816 [Note] InnoDB: Cannot open '/home/fds/ferdb/mysql_data/ib_buffer_pool' for reading: No such file or directory 2018-03-05 16:20:09 140692865963776 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist 2018-03-05 16:20:10 140693519959840 [Note] Server socket created on IP: '::'. 2018-03-05 16:20:10 140693519959840 [ERROR] Missing system table mysql.roles_mapping; please run mysql_upgrade to create it 2018-03-05 16:20:10 140692865357568 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist 2018-03-05 16:20:10 140693519959840 [Note] Reading of all Master_info entries succeded 2018-03-05 16:20:10 140693519959840 [Note] Added new Master_info '' to hash table 2018-03-05 16:20:10 140693519959840 [Note] /home/fds/ferdb/mysql/bin/mysqld: ready for connections. Version: '10.2.12-MariaDB-log' socket: '/home/fds/ferdb/mysql/data/mysql.sock' port: 3364 MariaDB Server 2018-03-05 16:25:33 140692861593344 [Note] /home/fds/ferdb/mysql/bin/mysqld (unknown): Normal shutdown 2018-03-05 16:25:33 140692861593344 [Note] Event Scheduler: Purging the queue. 0 events 2018-03-05 16:25:33 140680996132608 [Note] InnoDB: FTS optimize thread exiting. 2018-03-05 16:25:33 140692861593344 [Note] InnoDB: Starting shutdown... 2018-03-05 16:25:33 140680591234816 [Note] InnoDB: Dumping buffer pool(s) to /home/fds/ferdb/mysql_data/ib_buffer_pool 2018-03-05 16:25:33 140680591234816 [Note] InnoDB: Buffer pool(s) dump completed at 180305 16:25:33 2018-03-05 16:25:36 140692861593344 [Note] InnoDB: Shutdown completed; log sequence number 5278306363728 2018-03-05 16:25:36 140692861593344 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-03-05 16:25:36 140692861593344 [Note] /home/fds/ferdb/mysql/bin/mysqld: Shutdown complete 2018-03-05 16:25:37 140543491143456 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-03-05 16:25:37 140543491143456 [Note] InnoDB: Uses event mutexes 2018-03-05 16:25:37 140543491143456 [Note] InnoDB: Compressed tables use zlib 1.2.3 2018-03-05 16:25:37 140543491143456 [Note] InnoDB: Using Linux native AIO 2018-03-05 16:25:37 140543491143456 [Note] InnoDB: Number of pools: 1 2018-03-05 16:25:37 140543491143456 [Note] InnoDB: Using SSE2 crc32 instructions 2018-03-05 16:25:37 140543491143456 [Note] InnoDB: Initializing buffer pool, total size = 10G, instances = 8, chunk size = 128M 2018-03-05 16:25:37 140543491143456 [Note] InnoDB: Completed initialization of buffer pool 2018-03-05 16:25:37 140530726926080 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-03-05 16:25:37 140543491143456 [Note] InnoDB: Highest supported file format is Barracuda. 2018-03-05 16:25:38 140543491143456 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-03-05 16:25:38 140543491143456 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-03-05 16:25:38 140543491143456 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-03-05 16:25:38 140543491143456 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-03-05 16:25:38 140543491143456 [Note] InnoDB: Waiting for purge to start 2018-03-05 16:25:38 140543491143456 [Note] InnoDB: 5.7.20 started; log sequence number 5278306363728 2018-03-05 16:25:38 140530549491456 [Note] InnoDB: Loading buffer pool(s) from /home/fds/ferdb/mysql_data/ib_buffer_pool 2018-03-05 16:25:38 140543491143456 [Note] Plugin 'FEEDBACK' is disabled. 2018-03-05 16:25:38 140543491143456 [Note] Server socket created on IP: '::'. 2018-03-05 16:25:38 140543491143456 [Note] Reading of all Master_info entries succeded 2018-03-05 16:25:38 140543491143456 [Note] Added new Master_info '' to hash table 2018-03-05 16:25:38 140543491143456 [Note] /home/fds/ferdb/mysql/bin/mysqld: ready for connections. Version: '10.2.12-MariaDB-log' socket: '/home/fds/ferdb/mysql/data/mysql.sock' port: 3364 MariaDB Server 2018-03-05 16:25:38 140542346114816 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.001717' at position 535359064, relay log '/home/fds/ferdb/mysql/data/ibsqlstagea04-relay-bin.718297' position: 13803 2018-03-05 16:25:38 140542806009600 [Note] Slave I/O thread: connected to master 'replication@ibsqlstagea05:3364',replication started in log 'mysql-bin.001717' at position 535359064 2018-03-05 16:25:54 140530549491456 [Note] InnoDB: Buffer pool(s) load completed at 180305 16:25:54 2018-03-05 16:26:21 140542344988416 [Note] Start binlog_dump to slave_server(4), pos(mysql-bin.001832, 535927477) 2018-03-05 16:31:11 140542806009600 [Note] Slave: received end packet from server, apparent master shutdown: 2018-03-05 16:31:11 140542806009600 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.001717' at position 535414487 2018-03-05 16:31:11 140542806009600 [ERROR] Slave I/O: error reconnecting to master 'replication@ibsqlstagea05:3364' - retry-time: 60 maximum-retries: 86400 message: Can't connect to MySQL server on 'ibsqlstagea05' (111 "Connection refused"), Internal MariaDB error code: 2003 2018-03-05 16:31:13 140542344988416 [Warning] Aborted connection 31 to db: 'unconnected' user: 'replication' host: '164.55.92.20' (Got an error writing communication packets) 2018-03-05 16:31:18 140542344988416 [Note] Start binlog_dump to slave_server(4), pos(mysql-bin.001834, 1733698) 2018-03-05 16:32:11 140542806009600 [Note] Slave: connected to master 'replication@ibsqlstagea05:3364',replication resumed in log 'mysql-bin.001717' at position 535414487 2018-03-05 17:43:46 140542343472896 [Warning] Aborted connection 1489 to db: 'unconnected' user: 'MONyog' host: '164.55.96.196' (Got timeout reading communication packets) 2018-03-06 7:55:16 140542342563584 [Warning] Aborted connection 28331 to db: 'FEROrders' user: 'recs_app' host: '172.21.127.37' (Got timeout reading communication packets) 2018-03-06 08:12:14 0x7fd2900b0700 InnoDB: Assertion failure in file /home/buildbot/buildbot/build/storage/innobase/que/que0que.cc line 567 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to https://jira.mariadb.org/ InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html InnoDB: about forcing recovery. 180306 8:12:14 [ERROR] mysqld got signal 6 ; 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.12-MariaDB-log key_buffer_size=268435456 read_buffer_size=131072 max_used_connections=51 max_threads=502 thread_count=60 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 1365189 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7fd28c3183d8 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 = 0x7fd2900afe18 thread_stack 0x49000 /home/fds/ferdb/mysql/bin/mysqld(my_print_stacktrace+0x2e)[0xde610e] /home/fds/ferdb/mysql/bin/mysqld(handle_fatal_signal+0x471)[0x7de601] /lib64/libpthread.so.0[0x363e80f7e0] /lib64/libc.so.6(gsignal+0x35)[0x363e032495] /lib64/libc.so.6(abort+0x175)[0x363e033c75] /home/fds/ferdb/mysql/bin/mysqld[0xbafc13] /home/fds/ferdb/mysql/bin/mysqld[0xad7f63] /home/fds/ferdb/mysql/bin/mysqld[0xb0e9e3] /home/fds/ferdb/mysql/bin/mysqld[0xa2b73a] /home/fds/ferdb/mysql/bin/mysqld(_Z8closefrmP5TABLE+0x11e)[0x6a811e] /home/fds/ferdb/mysql/bin/mysqld(_Z12tc_add_tableP3THDP5TABLE+0x333)[0x76b053] /home/fds/ferdb/mysql/bin/mysqld(_Z10open_tableP3THDP10TABLE_LISTP18Open_table_context+0xb83)[0x59d9c3] /home/fds/ferdb/mysql/bin/mysqld(_Z11open_tablesP3THDRK14DDL_options_stPP10TABLE_LISTPjjP19Prelocking_strategy+0xe77)[0x59f0b7] /home/fds/ferdb/mysql/bin/mysqld(_Z20open_and_lock_tablesP3THDRK14DDL_options_stP10TABLE_LISTbjP19Prelocking_strategy+0x4b)[0x59f56b] /home/fds/ferdb/mysql/bin/mysqld[0x5e6fe2] /home/fds/ferdb/mysql/bin/mysqld(_Z21mysql_execute_commandP3THD+0x187c)[0x5eab4c] /home/fds/ferdb/mysql/bin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x3a2)[0x5f4272] /home/fds/ferdb/mysql/bin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x26f0)[0x5f7190] /home/fds/ferdb/mysql/bin/mysqld(_Z10do_commandP3THD+0x15d)[0x5f84cd] /home/fds/ferdb/mysql/bin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x235)[0x6dc865] /home/fds/ferdb/mysql/bin/mysqld(handle_one_connection+0x3f)[0x6dca2f] /home/fds/ferdb/mysql/bin/mysqld[0xa054a9] /lib64/libpthread.so.0[0x363e807aa1] /lib64/libc.so.6(clone+0x6d)[0x363e0e8bcd] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7fd28c1f2660): select 'UID:CT62258805942:', (select SecurityName.inner_text from contool_utf8.tags SecurityName where SecurityName.submission_id = securityNode.submission_id and SecurityName.element_id = 10156 and SecurityName.parent_id = securityNode.node_id) as RealName, issuerNameValue.inner_text as company_name, (select CUSIP.inner_text from contool_utf8.tags securityId inner join contool_utf8.tags CUSIPType force key (submission_id) on CUSIPType.submission_id = securityId.submission_id and CUSIPType.parent_id = securityId.node_id and CUSIPType.element_id = 10151 and CUSIPType.inner_text in ('CUSIP','CINS') inner join contool_utf8.tags CUSIP force key (submission_id) on CUSIP.submission_id = CUSIPType.submission_id and CUSIP.element_id = 10152 and CUSIPType.parent_id = CUSIP.parent_id where securityId.submission_id = issuerNode.submission_id and securityId.element_id = 10154 and securityId.parent_id = securityNode.node_id ) as CUSIP, issuerPI.inner_text as primary_indicator, estimateAction.inner_text as estimateAction, coverageAction.inner_text as coverageAction, targetAction.inner_text as targetAction, ratingAction.inner_text as ratingAction, tradingCountryCodeValue.inner_text as tradingCountry, privateEntityID.inner_text as entityID, tickerValue.inner_text as ticker, (select RIC.inner_text from contool_utf8.tags securityId inner join contool_utf8.tags RICType force key (submission_id) on RICType.submission_id = securityId.submission_id and RICType.parent_id = securityId.node_id and RICType.element_id = 10151 and RICType.inner_text = 'RIC' inner join contool_utf8.tags RIC force key (submission_id) on RIC.submission_id = RICType.submission_id and RIC.element_id = 10152 and RICType.parent_id = RIC.parent_id where securityId.submission_id = issuerNode.submission_id and securityId.element_id = 10154 and securityId.parent_id = securityNode.node_id ) as RIC, (select ISIN.inner_text from contool_utf8.tags securityId inner join contool_utf8.tags ISINType force key (submission_id) on ISINType.submission_id = securityId.submission_id and ISINType.parent_id = securityId.node_id and ISINType.element_id = 10151 and ISINType.inner_text = 'ISIN' inner join contool_utf8.tags ISIN force key (submission_id) on ISIN.submission_id = ISINType.submission_id and ISIN.element_id = 10152 and ISINType.parent_id = ISIN.parent_id where securityId.submission_id = issuerNode.submission_id and securityId.element_id = 10154 and securityId.parent_id = securityNode.node_id ) as ISIN, (select SEDOL.inner_text from contool_utf8.tags securityId inner join contool_utf8.tags SEDOLType force key (submission_id) on SEDOLType.submission_id = securityId.submission_id and SEDOLType.parent_id = securityId.node_id and SEDOLType.element_id = 10151 inner join contool_utf8.tags SEDOL force key (submission_id) on SEDOL.submission_id = SEDOLType.submission_id and SEDOL.element_id = 10152 and SEDOLType.parent_id = SEDOL.parent_id where securityId.submission_id = issuerNode.submission_id and securityId.element_id = 10154 and securityId.parent_id = securityNode.node_id and SEDOLType.inner_text = 'SEDOL' ) as SEDOL, (select bloom.inner_text from contool_utf8.tags securityId inner join contool_utf8.tags bloomType force key (submission_id) on bloomType.submission_id = securityId.submission_id and bloomType.parent_id = securityId.node_id and bloomType.element_id = 10151 and bloomType.inner_text = 'Bloomberg' inner join contool_utf8.tags bloom force key (submission_id) on bloom.submission_id = bloomType.submission_id and bloom.element_id = 10152 and bloomType.parent_id = bloom.parent_id where securityId.submission_id = issuerNode.submission_id and securityId.element_id = 10154 and securityId.parent_id = securityNode.node_id ) as Bloomberg , (select exchange.inner_text from contool_utf8.tags exchange where exchange.submission_id = issuerNode.submission_id and exchange.parent_id = tickerValue.parent_id and exchange.element_id = 10150) as Exchange from contool_utf8.tags issuerNode inner join contool_utf8.tags issuerPI on issuerPI.submission_id = issuerNode.submission_id and issuerPI.parent_id = issuerNode.node_id and issuerPI.element_id = 10061 inner join contool_utf8.tags issuerName on issuerName.submission_id = issuerNode.submission_id and issuerName.parent_id = issuerNode.node_id and issuerName.element_id = 10165 inner join contool_utf8.tags issuerNameValue on issuerNameValue.submission_id = issuerNode.submission_id and issuerNameValue.parent_id = issuerName.node_id and issuerNameValue.element_id = 10163 inner join contool_utf8.tags securityDetails on securityDetails.submission_id = issuerNode.submission_id and securityDetails.parent_id = issuerNode.node_id and securityDetails.element_id = 10161 inner join contool_utf8.tags securityNode on securityNode.submission_id = issuerNode.submission_id and securityNode.element_id = 10160 and securityNode.parent_id = securityDetails.node_id left outer join contool_utf8.tags estimateAction on estimateAction.submission_id = issuerNode.submission_id and estimateAction.element_id = 10159 and estimateAction.parent_id = securityNode.node_id left outer join contool_utf8.tags coverageAction on coverageAction.submission_id = issuerNode.submission_id and coverageAction.element_id = 10182 and coverageAction.parent_id = securityNode.node_id left outer join contool_utf8.tags ratingAction on ratingAction.submission_id = issuerNode.submission_id and ratingAction.element_id = 10183 and ratingAction.parent_id = securityNode.node_id left outer join contool_utf8.tags targetAction on targetAction.submission_id = issuerNode.submission_id and targetAction.element_id = 10158 and targetAction.parent_id = securityNode.node_id LEFT OUTER JOIN contool_utf8.tags publisherDefinedValue ON publisherDefinedValue.submission_id = issuerNode.submission_id AND publisherDefinedValue.element_id = 10002 AND publisherDefinedValue.inner_text = 'Ticker' AND publisherDefinedValue.rgt < securityNode.rgt AND publisherDefinedValue.lft > securityNode.lft LEFT OUTER JOIN contool_utf8.tags tickerNode ON tickerNode.submission_id = issuerNode.submission_id AND tickerNode.element_id = 10151 AND tickerNode.inner_text = 'ExchangeTicker' AND tickerNode.rgt < securityNode.rgt AND tickerNode.lft > securityNode.lft LEFT OUTER JOIN contool_utf8.tags tickerValue ON tickerValue.submission_id = issuerNode.submission_id AND tickerValue.parent_id = IFNULL(tickerNode.parent_id,publisherDefinedValue.parent_id) AND tickerValue.element_id = 10152 LEFT OUTER JOIN contool_utf8.tags tradingCountryCodeValue ON tradingCountryCodeValue.submission_id = issuerNode.submission_id AND tradingCountryCodeValue.element_id = 10153 AND tradingCountryCodeValue.parent_id = tickerValue.parent_id LEFT OUTER JOIN contool_utf8.tags privateEntityID ON privateEntityID.submission_id = issuerNode.submission_id AND privateEntityID.element_id = 10209 AND privateEntityID.parent_id = tickerValue.parent_id where issuerNode.submission_id ='201801290348364557' and issuerNode.element_id = 10171 order by company_name Connection ID (thread ID): 71313 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=on,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. 2018-03-06 8:12:38 139637940365088 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-03-06 8:12:38 139637940365088 [Note] InnoDB: Uses event mutexes 2018-03-06 8:12:38 139637940365088 [Note] InnoDB: Compressed tables use zlib 1.2.3 2018-03-06 8:12:38 139637940365088 [Note] InnoDB: Using Linux native AIO 2018-03-06 8:12:38 139637940365088 [Note] InnoDB: Number of pools: 1 2018-03-06 8:12:38 139637940365088 [Note] InnoDB: Using SSE2 crc32 instructions 2018-03-06 8:12:38 139637940365088 [Note] InnoDB: Initializing buffer pool, total size = 10G, instances = 8, chunk size = 128M 2018-03-06 8:12:39 139637940365088 [Note] InnoDB: Completed initialization of buffer pool 2018-03-06 8:12:39 139625180620544 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-03-06 8:12:39 139637940365088 [Note] InnoDB: Highest supported file format is Barracuda. 2018-03-06 8:12:39 139637940365088 [Note] InnoDB: Starting crash recovery from checkpoint LSN=5283084574914 2018-03-06 8:12:40 139637940365088 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 2 row operations to undo 2018-03-06 8:12:40 139637940365088 [Note] InnoDB: Trx id counter is 86056704 2018-03-06 8:12:40 139637940365088 [Note] InnoDB: Starting final batch to recover 555 pages from redo log. 2018-03-06 8:12:40 139637940365088 [Note] InnoDB: Last binlog file '/home/fds/ferdb/mysql/data/mysql-bin.001838', position 285204091 2018-03-06 8:12:41 139637940365088 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-03-06 8:12:41 139625070843648 [Note] InnoDB: Starting in background the rollback of recovered transactions 2018-03-06 8:12:41 139637940365088 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-03-06 8:12:41 139637940365088 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-03-06 8:12:41 139637940365088 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-03-06 8:12:41 139637940365088 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-03-06 8:12:41 139637940365088 [Note] InnoDB: 5.7.20 started; log sequence number 5283084575861 2018-03-06 8:12:41 139625388361472 [Note] InnoDB: Loading buffer pool(s) from /home/fds/ferdb/mysql_data/ib_buffer_pool 2018-03-06 8:12:41 139637940365088 [Note] Plugin 'FEEDBACK' is disabled. 2018-03-06 8:12:41 139637940365088 [Note] Recovering after a crash using /home/fds/ferdb/mysql/data/mysql-bin 2018-03-06 8:12:41 139625070843648 [Note] InnoDB: Rollback of trx with id 0 completed 2018-03-06 8:12:41 139625070843648 [Note] InnoDB: Rollback of non-prepared transactions completed 2018-03-06 8:12:42 139637940365088 [Note] Starting crash recovery... 2018-03-06 8:12:42 139637940365088 [Note] Crash recovery finished. 2018-03-06 8:12:42 139637940365088 [Note] Server socket created on IP: '::'. 2018-03-06 8:12:42 139637940365088 [Note] Reading of all Master_info entries succeded 2018-03-06 8:12:42 139637940365088 [Note] Added new Master_info '' to hash table 2018-03-06 8:12:42 139637940365088 [Note] /home/fds/ferdb/mysql/bin/mysqld: ready for connections. Version: '10.2.12-MariaDB-log' socket: '/home/fds/ferdb/mysql/data/mysql.sock' port: 3364 MariaDB Server 2018-03-06 8:12:42 139637306005248 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.001719' at position 113385508, relay log '/home/fds/ferdb/mysql/data/ibsqlstagea04-relay-bin.718306' position: 540 2018-03-06 8:12:42 139637306308352 [Note] Slave I/O thread: connected to master 'replication@ibsqlstagea05:3364',replication started in log 'mysql-bin.001719' at position 113385508 2018-03-06 8:13:09 139625388361472 [Note] InnoDB: Buffer pool(s) load completed at 180306 8:13:09 2018-03-06 8:13:38 139636773000960 [Note] Start binlog_dump to slave_server(4), pos(mysql-bin.001838, 285204091) 2018-03-06 09:59:37 0x7effb832b700 InnoDB: Assertion failure in file /home/buildbot/buildbot/build/storage/innobase/que/que0que.cc line 567 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to https://jira.mariadb.org/ InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html InnoDB: about forcing recovery. 180306 9:59:37 [ERROR] mysqld got signal 6 ; 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.12-MariaDB-log key_buffer_size=268435456 read_buffer_size=131072 max_used_connections=17 max_threads=502 thread_count=26 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 1365189 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7efcdc006e98 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 = 0x7effb832ae18 thread_stack 0x49000 /home/fds/ferdb/mysql/bin/mysqld(my_print_stacktrace+0x2e)[0xde610e] /home/fds/ferdb/mysql/bin/mysqld(handle_fatal_signal+0x471)[0x7de601] /lib64/libpthread.so.0[0x363e80f7e0] /lib64/libc.so.6(gsignal+0x35)[0x363e032495] /lib64/libc.so.6(abort+0x175)[0x363e033c75] /home/fds/ferdb/mysql/bin/mysqld[0xbafc13] /home/fds/ferdb/mysql/bin/mysqld[0xad7f63] /home/fds/ferdb/mysql/bin/mysqld[0xb0e9e3] /home/fds/ferdb/mysql/bin/mysqld[0xa2b73a] /home/fds/ferdb/mysql/bin/mysqld(_Z8closefrmP5TABLE+0x11e)[0x6a811e] /home/fds/ferdb/mysql/bin/mysqld(_Z12tc_add_tableP3THDP5TABLE+0x333)[0x76b053] /home/fds/ferdb/mysql/bin/mysqld(_Z10open_tableP3THDP10TABLE_LISTP18Open_table_context+0xb83)[0x59d9c3] /home/fds/ferdb/mysql/bin/mysqld(_Z11open_tablesP3THDRK14DDL_options_stPP10TABLE_LISTPjjP19Prelocking_strategy+0xe77)[0x59f0b7] /home/fds/ferdb/mysql/bin/mysqld(_Z29mysqld_show_create_get_fieldsP3THDP10TABLE_LISTP4ListI4ItemEP6String+0xca)[0x665f9a] /home/fds/ferdb/mysql/bin/mysqld(_Z18mysqld_show_createP3THDP10TABLE_LIST+0x99)[0x666d59] /home/fds/ferdb/mysql/bin/mysqld(_Z21mysql_execute_commandP3THD+0x5902)[0x5eebd2] /home/fds/ferdb/mysql/bin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x3a2)[0x5f4272] /home/fds/ferdb/mysql/bin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x26f0)[0x5f7190] /home/fds/ferdb/mysql/bin/mysqld(_Z10do_commandP3THD+0x15d)[0x5f84cd] /home/fds/ferdb/mysql/bin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x235)[0x6dc865] /home/fds/ferdb/mysql/bin/mysqld(handle_one_connection+0x3f)[0x6dca2f] /home/fds/ferdb/mysql/bin/mysqld[0xa054a9] /lib64/libpthread.so.0[0x363e807aa1] /lib64/libc.so.6(clone+0x6d)[0x363e0e8bcd] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7efcdc0155a0): show create table `entitlements_diffs`.`_schema_changes` Connection ID (thread ID): 7902 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=on,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. 2018-03-06 9:59:41 140571098384160 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-03-06 9:59:41 140571098384160 [Note] InnoDB: Uses event mutexes 2018-03-06 9:59:41 140571098384160 [Note] InnoDB: Compressed tables use zlib 1.2.3 2018-03-06 9:59:41 140571098384160 [Note] InnoDB: Using Linux native AIO 2018-03-06 9:59:41 140571098384160 [Note] InnoDB: Number of pools: 1 2018-03-06 9:59:41 140571098384160 [Note] InnoDB: Using SSE2 crc32 instructions 2018-03-06 9:59:41 140571098384160 [Note] InnoDB: Initializing buffer pool, total size = 10G, instances = 8, chunk size = 128M 2018-03-06 9:59:41 140571098384160 [Note] InnoDB: Completed initialization of buffer pool 2018-03-06 9:59:41 140558339864320 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-03-06 9:59:41 140571098384160 [Note] InnoDB: Highest supported file format is Barracuda. 2018-03-06 9:59:41 140571098384160 [Note] InnoDB: Starting crash recovery from checkpoint LSN=5283107415573 2018-03-06 9:59:41 140571098384160 [Note] InnoDB: Starting final batch to recover 1 pages from redo log. 2018-03-06 9:59:42 140571098384160 [Note] InnoDB: Last binlog file '/home/fds/ferdb/mysql/data/mysql-bin.001839', position 9884328 2018-03-06 9:59:42 140571098384160 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-03-06 9:59:42 140571098384160 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-03-06 9:59:42 140571098384160 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-03-06 9:59:42 140571098384160 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-03-06 9:59:42 140571098384160 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-03-06 9:59:42 140571098384160 [Note] InnoDB: Waiting for purge to start 2018-03-06 9:59:43 140571098384160 [Note] InnoDB: 5.7.20 started; log sequence number 5283107416119 2018-03-06 9:59:43 140558547605248 [Note] InnoDB: Loading buffer pool(s) from /home/fds/ferdb/mysql_data/ib_buffer_pool 2018-03-06 9:59:43 140571098384160 [Note] Plugin 'FEEDBACK' is disabled. 2018-03-06 9:59:43 140571098384160 [Note] Recovering after a crash using /home/fds/ferdb/mysql/data/mysql-bin 2018-03-06 9:59:43 140571098384160 [Note] Starting crash recovery... 2018-03-06 9:59:43 140571098384160 [Note] Crash recovery finished. 2018-03-06 9:59:43 140571098384160 [Note] Server socket created on IP: '::'. 2018-03-06 9:59:43 140571098384160 [Note] Reading of all Master_info entries succeded 2018-03-06 9:59:43 140571098384160 [Note] Added new Master_info '' to hash table 2018-03-06 9:59:43 140571098384160 [Note] /home/fds/ferdb/mysql/bin/mysqld: ready for connections. Version: '10.2.12-MariaDB-log' socket: '/home/fds/ferdb/mysql/data/mysql.sock' port: 3364 MariaDB Server 2018-03-06 9:59:43 140570455979776 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.001719' at position 119192136, relay log '/home/fds/ferdb/mysql/data/ibsqlstagea04-relay-bin.718308' position: 544 2018-03-06 9:59:43 140570456282880 [Note] Slave I/O thread: connected to master 'replication@ibsqlstagea05:3364',replication started in log 'mysql-bin.001719' at position 119192136 2018-03-06 9:59:58 140558547605248 [Note] InnoDB: Buffer pool(s) load completed at 180306 9:59:58 2018-03-06 10:00:40 140569920182016 [Note] Start binlog_dump to slave_server(4), pos(mysql-bin.001839, 9884328) 2018-03-06 10:39:04 0x7fd653beb700 InnoDB: Assertion failure in file /home/buildbot/buildbot/build/storage/innobase/que/que0que.cc line 567 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to https://jira.mariadb.org/ InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html InnoDB: about forcing recovery. 180306 10:39:04 [ERROR] mysqld got signal 6 ; 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.12-MariaDB-log key_buffer_size=268435456 read_buffer_size=131072 max_used_connections=18 max_threads=502 thread_count=27 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 1365189 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7fd918000b18 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 = 0x7fd653beae18 thread_stack 0x49000 /home/fds/ferdb/mysql/bin/mysqld(my_print_stacktrace+0x2e)[0xde610e] /home/fds/ferdb/mysql/bin/mysqld(handle_fatal_signal+0x471)[0x7de601] /lib64/libpthread.so.0[0x363e80f7e0] /lib64/libc.so.6(gsignal+0x35)[0x363e032495] /lib64/libc.so.6(abort+0x175)[0x363e033c75] /home/fds/ferdb/mysql/bin/mysqld[0xbafc13] /home/fds/ferdb/mysql/bin/mysqld[0xad7f63] /home/fds/ferdb/mysql/bin/mysqld[0xb0e9e3] /home/fds/ferdb/mysql/bin/mysqld[0xa2b73a] /home/fds/ferdb/mysql/bin/mysqld(_Z8closefrmP5TABLE+0x11e)[0x6a811e] /home/fds/ferdb/mysql/bin/mysqld(_Z12tc_add_tableP3THDP5TABLE+0x333)[0x76b053] /home/fds/ferdb/mysql/bin/mysqld(_Z10open_tableP3THDP10TABLE_LISTP18Open_table_context+0xb83)[0x59d9c3] /home/fds/ferdb/mysql/bin/mysqld(_Z11open_tablesP3THDRK14DDL_options_stPP10TABLE_LISTPjjP19Prelocking_strategy+0xe77)[0x59f0b7] /home/fds/ferdb/mysql/bin/mysqld(_Z29mysqld_show_create_get_fieldsP3THDP10TABLE_LISTP4ListI4ItemEP6String+0xca)[0x665f9a] /home/fds/ferdb/mysql/bin/mysqld(_Z18mysqld_show_createP3THDP10TABLE_LIST+0x99)[0x666d59] /home/fds/ferdb/mysql/bin/mysqld(_Z21mysql_execute_commandP3THD+0x5902)[0x5eebd2] /home/fds/ferdb/mysql/bin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x3a2)[0x5f4272] /home/fds/ferdb/mysql/bin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x26f0)[0x5f7190] /home/fds/ferdb/mysql/bin/mysqld(_Z10do_commandP3THD+0x15d)[0x5f84cd] /home/fds/ferdb/mysql/bin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x235)[0x6dc865] /home/fds/ferdb/mysql/bin/mysqld(handle_one_connection+0x3f)[0x6dca2f] /home/fds/ferdb/mysql/bin/mysqld[0xa054a9] /lib64/libpthread.so.0[0x363e807aa1] /lib64/libc.so.6(clone+0x6d)[0x363e0e8bcd] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7fd91800f1b0): show create table `entdata_utf8`.`corp_user_group_log` Connection ID (thread ID): 2774 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=on,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. 2018-03-06 10:39:07 139967994976032 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-03-06 10:39:07 139967994976032 [Note] InnoDB: Uses event mutexes 2018-03-06 10:39:07 139967994976032 [Note] InnoDB: Compressed tables use zlib 1.2.3 2018-03-06 10:39:07 139967994976032 [Note] InnoDB: Using Linux native AIO 2018-03-06 10:39:07 139967994976032 [Note] InnoDB: Number of pools: 1 2018-03-06 10:39:07 139967994976032 [Note] InnoDB: Using SSE2 crc32 instructions 2018-03-06 10:39:07 139967994976032 [Note] InnoDB: Initializing buffer pool, total size = 10G, instances = 8, chunk size = 128M 2018-03-06 10:39:07 139967994976032 [Note] InnoDB: Completed initialization of buffer pool 2018-03-06 10:39:08 139955232503552 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-03-06 10:39:08 139967994976032 [Note] InnoDB: Highest supported file format is Barracuda. 2018-03-06 10:39:08 139967994976032 [Note] InnoDB: Starting crash recovery from checkpoint LSN=5283116140385 2018-03-06 10:39:08 139967994976032 [Note] InnoDB: Starting final batch to recover 5 pages from redo log. 2018-03-06 10:39:09 139967994976032 [Note] InnoDB: Last binlog file '/home/fds/ferdb/mysql/data/mysql-bin.001840', position 3498665 2018-03-06 10:39:09 139967994976032 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-03-06 10:39:09 139967994976032 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-03-06 10:39:09 139967994976032 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-03-06 10:39:09 139967994976032 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-03-06 10:39:09 139967994976032 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-03-06 10:39:09 139967994976032 [Note] InnoDB: Waiting for purge to start 2018-03-06 10:39:09 139967994976032 [Note] InnoDB: 5.7.20 started; log sequence number 5283116141520 2018-03-06 10:39:09 139955440244480 [Note] InnoDB: Loading buffer pool(s) from /home/fds/ferdb/mysql_data/ib_buffer_pool 2018-03-06 10:39:09 139967994976032 [Note] Plugin 'FEEDBACK' is disabled. 2018-03-06 10:39:09 139967994976032 [Note] Recovering after a crash using /home/fds/ferdb/mysql/data/mysql-bin 2018-03-06 10:39:09 139967994976032 [Note] Starting crash recovery... 2018-03-06 10:39:09 139967994976032 [Note] Crash recovery finished. 2018-03-06 10:39:09 139967994976032 [Note] Server socket created on IP: '::'. 2018-03-06 10:39:09 139967994976032 [Note] Reading of all Master_info entries succeded 2018-03-06 10:39:09 139967994976032 [Note] Added new Master_info '' to hash table 2018-03-06 10:39:09 139967994976032 [Note] /home/fds/ferdb/mysql/bin/mysqld: ready for connections. Version: '10.2.12-MariaDB-log' socket: '/home/fds/ferdb/mysql/data/mysql.sock' port: 3364 MariaDB Server 2018-03-06 10:39:09 139967352567552 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.001719' at position 120938979, relay log '/home/fds/ferdb/mysql/data/ibsqlstagea04-relay-bin.718310' position: 544 2018-03-06 10:39:09 139967352870656 [Note] Slave I/O thread: connected to master 'replication@ibsqlstagea05:3364',replication started in log 'mysql-bin.001719' at position 120938979 2018-03-06 10:39:27 139955440244480 [Note] InnoDB: Buffer pool(s) load completed at 180306 10:39:27 2018-03-06 10:40:07 139967351744256 [Note] Start binlog_dump to slave_server(4), pos(mysql-bin.001840, 3498665)