2024-01-02 12:19:04 [181] ERROR lp.shop.core.LogBase 【GetShopCartListPage】======MySql.Data.MySqlClient.MySqlException (0x80004005): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.TimeoutException: Timeout in IO operation
   在 MySql.Data.MySqlClient.TimedStream.StopTimer()
   在 MySql.Data.MySqlClient.TimedStream.Read(Byte[] buffer, Int32 offset, Int32 count)
   在 System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count)
   在 MySql.Data.MySqlClient.MySqlStream.ReadFully(Stream stream, Byte[] buffer, Int32 offset, Int32 count)
   在 MySql.Data.MySqlClient.MySqlStream.LoadPacket()
   在 MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   在 MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   在 MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
   在 MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   在 MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   在 MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   在 lp.shop.db.SQLHelper.ExecuteScalar(CommandType cmdType, String cmdStr, MySqlParameter[] cmdParams) 位置 E:\Work\lp_-shop_-hd\lp.shop.db\SQLHelper.cs:行号 234
   在 lp.shop.db.SQLHelper.ExecuteScalar(CommandType cmdType, String cmdStr) 位置 E:\Work\lp_-shop_-hd\lp.shop.db\SQLHelper.cs:行号 246
   在 lp.shop.dal.sqlcore_dal.Allpage(String tblName, String fldname, Int32 pagesize, Int32 pageindex, String orderby, String where, Int32& totalcount, Int32& pagecount, String groupby) 位置 E:\Work\lp_-shop_-hd\lp.shop.dal\sqlcore_dal.cs:行号 70
   在 lp.shop.bll.sqlcore_bll.Allpage(String tblName, String fldname, Int32 pagesize, Int32 pageindex, String orderby, String where, Int32& totalcount, Int32& pagecount, String groupby) 位置 E:\Work\lp_-shop_-hd\lp.shop.bll\sqlcore_bll.cs:行号 47
   在 lp.shop.bll.lp_shopcart_bll.get_shopcart_list(String memberuserid, String id, Int32 pageindex, Int32 pagesize, Int32 ispage) 位置 E:\Work\lp_-shop_-hd\lp.shop.bll\lp_shopcart_bll.cs:行号 49
   在 lp.shop.api.Controllers.app.AppShopCartController.GetShopCartListPage(ShopCartListPageInPut input) 位置 E:\Work\lp_-shop_-hd\lp.shop.api\Controllers\app\AppShopCartController.cs:行号 42

 
2024-01-02 12:19:13 [110] ERROR lp.shop.core.LogBase 【GetShopCartListPage】======MySql.Data.MySqlClient.MySqlException (0x80004005): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.TimeoutException: Timeout in IO operation
   在 MySql.Data.MySqlClient.TimedStream.StopTimer()
   在 MySql.Data.MySqlClient.TimedStream.Read(Byte[] buffer, Int32 offset, Int32 count)
   在 System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count)
   在 MySql.Data.MySqlClient.MySqlStream.ReadFully(Stream stream, Byte[] buffer, Int32 offset, Int32 count)
   在 MySql.Data.MySqlClient.MySqlStream.LoadPacket()
   在 MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   在 MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   在 MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
   在 MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   在 MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   在 MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   在 lp.shop.db.SQLHelper.ExecuteScalar(CommandType cmdType, String cmdStr, MySqlParameter[] cmdParams) 位置 E:\Work\lp_-shop_-hd\lp.shop.db\SQLHelper.cs:行号 234
   在 lp.shop.db.SQLHelper.ExecuteScalar(CommandType cmdType, String cmdStr) 位置 E:\Work\lp_-shop_-hd\lp.shop.db\SQLHelper.cs:行号 246
   在 lp.shop.dal.sqlcore_dal.Allpage(String tblName, String fldname, Int32 pagesize, Int32 pageindex, String orderby, String where, Int32& totalcount, Int32& pagecount, String groupby) 位置 E:\Work\lp_-shop_-hd\lp.shop.dal\sqlcore_dal.cs:行号 70
   在 lp.shop.bll.sqlcore_bll.Allpage(String tblName, String fldname, Int32 pagesize, Int32 pageindex, String orderby, String where, Int32& totalcount, Int32& pagecount, String groupby) 位置 E:\Work\lp_-shop_-hd\lp.shop.bll\sqlcore_bll.cs:行号 47
   在 lp.shop.bll.lp_shopcart_bll.get_shopcart_list(String memberuserid, String id, Int32 pageindex, Int32 pagesize, Int32 ispage) 位置 E:\Work\lp_-shop_-hd\lp.shop.bll\lp_shopcart_bll.cs:行号 49
   在 lp.shop.api.Controllers.app.AppShopCartController.GetShopCartListPage(ShopCartListPageInPut input) 位置 E:\Work\lp_-shop_-hd\lp.shop.api\Controllers\app\AppShopCartController.cs:行号 42

 
