Subject | Re: various errors during night tests |
---|---|
Author | Roman Rokytskyy |
Post date | 2003-03-28T12:40:58Z |
Hi,
in your tests. However it is hard to tell why, because I need test
that reproduces the bug. Can you create one?
deadlock.
Best regards,
Roman Rokytskyy
> An update about my night tests:Deadlock most likely is not caused by a bug in the driver, but a bug
>
> tonight i had this:
>
> GDS Exception. deadlock
> Error Code: 335544336
> SQL State: null
in your tests. However it is hard to tell why, because I need test
that reproduces the bug. Can you create one?
> executing a stored procedure that updates a single row.If you use concurrent transactions in this case, you can run into the
> reexecuting, from ibexpert, the same procedure with same parameters
> without restarting anything, was succesful...
>
> in my java app the workflow is approximately this:
>
> accept a tcp connection
> log in the database the request made (insert a row)
> insert a row in another table after some processing (not db
> processing) update the inserted row after some processing (not db
> processing) say goodbye close the tcp connection
deadlock.
> yesterday i had errors making the "log" insert.What transaction isolation do you use?
> tonight i had errors making the update.
> i forget to mention that i made query in autocommit mode.
Best regards,
Roman Rokytskyy