Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

BUG : Fails to Send Events on tvOS (only real device) #358

Closed
saeedmalas opened this issue Aug 8, 2023 · 19 comments · Fixed by #414
Closed

BUG : Fails to Send Events on tvOS (only real device) #358

saeedmalas opened this issue Aug 8, 2023 · 19 comments · Fixed by #414
Assignees
Labels
BUG Something isn't working v1

Comments

@saeedmalas
Copy link

saeedmalas commented Aug 8, 2023

I was working on RS 1.15.1 version on simulator it works correctly sending events while on real machine it shows these errors:

RSStack:Error:RSDBPersistentManager: checkIfStatusColumnExists: SQLite Command Preparation Failed: SELECT COUNT(*) from pragma_table_info("events") where name="status"

RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: ALTER TABLE events ADD COLUMN status INTEGER DEFAULT 0

RSStack:Error:RSDBPersistentManager: performMigration: events table migration failed

RSStack:Error:RSDBPersistentManager: saveEvent: SQLite Command Preparation Failed

RSStack:Error:RSDBPersistentManager: clearProcessedEventsFromDB: Failed to clear the processed events from the db

I tried to update the version to 1.17.0, and I tried to try the v2 SDK, but the same errors appear.

tvOS: 16.5
Note: that I did not use SQLite.shutdown().

@desusai7
Copy link
Contributor

desusai7 commented Aug 9, 2023

Hey @saeedmalas,

Seems like all the Sqlite commands were getting failed on the real tvOS device, Can you please share the complete logs for us to debug this issue ?

@desusai7 desusai7 added the BUG Something isn't working label Aug 9, 2023
@saeedmalas
Copy link
Author

Thank you @desusai7

These are all the problems that appear in the log and are related to RSStack:Error:


2023-08-09 11:26:35.777371+0300 AppName[419:165002] RSStack:Error:RSDBPersistentManager: getSQLiteVersion: SQLite Command Preparation Failed: SELECT sqlite_version()
AppName[419:165002] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: CREATE TABLE IF NOT EXISTS events( id INTEGER PRIMARY KEY AUTOINCREMENT, message TEXT NOT NULL, updated INTEGER NOT NULL, status INTEGER DEFAULT 0);
2023-08-09 11:26:35.812837+0300 AppName[419:165002] RSStack:Error:RSDBPersistentManager: createEventsTableWithVersion: failed to create the table
2023-08-09 11:26:35.813108+0300 AppName[419:165002] RSStack:Error:RSDBPersistentManager: checkIfStatusColumnExists: SQLite Command Preparation Failed: SELECT COUNT(*) from pragma_table_info("events") where name="status";
2023-08-09 11:26:35.814525+0300 AppName[419:165002] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: ALTER TABLE events ADD COLUMN status INTEGER DEFAULT 0;
2023-08-09 11:26:35.814646+0300 AppName[419:165002] RSStack:Error:RSDBPersistentManager: performMigration: events table migration failed
2023-08-09 11:26:35.930127+0300 AppName[419:165002] RSStack:Error:RSDBPersistentManager: saveEvent: SQLite Command Preparation Failed
2023-08-09 11:26:35.978435+0300 AppName[419:165002] RSStack:Error:RSDBPersistentManager: saveEvent: SQLite Command Preparation Failed
 AppName[419:165002] RSStack:Error:RSDBPersistentManager: saveEvent: SQLite Command Preparation Failed
