topic Re: Receiving this error, I know the database is not read only... could this have something to do with daylight savings? in Qlik Replicate

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

fj40wdh — Mon, 06 Nov 2023 15:01:53 GMT

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)

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

fj40wdh — Mon, 06 Nov 2023 15:57:02 GMT

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)

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

Dana_Baldwin — Mon, 06 Nov 2023 16:26:26 GMT

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

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

fj40wdh — Mon, 06 Nov 2023 16:34:40 GMT

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.

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

fj40wdh — Mon, 06 Nov 2023 16:37:17 GMT

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

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

Dana_Baldwin — Mon, 06 Nov 2023 16:53:26 GMT

Hi @fj40wdh

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

Thanks,

Dana