大哥大姐们,帮忙看下,在线等!
Mon Sep 26 09:19:14 201109:19:14Warning: PDQ functionality is not supported in IDS Innovator-C Edition.
The value of MAX_PDQPRIORITY cannot be set to 100. It is reset to 0.
09:19:14Booting Language <c> from module <>
09:19:14Loading Module <CNULL>
09:19:14Booting Language <builtin> from module <>
09:19:14Loading Module <BUILTINNULL>
09:19:14Could not disable priority aging: errno = 0
09:19:21DR: DRAUTO is 0 (Off)
09:19:21DR: ENCRYPT_HDR is 0 (HDR encryption Disabled)
09:19:21IBM Informix Dynamic Server Version 11.50.TC9IE Software Serial Number AAA#B000000
09:19:22IBM Informix Dynamic Server Initialized -- Shared Memory Initialized.
09:19:22Started 1 B-tree scanners.
09:19:23B-tree scanner threshold set at 5000.
09:19:23B-tree scanner range scan size set to -1.
09:19:23B-tree scanner ALICE mode set to 6.
09:19:23B-tree scanner index compression level set to med.
09:19:23Physical Recovery Started at Page (1:4291).
09:19:23Physical Recovery Complete: 0 Pages Examined, 0 Pages Restored.
09:19:23Logical Recovery Started.
09:19:2310 recovery worker threads will be started.
09:19:24Logical Recovery has reached the transaction cleanup phase.
09:19:24Logical Recovery Complete.
0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks
09:19:25Onconfig parameter STORAGE_FULL_ALARM modified from 0 to 3.
09:19:25Dataskip is now OFF for all dbspaces
09:19:25Init operation complete - Mode Online
09:19:25Checkpoint Completed:duration was 0 seconds.
09:19:25Mon Sep 26 - loguniq 6, logpos 0x670018, timestamp: 0x64059 Interval: 427
09:19:25Maximum server connections 0
09:19:25Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 2, Llog used 1
09:19:25On-Line Mode
09:19:28SCHAPI: Started dbScheduler thread.
09:19:29Booting Language <spl> from module <>
09:19:29Loading Module <SPLNULL>
09:19:29SCHAPI: Started 2 dbWorker threads.
09:19:31Warning: PDQ functionality is not supported in IDS Innovator-C Edition.
The value of PDQPRIORITY cannot be set to 10. It is reset to 0.
09:19:32SCHAPI: Error -206 The specified table (aus_command) is not in the database.
09:19:32SCHAPI: Error -111 ISAM error:no record found.
09:19:32SCHAPI: Error -206 The specified table (aus_command) is not in the database.
09:19:33SCHAPI: Error -111 ISAM error:no record found.
09:19:41Logical Log 6 Complete, timestamp: 0x6b0e4.
09:24:54Checkpoint Completed:duration was 0 seconds.
09:24:54Mon Sep 26 - loguniq 7, logpos 0x2a8898, timestamp: 0x70420 Interval: 428
09:24:54Maximum server connections 1
09:24:54Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 2370, Llog used 1532
09:29:54Checkpoint Completed:duration was 0 seconds.
09:29:54Mon Sep 26 - loguniq 7, logpos 0x2aa898, timestamp: 0x70498 Interval: 429
09:29:54Maximum server connections 1
09:29:54Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 8, Llog used 2
09:34:54Checkpoint Completed:duration was 0 seconds.
09:34:54Mon Sep 26 - loguniq 7, logpos 0x2ac018, timestamp: 0x704a3 Interval: 430
09:34:54Maximum server connections 1
09:34:54Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 2, Llog used 2
09:49:54Checkpoint Completed:duration was 0 seconds.
09:49:54Mon Sep 26 - loguniq 7, logpos 0x2ae018, timestamp: 0x704b2 Interval: 431
09:49:54Maximum server connections 1
09:49:54Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 2, Llog used 2
09:54:54Checkpoint Completed:duration was 0 seconds.
09:54:54Mon Sep 26 - loguniq 7, logpos 0x2b0958, timestamp: 0x70535 Interval: 432
09:54:54Maximum server connections 1
09:54:54Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 8, Llog used 2
09:59:54Checkpoint Completed:duration was 0 seconds.
09:59:54Mon Sep 26 - loguniq 7, logpos 0x2b21e4, timestamp: 0x705b3 Interval: 433
09:59:54Maximum server connections 1
09:59:54Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 4, Llog used 2
10:03:13dynamically allocated 20000 locks
10:03:25dynamically allocated 40000 locks
10:03:26Logical Log 7 Complete, timestamp: 0x80d50.
10:03:39Checkpoint Completed:duration was 0 seconds.
10:03:39Mon Sep 26 - loguniq 8, logpos 0x4dc17c, timestamp: 0x88010 Interval: 434
10:03:39Maximum server connections 6
10:03:39Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 1, Plog used 47, Llog used 3055
10:03:49dynamically allocated 80000 locks
10:03:54Checkpoint Completed:duration was 0 seconds.
10:03:54Mon Sep 26 - loguniq 8, logpos 0x7e52f4, timestamp: 0x8e098 Interval: 435
10:03:54Maximum server connections 6
10:03:54Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 15, Llog used 777
10:03:55Checkpoint Completed:duration was 0 seconds.
10:03:55Mon Sep 26 - loguniq 8, logpos 0x7e7018, timestamp: 0x8e0a5 Interval: 436
10:03:55Maximum server connections 6
10:03:55Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 1, Plog used 0, Llog used 3
10:03:59Checkpoint Completed:duration was 0 seconds.
10:03:59Mon Sep 26 - loguniq 8, logpos 0x7fbbe0, timestamp: 0x8e37c Interval: 437
10:03:59Maximum server connections 6
10:03:59Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 0, Llog used 20
10:04:02Logical Log Files are Full -- Backup is Needed
10:27:45SCHAPI: thread dbWorker1 task mon_sysenv(4-5) shutting down
10:27:45SCHAPI: thread dbWorker2 task post_alarm_message(15-5) shutting down
这个是今天的日志,早上来连不上了,好像锁表了,然后强制重启服务了,结果没起来,现在没办法备份逻辑日志了,全是共享内存不能初始化我的那个服务,现在怎么办?有没有办法不重建数据库啊?我的informix是装载windows下的。 Locks
addresswtlist owner lklist type tblsnumrowid key#/bsiz
c15b2180 ee84f98 0 HDR+S 100002 204 0
c15b2780 ee849a0 0 S 100002 204 0
c15b2d80 ee843a8 0 S 100002 204 0
c15b3380 ee86d70 0 HDR+S 100002 206 0
c15b3980 ee831c0 0 S 100002 206 0
c15b3f80 ee86180 0 S 100002 206 0
c15b4580 ee87368 0 S 100002 206 0
c15b4b80 ee86778 0 S 100002 206 0
c15b5d80 ee85b88 0 S 100002 206 0
c15b6380 ee86d70 c15b878HDR+X 200065 1f205 0 U
c15b6980 ee86d70 c15c6b8HDR+X 200065 1f806 0 U
c15b6f80 ee86d70 c15b698HDR+X 200065 1f807 0 U
c15b7580 ee86d70 c15b6f8HDR+X 200065 1f808 0 U
c15b7b80 ee86d70 c15b758HDR+X 200065 1f809 0 U
c15b8180 ee831c0 c15c658HDR+X 200065 efd08 0 U
c15b8780 ee86d70 c15b338HDR+IX 200065 0 0
c15b8d80 ee86d70 c15b638HDR+X 200065 1f206 0 U
c15b9380 ee86d70 c15b8d8HDR+X 200065 1f207 0 U
c15b9980 ee86d70 c15b938HDR+X 200065 1f208 0 U
c15b9f80 ee831c0 c15b398 IX 200065 0 0
c15ba580 ee86d70 c15e2d8HDR+X 200065 1f301 0 U
c15bab80 ee86d70 c15ba58HDR+X 200065 1f302 0 U
c15bb180 ee86d70 c15bab8HDR+X 200065 1f303 0 U
c15bb780 ee86d70 c15bb18HDR+X 200065 1f304 0 U
c15bbd80 ee86d70 c15bb78HDR+X 200065 1f305 0 U
c15bc380 ee85b88 c15e338HDR+X 200065 eff02 0 U
c15bc980 ee85b88 c15bc38HDR+X 200065 eff03 0 U
c15bcf80 ee85b88 c15bc98HDR+X 200065 eff04 0 U
c15bdb80 ee86d70 c15fb98HDR+X 200065 1f705 0 U
c15be180 ee86d70 c15bdb8HDR+X 200065 1f706 0 U
c15be780 ee86d70 c15be18HDR+X 200065 1f707 0 U
c15bed80 ee86d70 c15be78HDR+X 200065 1f708 0 U
c15bf380 ee831c0 c15fb38HDR+X 200065 efc07 0 U
c15bf980 ee87368 c15b458 IX 200065 0 0
c15bff80 ee86d70 c15bbd8HDR+X 200065 1f306 0 U
c15c0580 ee86d70 c15bff8HDR+X 200065 1f307 0 U
c15c0b80 ee86d70 c15c058HDR+X 200065 1f308 0 U
c15c1180 ee86d70 c15c0b8HDR+X 200065 1f309 0 U
c15c1780 ee86d70 c15e698HDR+X 200065 1f801 0 U
c15c1d80 ee86d70 c15c178HDR+X 200065 1f802 0 U
c15c2380 ee86d70 c15c1d8HDR+X 200065 1f803 0 U
c15c2980 ee86d70 c15c238HDR+X 200065 1f804 0 U
c15c2f80 ee831c0 c15e638HDR+X 200065 efd03 0 U
c15c3580 ee831c0 c15e278HDR+X 200065 ef808 0 U
c15c3b80 ee87368 c15bf98HDR+X 200065 1fa02 0 U
c15c4180 ee87368 c15c3b8HDR+X 200065 1fa03 0
c15c5380 ee831c0 c15c2f8HDR+X 200065 efd04 0 U
c15c5980 ee831c0 c15c538HDR+X 200065 efd05 0 U
c15c5f80 ee831c0 c15c598HDR+X 200065 efd06 0 U
c15c6580 ee831c0 c15c5f8HDR+X 200065 efd07 0 U
c15c6b80 ee86d70 c15c298HDR+X 200065 1f805 0 U
c15c7180 ee84f98 c15b218HDR+IX 1000f2 0 0
c15c7780 ee84f98 c15c718HDR+X 1000f2 305 0
c15c8f80 ee86180 c15b3f8HDR+IX 20003d 0 0
c15c9580 ee86180 c15c8f8HDR+X 20003d 206 0
c15cad80 ee87960 0 S 100002 206 0
c15cb380 ee86d70 c15ec98HDR+X 200065 1f907 0 U
c15cb980 ee86d70 c15cb38HDR+X 200065 1f908 0 U
c15cbf80 ee86d70 c15cb98HDR+X 200065 1f909 0 U
c15cc580 ee86d70 c15cbf8HDR+X 200065 1fa01 0 U
c15ccb80 ee86d70 c15d438HDR+X 200065 1f503 0 U
c15cd180 ee86d70 c15ccb8HDR+X 200065 1f504 0 U
c15cd780 ee86d70 c15cd18HDR+X 200065 1f505 0 U
c15cdd80 ee86d70 c15cd78HDR+X 200065 1f506 0 U
c15ce380 ee831c0 c15d1f8HDR+X 200065 efa05 0 U
c15ce980 ee831c0 c15ea58HDR+X 200065 efe09 0 U
c15cef80 ee86d70 c15df78HDR+X 200065 1f902 0 U
c15cf580 ee86d70 c15cef8HDR+X 200065 1f903 0 U
c15cfb80 ee86d70 c15cf58HDR+X 200065 1f904 0 U
c15d0180 ee86d70 c15cfb8HDR+X 200065 1f905 0 U
c15d0780 ee831c0 c15df18HDR+X 200065 efe04 0 U
c15d0d80 ee831c0 c15f058HDR+X 200065 efa01 0 U
c15d1380 ee831c0 c15d0d8HDR+X 200065 efa02 0 U
c15d1980 ee831c0 c15d138HDR+X 200065 efa03 0 U
c15d1f80 ee831c0 c15d198HDR+X 200065 efa04 0 U
c15d2580 ee831c0 c15b9f8HDR+X 200065 ef708 0 U
c15d2b80 ee831c0 c15d258HDR+X 200065 ef709 0 U
c15d3180 ee831c0 c15d2b8HDR+X 200065 ef801 0 U
c15d3780 ee831c0 c15d318HDR+X 200065 ef802 0 U
c15d3d80 ee831c0 c15d378HDR+X 200065 ef803 0 U
c15d4380 ee86d70 c15eff8HDR+X 200065 1f502 0 U
c15d4980 ee831c0 c15d9d8HDR+X 200065 efb07 0 U
c15d4f80 ee831c0 c15d498HDR+X 200065 efb08 0 U
c15d5580 ee831c0 c15d4f8HDR+X 200065 efb09 0 U
c15d5b80 ee831c0 c15d558HDR+X 200065 efc01 0 U
c15d6180 ee831c0 c15ce38HDR+X 200065 efa06 0 U
c15d6780 ee831c0 c15d618HDR+X 200065 efa07 0 U
c15d6d80 ee831c0 c15d678HDR+X 200065 efa08 0 U
c15d7380 ee831c0 c15d6d8HDR+X 200065 efa09 0 U
c15d7980 ee831c0 c15d738HDR+X 200065 efb01 0 U
c15d7f80 ee86d70 c15d978HDR+X 200065 1f603 0 U
c15d8580 ee86d70 c15e6f8HDR+X 200065 1f508 0 U
c15d8b80 ee86d70 c15d858HDR+X 200065 1f509 0 U
c15d9180 ee86d70 c15d8b8HDR+X 200065 1f601 0 U
c15d9780 ee86d70 c15d918HDR+X 200065 1f602 0 U
c15d9d80 ee831c0 c15e4b8HDR+X 200065 efb06 0 U
c15da380 ee831c0 c15c358HDR+X 200065 ef809 0 U
c15da980 ee831c0 c15da38HDR+X 200065 ef901 0 U
c15daf80 ee831c0 c15da98HDR+X 200065 ef902 0 U
c15db580 ee831c0 c15daf8HDR+X 200065 ef903 0 U
c15dbb80 ee831c0 c15dd98HDR+X 200065 ef905 0 U
c15dc180 ee831c0 c15dbb8HDR+X 200065 ef906 0 U
c15dc780 ee831c0 c15dc18HDR+X 200065 ef907 0 U
c15dcd80 ee831c0 c15dc78HDR+X 200065 ef908 0 U
c15dd380 ee86d70 c15c118HDR+X 200065 1f401 0 U
c15dd980 ee831c0 c15db58HDR+X 200065 ef904 0 U
c15ddf80 ee831c0 c15b818HDR+X 200065 efd09 0 U
c15de580 ee831c0 c15ddf8HDR+X 200065 efe01 0 U
c15deb80 ee831c0 c15de58HDR+X 200065 efe02 0 U
c15df180 ee831c0 c15deb8HDR+X 200065 efe03 0 U
c15df780 ee86d70 c15b7b8HDR+X 200065 1f901 0 U
c15dfd80 ee831c0 c15ce98HDR+X 200065 eff01 0 U
c15e1580 ee831c0 c15d3d8HDR+X 200065 ef804 0 U
c15e1b80 ee831c0 c15e158HDR+X 200065 ef805 0 U
c15e2180 ee831c0 c15e1b8HDR+X 200065 ef806 0 U
c15e2780 ee831c0 c15e218HDR+X 200065 ef807 0 U
c15e2d80 ee86d70 c15b998HDR+X 200065 1f209 0 U
c15e3380 ee85b88 c15b5d8 IX 200065 0 0
c15e3980 ee831c0 c15d798HDR+X 200065 efb02 0 U
c15e3f80 ee831c0 c15e398HDR+X 200065 efb03 0 U
c15e4580 ee831c0 c15e3f8HDR+X 200065 efb04 0 U
c15e4b80 ee831c0 c15e458HDR+X 200065 efb05 0 U
c15e5180 ee831c0 c15bf38HDR+X 200065 efc08 0 U
c15e5780 ee831c0 c15e518HDR+X 200065 efc09 0 U
c15e5d80 ee831c0 c15e578HDR+X 200065 efd01 0 U
c15e6380 ee831c0 c15e5d8HDR+X 200065 efd02 0 U
c15e6980 ee86d70 c15bed8HDR+X 200065 1f709 0 U
c15e6f80 ee86d70 c15cdd8HDR+X 200065 1f507 0 U
c15e9380 ee831c0 c15d078HDR+X 200065 efe05 0 U
c15e9980 ee831c0 c15e938HDR+X 200065 efe06 0 U
c15e9f80 ee831c0 c15e998HDR+X 200065 efe07 0 U
c15ea580 ee831c0 c15e9f8HDR+X 200065 efe08 0 U
c15eab80 ee86d70 c15dd38HDR+X 200065 1f402 0 U
c15eb180 ee86d70 c15eab8HDR+X 200065 1f403 0 U
c15eb780 ee86d70 c15eb18HDR+X 200065 1f404 0 U
c15ebd80 ee86d70 c15eb78HDR+X 200065 1f405 0 U
c15ec380 ee86d70 c15ebd8HDR+X 200065 1f406 0 U
c15ec980 ee86d70 c15d018HDR+X 200065 1f906 0 U
c15ecf80 ee86d70 c15d7f8HDR+X 200065 1f604 0 U
c15ed580 ee86d70 c15ecf8HDR+X 200065 1f605 0 U
c15edb80 ee86d70 c15ed58HDR+X 200065 1f606 0 U
c15ee180 ee86d70 c15edb8HDR+X 200065 1f607 0 U
c15ee780 ee86d70 c15ee18HDR+X 200065 1f608 0 U
c15eed80 ee86d70 c15ec38HDR+X 200065 1f407 0 U
c15ef380 ee86d70 c15eed8HDR+X 200065 1f408 0 U
c15ef980 ee86d70 c15ef38HDR+X 200065 1f409 0 U
c15eff80 ee86d70 c15ef98HDR+X 200065 1f501 0 U
c15f0580 ee831c0 c15dcd8HDR+X 200065 ef909 0 U
c15f2980 ee86d70 c15ee78HDR+X 200065 1f609 0 U
c15f2f80 ee86d70 c15f298HDR+X 200065 1f701 0 U
c15f3580 ee86d70 c15f2f8HDR+X 200065 1f702 0 U
c15f3b80 ee86d70 c15f358HDR+X 200065 1f703 0 U
c15f4180 ee831c0 c15d5b8HDR+X 200065 efc02 0 U
c15fa180 ee831c0 c15f418HDR+X 200065 efc03 0 U
c15fa780 ee831c0 c15fa18HDR+X 200065 efc04 0 U
c15fad80 ee831c0 c15fa78HDR+X 200065 efc05 0 U
c15fb380 ee831c0 c15fad8HDR+X 200065 efc06 0 U
c15fb980 ee86d70 c15f3b8HDR+X 200065 1f704 0 U
158 active, 260000 total, 16384 hash buckets, 4 lock table overflows
没人能回答我么,sessid杀不掉,onmode -ky没反应,重启服务失败,这个该怎么办啊? 逻辑日志满了吧
页:
[1]