免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
› 论坛 › 数据库技术 › Informix › 一个决策数据库加工时每天都报错：_aiowrite() returnin ...
最近访问板块 发新帖
查看: 3074 | 回复: 7
打印 上一主题 下一主题

一个决策数据库加工时每天都报错：_aiowrite() returning EAGAIN [复制链接]

Jens

论坛徽章:
0
跳转到指定楼层
1楼 [收藏(0)] [报告]
发表于 2006-01-25 16:50 |只看该作者 |倒序浏览
数据库大概20G，系统加数据时报的错，时间很短。

08:27:09  Checkpoint Completed:  duration was 4 seconds.
08:27:09  Checkpoint loguniq 2128, logpos 0x2b30054

08:32:11  Checkpoint Completed:  duration was 3 seconds.
08:32:11  Checkpoint loguniq 2128, logpos 0x2b5d35c

08:37:15  Checkpoint Completed:  duration was 3 seconds.
08:37:15  Checkpoint loguniq 2128, logpos 0x2b77018

08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  *** _aiowrite() returning EAGAIN ***
08:38:47  KAIO: out of OS resources, errno = 11, pid = 364726
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  *** _aiowrite() returning EAGAIN ***
08:38:51  KAIO: out of OS resources, errno = 11, pid = 364726
08:42:18  Checkpoint Completed:  duration was 4 seconds.
08:42:18  Checkpoint loguniq 2128, logpos 0x2c24018

08:47:21  Checkpoint Completed:  duration was 3 seconds.
08:47:21  Checkpoint loguniq 2128, logpos 0x2c560fc

08:52:28  Checkpoint Completed:  duration was 6 seconds.
08:52:28  Checkpoint loguniq 2128, logpos 0x2caf018


查了相关的资料：
CAUSE

maxreqs - AIX kernel tuning parameter. It specifies the maximum number of asynchronous I/O requests that can be outstanding at any one time. The default value is 4096. Either this parameter is set low and/or the IBM Informix® Dynamic Server Maximum number of Requests(IFMX_AIXKAIO_NUM_REQ) is set too low for the current I/O load on the system.


SOLUTION
Set the environment variable IFMX_AIXKAIO_NUM_REQ to a higher value. The minimum value is 512 and the maximum value is the Maximum number of requests set for Kernel AIO. The default value if not set is 1024.
If Informix AIO is used, increase the number of AIO VP's in the ONCONFIG configuration file so I/O will be faster and the queue for AIO control blocks will not overflow.

If the above solutions do not work, refer to the related URL section to find how to tune OS kernel parameters.


看样子是要调整informix或aix系统的内核参数。
但如上面所说，在使用KAIO时调整这个参数IFMX_AIXKAIO_NUM_REQ，但找不到这个参数，且这个参数调整有危险性，可能会导致informix崩溃
在使用AIO时调整AIO　VPS 。一盘系统优先使用KAIO的，KAIO的参数最好使用系统默认的值。

剩下的只能调整AIX系统内核参数的，即maxreqs　这一参数，这个参数修改后是在重启系统的。
还是这个数据加工的应用程序写得有问题？需要修改。（那程序写得实在是。。。。。好像基本不考虑执行效率的，yun）

不知道我的理解对不对。。。有没有哪位碰到过类似的问题？
IFMXDBA

论坛徽章:
0
2楼 [报告]
发表于 2006-01-25 20:56 |只看该作者

回复 1楼 Jens 的帖子

the default value of kernal paramaters on KAIO at AIX was too small.  The current setting in my aix box :-
  IFMX_AIXKAIO_NUM_REQ=4096

H80, AIX 5.2
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
Jens

论坛徽章:
0
3楼 [报告]
发表于 2006-01-26 08:51 |只看该作者
IFMX_AIXKAIO_NUM_REQ=4096 这个参数怎么样设置啊。在那个文件中有这个参数？
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
Jens

论坛徽章:
0
4楼 [报告]
发表于 2006-01-26 08:52 |只看该作者
你的informix版本是多少？我的是7.31UD5
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
IFMXDBA

论坛徽章:
0
5楼 [报告]
发表于 2006-01-26 09:20 |只看该作者

回复 3楼 Jens 的帖子

env var, you can set it your profile :-
  export IFMX_AIXKAIO_NUM_REQ=4096

IDS 9.4
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
Jens

论坛徽章:
0
6楼 [报告]
发表于 2006-01-26 14:34 |只看该作者
明白，谢谢。
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
IFMXDBA

论坛徽章:
0
7楼 [报告]
发表于 2006-01-26 22:23 |只看该作者

回复 6楼 Jens 的帖子

following is captured from smitty:-

                                               Change / Show Characteristics of Asynchronous I/O

Type or select values in entry fields.
Press Enter AFTER making all desired changes.

                                                        [Entry Fields]
  MINIMUM number of servers                          [150]                                                                                    #
  MAXIMUM number of servers per cpu                  [300]                                                                                    #
  Maximum number of REQUESTS                         [12288]                                                                                  #
  Server PRIORITY                                    [39]                                                                                     #
  STATE to be configured at system restart            available                                                                              +
  State of fast path                                  enable
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
Jens

论坛徽章:
0
8楼 [报告]
发表于 2006-02-09 10:03 |只看该作者
这是修改aix系统的核心参数。是需要重新启动系统才能生效的。对吧？
谢谢INFMXDBA
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

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

清除 Cookies - ChinaUnix - Archiver - WAP - TOP