Unknown column 'lazy' in 'field list' when upgrading from 28.0.1.1 to 29.0.3.4

ad8mustanggt · June 26, 2024, 8:43pm

Support intro

Sorry to hear you’re facing problems

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

Nextcloud version (eg, 29.0.5): 28.0.1.1, upgrading to 29.0.3.4
Operating system and version (eg, Ubuntu 29.04): "latest" Docker Image
Apache or nginx version (eg, Apache 2.4.25): "latest" Docker Image
PHP version (eg, 8.3): "latest" Docker Image

The issue you are facing:

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

Steps to replicate it:

run occ upgrade

The output of your Nextcloud log in Admin > Logging:

I can't access the WEB UI (server in maintenance mode), this is from the console:

occ -vvvvvvvv upgrade
Nextcloud or one of the apps require upgrade - only a limited number of commands are available
You may use your browser or the occ upgrade command to do the upgrade
2024-06-26T20:11:01+00:00 Setting log level to debug
2024-06-26T20:11:01+00:00 
2024-06-26T20:11:01+00:00 In DbalException.php line 71:
2024-06-26T20:11:01+00:00                                                                                                                                 
2024-06-26T20:11:01+00:00   [OC\DB\Exceptions\DbalException (1054)]                                                                                       
2024-06-26T20:11:01+00:00   An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lazy' in 'field list'  
2024-06-26T20:11:01+00:00                                                                                                                                 
2024-06-26T20:11:01+00:00 
2024-06-26T20:11:01+00:00 Exception trace:
2024-06-26T20:11:01+00:00   at /app/www/public/lib/private/DB/Exceptions/DbalException.php:71
2024-06-26T20:11:01+00:00  OC\DB\Exceptions\DbalException::wrap() at /app/www/public/lib/private/DB/QueryBuilder/QueryBuilder.php:328
2024-06-26T20:11:01+00:00  OC\DB\QueryBuilder\QueryBuilder->executeStatement() at /app/www/public/lib/private/AppConfig.php:783
2024-06-26T20:11:01+00:00  OC\AppConfig->setTypedValue() at /app/www/public/lib/private/AppConfig.php:1360
2024-06-26T20:11:01+00:00  OC\AppConfig->setValue() at /app/www/public/lib/private/AllConfig.php:208
2024-06-26T20:11:01+00:00  OC\AllConfig->setAppValue() at /app/www/public/lib/private/Updater.php:126
2024-06-26T20:11:01+00:00  OC\Updater->upgrade() at /app/www/public/core/Command/Upgrade.php:216
2024-06-26T20:11:01+00:00  OC\Core\Command\Upgrade->execute() at /app/www/public/3rdparty/symfony/console/Command/Command.php:298
2024-06-26T20:11:01+00:00  Symfony\Component\Console\Command\Command->run() at /app/www/public/3rdparty/symfony/console/Application.php:1040
2024-06-26T20:11:01+00:00  Symfony\Component\Console\Application->doRunCommand() at /app/www/public/3rdparty/symfony/console/Application.php:301
2024-06-26T20:11:01+00:00  Symfony\Component\Console\Application->doRun() at /app/www/public/3rdparty/symfony/console/Application.php:171
2024-06-26T20:11:01+00:00  Symfony\Component\Console\Application->run() at /app/www/public/lib/private/Console/Application.php:213
2024-06-26T20:11:01+00:00  OC\Console\Application->run() at /app/www/public/console.php:102
2024-06-26T20:11:01+00:00  require_once() at /app/www/public/occ:11
2024-06-26T20:11:01+00:00 
2024-06-26T20:11:01+00:00 In ExceptionConverter.php line 67:
2024-06-26T20:11:01+00:00                                                                                                                                 
2024-06-26T20:11:01+00:00   [Doctrine\DBAL\Exception\InvalidFieldNameException (1054)]                                                                    
2024-06-26T20:11:01+00:00   An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lazy' in 'field list'  
2024-06-26T20:11:01+00:00                                                                                                                                 
2024-06-26T20:11:01+00:00 
2024-06-26T20:11:01+00:00 Exception trace:
2024-06-26T20:11:01+00:00   at /app/www/public/3rdparty/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:67
2024-06-26T20:11:01+00:00  Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert() at /app/www/public/3rdparty/doctrine/dbal/src/Connection.php:1943
2024-06-26T20:11:01+00:00  Doctrine\DBAL\Connection->handleDriverException() at /app/www/public/3rdparty/doctrine/dbal/src/Connection.php:1885
2024-06-26T20:11:01+00:00  Doctrine\DBAL\Connection->convertExceptionDuringQuery() at /app/www/public/3rdparty/doctrine/dbal/src/Connection.php:1213
2024-06-26T20:11:01+00:00  Doctrine\DBAL\Connection->executeStatement() at /app/www/public/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php:292
2024-06-26T20:11:01+00:00  Doctrine\DBAL\Connections\PrimaryReadReplicaConnection->executeStatement() at /app/www/public/lib/private/DB/Connection.php:373
2024-06-26T20:11:01+00:00  OC\DB\Connection->executeStatement() at /app/www/public/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php:393
2024-06-26T20:11:01+00:00  Doctrine\DBAL\Query\QueryBuilder->execute() at /app/www/public/lib/private/DB/QueryBuilder/QueryBuilder.php:280
2024-06-26T20:11:01+00:00  OC\DB\QueryBuilder\QueryBuilder->execute() at /app/www/public/lib/private/DB/QueryBuilder/QueryBuilder.php:326
2024-06-26T20:11:01+00:00  OC\DB\QueryBuilder\QueryBuilder->executeStatement() at /app/www/public/lib/private/AppConfig.php:783
2024-06-26T20:11:01+00:00  OC\AppConfig->setTypedValue() at /app/www/public/lib/private/AppConfig.php:1360
2024-06-26T20:11:01+00:00  OC\AppConfig->setValue() at /app/www/public/lib/private/AllConfig.php:208
2024-06-26T20:11:01+00:00  OC\AllConfig->setAppValue() at /app/www/public/lib/private/Updater.php:126
2024-06-26T20:11:01+00:00  OC\Updater->upgrade() at /app/www/public/core/Command/Upgrade.php:216
2024-06-26T20:11:01+00:00  OC\Core\Command\Upgrade->execute() at /app/www/public/3rdparty/symfony/console/Command/Command.php:298
2024-06-26T20:11:01+00:00  Symfony\Component\Console\Command\Command->run() at /app/www/public/3rdparty/symfony/console/Application.php:1040
2024-06-26T20:11:01+00:00  Symfony\Component\Console\Application->doRunCommand() at /app/www/public/3rdparty/symfony/console/Application.php:301
2024-06-26T20:11:01+00:00  Symfony\Component\Console\Application->doRun() at /app/www/public/3rdparty/symfony/console/Application.php:171
2024-06-26T20:11:01+00:00  Symfony\Component\Console\Application->run() at /app/www/public/lib/private/Console/Application.php:213
2024-06-26T20:11:01+00:00  OC\Console\Application->run() at /app/www/public/console.php:102
2024-06-26T20:11:01+00:00  require_once() at /app/www/public/occ:11
2024-06-26T20:11:01+00:00 
2024-06-26T20:11:01+00:00 In Exception.php line 28:
2024-06-26T20:11:01+00:00                                                                                  
2024-06-26T20:11:01+00:00   [Doctrine\DBAL\Driver\PDO\Exception (1054)]                                    
2024-06-26T20:11:01+00:00   SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lazy' in 'field list'  
2024-06-26T20:11:01+00:00                                                                                  
2024-06-26T20:11:01+00:00 
2024-06-26T20:11:01+00:00 Exception trace:
2024-06-26T20:11:01+00:00   at /app/www/public/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php:28
2024-06-26T20:11:01+00:00  Doctrine\DBAL\Driver\PDO\Exception::new() at /app/www/public/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php:132
2024-06-26T20:11:01+00:00  Doctrine\DBAL\Driver\PDO\Statement->execute() at /app/www/public/3rdparty/doctrine/dbal/src/Connection.php:1207
2024-06-26T20:11:01+00:00  Doctrine\DBAL\Connection->executeStatement() at /app/www/public/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php:292
2024-06-26T20:11:01+00:00  Doctrine\DBAL\Connections\PrimaryReadReplicaConnection->executeStatement() at /app/www/public/lib/private/DB/Connection.php:373
2024-06-26T20:11:01+00:00  OC\DB\Connection->executeStatement() at /app/www/public/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php:393
2024-06-26T20:11:01+00:00  Doctrine\DBAL\Query\QueryBuilder->execute() at /app/www/public/lib/private/DB/QueryBuilder/QueryBuilder.php:280
2024-06-26T20:11:01+00:00  OC\DB\QueryBuilder\QueryBuilder->execute() at /app/www/public/lib/private/DB/QueryBuilder/QueryBuilder.php:326
2024-06-26T20:11:01+00:00  OC\DB\QueryBuilder\QueryBuilder->executeStatement() at /app/www/public/lib/private/AppConfig.php:783
2024-06-26T20:11:01+00:00  OC\AppConfig->setTypedValue() at /app/www/public/lib/private/AppConfig.php:1360
2024-06-26T20:11:01+00:00  OC\AppConfig->setValue() at /app/www/public/lib/private/AllConfig.php:208
2024-06-26T20:11:01+00:00  OC\AllConfig->setAppValue() at /app/www/public/lib/private/Updater.php:126
2024-06-26T20:11:01+00:00  OC\Updater->upgrade() at /app/www/public/core/Command/Upgrade.php:216
2024-06-26T20:11:01+00:00  OC\Core\Command\Upgrade->execute() at /app/www/public/3rdparty/symfony/console/Command/Command.php:298
2024-06-26T20:11:01+00:00  Symfony\Component\Console\Command\Command->run() at /app/www/public/3rdparty/symfony/console/Application.php:1040
2024-06-26T20:11:01+00:00  Symfony\Component\Console\Application->doRunCommand() at /app/www/public/3rdparty/symfony/console/Application.php:301
2024-06-26T20:11:01+00:00  Symfony\Component\Console\Application->doRun() at /app/www/public/3rdparty/symfony/console/Application.php:171
2024-06-26T20:11:01+00:00  Symfony\Component\Console\Application->run() at /app/www/public/lib/private/Console/Application.php:213
2024-06-26T20:11:01+00:00  OC\Console\Application->run() at /app/www/public/console.php:102
2024-06-26T20:11:01+00:00  require_once() at /app/www/public/occ:11
2024-06-26T20:11:01+00:00 
2024-06-26T20:11:01+00:00 In Statement.php line 130:
2024-06-26T20:11:01+00:00                                                                                  
2024-06-26T20:11:01+00:00   [PDOException (42S22)]                                                         
2024-06-26T20:11:01+00:00   SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lazy' in 'field list'  
2024-06-26T20:11:01+00:00                                                                                  
2024-06-26T20:11:01+00:00 
2024-06-26T20:11:01+00:00 Exception trace:
2024-06-26T20:11:01+00:00   at /app/www/public/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php:130
2024-06-26T20:11:01+00:00  PDOStatement->execute() at /app/www/public/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php:130
2024-06-26T20:11:01+00:00  Doctrine\DBAL\Driver\PDO\Statement->execute() at /app/www/public/3rdparty/doctrine/dbal/src/Connection.php:1207
2024-06-26T20:11:01+00:00  Doctrine\DBAL\Connection->executeStatement() at /app/www/public/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php:292
2024-06-26T20:11:01+00:00  Doctrine\DBAL\Connections\PrimaryReadReplicaConnection->executeStatement() at /app/www/public/lib/private/DB/Connection.php:373
2024-06-26T20:11:01+00:00  OC\DB\Connection->executeStatement() at /app/www/public/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php:393
2024-06-26T20:11:01+00:00  Doctrine\DBAL\Query\QueryBuilder->execute() at /app/www/public/lib/private/DB/QueryBuilder/QueryBuilder.php:280
2024-06-26T20:11:01+00:00  OC\DB\QueryBuilder\QueryBuilder->execute() at /app/www/public/lib/private/DB/QueryBuilder/QueryBuilder.php:326
2024-06-26T20:11:01+00:00  OC\DB\QueryBuilder\QueryBuilder->executeStatement() at /app/www/public/lib/private/AppConfig.php:783
2024-06-26T20:11:01+00:00  OC\AppConfig->setTypedValue() at /app/www/public/lib/private/AppConfig.php:1360
2024-06-26T20:11:01+00:00  OC\AppConfig->setValue() at /app/www/public/lib/private/AllConfig.php:208
2024-06-26T20:11:01+00:00  OC\AllConfig->setAppValue() at /app/www/public/lib/private/Updater.php:126
2024-06-26T20:11:01+00:00  OC\Updater->upgrade() at /app/www/public/core/Command/Upgrade.php:216
2024-06-26T20:11:01+00:00  OC\Core\Command\Upgrade->execute() at /app/www/public/3rdparty/symfony/console/Command/Command.php:298
2024-06-26T20:11:01+00:00  Symfony\Component\Console\Command\Command->run() at /app/www/public/3rdparty/symfony/console/Application.php:1040
2024-06-26T20:11:01+00:00  Symfony\Component\Console\Application->doRunCommand() at /app/www/public/3rdparty/symfony/console/Application.php:301
2024-06-26T20:11:01+00:00  Symfony\Component\Console\Application->doRun() at /app/www/public/3rdparty/symfony/console/Application.php:171
2024-06-26T20:11:01+00:00  Symfony\Component\Console\Application->run() at /app/www/public/lib/private/Console/Application.php:213
2024-06-26T20:11:01+00:00  OC\Console\Application->run() at /app/www/public/console.php:102
2024-06-26T20:11:01+00:00  require_once() at /app/www/public/occ:11
2024-06-26T20:11:01+00:00 
2024-06-26T20:11:01+00:00 upgrade
2024-06-26T20:11:01+00:00

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

