Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[BUG] Unable to upgrade from 28.0.1.1 to 29.0.6.1; SQL error #470

Closed
1 task done
ALEEF02 opened this issue Sep 11, 2024 · 6 comments
Closed
1 task done

[BUG] Unable to upgrade from 28.0.1.1 to 29.0.6.1; SQL error #470

ALEEF02 opened this issue Sep 11, 2024 · 6 comments

Comments

@ALEEF02
Copy link

ALEEF02 commented Sep 11, 2024

Is there an existing issue for this?

  • I have searched the existing issues

Current Behavior

I just updated my container on through Unraid. I ran occ upgrade and was hit with the following set of SQL-related errors.

In DbalException.php line 71:
                                                                               
  An exception occurred while executing a query: SQLSTATE[42S22]: Column not   
  found: 1054 Unknown column 'lazy' in 'field list'                            
                                                                               

In ExceptionConverter.php line 67:
                                                                               
  An exception occurred while executing a query: SQLSTATE[42S22]: Column not   
  found: 1054 Unknown column 'lazy' in 'field list'                            
                                                                               

In Exception.php line 28:
                                                                               
  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lazy' in 'field list'                                                                           
                                                                               

In Statement.php line 130:
                                                                               
  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lazy' in 'field list'

My Nextcloud instance is stuck until I can upgrade.

Expected Behavior

It should upgrade successfully, allowing me to continue using Nextcloud.

Steps To Reproduce

Upgrade from 28.0.1.1 to 29.0.6.1

Environment

- OS: Unraid 6.12.3
- How docker service was installed: Through the Unraid App Browser, updated using the Unraid UI

CPU architecture

x86-64

Docker creation

