Nextcloud mis à jour impossible

cocofil · March 13, 2025, 11:26am

What type of hardware are you using: Other(?)
What YunoHost version are you running: 12.0.11
What app is this about: nextcloud

Describe your issue

mysqldump: Error 1034: Index for table ‘oc_filecache’ is corrupt; try to repair it when dumping table oc_filecache at row: 175504

Share relevant logs or error messages

https://paste.yunohost.org/raw/zipunilone

rodinux · March 13, 2025, 1:35pm

You can try this and try just do a backup ??

yunohost app shell nextcloud
php occ db:add-missing-indices
php occ files:scan --all

cocofil · March 15, 2025, 12:59pm

voilà la réponse à php occ files:scan --all

Exception during scan: An exception occurred while executing a query: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
#0 /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1943): Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert()
#1 /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1885): Doctrine\DBAL\Connection->handleDriverException()
#2 /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1106): Doctrine\DBAL\Connection->convertExceptionDuringQuery()
#3 /var/www/nextcloud/lib/private/DB/Connection.php(333): Doctrine\DBAL\Connection->executeQuery()
#4 /var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(344): OC\DB\Connection->executeQuery()
#5 /var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(384): Doctrine\DBAL\Query\QueryBuilder->executeQuery()
#6 /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(280): Doctrine\DBAL\Query\QueryBuilder->execute()
#7 /var/www/nextcloud/lib/private/Files/Cache/Cache.php(241): OC\DB\QueryBuilder\QueryBuilder->execute()
#8 /var/www/nextcloud/lib/private/Files/Cache/Scanner.php(429): OC\Files\Cache\Cache->getFolderContentsById()
#9 /var/www/nextcloud/lib/private/Files/Cache/Scanner.php(495): OC\Files\Cache\Scanner->getExistingChildren()
#10 /var/www/nextcloud/lib/private/Files/Cache/Scanner.php(453): OC\Files\Cache\Scanner->handleChildren()
#11 /var/www/nextcloud/lib/private/Files/Cache/Scanner.php(458): OC\Files\Cache\Scanner->scanChildren()
#12 /var/www/nextcloud/lib/private/Files/Cache/Scanner.php(458): OC\Files\Cache\Scanner->scanChildren()
#13 /var/www/nextcloud/lib/private/Files/Cache/Scanner.php(458): OC\Files\Cache\Scanner->scanChildren()
#14 /var/www/nextcloud/lib/private/Files/Cache/Scanner.php(359): OC\Files\Cache\Scanner->scanChildren()
#15 /var/www/nextcloud/lib/private/Files/Utils/Scanner.php(278): OC\Files\Cache\Scanner->scan()
#16 /var/www/nextcloud/apps/files/lib/Command/Scan.php(180): OC\Files\Utils\Scanner->scan()
#17 /var/www/nextcloud/apps/files/lib/Command/Scan.php(241): OCA\Files\Command\Scan->scanFiles()
#18 /var/www/nextcloud/3rdparty/symfony/console/Command/Command.php(298): OCA\Files\Command\Scan->execute()
#19 /var/www/nextcloud/core/Command/Base.php(177): Symfony\Component\Console\Command\Command->run()
#20 /var/www/nextcloud/3rdparty/symfony/console/Application.php(1040): OC\Core\Command\Base->run()
#21 /var/www/nextcloud/3rdparty/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand()
#22 /var/www/nextcloud/3rdparty/symfony/console/Application.php(171): Symfony\Component\Console\Application->doRun()
#23 /var/www/nextcloud/lib/private/Console/Application.php(213): Symfony\Component\Console\Application->run()
#24 /var/www/nextcloud/console.php(102): OC\Console\Application->run()
#25 /var/www/nextcloud/occ(11): require_once('...')
#26 {main}

In ExceptionConverter.php line 101:
                                                                                         
  An exception occurred in the driver: SQLSTATE[HY000] [2002] No such file or directory  
                                                                                         

In Exception.php line 28:
                                                    
  SQLSTATE[HY000] [2002] No such file or directory  
                                                    

In Driver.php line 33:
                                                    
  SQLSTATE[HY000] [2002] No such file or directory  
                                                    

files:scan [--output [OUTPUT]] [-p|--path PATH] [--generate-metadata [GENERATE-METADATA]] [--all] [--unscanned] [--shallow] [--home-only] [--] [<user_id>...]

rodinux · March 16, 2025, 8:29pm

Zut, pas de connexion à la database…

Donc nextcloud ne fonctionne pas…
Tu ne nous dis pas vraiment ce qui c’est passé avant… Mise à jour ? de quelle version ? vers quelle version ? la version actuelle ?

cocofil · March 17, 2025, 9:31am

