search

logogin / robertprojects

Automatically exported from code.google.com/p/robertprojects
0 stars 0 forks source link

0.7.3.1 исключение при открытии SQLite карты #62

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
0.7.3.1, при открытии гугл-карты Москвы в sqlite, 
которая в 0.6.4 работала 
отлично:

D/RMAPS   (32444): RSQLiteOpenHelper: Open database 
/sdcard/rmaps/maps/msk_gm.sqlitedb                                              

D/RMAPS   (32444): CashDatabase: Open SQLITEDB Database ver.3                   

E/RMAPS   (32444): In table ListCashTables 1 records                            

E/RMAPS   (32444): In table ListCashTables NO records for 
cahs_msk_gm_sqlitedb                                                            

W/dalvikvm(32444): threadid=29: thread exiting with uncaught exception 
(group=0x40013140)                                                              

E/AndroidRuntime(32444): Uncaught handler: thread pool-4-thread-1 exiting 
due to uncaught exception                                                       

E/AndroidRuntime(32444): android.database.sqlite.SQLiteException: no such 
table: info: , while compiling: SELECT minzoom AS ret FROM info                 

E/AndroidRuntime(32444):        at 
android.database.sqlite.SQLiteProgram.native_compile(Native Method)             

E/AndroidRuntime(32444):        at 
android.database.sqlite.SQLiteProgram.compile(SQLiteProgram.java:110)           

E/AndroidRuntime(32444):        at 
android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:59)             

E/AndroidRuntime(32444):        at 
android.database.sqlite.SQLiteQuery.<init>(SQLiteQuery.java:49)                 

E/AndroidRuntime(32444):        at 
android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDr
iver.java:49)                                                                  
E/AndroidRuntime(32444):        at 
android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.j
ava:1139)                                                                      
E/AndroidRuntime(32444):        at 
android.database.sqlite.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1113)       

E/AndroidRuntime(32444):        at 
com.robert.maps.utils.CashDatabase.getMinZoom(CashDatabase.java:73)             

E/AndroidRuntime(32444):        at 
org.andnav.osm.views.util.OpenStreetMapTileFilesystemProvider$2.run(OpenStr
eetMapTileFilesystemProvider.java:292)                                         
E/AndroidRuntime(32444):        at 
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.j
ava:648)                                                                       
E/AndroidRuntime(32444):        at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:
673)                                                                           
E/AndroidRuntime(32444):        at java.lang.Thread.run(Thread.java:1058)       

I/Process (   63): Sending signal. PID: 32444 SIG: 3                            

I/dalvikvm(32444): threadid=7: reacting to signal 3                             

I/AlertDialog(   63): [onCreate] auto launch SIP.                               

D/dalvikvm(32444): GC freed 16644 objects / 980336 bytes in 212ms               

D/RMAPS   (32444): finalize: Close SQLITEDB Database database                   

E/Database(32444): Leak found                                                   

E/Database(32444): java.lang.IllegalStateException: 
/data/data/com.robert.maps/databases/osmaptilefscache_db SQLiteDatabase 
created and never closed                                         
E/Database(32444):      at 
android.database.sqlite.SQLiteDatabase.<init>(SQLiteDatabase.java:1601)         

E/Database(32444):      at 
android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:659
)                                                                               

E/Database(32444):      at 
android.database.sqlite.SQLiteDatabase.openOrCreateDatabase(SQLiteDatabase.
java:680)                                                                       

E/Database(32444):      at 
android.database.sqlite.SQLiteDatabase.openOrCreateDatabase(SQLiteDatabase.
java:673)                                                                       

E/Database(32444):      at 
android.app.ApplicationContext.openOrCreateDatabase(ApplicationContext.java
:463)                                                                           

E/Database(32444):      at 
android.content.ContextWrapper.openOrCreateDatabase(ContextWrapper.java:181
)                                                                               

E/Database(32444):      at 
android.database.sqlite.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelp
er.java:98)                                                                     

E/Database(32444):      at 
org.andnav.osm.views.util.OpenStreetMapTileFilesystemProvider$OpenStreetMap
TileFilesystemProviderDataBase.<init>(OpenStreetMapTileFilesystemProvider.j
ava:719)    
E/Database(32444):      at 
org.andnav.osm.views.util.OpenStreetMapTileFilesystemProvider.<init>(OpenSt
reetMapTileFilesystemProvider.java:103)                                         

E/Database(32444):      at 
com.robert.maps.utils.InternalCachePreference.<init>(InternalCachePreferenc
e.java:29)                                                                      

E/Database(32444):      at 
java.lang.reflect.Constructor.constructNative(Native Method)                    

E/Database(32444):      at 
java.lang.reflect.Constructor.newInstance(Constructor.java:446)                 

E/Database(32444):      at 
android.preference.GenericInflater.createItem(GenericInflater.java:383)         

E/Database(32444):      at 
android.preference.GenericInflater.createItemFromTag(GenericInflater.java:4
30)                                                                             

E/Database(32444):      at 
android.preference.GenericInflater.rInflate(GenericInflater.java:481)           

E/Database(32444):      at 
android.preference.GenericInflater.rInflate(GenericInflater.java:493)           

E/Database(32444):      at 
android.preference.GenericInflater.inflate(GenericInflater.java:326)            

E/Database(32444):      at 
android.preference.GenericInflater.inflate(GenericInflater.java:263)            

E/Database(32444):      at 
android.preference.PreferenceManager.inflateFromResource(PreferenceManager.
java:250)                                                                       

E/Database(32444):      at 
android.preference.PreferenceActivity.addPreferencesFromResource(Preference
Activity.java:253)                                                              

E/Database(32444):      at 
com.robert.maps.MainPreferences.onCreate(MainPreferences.java:41)               

