Intermittent change_user_notembedded and failed_auth_3909 Jenkins failures

[Laurynas Biveinis]

http://jenkins.percona.com/job/percona-server-5.6-trunk/116/

For example:

http://jenkins.percona.com/job/percona-server-5.6-trunk/116/BUILD_TYPE=release,Host=ubuntu-lucid-32bit/testReport/junit/%28root%29/main/change_user_notembedded/

This looks related to bug 1172090 MariaDB fix replacement with Oracle fix, which happened at the MySQL 5.6.13 merge.

[Laurynas Biveinis (laurynas-biveinis)]

A testcase-only bug, should not be a 5.6 GA concern.

[Laurynas Biveinis (laurynas-biveinis)]

Some failure examples (as Jenkins link expire):

_StringException: Text attachment: traceback
------------
Comment:

Logfile:
CURRENT_TEST: main.failed_auth_3909
mysqltest: At line 29: query 'change_user u2' failed with wrong errno 2013: 'Lost connection to MySQL server at 'reading authorization packet', system error: 0', instead of 2006...

The result from queries just before the failure was:
< snip >
mysql.user optimize status OK
insert mysql.user (user,plugin) values ('foo','bar'),('bar','bar'),('baz','bar');
Warnings:
Warning 1364 Field 'ssl_cipher' doesn't have a default value
Warning 1364 Field 'x509_issuer' doesn't have a default value
Warning 1364 Field 'x509_subject' doesn't have a default value
flush privileges;
connect(localhost,u1,,test,MASTER_PORT,MASTER_SOCKET);
ERROR HY000: Plugin 'bar' is not loaded
connect(localhost,u2,,test,MASTER_PORT,MASTER_SOCKET);
ERROR 28000: Access denied for user 'u2'@'localhost' (using password: NO)
connect(localhost,u2,password,test,MASTER_PORT,MASTER_SOCKET);
ERROR 28000: Access denied for user 'u2'@'localhost' (using password: YES)
ERROR HY000: Plugin 'bar' is not loaded

More results from queries before failure can be found in /mnt/workspace/percona-server-5.6-trunk/BUILD_TYPE/release/Host/centos5-64/Percona-Server/build/mysql-test/var/3/log/failed_auth_3909.log
------------

Comment:

Logfile:
CURRENT_TEST: main.change_user_notembedded
mysqltest: At line 14: query 'change_user foo' failed with wrong errno 2013: 'Lost connection to MySQL server at 'reading authorization packet', system error: 0', instead of 2006...

The result from queries just before the failure was:
ERROR 28000: Access denied for user 'foo'@'localhost' (using password: NO)
------------

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-2039