Code Igniter database transactions

[eluser]gtech[/eluser]
With db_debug on it does stop the rest of the code in the request from working, thats why I tend to turn it off and log any errors manually.

I have tested a fail case with 1.6 with db_debug on and the rollback appears to work OK, so apologies even though the code halted after the commit subsequent requests still used the database ok.

[edit] this has later been proven just to be the case on my machine, on other os's it fails to complete the transaction when db_debug is set to TRUE[/edit]

[strike]
Are you using mysql tables that support rollback? *my tables use the innodb engine*

eg:

Code:

Create table sections(<whatever columns you have>) ENGINE = InnoDB;

have you tried inputting the sql statements manually into mysql within a transaction and see if the lock still happens?

Code:

START TRANSACTION;
insert ...
insert ... the duplicate key
ROLLBACK;

[/strike]