Skip to content

Instantly share code, notes, and snippets.

MariaDB [(none)]> kill 179;
ERROR 1095 (HY000): You are not owner of thread 179
MariaDB [(none)]> show processlist;
+-----+-------------+-----------------+------+---------+-------+---------------------------------+------------------------------------------------------------------------------------------------------+----------+
| Id | User | Host | db | Command | Time | State | Info | Progress |
+-----+-------------+-----------------+------+---------+-------+---------------------------------+------------------------------------------------------------------------------------------------------+----------+
| 1 | system user | | NULL | Sleep | 12121 | wsrep aborter idle | NULL | 0.000 |
| 2 | system user | | NULL | Sleep
CREATE TABLE `a` (
`a_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`b_id` int(10) unsigned NOT NULL,
`c_id` int(10) unsigned NOT NULL,
`d_id` int(10) unsigned DEFAULT NULL,
`e` varchar(20) NOT NULL,
`f` tinyint(3) unsigned NOT NULL,
`g` tinyint(3) unsigned NOT NULL,
`h` int(10) unsigned NOT NULL,
`i` char(1) NOT NULL,
engines/funcs.tc_partition_list_directory 'innodb' w2 [ fail ]
Test ended at 2016-09-13 15:49:12
CURRENT_TEST: engines/funcs.tc_partition_list_directory
mysqltest: At line 17: query 'CREATE TABLE t1 (id INTEGER NOT NULL, name VARCHAR(30), adate DATE)
PARTITION BY LIST(YEAR(adate))
(
PARTITION p1999 VALUES IN (1995, 1999, 2003)
DATA DIRECTORY = '$MYSQLTEST_VARDIR/tmp/tc_partition_list_directory/p1999/data'
INDEX DIRECTORY = '$MYSQLTEST_VARDIR/tmp/tc_partition_list_directory/p1999/idx',
mysqld: /data/src/10.1-bug/sql/sql_cache.cc:1176: void Query_cache::end_of_result(THD*): Assertion `thd->get_stmt_da()->is_eof()' failed.
160916 3:24:12 [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,
Thread 3 (Thread 0x7f60e2928b00 (LWP 15833)):
#0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185
#1 0x00007f60e231b5ae in safe_cond_wait (cond=0x7f60e2d0ee98 <query_cache+88>, mp=0x7f60e2d0eee0 <query_cache+160>, file=0x7f60e238f240 "/data/src/10.1-bug
/include/mysql/psi/mysql_thread.h", line=1165) at /data/src/10.1-bug/mysys/thr_mutex.c:493
#2 0x00007f60e1a2eec9 in inline_mysql_cond_wait (that=0x7f60e2d0ee98 <query_cache+88>, mutex=0x7f60e2d0eee0 <query_cache+160>, src_file=0x7f60e238f338 "/da
ta/src/10.1-bug/sql/sql_cache.cc", src_line=696) at /data/src/10.1-bug/include/mysql/psi/mysql_thread.h:1165
#3 0x00007f60e1a2f852 in Query_cache::lock_and_suspend (this=0x7f60e2d0ee40 <query_cache>) at /data/src/10.1-bug/sql/sql_cache.cc:696
#4 0x00007f60e1a30f1c in Query_cache::resize (this=0x7f60e2d0ee40 <query_cache>, query_cache_size_arg=262144) at /data/src/10.1-bug/sql/sql_cache.cc:1300
#5 0x00007f60e1bce180 in fix_query_cache_size (self=0x7f60e2d27400 <S
--enable_connect_log
set global query_cache_type=1, query_cache_size=1024*1024;
CREATE TABLE t1 (id int(10) NOT NULL auto_increment PRIMARY KEY);
INSERT INTO t1 VALUES (NULL),(NULL);
--connect (con8,localhost,root,,test)
--send
SELECT * FROM t1;
160922 16:09:02 [ERROR] mysqld got exception 0xc0000005 ;
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.
2016-09-22 16:09:01 2464 [Note] InnoDB: Online DDL : End of applying row log
2016-09-22 16:09:01 728 [Note] InnoDB: Online DDL : End of applying row log
2016-09-22 16:09:01 2464 [Note] InnoDB: Online DDL : Completed
2016-09-22 16:09:01 728 [Note] InnoDB: Online DDL : Completed
2016-09-22 16:09:02 4072 [Note] InnoDB: Online DDL : Start
2016-09-22 16:09:02 4072 [Note] InnoDB: Online DDL : Start reading clustered index of the table and create temporary files
2016-09-22 16:09:02 4072 [Note] InnoDB: Online DDL : End of reading clustered index of the table and create temporary files
2016-09-22 16:09:02 4072 [Note] InnoDB: Online DDL : Start applying row log
2016-09-22 16:09:02 4072 [Note] InnoDB: Online DDL : End of applying row log
2016-09-22 16:09:02 4072 [Note] InnoDB: Online DDL : Completed
2016-09-29 0:32:26 140093372975872 [Note] WSREP: New cluster view: global state: 0d4f7e0a-85c3-11e6-9042-db93ed55b54e:0, view# 1: Primary, number of nodes: 1, my index: 0, protocol version 3
2016-09-29 0:32:37 140094459464448 [Note] /usr/sbin/mysqld: Normal shutdown
2016-09-29 0:32:37 140094459464448 [Note] WSREP: Stop replication
2016-09-29 0:32:37 140094459464448 [Note] WSREP: Closing send monitor...
2016-09-29 0:32:37 140094459464448 [Note] WSREP: Closed send monitor.
2016-09-29 0:32:37 140094459464448 [Note] WSREP: gcomm: terminating thread
2016-09-29 0:32:37 140094459464448 [Note] WSREP: gcomm: joining thread
2016-09-29 0:32:37 140094459464448 [Note] WSREP: gcomm: closing backend
2016-09-29 0:32:37 140094459464448 [Note] WSREP: view((empty))
diff --git a/mysql-test/suite/innodb_zip/r/innochecksum_3.result b/mysql-test/suite/innodb_zip/r/innochecksum_3.result
index 8b1bdec..e019442 100644
--- a/mysql-test/suite/innodb_zip/r/innochecksum_3.result
+++ b/mysql-test/suite/innodb_zip/r/innochecksum_3.result
@@ -184,7 +184,7 @@ no-check FALSE
allow-mismatches 0
write crc32
page-type-summary FALSE
-page-type-dump /dev/shm/tmp/dump.txt
+page-type-dump MYSQLTEST_VARDIR/tmp/dump.txt