Update 1.8.2.7321 and a problem in the database

[corriou]

Good morning,

I have been using WAPT for a few years and I have never had a major problem (that I could not solve on my own or almost) until today during the updates.
This morning I was using version 1.8.2.7267 Community and after the update, I should have switched to the latest 1.8.2.7321. A small step for me, a giant leap for my database apparently.
Additional details: Server OS Debian 10.6, Administration/package creation machine OS Windows 10 20H2 (in short, I update regularly).

After the update, I ended up with a lot of lines like the following:

Code: Select all

Nov 26 14:38:39 wapt waptserver[39655]: 2020-11-26 14:38:39,890 [waptserver     ] CRITICAL Trying to upgrade database structure, error was : ProgrammingError('relation "hostsyncstatus" does not exist\nLINE 1: DELETE FROM hostsyncstatus WHERE hostsyncstatus.uuid = OLD.u...\n                    ^\nQUERY:  DELETE FROM hostsyncstatus WHERE hostsyncstatus.uuid = OLD.uuid\nCONTEXT:  PL/pgSQL function update_host_sync_status() line 14 at SQL statement\n',)

And my server has of course become unreachable with a 502 Bad Gateway error.

<mode flemme>I confess that I haven't gotten my hands dirty yet, figuring that someone would probably have a ready-made solution.</mode flemme>

If you have any ideas on how to fix the problem, I'm all ears.
Sincerely,
Alain

[htouvet]

Can you try the package that is in

https://wapt.tranquil.it/wapt/nightly/w ... 6-48828327

Fixes:

* fix extract CN from ssl client cert authentication for get_auth_token…
* fix regression on wakeonlan introduced by backported code from 1.9
* [FIX] PostgreSQL DB not correctly migrating from some 1.8.1.X

[corriou]

Hello,

Yes, the problem has indeed been resolved thanks to this nightly update (a nightly update is rather paradoxical ).
In any case, thank you for your speed and efficiency.

I will miss the Community version of WAPT. I admit I didn't have the time (or sometimes the knowledge) to contribute to it, but given the services it provided, I hope the future Discovery version will offer the same level of service.

Sincerely and with many thanks,
Alain

[Valentin Ficis]

I will miss the Community version of WAPT. I admit I didn't have the time (or sometimes the knowledge) to contribute to it, but given the services it provided, I hope the future Discovery version will offer the same level of service.

Hello Alain,
You probably read cbarille's message a little too quickly:

WAPT Community 1.8.2 will not disappear, but you will simply become masters of this version and its development.

If you find the time, in the future it will always be possible to contribute to the Community version and I would be very happy!