<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Exchange Server">
<!-- converted from text --><style><!-- .EmailQuote { margin-left: 1pt; padding-left: 4pt; border-left: #800000 2px solid; } --></style>
</head>
<body>
<meta content="text/html; charset=UTF-8">
<style type="text/css" style="">
<!--
p
{margin-top:0;
margin-bottom:0}
-->
</style>
<div dir="ltr">
<div id="x_divtagdefaultwrapper" dir="ltr" style="font-size:12pt; color:#000000; font-family:Calibri,Helvetica,sans-serif">
<p>sorry.. you can find log file after the reboot.</p>
<p><br>
</p>
<p>I have see an error in this log file:</p>
<p><span></span><span>Backend status file /var/log//pgpool_status does not exist</span><br>
</p>
</div>
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="x_divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" color="#000000" style="font-size:11pt"><b>From:</b> Tatsuo Ishii <ishii@sraoss.co.jp><br>
<b>Sent:</b> Wednesday, May 1, 2019 3:27:03 PM<br>
<b>To:</b> Pierre Ochsenbein<br>
<b>Cc:</b> ptim007@yahoo.com; pgpool-general@pgpool.net<br>
<b>Subject:</b> Re: [pgpool-general: 6526] Re: error pgpool</font>
<div> </div>
</div>
</div>
<font size="2"><span style="font-size:10pt;">
<div class="PlainText">> Attaches you can find the log file after the reboot and pcp_attach_node.<br>
<br>
Sorry, but the log is not what I want.<br>
<br>
1) remove pgpool_status<br>
2) reboot<br>
<br>
I need a Pgpool-II log right after 2).<br>
<br>
Best regards,<br>
--<br>
Tatsuo Ishii<br>
SRA OSS, Inc. Japan<br>
English: <a href="http://www.sraoss.co.jp/index_en.php">http://www.sraoss.co.jp/index_en.php</a><br>
Japanese:http://www.sraoss.co.jp<br>
<br>
> Thanks for your help<br>
> <br>
> ________________________________<br>
> From: Tatsuo Ishii <ishii@sraoss.co.jp><br>
> Sent: Wednesday, May 1, 2019 12:53:57 PM<br>
> To: Pierre Ochsenbein<br>
> Cc: ptim007@yahoo.com; pgpool-general@pgpool.net<br>
> Subject: Re: [pgpool-general: 6526] Re: error pgpool<br>
> <br>
> Unfortunatelu the log does not help too much. Please share the log<br>
> from the starting up (after removing pgpool_status file then restart<br>
> Pgpool-II).<br>
> <br>
> Also please tell me what Pgpool-II version you are using.<br>
> <br>
> Best regards,<br>
> --<br>
> Tatsuo Ishii<br>
> SRA OSS, Inc. Japan<br>
> English: <a href="http://www.sraoss.co.jp/index_en.php">http://www.sraoss.co.jp/index_en.php</a><br>
> Japanese:http://www.sraoss.co.jp<br>
> <br>
>> Attached you can find the log file and the config file.<br>
>><br>
>><br>
>> Thanks a lot<br>
>><br>
>> ________________________________<br>
>> From: Tatsuo Ishii <ishii@sraoss.co.jp><br>
>> Sent: Wednesday, May 1, 2019 10:10:03 AM<br>
>> To: Pierre Ochsenbein<br>
>> Cc: ptim007@yahoo.com; pgpool-general@pgpool.net<br>
>> Subject: Re: [pgpool-general: 6526] Re: error pgpool<br>
>><br>
>> Then Pgpool-II was not able to connect to neither of PostgreSQL<br>
>> servers. That may be because the PostgreSQL servers are all down<br>
>> and/or there are something wrong with the setting in pgpool.conf.<br>
>><br>
>> In order to inspect the cause of the problem, please share Pgpool-II<br>
>> log and pgpool.conf.<br>
>><br>
>> Best regards,<br>
>> --<br>
>> Tatsuo Ishii<br>
>> SRA OSS, Inc. Japan<br>
>> English: <a href="http://www.sraoss.co.jp/index_en.php">http://www.sraoss.co.jp/index_en.php</a><br>
>> Japanese:http://www.sraoss.co.jp<br>
>><br>
>>> I have removed the file and restart service and I have always the same error.<br>
>>><br>
>>><br>
>>> WARNING: All the DB nodes are in down status and skip writing status file<br>
>>><br>
>>> FATAL: pgpool is not accepting any new connections<br>
>>><br>
>>><br>
>>><br>
>>> ________________________________<br>
>>> From: Pierre Timmermans <ptim007@yahoo.com><br>
>>> Sent: Wednesday, May 1, 2019 08:33<br>
>>> To: pgpool-general@pgpool.net; Pierre Ochsenbein<br>
>>> Subject: Re: [pgpool-general: 6524] error pgpool<br>
>>><br>
>>> It means that pgpool sees all databases as being down. When pgpool starts it reads the state of the databases from a status file, it is /tmp/pgpool_status by default. There is one line per database.<br>
>>><br>
>>> So if the db are not down, you would need to stop pgpool, delete this file and restart it. The other way - the normal way - to bring back a node to status up is with the command pcp_attach_node. But in this case I think it is not posible because you cannot
even use pcp commands when all nodes are down (to be validated).<br>
>>><br>
>>> Pierre<br>
>>><br>
>>><br>
>>> On Tuesday, April 30, 2019, 11:36:55 PM GMT+2, Pierre Ochsenbein <pierre.ochsenbein@acceleris.ch> wrote:<br>
>>><br>
>>><br>
>>><br>
>>> Any idea about this error :<br>
>>><br>
>>> Apr 30 14:05:06 host01 pgpool[5992]: [1496-1] 2019-04-30 14:05:06: pid 5992: FATAL: pgpool is not accepting any new connections<br>
>>> Apr 30 14:05:06 host01 pgpool[5992]: [1496-2] 2019-04-30 14:05:06: pid 5992: DETAIL: all backend nodes are down, pgpool requires at least one valid node<br>
>>> Apr 30 14:05:06 host01 pgpool[5992]: [1496-3] 2019-04-30 14<br>
>>><br>
>>><br>
>>> [Acceleris]<br>
>>><br>
>>> Acceleris AG<br>
>>> Pierre Ochsenbein | Technical Consultant<br>
>>> Schosshaldenstrasse 85 | CH-3006 Bern<br>
>>> T : +41 31 911 33 22 | www.acceleris.ch<<a href="http://www.acceleris.ch">http://www.acceleris.ch</a>><br>
>>> pierre.ochsenbein@acceleris.ch<br>
>>><br>
>>> Acceleris Offices are in :<br>
>>> Bern | Zurich | Renens | Bucharest<br>
>>><br>
>>> [Facebook]<https://www.facebook.com/accelerisag/> [Twitter] <<a href="https://twitter.com/AccelerisAG">https://twitter.com/AccelerisAG</a>> [Linkedin] <<a href="https://www.linkedin.com/company/acceleris/">https://www.linkedin.com/company/acceleris/</a>>
[youtube] <<a href="https://www.youtube.com/channel/UCmpg-HGwJh6-0CoVApz7Cjg/featured">https://www.youtube.com/channel/UCmpg-HGwJh6-0CoVApz7Cjg/featured</a>><br>
>>><br>
>>> Disclaimer<br>
>>><br>
>>> This message possibly contains confidential data or items of information. It is intended solely for the rightful recipient. If you should have received the message wrongfully, it is not permitted to disclose the e-mail message or its contents to third parties,
to copy or use it. We would respectfully request you to destroy the message with the exclusion of any reproduction and to notify this to the originator by e-mail. Thank you very much.<br>
>>><br>
>>><br>
>>> _______________________________________________<br>
>>> pgpool-general mailing list<br>
>>> pgpool-general@pgpool.net<mailto:pgpool-general@pgpool.net><br>
>>> <a href="http://www.pgpool.net/mailman/listinfo/pgpool-general">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
>>><br>
>>> [Acceleris]<br>
>>><br>
>>> Acceleris AG<br>
>>> Pierre Ochsenbein | Technical Consultant<br>
>>> Schosshaldenstrasse 85 | CH-3006 Bern<br>
>>> T : +41 31 911 33 22 | www.acceleris.ch<<a href="http://www.acceleris.ch">http://www.acceleris.ch</a>><br>
>>> pierre.ochsenbein@acceleris.ch<br>
>>><br>
>>> Acceleris Offices are in :<br>
>>> Bern | Zurich | Renens | Bucharest<br>
>>><br>
>>> [Facebook]<https://www.facebook.com/accelerisag/> [Twitter] <<a href="https://twitter.com/AccelerisAG">https://twitter.com/AccelerisAG</a>> [Linkedin] <<a href="https://www.linkedin.com/company/acceleris/">https://www.linkedin.com/company/acceleris/</a>>
[youtube] <<a href="https://www.youtube.com/channel/UCmpg-HGwJh6-0CoVApz7Cjg/featured">https://www.youtube.com/channel/UCmpg-HGwJh6-0CoVApz7Cjg/featured</a>><br>
>>><br>
>>> Disclaimer<br>
>>><br>
>>> This message possibly contains confidential data or items of information. It is intended solely for the rightful recipient. If you should have received the message wrongfully, it is not permitted to disclose the e-mail message or its contents to third parties,
to copy or use it. We would respectfully request you to destroy the message with the exclusion of any reproduction and to notify this to the originator by e-mail. Thank you very much.<br>
>>><br>
>>><br>
>><br>
>> [Acceleris]<br>
>><br>
>> Acceleris AG<br>
>> Pierre Ochsenbein | Technical Consultant<br>
>> Schosshaldenstrasse 85 | CH-3006 Bern<br>
>> T : +41 31 911 33 22 | www.acceleris.ch<<a href="http://www.acceleris.ch">http://www.acceleris.ch</a>><br>
>> pierre.ochsenbein@acceleris.ch<br>
>><br>
>> Acceleris Offices are in :<br>
>> Bern | Zurich | Renens | Bucharest<br>
>><br>
>> [Facebook]<https://www.facebook.com/accelerisag/> [Twitter] <<a href="https://twitter.com/AccelerisAG">https://twitter.com/AccelerisAG</a>> [Linkedin] <<a href="https://www.linkedin.com/company/acceleris/">https://www.linkedin.com/company/acceleris/</a>>
[youtube] <<a href="https://www.youtube.com/channel/UCmpg-HGwJh6-0CoVApz7Cjg/featured">https://www.youtube.com/channel/UCmpg-HGwJh6-0CoVApz7Cjg/featured</a>><br>
>><br>
>> Disclaimer<br>
>><br>
>> This message possibly contains confidential data or items of information. It is intended solely for the rightful recipient. If you should have received the message wrongfully, it is not permitted to disclose the e-mail message or its contents to third parties,
to copy or use it. We would respectfully request you to destroy the message with the exclusion of any reproduction and to notify this to the originator by e-mail. Thank you very much.<br>
>><br>
>><br>
> <br>
> [Acceleris]<br>
> <br>
> Acceleris AG<br>
> Pierre Ochsenbein | Technical Consultant<br>
> Schosshaldenstrasse 85 | CH-3006 Bern<br>
> T : +41 31 911 33 22 | <a href="http://www.acceleris.ch">www.acceleris.ch</a><br>
> pierre.ochsenbein@acceleris.ch<br>
> <br>
> Acceleris Offices are in :<br>
> Bern | Zurich | Renens | Bucharest<br>
> <br>
> [Facebook]<https://www.facebook.com/accelerisag/> [Twitter] <<a href="https://twitter.com/AccelerisAG">https://twitter.com/AccelerisAG</a>> [Linkedin] <<a href="https://www.linkedin.com/company/acceleris/">https://www.linkedin.com/company/acceleris/</a>>
[youtube] <<a href="https://www.youtube.com/channel/UCmpg-HGwJh6-0CoVApz7Cjg/featured">https://www.youtube.com/channel/UCmpg-HGwJh6-0CoVApz7Cjg/featured</a>><br>
> <br>
> Disclaimer<br>
> <br>
> This message possibly contains confidential data or items of information. It is intended solely for the rightful recipient. If you should have received the message wrongfully, it is not permitted to disclose the e-mail message or its contents to third parties,
to copy or use it. We would respectfully request you to destroy the message with the exclusion of any reproduction and to notify this to the originator by e-mail. Thank you very much.<br>
> <br>
> <br>
</div>
</span></font><br>
<div><img alt="Acceleris" src="http://www.acceleris.ch/images/logo_acceleris_claim_pos_cloudifying.png" height="73" width="180"></div>
<br>
<div style="font-size:11pt; font-family: 'Helvetica',sans-serif;"><b>Acceleris AG
</b><br>
Pierre Ochsenbein | Technical Consultant<br>
Schosshaldenstrasse 85 | CH-3006 Bern<br>
T : +41 31 911 33 22 | www.acceleris.ch <br>
pierre.ochsenbein@acceleris.ch <br>
<br>
Acceleris Offices are in :<br>
Bern | Zurich | Renens | Bucharest </div>
<br>
<a href="https://www.facebook.com/accelerisag/"><img src="https://www.acceleris.ch/images/social_media/Facebook%20Round.png " width="25" height="25" padding="11" alt="Facebook"></a>
<a href="https://twitter.com/AccelerisAG"><img src="https://www.acceleris.ch/images/social_media/Twitter%20round.png" width="25px" height="25" padding="11" alt="Twitter"></a>
<a href="https://www.linkedin.com/company/acceleris/"><img src="https://www.acceleris.ch/images/social_media/Linkedin%20round.png" width="25" height="25" padding="11" alt="Linkedin"></a>
<a href="https://www.youtube.com/channel/UCmpg-HGwJh6-0CoVApz7Cjg/featured "><img src="https://www.acceleris.ch/images/social_media/Youtube%20round.png" width="25" height="25" padding="11" alt="youtube"></a>
<br>
<br>
<span style="font-size:10pt; font-family: 'Helvetica','sans-serif','garamond',serif; color:#000;">Disclaimer
</span><br>
<p style="font-size:8pt; line-height:10pt; font-family: Helvetica,'sans-serif',garamond;">
This message possibly contains confidential data or items of information. It is intended solely for the rightful recipient. If you should have received the message wrongfully, it is not permitted to disclose the e-mail message or its contents to third parties,
to copy or use it. We would respectfully request you to destroy the message with the exclusion of any reproduction and to notify this to the originator by e-mail. Thank you very much.
</p>
<br>
<br>
</body>
</html>