2023-07-01 14:36:56 [114] 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 2023-07-01 15:40:23 [81] INFO lp.shop.core.MsgAPI 发送手机号码：18079255488,短信模板：1,内容：{"phone":"18079255488","code":"8608"} 2023-07-01 15:40:23 [81] INFO lp.shop.core.MsgAPI 18079255488短信执行返回：{"RequestId":"BE69E63C-E637-5AE8-9514-AE6C7B21E52D","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":"BE69E63C-E637-5AE8-9514-AE6C7B21E52D","x-acs-trace-id":"8e3f92325855337fda2f3a7365976254","Content-Length":"222","Content-Type":"text/xml;charset=utf-8","Date":"Sat, 01 Jul 2023 07:40:23 GMT","ETag":"2llOo636SM7ZTau0QvLs8rA0"},"Url":"http://dysmsapi.aliyuncs.com/?Version=2017-05-25&Action=SendSms&Format=XML&PhoneNumbers=18079255488&SignName=%E9%AA%8C%E8%AF%81%E7%A0%81%E7%9F%AD%E4%BF%A1&TemplateCode=SMS_254105099&TemplateParam=%7B%22phone%22:%2218079255488%22%2c%22code%22:%228608%22%7D&OutId=202307011540239391&Timestamp=2023-07-01T07:40:23Z&SignatureMethod=HMAC-SHA1&SignatureVersion=1.0&SignatureNonce=26a74684-bafd-4810-87b4-c7bba70b613b&AccessKeyId=LTAI5tHGNbFjAFgUT7ssbgt3&RegionId=cn-hangzhou&Signature=rkgGF8qDscgwLiNuBXrOfdfyHZU%3d","Method":0,"ContentType":0,"Content":"PD94bWwgdmVyc2lvbj0nMS4wJyBlbmNvZGluZz0nVVRGLTgnPz48U2VuZFNtc1Jlc3BvbnNlPjxNZXNzYWdlPuivpei0puWPt+S4i+aJvuS4jeWIsOWvueW6lOetvuWQjTwvTWVzc2FnZT48UmVxdWVzdElkPkJFNjlFNjNDLUU2MzctNUFFOC05NTE0LUFFNkM3QjIxRTUyRDwvUmVxdWVzdElkPjxDb2RlPmlzdi5TTVNfU0lHTkFUVVJFX0lMTEVHQUw8L0NvZGU+PC9TZW5kU21zUmVzcG9uc2U+","Encoding":"UTF-8","TimeoutInMilliSeconds":100000}} 2023-07-01 15:40:23 [81] ERROR lp.shop.core.MsgAPI {"RequestId":"BE69E63C-E637-5AE8-9514-AE6C7B21E52D","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":"BE69E63C-E637-5AE8-9514-AE6C7B21E52D","x-acs-trace-id":"8e3f92325855337fda2f3a7365976254","Content-Length":"222","Content-Type":"text/xml;charset=utf-8","Date":"Sat, 01 Jul 2023 07:40:23 GMT","ETag":"2llOo636SM7ZTau0QvLs8rA0"},"Url":"http://dysmsapi.aliyuncs.com/?Version=2017-05-25&Action=SendSms&Format=XML&PhoneNumbers=18079255488&SignName=%E9%AA%8C%E8%AF%81%E7%A0%81%E7%9F%AD%E4%BF%A1&TemplateCode=SMS_254105099&TemplateParam=%7B%22phone%22:%2218079255488%22%2c%22code%22:%228608%22%7D&OutId=202307011540239391&Timestamp=2023-07-01T07:40:23Z&SignatureMethod=HMAC-SHA1&SignatureVersion=1.0&SignatureNonce=26a74684-bafd-4810-87b4-c7bba70b613b&AccessKeyId=LTAI5tHGNbFjAFgUT7ssbgt3&RegionId=cn-hangzhou&Signature=rkgGF8qDscgwLiNuBXrOfdfyHZU%3d","Method":0,"ContentType":0,"Content":"PD94bWwgdmVyc2lvbj0nMS4wJyBlbmNvZGluZz0nVVRGLTgnPz48U2VuZFNtc1Jlc3BvbnNlPjxNZXNzYWdlPuivpei0puWPt+S4i+aJvuS4jeWIsOWvueW6lOetvuWQjTwvTWVzc2FnZT48UmVxdWVzdElkPkJFNjlFNjNDLUU2MzctNUFFOC05NTE0LUFFNkM3QjIxRTUyRDwvUmVxdWVzdElkPjxDb2RlPmlzdi5TTVNfU0lHTkFUVVJFX0lMTEVHQUw8L0NvZGU+PC9TZW5kU21zUmVzcG9uc2U+","Encoding":"UTF-8","TimeoutInMilliSeconds":100000}} 2023-07-01 17:16:11 [101] ERROR lp.shop.core.LogBase 在 System.Threading.CancellationToken.ThrowOperationCanceledException() 在 System.Net.Http.HttpContentExtensions.d__17`1.MoveNext() --- 引发异常的上一位置中堆栈跟踪的末尾 --- 在 System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) 在 System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) 在 System.Web.Http.ModelBinding.FormatterParameterBinding.d__18.MoveNext() --- 引发异常的上一位置中堆栈跟踪的末尾 --- 在 System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) 在 System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) 在 System.Web.Http.Controllers.HttpActionBinding.d__12.MoveNext() --- 引发异常的上一位置中堆栈跟踪的末尾 --- 在 System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) 在 System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) 在 System.Web.Http.Controllers.ActionFilterResult.d__5.MoveNext() --- 引发异常的上一位置中堆栈跟踪的末尾 --- 在 System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) 在 System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) 在 System.Web.Http.Controllers.ExceptionFilterResult.d__6.MoveNext() 2023-07-01 17:20:20 [113] ERROR lp.shop.core.LogBase 在 System.Threading.CancellationToken.ThrowOperationCanceledException() 在 System.Net.Http.HttpContentExtensions.d__17`1.MoveNext() --- 引发异常的上一位置中堆栈跟踪的末尾 --- 在 System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) 在 System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) 在 System.Web.Http.ModelBinding.FormatterParameterBinding.d__18.MoveNext() --- 引发异常的上一位置中堆栈跟踪的末尾 --- 在 System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) 在 System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) 在 System.Web.Http.Controllers.HttpActionBinding.d__12.MoveNext() --- 引发异常的上一位置中堆栈跟踪的末尾 --- 在 System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) 在 System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) 在 System.Web.Http.Controllers.ActionFilterResult.d__5.MoveNext() --- 引发异常的上一位置中堆栈跟踪的末尾 --- 在 System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) 在 System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) 在 System.Web.Http.Controllers.ExceptionFilterResult.d__6.MoveNext() 2023-07-01 20:01:19 [80] INFO lp.shop.core.MsgAPI 发送手机号码：16698511190,短信模板：1,内容：{"phone":"16698511190","code":"7583"} 2023-07-01 20:01:19 [80] INFO lp.shop.core.MsgAPI 16698511190短信执行返回：{"RequestId":"EBBC08A6-912A-5303-92E1-62041598EC0B","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":"EBBC08A6-912A-5303-92E1-62041598EC0B","x-acs-trace-id":"ad76ea27f3d73e43cd779915b7518de9","Content-Length":"222","Content-Type":"text/xml;charset=utf-8","Date":"Sat, 01 Jul 2023 12:01:19 GMT","ETag":"2P0UvWc2BNUBHxWxvL6A7YQ0"},"Url":"http://dysmsapi.aliyuncs.com/?Version=2017-05-25&Action=SendSms&Format=XML&PhoneNumbers=16698511190&SignName=%E9%AA%8C%E8%AF%81%E7%A0%81%E7%9F%AD%E4%BF%A1&TemplateCode=SMS_254105099&TemplateParam=%7B%22phone%22:%2216698511190%22%2c%22code%22:%227583%22%7D&OutId=202307012001199395&Timestamp=2023-07-01T12:01:19Z&SignatureMethod=HMAC-SHA1&SignatureVersion=1.0&SignatureNonce=86da9be9-e599-416d-b859-f6e9142e370f&AccessKeyId=LTAI5tHGNbFjAFgUT7ssbgt3&RegionId=cn-hangzhou&Signature=s6%2bqv6s3XAj11uKRT5O%2bNwrraFM%3d","Method":0,"ContentType":0,"Content":"PD94bWwgdmVyc2lvbj0nMS4wJyBlbmNvZGluZz0nVVRGLTgnPz48U2VuZFNtc1Jlc3BvbnNlPjxNZXNzYWdlPuivpei0puWPt+S4i+aJvuS4jeWIsOWvueW6lOetvuWQjTwvTWVzc2FnZT48UmVxdWVzdElkPkVCQkMwOEE2LTkxMkEtNTMwMy05MkUxLTYyMDQxNTk4RUMwQjwvUmVxdWVzdElkPjxDb2RlPmlzdi5TTVNfU0lHTkFUVVJFX0lMTEVHQUw8L0NvZGU+PC9TZW5kU21zUmVzcG9uc2U+","Encoding":"UTF-8","TimeoutInMilliSeconds":100000}} 2023-07-01 20:01:19 [80] ERROR lp.shop.core.MsgAPI {"RequestId":"EBBC08A6-912A-5303-92E1-62041598EC0B","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":"EBBC08A6-912A-5303-92E1-62041598EC0B","x-acs-trace-id":"ad76ea27f3d73e43cd779915b7518de9","Content-Length":"222","Content-Type":"text/xml;charset=utf-8","Date":"Sat, 01 Jul 2023 12:01:19 GMT","ETag":"2P0UvWc2BNUBHxWxvL6A7YQ0"},"Url":"http://dysmsapi.aliyuncs.com/?Version=2017-05-25&Action=SendSms&Format=XML&PhoneNumbers=16698511190&SignName=%E9%AA%8C%E8%AF%81%E7%A0%81%E7%9F%AD%E4%BF%A1&TemplateCode=SMS_254105099&TemplateParam=%7B%22phone%22:%2216698511190%22%2c%22code%22:%227583%22%7D&OutId=202307012001199395&Timestamp=2023-07-01T12:01:19Z&SignatureMethod=HMAC-SHA1&SignatureVersion=1.0&SignatureNonce=86da9be9-e599-416d-b859-f6e9142e370f&AccessKeyId=LTAI5tHGNbFjAFgUT7ssbgt3&RegionId=cn-hangzhou&Signature=s6%2bqv6s3XAj11uKRT5O%2bNwrraFM%3d","Method":0,"ContentType":0,"Content":"PD94bWwgdmVyc2lvbj0nMS4wJyBlbmNvZGluZz0nVVRGLTgnPz48U2VuZFNtc1Jlc3BvbnNlPjxNZXNzYWdlPuivpei0puWPt+S4i+aJvuS4jeWIsOWvueW6lOetvuWQjTwvTWVzc2FnZT48UmVxdWVzdElkPkVCQkMwOEE2LTkxMkEtNTMwMy05MkUxLTYyMDQxNTk4RUMwQjwvUmVxdWVzdElkPjxDb2RlPmlzdi5TTVNfU0lHTkFUVVJFX0lMTEVHQUw8L0NvZGU+PC9TZW5kU21zUmVzcG9uc2U+","Encoding":"UTF-8","TimeoutInMilliSeconds":100000}} 2023-07-01 22:44:44 [98] 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