Informix安全问题

eg38132310 2014-12-17 10:18:29
Hi 大家:
请大家帮忙,我对informix的了解仅限于备份,运行了1年之后的有一天数据库突然停止了,后来发现逻辑日志满了,接着就发现问题的所在了。如下是bar_act.log和online.log日志的内容,请大家悦目。
我使用第三方备份软件networker 765(1.2NMDA模块)备份IDS10.0数据库时报错了。日志如下:
bar_act.log:
2014-11-18 19:00:01 18628 18625 /home/informix/bin/onbar_d -b
.............
2014-11-19 13:03:26 15637 15633 /home/informix/bin/onbar_d complete, returning 0 (0x00)

2014-11-19 19:00:01 7864 7862 /home/informix/bin/onbar_d -b
2014-11-19 19:00:01 7864 7862 Archive started on rootdbs, logdbs, phydbs, cdr_dbspace, cdr_qdata_sbspace, cdr_qhdr_dbspace, datadbs, idxdbs, tmpdbs1, tmpdbs2, tmpdbs3, tmpdbs4 (Requested Level 0).
2014-11-19 19:00:02 7864 7862 Begin level 0 backup rootdbs.
2014-11-19 19:00:02 7864 7862 Successfully connected to Storage Manager.
2014-11-19 19:00:03 7864 7862 Completed level 0 backup rootdbs (Storage Manager copy ID: 1416394802 1416394803).
2014-11-19 19:00:03 7914 7864 Process 7914 7864 successfully forked.
2014-11-19 19:00:03 7916 7864 Process 7916 7864 successfully forked.
2014-11-19 19:00:03 7915 7864 Process 7915 7864 successfully forked.
2014-11-19 19:00:03 7921 7864 Process 7921 7864 successfully forked.
2014-11-19 19:00:03 7920 7864 Process 7920 7864 successfully forked.
2014-11-19 19:00:03 7922 7864 Process 7922 7864 successfully forked.
2014-11-19 19:00:03 7919 7864 Process 7919 7864 successfully forked.
2014-11-19 19:00:03 7923 7864 Process 7923 7864 successfully forked.
2014-11-19 19:00:03 7924 7864 Process 7924 7864 successfully forked.
2014-11-19 19:00:03 7918 7864 Process 7918 7864 successfully forked.
2014-11-19 19:00:03 7917 7864 Process 7917 7864 successfully forked.
2014-11-19 19:00:04 7918 7864 Begin level 0 backup cdr_qhdr_dbspace.
2014-11-19 19:00:04 7915 7864 Begin level 0 backup phydbs.
2014-11-19 19:00:04 7924 7864 Begin level 0 backup tmpdbs4.
2014-11-19 19:00:04 7921 7864 Begin level 0 backup tmpdbs1.
2014-11-19 19:00:04 7922 7864 Begin level 0 backup tmpdbs2.
2014-11-19 19:00:04 7916 7864 Begin level 0 backup cdr_dbspace.
2014-11-19 19:00:04 7923 7864 Begin level 0 backup tmpdbs3.
2014-11-19 19:00:04 7914 7864 Begin level 0 backup logdbs.
2014-11-19 19:00:04 7915 7864 Successfully connected to Storage Manager.
2014-11-19 19:00:04 7918 7864 Successfully connected to Storage Manager.
2014-11-19 19:00:04 7920 7864 Begin level 0 backup idxdbs.
2014-11-19 19:00:04 7924 7864 Successfully connected to Storage Manager.
2014-11-19 19:00:04 7921 7864 Successfully connected to Storage Manager.
2014-11-19 19:00:04 7922 7864 Successfully connected to Storage Manager.
2014-11-19 19:00:04 7923 7864 Successfully connected to Storage Manager.
2014-11-19 19:00:04 7916 7864 Successfully connected to Storage Manager.
2014-11-19 19:00:04 7914 7864 Successfully connected to Storage Manager.
2014-11-19 19:00:04 7920 7864 Successfully connected to Storage Manager.
2014-11-19 19:00:05 7919 7864 Begin level 0 backup datadbs.
2014-11-19 19:00:05 7919 7864 Successfully connected to Storage Manager.
2014-11-19 19:00:05 7917 7864 Begin level 0 backup cdr_qdata_sbspace.
2014-11-19 19:00:05 7917 7864 Successfully connected to Storage Manager.
2014-11-19 19:00:10 7915 7864 Completed level 0 backup phydbs (Storage Manager copy ID: 1416394804 1416394805).
2014-11-19 19:00:10 7915 7864 Process 7915 7864 completed.
2014-11-19 19:00:10 7921 7864 Completed level 0 backup tmpdbs1 (Storage Manager copy ID: 1416394808 1416394809).
2014-11-19 19:00:10 7921 7864 Process 7921 7864 completed.
2014-11-19 19:00:11 7918 7864 Completed level 0 backup cdr_qhdr_dbspace (Storage Manager copy ID: 1416394807 1416394808).
2014-11-19 19:00:11 7918 7864 Process 7918 7864 completed.
2014-11-19 19:00:11 7924 7864 Completed level 0 backup tmpdbs4 (Storage Manager copy ID: 1416394809 1416394810).
2014-11-19 19:00:11 7924 7864 Process 7924 7864 completed.
2014-11-19 19:00:43 7917 7864 Completed level 0 backup cdr_qdata_sbspace (Storage Manager copy ID: 1416394806 1416394807).
2014-11-19 19:00:43 7917 7864 Process 7917 7864 completed.
2014-11-19 19:12:04 7922 7864 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2014-11-19 19:12:04 7923 7864 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2014-11-19 19:12:04 7916 7864 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2014-11-19 19:12:04 7914 7864 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
................
2014-11-19 21:12:04 7920 7864 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2014-11-19 21:12:58 7919 7864 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2014-11-19 21:35:56 7923 7864 XBSA Error: (BSACreateObject) A system error occurred. Aborting XBSA session.
2014-11-19 21:35:56 7914 7864 XBSA Error: (BSACreateObject) A system error occurred. Aborting XBSA session.
2014-11-19 21:35:56 7914 7864 Process 7914 7864 completed.
2014-11-19 21:35:56 7864 7862 (-43246) The ON-Bar process 7914 exited with a problem (exit code 3 (0x3),
signal 0).
2014-11-19 21:35:56 7923 7864 Process 7923 7864 completed.
2014-11-19 21:35:56 7864 7862 (-43246) The ON-Bar process 7923 exited with a problem (exit code 3 (0x3),
signal 0).
2014-11-19 21:52:04 7922 7864 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2014-11-19 21:52:04 7916 7864 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
...........
2014-11-19 22:32:04 7916 7864 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2014-11-19 22:32:04 7920 7864 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2014-11-19 22:32:58 7919 7864 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
.........
2014-11-20 12:32:58 7919 7864 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2014-11-20 13:00:02 4654 4648 /home/informix/bin/onbar_d -b -L 1
2014-11-20 13:00:02 4654 4648 Archive started on rootdbs, logdbs, phydbs, cdr_dbspace, cdr_qdata_sbspace, cdr_qhdr_dbspace, datadbs, idxdbs, tmpdbs1, tmpdbs2, tmpdbs3, tmpdbs4 (Requested Level 1).
2014-11-20 13:00:03 4654 4648 Begin level 1 backup rootdbs.
2014-11-20 13:00:03 4654 4648 Successfully connected to Storage Manager.
2014-11-20 13:12:03 4654 4648 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2014-11-20 13:12:05 7922 7864 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.