bonjour c’est depuis ma migration à debian 12 : je ne peux plus mettre à jour nextloud avec ce bug et je n’ai rien fait de spécial à part mettre à jour ma yunohost régulièrement et sans souci à part nextcloud

Applications

Nextcloud (nextcloud) de 29.0.8~ynh1 à 30.0.6~ynh3

OniriCorpe · March 17, 2025, 10:01am

Ça ressemble au problème de ce topic: Nextcloud connexion à la database - #2 by OniriCorpe

Je pense que le message du lien devrait résoudre le problème

cocofil · March 18, 2025, 9:38am

voilà la réponse à : il doit manquer qq chose ?
sudo -u nextcloud php8.3 --define apc.enable_cli=1 /var/www/nextcloud/occ

Nextcloud 29.0.8

Usage:
command [options] [arguments]

Options:
-h, --help Display help for the given command. When no command is given display help for the list command
-q, --quiet Do not output any message
-V, --version Display this application version
–ansi|–no-ansi Force (or disable --no-ansi) ANSI output
…

jarod5001 · March 18, 2025, 10:04am

github.com/YunoHost-Apps/nextcloud_ynh

doc/ADMIN.md?plain=1

3ff79026d


      
          ### Manually running Nextcloud commands
          
          You can run Nextcloud commands from the command line using:
          
          ```
          sudo -u __APP__ php__PHP_VERSION__ --define apc.enable_cli=1 __INSTALL_DIR__/occ ...
          ```
          
          Alternatively, you may open a 'Nextcloud shell' with `sudo yunohost app shell __APP__`, then run `php occ ...`

Alternatively, you may open a ‘Nextcloud shell’ with sudo yunohost app shell __APP__, then run php occ ...

cocofil · March 29, 2025, 5:54pm

désolé je n’y arrive pas
root@filco:~# sudo yunohost app shell nextcloud
nextcloud@filco:~$ sudo -u nextcloud php8.3 --define apc.enable_cli=1 /var/www/nextcloud/occ
nextcloud n’est pas autorisé à exécuter sudo sur filco.
nextcloud@filco:~$

cocofil · March 29, 2025, 5:56pm

et en root
root@filco:~# sudo -u nextcloud php8.3 --define apc.enable_cli=1 /var/www/nextcloud/occ
Nextcloud 29.0.8

Usage:
command [options] [arguments]

