Re: [BUGS] BUG #14531: server process (PID 12714) was terminated bysignal 11: Segmentation fault

Поиск
Список
Период
Сортировка
От NAVEEN CHALIMETI
Тема Re: [BUGS] BUG #14531: server process (PID 12714) was terminated bysignal 11: Segmentation fault
Дата
Msg-id CAJ5kcKen3F7T55wWo3FMge_0Zb7j_VMuCMhXMfrLcTiadY+7Yw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [BUGS] BUG #14531: server process (PID 12714) was terminated by signal 11: Segmentation fault  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
We have not looked into the previous core dump. We will look into the core dumps and let u know. 

We have just installed by using the command "sudo apt-get install postgresql postgresql-contrib", nothing else options we have used. And we are using psqlodbc driver as interface with our application.


./configure  --with-unixodbc=/usr/bin  --with-libpq=/usr/lib


this is the command to configure unix odbc.

I'm not sure whether this is because of hardware or postmaster. We will try this in different machines also for sure. Our production environment is suffering from this issue for many days. I hope will get a proper reason and solution soon.

We are very pleasure to hear from you which helps me to resolve this as soon as possible.

Regards,
Naveen Chalmeti

On Tue, Feb 7, 2017 at 12:30 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
NAVEEN CHALIMETI <naveenallin@gmail.com> writes:
> Thanks for your reply firstly.
> I did not mention anything about logs thinking the back trace would be
> enough to solve the issue. Sorry for that.
> I have enabled the *log_statement=all* already and each time it gives
> different queries. But until now i have seen postmaster crashed during
> SELECT query.
> ...
> The crash is reproducible with different queries.

Hm.  Have you looked at more than one core dump?  Is it always the same
backtrace?

Those queries don't look particularly exciting, so I'm now thinking the
problem is something unusual.  Do you have any nondefault extensions
installed?  Maybe you built the server with some unusual options?

I dislike blaming hardware problems, but we shouldn't rule out that
possibility either, unless you're seeing this on more than one machine.

                        regards, tom lane

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: [BUGS] BUG #14526: no unique or exclusion constraint matching theON CONFLICT
Следующее
От: totocrenn@gmail.com
Дата:
Сообщение: [BUGS] BUG #14535: SET search_path and list tables