免费注册 查看新帖 |

Chinaunix

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

数据库每天崩溃? [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2007-08-17 08:47 |只看该作者 |倒序浏览
系统每天某个点前后崩溃,不知是什么造成。
平台AIX  应用:delphi,java ,4gl
onlinelog:

10:33:13  Event alarms enabled.  ALARMPROG = '/informix/etc/log_full.sh'
10:33:13  Booting Language <c> from module <>
10:33:13  Loading Module <CNULL>
10:33:13  Booting Language <builtin> from module <>
10:33:13  Loading Module <BUILTINNULL>
10:33:18  DR: DRAUTO is 0 (Off)
10:33:18  AIX MP latch code enabled
10:33:18  Requested shared memory segment size rounded from 5276KB to 5280KB
10:33:18  Requested shared memory segment size rounded from 5276KB to 5280KB
10:33:18  Dynamically allocated new message shared memory segment (size 5280KB)
10:33:18  IBM Informix Dynamic Server Version 10.00.FC4     Software Serial Number AAA#B000000
10:33:18  WARNING! Logical log layout may cause Dynamic Server to get into
          a locked state.  Recommended smallest logical log size
          is 2 times maximum concurrent user threads.

10:33:18  ( connection rejected - no calls allowed for sqlexec
10:33:19  (14) connection rejected - no calls allowed for sqlexec
10:33:19  (15) connection rejected - no calls allowed for sqlexec
10:33:19  (16) connection rejected - no calls allowed for sqlexec
10:33:19  (17) connection rejected - no calls allowed for sqlexec
10:33:19  (1 connection rejected - no calls allowed for sqlexec
10:33:19  (19) connection rejected - no calls allowed for sqlexec

10:33:20  (21) connection rejected - no calls allowed for sqlexec
10:33:20  (22) connection rejected - no calls allowed for sqlexec
10:33:20  IBM Informix Dynamic Server Initialized -- Shared Memory Initialized.

10:33:20  Physical Recovery Started at Page (2:47432).
10:33:20  Physical Recovery Complete: 29 Pages Examined, 29 Pages Restored.
10:33:21  Logical Recovery Started.
10:33:21  10 recovery worker threads will be started.
10:33:24  listener-thread: err = -25580: oserr = 32: errstr = : System error occurred in network function.
System error = 32.
10:33:25  Logical Recovery has reached the transaction cleanup phase.
10:33:25  Logical Recovery Complete.
          16 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks

10:33:26  Dataskip is now OFF for all dbspaces
10:33:26  Checkpoint Completed:  duration was 0 seconds.
10:33:26  Checkpoint loguniq 70986, logpos 0x7fa7018, timestamp: 0x5c2f3782

10:33:26  Maximum server connections 0
10:33:26  Dropping temporary TBLspace 0x602715, recovering 8 pages.
10:33:26  Dropping temporary TBLspace 0x602716, recovering 4 pages.
10:33:26  (107) connection rejected - no calls allowed for sqlexec
10:33:26  listener-thread: err = -27002: oserr = 0: errstr = : No connections are allowed in quiescent mode.
0:33:26  Dropping temporary TBLspace 0x60272c, recovering 8 pages.
10:33:26  Dropping temporary TBLspace 0x60274e, recovering 8 pages.
10:33:26  Dropping temporary TBLspace 0x602753, recovering 8 pages.
10:33:26  Dropping temporary TBLspace 0x602759, recovering 8 pages.
10:33:26  Dropping temporary TBLspace 0x602768, recovering 8 pages.
10:33:26  Dropping temporary TBLspace 0x602769, recovering 4 pages.
10:33:26  Dropping temporary TBLspace 0x60276c, recovering 4 pages.
10:33:26  Dropping temporary TBLspace 0x602789, recovering 8 pages.
10:33:26  Dropping temporary TBLspace 0x60278a, recovering 8 pages.
10:33:26  Dropping temporary TBLspace 0x60278b, recovering 4 pages.
10:33:26  Dropping temporary TBLspace 0x60278c, recovering 4 pages.
10:33:26  Dropping temporary TBLspace 0x602794, recovering 8 pages.
10:33:26  Dropping temporary TBLspace 0x602797, recovering 8 pages.
10:33:26  Dropping temporary TBLspace 0x6027b8, recovering 8 pages.
10:33:26  Dropping temporary TBLspace 0x6027c1, recovering 8 pages.
10:33:26  Dropping temporary TBLspace 0x6027c2, recovering 4 pages.
10:33:26  Dropping temporary TBLspace 0x6027c3, recovering 4 pages.
10:33:26  Dropping temporary TBLspace 0x6027c4, recovering 32 pages.
10:33:26  Dropping temporary TBLspace 0x6027c5, recovering 8 pages.
10:33:26  Dropping temporary TBLspace 0x6027c6, recovering 8 pages.
10:33:26  Dropping temporary TBLspace 0x6027c7, recovering 16 pages.
10:33:26  Dropping temporary TBLspace 0x6027c8, recovering 4 pages.
10:33:26  Dropping temporary TBLspace 0x6027c9, recovering 4 pages.

论坛徽章:
0
2 [报告]
发表于 2007-08-17 08:56 |只看该作者
是不是逻辑日志文件太小了?

论坛徽章:
0
3 [报告]
发表于 2010-01-25 12:35 |只看该作者

回复 #1 白云 的帖子

我也遇到了
看來informix用的人太少太少
donw了之後沒有log記錄

论坛徽章:
11
金牛座
日期:2015-03-19 16:56:22数据库技术版块每日发帖之星
日期:2016-08-02 06:20:00数据库技术版块每日发帖之星
日期:2016-04-24 06:20:00数据库技术版块每日发帖之星
日期:2016-04-13 06:20:00IT运维版块每日发帖之星
日期:2016-04-13 06:20:00数据库技术版块每日发帖之星
日期:2016-02-03 06:20:00数据库技术版块每日发帖之星
日期:2015-08-06 06:20:00季节之章:春
日期:2015-03-27 15:54:57羊年新春福章
日期:2015-03-27 15:54:37戌狗
日期:2015-03-19 16:56:41数据库技术版块每日发帖之星
日期:2016-08-18 06:20:00
4 [报告]
发表于 2010-01-25 12:40 |只看该作者
原帖由 linuxboy99 于 2010-1-25 12:35 发表
我也遇到了
看來informix用的人太少太少
donw了之後沒有log記錄


从上面的日志里压根就看不出因为什么down掉~~这个日志里只提供了重启后的online.log
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

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

清除 Cookies - ChinaUnix - Archiver - WAP - TOP