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

From: David Steele <david(at)pgmasters(dot)net>
To: ericv(at)xs4all(dot)net, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: pgbackrest: ERROR: [029]: unable to convert base 10 string '0000000B' to unsigned int
Date: 2020-01-23 18:38:16
Message-ID: ca12d99f-23d6-2d8d-a2b0-92fcaed7443a@pgmasters.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 1/21/20 8:45 AM, David Steele wrote:
> On 1/21/20 12:55 AM, Eric Veldhuyzen wrote:
>> 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 '0000000B' to unsigned int.
>>>> I tried if a full backup would fix this, but it didn't.
>>>
>>> Maybe I'm missing something, but 0000000*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...
>
> That's exactly what should be happening.  There has already been a bug
> filed at https://github.com/pgbackrest/pgbackrest/issues/910 and you can
> find more details there.

This issue was fixed in 2.22, released on 21 JAN.

--
-David
david(at)pgmasters(dot)net

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mike Lissner 2020-01-23 19:17:00 Re: Does converting an indexed varchar to text rewrite its index? Docs say so, tests say no.
Previous Message Adrian Klaver 2020-01-23 17:54:48 Re: Does converting an indexed varchar to text rewrite its index? Docs say so, tests say no.