pgbackrest: ERROR: [029]: unable to convert base 10 string '0000000B' to unsigned int

[Eric Veldhuyzen]

Hi,

We are using pgbackrest (2.21) to backup out postgresql (11) clusters.
Last night our nightly diff backup gave me the
ERROR: unable to convert base 10 string '000B' to unsigned int.
I tried if a full backup would fix this, but it didn't.

Luckily this was only on our development/test cluster, so it is not a real
problem, but what is going on here and what would be the best way to fix this?

The last few lines of the log (with --log-level-console=info) are:

2020-01-21 08:07:44.613 P02   INFO: backup file
ericv.dev.xs4all.net:/var/lib/postgresql/11/main/pg_xact/ (136KB, 100%)
checksum 76e273a0f888d449a540f86eacd0bb8386c49209
2020-01-21 08:07:44.614 P00   INFO: full backup size = 62.7MB
2020-01-21 08:07:44.615 P00   INFO: execute non-exclusive pg_stop_backup() and
wait for all WAL segments to archive
2020-01-21 08:07:44.917 P00   INFO: backup stop archive =
000B001500C3, lsn = 15/C3002F38
ERROR: [029]: unable to convert base 10 string '000B' to unsigned int
2020-01-21 08:07:45.448 P00   INFO: backup command end: aborted with exception 
[029]

Eric Veldhuyzen



signature.asc
Description: OpenPGP digital signature

Re: pgbackrest: ERROR: [029]: unable to convert base 10 string '0000000B' to unsigned int

[Eric Veldhuyzen]

Ron wrote:
> On 1/21/20 1:10 AM, Eric Veldhuyzen wrote:
>> Hi,
>>
>> We are using pgbackrest (2.21) to backup out postgresql (11) clusters.
>> Last night our nightly diff backup gave me the
>> ERROR: unable to convert base 10 string '000B' to unsigned int.
>> I tried if a full backup would fix this, but it didn't.
> 
> Maybe I'm missing something, but 000*B* looks *hexa*decimal, not decimal.

You're not missing something, and this is most likely also the reason that this
fails. I'm quite sure it should try to convert a base 16 string here to an
unsigned int...

Eric Veldhuyzen



signature.asc
Description: OpenPGP digital signature