Postgresql create a core while trying log a message to syslog

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

Postgresql create a core while trying log a message to syslog

Demarest, Jamie

 

 

Red Hat Enterprise Linux Server release 7.2 (Maipo)

postgres (PostgreSQL) 9.5.4

 

psql logging has been set up to log to syslog.  When the syslog directory filled up psql trying to log to syslog cause psql to core.

 

Reading symbols from /opt/rh/rh-postgresql95/root/usr/bin/postgres...Reading symbols from /opt/rh/rh-postgresql95/root/usr/bin/postgres...(no debugging symbols found)...done.

(no debugging symbols found)...done.

[New LWP 7949]

[Thread debugging using libthread_db enabled]

Using host libthread_db library "/lib64/libthread_db.so.1".

Core was generated by `postgres: startup process   recovering 000000050000000000000017      '.

Program terminated with signal 6, Aborted.

#0  0x00007f385ebaf5f7 in raise () from /lib64/libc.so.6

Missing separate debuginfos, use: debuginfo-install rh-postgresql95-postgresql-server-9.5.4-1.el7.x86_64

(gdb) bt

#0  0x00007f385ebaf5f7 in raise () from /lib64/libc.so.6

#1  0x00007f385ebb0ce8 in abort () from /lib64/libc.so.6

#2  0x0000000000797058 in errfinish ()

#3  0x000000000079aa38 in elog_finish ()

#4  0x0000000000495db4 in heap_xlog_update ()

#5  0x000000000049d1af in heap_redo ()

#6  0x00000000004d8117 in StartupXLOG ()

#7  0x00000000006563c2 in StartupProcessMain ()

#8  0x00000000004e4e8a in AuxiliaryProcessMain ()

#9  0x0000000000653800 in StartChildProcess ()

#10 0x0000000000655e44 in PostmasterMain ()

#11 0x0000000000469d3e in main ()

 

Core file can be supplied.

 

Thanks You,

Jamie Demarest

Saab Sensis Corporation

 

 

 


This message is intended only for the addressee and may contain information that is company confidential or privileged. Any technical data in this message may be exported only in accordance with the U.S. International Traffic in Arms Regulations (22 CFR Parts 120-130) or the Export Administration Regulations (15 CFR Parts 730-774). Unauthorized use is strictly prohibited and may be unlawful. If you are not the intended recipient, or the person responsible for delivering to the intended recipient, you should not read, copy, disclose or otherwise use this message. If you have received this email in error, please delete it, and advise the sender immediately.
Reply | Threaded
Open this post in threaded view
|

Re: Postgresql create a core while trying log a message to syslog

Alvaro Herrera-9
On 2020-Mar-11, Demarest, Jamie wrote:

> psql logging has been set up to log to syslog.  When the syslog directory filled up psql trying to log to syslog cause psql to core.
>
> Reading symbols from /opt/rh/rh-postgresql95/root/usr/bin/postgres...Reading symbols from /opt/rh/rh-postgresql95/root/usr/bin/postgres...(no debugging symbols found)...done.
> (no debugging symbols found)...done.
> [New LWP 7949]
> [Thread debugging using libthread_db enabled]
> Using host libthread_db library "/lib64/libthread_db.so.1".
> Core was generated by `postgres: startup process   recovering 000000050000000000000017      '.
> Program terminated with signal 6, Aborted.
> #0  0x00007f385ebaf5f7 in raise () from /lib64/libc.so.6
> Missing separate debuginfos, use: debuginfo-install rh-postgresql95-postgresql-server-9.5.4-1.el7.x86_64
> (gdb) bt
> #0  0x00007f385ebaf5f7 in raise () from /lib64/libc.so.6
> #1  0x00007f385ebb0ce8 in abort () from /lib64/libc.so.6
> #2  0x0000000000797058 in errfinish ()
> #3  0x000000000079aa38 in elog_finish ()
> #4  0x0000000000495db4 in heap_xlog_update ()
> #5  0x000000000049d1af in heap_redo ()
> #6  0x00000000004d8117 in StartupXLOG ()

