> We use Delphi 6 and FB 1.5.2 on Linux servers. We use
> D6 native TIB
> components to access the data.
>
> Our application works fine at almost all of our
> clients. But we have 3
> clients where the system sometimes reports "Deadlock
> conflict on no wait
> transaction".
>
> "table_document", with id_table_document as primary
> key
> "table_article" with id_table_article as PK and
> id_table_document as FK.
>
> Insert a new record in "table_document", commit,
> trigger etc. Save
> id_table_document.
>
> Insert localy (in a dbf local table) some articles
> then, if the user
> confirms that he want to save the data, we insert the
> data in
> "table_article"
>
> Now , here is our problem:
>
> Sometimes (randomly), the system doesn't seems to find
> the saved
> id_table_document record that we just inserted. It
> generates a "Deadlock
> conflict on no wait transaction" and of course a
> "foreign key violation".
>
> Our database object:
>
> object dm: Tdm
> OldCreateOrder = False
> OnCreate = DataModuleCreate
> Left = 408
> Top = 119
> Height = 739
> Width = 863
> object database: TIBDatabase
> DatabaseName = 'C:\DEVELOP\GESTOCW\GESTOC.GDB'
> Params.Strings = (
> 'user_name=SYSDBA'
> 'password=xxxx')
> LoginPrompt = False
> DefaultTransaction = trans
> IdleTimer = 0
> SQLDialect = 3
> TraceFlags = []
> BeforeConnect = databaseBeforeConnect
> Left = 32
> Top = 8
> end
> object trans: TIBTransaction
> Active = False
> DefaultDatabase = database
> Params.Strings = (
> 'read_committed'
> 'rec_version'
> 'nowait')
> AutoStopAction = saNone
> Left = 88
> Top = 8
> end
>
>
> What can we do about this ?

Make sure you commit all your changes and/or use the same
transaction for all "save" actions.

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com