Nov 17 10:11:37 UBINTI mysqld[6004]: Version: '10.2.10-MariaDB-10.2.10+maria~zesty-log'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution

Nov 17 10:11:38 UBINTI systemd[1]: Started MariaDB database server.

Nov 17 10:12:47 UBINTI mysqld[6004]: 2017-11-17 10:12:47 139650531075840 [ERROR] Invalid (old?) table or database name '.rocksdb'

Nov 17 10:13:30 UBINTI mysqld[6004]: 171117 10:13:30 [ERROR] mysqld got signal 11 ;

Nov 17 10:13:30 UBINTI mysqld[6004]: This could be because you hit a bug. It is also possible that this binary

Nov 17 10:13:30 UBINTI mysqld[6004]: or one of the libraries it was linked against is corrupt, improperly built,

Nov 17 10:13:30 UBINTI mysqld[6004]: or misconfigured. This error can also be caused by malfunctioning hardware.

Nov 17 10:13:30 UBINTI mysqld[6004]: To report this bug, see https://mariadb.com/kb/en/reporting-bugs

Nov 17 10:13:30 UBINTI mysqld[6004]: We will try our best to scrape up some info that will hopefully help

Nov 17 10:13:30 UBINTI mysqld[6004]: diagnose the problem, but since we have already crashed,

Nov 17 10:13:30 UBINTI mysqld[6004]: something is definitely wrong and this may fail.

Nov 17 10:13:30 UBINTI mysqld[6004]: Server version: 10.2.10-MariaDB-10.2.10+maria~zesty-log

Nov 17 10:13:30 UBINTI mysqld[6004]: key_buffer_size=134217728

Nov 17 10:13:30 UBINTI mysqld[6004]: read_buffer_size=2097152

Nov 17 10:13:30 UBINTI mysqld[6004]: max_used_connections=1

Nov 17 10:13:30 UBINTI mysqld[6004]: max_threads=102

Nov 17 10:13:30 UBINTI mysqld[6004]: thread_count=8

Nov 17 10:13:30 UBINTI mysqld[6004]: It is possible that mysqld could use up to

Nov 17 10:13:30 UBINTI mysqld[6004]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 759899 K  bytes of memory

Nov 17 10:13:30 UBINTI mysqld[6004]: Hope that's ok; if not, decrease some variables in the equation.

Nov 17 10:13:30 UBINTI mysqld[6004]: Thread pointer: 0x7f02780009a8

Nov 17 10:13:30 UBINTI mysqld[6004]: Attempting backtrace. You can use the following information to find out

Nov 17 10:13:30 UBINTI mysqld[6004]: where mysqld died. If you see no messages after this, something went

Nov 17 10:13:30 UBINTI mysqld[6004]: terribly wrong...

Nov 17 10:13:30 UBINTI mysqld[6004]: stack_bottom = 0x7f02ee1a0d18 thread_stack 0x49000

Nov 17 10:13:30 UBINTI mysqld[6004]: /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x555b8c8d022e]

Nov 17 10:13:31 UBINTI mysqld[6004]: /usr/sbin/mysqld(handle_fatal_signal+0x3cd)[0x555b8c36ed9d]

Nov 17 10:13:31 UBINTI mysqld[6004]: /lib/x86_64-linux-gnu/libpthread.so.0(+0x11670)[0x7f0308cf8670]

Nov 17 10:13:31 UBINTI mysqld[6004]: /usr/sbin/mysqld(_ZN13MYSQL_BIN_LOG13mark_xid_doneEmb+0x97)[0x555b8c43d357]

Nov 17 10:13:31 UBINTI mysqld[6004]: /usr/sbin/mysqld(binlog_background_thread+0x323)[0x555b8c43da33]

Nov 17 10:13:31 UBINTI mysqld[6004]: /lib/x86_64-linux-gnu/libpthread.so.0(+0x76da)[0x7f0308cee6da]

Nov 17 10:13:31 UBINTI mysqld[6004]: /lib/x86_64-linux-gnu/libc.so.6(clone+0x5f)[0x7f0308397d7f]

Nov 17 10:13:31 UBINTI mysqld[6004]: Trying to get some variables.

Nov 17 10:13:31 UBINTI mysqld[6004]: Some pointers may be invalid and cause the dump to abort.

