sybase dump 超过1G就出错，怎么回事？

fdhunter

aix5.3  sybase12.5

数据备份时dump 超过1G就停下来了，是不是sybase有什么限制啊
系统limits的限制我已经取消啦

# ulimit -a
time(seconds)        unlimited
file(blocks)         unlimited
data(kbytes)         unlimited
stack(kbytes)        4194304
memory(kbytes)       unlimited
coredump(blocks)     unlimited
nofiles(descriptors) unlimited
#

那位高手指点一下。

flybean

详细的出错日志呢？

fdhunter

一  14:42:23
Backup Server session id is:  38.  Use this value when executing the
'sp_volchanged' system stored procedure after fulfilling any volume change
request from the Backup Server.
Backup Server: 4.41.1.1: Creating new disk file
/sybase_bak/izumi20080319_01.dmp.
Backup Server: 6.28.1.1: Dumpfile name 'izumi080790CE29  ' section number 1
mounted on disk file '/sybase_bak/izumi20080319_01.dmp'
Backup Server: 4.58.1.1: Database izumi: 1042030 kilobytes DUMPed.
Backup Server: 4.145.2.22: [3] Error for device
'/sybase_bak/izumi20080319_01.dmp'. Error writing to archive device
/sybase_bak/izumi20080319_01.dmp. Attempted to write 65536 bytes, 5632 bytes
were written.
Msg 8009, Level 16, State 1:
Server 'izumi', Line 1:
Error encountered by Backup Server.  Please refer to Backup Server messages for
details.




Aix 5.3,  JFS2的文件系统，
怎么单个文件只能最大到1073741312大小，一开始以为是
/etc/security/limits中的fsize的限制，但改fszie参数
为－1并重启后，还是不能突破该限制！

fdhunter

Mar 19 14:39:37 2008: Backup Server: 4.41.1.1: Creating new disk file /sybase_ba
k/izumi20080319_01.dmp.
Mar 19 14:39:37 2008: Backup Server: 6.28.1.1: Dumpfile name 'izumi080790CE29  '
section number 1 mounted on disk file '/sybase_bak/izumi20080319_01.dmp'
Mar 19 14:41:02 2008: A00: SYBMULTBUF ERROR: Error writing to archive device /sy
base_bak/izumi20080319_01.dmp. Attempted to write 65536 bytes, 5632 bytes were w
ritten.
Mar 19 14:41:03 2008: Backup Server: 4.145.2.22: [3] Error for device '/sybase_b
ak/izumi20080319_01.dmp'. Error writing to archive device /sybase_bak/izumi20080
319_01.dmp. Attempted to write 65536 bytes, 5632 bytes were written.
Mar 19 14:41:03 2008: Backup Server: 4.58.1.1: Database izumi: 1042030 kilobytes
DUMPed.
Mar 19 14:41:05 2008: Backup Server: 4.15.2.2: Label validation error: seek to t
railer labels failed.

chuxu

# ulimit -a
sybase 用户的呢？

hobbylu

修改操作系统限制

fdhunter

ok了，root用户、sybase用户都是ulimit -a
time(seconds)        unlimited
file(blocks)         unlimited
data(kbytes)         unlimited
stack(kbytes)        4194304
memory(kbytes)       unlimited
coredump(blocks)     unlimited
nofiles(descriptors) unlimited

把/etc/security/limits 下sybase用户的设置删掉，重启就可以啦，不懂什么原因！谢谢各位啦。