[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 Created: 2013-10-22  Updated: 2013-10-23  Resolved: 2013-10-23

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: 10.0.5

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-4397 Roles Closed
relates to MDEV-5164 Testing Roles Closed

 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;


Generated at Thu Feb 08 07:02:13 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.