dbTalk Databases Forums  

ASA Mirroring

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general


Discuss ASA Mirroring in the sybase.public.sqlanywhere.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
FalseDawn
 
Posts: n/a

Default ASA Mirroring - 08-05-2009 , 09:48 AM






Hi,
ASA 11.0.1.2276

This morning we had yet another failure of our ASA mirror. As reported
before, the mirroring process just stops working. Even when both
mirrors are connected again after a network interruption, data being
inserted into the primary just stops being mirrored into the
secondary.

I'd really like this to be reported as a bug and investigated as it's
happening on a regular basis.

Thanks!



Log on secondary:

I. 08/05 01:25:33. Database "mymirror" mirroring: mirror arbiter
disconnected
I. 08/05 01:25:33. Database "mymirror" mirroring: mirror partner
disconnected
E. 08/05 01:25:36. Database "mymirror" mirroring: mirror connection
to partner failed: authentication string may not match
I. 08/05 01:25:36. Database "mymirror" mirroring: restarting to
determine mirror role
E. 08/05 01:25:37. Database "mymirror" mirroring: mirror connection
to partner failed: authentication string may not match
I. 08/05 01:25:37. Connection terminated abnormally
I. 08/05 01:25:37. Disconnected TCPIP client's AppInfo:
IP=192.168.2.15;HOST=BACKUP;OSUSER=Prod;OS='Window s XP Build 2600
Service Pack
3';EXE=o:\debug\WD.exe;PID=0xc8;THREAD=0x6dc;VERSI ON=11.0.1.2250;API=ODBC;TIMEZONEADJUSTMENT=-240
I. 08/05 01:25:37. Recovery complete
I. 08/05 01:25:37. Database "mymirror" mirroring: local status:
role=mirror, state=synchronized, sequence=14, yielding=N
I. 08/05 01:25:37. Starting database "mymirror" (D:\db\MyDB.db) at Wed
Aug 05 2009 01:25
I. 08/05 01:25:37. Performance warning: Database file "D:\db\MyDB.db"
consists of 48 disk fragments
I. 08/05 01:25:37. Database recovery in progress
I. 08/05 01:25:37. Last checkpoint at Wed Aug 05 2009 00:56
I. 08/05 01:25:37. Checkpoint log...
I. 08/05 01:25:37. Database "mymirror" mirroring: mirror partner
connected
I. 08/05 01:25:39. Transaction log: MyDB.log...
I. 08/05 01:25:40. Database "mymirror" mirroring: determining mirror
role ...
E. 08/05 01:25:41. Database "mymirror" mirroring: mirror connection
to partner failed: authentication string may not match
I. 08/05 01:25:41. Database "mymirror" mirroring: mirror partner
disconnected
I. 08/05 01:25:42. Database "mymirror" mirroring: mirror arbiter
connected
I. 08/05 01:25:46. Database "mymirror" mirroring: waiting for mirror
partner ...
E. 08/05 01:25:47. Database "mymirror" mirroring: mirror connection
to partner failed: authentication string may not match
E. 08/05 01:25:52. Database "mymirror" mirroring: mirror connection
to partner failed: authentication string may not match
E. 08/05 01:25:53. Database "mymirror" mirroring: mirror connection
to partner failed: authentication string may not match
I. 08/05 01:25:53. Database "mymirror" mirroring: becoming primary
server
I. 08/05 01:25:53. Rollback log...
I. 08/05 01:25:53. Checkpointing...
I. 08/05 01:25:53. Starting checkpoint of "mymirror" (MyDB.db) at Wed
Aug 05 2009 01:25
I. 08/05 01:25:53. Finished checkpoint of "mymirror" (MyDB.db) at Wed
Aug 05 2009 01:25
I. 08/05 01:25:54. Recovery complete
I. 08/05 01:25:59. Database "mymirror" (MyDB.db) started at Wed Aug 05
2009 01:25
I. 08/05 01:45:54. Starting checkpoint of "mymirror" (MyDB.db) at Wed
Aug 05 2009 01:45
I. 08/05 01:45:54. Finished checkpoint of "mymirror" (MyDB.db) at Wed
Aug 05 2009 01:45
I. 08/05 02:05:55. Starting checkpoint of "mymirror" (MyDB.db) at Wed
Aug 05 2009 02:05
I. 08/05 02:05:56. Finished checkpoint of "mymirror" (MyDB.db) at Wed
Aug 05 2009 02:05
I. 08/05 02:25:57. Starting checkpoint of "mymirror" (MyDB.db) at Wed
Aug 05 2009 02:25
I. 08/05 02:25:57. Finished checkpoint of "mymirror" (MyDB.db) at Wed
Aug 05 2009 02:25
I. 08/05 02:45:58. Starting checkpoint of "mymirror" (MyDB.db) at Wed
Aug 05 2009 02:45
I. 08/05 02:45:58. Finished checkpoint of "mymirror" (MyDB.db) at Wed
Aug 05 2009 02:45
I. 08/05 03:05:59. Starting checkpoint of "mymirror" (MyDB.db) at Wed
Aug 05 2009 03:05
I. 08/05 03:05:59. Finished checkpoint of "mymirror" (MyDB.db) at Wed
Aug 05 2009 03:05
I. 08/05 03:26:00. Starting checkpoint of "mymirror" (MyDB.db) at Wed
Aug 05 2009 03:26
I. 08/05 03:26:01. Finished checkpoint of "mymirror" (MyDB.db) at Wed
Aug 05 2009 03:26
I. 08/05 03:46:02. Starting checkpoint of "mymirror" (MyDB.db) at Wed
Aug 05 2009 03:46
I. 08/05 03:46:02. Finished checkpoint of "mymirror" (MyDB.db) at Wed
Aug 05 2009 03:46
I. 08/05 04:06:03. Starting checkpoint of "mymirror" (MyDB.db) at Wed
Aug 05 2009 04:06
I. 08/05 04:06:03. Finished checkpoint of "mymirror" (MyDB.db) at Wed
Aug 05 2009 04:06
I. 08/05 04:26:04. Starting checkpoint of "mymirror" (MyDB.db) at Wed
Aug 05 2009 04:26
I. 08/05 04:26:05. Finished checkpoint of "mymirror" (MyDB.db) at Wed
Aug 05 2009 04:26
I. 08/05 04:46:06. Starting checkpoint of "mymirror" (MyDB.db) at Wed
Aug 05 2009 04:46
I. 08/05 04:46:06. Finished checkpoint of "mymirror" (MyDB.db) at Wed
Aug 05 2009 04:46
I. 08/05 05:06:07. Starting checkpoint of "mymirror" (MyDB.db) at Wed
Aug 05 2009 05:06
I. 08/05 05:06:08. Finished checkpoint of "mymirror" (MyDB.db) at Wed
Aug 05 2009 05:06
I. 08/05 05:26:09. Starting checkpoint of "mymirror" (MyDB.db) at Wed
Aug 05 2009 05:26
I. 08/05 05:26:09. Finished checkpoint of "mymirror" (MyDB.db) at Wed
Aug 05 2009 05:26
I. 08/05 05:46:10. Starting checkpoint of "mymirror" (MyDB.db) at Wed
Aug 05 2009 05:46
I. 08/05 05:46:10. Finished checkpoint of "mymirror" (MyDB.db) at Wed
Aug 05 2009 05:46
I. 08/05 06:06:11. Starting checkpoint of "mymirror" (MyDB.db) at Wed
Aug 05 2009 06:06
I. 08/05 06:06:11. Finished checkpoint of "mymirror" (MyDB.db) at Wed
Aug 05 2009 06:06
I. 08/05 06:26:13. Starting checkpoint of "mymirror" (MyDB.db) at Wed
Aug 05 2009 06:26
I. 08/05 06:26:13. Finished checkpoint of "mymirror" (MyDB.db) at Wed
Aug 05 2009 06:26
I. 08/05 06:46:14. Starting checkpoint of "mymirror" (MyDB.db) at Wed
Aug 05 2009 06:46
I. 08/05 06:46:14. Finished checkpoint of "mymirror" (MyDB.db) at Wed
Aug 05 2009 06:46
I. 08/05 07:06:15. Starting checkpoint of "mymirror" (MyDB.db) at Wed
Aug 05 2009 07:06
I. 08/05 07:06:16. Finished checkpoint of "mymirror" (MyDB.db) at Wed
Aug 05 2009 07:06
I. 08/05 07:26:17. Starting checkpoint of "mymirror" (MyDB.db) at Wed
Aug 05 2009 07:26
I. 08/05 07:26:17. Finished checkpoint of "mymirror" (MyDB.db) at Wed
Aug 05 2009 07:26
I. 08/05 07:46:18. Starting checkpoint of "mymirror" (MyDB.db) at Wed
Aug 05 2009 07:46
I. 08/05 07:46:19. Finished checkpoint of "mymirror" (MyDB.db) at Wed
Aug 05 2009 07:46
I. 08/05 08:06:20. Starting checkpoint of "mymirror" (MyDB.db) at Wed
Aug 05 2009 08:06
I. 08/05 08:06:20. Finished checkpoint of "mymirror" (MyDB.db) at Wed
Aug 05 2009 08:06
I. 08/05 08:26:21. Starting checkpoint of "mymirror" (MyDB.db) at Wed
Aug 05 2009 08:26
I. 08/05 08:26:21. Finished checkpoint of "mymirror" (MyDB.db) at Wed
Aug 05 2009 08:26
I. 08/05 08:46:22. Starting checkpoint of "mymirror" (MyDB.db) at Wed
Aug 05 2009 08:46
I. 08/05 08:46:22. Finished checkpoint of "mymirror" (MyDB.db) at Wed
Aug 05 2009 08:46
I. 08/05 09:06:23. Starting checkpoint of "mymirror" (MyDB.db) at Wed
Aug 05 2009 09:06
I. 08/05 09:06:24. Finished checkpoint of "mymirror" (MyDB.db) at Wed
Aug 05 2009 09:06
I. 08/05 09:26:25. Starting checkpoint of "mymirror" (MyDB.db) at Wed
Aug 05 2009 09:26
I. 08/05 09:26:25. Finished checkpoint of "mymirror" (MyDB.db) at Wed
Aug 05 2009 09:26
I. 08/05 09:46:26. Starting checkpoint of "mymirror" (MyDB.db) at Wed
Aug 05 2009 09:46
I. 08/05 09:46:27. Finished checkpoint of "mymirror" (MyDB.db) at Wed
Aug 05 2009 09:46
I. 08/05 10:06:27. Starting checkpoint of "mymirror" (MyDB.db) at Wed
Aug 05 2009 10:06
I. 08/05 10:06:28. Finished checkpoint of "mymirror" (MyDB.db) at Wed
Aug 05 2009 10:06
I. 08/05 10:20:37. Database server shutdown requested via server
console
I. 08/05 10:20:37. Starting checkpoint of "mymirror" (MyDB.db) at Wed
Aug 05 2009 10:20
I. 08/05 10:20:37. Finished checkpoint of "mymirror" (MyDB.db) at Wed
Aug 05 2009 10:20
I. 08/05 10:20:37. Database "mymirror" mirroring: mirror arbiter
disconnected
I. 08/05 10:20:37. Database server stopped at Wed Aug 05 2009 10:20