cat /config/www/nextcloud/config/config.php 
<?php
$CONFIG = array (
  'memcache.local' => '\\OC\\Memcache\\APCu',
  'datadirectory' => '/data',
  'instanceid' => 'mysecret',
  'passwordsalt' => 'mysecret',
  'secret' => 'mysecret',
  'trusted_domains' => 
  array (
    0 => '10.200.115.174:6443',
    1 => 'mysecret.domain',
  ),
  'dbtype' => 'mysql',
  'version' => '28.0.1.1',
  'overwrite.cli.url' => 'https://10.200.115.174:6443',
  'dbname' => 'nextcloud',
  'dbhost' => '10.200.115.174:3307',
  'dbport' => '',
  'dbtableprefix' => 'oc_',
  'mysql.utf8mb4' => true,
  'dbuser' => 'nextcloud',
  'dbpassword' => 'mysecret',
  'installed' => true,
  'twofactor_enforced' => 'false',
  'twofactor_enforced_groups' => 
  array (
  ),
  'twofactor_enforced_excluded_groups' => 
  array (
    0 => 'admin',
  ),
  'mail_from_address' => 'nextcloud',
  'mail_smtpmode' => 'smtp',
  'mail_sendmailmode' => 'smtp',
  'mail_domain' => 'mysecret.domain',
  'theme' => '',
  'loglevel' => 0,
  'maintenance' => true,
  'filelocking.enabled' => 'true',
  'memcache.locking' => '\\OC\\Memcache\\APCu',
  'upgrade.disable-web' => false,
);

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

