Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
fj40wdh
Contributor III
Contributor III

Receiving this error, I know the database is not read only... could this have something to do with daylight savings?

02056419: 2023-11-06T09:58:59 [DATA_STRUCTURE ]E: SQLite general error. Code <8>, Message <attempt to write a readonly database>. [1000505] (at_sqlite.c:525)
02056419: 2023-11-06T09:58:59 [INFRASTRUCTURE ]E: SQL statement at index #0 failed [1000505] (ar_sqlite.c:87)
02056419: 2023-11-06T09:58:59 [TASK_MANAGER ]E: Failed to initialize deferred_target_apply_operations.sqlite [1000505] (replicationtask.c:1175)

5 Replies
fj40wdh
Contributor III
Contributor III
Author

Looks like some of the .sqlite files under the tasks folder have changed owner, how could that happen. What is the proper owner?

change the owner and now get 

02058386: 2023-11-06T10:30:02:89973 [DATA_STRUCTURE ]T: sqlite_do_immediate: rc == SQLITE_DONE failed (at_sqlite.c:990)
02058386: 2023-11-06T10:30:02:89980 [DATA_STRUCTURE ]T: SQLite general error. Code <1>, Message <cannot start a transaction within a transaction>. [1000505] (at_sqlite.c:990)
02058386: 2023-11-06T10:30:02:89986 [DATA_STRUCTURE ]V: sqlite_do_immediate:990: Failed (at_sqlite.c:994)
02058386: 2023-11-06T10:30:02:107131 [TASK_MANAGER ]T: Join Notification Thread (replicationtask.c:4412)

Dana_Baldwin
Support
Support

Hi @fj40wdh 

This should not be related to the recent daylight savings time change.

All files should be owned by the user the Replicate service runs as. File ownership change is not expected or a feature of Replicate.

Are you on Windows or Linux?

Is this a new installation/implementation?

Is any other process locking any Qlik files, such as anti-virus? Please exclude the location of the binaries and the data folder & subfolders.

Please ensure there is adequate free disk space where the binaries and data folders reside on the server.

Thanks,

Dana

fj40wdh
Contributor III
Contributor III
Author

Created a new task, and it fails before it even creates a log file. The  tasks folder is owned by the replicate user, but the folder for the individual task is owned by the source database user, strange.  All the tasks for this instance are down. 

This instance ran fine for several weeks then this morning it went down, with no changes to the instance.

fj40wdh
Contributor III
Contributor III
Author

no sorry not DB user , but another used for Kerberos connection to Kafka.  Not the current task I'm working on 

Dana_Baldwin
Support
Support

Hi @fj40wdh 

Please open a support case and attach a diagnostics package so we can look into this further.

Thanks,

Dana