Nextcloud mis à jour impossible

Support apps
,
1

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

2

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
3

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>...]
4

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 ?

1 Like
5

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
6

Ç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

7

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
…

8

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