[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-general
Subject: Re: Troubleshooting a segfault and instance crash
From: Blair Boadway <bboadway () abebooks ! com>
Date: 2018-03-27 22:47:54
Message-ID: 616D192F-6ACA-49B7-A5F5-0D853E6FD001 () abebooks ! com
[Download RAW message or body]
[Attachment #2 (text/plain)]
As a follow up, we've been able to get the same back trace implicating pg_hint_plan \
from 2 separate crashes. We were using pg_hint_plan 1.2.2--we reported the issue to \
pg_hint_plan github. We've removed pg_hint_plan and it looks like the system will no \
longer segfault under the same conditions. This strongly suggests pg_hint_plan was \
the root cause of our issue but we can't yet be 100% certain as the issue was always \
transient.
-Blair
From: Pavel Stehule <pavel.stehule@gmail.com>
Date: Saturday, March 24, 2018 at 9:18 PM
To: Blair Boadway <bboadway@abebooks.com>
Cc: Peter Geoghegan <pg@bowt.ie>, "pgsql-general@postgresql.org" \
<pgsql-general@postgresql.org>
Subject: Re: Troubleshooting a segfault and instance crash
2018-03-25 0:41 GMT+01:00 Blair Boadway \
<bboadway@abebooks.com<mailto:bboadway@abebooks.com>>: Thanks for the tip. We are \
using RHEL 6.9 and definitely up to date on glibc (2.12-1.209.el6_9.2). We also have \
the same versions on a very similar system with no segfault.
My colleague got a better backtrace that shows another extension
Core was generated by `postgres: batch_user_account''.
Program terminated with signal 11, Segmentation fault.
#0 0x000000386712868a in __strcmp_sse42 () from /lib64/libc.so.6
Missing separate debuginfos, use: debuginfo-install \
postgresql96-server-9.6.5-1PGDG.rhel6.x86_64 (gdb) bt
#0 0x000000386712868a in __strcmp_sse42 () from /lib64/libc.so.6
#1 0x00007fa3f0c7074c in get_query_string (pstate=<value optimized out>, query=<value \
optimized out>, jumblequery=<value optimized out>) at pg_hint_plan.c:1882 #2 \
0x00007fa3f0c70a5d in pg_hint_plan_post_parse_analyze (pstate=0x25324b8, \
query=0x25325e8) at pg_hint_plan.c:2875 #3 0x00000000005203bc in parse_analyze ()
#4 0x00000000006df933 in pg_analyze_and_rewrite ()
#5 0x00000000007c6f6b in ?? ()
#6 0x00000000007c6ff0 in CachedPlanGetTargetList ()
#7 0x00000000006e173a in PostgresMain ()
#8 0x00000000006812f5 in PostmasterMain ()
#9 0x0000000000609278 in main ().
We aren't sure if this indicates that pg_hint_plan is causing the segfault or if it \
happened to be doing something when the segfault occurred. We aren't actually using \
pg_hint_plan hints in this system so we're not sure how all this relates to segfault \
when another process does a ‘grant usage on schema abc to user xyz;' unrelated to \
the account segfaulting.
although you don't use pg_hint_plan explicitly, pg_hint_plan is active - it is active \
via planner callbacks
Short of better ideas, we will pull the pg_hint_plan extension and see if that \
removes the problem.
please, try to report this back trace to pg_hint_plan authors.
Regards
Pavel
-Blair
From: Peter Geoghegan <pg@bowt.ie<mailto:pg@bowt.ie>>
Date: Saturday, March 24, 2018 at 4:18 PM
To: Blair Boadway <bboadway@abebooks.com<mailto:bboadway@abebooks.com>>
Cc: "pgsql-general@postgresql.org<mailto:pgsql-general@postgresql.org>" \
<pgsql-general@postgresql.org<mailto:pgsql-general@postgresql.org>>
Subject: Re: Troubleshooting a segfault and instance crash
On Thu, Mar 8, 2018 at 9:40 AM, Blair Boadway \
<bboadway@abebooks.com<mailto:bboadway@abebooks.com>> wrote:
Mar 7 14:46:35 pgprod2 kernel:postgres[29351]: segfault at 0 ip
000000302f32868a sp 00007ffcf1547498 error 4 in
libc-2.12.so<http://libc-2.12.so>[302f200000+18a000]
Mar 7 14:46:35 pgprod2 POSTGRES[21262]: [5] user=,db=,app=client= LOG:
server process (PID 29351) was terminated by signal 11: Segmentation fault
It crashes the database, though it starts again on its own without any
apparent issues. This has happened 3 times in 2 months and each time the
segfault error and memory address is the same.
We had a recent report of a segfault on a Redhat compatible system,
that seemed like it might originate from within its glibc [1].
Although all the versions there didn't match what you have, it's worth
considering as a possibility.
Maybe you can't install debuginfo packages because you don't yet have
the necessary debuginfo repos set up. Just a guess. That is sometimes
a required extra step.
[1] https://postgr.es/m/7369.1520528405@sss.pgh.pa.us
--
Peter Geoghegan
[Attachment #3 (text/html)]
<html xmlns:o="urn:schemas-microsoft-com:office:office" \
xmlns:w="urn:schemas-microsoft-com:office:word" \
xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" \
xmlns="http://www.w3.org/TR/REC-html40"> <head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style>
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal">As a follow up, we've been able to get the same back trace \
implicating pg_hint_plan from 2 separate crashes. We were using pg_hint_plan \
1.2.2--we reported the issue to pg_hint_plan github. We've removed pg_hint_plan \
and it looks like the system will no longer segfault under the same \
conditions. This strongly suggests pg_hint_plan was the root cause of our issue \
but we can't yet be 100% certain as the issue was always transient.<o:p></o:p></p> <p \
class="MsoNormal"><o:p> </o:p></p> <p class="MsoNormal">-Blair<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:12.0pt;color:black">From: \
</span></b><span style="font-size:12.0pt;color:black">Pavel Stehule \
<pavel.stehule@gmail.com><br> <b>Date: </b>Saturday, March 24, 2018 at 9:18 \
PM<br> <b>To: </b>Blair Boadway <bboadway@abebooks.com><br>
<b>Cc: </b>Peter Geoghegan <pg@bowt.ie>, \
"pgsql-general@postgresql.org" <pgsql-general@postgresql.org><br> \
<b>Subject: </b>Re: Troubleshooting a segfault and instance \
crash<o:p></o:p></span></p> </div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><a name="_MailOriginalBody"><o:p> </o:p></a></p>
<div>
<p class="MsoNormal"><span \
style="mso-bookmark:_MailOriginalBody"><o:p> </o:p></span></p> <div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody">2018-03-25 0:41 \
GMT+01:00 Blair Boadway <</span><a href="mailto:bboadway@abebooks.com" \
target="_blank"><span \
style="mso-bookmark:_MailOriginalBody">bboadway@abebooks.com</span><span \
style="mso-bookmark:_MailOriginalBody"></span></a><span \
style="mso-bookmark:_MailOriginalBody">>:<o:p></o:p></span></p> <blockquote \
style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in \
6.0pt;margin-left:4.8pt;margin-right:0in"> <div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span \
style="mso-bookmark:_MailOriginalBody">Thanks for the tip. We are using RHEL \
6.9 and definitely up to date on glibc (2.12-1.209.el6_9.2). We also have the \
same versions on a very similar system with no segfault.<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span \
style="mso-bookmark:_MailOriginalBody"> <o:p></o:p></span></p> <p \
class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span \
style="mso-bookmark:_MailOriginalBody">My colleague got a better backtrace that shows \
another extension <o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span \
style="mso-bookmark:_MailOriginalBody"> <o:p></o:p></span></p> <p \
class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span \
style="mso-bookmark:_MailOriginalBody">Core was generated by `postgres: \
batch_user_account''.<o:p></o:p></span></p> <p class="MsoNormal" \
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span \
style="mso-bookmark:_MailOriginalBody">Program terminated with signal 11, \
Segmentation fault.<o:p></o:p></span></p> <p class="MsoNormal" \
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span \
style="mso-bookmark:_MailOriginalBody">#0 0x000000386712868a in __strcmp_sse42 () \
from /lib64/libc.so.6<o:p></o:p></span></p> <p class="MsoNormal" \
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span \
style="mso-bookmark:_MailOriginalBody">Missing separate debuginfos, use: \
debuginfo-install postgresql96-server-9.6.5-1PGDG.rhel6.x86_64<o:p></o:p></span></p> \
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span \
style="mso-bookmark:_MailOriginalBody">(gdb) bt<o:p></o:p></span></p> <p \
class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span \
style="mso-bookmark:_MailOriginalBody">#0 0x000000386712868a in __strcmp_sse42 () \
from /lib64/libc.so.6<o:p></o:p></span></p> <p class="MsoNormal" \
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span \
style="mso-bookmark:_MailOriginalBody">#1 0x00007fa3f0c7074c in get_query_string \
(pstate=<value optimized out>, query=<value optimized out>, \
jumblequery=<value optimized out>) at \
pg_hint_plan.c:1882<o:p></o:p></span></p> <p class="MsoNormal" \
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span \
style="mso-bookmark:_MailOriginalBody">#2 0x00007fa3f0c70a5d in \
pg_hint_plan_post_parse_analyze (pstate=0x25324b8, query=0x25325e8) at \
pg_hint_plan.c:2875<o:p></o:p></span></p> <p class="MsoNormal" \
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span \
style="mso-bookmark:_MailOriginalBody">#3 0x00000000005203bc in parse_analyze \
()<o:p></o:p></span></p> <p class="MsoNormal" \
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span \
style="mso-bookmark:_MailOriginalBody">#4 0x00000000006df933 in \
pg_analyze_and_rewrite ()<o:p></o:p></span></p> <p class="MsoNormal" \
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span \
style="mso-bookmark:_MailOriginalBody">#5 0x00000000007c6f6b in ?? \
()<o:p></o:p></span></p> <p class="MsoNormal" \
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span \
style="mso-bookmark:_MailOriginalBody">#6 0x00000000007c6ff0 in \
CachedPlanGetTargetList ()<o:p></o:p></span></p> <p class="MsoNormal" \
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span \
style="mso-bookmark:_MailOriginalBody">#7 0x00000000006e173a in PostgresMain \
()<o:p></o:p></span></p> <p class="MsoNormal" \
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span \
style="mso-bookmark:_MailOriginalBody">#8 0x00000000006812f5 in PostmasterMain \
()<o:p></o:p></span></p> <p class="MsoNormal" \
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span \
style="mso-bookmark:_MailOriginalBody">#9 0x0000000000609278 in main \
().<o:p></o:p></span></p> <p class="MsoNormal" \
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span \
style="mso-bookmark:_MailOriginalBody"> <o:p></o:p></span></p> <p \
class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span \
style="mso-bookmark:_MailOriginalBody"> <o:p></o:p></span></p> <p \
class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span \
style="mso-bookmark:_MailOriginalBody">We aren't sure if this indicates that \
pg_hint_plan is causing the segfault or if it happened to be doing something when the \
segfault occurred. We aren't actually using pg_hint_plan hints in this system \
so we're not sure how all this relates to segfault when another process does a \
‘grant usage on schema abc to user xyz;' unrelated to the account \
segfaulting.<o:p></o:p></span></p> </div>
</div>
</blockquote>
<div>
<p class="MsoNormal"><span \
style="mso-bookmark:_MailOriginalBody"><o:p> </o:p></span></p> </div>
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody">although you don't \
use pg_hint_plan explicitly, pg_hint_plan is active - it is active via planner \
callbacks <br>
<o:p></o:p></span></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in \
6.0pt;margin-left:4.8pt;margin-right:0in"> <div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span \
style="mso-bookmark:_MailOriginalBody"> <o:p></o:p></span></p> <p \
class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span \
style="mso-bookmark:_MailOriginalBody">Short of better ideas, we will pull the \
pg_hint_plan extension and see if that removes the problem.<o:p></o:p></span></p> \
</div> </div>
</blockquote>
<div>
<p class="MsoNormal"><span \
style="mso-bookmark:_MailOriginalBody"><o:p> </o:p></span></p> </div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span \
style="mso-bookmark:_MailOriginalBody">please, try to report this back trace to \
pg_hint_plan authors. <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span \
style="mso-bookmark:_MailOriginalBody">Regards<o:p></o:p></span></p> </div>
<div>
<p class="MsoNormal"><span \
style="mso-bookmark:_MailOriginalBody">Pavel<o:p></o:p></span></p> </div>
<div>
<p class="MsoNormal"><span \
style="mso-bookmark:_MailOriginalBody"> <o:p></o:p></span></p> </div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in \
6.0pt;margin-left:4.8pt;margin-right:0in"> <div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span \
style="mso-bookmark:_MailOriginalBody"> <o:p></o:p></span></p> <p \
class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span \
style="mso-bookmark:_MailOriginalBody">-Blair<o:p></o:p></span></p> <p \
class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span \
style="mso-bookmark:_MailOriginalBody"> <o:p></o:p></span></p> <p \
class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span \
style="mso-bookmark:_MailOriginalBody"> <o:p></o:p></span></p> <p \
class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span \
style="mso-bookmark:_MailOriginalBody"> <o:p></o:p></span></p> <p \
class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span \
style="mso-bookmark:_MailOriginalBody"> <o:p></o:p></span></p> <p \
class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span \
style="mso-bookmark:_MailOriginalBody"> <o:p></o:p></span></p> <div \
style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in"> <p \
class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span \
style="mso-bookmark:_MailOriginalBody"><b><span \
style="font-size:12.0pt;color:black">From: </span></b></span><span \
style="mso-bookmark:_MailOriginalBody"><span \
style="font-size:12.0pt;color:black">Peter Geoghegan <</span></span><a \
href="mailto:pg@bowt.ie" target="_blank"><span \
style="mso-bookmark:_MailOriginalBody"><span \
style="font-size:12.0pt">pg@bowt.ie</span></span><span \
style="mso-bookmark:_MailOriginalBody"></span></a><span \
style="mso-bookmark:_MailOriginalBody"><span \
style="font-size:12.0pt;color:black">><br> <b>Date: </b>Saturday, March 24, 2018 \
at 4:18 PM<br> <b>To: </b>Blair Boadway <</span></span><a \
href="mailto:bboadway@abebooks.com" target="_blank"><span \
style="mso-bookmark:_MailOriginalBody"><span \
style="font-size:12.0pt">bboadway@abebooks.com</span></span><span \
style="mso-bookmark:_MailOriginalBody"></span></a><span \
style="mso-bookmark:_MailOriginalBody"><span \
style="font-size:12.0pt;color:black">><br> <b>Cc: </b>"</span></span><a \
href="mailto:pgsql-general@postgresql.org" target="_blank"><span \
style="mso-bookmark:_MailOriginalBody"><span \
style="font-size:12.0pt">pgsql-general@postgresql.org</span></span><span \
style="mso-bookmark:_MailOriginalBody"></span></a><span \
style="mso-bookmark:_MailOriginalBody"><span \
style="font-size:12.0pt;color:black">" <</span></span><a \
href="mailto:pgsql-general@postgresql.org" target="_blank"><span \
style="mso-bookmark:_MailOriginalBody"><span \
style="font-size:12.0pt">pgsql-general@postgresql.org</span></span><span \
style="mso-bookmark:_MailOriginalBody"></span></a><span \
style="mso-bookmark:_MailOriginalBody"><span \
style="font-size:12.0pt;color:black">><br> <b>Subject: </b>Re: Troubleshooting a \
segfault and instance crash</span><o:p></o:p></span></p> </div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span \
style="mso-bookmark:_MailOriginalBody"> <o:p></o:p></span></p> </div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span \
style="mso-bookmark:_MailOriginalBody"><a \
name="m_-329999471652110922__MailOriginalBody">On Thu, Mar 8, 2018 at 9:40 AM, Blair \
Boadway <</a></span><a href="mailto:bboadway@abebooks.com" target="_blank"><span \
style="mso-bookmark:_MailOriginalBody">bboadway@abebooks.com</span><span \
style="mso-bookmark:_MailOriginalBody"></span></a><span \
style="mso-bookmark:_MailOriginalBody">> wrote:<o:p></o:p></span></p>
</div>
<div>
<div>
<blockquote style="border:none;border-left:solid #B5C4DF 4.5pt;padding:0in 0in 0in \
4.0pt;margin-left:3.75pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt" \
id="m_-329999471652110922MAC_OUTLOOK_ATTRIBUTION_BLOCKQUOTE"> <div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span \
style="mso-bookmark:_MailOriginalBody">Mar 7 14:46:35 pgprod2 \
kernel:postgres[29351]: segfault at 0 ip<o:p></o:p></span></p> </div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span \
style="mso-bookmark:_MailOriginalBody">000000302f32868a sp 00007ffcf1547498 error 4 \
in<o:p></o:p></span></p> </div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span \
style="mso-bookmark:_MailOriginalBody"></span><a href="http://libc-2.12.so" \
target="_blank"><span style="mso-bookmark:_MailOriginalBody">libc-2.12.so</span><span \
style="mso-bookmark:_MailOriginalBody"></span></a><span \
style="mso-bookmark:_MailOriginalBody">[302f200000+18a000]<o:p></o:p></span></p> \
</div> <div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span \
style="mso-bookmark:_MailOriginalBody"> <o:p></o:p></span></p> </div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span \
style="mso-bookmark:_MailOriginalBody">Mar 7 14:46:35 pgprod2 \
POSTGRES[21262]: [5] user=,db=,app=client= LOG:<o:p></o:p></span></p> </div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span \
style="mso-bookmark:_MailOriginalBody">server process (PID 29351) was terminated by \
signal 11: Segmentation fault<o:p></o:p></span></p> </div>
</blockquote>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span \
style="mso-bookmark:_MailOriginalBody"> <o:p></o:p></span></p> </div>
<blockquote style="border:none;border-left:solid #B5C4DF 4.5pt;padding:0in 0in 0in \
4.0pt;margin-left:3.75pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt" \
id="m_-329999471652110922MAC_OUTLOOK_ATTRIBUTION_BLOCKQUOTE"> <div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span \
style="mso-bookmark:_MailOriginalBody">It crashes the database, though it starts \
again on its own without any<o:p></o:p></span></p> </div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span \
style="mso-bookmark:_MailOriginalBody">apparent issues. This has happened \
3 times in 2 months and each time the<o:p></o:p></span></p> </div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span \
style="mso-bookmark:_MailOriginalBody">segfault error and memory address is the \
same.<o:p></o:p></span></p> </div>
</blockquote>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span \
style="mso-bookmark:_MailOriginalBody"> <o:p></o:p></span></p> </div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span \
style="mso-bookmark:_MailOriginalBody">We had a recent report of a segfault on a \
Redhat compatible system,<o:p></o:p></span></p> </div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span \
style="mso-bookmark:_MailOriginalBody">that seemed like it might originate from \
within its glibc [1].<o:p></o:p></span></p> </div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span \
style="mso-bookmark:_MailOriginalBody">Although all the versions there didn't match \
what you have, it's worth<o:p></o:p></span></p> </div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span \
style="mso-bookmark:_MailOriginalBody">considering as a \
possibility.<o:p></o:p></span></p> </div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span \
style="mso-bookmark:_MailOriginalBody"> <o:p></o:p></span></p> </div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span \
style="mso-bookmark:_MailOriginalBody">Maybe you can't install debuginfo packages \
because you don't yet have<o:p></o:p></span></p> </div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span \
style="mso-bookmark:_MailOriginalBody">the necessary debuginfo repos set up. Just a \
guess. That is sometimes<o:p></o:p></span></p> </div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span \
style="mso-bookmark:_MailOriginalBody">a required extra step.<o:p></o:p></span></p> \
</div> <div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span \
style="mso-bookmark:_MailOriginalBody"> <o:p></o:p></span></p> </div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span \
style="mso-bookmark:_MailOriginalBody">[1] </span><a \
href="https://postgr.es/m/7369.1520528405@sss.pgh.pa.us" target="_blank"><span \
style="mso-bookmark:_MailOriginalBody">https://postgr.es/m/7369.1520528405@sss.pgh.pa.us</span><span \
style="mso-bookmark:_MailOriginalBody"></span></a><span \
style="mso-bookmark:_MailOriginalBody"><o:p></o:p></span></p> </div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span \
style="mso-bookmark:_MailOriginalBody">--<o:p></o:p></span></p> </div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span \
style="mso-bookmark:_MailOriginalBody">Peter Geoghegan<o:p></o:p></span></p> </div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span \
style="mso-bookmark:_MailOriginalBody"> <o:p></o:p></span></p> </div>
</div>
</div>
</div>
</div>
</blockquote>
</div>
<p class="MsoNormal"><span \
style="mso-bookmark:_MailOriginalBody"><o:p> </o:p></span></p> </div>
</div>
</div>
</body>
</html>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic