DBD::mysql failing commit test for transactions

"Michael Muratet US-Huntsville" <[email protected]>
Newsgroups gmane.comp.db.mysql.perl
Message-ID <2000234931344D4BA434A0C235D1956B0C4858@hsv-exmail02.operonads.local>
Greetings

I am trying to get mysql to work with a perl interface that fails with an error message about transactions not being enabled. I have gone back to the DBD driver and tried the test there and get:

[root@HSV-PROBE DBD-mysql-3.0003]# make test
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00base.............ok
t/10dsnlist..........ok
t/20createdrop.......ok
t/30insertfetch......ok
t/35limit............ok
t/40bindparam........ok
t/40blobs............ok
t/40listfields.......ok
t/40nulls............ok
t/40numrows..........ok
t/41blobs_prepare....ok
t/50chopblanks.......ok
t/50commit...........Transactions not supported by database at t/50commit.t line 101.
t/50commit...........dubious
        Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 5-30
        Failed 26/30 tests, 13.33% okay
t/60leaks............skipped
        all skipped: $ENV{SLOW_TESTS} is not set or Proc::ProcessTable not installed
t/dbdadmin...........ok
t/insertid...........ok
t/param_values.......ok
t/prepare_noerror....ok
t/texecute...........ok
Failed Test  Stat Wstat Total Fail  Failed  List of Failed
-------------------------------------------------------------------------------
t/50commit.t  255 65280    30   52 173.33%  5-30
1 test skipped.
Failed 1/19 test scripts, 94.74% okay. 26/371 subtests failed, 92.99% okay.

I am using v3.0003 with perl 5.8.5 on a Dell PowerEdge 6850 with RedHat Enterprise V4. I have DBI v1.50. I compiled mysql from source with --with-innodb at configure. SHOW ENGINES shows that innodb is enabled. Shouldn't I be able to support transactions with this? Can anyone offer any suggestions how to isolate the problem?

Thanks

Mike
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.