免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 1618 | 回复: 2
打印 上一主题 下一主题

今天数据库宕掉了,这是online。log的一段,谁能找出点毛病来 [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2003-06-02 17:39 |只看该作者 |倒序浏览
05:31:41  Checkpoint Completed:  duration was 0 seconds.
05:36:44  Checkpoint Completed:  duration was 0 seconds.
05:41:46  Checkpoint Completed:  duration was 0 seconds.
05:45:00  Logical Log 1510 Complete.
05:45:00  Process exited with return code 1: /bin/sh /bin/sh -c /usr/informix/log_full.sh 2 23 "Logical Log 1510 Complete." "Logical Log 1510 Complete."
05:46:49  Checkpoint Completed:  duration was 0 seconds.
05:51:52  Checkpoint Completed:  duration was 0 seconds.
05:56:55  Checkpoint Completed:  duration was 0 seconds.
06:01:58  Checkpoint Completed:  duration was 0 seconds.
06:07:01  Checkpoint Completed:  duration was 0 seconds.
06:12:04  Checkpoint Completed:  duration was 0 seconds.
06:17:07  Checkpoint Completed:  duration was 0 seconds.
06:22:11  Checkpoint Completed:  duration was 0 seconds.
06:25:22  Logical Log 1511 Complete.
06:25:22  Process exited with return code 1: /bin/sh /bin/sh -c /usr/informix/log_full.sh 2 23 "Logical Log 1511 Complete." "Logical Log 1511 Complete."
06:27:14  Checkpoint Completed:  duration was 0 seconds.
06:32:16  Checkpoint Completed:  duration was 0 seconds.
06:37:19  Checkpoint Completed:  duration was 0 seconds.
06:42:22  Checkpoint Completed:  duration was 0 seconds.
06:47:25  Checkpoint Completed:  duration was 0 seconds.
06:52:28  Checkpoint Completed:  duration was 0 seconds.
06:57:31  Checkpoint Completed:  duration was 0 seconds.
06:58:00  Logical Log 1512 Complete.
06:58:00  Process exited with return code 1: /bin/sh /bin/sh -c /usr/informix/log_full.sh 2 23 "Logical Log 1512 Complete." "Logical Log 1512 Complete."
07:02:34  Checkpoint Completed:  duration was 0 seconds.
07:07:37  Checkpoint Completed:  duration was 0 seconds.
07:12:40  Checkpoint Completed:  duration was 0 seconds.
07:17:42  Checkpoint Completed:  duration was 0 seconds.
07:22:45  Checkpoint Completed:  duration was 0 seconds.
07:25:31  Logical Log 1513 Complete.
07:25:31  Process exited with return code 1: /bin/sh /bin/sh -c /usr/informix/log_full.sh 2 23 "Logical Log 1513 Complete." "Logical Log 1513 Complete."
07:27:48  Checkpoint Completed:  duration was 0 seconds.
07:32:51  Checkpoint Completed:  duration was 0 seconds.
07:37:54  Checkpoint Completed:  duration was 0 seconds.
07:42:57  Checkpoint Completed:  duration was 0 seconds.
07:46:37  Logical Log 1514 Complete.
07:46:37  Process exited with return code 1: /bin/sh /bin/sh -c /usr/informix/log_full.sh 2 23 "Logical Log 1514 Complete." "Logical Log 1514 Complete."
07:47:16  Checkpoint Completed:  duration was 0 seconds.
07:51:38  Checkpoint Completed:  duration was 1 seconds.
07:56:16  Checkpoint Completed:  duration was 0 seconds.
07:59:49  Checkpoint Completed:  duration was 1 seconds.
08:02:24  Logical Log 1515 Complete.
08:02:24  Process exited with return code 1: /bin/sh /bin/sh -c /usr/informix/log_full.sh 2 23 "Logical Log 1515 Complete." "Logical Log 1515 Complete."
08:02:46  Checkpoint Completed:  duration was 0 seconds.
08:05:44  Checkpoint Completed:  duration was 1 seconds.
08:09:41  Checkpoint Completed:  duration was 1 seconds.
08:13:19  Checkpoint Completed:  duration was 0 seconds.
08:14:58  Logical Log 1516 Complete.
08:14:59  Process exited with return code 1: /bin/sh /bin/sh -c /usr/informix/log_full.sh 2 23 "Logical Log 1516 Complete." "Logical Log 1516 Complete."
08:16:05  Checkpoint Completed:  duration was 1 seconds.
08:19:33  Checkpoint Completed:  duration was 0 seconds.
08:22:11  Checkpoint Completed:  duration was 0 seconds.
08:24:55  Checkpoint Completed:  duration was 0 seconds.
08:25:30  Logical Log 1517 Complete.
08:25:30  Process exited with return code 1: /bin/sh /bin/sh -c /usr/informix/log_full.sh 2 23 "Logical Log 1517 Complete." "Logical Log 1517 Complete."
08:28:04  Checkpoint Completed:  duration was 0 seconds.
08:31:19  Checkpoint Completed:  duration was 0 seconds.
08:34:25  Checkpoint Completed:  duration was 0 seconds.
08:37:13  Checkpoint Completed:  duration was 0 seconds.
08:37:34  Logical Log 1518 Complete.
08:37:34  Process exited with return code 1: /bin/sh /bin/sh -c /usr/informix/log_full.sh 2 23 "Logical Log 1518 Complete." "Logical Log 1518 Complete."
08:39:58  Checkpoint Completed:  duration was 0 seconds.
08:42:48  Checkpoint Completed:  duration was 0 seconds.
08:45:17  Checkpoint Completed:  duration was 0 seconds.
08:46:55  Assert Failed: Internal Error - Segmentation Violation
08:46:55   Who: Session(39697, cgi@scosys, 20403, -2109329104)
                Thread(826157, sqlexec, 82445424, 1)
08:46:55   Results: OnLine must abort
08:46:55   Action: Reinitialize shared memory
08:46:55   See Also: /tmp/af.9b2d9e7f, shmem.9b2d9e7f.0
08:47:00  rsinit.c, line 9934, thread 826157, proc id 440, Segmentation Violation.
08:47:00    PANIC: Attempting to bring system down

Mon Jun  2 09:11:57 2003

09:11:57  Event alarms enabled.  ALARMPROG = '/usr/informix/log_full.sh'
09:11:59  DR: DRAUTO is 0 (Off)
09:12:00  ( connection rejected - no calls allowed for sqlexec
09:12:00  listener-thread: err = -27002: No connections are allowed in OnLine quiescent mode.

09:12:00  INFORMIX-OnLine Initialized -- Shared Memory Initialized.
09:12:00  Physical Recovery Started.
09:12:02  Assert Failed: WARNING! pthdrpage:ptalloc:bad bfget
09:12:02   Who: Session(11, informix@scosys, 0, -210933260
                Thread(25, fast_rec, 82440cb0, 1)
09:12:02   Results: Cannot use TBLSpace page for TBLSpace 4194305
09:12:02   Action: Run 'oncheck -pt 4194305'
09:12:02   See Also: /tmp/af.19a462
09:12:02  Cannot Open DBspace 4.
09:12:02  Physical Recovery Complete: 272 Pages Restored.
09:12:02  Logical Recovery Started.
09:12:03  Process exited with return code 1: /bin/sh /bin/sh -c /usr/informix/log_full.sh 3 12 "Cannot open DBspace: 'logdbs            informix'." "Cannot Open DBspa
09:12:03  Process exited with return code 1: /bin/sh /bin/sh -c /usr/informix/log_full.sh 3 1 "Table failure: 'TBLSpace 4194305'." "pthdrpage:ptalloc:bad bfget" /tmp/
09:12:06  Logical Recovery Complete.
        134 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks

09:12:06  Dataskip is now OFF for all dbspaces
09:12:06  On-Line Mode
09:12:06  Checkpoint Completed:  duration was 0 seconds.
09:12:08  WARNING! Physical Log size 1000 is too small.
          Physical Log overflows may occur during peak activity.
          Recommended minimum Physical Log size is 20 times maximum
          concurrent user threads.

09:12:08  Process exited with return code 1: /bin/sh /bin/sh -c /usr/informix/log_full.sh 3 7 "OnLine Initialization failure." "WARNING! Physical Log size 1000 is too
09:12:10  Logical Log 1519 Complete.
09:12:11  Process exited with return code 1: /bin/sh /bin/sh -c /usr/informix/log_full.sh 2 23 "Logical Log 1519 Complete." "Logical Log 1519 Complete."
09:12:14  WARNING! Buffer pool size may cause On-Line to get into
          a locked state.  Recommended minimum buffer pool size is
          4 times maximum concurrent user threads.
09:12:15  Process exited with return code 1: /bin/sh /bin/sh -c /usr/informix/log_full.sh 3 7 "OnLine Initialization failure." "WARNING! Buffer pool size may cause On
09:15:05  Checkpoint Completed:  duration was 0 seconds.
09:16:54  Checkpoint Completed:  duration was 0 seconds.
09:19:12  Checkpoint Completed:  duration was 1 seconds.
09:21:25  Checkpoint Completed:  duration was 1 seconds.
09:21:27  Logical Log 1520 Complete.
09:21:27  Process exited with return code 1: /bin/sh /bin/sh -c /usr/informix/log_full.sh 2 23 "Logical Log 1520 Complete." "Logical Log 1520 Complete."
09:23:43  Checkpoint Completed:  duration was 0 seconds.
09:26:33  Checkpoint Completed:  duration was 0 seconds.
09:29:13  Checkpoint Completed:  duration was 0 seconds.
09:30:50  Logical Log 1521 Complete.
09:30:50  Process exited with return code 1: /bin/sh /bin/sh -c /usr/informix/log_full.sh 2 23 "Logical Log 1521 Complete." "Logical Log 1521 Complete."
09:31:28  Checkpoint Completed:  duration was 0 seconds.
09:33:21  Checkpoint Completed:  duration was 0 seconds.
09:35:44  Checkpoint Completed:  duration was 0 seconds.
09:38:03  Checkpoint Completed:  duration was 0 seconds.
09:39:38  Logical Log 1522 Complete.
09:39:38  Process exited with return code 1: /bin/sh /bin/sh -c /usr/informix/log_full.sh 2 23 "Logical Log 1522 Complete." "Logical Log 1522 Complete."
09:40:09  Checkpoint Completed:  duration was 0 seconds.
09:42:11  Checkpoint Completed:  duration was 0 seconds.
09:45:06  Checkpoint Completed:  duration was 0 seconds.
09:47:36  Checkpoint Completed:  duration was 0 seconds.
09:48:52  Logical Log 1523 Complete.
09:48:52  Process exited with return code 1: /bin/sh /bin/sh -c /usr/informix/log_full.sh 2 23 "Logical Log 1523 Complete." "Logical Log 1523 Complete."
09:49:55  Checkpoint Completed:  duration was 1 seconds.
09:52:14  Checkpoint Completed:  duration was 0 seconds.
09:54:04  Checkpoint Completed:  duration was 0 seconds.
09:56:39  Checkpoint Completed:  duration was 0 seconds.
09:57:50  Logical Log 1524 Complete.
09:57:51  Process exited with return code 1: /bin/sh /bin/sh -c /usr/informix/log_full.sh 2 23 "Logical Log 1524 Complete." "Logical Log 1524 Complete."
09:59:13  Assert Failed: WARNING! pthdrpage:ptalloc:bad bfget
09:59:13   Who: Session(6305, informix@scosys, 6273, -2109317132)
                Thread(6318, oncheck, 8244d23c, 1)
09:59:13   Results: Cannot use TBLSpace page for TBLSpace 4194305
09:59:13   Action: Run 'oncheck -pt 4194305'
09:59:13   See Also: /tmp/af.18aeaf70
09:59:13  Process exited with return code 1: /bin/sh /bin/sh -c /usr/informix/log_full.sh 3 1 "Table failure: 'TBLSpace 4194305'." "pthdrpage:ptalloc:bad bfget" /tmp/
09:59:35  Checkpoint Completed:  duration was 0 seconds.
10:01:01  Checkpoint Completed:  duration was 1 seconds.
10:02:36  Checkpoint Completed:  duration was 1 seconds.
10:04:32  Checkpoint Completed:  duration was 0 seconds.
10:05:17  Logical Log 1525 Complete.
10:05:17  Process exited with return code 1: /bin/sh /bin/sh -c /usr/informix/log_full.sh 2 23 "Logical Log 1525 Complete." "Logical Log 1525 Complete."
10:06:19  Checkpoint Completed:  duration was 0 seconds.
10:08:20  Checkpoint Completed:  duration was 0 seconds.
10:10:59  Checkpoint Completed:  duration was 1 seconds.
10:13:15  Checkpoint Completed:  duration was 0 seconds.
10:14:18  Logical Log 1526 Complete.
10:14:18  Process exited with return code 1: /bin/sh /bin/sh -c /usr/informix/log_full.sh 2 23 "Logical Log 1526 Complete." "Logical Log 1526 Complete."
10:15:17  Checkpoint Completed:  duration was 1 seconds.
10:16:50  Checkpoint Completed:  duration was 1 seconds.
10:18:46  Checkpoint Completed:  duration was 0 seconds.
10:21:07  Checkpoint Completed:  duration was 1 seconds.
10:22:34  Logical Log 1527 Complete.
10:22:34  Process exited with return code 1: /bin/sh /bin/sh -c /usr/informix/log_full.sh 2 23 "Logical Log 1527 Complete." "Logical Log 1527 Complete."
10:23:00  Checkpoint Completed:  duration was 0 seconds.
10:25:08  Checkpoint Completed:  duration was 0 seconds.
10:27:28  Checkpoint Completed:  duration was 0 seconds.
10:30:04  Checkpoint Completed:  duration was 0 seconds.
10:31:44  Logical Log 1528 Complete.
10:31:44  Process exited with return code 1: /bin/sh /bin/sh -c /usr/informix/log_full.sh 2 23 "Logical Log 1528 Complete." "Logical Log 1528 Complete."
10:31:59  Checkpoint Completed:  duration was 0 seconds.
10:33:38  Checkpoint Completed:  duration was 0 seconds.
10:35:36  Checkpoint Completed:  duration was 1 seconds.
10:37:21  Checkpoint Completed:  duration was 0 seconds.

论坛徽章:
0
2 [报告]
发表于 2003-06-02 17:57 |只看该作者

今天数据库宕掉了,这是online。log的一段,谁能找出点毛病来

09:12:02 Action: Run 'oncheck -pt 4194305'
09:12:14 WARNING! Buffer pool size may cause On-Line to get into
a locked state. Recommended minimum buffer pool size is
4 times maximum concurrent user threads.
09:12:08 WARNING! Physical Log size 1000 is too small.
Physical Log overflows may occur during peak activity.
Recommended minimum Physical Log size is 20 times maximum
concurrent user threads.
这些信息值得注意。

论坛徽章:
1
荣誉版主
日期:2011-11-23 16:44:17
3 [报告]
发表于 2003-06-02 18:34 |只看该作者

今天数据库宕掉了,这是online。log的一段,谁能找出点毛病来

调整一下buffer number和phylog size。
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP