jeman 发表于 2013-6-26 00:05:12

更新数据到数据库时失败:查询过于复杂

本帖最后由 jeman 于 2013-6-26 00:12 编辑

更新数据到数据库时失败:查询过于复杂。Int32 ExecuteCommandTextForSingleResult(System.Data.OleDb.tagDBPARAMS, System.Object ByRef)
部份页出现上面错误信息,不知道怎么回事,好像分页在100页以上,就会出现上面错误信息?

只有一个字段,就是读取每个分类下面的产品信息,表格形式,然后这些表格又是多页的,√该标签循环匹配 √该标签在分页中匹配 然后拼接分页内容,难道跟内容信息多有关?

303718 发表于 2013-6-26 08:38:15

这种估计得收费版的MYSQL数据库才行

Deadwalkings 发表于 2013-6-26 09:32:31

100页以上。。你采集的好多啊

jeman 发表于 2013-6-26 09:52:53

有人知道这错误信息是啥意思吗?

本帖最后由 jeman 于 2013-6-26 09:54 编辑

数据量是很多,有1916944多个产品

采了一晚上,又出现这样错误了,汗,不知道有没有全部采完2013-06-26 06:43:07,640 ERROR System.Object [(null)] - UI Exception:
System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
   at System.Windows.Forms.RichTextBox.StreamOut(Int32 flags)
   at System.Windows.Forms.RichTextBox.get_Text()
   at F892D034DB81E03912D8A86B31C5DB.A007881DAC35906EB08D11CE8868FC2F9.E9E40E41335F16B4A12DED075B054C.
.AA1F0C8CB22E3623CE81339D34C1BEB92(Object
1
, EventArgs
2
)
   at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
   at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
   at System.Threading.ExecutionContext.runTryCode(Object userData)
   at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
   at System.Windows.Forms.Control.InvokeMarshaledCallbacks()
2013-06-26 07:00:05,562 FATAL System.Object [(null)] - No-UI Exception:(IsTerminating:True)
System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
   at System.String.InternalSubString(Int32 startIndex, Int32 length, Boolean fAlwaysCopy)
   at System.String.InternalSubStringWithChecks(Int32 startIndex, Int32 length, Boolean fAlwaysCopy)
   at System.Text.RegularExpressions.Capture.get_Value()
   at Super.Parse.Article.OO1OllOlOl0OOO01OO.<GetRuleContent>b__3(Object O1l00)
   at Super.Parse.Article.O00OO01O10lOl110Ol.<TryExecute>b__0()
   at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart()
页: [1]
查看完整版本: 更新数据到数据库时失败:查询过于复杂