Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

sqldatasource dal, wwwxxxenden, convert raid5 to raid 10 mdadm, apache force chunked, nrao wwwxxx, xxxxxdup, procmail change subject header, wwwXxx not20, Wwwxxx.doks sas, linux raid resync after reboot

Links

XODOX
Impressum

#1: 32bit Win Apps on 64bit Systems with Transactions

Posted on 2011-10-11 12:19:00 by Erwin Brandenberger

I have ODBC problems von 64bit machines using transactions.

Following sample:

START TRANSACTION
SELECT ...
DELETE FROM INST_FOLDER WHERE INSTFOLDERID = 26471
SELECT ...
DELETE FROM INST_FOLDER WHERE INSTFOLDERID = 26475
....
DELETE FROM INSTRUMENT WHERE INSTID = 677469
-> SQLExecDirect Error 1451 - HY000 - [MySQL][ODBC 5.1
Driver][mysqld-5.1.47]Cannot delete or update a parent row: a foreign
key constraint fails (`PicosDbCl`.`INST_FOLDER`, CONSTRAINT
`fk_inst_folder_instrument` FOREIGN KEY (`INSTID`) REFERENCES
`INSTRUMENT` (`INSTID`))
DELETE FROM INSTRUMENT WHERE INSTID = 677470
-> SQLExecDirect Error 1451 - HY000 - [MySQL][ODBC 5.1
Driver][mysqld-5.1.47]Cannot delete or update a parent row: a foreign
key constraint fails (`PicosDbCl`.`INST_FOLDER`, CONSTRAINT
`fk_inst_folder_instrument` FOREIGN KEY (`INSTID`) REFERENCES
`INSTRUMENT` (`INSTID`))

The problem starts when I have to delete a few hundreds (about 700-800)
instruments.

On 32bit machines, everything works fine with the same binary.

For me it seams, that the transaction suddently is rollbacked by the
odbc driver.

I have similar problems on 64bit compiled linux binaries with 64bit
mysql odbc drivers, too.

What is the reason for ?
Can I take a fow settings ?



--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

Report this message