sybase很脆弱吗？每次这样操作就死掉

ldxm

整个运行过程如下，每当数据库提示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

select * from t_sales
后sybase就挂在那儿了，动弹不了

起初我怀疑是否是tempdb不够大，加到30M还是如此，这是一个
很简单的表呀。怎么sybase反而不及 postgreSQL好操作。
更比不上oracle 的稳定。faint//
还是我设错了什么？


急

ldxm

挂住长时间后，有时会弹出下面的信息。
是什么呀？一点都看不明白。
望大虾们赐教。
00:00000:00015:2003/10/27 15:36:00.46 kernel  timeslice -501, current process infected
00:00000:00015:2003/10/27 15:36:00.46 kernel  ************************************
00:00000:00015:2003/10/27 15:36:00.46 kernel  SQL causing error :
select * from t_sales

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

timeslice 501错误，给sybase加上ebf一般都能够解决，应该是bug

ldxm

ebf 是什么呀。
能否详细点。补丁？

chenfeng825

是补丁。上sybase.com去下载，具体操作看精华有偏文章着重讨论了这个！

ldxm

谢谢了。我先下了试试看。
sybase的bug比 oracle多了不少呀。

zhangwei401

我也是个新手 麻烦这位前辈能不能告诉我如何安装SYBASE12。5在LINUX上我都装了好长时间了也没装上  `` 谢谢你了[/img]

zhangyh123

整个运行过程如下，每当数据库提示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

呵呵谢谢各位