Database upgrade fails
Davical web says:
Database schema needs upgrading. Current: 1.2.11, Desired: 1.3.2
So I tried to update, but it fails:
...
Looking at patches[25] (1.2.10.sql)
Patch 1.2.10.sql has already been applied.
Looking at patches[26] (1.2.10a.sql)
Patch 1.2.10a.sql has already been applied.
Looking at patches[27] (1.2.11.sql)
Patch 1.2.11.sql has already been applied.
Looking at patches[28] (1.2.12.sql)
Applying patch 1.2.12.sql ... Failed to apply revision 1.2.12.sql to the database!
failed!
psql:/usr/share/davical/dba/patches/1.2.12.sql:5: ERROR: Database has not been upgraded to 1.2.11
psql:/usr/share/davical/dba/patches/1.2.12.sql:8: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:/usr/share/davical/dba/patches/1.2.12.sql:9: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:/usr/share/davical/dba/patches/1.2.12.sql:12: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:/usr/share/davical/dba/patches/1.2.12.sql:15: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:/usr/share/davical/dba/patches/1.2.12.sql:18: ERROR: current transaction is aborted, commands ignored until end of transaction block
==> No further patches will be attempted!
No patches were applied.
...
How can I fix the update? Why does it say "not been upgraded to 1.2.11"? It is already on that version.
I am on ubuntu 16.04.2 and I tried to fix the wrong table owner, like written at http://wiki.davical.org/index.php/Issues/Wrong_table_owner so I get a clean list:
postgres@mail:/tmp$ psql davical
psql (9.5.7)
Type "help" for help.
davical=# \d
List of relations
Schema | Name | Type | Owner
--------+--------------------------------------+----------+-------------
public | access_ticket | table | davical_dba
public | addressbook_address_adr | table | davical_dba
public | addressbook_address_email | table | davical_dba
public | addressbook_address_tel | table | davical_dba
public | addressbook_resource | table | davical_dba
public | awl_db_revision | table | davical_dba
public | caldav_data | table | davical_dba
public | calendar_alarm | table | davical_dba
public | calendar_attendee | table | davical_dba
public | calendar_item | table | davical_dba
public | collection | table | davical_dba
public | dav_binding | table | davical_dba
public | dav_id_seq | sequence | davical_dba
public | dav_principal | view | davical_dba
public | freebusy_ticket | table | davical_dba
public | grants | table | davical_dba
public | group_member | table | davical_dba
public | locks | table | davical_dba
public | principal | table | davical_dba
public | principal_type | table | davical_dba
public | principal_type_principal_type_id_seq | sequence | davical_dba
public | property | table | davical_dba
public | relationship | table | davical_dba
public | relationship_type | table | davical_dba
public | relationship_type_rt_id_seq | sequence | davical_dba
public | role_member | table | davical_dba
public | roles | table | davical_dba
public | roles_role_no_seq | sequence | davical_dba
public | session | table | davical_dba
public | session_session_id_seq | sequence | davical_dba
public | supported_locales | table | davical_dba
public | sync_changes | table | davical_dba
public | sync_tokens | table | davical_dba
public | sync_tokens_sync_token_seq | sequence | davical_dba
public | timezones | table | davical_dba
public | timezones_our_tzno_seq | sequence | davical_dba
public | tmp_password | table | davical_dba
public | tz_aliases | table | davical_dba
public | tz_localnames | table | davical_dba
public | usr | table | davical_dba
public | usr_setting | table | davical_dba
public | usr_user_no_seq | sequence | davical_dba
(42 rows)
but no combo from http://wiki.davical.org/w/Update-davical-database works.
postgres@mail:/tmp$ /usr/share/davical/dba/update-davical-database --dbuser=davical_dba
seems to change nothing.
with postgres@mail:/tmp$ /usr/share/davical/dba/update-davical-database --dbuser=postgres
it changes at least one table to:
Schema | Name | Type | Owner
--------+--------------------------------------+----------+-------------
...
public | dav_principal | view | postgres
...
any help appreciated