2023-12-16 14:01:55 [38] 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-12-16 14:19:01 [83] ERROR lp.shop.core.LogBase 【GetShopSpuProductAuthorizeByCompanyidStoredid】======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_shopproduct_bll.get_shop_spuproduct_authorize_list(String companyid, String storedid, String spuid, String spusn, String name, String catetype, String cateid, String brandid, String styleid, String roomid, String model, Int32 label, Int32 pageindex, Int32 pagesize, Int32 ispage) 位置 E:\Work\lp_-shop_-hd\lp.shop.bll\lp_shopproduct_bll.cs:行号 259
   在 lp.shop.api.Controllers.app.AppShopProductController.GetShopSpuProductAuthorizeByCompanyidStoredid(ShopSpuProductAuthorizePageInPut input) 位置 E:\Work\lp_-shop_-hd\lp.shop.api\Controllers\app\AppShopProductController.cs:行号 45

 
2023-12-16 21:06:37 [37] INFO  lp.shop.core.MsgAPI 发送手机号码：18676058988,短信模板：1,内容：{"phone":"18676058988","code":"8256"}

 
2023-12-16 21:06:38 [37] INFO  lp.shop.core.MsgAPI 18676058988短信执行返回：{"RequestId":"27FEFCA5-372E-523F-97AE-C32FC939762B","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":"27FEFCA5-372E-523F-97AE-C32FC939762B","x-acs-trace-id":"a5d28c74c4b6b6af8a3a0a7d4d316b3e","Content-Length":"222","Content-Type":"text/xml;charset=utf-8","Date":"Sat, 16 Dec 2023 13:06:38 GMT","ETag":"24sAwmeEApK057J4y0vo8Ig0"},"Url":"http://dysmsapi.aliyuncs.com/?Version=2017-05-25&Action=SendSms&Format=XML&PhoneNumbers=18676058988&SignName=%E9%AA%8C%E8%AF%81%E7%A0%81%E7%9F%AD%E4%BF%A1&TemplateCode=SMS_254105099&TemplateParam=%7B%22phone%22:%2218676058988%22%2c%22code%22:%228256%22%7D&OutId=202312162106379819&Timestamp=2023-12-16T13:06:37Z&SignatureMethod=HMAC-SHA1&SignatureVersion=1.0&SignatureNonce=54b89255-ca66-4724-880a-3f5102f03f04&AccessKeyId=LTAI5tHGNbFjAFgUT7ssbgt3&RegionId=cn-hangzhou&Signature=x7nZyQ8AqrNYSL98IZwnxN2qBas%3d","Method":0,"ContentType":0,"Content":"PD94bWwgdmVyc2lvbj0nMS4wJyBlbmNvZGluZz0nVVRGLTgnPz48U2VuZFNtc1Jlc3BvbnNlPjxNZXNzYWdlPuivpei0puWPt+S4i+aJvuS4jeWIsOWvueW6lOetvuWQjTwvTWVzc2FnZT48UmVxdWVzdElkPjI3RkVGQ0E1LTM3MkUtNTIzRi05N0FFLUMzMkZDOTM5NzYyQjwvUmVxdWVzdElkPjxDb2RlPmlzdi5TTVNfU0lHTkFUVVJFX0lMTEVHQUw8L0NvZGU+PC9TZW5kU21zUmVzcG9uc2U+","Encoding":"UTF-8","TimeoutInMilliSeconds":100000}}

 
2023-12-16 21:06:38 [37] ERROR lp.shop.core.MsgAPI {"RequestId":"27FEFCA5-372E-523F-97AE-C32FC939762B","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":"27FEFCA5-372E-523F-97AE-C32FC939762B","x-acs-trace-id":"a5d28c74c4b6b6af8a3a0a7d4d316b3e","Content-Length":"222","Content-Type":"text/xml;charset=utf-8","Date":"Sat, 16 Dec 2023 13:06:38 GMT","ETag":"24sAwmeEApK057J4y0vo8Ig0"},"Url":"http://dysmsapi.aliyuncs.com/?Version=2017-05-25&Action=SendSms&Format=XML&PhoneNumbers=18676058988&SignName=%E9%AA%8C%E8%AF%81%E7%A0%81%E7%9F%AD%E4%BF%A1&TemplateCode=SMS_254105099&TemplateParam=%7B%22phone%22:%2218676058988%22%2c%22code%22:%228256%22%7D&OutId=202312162106379819&Timestamp=2023-12-16T13:06:37Z&SignatureMethod=HMAC-SHA1&SignatureVersion=1.0&SignatureNonce=54b89255-ca66-4724-880a-3f5102f03f04&AccessKeyId=LTAI5tHGNbFjAFgUT7ssbgt3&RegionId=cn-hangzhou&Signature=x7nZyQ8AqrNYSL98IZwnxN2qBas%3d","Method":0,"ContentType":0,"Content":"PD94bWwgdmVyc2lvbj0nMS4wJyBlbmNvZGluZz0nVVRGLTgnPz48U2VuZFNtc1Jlc3BvbnNlPjxNZXNzYWdlPuivpei0puWPt+S4i+aJvuS4jeWIsOWvueW6lOetvuWQjTwvTWVzc2FnZT48UmVxdWVzdElkPjI3RkVGQ0E1LTM3MkUtNTIzRi05N0FFLUMzMkZDOTM5NzYyQjwvUmVxdWVzdElkPjxDb2RlPmlzdi5TTVNfU0lHTkFUVVJFX0lMTEVHQUw8L0NvZGU+PC9TZW5kU21zUmVzcG9uc2U+","Encoding":"UTF-8","TimeoutInMilliSeconds":100000}}

 
2023-12-16 21:08:12 [11] INFO  lp.shop.core.MsgAPI 发送手机号码：18676058988,短信模板：1,内容：{"phone":"18676058988","code":"1356"}

 
2023-12-16 21:08:12 [11] INFO  lp.shop.core.MsgAPI 18676058988短信执行返回：{"RequestId":"CC72CA6E-D2E5-531C-9EF0-184E330EC15A","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":"CC72CA6E-D2E5-531C-9EF0-184E330EC15A","x-acs-trace-id":"88947bacfe5cae05a681198902d3ab0a","Content-Length":"222","Content-Type":"text/xml;charset=utf-8","Date":"Sat, 16 Dec 2023 13:08:12 GMT","ETag":"2qIcHIkr8VtabEBD+Hu7DSw0"},"Url":"http://dysmsapi.aliyuncs.com/?Version=2017-05-25&Action=SendSms&Format=XML&PhoneNumbers=18676058988&SignName=%E9%AA%8C%E8%AF%81%E7%A0%81%E7%9F%AD%E4%BF%A1&TemplateCode=SMS_254105099&TemplateParam=%7B%22phone%22:%2218676058988%22%2c%22code%22:%221356%22%7D&OutId=202312162108127528&Timestamp=2023-12-16T13:08:12Z&SignatureMethod=HMAC-SHA1&SignatureVersion=1.0&SignatureNonce=6b1b5db0-edca-4981-aa0b-03017a3e1770&AccessKeyId=LTAI5tHGNbFjAFgUT7ssbgt3&RegionId=cn-hangzhou&Signature=HmVr9NI8URoKDAjD2UgY%2bVb4Zt8%3d","Method":0,"ContentType":0,"Content":"PD94bWwgdmVyc2lvbj0nMS4wJyBlbmNvZGluZz0nVVRGLTgnPz48U2VuZFNtc1Jlc3BvbnNlPjxNZXNzYWdlPuivpei0puWPt+S4i+aJvuS4jeWIsOWvueW6lOetvuWQjTwvTWVzc2FnZT48UmVxdWVzdElkPkNDNzJDQTZFLUQyRTUtNTMxQy05RUYwLTE4NEUzMzBFQzE1QTwvUmVxdWVzdElkPjxDb2RlPmlzdi5TTVNfU0lHTkFUVVJFX0lMTEVHQUw8L0NvZGU+PC9TZW5kU21zUmVzcG9uc2U+","Encoding":"UTF-8","TimeoutInMilliSeconds":100000}}

 
2023-12-16 21:08:12 [11] ERROR lp.shop.core.MsgAPI {"RequestId":"CC72CA6E-D2E5-531C-9EF0-184E330EC15A","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":"CC72CA6E-D2E5-531C-9EF0-184E330EC15A","x-acs-trace-id":"88947bacfe5cae05a681198902d3ab0a","Content-Length":"222","Content-Type":"text/xml;charset=utf-8","Date":"Sat, 16 Dec 2023 13:08:12 GMT","ETag":"2qIcHIkr8VtabEBD+Hu7DSw0"},"Url":"http://dysmsapi.aliyuncs.com/?Version=2017-05-25&Action=SendSms&Format=XML&PhoneNumbers=18676058988&SignName=%E9%AA%8C%E8%AF%81%E7%A0%81%E7%9F%AD%E4%BF%A1&TemplateCode=SMS_254105099&TemplateParam=%7B%22phone%22:%2218676058988%22%2c%22code%22:%221356%22%7D&OutId=202312162108127528&Timestamp=2023-12-16T13:08:12Z&SignatureMethod=HMAC-SHA1&SignatureVersion=1.0&SignatureNonce=6b1b5db0-edca-4981-aa0b-03017a3e1770&AccessKeyId=LTAI5tHGNbFjAFgUT7ssbgt3&RegionId=cn-hangzhou&Signature=HmVr9NI8URoKDAjD2UgY%2bVb4Zt8%3d","Method":0,"ContentType":0,"Content":"PD94bWwgdmVyc2lvbj0nMS4wJyBlbmNvZGluZz0nVVRGLTgnPz48U2VuZFNtc1Jlc3BvbnNlPjxNZXNzYWdlPuivpei0puWPt+S4i+aJvuS4jeWIsOWvueW6lOetvuWQjTwvTWVzc2FnZT48UmVxdWVzdElkPkNDNzJDQTZFLUQyRTUtNTMxQy05RUYwLTE4NEUzMzBFQzE1QTwvUmVxdWVzdElkPjxDb2RlPmlzdi5TTVNfU0lHTkFUVVJFX0lMTEVHQUw8L0NvZGU+PC9TZW5kU21zUmVzcG9uc2U+","Encoding":"UTF-8","TimeoutInMilliSeconds":100000}}