Hi,
I sent the following e-mail to the msql-mysql-modules list earlier today
regarding a deadlock error using DBD::mysql.
I was advised by Jochen Wiedmann that DBD::mysql is simply a thin layer
on top of the C interface, and that I should therefore forward my
problem to this list, so here goes...
---
I'm experiencing deadlock errors on BDB tables when using DBD::mysql.
I've whittled it down to an unbelievably simple program:
------------------------------
use strict;
use warnings;
use DBI;
my $dbh = DBI->connect('dbi:mysql:test', 'root', '',
{AutoCommit => 0, PrintError => 0, RaiseError => 1});
for (my $i = 0; ; $i++) {
print "i = $i\n";
my $sth = $dbh->prepare("INSERT INTO x (id) VALUES ($i)");
$sth->execute();
$sth->finish();
$dbh->commit();
}
$dbh->disconnect();
------------------------------
I use the following batch file to (re-)create the database which this
program uses:
------------------------------
@echo off
\mysql\bin\mysqladmin -f drop test >NUL 2>&1
\mysql\bin\mysqladmin create test
\mysql\bin\mysql -u root -e "CREATE TABLE x (id INT) TYPE=BDB" test
------------------------------
The program runs fine on its own, but when I run two of them together,
one of them deadlocks in a matter of seconds.
The error is:
DBD::mysql::st execute failed: Deadlock found when trying to get lock;
Try restarting transaction at D:\Temp\deadlock.pl line 14.
I can't understand why this program should have deadlock errors in the
first place, but what is even stranger (and is why I'm mailing to *this*
list) is that it runs fine if I use DBD::ADO instead of DBD::mysql. (I
also tried DBD::ODBC; that had the same deadlock errors as DBD::mysql.)
However, I'm not keen to use the DBD::ADO driver because it doesn't
(currently) support bind parameters, which I'm making much use of.
Also, the same program with only the DBI connect string changed to
access a Sybase database works fine with the main Sybase DBD driver
(DBD::ASAny) and with DBD::ADO and DBD::ODBC.
Any help would be greatly appreciated.
Steve Hay
---
Version info:
OS: Windows NT4, SP6
Perl: 5.6.1, patched to the same level as ActivePerl Build 631
DBI: 1.21
DBD::mysql: 2.1013
DBD::ADO: 2.4
DBD::ODBC: 0.40
MySQL: 3.23.49a-max-nt
MyODBC: 2.50.39
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