Name:
nextcloud
Overview:
Nextcloud(https://nextcloud.com/) gives you access to all your files wherever you are.


Where are your photos and documents? With Nextcloud you pick a server of your choice, at home, in a data center or at a provider. And that is where your files will be. Nextcloud runs on that server, protecting your data and giving you access from your desktop or mobile devices. Through Nextcloud you also access, sync and share your existing data on that FTP drive at the office, a Dropbox or a NAS you have at home.


Additional Requirements:
None Listed
Repository:
lscr.io/linuxserver/nextcloud:latest
Network Type:

Bridge
Console shell command:

Bash
Privileged:
Off
WebUI:
4433
EditRemove
Container Port: 443
WebUI
Path: /data:
/mnt/user/nextcloud/
EditRemove
Container Path: /data
Your personal data.
Lighroom:
/mnt/user/SelfMedia/Lightroom/
EditRemove
Container Path: /lr

Premiere Pro:
/mnt/user/SelfMedia/Premiere Pro/
EditRemove
Container Path: /pr
Premiere Pro Media
 
 Hide more settings ...
Appdata:
/mnt/user/appdata/nextcloud
EditRemove
Container Path: /config
Nextcloud configs.
PUID:
99
EditRemove
Container Variable: PUID

PGID:
100
EditRemove
Container Variable: PGID

UMASK:
022
EditRemove
Container Variable: UMASK

Container logs

[migrations] started
[migrations] 01-nginx-site-confs-default: skipped
[migrations] 02-default-location: skipped
[migrations] done
───────────────────────────────────────

      ██╗     ███████╗██╗ ██████╗
      ██║     ██╔════╝██║██╔═══██╗
      ██║     ███████╗██║██║   ██║
      ██║     ╚════██║██║██║   ██║
      ███████╗███████║██║╚██████╔╝
      ╚══════╝╚══════╝╚═╝ ╚═════╝

   Brought to you by linuxserver.io
───────────────────────────────────────

To support LSIO projects visit:
https://www.linuxserver.io/donate/

───────────────────────────────────────
GID/UID
───────────────────────────────────────

User UID:    99
User GID:    100
───────────────────────────────────────
Linuxserver.io version: 29.0.6-ls338
Build-date: 2024-09-10T11:51:42+00:00
───────────────────────────────────────
    
using keys found in /config/keys
Initializing nextcloud 29.0.6.1 (this can take a while) ...
Upgrading nextcloud from 28.0.1.1 ...
Setting permissions
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
Setting log level to debug

In DbalException.php line 71:
                                                                               
  An exception occurred while executing a query: SQLSTATE[42S22]: Column not   
  found: 1054 Unknown column 'lazy' in 'field list'                            
                                                                               

In ExceptionConverter.php line 67:
                                                                               
  An exception occurred while executing a query: SQLSTATE[42S22]: Column not   
  found: 1054 Unknown column 'lazy' in 'field list'                            
                                                                               

In Exception.php line 28:
                                                                               
  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lazy' in 'field lis  
  t'                                                                           
                                                                               

In Statement.php line 130:
                                                                               
  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lazy' in 'field lis  
  t'                                                                           
                                                                               

upgrade

Initializing finished
**** The following active confs have different version dates than the samples that are shipped. ****
**** This may be due to user customization or an update to the samples. ****
**** You should compare the following files to the samples in the same folder and update them. ****
**** Use the link at the top of the file to view the changelog. ****
┌────────────┬────────────┬────────────────────────────────────────────────────────────────────────┐
│  old date  │  new date  │ path                                                                   │
├────────────┼────────────┼────────────────────────────────────────────────────────────────────────┤
│ 2023-04-13 │ 2024-05-27 │ /config/nginx/nginx.conf                                               │
│ 2023-06-23 │ 2024-06-24 │ /config/nginx/site-confs/default.conf                                  │
└────────────┴────────────┴────────────────────────────────────────────────────────────────────────┘
[custom-init] No custom files found, skipping...
[ls.io-init] done.
nginx: [warn] the "listen ... http2" directive is deprecated, use the "http2" directive instead in /config/nginx/site-confs/default.conf:13
nginx: [warn] the "listen ... http2" directive is deprecated, use the "http2" directive instead in /config/nginx/site-confs/default.conf:14
[migrations] started
[migrations] 01-nginx-site-confs-default: skipped
[migrations] 02-default-location: skipped
[migrations] done
usermod: no changes
───────────────────────────────────────

      ██╗     ███████╗██╗ ██████╗
      ██║     ██╔════╝██║██╔═══██╗
      ██║     ███████╗██║██║   ██║
      ██║     ╚════██║██║██║   ██║
      ███████╗███████║██║╚██████╔╝
      ╚══════╝╚══════╝╚═╝ ╚═════╝

   Brought to you by linuxserver.io
───────────────────────────────────────

To support LSIO projects visit:
https://www.linuxserver.io/donate/

───────────────────────────────────────
GID/UID
───────────────────────────────────────

User UID:    99
User GID:    100
───────────────────────────────────────
Linuxserver.io version: 29.0.6-ls338
Build-date: 2024-09-10T11:51:42+00:00
───────────────────────────────────────
    
using keys found in /config/keys
Initializing nextcloud 29.0.6.1 (this can take a while) ...
Upgrading nextcloud from 28.0.1.1 ...
Setting permissions
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
Setting log level to debug
Turned on maintenance mode

In DbalException.php line 71:
                                                                               
  An exception occurred while executing a query: SQLSTATE[42S22]: Column not   
  found: 1054 Unknown column 'lazy' in 'field list'                            
                                                                               

In ExceptionConverter.php line 67:
                                                                               
  An exception occurred while executing a query: SQLSTATE[42S22]: Column not   
  found: 1054 Unknown column 'lazy' in 'field list'                            
                                                                               

In Exception.php line 28:
                                                                               
  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lazy' in 'field lis  
  t'                                                                           
                                                                               

In Statement.php line 130:
                                                                               
  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lazy' in 'field lis  
  t'                                                                           
                                                                               

upgrade

Initializing finished
**** The following active confs have different version dates than the samples that are shipped. ****
**** This may be due to user customization or an update to the samples. ****
**** You should compare the following files to the samples in the same folder and update them. ****
**** Use the link at the top of the file to view the changelog. ****
┌────────────┬────────────┬────────────────────────────────────────────────────────────────────────┐
│  old date  │  new date  │ path                                                                   │
├────────────┼────────────┼────────────────────────────────────────────────────────────────────────┤
│ 2023-04-13 │ 2024-05-27 │ /config/nginx/nginx.conf                                               │
│ 2023-06-23 │ 2024-06-24 │ /config/nginx/site-confs/default.conf                                  │
└────────────┴────────────┴────────────────────────────────────────────────────────────────────────┘
[custom-init] No custom files found, skipping...
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
[ls.io-init] done.
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
nginx: [emerg] "http2" directive is duplicate in /config/nginx/site-confs/default.conf:16
[migrations] started
[migrations] 01-nginx-site-confs-default: skipped
[migrations] 02-default-location: skipped
[migrations] done
usermod: no changes
───────────────────────────────────────

      ██╗     ███████╗██╗ ██████╗
      ██║     ██╔════╝██║██╔═══██╗
      ██║     ███████╗██║██║   ██║
      ██║     ╚════██║██║██║   ██║
      ███████╗███████║██║╚██████╔╝
      ╚══════╝╚══════╝╚═╝ ╚═════╝

   Brought to you by linuxserver.io
───────────────────────────────────────

To support LSIO projects visit:
https://www.linuxserver.io/donate/

───────────────────────────────────────
GID/UID
───────────────────────────────────────

User UID:    99
User GID:    100
───────────────────────────────────────
Linuxserver.io version: 29.0.6-ls338
Build-date: 2024-09-10T11:51:42+00:00
───────────────────────────────────────
    
using keys found in /config/keys
Initializing nextcloud 29.0.6.1 (this can take a while) ...
Upgrading nextcloud from 28.0.1.1 ...
Setting permissions
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
Setting log level to debug

In DbalException.php line 71:
                                                                               
  An exception occurred while executing a query: SQLSTATE[42S22]: Column not   
  found: 1054 Unknown column 'lazy' in 'field list'                            
                                                                               

In ExceptionConverter.php line 67:
                                                                               
  An exception occurred while executing a query: SQLSTATE[42S22]: Column not   
  found: 1054 Unknown column 'lazy' in 'field list'                            
                                                                               

In Exception.php line 28:
                                                                               
  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lazy' in 'field lis  
  t'                                                                           
                                                                               

In Statement.php line 130:
                                                                               
  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lazy' in 'field lis  
  t'                                                                           
                                                                               

upgrade

Initializing finished
**** The following active confs have different version dates than the samples that are shipped. ****
**** This may be due to user customization or an update to the samples. ****
**** You should compare the following files to the samples in the same folder and update them. ****
**** Use the link at the top of the file to view the changelog. ****
┌────────────┬────────────┬────────────────────────────────────────────────────────────────────────┐
│  old date  │  new date  │ path                                                                   │
├────────────┼────────────┼────────────────────────────────────────────────────────────────────────┤
│ 2023-04-13 │ 2024-05-27 │ /config/nginx/nginx.conf                                               │
│ 2023-06-23 │ 2024-06-24 │ /config/nginx/site-confs/default.conf                                  │
└────────────┴────────────┴────────────────────────────────────────────────────────────────────────┘
[custom-init] No custom files found, skipping...
[ls.io-init] done.
@github-actions GitHub Actions
Copy link

Thanks for opening your first issue here! Be sure to follow the relevant issue templates, or risk having this issue marked as invalid.

@j0nnymoe
Copy link
Member

Do smaller steps in upgrading your container by using the version tags. Never a good idea to use latest.

@j0nnymoe
Copy link
Member

Note, this also may be a bug with nextcloud itself, not our container.

@ALEEF02
Copy link
Author

ALEEF02 commented Sep 11, 2024

Alright. I've upgraded to the latest "previous" tag, which is major version 28 still and that worked. I'll attempt to upgrade to 29 tonight. In the meantime, is there any way to select a specific version, or is it just previous, latest, and develop?

@aptalca
Copy link
Member

aptalca commented Sep 11, 2024

There are many more specific tags you can pull. Docker hub is easier to navigate through for that purpose as they allow searching/filtering through the tags

https://www.linuxserver.io/blog/docker-tags-so-many-tags-so-little-time

@ALEEF02
Copy link
Author

ALEEF02 commented Sep 12, 2024

I was able to solve the issue by updating from 28.0.1.1 to previous, then to 29.0.0, then to 29.0.4, and finally to latest.

@ALEEF02 ALEEF02 closed this as completed Sep 12, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
Issue & PR Tracker
Status: Done
Milestone
No milestone
Development

No branches or pull requests
3 participants
@aptalca @j0nnymoe @ALEEF02