Tim and Thomas, Not sure why this is the case, but I noticed that doing an insert with an execute via DBD::Multiplex didn't work when using text that contained latex for example. But a do with the same did work. After much work I found that calling execute with @_ (even though it was empty) caused the error. So I added logic to not call it with @_.
Peter Halliday Excelsior Systems http://www.excelsiorsystems.net (Phone:) 607-936-2172 (Support:) 607-329-6905 (Fax:) 607-398-7928 > -----Original Message----- > From: Tim Bunce [mailto:[EMAIL PROTECTED] > Sent: Thursday, May 11, 2006 7:44 AM > To: Peter Halliday > Cc: dbi-users@perl.org > Subject: Re: Problem with DBI::Multiplex > > On Tue, May 09, 2006 at 11:07:38AM -0400, Peter Halliday wrote: > > I'm trying to load balance reads across two MySQL database that have > replication. The reads are working wonderfully. The inserts actually do > insert. However, there are some table that use auto increment primary > keys. I can't figure out how to actually get those particular keys now. > > You could patch DBI::Multiplex so the last_insert_id method uses the same > dbh as the previous operation. > > Patches welcome. > > Tim. > > -- > No virus found in this incoming message. > Checked by AVG Free Edition. > Version: 7.1.394 / Virus Database: 268.7.1/347 - Release Date: 5/24/2006 > -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.394 / Virus Database: 268.7.1/347 - Release Date: 5/24/2006
Multiplex.pm.patch
Description: Binary data