Migation from MariaDB to PostgreSQL error - SQLSTATE[23505]

BluePixel4k · November 3, 2024, 11:44pm

Support intro

Sorry to hear you’re facing problems

help.nextcloud.com is for home/non-enterprise users. If you’re running a business, paid support can be accessed via portal.nextcloud.com where we can ensure your business keeps running smoothly.

In order to help you as quickly as possible, before clicking Create Topic please provide as much of the below as you can. Feel free to use a pastebin service for logs, otherwise either indent short log examples with four spaces:

example

Or for longer, use three backticks above and below the code snippet:

longer
example
here

Some or all of the below information will be requested if it isn’t supplied; for fastest response please provide as much as you can

Nextcloud version: 30.0.1
Operating system and version: Ubuntu 20.04.6
Apache or nginx version: Apache/2.4.41
PHP version: 8.3

The issue you are facing:

While migrating my MariaDB database to PostgreSQL i get following errors:

 - oc_twofactor_admincodes
    0 [>---------------------------] < 1 sec
 - oc_twofactor_totp_secrets
 0/7 [>---------------------------]   0% < 1 sec/< 1 sec
In ExceptionConverter.php line 53:
                                                                                                                                                                               
  An exception occurred while executing a query: SQLSTATE[23505]: Unique violation: 7 ERROR:  duplicate key value violates unique constraint "oc_twofactor_totp_secrets_pkey"  
  DETAIL:  Key (id)=(1) already exists.                                                                                                                                        
                                                                                                                                                                               

In Exception.php line 28:
                                                                                                                                
  SQLSTATE[23505]: Unique violation: 7 ERROR:  duplicate key value violates unique constraint "oc_twofactor_totp_secrets_pkey"  
  DETAIL:  Key (id)=(1) already exists.                                                                                         
                                                                                                                                

In Statement.php line 130:
                                                                                                                                
  SQLSTATE[23505]: Unique violation: 7 ERROR:  duplicate key value violates unique constraint "oc_twofactor_totp_secrets_pkey"  
  DETAIL:  Key (id)=(1) already exists.

Is this the first time you’ve seen this error?: No, already other apps already reproduced these errors, but removing these apps helped. But it’s not possible to remove twofactor_totp (and I would not like to do it).

Steps to replicate it:

Edit these files: fix: added type to createConnectionParams, removed safeguard [restore db conversions] by Delogon · Pull Request #48666 · nextcloud/server · GitHub
Following this migration guide: all-in-one/migration.md at main · nextcloud/all-in-one · GitHub
Perform at the end: sudo -u www-data php -f /var/www/nextcloud/occ db:convert-type --all-apps --password “$PG_PASSWORD” pgsql “$PG_USER” 127.0.0.1 “$PG_DATABASE”

Is it possible to solve these errors?
Thanks in advance!

jtr · November 3, 2024, 11:58pm

Any chance you’re simply rerunning the conversion against the same destination db (without deleting/clearing it in-between)?

You mentioned already seeing similar problems with other apps.

If the destination db wasn’t cleared in between re-runs it may explain this.

You can use the --clear-schema option to accomplish this.

Otherwise I don’t see how you’d be getting these errors. The target database is empty (or should be).

The other possibility is a side effect of the PR you’re utilizing. It’s not merged yet because there are still side effects to be considered (not saying there are any, just it’s also a possibility).

Definitely make sure you have a good database backup snapshot in place.

BluePixel4k · November 4, 2024, 12:36am

I performed the comment again, but with –clear-schema and it’s gone through without an error.

Thank you!

According to the instructions, Nextcloud should now be accessible again, but unfortunately I only get a “403 Forbidden — openresty”.
Maybe I have to restart the server?

BluePixel4k · November 4, 2024, 12:50am

A reboot was not enough (was predictable).
Unfortunately, I still can’t access the NC website.

BluePixel4k · November 4, 2024, 10:44am

I see these kind of errors in the nextcloud.log file:

