Oninit cdi / Archive
Talk to an expert →

dead lock in informix.ph_run ?

Posted in 2014

Topics: Error Codes & Troubleshooting, Transactions, Locking & Isolation, Logging & Checkpoints

FRANK — — source: IIUG Forums & Mailing Lists

Folks, IDS11.50 FC8 Any comments on the following online message? Thanks, Frank 1:16:49 Sun Apr 6 - loguniq 208549, logpos 0x20feb018, timestamp: 0x227c7884 Interval: 329515 21:16:49 Maximum server connections 288 21:16:49 Checkpoint Statistics - Avg. Txn Block Time 0.046, # Txns blocked 26, Plog used 24787, Llog used 460100 21:17:01 SCHAPI: [post_alarm_message 15-1603281] Error -243 Could not position within a table (informix.ph_run). 21:17:01 SCHAPI: [post_alarm_message 15-1603281] Error -143 ISAM error: deadlock detected 21:17:54 Logical Log 208550 Complete, timestamp: 0x22890a95. 21:17:54 Logical Log 208545 - Backup Started 21:18:20 Logical Log 208545 - Backup Completed 21:18:20 Logical Log 208546 - Backup Started 21:18:32 SCHAPI: [post_alarm_message 15-1603855] Error -243 Could not position within a table (informix.ph_run). 21:18:32 SCHAPI: [post_alarm_message 15-1603855] Error -143 ISAM error: deadlock detected 21:18:54 Logical Log 208546 - Backup Completed 21:18:54 Logical Log 208547 - Backup Started 21:19:27 SCHAPI: [post_alarm_message 15-1604253] Error -243 Could not position within a table (informix.ph_run). 21:19:27 SCHAPI: [post_alarm_message 15-1604253] Error -143 ISAM error: deadlock detected 21:19:45 Logical Log 208547 - Backup Completed 21:19:45 Logical Log 208548 - Backup Started 21:19:55 SCHAPI: [post_alarm_message 15-1604426] Error -243 Could not position within a table (informix.ph_run). 21:19:55 SCHAPI: [post_alarm_message 15-1604426] Error -143 ISAM error: deadlock detected 21:19:56 SCHAPI: [post_alarm_message 15-1604434] Error -243 Could not position within a table (informix.ph_run). 21:19:56 SCHAPI: [post_alarm_message 15-1604434] Error -143 ISAM error: deadlock detected 21:20:05 SCHAPI: [post_alarm_message 15-1604504] Error -243 Could not position within a table (informix.ph_run). 21:20:05 SCHAPI: [post_alarm_message 15-1604504] Error -143 ISAM error: deadlock detected 21:20:10 SCHAPI: [post_alarm_message 15-1604527] Error -243 Could not position within a table (informix.ph_run). 21:20:10 SCHAPI: [post_alarm_message 15-1604527] Error -143 ISAM error: deadlock detected 21:20:14 Logical Log 208548 - Backup Completed 21:20:14 Logical Log 208549 - Backup Started 21:20:33 Logical Log 208549 - Backup Completed 21:20:33 Logical Log 208550 - Backup Started 21:21:05 Logical Log 208550 - Backup Completed 21:21:15 SCHAPI: [post_alarm_message 15-1605056] Error -243 Could not position within a table (informix.ph_run). 21:21:15 SCHAPI: [post_alarm_message 15-1605056] Error -143 ISAM error: deadlock detected 21:21:23 SCHAPI: [post_alarm_message 15-1605120] Error -243 Could not position within a table (informix.ph_run). 21:21:23 SCHAPI: [post_alarm_message 15-1605120] Error -143 ISAM error: deadlock detected 21:21:57 Checkpoint Completed: duration was 276 seconds. 21:21:57 Sun Apr 6 - loguniq 208550, logpos 0x2d100018, timestamp: 0x22a86921 Interval: 329516 21:21:57 Maximum server connections 288 21:21:57 Checkpoint Statistics - Avg. Txn Block Time 0.002, # Txns blocked 33, Plog used 33589, Llog used 435548 21:22:52 Logical Log 208551 Complete, timestamp: 0x22ae8100. 21:22:52 Logical Log 208551 - Backup Started 21:23:26 Logical Log 208551 - Backup Completed 21:24:08 SCHAPI: [post_alarm_message 15-1606182] Error -243 Could not position within a table (informix.ph_run). 21:24:08 SCHAPI: [post_alarm_message 15-1606182] Error -143 ISAM error: deadlock detected 21:25:55 Checkpoint Completed: duration was 207 seconds. 21:25:55 Sun Apr 6 - loguniq 208551, logpos 0x2de28018, timestamp: 0x22c270db Interval: 329517 21:25:55 Maximum server connections 288 21:25:55 Checkpoint Statistics - Avg. Txn Block Time 0.075, # Txns blocked 25, Plog used 22887, Llog used 317744 21:26:21 SCHAPI: [post_alarm_message 15-1607482] Error -243 Could not position within a table (informix.ph_run). 21:26:21 SCHAPI: [post_alarm_message 15-1607482] Error -143 ISAM error: deadlock detected 21:26:23 SCHAPI: [post_alarm_message 15-1607503] Error -243 Could not position within a table (informix.ph_run). 21:26:23 SCHAPI: [post_alarm_message 15-1607503] Error -143 ISAM error: deadlock detected 21:27:01 SCHAPI: [post_alarm_message 15-1607816] Error -243 Could not position within a table (informix.ph_run). 21:27:01 SCHAPI: [post_alarm_message 15-1607816] Error -143 ISAM error: deadlock detected 21:27:49 Logical Log 208552 Complete, timestamp: 0x22d422f2. 21:27:50 Logical Log 208552 - Backup Started 21:28:07 Logical Log 208552 - Backup Completed 21:29:44 SCHAPI: [post_alarm_message 15-1608800] Error -243 Could not position within a table (informix.ph_run). 21:29:44 SCHAPI: [post_alarm_message 15-1608800] Error -143 ISAM error: deadlock detected 21:30:26 SCHAPI: [post_alarm_message 15-1609112] Error -243 Could not position within a table (informix.ph_run). 21:30:26 SCHAPI: [post_alarm_message 15-1609112] Error -143 ISAM error: deadlock detected 21:30:28 SCHAPI: [post_alarm_message 15-1609115] Error -243 Could not position within a table (informix.ph_run). 21:30:28 SCHAPI: [post_alarm_message 15-1609115] Error -143 ISAM error: deadlock detected 21:30:29 SCHAPI: [post_alarm_message 15-1609121] Error -243 Could not position within a table (informix.ph_run). 21:30:29 SCHAPI: [post_alarm_message 15-1609121] Error -143 ISAM error: deadlock detected 21:31:49 Checkpoint Completed: duration was 234 seconds. 21:31:49 Sun Apr 6 - loguniq 208553, logpos 0x714048, timestamp: 0x22eb8dd9 Interval: 329518 21:31:49 Maximum server connections 288 21:31:49 Checkpoint Statistics - Avg. Txn Block Time 0.067, # Txns blocked 26, Plog used 18860, Llog used 326839 21:33:03 Logical Log 208553 Complete, timestamp: 0x22fa5a42. 21:35:43 SCHAPI: [post_alarm_message 15-1611205] Error -243 Could not position within a table (informix.ph_run). 21:35:43 SCHAPI: [post_alarm_message 15-1611205] Error -143 ISAM error: deadlock detected 21:36:16 Checkpoint Completed: duration was 176 seconds. 21:36:16 Sun Apr 6 - loguniq 208554, logpos 0x1817018, timestamp: 0x2306c5f1 Interval: 329519 21:36:16 Maximum server connections 288 21:36:16 Checkpoint Statistics - Avg. Txn Block Time 0.001, # Txns blocked 31, Plog used 20716, Llog used 242114 21:39:52 Checkpoint Completed: duration was 67 seconds. 21:39:52 Sun Apr 6 - loguniq 208554, logpos 0x12b9b018, timestamp: 0x2314e374 Interval: 329520 21:39:52 Maximum server connections 288 21:39:52 Checkpoint Statistics - Avg. Txn Block Time 0.490, # Txns blocked 73, Plog used 16482, Llog used 78051 --001a11c2bd2eee9df204f666a1b4

