Обсуждение: Frontend coredumps on NOTICE

Hello!

This trouble has been reported to general list some time ago,
but without success. The bug is simple: frontend, written in C
(with libpq) dies with core dump on any query that returns NOTICE
from backend. Postgres 6.5 was on Pentium (currently on Cyrix MII),
gcc 2.7.2.3.  In writing my programs I took example programs from
Postgres docs as template. If you wish, I can send the code exactly.

--
Leon.

Leon <leon@udmnet.ru> writes:
> This trouble has been reported to general list some time ago,
> but without success. The bug is simple: frontend, written in C
> (with libpq) dies with core dump on any query that returns NOTICE
> from backend.

No one else is seeing this, so I feel fairly safe in betting that
it's some bug in your own code.  You didn't do something silly
like closing stderr, did you?

You might try setting a breakpoint at defaultNoticeProcessor in
fe-connect.c, and seeing whether control is getting there or not.
A stack backtrace from the core file would be helpful info as well.

            regards, tom lane

Tom Lane wrote:
>
> Leon <leon@udmnet.ru> writes:
> > This trouble has been reported to general list some time ago,
> > but without success. The bug is simple: frontend, written in C
> > (with libpq) dies with core dump on any query that returns NOTICE
> > from backend.
>
> No one else is seeing this, so I feel fairly safe in betting that
> it's some bug in your own code.  You didn't do something silly
> like closing stderr, did you?

You were right. This bug disappeared after I recompiled pq lib.
Never before have I seen such compile troubles. To be sure, I
linked libpq against Electric Fence, and it didn't ever complain.

Thank you for cooperation.

But I have one more bugreport, this time I'm sure it is real :)

--
Leon.