Options:
-h, --help Display help for the given command. When no command is given display help for the list command
-q, --quiet Do not output any message
-V, --version Display this application version
–ansi|–no-ansi Force (or disable --no-a …

jarod5001 · March 30, 2025, 1:00am

sudo -u nextcloud php8.3 --define apc.enable_cli=1 /var/www/nextcloud/occ db:add-missing-indices

github.com/nextcloud/server

Index for table 'oc_filecache' is corrupt

opened 02:57PM - 23 Dec 21 UTC

closed 01:08PM - 30 Dec 21 UTC

Bevito

bug 0. Needs triage

Hi, I just upgraded from Nextcloud 22.2.3 to Nextcloud 23.0.0 and the occ db:a…dd-missing-indices reports some errors and doesn't end properly. ### Steps to reproduce 1. Launch `sudo -u www-data php occ db:add-missing-indices` after updating from Nextcloud 22.2.3 to 23.0.0 ### Expected behaviour The database maintenance script should update everything without errors. ### Actual behaviour occ report errors : ``` Check indices of the share table. Check indices of the filecache table. Adding additional size index to the filecache table, this can take some time... Filecache table updated successfully. Adding additional path index to the filecache table, this can take some time... In ExceptionConverter.php line 114: An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1034 Index for table 'oc_filecache' is corrupt; try to repair it In Exception.php line 26: SQLSTATE[HY000]: General error: 1034 Index for table 'oc_filecache' is corrupt; try to repair it In Connection.php line 82: SQLSTATE[HY000]: General error: 1034 Index for table 'oc_filecache' is corrupt; try to repair it db:add-missing-indices ``` ### Server configuration **Operating system:** Debian 11.2 **Web server:** Apache 2.4 (2.4.51-1~deb11u1) **Database:** MariaDB (10.5.12-0+deb11u1) **PHP version:** 7.4 (7.4.25-1+deb11u1) **Nextcloud version:** (see Nextcloud admin page) Nextcloud Hub II (23.0.0) **Updated from an older Nextcloud/ownCloud or fresh install:** Updated from 22.2.3 **Where did you install Nextcloud from:** Auto updater **Signing status:** <details> <summary>Signing status</summary> ``` Login as admin user into your Nextcloud and access http://example.com/index.php/settings/integrity/failed paste the results here. ``` </details> No errors have been found. **List of activated apps:** <details> <summary>App list</summary> ``` If you have access to your command line run e.g.: sudo -u www-data php occ app:list from within your Nextcloud installation folder ``` </details> Enabled: - accessibility: 1.9.0 - activity: 2.15.0 - admin_audit: 1.13.0 - bruteforcesettings: 2.3.0 - circles: 23.0.0 - cloud_federation_api: 1.6.0 - comments: 1.13.0 - contactsinteraction: 1.4.0 - dashboard: 7.3.0 - dav: 1.21.0 - drawio: 1.0.2 - federatedfilesharing: 1.13.0 - federation: 1.13.0 - files: 1.18.0 - files_external: 1.15.0 - files_pdfviewer: 2.4.0 - files_rightclick: 1.2.0 - files_sharing: 1.15.0 - files_trashbin: 1.13.0 - files_versions: 1.16.0 - files_videoplayer: 1.12.0 - firstrunwizard: 2.12.0 - logreader: 2.8.0 - lookup_server_connector: 1.11.0 - nextcloud_announcements: 1.12.0 - notifications: 2.11.1 - oauth2: 1.11.0 - onlyoffice: 7.2.1 - password_policy: 1.13.0 - photos: 1.5.0 - privacy: 1.7.0 - provisioning_api: 1.13.0 - recommendations: 1.2.0 - serverinfo: 1.13.0 - settings: 1.5.0 - sharebymail: 1.13.0 - support: 1.6.0 - survey_client: 1.11.0 - systemtags: 1.13.0 - tasks: 0.14.2 - text: 3.4.0 - theming: 1.14.0 - twofactor_backupcodes: 1.12.0 - updatenotification: 1.13.0 - user_ldap: 1.13.0 - user_status: 1.3.1 - viewer: 1.7.0 - weather_status: 1.3.0 - workflowengine: 2.5.0 Disabled: - announcementcenter - encryption - groupfolders - quota_warning - **Nextcloud configuration:** <details> <summary>Config report</summary> ``` If you have access to your command line run e.g.: sudo -u www-data php occ config:list system from within your Nextcloud installation folder { "system": { "instanceid": "***REMOVED SENSITIVE VALUE***", "passwordsalt": "***REMOVED SENSITIVE VALUE***", "datadirectory": "***REMOVED SENSITIVE VALUE***", "dbtype": "mysql", "version": "23.0.0.10", "dbname": "***REMOVED SENSITIVE VALUE***", "dbhost": "***REMOVED SENSITIVE VALUE***", "dbtableprefix": "oc_", "dbuser": "***REMOVED SENSITIVE VALUE***", "dbpassword": "***REMOVED SENSITIVE VALUE***", "installed": true, "ldapIgnoreNamingRules": false, "maxZipInputSize": 1073741824, "allowZipDownload": true, "theme": "", "overwrite.cli.url": "https:\/\/cloud.iut-orsay.fr", "htaccess.RewriteBase": "\/", "maintenance": false, "default_language": "fr", "default_phone_region": "FR", "defaultapp": "files,dashboard", "log_type": "owncloud", "logfile": "\/var\/log\/nextcloud\/nextcloud.log", "loglevel": 0, "trusted_domains": [ "cloud.iut-orsay.fr" ], "mail_smtpmode": "smtp", "mail_smtpauthtype": "PLAIN", "mail_smtphost": "***REMOVED SENSITIVE VALUE***", "mail_smtpport": "25", "secret": "***REMOVED SENSITIVE VALUE***", "trashbin_retention_obligation": "15, auto", "memcache.local": "\\OC\\Memcache\\APCu", "memcache.distributed": "\\OC\\Memcache\\Redis", "memcache.locking": "\\OC\\Memcache\\Redis", "redis": { "host": "***REMOVED SENSITIVE VALUE***", "port": 6379, "dbindex": 0, "timeout": 0 }, "onlyoffice": { "jwt_secret": "REMOVED SENSITIVE VALUE", "jwt_header": "REMOVED SENSITIVE VALUE" }, "mail_from_address": "***REMOVED SENSITIVE VALUE***", "mail_domain": "***REMOVED SENSITIVE VALUE***", "ldapProviderFactory": "\\OCA\\User_LDAP\\LDAPProviderFactory", "ldapUserCleanupInterval": "60", "updater.release.channel": "stable", "mysql.utf8mb4": true, "mail_sendmailmode": "smtp", "app_install_overwrite": [ "printer" ], "updater.secret": "***REMOVED SENSITIVE VALUE***" } } ### Client configuration **Browser:** Mozilla Firefox 91.4.1esr **Operating system:** Linux Debian 11.2

mysql 
USE nextcloud;
ALTER TABLE `oc_filecache` ENGINE = InnoDB;

system · April 14, 2025, 1:01am

This topic was automatically closed 15 days after the last reply. New replies are no longer allowed.