Nov 17 10:13:31 UBINTI mysqld[6004]: Query (0x0):

Nov 17 10:13:31 UBINTI mysqld[6004]: Connection ID (thread ID): 6

Nov 17 10:13:31 UBINTI mysqld[6004]: Status: NOT_KILLED

MariaDB [(none)]> show plugins;

+-------------------------------+----------+--------------------+---------------+---------+

| Name                          | Status   | Type               | Library       | License |

+-------------------------------+----------+--------------------+---------------+---------+

| binlog                        | ACTIVE   | STORAGE ENGINE     | NULL          | GPL     |

| mysql_native_password         | ACTIVE   | AUTHENTICATION     | NULL          | GPL     |

| mysql_old_password            | ACTIVE   | AUTHENTICATION     | NULL          | GPL     |

| wsrep                         | ACTIVE   | STORAGE ENGINE     | NULL          | GPL     |

| CSV                           | ACTIVE   | STORAGE ENGINE     | NULL          | GPL     |

| MEMORY                        | ACTIVE   | STORAGE ENGINE     | NULL          | GPL     |

| MyISAM                        | ACTIVE   | STORAGE ENGINE     | NULL          | GPL     |

| MRG_MyISAM                    | ACTIVE   | STORAGE ENGINE     | NULL          | GPL     |

| CLIENT_STATISTICS             | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |

| INDEX_STATISTICS              | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |

| TABLE_STATISTICS              | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |

| USER_STATISTICS               | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |

| InnoDB                        | ACTIVE   | STORAGE ENGINE     | NULL          | GPL     |

| INNODB_TRX                    | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |

| INNODB_LOCKS                  | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |

| INNODB_LOCK_WAITS             | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |

| INNODB_CMP                    | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |

| INNODB_CMP_RESET              | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |

| INNODB_CMPMEM                 | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |

| INNODB_CMPMEM_RESET           | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |

| INNODB_CMP_PER_INDEX          | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |

| INNODB_CMP_PER_INDEX_RESET    | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |

| INNODB_BUFFER_PAGE            | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |

| INNODB_BUFFER_PAGE_LRU        | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |

| INNODB_BUFFER_POOL_STATS      | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |

| INNODB_METRICS                | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |

| INNODB_FT_DEFAULT_STOPWORD    | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |

| INNODB_FT_DELETED             | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |

| INNODB_FT_BEING_DELETED       | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |

| INNODB_FT_CONFIG              | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |

| INNODB_FT_INDEX_CACHE         | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |

| INNODB_FT_INDEX_TABLE         | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |

| INNODB_SYS_TABLES             | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |

| INNODB_SYS_TABLESTATS         | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |

| INNODB_SYS_INDEXES            | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |

| INNODB_SYS_COLUMNS            | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |

| INNODB_SYS_FIELDS             | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |

| INNODB_SYS_FOREIGN            | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |

| INNODB_SYS_FOREIGN_COLS       | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |

| INNODB_SYS_TABLESPACES        | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |

| INNODB_SYS_DATAFILES          | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |

| INNODB_SYS_VIRTUAL            | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |

| INNODB_MUTEXES                | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |

| INNODB_SYS_SEMAPHORE_WAITS    | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |

| INNODB_TABLESPACES_ENCRYPTION | ACTIVE   | INFORMATION SCHEMA | NULL          | BSD     |

| INNODB_TABLESPACES_SCRUBBING  | ACTIVE   | INFORMATION SCHEMA | NULL          | BSD     |

| Aria                          | ACTIVE   | STORAGE ENGINE     | NULL          | GPL     |

| PERFORMANCE_SCHEMA            | ACTIVE   | STORAGE ENGINE     | NULL          | GPL     |

| SEQUENCE                      | ACTIVE   | STORAGE ENGINE     | NULL          | GPL     |

| FEEDBACK                      | DISABLED | INFORMATION SCHEMA | NULL          | GPL     |

| user_variables                | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |

| partition                     | ACTIVE   | STORAGE ENGINE     | NULL          | GPL     |

| ROCKSDB                       | ACTIVE   | STORAGE ENGINE     | ha_rocksdb.so | GPL     |

| ROCKSDB_CFSTATS               | ACTIVE   | INFORMATION SCHEMA | ha_rocksdb.so | GPL     |