2024/06/26 16:05:16 [warn] 571#571: the "listen ... http2" directive is deprecated, use the "http2" directive instead in /config/nginx/site-confs/default.conf:13
2024/06/26 16:05:16 [warn] 571#571: the "listen ... http2" directive is deprecated, use the "http2" directive instead in /config/nginx/site-confs/default.conf:14

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.

cat nextcloud.log
{"reqId":"mLVjfxAdoUZDyRdRtfel","level":1,"time":"2024-06-26T20:25:54+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","message":"\\OC\\Updater::setDebugLogLevel: Set log level to debug","userAgent":"--","version":"28.0.1.1","data":{"app":"updater"}}

jtr · June 26, 2024, 11:00pm

What image are you using? It’s unusual to run occ upgrade against a Docker image unless you’re already having problems.

How, precisely, did you update your container from 28.0.1 to 29.0.3?

From the looks of it you’re not using any of the Nextcloud provided images, but perhaps the LinuxServer.io maintained one?

In general I would not make such large jumps in between versions. You are far more likely to encounter problems.

Officially you’re supposed to upgrade to the latest maintenance release in your major version before jumping to the next major version.

j-ed · June 27, 2024, 8:10am

I’m still using NC 28.0.7 and had a quick look in which table the lazy field exists. This is my finding:

