[Pgpool-general] Understanding Error Messages

[Łukasz Jagiełło]

2008/12/30 Jay Payne <letterj at gmail.com>:
> We are running a two node pgpool-II database set and are using Master -
> Master replication.
>
> What do these errors mean?
>
> Dec 30 15:46:17 pgpool1-2 pgpool: 2008-12-30 15:46:17 LOG:   pid 3188:
> ProcessFrontendResponse: failed to read kind from frontend. frontend
> abnormally exited
> Dec 30 15:46:17 pgpool1-2 pgpool: 2008-12-30 15:46:17 ERROR: pid 3188:
> pool_process_query: 1 th kind E does not match with master connection kind S
>
> Dec 30 15:46:21 pgpool1-2 pgpool: 2008-12-30 15:46:21 ERROR: pid 4413:
> pool_process_query: 1 th kind E does not match with master connection kind C
> Dec 30 15:46:21 pgpool1-2 pgpool: 2008-12-30 15:46:21 LOG:   pid 4413:
> do_child: exits with status 1 due to error
>
> It would be nice if pgpool would log the query that generated the error.
>
> There is no way we can run pgpool in debug mode in production.
>
> Is there a document that explains what kind E or kind S means?
>
> Thanks in advance for your time.

Check at postgresql log, one should contain error.


-- 
Łukasz Jagiełło
G-Forces Web Management Polska

T: +44 (0) 845 055 9040
F: +44 (0) 845 055 9038
E: lukasz.jagiello at gforces.pl
W: www.gforces.co.uk

This e-mail is confidential and intended solely for the use of the
individual to whom it is addressed. If you are not the intended
recipient, please notify the sender immediately. Do not disclose the
contents of this e-mail to any other person, use it for any purpose,
print, copy, store, or distribute it. This e-mail should then be
destroyed. Any views expressed in this message are those of the
individual sender except where the sender specifically states them to
be the views of G-Forces Web Management Ltd. Registered Office: 4 & 5
Kings Row, Armstrong Road, Maidstone, Kent. ME15 6AQ. Registered
Company No. 3863609. VAT Registration No. 7250 384 50