| ROCKSDB_DBSTATS               | ACTIVE   | INFORMATION SCHEMA | ha_rocksdb.so | GPL     |

| ROCKSDB_PERF_CONTEXT          | ACTIVE   | INFORMATION SCHEMA | ha_rocksdb.so | GPL     |

| ROCKSDB_PERF_CONTEXT_GLOBAL   | ACTIVE   | INFORMATION SCHEMA | ha_rocksdb.so | GPL     |

| ROCKSDB_CF_OPTIONS            | ACTIVE   | INFORMATION SCHEMA | ha_rocksdb.so | GPL     |

| ROCKSDB_COMPACTION_STATS      | ACTIVE   | INFORMATION SCHEMA | ha_rocksdb.so | GPL     |

| ROCKSDB_GLOBAL_INFO           | ACTIVE   | INFORMATION SCHEMA | ha_rocksdb.so | GPL     |

| ROCKSDB_DDL                   | ACTIVE   | INFORMATION SCHEMA | ha_rocksdb.so | GPL     |

| ROCKSDB_INDEX_FILE_MAP        | ACTIVE   | INFORMATION SCHEMA | ha_rocksdb.so | GPL     |

| ROCKSDB_LOCKS                 | ACTIVE   | INFORMATION SCHEMA | ha_rocksdb.so | GPL     |

| ROCKSDB_TRX                   | ACTIVE   | INFORMATION SCHEMA | ha_rocksdb.so | GPL     |

+-------------------------------+----------+--------------------+---------------+---------+

64 rows in set (0.01 sec)

MariaDB [(none)]> use test

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Database changed

MariaDB [test]> flush binary logs;

Query OK, 0 rows affected (0.15 sec)

MariaDB [test]> select 1;

ERROR 2006 (HY000): MySQL server has gone away

No connection. Trying to reconnect...

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)

ERROR: Can't connect to the server

unknown [test]> flush binary logs;

No connection. Trying to reconnect...

Connection id:    9

Current database: test

Query OK, 0 rows affected (0.15 sec)

MariaDB [test]> select 1;

ERROR 2006 (HY000): MySQL server has gone away

No connection. Trying to reconnect...

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)

ERROR: Can't connect to the server

unknown [test]> 

unknown [test]> 

unknown [test]> uninstall soname 'ha_rocksdb';

No connection. Trying to reconnect...

Connection id:    9

Current database: test

Query OK, 0 rows affected (0.09 sec)

MariaDB [test]> select 1;

+---+

| 1 |

+---+

| 1 |

+---+

1 row in set (0.00 sec)

MariaDB [test]> flush binary logs;

Query OK, 0 rows affected (0.15 sec)

MariaDB [test]> select 1;

+---+

| 1 |

+---+

| 1 |

+---+

1 row in set (0.00 sec)

MariaDB [test]> install soname 'ha_rocksdb';

ERROR 2013 (HY000): Lost connection to MySQL server during query

MariaDB [test]> install soname 'ha_rocksdb';

ERROR 2006 (HY000): MySQL server has gone away

No connection. Trying to reconnect...

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)

ERROR: Can't connect to the server

unknown [test]> install soname 'ha_rocksdb';

No connection. Trying to reconnect...

Connection id:    9

Current database: test

Query OK, 0 rows affected (0.00 sec)

MariaDB [test]> select 1;

+---+

| 1 |

+---+

| 1 |

+---+

1 row in set (0.00 sec)

MariaDB [test]> flush binary logs;

Query OK, 0 rows affected (0.16 sec)

MariaDB [test]> select 1;

ERROR 2006 (HY000): MySQL server has gone away

No connection. Trying to reconnect...

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)

ERROR: Can't connect to the server

unknown [test]> uninstall soname 'ha_rocksdb';

No connection. Trying to reconnect...

Connection id:    9

Current database: test

Query OK, 0 rows affected (0.08 sec)

MariaDB [test]> select 1;

+---+

| 1 |

+---+

| 1 |

+---+

1 row in set (0.00 sec)

MariaDB [test]> flush binary logs;

Query OK, 0 rows affected (0.14 sec)

MariaDB [test]> select 1;

+---+

| 1 |

+---+

| 1 |

+---+

1 row in set (0.00 sec)

