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

debug assert on SET PASSWORD when binlog fails

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

          There are no comments yet on this issue.

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.