Hmm.  Please install debuginfo and get the backtrace again, as
instructed:

debuginfo-install rh-postgresql95-postgresql-server-9.5.4-1.el7.x86_64

Thanks

--
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


Reply | Threaded
Open this post in threaded view
|

Re: Postgresql create a core while trying log a message to syslog

Tom Lane-2
In reply to this post by Demarest, Jamie
"Demarest, Jamie" <[hidden email]> writes:
> psql logging has been set up to log to syslog.  When the syslog directory filled up psql trying to log to syslog cause psql to core.

This looks more like a PANIC due to corrupt data than what you're
claiming the cause is.  I wonder whether the out-of-disk-space
problem had affected previous attempts to write to WAL.

                        regards, tom lane


Reply | Threaded
Open this post in threaded view
|

RE: Postgresql create a core while trying log a message to syslog

Demarest, Jamie
In reply to this post by Alvaro Herrera-9
Alvaro,

Thank you for the quick response I am working with my team to get the debug installed so we can recreate the backtrace.


Thanks,
Jamie

-----Original Message-----
From: Alvaro Herrera [mailto:[hidden email]]
Sent: Thursday, March 12, 2020 8:27 AM
To: Demarest, Jamie
Cc: [hidden email]; Tamayo, Cristofer; Cornman, Melody
Subject: Re: Postgresql create a core while trying log a message to syslog

[ EXTERNAL EMAIL ]



On 2020-Mar-11, Demarest, Jamie wrote:

> psql logging has been set up to log to syslog.  When the syslog directory filled up psql trying to log to syslog cause psql to core.
>
> Reading symbols from /opt/rh/rh-postgresql95/root/usr/bin/postgres...Reading symbols from /opt/rh/rh-postgresql95/root/usr/bin/postgres...(no debugging symbols found)...done.
> (no debugging symbols found)...done.
> [New LWP 7949]
> [Thread debugging using libthread_db enabled] Using host libthread_db
> library "/lib64/libthread_db.so.1".
> Core was generated by `postgres: startup process   recovering 000000050000000000000017      '.
> Program terminated with signal 6, Aborted.
> #0  0x00007f385ebaf5f7 in raise () from /lib64/libc.so.6 Missing
> separate debuginfos, use: debuginfo-install
> rh-postgresql95-postgresql-server-9.5.4-1.el7.x86_64
> (gdb) bt
> #0  0x00007f385ebaf5f7 in raise () from /lib64/libc.so.6
> #1  0x00007f385ebb0ce8 in abort () from /lib64/libc.so.6
> #2  0x0000000000797058 in errfinish ()
> #3  0x000000000079aa38 in elog_finish ()
> #4  0x0000000000495db4 in heap_xlog_update ()
> #5  0x000000000049d1af in heap_redo ()
> #6  0x00000000004d8117 in StartupXLOG ()

Hmm.  Please install debuginfo and get the backtrace again, as
instructed:

debuginfo-install rh-postgresql95-postgresql-server-9.5.4-1.el7.x86_64

Thanks

--
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
-
This message is intended only for the addressee and may contain information that is company confidential or privileged.  Any technical data in this message may be exported only in accordance with the U.S. International Traffic in Arms Regulations (22 CFR Parts 120-130) or the Export Administration Regulations (15 CFR Parts 730-774). Unauthorized use is strictly prohibited and may be unlawful. If you are not the intended recipient, or the person responsible for delivering to the intended recipient, you should not read, copy, disclose or otherwise use this message. If you have received this email in error, please delete it, and advise the sender immediately.
-          

Reply | Threaded
Open this post in threaded view
|

RE: Postgresql create a core while trying log a message to syslog

Demarest, Jamie
In reply to this post by Alvaro Herrera-9
Alvaro,

Did you mean debuginfo-install rh-postgresql95-postgresql-server-9.5.4-1.el7.x86_64 of debuginfo-install rh-postgresql95-postgresql-debuginfo-9.5.14-1.el7.x86_64.rpm

Thank you,
Jamie Demarest

-----Original Message-----
From: Alvaro Herrera [mailto:[hidden email]]
Sent: Thursday, March 12, 2020 8:27 AM
To: Demarest, Jamie
Cc: [hidden email]; Tamayo, Cristofer; Cornman, Melody
Subject: Re: Postgresql create a core while trying log a message to syslog

[ EXTERNAL EMAIL ]



On 2020-Mar-11, Demarest, Jamie wrote:

> psql logging has been set up to log to syslog.  When the syslog directory filled up psql trying to log to syslog cause psql to core.
>
> Reading symbols from /opt/rh/rh-postgresql95/root/usr/bin/postgres...Reading symbols from /opt/rh/rh-postgresql95/root/usr/bin/postgres...(no debugging symbols found)...done.
> (no debugging symbols found)...done.
> [New LWP 7949]
> [Thread debugging using libthread_db enabled] Using host libthread_db
> library "/lib64/libthread_db.so.1".
> Core was generated by `postgres: startup process   recovering 000000050000000000000017      '.
> Program terminated with signal 6, Aborted.
> #0  0x00007f385ebaf5f7 in raise () from /lib64/libc.so.6 Missing
> separate debuginfos, use: debuginfo-install
> rh-postgresql95-postgresql-server-9.5.4-1.el7.x86_64
> (gdb) bt
> #0  0x00007f385ebaf5f7 in raise () from /lib64/libc.so.6
> #1  0x00007f385ebb0ce8 in abort () from /lib64/libc.so.6
> #2  0x0000000000797058 in errfinish ()
> #3  0x000000000079aa38 in elog_finish ()
> #4  0x0000000000495db4 in heap_xlog_update ()
> #5  0x000000000049d1af in heap_redo ()
> #6  0x00000000004d8117 in StartupXLOG ()

