PostgreSQL database error following database migration

[Geovariances]

Hello and Happy New Year to everyone!

I installed a test server (DEBIAN 10) in version 2.2.6.2 and then exported my current database (via the export procedure documented on the site) in 1.8.2.
Once exported, I performed a postconf and a restoration of the database and the necessary directories.
First, my database hasn't been updated to 2.2.6.2. Is postconf supposed to do that?
Second problem: I'm getting an error starting the waptserver service. This error is related to my PostgreSQL database

Code: Select all

> Traceback (most recent call last):
  File "/opt/wapt/lib/python3.8/site-packages/peewee.py", line 3144, in execute_sql
    cursor.execute(sql, params or ())
psycopg2.errors.UndefinedColumn: column t1.user_fingerprint does not exist
LINE 1: ...od", "t1"."description", "t1"."user_certificate", "t1"."user...

How to get out of this problem?
It's a test machine but it allows me to validate an upgrade from my 1.8.2 to a 2.2.

Thank you in advance for your help.

Mickaël

[dcardon]

Hello,

Which version exactly is it? Wasn't there a version 2.2.6? The error message indicates that the database wasn't upgraded correctly.

The database is updated when the waptserver service starts. However, in older versions, this could happen silently. Could you test the latest version, 2.2.3.12485? The service startup should fail if the database upgrade doesn't go through.
Afterward, you should post the error logs here.

Sincerely,

Denis Cardon

[Geovariances]

Hello,

the WaptServer version is 2.2.3.12485 to be precise.
I'll look into upgrading it and post the logs tomorrow.

Thanks

, Mickaël

[dcardon]

Hello,

if you were already on version 2.2.3.12485, it's strange that it's crashing. Were you on the latest version, 1.8.2.7393, before upgrading?

Regards,

Denis

[Geovariances]

Hello,

if you were already on version 2.2.3.12485, it's strange that it's crashing. Were you on the latest version, 1.8.2.7393, before upgrading?

Regards,

Denis

Good morning,

No, version 1.8.2.7334 is the version of the server to be upgraded.