E/Database(32444):      at 
android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1132)

E/Database(32444):      at 
android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2231)      

E/Database(32444):      at 
android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2284)       

E/Database(32444):      at 
android.app.ActivityThread.access$1800(ActivityThread.java:112)                 

E/Database(32444):      at 
android.app.ActivityThread$H.handleMessage(ActivityThread.java:1692)            

E/Database(32444):      at 
android.os.Handler.dispatchMessage(Handler.java:99)                             

E/Database(32444):      at android.os.Looper.loop(Looper.java:123)              

E/Database(32444):      at 
android.app.ActivityThread.main(ActivityThread.java:3948)                       

E/Database(32444):      at java.lang.reflect.Method.invokeNative(Native 
Method)                                                                         

E/Database(32444):      at java.lang.reflect.Method.invoke(Method.java:521)     

E/Database(32444):      at 
com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:
782)                                                                            

E/Database(32444):      at 
com.android.internal.os.ZygoteInit.main(ZygoteInit.java:540)                    

E/Database(32444):      at dalvik.system.NativeStart.main(Native Method)        

E/Database(32444): Leak found                                                   

E/Database(32444): java.lang.IllegalStateException: 
/sdcard/rmaps/data/index.db SQLiteDatabase created and never closed             

E/Database(32444):      at 
android.database.sqlite.SQLiteDatabase.<init>(SQLiteDatabase.java:1601)         

E/Database(32444):      at 
android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:659
)                                                                               

E/Database(32444):      at 
android.database.sqlite.SQLiteDatabase.openOrCreateDatabase(SQLiteDatabase.
java:680)                                                                       

E/Database(32444):      at 
com.robert.maps.utils.RSQLiteOpenHelper.getWritableDatabase(RSQLiteOpenHelp
er.java:102)                                                                    

E/Database(32444):      at 
org.andnav.osm.views.util.OpenStreetMapTileFilesystemProvider.getIndexDatab
ase(OpenStreetMapTileFilesystemProvider.java:1046)                              

E/Database(32444):      at 
org.andnav.osm.views.util.OpenStreetMapTileFilesystemProvider$OpenStreetMap
TileFilesystemProviderDataBase.<init>(OpenStreetMapTileFilesystemProvider.j
ava:718)    
E/Database(32444):      at 
org.andnav.osm.views.util.OpenStreetMapTileFilesystemProvider.<init>(OpenSt
reetMapTileFilesystemProvider.java:103)                                         

E/Database(32444):      at 
com.robert.maps.utils.InternalCachePreference.<init>(InternalCachePreferenc
e.java:29)                                                                      

E/Database(32444):      at 
java.lang.reflect.Constructor.constructNative(Native Method)                    

E/Database(32444):      at 
java.lang.reflect.Constructor.newInstance(Constructor.java:446)                 

E/Database(32444):      at 
android.preference.GenericInflater.createItem(GenericInflater.java:383)         

E/Database(32444):      at 
android.preference.GenericInflater.createItemFromTag(GenericInflater.java:4
30)                                                                             

E/Database(32444):      at 
android.preference.GenericInflater.rInflate(GenericInflater.java:481)           

E/Database(32444):      at 
android.preference.GenericInflater.rInflate(GenericInflater.java:493)           

E/Database(32444):      at 
android.preference.GenericInflater.inflate(GenericInflater.java:326)            

E/Database(32444):      at 
android.preference.GenericInflater.inflate(GenericInflater.java:263)            

E/Database(32444):      at 
android.preference.PreferenceManager.inflateFromResource(PreferenceManager.
java:250)                                                                       

E/Database(32444):      at 
android.preference.PreferenceActivity.addPreferencesFromResource(Preference
Activity.java:253)                                                              

E/Database(32444):      at 
com.robert.maps.MainPreferences.onCreate(MainPreferences.java:41)               

E/Database(32444):      at 
android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1132)

E/Database(32444):      at 
android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2231)      

E/Database(32444):      at 
android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2284)       

E/Database(32444):      at 
android.app.ActivityThread.access$1800(ActivityThread.java:112)                 

E/Database(32444):      at 
android.app.ActivityThread$H.handleMessage(ActivityThread.java:1692)            

E/Database(32444):      at 
android.os.Handler.dispatchMessage(Handler.java:99)                             

E/Database(32444):      at android.os.Looper.loop(Looper.java:123)              

E/Database(32444):      at 
android.app.ActivityThread.main(ActivityThread.java:3948)                       

E/Database(32444):      at java.lang.reflect.Method.invokeNative(Native 
Method)                                                                         

E/Database(32444):      at java.lang.reflect.Method.invoke(Method.java:521)     

E/Database(32444):      at 
com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:
782)                                                                            

E/Database(32444):      at 
com.android.internal.os.ZygoteInit.main(ZygoteInit.java:540)                    

E/Database(32444):      at dalvik.system.NativeStart.main(Native Method)        

D/RMAPS   (32444): OpenStreetMapTileFilesystemProvider: Open INDEX database     

D/RMAPS   (32444): RSQLiteOpenHelper: Open database 
/sdcard/rmaps/data/index.db                                                     

D/RMAPS   (32444): finalize: Close INDEX database

Original issue reported on code.google.com by edward.h...@gmail.com on 19 Oct 2009 at 7:46

GoogleCodeExporter commented 9 years ago 
Try v.0.7.3.2

Original comment by RobertK...@gmail.com on 19 Oct 2009 at 9:04

GoogleCodeExporter commented 9 years ago 
Работает. Спасибо!

Original comment by edward.h...@gmail.com on 20 Oct 2009 at 6:42

GoogleCodeExporter commented 9 years ago

Original comment by RobertK...@gmail.com on 20 Oct 2009 at 1:45