Thursday, September 6, 2018

Database "Not synchronizing / suspect" in Always On High Availability Groups

We recently configured Always On with 2 secondary servers. One secondary is synchronous commit and another with Asynchronous commit.

We are running log backup but noticed that secondary couldn’t redo the log at secondary and kept on piling the log and the drive got full.

Run below command to see what log is not clearing out
SELECT name, log_reuse_wait_desc FROM sys.databases WHERE name = 'HRDB';

Name    log_reuse_wait_desc
--------  -------------------------------
HRDB    AVAILABILITY_REPLICA

For short term add space or you might have to remove database from AlwaysOn Group and add it back. 

In the log we see “Could not redo log record” message 

Could not redo log record (40557:30625:14), for transaction ID (0:196794283), on page (1:1033), allocation unit 72058591529205760, database 'HRDB' (database ID 7). Page: LSN = (40557:30379:326), allocation unit = 72058646460891136, type = 10. Log: OpCode = 7, context 10, PrevPageLSN: (40557:30625:12). Restore from a backup of the database, or repair the database.

After troubleshooting it looks like a Bug and need to apply Cumulative patch

https://support.microsoft.com/en-us/help/3173471/fix-could-not-redo-log-record-error-and-replica-is-suspended-in-sql-se

Thanks
Satishbabu Gunukula
http://www.sqlserver-expert.com

