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

Assertion `(&(&acl_cache->lock)->m_mutex)->count > 0 && pthread_equal(pthread_self(), (&(&acl_cache->lock)->m_mutex)->thread)' fails after restarting server with a pre-created role grants

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 10.0.5
    • Component/s: None
    • Labels:
      None

      Description

      mysqld: sql/sql_acl.cc:2771: ACL_ROLE* find_acl_role(const char*): Assertion `(&(&acl_cache->lock)->m_mutex)->count > 0 && pthread_equal(pthread_self(), (&(&acl_cache->lock)->m_mutex)->thread)' failed.
      131022 20:03:47 [ERROR] mysqld got signal 6 ;

      #4  0x00007f22a17b1425 in __GI_raise (sig=<optimized out>) at ../nptl/sysdeps/unix/sysv/linux/raise.c:64
      #5  0x00007f22a17b4b8b in __GI_abort () at abort.c:91
      #6  0x00007f22a17aa0ee in __assert_fail_base (fmt=<optimized out>, assertion=0xde5188 "(&(&acl_cache->lock)->m_mutex)->count > 0 && pthread_equal(pthread_self(), (&(&acl_cache->lock)->m_mutex)->thread)", file=0xde4950 "sql/sql_acl.cc", line=<optimized out>, function=<optimized out>) at assert.c:94
      #7  0x00007f22a17aa192 in __GI___assert_fail (assertion=0xde5188 "(&(&acl_cache->lock)->m_mutex)->count > 0 && pthread_equal(pthread_self(), (&(&acl_cache->lock)->m_mutex)->thread)", file=0xde4950 "sql/sql_acl.cc", line=2771, function=0xde7da0 "ACL_ROLE* find_acl_role(const char*)") at assert.c:103
      #8  0x00000000005a6dc2 in find_acl_role (user=0x7f229cf2c0a0 "r1") at sql/sql_acl.cc:2771
      #9  0x00000000005a284a in acl_load (thd=0x7f229ff9d070, tables=0x7fff77b5f2f0) at sql/sql_acl.cc:1337
      #10 0x00000000005a37bc in acl_reload (thd=0x7f229ff9d070) at sql/sql_acl.cc:1587
      #11 0x00000000005a1316 in acl_init (dont_read_acl_tables=false) at sql/sql_acl.cc:963
      #12 0x0000000000572a8f in mysqld_main (argc=97, argv=0x7f22a0c1d5c0) at sql/mysqld.cc:5104
      #13 0x000000000056a5f4 in main (argc=6, argv=0x7fff77b61368) at sql/main.cc:25

      revision-id: sergii@pisem.net-20131020232702-db6ekuk4lz0itg1b
      revno: 3892
      branch-nick: 10.0-serg
      BUILD/compile-pentium-debug-max-no-ndb

      create user user1@localhost;
      create role r1 with admin user1@localhost;
      grant all on test.* to r1;
       
      --append_file $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
      wait
      EOF
      --shutdown_server 60
      --source include/wait_until_disconnected.inc
      --enable_reconnect
      --append_file $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
      restart
      EOF
      --source include/wait_until_connected_again.inc
       
      select 1;

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              serg Sergei Golubchik
              Reporter:
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: