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 <at> 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
(Continue reading)

FW: DBI/DBD won't recognize transaction support


> Greetings
> 
> I am trying to get the perl interface to work for InnoDB tables on mysql v 5.0.21, perl 5.8.5, dbi 1.51, dbd
3.0004_1 on a Dell PowerEdge with quad dual-core Xeons running Redhat Enterprise v4. I can create an
InnoDB table from the mysql command line, insert a row, see it's there, rollback, see the row is gone. But
the simple script below fails:
> 
> use DBI;
> my $user = 'root';
> my $pw = ;
> my $dbh = DBI->connect("DBI:mysql:database=test;host=127.0.0.1", $user, $pw, { AutoCommit => 0,
RaiseError => 0 });
> die DBI::errstr unless $dbh;
> $dbh->disconnect;
> 
> The DBI/DBD interface is working OK for other (non-InnoDB) scripts.
> 
> DBI passes all it's tests except for those that complain about DBI::PurePerl. DBD passes all of its tests
except the one that deals with transactions. Can anyone offer a suggestion how to isolate the problem?
SHOW ENGINES indicates that InnoDB is indeed enabled and actions with InnoDB from the mysql command line
work OK. Should I make InnoDB the default table type when I start the server? Am I simply hosed because of multi-threading?
> 
> Thanks
> 
> Mike
> 
Patrick Galbraith | 8 Jun 18:08 2006
Picon

Re: FW: DBI/DBD won't recognize transaction support

Michael Muratet US-Huntsville wrote:

Michael,

I'll take a look into this issue tomorrow. I'm working on another 
release hopefully by this weekend.

Thanks!

Patrick
>> Greetings
>>
>> I am trying to get the perl interface to work for InnoDB tables on mysql v 5.0.21, perl 5.8.5, dbi 1.51, dbd
3.0004_1 on a Dell PowerEdge with quad dual-core Xeons running Redhat Enterprise v4. I can create an
InnoDB table from the mysql command line, insert a row, see it's there, rollback, see the row is gone. But
the simple script below fails:
>>
>> use DBI;
>> my $user = 'root';
>> my $pw = ;
>> my $dbh = DBI->connect("DBI:mysql:database=test;host=127.0.0.1", $user, $pw, { AutoCommit => 0,
RaiseError => 0 });
>> die DBI::errstr unless $dbh;
>> $dbh->disconnect;
>>
>> The DBI/DBD interface is working OK for other (non-InnoDB) scripts.
>>
>> DBI passes all it's tests except for those that complain about DBI::PurePerl. DBD passes all of its tests
except the one that deals with transactions. Can anyone offer a suggestion how to isolate the problem?
SHOW ENGINES indicates that InnoDB is indeed enabled and actions with InnoDB from the mysql command line
(Continue reading)

kirit.gajera | 9 Jun 15:49 2006
Picon

I fond problem during installation of DBI::DBD

Hello Friends,

During installation of MySQL DBI::DBD I fond following problem 

Can't locate DBI/DBD.pm in  <at> INC ( <at> INC contains:
/usr/lib/perl5/5.8.0/i386-linux-thread-multi /usr/lib/perl5/5.8.0
/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.0 /usr/lib/perl5/site_perl
/usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.0 /usr/lib/perl5/vendor_perl .) at
Makefile.PL line 23.

So please help me as fast as possible.

Thanks

Kirit Gajera

kirit.gajera <at> i-link.co.in
Patrick Galbraith | 10 Jun 02:16 2006
Picon

Re: FW: DBI/DBD won't recognize transaction support

Michael Muratet US-Huntsville wrote:

Michael,

I can't get this to fail. What sort of error does this throw?

Thanks!

Patrick
>> Greetings
>>
>> I am trying to get the perl interface to work for InnoDB tables on mysql v 5.0.21, perl 5.8.5, dbi 1.51, dbd
3.0004_1 on a Dell PowerEdge with quad dual-core Xeons running Redhat Enterprise v4. I can create an
InnoDB table from the mysql command line, insert a row, see it's there, rollback, see the row is gone. But
the simple script below fails:
>>
>> use DBI;
>> my $user = 'root';
>> my $pw = ;
>> my $dbh = DBI->connect("DBI:mysql:database=test;host=127.0.0.1", $user, $pw, { AutoCommit => 0,
RaiseError => 0 });
>> die DBI::errstr unless $dbh;
>> $dbh->disconnect;
>>
>> The DBI/DBD interface is working OK for other (non-InnoDB) scripts.
>>
>> DBI passes all it's tests except for those that complain about DBI::PurePerl. DBD passes all of its tests
except the one that deals with transactions. Can anyone offer a suggestion how to isolate the problem?
SHOW ENGINES indicates that InnoDB is indeed enabled and actions with InnoDB from the mysql command line
work OK. Should I make InnoDB the default table type when I start the server? Am I simply hosed because of multi-threading?
(Continue reading)

Alexander | 11 Jun 23:10 2006
Picon

Several statements in one query

SET  <at> a=1;
SELECT  <at> a;

Works in phpMyAdmin. But does not work in perl. Where can be the problem?

Alexander
Alexander | 11 Jun 23:48 2006
Picon

Fw: Several statements in one query

I've figured out, that if i execute that statements one by one, i can get 
result that i want.
But there is no sense to use:
SET  <at> a = SELECT ID FROM Table1 WHERE smth=?;
INSERT INTO Table2 smth_id VALUES( <at> a);
...

----- Original Message ----- 
From: "Alexander" <zukoff <at> ukr.net>
To: <perl <at> lists.mysql.com>
Sent: Monday, June 12, 2006 12:10 AM
Subject: Several statements in one query

SET  <at> a=1;
SELECT  <at> a;

Works in phpMyAdmin. But does not work in perl. Where can be the problem?

Alexander 

--

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules <at> m.gmane.org

paul lucassen | 12 Jun 13:22 2006

re-executing prepared statement leads to 'Modification of a read-only value attempted'

Hi,

While playing with the examples from the eg/ directory 
(DBD-mysql-3.0006_1) I took proc_example3.pl and
copied the $sth->execute and the subsequent do-block.
The second execution then leads to a
     Modification of a read-only value attempted
at the line with while ( <at> row= $sth->fetchrow_array()). (The problem here 
is with $sth)

My environment: SLES9 with stock perl (5.8.3), Mysql 5.0.21, DBI 1.51, 
DBD::mysql 3.0006_1.

The test-script:

#!/usr/bin/perl

use DBI;

$DATABASE='test';
$HOST='localhost';
$PORT=3306; $USER='root';
$PASSWORD='';

$dbh = DBI->connect("DBI:mysql:$DATABASE:$HOST:$PORT",
                    "$USER", "$PASSWORD",
                  { PrintError => 0}) || die $DBI::errstr;

$dbh->trace(3, "./dbd.log");

(Continue reading)

Andrew Nelson | 15 Jun 23:56 2006
Picon

Solaris 10 -- mysql-5.0.22 DBD::mysql Fails to Build

I can't get DBD::mysql to build on Solaris 10 using the mysql.com provided
.pkg and the Sun Forte Compiler.

bash-3.00$ echo $PATH
/opt/SUNWspro/bin:/opt/SUNWspro/prod/bin:/opt/mysql/mysql/bin:/usr/ccs/bin:/opt/SUNWspro/bin:/opt/mysql/mysql/bin:/usr/ccs/bin:/usr/bin:/usr/ucb:/etc:.
bash-3.00$ perm Makefile.PL
bash: perm: command not found
bash-3.00$ perl Makefile.PL
I will use the following settings for compiling and testing:

  cflags        (mysql_config) = -I/opt/mysql/mysql/include -xO3 -mt -fsimple=1 -ftrap=%none -nofstore
-xbuiltin=%all -xlibmil -xlibmopt -xtarget=generic
  embedded      (mysql_config) = 
  libs          (mysql_config) = -L/opt/mysql/mysql/lib -lmysqlclient -lz -lposix4 -lcrypt -lgen -lsocket -lnsl -lm
  mysql_config  (guessed     ) = mysql_config
  nocatchstderr (default     ) = 0
  nofoundrows   (default     ) = 0
  ssl           (guessed     ) = 0
  testdb        (default     ) = test
  testhost      (default     ) = 
  testpassword  (default     ) = 
  testsocket    (default     ) = 
  testuser      (default     ) = 

To change these settings, see 'perl Makefile.PL --help' and
'perldoc INSTALL'.

Checking if your kit is complete...
Looks good
Using DBI 1.51 (for perl 5.008004 on i86pc-solaris-64int) installed in /usr/perl5/site_perl/5.8.4/i86pc-solaris-64int/auto/DBI/
(Continue reading)

Martin J. Evans | 16 Jun 10:22 2006

RE: Solaris 10 -- mysql-5.0.22 DBD::mysql Fails to Build

A google search for "ube: error: Assert has been violated at" seems show many
very similar looking issues.

http://sunsolve.sun.com/search/document.do?assetkey=120759-05h

Try getting your compiler patches up to date or lowering the level of
optimisation - the -xO3.

Martin

On 15-Jun-2006 Andrew Nelson wrote:
> I can't get DBD::mysql to build on Solaris 10 using the mysql.com provided
> .pkg and the Sun Forte Compiler.
> 
> bash-3.00$ echo $PATH
> /opt/SUNWspro/bin:/opt/SUNWspro/prod/bin:/opt/mysql/mysql/bin:/usr/ccs/bin:/op
> t/SUNWspro/bin:/opt/mysql/mysql/bin:/usr/ccs/bin:/usr/bin:/usr/ucb:/etc:.
> bash-3.00$ perm Makefile.PL
> bash: perm: command not found
> bash-3.00$ perl Makefile.PL
> I will use the following settings for compiling and testing:
> 
>   cflags        (mysql_config) = -I/opt/mysql/mysql/include -xO3 -mt
> -fsimple=1 -ftrap=%none -nofstore -xbuiltin=%all -xlibmil -xlibmopt
> -xtarget=generic
>   embedded      (mysql_config) = 
>   libs          (mysql_config) = -L/opt/mysql/mysql/lib -lmysqlclient -lz
> -lposix4 -lcrypt -lgen -lsocket -lnsl -lm
>   mysql_config  (guessed     ) = mysql_config
>   nocatchstderr (default     ) = 0
(Continue reading)


Gmane