我从服务器中获取大量数据.我使用Get方法来获得响应,我能够得到响应,但问题是在解析应用程序之间崩溃是因为某些“HeapWorker被楔入”错误.
logcat的
- 12-20 10:02:55.111: ERROR/dalvikvm(277): HeapWorker is wedged: 10194ms spent inside Landroid/database/sqlite/sqliteCursor;.finalize()V
- 12-20 10:02:55.111: INFO/dalvikvm(277): DALVIK THREADS:
- 12-20 10:02:55.111: INFO/dalvikvm(277): "main" prio=5 tid=3 NATIVE
- 12-20 10:02:55.111: INFO/dalvikvm(277): | group="main" sCount=1 dsCount=0 s=Y obj=0x4001b268 self=0xbd00
- 12-20 10:02:55.111: INFO/dalvikvm(277): | sysTid=277 nice=0 sched=0/0 cgrp=default handle=-1344001384
- 12-20 10:02:55.111: INFO/dalvikvm(277): at android.graphics.NinePatch.nativeDraw(Native Method)
- 12-20 10:02:55.111: INFO/dalvikvm(277): at android.graphics.NinePatch.draw(NinePatch.java:104)
- 12-20 10:02:55.111: INFO/dalvikvm(277): at android.graphics.drawable.NinePatchDrawable.draw(NinePatchDrawable.java:188)
- 12-20 10:02:55.121: INFO/dalvikvm(277): at android.view.View.draw(View.java:6520)
- 12-20 10:02:55.121: INFO/dalvikvm(277): at android.widget.FrameLayout.draw(FrameLayout.java:352)
- 12-20 10:02:55.121: INFO/dalvikvm(277): at android.view.ViewGroup.drawChild(ViewGroup.java:1531)
- 12-20 10:02:55.121: INFO/dalvikvm(277): at android.view.ViewGroup.dispatchDraw(ViewGroup.java:1258)
- 12-20 10:02:55.121: INFO/dalvikvm(277): at android.view.ViewGroup.drawChild(ViewGroup.java:1529)
- 12-20 10:02:55.121: INFO/dalvikvm(277): at android.view.ViewGroup.dispatchDraw(ViewGroup.java:1258)
- 12-20 10:02:55.121: INFO/dalvikvm(277): at android.view.ViewGroup.drawChild(ViewGroup.java:1529)
- 12-20 10:02:55.121: INFO/dalvikvm(277): at android.view.ViewGroup.dispatchDraw(ViewGroup.java:1258)
- 12-20 10:02:55.121: INFO/dalvikvm(277): at android.view.View.draw(View.java:6538)
- 12-20 10:02:55.121: INFO/dalvikvm(277): at android.widget.FrameLayout.draw(FrameLayout.java:352)
- 12-20 10:02:55.121: INFO/dalvikvm(277): at com.android.internal.policy.impl.PhoneWindow$DecorView.draw(PhoneWindow.java:1830)
- 12-20 10:02:55.121: INFO/dalvikvm(277): at android.view.ViewRoot.draw(ViewRoot.java:1349)
- 12-20 10:02:55.121: INFO/dalvikvm(277): at android.view.ViewRoot.performTraversals(ViewRoot.java:1114)
- 12-20 10:02:55.121: INFO/dalvikvm(277): at android.view.ViewRoot.handleMessage(ViewRoot.java:1633)
- 12-20 10:02:55.132: INFO/dalvikvm(277): at android.os.Handler.dispatchMessage(Handler.java:99)
- 12-20 10:02:55.132: INFO/dalvikvm(277): at android.os.Looper.loop(Looper.java:123)
- 12-20 10:02:55.132: INFO/dalvikvm(277): at android.app.ActivityThread.main(ActivityThread.java:4363)
- 12-20 10:02:55.132: INFO/dalvikvm(277): at java.lang.reflect.Method.invokeNative(Native Method)
- 12-20 10:02:55.132: INFO/dalvikvm(277): at java.lang.reflect.Method.invoke(Method.java:521)
- 12-20 10:02:55.132: INFO/dalvikvm(277): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:860)
- 12-20 10:02:55.132: INFO/dalvikvm(277): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:618)
- 12-20 10:02:55.132: INFO/dalvikvm(277): at dalvik.system.NativeStart.main(Native Method)
- 12-20 10:02:55.132: INFO/dalvikvm(277): "AsyncTask #1" prio=5 tid=15 RUNNABLE
- 12-20 10:02:55.132: INFO/dalvikvm(277): | group="main" sCount=0 dsCount=0 s=N obj=0x44dd0bd0 self=0x125a30
- 12-20 10:02:55.132: INFO/dalvikvm(277): | sysTid=283 nice=0 sched=0/0 cgrp=default handle=1203016
- 12-20 10:02:55.132: INFO/dalvikvm(277): at java.io.BufferedWriter.<init>(BufferedWriter.java:~67)
- 12-20 10:02:55.132: INFO/dalvikvm(277): at uk.co.dodec.ukrcmobileapp.helper.UDFHelper.createHtml(UDFHelper.java:167)
- 12-20 10:02:55.132: INFO/dalvikvm(277): at uk.co.dodec.ukrcmobileapp.helper.XMLParser.parseUpdates(XMLParser.java:510)
- 12-20 10:02:55.132: INFO/dalvikvm(277): at uk.co.dodec.ukrcmobileapp.Homepage$getUpdateTask.doInBackground(Homepage.java:170)
- 12-20 10:02:55.132: INFO/dalvikvm(277): at uk.co.dodec.ukrcmobileapp.Homepage$getUpdateTask.doInBackground(Homepage.java:1)
- 12-20 10:02:55.132: INFO/dalvikvm(277): at android.os.AsyncTask$2.call(AsyncTask.java:185)
- 12-20 10:02:55.132: INFO/dalvikvm(277): at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:305)
- 12-20 10:02:55.132: INFO/dalvikvm(277): at java.util.concurrent.FutureTask.run(FutureTask.java:137)
- 12-20 10:02:55.141: INFO/dalvikvm(277): at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1068)
- 12-20 10:02:55.141: INFO/dalvikvm(277): at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:561)
- 12-20 10:02:55.141: INFO/dalvikvm(277): at java.lang.Thread.run(Thread.java:1096)
- 12-20 10:02:55.141: INFO/dalvikvm(277): "Binder Thread #2" prio=5 tid=13 NATIVE
- 12-20 10:02:55.141: INFO/dalvikvm(277): | group="main" sCount=1 dsCount=0 s=N obj=0x44da1c38 self=0x11d3c8
- 12-20 10:02:55.141: INFO/dalvikvm(277): | sysTid=282 nice=0 sched=0/0 cgrp=default handle=1343552
- 12-20 10:02:55.141: INFO/dalvikvm(277): at dalvik.system.NativeStart.run(Native Method)
- 12-20 10:02:55.141: INFO/dalvikvm(277): "Binder Thread #1" prio=5 tid=11 NATIVE
- 12-20 10:02:55.141: INFO/dalvikvm(277): | group="main" sCount=1 dsCount=0 s=N obj=0x44d9dea8 self=0x14d8d0
- 12-20 10:02:55.141: INFO/dalvikvm(277): | sysTid=281 nice=0 sched=0/0 cgrp=default handle=1366160
- 12-20 10:02:55.141: INFO/dalvikvm(277): at dalvik.system.NativeStart.run(Native Method)
- 12-20 10:02:55.141: INFO/dalvikvm(277): "JDWP" daemon prio=5 tid=9 VMWAIT
- 12-20 10:02:55.141: INFO/dalvikvm(277): | group="system" sCount=1 dsCount=0 s=N obj=0x44d9b2a0 self=0x145338
- 12-20 10:02:55.141: INFO/dalvikvm(277): | sysTid=280 nice=0 sched=0/0 cgrp=default handle=1331744
- 12-20 10:02:55.141: INFO/dalvikvm(277): at dalvik.system.NativeStart.run(Native Method)
- 12-20 10:02:55.141: INFO/dalvikvm(277): "Signal Catcher" daemon prio=5 tid=7 VMWAIT
- 12-20 10:02:55.141: INFO/dalvikvm(277): | group="system" sCount=1 dsCount=0 s=N obj=0x44d9b1e8 self=0x145108
- 12-20 10:02:55.141: INFO/dalvikvm(277): | sysTid=279 nice=0 sched=0/0 cgrp=default handle=1262808
- 12-20 10:02:55.141: INFO/dalvikvm(277): at dalvik.system.NativeStart.run(Native Method)
- 12-20 10:02:55.151: INFO/dalvikvm(277): "HeapWorker" daemon prio=5 tid=5 WAIT
- 12-20 10:02:55.151: INFO/dalvikvm(277): | group="system" sCount=1 dsCount=0 s=N obj=0x4369a188 self=0x1343c0
- 12-20 10:02:55.151: INFO/dalvikvm(277): | sysTid=278 nice=0 sched=0/0 cgrp=default handle=1208016
- 12-20 10:02:55.151: INFO/dalvikvm(277): at java.lang.Object.wait(Native Method)
- 12-20 10:02:55.151: INFO/dalvikvm(277): - waiting on <0x3362f0> (a java.lang.VMThread)
- 12-20 10:02:55.151: INFO/dalvikvm(277): at java.lang.Thread.parkFor(Thread.java:1535)
- 12-20 10:02:55.151: INFO/dalvikvm(277): at java.lang.LangAccessImpl.parkFor(LangAccessImpl.java:48)
- 12-20 10:02:55.151: INFO/dalvikvm(277): at sun.misc.Unsafe.park(Unsafe.java:317)
- 12-20 10:02:55.151: INFO/dalvikvm(277): at java.util.concurrent.locks.LockSupport.park(LockSupport.java:131)
- 12-20 10:02:55.151: INFO/dalvikvm(277): at java.util.concurrent.locks.AbstractQueuedSynchronizer.parkAndCheckInterrupt(AbstractQueuedSynchronizer.java:790)
- 12-20 10:02:55.151: INFO/dalvikvm(277): at java.util.concurrent.locks.AbstractQueuedSynchronizer.acquireQueued(AbstractQueuedSynchronizer.java:823)
- 12-20 10:02:55.151: INFO/dalvikvm(277): at java.util.concurrent.locks.AbstractQueuedSynchronizer.acquire(AbstractQueuedSynchronizer.java:1153)
- 12-20 10:02:55.151: INFO/dalvikvm(277): at java.util.concurrent.locks.ReentrantLock$FairSync.lock(ReentrantLock.java:200)
- 12-20 10:02:55.151: INFO/dalvikvm(277): at java.util.concurrent.locks.ReentrantLock.lock(ReentrantLock.java:261)
- 12-20 10:02:55.151: INFO/dalvikvm(277): at android.database.sqlite.sqliteDatabase.lock(sqliteDatabase.java:305)
- 12-20 10:02:55.151: INFO/dalvikvm(277): at android.database.sqlite.sqliteProgram.close(sqliteProgram.java:219)
- 12-20 10:02:55.151: INFO/dalvikvm(277): at android.database.sqlite.sqliteQuery.close(sqliteQuery.java:141)
- 12-20 10:02:55.151: INFO/dalvikvm(277): at android.database.sqlite.sqliteCursor.close(sqliteCursor.java:507)
- 12-20 10:02:55.151: INFO/dalvikvm(277): at android.database.sqlite.sqliteCursor.finalize(sqliteCursor.java:586)
- 12-20 10:02:55.151: INFO/dalvikvm(277): at dalvik.system.NativeStart.run(Native Method)
- 12-20 10:02:55.151: ERROR/dalvikvm(277): VM aborting
- 12-20 10:02:55.296: INFO/DEBUG(28): *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** ***
- 12-20 10:02:55.296: INFO/DEBUG(28): signal 11 (SIGSEGV),fault addr deadd00d
- 12-20 10:02:55.296: INFO/DEBUG(28): r0 00000354 r1 afe1331d r2 0000000c r3 deadd00d
- 12-20 10:02:55.296: INFO/DEBUG(28): r4 00000026 r5 400091e8 r6 ad065714 r7 003fca30
- 12-20 10:02:55.296: INFO/DEBUG(28): r8 00000344 r9 00000001 10 ad080c00 fp 00000000
- 12-20 10:02:55.296: INFO/DEBUG(28): ip ad080160 sp 46a32c58 lr afe142dd pc ad035452 cpsr 20000030
- 12-20 10:02:55.391: INFO/DEBUG(28): #00 pc 00035452 /system/lib/libdvm.so
- 12-20 10:02:55.391: INFO/DEBUG(28): #01 pc 000440d8 /system/lib/libdvm.so
- 12-20 10:02:55.391: INFO/DEBUG(28): #02 pc 0001680c /system/lib/libdvm.so
- 12-20 10:02:55.391: INFO/DEBUG(28): #03 pc 000170c4 /system/lib/libdvm.so
- 12-20 10:02:55.391: INFO/DEBUG(28): #04 pc 0001724c /system/lib/libdvm.so
- 12-20 10:02:55.401: INFO/DEBUG(28): #05 pc 00055b52 /system/lib/libdvm.so
- 12-20 10:02:55.401: INFO/DEBUG(28): #06 pc 00055c80 /system/lib/libdvm.so
- 12-20 10:02:55.401: INFO/DEBUG(28): #07 pc 00055d80 /system/lib/libdvm.so
- 12-20 10:02:55.401: INFO/DEBUG(28): #08 pc 0001353c /system/lib/libdvm.so
- 12-20 10:02:55.411: INFO/DEBUG(28): #09 pc 00019888 /system/lib/libdvm.so
- 12-20 10:02:55.411: INFO/DEBUG(28): #10 pc 00018d5c /system/lib/libdvm.so
- 12-20 10:02:55.411: INFO/DEBUG(28): #11 pc 0004d6d0 /system/lib/libdvm.so
- 12-20 10:02:55.411: INFO/DEBUG(28): #12 pc 0004d702 /system/lib/libdvm.so
- 12-20 10:02:55.411: INFO/DEBUG(28): #13 pc 00041c78 /system/lib/libdvm.so
- 12-20 10:02:55.411: INFO/DEBUG(28): #14 pc 00010000 /system/lib/libc.so
- 12-20 10:02:55.411: INFO/DEBUG(28): #15 pc 0000fad4 /system/lib/libc.so
- 12-20 10:02:55.411: INFO/DEBUG(28): code around pc:
- 12-20 10:02:55.411: INFO/DEBUG(28): ad035440 4808ecb6 6b9b5823 d0002b00 4b064798
- 12-20 10:02:55.411: INFO/DEBUG(28): ad035450 701c2426 ed28f7d9 0004ab1c fffe57c4
- 12-20 10:02:55.411: INFO/DEBUG(28): ad035460 fffe8c30 00000354 deadd00d b510b40e
- 12-20 10:02:55.411: INFO/DEBUG(28): code around lr:
- 12-20 10:02:55.422: INFO/DEBUG(28): afe142cc 220ce008 2b005eab 1c28d003 47889901
- 12-20 10:02:55.422: INFO/DEBUG(28): afe142dc 35544306 d5f43f01 2c006824 b003d1ee
- 12-20 10:02:55.422: INFO/DEBUG(28): afe142ec bdf01c30 00024b44 000000b4 1c0fb5f0
- 12-20 10:02:55.422: INFO/DEBUG(28): stack:
- 12-20 10:02:55.422: INFO/DEBUG(28): 46a32c18 00000015
- 12-20 10:02:55.422: INFO/DEBUG(28): 46a32c1c afe1334d /system/lib/libc.so
- 12-20 10:02:55.422: INFO/DEBUG(28): 46a32c20 afe3902c /system/lib/libc.so
- 12-20 10:02:55.422: INFO/DEBUG(28): 46a32c24 afe38fd8 /system/lib/libc.so
- 12-20 10:02:55.422: INFO/DEBUG(28): 46a32c28 00000000
- 12-20 10:02:55.422: INFO/DEBUG(28): 46a32c2c afe142dd /system/lib/libc.so
- 12-20 10:02:55.422: INFO/DEBUG(28): 46a32c30 46a32c44
- 12-20 10:02:55.422: INFO/DEBUG(28): 46a32c34 afe1331d /system/lib/libc.so
- 12-20 10:02:55.422: INFO/DEBUG(28): 46a32c38 ad065714 /system/lib/libdvm.so
- 12-20 10:02:55.422: INFO/DEBUG(28): 46a32c3c ad07ff50 /system/lib/libdvm.so
- 12-20 10:02:55.422: INFO/DEBUG(28): 46a32c40 400091e8 /dev/ashmem/mspace/dalvik-heap/zygote/0 (deleted)
- 12-20 10:02:55.422: INFO/DEBUG(28): 46a32c44 ad065714 /system/lib/libdvm.so
- 12-20 10:02:55.431: INFO/DEBUG(28): 46a32c48 003fca30 [heap]
- 12-20 10:02:55.431: INFO/DEBUG(28): 46a32c4c afe1337f /system/lib/libc.so
- 12-20 10:02:55.431: INFO/DEBUG(28): 46a32c50 df002777
- 12-20 10:02:55.431: INFO/DEBUG(28): 46a32c54 e3a070ad
- 12-20 10:02:55.431: INFO/DEBUG(28): #00 46a32c58 ad06ccd7 /system/lib/libdvm.so
- 12-20 10:02:55.431: INFO/DEBUG(28): 46a32c5c ad0440dd /system/lib/libdvm.so
- 12-20 10:02:55.431: INFO/DEBUG(28): #01 46a32c60 000027d2
- 12-20 10:02:55.431: INFO/DEBUG(28): 46a32c64 00000000
- 12-20 10:02:55.431: INFO/DEBUG(28): 46a32c68 42a58733 /data/dalvik-cache/system@framework@framework.jar@classes.dex
- 12-20 10:02:55.431: INFO/DEBUG(28): 46a32c6c 42ad950b /data/dalvik-cache/system@framework@framework.jar@classes.dex
- 12-20 10:02:55.431: INFO/DEBUG(28): 46a32c70 003fca30 [heap]
- 12-20 10:02:55.431: INFO/DEBUG(28): 46a32c74 0000011b
- 12-20 10:02:55.431: INFO/DEBUG(28): 46a32c78 ad080f8c /system/lib/libdvm.so
- 12-20 10:02:55.431: INFO/DEBUG(28): 46a32c7c afe0f3b0 /system/lib/libc.so
- 12-20 10:02:55.431: INFO/DEBUG(28): 46a32c80 009b8cc3
- 12-20 10:02:55.431: INFO/DEBUG(28): 46a32c84 00000000
- 12-20 10:02:55.431: INFO/DEBUG(28): 46a32c88 00000354
- 12-20 10:02:55.431: INFO/DEBUG(28): 46a32c8c 400091e8 /dev/ashmem/mspace/dalvik-heap/zygote/0 (deleted)
- 12-20 10:02:55.431: INFO/DEBUG(28): 46a32c90 ad07ff50 /system/lib/libdvm.so
- 12-20 10:02:55.431: INFO/DEBUG(28): 46a32c94 00000354
- 12-20 10:02:55.431: INFO/DEBUG(28): 46a32c98 0000000a
- 12-20 10:02:55.431: INFO/DEBUG(28): 46a32c9c ad016810 /system/lib/libdvm.so
解决方法
我找到了解决问题的方法
我在解析数据和将数据插入数据库时使用事务.
但在这之间我试图从数据库中获取一些值.
这样的层次结构如下
我在解析数据和将数据插入数据库时使用事务.
但在这之间我试图从数据库中获取一些值.
这样的层次结构如下
- <transaction>
- <Insert>
- <select>
- <insert>
- </transaction>
我正在尝试在数据库上运行select查询,而数据库在事务中.
实际上这里有一个关于concurrent transaction的解决方案
sql命令“BEGIN TRANSACTION”(TRANSACTION关键字是可选的)用于使sqlite脱离自动提交模式.请注意,BEGIN命令不会获取数据库上的任何锁定.在BEGIN命令之后,执行第一个SELECT语句时将获取SHARED锁.执行第一个INSERT,UPDATE或DELETE语句时将获取RESERVED锁.在内存缓存填满并且必须溢出到磁盘或事务提交之前,不会获取EXCLUSIVE锁.通过这种方式,系统延迟阻止对文件文件的读访问,直到最后一刻.
编辑
另外还有一个解决方案是你设置锁定启用false就像
- mDb.setLockingEnabled(false);