Click here to Skip to main content
15,851,090 members
Home / Discussions / Database
   

Database

 
QuestionSql Server Database goes into Recovery mode Pin
Nilesh M. Prajapati17-Nov-23 18:59
Nilesh M. Prajapati17-Nov-23 18:59 
AnswerRe: Sql Server Database goes into Recovery mode Pin
Andre Oosthuizen18-Nov-23 8:35
mveAndre Oosthuizen18-Nov-23 8:35 
AnswerRe: Sql Server Database goes into Recovery mode Pin
Mycroft Holmes18-Nov-23 12:38
professionalMycroft Holmes18-Nov-23 12:38 
AnswerRe: Sql Server Database goes into Recovery mode Pin
CHill6020-Nov-23 5:10
mveCHill6020-Nov-23 5:10 
AnswerRe: Sql Server Database goes into Recovery mode Pin
jschell20-Nov-23 8:48
jschell20-Nov-23 8:48 
QuestionSQLite Thread Safety Pin
Richard Andrew x6410-Nov-23 13:23
professionalRichard Andrew x6410-Nov-23 13:23 
AnswerRe: SQLite Thread Safety Pin
Gerry Schmitz10-Nov-23 15:04
mveGerry Schmitz10-Nov-23 15:04 
GeneralRe: SQLite Thread Safety Pin
Richard Andrew x6410-Nov-23 16:33
professionalRichard Andrew x6410-Nov-23 16:33 
Well that seems related to the issue that I'm encountering. Occasionally I'll receive a "Access denied - Database locked" error message, and I can't understand it because all of my writes are synchronized around a single mutex. So I thought maybe I can't read either when a thread is writing to the DB.

It's an INSERT statement that's receiving the Database locked message, so the only other thing I can think of is that there's something wrong with my threading code and it's actually attempting two writes at once.



The difficult we do right away...
...the impossible takes slightly longer.


modified 10-Nov-23 21:46pm.

GeneralRe: SQLite Thread Safety Pin
Gerry Schmitz13-Nov-23 12:14
mveGerry Schmitz13-Nov-23 12:14 
AnswerRe: SQLite Thread Safety Pin
Jörgen Andersson12-Nov-23 22:16
professionalJörgen Andersson12-Nov-23 22:16 
QuestionSQLite syntax error that I can't figure out - SOLVED Pin
Richard Andrew x644-Nov-23 15:09
professionalRichard Andrew x644-Nov-23 15:09 
AnswerRe: SQLite syntax error that I can't figure out Pin
k50544-Nov-23 18:22
mvek50544-Nov-23 18:22 
GeneralRe: SQLite syntax error that I can't figure out Pin
Richard Andrew x645-Nov-23 2:57
professionalRichard Andrew x645-Nov-23 2:57 
Questionplease Pin
daw htikehtike21-Oct-23 20:17
daw htikehtike21-Oct-23 20:17 
AnswerRe: please Pin
Richard MacCutchan21-Oct-23 22:14
mveRichard MacCutchan21-Oct-23 22:14 
AnswerRe: please Pin
jschell23-Oct-23 6:25
jschell23-Oct-23 6:25 
AnswerRe: please Pin
Gerry Schmitz24-Oct-23 8:15
mveGerry Schmitz24-Oct-23 8:15 
AnswerRe: please Pin
CHill6030-Oct-23 0:44
mveCHill6030-Oct-23 0:44 
QuestionGetting Last Record and First Record from a Record Set (SQL server DB) Pin
Member 1184335621-Sep-23 9:07
Member 1184335621-Sep-23 9:07 
AnswerRe: Getting Last Record and First Record from a Record Set (SQL server DB) Pin
Richard Andrew x6421-Sep-23 9:58
professionalRichard Andrew x6421-Sep-23 9:58 
GeneralRe: Getting Last Record and First Record from a Record Set (SQL server DB) Pin
Member 1184335621-Sep-23 10:18
Member 1184335621-Sep-23 10:18 
GeneralRe: Getting Last Record and First Record from a Record Set (SQL server DB) Pin
Gerry Schmitz21-Sep-23 15:02
mveGerry Schmitz21-Sep-23 15:02 
Questionprior action plan to prevent sql database corruption Pin
Kar_Malay1-Sep-23 21:01
Kar_Malay1-Sep-23 21:01 
AnswerRe: prior action plan to prevent sql database corruption Pin
Richard Andrew x642-Sep-23 3:38
professionalRichard Andrew x642-Sep-23 3:38 
GeneralRe: prior action plan to prevent sql database corruption Pin
Dave Kreskowiak2-Sep-23 4:33
mveDave Kreskowiak2-Sep-23 4:33 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.