[CalendarServer-users] Trouble upgrading from 5.3 to 7.0

[Jacques Distler]

> On Jan 25, 2016, at 9:43 AM, Jacques Distler <distler at golem.ph.utexas.edu> wrote:
> 
>> Have you tried installing directly from our latest svn trunk into a separate directory with a clean DB?
> 
> Haven't tried that yet.

Trying it was something of a washout.

Trunk does not compile on MacOSX 10.9. (You probably knew that already.)

Installing a fresh copy of CalendarServer 7.0, into a separate directory with a clean DB, had a (to me) surprising result.

     sudo bin/run -n

failed to initialize the database.

==============
Using /usr/local/CalDAV-7.0/CalendarServer/.develop/virtualenv/bin/python as Python

Starting server...
Reading configuration from file: /usr/local/CalDAV-7.0/CalendarServer/conf/caldavd-dev.plist
2016-01-26 02:39:48-0600 [-] Log opened.
2016-01-26 02:39:48-0600 [-] [twisted.application.app#info] twistd 15.2.1 (/usr/local/CalDAV-7.0/CalendarServer/.develop/virtualenv/bin/python 2.7.11) starting up.
2016-01-26 02:39:48-0600 [-] [twisted.application.app#info] reactor class: twisted.internet.selectreactor.SelectReactor.
2016-01-26 02:39:48-0600 [-] ControlSocket starting on '/Library/CalDAV/logs/caldavd.sock'
2016-01-26 02:39:48-0600 [-] [txdav.common.datastore.upgrade.sql.upgrade.UpgradeDatabaseSchemaStep#warn] Beginning database schema check.
2016-01-26 02:39:48-0600 [-] [txdav.common.datastore.upgrade.sql.upgrade.UpgradeDatabaseSchemaStep#warn] Required database key VERSION: 58.
2016-01-26 02:39:48-0600 [-] Exception from execute() on first statement in transaction.  Possibly caused by a database
 server restart.  Automatically reconnecting now.
        Traceback (most recent call last):
          File "/usr/local/CalDAV-7.0/CalendarServer/.develop/virtualenv/src/twextpy/twext/internet/threadutils.py", lne 48, in _run
            while self._qpull():
          File "/usr/local/CalDAV-7.0/CalendarServer/.develop/virtualenv/src/twextpy/twext/internet/threadutils.py", line 68, in _qpull
            self._oneWorkUnit(*work)
          File "/usr/local/CalDAV-7.0/CalendarServer/.develop/virtualenv/src/twextpy/twext/internet/threadutils.py", line 74, in _oneWorkUnit
            result = instruction()
          File "/usr/local/CalDAV-7.0/CalendarServer/.develop/virtualenv/src/twextpy/twext/enterprise/adbapi2.py", line 322, in <lambda>
            lambda: self._reallyExecSQL(*args, **kw)
        --- <exception caught here> ---
          File "/usr/local/CalDAV-7.0/CalendarServer/.develop/virtualenv/src/twextpy/twext/enterprise/adbapi2.py", line 246, in _reallyExecSQL
            self._cursor.execute(sql, args)
          File "/usr/local/CalDAV-7.0/CalendarServer/txdav/base/datastore/dbapiclient.py", line 83, in execute
            self.realCursor.execute(sql, args)
          File "/usr/local/CalDAV-7.0/CalendarServer/.develop/virtualenv/lib/python2.7/site-packages/pg8000/core.py", line 910, in execute
            self._c.execute(self, operation, args)
          File "/usr/local/CalDAV-7.0/CalendarServer/.develop/virtualenv/lib/python2.7/site-packages/pg8000/core.py", line 1969, in execute
            self.handle_messages(cursor)
          File "/usr/local/CalDAV-7.0/CalendarServer/.develop/virtualenv/lib/python2.7/site-packages/pg8000/core.py", line 2117, in handle_messages
            raise self.error
        pg8000.core.ProgrammingError: (u'ERROR', u'42P01', u'relation "calendarserver" does not exist', u'19', u'parse_relation.c', u'1156', u'parserOpenTable', u'', u'')

2016-01-26 02:39:48-0600 [-] [calendarserver.tap.util#error] Step failure
        Traceback (most recent call last):

         ... [lots of similar messages]

          File "/usr/local/CalDAV-7.0/CalendarServer/.develop/virtualenv/lib/python2.7/site-packages/pg8000/core.py", line 1969, in execute
            self.handle_messages(cursor)
          File "/usr/local/CalDAV-7.0/CalendarServer/.develop/virtualenv/lib/python2.7/site-packages/pg8000/core.py", line 2117, in handle_messages
            raise self.error
        pg8000.core.ProgrammingError: (u'ERROR', u'42P01', u'relation "calendarserver" does not exist', u'19', u'parse_relation.c', u'1156', u'parserOpenTable', u'', u'')

2016-01-26 02:39:48-0600 [-] [calendarserver.tap.caldav#error] Data store not available; shutting down
2016-01-26 02:39:48-0600 [-] [memcached-Default] Signal handled: Terminated: 15.
2016-01-26 02:39:48-0600 [-] (UNIX Port '/Library/CalDAV/logs/caldavd.sock' Closed)
2016-01-26 02:39:48-0600 [-] [twisted.internet.base#info] Main loop terminated.
2016-01-26 02:39:48-0600 [-] [twisted.application.app#info] Server Shut Down.

=============

This seems very wrong to me.

Perhaps it is relevant that the running PostgreSQL is version 9.5 (rather than the v. 9.3) assumed by CalendarServer?
N.B.: PostgreSQL 9.5 worked just fine with CalendarServer 5.3.