Hmm.  Please install debuginfo and get the backtrace again, as
instructed:

debuginfo-install rh-postgresql95-postgresql-server-9.5.4-1.el7.x86_64

Thanks

--
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
-
This message is intended only for the addressee and may contain information that is company confidential or privileged.  Any technical data in this message may be exported only in accordance with the U.S. International Traffic in Arms Regulations (22 CFR Parts 120-130) or the Export Administration Regulations (15 CFR Parts 730-774). Unauthorized use is strictly prohibited and may be unlawful. If you are not the intended recipient, or the person responsible for delivering to the intended recipient, you should not read, copy, disclose or otherwise use this message. If you have received this email in error, please delete it, and advise the sender immediately.
-          

Reply | Threaded
Open this post in threaded view
|

Re: Postgresql create a core while trying log a message to syslog

Alvaro Herrera-9
Jamie,

On 2020-Mar-19, Demarest, Jamie wrote:

> Did you mean debuginfo-install rh-postgresql95-postgresql-server-9.5.4-1.el7.x86_64 of debuginfo-install rh-postgresql95-postgresql-debuginfo-9.5.14-1.el7.x86_64.rpm

I merely copied the exact line that GDB gave you, which presumably
matches the executable package you already have installed.  If you try
to use a debuginfo package that does not *exactly* match the executable
you're running, it's going to give a bogus backtrace, if it gives
anything at all.

> This message is intended only for the addressee and may contain
> information that is company confidential or privileged.  Any technical
> data in this message may be exported only in accordance with the U.S.
> International Traffic in Arms Regulations (22 CFR Parts 120-130) or
> the Export Administration Regulations (15 CFR Parts 730-774).
> Unauthorized use is strictly prohibited and may be unlawful. If you
> are not the intended recipient, or the person responsible for
> delivering to the intended recipient, you should not read, copy,
> disclose or otherwise use this message. If you have received this
> email in error, please delete it, and advise the sender immediately.

*shudder*  This is not a good thing to be posting to a public mailing
list, you know?

--
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services