MariaDB [test]> flush binary logs;

Query OK, 0 rows affected (0.18 sec)

MariaDB [test]> select 1;

+---+

| 1 |

+---+

| 1 |

+---+

1 row in set (0.00 sec)

MariaDB [test]> install soname 'ha_rocksdb';

ERROR 2013 (HY000): Lost connection to MySQL server during query

MariaDB [test]> install soname 'ha_rocksdb';

ERROR 2006 (HY000): MySQL server has gone away

No connection. Trying to reconnect...

Connection id:    9

Current database: test

Query OK, 0 rows affected (0.01 sec)

MariaDB [test]> create table tt engine=rocksdb select 1;

Query OK, 1 row affected (0.14 sec)

Records: 1  Duplicates: 0  Warnings: 0

MariaDB [test]> select 1;

+---+

| 1 |

+---+

| 1 |

+---+

1 row in set (0.00 sec)

MariaDB [test]> flush binary logs;

Query OK, 0 rows affected (0.16 sec)

MariaDB [test]> select 1;

ERROR 2006 (HY000): MySQL server has gone away

No connection. Trying to reconnect...

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)

ERROR: Can't connect to the server

--source include/have_rocksdb.inc

flush binary logs;

do sleep(2);

create table t engine=rocksdb select 1;

flush binary logs;

do sleep(5);

drop table t;

flush binary logs;

select 'passed';

./mtr binlog_rotate --suite=rocksdb --mysqld=--log-bin --mysqld=--binlog-format=row

Logging: /home/a/env1/m8-10.2/src/mysql-test/mysql-test-run.pl  binlog_rotate --suite=rocksdb --mysqld=--log-bin --mysqld=--binlog-format=row

Using binlog format 'row'

vardir: /home/a/env1/_depot/m-branch/m8-10.2-bld/mysql-test/var

Checking leftover processes...

Removing old var directory...

Creating var directory '/home/a/env1/_depot/m-branch/m8-10.2-bld/mysql-test/var'...

Checking supported features...

MariaDB Version 10.2.11-MariaDB

 - SSL connections supported

Collecting tests...

Installing system database...

==============================================================================

TEST                                      RESULT   TIME (ms) or COMMENT

--------------------------------------------------------------------------

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019

flush binary logs;

do sleep(2);

create table t engine=rocksdb select 1;

flush binary logs;

do sleep(5);

drop table t;

flush binary logs;

select 'passed';

passed

passed

rocksdb.binlog_rotate                    [ pass ]   7258

--------------------------------------------------------------------------

The servers were restarted 0 times

Spent 7.258 of 14 seconds executing testcases

Completed: All 1 tests were successful.

./mtr binlog_rotate --suite=rocksdb --mysqld=--log-bin --mysqld=--binlog-format=row --mysqld=--innodb

Logging: /home/a/env1/m8-10.2/src/mysql-test/mysql-test-run.pl  binlog_rotate --suite=rocksdb --mysqld=--log-bin --mysqld=--binlog-format=row --mysqld=--innodb

Using binlog format 'row'

vardir: /home/a/env1/_depot/m-branch/m8-10.2-bld/mysql-test/var

Checking leftover processes...

Removing old var directory...

Creating var directory '/home/a/env1/_depot/m-branch/m8-10.2-bld/mysql-test/var'...

Checking supported features...

MariaDB Version 10.2.11-MariaDB

 - SSL connections supported

Collecting tests...

Installing system database...

==============================================================================

TEST                                      RESULT   TIME (ms) or COMMENT

--------------------------------------------------------------------------

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019

flush binary logs;

do sleep(2);

create table t engine=rocksdb select 1;

flush binary logs;

do sleep(5);

rocksdb.binlog_rotate                    [ fail ]

        Test ended at 2017-11-17 13:51:57

CURRENT_TEST: rocksdb.binlog_rotate

mysqltest: At line 8: query 'do sleep(5)' failed: 2013: Lost connection to MySQL server during query

Server [mysqld.1 - pid: 5142, winpid: 5142, exit: 256] failed during test run

Server log from this test:

----------SERVER LOG START-----------

2017-11-17 13:51:54 140295267206976 [Note] /home/a/env1/m8-10.2/bld/sql/mysqld (mysqld 10.2.11-MariaDB-log) starting as process 5143 ...

