Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-24668

debug assert on SET PASSWORD when binlog fails

    XMLWordPrintable

    Details

      Description

      10.6.0 9118fd360a3da0bba521caf2a35c424968235ac4 (Debug)

      2021-01-25 10:27:32 561 [Warning] Next log extension: 2147483647. Remaining log filename extensions: 0. Please consider archiving some logs.
      2021-01-25 10:27:32 549 [ERROR] Log filename extension number exhausted: 2147483647. Please fix this by archiving old logs and updating the index files.
      2021-01-25 10:27:32 549 [ERROR] Can't generate a unique log-filename qa-roel-2-bin.(1-999)
       
      safe_mutex: Trying to unlock mutex lock that wasn't locked at /test/10.6_dbg/sql/sql_acl.cc, line 4011
      Last used at /test/10.6_dbg/sql/sql_acl.cc, line: 3947
      210125 10:27:32 [ERROR] mysqld got signal 6 ;
      

      10.6.0 9118fd360a3da0bba521caf2a35c424968235ac4 (Debug)

      Core was generated by `/test/MD010121-mariadb-10.6.0-linux-x86_64-dbg/bin/mysqld --no-defaults --core-'.
      Program terminated with signal SIGABRT, Aborted.
      #0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=6)
          at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
      [Current thread is 1 (Thread 0x146e4d13e700 (LWP 866255))]
      (gdb) bt
      #0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
      #1  0x000055ea55bd90d7 in my_write_core (sig=sig@entry=6) at /test/10.6_dbg/mysys/stacktrace.c:424
      #2  0x000055ea5536dab1 in handle_fatal_signal (sig=6) at /test/10.6_dbg/sql/signal_handler.cc:330
      #3  <signal handler called>
      #4  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
      #5  0x0000146e71eca859 in __GI_abort () at abort.c:79
      #6  0x000055ea55bde5c6 in safe_mutex_unlock (mp=mp@entry=0x55ea58fbc528, file=file@entry=0x55ea55d2df7f "/test/10.6_dbg/sql/sql_acl.cc", line=line@entry=4011) at /test/10.6_dbg/mysys/thr_mutex.c:419
      #7  0x000055ea54ff748a in inline_mysql_mutex_unlock (src_line=4011, src_file=0x55ea55d2df7f "/test/10.6_dbg/sql/sql_acl.cc", that=0x55ea58fbc528) at /test/10.6_dbg/include/mysql/psi/mysql_thread.h:831
      #8  change_password (thd=thd@entry=0x146d94000db8, user=<optimized out>) at /test/10.6_dbg/sql/sql_acl.cc:4011
      #9  0x000055ea54fa61aa in set_var_password::update (this=<optimized out>, thd=0x146d94000db8) at /test/10.6_dbg/sql/set_var.cc:955
      #10 0x000055ea54fa8414 in sql_set_variables (thd=thd@entry=0x146d94000db8, var_list=var_list@entry=0x146d94005e88, free=free@entry=true) at /test/10.6_dbg/sql/set_var.cc:746
      #11 0x000055ea550abcb2 in mysql_execute_command (thd=thd@entry=0x146d94000db8) at /test/10.6_dbg/sql/sql_parse.cc:4910
      #12 0x000055ea55095072 in mysql_parse (thd=thd@entry=0x146d94000db8, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x146e4d13d3d0) at /test/10.6_dbg/sql/sql_parse.cc:7881
      #13 0x000055ea550a31ec in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x146d94000db8, packet=packet@entry=0x146d94008e59 "SET PASSWORD FOR user@localhost=PASSWORD('a')", packet_length=packet_length@entry=45) at /test/10.6_dbg/sql/sql_class.h:1293
      #14 0x000055ea550a652d in do_command (thd=0x146d94000db8) at /test/10.6_dbg/sql/sql_parse.cc:1348
      #15 0x000055ea552027fc in do_handle_one_connection (connect=<optimized out>, connect@entry=0x55ea58feb808, put_in_cache=put_in_cache@entry=true) at /test/10.6_dbg/sql/sql_connect.cc:1410
      #16 0x000055ea55202f03 in handle_one_connection (arg=arg@entry=0x55ea58feb808) at /test/10.6_dbg/sql/sql_connect.cc:1312
      #17 0x000055ea556b888f in pfs_spawn_thread (arg=0x55ea58feb8e8) at /test/10.6_dbg/storage/perfschema/pfs.cc:2201
      #18 0x0000146e723d8609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #19 0x0000146e71fc7293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      10.5.9 139c85aafd4e4938f95843d44a455265a49b572e (Debug)

      Core was generated by `/test/MD010121-mariadb-10.5.9-linux-x86_64-dbg/bin/mysqld --no-defaults --core-'.
      Program terminated with signal SIGABRT, Aborted.
      #0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=6)
          at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
      [Current thread is 1 (Thread 0x14bc80117700 (LWP 3598758))]
      (gdb) bt
      #0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
      #1  0x000055e057310955 in my_write_core (sig=sig@entry=6) at /test/10.5_dbg/mysys/stacktrace.c:424
      #2  0x000055e056a62879 in handle_fatal_signal (sig=6) at /test/10.5_dbg/sql/signal_handler.cc:330
      #3  <signal handler called>
      #4  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
      #5  0x000014bc94bff859 in __GI_abort () at abort.c:79
      #6  0x000055e057315e44 in safe_mutex_unlock (mp=mp@entry=0x55e059a2eb88, file=file@entry=0x55e057465c5f "/test/10.5_dbg/sql/sql_acl.cc", line=line@entry=4011) at /test/10.5_dbg/mysys/thr_mutex.c:419
      #7  0x000055e0566ec25a in inline_mysql_mutex_unlock (src_line=4011, src_file=0x55e057465c5f "/test/10.5_dbg/sql/sql_acl.cc", that=0x55e059a2eb88) at /test/10.5_dbg/include/mysql/psi/mysql_thread.h:831
      #8  change_password (thd=thd@entry=0x14bc44000db8, user=<optimized out>) at /test/10.5_dbg/sql/sql_acl.cc:4011
      #9  0x000055e05669af68 in set_var_password::update (this=<optimized out>, thd=0x14bc44000db8) at /test/10.5_dbg/sql/set_var.cc:955
      #10 0x000055e05669d1d2 in sql_set_variables (thd=thd@entry=0x14bc44000db8, var_list=var_list@entry=0x14bc44005e60, free=free@entry=true) at /test/10.5_dbg/sql/set_var.cc:746
      #11 0x000055e0567a0b33 in mysql_execute_command (thd=thd@entry=0x14bc44000db8) at /test/10.5_dbg/sql/sql_parse.cc:5058
      #12 0x000055e0567898a5 in mysql_parse (thd=thd@entry=0x14bc44000db8, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x14bc801163d0, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.5_dbg/sql/sql_parse.cc:8042
      #13 0x000055e056797c46 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x14bc44000db8, packet=packet@entry=0x14bc440090b9 "SET PASSWORD FOR user@localhost=PASSWORD('a')", packet_length=packet_length@entry=45, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.5_dbg/sql/sql_class.h:1255
      #14 0x000055e05679b3a7 in do_command (thd=0x14bc44000db8) at /test/10.5_dbg/sql/sql_parse.cc:1353
      #15 0x000055e0568f72c8 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x55e059b0f8a8, put_in_cache=put_in_cache@entry=true) at /test/10.5_dbg/sql/sql_connect.cc:1410
      #16 0x000055e0568f79cf in handle_one_connection (arg=arg@entry=0x55e059b0f8a8) at /test/10.5_dbg/sql/sql_connect.cc:1312
      #17 0x000055e056daeaef in pfs_spawn_thread (arg=0x55e059a8bf98) at /test/10.5_dbg/storage/perfschema/pfs.cc:2201
      #18 0x000014bc9510d609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #19 0x000014bc94cfc293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      10.4.18 3454b5cf35a61e8f6cfab376638520dee4a50609 (Debug)

      Core was generated by `/test/MD010121-mariadb-10.4.18-linux-x86_64-dbg/bin/mysqld --no-defaults --core'.
      Program terminated with signal SIGABRT, Aborted.
      #0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=6)
          at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
      [Current thread is 1 (Thread 0x150c9826e700 (LWP 3646074))]
      (gdb) bt
      #0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
      #1  0x000055f2322b6ebd in my_write_core (sig=sig@entry=6) at /test/10.4_dbg/mysys/stacktrace.c:386
      #2  0x000055f2319cdabf in handle_fatal_signal (sig=6) at /test/10.4_dbg/sql/signal_handler.cc:343
      #3  <signal handler called>
      #4  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
      #5  0x0000150cbe77f859 in __GI_abort () at abort.c:79
      #6  0x000055f2322bc336 in safe_mutex_unlock (mp=mp@entry=0x55f235334360, file=file@entry=0x55f23237edff "/test/10.4_dbg/sql/sql_acl.cc", line=line@entry=3881) at /test/10.4_dbg/mysys/thr_mutex.c:419
      #7  0x000055f231656d4a in inline_mysql_mutex_unlock (src_line=3881, src_file=0x55f23237edff "/test/10.4_dbg/sql/sql_acl.cc", that=0x55f235334360) at /test/10.4_dbg/include/mysql/psi/mysql_thread.h:783
      #8  change_password (thd=thd@entry=0x150c3c000d90, user=<optimized out>) at /test/10.4_dbg/sql/sql_acl.cc:3881
      #9  0x000055f231605a56 in set_var_password::update (this=<optimized out>, thd=0x150c3c000d90) at /test/10.4_dbg/sql/set_var.cc:933
      #10 0x000055f231607b9d in sql_set_variables (thd=thd@entry=0x150c3c000d90, var_list=var_list@entry=0x150c3c005bd0, free=free@entry=true) at /test/10.4_dbg/sql/set_var.cc:740
      #11 0x000055f2316fdd39 in mysql_execute_command (thd=thd@entry=0x150c3c000d90) at /test/10.4_dbg/sql/sql_parse.cc:4994
      #12 0x000055f2317040d4 in mysql_parse (thd=thd@entry=0x150c3c000d90, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x150c9826d490, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.4_dbg/sql/sql_parse.cc:7958
      #13 0x000055f231706972 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x150c3c000d90, packet=packet@entry=0x150c3c0087b1 "SET PASSWORD FOR user@localhost=PASSWORD('a')", packet_length=packet_length@entry=45, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.4_dbg/sql/sql_class.h:1170
      #14 0x000055f23170a12b in do_command (thd=0x150c3c000d90) at /test/10.4_dbg/sql/sql_parse.cc:1373
      #15 0x000055f231843e4f in do_handle_one_connection (connect=connect@entry=0x55f235451ec0) at /test/10.4_dbg/sql/sql_connect.cc:1412
      #16 0x000055f231843f6e in handle_one_connection (arg=0x55f235451ec0) at /test/10.4_dbg/sql/sql_connect.cc:1316
      #17 0x0000150cbed3c609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #18 0x0000150cbe87c293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      Seen in 10.4.18, 10.5.9, 10.6.0, debug builds only, stacks above. Not present in 10.2.37, 10.3.28

        Attachments

          Activity

            People

            Assignee:
            serg Sergei Golubchik
            Reporter:
            Roel Roel Van de Paar
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration