Mailing List Archive: DAViCal: General

update-davical-database help

Index | Next | Previous | View Threaded

travs69 at gmail

Oct 17, 2011, 3:29 PM

Post #1 of 4 (450 views)
Permalink

update-davical-database help

I recently upgraded Davical and tried to to the update-davical-database and
I'm getting the following output

/usr/share/davical/dba/update-davical-database
--dbuser=davi cal_dba
The database is version 8.4 currently at revision 1.2.9.
Applying patch 1.2.10.sql ... failed. Attempting next alternative.
Applying patch 1.2.10a.sql ... failed!
psql:/usr/share/davical/dba/patches/1.2.10a.sql:31: ERROR: could not load
libra ry "/usr/lib/postgresql/8.4/lib/plpgsql.so":
/usr/lib/postgresql/8.4/lib/plpgsql .so: undefined
symbol: do_convert_tuple
psql:/usr/share/davical/dba/patches/1.2.10a.sql:36: ERROR: constraint
"unique_u ser" of relation "principal" does not exist
psql:/usr/share/davical/dba/patches/1.2.10a.sql:37: ERROR: constraint
"unique_p ath" of relation "collection" does not exist
psql:/usr/share/davical/dba/patches/1.2.10a.sql:62: ERROR: could not load
libra ry "/usr/lib/postgresql/8.4/lib/plpgsql.so":
/usr/lib/postgresql/8.4/lib/plpgsql .so: undefined
symbol: do_convert_tuple
psql:/usr/share/davical/dba/patches/1.2.10a.sql:65: ERROR: could not load
libra ry "/usr/lib/postgresql/8.4/lib/plpgsql.so":
/usr/lib/postgresql/8.4/lib/plpgsql .so: undefined
symbol: do_convert_tuple
psql:/usr/share/davical/dba/patches/1.2.10a.sql:67: ERROR: current
transaction is aborted, commands ignored until end of
transaction block
psql:/usr/share/davical/dba/patches/1.2.10a.sql:70: ERROR: current
transaction is aborted, commands ignored until end of
transaction block
psql:/usr/share/davical/dba/patches/1.2.10a.sql:71: ERROR: current
transaction is aborted, commands ignored until end of
transaction block
psql:/usr/share/davical/dba/patches/1.2.10a.sql:73: ERROR: current
transaction is aborted, commands ignored until end of
transaction block
psql:/usr/share/davical/dba/patches/1.2.10a.sql:79: ERROR: current
transaction is aborted, commands ignored until end of
transaction block
psql:/usr/share/davical/dba/patches/1.2.10a.sql:81: ERROR: current
transaction is aborted, commands ignored until end of
transaction block
psql:/usr/share/davical/dba/patches/1.2.10a.sql:83: ERROR: current
transaction is aborted, commands ignored until end of
transaction block
psql:/usr/share/davical/dba/patches/1.2.10a.sql:86: ERROR: current
transaction is aborted, commands ignored until end of
transaction block
psql:/usr/share/davical/dba/patches/1.2.10a.sql:89: ERROR: current
transaction is aborted, commands ignored until end of
transaction block
psql:/usr/share/davical/dba/patches/1.2.10a.sql:90: ERROR: current
transaction is aborted, commands ignored until end of
transaction block
psql:/usr/share/davical/dba/patches/1.2.10a.sql:92: 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.
DBD::Pg::db do failed: ERROR: relation "timezones" does not exist at
/usr/share/davical/dba/update-davical-database line 400, <PERMS> line 48.
DBD::Pg::db do failed: ERROR: relation "tz_aliases" does not exist at
/usr/share/davical/dba/update-davical-database line 400, <PERMS> line 49.
DBD::Pg::db do failed: ERROR: relation "tz_localnames" does not exist at
/usr/share/davical/dba/update-davical-database line 400, <PERMS> line 50.
DBD::Pg::db do failed: ERROR: relation "timezones_our_tzno_seq" does not
exist at /usr/share/davical/dba/update-davical-database line 400, <PERMS>
line 60.
Database permissions updated.

Any help is appreciated..

Thanks,

Travis

andrew at morphoss

Oct 17, 2011, 3:52 PM

Post #2 of 4 (443 views)
Permalink

Re: update-davical-database help [In reply to]

