请问这个Sybase错误提示何解?

flippy

　　ASE 12.5.1 on HPUX IA64　　
    近日，日志中出现如下信息：
01:00000:00371:2005/04/04 17:00:00.55 kernel  read on virtual disk 5 block 39968 was INTERRUPTED (EINTR) ... (retrying) ...
01:00000:00371:2005/04/04 17:00:00.57 kernel  read on virtual disk 5 block 39968 SUCCEEDED after 1 retries (EINTRs)
00:00000:00190:2005/04/04 17:00:00.73 kernel  read on virtual disk 7 block 897816 was INTERRUPTED (EINTR) ... (retrying) ...
00:00000:00190:2005/04/04 17:00:00.74 kernel  read on virtual disk 7 block 897816 SUCCEEDED after 1 retries (EINTRs)
01:00000:00371:2005/04/04 17:00:00.95 kernel  read on virtual disk 5 block 58592 was INTERRUPTED (EINTR) ... (retrying) ...
01:00000:00371:2005/04/04 17:00:00.96 kernel  read on virtual disk 5 block 58592 SUCCEEDED after 1 retries (EINTRs)
00:00000:00190:2005/04/04 17:00:01.23 kernel  read on virtual disk 7 block 902568 was INTERRUPTED (EINTR) ... (retrying) ...
00:00000:00190:2005/04/04 17:00:01.24 kernel  read on virtual disk 7 block 902568 SUCCEEDED after 1 retries (EINTRs)
00:00000:00190:2005/04/04 17:00:01.53 kernel  read on virtual disk 7 block 905144 was INTERRUPTED (EINTR) ... (retrying) ...
00:00000:00190:2005/04/04 17:00:01.54 kernel  read on virtual disk 7 block 905144 SUCCEEDED after 1 retries (EINTRs)
00:00000:00190:2005/04/04 17:00:02.83 kernel  read on virtual disk 7 block 921560 was INTERRUPTED (EINTR) ... (retrying) ...
00:00000:00190:2005/04/04 17:00:02.84 kernel  read on virtual disk 7 block 921560 SUCCEEDED after 1 retries (EINTRs)
00:00000:00190:2005/04/04 17:00:03.24 kernel  read on virtual disk 7 block 936656 was INTERRUPTED (EINTR) ... (retrying) ...
00:00000:00190:2005/04/04 17:00:03.24 kernel  read on virtual disk 7 block 936656 SUCCEEDED after 1 retries (EINTRs)
00:00000:00190:2005/04/04 17:00:03.94 kernel  read on virtual disk 7 block 944688 was INTERRUPTED (EINTR) ... (retrying) ...
00:00000:00190:2005/04/04 17:00:03.94 kernel  read on virtual disk 7 block 944688 SUCCEEDED after 1 retries (EINTRs)
03:00000:00371:2005/04/04 17:00:04.27 kernel  read on virtual disk 5 block 405800 was INTERRUPTED (EINTR) ... (retrying) ...
03:00000:00371:2005/04/04 17:00:04.28 kernel  read on virtual disk 5 block 405800 SUCCEEDED after 1 retries (EINTRs)
03:00000:00371:2005/04/04 17:00:04.57 kernel  read on virtual disk 5 block 562304 was INTERRUPTED (EINTR) ... (retrying) ...
03:00000:00371:2005/04/04 17:00:04.58 kernel  read on virtual disk 5 block 562304 SUCCEEDED after 1 retries (EINTRs)
03:00000:00371:2005/04/04 17:00:04.67 kernel  read on virtual disk 5 block 588864 was INTERRUPTED (EINTR) ... (retrying) ...
03:00000:00371:2005/04/04 17:00:04.68 kernel  read on virtual disk 5 block 588864 SUCCEEDED after 1 retries (EINTRs)
00:00000:00371:2005/04/04 17:00:09.94 kernel  read on virtual disk 5 block 649280 was INTERRUPTED (EINTR) ... (retrying) ...
00:00000:00371:2005/04/04 17:00:09.95 kernel  read on virtual disk 5 block 649280 SUCCEEDED after 1 retries (EINTRs)

请问高手何解？

1017of

检查一下操作系统有什么提示

sqyccs

是unix的机器。

常笑

[quote]原帖由 "sqyccs"]是unix的机器。[/quote 发表：

          



操作系统级，有报错吗？

flippy

　　没有，因为我对Sybase还算比较熟，对HPUX却不太熟，不知道去哪里看操作系统的错误日志。

pandu

errpt -a>;errpt.out  
然后使用ftp copy 下来，贴出来看看

flippy

原帖由 "pandu" 发表：
errpt -a>;errpt.out  
然后使用ftp copy 下来，贴出来看看

# errpt -a >; errpt.out
sh: errpt:  not found.

补充一下：
服务器是二台HP rx5670做cluster(每台有安腾1.3Gx4,内存每台8G),操作系统是HPUX 11iv2
# ioscan -fCdisk
Class     I  H/W Path       Driver   S/W State   H/W Type     Description
==========================================================================
disk      0  0/0/2/0.0.0    sdisk    CLAIMED     DEVICE       HP 36.4GST336753LC
disk      1  0/0/2/1.3.0    sdisk    CLAIMED     DEVICE       HP      DVD-ROM 305
disk      8  0/1/1/0/1/1.0.0        sdisk    CLAIMED     DEVICE       HP 73.4GST373453LC
disk      2  0/4/1/0.8.0.107.0.0.0  sdisk    CLAIMED     DEVICE       HP      A6218A
disk      4  0/4/1/0.8.0.107.0.0.1  sdisk    CLAIMED     DEVICE       HP      A6218A
disk      5  0/4/1/0.8.0.107.0.0.2  sdisk    CLAIMED     DEVICE       HP      A6218A
disk      3  0/5/1/0.8.0.109.0.0.0  sdisk    CLAIMED     DEVICE       HP      A6218A
disk      6  0/5/1/0.8.0.109.0.0.1  sdisk    CLAIMED     DEVICE       HP      A6218A
disk      7  0/5/1/0.8.0.109.0.0.2  sdisk    CLAIMED     DEVICE       HP      A6218A

Sybase的数据设备均建在A6218A上，Async IO未开启（一直无法开启）
日志中的错误信息均出现在每天高峰时段，夜间虽然也运行大量后台统计，但不会出现该错误。virtual disk 5 是日志段之一(4G,共有12G）,virtual disk 7 是数据段之一(4G,共有28G),该错误提示只出现在这两个设备上。

flippy

[quote]原帖由 "livefordie"]呵呵，人家都说是HPUX了还用errpt，这位仁兄真逗。AIO没有，你的CPU性能和I/O性能会大打折扣的，这个问题你自己已经找出原因了，还用大家来解答？在内核里把AIO加上吧，没别的办法的。[/quote 发表：


不是这样的,内核的AIO已加上,同一台机器上,另一个小的Server可以打开AsyncIO(只用一个CPU和少量内存,数据库容量比较小,只是偶尔使用),但大的这个不行，每次用sp_configure 'allow sql server async i/o',1　打开AIO，Server重启后该选项又自动变回0，不知道是何原因。还有，我列举的只是错误现象，不是错误原因，还望各位大侠多多赐教。

flippy

　　已解决。
　　原来的确是Async　I/O未开启导致的此问题，而Async I/O未开启的原因居然是"max memory"设置过大！原设为3276800(6.4G),降为3072000(6G)后Async I/O成功开启，该操作系统消息未再出现。