Re: Server Crash

Hi Fabio,

I understand your point, however i am in tremendous pressure to provide
the solution.

I have attached the log file for review.

We have Red Hat machine and Postgres 9.1.13 version.

Appreciate for your response and help.

Regards,

Anjul TYAGI

ü Go Green

------ Original Message ------
From: "Fabio Pardi" <f(dot)pardi(at)portavita(dot)eu>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Sent: 27-06-2018 14:43:30
Subject: Re: Server Crash

>Hi Anjul,
>
>please avoid cross posting over multiple mailing lists.
>
>Also asking again does not help, and usually is counterproductive:
>members see a reply and they might put efforts on helping somebody who
>did not get a reply yet.
>
>Please take good note of it.
>
>About your problem:
>
>I would suggest you to upgrade to a newer version, since Postgres 9.1
>is too old and does not get updates any longer.
>
>Besides that, not being a perl expert i cannot help with your
>procedure. I think anyway the problem might be somewhere else. I
>suspect that your server crashes and what you read there is only a
>consequence, not the cause.
>
>Could you post any relevant log entry in /var/log/messages and maybe
>anything else appearing in the postgres logfile?
>
>
>
>What kind of machine are you running on? can we have more specs?
>
>How is your server configured?
>
>
>
>regards,
>
>fabio pardi
>
>
>
>
>
>
>On 27/06/18 10:51, Anjul Tyagi wrote:
>>Hi All,
>>
>>can you please suggest on the issue we are facing?
>>
>>
>>
>>Regards,
>>
>>Anjul TYAGI
>>
>>
>>
>>ü Go Green
>>
>>
>>------ Original Message ------
>>From: "Anjul Tyagi" <anjul(at)ibosstech-us(dot)com>
>>To: "pgsql-bugs(at)lists(dot)postgresql(dot)org"
>><mailto:pgsql-bugs(at)lists(dot)postgresql(dot)org>
>><pgsql-bugs(at)lists(dot)postgresql(dot)org>
>>Sent: 26-06-2018 18:17:26
>>Subject: Server Crash
>>
>>>Hi All,
>>>
>>>We have recently deployed couple of new plperl SPROC in our postgres
>>>production server and after that server start throwing error.
>>>Currently we are using postgres 9.1 and planning to upgrade with PG
>>>10.
>>>
>>>But we are not sure if that will cause the same error in PG 10 as
>>>well. We really need help.
>>>
>>>Error Message:
>>>
>>>2018-06-21 13:43:29 EDT [22212]: [4-1] user=cmsuser,db=forte
>>>,host=10.10.1.3,port=10.10.1.3(56601),id=5b2bdea5.56c4,line=4DETAIL:
>>>The postmaster has commanded this server process to roll back the
>>>current transaction and exit, because another server process exited
>>>abnormally and possibly corrupted shared memory.
>>>
>>>
>>>
>>>2018-06-21 13:43:29 EDT [3673]: [5-1] user=cmsuser,db=forte
>>>,host=10.10.1.3,port=10.10.1.3(55649),id=5b2bd568.e59,line=5DETAIL:
>>>The postmaster has commanded this server process to roll back the
>>>current transaction and exit, because another server process exited
>>>abnormally and possibly corrupted shared memory.
>>>
>>>
>>>Server Details:
>>>Linux - Red Hat Enterprise Linux Server release 6.3 (Santiago)
>>>Postgres - Postgres 9.1.13
>>>
>>>below are the sample SPROC code:
>>>
>>>
>>>CREATE OR REPLACE FUNCTION getauthcode(
>>> claim character varying,
>>> oflag character varying,
>>> pacode character varying,
>>> dispos character varying)
>>> RETURNS text AS
>>>$BODY$
>>>use strict;
>>>use warnings;
>>>use SOAP::Lite;
>>>use JSON;
>>>
>>>
>>>try
>>>{
>>> my $host = `hostname`;
>>> my $rv = spi_exec_query("select * from
>>>getsprocurl('getauthcode','".$host."')");
>>> my $url = $rv->{rows}[0]->{ret_url};
>>> elog(NOTICE, 'Host Name ' . $host . ' URL '. $url );
>>>
>>> my $soap = SOAP::Lite->new();
>>> my $service = $soap->service($url);
>>> my %params = ("claim" => $_[0], "oflag" => $_[1], "pacode" =>
>>>$_[2], "dispos" => $_[3]);
>>> my $response = $service->getAuthCode(%params);
>>> my $json_array = decode_json($response);
>>>
>>> for my $report ( $json_array) {
>>> my $status = $report->{status}, '\n';
>>> if ($status eq 'success')
>>> {
>>> return $report->{PriorApprovalCode};
>>> }
>>> else{
>>> return $report->{message};
>>> }
>>> }
>>>}
>>>catch Exception with
>>>{
>>> my $ex = shift;
>>> return 'SOAPFAULT: ' . date('H:i:s') . ' ' . exception($ex);
>>>}
>>>
>>>$BODY$
>>> LANGUAGE plperlu VOLATILE STRICT
>>> COST 100;
>>>
>>>Appreciate for your help in advance.
>>>
>>>Regards,
>>>
>>>Anjul TYAGI
>>>
>>>
>>>
>>>ü Go Green
>>>
>>>
>