Bug #30142 perl script using innodb does not work with 6.0 anymore
Submitted: 31 Jul 2007 10:21 Modified: 20 Feb 2013 22:35
Reporter: Oli Sennhauser Email Updates:
Status: Unsupported Impact on me:
Category:Connectors: DBD::mysql ( Perl ) Severity:S3 (Non-critical)
Version:6.0 OS:Linux (OpenSuSE 10.2)
Assigned to: CPU Architecture:Any

[31 Jul 2007 10:21] Oli Sennhauser
When running the following trx-throughput test script (http://www.shinguz.ch/MySQL/commit_demo.txt) on MySQl 5.0.45 it works fine. When running the same script against MySQL 6.0. I gives an error.

When the line 
                      , AutoCommit => 0

is skipped the skript will work again. But this is not what we want! Seems to me to be a problem with Perl DBI/DBD.

How to repeat:
On 5.0.45:
./commit_demo.pl -c --database=test --host=localhost --port=3326 -u root
./commit_demo.pl --database=test --host=localhost --port=3326 -u root -i 1000
./commit_demo.pl -d --database=test --host=localhost --port=3326 -u root

On 6.0.0:
./commit_demo.pl -c --database=test --host=localhost --port=3326 -u root
Transactions not supported by database at /usr/lib/perl5/vendor_perl/5.8.8/i586-linux-thread-multi/DBI.pm line 672.

Suggested fix:
no idea!
[31 Jul 2007 12:30] MySQL Verification Team
Are you verified if Falcon engine is the default storage engine when the
server is started?. Thanks in advance.
[31 Jul 2007 12:32] MySQL Verification Team
Sorry I meant InnoDB engine to last question.
[29 Aug 2007 10:25] Oli Sennhauser
This does/should not matter. In 5.0 it works in 6.0 not. test it and you will see it.
[8 Sep 2007 4:29] Valeriy Kravchuk
Please, try to repeat with a newer version, 6.0.2, and inform about the results.
[10 Sep 2007 12:12] Oli Sennhauser
oli@master:~/mysql/scripts [mysqld602, 3317]> ./commit_demo.pl -c -u root
Transactions not supported by database at /usr/lib/perl5/vendor_perl/5.8.8/i586-linux-thread-multi/DBI.pm line 672.

Can you reproduce it?
[10 Oct 2007 14:05] MySQL Verification Team
On Windows I got the below error message:

Truncate table.
ERROR execute: Table 'test.commit_demo' doesn't existIssuing rollback() for database handle being DESTROY'd without explicit disconnect() at comm
it_demo.pl line 168.
[20 Feb 2013 22:35] Sveta Smirnova
Thank you for the report.

We don't work on DBD::mysql bugs anymore. All its bugs should go to CPAN: https://rt.cpan.org/Public/Dist/Display.html?Name=DBD-mysql

But since version 6.0 is not supported and DBD::mysql perfectly works with all supported versions, probably, this bug does not make sense anymore.