The Basics
- Nextcloud Server version (e.g., 29.x.x):
30.0.2
- Operating system and version (e.g., Ubuntu 24.04):
- `Debian 12 (bookworm)’
- Web server and version (e.g, Apache 2.4.25):
apache2 2.4.62-1~deb12u2
- Reverse proxy and version _(e.g. nginx 1.27.2)
n/a
- PHP version (e.g, 8.3):
PHP 8.2.24 (cli) (built: Sep 27 2024 04:16:10) (NTS)
- Is this the first time you’ve seen this error? (Yes / No):
No
- When did this problem seem to first start?
Unknow, but it just got a lot worse.
- Installation method (e.g. AIO, NCP, Bare Metal/Archive, etc.)
Downloaded archive file, upgraded since.
- Are you using Cloudflare, mod_security, or similar? (Yes / No)
no
- Database:
sqlite3 3.40.1 2022-12-28 14:03:47
Summary of the issue you are facing:
I am trying to import an ics file with over a thousand events. This has worked in the past, with occasionally a few failures. Now, I get a lot more failures (several hundred), even with smaller files. I get the following sort of error in the nextcloud log:
DbalException
An exception occurred while executing a query: SQLSTATE[HY000]: General error: 5 database is locked
And errors like so:
root@hawk:/var/log/apache2# zgrep 00A121DC772.ics nextcloud-access.log*
nextcloud-access.log.1:192.168.10.1 - - [15/Nov/2024:17:06:06 -0700] "PUT /remote.php/dav/calendars/charles/the-libertarian-calendar-4/E7B916EF-BEC9-469D-9F69-900A121DC772.ics HTTP/1.1" 500 1266 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36"
root@hawk:/var/log/apache2#
Steps to replicate it (hint: details matter!):
Import a calendar with a lot of events in it.
Log entries
Nextcloud
Please provide the log entries from your Nextcloud log that are generated during the time of problem (via the Copy raw option from Administration settings->Logging screen or from your nextcloud.log located in your data directory). Feel free to use a pastebin/gist service if necessary.
{"reqId":"9YQnObo5RQmXF95gxNtD","level":3,"time":"2024-11-16T09:17:14-07:00","remoteAddr":"192.168.10.1","user":"--","app":"no app in context","method":"GET","url":"/index.php/apps/theming/favicon?v=f1f29b8a","message":"Could not decrypt or decode encrypted session data","userAgent":"Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36","version":"30.0.2.2","exception":{"Exception":"Exception","Message":"HMAC does not match.","Code":0,"Trace":[{"file":"/var/www/nextcloud/lib/private/Security/Crypto.php","line":98,"function":"decryptWithoutSecret","class":"OC\\Security\\Crypto","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/lib/private/Session/CryptoSessionData.php","line":70,"function":"decrypt","class":"OC\\Security\\Crypto","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/lib/private/Session/CryptoSessionData.php","line":47,"function":"initializeSession","class":"OC\\Session\\CryptoSessionData","type":"->"},{"file":"/var/www/nextcloud/lib/private/Session/CryptoWrapper.php","line":94,"function":"__construct","class":"OC\\Session\\CryptoSessionData","type":"->"},{"file":"/var/www/nextcloud/lib/base.php","line":402,"function":"wrapSession","class":"OC\\Session\\CryptoWrapper","type":"->"},{"file":"/var/www/nextcloud/lib/base.php","line":662,"function":"initSession","class":"OC","type":"::"},{"file":"/var/www/nextcloud/lib/base.php","line":1132,"function":"init","class":"OC","type":"::"},{"file":"/var/www/nextcloud/index.php","line":22,"args":["/var/www/nextcloud/lib/base.php"],"function":"require_once"}],"File":"/var/www/nextcloud/lib/private/Security/Crypto.php","Line":137,"message":"Could not decrypt or decode encrypted session data","exception":[],"CustomMessage":"Could not decrypt or decode encrypted session data"},"id":"67392c020d6e0"}
Web Browser
If the problem is related to the Web interface, open your browser inspector Console and Network tabs while refreshing (reloading) and reproducing the problem. Provide any relevant output/errors here that appear.
n/a
Web server / Reverse Proxy
The output of your Apache/nginx/system log in /var/log/____:
See above sample.
Configuration
Nextcloud
The output of occ config:list system or similar is best, but, if not possible, the contents of your config.php file from /path/to/nextcloud is fine (make sure to remove any identifiable information!):
root@hawk:/var/log/apache2# su - www-data -c 'php /var/www/nextcloud/occ config:list system'
Today is Setting Orange, the 28th of The Aftermath, 3190. Keep the Lasagna flying!
{
"system": {
"passwordsalt": "***REMOVED SENSITIVE VALUE***",
"secret": "***REMOVED SENSITIVE VALUE***",
"trusted_domains": [
"nextcloud",
"nextcloud.localdomain",
"localhost",
"hawk",
"hawk.localdomain",
"nextcloud.curleynet.mywire.org:17800"
],
"datadirectory": "***REMOVED SENSITIVE VALUE***",
"dbtype": "sqlite3",
"version": "30.0.2.2",
"overwrite.cli.url": "http:\/\/localhost",
"dbname": "***REMOVED SENSITIVE VALUE***",
"installed": true,
"instanceid": "***REMOVED SENSITIVE VALUE***",
"maintenance": false,
"default_phone_region": "US",
"theme": "",
"loglevel": 2,
"logtimezone": "America\/Denver",
"logfile": "\/var\/log\/nextcloud\/nextcloud.log",
"mail_domain": "***REMOVED SENSITIVE VALUE***",
"mail_from_address": "***REMOVED SENSITIVE VALUE***",
"mail_smtpmode": "smtp",
"mail_sendmailmode": "smtp",
"mail_smtpauth": 1,
"mail_smtpauthtype": "LOGIN",
"mail_smtphost": "***REMOVED SENSITIVE VALUE***",
"mail_smtpname": "***REMOVED SENSITIVE VALUE***",
"mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
"app_install_overwrite": [
"calendar"
],
"memcache.local": "\\OC\\Memcache\\APCu",
"trashbin_retention_obligation": "auto, 90",
"maintenance_window_start": 19,
"filelocking.enabled": true,
"memcache.locking": "\\OC\\Memcache\\Redis",
"redis": {
"host": "***REMOVED SENSITIVE VALUE***",
"port": 0,
"timeout": 0
}
}
}
root@hawk:/var/log/apache2#
Apps
The output of occ app:list (if possible).
root@hawk:/var/log/apache2# su - www-data -c 'php /var/www/nextcloud/occ app:list'
Today is Setting Orange, the 28th of The Aftermath, 3190. Or is it?
Enabled:
- activity: 3.0.0
- app_api: 4.0.0
- bruteforcesettings: 3.0.0
- calendar: 5.0.1
- circles: 30.0.0
- cloud_federation_api: 1.13.0
- comments: 1.20.1
- contacts: 6.1.1
- contactsinteraction: 1.11.0
- dashboard: 7.10.0
- dav: 1.31.1
- federatedfilesharing: 1.20.0
- federation: 1.20.0
- files: 2.2.0
- files_downloadlimit: 3.0.0
- files_pdfviewer: 3.0.0
- files_reminders: 1.3.0
- files_sharing: 1.22.0
- files_trashbin: 1.20.1
- files_versions: 1.23.0
- fileslibreofficeedit: 2.0.1
- firstrunwizard: 3.0.0
- gpxpod: 7.0.4
- logreader: 3.0.0
- lookup_server_connector: 1.18.0
- nextcloud_announcements: 2.0.0
- notes: 4.11.0
- notifications: 3.0.0
- oauth2: 1.18.1
- password_policy: 2.0.0
- privacy: 2.0.0
- provisioning_api: 1.20.0
- recommendations: 3.0.0
- related_resources: 1.5.0
- serverinfo: 2.0.0
- settings: 1.13.0
- sharebymail: 1.20.0
- support: 2.0.0
- systemtags: 1.20.0
- tasks: 0.16.1
- text: 4.1.0
- theming: 2.5.0
- twofactor_backupcodes: 1.19.0
- updatenotification: 1.20.0
- user_status: 1.10.0
- viewer: 3.0.0
- webhook_listeners: 1.1.0-dev
- workflowengine: 2.12.0
Disabled:
- admin_audit: 1.20.0
- encryption: 2.18.0
- files_external: 1.22.0
- photos: 3.0.2 (installed 2.0.1)
- survey_client: 2.0.0 (installed 2.0.0)
- suspicious_login: 8.0.0
- twofactor_nextcloud_notification: 4.0.0
- twofactor_totp: 12.0.0-dev
- user_ldap: 1.21.0
- weather_status: 1.10.0 (installed 1.2.0)
root@hawk:/var/log/apache2#
Tips for increasing the likelihood of a response
- Use the
preformatted textformatting option in the editor for all log entries and configuration output. - If screenshots are useful, feel free to include them.
- If possible, also include key error output in text form so it can be searched for.
- Try to edit log output only minimally (if at all) so that it can be ran through analyzers / formatters by those trying to help you.