2023-08-09 11:26:37.863589+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: DELETE FROM events WHERE status = 3
2023-08-09 11:26:37.863885+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: clearProcessedEventsFromDB: Failed to clear the processed events from the db
2023-08-09 11:26:37.864573+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getDBRecordCount: Failed to fetch events count from DB
2023-08-09 11:26:37.865424+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getEventsFromDB: Failed to fetch events from DB
2023-08-09 11:26:38.872046+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: DELETE FROM events WHERE status = 3
2023-08-09 11:26:38.872332+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: clearProcessedEventsFromDB: Failed to clear the processed events from the db
2023-08-09 11:26:38.873037+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getDBRecordCount: Failed to fetch events count from DB
2023-08-09 11:26:38.873867+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getEventsFromDB: Failed to fetch events from DB
2023-08-09 11:26:39.880096+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: DELETE FROM events WHERE status = 3
2023-08-09 11:26:39.880238+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: clearProcessedEventsFromDB: Failed to clear the processed events from the db
2023-08-09 11:26:39.880557+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getDBRecordCount: Failed to fetch events count from DB
2023-08-09 11:26:39.882133+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getEventsFromDB: Failed to fetch events from DB
2023-08-09 11:26:40.183197+0300 AppName[419:165002] RSStack:Error:RSDBPersistentManager: saveEvent: SQLite Command Preparation Failed
2023-08-09 11:26:40.887825+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: DELETE FROM events WHERE status = 3
2023-08-09 11:26:40.887923+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: clearProcessedEventsFromDB: Failed to clear the processed events from the db
2023-08-09 11:26:40.888129+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getDBRecordCount: Failed to fetch events count from DB
2023-08-09 11:26:40.891184+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getEventsFromDB: Failed to fetch events from DB
2023-08-09 11:26:41.895235+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: DELETE FROM events WHERE status = 3
2023-08-09 11:26:41.895654+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: clearProcessedEventsFromDB: Failed to clear the processed events from the db
2023-08-09 11:26:41.896654+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getDBRecordCount: Failed to fetch events count from DB
2023-08-09 11:26:41.899201+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getEventsFromDB: Failed to fetch events from DB
2023-08-09 11:26:42.903053+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: DELETE FROM events WHERE status = 3
2023-08-09 11:26:42.903330+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: clearProcessedEventsFromDB: Failed to clear the processed events from the db
2023-08-09 11:26:42.904035+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getDBRecordCount: Failed to fetch events count from DB
2023-08-09 11:26:42.906792+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getEventsFromDB: Failed to fetch events from DB
2023-08-09 11:26:43.913405+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: DELETE FROM events WHERE status = 3
2023-08-09 11:26:43.913691+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: clearProcessedEventsFromDB: Failed to clear the processed events from the db
2023-08-09 11:26:43.914379+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getDBRecordCount: Failed to fetch events count from DB
2023-08-09 11:26:43.915197+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getEventsFromDB: Failed to fetch events from DB
2023-08-09 11:26:44.919866+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: DELETE FROM events WHERE status = 3
2023-08-09 11:26:44.920144+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: clearProcessedEventsFromDB: Failed to clear the processed events from the db
2023-08-09 11:26:44.920810+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getDBRecordCount: Failed to fetch events count from DB
2023-08-09 11:26:44.921672+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getEventsFromDB: Failed to fetch events from DB
2023-08-09 11:26:45.928223+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: DELETE FROM events WHERE status = 3
2023-08-09 11:26:45.928510+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: clearProcessedEventsFromDB: Failed to clear the processed events from the db
2023-08-09 11:26:45.929252+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getDBRecordCount: Failed to fetch events count from DB
2023-08-09 11:26:45.930094+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getEventsFromDB: Failed to fetch events from DB
2023-08-09 11:26:46.936479+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: DELETE FROM events WHERE status = 3
2023-08-09 11:26:46.936796+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: clearProcessedEventsFromDB: Failed to clear the processed events from the db
2023-08-09 11:26:46.938005+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getDBRecordCount: Failed to fetch events count from DB
2023-08-09 11:26:46.940867+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getEventsFromDB: Failed to fetch events from DB
2023-08-09 11:26:47.944274+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: DELETE FROM events WHERE status = 3
2023-08-09 11:26:47.944565+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: clearProcessedEventsFromDB: Failed to clear the processed events from the db
2023-08-09 11:26:47.945257+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getDBRecordCount: Failed to fetch events count from DB
2023-08-09 11:26:47.946095+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getEventsFromDB: Failed to fetch events from DB
2023-08-09 11:26:48.952677+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: DELETE FROM events WHERE status = 3
2023-08-09 11:26:48.952963+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: clearProcessedEventsFromDB: Failed to clear the processed events from the db
2023-08-09 11:26:48.953648+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getDBRecordCount: Failed to fetch events count from DB
2023-08-09 11:26:48.954473+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getEventsFromDB: Failed to fetch events from DB
2023-08-09 11:26:49.956391+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: DELETE FROM events WHERE status = 3
2023-08-09 11:26:49.956585+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: clearProcessedEventsFromDB: Failed to clear the processed events from the db
2023-08-09 11:26:49.957038+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getDBRecordCount: Failed to fetch events count from DB
2023-08-09 11:26:49.957609+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getEventsFromDB: Failed to fetch events from DB
2023-08-09 11:26:50.964061+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: DELETE FROM events WHERE status = 3
2023-08-09 11:26:50.964346+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: clearProcessedEventsFromDB: Failed to clear the processed events from the db
2023-08-09 11:26:50.965037+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getDBRecordCount: Failed to fetch events count from DB
2023-08-09 11:26:50.966238+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getEventsFromDB: Failed to fetch events from DB
2023-08-09 11:26:51.972199+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: DELETE FROM events WHERE status = 3
2023-08-09 11:26:51.972573+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: clearProcessedEventsFromDB: Failed to clear the processed events from the db
2023-08-09 11:26:51.973291+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getDBRecordCount: Failed to fetch events count from DB
2023-08-09 11:26:51.976975+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getEventsFromDB: Failed to fetch events from DB
2023-08-09 11:26:52.985332+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: DELETE FROM events WHERE status = 3
2023-08-09 11:26:52.985493+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: clearProcessedEventsFromDB: Failed to clear the processed events from the db
2023-08-09 11:26:52.985864+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getDBRecordCount: Failed to fetch events count from DB
2023-08-09 11:26:52.987400+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getEventsFromDB: Failed to fetch events from DB
2023-08-09 11:26:53.993387+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: DELETE FROM events WHERE status = 3
2023-08-09 11:26:53.993630+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: clearProcessedEventsFromDB: Failed to clear the processed events from the db
2023-08-09 11:26:53.994146+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getDBRecordCount: Failed to fetch events count from DB
2023-08-09 11:26:53.994696+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getEventsFromDB: Failed to fetch events from DB
2023-08-09 11:26:54.996600+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: DELETE FROM events WHERE status = 3
2023-08-09 11:26:54.996928+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: clearProcessedEventsFromDB: Failed to clear the processed events from the db
2023-08-09 11:26:54.997620+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getDBRecordCount: Failed to fetch events count from DB
2023-08-09 11:26:55.000067+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getEventsFromDB: Failed to fetch events from DB
2023-08-09 11:26:56.005030+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: DELETE FROM events WHERE status = 3
2023-08-09 11:26:56.005143+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: clearProcessedEventsFromDB: Failed to clear the processed events from the db
2023-08-09 11:26:56.005759+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getDBRecordCount: Failed to fetch events count from DB
2023-08-09 11:26:56.007074+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getEventsFromDB: Failed to fetch events from DB
2023-08-09 11:26:57.011406+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: DELETE FROM events WHERE status = 3
2023-08-09 11:26:57.011983+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: clearProcessedEventsFromDB: Failed to clear the processed events from the db
2023-08-09 11:26:57.013423+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getDBRecordCount: Failed to fetch events count from DB
2023-08-09 11:26:57.014704+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getEventsFromDB: Failed to fetch events from DB
2023-08-09 11:26:58.017652+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: DELETE FROM events WHERE status = 3
2023-08-09 11:26:58.017830+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: clearProcessedEventsFromDB: Failed to clear the processed events from the db
2023-08-09 11:26:58.018173+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getDBRecordCount: Failed to fetch events count from DB
2023-08-09 11:26:58.018600+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getEventsFromDB: Failed to fetch events from DB
2023-08-09 11:26:59.022682+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: DELETE FROM events WHERE status = 3
2023-08-09 11:26:59.022903+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: clearProcessedEventsFromDB: Failed to clear the processed events from the db
2023-08-09 11:26:59.023566+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getDBRecordCount: Failed to fetch events count from DB
2023-08-09 11:26:59.025517+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getEventsFromDB: Failed to fetch events from DB
2023-08-09 11:27:00.032558+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: DELETE FROM events WHERE status = 3
2023-08-09 11:27:00.033201+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: clearProcessedEventsFromDB: Failed to clear the processed events from the db
2023-08-09 11:27:00.034333+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getDBRecordCount: Failed to fetch events count from DB
2023-08-09 11:27:00.036065+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getEventsFromDB: Failed to fetch events from DB
2023-08-09 11:27:01.042006+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: DELETE FROM events WHERE status = 3
2023-08-09 11:27:01.042318+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: clearProcessedEventsFromDB: Failed to clear the processed events from the db
2023-08-09 11:27:01.043007+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getDBRecordCount: Failed to fetch events count from DB
2023-08-09 11:27:01.043926+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getEventsFromDB: Failed to fetch events from DB
2023-08-09 11:27:02.046518+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: DELETE FROM events WHERE status = 3
2023-08-09 11:27:02.046704+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: clearProcessedEventsFromDB: Failed to clear the processed events from the db
2023-08-09 11:27:02.047135+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getDBRecordCount: Failed to fetch events count from DB
2023-08-09 11:27:02.052045+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getEventsFromDB: Failed to fetch events from DB
2023-08-09 11:27:03.057334+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: DELETE FROM events WHERE status = 3
2023-08-09 11:27:03.057514+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: clearProcessedEventsFromDB: Failed to clear the processed events from the db
2023-08-09 11:27:03.057944+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getDBRecordCount: Failed to fetch events count from DB
2023-08-09 11:27:03.060332+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getEventsFromDB: Failed to fetch events from DB
2023-08-09 11:27:04.062108+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: DELETE FROM events WHERE status = 3
2023-08-09 11:27:04.062397+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: clearProcessedEventsFromDB: Failed to clear the processed events from the db
2023-08-09 11:27:04.062932+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getDBRecordCount: Failed to fetch events count from DB
2023-08-09 11:27:04.065564+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getEventsFromDB: Failed to fetch events from DB
2023-08-09 11:27:05.070585+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: DELETE FROM events WHERE status = 3
2023-08-09 11:27:05.070801+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: clearProcessedEventsFromDB: Failed to clear the processed events from the db
2023-08-09 11:27:05.071141+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getDBRecordCount: Failed to fetch events count from DB
2023-08-09 11:27:05.071625+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getEventsFromDB: Failed to fetch events from DB
2023-08-09 11:27:06.077715+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: DELETE FROM events WHERE status = 3
2023-08-09 11:27:06.077841+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: clearProcessedEventsFromDB: Failed to clear the processed events from the db
2023-08-09 11:27:06.078151+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getDBRecordCount: Failed to fetch events count from DB
2023-08-09 11:27:06.078904+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getEventsFromDB: Failed to fetch events from DB
2023-08-09 11:27:07.086171+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: DELETE FROM events WHERE status = 3
2023-08-09 11:27:07.086331+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: clearProcessedEventsFromDB: Failed to clear the processed events from the db
2023-08-09 11:27:07.086663+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getDBRecordCount: Failed to fetch events count from DB
2023-08-09 11:27:07.087072+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getEventsFromDB: Failed to fetch events from DB
2023-08-09 11:27:08.088667+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: DELETE FROM events WHERE status = 3
2023-08-09 11:27:08.088884+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: clearProcessedEventsFromDB: Failed to clear the processed events from the db
2023-08-09 11:27:08.089226+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getDBRecordCount: Failed to fetch events count from DB
2023-08-09 11:27:08.089648+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getEventsFromDB: Failed to fetch events from DB
2023-08-09 11:27:09.095171+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: DELETE FROM events WHERE status = 3
2023-08-09 11:27:09.095372+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: clearProcessedEventsFromDB: Failed to clear the processed events from the db
2023-08-09 11:27:09.095732+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getDBRecordCount: Failed to fetch events count from DB
2023-08-09 11:27:09.097845+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getEventsFromDB: Failed to fetch events from DB
2023-08-09 11:27:10.102945+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: DELETE FROM events WHERE status = 3
2023-08-09 11:27:10.103217+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: clearProcessedEventsFromDB: Failed to clear the processed events from the db
2023-08-09 11:27:10.103998+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getDBRecordCount: Failed to fetch events count from DB
2023-08-09 11:27:10.106369+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getEventsFromDB: Failed to fetch events from DB
2023-08-09 11:27:11.107466+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: DELETE FROM events WHERE status = 3
2023-08-09 11:27:11.108041+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: clearProcessedEventsFromDB: Failed to clear the processed events from the db
2023-08-09 11:27:11.108674+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getDBRecordCount: Failed to fetch events count from DB
2023-08-09 11:27:11.109761+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getEventsFromDB: Failed to fetch events from DB
2023-08-09 11:27:12.115260+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: DELETE FROM events WHERE status = 3
2023-08-09 11:27:12.115375+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: clearProcessedEventsFromDB: Failed to clear the processed events from the db
2023-08-09 11:27:12.115631+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getDBRecordCount: Failed to fetch events count from DB
2023-08-09 11:27:12.116378+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getEventsFromDB: Failed to fetch events from DB
2023-08-09 11:27:13.121474+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: DELETE FROM events WHERE status = 3
2023-08-09 11:27:13.121686+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: clearProcessedEventsFromDB: Failed to clear the processed events from the db
2023-08-09 11:27:13.122057+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getDBRecordCount: Failed to fetch events count from DB
2023-08-09 11:27:13.122462+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getEventsFromDB: Failed to fetch events from DB
2023-08-09 11:27:14.127194+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: DELETE FROM events WHERE status = 3
2023-08-09 11:27:14.127330+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: clearProcessedEventsFromDB: Failed to clear the processed events from the db
2023-08-09 11:27:14.128782+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getDBRecordCount: Failed to fetch events count from DB
 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getEventsFromDB: Failed to fetch events from DB