↪ replying to FRANK
Alexandre Marini — — source: IIUG Forums & Mailing Lists

Hello, Frank. I have several boxes in 11.50.FC9 engine, but never saw this kind of lock message (rollback issue) in ph_run table. Is this a recently upgraded engine? If so, you could try to recreate the sysadmin database, maybe there is some error in your sysadmin structure. Please advice if you need some additional help in this, ok? It´s a simple process, look for the scripts in your $INFORMIXDIR/etc/sysadmin directory. There are sql scripts for stopping and recreating the sysadmin database manually. Hope this helps. Regards. Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10 IBM Information Management Informix Technical Professional IBM Infosphere DataStage Technical Professional Informix Senior DBA - Orizon Brasil BRIUG website administrator Informix independent consultant > To: ids@iiug.org > From: yunyaoqu@gmail.com > Subject: dead lock in informix.ph_run ? [32868] > Date: Sun, 6 Apr 2014 17:42:56 -0400 > > Folks, > > IDS11.50 FC8 > > Any comments on the following online message? > > Thanks, > Frank > > 1:16:49 Sun Apr 6 - loguniq 208549, logpos 0x20feb018, timestamp: > 0x227c7884 Interval: 329515 > 21:16:49 Maximum server connections 288 > 21:16:49 Checkpoint Statistics - Avg. Txn Block Time 0.046, # Txns blocked > 26, Plog used 24787, Llog used 460100 > 21:17:01 SCHAPI: [post_alarm_message 15-1603281] Error -243 Could not > position within a table (informix.ph_run). > 21:17:01 SCHAPI: [post_alarm_message 15-1603281] Error -143 ISAM error: > deadlock detected > 21:17:54 Logical Log 208550 Complete, timestamp: 0x22890a95. > 21:17:54 Logical Log 208545 - Backup Started > 21:18:20 Logical Log 208545 - Backup Completed > 21:18:20 Logical Log 208546 - Backup Started > 21:18:32 SCHAPI: [post_alarm_message 15-1603855] Error -243 Could not > position within a table (informix.ph_run). > 21:18:32 SCHAPI: [post_alarm_message 15-1603855] Error -143 ISAM error: > deadlock detected > 21:18:54 Logical Log 208546 - Backup Completed > 21:18:54 Logical Log 208547 - Backup Started > 21:19:27 SCHAPI: [post_alarm_message 15-1604253] Error -243 Could not > position within a table (informix.ph_run). > 21:19:27 SCHAPI: [post_alarm_message 15-1604253] Error -143 ISAM error: > deadlock detected > 21:19:45 Logical Log 208547 - Backup Completed > 21:19:45 Logical Log 208548 - Backup Started > 21:19:55 SCHAPI: [post_alarm_message 15-1604426] Error -243 Could not > position within a table (informix.ph_run). > 21:19:55 SCHAPI: [post_alarm_message 15-1604426] Error -143 ISAM error: > deadlock detected > 21:19:56 SCHAPI: [post_alarm_message 15-1604434] Error -243 Could not > position within a table (informix.ph_run). > 21:19:56 SCHAPI: [post_alarm_message 15-1604434] Error -143 ISAM error: > deadlock detected > 21:20:05 SCHAPI: [post_alarm_message 15-1604504] Error -243 Could not > position within a table (informix.ph_run). > 21:20:05 SCHAPI: [post_alarm_message 15-1604504] Error -143 ISAM error: > deadlock detected > 21:20:10 SCHAPI: [post_alarm_message 15-1604527] Error -243 Could not > position within a table (informix.ph_run). > 21:20:10 SCHAPI: [post_alarm_message 15-1604527] Error -143 ISAM error: > deadlock detected > 21:20:14 Logical Log 208548 - Backup Completed > 21:20:14 Logical Log 208549 - Backup Started > 21:20:33 Logical Log 208549 - Backup Completed > 21:20:33 Logical Log 208550 - Backup Started > 21:21:05 Logical Log 208550 - Backup Completed > 21:21:15 SCHAPI: [post_alarm_message 15-1605056] Error -243 Could not > position within a table (informix.ph_run). > 21:21:15 SCHAPI: [post_alarm_message 15-1605056] Error -143 ISAM error: > deadlock detected > 21:21:23 SCHAPI: [post_alarm_message 15-1605120] Error -243 Could not > position within a table (informix.ph_run). > 21:21:23 SCHAPI: [post_alarm_message 15-1605120] Error -143 ISAM error: > deadlock detected > 21:21:57 Checkpoint Completed: duration was 276 seconds. > 21:21:57 Sun Apr 6 - loguniq 208550, logpos 0x2d100018, timestamp: > 0x22a86921 Interval: 329516 > 21:21:57 Maximum server connections 288 > 21:21:57 Checkpoint Statistics - Avg. Txn Block Time 0.002, # Txns blocked > 33, Plog used 33589, Llog used 435548 > 21:22:52 Logical Log 208551 Complete, timestamp: 0x22ae8100. > 21:22:52 Logical Log 208551 - Backup Started > 21:23:26 Logical Log 208551 - Backup Completed > 21:24:08 SCHAPI: [post_alarm_message 15-1606182] Error -243 Could not > position within a table (informix.ph_run). > 21:24:08 SCHAPI: [post_alarm_message 15-1606182] Error -143 ISAM error: > deadlock detected > 21:25:55 Checkpoint Completed: duration was 207 seconds. > 21:25:55 Sun Apr 6 - loguniq 208551, logpos 0x2de28018, timestamp: > 0x22c270db Interval: 329517 > 21:25:55 Maximum server connections 288 > 21:25:55 Checkpoint Statistics - Avg. Txn Block Time 0.075, # Txns blocked > 25, Plog used 22887, Llog used 317744 > 21:26:21 SCHAPI: [post_alarm_message 15-1607482] Error -243 Could not > position within a table (informix.ph_run). > 21:26:21 SCHAPI: [post_alarm_message 15-1607482] Error -143 ISAM error: > deadlock detected > 21:26:23 SCHAPI: [post_alarm_message 15-1607503] Error -243 Could not > position within a table (informix.ph_run). > 21:26:23 SCHAPI: [post_alarm_message 15-1607503] Error -143 ISAM error: > deadlock detected > 21:27:01 SCHAPI: [post_alarm_message 15-1607816] Error -243 Could not > position within a table (informix.ph_run). > 21:27:01 SCHAPI: [post_alarm_message 15-1607816] Error -143 ISAM error: > deadlock detected > 21:27:49 Logical Log 208552 Complete, timestamp: 0x22d422f2. > 21:27:50 Logical Log 208552 - Backup Started > 21:28:07 Logical Log 208552 - Backup Completed > 21:29:44 SCHAPI: [post_alarm_message 15-1608800] Error -243 Could not > position within a table (informix.ph_run). > 21:29:44 SCHAPI: [post_alarm_message 15-1608800] Error -143 ISAM error: > deadlock detected > 21:30:26 SCHAPI: [post_alarm_message 15-1609112] Error -243 Could not > position within a table (informix.ph_run). > 21:30:26 SCHAPI: [post_alarm_message 15-1609112] Error -143 ISAM error: > deadlock detected > 21:30:28 SCHAPI: [post_alarm_message 15-1609115] Error -243 Could not > position within a table (informix.ph_run). > 21:30:28 SCHAPI: [post_alarm_message 15-1609115] Error -143 ISAM error: > deadlock detected > 21:30:29 SCHAPI: [post_alarm_message 15-1609121] Error -243 Could not > position within a table (informix.ph_run). > 21:30:29 SCHAPI: [post_alarm_message 15-1609121] Error -143 ISAM error: > deadlock detected > 21:31:49 Checkpoint Completed: duration was 234 seconds. > 21:31:49 Sun Apr 6 - loguniq 208553, logpos 0x714048, timestamp: > 0x22eb8dd9 Interval: 329518 > 21:31:49 Maximum server connections 288 > 21:31:49 Checkpoint Statistics - Avg. Txn Block Time 0.067, # Txns blocked > 26, Plog used 18860, Llog used 326839 > 21:33:03 Logical Log 208553 Complete, timestamp: 0x22fa5a42. > 21:35:43 SCHAPI: [post_alarm_message 15-1611205] Error -243 Could not > position within a table (informix.ph_run). > 21:35:43 SCHAPI: [post_alarm_message 15-1611205] Error -143 ISAM error: > deadlock detected > 21:36:16 Checkpoint Completed: duration was 176

Glossary