Upgrade to 19.2.4 on PostgreSQL is broken

[Andreas Rogge]

Hi Everybody,

we have a bad bug in 19.2.4[1]. Due to this it is currently not possible
to upgrade your PostgreSQL catalog with the supplied scripts.
Philipp added commit 40f7e9b[2] that reduces the amount of text that is
output during installation and upgrade. That patch included this bug as
a regression.

You current options are:
- install 19.2.4~rc1 and then upgrade to 19.2.4
- apply the changes in PR #405 [2] to work around the issue
- wait to 19.2.5 to appear in the repositories

We will release 19.2.5 shortly and will provide binary packages for
19.2.5 on download.bareos.org and download.bareos.com.

Best Regards,
Andreas

[1] https://bugs.bareos.org/view.php?id=1172
[2]
https://github.com/bareos/bareos/commit/40f7e9b455891224c9d67ba0e4e22e5ad41b43cf
[3]
https://github.com/bareos/bareos/pull/405/commits/9423b98f3dd090eb8f285f6d8cb4c49af5c30949

--
Andreas Rogge andrea...@bareos.com
Bareos GmbH & Co. KG Phone: +49 221-630693-86
http://www.bareos.com

Sitz der Gesellschaft: Köln | Amtsgericht Köln: HRA 29646
Komplementär: Bareos Verwaltungs-GmbH
Geschäftsführer: S. Dühr, M. Außendorf, J. Steffens, Philipp Storz

[Chad William Seys]

Thanks for the heads up Andreas!
C.

[Andreas Rogge]

Hello Everybody,

the problem has been fixed in branches master and bareos-19.2.
We have released Bareos 19.2.5 to address this issue. The binary
packages are building right now and will be available soon.

We also created PR #406[1] that will add a systemtest that checks the
database upgrade scripts actually work.

Best Regards,
Andreas

[1] https://github.com/bareos/bareos/pull/406/

[fon...@web.de]

Hi Andreas,

 

when I performed "apt update && apt upgrade" today (of course before(!) I read your message...), I got these messages:

 

error encountered backing up the old database:
psql: FATAL: password authentication failed for user "bareos" password retrieved from file "/tmp/dbconfig-common.psql_home.hG1tyz/.pgpass" FATAL: password authentication failed for user "bareos" password retrieved from file "/tmp/dbconfig-common.psql_home.hG1tyz/.pgpass"
dbconfig-common: bareos-database-common configure: ignoring errors from here forwards

 

Now the connection to the director fails ("Failed to connect to Director. Giving up.").

 

Are these messages related to the bug you mentioned? Is there any possibility to repair it?

 

Regards,

Carsten

 

 

Gesendet: Montag, 03. Februar 2020 um 15:28 Uhr
Von: "Andreas Rogge" <andrea...@bareos.com>
An: bareos...@googlegroups.com
Betreff: [bareos-users] Upgrade to 19.2.4 on PostgreSQL is broken

--
You received this message because you are subscribed to the Google Groups "bareos-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to bareos-users...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/bareos-users/c6906eb8-9ad2-6c5f-27ca-2a03d9374fbc%40bareos.com.

 

 

[Andreas Rogge]

Hi Carsten,

at this point your best bet is probably to disable dbconfig-common for
bareos (I'm not completely sure how to do that) and then upgrade to
19.2.5 which will allow you to upgrade using the fixed update script.

The issue you're facing there looks like you (or someone else) changed
the password for the bareos user to something that doesn't match with
what dbconfig-common expects. But then again I'm not really into Debian,
so my knowledge of dbconfig-common is very limited.

Hope that helps anyway.

Best Regards,
Andreas

Am 03.02.20 um 18:16 schrieb fon...@web.de:

> Hi Andreas,
>  
> when I performed "apt update && apt upgrade" today (of course before(!)
> I read your message...), I got these messages:
>  
> error encountered backing up the old database:
> psql: FATAL: password authentication failed for user "bareos" password
> retrieved from file "/tmp/dbconfig-common.psql_home.hG1tyz/.pgpass"
> FATAL: password authentication failed for user "bareos" password
> retrieved from file "/tmp/dbconfig-common.psql_home.hG1tyz/.pgpass"
> dbconfig-common: bareos-database-common configure: ignoring errors from
> here forwards
>  
> Now the connection to the director fails ("Failed to connect to
> Director. Giving up.").
>  
> Are these messages related to the bug you mentioned? Is there any
> possibility to repair it?
>  
> Regards,
> Carsten
>  
>  

> *Gesendet:* Montag, 03. Februar 2020 um 15:28 Uhr
> *Von:* "Andreas Rogge" <andrea...@bareos.com>
> *An:* bareos...@googlegroups.com
> *Betreff:* [bareos-users] Upgrade to 19.2.4 on PostgreSQL is broken

> <mailto:bareos-users...@googlegroups.com>.

> To view this discussion on the web visit

> https://groups.google.com/d/msgid/bareos-users/trinity-137032d7-a6e2-4a94-987d-d97f45690ffd-1580750204941%403c-app-webde-bap07
> <https://groups.google.com/d/msgid/bareos-users/trinity-137032d7-a6e2-4a94-987d-d97f45690ffd-1580750204941%403c-app-webde-bap07?utm_medium=email&utm_source=footer>.

[Andreas Rogge]

Hi Everybody,

bareos 19.2.5 was just synced to the mirrors. The upgrade-problem is
fixed there.
Sorry for the inconvenience.

Best Regards,
Andreas