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