+1-888-365-2779
Try Now
More in this section

Forums / General Discussions / Read-only database error - PLEASE HELP!!

Read-only database error - PLEASE HELP!!

5 posts, 0 answered
  1. Beth Grabo
    Beth  Grabo avatar
    6 posts
    Registered:
    02 Mar 2010
    09 Feb 2012
    Link to this post
    Hello all.  Have a problem I was hoping someone could help me with.  I made a change to our _Common.master file (added a new script library link) and saved the file.  Now all of a sudden, our site will not come up- it is repeatedly giving us "the database is read-only" error. (see screen shot) Thinking the problem was the script library link, I immediately removed the line and re-saved the _Common.master as it originally was.  However, regardless of the change inside the file, we are still getting the read-only error.  ??

    I presume that the simple act of opening and saving the file has kicked off some "log" or tracking process that is telling Sitefinity to record that the _Common.master file was edited.  But, since our db is read-only (because it is our public facing box), the process is trying to record this fact and is being rejected.  

    This happened last Friday and we still can't get rid of this error.   Does anyone have a suggestion?  Is there a way to reset- or kill the process that is trying to write to the db?  Can I turn that setting off on our Sitefinity configuration?    

    We are at a standstill and can't move forward.  Any hints, suggestions, theories, or help is greatly appreciated. 

    Thanks so much

    -Jack
  2. Svetoslav Petsov
    Svetoslav Petsov avatar
    456 posts
    Registered:
    24 Sep 2012
    14 Feb 2012
    Link to this post
    Hi Beth,

     Did you try restarting your server and recycling the app pool after you deleted the problematic script? A simple restart/recycle would have to kill such a process.

    Kind regards,
    Svetoslav Petsov
    the Telerik team
    Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  3. Beth Grabo
    Beth  Grabo avatar
    6 posts
    Registered:
    02 Mar 2010
    14 Feb 2012
    Link to this post
    Thanks Svetoslav for your reply.  Yes, we did recycle the app pool and restarted the server.  But the problem is I don't know what problematic script is causing SF to want to write to the database.  All I did was edit the _Common.master file and save it.  I then reversed my edit and changed the _Common.master file back to the way it was.  But somehow something is still trying to write to the database.  I'd gladly delete any script.  Which script wants to write to the db when I edit a file?  I'm not updating any data that would need to go to the db, so I presume it is trying to write to a log of some sort- recording that the file was edited.    Any ideas of how to turn off logs at this point?
  4. Svetoslav Petsov
    Svetoslav Petsov avatar
    456 posts
    Registered:
    24 Sep 2012
    17 Feb 2012
    Link to this post
    Hello Beth,

     Is there a chance that you could give write permissions to the database, so that the update can be submitted, and then put it back on read-only? I think this would be the only decision in this case, as there is no other way to stop the update process.

    Greetings,
    Svetoslav Petsov
    the Telerik team
    Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  5. Anshu
    Anshu avatar
    1 posts
    Registered:
    12 Jul 2012
    09 Aug 2012
    Link to this post

    Hello,

    we have setup a failover site which was running  with Read-Only database for long time without any issue. Now that site do not run with Read-Only database, after trace we found that stored procedure [dbo].[NN_NextValue]
    trying to update Column "CounterValue" of table  [dbo].[NN_Counters].
    Can you please let me know what is  [dbo].[NN_Counters] all about?

    Thanks

Register for webinar
5 posts, 0 answered