im_flutter_sdk icon indicating copy to clipboard operation
im_flutter_sdk copied to clipboard

sqlite out of memory 导致APP闪退

Open ixre opened this issue 2 years ago • 2 comments

在会话页会出现大量的 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 avatar May 20 '22 05:05 ixre

@ixre 这个是什么情况下出现的。

dujiepeng avatar May 24 '22 18:05 dujiepeng

会话页免检查会话是否有 @我的内容

ixre avatar May 26 '22 03:05 ixre