randgen team mailing list archive

[Bernt Marius Johnsen <bernt.johnsen@xxxxxxxxxx>]

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     : randgen@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~randgen
> More help   : https://help.launchpad.net/ListHelp