sql死锁问题
最的SQL2000 SP4 数据库不知道为什么老会出现死锁问题,以及活动进程 错误提示 1222.
在网上用了 p-lockinfo 查询的结果如下;
1 |_牺牲品_> 51 sleeping DECLARE @P022 varchar(16) SELECT @P022 = '' execute PROC_EXEC_curorder_ADDDETAIL @CURORDER_ID = 'D201010120198', @tablename = '1631', @waiter = '姜霞', @dish_id = '01001', @ps_flag = 'N', @quantity = 1, @discount_rate = 1.0, @price = 98, @kill_id = '', @dis
2 |_牺牲品_> 57 DECLARE @P022 varchar(16) SELECT @P022 = '' execute PROC_EXEC_curorder_ADDDETAIL @CURORDER_ID = 'D201010120185', @tablename = '1606', @waiter = '高剑', @dish_id = '08139', @ps_flag = 'N', @quantity = 1, @discount_rate = 1, @price = 10, @kill_id = '', @dish_
3 |_牺牲品_> 60 DECLARE @P022 varchar(16) SELECT @P022 = '' execute PROC_EXEC_curorder_ADDDETAIL @CURORDER_ID = 'D201010120199', @tablename = '1103', @waiter = '姜霞', @dish_id = '01001', @ps_flag = 'N', @quantity = 1, @discount_rate = 1.0, @price = 98, @kill_id = '', @dis
4 死锁的进程 55 DECLARE @P001 int, @P002 int, @P003 int, @P004 int, @P005 int, @P006 int SELECT @P001 = 0, @P002 = 0, @P003 = 0, @P004 = 0, @P005 = 0, @P006 = 0 execute PROC_EXEC_kftj @zfjs = @P001 output , @usefjs = @P002 output , @freefjs = @P003 output , @zffjs = @P00
5 |_牺牲品_> 54 update tables set room_id ='' , bed_no ='' , room_flag ='' , begin_time =null , time_long =0 , warn_flag =0 , end_time =null , if_adv ='n' where tablename ='1863'
6 |_牺牲品_> 61 DECLARE @P002 int SELECT @P002 = 0 execute PROC_sauna_zzcdj @sp_id = '89-5000078306ac-16', @my_xh = @P002 output SELECT @P002
7 |_牺牲品_> 53 DECLARE @P022 varchar(16) SELECT @P022 = '' execute PROC_EXEC_curorder_ADDDETAIL @CURORDER_ID = 'D201010120132', @tablename = '2220', @waiter = '蔡婷', @dish_id = '02001', @ps_flag = 'N', @quantity = 1, @discount_rate = 1, @price = 98, @kill_id = '', @dish_
更奇怪的问题,我已经录入到计算机的数据信息,当我重启动slq数据库时会丢失.
希望朋友们能支持.分析分析 在下感谢了.