search

wangyif2 / GroceryGo

A consolidated Android application that lets you view sales information on grocery items of major grocery items on the go, right where you need them
3 stars 1 forks source link

SQLite error on Refresh #14

Closed yancheva closed 11 years ago

yancheva commented 11 years ago

To reproduce:

1) With your existing install, click Refresh in the Client app (I am not sure if it happens every time but it started happening for me today and it is pretty consistent). SQLite seems to encounter a non-unique grocery_id, and the app crashes. I am only pasting a subset of the errors here:

03-06 23:40:17.304: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1469) 03-06 23:40:17.304: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1339) 03-06 23:40:17.304: E/SQLiteDatabase(6895): at com.groceryotg.android.database.contentprovider.GroceryotgProvider.insert(GroceryotgProvider.java:128) 03-06 23:40:17.304: E/SQLiteDatabase(6895): at android.content.ContentProvider.bulkInsert(ContentProvider.java:705) 03-06 23:40:17.304: E/SQLiteDatabase(6895): at android.content.ContentProvider$Transport.bulkInsert(ContentProvider.java:207) 03-06 23:40:17.304: E/SQLiteDatabase(6895): at android.content.ContentResolver.bulkInsert(ContentResolver.java:925) 03-06 23:40:17.304: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.addNewGroceries(NetworkHandler.java:179) 03-06 23:40:17.304: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.refreshGrocery(NetworkHandler.java:145) 03-06 23:40:17.304: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.onHandleIntent(NetworkHandler.java:57) 03-06 23:40:17.304: E/SQLiteDatabase(6895): at android.app.IntentService$ServiceHandler.handleMessage(IntentService.java:65) 03-06 23:40:17.304: E/SQLiteDatabase(6895): at android.os.Handler.dispatchMessage(Handler.java:99) 03-06 23:40:17.304: E/SQLiteDatabase(6895): at android.os.Looper.loop(Looper.java:137) 03-06 23:40:17.304: E/SQLiteDatabase(6895): at android.os.HandlerThread.run(HandlerThread.java:60) 03-06 23:40:17.311: E/SQLiteDatabase(6895): Error inserting grocery_category=7 grocery_name=HUNTâ??S SNACK PACK PUDDING CUPS. 4â??S. SELECTED VARIETIES. grocery_expiry=1362632400000 grocery_price=1.0 grocery_id=5929 03-06 23:40:17.311: E/SQLiteDatabase(6895): android.database.sqlite.SQLiteConstraintException: column grocery_id is not unique (code 19)

2) Re-install the client app. Click Refresh for the first time. The app doesn't crash, but in LogCat you can see a bunch of SQLite errors, this time having to do with non-unique category_id's.

03-06 23:45:21.077: E/SQLiteDatabase(7488): Error inserting category_id=1 category_name=Dairy 03-06 23:45:21.077: E/SQLiteDatabase(7488): android.database.sqlite.SQLiteConstraintException: column category_id is not unique (code 19) 03-06 23:45:21.077: E/SQLiteDatabase(7488): at android.database.sqlite.SQLiteConnection.nativeExecuteForLastInsertedRowId(Native Method) 03-06 23:45:21.077: E/SQLiteDatabase(7488): at android.database.sqlite.SQLiteConnection.executeForLastInsertedRowId(SQLiteConnection.java:775) 03-06 23:45:21.077: E/SQLiteDatabase(7488): at android.database.sqlite.SQLiteSession.executeForLastInsertedRowId(SQLiteSession.java:788) 03-06 23:45:21.077: E/SQLiteDatabase(7488): at android.database.sqlite.SQLiteStatement.executeInsert(SQLiteStatement.java:86) 03-06 23:45:21.077: E/SQLiteDatabase(7488): at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1469) 03-06 23:45:21.077: E/SQLiteDatabase(7488): at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1339) 03-06 23:45:21.077: E/SQLiteDatabase(7488): at com.groceryotg.android.database.contentprovider.GroceryotgProvider.insert(GroceryotgProvider.java:124) 03-06 23:45:21.077: E/SQLiteDatabase(7488): at android.content.ContentProvider.bulkInsert(ContentProvider.java:705) 03-06 23:45:21.077: E/SQLiteDatabase(7488): at android.content.ContentProvider$Transport.bulkInsert(ContentProvider.java:207) 03-06 23:45:21.077: E/SQLiteDatabase(7488): at android.content.ContentResolver.bulkInsert(ContentResolver.java:925) 03-06 23:45:21.077: E/SQLiteDatabase(7488): at com.groceryotg.android.services.NetworkHandler.refreshCategory(NetworkHandler.java:101) 03-06 23:45:21.077: E/SQLiteDatabase(7488): at com.groceryotg.android.services.NetworkHandler.onHandleIntent(NetworkHandler.java:54) 03-06 23:45:21.077: E/SQLiteDatabase(7488): at android.app.IntentService$ServiceHandler.handleMessage(IntentService.java:65) 03-06 23:45:21.077: E/SQLiteDatabase(7488): at android.os.Handler.dispatchMessage(Handler.java:99) 03-06 23:45:21.077: E/SQLiteDatabase(7488): at android.os.Looper.loop(Looper.java:137) 03-06 23:45:21.077: E/SQLiteDatabase(7488): at android.os.HandlerThread.run(HandlerThread.java:60)

wangyif2 commented 11 years ago

The SQL lights exception is not why the app crashed, the nun unique ID exception is actually a standard practice for avoiding duplicated entry in database.

The exception that cost the crash is most likely buried, you should try to find that 1 and post that instead. On Mar 6, 2013 11:51 PM, "Maria Yancheva" notifications@github.com wrote:

To reproduce:

1) With your existing install, click Refresh in the Client app (I am not sure if it happens every time but it started happening for me today and it is pretty consistent). SQLite seems to encounter a non-unique grocery_id, and the app crashes. I am only pasting a subset of the errors here:

03-06 23:40:17.304: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1469) 03-06 23:40:17.304: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1339) 03-06 23:40:17.304: E/SQLiteDatabase(6895): at com.groceryotg.android.database.contentprovider.GroceryotgProvider.insert(GroceryotgProvider.java:128) 03-06 23:40:17.304: E/SQLiteDatabase(6895): at android.content.ContentProvider.bulkInsert(ContentProvider.java:705) 03-06 23:40:17.304: E/SQLiteDatabase(6895): at android.content.ContentProvider$Transport.bulkInsert(ContentProvider.java:207) 03-06 23:40:17.304: E/SQLiteDatabase(6895): at android.content.ContentResolver.bulkInsert(ContentResolver.java:925) 03-06 23:40:17.304: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.addNewGroceries(NetworkHandler.java:179) 03-06 23:40:17.304: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.refreshGrocery(NetworkHandler.java:145) 03-06 23:40:17.304: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.onHandleIntent(NetworkHandler.java:57) 03-06 23:40:17.304: E/SQLiteDatabase(6895): at android.app.IntentService$ServiceHandler.handleMessage(IntentService.java:65) 03-06 23:40:17.304: E/SQLiteDatabase(6895): at android.os.Handler.dispatchMessage(Handler.java:99) 03-06 23:40:17.304: E/SQLiteDatabase(6895): at android.os.Looper.loop(Looper.java:137) 03-06 23:40:17.304: E/SQLiteDatabase(6895): at android.os.HandlerThread.run(HandlerThread.java:60) 03-06 23:40:17.311: E/SQLiteDatabase(6895): Error inserting grocery_category=7 grocery_name=HUNTâ??S SNACK PACK PUDDING CUPS. 4â??S. SELECTED VARIETIES. grocery_expiry=1362632400000 grocery_price=1.0 grocery_id=5929 03-06 23:40:17.311: E/SQLiteDatabase(6895): android.database.sqlite.SQLiteConstraintException: column grocery_id is not unique (code 19)

2) Re-install the client app. Click Refresh for the first time. The app doesn't crash, but in LogCat you can see a bunch of SQLite errors, this time having to do with non-unique category_id's.

03-06 23:45:21.077: E/SQLiteDatabase(7488): Error inserting category_id=1 category_name=Dairy 03-06 23:45:21.077: E/SQLiteDatabase(7488): android.database.sqlite.SQLiteConstraintException: column category_id is not unique (code 19) 03-06 23:45:21.077: E/SQLiteDatabase(7488): at android.database.sqlite.SQLiteConnection.nativeExecuteForLastInsertedRowId(Native Method) 03-06 23:45:21.077: E/SQLiteDatabase(7488): at android.database.sqlite.SQLiteConnection.executeForLastInsertedRowId(SQLiteConnection.java:775) 03-06 23:45:21.077: E/SQLiteDatabase(7488): at android.database.sqlite.SQLiteSession.executeForLastInsertedRowId(SQLiteSession.java:788) 03-06 23:45:21.077: E/SQLiteDatabase(7488): at android.database.sqlite.SQLiteStatement.executeInsert(SQLiteStatement.java:86) 03-06 23:45:21.077: E/SQLiteDatabase(7488): at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1469) 03-06 23:45:21.077: E/SQLiteDatabase(7488): at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1339) 03-06 23:45:21.077: E/SQLiteDatabase(7488): at com.groceryotg.android.database.contentprovider.GroceryotgProvider.insert(GroceryotgProvider.java:124) 03-06 23:45:21.077: E/SQLiteDatabase(7488): at android.content.ContentProvider.bulkInsert(ContentProvider.java:705) 03-06 23:45:21.077: E/SQLiteDatabase(7488): at android.content.ContentProvider$Transport.bulkInsert(ContentProvider.java:207) 03-06 23:45:21.077: E/SQLiteDatabase(7488): at android.content.ContentResolver.bulkInsert(ContentResolver.java:925) 03-06 23:45:21.077: E/SQLiteDatabase(7488): at com.groceryotg.android.services.NetworkHandler.refreshCategory(NetworkHandler.java:101) 03-06 23:45:21.077: E/SQLiteDatabase(7488): at com.groceryotg.android.services.NetworkHandler.onHandleIntent(NetworkHandler.java:54) 03-06 23:45:21.077: E/SQLiteDatabase(7488): at android.app.IntentService$ServiceHandler.handleMessage(IntentService.java:65) 03-06 23:45:21.077: E/SQLiteDatabase(7488): at android.os.Handler.dispatchMessage(Handler.java:99) 03-06 23:45:21.077: E/SQLiteDatabase(7488): at android.os.Looper.loop(Looper.java:137) 03-06 23:45:21.077: E/SQLiteDatabase(7488): at android.os.HandlerThread.run(HandlerThread.java:60)

