mysql: begin_work after commit fails
- From: hjp@xxxxxxxxx (Peter J. Holzer)
- Date: Fri, 28 Oct 2005 18:17:22 +0200
I have a strange problem with mysql 4.1 (innodb engine) and
DBD::mysql 2.9006:
A dbh->begin_work immediately after a dbh->commit fails with
the error "Already in a transaction".
A level 2 trace shows that there are indeed no other DBI calls between
these two:
-> commit for DBD::mysql::db (DBI::db=HASH(0x872feb4)~0x8753170) thr#814bf18
<- commit= 1 at MySQL.pm line 141
-> begin_work in DBD::_::db for DBD::mysql::db (DBI::db=HASH(0x872feb4)~0x8753170) thr#814bf18
1 -> FETCH for DBD::mysql::db (DBI::db=HASH(0x8753170)~INNER 'AutoCommit') thr#814bf18
1 <- FETCH= '' at DBI.pm line 1623
1 -> set_err in DBD::_::common for DBD::mysql::db (DBI::db=HASH(0x8753170)~INNER 1 'Already in a transaction') thr#814bf18
!! ERROR: 1 'Already in a transaction' (err#1)
1 <- set_err= undef at DBI.pm line 1623
!! ERROR: 1 'Already in a transaction' (err#1)
<- begin_work= undef at MySQL.pm line 336
How can this happen?
hp
--
_ | Peter J. Holzer | In our modern say,learn,know in a day
|_|_) | Sysadmin WSR | world, perhaps being an expert is an
| | | hjp@xxxxxxxxx | outdated concept.
__/ | http://www.hjp.at/ | -- Catharine Drozdowski on dbi-users.
Attachment:pgpSytcYhhjh1.pgp
Description: PGP signature
- Follow-Ups:
- Re: mysql: begin_work after commit fails
- From: Peter J. Holzer
- Re: mysql: begin_work after commit fails
- Prev by Date: DBD::Oracle and CLOBs
- Next by Date: Re: mysql: begin_work after commit fails
- Previous by thread: DBD::Oracle and CLOBs
- Next by thread: Re: mysql: begin_work after commit fails
- Index(es):
Relevant Pages
|
