MySQL Bugs: #87573: InnoDB: Failing assertion: strchr(path, '/') != _

Bug #87573	InnoDB: Failing assertion: strchr(path, '/') != __null
Submitted:	29 Aug 2017 7:45	Modified:	29 Aug 2017 8:06
Reporter:	Roel Van de Paar	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: InnoDB storage engine	Severity:	S6 (Debug Builds)
Version:	5.7.19, 5.7.42	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
Core was generated by `/sda/MS250817-mysql-5.7.19-linux-x86_64-debug/bin/mysqld --no-defaults --core-f'.
Program terminated with signal 6, Aborted.
#0  0x00007f2241462741 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
61	  val = INTERNAL_SYSCALL (tgkill, err, 3, THREAD_GETMEM (THREAD_SELF, pid),
(gdb) bt
#0  0x00007f2241462741 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
#1  0x0000000001836ef0 in my_write_core (sig=6) at /git/mysql-server_dbg/mysys/stacktrace.c:249
#2  0x0000000000e7d8b2 in handle_fatal_signal (sig=6) at /git/mysql-server_dbg/sql/signal_handler.cc:220
#3  <signal handler called>
#4  0x00007f223f7f61d7 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56
#5  0x00007f223f7f78c8 in __GI_abort () at abort.c:90
#6  0x0000000001b9faae in ut_dbg_assertion_failed (expr=0x215ed20 "strchr(path, '/') != __null", 
    file=0x215dd20 "/git/mysql-server_dbg/storage/innobase/fil/fil0fil.cc", line=2074)
    at /git/mysql-server_dbg/storage/innobase/ut/ut0dbg.cc:67
#7  0x0000000001c833e4 in fil_op_write_log (type=MLOG_FILE_CREATE2, space_id=24, first_page_no=0, 
    path=0x7f2203c2f238 ".Öibport_s12.ibd", new_path=0x0, flags=2048, mtr=0x7f2241a50f90)
    at /git/mysql-server_dbg/storage/innobase/fil/fil0fil.cc:2074
#8  0x0000000001c87f7a in fil_ibd_create (space_id=24, name=0x7f2203c2f1d8 "ibport_s12", path=0x7f2203c33458 ".Öibport_s12.ibd", 
    flags=2048, size=4) at /git/mysql-server_dbg/storage/innobase/fil/fil0fil.cc:3764
#9  0x0000000001c37fd0 in dict_build_tablespace (tablespace=0x7f2241a52200)
    at /git/mysql-server_dbg/storage/innobase/dict/dict0crea.cc:417
#10 0x0000000001979384 in innobase_create_tablespace (hton=0x7f223aff94a0, thd=0x7f2203c19000, alter_info=0x7f2203c2c9e8)
    at /git/mysql-server_dbg/storage/innobase/handler/ha_innodb.cc:12812
#11 0x000000000197988c in innobase_alter_tablespace (hton=0x7f223aff94a0, thd=0x7f2203c19000, alter_info=0x7f2203c2c9e8)
    at /git/mysql-server_dbg/storage/innobase/handler/ha_innodb.cc:12941
#12 0x000000000159bc72 in mysql_alter_tablespace (thd=0x7f2203c19000, ts_info=0x7f2203c2c9e8)
    at /git/mysql-server_dbg/sql/sql_tablespace.cc:163
#13 0x0000000001505aca in mysql_execute_command (thd=0x7f2203c19000, first_level=true)
    at /git/mysql-server_dbg/sql/sql_parse.cc:4809
#14 0x0000000001507902 in mysql_parse (thd=0x7f2203c19000, parser_state=0x7f2241a53550)
    at /git/mysql-server_dbg/sql/sql_parse.cc:5574
#15 0x00000000014fd1d4 in dispatch_command (thd=0x7f2203c19000, com_data=0x7f2241a53cb0, command=COM_QUERY)
    at /git/mysql-server_dbg/sql/sql_parse.cc:1461
#16 0x00000000014fc0c6 in do_command (thd=0x7f2203c19000) at /git/mysql-server_dbg/sql/sql_parse.cc:999
#17 0x000000000162c436 in handle_connection (arg=0x7f2216a2c860)
    at /git/mysql-server_dbg/sql/conn_handler/connection_handler_per_thread.cc:300
#18 0x000000000186363b in pfs_spawn_thread (arg=0x7f2227fe0220) at /git/mysql-server_dbg/storage/perfschema/pfs.cc:2188
#19 0x00007f224145ddc5 in start_thread (arg=0x7f2241a54700) at pthread_create.c:308
#20 0x00007f223f8b873d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113

How to repeat:
DROP DATABASE test;CREATE DATABASE test;USE test;
SET @@character_set_client = swe7;
CREATE TABLESPACE ibport_s12 ADD DATAFILE '.\\ibport_s12.ibd';
SELECT 1; # shows server is gone if not already shown in last statement

Hello Roel,

Thank you for the report and test case.
Observed that 5.7.19 debug build is affected.

Thanks,
Umesh

Posted by developer:
 
I can't reproduce on latest 8.0.