2023-08-09 11:27:15.135622+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: DELETE FROM events WHERE status = 3
2023-08-09 11:27:15.136292+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: clearProcessedEventsFromDB: Failed to clear the processed events from the db
2023-08-09 11:27:15.137206+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getDBRecordCount: Failed to fetch events count from DB
2023-08-09 11:27:15.138781+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getEventsFromDB: Failed to fetch events from DB
2023-08-09 11:27:16.140531+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: DELETE FROM events WHERE status = 3
2023-08-09 11:27:16.140647+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: clearProcessedEventsFromDB: Failed to clear the processed events from the db
2023-08-09 11:27:16.140905+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getDBRecordCount: Failed to fetch events count from DB
2023-08-09 11:27:16.141215+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getEventsFromDB: Failed to fetch events from DB
2023-08-09 11:27:17.142084+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: DELETE FROM events WHERE status = 3
2023-08-09 11:27:17.142235+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: clearProcessedEventsFromDB: Failed to clear the processed events from the db
2023-08-09 11:27:17.142585+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getDBRecordCount: Failed to fetch events count from DB
2023-08-09 11:27:17.142995+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getEventsFromDB: Failed to fetch events from DB
2023-08-09 11:27:18.144825+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: DELETE FROM events WHERE status = 3
2023-08-09 11:27:18.145234+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: clearProcessedEventsFromDB: Failed to clear the processed events from the db
2023-08-09 11:27:18.145718+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getDBRecordCount: Failed to fetch events count from DB
2023-08-09 11:27:18.147474+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getEventsFromDB: Failed to fetch events from DB
2023-08-09 11:27:19.153535+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: DELETE FROM events WHERE status = 3
2023-08-09 11:27:19.153746+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: clearProcessedEventsFromDB: Failed to clear the processed events from the db
2023-08-09 11:27:19.154240+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getDBRecordCount: Failed to fetch events count from DB
2023-08-09 11:27:19.154864+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getEventsFromDB: Failed to fetch events from DB
2023-08-09 11:27:20.160713+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: DELETE FROM events WHERE status = 3
2023-08-09 11:27:20.160917+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: clearProcessedEventsFromDB: Failed to clear the processed events from the db
2023-08-09 11:27:20.161392+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getDBRecordCount: Failed to fetch events count from DB
2023-08-09 11:27:20.162002+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getEventsFromDB: Failed to fetch events from DB
2023-08-09 11:27:21.164630+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: DELETE FROM events WHERE status = 3
2023-08-09 11:27:21.164918+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: clearProcessedEventsFromDB: Failed to clear the processed events from the db
2023-08-09 11:27:21.165771+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getDBRecordCount: Failed to fetch events count from DB
2023-08-09 11:27:21.169132+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getEventsFromDB: Failed to fetch events from DB
2023-08-09 11:27:22.173591+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: DELETE FROM events WHERE status = 3
2023-08-09 11:27:22.173739+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: clearProcessedEventsFromDB: Failed to clear the processed events from the db
2023-08-09 11:27:22.174089+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getDBRecordCount: Failed to fetch events count from DB
2023-08-09 11:27:22.174587+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getEventsFromDB: Failed to fetch events from DB
2023-08-09 11:27:23.180797+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: DELETE FROM events WHERE status = 3
2023-08-09 11:27:23.180998+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: clearProcessedEventsFromDB: Failed to clear the processed events from the db
2023-08-09 11:27:23.181486+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getDBRecordCount: Failed to fetch events count from DB
2023-08-09 11:27:23.183424+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getEventsFromDB: Failed to fetch events from DB
2023-08-09 11:27:24.189201+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: DELETE FROM events WHERE status = 3
2023-08-09 11:27:24.189403+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: clearProcessedEventsFromDB: Failed to clear the processed events from the db
2023-08-09 11:27:24.190032+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getDBRecordCount: Failed to fetch events count from DB
2023-08-09 11:27:24.191204+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getEventsFromDB: Failed to fetch events from DB
2023-08-09 11:27:25.194247+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: DELETE FROM events WHERE status = 3
2023-08-09 11:27:25.194658+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: clearProcessedEventsFromDB: Failed to clear the processed events from the db
2023-08-09 11:27:25.195520+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getDBRecordCount: Failed to fetch events count from DB
2023-08-09 11:27:25.196287+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getEventsFromDB: Failed to fetch events from DB
2023-08-09 11:27:26.203635+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: DELETE FROM events WHERE status = 3
2023-08-09 11:27:26.203911+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: clearProcessedEventsFromDB: Failed to clear the processed events from the db
2023-08-09 11:27:26.204682+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getDBRecordCount: Failed to fetch events count from DB
2023-08-09 11:27:26.207266+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getEventsFromDB: Failed to fetch events from DB
2023-08-09 11:27:27.213273+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: DELETE FROM events WHERE status = 3
2023-08-09 11:27:27.213484+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: clearProcessedEventsFromDB: Failed to clear the processed events from the db
2023-08-09 11:27:27.213973+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getDBRecordCount: Failed to fetch events count from DB
2023-08-09 11:27:27.214739+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getEventsFromDB: Failed to fetch events from DB
2023-08-09 11:27:28.222143+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: DELETE FROM events WHERE status = 3
2023-08-09 11:27:28.222428+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: clearProcessedEventsFromDB: Failed to clear the processed events from the db
2023-08-09 11:27:28.223077+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getDBRecordCount: Failed to fetch events count from DB
2023-08-09 11:27:28.224219+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getEventsFromDB: Failed to fetch events from DB
2023-08-09 11:27:29.233115+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: DELETE FROM events WHERE status = 3
2023-08-09 11:27:29.233310+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: clearProcessedEventsFromDB: Failed to clear the processed events from the db
2023-08-09 11:27:29.234290+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getDBRecordCount: Failed to fetch events count from DB
2023-08-09 11:27:29.235864+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getEventsFromDB: Failed to fetch events from DB
2023-08-09 11:27:30.242409+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: DELETE FROM events WHERE status = 3
2023-08-09 11:27:30.242728+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: clearProcessedEventsFromDB: Failed to clear the processed events from the db
2023-08-09 11:27:30.243439+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getDBRecordCount: Failed to fetch events count from DB
2023-08-09 11:27:30.244367+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getEventsFromDB: Failed to fetch events from DB
2023-08-09 11:27:31.247561+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: DELETE FROM events WHERE status = 3
2023-08-09 11:27:31.247837+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: clearProcessedEventsFromDB: Failed to clear the processed events from the db
2023-08-09 11:27:31.248495+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getDBRecordCount: Failed to fetch events count from DB
2023-08-09 11:27:31.249447+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getEventsFromDB: Failed to fetch events from DB
2023-08-09 11:27:32.255100+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: DELETE FROM events WHERE status = 3
2023-08-09 11:27:32.255397+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: clearProcessedEventsFromDB: Failed to clear the processed events from the db
2023-08-09 11:27:32.256190+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getDBRecordCount: Failed to fetch events count from DB
2023-08-09 11:27:32.257705+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getEventsFromDB: Failed to fetch events from DB
2023-08-09 11:27:33.265297+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: DELETE FROM events WHERE status = 3
2023-08-09 11:27:33.265585+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: clearProcessedEventsFromDB: Failed to clear the processed events from the db
2023-08-09 11:27:33.266282+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getDBRecordCount: Failed to fetch events count from DB
2023-08-09 11:27:33.267075+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getEventsFromDB: Failed to fetch events from DB
2023-08-09 11:27:34.271600+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: DELETE FROM events WHERE status = 3
2023-08-09 11:27:34.271884+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: clearProcessedEventsFromDB: Failed to clear the processed events from the db
2023-08-09 11:27:34.272559+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getDBRecordCount: Failed to fetch events count from DB
2023-08-09 11:27:34.273397+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getEventsFromDB: Failed to fetch events from DB
2023-08-09 11:27:35.279924+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: execSQL: SQLite Command Preparation Failed: DELETE FROM events WHERE status = 3
2023-08-09 11:27:35.280214+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: clearProcessedEventsFromDB: Failed to clear the processed events from the db
2023-08-09 11:27:35.280897+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getDBRecordCount: Failed to fetch events count from DB
2023-08-09 11:27:35.281970+0300 AppName[419:165187] RSStack:Error:RSDBPersistentManager: getEventsFromDB: Failed to fetch events from DB