2024-01-02 12:48:43 [116] ERROR lp.shop.core.LogBase 【GetShopCartListPage】======MySql.Data.MySqlClient.MySqlException (0x80004005): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.TimeoutException: Timeout in IO operation
   在 MySql.Data.MySqlClient.TimedStream.StopTimer()
   在 MySql.Data.MySqlClient.TimedStream.Read(Byte[] buffer, Int32 offset, Int32 count)
   在 System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count)
   在 MySql.Data.MySqlClient.MySqlStream.ReadFully(Stream stream, Byte[] buffer, Int32 offset, Int32 count)
   在 MySql.Data.MySqlClient.MySqlStream.LoadPacket()
   在 MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   在 MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   在 MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
   在 MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   在 MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   在 MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   在 lp.shop.db.SQLHelper.ExecuteScalar(CommandType cmdType, String cmdStr, MySqlParameter[] cmdParams) 位置 E:\Work\lp_-shop_-hd\lp.shop.db\SQLHelper.cs:行号 234
   在 lp.shop.db.SQLHelper.ExecuteScalar(CommandType cmdType, String cmdStr) 位置 E:\Work\lp_-shop_-hd\lp.shop.db\SQLHelper.cs:行号 246
   在 lp.shop.dal.sqlcore_dal.Allpage(String tblName, String fldname, Int32 pagesize, Int32 pageindex, String orderby, String where, Int32& totalcount, Int32& pagecount, String groupby) 位置 E:\Work\lp_-shop_-hd\lp.shop.dal\sqlcore_dal.cs:行号 70
   在 lp.shop.bll.sqlcore_bll.Allpage(String tblName, String fldname, Int32 pagesize, Int32 pageindex, String orderby, String where, Int32& totalcount, Int32& pagecount, String groupby) 位置 E:\Work\lp_-shop_-hd\lp.shop.bll\sqlcore_bll.cs:行号 47
   在 lp.shop.bll.lp_shopcart_bll.get_shopcart_list(String memberuserid, String id, Int32 pageindex, Int32 pagesize, Int32 ispage) 位置 E:\Work\lp_-shop_-hd\lp.shop.bll\lp_shopcart_bll.cs:行号 49
   在 lp.shop.api.Controllers.app.AppShopCartController.GetShopCartListPage(ShopCartListPageInPut input) 位置 E:\Work\lp_-shop_-hd\lp.shop.api\Controllers\app\AppShopCartController.cs:行号 42

 
