El día lunes, abril 26, 2021 a las 07:38:40a. m. +0200, Matthias Apitz escribió:
> Having solved this issue, one last question: Is there any good way for a
> C-written or ESQL/C-written client to get the local port number or even
> the PID of the PostgreSQL server process on the other end of the
>
El día domingo, abril 25, 2021 a las 01:54:49p. m. +0200, Matthias Apitz
escribió:
...
> # select * from pg_stat_activity where client_port = 52288;
>
> datid | datname | pid | leader_pid | usesysid | usename |
> application_name | client_addr | client_hostname | client_port
El día domingo, abril 25, 2021 a las 08:05:21p. m. +0200, Karsten Hilbert
escribió:
> > > > The serverlog has around this time (sorry for German):
> > > >
> > > > 2021-04-23 05:55:23.591 CEST [2317] LOG: unvollständige Message vom
> > > > Client
>
> "incomplete message from client"
>
>
On Sun, Apr 25, 2021 at 11:27 AM Adrian Klaver
wrote:
>
> On 4/25/21 5:28 AM, Malik Rumi wrote:
> > Greetings.
> >
> > I am about to do a long overdue upgrade to the latest version, which I
> > believe is 13.2. However, I have full text search in my current install
> > (9.4) and I am wondering if
Karsten Hilbert writes:
> Am Sun, Apr 25, 2021 at 01:21:25PM -0400 schrieb Tom Lane:
>> Still, the apparent message length is then "RP-2" (0x52502d32)
>> which is bigger than 1GB so I don't quite understand why you didn't
>> get an "out of memory" error.
> But he did, didn't he ?
Those log messa
Am Sun, Apr 25, 2021 at 01:21:25PM -0400 schrieb Tom Lane:
> > 10:57:16.051326 IP 127.0.0.1.52288 > 127.0.0.1.5432: Flags [P.], seq
> > 14280:14407, ack 120304, win 512, options [nop,nop,TS val 3424445708 ecr
> > 3424445708], length 127
> > 0x: 4500 00b3 b84e 4000 4006 83f4 7f00 000
Matthias Apitz writes:
> El día domingo, abril 25, 2021 a las 11:51:45a. m. -0400, Tom Lane escribió:
>> Hmph. So why wasn't this visible in the tcpdump trace?
> It was visible. That's why I detected it while looking up the TCP
> packages before the UPDATE:
> 10:57:16.051326 IP 127.0.0.1.52288
El día domingo, abril 25, 2021 a las 11:51:45a. m. -0400, Tom Lane escribió:
> Matthias Apitz writes:
> > At the end of the day, it turned out that out client caused the problem.
> > Because we were hunting some other issue, the client was logging some
> > message with fprintf(stderr, ...) but th
Matthias Apitz writes:
> At the end of the day, it turned out that out client caused the problem.
> Because we were hunting some other issue, the client was logging some
> message with fprintf(stderr, ...) but the fd=2 was not stderr, fd=2 was the
> connection to the socket of the PostgreSQL serve
El día domingo, abril 25, 2021 a las 01:54:49p. m. +0200, Matthias Apitz
escribió:
>From the collected data, I tend to say: this must be a bug in the Pos
> server...
>
At the end of the day, it turned out that out client caused the problem.
Because we were hunting some other issue, the client
On 4/25/21 5:28 AM, Malik Rumi wrote:
Greetings.
I am about to do a long overdue upgrade to the latest version, which I
believe is 13.2. However, I have full text search in my current install
(9.4) and I am wondering if there are any special provisions I need to
take to make sure that is not
Greetings.
I am about to do a long overdue upgrade to the latest version, which I
believe is 13.2. However, I have full text search in my current install
(9.4) and I am wondering if there are any special provisions I need to take
to make sure that is not lost in the transition? If this would be t
El día viernes, abril 23, 2021 a las 11:32:02a. m. +0200, Matthias Apitz
escribió:
> El día viernes, abril 23, 2021 a las 10:48:24a. m. +0200, Laurenz Albe
> escribió:
>
> > > The serverlog has around this time (sorry for German):
> > >
> > > 2021-04-23 05:55:23.591 CEST [2317] LOG: unvollstä
13 matches
Mail list logo
