CREATE table .. SELECT * from <table> fails if destination table is from other SE that is not aware of fake-changes
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Fix Released
|
Medium
|
Krunal Bauskar | ||
5.1 |
Won't Fix
|
Medium
|
Unassigned | ||
5.5 |
Fix Released
|
Medium
|
Krunal Bauskar | ||
5.6 |
Fix Released
|
Medium
|
Krunal Bauskar |
Bug Description
Thread 1 (Thread 0x7f46c46ff700 (LWP 1967)):
+bt
#0 0x00007f46e2ad2771 in pthread_kill () from /lib64/
#1 0x0000000000ab6f6a in my_write_core (sig=6) at /mnt/workspace/
#2 0x000000000072f89f in handle_fatal_signal (sig=6) at /mnt/workspace/
#3 <signal handler called>
#4 0x00007f46e16d65c9 in raise () from /lib64/libc.so.6
#5 0x00007f46e16d7cd8 in abort () from /lib64/libc.so.6
#6 0x00007f46e16cf536 in __assert_fail_base () from /lib64/libc.so.6
#7 0x00007f46e16cf5e2 in __assert_fail () from /lib64/libc.so.6
#8 0x00000000007c9569 in select_
#9 0x00000000007ca9f7 in select_
#10 0x00000000008122d9 in handle_select (thd=0x25bd210, result=
#11 0x00000000007e3fd7 in mysql_execute_
#12 0x00000000007ed033 in mysql_parse (thd=0x25bd210, rawbuf=
#13 0x00000000007df49c in dispatch_command (command=COM_QUERY, thd=0x25bd210, packet=0x2dd1661 "create table t2_myisam as select * from t2;", packet_length=43) at /mnt/workspace/
#14 0x00000000007de3c8 in do_command (thd=0x25bd210) at /mnt/workspace/
#15 0x00000000007a6385 in do_handle_
#16 0x00000000007a5e8d in handle_
#17 0x0000000000dc5590 in pfs_spawn_thread (arg=0x2d88ad0) at /mnt/workspace/
#18 0x00007f46e2acddf3 in start_thread () from /lib64/
#19 0x00007f46e179701d in clone () from /lib64/libc.so.6
2014-10-06 21:46:19 1913 [Note] /sda/Percona-
Version: '5.6.21-69.0-debug' socket: '/dev/shm/
2014-10-06 21:46:19 7f46917fd700 InnoDB: FTS Optimize Removing table test/t1
2014-10-06 21:46:20 7f46917fd700 InnoDB: FTS Optimize Removing table test/t1
2014-10-06 21:46:20 1913 [Note] InnoDB: Saving InnoDB page number: 1
2014-10-06 21:46:20 1913 [Warning] Did not write failed 'GRANT ALL PRIVILEGES ON test_user_db.* TO plug IDENTIFIED WITH test_plugin_server AS 'plug_dest'' into binary log while granting/revoking privileges in databases.
2014-10-06 21:46:20 1913 [ERROR] InnoDB: The table data/#sql779_4_d doesn't have a corresponding tablespace, it was discarded.
2014-10-06 21:46:20 1913 [ERROR] InnoDB: The table data/#sql779_4_d doesn't have a corresponding tablespace, it was discarded.
2014-10-06 21:46:20 1913 [ERROR] InnoDB: The table data/#sql779_4_d doesn't have a corresponding tablespace, it was discarded.
2014-10-06 21:46:20 1913 [ERROR] InnoDB: The table data/#sql779_4_d doesn't have a corresponding tablespace, it was discarded.
2014-10-06 21:46:20 1913 [ERROR] InnoDB: The table data/#sql779_4_d doesn't have a corresponding tablespace, it was discarded.
2014-10-06 21:46:20 1913 [ERROR] InnoDB: The table data/#sql779_4_d doesn't have a corresponding tablespace, it was discarded.
2014-10-06 21:46:20 1913 [ERROR] InnoDB: The table data/#sql779_4_d doesn't have a corresponding tablespace, it was discarded.
2014-10-06 21:46:20 1913 [ERROR] InnoDB: The table data/#sql779_4_d doesn't have a corresponding tablespace, it was discarded.
2014-10-06 21:46:20 1913 [ERROR] InnoDB: The table data/#sql779_4_d doesn't have a corresponding tablespace, it was discarded.
2014-10-06 21:46:20 1913 [ERROR] InnoDB: The table data/#sql779_4_d doesn't have a corresponding tablespace, it was discarded.
2014-10-06 21:46:20 1913 [ERROR] InnoDB: The table data/#sql779_4_d doesn't have a corresponding tablespace, it was discarded.
2014-10-06 21:46:20 1913 [ERROR] InnoDB: The table data/#sql779_4_d doesn't have a corresponding tablespace, it was discarded.
2014-10-06 21:46:20 1913 [Warning] Could not remove temporary table: '/dev/shm/
2014-10-06 21:46:20 1913 [Note] InnoDB: Saving InnoDB page number: 10
2014-10-06 21:46:20 1913 [Warning] Did not write failed 'GRANT SELECT ON *.* TO mysqltest6@
2014-10-06 21:46:20 1913 [Note] Event Scheduler: scheduler thread started with id 16
mysqld: /mnt/workspace/
10:46:20 UTC - mysqld got signal 6 ;
[...]
Query (7f46840050a0): create table t2_myisam as select * from t2
Note "myisam" is just text here, not an actual table storage engine selection.
tags: | added: fake-changes |
summary: |
- sql/sql_insert.cc:3943: virtual void select_insert::abort_result_set(): - Assertion `transactional_table || !changed || - thd->transaction.stmt.cannot_safely_rollback()' failed. | abort (sig=6) - in select_insert::abort_result_set + CREATE table .. SELECT * from <table> fails if destination table is from + other SE that is not aware of fake-changes |
Issue is single threaded (original run was single threaded). Testcase creation with reducer failed, but all files are available. Upload below.