{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:01+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"CLI cron call has selected job OCA\\DAV\\BackgroundJob\\CalendarRetentionJob (id: 19514, arguments: null)","userAgent":"--","version":"30.0.1.2","data":{"app":"cron>
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:01+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT * FROM `*PREFIX*jobs` WHERE (`reserved_at` <= :dcValue1) AND (`last_checked` <= :dcValue2) AND (`time_sensitive` = :dcValue3)>
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:01+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"CLI cron call has selected job OCA\\Files_Trashbin\\BackgroundJob\\ExpireTrash (id: 3, arguments: null)","userAgent":"--","version":"30.0.1.2","data":{"app":"cron"}}
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:01+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"Starting job OCA\\Files_Trashbin\\BackgroundJob\\ExpireTrash (id: 3, arguments: null)","userAgent":"--","version":"30.0.1.2","data":{"app":"cron"}}
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:01+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"Calling OCP\\DB\\QueryBuilder\\IQueryBuilder::andX without parameters is deprecated and will throw soon.","userAgent":"--","version":"30.0.1.2","except>
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:01+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"Calling OCP\\DB\\QueryBuilder\\IQueryBuilder::orX without parameters is deprecated and will throw soon.","userAgent":"--","version":"30.0.1.2","excepti>
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:01+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"Calling OCP\\DB\\QueryBuilder\\IQueryBuilder::orX without parameters is deprecated and will throw soon.","userAgent":"--","version":"30.0.1.2","excepti>
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:01+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"Calling OCP\\DB\\QueryBuilder\\IQueryBuilder::orX without parameters is deprecated and will throw soon.","userAgent":"--","version":"30.0.1.2","excepti>
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:01+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"Calling OCP\\DB\\QueryBuilder\\IQueryBuilder::andX without parameters is deprecated and will throw soon.","userAgent":"--","version":"30.0.1.2","except>
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:01+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"Calling OCP\\DB\\QueryBuilder\\IQueryBuilder::orX without parameters is deprecated and will throw soon.","userAgent":"--","version":"30.0.1.2","excepti>
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:01+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"Calling OCP\\DB\\QueryBuilder\\IQueryBuilder::andX without parameters is deprecated and will throw soon.","userAgent":"--","version":"30.0.1.2","except>
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:01+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"Calling OCP\\DB\\QueryBuilder\\IQueryBuilder::orX without parameters is deprecated and will throw soon.","userAgent":"--","version":"30.0.1.2","excepti>
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:01+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"Calling OCP\\DB\\QueryBuilder\\IQueryBuilder::orX without parameters is deprecated and will throw soon.","userAgent":"--","version":"30.0.1.2","excepti>
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:01+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"Calling OCP\\DB\\QueryBuilder\\IQueryBuilder::orX without parameters is deprecated and will throw soon.","userAgent":"--","version":"30.0.1.2","excepti>
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:01+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"Calling OCP\\DB\\QueryBuilder\\IQueryBuilder::andX without parameters is deprecated and will throw soon.","userAgent":"--","version":"30.0.1.2","except>
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:01+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"Calling OCP\\DB\\QueryBuilder\\IQueryBuilder::orX without parameters is deprecated and will throw soon.","userAgent":"--","version":"30.0.1.2","excepti>
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:01+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT `storage_id`, `root_id`, `user_id`, `mount_point`, `mount_id`, `mount_provider_class` FROM `*PREFIX*mounts` `m` WHERE `user_i>
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"CLI cron call has selected job OCA\\WorkflowEngine\\BackgroundJobs\\Rotate (id: 15, arguments: null)","userAgent":"--","version":"30.0.1.2","data":{"app":"cron"}}
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT * FROM `*PREFIX*jobs` WHERE (`reserved_at` <= :dcValue1) AND (`last_checked` <= :dcValue2) AND (`time_sensitive` = :dcValue3)>
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"CLI cron call has selected job OCA\\Files_Sharing\\BackgroundJob\\FederatedSharesDiscoverJob (id: 20, arguments: null)","userAgent":"--","version":"30.0.1.2","data">
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT * FROM `*PREFIX*jobs` WHERE (`reserved_at` <= :dcValue1) AND (`last_checked` <= :dcValue2) AND (`time_sensitive` = :dcValue3)>
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"CLI cron call has selected job OC\\Log\\Rotate (id: 24, arguments: null)","userAgent":"--","version":"30.0.1.2","data":{"app":"cron"}}
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"Starting job OC\\Log\\Rotate (id: 24, arguments: null)","userAgent":"--","version":"30.0.1.2","data":{"app":"cron"}}
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"Finished job OC\\Log\\Rotate (id: 24, arguments: null) in 0 seconds","userAgent":"--","version":"30.0.1.2","data":{"app":"cron"}}
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT * FROM `*PREFIX*jobs` WHERE (`reserved_at` <= :dcValue1) AND (`last_checked` <= :dcValue2) AND (`time_sensitive` = :dcValue3)>
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"CLI cron call has selected job OC\\Preview\\BackgroundCleanupJob (id: 25, arguments: null)","userAgent":"--","version":"30.0.1.2","data":{"app":"cron"}}
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT * FROM `*PREFIX*jobs` WHERE (`reserved_at` <= :dcValue1) AND (`last_checked` <= :dcValue2) AND (`time_sensitive` = :dcValue3)>
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"CLI cron call has selected job OCA\\Support\\BackgroundJobs\\CheckSubscription (id: 8, arguments: null)","userAgent":"--","version":"30.0.1.2","data":{"app":"cron"}}
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT * FROM `*PREFIX*jobs` WHERE (`reserved_at` <= :dcValue1) AND (`last_checked` <= :dcValue2) AND (`time_sensitive` = :dcValue3)>
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"CLI cron call has selected job OCA\\Cospend\\Cron\\RepeatBills (id: 5065, arguments: null)","userAgent":"--","version":"30.0.1.2","data":{"app":"cron"}}
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT * FROM `*PREFIX*jobs` WHERE (`reserved_at` <= :dcValue1) AND (`last_checked` <= :dcValue2) AND (`time_sensitive` = :dcValue3)>
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"CLI cron call has selected job OCA\\Federation\\SyncJob (id: 21, arguments: null)","userAgent":"--","version":"30.0.1.2","data":{"app":"cron"}}
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT * FROM `*PREFIX*jobs` WHERE (`reserved_at` <= :dcValue1) AND (`last_checked` <= :dcValue2) AND (`time_sensitive` = :dcValue3)>
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"CLI cron call has selected job OC\\Core\\BackgroundJobs\\CleanupLoginFlowV2 (id: 68, arguments: null)","userAgent":"--","version":"30.0.1.2","data":{"app":"cron"}}
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT * FROM `*PREFIX*jobs` WHERE (`reserved_at` <= :dcValue1) AND (`last_checked` <= :dcValue2) AND (`time_sensitive` = :dcValue3)>
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"CLI cron call has selected job OCA\\Cospend\\Cron\\AutoExport (id: 5066, arguments: null)","userAgent":"--","version":"30.0.1.2","data":{"app":"cron"}}
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT * FROM `*PREFIX*jobs` WHERE (`reserved_at` <= :dcValue1) AND (`last_checked` <= :dcValue2) AND (`time_sensitive` = :dcValue3)>
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"CLI cron call has selected job OCA\\NextcloudAnnouncements\\Cron\\Crawler (id: 22, arguments: null)","userAgent":"--","version":"30.0.1.2","data":{"app":"cron"}}
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT * FROM `*PREFIX*jobs` WHERE (`reserved_at` <= :dcValue1) AND (`last_checked` <= :dcValue2) AND (`time_sensitive` = :dcValue3)>
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"CLI cron call has selected job OCA\\Activity\\BackgroundJob\\DigestMail (id: 7630, arguments: null)","userAgent":"--","version":"30.0.1.2","data":{"app":"cron"}}
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"Starting job OCA\\Activity\\BackgroundJob\\DigestMail (id: 7630, arguments: null)","userAgent":"--","version":"30.0.1.2","data":{"app":"cron"}}
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"Finished job OCA\\Activity\\BackgroundJob\\DigestMail (id: 7630, arguments: null) in 0 seconds","userAgent":"--","version":"30.0.1.2","data":{"app":"cron"}}
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT * FROM `*PREFIX*jobs` WHERE (`reserved_at` <= :dcValue1) AND (`last_checked` <= :dcValue2) AND (`time_sensitive` = :dcValue3)>
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"CLI cron call has selected job OCA\\DAV\\BackgroundJob\\RefreshWebcalJob (id: 32569, arguments: {\"principaluri\":\"principals\\/users\\/Stefan\",\"uri\":\"feiertag>
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT * FROM `*PREFIX*jobs` WHERE (`reserved_at` <= :dcValue1) AND (`last_checked` <= :dcValue2) AND (`time_sensitive` = :dcValue3)>
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"CLI cron call has selected job OC\\TextToImage\\RemoveOldTasksBackgroundJob (id: 40037, arguments: null)","userAgent":"--","version":"30.0.1.2","data":{"app":"cron">
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT * FROM `*PREFIX*jobs` WHERE (`reserved_at` <= :dcValue1) AND (`last_checked` <= :dcValue2) AND (`time_sensitive` = :dcValue3)>
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"CLI cron call has selected job OCA\\Files\\BackgroundJob\\DeleteOrphanedItems (id: 5, arguments: null)","userAgent":"--","version":"30.0.1.2","data":{"app":"cron"}}
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT * FROM `*PREFIX*jobs` WHERE (`reserved_at` <= :dcValue1) AND (`last_checked` <= :dcValue2) AND (`time_sensitive` = :dcValue3)>
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"CLI cron call has selected job OC\\TextProcessing\\RemoveOldTasksBackgroundJob (id: 37364, arguments: null)","userAgent":"--","version":"30.0.1.2","data":{"app":"cr>
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT * FROM `*PREFIX*jobs` WHERE (`reserved_at` <= :dcValue1) AND (`last_checked` <= :dcValue2) AND (`time_sensitive` = :dcValue3)>
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"CLI cron call has selected job OCA\\Memories\\Cron\\IndexJob (id: 162875, arguments: null)","userAgent":"--","version":"30.0.1.2","data":{"app":"cron"}}
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT * FROM `*PREFIX*jobs` WHERE (`reserved_at` <= :dcValue1) AND (`last_checked` <= :dcValue2) AND (`time_sensitive` = :dcValue3)>
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"CLI cron call has selected job OCA\\UserStatus\\BackgroundJob\\ClearOldStatusesBackgroundJob (id: 7636, arguments: null)","userAgent":"--","version":"30.0.1.2","dat>
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"Starting job OCA\\UserStatus\\BackgroundJob\\ClearOldStatusesBackgroundJob (id: 7636, arguments: null)","userAgent":"--","version":"30.0.1.2","data":{"app":"cron"}}
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"Finished job OCA\\UserStatus\\BackgroundJob\\ClearOldStatusesBackgroundJob (id: 7636, arguments: null) in 0 seconds","userAgent":"--","version":"30.0.1.2","data":{">
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT * FROM `*PREFIX*jobs` WHERE (`reserved_at` <= :dcValue1) AND (`last_checked` <= :dcValue2) AND (`time_sensitive` = :dcValue3)>
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"CLI cron call has selected job OCA\\Activity\\BackgroundJob\\RemoveFormerActivitySettings (id: 449343, arguments: null)","userAgent":"--","version":"30.0.1.2","data>
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT * FROM `*PREFIX*jobs` WHERE (`reserved_at` <= :dcValue1) AND (`last_checked` <= :dcValue2) AND (`time_sensitive` = :dcValue3)>
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"CLI cron call has selected job OCA\\UpdateNotification\\BackgroundJob\\ResetToken (id: 449377, arguments: null)","userAgent":"--","version":"30.0.1.2","data":{"app">
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT * FROM `*PREFIX*jobs` WHERE (`reserved_at` <= :dcValue1) AND (`last_checked` <= :dcValue2) AND (`time_sensitive` = :dcValue3)>
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"CLI cron call has selected job OCA\\UpdateNotification\\BackgroundJob\\UpdateAvailableNotifications (id: 449378, arguments: null)","userAgent":"--","version":"30.0.>
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT * FROM `*PREFIX*jobs` WHERE (`reserved_at` <= :dcValue1) AND (`last_checked` <= :dcValue2) AND (`time_sensitive` = :dcValue3)>
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"CLI cron call has selected job OCA\\Deck\\Cron\\CardDescriptionActivity (id: 249, arguments: null)","userAgent":"--","version":"30.0.1.2","data":{"app":"cron"}}
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"Starting job OCA\\Deck\\Cron\\CardDescriptionActivity (id: 249, arguments: null)","userAgent":"--","version":"30.0.1.2","data":{"app":"cron"}}
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"Finished job OCA\\Deck\\Cron\\CardDescriptionActivity (id: 249, arguments: null) in 0 seconds","userAgent":"--","version":"30.0.1.2","data":{"app":"cron"}}
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT * FROM `*PREFIX*jobs` WHERE (`reserved_at` <= :dcValue1) AND (`last_checked` <= :dcValue2) AND (`time_sensitive` = :dcValue3)>
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"CLI cron call has selected job OCA\\Text\\Cron\\Cleanup (id: 38975, arguments: null)","userAgent":"--","version":"30.0.1.2","data":{"app":"cron"}}
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT * FROM `*PREFIX*jobs` WHERE (`reserved_at` <= :dcValue1) AND (`last_checked` <= :dcValue2) AND (`time_sensitive` = :dcValue3)>
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"CLI cron call has selected job OCA\\Files\\BackgroundJob\\ScanFiles (id: 4, arguments: null)","userAgent":"--","version":"30.0.1.2","data":{"app":"cron"}}
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT * FROM `*PREFIX*jobs` WHERE (`reserved_at` <= :dcValue1) AND (`last_checked` <= :dcValue2) AND (`time_sensitive` = :dcValue3)>
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"CLI cron call has selected job OCA\\AppAPI\\BackgroundJob\\ExAppInitStatusCheckJob (id: 449694, arguments: null)","userAgent":"--","version":"30.0.1.2","data":{"app>
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"Starting job OCA\\AppAPI\\BackgroundJob\\ExAppInitStatusCheckJob (id: 449694, arguments: null)","userAgent":"--","version":"30.0.1.2","data":{"app":"cron"}}
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"Finished job OCA\\AppAPI\\BackgroundJob\\ExAppInitStatusCheckJob (id: 449694, arguments: null) in 0 seconds","userAgent":"--","version":"30.0.1.2","data":{"app":"cr>
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT * FROM `*PREFIX*jobs` WHERE (`reserved_at` <= :dcValue1) AND (`last_checked` <= :dcValue2) AND (`time_sensitive` = :dcValue3)>
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"CLI cron call has selected job OCA\\FilesReminders\\BackgroundJob\\ScheduledNotifications (id: 37366, arguments: null)","userAgent":"--","version":"30.0.1.2","data">
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"Starting job OCA\\FilesReminders\\BackgroundJob\\ScheduledNotifications (id: 37366, arguments: null)","userAgent":"--","version":"30.0.1.2","data":{"app":"cron"}}
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"Finished job OCA\\FilesReminders\\BackgroundJob\\ScheduledNotifications (id: 37366, arguments: null) in 0 seconds","userAgent":"--","version":"30.0.1.2","data":{"ap>
{"reqId":"rTYiNScNZQkpEgKFT6eJ","level":0,"time":"2024-11-04T10:15:02+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT * FROM `*PREFIX*jobs` WHERE (`reserved_at` <= :dcValue1) AND (`last_checked` <= :dcValue2) AND (`time_sensitive` = :dcValue3)>

Does anyone have an idea what causes the error and how to solve him?

Thanks in advance!

jtr · November 4, 2024, 1:34pm

That is coming from your web server. What do your web server error logs show? I don’t have any idea offhand why you’d see that after a db conversion. I doubt it’s entirely a coincidence, but almost looks unrelated…

I see these kind of errors in the nextcloud.log file:

None of those are errors really. You’re only seeing them because you have debug level logging on and they appear to all be coming from cron jobs. Are there any that show up w/o debug logging on when you try to access the instance? (Though I suspect the real clue will be in your openrest/nginx error log)

BluePixel4k · November 4, 2024, 2:35pm

Good hint. I looked into the logs from my Nginx Proxy Manager and found this error:

2024/11/04 14:13:19 [error] 281#281: *23370 access forbidden by rule, client: xxx.xxx.xxx.xxx, server: example.com, request: "GET /index.php>

Afterwards I found this issue: Setting access restriction results in 403 forbidden error · Issue #383 · NginxProxyManager/nginx-proxy-manager · GitHub
I found out, that this issue was caused by the access restriction in combination with HTTP/2 Support. I had to disable and enable it again.
But now it’s working!

I only enabled the access restriction for the NC merge, therefor the issue didn’t occur before.

Thanks a lot for your support!

system · November 12, 2024, 2:36pm

This topic was automatically closed 8 days after the last reply. New replies are no longer allowed.