Re: [sqlite] Seemingly random Access violation errors

Matthew Dumbleton wrote: > > I have tried the new version you mentioned (via the ZIP archive) but this > doesn't seem to have resolved my issue. > I'm working on some more changes that might help if the issue is actually related to threads being aborted. > > I did remove the abort call previousl

Re: [sqlite] Seemingly random Access violation errors

Matthew Dumbleton wrote: > > I have managed to get hold of a HTC HD2 device to do testing on and > have unfortunately found the error still occurs using the small test > application I sent you a while back. > I've just made some experimental changes (on the "threadAbortProtect" branch), primari

Re: [sqlite] Seemingly random Access violation errors

Kevin Benson wrote: > > > > > Matthew Dumbleton wrote: > > > > > > I have managed to get hold of a HTC HD2 device to do testing on and have > > > unfortunately found the error still occurs using the small test > > application > > > I sent you a while back. > > > > > > > Looking at your sample co

Re: [sqlite] Seemingly random Access violation errors

On Thu, Oct 11, 2012 at 6:07 AM, Joe Mistachkin wrote: > > Matthew Dumbleton wrote: > > > > I have managed to get hold of a HTC HD2 device to do testing on and have > > unfortunately found the error still occurs using the small test > application > > I sent you a while back. > > > > Looking at you

Re: [sqlite] Seemingly random Access violation errors

Matthew Dumbleton wrote: > > I have managed to get hold of a HTC HD2 device to do testing on and have > unfortunately found the error still occurs using the small test application > I sent you a while back. > Looking at your sample code again, the use of Thread.Abort could be causing problems.

Re: [sqlite] Seemingly random Access violation errors

Matthew Dumbleton wrote: > > I noticed in your testce code that when the code the threads are running > ('TestThreadStart()') in the multi-thread test do not seem to 'close()' > their connections once finished. Is there a reason for this (i.e. should > close() not be called?) or is it just part

Re: [sqlite] Seemingly random Access violation errors

Matthew Dumbleton wrote: > > Just in case it's of any use I have attached a text file with the end > of the logging from the HD2 crash. > Yes, it is useful. I've noticed something interesting; however, I'm not 100% sure what it means given that the output appears to be incomplete. sqlite3_final

Re: [sqlite] Seemingly random Access violation errors (resent)