@pallabmaiti
Copy link
Contributor

@saeedmalas, can you open the SQLite database by downloading the container?

@saeedmalas
Copy link
Author

@pallabmaiti
I downloaded the container and did not find anything related to RS and SQLite in it.

@pallabmaiti
Copy link
Contributor

@saeedmalas, did you upgrade the SDK & facing this issue, or are you facing this issue for the 1st time?

@saeedmalas
Copy link
Author

@pallabmaiti
I tried to update the version to 1.17.0, and I tried to try the v2 SDK -> 2.4.0, but the same errors appear.

@pallabmaiti
Copy link
Contributor

I mean to say, you integrate the SDK and tested on a real device for the 1st time and faced the issue or you were using the SDK and suddenly got his issue?

@saeedmalas
Copy link
Author

@pallabmaiti
Sorry, I was just trying on the emulator and everything worked properly, before publishing the version to the users, I tried the version on a real device, and found out that it didn't work because of the mentioned errors, I change the RS version, but the same error appeared.

@pallabmaiti
Copy link
Contributor

pallabmaiti commented Aug 10, 2023

Can you change this block of code to this and give us the executeCode you are getting?

- (void)createDB {
    int executeCode = sqlite3_open_v2([RSUtils getDBPath], &(self->_database), SQLITE_OPEN_CREATE | SQLITE_OPEN_READWRITE | SQLITE_OPEN_FULLMUTEX, nil);
    if (executeCode == SQLITE_OK) {
        // opened correctly
    }
}

