Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

ftp://192.168.100.100/, www.xxxcon, which comes first ob_start or session, wwwxxx/58/2010, xxxxdup, xxxxdup, mailx informatii, should producers of software-based services, such as atms, be held liable for economic injuries suffered when their systems fail?, mysql feiertage, bash netcat eof

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