Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Are the sqls that crash using the correct index to find data from the
database? (explain plan).
Update stats?
Increase the duration of the set lock mode to wait.
Neither of those messages necessarily indicate deadlocks. Why do you think
there are deadlocks?
MW
> -----Original Message-----
> From: owner-informix-list@iiug.org
> [mailto:owner-informix-list@iiug.org]On Behalf Of Jason
> Sent: Tuesday, 22 July 2003 11:54 a.m.
> To: informix-list@iiug.org
> Subject: Deadlock question
>
>
> Broad question.
>
> Are there any settings in the onconfig, that if not properly
> set, could
> lead to an increase in deadlock issues (showing a LOT of
> -243's and -154's)
> .
>
> I just upgraded to 9.30.FC3 and I am seeing an awful lot of
> dead locks...
>
> Just wondering.
>
>
>
> --
> Using M2, Opera's revolutionary e-mail client:
> http://www.opera.com/m2/
sending to informix-list
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.