Subject Re: SQLCODE: -913 Deadlock
Author Chooi-Ting
--- In, Helen Borrie <helebor@t...>
> At 01:50 AM 5/09/2003 +0000, you wrote:
> >hi,
> >
> >I am having the above error code while I issueing a select query
> >isql:
> >select count(*) from table1;
> >
> >it returns:
> >Statement Failed, SQLCODE= -913
> >deadlock
> >
> >
> >What should I do to clear the deadlock? and what should I do to
> >this error happen again?
> This is weird. It shouldn't happen at all in isolation levels
> READ COMMITTED. isql runs DML in SNAPSHOT by default. Writers in
> isolation levels don't block readers, so you should never get a
> conflict just counting rows.
> Can you provide some information about what database and version
you are using?
> What else was going on the database 1) inside your isql session 2)
outside it?
> heLen

I am runing firebird 1.0 in Sun Sparc (S0-V1.0.0.796 Firebird 1.0).
Previously I have deadlock error when I update a table thru my
application. After get the error, I terminated the application by
using CTRL-C, since it is a C-program application. Then, I issued
select count(*) command thru isql, and got this error -913.

Chooi Ting