2017-11-17 13:51:54 140295267206976 [Warning] Could not increase number of max_open_files to more than 1024 (request: 4162)

2017-11-17 13:51:54 140295267206976 [Note] RocksDB: Got ENOENT when listing column families

2017-11-17 13:51:54 140295267206976 [Note] RocksDB:   assuming that we're creating a new database

2017-11-17 13:51:54 140295267206976 [Note] RocksDB: Column Families at start:

2017-11-17 13:51:54 140295267206976 [Note]   cf=default

2017-11-17 13:51:54 140295267206976 [Note]     write_buffer_size=67108864

2017-11-17 13:51:54 140295267206976 [Note]     target_file_size_base=67108864

2017-11-17 13:51:54 140295267206976 [Note] RocksDB: creating a column family __system__

2017-11-17 13:51:54 140295267206976 [Note]     write_buffer_size=67108864

2017-11-17 13:51:54 140295267206976 [Note]     target_file_size_base=67108864

2017-11-17 13:51:54 140295267206976 [Note] RocksDB: Table_store: loaded DDL data for 0 tables

2017-11-17 13:51:54 140295267206976 [Note] RocksDB: global statistics using get_sched_indexer_t indexer

2017-11-17 13:51:54 140295267206976 [Note] MyRocks storage engine plugin has been successfully initialized.

2017-11-17 13:51:54 140295267206976 [Note] Plugin 'SEQUENCE' is disabled.

2017-11-17 13:51:54 140295267206976 [Note] Plugin 'partition' is disabled.

2017-11-17 13:51:54 140295267206976 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2017-11-17 13:51:54 140295267206976 [Note] InnoDB: Uses event mutexes

2017-11-17 13:51:54 140295267206976 [Note] InnoDB: Compressed tables use zlib 1.2.11

2017-11-17 13:51:54 140295267206976 [Note] InnoDB: Using Linux native AIO

2017-11-17 13:51:54 140295267206976 [Note] InnoDB: Number of pools: 1

2017-11-17 13:51:54 140295267206976 [Note] InnoDB: Using SSE2 crc32 instructions

2017-11-17 13:51:54 140295267206976 [Note] InnoDB: Initializing buffer pool, total size = 8M, instances = 1, chunk size = 8M

2017-11-17 13:51:54 140295267206976 [Note] InnoDB: Completed initialization of buffer pool

2017-11-17 13:51:54 140294695642880 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().

2017-11-17 13:51:54 140295267206976 [Note] InnoDB: Highest supported file format is Barracuda.

2017-11-17 13:51:54 140295267206976 [Note] InnoDB: 128 out of 128 rollback segments are active.

2017-11-17 13:51:54 140295267206976 [Note] InnoDB: Creating shared tablespace for temporary tables

2017-11-17 13:51:54 140295267206976 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...

2017-11-17 13:51:54 140295267206976 [Note] InnoDB: File './ibtmp1' size is now 12 MB.

2017-11-17 13:51:54 140295267206976 [Note] InnoDB: 5.7.20 started; log sequence number 1633766

2017-11-17 13:51:54 140294527887104 [Note] InnoDB: Loading buffer pool(s) from /home/a/env1/_depot/m-branch/m8-10.2-bld/mysql-test/var/mysqld.1/data/ib_buffer_pool

2017-11-17 13:51:54 140294527887104 [Note] InnoDB: Buffer pool(s) load completed at 171117 13:51:54

2017-11-17 13:51:54 140295267206976 [Note] Plugin 'INNODB_SYS_DATAFILES' is disabled.

2017-11-17 13:51:54 140295267206976 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled.

2017-11-17 13:51:54 140295267206976 [Note] Plugin 'INNODB_LOCKS' is disabled.

2017-11-17 13:51:54 140295267206976 [Note] Plugin 'INNODB_MUTEXES' is disabled.

2017-11-17 13:51:54 140295267206976 [Note] Plugin 'INNODB_CMPMEM' is disabled.

2017-11-17 13:51:54 140295267206976 [Note] Plugin 'INNODB_CMP_PER_INDEX' is disabled.

2017-11-17 13:51:54 140295267206976 [Note] Plugin 'INNODB_CMP' is disabled.