@saeedmalas
Copy link
Author

I tried that and it was:
executeCode = 14

@pallabmaiti
Copy link
Contributor

Thanks.

@pallabmaiti
Copy link
Contributor

@saeedmalas did you able to solve the issue?

@saeedmalas
Copy link
Author

@pallabmaiti
I did not find a solution on my side, after I sent you executeCode, I was waiting for you to respond so that I could try a new version that includes a solution to the problem.

@pallabmaiti
Copy link
Contributor

@saeedmalas, we are working on this. Can you let us know which Rudder version worked/working for you?

@pallabmaiti pallabmaiti added the v1 label Sep 28, 2023
@saeedmalas
Copy link
Author

@pallabmaiti
Last time I tested this, version was 1.18 and it worked on real device iOS but not working on real device tvOS.

@saeedmalas
Copy link
Author

@pallabmaiti
Is there any update regarding this issue?
I just tried the latest version V1 and V2 but same error.

Note: This error appeared in the version 2.4.2:

API call with NULL database connection pointer
misuse at line 143292 of [554764a6e7]
nw_path_necp_check_for_updates Failed to copy updated result (22)

@desusai7
Copy link
Contributor

@saeedmalas, yes this issue is happening with both v1 and v2 of iOS SDKs.

We've debugged more into this and figured out that the issue is happening because SDK is unable to create a database itself in the first place. We are tracking this internally, but got delayed due to some other priorities at the moment.

We will let you know once we have an update on this.

CC @pallabmaiti

@saeedmalas
Copy link
Author

Thank you @desusai7 can you tell me which version you first tried on a real device and it worked without problems?
I think after trying this you decided to add that it is compatible with tvOS.

@desusai7 desusai7 linked a pull request Nov 16, 2023 that will close this issue
@desusai7
Copy link
Contributor

Hey @saeedmalas,

I'm sorry for the delay on this, we've come up with a fix for this issue and we've just tested it on a real tvOS device and it is working as expected, we will have it released soon after the code freeze and will keep you posted.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
BUG Something isn't working v1
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants