FAQ Search Today's Posts Mark Forums Read
» Video Reviews

» Linux Archive

Linux-archive is a website aiming to archive linux email lists and to make them easily accessible for linux users/developers.


» Sponsor

» Partners

» Sponsor

Go Back   Linux Archive > Redhat > Fedora Infrastructure

 
 
LinkBack Thread Tools
 
Old 11-05-2009, 08:08 PM
 
Default change request: switch MM off using pgpool

all MM apps running on bapp1 are stalled because pgpool is hung. MM has lots of connections to pgpool, more than it can handle. Until this is understood, go back to not using pgpool for MM.

diff --git a/modules/mirrormanager/templates/mirrormanager-prod.cfg.erb b/modules/mirrormanager/templates/mirrormanager-prod.cfg.erb
index e17022d..1b60465 100644
--- a/modules/mirrormanager/templates/mirrormanager-prod.cfg.erb
+++ b/modules/mirrormanager/templates/mirrormanager-prod.cfg.erb
@@ -15,7 +15,7 @@

# This is for local development purposes. It won't be used for
# production.
-sqlobject.dburi="notrans_postgres://mirroradmin:<%= mirrorPassword %>@db2.fedora.phx.redhat.com:9999/mirrormanager"
+sqlobject.dburi="notrans_postgres://mirroradmin:<%= mirrorPassword %>@db2.fedora.phx.redhat.com:5432/mirrormanager"

# if you are using a database or table type without transactions
# (MySQL default, for example), you should turn off transactions


--
Matt Domsch
Technology Strategist, Dell Office of the CTO
linux.dell.com & www.dell.com/linux



_______________________________________________
Fedora-infrastructure-list mailing list
Fedora-infrastructure-list@redhat.com
https://www.redhat.com/mailman/listinfo/fedora-infrastructure-list
 
Old 11-05-2009, 08:20 PM
Mike McGrath
 
Default change request: switch MM off using pgpool

On Thu, 5 Nov 2009, Matt_Domsch@Dell.com wrote:

> all MM apps running on bapp1 are stalled because pgpool is hung. MM has lots of connections to pgpool, more than it can handle. Until this is understood, go back to not using pgpool for MM.
>
> diff --git a/modules/mirrormanager/templates/mirrormanager-prod.cfg.erb b/modules/mirrormanager/templates/mirrormanager-prod.cfg.erb
> index e17022d..1b60465 100644
> --- a/modules/mirrormanager/templates/mirrormanager-prod.cfg.erb
> +++ b/modules/mirrormanager/templates/mirrormanager-prod.cfg.erb
> @@ -15,7 +15,7 @@
>
> # This is for local development purposes. It won't be used for
> # production.
> -sqlobject.dburi="notrans_postgres://mirroradmin:<%= mirrorPassword %>@db2.fedora.phx.redhat.com:9999/mirrormanager"
> +sqlobject.dburi="notrans_postgres://mirroradmin:<%= mirrorPassword %>@db2.fedora.phx.redhat.com:5432/mirrormanager"
>
> # if you are using a database or table type without transactions
> # (MySQL default, for example), you should turn off transactions
>
>

+1

-Mike

_______________________________________________
Fedora-infrastructure-list mailing list
Fedora-infrastructure-list@redhat.com
https://www.redhat.com/mailman/listinfo/fedora-infrastructure-list
 
Old 11-05-2009, 08:26 PM
Ricky Zhou
 
Default change request: switch MM off using pgpool

On 2009-11-05 03:08:15 PM, Matt_Domsch@Dell.com wrote:
> all MM apps running on bapp1 are stalled because pgpool is hung. MM has lots of connections to pgpool, more than it can handle. Until this is understood, go back to not using pgpool for MM.
>
> diff --git a/modules/mirrormanager/templates/mirrormanager-prod.cfg.erb b/modules/mirrormanager/templates/mirrormanager-prod.cfg.erb
> index e17022d..1b60465 100644
> --- a/modules/mirrormanager/templates/mirrormanager-prod.cfg.erb
> +++ b/modules/mirrormanager/templates/mirrormanager-prod.cfg.erb
> @@ -15,7 +15,7 @@
>
> # This is for local development purposes. It won't be used for
> # production.
> -sqlobject.dburi="notrans_postgres://mirroradmin:<%= mirrorPassword %>@db2.fedora.phx.redhat.com:9999/mirrormanager"
> +sqlobject.dburi="notrans_postgres://mirroradmin:<%= mirrorPassword %>@db2.fedora.phx.redhat.com:5432/mirrormanager"
>
> # if you are using a database or table type without transactions
> # (MySQL default, for example), you should turn off transactions
>
>
> --
+1

Thanks,
Ricky
_______________________________________________
Fedora-infrastructure-list mailing list
Fedora-infrastructure-list@redhat.com
https://www.redhat.com/mailman/listinfo/fedora-infrastructure-list
 

Thread Tools




All times are GMT. The time now is 11:14 AM.

VBulletin, Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO ©2007, Crawlability, Inc.
Copyright 2007 - 2008, www.linux-archive.org