2017-11-17 13:51:54 140295267206976 [Note] Plugin 'INNODB_TABLESPACES_ENCRYPTION' is disabled.

2017-11-17 13:51:54 140295267206976 [Note] Plugin 'INNODB_CMP_RESET' is disabled.

2017-11-17 13:51:54 140295267206976 [Note] Plugin 'INNODB_SYS_INDEXES' is disabled.

2017-11-17 13:51:54 140295267206976 [Note] Plugin 'INNODB_BUFFER_PAGE_LRU' is disabled.

2017-11-17 13:51:54 140295267206976 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled.

2017-11-17 13:51:54 140295267206976 [Note] Plugin 'INNODB_SYS_COLUMNS' is disabled.

2017-11-17 13:51:54 140295267206976 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled.

2017-11-17 13:51:54 140295267206976 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled.

2017-11-17 13:51:54 140295267206976 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled.

2017-11-17 13:51:54 140295267206976 [Note] Plugin 'INNODB_SYS_FOREIGN_COLS' is disabled.

2017-11-17 13:51:54 140295267206976 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled.

2017-11-17 13:51:54 140295267206976 [Note] Plugin 'INNODB_TRX' is disabled.

2017-11-17 13:51:54 140295267206976 [Note] Plugin 'INNODB_SYS_FOREIGN' is disabled.

2017-11-17 13:51:54 140295267206976 [Note] Plugin 'INNODB_SYS_TABLES' is disabled.

2017-11-17 13:51:54 140295267206976 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled.

2017-11-17 13:51:54 140295267206976 [Note] Plugin 'INNODB_FT_CONFIG' is disabled.

2017-11-17 13:51:54 140295267206976 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled.

2017-11-17 13:51:54 140295267206976 [Note] Plugin 'INNODB_TABLESPACES_SCRUBBING' is disabled.

2017-11-17 13:51:54 140295267206976 [Note] Plugin 'INNODB_SYS_SEMAPHORE_WAITS' is disabled.

2017-11-17 13:51:54 140295267206976 [Note] Plugin 'INNODB_SYS_FIELDS' is disabled.

2017-11-17 13:51:54 140295267206976 [Note] Plugin 'INNODB_METRICS' is disabled.

2017-11-17 13:51:54 140295267206976 [Note] Plugin 'INNODB_FT_DELETED' is disabled.

2017-11-17 13:51:54 140295267206976 [Note] Plugin 'user_variables' is disabled.

2017-11-17 13:51:54 140295267206976 [Note] Plugin 'INNODB_BUFFER_POOL_STATS' is disabled.

2017-11-17 13:51:54 140295267206976 [Note] Plugin 'INNODB_LOCK_WAITS' is disabled.

2017-11-17 13:51:54 140295267206976 [Note] Plugin 'INNODB_SYS_VIRTUAL' is disabled.

2017-11-17 13:51:54 140295267206976 [Note] Plugin 'INNODB_BUFFER_PAGE' is disabled.

2017-11-17 13:51:54 140295267206976 [Note] Plugin 'FEEDBACK' is disabled.

2017-11-17 13:51:54 140295267206976 [Warning] /home/a/env1/m8-10.2/bld/sql/mysqld: unknown variable 'loose-feedback-debug-startup-interval=20'

2017-11-17 13:51:54 140295267206976 [Warning] /home/a/env1/m8-10.2/bld/sql/mysqld: unknown variable 'loose-feedback-debug-first-interval=60'

2017-11-17 13:51:54 140295267206976 [Warning] /home/a/env1/m8-10.2/bld/sql/mysqld: unknown variable 'loose-feedback-debug-interval=60'

2017-11-17 13:51:54 140295267206976 [Warning] /home/a/env1/m8-10.2/bld/sql/mysqld: unknown option '--loose-pam-debug'

2017-11-17 13:51:54 140295267206976 [Warning] /home/a/env1/m8-10.2/bld/sql/mysqld: unknown option '--loose-enable-rocksdb_lock_info'

2017-11-17 13:51:54 140295267206976 [Warning] /home/a/env1/m8-10.2/bld/sql/mysqld: unknown variable 'loose-debug-sync-timeout=300'

2017-11-17 13:51:54 140295267206976 [Note] Server socket created on IP: '127.0.0.1'.

