472,807 Members | 3,593 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,807 software developers and data experts.

Database switching to read_only mode randomly

Ok, I'm looking for expert advice on this one.

I have a database which keeps going into read_only mode. Sometimes it goes into read_only / single user mode. Once it was taken offline completely. This seemingly happens randomly. Out of all of the database I have worked with, this has happened on 3 of them - several times randomly to each. All three of the databases that have exhibited this behaviour have been databases I have written for the company to which I am currently employed by. Once with SQL server 2000, another with sql server 2005, and another with SQL server 2008. Two of the database this happened to were/are using an asp.net front end - the other one was over 2 years ago and was using an ASP classic front end.

To be blunt, I believe a colleague who works for the same company is doing this in order to discredit me. I am almost certain about it, since it has happened at extremely odd times - like the day before a project review meeting where I really don't need to be spending hours trying to get my database out of read only mode - or today.. which was the worst occurrence yet - while in a project review meeting, he attempted to throw the database design under the bus directly to the boss man - to which the end result was us agreeing we would stress test the database to see whether in fact there is a problem with the design of the database or just any point of the database itself. I created a stored procedure to slam a parent table with 1,000,000 records, and then insert 40 records into a child table for each parent record. 41,000,000 records in total. (and yes I realize that's not an accurate test) If that was successful, I was going to perform other tests, this was just a good enough place to start. All was going good for 45 minutes, around 9,000,000 rows inserted and counting with minimal effort on the database server's part considering the feat it was performing. I left my desk to walk out of the building at 4:57ish and left the script to continue executing, give or take (while my colleage was still upstairs I might add). I got home later on, and the query had bombed. I checked the logs and the database went into read_only mode at 5:02.

The "dispute" between my colleague and I is over database design concept. He wrote the original one for the company - one that includes more than a few tables with 350+ columns. Rampant misuse of data types, no stored procedures. Horribly written views, etc. The database is written based on column based input, instead of row based relational data.

The database which I have structured - and which all three databases exhibiting this behaviour are/were structured like - uses relational n-tier structures with stored procedures, triggers, etc. EG: Table A has parent record, Table B is a "child" table of Table A and has 20 subsidiary records which relate to the parent record in Table A.

So.. I have several questions: Most of them simply because I'm second guessing myself now given the recent events, and I need to verify I'm not nuts.

1) Is this normal behaviour given my database design
2) Have I made serious error in the design of the database?
3) Is my colleague screwing with me?
4) If my colleague is screwing with me, can you think of any way I can set a trap for him and/or track by which method and/or user this issue is being executed - is there any way I can obtain proof that he is screwing with me.
5) Would you recommend any tweaks to my database design, or is it pretty standard?
6) The existing database, built by my colleague years ago has tables in it with 350 columns. Is 350+ columns in a single database table ludicrous or common place? It's ludicrous from my experiences, but I want to gather other people's thoughts on the matter.
7) If I'm not being screwed with, can you think of anything that could cause such a problem to occur?

Thanks, and I look forward to your responses on the matter :)
Oct 6 '09 #1
2 5113
2,878 Expert 2GB
Looks to me like a personality problem, not a technical problem.

If your friend does not need admin rights, give him a user rights.

--- CK
Oct 7 '09 #2
1 Bit
wow, just wow! instead of learning from your methodologies and improving his skillset, he does this.

whelp, i would put some logging in / monitoring the server / lock his account, etc., but prove his account is doing this / what times, etc., then go to him with it (not the boss, no one likes a tattle tale) and tell him next time you'll take him to the boss, yourself, and let him decide what to do with the guy.

Or, can you redirect his account to a mock-database? maybe with registry / environment variables, etc.- you can redirect his account access to that mock-dbase, and he'll be none the wiser, whilst you and your stakeholders move along into the 22nd century.
Jul 16 '21 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

by: Joseph Cook | last post by:
I was wondering if there was any way to do the following: If I have a class Base, and multiple Derived classes which all have some different behavior on some function foo()...is there any good...
by: Matthew Wells | last post by:
I have a a parent form with a subform. The parent form has two command buttons to change the subform view to single form view and datasheet view respectively. I can't seem to get this to work. ...
by: None | last post by:
Hi, I'm sure this a FAQ-worthy one, but.... I need a fairly simple database to catalogue a large number of photographs. The primary purpose is to be able to search on fields to see if a...
by: Macca | last post by:
Hi, I have an windows forms application that accesses a SQL database I have a few questions as to connecting to the database. This application will run 24 hours a day. It is a monitoring...
by: Petra Chong | last post by:
Hello all I am using Python 2.3 and ZODB (without the rest of Zope) with the following pattern: * One process which writes stuff to a ZODB instance (call it test.db) * Another process which...
by: war_wheelan | last post by:
I created the db with the attached script and I am able to access it until I reboot the server. I've tried enabling flag 1807 via the SQL server service and the startup parameters of the instance....
by: tamaker | last post by:
Is this do-able with ASP / VBscript? -- I have a database with user records (name, photo, etc. etc.) I want to use asp to generate (on the homepage) a series of 4 randomly selected 'user...
by: Gordon | last post by:
I want to add a feature to a project I'm working on where i have multiple users set up on my Postgres database with varying levels of access. At the bare minimum there will be a login user who...
by: Sam Lambson | last post by:
Hi, This is similar to another post, because I still haven't gotten to the bottom of it. I have a back end database on a shared drive. Each (of 4) user has a front end file on their own C:...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 2 August 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
by: erikbower65 | last post by:
Using CodiumAI's pr-agent is simple and powerful. Follow these steps: 1. Install CodiumAI CLI: Ensure Node.js is installed, then run 'npm install -g codiumai' in the terminal. 2. Connect to...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Sept 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
by: Taofi | last post by:
I try to insert a new record but the error message says the number of query names and destination fields are not the same This are my field names ID, Budgeted, Actual, Status and Differences ...
by: DJRhino1175 | last post by:
When I run this code I get an error, its Run-time error# 424 Object required...This is my first attempt at doing something like this. I test the entire code and it worked until I added this - If...
by: DJRhino | last post by:
Private Sub CboDrawingID_BeforeUpdate(Cancel As Integer) If = 310029923 Or 310030138 Or 310030152 Or 310030346 Or 310030348 Or _ 310030356 Or 310030359 Or 310030362 Or...
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
by: lllomh | last post by:
How does React native implement an English player?
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.