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


...全文
870 1 打赏 收藏 转发到动态 举报
写回复
用AI写文章
1 条回复
切换为时间正序
请发表友善的回复…
发表回复
本书由专业Informix用户、数据库管理员、Informix管理员和应用程序开发员编写而成,把各大Informix产品的方方面面综合、深入地集中在一起,包括最新Informix产品的详细信息,如Informix Internet Foundation.2000以及i.Reach、i.Sell和IDS.2000。本书作者在Web站点www.informixhandbook.com中根据产品的演变更新内容。    这个站点是由Informix数据库驱动的.提供了Informix的丰富信息,包括章节更新、代码样本、白皮书、站点链接等等。本书内容包括核心概念、Informix SQL、服务器管理、安装与维护、性能调整、应用程序开发、Web应用程序和对象关系式数据库等,所附光盘中有大量实用程序、白皮书和与书中内容有关的其他信息。还提供一些Web站点链接.包括免费的Linux与NT版Informix Dynamic Server以及基于计算机的Informix培训材料。 第一部分 informix的核心概念 第1章 informix:过去、现在与未来 1.1 不断变化的informix公司 1.2 informix产品战略简介 1.3 了解informix产品系列 1. 4 更多信息 1.5 informix和其他参考资料 第2章 出自硅谷 2.1 数据库与informix的诞生 2.2 移师门罗公园,推出更多产品 2.3 20世纪90年代的informix 2.4 走向新世纪 2.5 现状与未来 2.6 更多信息 2.7 informix和其他参考资料 第3章 生成与使用stores数据库 3.1 何谓stores数据库 3.2 stores数据库中的演示文件 3.3 利用stores数据库学习 3.4 测试stores数据库 .3.5 更多信息 3.6 informix与其他参考资料 第4章 了解lnformix体系结构 4.1 关于本章的重要信息 4.2 informix服务器的演变 4.3 informix服务器系列 4.4 管理实例与共享内存 4.5 了解磁盘使用 4.6 虚拟处理器与监视线程 4.7 用备份与日志保持容错 4.8 使用pdq与分块 4.9 更多信息 4.10 informix与其他参考资料 第5章 informix sql的独特特性 5.1 informix sql及其特性 5.2 遵循ansi sql标准 5.3 informix数据类型 5.4 更多信息 5.5 informix和其他参考资料 第6章 取得数据:界面 6.1 为什么要dbaccess与isql 6.2 dbaccess与isgl的区别 6.3 交互式运行命令 6.4 使用菜单 6.5 主菜单 6.6 选择数据库与服务器 6.7 query-langlage菜单 6.8 connection菜单(仅适用于dbaccess) 6.9 database菜单 6.10 table菜单 6.11 session菜单(仅适用于dbaccess) 6.12 form菜单(仅适用于isql) 6.13 report菜单(仅适用于isql) 6.14 user-menu菜单(仅适用于isql) 6.15 更多信息 6. 16 informix与其他参考资料 第7章 informix与数据仓库 7.1 何谓数据仓库 7.2 informix对数据仓库的投资 7.3 更多信息 7.4 informix与其他参考资料 第二部分 lnpormlx sql 第8章 生成数据库与表格 8.1 规划磁盘布局与存储要求 8.2 使用语法符号 8.3 生成数据库 8.4 删除数据库 8.5 生成表格 8.6 删除表格 8.7 改变表格 8.8 更多信息 8.9 informix与其他参考资料 第9章 select语句 9.1 select语句结构 9.2 选择喉一值 9.3 where子句 9.4 使用连接 9.5 group by子句 9.6 having子句 9.7 order by子句 9.8 intotemp子句 9.9 使用内部函数 9.10 从远程数据库中选择 9.11 从mode-ansi数据库选择 9.12 高级语句 9.13 基本性能考虑 9.14 更多信息 9. 15 informix与其他参考资料 第10章 插入、更新与删除 10.1 insert、update与delete的重要性 10.2 使用insert语句 10.3 使用update语句 10.4 使用de

1,195

社区成员

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

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