> describe oc_appconfig;
+-------------+-------------+------+-----+---------+-------+
| Field       | Type        | Null | Key | Default | Extra |
+-------------+-------------+------+-----+---------+-------+
| appid       | varchar(32) | NO   | PRI |         |       |
| configkey   | varchar(64) | NO   | PRI |         |       |
| configvalue | longtext    | YES  |     | NULL    |       |
| type        | int(11)     | NO   |     | 2       |       |
| lazy        | tinyint(1)  | YES  |     | 0       |       |
+-------------+-------------+------+-----+---------+-------+
5 rows in set (0.001 sec)

Unfortunately I don’t know if this field is being removed in future NC versions.

Pi_V · June 27, 2024, 10:28am

I just got the same error while upgrading using the Docker image from https://hub.docker.com/_/nextcloud with the tag nextcloud:apache.
When I go to the Nextcloud URL, I agree to update the database and then it tells me :

OC\DB\Exceptions\DbalException: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lazy' in 'field list'

Looking at the databases:

MariaDB [nextcloud]> describe oc_appconfig;
+-------------+-------------+------+-----+---------+-------+
| Field       | Type        | Null | Key | Default | Extra |
+-------------+-------------+------+-----+---------+-------+
| appid       | varchar(32) | NO   | PRI |         |       |
| configkey   | varchar(64) | NO   | PRI |         |       |
| configvalue | longtext    | YES  |     | NULL    |       |
+-------------+-------------+------+-----+---------+-------+
3 rows in set (0.002 sec)