— Reply to this email directly or view it on GitHubhttps://github.com/wangyif2/GroceryOTG/issues/14 .

yancheva commented 11 years ago

The server database was updated with today's values this morning. Now I'm observing this behaviour: 1) Re-install app on your phone. 2) Click Refresh, it updates the Categories. 3) Click Dairy, and click Refresh to update the grocery items. 4) It only displays a single item: "PIZZA OR GARLIC... " even though on the server there are 21 items with today's date in the category Dairy. (I think, from manually scanning the list, that the other 20 items were previously there last week, and only the pizza item is new, but since I re-installed the app that should cleared the SQLite db right?)

Also attached is the dump from yesterday. The relevant exception is at the very end:

03-06 23:40:32.624: E/AndroidRuntime(6895): FATAL EXCEPTION: IntentService[NetworkHandler] 03-06 23:40:32.624: E/AndroidRuntime(6895): java.lang.NullPointerException 03-06 23:40:32.624: E/AndroidRuntime(6895): at android.os.Parcel.readException(Parcel.java:1431) 03-06 23:40:32.624: E/AndroidRuntime(6895): at android.os.Parcel.readException(Parcel.java:1379) 03-06 23:40:32.624: E/AndroidRuntime(6895): at android.content.IIntentSender$Stub$Proxy.send(IIntentSender.java:106) 03-06 23:40:32.624: E/AndroidRuntime(6895): at android.app.PendingIntent.send(PendingIntent.java:587) 03-06 23:40:32.624: E/AndroidRuntime(6895): at android.app.PendingIntent.send(PendingIntent.java:464) 03-06 23:40:32.624: E/AndroidRuntime(6895): at com.groceryotg.android.services.NetworkHandler.onHandleIntent(NetworkHandler.java:72) 03-06 23:40:32.624: E/AndroidRuntime(6895): at android.app.IntentService$ServiceHandler.handleMessage(IntentService.java:65) 03-06 23:40:32.624: E/AndroidRuntime(6895): at android.os.Handler.dispatchMessage(Handler.java:99) 03-06 23:40:32.624: E/AndroidRuntime(6895): at android.os.Looper.loop(Looper.java:137) 03-06 23:40:32.624: E/AndroidRuntime(6895): at android.os.HandlerThread.run(HandlerThread.java:60)

Looking at this I think it may have been an internet issue again (in which case, if internet connectivity goes down halfway through refresh, there's probably no way to handle that).

On 7 March 2013 08:51, Robert Wang notifications@github.com wrote:

The SQL lights exception is not why the app crashed, the nun unique ID exception is actually a standard practice for avoiding duplicated entry in database.

The exception that cost the crash is most likely buried, you should try to find that 1 and post that instead. On Mar 6, 2013 11:51 PM, "Maria Yancheva" notifications@github.com wrote:

To reproduce:

1) With your existing install, click Refresh in the Client app (I am not sure if it happens every time but it started happening for me today and it is pretty consistent). SQLite seems to encounter a non-unique grocery_id, and the app crashes. I am only pasting a subset of the errors here:

03-06 23:40:17.304: E/SQLiteDatabase(6895): at

android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1469)

03-06 23:40:17.304: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1339) 03-06 23:40:17.304: E/SQLiteDatabase(6895): at

com.groceryotg.android.database.contentprovider.GroceryotgProvider.insert(GroceryotgProvider.java:128)

03-06 23:40:17.304: E/SQLiteDatabase(6895): at android.content.ContentProvider.bulkInsert(ContentProvider.java:705) 03-06 23:40:17.304: E/SQLiteDatabase(6895): at

android.content.ContentProvider$Transport.bulkInsert(ContentProvider.java:207)

03-06 23:40:17.304: E/SQLiteDatabase(6895): at android.content.ContentResolver.bulkInsert(ContentResolver.java:925) 03-06 23:40:17.304: E/SQLiteDatabase(6895): at

com.groceryotg.android.services.NetworkHandler.addNewGroceries(NetworkHandler.java:179)

03-06 23:40:17.304: E/SQLiteDatabase(6895): at

com.groceryotg.android.services.NetworkHandler.refreshGrocery(NetworkHandler.java:145)

03-06 23:40:17.304: E/SQLiteDatabase(6895): at

com.groceryotg.android.services.NetworkHandler.onHandleIntent(NetworkHandler.java:57)

03-06 23:40:17.304: E/SQLiteDatabase(6895): at

android.app.IntentService$ServiceHandler.handleMessage(IntentService.java:65)

03-06 23:40:17.304: E/SQLiteDatabase(6895): at android.os.Handler.dispatchMessage(Handler.java:99) 03-06 23:40:17.304: E/SQLiteDatabase(6895): at android.os.Looper.loop(Looper.java:137) 03-06 23:40:17.304: E/SQLiteDatabase(6895): at android.os.HandlerThread.run(HandlerThread.java:60) 03-06 23:40:17.311: E/SQLiteDatabase(6895): Error inserting grocery_category=7 grocery_name=HUNTâ??S SNACK PACK PUDDING CUPS. 4â??S. SELECTED VARIETIES. grocery_expiry=1362632400000 grocery_price=1.0 grocery_id=5929 03-06 23:40:17.311: E/SQLiteDatabase(6895): android.database.sqlite.SQLiteConstraintException: column grocery_id is not unique (code 19)

2) Re-install the client app. Click Refresh for the first time. The app doesn't crash, but in LogCat you can see a bunch of SQLite errors, this time having to do with non-unique category_id's.

03-06 23:45:21.077: E/SQLiteDatabase(7488): Error inserting category_id=1 category_name=Dairy 03-06 23:45:21.077: E/SQLiteDatabase(7488): android.database.sqlite.SQLiteConstraintException: column category_id is not unique (code 19) 03-06 23:45:21.077: E/SQLiteDatabase(7488): at

android.database.sqlite.SQLiteConnection.nativeExecuteForLastInsertedRowId(Native

Method) 03-06 23:45:21.077: E/SQLiteDatabase(7488): at

android.database.sqlite.SQLiteConnection.executeForLastInsertedRowId(SQLiteConnection.java:775)

03-06 23:45:21.077: E/SQLiteDatabase(7488): at

android.database.sqlite.SQLiteSession.executeForLastInsertedRowId(SQLiteSession.java:788)

03-06 23:45:21.077: E/SQLiteDatabase(7488): at

android.database.sqlite.SQLiteStatement.executeInsert(SQLiteStatement.java:86)

03-06 23:45:21.077: E/SQLiteDatabase(7488): at

android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1469)

03-06 23:45:21.077: E/SQLiteDatabase(7488): at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1339) 03-06 23:45:21.077: E/SQLiteDatabase(7488): at

com.groceryotg.android.database.contentprovider.GroceryotgProvider.insert(GroceryotgProvider.java:124)

03-06 23:45:21.077: E/SQLiteDatabase(7488): at android.content.ContentProvider.bulkInsert(ContentProvider.java:705) 03-06 23:45:21.077: E/SQLiteDatabase(7488): at

android.content.ContentProvider$Transport.bulkInsert(ContentProvider.java:207)

03-06 23:45:21.077: E/SQLiteDatabase(7488): at android.content.ContentResolver.bulkInsert(ContentResolver.java:925) 03-06 23:45:21.077: E/SQLiteDatabase(7488): at

com.groceryotg.android.services.NetworkHandler.refreshCategory(NetworkHandler.java:101)

03-06 23:45:21.077: E/SQLiteDatabase(7488): at

com.groceryotg.android.services.NetworkHandler.onHandleIntent(NetworkHandler.java:54)

03-06 23:45:21.077: E/SQLiteDatabase(7488): at

android.app.IntentService$ServiceHandler.handleMessage(IntentService.java:65)

03-06 23:45:21.077: E/SQLiteDatabase(7488): at android.os.Handler.dispatchMessage(Handler.java:99) 03-06 23:45:21.077: E/SQLiteDatabase(7488): at android.os.Looper.loop(Looper.java:137) 03-06 23:45:21.077: E/SQLiteDatabase(7488): at android.os.HandlerThread.run(HandlerThread.java:60)

— Reply to this email directly or view it on GitHub< https://github.com/wangyif2/GroceryOTG/issues/14> .

— Reply to this email directly or view it on GitHubhttps://github.com/wangyif2/GroceryOTG/issues/14#issuecomment-14561429 .

