Bug 640490

Summary:	www-apps/nextcloud-12.0.* with postgresql-10 - Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing 'SELECT min_value, increment_by FROM "oc_activity_mq_mail_id_seq"': SQLSTATE[42703]: Undefined column: 7 ERROR: ...
Product:	Gentoo Linux	Reporter:	Nils Freydank <holgersson>
Component:	Current packages	Assignee:	Bernard Cafarelli <voyageur>
Status:	RESOLVED FIXED
Severity:	normal	CC:	holgersson, kaikaikai, web-apps
Priority:	Normal
Version:	unspecified
Hardware:	All
OS:	Linux
URL:	https://github.com/nextcloud/server/issues/5930
Whiteboard:
Package list:		Runtime testing required:	---
Attachments:	nextcloud-12.0.4-upgrade-with-postgresqlv10.patch

Description Nils Freydank 2017-12-10 12:04:16 UTC

Hi,

I updated my postgresql database from v9 to v10 while running nextcloud-12.0.3.

While updating nextcloud to 12.0.4 today I run into the errors described in the github issue tracker (see URL).

The patch posted there works fine for me via /etc/portage/patches. I’ll attach it here.

Reproducible: Always

Comment 1 Nils Freydank 2017-12-10 12:05:20 UTC

Created attachment 509234 [details, diff]
nextcloud-12.0.4-upgrade-with-postgresqlv10.patch

Comment 2 Jeroen Roovers (RETIRED) gentoo-dev

2017-12-14 22:29:28 UTC

Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing 'SELECT min_value, increment_by FROM "oc_activity_mq_mail_id_seq"':

SQLSTATE[42703]: Undefined column: 7 ERROR:  column "min_value" does not exist
LINE 1: SELECT min_value, increment_by FROM "oc_activity_mq_mail_id_...
               ^
Update failed

Comment 3 Bernard Cafarelli gentoo-dev

2018-01-04 10:32:42 UTC

Thanks for the report! While this fixes the installation issue, it looks like additional changes are needed for proper runtime operation. So instead of visible error on upgrade, users may see issues cropping up later (and harder to diagnose).


Hmm, the requirements are up-to-date now:
https://docs.nextcloud.com/server/12/admin_manual/installation/system_requirements.html#supported-platforms
(I am updating the ebuilds to block php7.2)
so I am leaning on leaving this bug open until 13.0 is out, if people want to try the patch (or get to understand the problem). It would have been nice if upstream had added some runtime checks on it though :(

Comment 4 Alexey Korepanov 2018-02-06 16:22:36 UTC

13.0 is out

Comment 5 Bernard Cafarelli gentoo-dev

2018-02-07 10:30:41 UTC

And it seems to work fine here! Added 13.0.0 to tree, hopefully both php 7.2 and postgres 10 wok fine with it