........
2014-11-20 15:12:05 7916 7864 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2014-11-20 15:12:05 7920 7864 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2014-11-20 15:12:58 7919 7864 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2014-11-20 15:38:13 4654 4648 XBSA Error: (BSACreateObject) A system error occurred. Aborting XBSA session.
2014-11-20 15:38:13 4654 4648 Archive on rootdbs, logdbs, phydbs, cdr_dbspace, cdr_qdata_sbspace, cdr_qhdr_dbspace, datadbs, idxdbs, tmpdbs1, tmpdbs2, tmpdbs3, tmpdbs4 ABORTED (Requested Level 1).
2014-11-20 15:38:13 4654 4648 /home/informix/bin/onbar_d complete, returning 3 (0x03)
2014-11-20 15:52:05 7922 7864 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2014-11-20 15:52:05 7916 7864 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2014-11-20 15:52:05 7920 7864 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.

online.log:
19:00:02 Checkpoint Completed: duration was 0 seconds.
19:00:02 Checkpoint loguniq 4941, logpos 0x5c55018, timestamp: 0x70dcfafb

19:00:02 Maximum server connections 48
19:00:02 Level 0 Archive started on rootdbs
19:00:03 Archive on rootdbs Completed.
19:00:04 Checkpoint Completed: duration was 0 seconds.
19:00:04 Checkpoint loguniq 4941, logpos 0x5c58018, timestamp: 0x70dcfbab

19:00:04 Maximum server connections 48
19:00:04 Level 0 Archive started on cdr_qhdr_dbspace
19:00:04 Level 0 Archive started on tmpdbs3
19:00:04 Level 0 Archive started on tmpdbs4
19:00:04 Level 0 Archive started on tmpdbs2
19:00:04 Level 0 Archive started on cdr_dbspace
19:00:04 Level 0 Archive started on phydbs
19:00:04 Level 0 Archive started on tmpdbs1
19:00:04 Level 0 Archive started on logdbs
19:00:04 Level 0 Archive started on idxdbs
19:00:05 Level 0 Archive started on datadbs
19:00:05 Checkpoint Completed: duration was 0 seconds.
19:00:05 Checkpoint loguniq 4941, logpos 0x5c59250, timestamp: 0x70dcfe06
19:00:05 Maximum server connections 48
19:00:05 Level 0 Archive started on cdr_qdata_sbspace
19:00:10 Archive on phydbs Completed.
19:00:10 Archive on tmpdbs1 Completed.
19:00:11 Archive on cdr_qhdr_dbspace Completed.
19:00:11 Archive on tmpdbs4 Completed.
19:00:43 Archive on cdr_qdata_sbspace Completed.
19:30:07 Fuzzy Checkpoint Completed: duration was 0 seconds, 2 buffers not flushed.
19:30:07 Checkpoint loguniq 4941, logpos 0x5c6a070, timestamp: 0x70dd0e01
19:30:07 Maximum server connections 48
20:00:09 Fuzzy Checkpoint Completed: duration was 0 seconds, 2 buffers not flushed.
20:00:09 Checkpoint loguniq 4941, logpos 0x5c6b070, timestamp: 0x70dd1018
20:00:09 Maximum server connections 48
21:35:56 Archive on logdbs ABORTED.
21:35:56 Aborted by client.
21:35:56 Archive on tmpdbs3 ABORTED.
21:35:56 Aborted by client.
09:07:24 Logical Log 4944 Complete, timestamp: 0x7103cc2b.
09:31:09 Fuzzy Checkpoint Completed: duration was 0 seconds, 5129 buffers not flushed.
09:31:09 Checkpoint loguniq 4945, logpos 0x38d1084, timestamp: 0x7110f30c


...全文
865 1 打赏 收藏 转发到动态 举报
写回复
用AI写文章
1 条回复
切换为时间正序
请发表友善的回复…
发表回复

1,194

社区成员

发帖
与我相关
我的任务
社区描述
其他数据库开发 Informix
社区管理员
  • Informix社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