From: | Célestin Matte <celestin(dot)matte(at)cmatte(dot)me> |
---|---|
To: | pgsql-www(at)lists(dot)postgresql(dot)org |
Subject: | Re: [PATCH] pgarchives: Bugfix: allow message's parentid to be null |
Date: | 2021-10-26 18:31:46 |
Message-ID: | 723b45bd-0c14-83eb-1911-b4f481e1b74c@cmatte.me |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-www |
Attached: associated migration
On 25/10/2021 16:52, Célestin Matte wrote:
> Hello,
>
> Upon execution of load_messages.py, when creating a new thread, I get a crash:
> (Sorry about the format, I get this out of strace)
>
> Traceback (most recent call last):\n File \"/srv/pgarchives/local/loader/load_message.py\", lin\
> e 174, in <module>\n ap.store(conn, listid, opt.overwrite, opt.overwrite)\n File \"/srv/pgarchives/local/loader/li\
> b/storage.py\", line 232, in store\n 'rawtxt': bytearray(self.rawtxt),\npsycopg2.errors.NotNullViolation: null valu\
> e in column \"parentid\" violates not-null constraint\nDETAIL: Failing row contains (2, 2, cmatte <cmatte(at)[my_domain]\
> .tld>, helloworld(at)[my_pglister_domain], , Test archive after redeployment 2, 2021-10-25 14:13:32+00, 1635171212.3\
> 49997(dot)1068459(dot)nullmailer(at)[my_domain], hello world\n\n\n\n, null, f, null, \\x46726f6d2068656c6c6f776f726c642d6f776\
> e65722b617263686976654062..., '2':5A 'after':3A 'archive':2A 'hello':6 'redeployment':4A 'test...).\n\n
>
> I think the way to fix this is simply to allow message.parentid to be null.
>
> Cheers,
>
--
Célestin Matte
Attachment | Content-Type | Size |
---|---|---|
0002-Add-migration-associated-with-ba3852df-allow-parenti.patch | text/x-patch | 1.1 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Magnus Hagander | 2021-10-27 09:19:46 | Re: [PATCH] pgarchives: Bugfix: allow message's parentid to be null |
Previous Message | Célestin Matte | 2021-10-26 14:34:47 | [PATCH] pgweb: Add ARCHIVES_FRONT_ADDRESS to allow configuration of archives |