[Pgpool-general] Cancelled queries or empty results?

[Tom Spivey]

Glyn Astill <glynastill at ...> writes:

> 
> I'm guessing it refers to the identification token from the front/backend 
> protocol
> 
> http://www.postgresql.org/docs/8.4/static/protocol-error-fields.html
> 

Hi Glyn et al,

grepping the log file, it always has to do with the use of temporary tables.
I think they are used by pgpool, right?
Also, the error is given by the master DB node id: 0.

2011-02-17 08:45:48 CET [10192]: [161-1]
LOG:  statement: 
SELECT count(*) FROM pg_catalog.pg_class AS c WHERE 
c.relname = 'stock_container' AND c.relistemp
2011-02-17 08:45:48 CET [10192]: [162-1] 
ERROR:  portal "" does not exist

Thanks for any help.

Kind regards,
Tom

> --- On Thu, 17/2/11, Tom Spivey <tom at ...> wrote:
> 
> > From: Tom Spivey <tom at ...>
> > Subject: Re: [Pgpool-general] Cancelled queries or empty results?
> > To: pgpool-general at ...
> > Date: Thursday, 17 February, 2011, 8:11
> > Tried the logging, but there was no
> > sign of a big lag behind.
> > However, I see an error, which I have no clue about - see
> > the 
> > 'pool_send_and_wait:' error:
> > 
> > 2011-02-17 08:22:17 LOG:   pid 49474:
> > pool_send_and_wait: E
> > rror or notice message from backend: : 
> > DB node id: 0 backend pid: 9205 statement: P message:
> > portal "" does not exist
> > 2011-02-17 08:24:23 LOG:   pid 49478:
> > Replication of node:1 is behind 
> > 12000 bytes from the primary server (node:0)
> > 2011-02-17 08:24:43 LOG:   pid 49478:
> > Replication of node:1 is behind 
> > 0 bytes from the primary 
> > server (node:0)
> > 
> > What does "statement: P" mean?
> > 
> > Tried version 3.0.2, but that shows the same behaviour.
> > 
> > Thanks again for your help!
> > 
> > Regards, Tom
> > 
> > 
> > _______________________________________________
> > Pgpool-general mailing list
> > Pgpool-general at ...
> > http://pgfoundry.org/mailman/listinfo/pgpool-general
> >