2023-06-27 14:32:47 [47] 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 2023-06-27 17:49:45 [168] INFO lp.shop.core.MsgAPI 发送手机号码：18895686847,短信模板：1,内容：{"phone":"18895686847","code":"6478"} 2023-06-27 17:49:45 [168] INFO lp.shop.core.MsgAPI 18895686847短信执行返回：{"RequestId":"28D3A12D-5795-57DB-A269-B6F228D84417","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":"28D3A12D-5795-57DB-A269-B6F228D84417","x-acs-trace-id":"db1f5961c37a434840655c8ef31c7cb6","Content-Length":"222","Content-Type":"text/xml;charset=utf-8","Date":"Tue, 27 Jun 2023 09:49:45 GMT"},"Url":"http://dysmsapi.aliyuncs.com/?Version=2017-05-25&Action=SendSms&Format=XML&PhoneNumbers=18895686847&SignName=%E9%AA%8C%E8%AF%81%E7%A0%81%E7%9F%AD%E4%BF%A1&TemplateCode=SMS_254105099&TemplateParam=%7B%22phone%22:%2218895686847%22%2c%22code%22:%226478%22%7D&OutId=202306271749454647&Timestamp=2023-06-27T09:49:45Z&SignatureMethod=HMAC-SHA1&SignatureVersion=1.0&SignatureNonce=88ad3433-5605-4493-98dc-a8592490756b&AccessKeyId=LTAI5tHGNbFjAFgUT7ssbgt3&RegionId=cn-hangzhou&Signature=xlW5CRlFzPrSfnp4m5wqS2rfqIs%3d","Method":0,"ContentType":0,"Content":"PD94bWwgdmVyc2lvbj0nMS4wJyBlbmNvZGluZz0nVVRGLTgnPz48U2VuZFNtc1Jlc3BvbnNlPjxNZXNzYWdlPuivpei0puWPt+S4i+aJvuS4jeWIsOWvueW6lOetvuWQjTwvTWVzc2FnZT48UmVxdWVzdElkPjI4RDNBMTJELTU3OTUtNTdEQi1BMjY5LUI2RjIyOEQ4NDQxNzwvUmVxdWVzdElkPjxDb2RlPmlzdi5TTVNfU0lHTkFUVVJFX0lMTEVHQUw8L0NvZGU+PC9TZW5kU21zUmVzcG9uc2U+","Encoding":"UTF-8","TimeoutInMilliSeconds":100000}} 2023-06-27 17:49:45 [168] ERROR lp.shop.core.MsgAPI {"RequestId":"28D3A12D-5795-57DB-A269-B6F228D84417","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":"28D3A12D-5795-57DB-A269-B6F228D84417","x-acs-trace-id":"db1f5961c37a434840655c8ef31c7cb6","Content-Length":"222","Content-Type":"text/xml;charset=utf-8","Date":"Tue, 27 Jun 2023 09:49:45 GMT"},"Url":"http://dysmsapi.aliyuncs.com/?Version=2017-05-25&Action=SendSms&Format=XML&PhoneNumbers=18895686847&SignName=%E9%AA%8C%E8%AF%81%E7%A0%81%E7%9F%AD%E4%BF%A1&TemplateCode=SMS_254105099&TemplateParam=%7B%22phone%22:%2218895686847%22%2c%22code%22:%226478%22%7D&OutId=202306271749454647&Timestamp=2023-06-27T09:49:45Z&SignatureMethod=HMAC-SHA1&SignatureVersion=1.0&SignatureNonce=88ad3433-5605-4493-98dc-a8592490756b&AccessKeyId=LTAI5tHGNbFjAFgUT7ssbgt3&RegionId=cn-hangzhou&Signature=xlW5CRlFzPrSfnp4m5wqS2rfqIs%3d","Method":0,"ContentType":0,"Content":"PD94bWwgdmVyc2lvbj0nMS4wJyBlbmNvZGluZz0nVVRGLTgnPz48U2VuZFNtc1Jlc3BvbnNlPjxNZXNzYWdlPuivpei0puWPt+S4i+aJvuS4jeWIsOWvueW6lOetvuWQjTwvTWVzc2FnZT48UmVxdWVzdElkPjI4RDNBMTJELTU3OTUtNTdEQi1BMjY5LUI2RjIyOEQ4NDQxNzwvUmVxdWVzdElkPjxDb2RlPmlzdi5TTVNfU0lHTkFUVVJFX0lMTEVHQUw8L0NvZGU+PC9TZW5kU21zUmVzcG9uc2U+","Encoding":"UTF-8","TimeoutInMilliSeconds":100000}} 2023-06-27 17:51:07 [106] INFO lp.shop.core.MsgAPI 发送手机号码：18895686847,短信模板：1,内容：{"phone":"18895686847","code":"4755"} 2023-06-27 17:51:07 [106] INFO lp.shop.core.MsgAPI 18895686847短信执行返回：{"RequestId":"F27F2D1B-6DE3-55D1-A249-88D03ECBD659","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":"F27F2D1B-6DE3-55D1-A249-88D03ECBD659","x-acs-trace-id":"599d83e6d14f6399caa424c31f242fb4","Content-Length":"222","Content-Type":"text/xml;charset=utf-8","Date":"Tue, 27 Jun 2023 09:51:07 GMT"},"Url":"http://dysmsapi.aliyuncs.com/?Version=2017-05-25&Action=SendSms&Format=XML&PhoneNumbers=18895686847&SignName=%E9%AA%8C%E8%AF%81%E7%A0%81%E7%9F%AD%E4%BF%A1&TemplateCode=SMS_254105099&TemplateParam=%7B%22phone%22:%2218895686847%22%2c%22code%22:%224755%22%7D&OutId=202306271751078564&Timestamp=2023-06-27T09:51:07Z&SignatureMethod=HMAC-SHA1&SignatureVersion=1.0&SignatureNonce=85891813-a805-4131-a9c6-99fa2af272be&AccessKeyId=LTAI5tHGNbFjAFgUT7ssbgt3&RegionId=cn-hangzhou&Signature=P9RnBTihUBg%2fZNRGF1mfB5CGmDg%3d","Method":0,"ContentType":0,"Content":"PD94bWwgdmVyc2lvbj0nMS4wJyBlbmNvZGluZz0nVVRGLTgnPz48U2VuZFNtc1Jlc3BvbnNlPjxNZXNzYWdlPuivpei0puWPt+S4i+aJvuS4jeWIsOWvueW6lOetvuWQjTwvTWVzc2FnZT48UmVxdWVzdElkPkYyN0YyRDFCLTZERTMtNTVEMS1BMjQ5LTg4RDAzRUNCRDY1OTwvUmVxdWVzdElkPjxDb2RlPmlzdi5TTVNfU0lHTkFUVVJFX0lMTEVHQUw8L0NvZGU+PC9TZW5kU21zUmVzcG9uc2U+","Encoding":"UTF-8","TimeoutInMilliSeconds":100000}} 2023-06-27 17:51:07 [106] ERROR lp.shop.core.MsgAPI {"RequestId":"F27F2D1B-6DE3-55D1-A249-88D03ECBD659","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":"F27F2D1B-6DE3-55D1-A249-88D03ECBD659","x-acs-trace-id":"599d83e6d14f6399caa424c31f242fb4","Content-Length":"222","Content-Type":"text/xml;charset=utf-8","Date":"Tue, 27 Jun 2023 09:51:07 GMT"},"Url":"http://dysmsapi.aliyuncs.com/?Version=2017-05-25&Action=SendSms&Format=XML&PhoneNumbers=18895686847&SignName=%E9%AA%8C%E8%AF%81%E7%A0%81%E7%9F%AD%E4%BF%A1&TemplateCode=SMS_254105099&TemplateParam=%7B%22phone%22:%2218895686847%22%2c%22code%22:%224755%22%7D&OutId=202306271751078564&Timestamp=2023-06-27T09:51:07Z&SignatureMethod=HMAC-SHA1&SignatureVersion=1.0&SignatureNonce=85891813-a805-4131-a9c6-99fa2af272be&AccessKeyId=LTAI5tHGNbFjAFgUT7ssbgt3&RegionId=cn-hangzhou&Signature=P9RnBTihUBg%2fZNRGF1mfB5CGmDg%3d","Method":0,"ContentType":0,"Content":"PD94bWwgdmVyc2lvbj0nMS4wJyBlbmNvZGluZz0nVVRGLTgnPz48U2VuZFNtc1Jlc3BvbnNlPjxNZXNzYWdlPuivpei0puWPt+S4i+aJvuS4jeWIsOWvueW6lOetvuWQjTwvTWVzc2FnZT48UmVxdWVzdElkPkYyN0YyRDFCLTZERTMtNTVEMS1BMjQ5LTg4RDAzRUNCRDY1OTwvUmVxdWVzdElkPjxDb2RlPmlzdi5TTVNfU0lHTkFUVVJFX0lMTEVHQUw8L0NvZGU+PC9TZW5kU21zUmVzcG9uc2U+","Encoding":"UTF-8","TimeoutInMilliSeconds":100000}} 2023-06-27 17:52:31 [187] INFO lp.shop.core.MsgAPI 发送手机号码：18895686847,短信模板：1,内容：{"phone":"18895686847","code":"0301"} 2023-06-27 17:52:31 [187] INFO lp.shop.core.MsgAPI 18895686847短信执行返回：{"RequestId":"D62CE091-2ED1-566D-B140-74D0B9823465","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":"D62CE091-2ED1-566D-B140-74D0B9823465","x-acs-trace-id":"49178621ec79a1384c54883c131879bb","Content-Length":"222","Content-Type":"text/xml;charset=utf-8","Date":"Tue, 27 Jun 2023 09:52:31 GMT"},"Url":"http://dysmsapi.aliyuncs.com/?Version=2017-05-25&Action=SendSms&Format=XML&PhoneNumbers=18895686847&SignName=%E9%AA%8C%E8%AF%81%E7%A0%81%E7%9F%AD%E4%BF%A1&TemplateCode=SMS_254105099&TemplateParam=%7B%22phone%22:%2218895686847%22%2c%22code%22:%220301%22%7D&OutId=202306271752318721&Timestamp=2023-06-27T09:52:31Z&SignatureMethod=HMAC-SHA1&SignatureVersion=1.0&SignatureNonce=c62f94e2-d117-4173-9160-d3951977236b&AccessKeyId=LTAI5tHGNbFjAFgUT7ssbgt3&RegionId=cn-hangzhou&Signature=ijuQpnn%2f9nSSXUkERaSeL%2bH3AxY%3d","Method":0,"ContentType":0,"Content":"PD94bWwgdmVyc2lvbj0nMS4wJyBlbmNvZGluZz0nVVRGLTgnPz48U2VuZFNtc1Jlc3BvbnNlPjxNZXNzYWdlPuivpei0puWPt+S4i+aJvuS4jeWIsOWvueW6lOetvuWQjTwvTWVzc2FnZT48UmVxdWVzdElkPkQ2MkNFMDkxLTJFRDEtNTY2RC1CMTQwLTc0RDBCOTgyMzQ2NTwvUmVxdWVzdElkPjxDb2RlPmlzdi5TTVNfU0lHTkFUVVJFX0lMTEVHQUw8L0NvZGU+PC9TZW5kU21zUmVzcG9uc2U+","Encoding":"UTF-8","TimeoutInMilliSeconds":100000}} 2023-06-27 17:52:31 [187] ERROR lp.shop.core.MsgAPI {"RequestId":"D62CE091-2ED1-566D-B140-74D0B9823465","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":"D62CE091-2ED1-566D-B140-74D0B9823465","x-acs-trace-id":"49178621ec79a1384c54883c131879bb","Content-Length":"222","Content-Type":"text/xml;charset=utf-8","Date":"Tue, 27 Jun 2023 09:52:31 GMT"},"Url":"http://dysmsapi.aliyuncs.com/?Version=2017-05-25&Action=SendSms&Format=XML&PhoneNumbers=18895686847&SignName=%E9%AA%8C%E8%AF%81%E7%A0%81%E7%9F%AD%E4%BF%A1&TemplateCode=SMS_254105099&TemplateParam=%7B%22phone%22:%2218895686847%22%2c%22code%22:%220301%22%7D&OutId=202306271752318721&Timestamp=2023-06-27T09:52:31Z&SignatureMethod=HMAC-SHA1&SignatureVersion=1.0&SignatureNonce=c62f94e2-d117-4173-9160-d3951977236b&AccessKeyId=LTAI5tHGNbFjAFgUT7ssbgt3&RegionId=cn-hangzhou&Signature=ijuQpnn%2f9nSSXUkERaSeL%2bH3AxY%3d","Method":0,"ContentType":0,"Content":"PD94bWwgdmVyc2lvbj0nMS4wJyBlbmNvZGluZz0nVVRGLTgnPz48U2VuZFNtc1Jlc3BvbnNlPjxNZXNzYWdlPuivpei0puWPt+S4i+aJvuS4jeWIsOWvueW6lOetvuWQjTwvTWVzc2FnZT48UmVxdWVzdElkPkQ2MkNFMDkxLTJFRDEtNTY2RC1CMTQwLTc0RDBCOTgyMzQ2NTwvUmVxdWVzdElkPjxDb2RlPmlzdi5TTVNfU0lHTkFUVVJFX0lMTEVHQUw8L0NvZGU+PC9TZW5kU21zUmVzcG9uc2U+","Encoding":"UTF-8","TimeoutInMilliSeconds":100000}} 2023-06-27 21:03:31 [31] 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 2023-06-27 23:06:42 [71] 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.FetchDataRow(Int32 statementId, Int32 columns) 在 MySql.Data.MySqlClient.Driver.FetchDataRow(Int32 statementId, Int32 columns) 在 MySql.Data.MySqlClient.ResultSet.GetNextRow() 在 MySql.Data.MySqlClient.ResultSet.NextRow(CommandBehavior behavior) 在 MySql.Data.MySqlClient.MySqlDataReader.Read() 在 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