Matthew Dumbleton wrote: > > Yes. Motorola ES400. Do have any advice/experience with these? (Apart from > 'don't use them' :) ) > I've added threading tests to the Windows CE test project. Could you try running it on your device and see how it behaves? -- Joe Mistachkin _

Re: [sqlite] Seemingly random Access violation errors (resent)

Good point. Also worth a look. > From: kevin.m.ben...@gmail.com > Date: Mon, 8 Oct 2012 12:42:09 -0400 > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Seemingly random Access violation errors (resent) > > On Mon, Oct 8, 2012 at 12:32 PM, Matthew Dumbleton wrote: >

Re: [sqlite] Seemingly random Access violation errors (resent)

On Mon, Oct 8, 2012 at 12:32 PM, Matthew Dumbleton wrote: > > Thanks Kevin. > I will see if I can find some sort of registry hack or something to > disable this and see if it makes any difference. > Actually, you might investigate how to access the RTLog Manager to examine the log(s) and see what

Re: [sqlite] Seemingly random Access violation errors (resent)

Thanks Kevin. I will see if I can find some sort of registry hack or something to disable this and see if it makes any difference. > From: kevin.m.ben...@gmail.com > Date: Mon, 8 Oct 2012 12:14:58 -0400 > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Seemingly random Acce

Re: [sqlite] Seemingly random Access violation errors (resent)

On Mon, Oct 8, 2012 at 11:57 AM, Matthew Dumbleton wrote: > Joe, > > > It's worked on every device that I've used in the past. > > I hope you see the funny side when I say, this doesn't fill me with a > great amount of confidence as according to your previous messages you don't > have a device to

Re: [sqlite] Seemingly random Access violation errors (resent)

T :Re: [sqlite] Seemingly random Access violation errors (resent) Simon, Apologies if it seems like I'm picking on SQLite. As previously stated I am just disappointed that I don't seem to be able to use it in a simple c# app. I'm sure it works great on other platforms/devices etc.

Re: [sqlite] Seemingly random Access violation errors (resent)

2 16:54:00 +0100 > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Seemingly random Access violation errors (resent) > > > On 8 Oct 2012, at 3:54pm, Matthew Dumbleton wrote: > > > So does this mean therefore SQLite will not currently work on a compact > > frame

Re: [sqlite] Seemingly random Access violation errors (resent)

Yes. Motorola ES400. Do have any advice/experience with these? (Apart from 'don't use them' :) ) > From: kevin.m.ben...@gmail.com > Date: Mon, 8 Oct 2012 11:55:57 -0400 > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Seemingly random Access violation errors

Re: [sqlite] Seemingly random Access violation errors (resent)

Joe, > It's worked on every device that I've used in the past. I hope you see the funny side when I say, this doesn't fill me with a great amount of confidence as according to your previous messages you don't have a device to test on, only emulators. :) > I have no idea what the "rtlog

Re: [sqlite] Seemingly random Access violation errors (resent)

h > disappears when SQLite is not referenced. > And since Microsoft aren't likely to release any updates to the compact > framework I'm not sure where to go with this. > > > From: sql...@mistachkin.com > > To: sqlite-users@sqlite.org > > Date: Mon, 8 Oct 20

Re: [sqlite] Seemingly random Access violation errors (resent)

On 8 Oct 2012, at 3:54pm, Matthew Dumbleton wrote: > So does this mean therefore SQLite will not currently work on a compact > framework device? (Or at least not on mine.) SQLite is distributed as C source code. It's the .c and .h files you find when you download the amalgamation from

Re: [sqlite] Seemingly random Access violation errors (resent)

Matthew Dumbleton wrote: > > So does this mean therefore SQLite will not currently work on a > compact framework device? (Or at least not on mine.) > It's worked on every device that I've used in the past. > > That dll is protected inside the windows directory on the device so I > cannot even t

Re: [sqlite] Seemingly random Access violation errors (resent)

elease any updates to the compact framework I'm not sure where to go with this. > From: sql...@mistachkin.com > To: sqlite-users@sqlite.org > Date: Mon, 8 Oct 2012 06:00:50 -0700 > Subject: Re: [sqlite] Seemingly random Access violation errors (resent) > > > Matthew Dumble

Re: [sqlite] Seemingly random Access violation errors (resent)

Matthew Dumbleton wrote: > > Sorry about that. Sent you the attachments properly a while ago and have > also just sent you a .txt file with the last output from the debugger > before the access violation crash thanks to your new version. > The start of the trouble seems to be here: Data Abort

Re: [sqlite] Seemingly random Access violation errors (resent)

t 2012 04:38:37 -0700 > Subject: Re: [sqlite] Seemingly random Access violation errors (resent) > > > Matthew Dumbleton wrote: > > > > Have attached the latest .kdmp and pdbs since you last email/source > > changes. Hopefully the dump makes more sense to you than it d

Re: [sqlite] Seemingly random Access violation errors (resent)

Matthew Dumbleton wrote: > > Have attached the latest .kdmp and pdbs since you last email/source > changes. Hopefully the dump makes more sense to you than it does to > me. Builds were debug builds as requested. > There were no attachments to your message that I saw. Also, were you able to ca

Re: [sqlite] Seemingly random Access Violation errors

Joe, Have done as you said and reproduced the issue. Have sent you direct the relevant pdbs and kdmp from the latest crash. > From: sql...@mistachkin.com > To: sqlite-users@sqlite.org > Date: Mon, 8 Oct 2012 02:24:08 -0700 > Subject: Re: [sqlite] Seemingly random Access Viol

Re: [sqlite] Seemingly random Access Violation errors

I've just added some extra diagnostics to the debug build of the native interop assembly ("SQLite.Interop.dll"), could you update your local sources, compile everything in the debug build configuration, and then try to reproduce the problem? -- Joe Mistachkin

Re: [sqlite] Seemingly random Access Violation errors

Matthew Dumbleton wrote: > > Currently using version 83. Is this correct? Started on 82. > I assume you are building from the source code in the repository then? Are you using the included (built from source) "SQLite.Interop.dll" or a standard Win32 "sqlite3.dll" with the managed assembly? Wha

Re: [sqlite] Seemingly random Access Violation errors

Currently using version 83. Is this correct? Started on 82. Will give the device a factory reset to be sure but manually deleted previous copy of dll on the device before compiling the version with your last set of changes (managed to find where to download the whole of the source code this t

Re: [sqlite] Seemingly random Access Violation errors

Joe Mistachkin wrote: > > I do not have a real device to test the code on. Also, the project you sent is > targeted to a different emulator version than the ones I currently have available. > I'll try to manually retarget the project tonight and try to reproduce the issue > in more detail. >

Re: [sqlite] Seemingly random Access Violation errors

Matthew Dumbleton wrote: > > I'm afraid this doesn't seem to fix the issue. > Odd, it seemed like a disposal race condition. I thought the additional locking semantics would fix it. On the desktop versions of the .NET Framework, there is an actual CriticalHandle class and the necessary overl

Re: [sqlite] Seemingly random Access Violation errors

s I'll check my code. > From: michael.bla...@ngc.com > To: sqlite-users@sqlite.org > Date: Fri, 5 Oct 2012 14:04:59 + > Subject: Re: [sqlite] Seemingly random Access Violation errors > > It would seem to me that if GC.Collect fixes the problem than all you've do

Re: [sqlite] Seemingly random Access Violation errors

iday, October 05, 2012 5:46 AM To: sqlite-users@sqlite.org Subject: EXT :Re: [sqlite] Seemingly random Access Violation errors Joe, I'm afraid this doesn't seem to fix the issue. Just out of interest are you able to run the code I sent on a real device or in an emulator? I'm tes

Re: [sqlite] Seemingly random Access Violation errors

practice. Will continue to test. > From: sql...@mistachkin.com > To: sqlite-users@sqlite.org > Date: Thu, 4 Oct 2012 17:20:18 -0700 > Subject: Re: [sqlite] Seemingly random Access Violation errors > > > Matthew Dumbleton wrote: > > > > I have tried this change and I

Re: [sqlite] Seemingly random Access Violation errors

Matthew Dumbleton wrote: > > I have tried this change and I'm afraid it hasn't stopped the crashes. > I've further refined the locking semantics for the .NET Compact Framework build here: https://system.data.sqlite.org/index.html/info/ac5f4cc084 I think this should correct the problem,

Re: [sqlite] Seemingly random Access Violation errors

his correct or did I miss something? (Don't know if there are other crucial changes elsewhere in the source code.) > From: sql...@mistachkin.com > To: sqlite-users@sqlite.org > Date: Thu, 4 Oct 2012 04:27:47 -0700 > Subject: Re: [sqlite] Seemingly random Access Violation errors > &

Re: [sqlite] Seemingly random Access Violation errors

Matthew Dumbleton wrote: > > Attached is a small project that should recreate the issues I'm having. > Could you try the following change and let us know if it works for you? http://system.data.sqlite.org/index.html/ci/b8212344a0 -- Joe Mistachkin _

Re: [sqlite] Seemingly random Access Violation errors

Matthew Dumbleton wrote: > > Joe, I have tried sending the attachment to you direct but I guess > otherwise the answer to.. > I received the attachment and I'll look into it. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org h

Re: [sqlite] Seemingly random Access Violation errors

Oh. Joe, I have tried sending the attachment to you direct but I guess otherwise the answer to.. 'Could you provide some sample C# code that demonstrates the issue?' -- Joe Mistachkin ...is, no. On 03/10/2012 14:25, Simon Slavin wrote: On 2 Oct 2012, at 7:40pm, Matthew Dumbleton wrote:

Re: [sqlite] Seemingly random Access Violation errors

On 2 Oct 2012, at 7:40pm, Matthew Dumbleton wrote: > I have attached a small project Sorry but attachments don't work with posts to this list. We don't want everyone sending us their homework and killing our byte caps. Could you put your work on a server somewhere and post a pointer ? Simo

Re: [sqlite] Seemingly random Access Violation errors

I have attached a small project with which you should be able to see the issue I am having. Thanks in advance for taking the time to look. On 26/09/2012 23:47, Joe Mistachkin wrote: Matthew Dumbleton wrote: Sorry, should have highlighted this better in my initial message. Started out using 1.

Re: [sqlite] Seemingly random Access Violation errors

Ok. Will try and write a simpler version to pass on to you asap. From: Joe Mistachkin Sent: 26/09/2012 23:47 To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] Seemingly random Access Violation errors Matthew Dumbleton wrote: > > So

Re: [sqlite] Seemingly random Access Violation errors

Matthew Dumbleton wrote: > > Sorry, should have highlighted this better in my initial message. Started > out using 1.0.56.0 and changed to 1.0.82.0, however problem remains. > I'm unable to reproduce the issue here using the latest version. Could you provide some sample C# code that demonstrates

Re: [sqlite] Seemingly random Access Violation errors

Seemingly random Access Violation errors Matthew Dumbleton wrote: > > at UnsafeNativeMethods.sqlite3_close_interop(IntPtr db) > at SQLiteBase.CloseConnection(SQLiteConnectionHandle db) > at SQLiteConnectionHandle.ReleaseHandle() > at CriticalH

Re: [sqlite] Seemingly random Access Violation errors

Matthew Dumbleton wrote: > > at UnsafeNativeMethods.sqlite3_close_interop(IntPtr db) > at SQLiteBase.CloseConnection(SQLiteConnectionHandle db) > at SQLiteConnectionHandle.ReleaseHandle() > at CriticalHandle.Cleanup() > at CriticalHandle.Dispose(Boolean disposing) > a

Re: [sqlite] Seemingly random Access Violation errors

Mistachkin Sent: 26/09/2012 20:54 To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] Seemingly random Access Violation errors Matthew Dumbleton wrote: > > at UnsafeNativeMethods.sqlite3_close_interop(IntPtr db) > at SQLiteBase.CloseConnection(SQLite

Re: [sqlite] Seemingly random Access Violation errors

Matthew Dumbleton wrote: > > at UnsafeNativeMethods.sqlite3_close_interop(IntPtr db) > at SQLiteBase.CloseConnection(SQLiteConnectionHandle db) > at SQLiteConnectionHandle.ReleaseHandle() > at CriticalHandle.Cleanup() > at CriticalHandle.Dispose(Boolean disposing) > a

[sqlite] Seemingly random Access Violation errors

I'm currently trying to write an app for the compact framework (3.5) using an sqlite database in c#. The application is occasionally throwing up odd Access Violation errors, crashing the application. Getting precious little from the crash dumps produced but from experimentation it seems that