long time running down errors log ----ANR---android,sqlite

long time running down errors log1.txt 

04-02 04:42:57.634: E/CursorWindow(13696): Could not allocate CursorWindow '/data/data/com.androidui.deviceui.function/databases/hgwServer.db' of size 2097152 due to error -24.

04-02 04:42:57.639: D/AndroidRuntime(13696): Shutting down VM
04-02 04:42:57.639: W/dalvikvm(13696): threadid=1: thread exiting with uncaught exception (group=0x40a661f8)
04-02 04:42:57.644: E/AndroidRuntime(13696): FATAL EXCEPTION: main
04-02 04:42:57.644: E/AndroidRuntime(13696): android.database.CursorWindowAllocationException: Cursor window allocation of 2048 kb failed. # Open Cursors=53 (# cursors opened by this proc=53)
04-02 04:42:57.644: E/AndroidRuntime(13696): at android.database.CursorWindow.<init>(CursorWindow.java:104)
04-02 04:42:57.644: E/AndroidRuntime(13696): at android.database.AbstractWindowedCursor.clearOrCreateWindow(AbstractWindowedCursor.java:198)
04-02 04:42:57.644: E/AndroidRuntime(13696): at android.database.sqlite.SQLiteCursor.fillWindow(SQLiteCursor.java:162)
04-02 04:42:57.644: E/AndroidRuntime(13696): at android.database.sqlite.SQLiteCursor.getCount(SQLiteCursor.java:156)
04-02 04:42:57.644: E/AndroidRuntime(13696): at android.database.AbstractCursor.moveToPosition(AbstractCursor.java:161)
04-02 04:42:57.644: E/AndroidRuntime(13696): at android.database.AbstractCursor.moveToFirst(AbstractCursor.java:201)
04-02 04:43:52.269: E/SqliteDatabaseCpp(13696): sqlite3_open_v2("/data/data/com.androidui.deviceui.function/databases/hgwServer.db", &handle, 6, NULL) failed
04-02 04:43:52.269: E/SQLiteDatabase(13696): Failed to open the database. closing it.
04-02 04:43:52.269: E/SQLiteDatabase(13696): android.database.sqlite.SQLiteCantOpenDatabaseException: unable to open database file
04-02 04:43:52.269: E/SQLiteDatabase(13696): at android.database.sqlite.SQLiteDatabase.dbopen(Native Method)
04-02 04:43:52.269: E/SQLiteDatabase(13696): at android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:1013)
04-02 04:43:52.269: E/SQLiteDatabase(13696): at android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:986)
04-02 04:43:52.269: E/SQLiteDatabase(13696): at android.database.sqlite.SQLiteDatabase.openOrCreateDatabase(SQLiteDatabase.java:1051)
04-02 04:43:52.269: E/SQLiteDatabase(13696): at android.app.ContextImpl.openOrCreateDatabase(ContextImpl.java:786)
04-02 04:43:52.269: E/SQLiteDatabase(13696): at android.content.ContextWrapper.openOrCreateDatabase(ContextWrapper.java:221)
04-02 04:43:52.269: E/SQLiteDatabase(13696): at android.database.sqlite.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:157)
04-02 04:43:52.269: E/SQLiteDatabase(13696): at com.example.hgwdb.DBManager.<init>(DBManager.java:23)
04-02 04:43:52.269: E/SQLiteDatabase(13696): at com.hgw.Svr.ServerThread$NodeList.updateOtherNodeTimer(ServerThread.java:718)
04-02 04:43:52.269: E/SQLiteDatabase(13696): at com.hgw.Svr.ServerThread$Service.run(ServerThread.java:317)
04-02 04:43:52.269: E/SQLiteDatabase(13696): at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1076)
04-02 04:43:52.269: E/SQLiteDatabase(13696): at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:569)

04-02 04:43:52.269: E/SQLiteDatabase(13696): at java.lang.Thread.run(Thread.java:856)

long time running down errors log2.txt 

