Database failed inserting Meta objects for all xx notes. If this happens consistently, there is a problem with your database.

[vanyolai]

Steps to reproduce

1. Normal usage, see log

Expected behaviour

Message not shown

Actual behaviour

Message appears every time I'm opening Notes

Screenshots

If applicable, add screenshots to help explain your problem.

Server

Please complete the following information.

• Notes app version: 4.8.1
• Nextcloud version: 27.1.3
• OS: FreeBSD 13.1-RELEASE-p7 amd64
• Web server: Apache
• PHP version: 8.1.20
• Database: MySQL 10.5.20

Nextcloud configuration:

{
    "system": {
        "apps_paths": [
            {
                "path": "\/usr\/local\/www\/nextcloud\/apps",
                "url": "\/apps",
                "writable": true
            },
            {
                "path": "\/usr\/local\/www\/nextcloud\/apps-pkg",
                "url": "\/apps-pkg",
                "writable": false
            }
        ],
        "logfile": "\/var\/log\/nextcloud\/nextcloud.log",
        "memcache.local": "\\OC\\Memcache\\APCu",
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            ************************
        ],
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "dbtype": "mysql",
        "version": "27.1.3.2",
        "overwrite.cli.url": "********",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbport": "",
        "dbtableprefix": "oc_",
        "mysql.utf8mb4": true,
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "installed": true,
        "has_rebuilt_cache": true,
        "redis": {
            "host": "***REMOVED SENSITIVE VALUE***",
            "port": 0
        },
        "trusted_proxies": "***REMOVED SENSITIVE VALUE***",
        "maintenance": false,
        "memcache.locking": "\\OC\\Memcache\\Redis",
        "loglevel": 2,
        "theme": "",
        "default_phone_region": "HU",
        "mail_smtpmode": "smtp",
        "mail_smtpsecure": "ssl",
        "mail_sendmailmode": "smtp",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpport": "465",
        "mail_smtpauthtype": "LOGIN",
        "mail_smtpauth": 1,
        "mail_smtpname": "***REMOVED SENSITIVE VALUE***",
        "mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
        "updater.release.channel": "stable",
        "app_install_overwrite": [
            "carnet"
        ],
        "updater.secret": "***REMOVED SENSITIVE VALUE***"
    }
}

Client

Please complete the following information.

• Browser (incl. version): Brave v1.59.124
• OS: Debian12

Log files

{"reqId":"hWmIwL8esc12UqOMuo0Z","level":2,"time":"2023-10-29T12:03:10+00:00","remoteAddr":"******","user":"vanyo","app":"notes","method":"GET","url":"/index.php/apps/notes/notes","message":"Database failed inserting Meta objects for all 63 notes. If this happens consistently, there is a problem with your database.","userAgent":"Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/118.0.0.0 Safari/537.36","version":"27.1.3.2","data":{"app":"notes"},"id":"653e4c9f92d52"}

[joshtrichards]

#778 & #835