At.Mitani -
Thanks for the quick reply. I have already tried setting the
not_replicate_prepared_select to 'true' - now I tried with 'yes' also. That did
not make any difference. With just one user and that too after using couple of
minutes, I see 108 entries in pg_locks... which seem to be too much.
dikpala-cosme=# select count(*) from pg_locks;
count
-------
108
(1 row)
Why did you call the variable "not_replicate_prepared_select" - is it only
applicable for prepared select and not for dynamic selects?
Anything else?
Regards,
Hari Gangadharan
The /etc/hosts is as follows (also the ifconfig to show ipaddress):
# cat /etc/hosts
127.0.0.1 localhost node-1
10.252.71.16 cluster_1 rep_1 lb_1
10.252.47.70 cluster_2 rep_2 lb_2 db-host
# ifconfig
eth0 Link encap:Ethernet HWaddr 12:31:38:00:28:B8
inet addr:10.252.47.70 Bcast:10.252.47.255 Mask:255.255.254.0
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:2908807 errors:0 dropped:0 overruns:0 frame:0
TX packets:3154803 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:662880498 (632.1 MiB) TX bytes:1652103126 (1.5 GiB)
....
# cat /etc/hosts
127.0.0.1 localhost node-1
10.252.71.16 cluster_1 rep_1 lb_1
10.252.47.70 cluster_2 rep_2 lb_2 db-host
# ifconfig
eth0 Link encap:Ethernet HWaddr 12:31:38:00:40:E2
inet addr:10.252.71.16 Bcast:10.252.71.255 Mask:255.255.254.0
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:1119951 errors:0 dropped:0 overruns:0 frame:0
TX packets:883258 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:254151981 (242.3 MiB) TX bytes:243019474 (231.7 MiB)
...
> Date: Fri, 28 Dec 2007 09:25:00 +0900
> From: [EMAIL PROTECTED]
> To: [email protected]
> Subject: Re: [Pgcluster-general] PGCluster 1.7 seems to be stuck in deadlocks
>
> Hi Hari,
>
> Would you let us know the "/etc/hosts" in each servers.
> Did you set "yes" to "not_replicate_prepared_select" in the postgresql.conf ?
> If you don't use stored procedure with SELECT query, I recomend to set "yes"
> for it.
> Otherwise all queries are replicated when application uses JDBC.
>
> Regards,
> ----------------
> At.Mitani
>
> _______________________________________________
> Pgcluster-general mailing list
> [email protected]
> http://pgfoundry.org/mailman/listinfo/pgcluster-general
_________________________________________________________________
Don't get caught with egg on your face. Play Chicktionary!
http://club.live.com/chicktionary.aspx?icid=chick_wlhmtextlink1_dec_______________________________________________
Pgcluster-general mailing list
[email protected]
http://pgfoundry.org/mailman/listinfo/pgcluster-general
