************************************************************************************** [意料之内的错误] ----- 2022-06-06 09:54:46 [错误信息] => 登录已失效 [详细] => 在 Api.BaseService.GetMethod(MethodInfo method, Dictionary`2 pairs) 在 Api.BaseService.ProcessRequest(HttpContext context) [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.shopcart , [方法] => get_all [入参] => ************************************************************************************** ************************************************************************************** [意料之内的错误] ----- 2022-06-06 09:54:46 [错误信息] => 登录已失效 [详细] => 在 Api.BaseService.GetMethod(MethodInfo method, Dictionary`2 pairs) 在 Api.BaseService.ProcessRequest(HttpContext context) [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.shopcart , [方法] => get_all [入参] => ************************************************************************************** **************************mima_b2b_Login()2022/6/6 10:46:39************************* paramter0:1001 paramter1:oDppT5NyKn9tL2v3W3wQju_eE7RE Api.Helper.Exceptions.KatException: 密码错误 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-06-06 10:46:39 [错误信息] => 密码错误 [sql] => select a.oper_id, a.oper_name, a.oper_pwd, a.open_id, (case when isnull(c.cust_level, 1) = '' then '1' else isnull(c.cust_level, 1) end) as cus_level, c.is_branch, b.supcust_no, c.supcust_group from sa_t_mobile_oper as a inner join sa_t_mobile_data_main as b on a.oper_id = b.oper_id left join bi_t_supcust_info as c on b.supcust_no = c.supcust_no where a.oper_id = '1001' or a.login_no = '1001' [详细] => 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) 在 Api.SingOut.b2b.mina.oper.login(String card_id, String vip_pass, String is_bind, String open_id) [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.oper , [方法] => login [入参] => {"card_id":"1001","vip_pass":"","is_bind":"1","open_id":"oDppT5NyKn9tL2v3W3wQju_eE7RE"} ************************************************************************************** **************************mima_b2b_Login()2022/6/6 14:05:02************************* paramter0:1024 paramter1:oDppT5IqQjL5tc8SXv5U77joK1vc Api.Helper.Exceptions.KatException: 密码错误 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-06-06 14:05:02 [错误信息] => 密码错误 [sql] => select a.oper_id, a.oper_name, a.oper_pwd, a.open_id, (case when isnull(c.cust_level, 1) = '' then '1' else isnull(c.cust_level, 1) end) as cus_level, c.is_branch, b.supcust_no, c.supcust_group from sa_t_mobile_oper as a inner join sa_t_mobile_data_main as b on a.oper_id = b.oper_id left join bi_t_supcust_info as c on b.supcust_no = c.supcust_no where a.oper_id = '1024' or a.login_no = '1024' [详细] => 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) 在 Api.SingOut.b2b.mina.oper.login(String card_id, String vip_pass, String is_bind, String open_id) [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.oper , [方法] => login [入参] => {"card_id":"1024","vip_pass":"123466","is_bind":"1","open_id":"oDppT5IqQjL5tc8SXv5U77joK1vc"} ************************************************************************************** **************************mima_b2b_Login()2022/6/6 14:33:19************************* paramter0:1113 paramter1:oDppT5OfLYaGntvpEwkC5oUx7cjk Api.Helper.Exceptions.KatException: 密码错误 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-06-06 14:33:19 [错误信息] => 密码错误 [sql] => select a.oper_id, a.oper_name, a.oper_pwd, a.open_id, (case when isnull(c.cust_level, 1) = '' then '1' else isnull(c.cust_level, 1) end) as cus_level, c.is_branch, b.supcust_no, c.supcust_group from sa_t_mobile_oper as a inner join sa_t_mobile_data_main as b on a.oper_id = b.oper_id left join bi_t_supcust_info as c on b.supcust_no = c.supcust_no where a.oper_id = '1113' or a.login_no = '1113' [详细] => 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) 在 Api.SingOut.b2b.mina.oper.login(String card_id, String vip_pass, String is_bind, String open_id) [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.oper , [方法] => login [入参] => {"card_id":"1113","vip_pass":"881113","is_bind":"1","open_id":"oDppT5OfLYaGntvpEwkC5oUx7cjk"} ************************************************************************************** **************************mima_b2b_Login()2022/6/6 14:33:37************************* paramter0: paramter1:oDppT5OfLYaGntvpEwkC5oUx7cjk Api.Helper.Exceptions.KatException: 用户不存在 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-06-06 14:33:37 [错误信息] => 用户不存在 [sql] => select a.oper_id, a.oper_name, a.oper_pwd, a.open_id, (case when isnull(c.cust_level, 1) = '' then '1' else isnull(c.cust_level, 1) end) as cus_level, c.is_branch, b.supcust_no, c.supcust_group from sa_t_mobile_oper as a inner join sa_t_mobile_data_main as b on a.oper_id = b.oper_id left join bi_t_supcust_info as c on b.supcust_no = c.supcust_no where a.oper_id = '' or a.login_no = '' [详细] => 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) 在 Api.SingOut.b2b.mina.oper.login(String card_id, String vip_pass, String is_bind, String open_id) [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.oper , [方法] => login [入参] => {"card_id":"","vip_pass":"","is_bind":"1","open_id":"oDppT5OfLYaGntvpEwkC5oUx7cjk"} ************************************************************************************** **************************mima_b2b_Login()2022/6/6 14:36:21************************* paramter0: paramter1:oDppT5Bscj3XiVDvBA3FkIuWAA4U Api.Helper.Exceptions.KatException: 用户不存在 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-06-06 14:36:21 [错误信息] => 用户不存在 [sql] => select a.oper_id, a.oper_name, a.oper_pwd, a.open_id, (case when isnull(c.cust_level, 1) = '' then '1' else isnull(c.cust_level, 1) end) as cus_level, c.is_branch, b.supcust_no, c.supcust_group from sa_t_mobile_oper as a inner join sa_t_mobile_data_main as b on a.oper_id = b.oper_id left join bi_t_supcust_info as c on b.supcust_no = c.supcust_no where a.oper_id = '' or a.login_no = '' [详细] => 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) 在 Api.SingOut.b2b.mina.oper.login(String card_id, String vip_pass, String is_bind, String open_id) [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.oper , [方法] => login [入参] => {"card_id":"","vip_pass":"123456","is_bind":"1","open_id":"oDppT5Bscj3XiVDvBA3FkIuWAA4U"} ************************************************************************************** **************************mima_b2b_Login()2022/6/6 14:36:27************************* paramter0: paramter1:oDppT5Bscj3XiVDvBA3FkIuWAA4U Api.Helper.Exceptions.KatException: 用户不存在 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-06-06 14:36:27 [错误信息] => 用户不存在 [sql] => select a.oper_id, a.oper_name, a.oper_pwd, a.open_id, (case when isnull(c.cust_level, 1) = '' then '1' else isnull(c.cust_level, 1) end) as cus_level, c.is_branch, b.supcust_no, c.supcust_group from sa_t_mobile_oper as a inner join sa_t_mobile_data_main as b on a.oper_id = b.oper_id left join bi_t_supcust_info as c on b.supcust_no = c.supcust_no where a.oper_id = '' or a.login_no = '' [详细] => 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) 在 Api.SingOut.b2b.mina.oper.login(String card_id, String vip_pass, String is_bind, String open_id) [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.oper , [方法] => login [入参] => {"card_id":"","vip_pass":"123456","is_bind":"1","open_id":"oDppT5Bscj3XiVDvBA3FkIuWAA4U"} ************************************************************************************** **************************mima_b2b_Login()2022/6/6 14:36:43************************* paramter0: paramter1:oDppT5Bscj3XiVDvBA3FkIuWAA4U Api.Helper.Exceptions.KatException: 用户不存在 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-06-06 14:36:43 [错误信息] => 用户不存在 [sql] => select a.oper_id, a.oper_name, a.oper_pwd, a.open_id, (case when isnull(c.cust_level, 1) = '' then '1' else isnull(c.cust_level, 1) end) as cus_level, c.is_branch, b.supcust_no, c.supcust_group from sa_t_mobile_oper as a inner join sa_t_mobile_data_main as b on a.oper_id = b.oper_id left join bi_t_supcust_info as c on b.supcust_no = c.supcust_no where a.oper_id = '' or a.login_no = '' [详细] => 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) 在 Api.SingOut.b2b.mina.oper.login(String card_id, String vip_pass, String is_bind, String open_id) [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.oper , [方法] => login [入参] => {"card_id":"","vip_pass":"123456","is_bind":"1","open_id":"oDppT5Bscj3XiVDvBA3FkIuWAA4U"} ************************************************************************************** **************************mima_b2b_Login()2022/6/6 14:36:51************************* paramter0: paramter1:oDppT5Bscj3XiVDvBA3FkIuWAA4U Api.Helper.Exceptions.KatException: 用户不存在 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-06-06 14:36:51 [错误信息] => 用户不存在 [sql] => select a.oper_id, a.oper_name, a.oper_pwd, a.open_id, (case when isnull(c.cust_level, 1) = '' then '1' else isnull(c.cust_level, 1) end) as cus_level, c.is_branch, b.supcust_no, c.supcust_group from sa_t_mobile_oper as a inner join sa_t_mobile_data_main as b on a.oper_id = b.oper_id left join bi_t_supcust_info as c on b.supcust_no = c.supcust_no where a.oper_id = '' or a.login_no = '' [详细] => 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) 在 Api.SingOut.b2b.mina.oper.login(String card_id, String vip_pass, String is_bind, String open_id) [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.oper , [方法] => login [入参] => {"card_id":"","vip_pass":"123456","is_bind":"1","open_id":"oDppT5Bscj3XiVDvBA3FkIuWAA4U"} ************************************************************************************** **************************mima_b2b_Login()2022/6/6 14:36:51************************* paramter0: paramter1:oDppT5Bscj3XiVDvBA3FkIuWAA4U Api.Helper.Exceptions.KatException: 用户不存在 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-06-06 14:36:51 [错误信息] => 用户不存在 [sql] => select a.oper_id, a.oper_name, a.oper_pwd, a.open_id, (case when isnull(c.cust_level, 1) = '' then '1' else isnull(c.cust_level, 1) end) as cus_level, c.is_branch, b.supcust_no, c.supcust_group from sa_t_mobile_oper as a inner join sa_t_mobile_data_main as b on a.oper_id = b.oper_id left join bi_t_supcust_info as c on b.supcust_no = c.supcust_no where a.oper_id = '' or a.login_no = '' [详细] => 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) 在 Api.SingOut.b2b.mina.oper.login(String card_id, String vip_pass, String is_bind, String open_id) [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.oper , [方法] => login [入参] => {"card_id":"","vip_pass":"123456","is_bind":"1","open_id":"oDppT5Bscj3XiVDvBA3FkIuWAA4U"} ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-06-06 14:38:26 [错误信息] => 事务(进程 ID 62)与另一个进程被死锁在 锁 资源上，并且已被选作死锁牺牲品。请重新运行该事务。 [sql] => update tr_shopcart set price='10.50000000',unit_no='斤',amount=10.50000000 * qty where goods_id='0000000000025' and open_id='1034';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000000027' and open_id='1034';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000000028' and open_id='1034';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000000660' and open_id='1034';update tr_shopcart set price='3.30000000',unit_no='斤',amount=3.30000000 * qty where goods_id='0000000000934' and open_id='1034';update tr_shopcart set price='4.80000000',unit_no='斤',amount=4.80000000 * qty where goods_id='0000000000964' and open_id='1034';update tr_shopcart set price='4.00000000',unit_no='盒',amount=4.00000000 * qty where goods_id='0000000000996' and open_id='1034';update tr_shopcart set price='5.30000000',unit_no='斤',amount=5.30000000 * qty where goods_id='0000000001048' and open_id='1034';update tr_shopcart set price='8.50000000',unit_no='斤',amount=8.50000000 * qty where goods_id='0000000001117' and open_id='1034';update tr_shopcart set price='4.80000000',unit_no='斤',amount=4.80000000 * qty where goods_id='0000000001246' and open_id='1034';update tr_shopcart set price='3.50000000',unit_no='盒',amount=3.50000000 * qty where goods_id='0000000001254' and open_id='1034';update tr_shopcart set price='6.50000000',unit_no='斤',amount=6.50000000 * qty where goods_id='0000000001258' and open_id='1034';update tr_shopcart set price='3.50000000',unit_no='盒',amount=3.50000000 * qty where goods_id='0000000001270' and open_id='1034';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000001276' and open_id='1034';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000001278' and open_id='1034';update tr_shopcart set price='7.00000000',unit_no='斤',amount=7.00000000 * qty where goods_id='0000000001570' and open_id='1034';update tr_shopcart set price='9.00000000',unit_no='斤',amount=9.00000000 * qty where goods_id='0000000001637' and open_id='1034';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000001746' and open_id='1034';update tr_shopcart set price='6.30000000',unit_no='瓶',amount=6.30000000 * qty where goods_id='0000000003142' and open_id='1034';update tr_shopcart set price='6.33000000',unit_no='瓶',amount=6.33000000 * qty where goods_id='0000000003236' and open_id='1034';update tr_shopcart set price='8.11000000',unit_no='瓶',amount=8.11000000 * qty where goods_id='0000000003339' and open_id='1034';update tr_shopcart set price='8.33000000',unit_no='瓶',amount=8.33000000 * qty where goods_id='0000000003342' and open_id='1034';update tr_shopcart set price='6.60000000',unit_no='瓶',amount=6.60000000 * qty where goods_id='0000000003357' and open_id='1034';update tr_shopcart set price='4.67000000',unit_no='瓶',amount=4.67000000 * qty where goods_id='0000000003371' and open_id='1034';update tr_shopcart set price='3.47000000',unit_no='瓶',amount=3.47000000 * qty where goods_id='0000000003436' and open_id='1034';update tr_shopcart set price='10.50000000',unit_no='包',amount=10.50000000 * qty where goods_id='0000000004667' and open_id='1034';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000004688' and open_id='1034';update tr_shopcart set price='4.10000000',unit_no='斤',amount=4.10000000 * qty where goods_id='0000000004697' and open_id='1034';update tr_shopcart set price='16.50000000',unit_no='斤',amount=16.50000000 * qty where goods_id='0000000004700' and open_id='1034';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000004718' and open_id='1034';update tr_shopcart set price='3.80000000',unit_no='斤',amount=3.80000000 * qty where goods_id='0000000004720' and open_id='1034';update tr_shopcart set price='2.40000000',unit_no='斤',amount=2.40000000 * qty where goods_id='0000000004729' and open_id='1034';update tr_shopcart set price='6.63000000',unit_no='斤',amount=6.63000000 * qty where goods_id='0000000004742' and open_id='1034';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000004744' and open_id='1034';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000004757' and open_id='1034';update tr_shopcart set price='4.50000000',unit_no='斤',amount=4.50000000 * qty where goods_id='0000000004758' and open_id='1034';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000004761' and open_id='1034';update tr_shopcart set price='1.70000000',unit_no='斤',amount=1.70000000 * qty where goods_id='0000000004769' and open_id='1034';update tr_shopcart set price='4.50000000',unit_no='包',amount=4.50000000 * qty where goods_id='0000000004777' and open_id='1034';update tr_shopcart set price='1.60000000',unit_no='斤',amount=1.60000000 * qty where goods_id='0000000004780' and open_id='1034';update tr_shopcart set price='20.00000000',unit_no='斤',amount=20.00000000 * qty where goods_id='0000000004961' and open_id='1034';update tr_shopcart set price='24.44000000',unit_no='斤',amount=24.44000000 * qty where goods_id='0000000004962' and open_id='1034';update tr_shopcart set price='8.50000000',unit_no='斤',amount=8.50000000 * qty where goods_id='0000000004994' and open_id='1034';update tr_shopcart set price='19.00000000',unit_no='只',amount=19.00000000 * qty where goods_id='0000000005132' and open_id='1034';update tr_shopcart set price='3.60000000',unit_no='斤',amount=3.60000000 * qty where goods_id='0000000005703' and open_id='1034';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005709' and open_id='1034';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000005713' and open_id='1034';update tr_shopcart set price='4.50000000',unit_no='斤',amount=4.50000000 * qty where goods_id='0000000005718' and open_id='1034';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005732' and open_id='1034';update tr_shopcart set price='2.30000000',unit_no='斤',amount=2.30000000 * qty where goods_id='0000000005735' and open_id='1034';update tr_shopcart set price='2.70000000',unit_no='斤',amount=2.70000000 * qty where goods_id='0000000005744' and open_id='1034';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005747' and open_id='1034';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005752' and open_id='1034';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000005754' and open_id='1034';update tr_shopcart set price='7.00000000',unit_no='斤',amount=7.00000000 * qty where goods_id='0000000005756' and open_id='1034';update tr_shopcart set price='3.60000000',unit_no='斤',amount=3.60000000 * qty where goods_id='0000000005757' and open_id='1034';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005759' and open_id='1034';update tr_shopcart set price='7.50000000',unit_no='斤',amount=7.50000000 * qty where goods_id='0000000005763' and open_id='1034';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000005765' and open_id='1034';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000005766' and open_id='1034';update tr_shopcart set price='6.00000000',unit_no='斤',amount=6.00000000 * qty where goods_id='0000000005768' and open_id='1034';update tr_shopcart set price='2.10000000',unit_no='斤',amount=2.10000000 * qty where goods_id='0000000005769' and open_id='1034';update tr_shopcart set price='1.70000000',unit_no='斤',amount=1.70000000 * qty where goods_id='0000000005774' and open_id='1034';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005775' and open_id='1034';update tr_shopcart set price='3.80000000',unit_no='包',amount=3.80000000 * qty where goods_id='0000000005776' and open_id='1034';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000005778' and open_id='1034';update tr_shopcart set price='3.40000000',unit_no='斤',amount=3.40000000 * qty where goods_id='0000000005797' and open_id='1034';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000005799' and open_id='1034';update tr_shopcart set price='3.10000000',unit_no='斤',amount=3.10000000 * qty where goods_id='0000000005800' and open_id='1034';update tr_shopcart set price='1.30000000',unit_no='斤',amount=1.30000000 * qty where goods_id='0000000005809' and open_id='1034';update tr_shopcart set price='3.10000000',unit_no='斤',amount=3.10000000 * qty where goods_id='0000000005810' and open_id='1034';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000005812' and open_id='1034';update tr_shopcart set price='2.00000000',unit_no='斤',amount=2.00000000 * qty where goods_id='0000000005814' and open_id='1034';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000005821' and open_id='1034';update tr_shopcart set price='2.70000000',unit_no='斤',amount=2.70000000 * qty where goods_id='0000000005824' and open_id='1034';update tr_shopcart set price='0.90000000',unit_no='斤',amount=0.90000000 * qty where goods_id='0000000005827' and open_id='1034';update tr_shopcart set price='1.60000000',unit_no='斤',amount=1.60000000 * qty where goods_id='0000000005828' and open_id='1034';update tr_shopcart set price='5.50000000',unit_no='斤',amount=5.50000000 * qty where goods_id='0000000005832' and open_id='1034';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000005838' and open_id='1034';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000005839' and open_id='1034';update tr_shopcart set price='3.40000000',unit_no='斤',amount=3.40000000 * qty where goods_id='0000000005840' and open_id='1034';update tr_shopcart set price='2.10000000',unit_no='斤',amount=2.10000000 * qty where goods_id='0000000005843' and open_id='1034';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000005844' and open_id='1034';update tr_shopcart set price='1.30000000',unit_no='斤',amount=1.30000000 * qty where goods_id='0000000005845' and open_id='1034';update tr_shopcart set price='3.70000000',unit_no='斤',amount=3.70000000 * qty where goods_id='0000000005846' and open_id='1034';update tr_shopcart set price='6.20000000',unit_no='斤',amount=6.20000000 * qty where goods_id='0000000005847' and open_id='1034';update tr_shopcart set price='2.00000000',unit_no='斤',amount=2.00000000 * qty where goods_id='0000000005848' and open_id='1034';update tr_shopcart set price='2.40000000',unit_no='斤',amount=2.40000000 * qty where goods_id='0000000005852' and open_id='1034';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005855' and open_id='1034';update tr_shopcart set price='1.60000000',unit_no='斤',amount=1.60000000 * qty where goods_id='0000000005859' and open_id='1034';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005861' and open_id='1034';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005862' and open_id='1034';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000005863' and open_id='1034';update tr_shopcart set price='6.00000000',unit_no='斤',amount=6.00000000 * qty where goods_id='0000000005864' and open_id='1034';update tr_shopcart set price='2.70000000',unit_no='斤',amount=2.70000000 * qty where goods_id='0000000005867' and open_id='1034';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000005868' and open_id='1034';update tr_shopcart set price='4.40000000',unit_no='斤',amount=4.40000000 * qty where goods_id='0000000005870' and open_id='1034';update tr_shopcart set price='1.50000000',unit_no='斤',amount=1.50000000 * qty where goods_id='0000000005871' and open_id='1034';update tr_shopcart set price='13.50000000',unit_no='斤',amount=13.50000000 * qty where goods_id='0000000005873' and open_id='1034';update tr_shopcart set price='47.00000000',unit_no='斤',amount=47.00000000 * qty where goods_id='0000000005895' and open_id='1034';update tr_shopcart set price='49.50000000',unit_no='斤',amount=49.50000000 * qty where goods_id='0000000005896' and open_id='1034'; [详细] => 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() 在 System.Data.SqlClient.SqlDataReader.get_MetaData() 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteScalar() 在 Db.DBContext.ExecuteScalar(String sql, IDbDataParameter[] pars) 在 Api.BLL.b2b.ShopCartService.GetAll(String oper_id, String supcust_no) 在 Api.SingOut.b2b.mina.shopcart.get_all() [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.shopcart , [方法] => get_all [入参] => ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-06-06 14:38:45 [错误信息] => 事务(进程 ID 67)与另一个进程被死锁在 锁 资源上，并且已被选作死锁牺牲品。请重新运行该事务。 [sql] => update tr_shopcart set price='10.50000000',unit_no='斤',amount=10.50000000 * qty where goods_id='0000000000025' and open_id='1034';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000000027' and open_id='1034';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000000028' and open_id='1034';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000000660' and open_id='1034';update tr_shopcart set price='2.90000000',unit_no='斤',amount=2.90000000 * qty where goods_id='0000000000924' and open_id='1034';update tr_shopcart set price='3.30000000',unit_no='斤',amount=3.30000000 * qty where goods_id='0000000000934' and open_id='1034';update tr_shopcart set price='4.80000000',unit_no='斤',amount=4.80000000 * qty where goods_id='0000000000964' and open_id='1034';update tr_shopcart set price='4.00000000',unit_no='盒',amount=4.00000000 * qty where goods_id='0000000000996' and open_id='1034';update tr_shopcart set price='5.30000000',unit_no='斤',amount=5.30000000 * qty where goods_id='0000000001048' and open_id='1034';update tr_shopcart set price='8.50000000',unit_no='斤',amount=8.50000000 * qty where goods_id='0000000001117' and open_id='1034';update tr_shopcart set price='4.80000000',unit_no='斤',amount=4.80000000 * qty where goods_id='0000000001246' and open_id='1034';update tr_shopcart set price='3.50000000',unit_no='盒',amount=3.50000000 * qty where goods_id='0000000001254' and open_id='1034';update tr_shopcart set price='6.50000000',unit_no='斤',amount=6.50000000 * qty where goods_id='0000000001258' and open_id='1034';update tr_shopcart set price='3.50000000',unit_no='盒',amount=3.50000000 * qty where goods_id='0000000001270' and open_id='1034';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000001276' and open_id='1034';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000001278' and open_id='1034';update tr_shopcart set price='7.00000000',unit_no='斤',amount=7.00000000 * qty where goods_id='0000000001570' and open_id='1034';update tr_shopcart set price='9.00000000',unit_no='斤',amount=9.00000000 * qty where goods_id='0000000001637' and open_id='1034';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000001746' and open_id='1034';update tr_shopcart set price='6.30000000',unit_no='瓶',amount=6.30000000 * qty where goods_id='0000000003142' and open_id='1034';update tr_shopcart set price='6.33000000',unit_no='瓶',amount=6.33000000 * qty where goods_id='0000000003236' and open_id='1034';update tr_shopcart set price='8.11000000',unit_no='瓶',amount=8.11000000 * qty where goods_id='0000000003339' and open_id='1034';update tr_shopcart set price='8.33000000',unit_no='瓶',amount=8.33000000 * qty where goods_id='0000000003342' and open_id='1034';update tr_shopcart set price='6.60000000',unit_no='瓶',amount=6.60000000 * qty where goods_id='0000000003357' and open_id='1034';update tr_shopcart set price='4.67000000',unit_no='瓶',amount=4.67000000 * qty where goods_id='0000000003371' and open_id='1034';update tr_shopcart set price='3.47000000',unit_no='瓶',amount=3.47000000 * qty where goods_id='0000000003436' and open_id='1034';update tr_shopcart set price='10.50000000',unit_no='包',amount=10.50000000 * qty where goods_id='0000000004667' and open_id='1034';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000004688' and open_id='1034';update tr_shopcart set price='4.10000000',unit_no='斤',amount=4.10000000 * qty where goods_id='0000000004697' and open_id='1034';update tr_shopcart set price='16.50000000',unit_no='斤',amount=16.50000000 * qty where goods_id='0000000004700' and open_id='1034';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000004718' and open_id='1034';update tr_shopcart set price='3.80000000',unit_no='斤',amount=3.80000000 * qty where goods_id='0000000004720' and open_id='1034';update tr_shopcart set price='2.40000000',unit_no='斤',amount=2.40000000 * qty where goods_id='0000000004729' and open_id='1034';update tr_shopcart set price='6.63000000',unit_no='斤',amount=6.63000000 * qty where goods_id='0000000004742' and open_id='1034';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000004744' and open_id='1034';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000004757' and open_id='1034';update tr_shopcart set price='4.50000000',unit_no='斤',amount=4.50000000 * qty where goods_id='0000000004758' and open_id='1034';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000004761' and open_id='1034';update tr_shopcart set price='1.70000000',unit_no='斤',amount=1.70000000 * qty where goods_id='0000000004769' and open_id='1034';update tr_shopcart set price='4.50000000',unit_no='包',amount=4.50000000 * qty where goods_id='0000000004777' and open_id='1034';update tr_shopcart set price='1.60000000',unit_no='斤',amount=1.60000000 * qty where goods_id='0000000004780' and open_id='1034';update tr_shopcart set price='20.00000000',unit_no='斤',amount=20.00000000 * qty where goods_id='0000000004961' and open_id='1034';update tr_shopcart set price='24.44000000',unit_no='斤',amount=24.44000000 * qty where goods_id='0000000004962' and open_id='1034';update tr_shopcart set price='8.50000000',unit_no='斤',amount=8.50000000 * qty where goods_id='0000000004994' and open_id='1034';update tr_shopcart set price='19.00000000',unit_no='只',amount=19.00000000 * qty where goods_id='0000000005132' and open_id='1034';update tr_shopcart set price='3.60000000',unit_no='斤',amount=3.60000000 * qty where goods_id='0000000005703' and open_id='1034';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005709' and open_id='1034';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000005713' and open_id='1034';update tr_shopcart set price='4.50000000',unit_no='斤',amount=4.50000000 * qty where goods_id='0000000005718' and open_id='1034';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005732' and open_id='1034';update tr_shopcart set price='2.30000000',unit_no='斤',amount=2.30000000 * qty where goods_id='0000000005735' and open_id='1034';update tr_shopcart set price='2.70000000',unit_no='斤',amount=2.70000000 * qty where goods_id='0000000005744' and open_id='1034';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005747' and open_id='1034';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005752' and open_id='1034';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000005754' and open_id='1034';update tr_shopcart set price='7.00000000',unit_no='斤',amount=7.00000000 * qty where goods_id='0000000005756' and open_id='1034';update tr_shopcart set price='3.60000000',unit_no='斤',amount=3.60000000 * qty where goods_id='0000000005757' and open_id='1034';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005759' and open_id='1034';update tr_shopcart set price='7.50000000',unit_no='斤',amount=7.50000000 * qty where goods_id='0000000005763' and open_id='1034';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000005765' and open_id='1034';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000005766' and open_id='1034';update tr_shopcart set price='6.00000000',unit_no='斤',amount=6.00000000 * qty where goods_id='0000000005768' and open_id='1034';update tr_shopcart set price='2.10000000',unit_no='斤',amount=2.10000000 * qty where goods_id='0000000005769' and open_id='1034';update tr_shopcart set price='1.70000000',unit_no='斤',amount=1.70000000 * qty where goods_id='0000000005774' and open_id='1034';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005775' and open_id='1034';update tr_shopcart set price='3.80000000',unit_no='包',amount=3.80000000 * qty where goods_id='0000000005776' and open_id='1034';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000005778' and open_id='1034';update tr_shopcart set price='3.40000000',unit_no='斤',amount=3.40000000 * qty where goods_id='0000000005797' and open_id='1034';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000005799' and open_id='1034';update tr_shopcart set price='3.10000000',unit_no='斤',amount=3.10000000 * qty where goods_id='0000000005800' and open_id='1034';update tr_shopcart set price='1.30000000',unit_no='斤',amount=1.30000000 * qty where goods_id='0000000005809' and open_id='1034';update tr_shopcart set price='3.10000000',unit_no='斤',amount=3.10000000 * qty where goods_id='0000000005810' and open_id='1034';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000005812' and open_id='1034';update tr_shopcart set price='2.00000000',unit_no='斤',amount=2.00000000 * qty where goods_id='0000000005814' and open_id='1034';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000005821' and open_id='1034';update tr_shopcart set price='2.70000000',unit_no='斤',amount=2.70000000 * qty where goods_id='0000000005824' and open_id='1034';update tr_shopcart set price='0.90000000',unit_no='斤',amount=0.90000000 * qty where goods_id='0000000005827' and open_id='1034';update tr_shopcart set price='1.60000000',unit_no='斤',amount=1.60000000 * qty where goods_id='0000000005828' and open_id='1034';update tr_shopcart set price='5.50000000',unit_no='斤',amount=5.50000000 * qty where goods_id='0000000005832' and open_id='1034';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000005838' and open_id='1034';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000005839' and open_id='1034';update tr_shopcart set price='3.40000000',unit_no='斤',amount=3.40000000 * qty where goods_id='0000000005840' and open_id='1034';update tr_shopcart set price='2.10000000',unit_no='斤',amount=2.10000000 * qty where goods_id='0000000005843' and open_id='1034';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000005844' and open_id='1034';update tr_shopcart set price='1.30000000',unit_no='斤',amount=1.30000000 * qty where goods_id='0000000005845' and open_id='1034';update tr_shopcart set price='3.70000000',unit_no='斤',amount=3.70000000 * qty where goods_id='0000000005846' and open_id='1034';update tr_shopcart set price='6.20000000',unit_no='斤',amount=6.20000000 * qty where goods_id='0000000005847' and open_id='1034';update tr_shopcart set price='2.00000000',unit_no='斤',amount=2.00000000 * qty where goods_id='0000000005848' and open_id='1034';update tr_shopcart set price='2.40000000',unit_no='斤',amount=2.40000000 * qty where goods_id='0000000005852' and open_id='1034';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005855' and open_id='1034';update tr_shopcart set price='1.60000000',unit_no='斤',amount=1.60000000 * qty where goods_id='0000000005859' and open_id='1034';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005861' and open_id='1034';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005862' and open_id='1034';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000005863' and open_id='1034';update tr_shopcart set price='6.00000000',unit_no='斤',amount=6.00000000 * qty where goods_id='0000000005864' and open_id='1034';update tr_shopcart set price='2.70000000',unit_no='斤',amount=2.70000000 * qty where goods_id='0000000005867' and open_id='1034';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000005868' and open_id='1034';update tr_shopcart set price='4.40000000',unit_no='斤',amount=4.40000000 * qty where goods_id='0000000005870' and open_id='1034';update tr_shopcart set price='1.50000000',unit_no='斤',amount=1.50000000 * qty where goods_id='0000000005871' and open_id='1034';update tr_shopcart set price='13.50000000',unit_no='斤',amount=13.50000000 * qty where goods_id='0000000005873' and open_id='1034';update tr_shopcart set price='47.00000000',unit_no='斤',amount=47.00000000 * qty where goods_id='0000000005895' and open_id='1034';update tr_shopcart set price='49.50000000',unit_no='斤',amount=49.50000000 * qty where goods_id='0000000005896' and open_id='1034'; [详细] => 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() 在 System.Data.SqlClient.SqlDataReader.get_MetaData() 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteScalar() 在 Db.DBContext.ExecuteScalar(String sql, IDbDataParameter[] pars) 在 Api.BLL.b2b.ShopCartService.GetAll(String oper_id, String supcust_no) 在 Api.SingOut.b2b.mina.shopcart.get_all() [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.shopcart , [方法] => get_all [入参] => ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-06-06 14:38:50 [错误信息] => 事务(进程 ID 63)与另一个进程被死锁在 锁 资源上，并且已被选作死锁牺牲品。请重新运行该事务。 [sql] => update tr_shopcart set price='10.50000000',unit_no='斤',amount=10.50000000 * qty where goods_id='0000000000025' and open_id='1034';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000000027' and open_id='1034';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000000028' and open_id='1034';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000000660' and open_id='1034';update tr_shopcart set price='2.90000000',unit_no='斤',amount=2.90000000 * qty where goods_id='0000000000924' and open_id='1034';update tr_shopcart set price='3.30000000',unit_no='斤',amount=3.30000000 * qty where goods_id='0000000000934' and open_id='1034';update tr_shopcart set price='4.80000000',unit_no='斤',amount=4.80000000 * qty where goods_id='0000000000964' and open_id='1034';update tr_shopcart set price='4.00000000',unit_no='盒',amount=4.00000000 * qty where goods_id='0000000000996' and open_id='1034';update tr_shopcart set price='5.30000000',unit_no='斤',amount=5.30000000 * qty where goods_id='0000000001048' and open_id='1034';update tr_shopcart set price='8.50000000',unit_no='斤',amount=8.50000000 * qty where goods_id='0000000001117' and open_id='1034';update tr_shopcart set price='4.80000000',unit_no='斤',amount=4.80000000 * qty where goods_id='0000000001246' and open_id='1034';update tr_shopcart set price='3.50000000',unit_no='盒',amount=3.50000000 * qty where goods_id='0000000001254' and open_id='1034';update tr_shopcart set price='6.50000000',unit_no='斤',amount=6.50000000 * qty where goods_id='0000000001258' and open_id='1034';update tr_shopcart set price='3.50000000',unit_no='盒',amount=3.50000000 * qty where goods_id='0000000001270' and open_id='1034';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000001276' and open_id='1034';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000001278' and open_id='1034';update tr_shopcart set price='7.00000000',unit_no='斤',amount=7.00000000 * qty where goods_id='0000000001570' and open_id='1034';update tr_shopcart set price='9.00000000',unit_no='斤',amount=9.00000000 * qty where goods_id='0000000001637' and open_id='1034';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000001746' and open_id='1034';update tr_shopcart set price='6.30000000',unit_no='瓶',amount=6.30000000 * qty where goods_id='0000000003142' and open_id='1034';update tr_shopcart set price='6.33000000',unit_no='瓶',amount=6.33000000 * qty where goods_id='0000000003236' and open_id='1034';update tr_shopcart set price='8.11000000',unit_no='瓶',amount=8.11000000 * qty where goods_id='0000000003339' and open_id='1034';update tr_shopcart set price='8.33000000',unit_no='瓶',amount=8.33000000 * qty where goods_id='0000000003342' and open_id='1034';update tr_shopcart set price='6.60000000',unit_no='瓶',amount=6.60000000 * qty where goods_id='0000000003357' and open_id='1034';update tr_shopcart set price='4.67000000',unit_no='瓶',amount=4.67000000 * qty where goods_id='0000000003371' and open_id='1034';update tr_shopcart set price='3.47000000',unit_no='瓶',amount=3.47000000 * qty where goods_id='0000000003436' and open_id='1034';update tr_shopcart set price='10.50000000',unit_no='包',amount=10.50000000 * qty where goods_id='0000000004667' and open_id='1034';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000004688' and open_id='1034';update tr_shopcart set price='4.10000000',unit_no='斤',amount=4.10000000 * qty where goods_id='0000000004697' and open_id='1034';update tr_shopcart set price='16.50000000',unit_no='斤',amount=16.50000000 * qty where goods_id='0000000004700' and open_id='1034';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000004718' and open_id='1034';update tr_shopcart set price='3.80000000',unit_no='斤',amount=3.80000000 * qty where goods_id='0000000004720' and open_id='1034';update tr_shopcart set price='2.40000000',unit_no='斤',amount=2.40000000 * qty where goods_id='0000000004729' and open_id='1034';update tr_shopcart set price='6.63000000',unit_no='斤',amount=6.63000000 * qty where goods_id='0000000004742' and open_id='1034';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000004744' and open_id='1034';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000004757' and open_id='1034';update tr_shopcart set price='4.50000000',unit_no='斤',amount=4.50000000 * qty where goods_id='0000000004758' and open_id='1034';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000004761' and open_id='1034';update tr_shopcart set price='1.70000000',unit_no='斤',amount=1.70000000 * qty where goods_id='0000000004769' and open_id='1034';update tr_shopcart set price='4.50000000',unit_no='包',amount=4.50000000 * qty where goods_id='0000000004777' and open_id='1034';update tr_shopcart set price='1.60000000',unit_no='斤',amount=1.60000000 * qty where goods_id='0000000004780' and open_id='1034';update tr_shopcart set price='20.00000000',unit_no='斤',amount=20.00000000 * qty where goods_id='0000000004961' and open_id='1034';update tr_shopcart set price='24.44000000',unit_no='斤',amount=24.44000000 * qty where goods_id='0000000004962' and open_id='1034';update tr_shopcart set price='8.50000000',unit_no='斤',amount=8.50000000 * qty where goods_id='0000000004994' and open_id='1034';update tr_shopcart set price='19.00000000',unit_no='只',amount=19.00000000 * qty where goods_id='0000000005132' and open_id='1034';update tr_shopcart set price='3.60000000',unit_no='斤',amount=3.60000000 * qty where goods_id='0000000005703' and open_id='1034';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005709' and open_id='1034';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000005713' and open_id='1034';update tr_shopcart set price='4.50000000',unit_no='斤',amount=4.50000000 * qty where goods_id='0000000005718' and open_id='1034';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005732' and open_id='1034';update tr_shopcart set price='2.30000000',unit_no='斤',amount=2.30000000 * qty where goods_id='0000000005735' and open_id='1034';update tr_shopcart set price='2.70000000',unit_no='斤',amount=2.70000000 * qty where goods_id='0000000005744' and open_id='1034';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005747' and open_id='1034';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005752' and open_id='1034';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000005754' and open_id='1034';update tr_shopcart set price='7.00000000',unit_no='斤',amount=7.00000000 * qty where goods_id='0000000005756' and open_id='1034';update tr_shopcart set price='3.60000000',unit_no='斤',amount=3.60000000 * qty where goods_id='0000000005757' and open_id='1034';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005759' and open_id='1034';update tr_shopcart set price='7.50000000',unit_no='斤',amount=7.50000000 * qty where goods_id='0000000005763' and open_id='1034';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000005765' and open_id='1034';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000005766' and open_id='1034';update tr_shopcart set price='6.00000000',unit_no='斤',amount=6.00000000 * qty where goods_id='0000000005768' and open_id='1034';update tr_shopcart set price='2.10000000',unit_no='斤',amount=2.10000000 * qty where goods_id='0000000005769' and open_id='1034';update tr_shopcart set price='1.70000000',unit_no='斤',amount=1.70000000 * qty where goods_id='0000000005771' and open_id='1034';update tr_shopcart set price='1.70000000',unit_no='斤',amount=1.70000000 * qty where goods_id='0000000005774' and open_id='1034';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005775' and open_id='1034';update tr_shopcart set price='3.80000000',unit_no='包',amount=3.80000000 * qty where goods_id='0000000005776' and open_id='1034';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000005778' and open_id='1034';update tr_shopcart set price='3.40000000',unit_no='斤',amount=3.40000000 * qty where goods_id='0000000005797' and open_id='1034';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000005799' and open_id='1034';update tr_shopcart set price='3.10000000',unit_no='斤',amount=3.10000000 * qty where goods_id='0000000005800' and open_id='1034';update tr_shopcart set price='1.30000000',unit_no='斤',amount=1.30000000 * qty where goods_id='0000000005809' and open_id='1034';update tr_shopcart set price='3.10000000',unit_no='斤',amount=3.10000000 * qty where goods_id='0000000005810' and open_id='1034';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000005812' and open_id='1034';update tr_shopcart set price='2.00000000',unit_no='斤',amount=2.00000000 * qty where goods_id='0000000005814' and open_id='1034';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000005821' and open_id='1034';update tr_shopcart set price='2.70000000',unit_no='斤',amount=2.70000000 * qty where goods_id='0000000005824' and open_id='1034';update tr_shopcart set price='0.90000000',unit_no='斤',amount=0.90000000 * qty where goods_id='0000000005827' and open_id='1034';update tr_shopcart set price='1.60000000',unit_no='斤',amount=1.60000000 * qty where goods_id='0000000005828' and open_id='1034';update tr_shopcart set price='5.50000000',unit_no='斤',amount=5.50000000 * qty where goods_id='0000000005832' and open_id='1034';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000005838' and open_id='1034';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000005839' and open_id='1034';update tr_shopcart set price='3.40000000',unit_no='斤',amount=3.40000000 * qty where goods_id='0000000005840' and open_id='1034';update tr_shopcart set price='2.10000000',unit_no='斤',amount=2.10000000 * qty where goods_id='0000000005843' and open_id='1034';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000005844' and open_id='1034';update tr_shopcart set price='1.30000000',unit_no='斤',amount=1.30000000 * qty where goods_id='0000000005845' and open_id='1034';update tr_shopcart set price='3.70000000',unit_no='斤',amount=3.70000000 * qty where goods_id='0000000005846' and open_id='1034';update tr_shopcart set price='6.20000000',unit_no='斤',amount=6.20000000 * qty where goods_id='0000000005847' and open_id='1034';update tr_shopcart set price='2.00000000',unit_no='斤',amount=2.00000000 * qty where goods_id='0000000005848' and open_id='1034';update tr_shopcart set price='2.40000000',unit_no='斤',amount=2.40000000 * qty where goods_id='0000000005852' and open_id='1034';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005855' and open_id='1034';update tr_shopcart set price='1.60000000',unit_no='斤',amount=1.60000000 * qty where goods_id='0000000005859' and open_id='1034';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005861' and open_id='1034';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005862' and open_id='1034';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000005863' and open_id='1034';update tr_shopcart set price='6.00000000',unit_no='斤',amount=6.00000000 * qty where goods_id='0000000005864' and open_id='1034';update tr_shopcart set price='2.70000000',unit_no='斤',amount=2.70000000 * qty where goods_id='0000000005867' and open_id='1034';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000005868' and open_id='1034';update tr_shopcart set price='4.40000000',unit_no='斤',amount=4.40000000 * qty where goods_id='0000000005870' and open_id='1034';update tr_shopcart set price='1.50000000',unit_no='斤',amount=1.50000000 * qty where goods_id='0000000005871' and open_id='1034';update tr_shopcart set price='13.50000000',unit_no='斤',amount=13.50000000 * qty where goods_id='0000000005873' and open_id='1034';update tr_shopcart set price='47.00000000',unit_no='斤',amount=47.00000000 * qty where goods_id='0000000005895' and open_id='1034';update tr_shopcart set price='49.50000000',unit_no='斤',amount=49.50000000 * qty where goods_id='0000000005896' and open_id='1034'; [详细] => 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() 在 System.Data.SqlClient.SqlDataReader.get_MetaData() 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteScalar() 在 Db.DBContext.ExecuteScalar(String sql, IDbDataParameter[] pars) 在 Api.BLL.b2b.ShopCartService.GetAll(String oper_id, String supcust_no) 在 Api.SingOut.b2b.mina.shopcart.get_all() [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.shopcart , [方法] => get_all [入参] => ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-06-06 14:39:01 [错误信息] => 事务(进程 ID 62)与另一个进程被死锁在 锁 资源上，并且已被选作死锁牺牲品。请重新运行该事务。 [sql] => update tr_shopcart set price='10.50000000',unit_no='斤',amount=10.50000000 * qty where goods_id='0000000000025' and open_id='1034';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000000027' and open_id='1034';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000000028' and open_id='1034';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000000660' and open_id='1034';update tr_shopcart set price='2.90000000',unit_no='斤',amount=2.90000000 * qty where goods_id='0000000000924' and open_id='1034';update tr_shopcart set price='3.30000000',unit_no='斤',amount=3.30000000 * qty where goods_id='0000000000934' and open_id='1034';update tr_shopcart set price='4.80000000',unit_no='斤',amount=4.80000000 * qty where goods_id='0000000000964' and open_id='1034';update tr_shopcart set price='4.00000000',unit_no='盒',amount=4.00000000 * qty where goods_id='0000000000996' and open_id='1034';update tr_shopcart set price='5.30000000',unit_no='斤',amount=5.30000000 * qty where goods_id='0000000001048' and open_id='1034';update tr_shopcart set price='8.50000000',unit_no='斤',amount=8.50000000 * qty where goods_id='0000000001117' and open_id='1034';update tr_shopcart set price='4.80000000',unit_no='斤',amount=4.80000000 * qty where goods_id='0000000001246' and open_id='1034';update tr_shopcart set price='3.50000000',unit_no='盒',amount=3.50000000 * qty where goods_id='0000000001254' and open_id='1034';update tr_shopcart set price='6.50000000',unit_no='斤',amount=6.50000000 * qty where goods_id='0000000001258' and open_id='1034';update tr_shopcart set price='3.50000000',unit_no='盒',amount=3.50000000 * qty where goods_id='0000000001270' and open_id='1034';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000001276' and open_id='1034';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000001278' and open_id='1034';update tr_shopcart set price='7.00000000',unit_no='斤',amount=7.00000000 * qty where goods_id='0000000001570' and open_id='1034';update tr_shopcart set price='9.00000000',unit_no='斤',amount=9.00000000 * qty where goods_id='0000000001637' and open_id='1034';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000001746' and open_id='1034';update tr_shopcart set price='6.30000000',unit_no='瓶',amount=6.30000000 * qty where goods_id='0000000003142' and open_id='1034';update tr_shopcart set price='6.33000000',unit_no='瓶',amount=6.33000000 * qty where goods_id='0000000003236' and open_id='1034';update tr_shopcart set price='8.11000000',unit_no='瓶',amount=8.11000000 * qty where goods_id='0000000003339' and open_id='1034';update tr_shopcart set price='8.33000000',unit_no='瓶',amount=8.33000000 * qty where goods_id='0000000003342' and open_id='1034';update tr_shopcart set price='6.60000000',unit_no='瓶',amount=6.60000000 * qty where goods_id='0000000003357' and open_id='1034';update tr_shopcart set price='4.67000000',unit_no='瓶',amount=4.67000000 * qty where goods_id='0000000003371' and open_id='1034';update tr_shopcart set price='3.47000000',unit_no='瓶',amount=3.47000000 * qty where goods_id='0000000003436' and open_id='1034';update tr_shopcart set price='10.50000000',unit_no='包',amount=10.50000000 * qty where goods_id='0000000004667' and open_id='1034';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000004688' and open_id='1034';update tr_shopcart set price='4.10000000',unit_no='斤',amount=4.10000000 * qty where goods_id='0000000004697' and open_id='1034';update tr_shopcart set price='16.50000000',unit_no='斤',amount=16.50000000 * qty where goods_id='0000000004700' and open_id='1034';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000004718' and open_id='1034';update tr_shopcart set price='3.80000000',unit_no='斤',amount=3.80000000 * qty where goods_id='0000000004720' and open_id='1034';update tr_shopcart set price='2.40000000',unit_no='斤',amount=2.40000000 * qty where goods_id='0000000004729' and open_id='1034';update tr_shopcart set price='6.63000000',unit_no='斤',amount=6.63000000 * qty where goods_id='0000000004742' and open_id='1034';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000004744' and open_id='1034';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000004757' and open_id='1034';update tr_shopcart set price='4.50000000',unit_no='斤',amount=4.50000000 * qty where goods_id='0000000004758' and open_id='1034';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000004761' and open_id='1034';update tr_shopcart set price='1.70000000',unit_no='斤',amount=1.70000000 * qty where goods_id='0000000004769' and open_id='1034';update tr_shopcart set price='4.50000000',unit_no='包',amount=4.50000000 * qty where goods_id='0000000004777' and open_id='1034';update tr_shopcart set price='1.60000000',unit_no='斤',amount=1.60000000 * qty where goods_id='0000000004780' and open_id='1034';update tr_shopcart set price='20.00000000',unit_no='斤',amount=20.00000000 * qty where goods_id='0000000004961' and open_id='1034';update tr_shopcart set price='24.44000000',unit_no='斤',amount=24.44000000 * qty where goods_id='0000000004962' and open_id='1034';update tr_shopcart set price='8.50000000',unit_no='斤',amount=8.50000000 * qty where goods_id='0000000004994' and open_id='1034';update tr_shopcart set price='19.00000000',unit_no='只',amount=19.00000000 * qty where goods_id='0000000005132' and open_id='1034';update tr_shopcart set price='3.60000000',unit_no='斤',amount=3.60000000 * qty where goods_id='0000000005703' and open_id='1034';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005709' and open_id='1034';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000005713' and open_id='1034';update tr_shopcart set price='4.50000000',unit_no='斤',amount=4.50000000 * qty where goods_id='0000000005718' and open_id='1034';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005732' and open_id='1034';update tr_shopcart set price='2.30000000',unit_no='斤',amount=2.30000000 * qty where goods_id='0000000005735' and open_id='1034';update tr_shopcart set price='2.70000000',unit_no='斤',amount=2.70000000 * qty where goods_id='0000000005744' and open_id='1034';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005747' and open_id='1034';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005752' and open_id='1034';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000005754' and open_id='1034';update tr_shopcart set price='7.00000000',unit_no='斤',amount=7.00000000 * qty where goods_id='0000000005756' and open_id='1034';update tr_shopcart set price='3.60000000',unit_no='斤',amount=3.60000000 * qty where goods_id='0000000005757' and open_id='1034';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005759' and open_id='1034';update tr_shopcart set price='7.50000000',unit_no='斤',amount=7.50000000 * qty where goods_id='0000000005763' and open_id='1034';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000005765' and open_id='1034';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000005766' and open_id='1034';update tr_shopcart set price='6.00000000',unit_no='斤',amount=6.00000000 * qty where goods_id='0000000005768' and open_id='1034';update tr_shopcart set price='2.10000000',unit_no='斤',amount=2.10000000 * qty where goods_id='0000000005769' and open_id='1034';update tr_shopcart set price='1.70000000',unit_no='斤',amount=1.70000000 * qty where goods_id='0000000005771' and open_id='1034';update tr_shopcart set price='1.60000000',unit_no='斤',amount=1.60000000 * qty where goods_id='0000000005772' and open_id='1034';update tr_shopcart set price='1.70000000',unit_no='斤',amount=1.70000000 * qty where goods_id='0000000005774' and open_id='1034';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005775' and open_id='1034';update tr_shopcart set price='3.80000000',unit_no='包',amount=3.80000000 * qty where goods_id='0000000005776' and open_id='1034';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000005778' and open_id='1034';update tr_shopcart set price='3.40000000',unit_no='斤',amount=3.40000000 * qty where goods_id='0000000005797' and open_id='1034';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000005799' and open_id='1034';update tr_shopcart set price='3.10000000',unit_no='斤',amount=3.10000000 * qty where goods_id='0000000005800' and open_id='1034';update tr_shopcart set price='1.30000000',unit_no='斤',amount=1.30000000 * qty where goods_id='0000000005809' and open_id='1034';update tr_shopcart set price='3.10000000',unit_no='斤',amount=3.10000000 * qty where goods_id='0000000005810' and open_id='1034';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000005812' and open_id='1034';update tr_shopcart set price='2.00000000',unit_no='斤',amount=2.00000000 * qty where goods_id='0000000005814' and open_id='1034';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000005821' and open_id='1034';update tr_shopcart set price='2.70000000',unit_no='斤',amount=2.70000000 * qty where goods_id='0000000005824' and open_id='1034';update tr_shopcart set price='0.90000000',unit_no='斤',amount=0.90000000 * qty where goods_id='0000000005827' and open_id='1034';update tr_shopcart set price='1.60000000',unit_no='斤',amount=1.60000000 * qty where goods_id='0000000005828' and open_id='1034';update tr_shopcart set price='5.50000000',unit_no='斤',amount=5.50000000 * qty where goods_id='0000000005832' and open_id='1034';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000005838' and open_id='1034';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000005839' and open_id='1034';update tr_shopcart set price='3.40000000',unit_no='斤',amount=3.40000000 * qty where goods_id='0000000005840' and open_id='1034';update tr_shopcart set price='2.10000000',unit_no='斤',amount=2.10000000 * qty where goods_id='0000000005843' and open_id='1034';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000005844' and open_id='1034';update tr_shopcart set price='1.30000000',unit_no='斤',amount=1.30000000 * qty where goods_id='0000000005845' and open_id='1034';update tr_shopcart set price='3.70000000',unit_no='斤',amount=3.70000000 * qty where goods_id='0000000005846' and open_id='1034';update tr_shopcart set price='6.20000000',unit_no='斤',amount=6.20000000 * qty where goods_id='0000000005847' and open_id='1034';update tr_shopcart set price='2.00000000',unit_no='斤',amount=2.00000000 * qty where goods_id='0000000005848' and open_id='1034';update tr_shopcart set price='2.40000000',unit_no='斤',amount=2.40000000 * qty where goods_id='0000000005852' and open_id='1034';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005855' and open_id='1034';update tr_shopcart set price='1.60000000',unit_no='斤',amount=1.60000000 * qty where goods_id='0000000005859' and open_id='1034';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005861' and open_id='1034';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005862' and open_id='1034';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000005863' and open_id='1034';update tr_shopcart set price='6.00000000',unit_no='斤',amount=6.00000000 * qty where goods_id='0000000005864' and open_id='1034';update tr_shopcart set price='2.70000000',unit_no='斤',amount=2.70000000 * qty where goods_id='0000000005867' and open_id='1034';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000005868' and open_id='1034';update tr_shopcart set price='4.40000000',unit_no='斤',amount=4.40000000 * qty where goods_id='0000000005870' and open_id='1034';update tr_shopcart set price='1.50000000',unit_no='斤',amount=1.50000000 * qty where goods_id='0000000005871' and open_id='1034';update tr_shopcart set price='13.50000000',unit_no='斤',amount=13.50000000 * qty where goods_id='0000000005873' and open_id='1034';update tr_shopcart set price='47.00000000',unit_no='斤',amount=47.00000000 * qty where goods_id='0000000005895' and open_id='1034';update tr_shopcart set price='49.50000000',unit_no='斤',amount=49.50000000 * qty where goods_id='0000000005896' and open_id='1034'; [详细] => 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() 在 System.Data.SqlClient.SqlDataReader.get_MetaData() 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteScalar() 在 Db.DBContext.ExecuteScalar(String sql, IDbDataParameter[] pars) 在 Api.BLL.b2b.ShopCartService.GetAll(String oper_id, String supcust_no) 在 Api.SingOut.b2b.mina.shopcart.get_all() [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.shopcart , [方法] => get_all [入参] => ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-06-06 14:39:40 [错误信息] => 事务(进程 ID 62)与另一个进程被死锁在 锁 资源上，并且已被选作死锁牺牲品。请重新运行该事务。 [sql] => update tr_shopcart set price='10.50000000',unit_no='斤',amount=10.50000000 * qty where goods_id='0000000000025' and open_id='1034';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000000027' and open_id='1034';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000000028' and open_id='1034';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000000660' and open_id='1034';update tr_shopcart set price='2.90000000',unit_no='斤',amount=2.90000000 * qty where goods_id='0000000000924' and open_id='1034';update tr_shopcart set price='3.30000000',unit_no='斤',amount=3.30000000 * qty where goods_id='0000000000934' and open_id='1034';update tr_shopcart set price='4.80000000',unit_no='斤',amount=4.80000000 * qty where goods_id='0000000000964' and open_id='1034';update tr_shopcart set price='4.00000000',unit_no='盒',amount=4.00000000 * qty where goods_id='0000000000996' and open_id='1034';update tr_shopcart set price='5.30000000',unit_no='斤',amount=5.30000000 * qty where goods_id='0000000001048' and open_id='1034';update tr_shopcart set price='8.50000000',unit_no='斤',amount=8.50000000 * qty where goods_id='0000000001117' and open_id='1034';update tr_shopcart set price='4.80000000',unit_no='斤',amount=4.80000000 * qty where goods_id='0000000001246' and open_id='1034';update tr_shopcart set price='3.50000000',unit_no='盒',amount=3.50000000 * qty where goods_id='0000000001254' and open_id='1034';update tr_shopcart set price='6.50000000',unit_no='斤',amount=6.50000000 * qty where goods_id='0000000001258' and open_id='1034';update tr_shopcart set price='3.50000000',unit_no='盒',amount=3.50000000 * qty where goods_id='0000000001270' and open_id='1034';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000001276' and open_id='1034';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000001278' and open_id='1034';update tr_shopcart set price='7.00000000',unit_no='斤',amount=7.00000000 * qty where goods_id='0000000001570' and open_id='1034';update tr_shopcart set price='9.00000000',unit_no='斤',amount=9.00000000 * qty where goods_id='0000000001637' and open_id='1034';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000001746' and open_id='1034';update tr_shopcart set price='6.30000000',unit_no='瓶',amount=6.30000000 * qty where goods_id='0000000003142' and open_id='1034';update tr_shopcart set price='6.33000000',unit_no='瓶',amount=6.33000000 * qty where goods_id='0000000003236' and open_id='1034';update tr_shopcart set price='8.11000000',unit_no='瓶',amount=8.11000000 * qty where goods_id='0000000003339' and open_id='1034';update tr_shopcart set price='8.33000000',unit_no='瓶',amount=8.33000000 * qty where goods_id='0000000003342' and open_id='1034';update tr_shopcart set price='6.60000000',unit_no='瓶',amount=6.60000000 * qty where goods_id='0000000003357' and open_id='1034';update tr_shopcart set price='4.67000000',unit_no='瓶',amount=4.67000000 * qty where goods_id='0000000003371' and open_id='1034';update tr_shopcart set price='3.47000000',unit_no='瓶',amount=3.47000000 * qty where goods_id='0000000003436' and open_id='1034';update tr_shopcart set price='10.50000000',unit_no='包',amount=10.50000000 * qty where goods_id='0000000004667' and open_id='1034';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000004688' and open_id='1034';update tr_shopcart set price='4.10000000',unit_no='斤',amount=4.10000000 * qty where goods_id='0000000004697' and open_id='1034';update tr_shopcart set price='16.50000000',unit_no='斤',amount=16.50000000 * qty where goods_id='0000000004700' and open_id='1034';update tr_shopcart set price='11.50000000',unit_no='斤',amount=11.50000000 * qty where goods_id='0000000004715' and open_id='1034';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000004718' and open_id='1034';update tr_shopcart set price='3.80000000',unit_no='斤',amount=3.80000000 * qty where goods_id='0000000004720' and open_id='1034';update tr_shopcart set price='2.40000000',unit_no='斤',amount=2.40000000 * qty where goods_id='0000000004729' and open_id='1034';update tr_shopcart set price='6.63000000',unit_no='斤',amount=6.63000000 * qty where goods_id='0000000004742' and open_id='1034';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000004744' and open_id='1034';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000004757' and open_id='1034';update tr_shopcart set price='4.50000000',unit_no='斤',amount=4.50000000 * qty where goods_id='0000000004758' and open_id='1034';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000004761' and open_id='1034';update tr_shopcart set price='1.70000000',unit_no='斤',amount=1.70000000 * qty where goods_id='0000000004769' and open_id='1034';update tr_shopcart set price='4.50000000',unit_no='包',amount=4.50000000 * qty where goods_id='0000000004777' and open_id='1034';update tr_shopcart set price='1.60000000',unit_no='斤',amount=1.60000000 * qty where goods_id='0000000004780' and open_id='1034';update tr_shopcart set price='20.00000000',unit_no='斤',amount=20.00000000 * qty where goods_id='0000000004961' and open_id='1034';update tr_shopcart set price='24.44000000',unit_no='斤',amount=24.44000000 * qty where goods_id='0000000004962' and open_id='1034';update tr_shopcart set price='8.50000000',unit_no='斤',amount=8.50000000 * qty where goods_id='0000000004994' and open_id='1034';update tr_shopcart set price='19.00000000',unit_no='只',amount=19.00000000 * qty where goods_id='0000000005132' and open_id='1034';update tr_shopcart set price='3.60000000',unit_no='斤',amount=3.60000000 * qty where goods_id='0000000005703' and open_id='1034';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005709' and open_id='1034';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000005713' and open_id='1034';update tr_shopcart set price='4.50000000',unit_no='斤',amount=4.50000000 * qty where goods_id='0000000005718' and open_id='1034';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005732' and open_id='1034';update tr_shopcart set price='2.30000000',unit_no='斤',amount=2.30000000 * qty where goods_id='0000000005735' and open_id='1034';update tr_shopcart set price='2.70000000',unit_no='斤',amount=2.70000000 * qty where goods_id='0000000005744' and open_id='1034';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005747' and open_id='1034';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005752' and open_id='1034';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000005754' and open_id='1034';update tr_shopcart set price='7.00000000',unit_no='斤',amount=7.00000000 * qty where goods_id='0000000005756' and open_id='1034';update tr_shopcart set price='3.60000000',unit_no='斤',amount=3.60000000 * qty where goods_id='0000000005757' and open_id='1034';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005759' and open_id='1034';update tr_shopcart set price='7.50000000',unit_no='斤',amount=7.50000000 * qty where goods_id='0000000005763' and open_id='1034';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000005765' and open_id='1034';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000005766' and open_id='1034';update tr_shopcart set price='6.00000000',unit_no='斤',amount=6.00000000 * qty where goods_id='0000000005768' and open_id='1034';update tr_shopcart set price='2.10000000',unit_no='斤',amount=2.10000000 * qty where goods_id='0000000005769' and open_id='1034';update tr_shopcart set price='1.70000000',unit_no='斤',amount=1.70000000 * qty where goods_id='0000000005771' and open_id='1034';update tr_shopcart set price='1.60000000',unit_no='斤',amount=1.60000000 * qty where goods_id='0000000005772' and open_id='1034';update tr_shopcart set price='1.70000000',unit_no='斤',amount=1.70000000 * qty where goods_id='0000000005774' and open_id='1034';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005775' and open_id='1034';update tr_shopcart set price='3.80000000',unit_no='包',amount=3.80000000 * qty where goods_id='0000000005776' and open_id='1034';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000005778' and open_id='1034';update tr_shopcart set price='3.40000000',unit_no='斤',amount=3.40000000 * qty where goods_id='0000000005797' and open_id='1034';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000005799' and open_id='1034';update tr_shopcart set price='3.10000000',unit_no='斤',amount=3.10000000 * qty where goods_id='0000000005800' and open_id='1034';update tr_shopcart set price='1.30000000',unit_no='斤',amount=1.30000000 * qty where goods_id='0000000005809' and open_id='1034';update tr_shopcart set price='3.10000000',unit_no='斤',amount=3.10000000 * qty where goods_id='0000000005810' and open_id='1034';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000005812' and open_id='1034';update tr_shopcart set price='2.00000000',unit_no='斤',amount=2.00000000 * qty where goods_id='0000000005814' and open_id='1034';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000005821' and open_id='1034';update tr_shopcart set price='2.70000000',unit_no='斤',amount=2.70000000 * qty where goods_id='0000000005824' and open_id='1034';update tr_shopcart set price='0.90000000',unit_no='斤',amount=0.90000000 * qty where goods_id='0000000005827' and open_id='1034';update tr_shopcart set price='1.60000000',unit_no='斤',amount=1.60000000 * qty where goods_id='0000000005828' and open_id='1034';update tr_shopcart set price='5.50000000',unit_no='斤',amount=5.50000000 * qty where goods_id='0000000005832' and open_id='1034';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000005838' and open_id='1034';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000005839' and open_id='1034';update tr_shopcart set price='3.40000000',unit_no='斤',amount=3.40000000 * qty where goods_id='0000000005840' and open_id='1034';update tr_shopcart set price='2.10000000',unit_no='斤',amount=2.10000000 * qty where goods_id='0000000005843' and open_id='1034';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000005844' and open_id='1034';update tr_shopcart set price='1.30000000',unit_no='斤',amount=1.30000000 * qty where goods_id='0000000005845' and open_id='1034';update tr_shopcart set price='3.70000000',unit_no='斤',amount=3.70000000 * qty where goods_id='0000000005846' and open_id='1034';update tr_shopcart set price='6.20000000',unit_no='斤',amount=6.20000000 * qty where goods_id='0000000005847' and open_id='1034';update tr_shopcart set price='2.00000000',unit_no='斤',amount=2.00000000 * qty where goods_id='0000000005848' and open_id='1034';update tr_shopcart set price='2.40000000',unit_no='斤',amount=2.40000000 * qty where goods_id='0000000005852' and open_id='1034';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005855' and open_id='1034';update tr_shopcart set price='1.60000000',unit_no='斤',amount=1.60000000 * qty where goods_id='0000000005859' and open_id='1034';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005861' and open_id='1034';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005862' and open_id='1034';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000005863' and open_id='1034';update tr_shopcart set price='6.00000000',unit_no='斤',amount=6.00000000 * qty where goods_id='0000000005864' and open_id='1034';update tr_shopcart set price='2.70000000',unit_no='斤',amount=2.70000000 * qty where goods_id='0000000005867' and open_id='1034';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000005868' and open_id='1034';update tr_shopcart set price='4.40000000',unit_no='斤',amount=4.40000000 * qty where goods_id='0000000005870' and open_id='1034';update tr_shopcart set price='1.50000000',unit_no='斤',amount=1.50000000 * qty where goods_id='0000000005871' and open_id='1034';update tr_shopcart set price='13.50000000',unit_no='斤',amount=13.50000000 * qty where goods_id='0000000005873' and open_id='1034';update tr_shopcart set price='47.00000000',unit_no='斤',amount=47.00000000 * qty where goods_id='0000000005895' and open_id='1034';update tr_shopcart set price='49.50000000',unit_no='斤',amount=49.50000000 * qty where goods_id='0000000005896' and open_id='1034'; [详细] => 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() 在 System.Data.SqlClient.SqlDataReader.get_MetaData() 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteScalar() 在 Db.DBContext.ExecuteScalar(String sql, IDbDataParameter[] pars) 在 Api.BLL.b2b.ShopCartService.GetAll(String oper_id, String supcust_no) 在 Api.SingOut.b2b.mina.shopcart.get_all() [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.shopcart , [方法] => get_all [入参] => ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-06-06 14:39:51 [错误信息] => 事务(进程 ID 67)与另一个进程被死锁在 锁 资源上，并且已被选作死锁牺牲品。请重新运行该事务。 [sql] => update tr_shopcart set price='10.50000000',unit_no='斤',amount=10.50000000 * qty where goods_id='0000000000025' and open_id='1034';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000000027' and open_id='1034';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000000028' and open_id='1034';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000000660' and open_id='1034';update tr_shopcart set price='2.90000000',unit_no='斤',amount=2.90000000 * qty where goods_id='0000000000924' and open_id='1034';update tr_shopcart set price='3.30000000',unit_no='斤',amount=3.30000000 * qty where goods_id='0000000000934' and open_id='1034';update tr_shopcart set price='4.80000000',unit_no='斤',amount=4.80000000 * qty where goods_id='0000000000964' and open_id='1034';update tr_shopcart set price='4.00000000',unit_no='盒',amount=4.00000000 * qty where goods_id='0000000000996' and open_id='1034';update tr_shopcart set price='5.30000000',unit_no='斤',amount=5.30000000 * qty where goods_id='0000000001048' and open_id='1034';update tr_shopcart set price='8.50000000',unit_no='斤',amount=8.50000000 * qty where goods_id='0000000001117' and open_id='1034';update tr_shopcart set price='4.80000000',unit_no='斤',amount=4.80000000 * qty where goods_id='0000000001246' and open_id='1034';update tr_shopcart set price='3.50000000',unit_no='盒',amount=3.50000000 * qty where goods_id='0000000001254' and open_id='1034';update tr_shopcart set price='6.50000000',unit_no='斤',amount=6.50000000 * qty where goods_id='0000000001258' and open_id='1034';update tr_shopcart set price='3.50000000',unit_no='盒',amount=3.50000000 * qty where goods_id='0000000001270' and open_id='1034';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000001276' and open_id='1034';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000001278' and open_id='1034';update tr_shopcart set price='7.00000000',unit_no='斤',amount=7.00000000 * qty where goods_id='0000000001570' and open_id='1034';update tr_shopcart set price='9.00000000',unit_no='斤',amount=9.00000000 * qty where goods_id='0000000001637' and open_id='1034';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000001746' and open_id='1034';update tr_shopcart set price='6.30000000',unit_no='瓶',amount=6.30000000 * qty where goods_id='0000000003142' and open_id='1034';update tr_shopcart set price='6.33000000',unit_no='瓶',amount=6.33000000 * qty where goods_id='0000000003236' and open_id='1034';update tr_shopcart set price='8.11000000',unit_no='瓶',amount=8.11000000 * qty where goods_id='0000000003339' and open_id='1034';update tr_shopcart set price='8.33000000',unit_no='瓶',amount=8.33000000 * qty where goods_id='0000000003342' and open_id='1034';update tr_shopcart set price='6.60000000',unit_no='瓶',amount=6.60000000 * qty where goods_id='0000000003357' and open_id='1034';update tr_shopcart set price='4.67000000',unit_no='瓶',amount=4.67000000 * qty where goods_id='0000000003371' and open_id='1034';update tr_shopcart set price='3.47000000',unit_no='瓶',amount=3.47000000 * qty where goods_id='0000000003436' and open_id='1034';update tr_shopcart set price='10.50000000',unit_no='包',amount=10.50000000 * qty where goods_id='0000000004667' and open_id='1034';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000004688' and open_id='1034';update tr_shopcart set price='4.10000000',unit_no='斤',amount=4.10000000 * qty where goods_id='0000000004697' and open_id='1034';update tr_shopcart set price='16.50000000',unit_no='斤',amount=16.50000000 * qty where goods_id='0000000004700' and open_id='1034';update tr_shopcart set price='11.50000000',unit_no='斤',amount=11.50000000 * qty where goods_id='0000000004715' and open_id='1034';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000004718' and open_id='1034';update tr_shopcart set price='3.80000000',unit_no='斤',amount=3.80000000 * qty where goods_id='0000000004720' and open_id='1034';update tr_shopcart set price='7.50000000',unit_no='斤',amount=7.50000000 * qty where goods_id='0000000004725' and open_id='1034';update tr_shopcart set price='2.40000000',unit_no='斤',amount=2.40000000 * qty where goods_id='0000000004729' and open_id='1034';update tr_shopcart set price='6.63000000',unit_no='斤',amount=6.63000000 * qty where goods_id='0000000004742' and open_id='1034';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000004744' and open_id='1034';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000004757' and open_id='1034';update tr_shopcart set price='4.50000000',unit_no='斤',amount=4.50000000 * qty where goods_id='0000000004758' and open_id='1034';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000004761' and open_id='1034';update tr_shopcart set price='1.70000000',unit_no='斤',amount=1.70000000 * qty where goods_id='0000000004769' and open_id='1034';update tr_shopcart set price='4.50000000',unit_no='包',amount=4.50000000 * qty where goods_id='0000000004777' and open_id='1034';update tr_shopcart set price='1.60000000',unit_no='斤',amount=1.60000000 * qty where goods_id='0000000004780' and open_id='1034';update tr_shopcart set price='20.00000000',unit_no='斤',amount=20.00000000 * qty where goods_id='0000000004961' and open_id='1034';update tr_shopcart set price='24.44000000',unit_no='斤',amount=24.44000000 * qty where goods_id='0000000004962' and open_id='1034';update tr_shopcart set price='8.50000000',unit_no='斤',amount=8.50000000 * qty where goods_id='0000000004994' and open_id='1034';update tr_shopcart set price='19.00000000',unit_no='只',amount=19.00000000 * qty where goods_id='0000000005132' and open_id='1034';update tr_shopcart set price='3.60000000',unit_no='斤',amount=3.60000000 * qty where goods_id='0000000005703' and open_id='1034';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005709' and open_id='1034';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000005713' and open_id='1034';update tr_shopcart set price='4.50000000',unit_no='斤',amount=4.50000000 * qty where goods_id='0000000005718' and open_id='1034';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005732' and open_id='1034';update tr_shopcart set price='2.30000000',unit_no='斤',amount=2.30000000 * qty where goods_id='0000000005735' and open_id='1034';update tr_shopcart set price='2.70000000',unit_no='斤',amount=2.70000000 * qty where goods_id='0000000005744' and open_id='1034';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005747' and open_id='1034';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005752' and open_id='1034';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000005754' and open_id='1034';update tr_shopcart set price='7.00000000',unit_no='斤',amount=7.00000000 * qty where goods_id='0000000005756' and open_id='1034';update tr_shopcart set price='3.60000000',unit_no='斤',amount=3.60000000 * qty where goods_id='0000000005757' and open_id='1034';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005759' and open_id='1034';update tr_shopcart set price='7.50000000',unit_no='斤',amount=7.50000000 * qty where goods_id='0000000005763' and open_id='1034';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000005765' and open_id='1034';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000005766' and open_id='1034';update tr_shopcart set price='6.00000000',unit_no='斤',amount=6.00000000 * qty where goods_id='0000000005768' and open_id='1034';update tr_shopcart set price='2.10000000',unit_no='斤',amount=2.10000000 * qty where goods_id='0000000005769' and open_id='1034';update tr_shopcart set price='1.70000000',unit_no='斤',amount=1.70000000 * qty where goods_id='0000000005771' and open_id='1034';update tr_shopcart set price='1.60000000',unit_no='斤',amount=1.60000000 * qty where goods_id='0000000005772' and open_id='1034';update tr_shopcart set price='1.70000000',unit_no='斤',amount=1.70000000 * qty where goods_id='0000000005774' and open_id='1034';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005775' and open_id='1034';update tr_shopcart set price='3.80000000',unit_no='包',amount=3.80000000 * qty where goods_id='0000000005776' and open_id='1034';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000005778' and open_id='1034';update tr_shopcart set price='3.40000000',unit_no='斤',amount=3.40000000 * qty where goods_id='0000000005797' and open_id='1034';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000005799' and open_id='1034';update tr_shopcart set price='3.10000000',unit_no='斤',amount=3.10000000 * qty where goods_id='0000000005800' and open_id='1034';update tr_shopcart set price='1.30000000',unit_no='斤',amount=1.30000000 * qty where goods_id='0000000005809' and open_id='1034';update tr_shopcart set price='3.10000000',unit_no='斤',amount=3.10000000 * qty where goods_id='0000000005810' and open_id='1034';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000005812' and open_id='1034';update tr_shopcart set price='2.00000000',unit_no='斤',amount=2.00000000 * qty where goods_id='0000000005814' and open_id='1034';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000005821' and open_id='1034';update tr_shopcart set price='2.70000000',unit_no='斤',amount=2.70000000 * qty where goods_id='0000000005824' and open_id='1034';update tr_shopcart set price='0.90000000',unit_no='斤',amount=0.90000000 * qty where goods_id='0000000005827' and open_id='1034';update tr_shopcart set price='1.60000000',unit_no='斤',amount=1.60000000 * qty where goods_id='0000000005828' and open_id='1034';update tr_shopcart set price='5.50000000',unit_no='斤',amount=5.50000000 * qty where goods_id='0000000005832' and open_id='1034';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000005838' and open_id='1034';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000005839' and open_id='1034';update tr_shopcart set price='3.40000000',unit_no='斤',amount=3.40000000 * qty where goods_id='0000000005840' and open_id='1034';update tr_shopcart set price='2.10000000',unit_no='斤',amount=2.10000000 * qty where goods_id='0000000005843' and open_id='1034';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000005844' and open_id='1034';update tr_shopcart set price='1.30000000',unit_no='斤',amount=1.30000000 * qty where goods_id='0000000005845' and open_id='1034';update tr_shopcart set price='3.70000000',unit_no='斤',amount=3.70000000 * qty where goods_id='0000000005846' and open_id='1034';update tr_shopcart set price='6.20000000',unit_no='斤',amount=6.20000000 * qty where goods_id='0000000005847' and open_id='1034';update tr_shopcart set price='2.00000000',unit_no='斤',amount=2.00000000 * qty where goods_id='0000000005848' and open_id='1034';update tr_shopcart set price='2.40000000',unit_no='斤',amount=2.40000000 * qty where goods_id='0000000005852' and open_id='1034';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005855' and open_id='1034';update tr_shopcart set price='1.60000000',unit_no='斤',amount=1.60000000 * qty where goods_id='0000000005859' and open_id='1034';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005861' and open_id='1034';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005862' and open_id='1034';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000005863' and open_id='1034';update tr_shopcart set price='6.00000000',unit_no='斤',amount=6.00000000 * qty where goods_id='0000000005864' and open_id='1034';update tr_shopcart set price='2.70000000',unit_no='斤',amount=2.70000000 * qty where goods_id='0000000005867' and open_id='1034';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000005868' and open_id='1034';update tr_shopcart set price='4.40000000',unit_no='斤',amount=4.40000000 * qty where goods_id='0000000005870' and open_id='1034';update tr_shopcart set price='1.50000000',unit_no='斤',amount=1.50000000 * qty where goods_id='0000000005871' and open_id='1034';update tr_shopcart set price='13.50000000',unit_no='斤',amount=13.50000000 * qty where goods_id='0000000005873' and open_id='1034';update tr_shopcart set price='47.00000000',unit_no='斤',amount=47.00000000 * qty where goods_id='0000000005895' and open_id='1034';update tr_shopcart set price='49.50000000',unit_no='斤',amount=49.50000000 * qty where goods_id='0000000005896' and open_id='1034'; [详细] => 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() 在 System.Data.SqlClient.SqlDataReader.get_MetaData() 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteScalar() 在 Db.DBContext.ExecuteScalar(String sql, IDbDataParameter[] pars) 在 Api.BLL.b2b.ShopCartService.GetAll(String oper_id, String supcust_no) 在 Api.SingOut.b2b.mina.shopcart.get_all() [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.shopcart , [方法] => get_all [入参] => ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-06-06 14:40:05 [错误信息] => 事务(进程 ID 67)与另一个进程被死锁在 锁 资源上，并且已被选作死锁牺牲品。请重新运行该事务。 [sql] => update tr_shopcart set price='10.50000000',unit_no='斤',amount=10.50000000 * qty where goods_id='0000000000025' and open_id='1034';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000000027' and open_id='1034';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000000028' and open_id='1034';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000000660' and open_id='1034';update tr_shopcart set price='2.90000000',unit_no='斤',amount=2.90000000 * qty where goods_id='0000000000924' and open_id='1034';update tr_shopcart set price='3.30000000',unit_no='斤',amount=3.30000000 * qty where goods_id='0000000000934' and open_id='1034';update tr_shopcart set price='4.80000000',unit_no='斤',amount=4.80000000 * qty where goods_id='0000000000964' and open_id='1034';update tr_shopcart set price='4.00000000',unit_no='盒',amount=4.00000000 * qty where goods_id='0000000000996' and open_id='1034';update tr_shopcart set price='5.30000000',unit_no='斤',amount=5.30000000 * qty where goods_id='0000000001048' and open_id='1034';update tr_shopcart set price='8.50000000',unit_no='斤',amount=8.50000000 * qty where goods_id='0000000001117' and open_id='1034';update tr_shopcart set price='4.80000000',unit_no='斤',amount=4.80000000 * qty where goods_id='0000000001246' and open_id='1034';update tr_shopcart set price='3.50000000',unit_no='盒',amount=3.50000000 * qty where goods_id='0000000001254' and open_id='1034';update tr_shopcart set price='6.50000000',unit_no='斤',amount=6.50000000 * qty where goods_id='0000000001258' and open_id='1034';update tr_shopcart set price='3.50000000',unit_no='盒',amount=3.50000000 * qty where goods_id='0000000001270' and open_id='1034';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000001276' and open_id='1034';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000001278' and open_id='1034';update tr_shopcart set price='7.00000000',unit_no='斤',amount=7.00000000 * qty where goods_id='0000000001570' and open_id='1034';update tr_shopcart set price='9.00000000',unit_no='斤',amount=9.00000000 * qty where goods_id='0000000001637' and open_id='1034';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000001746' and open_id='1034';update tr_shopcart set price='6.30000000',unit_no='瓶',amount=6.30000000 * qty where goods_id='0000000003142' and open_id='1034';update tr_shopcart set price='6.33000000',unit_no='瓶',amount=6.33000000 * qty where goods_id='0000000003236' and open_id='1034';update tr_shopcart set price='8.11000000',unit_no='瓶',amount=8.11000000 * qty where goods_id='0000000003339' and open_id='1034';update tr_shopcart set price='8.33000000',unit_no='瓶',amount=8.33000000 * qty where goods_id='0000000003342' and open_id='1034';update tr_shopcart set price='6.60000000',unit_no='瓶',amount=6.60000000 * qty where goods_id='0000000003357' and open_id='1034';update tr_shopcart set price='4.67000000',unit_no='瓶',amount=4.67000000 * qty where goods_id='0000000003371' and open_id='1034';update tr_shopcart set price='3.47000000',unit_no='瓶',amount=3.47000000 * qty where goods_id='0000000003436' and open_id='1034';update tr_shopcart set price='10.50000000',unit_no='包',amount=10.50000000 * qty where goods_id='0000000004667' and open_id='1034';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000004688' and open_id='1034';update tr_shopcart set price='4.10000000',unit_no='斤',amount=4.10000000 * qty where goods_id='0000000004697' and open_id='1034';update tr_shopcart set price='16.50000000',unit_no='斤',amount=16.50000000 * qty where goods_id='0000000004700' and open_id='1034';update tr_shopcart set price='11.50000000',unit_no='斤',amount=11.50000000 * qty where goods_id='0000000004715' and open_id='1034';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000004718' and open_id='1034';update tr_shopcart set price='3.80000000',unit_no='斤',amount=3.80000000 * qty where goods_id='0000000004720' and open_id='1034';update tr_shopcart set price='7.50000000',unit_no='斤',amount=7.50000000 * qty where goods_id='0000000004725' and open_id='1034';update tr_shopcart set price='2.40000000',unit_no='斤',amount=2.40000000 * qty where goods_id='0000000004729' and open_id='1034';update tr_shopcart set price='6.63000000',unit_no='斤',amount=6.63000000 * qty where goods_id='0000000004742' and open_id='1034';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000004744' and open_id='1034';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000004757' and open_id='1034';update tr_shopcart set price='4.50000000',unit_no='斤',amount=4.50000000 * qty where goods_id='0000000004758' and open_id='1034';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000004761' and open_id='1034';update tr_shopcart set price='1.70000000',unit_no='斤',amount=1.70000000 * qty where goods_id='0000000004769' and open_id='1034';update tr_shopcart set price='4.50000000',unit_no='包',amount=4.50000000 * qty where goods_id='0000000004777' and open_id='1034';update tr_shopcart set price='1.60000000',unit_no='斤',amount=1.60000000 * qty where goods_id='0000000004780' and open_id='1034';update tr_shopcart set price='20.00000000',unit_no='斤',amount=20.00000000 * qty where goods_id='0000000004961' and open_id='1034';update tr_shopcart set price='24.44000000',unit_no='斤',amount=24.44000000 * qty where goods_id='0000000004962' and open_id='1034';update tr_shopcart set price='8.50000000',unit_no='斤',amount=8.50000000 * qty where goods_id='0000000004994' and open_id='1034';update tr_shopcart set price='19.00000000',unit_no='只',amount=19.00000000 * qty where goods_id='0000000005132' and open_id='1034';update tr_shopcart set price='7.00000000',unit_no='斤',amount=7.00000000 * qty where goods_id='0000000005692' and open_id='1034';update tr_shopcart set price='3.60000000',unit_no='斤',amount=3.60000000 * qty where goods_id='0000000005703' and open_id='1034';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005709' and open_id='1034';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000005713' and open_id='1034';update tr_shopcart set price='4.50000000',unit_no='斤',amount=4.50000000 * qty where goods_id='0000000005718' and open_id='1034';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005732' and open_id='1034';update tr_shopcart set price='2.30000000',unit_no='斤',amount=2.30000000 * qty where goods_id='0000000005735' and open_id='1034';update tr_shopcart set price='2.70000000',unit_no='斤',amount=2.70000000 * qty where goods_id='0000000005744' and open_id='1034';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005747' and open_id='1034';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005752' and open_id='1034';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000005754' and open_id='1034';update tr_shopcart set price='7.00000000',unit_no='斤',amount=7.00000000 * qty where goods_id='0000000005756' and open_id='1034';update tr_shopcart set price='3.60000000',unit_no='斤',amount=3.60000000 * qty where goods_id='0000000005757' and open_id='1034';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005759' and open_id='1034';update tr_shopcart set price='7.50000000',unit_no='斤',amount=7.50000000 * qty where goods_id='0000000005763' and open_id='1034';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000005765' and open_id='1034';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000005766' and open_id='1034';update tr_shopcart set price='6.00000000',unit_no='斤',amount=6.00000000 * qty where goods_id='0000000005768' and open_id='1034';update tr_shopcart set price='2.10000000',unit_no='斤',amount=2.10000000 * qty where goods_id='0000000005769' and open_id='1034';update tr_shopcart set price='1.70000000',unit_no='斤',amount=1.70000000 * qty where goods_id='0000000005771' and open_id='1034';update tr_shopcart set price='1.60000000',unit_no='斤',amount=1.60000000 * qty where goods_id='0000000005772' and open_id='1034';update tr_shopcart set price='1.70000000',unit_no='斤',amount=1.70000000 * qty where goods_id='0000000005774' and open_id='1034';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005775' and open_id='1034';update tr_shopcart set price='3.80000000',unit_no='包',amount=3.80000000 * qty where goods_id='0000000005776' and open_id='1034';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000005778' and open_id='1034';update tr_shopcart set price='3.40000000',unit_no='斤',amount=3.40000000 * qty where goods_id='0000000005797' and open_id='1034';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000005799' and open_id='1034';update tr_shopcart set price='3.10000000',unit_no='斤',amount=3.10000000 * qty where goods_id='0000000005800' and open_id='1034';update tr_shopcart set price='1.30000000',unit_no='斤',amount=1.30000000 * qty where goods_id='0000000005809' and open_id='1034';update tr_shopcart set price='3.10000000',unit_no='斤',amount=3.10000000 * qty where goods_id='0000000005810' and open_id='1034';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000005812' and open_id='1034';update tr_shopcart set price='2.00000000',unit_no='斤',amount=2.00000000 * qty where goods_id='0000000005814' and open_id='1034';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000005821' and open_id='1034';update tr_shopcart set price='2.70000000',unit_no='斤',amount=2.70000000 * qty where goods_id='0000000005824' and open_id='1034';update tr_shopcart set price='0.90000000',unit_no='斤',amount=0.90000000 * qty where goods_id='0000000005827' and open_id='1034';update tr_shopcart set price='1.60000000',unit_no='斤',amount=1.60000000 * qty where goods_id='0000000005828' and open_id='1034';update tr_shopcart set price='5.50000000',unit_no='斤',amount=5.50000000 * qty where goods_id='0000000005832' and open_id='1034';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000005838' and open_id='1034';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000005839' and open_id='1034';update tr_shopcart set price='3.40000000',unit_no='斤',amount=3.40000000 * qty where goods_id='0000000005840' and open_id='1034';update tr_shopcart set price='2.10000000',unit_no='斤',amount=2.10000000 * qty where goods_id='0000000005843' and open_id='1034';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000005844' and open_id='1034';update tr_shopcart set price='1.30000000',unit_no='斤',amount=1.30000000 * qty where goods_id='0000000005845' and open_id='1034';update tr_shopcart set price='3.70000000',unit_no='斤',amount=3.70000000 * qty where goods_id='0000000005846' and open_id='1034';update tr_shopcart set price='6.20000000',unit_no='斤',amount=6.20000000 * qty where goods_id='0000000005847' and open_id='1034';update tr_shopcart set price='2.00000000',unit_no='斤',amount=2.00000000 * qty where goods_id='0000000005848' and open_id='1034';update tr_shopcart set price='2.40000000',unit_no='斤',amount=2.40000000 * qty where goods_id='0000000005852' and open_id='1034';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005855' and open_id='1034';update tr_shopcart set price='1.60000000',unit_no='斤',amount=1.60000000 * qty where goods_id='0000000005859' and open_id='1034';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005861' and open_id='1034';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005862' and open_id='1034';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000005863' and open_id='1034';update tr_shopcart set price='6.00000000',unit_no='斤',amount=6.00000000 * qty where goods_id='0000000005864' and open_id='1034';update tr_shopcart set price='2.70000000',unit_no='斤',amount=2.70000000 * qty where goods_id='0000000005867' and open_id='1034';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000005868' and open_id='1034';update tr_shopcart set price='4.40000000',unit_no='斤',amount=4.40000000 * qty where goods_id='0000000005870' and open_id='1034';update tr_shopcart set price='1.50000000',unit_no='斤',amount=1.50000000 * qty where goods_id='0000000005871' and open_id='1034';update tr_shopcart set price='13.50000000',unit_no='斤',amount=13.50000000 * qty where goods_id='0000000005873' and open_id='1034';update tr_shopcart set price='47.00000000',unit_no='斤',amount=47.00000000 * qty where goods_id='0000000005895' and open_id='1034';update tr_shopcart set price='49.50000000',unit_no='斤',amount=49.50000000 * qty where goods_id='0000000005896' and open_id='1034'; [详细] => 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() 在 System.Data.SqlClient.SqlDataReader.get_MetaData() 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteScalar() 在 Db.DBContext.ExecuteScalar(String sql, IDbDataParameter[] pars) 在 Api.BLL.b2b.ShopCartService.GetAll(String oper_id, String supcust_no) 在 Api.SingOut.b2b.mina.shopcart.get_all() [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.shopcart , [方法] => get_all [入参] => ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-06-06 14:40:38 [错误信息] => 事务(进程 ID 67)与另一个进程被死锁在 锁 资源上，并且已被选作死锁牺牲品。请重新运行该事务。 [sql] => update tr_shopcart set price='10.50000000',unit_no='斤',amount=10.50000000 * qty where goods_id='0000000000025' and open_id='1034';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000000027' and open_id='1034';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000000028' and open_id='1034';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000000660' and open_id='1034';update tr_shopcart set price='2.90000000',unit_no='斤',amount=2.90000000 * qty where goods_id='0000000000924' and open_id='1034';update tr_shopcart set price='3.30000000',unit_no='斤',amount=3.30000000 * qty where goods_id='0000000000934' and open_id='1034';update tr_shopcart set price='4.80000000',unit_no='斤',amount=4.80000000 * qty where goods_id='0000000000964' and open_id='1034';update tr_shopcart set price='4.00000000',unit_no='盒',amount=4.00000000 * qty where goods_id='0000000000996' and open_id='1034';update tr_shopcart set price='5.30000000',unit_no='斤',amount=5.30000000 * qty where goods_id='0000000001048' and open_id='1034';update tr_shopcart set price='8.50000000',unit_no='斤',amount=8.50000000 * qty where goods_id='0000000001117' and open_id='1034';update tr_shopcart set price='4.80000000',unit_no='斤',amount=4.80000000 * qty where goods_id='0000000001246' and open_id='1034';update tr_shopcart set price='3.50000000',unit_no='盒',amount=3.50000000 * qty where goods_id='0000000001254' and open_id='1034';update tr_shopcart set price='6.50000000',unit_no='斤',amount=6.50000000 * qty where goods_id='0000000001258' and open_id='1034';update tr_shopcart set price='3.50000000',unit_no='盒',amount=3.50000000 * qty where goods_id='0000000001270' and open_id='1034';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000001276' and open_id='1034';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000001278' and open_id='1034';update tr_shopcart set price='7.00000000',unit_no='斤',amount=7.00000000 * qty where goods_id='0000000001570' and open_id='1034';update tr_shopcart set price='9.00000000',unit_no='斤',amount=9.00000000 * qty where goods_id='0000000001637' and open_id='1034';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000001746' and open_id='1034';update tr_shopcart set price='6.30000000',unit_no='瓶',amount=6.30000000 * qty where goods_id='0000000003142' and open_id='1034';update tr_shopcart set price='6.33000000',unit_no='瓶',amount=6.33000000 * qty where goods_id='0000000003236' and open_id='1034';update tr_shopcart set price='8.11000000',unit_no='瓶',amount=8.11000000 * qty where goods_id='0000000003339' and open_id='1034';update tr_shopcart set price='8.33000000',unit_no='瓶',amount=8.33000000 * qty where goods_id='0000000003342' and open_id='1034';update tr_shopcart set price='6.60000000',unit_no='瓶',amount=6.60000000 * qty where goods_id='0000000003357' and open_id='1034';update tr_shopcart set price='4.67000000',unit_no='瓶',amount=4.67000000 * qty where goods_id='0000000003371' and open_id='1034';update tr_shopcart set price='3.47000000',unit_no='瓶',amount=3.47000000 * qty where goods_id='0000000003436' and open_id='1034';update tr_shopcart set price='10.50000000',unit_no='包',amount=10.50000000 * qty where goods_id='0000000004667' and open_id='1034';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000004688' and open_id='1034';update tr_shopcart set price='4.10000000',unit_no='斤',amount=4.10000000 * qty where goods_id='0000000004697' and open_id='1034';update tr_shopcart set price='16.50000000',unit_no='斤',amount=16.50000000 * qty where goods_id='0000000004700' and open_id='1034';update tr_shopcart set price='11.50000000',unit_no='斤',amount=11.50000000 * qty where goods_id='0000000004715' and open_id='1034';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000004718' and open_id='1034';update tr_shopcart set price='3.80000000',unit_no='斤',amount=3.80000000 * qty where goods_id='0000000004720' and open_id='1034';update tr_shopcart set price='7.50000000',unit_no='斤',amount=7.50000000 * qty where goods_id='0000000004725' and open_id='1034';update tr_shopcart set price='2.40000000',unit_no='斤',amount=2.40000000 * qty where goods_id='0000000004729' and open_id='1034';update tr_shopcart set price='6.63000000',unit_no='斤',amount=6.63000000 * qty where goods_id='0000000004742' and open_id='1034';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000004744' and open_id='1034';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000004757' and open_id='1034';update tr_shopcart set price='4.50000000',unit_no='斤',amount=4.50000000 * qty where goods_id='0000000004758' and open_id='1034';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000004761' and open_id='1034';update tr_shopcart set price='1.70000000',unit_no='斤',amount=1.70000000 * qty where goods_id='0000000004769' and open_id='1034';update tr_shopcart set price='4.50000000',unit_no='包',amount=4.50000000 * qty where goods_id='0000000004777' and open_id='1034';update tr_shopcart set price='1.60000000',unit_no='斤',amount=1.60000000 * qty where goods_id='0000000004780' and open_id='1034';update tr_shopcart set price='20.00000000',unit_no='斤',amount=20.00000000 * qty where goods_id='0000000004961' and open_id='1034';update tr_shopcart set price='24.44000000',unit_no='斤',amount=24.44000000 * qty where goods_id='0000000004962' and open_id='1034';update tr_shopcart set price='8.50000000',unit_no='斤',amount=8.50000000 * qty where goods_id='0000000004994' and open_id='1034';update tr_shopcart set price='19.00000000',unit_no='只',amount=19.00000000 * qty where goods_id='0000000005132' and open_id='1034';update tr_shopcart set price='7.00000000',unit_no='斤',amount=7.00000000 * qty where goods_id='0000000005692' and open_id='1034';update tr_shopcart set price='3.60000000',unit_no='斤',amount=3.60000000 * qty where goods_id='0000000005703' and open_id='1034';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005709' and open_id='1034';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000005713' and open_id='1034';update tr_shopcart set price='4.50000000',unit_no='斤',amount=4.50000000 * qty where goods_id='0000000005718' and open_id='1034';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005732' and open_id='1034';update tr_shopcart set price='2.30000000',unit_no='斤',amount=2.30000000 * qty where goods_id='0000000005735' and open_id='1034';update tr_shopcart set price='2.70000000',unit_no='斤',amount=2.70000000 * qty where goods_id='0000000005744' and open_id='1034';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005747' and open_id='1034';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005752' and open_id='1034';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000005754' and open_id='1034';update tr_shopcart set price='7.00000000',unit_no='斤',amount=7.00000000 * qty where goods_id='0000000005756' and open_id='1034';update tr_shopcart set price='3.60000000',unit_no='斤',amount=3.60000000 * qty where goods_id='0000000005757' and open_id='1034';update tr_shopcart set price='2.80000000',unit_no='斤',amount=2.80000000 * qty where goods_id='0000000005759' and open_id='1034';update tr_shopcart set price='7.50000000',unit_no='斤',amount=7.50000000 * qty where goods_id='0000000005763' and open_id='1034';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000005765' and open_id='1034';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000005766' and open_id='1034';update tr_shopcart set price='6.00000000',unit_no='斤',amount=6.00000000 * qty where goods_id='0000000005768' and open_id='1034';update tr_shopcart set price='2.10000000',unit_no='斤',amount=2.10000000 * qty where goods_id='0000000005769' and open_id='1034';update tr_shopcart set price='1.70000000',unit_no='斤',amount=1.70000000 * qty where goods_id='0000000005771' and open_id='1034';update tr_shopcart set price='1.60000000',unit_no='斤',amount=1.60000000 * qty where goods_id='0000000005772' and open_id='1034';update tr_shopcart set price='1.70000000',unit_no='斤',amount=1.70000000 * qty where goods_id='0000000005774' and open_id='1034';update tr_shopcart set price='3.00000000',unit_no='斤',amount=3.00000000 * qty where goods_id='0000000005775' and open_id='1034';update tr_shopcart set price='3.80000000',unit_no='包',amount=3.80000000 * qty where goods_id='0000000005776' and open_id='1034';update tr_shopcart set price='1.20000000',unit_no='斤',amount=1.20000000 * qty where goods_id='0000000005778' and open_id='1034';update tr_shopcart set price='3.40000000',unit_no='斤',amount=3.40000000 * qty where goods_id='0000000005797' and open_id='1034';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000005799' and open_id='1034';update tr_shopcart set price='3.10000000',unit_no='斤',amount=3.10000000 * qty where goods_id='0000000005800' and open_id='1034';update tr_shopcart set price='1.30000000',unit_no='斤',amount=1.30000000 * qty where goods_id='0000000005809' and open_id='1034';update tr_shopcart set price='3.10000000',unit_no='斤',amount=3.10000000 * qty where goods_id='0000000005810' and open_id='1034';update tr_shopcart set price='5.00000000',unit_no='斤',amount=5.00000000 * qty where goods_id='0000000005812' and open_id='1034';update tr_shopcart set price='2.00000000',unit_no='斤',amount=2.00000000 * qty where goods_id='0000000005814' and open_id='1034';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000005821' and open_id='1034';update tr_shopcart set price='2.70000000',unit_no='斤',amount=2.70000000 * qty where goods_id='0000000005824' and open_id='1034';update tr_shopcart set price='0.90000000',unit_no='斤',amount=0.90000000 * qty where goods_id='0000000005827' and open_id='1034';update tr_shopcart set price='1.60000000',unit_no='斤',amount=1.60000000 * qty where goods_id='0000000005828' and open_id='1034';update tr_shopcart set price='4.20000000',unit_no='斤',amount=4.20000000 * qty where goods_id='0000000005830' and open_id='1034';update tr_shopcart set price='5.50000000',unit_no='斤',amount=5.50000000 * qty where goods_id='0000000005832' and open_id='1034';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000005838' and open_id='1034';update tr_shopcart set price='2.50000000',unit_no='斤',amount=2.50000000 * qty where goods_id='0000000005839' and open_id='1034';update tr_shopcart set price='3.40000000',unit_no='斤',amount=3.40000000 * qty where goods_id='0000000005840' and open_id='1034';update tr_shopcart set price='2.10000000',unit_no='斤',amount=2.10000000 * qty where goods_id='0000000005843' and open_id='1034';update tr_shopcart set price='2.60000000',unit_no='斤',amount=2.60000000 * qty where goods_id='0000000005844' and open_id='1034';update tr_shopcart set price='1.30000000',unit_no='斤',amount=1.30000000 * qty where goods_id='0000000005845' and open_id='1034';update tr_shopcart set price='3.70000000',unit_no='斤',amount=3.70000000 * qty where goods_id='0000000005846' and open_id='1034';update tr_shopcart set price='6.20000000',unit_no='斤',amount=6.20000000 * qty where goods_id='0000000005847' and open_id='1034';update tr_shopcart set price='2.00000000',unit_no='斤',amount=2.00000000 * qty where goods_id='0000000005848' and open_id='1034';update tr_shopcart set price='2.40000000',unit_no='斤',amount=2.40000000 * qty where goods_id='0000000005852' and open_id='1034';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005855' and open_id='1034';update tr_shopcart set price='1.60000000',unit_no='斤',amount=1.60000000 * qty where goods_id='0000000005859' and open_id='1034';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005861' and open_id='1034';update tr_shopcart set price='1.80000000',unit_no='斤',amount=1.80000000 * qty where goods_id='0000000005862' and open_id='1034';update tr_shopcart set price='4.00000000',unit_no='斤',amount=4.00000000 * qty where goods_id='0000000005863' and open_id='1034';update tr_shopcart set price='6.00000000',unit_no='斤',amount=6.00000000 * qty where goods_id='0000000005864' and open_id='1034';update tr_shopcart set price='2.70000000',unit_no='斤',amount=2.70000000 * qty where goods_id='0000000005867' and open_id='1034';update tr_shopcart set price='3.50000000',unit_no='斤',amount=3.50000000 * qty where goods_id='0000000005868' and open_id='1034';update tr_shopcart set price='4.40000000',unit_no='斤',amount=4.40000000 * qty where goods_id='0000000005870' and open_id='1034';update tr_shopcart set price='1.50000000',unit_no='斤',amount=1.50000000 * qty where goods_id='0000000005871' and open_id='1034';update tr_shopcart set price='13.50000000',unit_no='斤',amount=13.50000000 * qty where goods_id='0000000005873' and open_id='1034';update tr_shopcart set price='47.00000000',unit_no='斤',amount=47.00000000 * qty where goods_id='0000000005895' and open_id='1034';update tr_shopcart set price='49.50000000',unit_no='斤',amount=49.50000000 * qty where goods_id='0000000005896' and open_id='1034'; [详细] => 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() 在 System.Data.SqlClient.SqlDataReader.get_MetaData() 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteScalar() 在 Db.DBContext.ExecuteScalar(String sql, IDbDataParameter[] pars) 在 Api.BLL.b2b.ShopCartService.GetAll(String oper_id, String supcust_no) 在 Api.SingOut.b2b.mina.shopcart.get_all() [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.shopcart , [方法] => get_all [入参] => ************************************************************************************** **************************mima_b2b_Login()2022/6/6 14:58:08************************* paramter0:1001 paramter1:oDppT5HV_-d-YmDcc9Od4IPlRyr0 Api.Helper.Exceptions.KatException: 密码错误 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-06-06 14:58:08 [错误信息] => 密码错误 [sql] => select a.oper_id, a.oper_name, a.oper_pwd, a.open_id, (case when isnull(c.cust_level, 1) = '' then '1' else isnull(c.cust_level, 1) end) as cus_level, c.is_branch, b.supcust_no, c.supcust_group from sa_t_mobile_oper as a inner join sa_t_mobile_data_main as b on a.oper_id = b.oper_id left join bi_t_supcust_info as c on b.supcust_no = c.supcust_no where a.oper_id = '1001' or a.login_no = '1001' [详细] => 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) 在 Api.SingOut.b2b.mina.oper.login(String card_id, String vip_pass, String is_bind, String open_id) [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.oper , [方法] => login [入参] => {"card_id":"1001","vip_pass":"a123456","is_bind":"1","open_id":"oDppT5HV_-d-YmDcc9Od4IPlRyr0"} ************************************************************************************** **************************mima_b2b_Login()2022/6/6 15:51:01************************* paramter0:1036 paramter1:oDppT5EAa-Q21_CQSR43MhBPLTkc Api.Helper.Exceptions.KatException: 密码错误 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-06-06 15:51:01 [错误信息] => 密码错误 [sql] => select a.oper_id, a.oper_name, a.oper_pwd, a.open_id, (case when isnull(c.cust_level, 1) = '' then '1' else isnull(c.cust_level, 1) end) as cus_level, c.is_branch, b.supcust_no, c.supcust_group from sa_t_mobile_oper as a inner join sa_t_mobile_data_main as b on a.oper_id = b.oper_id left join bi_t_supcust_info as c on b.supcust_no = c.supcust_no where a.oper_id = '1036' or a.login_no = '1036' [详细] => 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) 在 Api.SingOut.b2b.mina.oper.login(String card_id, String vip_pass, String is_bind, String open_id) [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.oper , [方法] => login [入参] => {"card_id":"1036","vip_pass":"123457","is_bind":"1","open_id":"oDppT5EAa-Q21_CQSR43MhBPLTkc"} ************************************************************************************** **************************mima_b2b_Login()2022/6/6 16:15:22************************* paramter0:19902482269 paramter1:oDppT5HV_-d-YmDcc9Od4IPlRyr0 Api.Helper.Exceptions.KatException: 用户不存在 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-06-06 16:15:22 [错误信息] => 用户不存在 [sql] => select a.oper_id, a.oper_name, a.oper_pwd, a.open_id, (case when isnull(c.cust_level, 1) = '' then '1' else isnull(c.cust_level, 1) end) as cus_level, c.is_branch, b.supcust_no, c.supcust_group from sa_t_mobile_oper as a inner join sa_t_mobile_data_main as b on a.oper_id = b.oper_id left join bi_t_supcust_info as c on b.supcust_no = c.supcust_no where a.oper_id = '19902482269' or a.login_no = '19902482269' [详细] => 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) 在 Api.SingOut.b2b.mina.oper.login(String card_id, String vip_pass, String is_bind, String open_id) [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.oper , [方法] => login [入参] => {"card_id":"19902482269","vip_pass":"a123456","is_bind":"1","open_id":"oDppT5HV_-d-YmDcc9Od4IPlRyr0"} ************************************************************************************** **************************mima_b2b_Login()2022/6/6 16:15:34************************* paramter0:19902482269 paramter1:oDppT5HV_-d-YmDcc9Od4IPlRyr0 Api.Helper.Exceptions.KatException: 用户不存在 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-06-06 16:15:34 [错误信息] => 用户不存在 [sql] => select a.oper_id, a.oper_name, a.oper_pwd, a.open_id, (case when isnull(c.cust_level, 1) = '' then '1' else isnull(c.cust_level, 1) end) as cus_level, c.is_branch, b.supcust_no, c.supcust_group from sa_t_mobile_oper as a inner join sa_t_mobile_data_main as b on a.oper_id = b.oper_id left join bi_t_supcust_info as c on b.supcust_no = c.supcust_no where a.oper_id = '19902482269' or a.login_no = '19902482269' [详细] => 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) 在 Api.SingOut.b2b.mina.oper.login(String card_id, String vip_pass, String is_bind, String open_id) [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.oper , [方法] => login [入参] => {"card_id":"19902482269","vip_pass":"a123456","is_bind":"1","open_id":"oDppT5HV_-d-YmDcc9Od4IPlRyr0"} ************************************************************************************** **************************mima_b2b_Login()2022/6/6 16:22:21************************* paramter0:1037 paramter1:oDppT5EQLOkOajTISdXvjjOVCebs Api.Helper.Exceptions.KatException: 密码错误 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-06-06 16:22:21 [错误信息] => 密码错误 [sql] => select a.oper_id, a.oper_name, a.oper_pwd, a.open_id, (case when isnull(c.cust_level, 1) = '' then '1' else isnull(c.cust_level, 1) end) as cus_level, c.is_branch, b.supcust_no, c.supcust_group from sa_t_mobile_oper as a inner join sa_t_mobile_data_main as b on a.oper_id = b.oper_id left join bi_t_supcust_info as c on b.supcust_no = c.supcust_no where a.oper_id = '1037' or a.login_no = '1037' [详细] => 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) 在 Api.SingOut.b2b.mina.oper.login(String card_id, String vip_pass, String is_bind, String open_id) [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.oper , [方法] => login [入参] => {"card_id":"1037","vip_pass":"a123456","is_bind":"1","open_id":"oDppT5EQLOkOajTISdXvjjOVCebs"} ************************************************************************************** **************************mima_b2b_Login()2022/6/6 16:22:30************************* paramter0:1037 paramter1:oDppT5EQLOkOajTISdXvjjOVCebs Api.Helper.Exceptions.KatException: 密码错误 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-06-06 16:22:30 [错误信息] => 密码错误 [sql] => select a.oper_id, a.oper_name, a.oper_pwd, a.open_id, (case when isnull(c.cust_level, 1) = '' then '1' else isnull(c.cust_level, 1) end) as cus_level, c.is_branch, b.supcust_no, c.supcust_group from sa_t_mobile_oper as a inner join sa_t_mobile_data_main as b on a.oper_id = b.oper_id left join bi_t_supcust_info as c on b.supcust_no = c.supcust_no where a.oper_id = '1037' or a.login_no = '1037' [详细] => 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) 在 Api.SingOut.b2b.mina.oper.login(String card_id, String vip_pass, String is_bind, String open_id) [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.oper , [方法] => login [入参] => {"card_id":"1037","vip_pass":"a123456","is_bind":"1","open_id":"oDppT5EQLOkOajTISdXvjjOVCebs"} ************************************************************************************** **************************mima_b2b_Login()2022/6/6 17:25:14************************* paramter0:1001 paramter1:oDppT5DEga1ePDbZkp7H3uxBNGxg Api.Helper.Exceptions.KatException: 密码错误 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-06-06 17:25:14 [错误信息] => 密码错误 [sql] => select a.oper_id, a.oper_name, a.oper_pwd, a.open_id, (case when isnull(c.cust_level, 1) = '' then '1' else isnull(c.cust_level, 1) end) as cus_level, c.is_branch, b.supcust_no, c.supcust_group from sa_t_mobile_oper as a inner join sa_t_mobile_data_main as b on a.oper_id = b.oper_id left join bi_t_supcust_info as c on b.supcust_no = c.supcust_no where a.oper_id = '1001' or a.login_no = '1001' [详细] => 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) 在 Api.SingOut.b2b.mina.oper.login(String card_id, String vip_pass, String is_bind, String open_id) [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.oper , [方法] => login [入参] => {"card_id":"1001","vip_pass":"123445","is_bind":"1","open_id":"oDppT5DEga1ePDbZkp7H3uxBNGxg"} ************************************************************************************** **************************mima_b2b_Login()2022/6/6 19:41:03************************* paramter0:1019 paramter1:oDppT5O2ZcWIDH75_t-tphpdGjgY Api.Helper.Exceptions.KatException: 密码错误 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) ************************************************************************************** ************************************************************************************** [意料之外的错误] ----- 2022-06-06 19:41:03 [错误信息] => 密码错误 [sql] => select a.oper_id, a.oper_name, a.oper_pwd, a.open_id, (case when isnull(c.cust_level, 1) = '' then '1' else isnull(c.cust_level, 1) end) as cus_level, c.is_branch, b.supcust_no, c.supcust_group from sa_t_mobile_oper as a inner join sa_t_mobile_data_main as b on a.oper_id = b.oper_id left join bi_t_supcust_info as c on b.supcust_no = c.supcust_no where a.oper_id = '1019' or a.login_no = '1019' [详细] => 在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token) 在 Api.SingOut.b2b.mina.oper.login(String card_id, String vip_pass, String is_bind, String open_id) [路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.oper , [方法] => login [入参] => {"card_id":"1019","vip_pass":"123456","is_bind":"1","open_id":"oDppT5O2ZcWIDH75_t-tphpdGjgY"} **************************************************************************************