[Pgcluster-general] Load Balance Pg cluster

Monde Hans mhans at fnb.co.za
Thu Jun 21 08:36:04 UTC 2007 

Here is the error message from the load balance.

It reports that all the cluster DBs have failed after this.


2007-06-21 10:03:43 [5050] DEBUG:Query(): DROP DATABASE testlocaldb;
2007-06-21 10:03:43 [5050] DEBUG:pool_process_query():read kind from
backend C
2007-06-21 10:03:43 [5050] DEBUG:pool_process_query():read kind from
backend pen
ding data Z len: 5 po: 19
2007-06-21 10:03:43 [5050] DEBUG:ReadyForQuery(): message length: 5
2007-06-21 10:03:43 [5050] DEBUG:ReadyForQuery(): transaction state: I
2007-06-21 10:03:43 [5050] DEBUG:ProcessFrontendResponse():read kind
from fronte
nd Q(51)
2007-06-21 10:03:43 [5050] DEBUG:Query(): SELECT description FROM
pg_shdescripti
on WHERE objoid=10819::oid
2007-06-21 10:03:43 [5050] DEBUG:pool_process_query():read kind from
backend T
2007-06-21 10:03:43 [5050] DEBUG:pool_process_query():read kind from
backend pen
ding data C len: 17 po: 37
2007-06-21 10:03:43 [5050] DEBUG:pool_process_query():read kind from
backend pen
ding data Z len: 5 po: 49
2007-06-21 10:03:43 [5050] DEBUG:ReadyForQuery(): message length: 5
2007-06-21 10:03:43 [5050] DEBUG:ReadyForQuery(): transaction state: I
2007-06-21 10:03:43 [5050] DEBUG:ProcessFrontendResponse():read kind
from fronte
nd Q(51)
2007-06-21 10:03:43 [5050] DEBUG:Query(): SELECT proname FROM pg_proc
WHERE pron
ame='pg_get_viewdef' AND proargtypes[1]=16
2007-06-21 10:03:43 [5050] DEBUG:pool_process_query():read kind from
backend T
2007-06-21 10:03:43 [5050] DEBUG:pool_process_query():read kind from
backend pen
ding data D len: 67 po: 33
2007-06-21 10:03:43 [5050] DEBUG:pool_process_query():read kind from
backend pen
ding data D len: 42 po: 58
2007-06-21 10:03:43 [5050] DEBUG:pool_process_query():read kind from
backend pen
ding data C len: 17 po: 83
2007-06-21 10:03:43 [5050] DEBUG:pool_process_query():read kind from
backend pen
ding data Z len: 5 po: 95
2007-06-21 10:03:43 [5050] DEBUG:ReadyForQuery(): message length: 5
2007-06-21 10:03:43 [5050] DEBUG:ReadyForQuery(): transaction state: I
2007-06-21 10:03:43 [5050] DEBUG:ProcessFrontendResponse():read kind
from fronte
nd Q(51)
2007-06-21 10:03:43 [5050] DEBUG:Query(): SHOW search_path
2007-06-21 10:03:43 [5050] DEBUG:pool_process_query():read kind from
backend T
2007-06-21 10:03:43 [5050] DEBUG:pool_process_query():read kind from
backend pen
ding data D len: 40 po: 37
2007-06-21 10:03:43 [5050] DEBUG:pool_process_query():read kind from
backend pen
ding data C len: 15 po: 62
2007-06-21 10:03:43 [5050] DEBUG:pool_process_query():read kind from
backend pen
ding data Z len: 5 po: 72
2007-06-21 10:03:43 [5050] DEBUG:ReadyForQuery(): message length: 5
2007-06-21 10:03:43 [5050] DEBUG:ReadyForQuery(): transaction state: I
2007-06-21 10:03:43 [5050] DEBUG:ProcessFrontendResponse():read kind
from fronte
nd Q(51)
2007-06-21 10:03:43 [5050] DEBUG:Query(): SELECT nspname,
session_user=nspname A
S isuser FROM pg_namespace
2007-06-21 10:03:43 [5050] DEBUG:pool_process_query():read kind from
backend T
2007-06-21 10:03:43 [5050] DEBUG:pool_process_query():read kind from
backend pen
ding data D len: 148 po: 58
2007-06-21 10:03:43 [5050] DEBUG:pool_process_query():read kind from
backend pen
ding data D len: 124 po: 82
2007-06-21 10:03:43 [5050] DEBUG:pool_process_query():read kind from
backend pen
ding data D len: 99 po: 107
2007-06-21 10:03:43 [5050] DEBUG:pool_process_query():read kind from
backend pen
ding data D len: 73 po: 133
2007-06-21 10:03:43 [5050] DEBUG:pool_process_query():read kind from
backend pen
ding data D len: 51 po: 155
2007-06-21 10:03:43 [5050] DEBUG:pool_process_query():read kind from
backend pen
ding data C len: 17 po: 189
2007-06-21 10:03:43 [5050] DEBUG:pool_process_query():read kind from
backend pen
ding data Z len: 5 po: 201
2007-06-21 10:03:43 [5050] DEBUG:ReadyForQuery(): message length: 5
2007-06-21 10:03:43 [5050] DEBUG:ReadyForQuery(): transaction state: I
2007-06-21 10:03:43 [5050] DEBUG:ProcessFrontendResponse():read kind
from fronte
nd Q(51)
2007-06-21 10:03:43 [5050] DEBUG:Query(): SELECT ca.oid, ca.*,
format_type(st.oi
d,NULL) AS srctyp, format_type(tt.oid,tt.typtypmod) AS trgtyp,
ns.nspname AS src
nspname, nt.nspname AS trgnspname,
 proname, np.nspname AS pronspname, description
  FROM pg_cast ca
  JOIN pg_type st ON st.oid=castsource
  JOIN pg_namespace ns ON ns.oid=st.typnamespace
  JOIN pg_type tt ON tt.oid=casttarget
  JOIN pg_namespace nt ON nt.oid=tt.typnamespace
  LEFT JOIN pg_proc pr ON pr.oid=castfunc
  LEFT JOIN pg_namespace np ON np.oid=pr.pronamespace
  LEFT OUTER JOIN pg_description des ON des.objoid=ca.oid AND
