[SOLVED] PC appears disconnected since update to 2.2

[dcardon]

What version of PostgreSQL is currently running (not the installed versions)?

Code: Select all

sudo -u postgres psql template1 -c "SELECT version();"

Could you retrieve the exception corresponding to the error returned ("ERROR: syntax error on or near...") in /var/log/waptserver.log.

By the way, it seems your server is installed in a French locale, which doesn't meet the documentation requirements... It's not best practice...

Sincerely,

Denis

[Alex]

- The version is PostgreSQL 9.4.19

- Here's what I retrieved from the logs:

Code: Select all

Jul  3 00:04:05 EOS waptserver[1047]: 2022-07-03 00:04:05,930 [waptserver     ] CRITICAL Get_websocket_auth_token failed ProgrammingError("ERREUR:  erreur de syntaxe sur ou près de « ON »\nLINE 1: ...519b9b0-d697-11e7-8d03-000c2954dc5e', 1656799445) ON CONFLIC...\n                                                             ^\n")
Jul  3 00:04:06 EOS waptserver[1047]: 2022-07-03 00:04:06,936 [waptserver     ] CRITICAL Get_websocket_auth_token failed ProgrammingError("ERREUR:  erreur de syntaxe sur ou près de « ON »\nLINE 1: ...519b9b0-d697-11e7-8d03-000c2954dc5e', 1656799446) ON CONFLIC...\n                                                             ^\n")
Jul  3 00:04:07 EOS waptserver[1047]: 2022-07-03 00:04:07,399 [waptdb         ] CRITICAL Unable to update installed_softwares for 4C4C4544-0053-5210-804C-B6C04F32344A: ProgrammingError: ERREUR:  erreur de syntaxe sur ou près de « on »
Jul  3 00:04:07 EOS waptserver[1047]: LINE 3:               on conflict (host_id,software_id) do update

- Regarding the language, I just switched back to LANG=en_US.UTF-8

[dcardon]

You need at least PostgreSQL 9.6. Please upgrade PostgreSQL (by default, Debian installs the new version during a major distribution upgrade but doesn't switch over and keeps the old version in production on port 5432).

Regards,

Denis

[Alex]

Like this?

Code: Select all

9.4 main    5432 online postgres /var/lib/postgresql/9.4/main /var/log/postgresql/postgresql-9.4-main.log
11  main    5433 online postgres /var/lib/postgresql/11/main  /var/log/postgresql/postgresql-11-main.log

But that doesn't change anything... is there a specific procedure to follow?

[dcardon]

The problem doesn't depend on wapt, but on the Debian upgrade process. You need to use the `pg_upgradecluster` command to update the data to version 11.

You can refer to:

https://gist.github.com/dmitrykustov/27 ... c830910019.

At the end of the process, it should be PostgreSQL 11 listening on port 5432 with the wapt database, and you can then remove the PostgreSQL 9.4 packages.

Denis

[Alex]

Ah, after that, it's much better! The upgraded machines are now showing as OK!

Thank you so much.
Have a good day.

[dcardon]

Okay, good news. So the problem was that the Postgres database hadn't been upgraded during the Debian distribution upgrade. As a reminder, you need Postgres version 9.6 or higher to run the WAPT server.

I'm marking this as resolved.

Regards,

Denis