标题: sybase很脆弱吗？每次这样操作就死掉 [打印本页] 作者: ldxm 时间: 2003-10-27 15:01 标题: sybase很脆弱吗？每次这样操作就死掉 整个运行过程如下，每当数据库提示Identity field 'sa_id' must be a numeric with a scale of 0 and not null allowe后sybase就不正常了，以后执行任何操作都block这里.
这是什么原因，有人知道吗。我是个sybase 新手。我快没信息玩sybase了。
环境为sybase ase 12.5 + linux
1>;
2>; IF EXISTS (SELECT * FROM sysobjects WHERE name = 't_sales')
3>; DROP TABLE t_sales
4>; GO
1>;
2>; CREATE TABLE t_sales (
3>; sa_id int identity,
4>; sa_name Varchar(120) ,
5>; discount Numeric(5,0) default 1,
6>; CONSTRAINT pk_t_sales PRIMARY KEY (sa_name)
7>; )
8>; GO
Msg 2764, Level 16, State 2:
Server 'accunetsvr', Line 2:
Identity field 'sa_id' must be a numeric with a scale of 0 and not null
allowed.
1>; IF EXISTS (SELECT * FROM sysobjects WHERE name = 't_sales')
2>; DROP TABLE t_sales
3>; GO
1>;
2>; CREATE TABLE t_sales (
3>; sa_id numeric(20,0) identity,
4>; sa_name Varchar(120) ,
5>; discount Numeric(5,0) default 1,
6>; CONSTRAINT pk_t_sales PRIMARY KEY (sa_name)
7>; )
8>; GO
1>;
2>;
3>; select * from t_sales
4>; go作者: ldxm 时间: 2003-10-27 15:56 标题: sybase很脆弱吗？每次这样操作就死掉 select * from t_sales
后sybase就挂在那儿了，动弹不了
00:00000:00015:2003/10/27 15:36:00.46 kernel ************************************
00:00000:00015:2003/10/27 15:36:00.46 server SQL Text:
select * from t_sales
00:00000:00015:2003/10/27 15:36:00.46 kernel curdb = 4 pstat = 0x14000 lasterror = 208
00:00000:00015:2003/10/27 15:36:00.46 kernel preverror = 0 transtate = 3
00:00000:00015:2003/10/27 15:36:00.46 kernel curcmd = 0 program = isql
00:00000:00015:2003/10/27 15:36:00.53 kernel pc 0x862e2a9 ucbacktrace+0x89(0x0,0x1,0x8d4694c,0x40554294,0x40b6e2cc)
00:00000:00015:2003/10/27 15:36:00.53 kernel pc 0x810b647 terminate_process+0xb13(0x0,0xffffffff,0x4007a5f8,0x0,0x400785a
00:00000:00015:2003/10/27 15:36:00.53 kernel pc 0x867b161 kaclkintr+0x451(0xe,0x40554348,0x405543c8,0x4006f91a,0x405546d
00:00000:00015:2003/10/27 15:36:00.56 kernel pc 0x4006f963 init_dummy+0x377a764f(0xe,0x40554348,0x405543c8,0xe,0x0)
00:00000:00015:2003/10/27 15:36:00.56 kernel pc 0x400a9840 init_dummy+0x377e152c(0x405546d8,0x20,0x405546d8,0x0,0x0)
00:00000:00015:2003/10/27 15:36:00.56 kernel pc 0x4006f079 init_dummy+0x377a6d65(0x40077d60,0x40554788,0x94,0x4006f0c1,0x40077d60)
00:00000:00015:2003/10/27 15:36:00.56 kernel pc 0x4006f13f init_dummy+0x377a6e2b(0x4055489c,0x405548a8,0x42526a40,0x8dd1ca0,0x405548a
00:00000:00015:2003/10/27 15:36:00.56 kernel pc 0x4252693d init_dummy+0x39c5e629(0x0,0x8d4694c,0x40554a1c,0x8635ee9,0x410593f
00:00000:00015:2003/10/27 15:36:00.56 kernel pc 0x42527320 init_dummy+0x39c5f00c(0x410593f8,0x8d4694c,0x410593f4,0x8b81c1c,0x410593f
00:00000:00015:2003/10/27 15:36:00.56 kernel pc 0x8635ee9 rt__daiostart+0xd1(0x6,0x410593f4,0x8d4694c,0x1,0x40554a74)
00:00000:00015:2003/10/27 15:36:00.56 kernel pc 0x86365ed basis_daiostart+0x21(0x6,0x410593f4,0x8d4694c,0x410593f4,0x6)
00:00000:00015:2003/10/27 15:36:00.56 kernel pc 0x863684d basis_dstart+0x1d5(0x6,0x410593f4,0x800,0x8d4694c,0x410593f4)
00:00000:00015:2003/10/27 15:36:00.56 kernel pc 0x8637fdc dstart+0x21c(0x4104d140,0x410593f4,0x8d4694c,0x0,0x410593f4)
00:00000:00015:2003/10/27 15:36:00.56 kernel pc 0x8637c4f dstartio+0x11b(0x4104d140,0x410593f4,0x1,0x8d4694c,0x410593f4)
00:00000:00015:2003/10/27 15:36:00.56 kernel pc 0x8632cb3 udstartio+0x3bb(0x410593f4,0xffffffff,0x8d4694c,0x40b6e854,0x0)
00:00000:00015:2003/10/27 15:36:00.58 kernel pc 0x818e040 bufread+0x4fc(0x4217d1e4,0x40b6e854,0x8d4694c,0x40b6e854,0x4055519c)
00:00000:00015:2003/10/27 15:36:00.58 kernel pc 0x8296fe5 getpage_with_validation+0x551(0x40b6e854,0x4,0x0,0x0,0x0)
00:00000:00015:2003/10/27 15:36:00.58 kernel pc 0x82b852b apl__startscan+0x403(0x40b6e854,0x1,0x40e68d44,0x1,0x8d4694c)
00:00000:00015:2003/10/27 15:36:00.58 kernel pc 0x82b8109 startscan+0x419(0x40b6e854,0x1,0x1,0x8d4694c,0xd0)
00:00000:00015:2003/10/27 15:36:00.58 kernel pc 0x8152b49 findtext+0x1ed(0xd0,0x405554ac,0x405562d8,0x405558b0,0x405562dc)
00:00000:00015:2003/10/27 15:36:00.58 kernel pc 0x814f241 ex_doprint+0x441(0xd0,0x10,0x1,0x405563f4,0x8d4694c)
00:00000:00015:2003/10/27 15:36:00.58 kernel pc 0x814edf5 ex_print+0x99(0xd0,0x10,0x1,0x405563f4,0x8d4694c)
00:00000:00015:2003/10/27 15:36:00.60 kernel pc 0x83ca73c s_handle+0xdfc(0x2,0x8,0x10,0x1,0x405563f4)
00:00000:00015:2003/10/27 15:36:00.60 kernel pc 0x8153b90 ex_raise+0x2f8(0x2,0x8,0x10,0x1,0x7)
00:00000:00015:2003/10/27 15:36:00.60 kernel pc 0x839f4ec open_range+0x4bc(0x0,0x412deda4,0x0,0x1,0x8d4694c)
00:00000:00015:2003/10/27 15:36:00.60 kernel pc 0x83939b7 col_open_range+0x3b(0x412ded20,0x405564fc,0x40556500,0x8d4694c,0x412ded20)
00:00000:00015:2003/10/27 15:36:00.60 kernel pc 0x8393757 colnames_driver+0x37(0x412deef4,0x412ded20,0x1,0x8d4694c,0xc1)
00:00000:00015:2003/10/27 15:36:00.60 kernel pc 0x83c89b8 s_normquery+0x60(0x412deef4,0x0,0x8d4694c,0x0,0x40b6e200)
00:00000:00015:2003/10/27 15:36:00.60 kernel pc 0x83c8013 s_normalize+0x62b(0x0,0x8d4694c,0x0,0x40b6e200,0x6f726620)
00:00000:00015:2003/10/27 15:36:00.60 kernel pc 0x83c6b33 sequencer+0x287(0x412de800,0x8d4694c,0x0,0x40b6e200,0x811aaba)
00:00000:00015:2003/10/27 15:36:00.60 kernel pc 0x812ed62 tdsrecv_language+0x2de(0x0,0x0,0x0,0x0,0x0)
00:00000:00015:2003/10/27 15:36:00.60 kernel pc 0x813d829 conn_hdlr+0x2531(0x8,0x40556aac,0x895eed31,0x0,0x0)
00:00000:00015:2003/10/27 15:36:00.60 kernel pc 0x81860e3 ex_cleanup(0x0,0x0,0x0,0x40406900,0x15)
00:00000:00015:2003/10/27 15:36:00.60 kernel pc 0x895eed31 init_dummy+0x80d26a1d(0x0,0x40406900,0x15,0x1,0x5374616b)
00:00000:00015:2003/10/27 15:36:00.60 kernel end of stack trace, spid 15, kpid 1310740, suid 3
Message empty.作者: chenfeng825 时间: 2003-10-27 16:07 标题: sybase很脆弱吗？每次这样操作就死掉 timeslice 501错误，给sybase加上ebf一般都能够解决，应该是bug作者: ldxm 时间: 2003-10-27 16:19 标题: sybase很脆弱吗？每次这样操作就死掉 ebf 是什么呀。
能否详细点。补丁？作者: chenfeng825 时间: 2003-10-27 16:35 标题: sybase很脆弱吗？每次这样操作就死掉 是补丁。上sybase.com去下载，具体操作看精华有偏文章着重讨论了这个！作者: ldxm 时间: 2003-10-27 17:13 标题: sybase很脆弱吗？每次这样操作就死掉 谢谢了。我先下了试试看。
sybase的bug比 oracle多了不少呀。作者: zhangwei401 时间: 2003-11-04 20:14 标题: sybase很脆弱吗？每次这样操作就死掉 我也是个新手 麻烦这位前辈能不能告诉我如何安装SYBASE12。5在LINUX上我都装了好长时间了也没装上 `` 谢谢你了[/img]作者: zhangyh123 时间: 2003-11-04 21:49 标题: sybase很脆弱吗？每次这样操作就死掉 整个运行过程如下，每当数据库提示Identity field 'sa_id' must be a numeric with a scale of 0 and not null allowe后sybase就不正常了，以后执行任何操作都block这里.
这是什么原因，有人知道吗。我是个sybase 新手。我快没信息玩sybase了。
环境为sybase ase 12.5 + linux
1>;
2>; IF EXISTS (SELECT * FROM sysobjects WHERE name = 't_sales')
3>; DROP TABLE t_sales
4>; GO
1>;
2>; CREATE TABLE t_sales (
3>; sa_id int identity, ---- 此处应该为 sa_id numeric(10,0 ) identity4>; sa_name Varchar(120) ,
5>; discount Numeric(5,0) default 1,
6>; CONSTRAINT pk_t_sales PRIMARY KEY (sa_name)
7>; )
8>; GO
Msg 2764, Level 16, State 2:
Server 'accunetsvr', Line 2:
Identity field 'sa_id' must be a numeric with a scale of 0 and not null
allowed.
1>; IF EXISTS (SELECT * FROM sysobjects WHERE name = 't_sales')
2>; DROP TABLE t_sales
3>; GO
1>;
2>; CREATE TABLE t_sales (
3>; sa_id numeric(20,0) identity,
4>; sa_name Varchar(120) ,
5>; discount Numeric(5,0) default 1,
6>; CONSTRAINT pk_t_sales PRIMARY KEY (sa_name)
7>; )
8>; GO
1>;
2>;
3>; select * from t_sales
4>; go作者: solofeng 时间: 2003-11-05 10:11 标题: sybase很脆弱吗？每次这样操作就死掉 呵呵谢谢各位
