640490 – 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: ...

Bug 640490 - 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: ...

Summary: www-apps/nextcloud-12.0.* with postgresql-10 - Doctrine\DBAL\Exception\Invali...

Status:	RESOLVED FIXED

Alias:	None

Product:	Gentoo Linux
Classification:	Unclassified
Component:	Current packages (show other bugs)
Hardware:	All Linux

Importance:	Normal normal (vote)
Assignee:	Bernard Cafarelli

URL:	https://github.com/nextcloud/server/i...
Whiteboard:
Keywords:

Depends on:
Blocks:

Reported:	2017-12-10 12:04 UTC by Nils Freydank
Modified:	2018-02-07 10:30 UTC (History)
CC List:	3 users (show)

See Also:
Package list:
Runtime testing required:	---

Attachments
nextcloud-12.0.4-upgrade-with-postgresqlv10.patch (fix-upgrade-with-postgresql-10.patch,1.55 KB, patch) 2017-12-10 12:05 UTC, Nils Freydank	Details \| Diff
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.

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