logo       

DBD::mysql failing commit test for transactions: msg#00000

db.mysql.perl

Subject: DBD::mysql failing commit test for transactions

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
<Prev in Thread] Current Thread [Next in Thread>
Google Custom Search

News | FAQ | advertise