37 comments:

  1. Superb site you have here but I was wanting to know if you knew of any forums that cover the same topics discussed in this article? I'd really like to be a part of group where I can get suggestions from other knowledgeable individuals that share the same interest. If you have any suggestions, please let me know. Thank you! set up a website

    ReplyDelete
  2. This sort of learning upgrades your down to earth information alongside hypothetical learning and it likewise increases the value of your resume or CV.ExcelR Data Science Courses

    ReplyDelete
  3. MediaOne has become the top website design company in singapore with their experience and expertise in the web designing arena. The experts of the agency would ensure to provide you the right web design meeting your standards without burning a hole in your pocket.

    ReplyDelete
  4. Attend The Data Analytics Courses From ExcelR. Practical Data Analytics Courses Sessions With Assured Placement Support From Experienced Faculty. ExcelR Offers The Data Analytics Courses.
    ExcelR Data Analytics Courses

    ReplyDelete
  5. What’s Happening i'm new to this, I stumbled upon this I have found It absolutely helpful and it has aided me out loads. I hope to contribute & help other users like its helped me. Good job. digital defence Singapore

    ReplyDelete
  6. I do agree with all of the ideas you've presented in your post. They're very convincing and will certainly work. Still, the posts are very short for newbies. Could you please extend them a bit from next time? Thanks for the post. 3 room bto interior design

    ReplyDelete
  7. Pretty nice post. I just stumbled upon your blog and wanted to say that I have really enjoyed surfing around your blog posts. After all I’ll be subscribing to your feed and I hope you write again very soon! event logistics Singapore

    ReplyDelete
  8. I found your this post while looking for details about blog-related research ... It's a good post .. keep posting and updating information. ashes to diamond

    ReplyDelete
  9. digital marketing courses in hyderabad by 360DigiTMG is the best one with quality training, best support and more than 9,000 Students Enrolled
    360DigiTMG digital marketing course

    ReplyDelete
  10. Hola! I've been reading your blog for a while now and finally got the courage to go ahead and give you a shout out from Atascocita Texas! Just wanted to say keep up the good job! paragon medical centre

    ReplyDelete
  11. Wow, awesome blog layout! How long have you been blogging for? you made blogging look easy. The overall look of your website is wonderful, as well as the content! List of Wastewater Treatment Companies in Singapore

    ReplyDelete
  12. Magnificent site. Plenty of useful info here. I am sending it to some friends ans also sharing in delicious. And obviously, thanks for your effort! estate planning

    ReplyDelete
  13. If your looking for Online Illinois license plate sticker renewals then you have need to come to the right place.We offer the fastest Illinois license plate sticker renewals in the state.
    data science course
    360DigiTMG

    ReplyDelete
  14. Excellent Blog! I would like to thank for the efforts you have made in writing this post. I am hoping the same best work from you in the future as well. I wanted to thank you for this websites! Thanks for sharing. Great websites!
    data science course in indore

    ReplyDelete
  15. I was just browsing through the internet looking for some information and came across your blog. I am impressed by the information that you have on this blog. It shows how well you understand this subject. Bookmarked this page, will come back for more.
    360DigiTMG PMP Certification
    360DigiTMG PMP Course in malaysia
    360DigiTMG PMP Course
    360DigiTMG PMP Training in malaysia
    360DigiTMG PMP Training

    ReplyDelete
  16. Hi buddies, it is great written piece entirely defined, continue the good work constantly.data science course

    ReplyDelete
  17. Awesome blog. I enjoyed reading your articles. This is truly a great read for me. I have bookmarked it and I am looking forward to reading new articles. Keep up the good work!
    data analytics course
    big data analytics malaysia
    big data course

    ReplyDelete
  18. Very interesting blog. Many blogs I see these days do not really provide anything that attracts others, but believe me the way you interact is literally awesome.You can also check my articles as well.

    Data Science In Banglore With Placements
    Data Science Course In Bangalore
    Data Science Training In Bangalore
    Best Data Science Courses In Bangalore
    Data Science Institute In Bangalore

    Thank you..

    ReplyDelete
  19. Thank you for helping people get the information they need. Great stuff as usual. Keep up the great work!!!
    data analytics certification training course

    ReplyDelete
  20. Thank you for this fascinating post, I am happy I observed this website on Google. Not just content, in fact, the whole site is fantastic.

    ReplyDelete
  21. Thanks for the blog filled with so many information. Stopping by your blog helped me to get what I was looking for. Now my task has become as easy as ABC. dotcom secrets

    ReplyDelete
  22. I have to search sites with relevant information ,This is a
    wonderful blog,These type of blog keeps the users interest in
    the website, i am impressed. thank you.
    Data Science Course in Bangalore

    ReplyDelete
  23. I have to search sites with relevant information ,This is a
    wonderful blog,These type of blog keeps the users interest in
    the website, i am impressed. thank you.
    Data Science Training in Bangalore

    ReplyDelete
  24. I know this if off topic but I'm looking into starting my own weblog and was curious what all is needed to get set up? I'm assuming having a blog like yours would cost a pretty penny? I'm not very internet smart so I'm not 100% sure. Any suggestions or advice would be greatly appreciated. Cheerskose sekkisei

    ReplyDelete
  25. Very good message. I stumbled across your blog and wanted to say that I really enjoyed reading your articles. Anyway, I will subscribe to your feed and hope you post again soon.

    Business Analytics Course

    ReplyDelete
  26. Nice article. I liked very much. All the information given by you are really helpful for my research. keep on posting your views.
    data science in malaysia

    ReplyDelete
  27. Your content is very unique and understandable useful for the readers keep update more article like this.
    data science course in gurgaon

    ReplyDelete
  28. Nice post! This is a very nice blog that I will definitively come back to more times this year! Thanks for informative post.

    mystrikingly weebly Rhinoplasty

    ReplyDelete
  29. Thanks for your sharing great article, I am very happy to read this article and I like it very much!I would also recommend it to my friends.
    sun news live
    sun news
    sun tv live
    news 7 live
    sun news live today
    sun tv news
    sun tv news live
    sun tv live news
    சன் நியூஸ்
    thanthinews

    ReplyDelete
  30. I will really appreciate the writer's choice for choosing this excellent article appropriate to my matter.Here is deep description about the article matter which helped me more.
    data science course

    ReplyDelete
  31. I wanted to leave a little comment to support you and wish you a good continuation. Wishing you the best of luck for all your blogging efforts.
    data science training in malaysia

    ReplyDelete
  32. This article content is really unique and amazing. This article really helpful and explained very well. So I am really thankful to you for sharing keep it up.. Mason Jacob

    ReplyDelete