开发者

ibase_execute just hangs when there is a deadlock

开发者 https://www.devze.com 2023-01-17 20:49 出处:网络
Setup: firebirdsql 2.1.3 win32, php 5.3 (installed with xampp) When I try to update a record that\'s edited in a desktop 开发者_运维问答app or IBexpert, and there is a deadlock, ibase_execute just han

Setup: firebirdsql 2.1.3 win32, php 5.3 (installed with xampp) When I try to update a record that's edited in a desktop 开发者_运维问答app or IBexpert, and there is a deadlock, ibase_execute just hangs, does not return any value nor raises an exception. When there's no deadlock, everything works fine. Any ideas how to catch this?


I found the problem.

By default, the transactions are IBASE_WAIT, so it waits until the record is no longer edited. You have to start a transaction with the IBASE_NOWAIT option to get an immediate response in a deadlock situation.

0

精彩评论

暂无评论...
验证码 换一张
取 消