MySQL Bugs: #45888: concurrent_innodb_unsafelog fails sporadically on pushbuild: Access denied

Bug #45888	concurrent_innodb_unsafelog fails sporadically on pushbuild: Access denied
Submitted:	1 Jul 2009 20:07	Modified:	4 Jul 2009 12:51
Reporter:	Christian Hammers (Silver Quality Contributor) (OCA)	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	Tests	Severity:	S3 (Non-critical)
Version:	5.1.36	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
This seems similar but not identical to Bug #40699. It failed repeatedly twice times in a row.

$ make test
...
main.lowercase_utf8                      [ pass ]      6
main.ctype_ldml                          [ pass ]     76
main.date_formats                        [ pass ]     80
main.ctype_latin1_de                     [ pass ]     80
main.ctype_ucs2_def                      [ pass ]     22
main.events_bugs                         [ pass ]   9608
main.events_restart                      [ pass ]   3389
main.log_state                           [ pass ]   6127
main.innodb_ignore_builtin               [ pass ]      3
main.init_file                           [ pass ]      3
main.innodb_bug30919                     [ pass ]   1749
main.innodb_autoinc_lock_mode_zero       [ pass ]     24
main.innodb_mysql                        [ pass ]  33187
main.innodb_bug42101-nonzero             [ pass ]      4
main.concurrent_innodb_unsafelog         [ fail ]
        Test ended at 2009-07-01 21:57:31

CURRENT_TEST: main.concurrent_innodb_unsafelog
mysqltest: In included file "./include/concurrent.inc": At line 69: query 'connect  thread1, localhost, mysqltest,,' failed: 1044: Access denied for
 user 'mysqltest'@'localhost' to database 'test'

The result from queries just before the failure was:
SET GLOBAL TRANSACTION ISOLATION LEVEL REPEATABLE READ;
SELECT @@global.tx_isolation;
@@global.tx_isolation
REPEATABLE-READ
SELECT @@global.innodb_locks_unsafe_for_binlog;
@@global.innodb_locks_unsafe_for_binlog
1
# keep_locks == 0
GRANT USAGE ON test.* TO mysqltest@localhost;
drop table if exists t1;

**
** two UPDATE's running and both changing distinct result sets
**
** connection thread1

 - saving '/srv/home/james/debian/mysql/build-area/mysql-dfsg-5.1-5.1.36/mysql-test/var/log/main.concurrent_innodb_unsafelog/' to '/srv/home/james/d
ebian/mysql/build-area/mysql-dfsg-5.1-5.1.36/mysql-test/var/log/main.concurrent_innodb_unsafelog/'

Only  265  of 865 completed.
mysql-test-run: *** ERROR: Not all tests completed
make: *** [test-ns] Fehler 1

How to repeat:
$ ./configure --build=x86_64-linux-gnu --host=x86_64-linux-gnu --prefix=/usr --exec-prefix=/usr --libexecdir=/usr/sbin --datadir=/usr/share --localstatedir=/var/lib/mysql --includedir=/usr/include --infodir=/usr/share/info --mandir=/usr/share/man --with-server-suffix=-0.1 --with-comment=(Debian) --with-system-type=debian-linux-gnu --enable-shared --enable-static --enable-thread-safe-client --enable-assembler --enable-local-infile --with-pic --with-lib-ccflags=-fPIC --with-pstack --with-fast-mutexes --with-big-tables --with-unix-socket-path=/var/run/mysqld/mysqld.sock --with-mysqld-user=mysql --with-libwrap --with-ssl --without-docs --with-extra-charsets=all --with-plugins=max --without-ndbcluster --with-embedded-server --with-embedded-privilege-control

$ make

$ make test

Suggested fix:
none known

After running "make test-ignore", I found the following test failing with a quite similar message, too:

main.concurrent_innodb_safelog
mysqltest: In included file "./include/concurrent.inc": At line 69: query 'connect  thread1, localhost, mysqltest,,' failed: 1044: Access denied for user 'mysqltest'@'localhost' to database 'test'

main.show_check
mysqltest: At line 336: query 'connect  con2,localhost,mysqltest_2,,test' failed: 1044: Access denied for user 'mysqltest_2'@'localhost' to database 'test'

main.grant3                              [ fail ]
mysqltest: At line 28: query 'connect  user_a,localhost,mysqltest_1,,' failed: 1044: Access denied for user 'mysqltest_1'@'localhost' to database 'test'

main.init_connect                        [ fail ]
mysqltest: At line 21: query 'connect  con1,localhost,user_1,,' failed: 1044: Access denied for user ''@'localhost' to database 'test'

Thank you for the report.

I can not repeat described behavior. Please indicate accurate package name you are using
(filename you downloaded). If you compiled sources yourself provide configure options.

Can be closed too, for the same reason as 45890

Thank you for the feedback.

Closed as "Not a Bug"