04-02 08:32:58.059: E/SurfaceHolder(4788): Exception locking surface
04-02 08:32:58.059: E/SurfaceHolder(4788): java.lang.IllegalArgumentException
04-02 08:32:58.059: E/SurfaceHolder(4788): at android.view.Surface.lockCanvasNative(Native Method)
04-02 08:32:58.059: E/SurfaceHolder(4788): at android.view.Surface.lockCanvas(Surface.java:76)
04-02 08:32:58.059: E/SurfaceHolder(4788): at android.view.SurfaceView$4.internalLockCanvas(SurfaceView.java:744)
04-02 08:32:58.059: E/SurfaceHolder(4788): at android.view.SurfaceView$4.lockCanvas(SurfaceView.java:720)
04-02 08:32:58.059: E/SurfaceHolder(4788): at com.androidui.deviceui.function.AirhumidMain$4.surfaceCreated(AirhumidMain.java:323)
04-02 08:32:58.059: E/SurfaceHolder(4788): at android.view.SurfaceView.updateWindow(SurfaceView.java:533)
04-02 08:32:58.059: E/SurfaceHolder(4788): at android.view.SurfaceView.access$000(SurfaceView.java:81)
04-02 08:32:58.059: E/SurfaceHolder(4788): at android.view.SurfaceView$3.onPreDraw(SurfaceView.java:169)
04-02 08:32:58.059: E/SurfaceHolder(4788): at android.view.ViewTreeObserver.dispatchOnPreDraw(ViewTreeObserver.java:590)
04-02 08:32:58.059: E/SurfaceHolder(4788): at android.view.ViewRootImpl.performTraversals(ViewRootImpl.java:1617)
04-02 08:32:58.059: E/SurfaceHolder(4788): at android.view.ViewRootImpl.handleMessage(ViewRootImpl.java:2442)
04-02 08:32:58.059: E/SurfaceHolder(4788): at android.os.Handler.dispatchMessage(Handler.java:99)
04-02 08:32:58.059: E/SurfaceHolder(4788): at android.os.Looper.loop(Looper.java:137)
04-02 08:32:58.059: E/SurfaceHolder(4788): at android.app.ActivityThread.main(ActivityThread.java:4424)
04-02 08:32:58.059: E/SurfaceHolder(4788): at java.lang.reflect.Method.invokeNative(Native Method)
04-02 08:32:58.059: E/SurfaceHolder(4788): at java.lang.reflect.Method.invoke(Method.java:511)
04-02 08:32:58.059: E/SurfaceHolder(4788): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:787)
04-02 08:32:58.059: E/SurfaceHolder(4788): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:554)
04-02 08:32:58.059: E/SurfaceHolder(4788): at dalvik.system.NativeStart.main(Native Method)

long time running down errors log3.txt 

04-02 14:02:22.969: E/AndroidRuntime(3579): FATAL EXCEPTION: pool-1-thread-1
04-02 14:02:22.969: E/AndroidRuntime(3579): java.lang.RuntimeException: Can't create handler inside thread that has not called Looper.prepare()
04-02 14:02:22.969: E/AndroidRuntime(3579): at android.os.Handler.<init>(Handler.java:121)
04-02 14:02:22.969: E/AndroidRuntime(3579): at android.widget.Toast$TN.<init>(Toast.java:317)
04-02 14:02:22.969: E/AndroidRuntime(3579): at android.widget.Toast.<init>(Toast.java:91)
04-02 14:02:22.969: E/AndroidRuntime(3579): at android.widget.Toast.makeText(Toast.java:233)
04-02 14:02:22.969: E/AndroidRuntime(3579): at com.hgw.Svr.ServerThread$NodeList.updateOtherNodeTimer(ServerThread.java:725)
04-02 14:02:22.969: E/AndroidRuntime(3579): at com.hgw.Svr.ServerThread$Service.run(ServerThread.java:323)
04-02 14:02:22.969: E/AndroidRuntime(3579): at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1076)
04-02 14:02:22.969: E/AndroidRuntime(3579): at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:569)
04-02 14:02:22.969: E/AndroidRuntime(3579): at java.lang.Thread.run(Thread.java:856)

启动某shell脚本，长时间运行出现如下log information：