des.objsubid=0
 WHERE ca.oid > 10818
 ORDER BY st.typname, tt.typname
2007-06-21 10:03:43 [5050] DEBUG:pool_process_query():read kind from
backend T
2007-06-21 10:03:43 [5050] DEBUG:pool_process_query():read kind from
backend pen
ding data C len: 17 po: 337
2007-06-21 10:03:43 [5050] DEBUG:pool_process_query():read kind from
backend pen
ding data Z len: 5 po: 349
2007-06-21 10:03:43 [5050] DEBUG:ReadyForQuery(): message length: 5
2007-06-21 10:03:43 [5050] DEBUG:ReadyForQuery(): transaction state: I
2007-06-21 10:03:43 [5050] DEBUG:ProcessFrontendResponse():read kind
from fronte
nd Q(51)
2007-06-21 10:03:43 [5050] DEBUG:Query(): SELECT lan.oid, lan.lanname,
lanpltrus
ted, lanacl, hp.proname as lanproc, vp.proname as lanval, description
  FROM pg_language lan
  JOIN pg_proc hp on hp.oid=lanplcallfoid
  LEFT OUTER JOIN pg_proc vp on vp.oid=lanvalidator
  LEFT OUTER JOIN pg_description des ON des.objoid=lan.oid AND
des.objsubid=0
 WHERE lanispl IS TRUE
 ORDER BY lanname
2007-06-21 10:03:43 [5050] DEBUG:pool_process_query():read kind from
backend T
2007-06-21 10:03:43 [5050] DEBUG:pool_process_query():read kind from
backend pen      ding data C len: 17 po: 192
2007-06-21 10:03:43 [5050] DEBUG:pool_process_query():read kind from
backend pen      ding data Z len: 5 po: 204
2007-06-21 10:03:43 [5050] DEBUG:ReadyForQuery(): message length: 5
2007-06-21 10:03:43 [5050] DEBUG:ReadyForQuery(): transaction state: I
2007-06-21 10:03:43 [5050] DEBUG:ProcessFrontendResponse():read kind
from fronte      nd Q(51)
2007-06-21 10:03:43 [5050] DEBUG:Query(): SELECT CASE WHEN nspname LIKE
E'pg\_te      mp\_%%' THEN 1
            WHEN (nspname LIKE E'pg\_%' OR nspname =
'information_schema') THEN       0
            ELSE 3 END AS nsptyp,
       nsp.nspname, nsp.oid, pg_get_userbyid(nspowner) AS
namespaceowner, nspacl      , description,
has_schema_privilege(nsp.oid, 'CREATE') as cancreate
  FROM pg_namespace nsp
  LEFT OUTER JOIN pg_description des ON des.objoid=nsp.oid
 ORDER BY 1, nspname
2007-06-21 10:03:43 [5022] DEBUG:set_recovery():received no:101
2007-06-21 10:03:43 [5022]
DEBUG:PGRset_status_on_cluster_tbl():host:fcdatarp po      rt:5432
max:32 use:2 status99
2007-06-21 10:10:37 [5050] ERROR:pool_read: EOF encountered
2007-06-21 10:10:37 [5050] ERROR:ProcessFrontendResponse(): failed to
read kind
2007-06-21 10:23:49 [5021] DEBUG:PGRscan_cluster:0 ClusterDB can be used
2007-06-21 10:23:49 [5021] DEBUG:PGRscan_cluster:fcdatarp
[5432],useFlag->99 max->32 use_num->0

2007-06-21 10:23:49 [5021] DEBUG:PGRscan_cluster:0 ClusterDB can be used
2007-06-21 10:23:49 [5021] DEBUG:PGRscan_cluster:fcdatarp
[5432],useFlag->99 max->32 use_num->0

2007-06-21 10:23:49 [5021] DEBUG:PGRscan_cluster:0 ClusterDB can be used
2007-06-21 10:23:49 [5021] DEBUG:PGRscan_cluster:fcdatarp
[5432],useFlag->99 max->32 use_num->0

2007-06-21 10:23:49 [5021] DEBUG:PGRscan_cluster:0 ClusterDB can be used
2007-06-21 10:23:49 [5021] DEBUG:PGRscan_cluster:fcdatarp
[5432],useFlag->99 max->32 use_num->0




M.


To read FirstRand Bank's Disclaimer for this email click on the following address or copy into your Internet browser: 
https://www.fnb.co.za/disclaimer.html 

If you are unable to access the Disclaimer, send a blank e-mail to
firstrandbankdisclaimer at fnb.co.za and we will send you a copy of the Disclaimer.

More information about the Pgcluster-general mailing list