Update-progress stuck

Support intro

Sorry to hear you’re facing problems :slightly_frowning_face:

help.nextcloud.com is for home/non-enterprise users. If you’re running a business, paid support can be accessed via portal.nextcloud.com where we can ensure your business keeps running smoothly.

In order to help you as quickly as possible, before clicking Create Topic please provide as much of the below as you can. Feel free to use a pastebin service for logs, otherwise either indent short log examples with four spaces:

example

Or for longer, use three backticks above and below the code snippet:

longer
example
here

Some or all of the below information will be requested if it isn’t supplied; for fastest response please provide as much as you can :heart:

Nextcloud version (eg, 20.0.5): 20.0.7.1
Operating system and version (eg, Ubuntu 20.04): Ubuntu
Apache or nginx version (eg, Apache 2.4.25): Apache
PHP version (eg, 7.4): PHP 7.3

The issue you are facing:
There was a php-Error so I can’t access WebUI etc.
So I run update-Process and was hoping the php-Error would go away. Now the installation of Update is stuck at:
Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ‘SELECT DISTINCT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME /*!50116 , c.update_rule, c.delete_rule / FROM information_schema.key_column_usage k /!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = ‘oc_notes_meta’ / WHERE k.table_name = ‘oc_notes_meta’ AND k.table_schema = ‘nextcloud’ /!50116 AND c.constraint_schema = ‘nextcloud’ */ AND k.REFERENCED_COLUMN_NAME is not NULL’:

SQLSTATE[HY000]: General error: 2006 MySQL server has gone away

After reading the whole Internet and finding some things about enabling the mysql 4-byte I followed the steps and the result was:


In AbstractMySQLDriver.php line 106:

An exception occurred while executing ‘SELECT id FROM oc_jobs WHERE (c lass = ?) AND (argument = ?) LIMIT 1’ with params [“OC\Preview\Backgro
undCleanupJob”, “null”]:

SQLSTATE[HY000]: General error: 2006 MySQL server has gone away

In PDOStatement.php line 129:

SQLSTATE[HY000]: General error: 2006 MySQL server has gone away

In PDOStatement.php line 127:

SQLSTATE[HY000]: General error: 2006 MySQL server has gone away

Is this the first time you’ve seen this error? (Y/N): Y

Steps to replicate it:

  1. run sudo -u www-data php /var/www/nextcloud/updater/updater.phar

The output of your Nextcloud log in Admin > Logging:

Can't access

The output of your config.php file in /path/to/nextcloud (make sure you remove any identifiable information!):

<?php
$CONFIG = array (
  'passwordsalt' => ':-)',
  'secret' => ':-)',
  'trusted_domains' => 
  array (
    0 => 'localhost',
    5 => 'nextcloudpi.local',
    7 => 'nextcloudpi',
    8 => 'nextcloudpi.lan',
    1 => ':-)',
    11 => ':-)',
    3 => ':-)',
    12 => ':-)',
  ),
  'datadirectory' => '/media/myCloudDrive/ncdata',
  'dbtype' => 'mysql',
  'version' => '20.0.5.2',
  'overwrite.cli.url' => ':-)',
  'dbname' => 'nextcloud',
  'dbhost' => 'localhost',
  'dbport' => '',
  'dbtableprefix' => 'oc_',
  'mysql.utf8mb4' => true,
  'dbuser' => 'ncadmin',
  'dbpassword' => ':-)',
  'installed' => true,
  'instanceid' => 'ochvelgsn5v1',
  'memcache.local' => '\\OC\\Memcache\\Redis',
  'memcache.locking' => '\\OC\\Memcache\\Redis',
  'redis' => 
  array (
    'host' => '/var/run/redis/redis.sock',
    'port' => 0,
    'timeout' => 0.0,
    'password' => ':-)',
  ),
  'tempdirectory' => '/media/myCloudDrive/ncdata/tmp',
  'mail_smtpmode' => 'sendmail',
  'mail_smtpauthtype' => 'LOGIN',
  'mail_from_address' => 'admin',
  'mail_domain' => 'ownyourbits.com',
  'preview_max_x' => '2048',
  'preview_max_y' => '2048',
  'jpeg_quality' => '60',
  'overwriteprotocol' => 'https',
  'maintenance' => false,
  'logfile' => '/media/myCloudDrive/ncdata/nextcloud.log',
  'loglevel' => '2',
  'log_type' => 'file',
  'htaccess.RewriteBase' => '/',
  'theme' => '',
);

The output of your Apache/nginx/system log in /var/log/____:

can't find it