03-06 17:06:28.189: D/dalvikvm(20870): JIT unchain all for threadid=24
03-06 17:06:29.724: D/dalvikvm(20870): JIT unchain all for threadid=24
03-06 17:06:30.124: D/dalvikvm(20870): GC_CONCURRENT freed 791K, 11% free 9607K/10759K, paused 2ms+6ms
03-06 17:06:31.914: D/dalvikvm(20870): GC_CONCURRENT freed 1036K, 12% free 9610K/10823K, paused 2ms+7ms
03-06 17:06:33.464: D/dalvikvm(20870): JIT unchain all for threadid=24
03-06 17:06:33.864: D/dalvikvm(20870): GC_CONCURRENT freed 1022K, 12% free 9620K/10823K, paused 1ms+6ms
03-06 17:06:35.374: D/dalvikvm(20870): JIT unchain all for threadid=24
03-06 17:06:35.719: D/dalvikvm(20870): JIT unchain all for threadid=24
03-06 17:06:35.764: D/dalvikvm(20870): GC_CONCURRENT freed 1034K, 12% free 9612K/10823K, paused 1ms+7ms
03-06 17:06:37.304: D/dalvikvm(20870): JIT unchain all for threadid=24
03-06 17:06:37.659: D/dalvikvm(20870): JIT unchain all for threadid=24
03-06 17:06:37.709: D/dalvikvm(20870): GC_CONCURRENT freed 1026K, 12% free 9617K/10823K, paused 1ms+8ms
03-06 17:06:39.139: D/dalvikvm(20870): JIT unchain all for threadid=24
03-06 17:06:39.484: D/dalvikvm(20870): JIT unchain all for threadid=24
03-06 17:06:39.534: D/dalvikvm(20870): GC_CONCURRENT freed 1036K, 12% free 9608K/10823K, paused 2ms+7ms
03-06 17:06:41.014: D/dalvikvm(20870): JIT unchain all for threadid=24
03-06 17:06:41.374: D/dalvikvm(20870): JIT unchain all for threadid=24
03-06 17:06:41.424: D/dalvikvm(20870): GC_CONCURRENT freed 1025K, 12% free 9613K/10823K, paused 1ms+6ms
03-06 17:06:43.019: D/dalvikvm(20870): JIT unchain all for threadid=24
03-06 17:06:43.369: D/dalvikvm(20870): JIT unchain all for threadid=24
03-06 17:06:44.834: D/dalvikvm(20870): JIT unchain all for threadid=24
03-06 17:06:45.194: D/dalvikvm(20870): JIT unchain all for threadid=24
03-06 17:06:45.244: D/dalvikvm(20870): GC_CONCURRENT freed 1035K, 12% free 9605K/10823K, paused 1ms+6ms

原因不名的error：

03-07 21:03:29.034: E/WindowManager(2935): Activity com.androidui.deviceui.function.LogMain has leaked window com.android.internal.policy.impl.PhoneWindow$DecorView@41773130 that was originally added here
03-07 21:03:29.034: E/WindowManager(2935): android.view.WindowLeaked: Activity com.androidui.deviceui.function.LogMain has leaked window com.android.internal.policy.impl.PhoneWindow$DecorView@41773130 that was originally added here
03-07 21:03:29.034: E/WindowManager(2935): at android.view.ViewRootImpl.<init>(ViewRootImpl.java:344)
03-07 21:03:29.034: E/WindowManager(2935): at android.view.WindowManagerImpl.addView(WindowManagerImpl.java:267)
03-07 21:03:29.034: E/WindowManager(2935): at android.view.WindowManagerImpl.addView(WindowManagerImpl.java:215)
03-07 21:03:29.034: E/WindowManager(2935): at android.view.WindowManagerImpl$CompatModeWrapper.addView(WindowManagerImpl.java:140)
03-07 21:03:29.034: E/WindowManager(2935): at android.view.Window$LocalWindowManager.addView(Window.java:537)
03-07 21:03:29.034: E/WindowManager(2935): at android.app.Dialog.show(Dialog.java:278)
03-07 21:03:29.034: E/WindowManager(2935): at com.androidui.deviceui.function.LogMain.showTips(LogMain.java:237)
03-07 21:03:29.034: E/WindowManager(2935): at com.androidui.deviceui.function.LogMain.onOptionsItemSelected(LogMain.java:149)
03-07 21:03:29.034: E/WindowManager(2935): at android.app.Activity.onMenuItemSelected(Activity.java:2502)
03-07 21:03:29.034: E/WindowManager(2935): at com.android.internal.policy.impl.PhoneWindow.onMenuItemSelected(PhoneWindow.java:950)
03-07 21:03:29.034: E/WindowManager(2935): at com.android.internal.view.menu.MenuBuilder.dispatchMenuItemSelected(MenuBuilder.java:735)
03-07 21:03:29.034: E/WindowManager(2935): at com.android.internal.view.menu.MenuItemImpl.invoke(MenuItemImpl.java:149)
03-07 21:03:29.034: E/WindowManager(2935): at com.android.internal.view.menu.MenuBuilder.performItemAction(MenuBuilder.java:874)
03-07 21:03:29.034: E/WindowManager(2935): at com.android.internal.view.menu.ActionMenuView.invokeItem(ActionMenuView.java:490)
03-07 21:03:29.034: E/WindowManager(2935): at com.android.internal.view.menu.ActionMenuItemView.onClick(ActionMenuItemView.java:108)
03-07 21:03:29.034: E/WindowManager(2935): at android.view.View.performClick(View.java:3511)
03-07 21:03:29.034: E/WindowManager(2935): at android.view.View$PerformClick.run(View.java:14105)
03-07 21:03:29.034: E/WindowManager(2935): at android.os.Handler.handleCallback(Handler.java:605)
03-07 21:03:29.034: E/WindowManager(2935): at android.os.Handler.dispatchMessage(Handler.java:92)
03-07 21:03:29.034: E/WindowManager(2935): at android.os.Looper.loop(Looper.java:137)
03-07 21:03:29.034: E/WindowManager(2935): at android.app.ActivityThread.main(ActivityThread.java:4424)
03-07 21:03:29.034: E/WindowManager(2935): at java.lang.reflect.Method.invokeNative(Native Method)
03-07 21:03:29.034: E/WindowManager(2935): at java.lang.reflect.Method.invoke(Method.java:511)
03-07 21:03:29.034: E/WindowManager(2935): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:787)
03-07 21:03:29.034: E/WindowManager(2935): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:554)
03-07 21:03:29.034: E/WindowManager(2935): at dalvik.system.NativeStart.main(Native Method)

