andrew at morphoss
Sep 16, 2011, 8:37 PM
Post #2 of 6
(443 views)
Permalink
|
hi Johannes,
Thanks for this note. I've seen a few upgrades that went this way but
never actually got to understand why :-)
Can you run a couple of queries for me so I can work out why, and try
and fix the actual problem?
You'll need to do the following, first start psql:
psql -U davical_dba davical
First, this line should dump the structure of the awl_db_revision table:
\d awl_db_revision
Then this query (line breaks should not affect it) which is what the
upgrade script is actually running and should help me identify the
error:
SELECT COUNT(*) INTO matching FROM awl_db_revision WHERE (schema_major =
major AND schema_minor = minor AND schema_patch > patch) OR
(schema_major = major AND schema_minor > minor) OR (schema_major >
major);
Finally this query should dump all the rows:
SELECT * FROM awl_db_revision;
then send me the output from those two queries.
Finally, to fix the problem:
DELETE FROM awl_db_revision;
should delete all the existing rows, and:
SELECT new_db_revision(1,2,9, 'Octobre' );
should put a single correct row in there.
After that you should be able to re-run the update script and have it
complete correctly.
No need to send that all to the list - just e-mail it to me directly.
Regards,
Andrew McMillan.
On Fri, 2011-09-16 at 13:26 +0200, Johannes Kreuzhuber wrote:
> Using database: davical_dba%@dbi:Pg:dbname=davical
> The database is version 8.4 currently at revision 1.2.9.
> Looking at patches[0] (1.1.2.sql)
> Patch 1.1.2.sql has already been applied.
> Looking at patches[1] (1.1.3.sql)
> Patch 1.1.3.sql has already been applied.
> Looking at patches[2] (1.1.4.sql)
> Patch 1.1.4.sql has already been applied.
> Looking at patches[3] (1.1.5.sql)
> Patch 1.1.5.sql has already been applied.
> Looking at patches[4] (1.1.6.sql)
> Patch 1.1.6.sql has already been applied.
> Looking at patches[5] (1.1.7.sql)
> Patch 1.1.7.sql has already been applied.
> Looking at patches[6] (1.1.8.sql)
> Patch 1.1.8.sql has already been applied.
> Looking at patches[7] (1.1.9.sql)
> Patch 1.1.9.sql has already been applied.
> Looking at patches[8] (1.1.10.sql)
> Patch 1.1.10.sql has already been applied.
> Looking at patches[9] (1.1.11.sql)
> Patch 1.1.11.sql has already been applied.
> Looking at patches[10] (1.1.11a.sql)
> Patch 1.1.11a.sql has already been applied.
> Looking at patches[11] (1.1.12.sql)
> Patch 1.1.12.sql has already been applied.
> Looking at patches[12] (1.1.12a.sql)
> Patch 1.1.12a.sql has already been applied.
> Looking at patches[13] (1.2.1.sql)
> Patch 1.2.1.sql has already been applied.
> Looking at patches[14] (1.2.1a.sql)
> Patch 1.2.1a.sql has already been applied.
> Looking at patches[15] (1.2.1b.sql)
> Patch 1.2.1b.sql has already been applied.
> Looking at patches[16] (1.2.2.sql)
> Patch 1.2.2.sql has already been applied.
> Looking at patches[17] (1.2.3.sql)
> Patch 1.2.3.sql has already been applied.
> Looking at patches[18] (1.2.3a.sql)
> Patch 1.2.3a.sql has already been applied.
> Looking at patches[19] (1.2.4.sql)
> Patch 1.2.4.sql has already been applied.
> Looking at patches[20] (1.2.5.sql)
> Patch 1.2.5.sql has already been applied.
> Looking at patches[21] (1.2.6.sql)
> Patch 1.2.6.sql has already been applied.
> Looking at patches[22] (1.2.7.sql)
> Patch 1.2.7.sql has already been applied.
> Looking at patches[23] (1.2.8.sql)
> Patch 1.2.8.sql has already been applied.
> Looking at patches[24] (1.2.9.sql)
> Patch 1.2.9.sql has already been applied.
> Looking at patches[25] (1.2.10.sql)
> Applying patch 1.2.10.sql ... Failed to apply revision 1.2.10.sql to
> the database!
> failed!
> psql:/usr/share/davical/dba/patches/1.2.10.sql:8: ERROR: constraint
> "unique_user" of relation "principal" does not exist
> psql:/usr/share/davical/dba/patches/1.2.10.sql:9: ERROR: constraint
> "unique_path" of relation "collection" does not exist
> psql:/usr/share/davical/dba/patches/1.2.10.sql:37: ERROR: Database
> has not been upgraded to 1.2.9
> psql:/usr/share/davical/dba/patches/1.2.10.sql:39: ERROR: current
> transaction is aborted, commands ignored until end of transaction
> block
> psql:/usr/share/davical/dba/patches/1.2.10.sql:42: ERROR: current
> transaction is aborted, commands ignored until end of transaction
> block
> psql:/usr/share/davical/dba/patches/1.2.10.sql:43: ERROR: current
> transaction is aborted, commands ignored until end of transaction
> block
> psql:/usr/share/davical/dba/patches/1.2.10.sql:45: ERROR: current
> transaction is aborted, commands ignored until end of transaction
> block
> psql:/usr/share/davical/dba/patches/1.2.10.sql:51: ERROR: current
> transaction is aborted, commands ignored until end of transaction
> block
> psql:/usr/share/davical/dba/patches/1.2.10.sql:53: ERROR: current
> transaction is aborted, commands ignored until end of transaction
> block
> psql:/usr/share/davical/dba/patches/1.2.10.sql:55: ERROR: current
> transaction is aborted, commands ignored until end of transaction
> block
> psql:/usr/share/davical/dba/patches/1.2.10.sql:58: ERROR: current
> transaction is aborted, commands ignored until end of transaction
> block
> psql:/usr/share/davical/dba/patches/1.2.10.sql:61: ERROR: current
> transaction is aborted, commands ignored until end of transaction
> block
> psql:/usr/share/davical/dba/patches/1.2.10.sql:62: ERROR: current
> transaction is aborted, commands ignored until end of transaction
> block
> psql:/usr/share/davical/dba/patches/1.2.10.sql:64: ERROR: current
> transaction is aborted, commands ignored until end of transaction
> block
> there is no transaction in progress
> ==> No further patches will be attempted!
> No patches were applied.
> Supported locales updated.
> Updated view: dav_principal.sql applied.
> CalDAV functions updated.
> RRULE functions updated.
> GRANT SELECT,INSERT,UPDATE,DELETE on collection to davical_app
> GRANT SELECT,INSERT,UPDATE,DELETE on caldav_data to davical_app
> GRANT SELECT,INSERT,UPDATE,DELETE on calendar_item to davical_app
> GRANT SELECT,INSERT,UPDATE,DELETE on relationship to davical_app
> GRANT SELECT,INSERT,UPDATE,DELETE on locks to davical_app
> GRANT SELECT,INSERT,UPDATE,DELETE on property to davical_app
> GRANT SELECT,INSERT,UPDATE,DELETE on freebusy_ticket to davical_app
> GRANT SELECT,INSERT,UPDATE,DELETE on usr to davical_app
> GRANT SELECT,INSERT,UPDATE,DELETE on usr_setting to davical_app
> GRANT SELECT,INSERT,UPDATE,DELETE on roles to davical_app
> GRANT SELECT,INSERT,UPDATE,DELETE on role_member to davical_app
> GRANT SELECT,INSERT,UPDATE,DELETE on session to davical_app
> GRANT SELECT,INSERT,UPDATE,DELETE on tmp_password to davical_app
> GRANT SELECT,INSERT,UPDATE,DELETE on group_member to davical_app
> GRANT SELECT,INSERT,UPDATE,DELETE on principal to davical_app
> GRANT SELECT,INSERT,UPDATE,DELETE on relationship_type to davical_app
> GRANT SELECT,INSERT,UPDATE,DELETE on sync_tokens to davical_app
> GRANT SELECT,INSERT,UPDATE,DELETE on sync_changes to davical_app
> GRANT SELECT,INSERT,UPDATE,DELETE on grants to davical_app
> GRANT SELECT,INSERT,UPDATE,DELETE on dav_principal to davical_app
> GRANT SELECT,INSERT,UPDATE,DELETE on access_ticket to davical_app
> GRANT SELECT,INSERT,UPDATE,DELETE on dav_binding to davical_app
> GRANT SELECT,INSERT,UPDATE,DELETE on calendar_alarm to davical_app
> GRANT SELECT,INSERT,UPDATE,DELETE on calendar_attendee to davical_app
> GRANT SELECT,INSERT,UPDATE,DELETE on addressbook_resource to
> davical_app
> GRANT SELECT,INSERT,UPDATE,DELETE on addressbook_address_adr to
> davical_app
> GRANT SELECT,INSERT,UPDATE,DELETE on addressbook_address_tel to
> davical_app
> GRANT SELECT,INSERT,UPDATE,DELETE on addressbook_address_email to
> davical_app
> GRANT SELECT,UPDATE on relationship_type_rt_id_seq to davical_app
> GRANT SELECT,UPDATE on dav_id_seq to davical_app
> GRANT SELECT,UPDATE on usr_user_no_seq to davical_app
> GRANT SELECT,UPDATE on roles_role_no_seq to davical_app
> GRANT SELECT,UPDATE on session_session_id_seq to davical_app
> GRANT SELECT,UPDATE on principal_type_principal_type_id_seq to
> davical_app
> GRANT SELECT,UPDATE on sync_tokens_sync_token_seq to davical_app
> GRANT SELECT,INSERT on time_zone to davical_app
> GRANT SELECT on supported_locales to davical_app
> GRANT SELECT on awl_db_revision to davical_app
> GRANT SELECT on principal_type to davical_app
> Database permissions updated.
>
>
>
>
> mfg
>
>
>
> Ing. Johannes Kreuzhuber
> Kellergasse 17
> 7093 Jois
> Austria
> www.jbk-net.com
> kreuzhuber [at] jbk-net
> +436763388896
>
> ------------------------------------------------------------------------------
> BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA
> http://p.sf.net/sfu/rim-devcon-copy2
> _______________________________________________ Davical-general mailing list Davical-general [at] lists https://lists.sourceforge.net/lists/listinfo/davical-general
--
------------------------------------------------------------------------
andrew (AT) morphoss (DOT) com +64(272)DEBIAN
Don't engineer in a crisis. -- Vint Cerf speaking on IPv6
------------------------------------------------------------------------
|
signature.asc