03-06 23:40:17.304: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1469) 03-06 23:40:17.304: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1339) 03-06 23:40:17.304: E/SQLiteDatabase(6895): at com.groceryotg.android.database.contentprovider.GroceryotgProvider.insert(GroceryotgProvider.java:128) 03-06 23:40:17.304: E/SQLiteDatabase(6895): at android.content.ContentProvider.bulkInsert(ContentProvider.java:705) 03-06 23:40:17.304: E/SQLiteDatabase(6895): at android.content.ContentProvider$Transport.bulkInsert(ContentProvider.java:207) 03-06 23:40:17.304: E/SQLiteDatabase(6895): at android.content.ContentResolver.bulkInsert(ContentResolver.java:925) 03-06 23:40:17.304: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.addNewGroceries(NetworkHandler.java:179) 03-06 23:40:17.304: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.refreshGrocery(NetworkHandler.java:145) 03-06 23:40:17.304: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.onHandleIntent(NetworkHandler.java:57) 03-06 23:40:17.304: E/SQLiteDatabase(6895): at android.app.IntentService$ServiceHandler.handleMessage(IntentService.java:65) 03-06 23:40:17.304: E/SQLiteDatabase(6895): at android.os.Handler.dispatchMessage(Handler.java:99) 03-06 23:40:17.304: E/SQLiteDatabase(6895): at android.os.Looper.loop(Looper.java:137) 03-06 23:40:17.304: E/SQLiteDatabase(6895): at android.os.HandlerThread.run(HandlerThread.java:60) 03-06 23:40:17.311: E/SQLiteDatabase(6895): Error inserting grocery_category=7 grocery_name=HUNTâ??S SNACK PACK PUDDING CUPS. 4â??S. SELECTED VARIETIES. grocery_expiry=1362632400000 grocery_price=1.0 grocery_id=5929 03-06 23:40:17.311: E/SQLiteDatabase(6895): android.database.sqlite.SQLiteConstraintException: column grocery_id is not unique (code 19) 03-06 23:40:17.311: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteConnection.nativeExecuteForLastInsertedRowId(Native Method) 03-06 23:40:17.311: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteConnection.executeForLastInsertedRowId(SQLiteConnection.java:775) 03-06 23:40:17.311: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteSession.executeForLastInsertedRowId(SQLiteSession.java:788) 03-06 23:40:17.311: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteStatement.executeInsert(SQLiteStatement.java:86) 03-06 23:40:17.311: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1469) 03-06 23:40:17.311: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1339) 03-06 23:40:17.311: E/SQLiteDatabase(6895): at com.groceryotg.android.database.contentprovider.GroceryotgProvider.insert(GroceryotgProvider.java:128) 03-06 23:40:17.311: E/SQLiteDatabase(6895): at android.content.ContentProvider.bulkInsert(ContentProvider.java:705) 03-06 23:40:17.311: E/SQLiteDatabase(6895): at android.content.ContentProvider$Transport.bulkInsert(ContentProvider.java:207) 03-06 23:40:17.311: E/SQLiteDatabase(6895): at android.content.ContentResolver.bulkInsert(ContentResolver.java:925) 03-06 23:40:17.311: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.addNewGroceries(NetworkHandler.java:179) 03-06 23:40:17.311: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.refreshGrocery(NetworkHandler.java:145) 03-06 23:40:17.311: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.onHandleIntent(NetworkHandler.java:57) 03-06 23:40:17.311: E/SQLiteDatabase(6895): at android.app.IntentService$ServiceHandler.handleMessage(IntentService.java:65) 03-06 23:40:17.311: E/SQLiteDatabase(6895): at android.os.Handler.dispatchMessage(Handler.java:99) 03-06 23:40:17.311: E/SQLiteDatabase(6895): at android.os.Looper.loop(Looper.java:137) 03-06 23:40:17.311: E/SQLiteDatabase(6895): at android.os.HandlerThread.run(HandlerThread.java:60) 03-06 23:40:17.311: E/SQLiteDatabase(6895): Error inserting grocery_category=6 grocery_name=MINUTE MAID FIVE ALIVE, FRUITOPIA OR. NESTEA DRINKS. CHILLED, 1.75 L. SELECTED VARIETIES. grocery_expiry=1362632400000 grocery_price=3.0 grocery_id=5930 03-06 23:40:17.311: E/SQLiteDatabase(6895): android.database.sqlite.SQLiteConstraintException: column grocery_id is not unique (code 19) 03-06 23:40:17.311: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteConnection.nativeExecuteForLastInsertedRowId(Native Method) 03-06 23:40:17.311: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteConnection.executeForLastInsertedRowId(SQLiteConnection.java:775) 03-06 23:40:17.311: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteSession.executeForLastInsertedRowId(SQLiteSession.java:788) 03-06 23:40:17.311: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteStatement.executeInsert(SQLiteStatement.java:86) 03-06 23:40:17.311: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1469) 03-06 23:40:17.311: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1339) 03-06 23:40:17.311: E/SQLiteDatabase(6895): at com.groceryotg.android.database.contentprovider.GroceryotgProvider.insert(GroceryotgProvider.java:128) 03-06 23:40:17.311: E/SQLiteDatabase(6895): at android.content.ContentProvider.bulkInsert(ContentProvider.java:705) 03-06 23:40:17.311: E/SQLiteDatabase(6895): at android.content.ContentProvider$Transport.bulkInsert(ContentProvider.java:207) 03-06 23:40:17.311: E/SQLiteDatabase(6895): at android.content.ContentResolver.bulkInsert(ContentResolver.java:925) 03-06 23:40:17.311: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.addNewGroceries(NetworkHandler.java:179) 03-06 23:40:17.311: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.refreshGrocery(NetworkHandler.java:145) 03-06 23:40:17.311: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.onHandleIntent(NetworkHandler.java:57) 03-06 23:40:17.311: E/SQLiteDatabase(6895): at android.app.IntentService$ServiceHandler.handleMessage(IntentService.java:65) 03-06 23:40:17.311: E/SQLiteDatabase(6895): at android.os.Handler.dispatchMessage(Handler.java:99) 03-06 23:40:17.311: E/SQLiteDatabase(6895): at android.os.Looper.loop(Looper.java:137) 03-06 23:40:17.311: E/SQLiteDatabase(6895): at android.os.HandlerThread.run(HandlerThread.java:60) 03-06 23:40:17.319: E/SQLiteDatabase(6895): Error inserting grocery_category=7 grocery_name=SELECTION BLEACH. 3 L. SELECTED VARIETIES. grocery_expiry=1362632400000 grocery_price=1.0 grocery_id=5931 03-06 23:40:17.319: E/SQLiteDatabase(6895): android.database.sqlite.SQLiteConstraintException: column grocery_id is not unique (code 19) 03-06 23:40:17.319: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteConnection.nativeExecuteForLastInsertedRowId(Native Method) 03-06 23:40:17.319: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteConnection.executeForLastInsertedRowId(SQLiteConnection.java:775) 03-06 23:40:17.319: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteSession.executeForLastInsertedRowId(SQLiteSession.java:788) 03-06 23:40:17.319: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteStatement.executeInsert(SQLiteStatement.java:86) 03-06 23:40:17.319: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1469) 03-06 23:40:17.319: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1339) 03-06 23:40:17.319: E/SQLiteDatabase(6895): at com.groceryotg.android.database.contentprovider.GroceryotgProvider.insert(GroceryotgProvider.java:128) 03-06 23:40:17.319: E/SQLiteDatabase(6895): at android.content.ContentProvider.bulkInsert(ContentProvider.java:705) 03-06 23:40:17.319: E/SQLiteDatabase(6895): at android.content.ContentProvider$Transport.bulkInsert(ContentProvider.java:207) 03-06 23:40:17.319: E/SQLiteDatabase(6895): at android.content.ContentResolver.bulkInsert(ContentResolver.java:925) 03-06 23:40:17.319: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.addNewGroceries(NetworkHandler.java:179) 03-06 23:40:17.319: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.refreshGrocery(NetworkHandler.java:145) 03-06 23:40:17.319: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.onHandleIntent(NetworkHandler.java:57) 03-06 23:40:17.319: E/SQLiteDatabase(6895): at android.app.IntentService$ServiceHandler.handleMessage(IntentService.java:65) 03-06 23:40:17.319: E/SQLiteDatabase(6895): at android.os.Handler.dispatchMessage(Handler.java:99) 03-06 23:40:17.319: E/SQLiteDatabase(6895): at android.os.Looper.loop(Looper.java:137) 03-06 23:40:17.319: E/SQLiteDatabase(6895): at android.os.HandlerThread.run(HandlerThread.java:60) 03-06 23:40:17.319: E/SQLiteDatabase(6895): Error inserting grocery_category=1 grocery_name=NESTLÃ? OR MARS BARS. 41 - 57 G. CADBURY CREME EGG. 34 G. SELECTED VARIETIES. WHILE QUANTITIES LAST. grocery_expiry=1362632400000 grocery_price=2.0 grocery_id=5932 03-06 23:40:17.319: E/SQLiteDatabase(6895): android.database.sqlite.SQLiteConstraintException: column grocery_id is not unique (code 19) 03-06 23:40:17.319: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteConnection.nativeExecuteForLastInsertedRowId(Native Method) 03-06 23:40:17.319: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteConnection.executeForLastInsertedRowId(SQLiteConnection.java:775) 03-06 23:40:17.319: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteSession.executeForLastInsertedRowId(SQLiteSession.java:788) 03-06 23:40:17.319: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteStatement.executeInsert(SQLiteStatement.java:86) 03-06 23:40:17.319: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1469) 03-06 23:40:17.319: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1339) 03-06 23:40:17.319: E/SQLiteDatabase(6895): at com.groceryotg.android.database.contentprovider.GroceryotgProvider.insert(GroceryotgProvider.java:128) 03-06 23:40:17.319: E/SQLiteDatabase(6895): at android.content.ContentProvider.bulkInsert(ContentProvider.java:705) 03-06 23:40:17.319: E/SQLiteDatabase(6895): at android.content.ContentProvider$Transport.bulkInsert(ContentProvider.java:207) 03-06 23:40:17.319: E/SQLiteDatabase(6895): at android.content.ContentResolver.bulkInsert(ContentResolver.java:925) 03-06 23:40:17.319: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.addNewGroceries(NetworkHandler.java:179) 03-06 23:40:17.319: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.refreshGrocery(NetworkHandler.java:145) 03-06 23:40:17.319: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.onHandleIntent(NetworkHandler.java:57) 03-06 23:40:17.319: E/SQLiteDatabase(6895): at android.app.IntentService$ServiceHandler.handleMessage(IntentService.java:65) 03-06 23:40:17.319: E/SQLiteDatabase(6895): at android.os.Handler.dispatchMessage(Handler.java:99) 03-06 23:40:17.319: E/SQLiteDatabase(6895): at android.os.Looper.loop(Looper.java:137) 03-06 23:40:17.319: E/SQLiteDatabase(6895): at android.os.HandlerThread.run(HandlerThread.java:60) 03-06 23:40:17.327: E/SQLiteDatabase(6895): Error inserting grocery_category=5 grocery_name=SELECTION CAKE MIX. 510 G. SELECTED VARIETIES. grocery_expiry=1362632400000 grocery_price=1.0 grocery_id=5933 03-06 23:40:17.327: E/SQLiteDatabase(6895): android.database.sqlite.SQLiteConstraintException: column grocery_id is not unique (code 19) 03-06 23:40:17.327: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteConnection.nativeExecuteForLastInsertedRowId(Native Method) 03-06 23:40:17.327: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteConnection.executeForLastInsertedRowId(SQLiteConnection.java:775) 03-06 23:40:17.327: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteSession.executeForLastInsertedRowId(SQLiteSession.java:788) 03-06 23:40:17.327: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteStatement.executeInsert(SQLiteStatement.java:86) 03-06 23:40:17.327: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1469) 03-06 23:40:17.327: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1339) 03-06 23:40:17.327: E/SQLiteDatabase(6895): at com.groceryotg.android.database.contentprovider.GroceryotgProvider.insert(GroceryotgProvider.java:128) 03-06 23:40:17.327: E/SQLiteDatabase(6895): at android.content.ContentProvider.bulkInsert(ContentProvider.java:705) 03-06 23:40:17.327: E/SQLiteDatabase(6895): at android.content.ContentProvider$Transport.bulkInsert(ContentProvider.java:207) 03-06 23:40:17.327: E/SQLiteDatabase(6895): at android.content.ContentResolver.bulkInsert(ContentResolver.java:925) 03-06 23:40:17.327: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.addNewGroceries(NetworkHandler.java:179) 03-06 23:40:17.327: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.refreshGrocery(NetworkHandler.java:145) 03-06 23:40:17.327: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.onHandleIntent(NetworkHandler.java:57) 03-06 23:40:17.327: E/SQLiteDatabase(6895): at android.app.IntentService$ServiceHandler.handleMessage(IntentService.java:65) 03-06 23:40:17.327: E/SQLiteDatabase(6895): at android.os.Handler.dispatchMessage(Handler.java:99) 03-06 23:40:17.327: E/SQLiteDatabase(6895): at android.os.Looper.loop(Looper.java:137) 03-06 23:40:17.327: E/SQLiteDatabase(6895): at android.os.HandlerThread.run(HandlerThread.java:60) 03-06 23:40:17.327: E/SQLiteDatabase(6895): Error inserting grocery_category=5 grocery_name=SELECTION FLOUR. 2.5 KG. SELECTED VARIETIES. grocery_expiry=1362632400000 grocery_price=3.0 grocery_id=5934 03-06 23:40:17.327: E/SQLiteDatabase(6895): android.database.sqlite.SQLiteConstraintException: column grocery_id is not unique (code 19) 03-06 23:40:17.327: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteConnection.nativeExecuteForLastInsertedRowId(Native Method) 03-06 23:40:17.327: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteConnection.executeForLastInsertedRowId(SQLiteConnection.java:775) 03-06 23:40:17.327: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteSession.executeForLastInsertedRowId(SQLiteSession.java:788) 03-06 23:40:17.327: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteStatement.executeInsert(SQLiteStatement.java:86) 03-06 23:40:17.327: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1469) 03-06 23:40:17.327: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1339) 03-06 23:40:17.327: E/SQLiteDatabase(6895): at com.groceryotg.android.database.contentprovider.GroceryotgProvider.insert(GroceryotgProvider.java:128) 03-06 23:40:17.327: E/SQLiteDatabase(6895): at android.content.ContentProvider.bulkInsert(ContentProvider.java:705) 03-06 23:40:17.327: E/SQLiteDatabase(6895): at android.content.ContentProvider$Transport.bulkInsert(ContentProvider.java:207) 03-06 23:40:17.327: E/SQLiteDatabase(6895): at android.content.ContentResolver.bulkInsert(ContentResolver.java:925) 03-06 23:40:17.327: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.addNewGroceries(NetworkHandler.java:179) 03-06 23:40:17.327: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.refreshGrocery(NetworkHandler.java:145) 03-06 23:40:17.327: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.onHandleIntent(NetworkHandler.java:57) 03-06 23:40:17.327: E/SQLiteDatabase(6895): at android.app.IntentService$ServiceHandler.handleMessage(IntentService.java:65) 03-06 23:40:17.327: E/SQLiteDatabase(6895): at android.os.Handler.dispatchMessage(Handler.java:99) 03-06 23:40:17.327: E/SQLiteDatabase(6895): at android.os.Looper.loop(Looper.java:137) 03-06 23:40:17.327: E/SQLiteDatabase(6895): at android.os.HandlerThread.run(HandlerThread.java:60) 03-06 23:40:17.335: E/SQLiteDatabase(6895): Error inserting grocery_category=6 grocery_name=SELECTION COCOA. 227 G. SELECTED VARIETIES. grocery_expiry=1362632400000 grocery_price=2.0 grocery_id=5935 03-06 23:40:17.335: E/SQLiteDatabase(6895): android.database.sqlite.SQLiteConstraintException: column grocery_id is not unique (code 19) 03-06 23:40:17.335: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteConnection.nativeExecuteForLastInsertedRowId(Native Method) 03-06 23:40:17.335: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteConnection.executeForLastInsertedRowId(SQLiteConnection.java:775) 03-06 23:40:17.335: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteSession.executeForLastInsertedRowId(SQLiteSession.java:788) 03-06 23:40:17.335: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteStatement.executeInsert(SQLiteStatement.java:86) 03-06 23:40:17.335: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1469) 03-06 23:40:17.335: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1339) 03-06 23:40:17.335: E/SQLiteDatabase(6895): at com.groceryotg.android.database.contentprovider.GroceryotgProvider.insert(GroceryotgProvider.java:128) 03-06 23:40:17.335: E/SQLiteDatabase(6895): at android.content.ContentProvider.bulkInsert(ContentProvider.java:705) 03-06 23:40:17.335: E/SQLiteDatabase(6895): at android.content.ContentProvider$Transport.bulkInsert(ContentProvider.java:207) 03-06 23:40:17.335: E/SQLiteDatabase(6895): at android.content.ContentResolver.bulkInsert(ContentResolver.java:925) 03-06 23:40:17.335: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.addNewGroceries(NetworkHandler.java:179) 03-06 23:40:17.335: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.refreshGrocery(NetworkHandler.java:145) 03-06 23:40:17.335: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.onHandleIntent(NetworkHandler.java:57) 03-06 23:40:17.335: E/SQLiteDatabase(6895): at android.app.IntentService$ServiceHandler.handleMessage(IntentService.java:65) 03-06 23:40:17.335: E/SQLiteDatabase(6895): at android.os.Handler.dispatchMessage(Handler.java:99) 03-06 23:40:17.335: E/SQLiteDatabase(6895): at android.os.Looper.loop(Looper.java:137) 03-06 23:40:17.335: E/SQLiteDatabase(6895): at android.os.HandlerThread.run(HandlerThread.java:60) 03-06 23:40:17.335: E/SQLiteDatabase(6895): Error inserting grocery_category=5 grocery_name=PILLSBURY CHOCOLATE COOKIE DOUGH. 468 G. CINNAMON ROLLS DOUGH. 351 G. SELECTED VARIETIES. grocery_expiry=1362632400000 grocery_price=2.0 grocery_id=5936 03-06 23:40:17.335: E/SQLiteDatabase(6895): android.database.sqlite.SQLiteConstraintException: column grocery_id is not unique (code 19) 03-06 23:40:17.335: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteConnection.nativeExecuteForLastInsertedRowId(Native Method) 03-06 23:40:17.335: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteConnection.executeForLastInsertedRowId(SQLiteConnection.java:775) 03-06 23:40:17.335: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteSession.executeForLastInsertedRowId(SQLiteSession.java:788) 03-06 23:40:17.335: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteStatement.executeInsert(SQLiteStatement.java:86) 03-06 23:40:17.335: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1469) 03-06 23:40:17.335: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1339) 03-06 23:40:17.335: E/SQLiteDatabase(6895): at com.groceryotg.android.database.contentprovider.GroceryotgProvider.insert(GroceryotgProvider.java:128) 03-06 23:40:17.335: E/SQLiteDatabase(6895): at android.content.ContentProvider.bulkInsert(ContentProvider.java:705) 03-06 23:40:17.335: E/SQLiteDatabase(6895): at android.content.ContentProvider$Transport.bulkInsert(ContentProvider.java:207) 03-06 23:40:17.335: E/SQLiteDatabase(6895): at android.content.ContentResolver.bulkInsert(ContentResolver.java:925) 03-06 23:40:17.335: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.addNewGroceries(NetworkHandler.java:179) 03-06 23:40:17.335: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.refreshGrocery(NetworkHandler.java:145) 03-06 23:40:17.335: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.onHandleIntent(NetworkHandler.java:57) 03-06 23:40:17.335: E/SQLiteDatabase(6895): at android.app.IntentService$ServiceHandler.handleMessage(IntentService.java:65) 03-06 23:40:17.335: E/SQLiteDatabase(6895): at android.os.Handler.dispatchMessage(Handler.java:99) 03-06 23:40:17.335: E/SQLiteDatabase(6895): at android.os.Looper.loop(Looper.java:137) 03-06 23:40:17.335: E/SQLiteDatabase(6895): at android.os.HandlerThread.run(HandlerThread.java:60) 03-06 23:40:17.343: E/SQLiteDatabase(6895): Error inserting grocery_category=1 grocery_name=SELECTION SWEETENED CONDENSED MILK. 300 ML. SELECTED VARIETIES. grocery_expiry=1362632400000 grocery_price=2.0 grocery_id=5937 03-06 23:40:17.343: E/SQLiteDatabase(6895): android.database.sqlite.SQLiteConstraintException: column grocery_id is not unique (code 19) 03-06 23:40:17.343: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteConnection.nativeExecuteForLastInsertedRowId(Native Method) 03-06 23:40:17.343: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteConnection.executeForLastInsertedRowId(SQLiteConnection.java:775) 03-06 23:40:17.343: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteSession.executeForLastInsertedRowId(SQLiteSession.java:788) 03-06 23:40:17.343: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteStatement.executeInsert(SQLiteStatement.java:86) 03-06 23:40:17.343: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1469) 03-06 23:40:17.343: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1339) 03-06 23:40:17.343: E/SQLiteDatabase(6895): at com.groceryotg.android.database.contentprovider.GroceryotgProvider.insert(GroceryotgProvider.java:128) 03-06 23:40:17.343: E/SQLiteDatabase(6895): at android.content.ContentProvider.bulkInsert(ContentProvider.java:705) 03-06 23:40:17.343: E/SQLiteDatabase(6895): at android.content.ContentProvider$Transport.bulkInsert(ContentProvider.java:207) 03-06 23:40:17.343: E/SQLiteDatabase(6895): at android.content.ContentResolver.bulkInsert(ContentResolver.java:925) 03-06 23:40:17.343: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.addNewGroceries(NetworkHandler.java:179) 03-06 23:40:17.343: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.refreshGrocery(NetworkHandler.java:145) 03-06 23:40:17.343: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.onHandleIntent(NetworkHandler.java:57) 03-06 23:40:17.343: E/SQLiteDatabase(6895): at android.app.IntentService$ServiceHandler.handleMessage(IntentService.java:65) 03-06 23:40:17.343: E/SQLiteDatabase(6895): at android.os.Handler.dispatchMessage(Handler.java:99) 03-06 23:40:17.343: E/SQLiteDatabase(6895): at android.os.Looper.loop(Looper.java:137) 03-06 23:40:17.343: E/SQLiteDatabase(6895): at android.os.HandlerThread.run(HandlerThread.java:60) 03-06 23:40:17.343: E/SQLiteDatabase(6895): Error inserting grocery_category=7 grocery_name=SELECTION CANOLA OIL COOKING SPRAY. 170 G. SELECTED VARIETIES. grocery_expiry=1362632400000 grocery_price=2.0 grocery_id=5938 03-06 23:40:17.343: E/SQLiteDatabase(6895): android.database.sqlite.SQLiteConstraintException: column grocery_id is not unique (code 19) 03-06 23:40:17.343: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteConnection.nativeExecuteForLastInsertedRowId(Native Method) 03-06 23:40:17.343: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteConnection.executeForLastInsertedRowId(SQLiteConnection.java:775) 03-06 23:40:17.343: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteSession.executeForLastInsertedRowId(SQLiteSession.java:788) 03-06 23:40:17.343: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteStatement.executeInsert(SQLiteStatement.java:86) 03-06 23:40:17.343: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1469) 03-06 23:40:17.343: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1339) 03-06 23:40:17.343: E/SQLiteDatabase(6895): at com.groceryotg.android.database.contentprovider.GroceryotgProvider.insert(GroceryotgProvider.java:128) 03-06 23:40:17.343: E/SQLiteDatabase(6895): at android.content.ContentProvider.bulkInsert(ContentProvider.java:705) 03-06 23:40:17.343: E/SQLiteDatabase(6895): at android.content.ContentProvider$Transport.bulkInsert(ContentProvider.java:207) 03-06 23:40:17.343: E/SQLiteDatabase(6895): at android.content.ContentResolver.bulkInsert(ContentResolver.java:925) 03-06 23:40:17.343: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.addNewGroceries(NetworkHandler.java:179) 03-06 23:40:17.343: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.refreshGrocery(NetworkHandler.java:145) 03-06 23:40:17.343: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.onHandleIntent(NetworkHandler.java:57) 03-06 23:40:17.343: E/SQLiteDatabase(6895): at android.app.IntentService$ServiceHandler.handleMessage(IntentService.java:65) 03-06 23:40:17.343: E/SQLiteDatabase(6895): at android.os.Handler.dispatchMessage(Handler.java:99) 03-06 23:40:17.343: E/SQLiteDatabase(6895): at android.os.Looper.loop(Looper.java:137) 03-06 23:40:17.343: E/SQLiteDatabase(6895): at android.os.HandlerThread.run(HandlerThread.java:60) 03-06 23:40:17.351: E/SQLiteDatabase(6895): Error inserting grocery_category=5 grocery_name=KELLOGGâ??S RICE KRISPIES. 340 - 525 G. MINI-WHEATS. 430 - 510 G. SELECTED VARIETIES. WHILE QUANTITIES LAST. grocery_expiry=1362632400000 grocery_price=4.0 grocery_id=5939 03-06 23:40:17.351: E/SQLiteDatabase(6895): android.database.sqlite.SQLiteConstraintException: column grocery_id is not unique (code 19) 03-06 23:40:17.351: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteConnection.nativeExecuteForLastInsertedRowId(Native Method) 03-06 23:40:17.351: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteConnection.executeForLastInsertedRowId(SQLiteConnection.java:775) 03-06 23:40:17.351: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteSession.executeForLastInsertedRowId(SQLiteSession.java:788) 03-06 23:40:17.351: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteStatement.executeInsert(SQLiteStatement.java:86) 03-06 23:40:17.351: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1469) 03-06 23:40:17.351: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1339) 03-06 23:40:17.351: E/SQLiteDatabase(6895): at com.groceryotg.android.database.contentprovider.GroceryotgProvider.insert(GroceryotgProvider.java:128) 03-06 23:40:17.351: E/SQLiteDatabase(6895): at android.content.ContentProvider.bulkInsert(ContentProvider.java:705) 03-06 23:40:17.351: E/SQLiteDatabase(6895): at android.content.ContentProvider$Transport.bulkInsert(ContentProvider.java:207) 03-06 23:40:17.351: E/SQLiteDatabase(6895): at android.content.ContentResolver.bulkInsert(ContentResolver.java:925) 03-06 23:40:17.351: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.addNewGroceries(NetworkHandler.java:179) 03-06 23:40:17.351: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.refreshGrocery(NetworkHandler.java:145) 03-06 23:40:17.351: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.onHandleIntent(NetworkHandler.java:57) 03-06 23:40:17.351: E/SQLiteDatabase(6895): at android.app.IntentService$ServiceHandler.handleMessage(IntentService.java:65) 03-06 23:40:17.351: E/SQLiteDatabase(6895): at android.os.Handler.dispatchMessage(Handler.java:99) 03-06 23:40:17.351: E/SQLiteDatabase(6895): at android.os.Looper.loop(Looper.java:137) 03-06 23:40:17.351: E/SQLiteDatabase(6895): at android.os.HandlerThread.run(HandlerThread.java:60) 03-06 23:40:17.351: E/SQLiteDatabase(6895): Error inserting grocery_category=4 grocery_name=CLOVER LEAF OR GOLD SEAL. LIGHT TUNA. 170 G. SELECTED VARIETIES. grocery_expiry=1362632400000 grocery_price=5.0 grocery_id=5940 03-06 23:40:17.351: E/SQLiteDatabase(6895): android.database.sqlite.SQLiteConstraintException: column grocery_id is not unique (code 19) 03-06 23:40:17.351: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteConnection.nativeExecuteForLastInsertedRowId(Native Method) 03-06 23:40:17.351: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteConnection.executeForLastInsertedRowId(SQLiteConnection.java:775) 03-06 23:40:17.351: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteSession.executeForLastInsertedRowId(SQLiteSession.java:788) 03-06 23:40:17.351: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteStatement.executeInsert(SQLiteStatement.java:86) 03-06 23:40:17.351: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1469) 03-06 23:40:17.351: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1339) 03-06 23:40:17.351: E/SQLiteDatabase(6895): at com.groceryotg.android.database.contentprovider.GroceryotgProvider.insert(GroceryotgProvider.java:128) 03-06 23:40:17.351: E/SQLiteDatabase(6895): at android.content.ContentProvider.bulkInsert(ContentProvider.java:705) 03-06 23:40:17.351: E/SQLiteDatabase(6895): at android.content.ContentProvider$Transport.bulkInsert(ContentProvider.java:207) 03-06 23:40:17.351: E/SQLiteDatabase(6895): at android.content.ContentResolver.bulkInsert(ContentResolver.java:925) 03-06 23:40:17.351: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.addNewGroceries(NetworkHandler.java:179) 03-06 23:40:17.351: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.refreshGrocery(NetworkHandler.java:145) 03-06 23:40:17.351: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.onHandleIntent(NetworkHandler.java:57) 03-06 23:40:17.351: E/SQLiteDatabase(6895): at android.app.IntentService$ServiceHandler.handleMessage(IntentService.java:65) 03-06 23:40:17.351: E/SQLiteDatabase(6895): at android.os.Handler.dispatchMessage(Handler.java:99) 03-06 23:40:17.351: E/SQLiteDatabase(6895): at android.os.Looper.loop(Looper.java:137) 03-06 23:40:17.351: E/SQLiteDatabase(6895): at android.os.HandlerThread.run(HandlerThread.java:60) 03-06 23:40:17.358: E/SQLiteDatabase(6895): Error inserting grocery_category=1 grocery_name=GAY LEA BUTTER. 454 G. SELECTED VARIETIES. grocery_expiry=1362632400000 grocery_price=4.0 grocery_id=5941 03-06 23:40:17.358: E/SQLiteDatabase(6895): android.database.sqlite.SQLiteConstraintException: column grocery_id is not unique (code 19) 03-06 23:40:17.358: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteConnection.nativeExecuteForLastInsertedRowId(Native Method) 03-06 23:40:17.358: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteConnection.executeForLastInsertedRowId(SQLiteConnection.java:775) 03-06 23:40:17.358: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteSession.executeForLastInsertedRowId(SQLiteSession.java:788) 03-06 23:40:17.358: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteStatement.executeInsert(SQLiteStatement.java:86) 03-06 23:40:17.358: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1469) 03-06 23:40:17.358: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1339) 03-06 23:40:17.358: E/SQLiteDatabase(6895): at com.groceryotg.android.database.contentprovider.GroceryotgProvider.insert(GroceryotgProvider.java:128) 03-06 23:40:17.358: E/SQLiteDatabase(6895): at android.content.ContentProvider.bulkInsert(ContentProvider.java:705) 03-06 23:40:17.358: E/SQLiteDatabase(6895): at android.content.ContentProvider$Transport.bulkInsert(ContentProvider.java:207) 03-06 23:40:17.358: E/SQLiteDatabase(6895): at android.content.ContentResolver.bulkInsert(ContentResolver.java:925) 03-06 23:40:17.358: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.addNewGroceries(NetworkHandler.java:179) 03-06 23:40:17.358: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.refreshGrocery(NetworkHandler.java:145) 03-06 23:40:17.358: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.onHandleIntent(NetworkHandler.java:57) 03-06 23:40:17.358: E/SQLiteDatabase(6895): at android.app.IntentService$ServiceHandler.handleMessage(IntentService.java:65) 03-06 23:40:17.358: E/SQLiteDatabase(6895): at android.os.Handler.dispatchMessage(Handler.java:99) 03-06 23:40:17.358: E/SQLiteDatabase(6895): at android.os.Looper.loop(Looper.java:137) 03-06 23:40:17.358: E/SQLiteDatabase(6895): at android.os.HandlerThread.run(HandlerThread.java:60) 03-06 23:40:17.358: E/SQLiteDatabase(6895): Error inserting grocery_category=5 grocery_name=MR. NOODLES. 12 X 85 G. SELECTED VARIETIES. WHILE QUANTITIES LAST. grocery_expiry=1362632400000 grocery_price=5.0 grocery_id=5942 03-06 23:40:17.358: E/SQLiteDatabase(6895): android.database.sqlite.SQLiteConstraintException: column grocery_id is not unique (code 19) 03-06 23:40:17.358: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteConnection.nativeExecuteForLastInsertedRowId(Native Method) 03-06 23:40:17.358: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteConnection.executeForLastInsertedRowId(SQLiteConnection.java:775) 03-06 23:40:17.358: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteSession.executeForLastInsertedRowId(SQLiteSession.java:788) 03-06 23:40:17.358: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteStatement.executeInsert(SQLiteStatement.java:86) 03-06 23:40:17.358: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1469) 03-06 23:40:17.358: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1339) 03-06 23:40:17.358: E/SQLiteDatabase(6895): at com.groceryotg.android.database.contentprovider.GroceryotgProvider.insert(GroceryotgProvider.java:128) 03-06 23:40:17.358: E/SQLiteDatabase(6895): at android.content.ContentProvider.bulkInsert(ContentProvider.java:705) 03-06 23:40:17.358: E/SQLiteDatabase(6895): at android.content.ContentProvider$Transport.bulkInsert(ContentProvider.java:207) 03-06 23:40:17.358: E/SQLiteDatabase(6895): at android.content.ContentResolver.bulkInsert(ContentResolver.java:925) 03-06 23:40:17.358: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.addNewGroceries(NetworkHandler.java:179) 03-06 23:40:17.358: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.refreshGrocery(NetworkHandler.java:145) 03-06 23:40:17.358: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.onHandleIntent(NetworkHandler.java:57) 03-06 23:40:17.358: E/SQLiteDatabase(6895): at android.app.IntentService$ServiceHandler.handleMessage(IntentService.java:65) 03-06 23:40:17.358: E/SQLiteDatabase(6895): at android.os.Handler.dispatchMessage(Handler.java:99) 03-06 23:40:17.358: E/SQLiteDatabase(6895): at android.os.Looper.loop(Looper.java:137) 03-06 23:40:17.358: E/SQLiteDatabase(6895): at android.os.HandlerThread.run(HandlerThread.java:60) 03-06 23:40:17.358: E/SQLiteDatabase(6895): Error inserting grocery_category=6 grocery_name=PEPSI OR 7UP. 2 L. SELECTED VARIETIES. grocery_expiry=1362632400000 grocery_price=3.0 grocery_id=5943 03-06 23:40:17.358: E/SQLiteDatabase(6895): android.database.sqlite.SQLiteConstraintException: column grocery_id is not unique (code 19) 03-06 23:40:17.358: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteConnection.nativeExecuteForLastInsertedRowId(Native Method) 03-06 23:40:17.358: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteConnection.executeForLastInsertedRowId(SQLiteConnection.java:775) 03-06 23:40:17.358: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteSession.executeForLastInsertedRowId(SQLiteSession.java:788) 03-06 23:40:17.358: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteStatement.executeInsert(SQLiteStatement.java:86) 03-06 23:40:17.358: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1469) 03-06 23:40:17.358: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1339) 03-06 23:40:17.358: E/SQLiteDatabase(6895): at com.groceryotg.android.database.contentprovider.GroceryotgProvider.insert(GroceryotgProvider.java:128) 03-06 23:40:17.358: E/SQLiteDatabase(6895): at android.content.ContentProvider.bulkInsert(ContentProvider.java:705) 03-06 23:40:17.358: E/SQLiteDatabase(6895): at android.content.ContentProvider$Transport.bulkInsert(ContentProvider.java:207) 03-06 23:40:17.358: E/SQLiteDatabase(6895): at android.content.ContentResolver.bulkInsert(ContentResolver.java:925) 03-06 23:40:17.358: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.addNewGroceries(NetworkHandler.java:179) 03-06 23:40:17.358: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.refreshGrocery(NetworkHandler.java:145) 03-06 23:40:17.358: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.onHandleIntent(NetworkHandler.java:57) 03-06 23:40:17.358: E/SQLiteDatabase(6895): at android.app.IntentService$ServiceHandler.handleMessage(IntentService.java:65) 03-06 23:40:17.358: E/SQLiteDatabase(6895): at android.os.Handler.dispatchMessage(Handler.java:99) 03-06 23:40:17.358: E/SQLiteDatabase(6895): at android.os.Looper.loop(Looper.java:137) 03-06 23:40:17.358: E/SQLiteDatabase(6895): at android.os.HandlerThread.run(HandlerThread.java:60) 03-06 23:40:17.366: E/SQLiteDatabase(6895): Error inserting grocery_category=7 grocery_name=NESTLÃ? REAL DAIRY ICE CREAM 1.5 L. FROZEN DESSERT OR TREATS 1.5 L OR 12â??S. DEL MONTE TREATS 12â??S, SELECTED VARIETIES. grocery_expiry=1362632400000 grocery_price=5.0 grocery_id=5944 03-06 23:40:17.366: E/SQLiteDatabase(6895): android.database.sqlite.SQLiteConstraintException: column grocery_id is not unique (code 19) 03-06 23:40:17.366: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteConnection.nativeExecuteForLastInsertedRowId(Native Method) 03-06 23:40:17.366: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteConnection.executeForLastInsertedRowId(SQLiteConnection.java:775) 03-06 23:40:17.366: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteSession.executeForLastInsertedRowId(SQLiteSession.java:788) 03-06 23:40:17.366: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteStatement.executeInsert(SQLiteStatement.java:86) 03-06 23:40:17.366: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1469) 03-06 23:40:17.366: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1339) 03-06 23:40:17.366: E/SQLiteDatabase(6895): at com.groceryotg.android.database.contentprovider.GroceryotgProvider.insert(GroceryotgProvider.java:128) 03-06 23:40:17.366: E/SQLiteDatabase(6895): at android.content.ContentProvider.bulkInsert(ContentProvider.java:705) 03-06 23:40:17.366: E/SQLiteDatabase(6895): at android.content.ContentProvider$Transport.bulkInsert(ContentProvider.java:207) 03-06 23:40:17.366: E/SQLiteDatabase(6895): at android.content.ContentResolver.bulkInsert(ContentResolver.java:925) 03-06 23:40:17.366: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.addNewGroceries(NetworkHandler.java:179) 03-06 23:40:17.366: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.refreshGrocery(NetworkHandler.java:145) 03-06 23:40:17.366: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.onHandleIntent(NetworkHandler.java:57) 03-06 23:40:17.366: E/SQLiteDatabase(6895): at android.app.IntentService$ServiceHandler.handleMessage(IntentService.java:65) 03-06 23:40:17.366: E/SQLiteDatabase(6895): at android.os.Handler.dispatchMessage(Handler.java:99) 03-06 23:40:17.366: E/SQLiteDatabase(6895): at android.os.Looper.loop(Looper.java:137) 03-06 23:40:17.366: E/SQLiteDatabase(6895): at android.os.HandlerThread.run(HandlerThread.java:60) 03-06 23:40:17.374: E/SQLiteDatabase(6895): Error inserting grocery_category=1 grocery_name=SELECTION LARGE WHITE EGGS. 18â??S. SELECTED VARIETIES. grocery_expiry=1362632400000 grocery_price=4.0 grocery_id=5945 03-06 23:40:17.374: E/SQLiteDatabase(6895): android.database.sqlite.SQLiteConstraintException: column grocery_id is not unique (code 19) 03-06 23:40:17.374: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteConnection.nativeExecuteForLastInsertedRowId(Native Method) 03-06 23:40:17.374: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteConnection.executeForLastInsertedRowId(SQLiteConnection.java:775) 03-06 23:40:17.374: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteSession.executeForLastInsertedRowId(SQLiteSession.java:788) 03-06 23:40:17.374: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteStatement.executeInsert(SQLiteStatement.java:86) 03-06 23:40:17.374: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1469) 03-06 23:40:17.374: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1339) 03-06 23:40:17.374: E/SQLiteDatabase(6895): at com.groceryotg.android.database.contentprovider.GroceryotgProvider.insert(GroceryotgProvider.java:128) 03-06 23:40:17.374: E/SQLiteDatabase(6895): at android.content.ContentProvider.bulkInsert(ContentProvider.java:705) 03-06 23:40:17.374: E/SQLiteDatabase(6895): at android.content.ContentProvider$Transport.bulkInsert(ContentProvider.java:207) 03-06 23:40:17.374: E/SQLiteDatabase(6895): at android.content.ContentResolver.bulkInsert(ContentResolver.java:925) 03-06 23:40:17.374: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.addNewGroceries(NetworkHandler.java:179) 03-06 23:40:17.374: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.refreshGrocery(NetworkHandler.java:145) 03-06 23:40:17.374: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.onHandleIntent(NetworkHandler.java:57) 03-06 23:40:17.374: E/SQLiteDatabase(6895): at android.app.IntentService$ServiceHandler.handleMessage(IntentService.java:65) 03-06 23:40:17.374: E/SQLiteDatabase(6895): at android.os.Handler.dispatchMessage(Handler.java:99) 03-06 23:40:17.374: E/SQLiteDatabase(6895): at android.os.Looper.loop(Looper.java:137) 03-06 23:40:17.374: E/SQLiteDatabase(6895): at android.os.HandlerThread.run(HandlerThread.java:60) 03-06 23:40:17.554: D/dalvikvm(6895): GC_FOR_ALLOC freed 1712K, 6% free 38780K/40903K, paused 178ms, total 178ms 03-06 23:40:17.554: E/SQLiteDatabase(6895): Error inserting grocery_category=7 grocery_name=CHIPITS. 200 - 350 G. SELECTED VARIETIES. grocery_expiry=1362632400000 grocery_price=5.0 grocery_id=5946 03-06 23:40:17.554: E/SQLiteDatabase(6895): android.database.sqlite.SQLiteConstraintException: column grocery_id is not unique (code 19) 03-06 23:40:17.554: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteConnection.nativeExecuteForLastInsertedRowId(Native Method) 03-06 23:40:17.554: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteConnection.executeForLastInsertedRowId(SQLiteConnection.java:775) 03-06 23:40:17.554: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteSession.executeForLastInsertedRowId(SQLiteSession.java:788) 03-06 23:40:17.554: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteStatement.executeInsert(SQLiteStatement.java:86) 03-06 23:40:17.554: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1469) 03-06 23:40:17.554: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1339) 03-06 23:40:17.554: E/SQLiteDatabase(6895): at com.groceryotg.android.database.contentprovider.GroceryotgProvider.insert(GroceryotgProvider.java:128) 03-06 23:40:17.554: E/SQLiteDatabase(6895): at android.content.ContentProvider.bulkInsert(ContentProvider.java:705) 03-06 23:40:17.554: E/SQLiteDatabase(6895): at android.content.ContentProvider$Transport.bulkInsert(ContentProvider.java:207) 03-06 23:40:17.554: E/SQLiteDatabase(6895): at android.content.ContentResolver.bulkInsert(ContentResolver.java:925) 03-06 23:40:17.554: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.addNewGroceries(NetworkHandler.java:179) 03-06 23:40:17.554: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.refreshGrocery(NetworkHandler.java:145) 03-06 23:40:17.554: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.onHandleIntent(NetworkHandler.java:57) 03-06 23:40:17.554: E/SQLiteDatabase(6895): at android.app.IntentService$ServiceHandler.handleMessage(IntentService.java:65) 03-06 23:40:17.554: E/SQLiteDatabase(6895): at android.os.Handler.dispatchMessage(Handler.java:99) 03-06 23:40:17.554: E/SQLiteDatabase(6895): at android.os.Looper.loop(Looper.java:137) 03-06 23:40:17.554: E/SQLiteDatabase(6895): at android.os.HandlerThread.run(HandlerThread.java:60) 03-06 23:40:17.554: E/SQLiteDatabase(6895): Error inserting grocery_category=5 grocery_name=SELECTION PIE FILLING. 540 ML. SELECTED VARIETIES. grocery_expiry=1362632400000 grocery_price=3.0 grocery_id=5947 03-06 23:40:17.554: E/SQLiteDatabase(6895): android.database.sqlite.SQLiteConstraintException: column grocery_id is not unique (code 19) 03-06 23:40:17.554: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteConnection.nativeExecuteForLastInsertedRowId(Native Method) 03-06 23:40:17.554: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteConnection.executeForLastInsertedRowId(SQLiteConnection.java:775) 03-06 23:40:17.554: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteSession.executeForLastInsertedRowId(SQLiteSession.java:788) 03-06 23:40:17.554: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteStatement.executeInsert(SQLiteStatement.java:86) 03-06 23:40:17.554: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1469) 03-06 23:40:17.554: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1339) 03-06 23:40:17.554: E/SQLiteDatabase(6895): at com.groceryotg.android.database.contentprovider.GroceryotgProvider.insert(GroceryotgProvider.java:128) 03-06 23:40:17.554: E/SQLiteDatabase(6895): at android.content.ContentProvider.bulkInsert(ContentProvider.java:705) 03-06 23:40:17.554: E/SQLiteDatabase(6895): at android.content.ContentProvider$Transport.bulkInsert(ContentProvider.java:207) 03-06 23:40:17.554: E/SQLiteDatabase(6895): at android.content.ContentResolver.bulkInsert(ContentResolver.java:925) 03-06 23:40:17.554: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.addNewGroceries(NetworkHandler.java:179) 03-06 23:40:17.554: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.refreshGrocery(NetworkHandler.java:145) 03-06 23:40:17.554: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.onHandleIntent(NetworkHandler.java:57) 03-06 23:40:17.554: E/SQLiteDatabase(6895): at android.app.IntentService$ServiceHandler.handleMessage(IntentService.java:65) 03-06 23:40:17.554: E/SQLiteDatabase(6895): at android.os.Handler.dispatchMessage(Handler.java:99) 03-06 23:40:17.554: E/SQLiteDatabase(6895): at android.os.Looper.loop(Looper.java:137) 03-06 23:40:17.554: E/SQLiteDatabase(6895): at android.os.HandlerThread.run(HandlerThread.java:60) 03-06 23:40:17.561: E/SQLiteDatabase(6895): Error inserting grocery_category=5 grocery_name=SELECTION PIE SHELLS. FROZEN, 228 - 380 G. SELECTED VARIETIES. OR 2.69 EA. grocery_expiry=1362632400000 grocery_price=5.0 grocery_id=5948 03-06 23:40:17.561: E/SQLiteDatabase(6895): android.database.sqlite.SQLiteConstraintException: column grocery_id is not unique (code 19) 03-06 23:40:17.561: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteConnection.nativeExecuteForLastInsertedRowId(Native Method) 03-06 23:40:17.561: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteConnection.executeForLastInsertedRowId(SQLiteConnection.java:775) 03-06 23:40:17.561: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteSession.executeForLastInsertedRowId(SQLiteSession.java:788) 03-06 23:40:17.561: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteStatement.executeInsert(SQLiteStatement.java:86) 03-06 23:40:17.561: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1469) 03-06 23:40:17.561: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1339) 03-06 23:40:17.561: E/SQLiteDatabase(6895): at com.groceryotg.android.database.contentprovider.GroceryotgProvider.insert(GroceryotgProvider.java:128) 03-06 23:40:17.561: E/SQLiteDatabase(6895): at android.content.ContentProvider.bulkInsert(ContentProvider.java:705) 03-06 23:40:17.561: E/SQLiteDatabase(6895): at android.content.ContentProvider$Transport.bulkInsert(ContentProvider.java:207) 03-06 23:40:17.561: E/SQLiteDatabase(6895): at android.content.ContentResolver.bulkInsert(ContentResolver.java:925) 03-06 23:40:17.561: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.addNewGroceries(NetworkHandler.java:179) 03-06 23:40:17.561: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.refreshGrocery(NetworkHandler.java:145) 03-06 23:40:17.561: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.onHandleIntent(NetworkHandler.java:57) 03-06 23:40:17.561: E/SQLiteDatabase(6895): at android.app.IntentService$ServiceHandler.handleMessage(IntentService.java:65) 03-06 23:40:17.561: E/SQLiteDatabase(6895): at android.os.Handler.dispatchMessage(Handler.java:99) 03-06 23:40:17.561: E/SQLiteDatabase(6895): at android.os.Looper.loop(Looper.java:137) 03-06 23:40:17.561: E/SQLiteDatabase(6895): at android.os.HandlerThread.run(HandlerThread.java:60) 03-06 23:40:17.561: E/SQLiteDatabase(6895): Error inserting grocery_category=7 grocery_name=SELECTION PECANS. 100 G. SELECTED VARIETIES. grocery_expiry=1362632400000 grocery_price=5.0 grocery_id=5949 03-06 23:40:17.561: E/SQLiteDatabase(6895): android.database.sqlite.SQLiteConstraintException: column grocery_id is not unique (code 19) 03-06 23:40:17.561: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteConnection.nativeExecuteForLastInsertedRowId(Native Method) 03-06 23:40:17.561: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteConnection.executeForLastInsertedRowId(SQLiteConnection.java:775) 03-06 23:40:17.561: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteSession.executeForLastInsertedRowId(SQLiteSession.java:788) 03-06 23:40:17.561: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteStatement.executeInsert(SQLiteStatement.java:86) 03-06 23:40:17.561: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1469) 03-06 23:40:17.561: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1339) 03-06 23:40:17.561: E/SQLiteDatabase(6895): at com.groceryotg.android.database.contentprovider.GroceryotgProvider.insert(GroceryotgProvider.java:128) 03-06 23:40:17.561: E/SQLiteDatabase(6895): at android.content.ContentProvider.bulkInsert(ContentProvider.java:705) 03-06 23:40:17.561: E/SQLiteDatabase(6895): at android.content.ContentProvider$Transport.bulkInsert(ContentProvider.java:207) 03-06 23:40:17.561: E/SQLiteDatabase(6895): at android.content.ContentResolver.bulkInsert(ContentResolver.java:925) 03-06 23:40:17.561: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.addNewGroceries(NetworkHandler.java:179) 03-06 23:40:17.561: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.refreshGrocery(NetworkHandler.java:145) 03-06 23:40:17.561: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.onHandleIntent(NetworkHandler.java:57) 03-06 23:40:17.561: E/SQLiteDatabase(6895): at android.app.IntentService$ServiceHandler.handleMessage(IntentService.java:65) 03-06 23:40:17.561: E/SQLiteDatabase(6895): at android.os.Handler.dispatchMessage(Handler.java:99) 03-06 23:40:17.561: E/SQLiteDatabase(6895): at android.os.Looper.loop(Looper.java:137) 03-06 23:40:17.561: E/SQLiteDatabase(6895): at android.os.HandlerThread.run(HandlerThread.java:60) 03-06 23:40:17.569: E/SQLiteDatabase(6895): Error inserting grocery_category=7 grocery_name=SELECTION HONEY. 1 KG. SELECTED VARIETIES. grocery_expiry=1362632400000 grocery_price=6.0 grocery_id=5950 03-06 23:40:17.569: E/SQLiteDatabase(6895): android.database.sqlite.SQLiteConstraintException: column grocery_id is not unique (code 19) 03-06 23:40:17.569: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteConnection.nativeExecuteForLastInsertedRowId(Native Method) 03-06 23:40:17.569: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteConnection.executeForLastInsertedRowId(SQLiteConnection.java:775) 03-06 23:40:17.569: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteSession.executeForLastInsertedRowId(SQLiteSession.java:788) 03-06 23:40:17.569: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteStatement.executeInsert(SQLiteStatement.java:86) 03-06 23:40:17.569: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1469) 03-06 23:40:17.569: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1339) 03-06 23:40:17.569: E/SQLiteDatabase(6895): at com.groceryotg.android.database.contentprovider.GroceryotgProvider.insert(GroceryotgProvider.java:128) 03-06 23:40:17.569: E/SQLiteDatabase(6895): at android.content.ContentProvider.bulkInsert(ContentProvider.java:705) 03-06 23:40:17.569: E/SQLiteDatabase(6895): at android.content.ContentProvider$Transport.bulkInsert(ContentProvider.java:207) 03-06 23:40:17.569: E/SQLiteDatabase(6895): at android.content.ContentResolver.bulkInsert(ContentResolver.java:925) 03-06 23:40:17.569: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.addNewGroceries(NetworkHandler.java:179) 03-06 23:40:17.569: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.refreshGrocery(NetworkHandler.java:145) 03-06 23:40:17.569: E/SQLiteDatabase(6895): at com.groceryotg.android.services.NetworkHandler.onHandleIntent(NetworkHandler.java:57) 03-06 23:40:17.569: E/SQLiteDatabase(6895): at android.app.IntentService$ServiceHandler.handleMessage(IntentService.java:65) 03-06 23:40:17.569: E/SQLiteDatabase(6895): at android.os.Handler.dispatchMessage(Handler.java:99) 03-06 23:40:17.569: E/SQLiteDatabase(6895): at android.os.Looper.loop(Looper.java:137) 03-06 23:40:17.569: E/SQLiteDatabase(6895): at android.os.HandlerThread.run(HandlerThread.java:60) 03-06 23:40:17.569: E/SQLiteDatabase(6895): Error inserting grocery_category=3 grocery_name=RUSSET POTATOES. PRODUCT OF CANADA. CANADA NO. 1, 5 LB BAG. grocery_expiry=1362632400000 grocery_price=1.0 grocery_id=5951 03-06 23:40:17.569: E/SQLiteDatabase(6895): android.database.sqlite.SQLiteConstraintException: column grocery_id is not unique (code 19) 03-06 23:40:17.569: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteConnection.nativeExecuteForLastInsertedRowId(Native Method) 03-06 23:40:17.569: E/SQLiteDatabase(6895): at android.database.sqlite.SQLiteConnection.executeForLastInsertedRowId(SQLiteConnection.java:775) 03-06 23

wangyif2 commented 11 years ago

K I was able to reproduce this error. But I have a midterm tomorrow, so i prob won't be able to fix it till tmrw night.

it seems to me that the older entries were deleted. If you have time, can you see if the end date was older than today's date?

For the exception, i believe it is because pending intent was trying to send back to the old activity that sent it in the first place, but the activity was destroyed. We can fix this by canceling the pending intent in activity onDestroy. I'll try to fix this on Friday...

yancheva commented 11 years ago

For the items that weren't being displayed: start_date=2013-03-01, end_date=2013-03-07 For the one item that was being displayed, start_date=2013-03-07, end_date=2013-03-13

So we need to include all items whose end date is the current date.

wangyif2 commented 11 years ago

Okay that makes sense, I believe that is a 1 character change, can you do a search for less than sign and add a equal after? On Mar 7, 2013 11:02 PM, "Maria Yancheva" notifications@github.com wrote:

For the items that weren't being displayed: start_date=2013-03-01, end_date=2013-03-07 For the one item that was being displayed, start_date=2013-03-07, end_date=2013-03-13

So we need to include all items whose end date is the current date.

— Reply to this email directly or view it on GitHubhttps://github.com/wangyif2/GroceryOTG/issues/14#issuecomment-14601684 .

yancheva commented 11 years ago

Hmm, in UpdateGroceryInfo it appears to be "greater than or equal to" already:

gro = (List) session.createCriteria(Grocery.class).add(Restrictions.ge("endDate", requestDate)).list();

Is there another place to check?

wangyif2 commented 11 years ago

Oh no, it should be in network Handler as well as database helper, that is the query I apply to delete On Mar 7, 2013 11:12 PM, "Maria Yancheva" notifications@github.com wrote:

Hmm, in UpdateGroceryInfo it appears to be "greater than or equal to" already:

gro = (List) session.createCriteria(Grocery.class).add(Restrictions.ge("endDate", requestDate)).list();

Is there another place to check?

— Reply to this email directly or view it on GitHubhttps://github.com/wangyif2/GroceryOTG/issues/14#issuecomment-14601904 .

yancheva commented 11 years ago

Well the problem was that it wasn't fetching (i.e. inserting) items, not that it wasn't deleting them. Also, as of my last refresh (just now), it loads all of the items (???).

wangyif2 commented 11 years ago

Fixed with commit 5ef2e43bb7be2465bd277f42e0d4432a7ebe5a3e