Re: [HELP] - Lock table overflow

On Wed, 19 Nov 2003 14:37:49 +0100, "Michel _newbie" <martin.michel8@wanadooo.fr> wrote: >Sorry, it's difficult for me to write in english. >I have some problems, this is a part of the file "/opt/informix/online.log" >: > >13:20:28 Lock table overflow - user id 0, session id 6985 >13:20:29 Lock table overflow - user id 0, session id 6986 >13:21:20 Lock table overflow - user id 0, session id 7018 >13:21:21 Lock table overflow - user id 0, session id 7019 >13:21:22 Lock table overflow - user id 0, session id 7020 >13:21:23 Lock table overflow - user id 1002, session id 6889 >13:21:23 Lock table overflow - user id 0, session id 7021 >13:21:30 Checkpoint Completed: duration was 107 seconds. >13:28:58 Checkpoint Completed: duration was 128 seconds. >13:34:02 Checkpoint Completed: duration was 3 seconds. >13:39:11 Checkpoint Completed: duration was 9 seconds. >13:44:19 Checkpoint Completed: duration was 8 seconds. >13:49:23 Checkpoint Completed: duration was 4 seconds. >13:54:26 Checkpoint Completed: duration was 3 seconds. >13:59:30 Checkpoint Completed: duration was 4 seconds. >14:04:33 Checkpoint Completed: duration was 3 seconds. >14:05:04 Logical Log 12365 - Backup Started >14:05:05 Logical Log 12365 Complete. >14:05:07 Logical Log 12365 - Backup Completed >14:09:36 Checkpoint Completed: duration was 3 seconds. >14:14:39 Checkpoint Completed: duration was 2 seconds. >14:19:41 Checkpoint Completed: duration was 3 seconds. >14:24:44 Checkpoint Completed: duration was 3 seconds. >14:31:22 Checkpoint Completed: duration was 167 seconds. >14:32:06 Lock table overflow - user id 100, session id 10139 >14:32:06 Lock table overflow - user id 100, session id 10139 >14:32:07 Lock table overflow - user id 1002, session id 10336 >14:32:07 Lock table overflow - user id 1002, session id 10336 >14:32:07 Lock table overflow - user id 1002, session id 10336 >14:32:08 Lock table overflow - user id 1002, session id 10336 >14:32:08 Lock table overflow - user id 1002, session id 10336 >14:32:08 Lock table overflow - user id 1002, session id 10336 >14:32:08 Lock table overflow - user id 1002, session id 10336 >14:32:09 Lock table overflow - user id 1002, session id 10336You have to check LOCKS in $ONCONFIG. But, you have the problem with checkpoint duration, too. Reason for that can be some others parameters in $ONCONFIG and your application logic. If in your application you have: large deletes or updates - try to lock table or split operations to smaller transactions selecting into temporary tables - use SELECT ... INTO TEMP t1 WITH NO LOG creating temporary tables - use CREATE TEMP TABLE t1 (....) WITH NO LOG Nebojsa ------------------------------------ Remove spam block (DELETE_) to reply