Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6
-
None
Description
INSTALL SONAME 'ha_archive'; |
|
CREATE TEMPORARY TABLE t (a INT) ENGINE=ARCHIVE; |
OPTIMIZE TABLE t; |
--error ER_CANT_CREATE_TABLE
|
ALTER TABLE t ADD PRIMARY KEY(a); |
|
# Cleanup
|
DROP TABLE t; |
UNINSTALL SONAME 'ha_archive'; |
10.2 aebb1112 |
mysqld: /data/src/10.2/mysys/my_pread.c:72: my_pread: Assertion `readbytes != (size_t)-1 || (*__errno_location ()) != 9' failed.
|
201216 17:33:25 [ERROR] mysqld got signal 6 ;
|
|
#7 0x00007f3655b84f36 in __GI___assert_fail (assertion=0x55f2dca685e0 "readbytes != (size_t)-1 || (*__errno_location ()) != 9", file=0x55f2dca68570 "/data/src/10.2/mysys/my_pread.c", line=72, function=0x55f2dca686b0 <__PRETTY_FUNCTION__.14575> "my_pread") at assert.c:101
|
#8 0x000055f2dc7244a7 in my_pread (Filedes=-1, Buffer=0x7f36504dc790 "\320\307MP6\177", Count=78, offset=0, MyFlags=0) at /data/src/10.2/mysys/my_pread.c:72
|
#9 0x00007f36504862e6 in azflush (s=0x7f3634055c20, flush=2) at /data/src/10.2/storage/archive/azio.c:691
|
#10 0x00007f365048baf9 in ha_archive::info (this=0x7f3634055798, flag=64) at /data/src/10.2/storage/archive/ha_archive.cc:1714
|
#11 0x00007f365048b7b9 in ha_archive::update_create_info (this=0x7f3634055798, create_info=0x7f36504de290) at /data/src/10.2/storage/archive/ha_archive.cc:1661
|
#12 0x000055f2dbe27ed1 in mysql_prepare_alter_table (thd=0x7f3634000d90, table=0x7f3634034e80, create_info=0x7f36504de290, alter_info=0x7f36504de1e0, alter_ctx=0x7f36504dd670) at /data/src/10.2/sql/sql_table.cc:8282
|
#13 0x000055f2dbe2a8ab in mysql_alter_table (thd=0x7f3634000d90, new_db=0x7f3634012df8 "test", new_name=0x0, create_info=0x7f36504de290, table_list=0x7f36340127e0, alter_info=0x7f36504de1e0, order_num=0, order=0x0, ignore=false) at /data/src/10.2/sql/sql_table.cc:9286
|
#14 0x000055f2dbea9824 in Sql_cmd_alter_table::execute (this=0x7f3634012ec0, thd=0x7f3634000d90) at /data/src/10.2/sql/sql_alter.cc:333
|
#15 0x000055f2dbd5816a in mysql_execute_command (thd=0x7f3634000d90) at /data/src/10.2/sql/sql_parse.cc:5993
|
#16 0x000055f2dbd5d181 in mysql_parse (thd=0x7f3634000d90, rawbuf=0x7f36340126f8 "ALTER TABLE t ADD PRIMARY KEY(a)", length=32, parser_state=0x7f36504df5f0, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7762
|
#17 0x000055f2dbd4b47a in dispatch_command (command=COM_QUERY, thd=0x7f3634000d90, packet=0x7f3634008b51 "ALTER TABLE t ADD PRIMARY KEY(a)", packet_length=32, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1827
|
#18 0x000055f2dbd49f75 in do_command (thd=0x7f3634000d90) at /data/src/10.2/sql/sql_parse.cc:1381
|
#19 0x000055f2dbea4219 in do_handle_one_connection (connect=0x55f2de0989c0) at /data/src/10.2/sql/sql_connect.cc:1336
|
#20 0x000055f2dbea3f7e in handle_one_connection (arg=0x55f2de0989c0) at /data/src/10.2/sql/sql_connect.cc:1241
|
#21 0x000055f2dc6cb95c in pfs_spawn_thread (arg=0x55f2de07bd80) at /data/src/10.2/storage/perfschema/pfs.cc:1869
|
#22 0x00007f3656094609 in start_thread (arg=<optimized out>) at pthread_create.c:477
|
#23 0x00007f3655c70293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|
Reproducible on 10.2-10.6.
No obvious problem on a non-debug build (it returns ER_CANT_CREATE_TABLE on ALTER, which is probably expected).