SQL error on upgrade from 10.0.7 to 10.0.8

upgrade
10

#1

Morning,

When upgrading from 10.0.7 to 10.0.8 I am getting the following SQL error:

2018-04-30T07:23:50+00:00 Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing 'SELECT min_value, increment_by FROM "oc_dav_shares_id_seq"':

SQLSTATE[42703]: Undefined column: 7 ERROR:  column "min_value" does not exist
LINE 1: SELECT min_value, increment_by FROM "oc_dav_shares_id_seq"
               ^
2018-04-30T07:23:50+00:00 Update failed

I can only agree with it, this column does not exist in that table:

owncloud=> \d oc_dav_shares_id_seq
Sequence "public.oc_dav_shares_id_seq"
   Column   |  Type   | Value 
------------+---------+-------
 last_value | bigint  | 1
 log_cnt    | bigint  | 0
 is_called  | boolean | f
Owned by: public.oc_dav_shares.id

Any ideas?

Thanks

Martin.


#2

Hi

To answer my own question, this turns out to be a problem for users of Postgres 10. The workaround suggested by "wzator" in this thread works: https://github.com/doctrine/dbal/issues/2868

Thanks

Martin.


#3

This is a known issue: