Bug #83120 virtual void Field::store_timestamp(const timeval*): Assertion `false' failed.
Submitted: 23 Sep 2016 5:07 Modified: 29 Nov 2016 15:07
Reporter: Roel Van de Paar Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Security: Privileges Severity:S1 (Critical)
Version:8.0-dmr OS:Any
Assigned to: CPU Architecture:Any

[23 Sep 2016 5:07] Roel Van de Paar
Description:
Version: '8.0.0-dmr-debug'  socket: '/sda/MS130916-mysql-8.0.0-dmr-linux-x86_64-debug/socket.sock'  port: 15348  MySQL Community Server (GPL)
mysqld: /git/MS8.0_dbg/sql/field.h:1030: virtual void Field::store_timestamp(const timeval*): Assertion `false' failed.
04:49:23 UTC - mysqld got signal 6 ;

+bt
#0  0x00007fa7fdf2d741 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
#1  0x00000000023fc1b9 in my_write_core (sig=6) at /git/MS8.0_dbg/mysys/stacktrace.cc:275
#2  0x0000000001b517ed in handle_fatal_signal (sig=6) at /git/MS8.0_dbg/sql/signal_handler.cc:219
#3  <signal handler called>
#4  0x00007fa7fc2c45f7 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56
#5  0x00007fa7fc2c5ce8 in __GI_abort () at abort.c:90
#6  0x00007fa7fc2bd566 in __assert_fail_base (fmt=0x7fa7fc40dce8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x2ff31b8 "false", file=file@entry=0x2ff319d "/git/MS8.0_dbg/sql/field.h", line=line@entry=1030, function=function@entry=0x2ff9180 <Field::store_timestamp(timeval const*)::__PRETTY_FUNCTION__> "virtual void Field::store_timestamp(const timeval*)") at assert.c:92
#7  0x00007fa7fc2bd612 in __GI___assert_fail (assertion=0x2ff31b8 "false", file=0x2ff319d "/git/MS8.0_dbg/sql/field.h", line=1030, function=0x2ff9180 <Field::store_timestamp(timeval const*)::__PRETTY_FUNCTION__> "virtual void Field::store_timestamp(const timeval*)") at assert.c:101
#8  0x0000000001c5515d in Field::store_timestamp (this=0x7fa7cbd058e0) at /git/MS8.0_dbg/sql/field.h:1030
#9  0x0000000001c04f79 in replace_user_table (thd=0x7fa7cbc19000, table=0x7fa7cbc71c20, combo=0x7fa7cbc2d9c0, rights=0, revoke_grant=false, can_create_user=true, what_to_replace=33) at /git/MS8.0_dbg/sql/auth/sql_user_table.cc:864
#10 0x0000000001bdaf42 in mysql_grant (thd=0x7fa7cbc19000, db=0x7fa7cbc2d9a0 "test", list=..., rights=1, revoke_grant=false, is_proxy=false) at /git/MS8.0_dbg/sql/auth/sql_authorization.cc:3332
#11 0x0000000001872175 in mysql_execute_command (thd=0x7fa7cbc19000, first_level=true) at /git/MS8.0_dbg/sql/sql_parse.cc:3818
#12 0x0000000001875c14 in mysql_parse (thd=0x7fa7cbc19000, parser_state=0x7fa7fe5204e0) at /git/MS8.0_dbg/sql/sql_parse.cc:5233
#13 0x000000000186c3b8 in dispatch_command (thd=0x7fa7cbc19000, com_data=0x7fa7fe520c70, command=COM_QUERY) at /git/MS8.0_dbg/sql/sql_parse.cc:1481
#14 0x000000000186b244 in do_command (thd=0x7fa7cbc19000) at /git/MS8.0_dbg/sql/sql_parse.cc:1043
#15 0x0000000001b43af1 in handle_connection (arg=0x7fa7cb56c080) at /git/MS8.0_dbg/sql/conn_handler/connection_handler_per_thread.cc:301
#16 0x000000000242bf29 in pfs_spawn_thread (arg=0x7fa7cb5e4f20) at /git/MS8.0_dbg/storage/perfschema/pfs.cc:2282
#17 0x00007fa7fdf28dc5 in start_thread (arg=0x7fa7fe521700) at pthread_create.c:308
#18 0x00007fa7fc385ced in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113

How to repeat:
DROP DATABASE test;CREATE DATABASE test;USE test;
ALTER TABLE mysql.user DROP COLUMN password_last_changed;
grant select on test.* to 'a'@'192.0.2.4';
[23 Sep 2016 5:40] MySQL Verification Team
Hello Roel,

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

Thanks,
Umesh
[29 Nov 2016 15:06] Georgi Kodinov
Posted by developer:
 
Fixed by the fix for bug #23295423