| From: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
|---|---|
| To: | Tomas Pospisek <tpo2(at)sourcepole(dot)ch> |
| Cc: | pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Strange results when casting string to double |
| Date: | 2022-02-19 15:38:41 |
| Message-ID: | CAHyXU0yOfe-KOeKitic25Li8tY6+1xfVAuNeX7=iXPz9CjnMJg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sat, Feb 19, 2022 at 8:35 AM Tomas Pospisek <tpo2(at)sourcepole(dot)ch> wrote:
>
> On 18.02.22 22:42, Peter J. Holzer wrote:
>
> > If there has been a glibc update (or a postgresql update) in those 480
> > days (Ubuntu 14.04 is out of its normal maintenance period but ESM is
> > still available) the running processes may well run different code than
> > a newly started program. So it could be a bug which has since been
> > fixed.
>
> That would be visible via `lsof`. `libc. The file `...libc...so` that
> `postgres` is keeping open would have the text `DEL` (as in deleted) in
> the `FD` column of `lsof`'s output.
>
> As opposed to a newly started program which would have `REG` (regular
> file) there.
If this doesn't bear fruit, are there debugging symbols? Setting a
breakpoint might produce some insight.
merlin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Cal Mitchell | 2022-02-19 16:42:51 | Detecting schema changes via WAL logs |
| Previous Message | Tomas Pospisek | 2022-02-19 14:35:36 | Re: Strange results when casting string to double |