Mailing List Archive: DB2 agent patch 1/3: Fix race between agent's activate and client connect

DB2 agent patch 1/3: Fix race between agent's activate and client connect

Nov 4, 2010, 1:28 AM

Post #1 of 3 (884 views)

# HG changeset patch
# User Holger Teutsch <holger.teutsch@web.de>
# Date 1288857217 -3600
# Node ID 554ebfef6e9513178ea04cc4093710b65311934a
# Parent 778e9bcc750fbe85792216a899a49823849f6c5d
Don't let the start method fail when a client connects faster to the db than we activate the db
i.e.
SQL1494W Activate database is successful, however, there is already a connection to the database
is success and not failure

diff -r 778e9bcc750f -r 554ebfef6e95 heartbeat/db2
--- a/heartbeat/db2 Tue Nov 02 12:04:05 2010 +0100
+++ b/heartbeat/db2 Thu Nov 04 08:53:37 2010 +0100
@@ -202,7 +202,7 @@ db2_start() {
ocf_log info "DB2 UDB database $DB activated"
else
case $output in
- SQL1490W*|*"already been activated"*)
+ SQL1490W*|SQL1494W*|*"already been activated"*)
ocf_log info "DB2 UDB database $DB already activated: $output";;

*) ocf_log err "DB2 UDB database $DB didn't activate: $output"; return $OCF_ERR_GENERIC;;
___________________________________________________________
GRATIS! Movie-FLAT mit Ã¼ber 300 Videos.
Jetzt freischalten unter http://movieflat.web.de
_______________________________________________________
Linux-HA-Dev: Linux-HA-Dev@lists.linux-ha.org
http://lists.linux-ha.org/mailman/listinfo/linux-ha-dev
Home Page: http://linux-ha.org/

Re: DB2 agent patch 1/3: Fix race between agent's activate and client connect [ In reply to ]

dejanmm at fastmail

Nov 4, 2010, 3:28 AM

Post #2 of 3 (865 views)

Permalink

Hi Holger,

All the patches fail to apply. If your copy of db2 is up to date,
then it's probably an issue with white space. Can you please send
the patches as attachments.

Thanks,

Dejan

On Thu, Nov 04, 2010 at 09:28:50AM +0100, Holger.Teutsch@web.de wrote:
> # HG changeset patch
> # User Holger Teutsch <holger.teutsch@web.de>
> # Date 1288857217 -3600
> # Node ID 554ebfef6e9513178ea04cc4093710b65311934a
> # Parent 778e9bcc750fbe85792216a899a49823849f6c5d
> Don't let the start method fail when a client connects faster to the db than we activate the db
> i.e.
> SQL1494W Activate database is successful, however, there is already a connection to the database
> is success and not failure
>
> diff -r 778e9bcc750f -r 554ebfef6e95 heartbeat/db2
> --- a/heartbeat/db2 Tue Nov 02 12:04:05 2010 +0100
> +++ b/heartbeat/db2 Thu Nov 04 08:53:37 2010 +0100
> @@ -202,7 +202,7 @@ db2_start() {
> ocf_log info "DB2 UDB database $DB activated"
> else
> case $output in
> - SQL1490W*|*"already been activated"*)
> + SQL1490W*|SQL1494W*|*"already been activated"*)
> ocf_log info "DB2 UDB database $DB already activated: $output";;
>
> *) ocf_log err "DB2 UDB database $DB didn't activate: $output"; return $OCF_ERR_GENERIC;;
> ___________________________________________________________
> GRATIS! Movie-FLAT mit über 300 Videos.
> Jetzt freischalten unter http://movieflat.web.de
> _______________________________________________________
> Linux-HA-Dev: Linux-HA-Dev@lists.linux-ha.org
> http://lists.linux-ha.org/mailman/listinfo/linux-ha-dev
> Home Page: http://linux-ha.org/
_______________________________________________________
Linux-HA-Dev: Linux-HA-Dev@lists.linux-ha.org
http://lists.linux-ha.org/mailman/listinfo/linux-ha-dev
Home Page: http://linux-ha.org/

Re: DB2 agent patch 1/3: Fix race between agent's activate and client connect [ In reply to ]

Holger.Teutsch at web

Nov 4, 2010, 4:03 AM

Post #3 of 3 (845 views)

Permalink

-----UrsprÃ¼ngliche Nachricht-----
Von: "Dejan Muhamedagic" <dejanmm@fastmail.fm>
Gesendet: Nov 4, 2010 11:28:38 AM
An: "High-Availability Linux Development List" <linux-ha-dev@lists.linux-ha.org>
Betreff: Re: [Linux-ha-dev] DB2 agent patch 1/3: Fix race between agent's activate and client connect

>Hi Holger,
>
>All the patches fail to apply. If your copy of db2 is up to date,
>then it's probably an issue with white space. Can you please send
>the patches as attachments.
>
>Thanks,
>
>Dejan

Dejan,
hopefully the will work now.

Thanx
Holger
___________________________________________________________
Neu: WEB.DE De-Mail - Einfach wie E-Mail, sicher wie ein Brief!
Jetzt De-Mail-Adresse reservieren: https://produkte.web.de/go/demail02

Mailing List Archive

Mailing List Archive

Attached Files: