You cannot rely on perl "local" working wrt. $dbh->{AutoCommit}, since
setting this attribute causes the invocation of C code and communication
with the server. And the perl system is in no way able to do anything
correct with this. RQG does NOT use this feature for database attributes.
On 06/11/2014 01:19 PM, Ramesh Sivaraman wrote:
Hi Team,
Recently I found an issue with RQG percona server 5.6 run. Some of the
trials were failing due to perl DBD driver issue.
{error} 2014-06-09T01:24:17 We have already exceeded time specified by
--duration=x; exiting now.
# 2014-06-09T01:24:17 Child worker process completed successfully.
# 2014-06-09T01:33:00 We have already exceeded time specified by
--duration=x; exiting now.
# 2014-06-09T01:33:03 Child worker process completed successfully.
DBD driver has not implemented the AutoCommit attribute at
/usr/lib64/perl5/DBI.pm line 705.
# 2014-06-09T01:33:52 Query: ALTER TABLE `table100_memory_int_autoinc`
KEY_BLOCK_SIZE = 2 failed: 2013 Lost connection to MySQL server during
query
# 2014-06-09T01:33:52 Query: FLUSH TABLE n failed: 2013 Lost
connection to MySQL server during query
# 2014-06-09T01:33:53 Query: TRUNCATE `table100_tokudb_int` failed:
2013 Lost connection to MySQL server during query
# 2014-06-09T01:33:54 Query: INSERT INTO y SELECT * FROM
`table500_tokudb_int_autoinc` failed: 2013 Lost connection to MySQL
server during query
--
--
# 2014-06-09T01:34:17 Test completed with failure status
STATUS_SERVER_CRASHED (101)
# 2014-06-09T01:34:21 gentest.pl <http://gentest.pl>exited with exit
status STATUS_SERVER_CRASHED (101)
2014-06-09T01:34:21 [8171] /ssd/qa56val/randgen/runall.pl
<http://runall.pl>will exit with exit status STATUS_SERVER_CRASHED (101)
{error}
Similar bug has been reported by Craig Manley in bugs.mysql.com
<http://bugs.mysql.com>
http://bugs.mysql.com/search.php?cmd=display&status=Active&reporter=725731
https://rt.cpan.org/Public/Bug/Display.html?id=83518
I was able to reproduce the error with a sample perl script provided
in the bug. Whenever the script execute the line "local
$dbh->{'AutoCommit'} = 0;", perl is terminating with the message "DBD
driver has not implemented the AutoCommit attribute"
$ ./test.pl <http://test.pl>
AutoCommit: 1
AutoCommit: 1
AutoCommit:
DBD driver has not implemented the AutoCommit attribute at ./test.pl
<http://test.pl>line 14.
$
Version info
Perl DBI : perl-DBD-MySQL-4.013-3.el6.x86_64
Percona Server : 5.6.17
OS : CentOS
Upgraded DBD::mysql module using CPAN to check the issue.
After upgrading perl DBD::mysql module, sample perl program did not
terminate in line "local $dbh->{'AutoCommit'} = 0;".
$ sudo cpanm DBD::mysql
DBD::mysql is up to date. (4.027)
$
$ ./test.pl <http://test.pl>
AutoCommit: 1
AutoCommit: 1
AutoCommit:
AutoCommit:
$
Feel free to use this workaround if you see this issue in RQG
--
Best Regards,
*
*
*Ramesh Sivaraman, Jr. QA Engineer, Percona*
http://www.percona.com/ <http://percona.com/>
Phone : +91 9886276761
Skype : rameshvs02
_______________________________________________
Mailing list: https://launchpad.net/~randgen
Post to : [email protected]
Unsubscribe : https://launchpad.net/~randgen
More help : https://help.launchpad.net/ListHelp
_______________________________________________
Mailing list: https://launchpad.net/~randgen
Post to : [email protected]
Unsubscribe : https://launchpad.net/~randgen
More help : https://help.launchpad.net/ListHelp