2024-01-02 14:19:15 [20] INFO  lp.shop.core.MsgAPI 发送手机号码：13666933157,短信模板：1,内容：{"phone":"13666933157","code":"2304"}

 
2024-01-02 14:19:15 [20] INFO  lp.shop.core.MsgAPI 13666933157短信执行返回：{"RequestId":"5DC49EDE-B4B5-516D-8CDE-24CBDFA345EA","BizId":null,"Code":"isv.SMS_SIGNATURE_ILLEGAL","Message":"该账号下找不到对应签名","HttpResponse":{"Status":200,"Headers":{"Connection":"keep-alive","Keep-Alive":"timeout=25","Access-Control-Allow-Origin":"*","Access-Control-Expose-Headers":"*","x-acs-request-id":"5DC49EDE-B4B5-516D-8CDE-24CBDFA345EA","x-acs-trace-id":"7261d3789bc1ae1a5d6adfe14aef0c7e","Content-Length":"222","Content-Type":"text/xml;charset=utf-8","Date":"Tue, 02 Jan 2024 06:19:15 GMT","ETag":"2eHZoreXtF7/8WIJYExkqhA0"},"Url":"http://dysmsapi.aliyuncs.com/?Version=2017-05-25&Action=SendSms&Format=XML&PhoneNumbers=13666933157&SignName=%E9%AA%8C%E8%AF%81%E7%A0%81%E7%9F%AD%E4%BF%A1&TemplateCode=SMS_254105099&TemplateParam=%7B%22phone%22:%2213666933157%22%2c%22code%22:%222304%22%7D&OutId=202401021419156699&Timestamp=2024-01-02T06:19:15Z&SignatureMethod=HMAC-SHA1&SignatureVersion=1.0&SignatureNonce=00bec1b8-44c8-483e-a24d-1539369016d9&AccessKeyId=LTAI5tHGNbFjAFgUT7ssbgt3&RegionId=cn-hangzhou&Signature=Gq4qavl%2f%2bFlJs%2bmb4WmfsnFxDNY%3d","Method":0,"ContentType":0,"Content":"PD94bWwgdmVyc2lvbj0nMS4wJyBlbmNvZGluZz0nVVRGLTgnPz48U2VuZFNtc1Jlc3BvbnNlPjxNZXNzYWdlPuivpei0puWPt+S4i+aJvuS4jeWIsOWvueW6lOetvuWQjTwvTWVzc2FnZT48UmVxdWVzdElkPjVEQzQ5RURFLUI0QjUtNTE2RC04Q0RFLTI0Q0JERkEzNDVFQTwvUmVxdWVzdElkPjxDb2RlPmlzdi5TTVNfU0lHTkFUVVJFX0lMTEVHQUw8L0NvZGU+PC9TZW5kU21zUmVzcG9uc2U+","Encoding":"UTF-8","TimeoutInMilliSeconds":100000}}

 
2024-01-02 14:19:15 [20] ERROR lp.shop.core.MsgAPI {"RequestId":"5DC49EDE-B4B5-516D-8CDE-24CBDFA345EA","BizId":null,"Code":"isv.SMS_SIGNATURE_ILLEGAL","Message":"该账号下找不到对应签名","HttpResponse":{"Status":200,"Headers":{"Connection":"keep-alive","Keep-Alive":"timeout=25","Access-Control-Allow-Origin":"*","Access-Control-Expose-Headers":"*","x-acs-request-id":"5DC49EDE-B4B5-516D-8CDE-24CBDFA345EA","x-acs-trace-id":"7261d3789bc1ae1a5d6adfe14aef0c7e","Content-Length":"222","Content-Type":"text/xml;charset=utf-8","Date":"Tue, 02 Jan 2024 06:19:15 GMT","ETag":"2eHZoreXtF7/8WIJYExkqhA0"},"Url":"http://dysmsapi.aliyuncs.com/?Version=2017-05-25&Action=SendSms&Format=XML&PhoneNumbers=13666933157&SignName=%E9%AA%8C%E8%AF%81%E7%A0%81%E7%9F%AD%E4%BF%A1&TemplateCode=SMS_254105099&TemplateParam=%7B%22phone%22:%2213666933157%22%2c%22code%22:%222304%22%7D&OutId=202401021419156699&Timestamp=2024-01-02T06:19:15Z&SignatureMethod=HMAC-SHA1&SignatureVersion=1.0&SignatureNonce=00bec1b8-44c8-483e-a24d-1539369016d9&AccessKeyId=LTAI5tHGNbFjAFgUT7ssbgt3&RegionId=cn-hangzhou&Signature=Gq4qavl%2f%2bFlJs%2bmb4WmfsnFxDNY%3d","Method":0,"ContentType":0,"Content":"PD94bWwgdmVyc2lvbj0nMS4wJyBlbmNvZGluZz0nVVRGLTgnPz48U2VuZFNtc1Jlc3BvbnNlPjxNZXNzYWdlPuivpei0puWPt+S4i+aJvuS4jeWIsOWvueW6lOetvuWQjTwvTWVzc2FnZT48UmVxdWVzdElkPjVEQzQ5RURFLUI0QjUtNTE2RC04Q0RFLTI0Q0JERkEzNDVFQTwvUmVxdWVzdElkPjxDb2RlPmlzdi5TTVNfU0lHTkFUVVJFX0lMTEVHQUw8L0NvZGU+PC9TZW5kU21zUmVzcG9uc2U+","Encoding":"UTF-8","TimeoutInMilliSeconds":100000}}

 
2024-01-02 14:40:31 [96] ERROR lp.shop.core.LogBase 【GetShopCartListPage】======MySql.Data.MySqlClient.MySqlException (0x80004005): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.TimeoutException: Timeout in IO operation
   在 MySql.Data.MySqlClient.TimedStream.StopTimer()
   在 MySql.Data.MySqlClient.TimedStream.Read(Byte[] buffer, Int32 offset, Int32 count)
   在 System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count)
   在 MySql.Data.MySqlClient.MySqlStream.ReadFully(Stream stream, Byte[] buffer, Int32 offset, Int32 count)
   在 MySql.Data.MySqlClient.MySqlStream.LoadPacket()
   在 MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   在 MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   在 MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
   在 MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   在 MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   在 MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   在 lp.shop.db.SQLHelper.ExecuteTable(CommandType cmdType, String cmdStr, MySqlParameter[] cmdParams) 位置 E:\Work\lp_-shop_-hd\lp.shop.db\SQLHelper.cs:行号 275
   在 lp.shop.db.SQLHelper.ExecuteTable(CommandType cmdType, String cmdStr) 位置 E:\Work\lp_-shop_-hd\lp.shop.db\SQLHelper.cs:行号 287
   在 lp.shop.dal.sqlcore_dal.Allpage(String tblName, String fldname, Int32 pagesize, Int32 pageindex, String orderby, String where, Int32& totalcount, Int32& pagecount, String groupby) 位置 E:\Work\lp_-shop_-hd\lp.shop.dal\sqlcore_dal.cs:行号 95
   在 lp.shop.bll.sqlcore_bll.Allpage(String tblName, String fldname, Int32 pagesize, Int32 pageindex, String orderby, String where, Int32& totalcount, Int32& pagecount, String groupby) 位置 E:\Work\lp_-shop_-hd\lp.shop.bll\sqlcore_bll.cs:行号 47
   在 lp.shop.bll.lp_shopcart_bll.get_shopcart_list(String memberuserid, String id, Int32 pageindex, Int32 pagesize, Int32 ispage) 位置 E:\Work\lp_-shop_-hd\lp.shop.bll\lp_shopcart_bll.cs:行号 49
   在 lp.shop.api.Controllers.app.AppShopCartController.GetShopCartListPage(ShopCartListPageInPut input) 位置 E:\Work\lp_-shop_-hd\lp.shop.api\Controllers\app\AppShopCartController.cs:行号 42