Database failed inserting Meta objects for all xx notes. If this happens consistently, there is a problem with your database.
Open
Nobody has claimed this yet.
bug
need to reproduce
- Dominant language
- JavaScript
- Stars
- 738
- Forks
- 162
- Avg merge
- 6h 2m
- Merged PRs (30d)
- 35
Description
Steps to reproduce
- 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"}
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start with the GET /index.php/apps/notes/notes request and the Notes log message showing that Meta objects failed to insert for all 63 notes. Reproduce by opening Notes in the listed Nextcloud, PHP, and MySQL environment, then verify that opening Notes no longer logs the database failure and the expected message is absent.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- javascript, mysql, php
- Domain
- backend, databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100