Glyn Astill <glynastill@...> 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@...> wrote: > > > From: Tom Spivey <tom@...> > > Subject: Re: [Pgpool-general] Cancelled queries or empty results? > > To: pgpool-general@... > > 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@... > > http://pgfoundry.org/mailman/listinfo/pgpool-general > > _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
