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
• Status: Unsupported
• Category: Connectors: DBD::mysql ( Perl )
• Severity: S3 (Non-critical)
• Version: 6.0
• OS: Linux (OpenSuSE 10.2)
• CPU Architecture: Any

[31 Jul 2007 10:21] Oli Sennhauser

Description:
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.