2017-11-17 13:51:54 140295267206976 [Note] /home/a/env1/m8-10.2/bld/sql/mysqld: ready for connections.

Version: '10.2.11-MariaDB-log'  socket: '/home/a/env1/_depot/m-branch/m8-10.2-bld/mysql-test/var/tmp/mysqld.1.sock'  port: 16000  Source distribution

2017-11-17 13:51:55 140294768772864 [Note] RocksDB: Manual memtable flush.

171117 13:51:57 [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.11-MariaDB-log

key_buffer_size=1048576

read_buffer_size=131072

max_used_connections=1

max_threads=153

thread_count=8

It is possible that mysqld could use up to 

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

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

Thread pointer: 0x7f98a40009a8

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

/home/a/env1/m8-10.2/bld/sql/mysqld(my_print_stacktrace+0x29)[0x5627b085bc39]

/home/a/env1/m8-10.2/bld/sql/mysqld(handle_fatal_signal+0x3bd)[0x5627b039aabd]

/lib/x86_64-linux-gnu/libpthread.so.0(+0x11670)[0x7f99085ff670]

/home/a/env1/m8-10.2/bld/sql/mysqld(_ZN13MYSQL_BIN_LOG13mark_xid_doneEmb+0x9f)[0x5627b045929f]

/home/a/env1/m8-10.2/bld/sql/mysqld(binlog_background_thread+0x30b)[0x5627b045995b]

/home/a/env1/m8-10.2/bld/sql/mysqld(+0xab32d4)[0x5627b08242d4]

mysys/stacktrace.c:268(my_print_stacktrace)[0x7f99085f56da]

sql/log.cc:9462(MYSQL_BIN_LOG::mark_xid_done(unsigned long, bool))[0x7f9907a87d7f]

Trying to get some variables.

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

Query (0x0): 

Connection ID (thread ID): 6

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.

Writing a core file

----------SERVER LOG END-------------

 - saving '/home/a/env1/_depot/m-branch/m8-10.2-bld/mysql-test/var/log/rocksdb.binlog_rotate/' to '/home/a/env1/_depot/m-branch/m8-10.2-bld/mysql-test/var/log/rocksdb.binlog_rotate/'

--------------------------------------------------------------------------

The servers were restarted 0 times

Spent 0.000 of 8 seconds executing testcases

Failure: Failed 1/1 tests, 0.00% were successful.

Failing test(s): rocksdb.binlog_rotate

The log files in var/log may give you some hint of what went wrong.

If you want to report this error, please read first the documentation

at http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html

mysql-test-run: *** ERROR: there were failing test cases

2017-11-20  9:44:29 0 [Note] /home/a/env1/m7-10.3/bld/sql//mysqld: ready for connections.

Version: '10.3.3-MariaDB-log'  socket: '/home/a/env1/m7-10.3/dt/my.sock'  port: 3313  Source distribution

171120  9:44:41 [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.3.3-MariaDB-log

key_buffer_size=134217728

read_buffer_size=131072

max_used_connections=1

max_threads=153

thread_count=8

It is possible that mysqld could use up to

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

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

Thread pointer: 0x7fec140009a8

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

/home/a/env1/m7-10.3/bld/sql//mysqld(my_print_stacktrace+0x29)[0x5638ea857009]

/home/a/env1/m7-10.3/bld/sql//mysqld(handle_fatal_signal+0x3bf)[0x5638ea38f08f]

/lib/x86_64-linux-gnu/libpthread.so.0(+0x11670)[0x7fec948b7670]

/home/a/env1/m7-10.3/bld/sql//mysqld(_ZN13MYSQL_BIN_LOG13mark_xid_doneEmb+0x9f)[0x5638ea44ef5f]

/home/a/env1/m7-10.3/bld/sql//mysqld(binlog_background_thread+0x323)[0x5638ea44f613]

/lib/x86_64-linux-gnu/libpthread.so.0(+0x76da)[0x7fec948ad6da]

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

Trying to get some variables.

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

Query (0x0):

Connection ID (thread ID): 6

Status: NOT_KILLED

  mysqld: /home/psergey/dev-git/10.2-mariarocks-r4/sql/log.cc:9580: void MYSQL_BIN_LOG::mark_xid_done(ulong, bool): Assertion `b->xid_count >= 0' failed.

(gdb) wher

  #0  0x00007ffff5931267 in __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:55

  #1  0x00007ffff5932eca in __GI_abort () at abort.c:89

  #2  0x00007ffff592a03d in __assert_fail_base (fmt=0x7ffff5a8c028 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x555556694ad0 "b->xid_count >= 0", file=file@entry=0x555556691078 "/home/psergey/dev-git/10.2-mariarocks-r4/sql/log.cc", line=line@entry=9580, function=function@entry=0x555556696f80 <MYSQL_BIN_LOG::mark_xid_done(unsigned long, bool)::__PRETTY_FUNCTION__> "void MYSQL_BIN_LOG::mark_xid_done(ulong, bool)") at assert.c:92

  #3  0x00007ffff592a0f2 in __GI___assert_fail (assertion=0x555556694ad0 "b->xid_count >= 0", file=0x555556691078 "/home/psergey/dev-git/10.2-mariarocks-r4/sql/log.cc", line=9580, function=0x555556696f80 <MYSQL_BIN_LOG::mark_xid_done(unsigned long, bool)::__PRETTY_FUNCTION__> "void MYSQL_BIN_LOG::mark_xid_done(ulong, bool)") at assert.c:101

  #4  0x0000555555e85681 in MYSQL_BIN_LOG::mark_xid_done (this=0x5555570e4480 <mysql_bin_log>, binlog_id=2, write_checkpoint=true) at /home/psergey/dev-git/10.2-mariarocks-r4/sql/log.cc:9580

  #5  0x0000555555e85f1d in binlog_background_thread (arg=0x0) at /home/psergey/dev-git/10.2-mariarocks-r4/sql/log.cc:9784

commit 77872e4519a9ebba2cd2ab4f5794faccf0a1f879

Author: Elena Stepanova <elenst@montyprogram.com>

Date:   Mon Nov 27 12:04:51 2017 +0200

    Additions to the list of unstable tests for 10.2.11

[mysqld]

binlog-format=row

log_bin=pslp

sync_binlog=1

server-id=12

set global max_binlog_size=1024000;

CREATE TABLE `tslap2` (

  `pk` int(11) NOT NULL AUTO_INCREMENT,

  `a` varchar(255) DEFAULT NULL,

  `b` varchar(255) DEFAULT NULL,

  `c` varchar(255) DEFAULT NULL,

  `d` varchar(255) DEFAULT NULL,

  PRIMARY KEY (`pk`)

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

#!/usr/bin/perl

for ($i =0; $i < 1000*1000; $i++) { 

  print "insert into tslap2 (a,b,c,d) values (repeat(uuid(),7),repeat(uuid(),7),repeat(uuid(),7),repeat(uuid(),7));\n";

}

perl file1.pl | mysql -uroot -A --socket=/tmp/mysql4.sock test

commit 2c1e4d4d7a174c180cfcac5e245840aec8458b77

Author: Sergei Petrunia <psergey@askmonty.org>

Date:   Tue Dec 5 16:33:38 2017 +0300

    MDEV-14563: Wrong query plan for query with no PK

diff --git a/sql/log.cc b/sql/log.cc

index 93d7a00..52e24b2 100644

--- a/sql/log.cc

+++ b/sql/log.cc

@@ -9535,6 +9535,8 @@ TC_LOG_BINLOG::mark_xids_active(ulong binlog_id, uint xid_count)

   {

     if (b->binlog_id == binlog_id)

     {

+      fprintf(stderr,"TC_LOG_BINLOG::mark_xids_active binlog_id=%ld,  %ld + %ld\n",

+              binlog_id, b->xid_count, xid_count);

       b->xid_count += xid_count;

       break;

     }

@@ -9575,7 +9577,9 @@ TC_LOG_BINLOG::mark_xid_done(ulong binlog_id, bool write_checkpoint)

   {

     if (b->binlog_id == binlog_id)

     {

+      //fprintf(stderr,"TC_LOG_BINLOG::mark_xids_active %d %d\n", binlog_id, xid_count);

       --b->xid_count;

+      fprintf(stderr, "TC_LOG_BINLOG::mark_xid_done (x-1= %ld)\n", b->xid_count);

       DBUG_ASSERT(b->xid_count >= 0); // catch unmatched (++) decrement