Bug #85059 | Assertion `length > 0' failed. in sql/field.cc:8732 | ||
---|---|---|---|
Submitted: | 18 Feb 2017 4:54 | Modified: | 17 Apr 2017 14:36 |
Reporter: | Roel Van de Paar | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: DML | Severity: | S1 (Critical) |
Version: | 5.7.17 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[18 Feb 2017 4:54]
Roel Van de Paar
[18 Feb 2017 11:39]
MySQL Verification Team
Hello Roel, Thank you for the report. May be you forgot to attache test case/tarball? Thanks, Umesh
[19 Feb 2017 22:18]
Roel Van de Paar
1486932221_bug_bundle.tar.gz
Attachment: 1486932221_bug_bundle.tar.gz (application/x-gzip, text), 1.79 MiB.
[19 Feb 2017 22:20]
Roel Van de Paar
Hi Umesh, Yes, thank you :) Done
[20 Feb 2017 7:03]
MySQL Verification Team
Thank you, observed that 5.7.17 debug build is affected. -- only debug build affacted rm -rf 85070 bin/mysqld --initialize-insecure --basedir=$PWD --datadir=$PWD/85070 -v bin/mysqld-debug --no-defaults --basedir=$PWD --datadir=$PWD/85070 --core-file --socket=/tmp/mysql_ushastry.sock --port=3306 --log-error=$PWD/85070/log.err 2>&1 & -- if required, set sql_mode='' 3rd attempt with the below test case triggered crash DROP DATABASE test;CREATE DATABASE test;USE test; SET default_storage_engine=ARCHIVE;#NOERROR CREATE TABLE t0(line LINESTRING NOT NULL)engine=aria;#NOERROR INSERT INTO t0 VALUES(null),(null),(null),(null),(null),(null);#NOERROR ALTER TABLE t0 ADD c TIMESTAMP DEFAULT '0-0-0 0:0:0'; (gdb) bt #0 0x00007f32386d3771 in pthread_kill () from /lib64/libpthread.so.0 #1 0x00000000018bfe19 in my_write_core (sig=6) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/mysys/stacktrace.c:249 #2 0x0000000000ecba80 in handle_fatal_signal (sig=6) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/signal_handler.cc:220 #3 <signal handler called> #4 0x00007f32372d95d7 in raise () from /lib64/libc.so.6 #5 0x00007f32372dacc8 in abort () from /lib64/libc.so.6 #6 0x00007f32372d2546 in __assert_fail_base () from /lib64/libc.so.6 #7 0x00007f32372d25f2 in __assert_fail () from /lib64/libc.so.6 #8 0x0000000000f1b1c1 in Field_geom::store_internal (this=0x7f31d8010b70, from=0x7f31d8010fa4 "", length=0, cs=0x2d97e20 <my_charset_bin>) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/field.cc:8732 #9 0x0000000000f19a07 in Field_blob::store (this=0x7f31d8010b70, from=0x7f31d8010fa4 "", length=0, cs=0x2d97e20 <my_charset_bin>) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/field.cc:8265 #10 0x0000000000f1ad3d in Field_blob::unpack (this=0x7f31d8010b70, to=0x7f31d8010b40 "", from=0x7f31d8010fa0 "", param_data=0, low_byte_first=true) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/field.cc:8623 #11 0x00000000014a3046 in Field::unpack (this=0x7f31d8010b70, to=0x7f31d8010b40 "", from=0x7f31d8010fa0 "") at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/field.h:1384 #12 0x0000000001dacc30 in ha_archive::unpack_row (this=0x7f31d803dc70, file_to_read=0x7f31d803df20, record=0x7f31d8010b40 "") at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/archive/ha_archive.cc:1258 #13 0x0000000001daccb2 in ha_archive::get_row_version3 (this=0x7f31d803dc70, file_to_read=0x7f31d803df20, buf=0x7f31d8010b40 "") at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/archive/ha_archive.cc:1269 #14 0x0000000001dac77e in ha_archive::get_row (this=0x7f31d803dc70, file_to_read=0x7f31d803df20, buf=0x7f31d8010b40 "") at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/archive/ha_archive.cc:1169 #15 0x0000000001dad1d8 in ha_archive::rnd_next (this=0x7f31d803dc70, buf=0x7f31d8010b40 "") at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/archive/ha_archive.cc:1375 #16 0x0000000000f45d48 in handler::ha_rnd_next (this=0x7f31d803dc70, buf=0x7f31d8010b40 "") at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/handler.cc:2947 #17 0x00000000014a1e14 in rr_sequential (info=0x7f322c05bb40) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/records.cc:510 #18 0x00000000016175e9 in copy_data_between_tables (psi=0x7f3233b012e8, from=0x7f31d8010190, to=0x7f31d801c350, create=..., copied=0x7f322c05d5a8, deleted=0x7f322c05d5a0, keys_onoff=Alter_info::LEAVE_AS_IS, alter_ctx=0x7f322c05bdb0) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/sql_table.cc:10277 #19 0x0000000001615c15 in mysql_alter_table (thd=0x7f31d8000b70, new_db=0x7f31d80064e8 "test", new_name=0x0, create_info=0x7f322c05dc40, table_list=0x7f31d8005f60, alter_info=0x7f322c05dd40) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/sql_table.cc:9823 #20 0x0000000001797605 in Sql_cmd_alter_table::execute (this=0x7f31d80066a8, thd=0x7f31d8000b70) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/sql_alter.cc:316 #21 0x0000000001580cec in mysql_execute_command (thd=0x7f31d8000b70, first_level=true) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/sql_parse.cc:4893 #22 0x0000000001582c75 in mysql_parse (thd=0x7f31d8000b70, parser_state=0x7f322c05f690) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/sql_parse.cc:5611 #23 0x00000000015774f6 in dispatch_command (thd=0x7f31d8000b70, com_data=0x7f322c05fe00, command=COM_QUERY) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/sql_parse.cc:1461 #24 0x00000000015762f9 in do_command (thd=0x7f31d8000b70) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/sql_parse.cc:999 #25 0x00000000016abfc4 in handle_connection (arg=0x413b730) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/conn_handler/connection_handler_per_thread.cc:300 #26 0x000000000194c420 in pfs_spawn_thread (arg=0x4129980) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/perfschema/pfs.cc:2188 #27 0x00007f32386cedf5 in start_thread () from /lib64/libpthread.so.0 #28 0x00007f323739a60d in clone () from /lib64/libc.so.6 (gdb)
[17 Apr 2017 14:36]
Paul DuBois
Posted by developer: Noted in 8.0.2 changelog. Failure occurred for ALTER TABLE on an ARCHIVE table containing a NOT NULL column having a geometry data type. For debug builds, an assertion was raised. For non-debug builds, an error occurred.