Closed ixre closed 1 year ago
在会话页会出现大量的 sql result: 0, sqlite出现out of memory
D/ONE SDK ( 1967): [2022/05/20 00:55:01:866]: sql result: 0 D/ONE SDK ( 1967): [2022/05/20 00:55:01:868]: sql result: 0 D/ONE SDK ( 1967): [2022/05/20 00:55:01:869]: sql result: 0 D/ONE SDK ( 1967): [2022/05/20 00:55:01:870]: sql result: 0 D/ONE SDK ( 1967): [2022/05/20 00:55:01:871]: sql result: 0 D/ONE SDK ( 1967): [2022/05/20 00:55:01:871]: sql result: 0 D/ONE SDK ( 1967): [2022/05/20 00:55:01:872]: sql result: 0 D/ONE SDK ( 1967): [2022/05/20 00:55:01:874]: sql result: 0 D/ONE SDK ( 1967): [2022/05/20 00:55:01:874]: sql result: 0 D/ONE SDK ( 1967): [2022/05/20 00:55:01:875]: sql result: 0 D/ONE SDK ( 1967): [2022/05/20 00:55:01:876]: sql result: 0 D/ONE SDK ( 1967): [2022/05/20 00:55:01:877]: sql result: 0 D/ONE SDK ( 1967): [2022/05/20 00:55:01:877]: Msg already exists in this database, do not insert again. msg id: 1011267752565934140 D/ONE SDK ( 1967): [2022/05/20 00:55:01:877]: Msg already exists in this database, do not insert again. msg id: 1011249836076304384 D/ONE SDK ( 1967): [2022/05/20 00:55:01:877]: Msg already exists in this database, do not insert again. msg id: 1011249273242650632 D/ONE SDK ( 1967): [2022/05/20 00:55:01:877]: Msg already exists in this database, do not insert again. msg id: 1011243530808462136 D/ONE SDK ( 1967): [2022/05/20 00:55:01:877]: Msg already exists in this database, do not insert again. msg id: 1011240952741759020 D/ONE SDK ( 1967): [2022/05/20 00:55:01:878]: sql result: 0 D/ONE SDK ( 1967): [2022/05/20 00:55:01:879]: sql result: 0 D/ONE SDK ( 1967): [2022/05/20 00:55:01:910]: sql result: 0 D/ONE SDK ( 1967): [2022/05/20 00:55:01:925]: sql result: 0 D/ONE SDK ( 1967): [2022/05/20 00:55:01:925]: sql result: 0 D/ONE SDK ( 1967): [2022/05/20 00:55:01:926]: sql result: 0 D/ONE SDK ( 1967): [2022/05/20 00:55:01:958]: sql result: 0 D/ONE SDK ( 1967): [2022/05/20 00:55:01:959]: Msg already exists in this database, do not insert again. msg id: 1011267752565934140 D/ONE SDK ( 1967): [2022/05/20 00:55:01:968]: sql result: 0 D/ONE SDK ( 1967): [2022/05/20 00:55:02:000]: sql result: 0 D/ONE SDK ( 1967): [2022/05/20 00:55:02:000]: sql result: 0 D/ONE SDK ( 1967): [2022/05/20 00:55:02:001]: sql result: 0 D/ONE SDK ( 1967): [2022/05/20 00:55:02:034]: sql result: 0 D/ONE SDK ( 1967): [2022/05/20 00:55:02:068]: sql result: 0 D/ONE SDK ( 1967): [2022/05/20 00:55:02:068]: sql result: 0 D/ONE SDK ( 1967): [2022/05/20 00:55:02:069]: sql result: 0 D/ONE SDK ( 1967): [2022/05/20 00:55:02:070]: sql result: 0 D/ONE SDK ( 1967): [2022/05/20 00:55:02:071]: sql result: 0 D/ONE SDK ( 1967): [2022/05/20 00:55:02:072]: sqlite failed to prepare statement (SELECT * FROM message WHERE conversation=? AND msgbody LIKE '%"msg":"%@小保%"%' AND servertime<? ORDER BY servertime DESC, rowid DESC LIMIT 0,?): 7, out of memory D/ONE SDK ( 1967): [2022/05/20 00:55:02:072]: sql result: 0 D/ONE SDK ( 1967): [2022/05/20 00:55:02:072]: sqlite failed to prepare statement (SELECT * FROM message WHERE conversation=? AND msgbody LIKE '%"msg":"%@小保%"%' AND servertime<? ORDER BY servertime DESC, rowid DESC LIMIT 0,?): 7, out of memory D/ONE SDK ( 1967): [2022/05/20 00:55:02:072]: sql result: 0 D/ONE SDK ( 1967): [2022/05/20 00:55:02:072]: sqlite failed to prepare statement (SELECT * FROM message WHERE conversation=? AND msgbody LIKE '%"msg":"%@小保%"%' AND servertime<? ORDER BY servertime DESC, rowid DESC LIMIT 0,?): 7, out of memory D/ONE SDK ( 1967): [2022/05/20 00:55:02:072]: sql result: 0 D/ONE SDK ( 1967): [2022/05/20 00:55:02:073]: sqlite failed to prepare statement (SELECT * FROM message WHERE conversation=? AND msgbody LIKE '%"msg":"%@小保%"%' AND servertime<? ORDER BY servertime DESC, rowid DESC LIMIT 0,?): 7, out of memory D/ONE SDK ( 1967): [2022/05/20 00:55:02:073]: sql result: 0 D/ONE SDK ( 1967): [2022/05/20 00:55:02:073]: sqlite failed to prepare statement (SELECT * FROM message WHERE conversation=? AND msgbody LIKE '%"msg":"%@小保%"%' AND servertime<? ORDER BY servertime DESC, rowid DESC LIMIT 0,?): 7, out of memory D/ONE SDK ( 1967): [2022/05/20 00:55:02:073]: sql result: 0 D/ONE SDK ( 1967): [2022/05/20 00:55:02:073]: sqlite failed to prepare statement (SELECT * FROM message WHERE conversation=? AND msgbody LIKE '%"msg":"%@小保%"%' AND servertime<? ORDER BY servertime DESC, rowid DESC LIMIT 0,?): 7, out of memory D/ONE SDK ( 1967): [2022/05/20 00:55:02:073]: sql result: 0 D/ONE SDK ( 1967): [2022/05/20 00:55:02:073]: sqlite failed to prepare statement (SELECT * FROM message WHERE conversation=? AND msgbody LIKE '%"msg":"%@小保%"%' AND servertime<? ORDER BY servertime DESC, rowid DESC LIMIT 0,?): 7, out of memory D/ONE SDK ( 1967): [2022/05/20 00:55:02:073]: sql result: 0 D/ONE SDK ( 1967): [2022/05/20 00:55:02:073]: sqlite failed to prepare statement (SELECT * FROM message WHERE conversation=? AND msgbody LIKE '%"msg":"%@小保%"%' AND servertime<? ORDER BY servertime DESC, rowid DESC LIMIT 0,?): 7, out of memory D/ONE SDK ( 1967): [2022/05/20 00:55:02:074]: sql result: 0 D/ONE SDK ( 1967): [2022/05/20 00:55:02:074]: sqlite failed to prepare statement (SELECT * FROM message WHERE conversation=? AND msgbody LIKE '%"msg":"%@小保%"%' AND servertime<? ORDER BY servertime DESC, rowid DESC LIMIT 0,?): 7, out of memory D/ONE SDK ( 1967): [2022/05/20 00:55:02:074]: sql result: 0 D/ONE SDK ( 1967): [2022/05/20 00:55:02:074]: sqlite failed to prepare statement (SELECT * FROM message WHERE conversation=? AND msgbody LIKE '%"msg":"%@小保%"%' AND servertime<? ORDER BY servertime DESC, rowid DESC LIMIT 0,?): 7, out of memory D/ONE SDK ( 1967): [2022/05/20 00:55:02:074]: sql result: 0 D/ONE SDK ( 1967): [2022/05/20 00:55:02:074]: sqlite failed to prepare statement (SELECT * FROM message WHERE conversation=? AND msgbody LIKE '%"msg":"%@小保%"%' AND servertime<? ORDER BY servertime DESC, rowid DESC LIMIT 0,?): 7, out of memory D/ONE SDK ( 1967): [2022/05/20 00:55:02:074]: sql result: 0 D/ONE SDK ( 1967): [2022/05/20 00:55:02:074]: sqlite failed to prepare statement (SELECT * FROM message WHERE conversation=? AND msgbody LIKE '%"msg":"%@小保%"%' AND servertime<? ORDER BY servertime DESC, rowid DESC LIMIT 0,?): 7, out of memory D/ONE SDK ( 1967): [2022/05/20 00:55:02:074]: sql result: 0 F/libc ( 1967): Fatal signal 11 (SIGSEGV), code 1 (SEGV_MAPERR), fault addr 0x0 in tid 10904 (pool-128-thread), pid 1967 (Shutdown thread) *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** Build fingerprint: 'Android/vbox86p/vbox86p:9/PI/138:userdebug/test-keys' Revision: '0' ABI: 'x86' pid: 1967, tid: 10904, name: pool-128-thread >>> com.xiangrui.baozhang <<< signal 11 (SIGSEGV), code 1 (SEGV_MAPERR), fault addr 0x0 Cause: null pointer dereference eax 00000000 ebx c2be96ec ecx 00000002 edx 00000001 edi 00010000 esi c07105e0 ebp 84ff8188 esp 84ff8160 eip c275eaef backtrace: #00 pc 000dbaef /data/app/com.xiangrui.baozhang-hYXkz4nr_tYNR8Qh9dJguw==/lib/x86/libhyphenate.so #01 pc 000dba87 /data/app/com.xiangrui.baozhang-hYXkz4nr_tYNR8Qh9dJguw==/lib/x86/libhyphenate.so #02 pc 000dba26 /data/app/com.xiangrui.baozhang-hYXkz4nr_tYNR8Qh9dJguw==/lib/x86/libhyphenate.so #03 pc 000db978 /data/app/com.xiangrui.baozhang-hYXkz4nr_tYNR8Qh9dJguw==/lib/x86/libhyphenate.so #04 pc 000db77d /data/app/com.xiangrui.baozhang-hYXkz4nr_tYNR8Qh9dJguw==/lib/x86/libhyphenate.so #05 pc 000db5aa /data/app/com.xiangrui.baozhang-hYXkz4nr_tYNR8Qh9dJguw==/lib/x86/libhyphenate.so #06 pc 000da95a /data/app/com.xiangrui.baozhang-hYXkz4nr_tYNR8Qh9dJguw==/lib/x86/libhyphenate.so #07 pc 000daa90 /data/app/com.xiangrui.baozhang-hYXkz4nr_tYNR8Qh9dJguw==/lib/x86/libhyphenate.so #08 pc 000da730 /data/app/com.xiangrui.baozhang-hYXkz4nr_tYNR8Qh9dJguw==/lib/x86/libhyphenate.so #09 pc 000da649 /data/app/com.xiangrui.baozhang-hYXkz4nr_tYNR8Qh9dJguw==/lib/x86/libhyphenate.so #10 pc 000da571 /data/app/com.xiangrui.baozhang-hYXkz4nr_tYNR8Qh9dJguw==/lib/x86/libhyphenate.so #11 pc 00166fa7 /data/app/com.xiangrui.baozhang-hYXkz4nr_tYNR8Qh9dJguw==/lib/x86/libhyphenate.so #12 pc 000d094e /data/app/com.xiangrui.baozhang-hYXkz4nr_tYNR8Qh9dJguw==/lib/x86/libhyphenate.so #13 pc 001a7a62 /data/app/com.xiangrui.baozhang-hYXkz4nr_tYNR8Qh9dJguw==/lib/x86/libhyphenate.so (Java_com_hyphenate_chat_adapter_EMAChatManager_nativeFetchConversationsFromServer+159) #14 pc 005f6b97 /system/lib/libart.so (art_quick_generic_jni_trampoline+71) #15 pc 005f0b82 /system/lib/libart.so (art_quick_invoke_stub+338) #16 pc 000a30ce /system/lib/libart.so (art::ArtMethod::Invoke(art::Thread*, unsigned int*, unsigned int, art::JValue*, char const*)+222) #17 pc 0029bca2 /system/lib/libart.so (art::interpreter::ArtInterpreterToCompiledCodeBridge(art::Thread*, art::ArtMethod*, art::ShadowFrame*, unsigned short, art::JValue*)+338) #18 pc 00293e48 /system/lib/libart.so (bool art::interpreter::DoCall<false, false>(art::ArtMethod*, art::Thread*, art::ShadowFrame&, art::Instruction const*, unsigned short, art::JValue*)+1048) #19 pc 005bc493 /system/lib/libart.so (MterpInvokeVirtual+691) #20 pc 005e2d21 /system/lib/libart.so (ExecuteMterpImpl+14241) #21 pc 003db09c /dev/ashmem/dalvik-classes.dex extracted in memory from /data/app/com.xiangrui.baozhang-hYXkz4nr_tYNR8Qh9dJguw==/base.apk (deleted) (com.hyphenate.chat.adapter.EMAChatManager.fetchConversationsFromServer) #22 pc 00266216 /system/lib/libart.so (_ZN3art11interpreterL7ExecuteEPNS_6ThreadERKNS_20CodeItemDataAccessorERNS_11ShadowFrameENS_6JValueEb.llvm.1549643468+598) #23 pc 0026c68e /system/lib/libart.so (art::interpreter::EnterInterpreterFromEntryPoint(art::Thread*, art::CodeItemDataAccessor const&, art::ShadowFrame*)+126) #24 pc 005a953d /system/lib/libart.so (artQuickToInterpreterBridge+1277) #25 pc 005f6c6d /system/lib/libart.so (art_quick_to_interpreter_bridge+77) #26 pc 000f0ba3 /dev/ashmem/dalvik-jit-code-cache (deleted) (com.hyphenate.chat.EMChatManager.fetchConversationsFromServer+99) #27 pc 005f0b82 /system/lib/libart.so (art_quick_invoke_stub+338) #28 pc 000a30ce /system/lib/libart.so (art::ArtMethod::Invoke(art::Thread*, unsigned int*, unsigned int, art::JValue*, char const*)+222) #29 pc 0029bca2 /system/lib/libart.so (art::interpreter::ArtInterpreterToCompiledCodeBridge(art::Thread*, art::ArtMethod*, art::ShadowFrame*, unsigned short, art::JValue*)+338) #30 pc 00293e48 /system/lib/libart.so (bool art::interpreter::DoCall<false, false>(art::ArtMethod*, art::Thread*, art::ShadowFrame&, art::Instruction const*, unsigned short, art::JValue*)+1048) #31 pc 005bc493 /system/lib/libart.so (MterpInvokeVirtual+691) #32 pc 005e2d21 /system/lib/libart.so (ExecuteMterpImpl+14241) #33 pc 0000e734 /dev/ashmem/dalvik-classes23.dex extracted in memory from /data/app/com.xiangrui.baozhang-hYXkz4nr_tYNR8Qh9dJguw==/base.apk!classes23.dex (deleted) (com.easemob.im_flutter_sdk.EMChatManagerWrapper.lambda$getConversationsFromServer$16$EMChatManagerWrapper+20) #34 pc 00266216 /system/lib/libart.so (_ZN3art11interpreterL7ExecuteEPNS_6ThreadERKNS_20CodeItemDataAccessorERNS_11ShadowFrameENS_6JValueEb.llvm.1549643468+598) #35 pc 0026c79c /system/lib/libart.so (art::interpreter::ArtInterpreterToInterpreterBridge(art::Thread*, art::CodeItemDataAccessor const&, art::ShadowFrame*, art::JValue*)+220) #36 pc 00293e2b /system/lib/libart.so (bool art::interpreter::DoCall<false, false>(art::ArtMethod*, art::Thread*, art::ShadowFrame&, art::Instruction const*, unsigned short, art::JValue*)+1019) #37 pc 005bc493 /system/lib/libart.so (MterpInvokeVirtual+691) #38 pc 005e2d21 /system/lib/libart.so (ExecuteMterpImpl+14241) #39 pc 0000a9b0 /dev/ashmem/dalvik-classes23.dex extracted in memory from /data/app/com.xiangrui.baozhang-hYXkz4nr_tYNR8Qh9dJguw==/base.apk!classes23.dex (deleted) (com.easemob.im_flutter_sdk.-$$Lambda$EMChatManagerWrapper$cT0bz_VhsQt9w7vb7UwHSVrYuvc.run+12) #40 pc 00266216 /system/lib/libart.so (_ZN3art11interpreterL7ExecuteEPNS_6ThreadERKNS_20CodeItemDataAccessorERNS_11ShadowFrameENS_6JValueEb.llvm.1549643468+598) #41 pc 0026c68e /system/lib/libart.so (art::interpreter::EnterInterpreterFromEntryPoint(art::Thread*, art::CodeItemDataAccessor const&, art::ShadowFrame*)+126) #42 pc 005a953d /system/lib/libart.so (artQuickToInterpreterBridge+1277) #43 pc 005f6c6d /system/lib/libart.so (art_quick_to_interpreter_bridge+77) #44 pc 00066b1a /dev/ashmem/dalvik-jit-code-cache (deleted) (java.util.concurrent.ThreadPoolExecutor.runWorker+378) #45 pc 0008afdb /dev/ashmem/dalvik-jit-code-cache (deleted) (java.util.concurrent.ThreadPoolExecutor$Worker.run+59) #46 pc 0008af4a /dev/ashmem/dalvik-jit-code-cache (deleted) (java.lang.Thread.run+74) #47 pc 005f0b82 /system/lib/libart.so (art_quick_invoke_stub+338) #48 pc 000a30ce /system/lib/libart.so (art::ArtMethod::Invoke(art::Thread*, unsigned int*, unsigned int, art::JValue*, char const*)+222) #49 pc 004d3349 /system/lib/libart.so (art::(anonymous namespace)::InvokeWithArgArray(art::ScopedObjectAccessAlreadyRunnable const&, art::ArtMethod*, art::(anonymous namespace)::ArgArray*, art::JValue*, char const*)+89) #50 pc 004d45f7 /system/lib/libart.so (art::InvokeVirtualOrInterfaceWithJValues(art::ScopedObjectAccessAlreadyRunnable const&, _jobject*, _jmethodID*, jvalue*)+471) #51 pc 0050958c /system/lib/libart.so (art::Thread::CreateCallback(void*)+1484) #52 pc 0008f275 /system/lib/libc.so (__pthread_start(void*)+53) #53 pc 0002480b /system/lib/libc.so (__start_thread+75)
@ixre 这个是什么情况下出现的。
会话页免检查会话是否有 @我的内容
在会话页会出现大量的 sql result: 0, sqlite出现out of memory