| From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
|---|---|
| To: | Marcos Pegoraro <marcos(at)f10(dot)com(dot)br> |
| Cc: | Andres Freund <andres(at)anarazel(dot)de>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: bug on log generation ? |
| Date: | 2022-08-08 15:36:17 |
| Message-ID: | 3286ab1d-28de-d8f9-8e35-b160967c5074@dunslane.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 2022-08-08 Mo 11:07, Marcos Pegoraro wrote:
>
> What platform is this on? Is it possible that on some platform the
> chunk
> size we're using is not doing an atomic write?
>
>
> Until last year we were Ubuntu 16.04 and Postgres 11 with the latest
> minor update.
> This January we changed to Ubuntu 20.04 and Postgres 14, now updated
> to 14.4.
>
> But the problem occured on both old and new SO and Postgres versions.
> Right now I opened the current log file and there are 20 or 30 of
> these statements and all of them are fine, maybe tomorrow the problem
> comes back, maybe this afternoon.
>
>
OK, we really need a repeatable test if possible. Perhaps a pgbench run
with lots of concurrent runs of a some very long query would do the trick.
cheers
andrew
--
Andrew Dunstan
EDB: https://www.enterprisedb.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jacob Champion | 2022-08-08 15:37:41 | Re: [PATCH] CF app: add "Returned: Needs more interest" |
| Previous Message | Matthias van de Meent | 2022-08-08 15:33:44 | Re: Remaining case where reltuples can become distorted across multiple VACUUM operations |