j-ed · June 27, 2024, 12:33pm

Due to the fact that a missing index has been addressed last week in the following ticket, I assume that the field is still required:

github.com/nextcloud/server

[Bug]: Missing index for oc_appconfig.lazy

opened 02:48PM - 20 Jun 24 UTC

ChristophWurst

bug 0. Needs triage performance 🚀 29-feedback

### ⚠️ This issue respects the following points: ⚠️ - [X] This is a **bug**, …not a question or a configuration/webserver/proxy issue. - [X] This issue is **not** already reported on [Github](https://github.com/nextcloud/server/issues?q=is%3Aopen+is%3Aissue+label%3Abug) OR [Nextcloud Community Forum](https://help.nextcloud.com/) _(I've searched it)_. - [X] Nextcloud Server **is** up to date. See [Maintenance and Release Schedule](https://github.com/nextcloud/server/wiki/Maintenance-and-Release-Schedule) for supported versions. - [X] I agree to follow Nextcloud's [Code of Conduct](https://nextcloud.com/contribute/code-of-conduct/). ### Bug description The query ```sql SELECT `appid`, `configkey`, `configvalue`, `type` FROM `oc_appconfig` WHERE `lazy` = 0 ``` does not use an index. It's executed often. Query id 43744e10e8843e7dff44336c2481d8ad ### Steps to reproduce 1. ??? ### Expected behavior Fast queries ### Installation method None ### Nextcloud Server version 29 ### Operating system None ### PHP engine version None ### Web server None ### Database engine version None ### Is this bug present after an update or on a fresh install? None ### Are you using the Nextcloud Server Encryption module? None ### What user-backends are you using? - [ ] Default user-backend _(database)_ - [ ] LDAP/ Active Directory - [ ] SSO - SAML - [ ] Other ### Configuration report _No response_ ### List of activated Apps _No response_ ### Nextcloud Signing status _No response_ ### Nextcloud Logs _No response_ ### Additional info _No response_

Have you tried to add the missing field manually to get rid of the error message?
Nevertheless it might be worth to open an issue ticket in the Github repository to get it fixed in the docker image:

ad8mustanggt · June 29, 2024, 8:26am

I went back to the latest 28.x release and it installed w/o issue. After that, the latest 29.x release installed with no problems. Next time I won’t try to take shortcuts

jtr · June 29, 2024, 8:01pm

Do you know what version you upgraded from? I would suggest tagging your Docker image reference with a version string so that you don’t get unpredictable version bumps.