Reply With Quote
  #2  
Old   
Reg Domaratzki [Sybase iAnywhere]
 
Posts: n/a

Default Re: ASA Mirroring - 08-07-2009 , 09:08 AM






FalseDawn wrote:
Quote:
Hi,
ASA 11.0.1.2276

This morning we had yet another failure of our ASA mirror. As reported
before, the mirroring process just stops working. Even when both
mirrors are connected again after a network interruption, data being
inserted into the primary just stops being mirrored into the
secondary.

I'd really like this to be reported as a bug and investigated as it's
happening on a regular basis.

This newsgroup is not an official forum to technical support. While
some issues that are reported on the newsgroup are simple to reproduce
and fix, yours in not.

You'll probably need to contact Technical Support to get this issue
resolved. Within North America, you can reach Technical Support
by calling 1-800-8SYBASE and selecting option 3. If you are located
outside of North America, you can find the contact information for
your local Sybase Support Center by going to
http://www.sybase.com/contactus/support.

You can always report a bug for free by visiting Case-Express at
http://case-express.sybase.com/cx/welcome.do and selecting
"Create Bug Report Case" from the left frame. When submitting calls
through Case-Express, please make sure to give an accurate description
of the steps you take to reproduce the bug, and include any
files that may be needed (database, source code) to reproduce the
problem.


--
Reg Domaratzki, Sybase iAnywhere Solutions
Please reply only to the newsgroup

Documentation : Exercise your WRITE @DocCommentXchange: DCX.sybase.com
SQL Anywhere Patches and EBFs : http://downloads.sybase.com/swd/base.do
-> Choose SQL Anywhere
-> Optionally set filter to "Display ALL platforms IN ALL MONTHS"

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.