08-23 14:32:53.697: E/Trace(3697): error opening trace file: No such file or directory (2)
08-23 14:32:53.757: D/dalvikvm(3697): GC_FOR_ALLOC freed 37K, 6% free 2616K/2768K, paused 1ms, total 9ms
08-23 14:32:53.757: I/dalvikvm-heap(3697): Grow heap (frag case) to 3.738MB for 1127532-byte allocation
08-23 14:32:53.769: D/dalvikvm(3697): GC_FOR_ALLOC freed 2K, 5% free 3714K/3872K, paused 12ms, total 12ms
08-23 14:32:53.773: D/dalvikvm(3697): GC_CONCURRENT freed 0K, 5% free 3715K/3872K, paused 2ms+0ms, total 4ms
08-23 14:32:53.805: D/libEGL(3697): loaded /system/lib/egl/libEGL_emulation.so
08-23 14:32:53.809: D/(3697): HostConnection::get() New Host Connection established 0xb955c810, tid 3697
08-23 14:32:53.813: D/libEGL(3697): loaded /system/lib/egl/libGLESv1_CM_emulation.so
08-23 14:32:53.817: D/libEGL(3697): loaded /system/lib/egl/libGLESv2_emulation.so
08-23 14:32:53.869: W/EGL_emulation(3697): eglSurfaceAttrib not implemented
08-23 14:32:53.877: D/OpenGLRenderer(3697): Enabling debug mode 0
08-23 14:32:57.121: W/EGL_emulation(3697): eglSurfaceAttrib not implemented
08-23 14:32:59.485: D/AndroidRuntime(3697): Shutting down VM
08-23 14:32:59.485: W/dalvikvm(3697): threadid=1: thread exiting with uncaught exception (group=0xa61ed908)
08-23 14:32:59.485: E/AndroidRuntime(3697): FATAL EXCEPTION: main
08-23 14:32:59.485: E/AndroidRuntime(3697): android.database.sqlite.SQLiteConstraintException: PRIMARY KEY must be unique (code 19)
08-23 14:32:59.485: E/AndroidRuntime(3697): at android.database.sqlite.SQLiteConnection.nativeExecuteForChangedRowCount(Native Method)
08-23 14:32:59.485: E/AndroidRuntime(3697): at android.database.sqlite.SQLiteConnection.executeForChangedRowCount(SQLiteConnection.java:727)
08-23 14:32:59.485: E/AndroidRuntime(3697): at android.database.sqlite.SQLiteSession.executeForChangedRowCount(SQLiteSession.java:754)
08-23 14:32:59.485: E/AndroidRuntime(3697): at android.database.sqlite.SQLiteStatement.executeUpdateDelete(SQLiteStatement.java:64)
08-23 14:32:59.485: E/AndroidRuntime(3697): at android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1665)
08-23 14:32:59.485: E/AndroidRuntime(3697): at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1594)
08-23 14:32:59.485: E/AndroidRuntime(3697): at test.dbtest2.MainActivity.InsertData(MainActivity.java:190)
08-23 14:32:59.485: E/AndroidRuntime(3697): at test.dbtest2.MainActivity.access$0(MainActivity.java:183)
08-23 14:32:59.485: E/AndroidRuntime(3697): at test.dbtest2.MainActivity$1.onClick(MainActivity.java:69)
08-23 14:32:59.485: E/AndroidRuntime(3697): at android.view.View.performClick(View.java:4204)
08-23 14:32:59.485: E/AndroidRuntime(3697): at android.view.View$PerformClick.run(View.java:17355)
08-23 14:32:59.485: E/AndroidRuntime(3697): at android.os.Handler.handleCallback(Handler.java:725)
08-23 14:32:59.485: E/AndroidRuntime(3697): at android.os.Handler.dispatchMessage(Handler.java:92)
08-23 14:32:59.485: E/AndroidRuntime(3697): at android.os.Looper.loop(Looper.java:137)
08-23 14:32:59.485: E/AndroidRuntime(3697): at android.app.ActivityThread.main(ActivityThread.java:5041)
08-23 14:32:59.485: E/AndroidRuntime(3697): at java.lang.reflect.Method.invokeNative(Native Method)
08-23 14:32:59.485: E/AndroidRuntime(3697): at java.lang.reflect.Method.invoke(Method.java:511)
08-23 14:32:59.485: E/AndroidRuntime(3697): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:793)
08-23 14:32:59.485: E/AndroidRuntime(3697): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:560)
08-23 14:32:59.485: E/AndroidRuntime(3697): at dalvik.system.NativeStart.main(Native Method)
08-23 14:32:59.489: D/dalvikvm(3697): GC_CONCURRENT freed 87K, 5% free 4012K/4216K, paused 2ms+1ms, total 4ms
위에는 로그캣 오류를 적어논 것이구요.
텍스트필드에 입력을 받아 입력받은 데이터를 데이터베이스에 넣고 데이터베이스에 있는 정보를 커서로 불러와 리스트뷰에 뿌려주는 프로그램입니다.
문제는 리스트뷰에 있는 아이템을 삭제후 (마지막 아이템이 아닌 다른 아이템) 다시 자료를 넣으려면 오류가 발생하고 꺼집니다.
그런데 마지막 아이템을 삭제하거나 데이터를 전부 삭제하면 프로그램이 잘 작동됩니다.
개인적인 생각에는 아이템 하나를 삭제했을 때 카운터가 줄어들어 마지막에 아이템이 들어와야 되는데 중간에 아이템이 없으니 그리로 들어가려고 하면서 오류가 발생했다고 생각합니다. 그런데 워낙 똥멍청이니 올바른 생각이 아닐거 같고 더욱이 해결방법도 몰라 이렇게 문의를 드립니다.