Nextcloud version (eg, 20.0.5): 27.0.0
Operating system and version (eg, Ubuntu 20.04): Hosted (manitu.de)
Apache or nginx version (eg, Apache 2.4.25): unknown
PHP version (eg, 7.4): 8.0
Nextcloud is running on hosted Webspace.
I changed the ownership of all files/folders in nextcloud-folder to my CLI-User, then updated Nextcloud via /usr/bin/php updater/updater.phar
25.0.1. → 25.0.8
25.0.8. → 26.0.3
26.0.3. → 27.0.0
I ran the occ upgrade
and - after finished - deactivated maintenance mode.
Now I can’t access my nexcloud any longer.
Unfortunately I can’t find any hint for the error Database threw an unique constraint on inserting a new mimetype, but couldn't return the ID for this very mimetype
- would be great if anyone would have an idea.
The output of your Nextcloud log in Admin > Logging:
not accessable
The output of your config.php file in /path/to/nextcloud
(make sure you remove any identifiable information!):
<?php
$CONFIG = array (
'instanceid' => 'XXXXXXXXXXXXXXXXXXXXXXXX',
'passwordsalt' => 'XXXXXXXXXXXXXXXXXXXXXXXX',
'secret' => 'XXXXXXXXXXXXXXXXXXXXXXXX',
'updater.secret' => 'XXXXXXXXXXXXXXXXXXXXXXXX',
'trusted_domains' =>
array (
0 => 'XXXXXXXXXXXXXXXXXXXXXXXX',
1 => 'XXXXXXXXXXXXXXXXXXXXXXXX',
2 => 'XXXXXXXXXXXXXXXXXXXXXXXX',
3 => 'XXXXXXXXXXXXXXXXXXXXXXXX',
),
'datadirectory' => '/home/sites/site1000xxxxx/web/nextcloud/data',
'overwrite.cli.url' => 'https://XXXXXXXXXXXXXXXXXXXXXXXX',
'default_language' => 'de',
'default_locale' => 'de',
'default_phone_region' => 'de',
'dbtype' => 'mysql',
'version' => '27.0.0.8',
'dbname' => 'dbXXXXXXX',
'dbhost' => 'dbserver',
'dbport' => '',
'dbtableprefix' => 'nc_',
'dbuser' => 'USER',
'dbpassword' => 'PASSWORD',
'mysql.utf8mb4' => true,
'installed' => true,
'mail_from_address' => 'XXXXXXXXX',
'mail_smtpmode' => 'smtp',
'mail_smtpauthtype' => 'LOGIN',
'mail_domain' => 'XXXXXXXXX',
'skeletondirectory' => '',
'maintenance' => false,
'theme' => '',
'loglevel' => 2,
'updater.release.channel' => 'stable',
'mail_smtpsecure' => 'ssl',
'mail_sendmailmode' => 'smtp',
'mail_smtphost' => 'XXXXXXXXX',
'mail_smtpport' => 'XXXXXXXXX',
'mail_smtpauth' => 1,
'mail_smtpname' => 'XXXXXXXXX@XXXXXXXXX',
'mail_smtppassword' => 'XXXXXXXXX',
'encryption.legacy_format_support' => false,
'encryption.key_storage_migrated' => false,
'app_install_overwrite' =>
array (
0 => 'occweb',
),
);
The output of your Apache/nginx/system log in /var/log/____
:
not available.
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.
USER@SERVER /home/sites/site1000xxxxx/web/nextcloud/data $ tail nextcloud.log
{"reqId":"ZJYDlmwy-oMgc-ShbnV8kBBBBGk","level":3,"time":"2023-06-23T20:41:58+00:00","remoteAddr":"X.X.X.X","user":"--","app":"index","method":"GET","url":"/index.php/login","message":"Database threw an unique constraint on inserting a new mimetype, but couldn't return the ID for this very mimetype","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36 Edg/114.0.1823.58","version":"27.0.0.8","exception":{"Exception":"Exception","Message":"Database threw an unique constraint on inserting a new mimetype, but couldn't return the ID for this very mimetype","Code":0,"Trace":[{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/public/AppFramework/Db/TTransactional.php","line":63,"function":"OC\\Files\\Type\\{closure}","class":"OC\\Files\\Type\\Loader","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Files/Type/Loader.php","line":144,"function":"atomic","class":"OC\\Files\\Type\\Loader","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Files/Type/Loader.php","line":88,"function":"store","class":"OC\\Files\\Type\\Loader","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Files/Cache/Cache.php","line":455,"function":"getId","class":"OC\\Files\\Type\\Loader","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Files/Cache/Cache.php","line":303,"function":"normalizeData","class":"OC\\Files\\Cache\\Cache","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Files/Cache/Scanner.php","line":300,"function":"insert","class":"OC\\Files\\Cache\\Cache","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Files/Cache/Scanner.php","line":233,"function":"addToCache","class":"OC\\Files\\Cache\\Scanner","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Files/Cache/LocalRootScanner.php","line":31,"function":"scanFile","class":"OC\\Files\\Cache\\Scanner","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Files/Cache/Scanner.php","line":345,"function":"scanFile","class":"OC\\Files\\Cache\\LocalRootScanner","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Files/Cache/LocalRootScanner.php","line":39,"function":"scan","class":"OC\\Files\\Cache\\Scanner","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Files/View.php","line":1317,"function":"scan","class":"OC\\Files\\Cache\\LocalRootScanner","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Files/View.php","line":1356,"function":"getCacheEntry","class":"OC\\Files\\View","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Files/Node/Root.php","line":205,"function":"getFileInfo","class":"OC\\Files\\View","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Files/Node/Folder.php","line":139,"function":"get","class":"OC\\Files\\Node\\Root","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Files/SimpleFS/SimpleFolder.php","line":75,"function":"get","class":"OC\\Files\\Node\\Folder","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Template/JSCombiner.php","line":187,"function":"getFile","class":"OC\\Files\\SimpleFS\\SimpleFolder","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Template/JSCombiner.php","line":96,"function":"cache","class":"OC\\Template\\JSCombiner","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Template/JSResourceLocator.php","line":145,"function":"process","class":"OC\\Template\\JSCombiner","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Template/JSResourceLocator.php","line":75,"function":"cacheAndAppendCombineJsonIfExist","class":"OC\\Template\\JSResourceLocator","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Template/ResourceLocator.php","line":73,"function":"doFind","class":"OC\\Template\\JSResourceLocator","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/TemplateLayout.php","line":377,"function":"find","class":"OC\\Template\\ResourceLocator","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/TemplateLayout.php","line":222,"function":"findJavascriptFiles","class":"OC\\TemplateLayout","type":"::"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/legacy/OC_Template.php","line":182,"function":"__construct","class":"OC\\TemplateLayout","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/public/AppFramework/Http/TemplateResponse.php","line":213,"function":"fetchPage","class":"OC_Template","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":182,"function":"render","class":"OCP\\AppFramework\\Http\\TemplateResponse","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/AppFramework/App.php","line":183,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Route/Router.php","line":315,"function":"main","class":"OC\\AppFramework\\App","type":"::"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/base.php","line":1064,"function":"match","class":"OC\\Route\\Router","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/index.php","line":36,"function":"handleRequest","class":"OC","type":"::"}],"File":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Files/Type/Loader.php","Line":142,"CustomMessage":"--"}}
{"reqId":"ZJYDlmwy-oMgc-ShbnV8kBBBBGk","level":3,"time":"2023-06-23T20:41:58+00:00","remoteAddr":"X.X.X.X","user":"--","app":"core","method":"GET","url":"/index.php/login","message":"Database threw an unique constraint on inserting a new mimetype, but couldn't return the ID for this very mimetype","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36 Edg/114.0.1823.58","version":"27.0.0.8","exception":{"Exception":"Exception","Message":"Database threw an unique constraint on inserting a new mimetype, but couldn't return the ID for this very mimetype","Code":0,"Trace":[{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/public/AppFramework/Db/TTransactional.php","line":63,"function":"OC\\Files\\Type\\{closure}","class":"OC\\Files\\Type\\Loader","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Files/Type/Loader.php","line":144,"function":"atomic","class":"OC\\Files\\Type\\Loader","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Files/Type/Loader.php","line":88,"function":"store","class":"OC\\Files\\Type\\Loader","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Files/Cache/Cache.php","line":455,"function":"getId","class":"OC\\Files\\Type\\Loader","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Files/Cache/Cache.php","line":303,"function":"normalizeData","class":"OC\\Files\\Cache\\Cache","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Files/Cache/Scanner.php","line":300,"function":"insert","class":"OC\\Files\\Cache\\Cache","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Files/Cache/Scanner.php","line":233,"function":"addToCache","class":"OC\\Files\\Cache\\Scanner","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Files/Cache/LocalRootScanner.php","line":31,"function":"scanFile","class":"OC\\Files\\Cache\\Scanner","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Files/Cache/Scanner.php","line":345,"function":"scanFile","class":"OC\\Files\\Cache\\LocalRootScanner","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Files/Cache/LocalRootScanner.php","line":39,"function":"scan","class":"OC\\Files\\Cache\\Scanner","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Files/View.php","line":1317,"function":"scan","class":"OC\\Files\\Cache\\LocalRootScanner","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Files/View.php","line":1356,"function":"getCacheEntry","class":"OC\\Files\\View","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Files/Node/Root.php","line":205,"function":"getFileInfo","class":"OC\\Files\\View","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Files/Node/Folder.php","line":139,"function":"get","class":"OC\\Files\\Node\\Root","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Files/SimpleFS/SimpleFolder.php","line":75,"function":"get","class":"OC\\Files\\Node\\Folder","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Template/JSCombiner.php","line":187,"function":"getFile","class":"OC\\Files\\SimpleFS\\SimpleFolder","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Template/JSCombiner.php","line":96,"function":"cache","class":"OC\\Template\\JSCombiner","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Template/JSResourceLocator.php","line":145,"function":"process","class":"OC\\Template\\JSCombiner","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Template/JSResourceLocator.php","line":75,"function":"cacheAndAppendCombineJsonIfExist","class":"OC\\Template\\JSResourceLocator","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Template/ResourceLocator.php","line":73,"function":"doFind","class":"OC\\Template\\JSResourceLocator","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/TemplateLayout.php","line":377,"function":"find","class":"OC\\Template\\ResourceLocator","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/TemplateLayout.php","line":222,"function":"findJavascriptFiles","class":"OC\\TemplateLayout","type":"::"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/legacy/OC_Template.php","line":182,"function":"__construct","class":"OC\\TemplateLayout","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/public/AppFramework/Http/TemplateResponse.php","line":213,"function":"fetchPage","class":"OC_Template","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":182,"function":"render","class":"OCP\\AppFramework\\Http\\TemplateResponse","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/AppFramework/App.php","line":183,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Route/Router.php","line":315,"function":"main","class":"OC\\AppFramework\\App","type":"::"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/base.php","line":1064,"function":"match","class":"OC\\Route\\Router","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/index.php","line":36,"function":"handleRequest","class":"OC","type":"::"}],"File":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Files/Type/Loader.php","Line":142,"CustomMessage":"--"}}
{"reqId":"ZJYDlmwy-oMgc-ShbnV8kBBBBGk","level":3,"time":"2023-06-23T20:41:58+00:00","remoteAddr":"X.X.X.X","user":"--","app":"core","method":"GET","url":"/index.php/login","message":"Database threw an unique constraint on inserting a new mimetype, but couldn't return the ID for this very mimetype","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36 Edg/114.0.1823.58","version":"27.0.0.8","exception":{"Exception":"Exception","Message":"Database threw an unique constraint on inserting a new mimetype, but couldn't return the ID for this very mimetype","Code":0,"Trace":[{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/public/AppFramework/Db/TTransactional.php","line":63,"function":"OC\\Files\\Type\\{closure}","class":"OC\\Files\\Type\\Loader","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Files/Type/Loader.php","line":144,"function":"atomic","class":"OC\\Files\\Type\\Loader","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Files/Type/Loader.php","line":88,"function":"store","class":"OC\\Files\\Type\\Loader","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Files/Cache/Cache.php","line":455,"function":"getId","class":"OC\\Files\\Type\\Loader","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Files/Cache/Cache.php","line":303,"function":"normalizeData","class":"OC\\Files\\Cache\\Cache","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Files/Cache/Scanner.php","line":300,"function":"insert","class":"OC\\Files\\Cache\\Cache","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Files/Cache/Scanner.php","line":233,"function":"addToCache","class":"OC\\Files\\Cache\\Scanner","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Files/Cache/LocalRootScanner.php","line":31,"function":"scanFile","class":"OC\\Files\\Cache\\Scanner","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Files/Cache/Scanner.php","line":345,"function":"scanFile","class":"OC\\Files\\Cache\\LocalRootScanner","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Files/Cache/LocalRootScanner.php","line":39,"function":"scan","class":"OC\\Files\\Cache\\Scanner","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Files/View.php","line":1317,"function":"scan","class":"OC\\Files\\Cache\\LocalRootScanner","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Files/View.php","line":1356,"function":"getCacheEntry","class":"OC\\Files\\View","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Files/Node/Root.php","line":205,"function":"getFileInfo","class":"OC\\Files\\View","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Files/Node/Folder.php","line":139,"function":"get","class":"OC\\Files\\Node\\Root","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Files/SimpleFS/SimpleFolder.php","line":75,"function":"get","class":"OC\\Files\\Node\\Folder","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Template/JSCombiner.php","line":187,"function":"getFile","class":"OC\\Files\\SimpleFS\\SimpleFolder","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Template/JSCombiner.php","line":96,"function":"cache","class":"OC\\Template\\JSCombiner","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Template/JSResourceLocator.php","line":145,"function":"process","class":"OC\\Template\\JSCombiner","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Template/JSResourceLocator.php","line":75,"function":"cacheAndAppendCombineJsonIfExist","class":"OC\\Template\\JSResourceLocator","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Template/ResourceLocator.php","line":73,"function":"doFind","class":"OC\\Template\\JSResourceLocator","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/TemplateLayout.php","line":377,"function":"find","class":"OC\\Template\\ResourceLocator","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/TemplateLayout.php","line":222,"function":"findJavascriptFiles","class":"OC\\TemplateLayout","type":"::"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/legacy/OC_Template.php","line":182,"function":"__construct","class":"OC\\TemplateLayout","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Template/Base.php","line":132,"function":"fetchPage","class":"OC_Template","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/legacy/OC_Template.php","line":331,"function":"printPage","class":"OC\\Template\\Base","type":"->"},{"file":"/home/sites/site1000xxxxx/web/nextcloud/index.php","line":74,"function":"printExceptionErrorPage","class":"OC_Template","type":"::"}],"File":"/home/sites/site1000xxxxx/web/nextcloud/lib/private/Files/Type/Loader.php","Line":142,"CustomMessage":"--"}}