03-14 01:35:04.509: E/NotificationService(1046): Package has already posted 50 toasts. Not showing more. Package=com.androidui.deviceui.function
03-14 01:35:05.549: E/NotificationService(1046): Package has already posted 50 toasts. Not showing more. Package=com.androidui.deviceui.function
03-14 01:35:05.584: E/NotificationService(1046): Package has already posted 50 toasts. Not showing more. Package=com.androidui.deviceui.function
03-14 01:35:06.529: E/NotificationService(1046): Package has already posted 50 toasts. Not showing more. Package=com.androidui.deviceui.function
03-14 01:35:06.554: E/NotificationService(1046): Package has already posted 50 toasts. Not showing more. Package=com.androidui.deviceui.function
03-14 01:35:07.514: E/NotificationService(1046): Package has already posted 50 toasts. Not showing more. Package=com.androidui.deviceui.function
03-14 01:35:08.494: E/NotificationService(1046): Package has already posted 50 toasts. Not showing more. Package=com.androidui.deviceui.function
03-14 01:35:08.504: E/NotificationService(1046): Package has already posted 50 toasts. Not showing more. Package=com.androidui.deviceui.function
03-14 01:35:08.519: E/NotificationService(1046): Package has already posted 50 toasts. Not showing more. Package=com.androidui.deviceui.function
03-14 01:35:09.254: D/dalvikvm(2062): GC_CONCURRENT freed 1883K, 15% free 14577K/16967K, paused 2ms+18ms
03-14 01:35:09.504: E/NotificationService(1046): Package has already posted 50 toasts. Not showing more. Package=com.androidui.deviceui.function
03-14 01:35:09.519: E/NotificationService(1046): Package has already posted 50 toasts. Not showing more. Package=com.androidui.deviceui.function
03-14 01:35:10.474: E/System(2062): at android.util.LruCache.trimToSize(LruCache.java:197)
03-14 01:35:10.614: E/NotificationService(1046): Package has already posted 50 toasts. Not showing more. Package=com.androidui.deviceui.function
03-14 01:35:10.634: E/NotificationService(1046): Package has already posted 50 toasts. Not showing more. Package=com.androidui.deviceui.function

需要查明白的问题：

1.Toast长时间运用会引起的错误，因为某个页面的Toast可以出现在app的任何一个page里面，有点像是后台线程，这个问题需要进一步查

2.数据库sqlite的最佳使用方式，使用后的close操作要很得当才不会有error出现，此处需要进一步查

3.线程在不使用的时候正常stop，这部分功能暂时还没有完全消化

出现的错误正在解决中ing