Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.1.4
Description
Use one of the below test cases few times:
Thread 1 (Thread 0x7f00a8ff9700 (LWP 9273)):
|
#0 0x00007f00ce79c621 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
|
#1 0x00007f00d0fd949a in my_write_core (sig=6) at /home/jan/mysql/10.1-encryption/mysys/stacktrace.c:456
|
#2 0x00007f00d0986390 in handle_fatal_signal (sig=6) at /home/jan/mysql/10.1-encryption/sql/signal_handler.cc:266
|
#3 <signal handler called>
|
#4 0x00007f00cddf6cc9 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56
|
#5 0x00007f00cddfa0d8 in __GI_abort () at abort.c:89
|
#6 0x00007f00d0f21a55 in fil_space_get_space (id=2441) at /home/jan/mysql/10.1-encryption/storage/xtradb/fil/fil0fil.cc:1449
|
#7 0x00007f00d0f21ca0 in fil_space_get_flags (id=2441) at /home/jan/mysql/10.1-encryption/storage/xtradb/fil/fil0fil.cc:1554
|
#8 0x00007f00d0f21cfc in fil_space_get_zip_size (id=2441) at /home/jan/mysql/10.1-encryption/storage/xtradb/fil/fil0fil.cc:1581
|
#9 0x00007f00d0e98ab8 in btr_scrub_start_space (space=2441, scrub_data=0x7f00a8ff8e78) at /home/jan/mysql/10.1-encryption/storage/xtradb/btr/btr0scrub.cc:826
|
#10 0x00007f00d0f3262d in fil_crypt_space_needs_rotation (state=0x7f00a8ff8e10, key_state=0x7f00a8ff8e00, recheck=0x7f00a8ff8deb) at /home/jan/mysql/10.1-encryption/storage/xtradb/fil/fil0crypt.cc:1347
|
#11 0x00007f00d0f32c4f in fil_crypt_find_space_to_rotate (key_state=0x7f00a8ff8e00, state=0x7f00a8ff8e10, recheck=0x7f00a8ff8deb) at /home/jan/mysql/10.1-encryption/storage/xtradb/fil/fil0crypt.cc:1584
|
#12 0x00007f00d0f341bf in fil_crypt_thread (arg=0x0) at /home/jan/mysql/10.1-encryption/storage/xtradb/fil/fil0crypt.cc:2239
|
#13 0x00007f00ce797182 in start_thread (arg=0x7f00a8ff9700) at pthread_create.c:312
|
#14 0x00007f00cdeba47d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
|
query:
|
INSERT IGNORE INTO _table ( _field ) VALUES ( _digit ), ( _digit ), ( _digit ), ( _digit ) |
|
DELETE FROM _table WHERE `pk` > _digit LIMIT 4 ;
|
|
thread2:
|
set_encrypt_option |
|
create_or_replace;
|
|
set_encrypt_option:
|
SET GLOBAL innodb_encrypt_tables = enc_tables |
|
SET GLOBAL innodb_encryption_threads = _digit |
|
SET GLOBAL innodb_scrub_log_speed = _smallint_unsigned
|
;
|
|
encrypt_on_off:
|
ON | OFF ;
|
|
enc_tables:
|
ON | OFF | 'FORCE' ;
|
|
create_or_replace:
|
CREATE OR REPLACE TABLE `create_or_replace_t` AS SELECT * FROM _table ;
|
RQG data template enc2.zz |
$tables = {
|
rows => [0, 1, 10 ],
|
pk => [ 'int auto_increment' ]
|
};
|
|
$fields = {
|
types => [ 'int' ],
|
indexes => [ 'key', undef ]
|
};
|
|
$data = {
|
numbers => [ 'digit', 'null', undef ],
|
strings => [ 'letter', 'english' ],
|
blobs => [ 'data' ],
|
temporals => ['date', 'year', 'null', undef ]
|
}
|
RQG command line (use lp:~elenst/randgen/mariadb-patches):
perl ./runall-new.pl --threads=2 --duration=400 --queries=100M --mysqld=--plugin-load-add=file_key_management.so --mysqld=--file_key_management_filename=<your basedir>/mysql-test/std_data/keys.txt --grammar=enc2.yy --gendata=enc2.zz --mtr-build-thread=73 --basedir1=<your basedir> --vardir1=<your vardir>
|
See MDEV-8171 for instructions how to run the same test several times.