Multiple test failures (rpl.rpl_*)
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
New
|
Undecided
|
Unassigned | ||
Gentoo Linux |
Fix Released
|
Critical
|
Bug Description
On Gentoo Linux, we are seeing the following test failures:
rpl.rpl_
rpl.rpl_
rpl.rpl_
rpl.rpl_relayrotate
rpl.rpl_
rpl.rpl_
rpl.rpl_
rpl.rpl_
Excerpt:
CURRENT_TEST: rpl.rpl_
mysqltest: In included file "./extra/
included from ./extra/
At line 85: query 'UPDATE t2, t1 SET t2.data = CONCAT($data, $data, $data, $data),
t1.data = CONCAT($data, $data, $data, $data)' failed with wrong errno 2013: 'Lost connection to MySQL server during query', instead of 1197...
The result from queries just before the failure was:
include/
Warnings:
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
[connection master]
call mtr.add_
call mtr.add_
SET GLOBAL max_binlog_
Warnings:
Warning 1738 Option binlog_cache_size (32768) is greater than max_binlog_
SET GLOBAL binlog_cache_size = 4096;
SET GLOBAL max_binlog_
Warnings:
Warning 1745 Option binlog_
SET GLOBAL binlog_
CREATE TABLE t1(a INT PRIMARY KEY, data VARCHAR(30000)) ENGINE=Innodb;
CREATE TABLE t2(a INT PRIMARY KEY, data VARCHAR(30000)) ENGINE=MyIsam;
CREATE TABLE t3(a INT PRIMARY KEY, data VARCHAR(30000)) ENGINE=Innodb;
###### 1 - SINGLE STATEMENT ######
*** Single statement on transactional table ***
Got one of the listed errors
*** Single statement on non-transactional table ***
Got one of the listed errors
include/
*** Single statement on both transactional and non-transactional tables. ***
safe_process[
Server [mysqld.1 - pid: 70285, winpid: 70285, exit: 256] failed during test run
Server log from this test:
----------SERVER LOG START-----------
2017-12-03 18:44:56 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_
2017-12-03 18:44:56 0 [Warning] Insecure configuration for --secure-file-priv: Data directory is accessible through --secure-file-priv. Consider choosing a different directory.
2017-12-03 18:44:56 0 [Warning] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory.
2017-12-03 18:44:56 0 [Note] /var/tmp/
2017-12-03 18:44:56 70286 [Warning] Buffered warning: Could not increase number of max_open_files to more than 3000 (request: 4162)
2017-12-03 18:44:56 70286 [Warning] Buffered warning: Changed limits: table_open_cache: 1419 (requested 2000)
2017-12-03 18:44:56 70286 [Note] Plugin 'FEDERATED' is disabled.
2017-12-03 18:44:56 70286 [Warning] The option innodb (skip-innodb) is deprecated and will be removed in a future release
2017-12-03 18:44:56 7f4da6e66f40 InnoDB: Warning: Using innodb_
2017-12-03 18:44:56 70286 [Note] InnoDB: innodb_
2017-12-03 18:44:56 70286 [Note] InnoDB: Using atomics to ref count buffer pool pages
2017-12-03 18:44:56 70286 [Note] InnoDB: The InnoDB memory heap is disabled
2017-12-03 18:44:56 70286 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-12-03 18:44:56 70286 [Note] InnoDB: Memory barrier is not used
2017-12-03 18:44:56 70286 [Note] InnoDB: Compressed tables use zlib 1.2.11
2017-12-03 18:44:56 70286 [Note] InnoDB: Using Linux native AIO
2017-12-03 18:44:56 70286 [Note] InnoDB: Using CPU crc32 instructions
2017-12-03 18:44:56 70286 [Note] InnoDB: Initializing buffer pool, size = 8.0M
2017-12-03 18:44:56 70286 [Note] InnoDB: Completed initialization of buffer pool
2017-12-03 18:44:56 70286 [Note] InnoDB: Highest supported file format is Barracuda.
2017-12-03 18:44:56 70286 [Note] InnoDB: 128 rollback segment(s) are active.
2017-12-03 18:44:56 70286 [Note] InnoDB: Waiting for purge to start
2017-12-03 18:44:56 70286 [Note] InnoDB: Percona XtraDB (http://
2017-12-03 18:44:56 70286 [Warning] /var/tmp/
2017-12-03 18:44:56 70286 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: e9a2b36e-
2017-12-03 18:44:56 70286 [Note] RSA private key file not found: /var/tmp/
2017-12-03 18:44:56 70286 [Note] RSA public key file not found: /var/tmp/
2017-12-03 18:44:56 70286 [Note] Server hostname (bind-address): '*'; port: 10441
2017-12-03 18:44:56 70286 [Note] IPv6 is available.
2017-12-03 18:44:56 70286 [Note] - '::' resolves to '::';
2017-12-03 18:44:56 70286 [Note] Server socket created on IP: '::'.
2017-12-03 18:44:56 70286 [Note] Event Scheduler: Loaded 0 events
2017-12-03 18:44:56 70286 [Note] /var/tmp/
Version: '5.6.37-82.2-log' socket: '/var/tmp/
15:44:57 UTC - 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.
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.
Please help us make Percona Server better by reporting any
bugs at http://
key_buffer_
read_buffer_
max_used_
max_threads=153
thread_count=6
connection_count=6
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_
Hope that's ok; if not, decrease some variables in the equation.
Thread pointer: 0x7f4d9d2df800
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 = 7f4da6ce5690 thread_stack 0x40000
/var/tmp/
/var/tmp/
/lib64/
/var/tmp/
/var/tmp/
/var/tmp/
/var/tmp/
/var/tmp/
/var/tmp/
/var/tmp/
/var/tmp/
/var/tmp/
/var/tmp/
/var/tmp/
/var/tmp/
/var/tmp/
/var/tmp/
/var/tmp/
/var/tmp/
/var/tmp/
/var/tmp/
/var/tmp/
/var/tmp/
/var/tmp/
/var/tmp/
/var/tmp/
/var/tmp/
/var/tmp/
/var/tmp/
/var/tmp/
/lib64/
/lib64/
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (7f4d8f2e1490): UPDATE t2, t1 SET t2.data = CONCAT(
Connection ID (thread ID): 8
Status: NOT_KILLED
You may download the Percona Server operations manual by visiting
http://
in the manual which will help you identify the cause of the crash.
Writing a core file
safe_process[
----------SERVER LOG END-------------
- saving '/var/tmp/
Changed in gentoo: | |
importance: | Unknown → Critical |
Changed in gentoo: | |
status: | Unknown → Fix Released |
System uname: Linux-4. 14.3-gentoo- x86_64- Intel-R- _Core-TM- _i7-3770K_ CPU_@_3. 50GHz-with- gentoo- 2.4.1 426ae8ee293d16f 61ccd1a80f
KiB Mem: 8134984 total, 1112276 free
KiB Swap: 1048572 total, 1048572 free
Timestamp of repository gentoo: Sun, 03 Dec 2017 14:47:52 +0000
Head commit of repository gentoo: 5298e145f0830b5
sh dash 0.5.9.1-r3 java-config: 2.2.0-r3::gentoo baselayout: 2.4.1-r2::gentoo gcc-config: 1.9.0::gentoo linux-headers: 4.13::gentoo (virtual/ os-headers)
ld GNU ld (Gentoo 2.29.1 p3) 2.29.1
app-shells/bash: 4.4_p12::gentoo
dev-java/
dev-lang/perl: 5.26.1-r1::gentoo
dev-lang/python: 2.7.14-r1::gentoo, 3.4.6-r1::gentoo, 3.5.4-r1::gentoo, 3.6.3-r1::gentoo
dev-util/cmake: 3.10.0::gentoo
dev-util/pkgconfig: 0.29.2::gentoo
sys-apps/
sys-apps/openrc: 0.34.11::gentoo
sys-apps/sandbox: 2.12::gentoo
sys-devel/autoconf: 2.69-r4::gentoo
sys-devel/automake: 1.13.4-r1::gentoo, 1.15.1-r1::gentoo
sys-devel/binutils: 2.29.1-r1::gentoo
sys-devel/gcc: 7.2.0::gentoo
sys-devel/
sys-devel/libtool: 2.4.6-r4::gentoo
sys-devel/make: 4.2.1-r1::gentoo
sys-kernel/
sys-libs/glibc: 2.26-r3::gentoo