ITPUB论坛 » Sybase管理与开发 » SYBASE设备问题求助


2008-6-19 16:34 fat_fish
SYBASE设备问题求助

环境:LINUX AS 4
数据库版本:12.5
建立的数据库文件系统.
我开始建立了个设备,觉得太小了,然后把它删除了,设备原来是6号,我又新建立个设备,还是使用6的这个.但是设备加到数据库上的时候,出现错误.
下面是数据库的日志记录:
00:00000:00000:2008/06/19 15:44:20.98 kernel  rt__dpoll aio_error returned 22
00:00000:00000:2008/06/19 15:44:20.98 kernel  rt__dpoll set dberrcode 22, aio_return expected 65536, got 0
00:00000:00000:2008/06/19 15:44:20.98 kernel  sddone: write error on virtual disk 6 block 1048576:
00:00000:00000:2008/06/19 15:44:21.00 kernel  sddone: Invalid argument
00:00000:00318:2008/06/19 15:44:21.02 server  Error: 3225, Severity: 21, State: 1
00:00000:00318:2008/06/19 15:44:21.04 server  当试图清除6号磁盘的开始页0页的时候输入/输出失败。
00:00000:00318:2008/06/19 15:44:21.04 server  Error: 3225, Severity: 21, State: 1
00:00000:00318:2008/06/19 15:44:21.04 server  I/O failed while attempting to clear pages starting at page 0 of disk number 6.
00:00000:00318:2008/06/19 15:44:21.04 kernel  ************************************
00:00000:00318:2008/06/19 15:44:21.04 kernel  SQL causing error : alter database point on point_data_03 = 10000
00:00000:00318:2008/06/19 15:44:21.04 kernel  ************************************
00:00000:00318:2008/06/19 15:44:21.05 server  SQL Text: alter database point on point_data_03 = 10000
00:00000:00318:2008/06/19 15:44:21.05 kernel  curdb = 4 pstat = 0x10000 lasterror = 3225
00:00000:00318:2008/06/19 15:44:21.05 kernel  preverror = 0 transtate = 0
00:00000:00318:2008/06/19 15:44:21.05 kernel  curcmd = 305 program = SC_ASEJ_Mgmt                  
00:00000:00318:2008/06/19 15:44:21.06 kernel  pc 0x862e2a9 ucbacktrace+0x89(0x0,0x1,0x8d4694c,0x15,0x8)
00:00000:00318:2008/06/19 15:44:21.06 kernel  pc 0x810b647 terminate_process+0xb13(0x0,0xffffffff,0x8d4694c,0x9d76fa88,0x8154129)
00:00000:00318:2008/06/19 15:44:21.06 kernel  pc 0x8153f3d close_network+0x19(0x8d4694c,0x9a4e3e00,0x9d76fb2c,0x83ca941,0x20)
00:00000:00318:2008/06/19 15:44:21.06 kernel  pc 0x8154129 hdl_default+0x49(0x20,0x19,0x15,0x1,0x9d76fb78)
00:00000:00318:2008/06/19 15:44:21.07 kernel  pc 0x83ca941 s_handle+0x1001(0x20,0x19,0x15,0x1,0x9d76fb78)
00:00000:00318:2008/06/19 15:44:21.07 kernel  pc 0x8153b90 ex_raise+0x2f8(0x20,0x19,0x15,0x1,0x0)
00:00000:00318:2008/06/19 15:44:21.07 kernel  pc 0x84fcf7b lddb_clear_dbpages+0x44f(0x4,0x9d76fd40,0xfa000,0x8d4694c,0x0)
00:00000:00318:2008/06/19 15:44:21.07 kernel  pc 0x82d0fa5 altdb_ext_al+0x65(0x9d76fd40,0x4,0x0,0x6,0x8d4694c)
00:00000:00318:2008/06/19 15:44:21.07 kernel  pc 0x82d0cf2 altdb_extend+0xa7a(0x0,0x4,0xa43eb654,0x5,0x9d76fec4)
00:00000:00318:2008/06/19 15:44:21.07 kernel  pc 0x81860e3 ex_cleanup(0xa43eb5ac,0x8d4694c,0x0,0x2,0x0)
00:00000:00318:2008/06/19 15:44:21.07 kernel  pc 0x81860e3 ex_cleanup(0x8d4694c,0x0,0xa1574900,0x61626174,0x70206573)
00:00000:00318:2008/06/19 15:44:21.07 kernel  pc 0x83c76fd sequencer+0xe51(0xa4473000,0x8d4694c,0x0,0xa1574900,0x811aaba)
00:00000:00318:2008/06/19 15:44:21.07 kernel  pc 0x81860e3 ex_cleanup(0x0,0x0,0x0,0x0,0x0)
00:00000:00318:2008/06/19 15:44:21.07 kernel  pc 0x813d829 conn_hdlr+0x2531(0x138,0x9d770c48,0x895eed31,0x0,0x0)
00:00000:00318:2008/06/19 15:44:21.07 kernel  pc 0x82d00f4 alterdb+0x7c0(0x0,0x0,0x0,0x9ae6d900,0x290)
00:00000:00318:2008/06/19 15:44:21.08 kernel  pc 0x895eed31 init_dummy+0x80d26a1d(0x0,0x9ae6d900,0x290,0x1,0x5374616b)
00:00000:00318:2008/06/19 15:44:21.08 kernel  end of stack trace, spid 318, kpid 87818895, suid 1

2008-6-19 16:45 fat_fish
设备开始并没有给数据库使用.

2008-6-19 16:50 fat_fish
补充现象

就会错误提示:
  第一个提示框:JZ006:捕获到IO例外:java.io.IOException:JZ0c0:连接已关闭
  第二个提示框:由于服务器关闭
                或者网络出现问题
                先前与服务器的连接已关闭。
                请在服务器启动后尝试连接

接着连接就Over了。。。。

2008-6-20 11:16 fat_fish
怎么没人理会啊?

2008-6-20 15:12 fat_fish
问题解决

sybase 管理的 设备文件大小一般不超过 2G
只要把设备的大小设置为<=2G,那么就没有问题.

我开始的设备设置得太大了,是10G的,呵呵

页: [1]
查看完整版本: SYBASE设备问题求助


Powered by ITPUB论坛