Desktop client "could not set file record to local db"

Support intro

Sorry to hear you’re facing problems :slightly_frowning_face:

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 :heart:

Nextcloud version (eg, 20.0.5): 28.0.2.5
Operating system and version (eg, Ubuntu 20.04): Ubuntu 22.04
Apache or nginx version (eg, Apache 2.4.25): 2.4.57 (Debian) Latest official docker container
PHP version (eg, 7.4): 8.2.16 Latest official docker container

The issue you are facing:
desktop client doesn’t sync anymore, in the app I see a list of the files that needs to updated/downloaded with the message
"could not set file record to local db"
In the server log I see a line for every file with a 207 response

Is this the first time you’ve seen this error? (Y/N): Y

Steps to replicate it:

  1. Open Nextcliud desktop
  2. start the synchronization
  3. See the error

The output of your Nextcloud log in Admin > Logging:

NOTHING

The output of your config.php file in /path/to/nextcloud (make sure you remove any identifiable information!):

{
    "system": {
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "localhost",
            "MYDOMAIN.com"
        ],
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "overwrite.cli.url": "https:\/\/MYDOMAIN.com",
        "dbtype": "mysql",
        "version": "28.0.3.2",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbport": "",
        "dbtableprefix": "oc_",
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "installed": true,
        "theme": "",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpmode": "smtp",
        "mail_smtpauthtype": "LOGIN",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpauth": 1,
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpport": "587",
        "mail_smtpname": "***REMOVED SENSITIVE VALUE***",
        "mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpsecure": "tls",
        "maintenance": false,
        "log_type": "file",
        "logfile": "\/var\/log\/nextcloud.log",
        "loglevel": "2",
        "log_rotate_size": "104857600",
        "app_install_overwrite": [
            "gpxpod",
            "issuetemplate",
            "twofactor_admin"
        ],
        "encryption.legacy_format_support": false,
        "encryption.key_storage_migrated": false,
        "updater.release.channel": "stable",
        "default_phone_region": "IT",
        "trusted_proxies": "***REMOVED SENSITIVE VALUE***",
        "forwarded_for_headers": [
            "HTTP_X_FORWARDED_FOR"
        ],
        "apps_paths": [
            {
                "path": "\/var\/www\/html\/apps",
                "url": "\/apps",
                "writable": false
            },
            {
                "path": "\/var\/www\/html\/custom_apps",
                "url": "\/custom_apps",
                "writable": true
            }
        ],
        "htaccess.RewriteBase": "\/",
        "memcache.local": "\\OC\\Memcache\\APCu",
        "overwriteprotocol": "https",
        "mysql.utf8mb4": true,
        "twofactor_enforced": "true",
        "twofactor_enforced_groups": [],
        "twofactor_enforced_excluded_groups": [
            "No_2FA_TEMP"
        ],
        "memories.exiftool": "\/var\/www\/html\/custom_apps\/memories\/bin-ext\/exiftool-amd64-glibc",
        "memories.gis_type": 1,
        "memories.vod.path": "\/var\/www\/html\/custom_apps\/memories\/bin-ext\/go-vod-amd64"
    },
    "apps": { 
       ...............CONTINUE ON PASTEBIN

All output of occ config:list here.

The output of your Apache/nginx/system log in /var/log/____:

I can't find it...sorry!

Output errors in nextcloud.log in /var/www/ or as admin user in top right menu, filtering for errors. Use a pastebin service if necessary.

No logs in the admin GUI

I believe this indicates the client can’t write to its own database (stored in the device not the server-side one).

Anything changed recently on your client device? Was the client recently updated? Anything moved around on disk? Plenty of disk space on all partitions/drives?

There should be more clues in the client debug log, but it may require some digging since there will be a lot of info in there. I believe that message itself will be in the log, so searching for that may suggest where to look.

I have updated the client just today to see if hat could solve the preexisting problem, but nothing.
I have plenty of space, I haven’t moved/deleted anything.

I’ll search the log files, in the GUI there is nothing else.
Thanks!

I don’t know how, but the problem was connected to an S3 folder that had some problem. I’ve removed that and it all went back to normal.