Switch RSS secondary back to Primary
Murali Pazhayannur asked how to re-establish a primary plus RSS pair after failover on 11.50.FC5, HP-UX. Nilesh Ozarkar advised running hdrmksec.sh on the old primary, then converting that HDR secondary to RSS with onmode -d RSS. Murali then saw 'Cannot create new proxy session' and error 240 until he restarted the RSS server. Nilesh said no restart should be needed and that it was a defect fixed in a later release.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
The switch back to re-establish the Primary-Secondary HDR pair after a failover is documented and the scripts to do this are in $INFORMIXDIR/bin (hdrmkpri.sh* hdrmksec.sh*). Are there similar scripts available to re-establish a Primary-RSS secondary server after a failover to the secondary? If not, I would appreciate just the steps to do this that I can script. I understand that an RSS secondary cannot be promoted to a Primary directly. ( IDS 11.50.FC5 on HP-UX 11.23 Ia).
Once RSS is promoted to a primary, you could take these steps ...
on old primary run :
hdrmksec.sh <current-primary-name>
This would setup a HDR secondary for you, then convert that HDR Secondary
to RSS using 'onmode -d RSS <current-primary-name>'.
Hope this helps.
- Nilesh -
ids-bounces@iiug.org wrote on 05/11/2010 08:01:03 AM:
> From:
>
> "MURALI PAZHAYANNUR" <pmurali@ftportfolios.com>:
>
> To:
>
> ids@iiug.org
>
> Date:
>
> 05/11/2010 08:02 AM
>
> Subject:
>
> Switch RSS secondary back to Primary [20091]
>
> Sent by:
>
> ids-bounces@iiug.org
>
> The switch back to re-establish the Primary-Secondary HDR pair after a
> failover is documented and the scripts to do this are in $INFORMIXDIR/bin
> (hdrmkpri.sh* hdrmksec.sh*). Are there similar scripts available to
> re-establish a Primary-RSS secondary server after a failover to the
> secondary?
> If not, I would appreciate just the steps to do this that I can script. I
> understand that an RSS secondary cannot be promoted to a Primary
directly. (
> IDS 11.50.FC5 on HP-UX 11.23 Ia).
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
I did what Nilesh adviced on and here's what happenned:
OAT (2.27) shows that the servers (Prim-RSS sec (updatable)) are connected.
However, nothing is getting written to the RSS.online log.
On RSS I see the following written to the online log when I bring up dbaccess:
14:29:31 Encountered problem processing update on secondary : Cannot create
new proxy session
I went to delete rows from a table and got this
240: Could not delete a row.Connection between secondary and primary has been lost
I stopped-restarted the RSS server, it reconnected to the Primary and the
delete statement worked.
Question: Once an HDR Secondary is demoted to RSS is it necessary to restart
the RSS secondary? It appears so, at least.
ids-bounces@iiug.org wrote on 05/13/2010 08:54:12 AM:
> From:
>
> "MURALI PAZHAYANNUR" <pmurali@ftportfolios.com>:
>
> To:
>
> ids@iiug.org
>
> Date:
>
> 05/13/2010 08:55 AM
>
> Subject:
>
> Re: Switch RSS secondary back to Primary [20130]
>
> Sent by:
>
> ids-bounces@iiug.org
>
> I did what Nilesh adviced on and here's what happenned:
>
> OAT (2.27) shows that the servers (Prim-RSS sec (updatable)) are
connected.
> However, nothing is getting written to the RSS.online log.
>
> On RSS I see the following written to the online log when I bring
updbaccess:
> 14:29:31 Encountered problem processing update on secondary : Cannot
create
> new proxy session
>
> I went to delete rows from a table and got this
> 240: Could not delete a row.> Connection between secondary and primary has been lost
>
> I stopped-restarted the RSS server, it reconnected to the Primary and the
> delete statement worked.
>
> Question: Once an HDR Secondary is demoted to RSS is it necessary to
restart
> the RSS secondary? It appears so, at least.
>
No - you should be able to use RSS without the need to restart.
What you noticed was a defect which got fixed in later release.
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>