On Mon, 2011-10-17 at 17:29 -0500, Travis Williams wrote:
> I recently upgraded Davical and tried to to the
> update-davical-database and I'm getting the following output
>
> /usr/share/davical/dba/update-davical-database --dbuser=davi
> cal_dba
> The database is version 8.4 currently at revision 1.2.9.
> Applying patch 1.2.10.sql ... failed. Attempting next alternative.
> Applying patch 1.2.10a.sql ... failed!
> psql:/usr/share/davical/dba/patches/1.2.10a.sql:31: ERROR: could not
> load libra ry
> "/usr/lib/postgresql/8.4/lib/plpgsql.so": /usr/lib/postgresql/8.4/lib/plpgsql .so: undefined symbol: do_convert_tuple

How is PostgreSQL installed? Looks like some kind of borked postgresql
installation where the plpgsql module is busted.

DAViCal depends on PL/PgSQL for various in-database functions, but this
is not news, so the library must have worked for you at some point in
the past.

Cheers,
Andrew.

--
------------------------------------------------------------------------
andrew (AT) morphoss (DOT) com +64(272)DEBIAN
Simon's Law:
Everything put together falls apart sooner or later.
------------------------------------------------------------------------

Attachments:

signature.asc (0.82 KB)

travs69 at gmail

Oct 17, 2011, 4:59 PM

Post #3 of 4 (455 views)
Permalink

Re: update-davical-database help [In reply to]

Andrew,
Thanks, I stopped/started postgresql and these errors went away and
patches applied.. strange.

I am getting one additiona message that I do not know if I should be
concerned about:

GRANT SELECT,UPDATE on timezones_our_tzno_seq to davical_app
GRANT SELECT,INSERT on time_zone to davical_app
DBD::Pg::db do failed: ERROR: relation "time_zone" does not exist at
./update-davical-database line 401, <PERMS> line 63.

but Davical seems to be acting fine.

Travis

On Mon, Oct 17, 2011 at 5:52 PM, Andrew McMillan <andrew [at] morphoss>wrote:

> On Mon, 2011-10-17 at 17:29 -0500, Travis Williams wrote:
> > I recently upgraded Davical and tried to to the
> > update-davical-database and I'm getting the following output
> >
> > /usr/share/davical/dba/update-davical-database --dbuser=davi
> > cal_dba
> > The database is version 8.4 currently at revision 1.2.9.
> > Applying patch 1.2.10.sql ... failed. Attempting next alternative.
> > Applying patch 1.2.10a.sql ... failed!
> > psql:/usr/share/davical/dba/patches/1.2.10a.sql:31: ERROR: could not
> > load libra ry
> > "/usr/lib/postgresql/8.4/lib/plpgsql.so":
> /usr/lib/postgresql/8.4/lib/plpgsql .so: undefined
> symbol: do_convert_tuple
>
> How is PostgreSQL installed? Looks like some kind of borked postgresql
> installation where the plpgsql module is busted.
>
> DAViCal depends on PL/PgSQL for various in-database functions, but this
> is not news, so the library must have worked for you at some point in
> the past.
>
> Cheers,
> Andrew.
>
> --
> ------------------------------------------------------------------------
> andrew (AT) morphoss (DOT) com +64(272)DEBIAN
> Simon's Law:
> Everything put together falls apart sooner or later.
> ------------------------------------------------------------------------
>
>

andrew at morphoss

Oct 17, 2011, 6:26 PM

Post #4 of 4 (469 views)
Permalink

Re: update-davical-database help [In reply to]

On Mon, 2011-10-17 at 18:59 -0500, Travis Williams wrote:
> Andrew,
> Thanks, I stopped/started postgresql and these errors went away and
> patches applied.. strange.
>
> I am getting one additiona message that I do not know if I should be
> concerned about:
>
> GRANT SELECT,UPDATE on timezones_our_tzno_seq to davical_app
> GRANT SELECT,INSERT on time_zone to davical_app
> DBD::Pg::db do failed: ERROR: relation "time_zone" does not exist
> at ./update-davical-database line 401, <PERMS> line 63.

It's cosmetic - fixed in Git also.

> but Davical seems to be acting fine.

Great :-)

Cheers,
Andrew.

>

--
------------------------------------------------------------------------
andrew (AT) morphoss (DOT) com +64(272)DEBIAN
Ignorance is like cholera. It cannot be controlled by the individual
alone: it requires the organised efforts of society. -- Sir Muir Gray

------------------------------------------------------------------------

Attachments:

signature.asc (0.82 KB)

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact Gossamer Threads