Re: [sqlite] HELP sqlite3 used in vxworks has someproblem?

2014-09-01 Thread Richard Hipp
On Mon, Sep 1, 2014 at 7:04 AM, Andy Ling wrote: > > This can be fixed by changing the patch to something like... > > #if OS_VXWORKS > }else if( errno==0x380003 || errno == 13){ /* == > S_dosFsLib_FILE_NOT_FOUND */ > rc = SQLITE_IOERR_DELETE_NOENT; > #endif > >

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem?

2014-09-01 Thread Jan Nijtmans
2014-09-01 13:04 GMT+02:00 Andy Ling : > Although this doesn't feel right having to keep extending the list of error > codes that are checked. > I'm not sure what else can be done though. Maybe some compile options that > let you choose. Here is a list of possible

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem?

2014-09-01 Thread Andy Ling
> -Original Message- > From: Andy Ling > Sent: 29 August 2014 16:15 > To: '???'; sqlite-users@sqlite.org > Subject: RE: Re:RE: [sqlite] HELP sqlite3 used in vxworks has someproblem? > > I would add a printf statement in unixDelete rather than rely on a break po

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem?

2014-08-29 Thread Andy Ling
if that works. Regards Andy Ling From: 王庆刚 [mailto:2004wqg2...@163.com] Sent: 29 August 2014 15:49 To: Andy Ling; sqlite-users@sqlite.org Subject: Re:RE: [sqlite] HELP sqlite3 used in vxworks has someproblem? hi, Andy Ling      I have removed the SQLITE_ENABLE_LOCKING_STYLE compile option, so

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem?

2014-08-29 Thread 王庆刚
se). Regards Andy Ling From: 163 [mailto:2004wqg2...@163.com] Sent: 29 August 2014 03:34 To: Andy Ling Cc:sqlite-users@sqlite.org; Jan Nijtmans Subject: Re: [sqlite] HELP sqlite3 used in vxworks has someproblem? i find it not enter the unixdelete. 发自我的 iPhone 在 2014年8月28日

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem?

2014-08-29 Thread Andy Ling
OS your host system is running (Windows I assume in your case). Regards Andy Ling From: 163 [mailto:2004wqg2...@163.com] Sent: 29 August 2014 03:34 To: Andy Ling Cc: sqlite-users@sqlite.org; Jan Nijtmans Subject: Re: [sqlite] HELP sqlite3 used in vxworks has someproblem? i find it not enter

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem?

2014-08-28 Thread 163
e that doesn’t exist. So it will need > another check adding to unixDelete > > Regards > > Andy Ling > > > From: 王庆刚 [mailto:2004wqg2...@163.com] > Sent: 28 August 2014 15:01 > To: Andy Ling > Cc: sqlite-users@sqlite.org; Jan Nijtmans > Subject: Re:RE:

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem?

2014-08-28 Thread Andy Ling
2014 15:01 To: Andy Ling Cc: sqlite-users@sqlite.org; Jan Nijtmans Subject: Re:RE: Re:RE: [sqlite] HELP sqlite3 used in vxworks has someproblem? Is unixUnlink an function? If it is , but I can not find the funtion in sqlite3.c. Regards Wang Qinggang At 2014-08-28 00:03:23, "Andy

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem?

2014-08-28 Thread 王庆刚
be good to find out what is causing the disk I/O error. Did you try putting some debug in unixUnlink? Regards Andy Ling From:王庆刚 [mailto:2004wqg2...@163.com] Sent: 27 August 2014 16:17 To: Andy Ling Cc:sqlite-users@sqlite.org; Jan Nijtmans Subject: Re:RE: [sqlite] HELP sqlite3 used

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem?

2014-08-28 Thread Andy Ling
2014 15:01 To: Andy Ling Cc: sqlite-users@sqlite.org; Jan Nijtmans Subject: Re:RE: Re:RE: [sqlite] HELP sqlite3 used in vxworks has someproblem? Is unixUnlink an function? If it is , but I can not find the funtion in sqlite3.c. Regards Wang Qinggang

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem?

2014-08-27 Thread Andy Ling
sqlite.org; Jan Nijtmans Subject: Re:RE: [sqlite] HELP sqlite3 used in vxworks has someproblem? Firstly: I fixed the disk I/O error by adding -DSQLITE_ENABLE_LOCKING_STYLE=1 to the build macro. Secondly: rc = sqlite3_open("D:\\WindRiver\\SqliteOne.db",); I change it to the

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem?

2014-08-27 Thread 王庆刚
. What did you have to do? Are there any more changes that need feeding back into the source? Regards Andy Ling From:王庆刚 [mailto:2004wqg2...@163.com] Sent: 26 August 2014 13:44 To: Andy Ling Cc:sqlite-users@sqlite.org; Jan Nijtmans Subject: Re:RE: Re:Re: [sqlite] HELP sqlite3 used

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem?

2014-08-26 Thread Richard Hipp
; different error code being set. start by adding a printf to unixUnlink to > find out if that is your problem. > > Regards > > Andy Ling > > > > From: 王庆刚 [2004wqg2...@163.com] > Sent: 25 August 2014 13:13 > To:sqlite-users@sqlite.org; Andy Ling; Jan Ni

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem?

2014-08-26 Thread Andy Ling
:2004wqg2...@163.com] Sent: 26 August 2014 13:44 To: Andy Ling Cc: sqlite-users@sqlite.org; Jan Nijtmans Subject: Re:RE: Re:Re: [sqlite] HELP sqlite3 used in vxworks has someproblem? hi, Andy Ling: The error disk I / o error I have resolved ; but when I used the following code: rc = sqlite3_open(&q

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem?

2014-08-26 Thread 王庆刚
that is your problem. Regards Andy Ling From: 王庆刚 [2004wqg2...@163.com] Sent: 25 August 2014 13:13 To:sqlite-users@sqlite.org; Andy Ling; Jan Nijtmans Subject: Re:Re: [sqlite] HELP sqlite3 used in vxworks has someproblem? hi I modified the code sqlite3.c according to you method, as fo

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem?

2014-08-25 Thread Andy Ling
August 2014 13:13 To: sqlite-users@sqlite.org; Andy Ling; Jan Nijtmans Subject: Re:Re: [sqlite] HELP sqlite3 used in vxworks has someproblem? hi I modified the code sqlite3.c according to you method, as follow <http://fossil-scm.org/index.html/vpatch?from=dd5743a8239d1ce9=b68f65bb69a09

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem?

2014-08-25 Thread 王庆刚
hi I modified the code sqlite3.c according to you method, as follow or I test you method in workbench3.2(vxworks6.8) , the build macros which I used

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem?

2014-08-14 Thread Andy Ling
sqlite.org] on behalf of Jan Nijtmans [jan.nijtm...@gmail.com] Sent: 14 August 2014 08:19 To: General Discussion of SQLite Database Subject: Re: [sqlite] HELP sqlite3 used in vxworks has someproblem? 2014-08-13 14:31 GMT+02:00 Andy Ling <andy.l...@quantel.com>: > > From: drhsql...@gm

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem?

2014-08-14 Thread Jan Nijtmans
2014-08-13 14:31 GMT+02:00 Andy Ling : > > From: drhsql...@gmail.com [mailto:drhsql...@gmail.com] On Behalf Of > Richard Hipp > > OK, I did find some cases where unlink() is called on files that do not > exist. > > > Anyway, a patch has now been checked in. > > Great,

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem?

2014-08-13 Thread Andy Ling
> From: drhsql...@gmail.com [mailto:drhsql...@gmail.com] On Behalf Of Richard > Hipp > Sent: 13 August 2014 12:40 > To: Andy Ling > Cc: General Discussion of SQLite Database > Subject: Re: [sqlite] HELP sqlite3 used in vxworks has someproblem? > OK, I did find so

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem ?

2014-08-13 Thread Dave Dyer
There's a class of errors that affect lots of programs, where backup and/or antivirus software have a file open "unexpectedly", which causes routine operations such as delete and rename to fail unexpectedly. I once promoted a fix for sqlite that combatted these problems by retrying such

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem ?

2014-08-13 Thread Dave Dyer
There's a class of errors that affect lots of programs, where backup and/or antivirus software have a file open "unexpectedly", which causes routine operations such as delete and rename to fail unexpectedly. I once promoted a fix for sqlite that combatted these problems by retrying such

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem?

2014-08-13 Thread Richard Hipp
--Original Message- > > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > > boun...@sqlite.org] On Behalf Of Andy Ling > > Sent: 13 August 2014 10:06 > > To: 'Richard Hipp' > > Cc: General Discussion of SQLite Database > > Subject: Re: [sqlite] HELP sqlit

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem?

2014-08-13 Thread Andy Ling
> -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Andy Ling > Sent: 13 August 2014 10:06 > To: 'Richard Hipp' > Cc: General Discussion of SQLite Database > Subject: Re: [sqlite] HELP sqlite

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem?

2014-08-13 Thread Andy Ling
> If your build is frequently trying to unlink a file that does not exist, > then something is wrong.  We need to figure out what that is and fix it. I have added some debug. First I create a brand new database called /ata0:3/testdb.sql Then I try and create a table and get an error from

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem?

2014-08-12 Thread Andy Ling
...@sqlite.org] on behalf of Richard Hipp [d...@sqlite.org] Sent: 12 August 2014 20:59 To: General Discussion of SQLite Database Subject: Re: [sqlite] HELP sqlite3 used in vxworks has someproblem? On Tue, Aug 12, 2014 at 3:54 PM, Andy Ling <andy.l...@quantel.com> wrote: > > I did wond

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem?

2014-08-12 Thread Richard Hipp
On Tue, Aug 12, 2014 at 3:54 PM, Andy Ling wrote: > > I did wonder if SQLite was making any assumptions about current > directories or the makeup of a file name. > No. Any filename will do. You have to specify -DSQLITE_ENABLE_8_3_NAMES if your filesystem is limited to

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem?

2014-08-12 Thread Andy Ling
From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Simon Slavin [slav...@bigfraud.org] Sent: 12 August 2014 20:16 To: General Discussion of SQLite Database Subject: Re: [sqlite] HELP sqlite3 used in vxworks has someproblem? On 12 Aug 2014

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem?

2014-08-12 Thread Simon Slavin
On 12 Aug 2014, at 7:46pm, Andy Ling wrote: > I can tell you the name of the database file is /ata0:3/testdb.sql and it > gets created. Can you add some commands to one of your apps using the library which create and delete a file in '/ata0:3/' and see they work ? In

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem?

2014-08-12 Thread Richard Hipp
n behalf of Richard > Hipp [d...@sqlite.org] > *Sent:* 12 August 2014 19:15 > > *To:* Andy Ling > *Cc:* General Discussion of SQLite Database; 王庆刚 > *Subject:* Re: [sqlite] HELP sqlite3 used in vxworks has someproblem? > > What is the name of the file that SQLite is tr

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem?

2014-08-12 Thread Andy Ling
Andy Ling From: drhsql...@gmail.com [drhsql...@gmail.com] on behalf of Richard Hipp [d...@sqlite.org] Sent: 12 August 2014 19:15 To: Andy Ling Cc: General Discussion of SQLite Database; 王庆刚 Subject: Re: [sqlite] HELP sqlite3 used in vxworks has someproblem? What

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem?

2014-08-12 Thread Richard Hipp
What is the name of the file that SQLite is trying to delete but which does not exist? And what is the name of the corresponding database file? The name of the file that fails unlink() will give us a big clue about what is going wrong. On Tue, Aug 12, 2014 at 2:13 PM, Richard Hipp

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem?

2014-08-12 Thread Richard Hipp
On Tue, Aug 12, 2014 at 2:00 PM, Andy Ling wrote: > Because the file doesn't exist. I assume because this is a brand new > database the file hasn't been created yet. > > I did debug this originally, but I don't remember the file it is trying to > delete. It definitely

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem?

2014-08-12 Thread Andy Ling
] Sent: 12 August 2014 18:01 To: Andy Ling Cc: General Discussion of SQLite Database; 王庆刚 Subject: Re: [sqlite] HELP sqlite3 used in vxworks has someproblem? On Tue, Aug 12, 2014 at 12:45 PM, Andy Ling <andy.l...@quantel.com<mailto:andy.l...@quantel.com>> wrote: Doing a create table gene

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem?

2014-08-12 Thread Richard Hipp
On Tue, Aug 12, 2014 at 12:45 PM, Andy Ling wrote: > Doing a create table generates a disk I/O error > > > > I open / create a new database with sqlite3_open_v2 > > > > *int* err = sqlite3_open_v2 (file, , SQLITE_OPEN_READWRITE | > SQLITE_OPEN_CREATE, "unix-namedsem") ;

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem?

2014-08-12 Thread Andy Ling
generates a disk I/O error. I assume it is trying to remove a temporary file. Regards Andy Ling From: drhsql...@gmail.com [mailto:drhsql...@gmail.com] On Behalf Of Richard Hipp Sent: 12 August 2014 17:24 To: Andy Ling Cc: General Discussion of SQLite Database; 王庆刚 Subject: Re: [sqlite] HELP sq

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem?

2014-08-12 Thread Richard Hipp
On Tue, Aug 12, 2014 at 11:40 AM, Andy Ling wrote: > > From: drhsql...@gmail.com [mailto:drhsql...@gmail.com] On Behalf Of > Richard Hipp > > Sent: 12 August 2014 15:46 > > > I put a new snapshot on the download page. Please try it, *without* > SQLITE_ENABLE_LOCKING_MODE.

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem?

2014-08-12 Thread Andy Ling
> From: drhsql...@gmail.com [mailto:drhsql...@gmail.com] On Behalf Of Richard > Hipp > Sent: 12 August 2014 15:46 > I put a new snapshot on the download page.  Please try it, *without* > SQLITE_ENABLE_LOCKING_MODE. OK, it builds, but doesn't run. It is missing the patch to unixDelete. Whilst

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem?

2014-08-12 Thread Richard Hipp
On Tue, Aug 12, 2014 at 10:38 AM, Andy Ling wrote: > 've just downloaded the latest pre-release > sqlite-amalgamation-201408081749.zip > a > I put a new snapshot on the download page. Please try it, *without* SQLITE_ENABLE_LOCKING_MODE. -- D. Richard Hipp

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem?

2014-08-12 Thread Andy Ling
> From: drhsql...@gmail.com [mailto:drhsql...@gmail.com] On Behalf Of Richard > Hipp > Sent: 12 August 2014 14:28 > To: Andy Ling > On Tue, Aug 12, 2014 at 9:23 AM, Andy Ling wrote: >> I have been testing >> the changes Jan has made and at the moment I am happy. > But

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem?

2014-08-12 Thread Richard Hipp
On Tue, Aug 12, 2014 at 9:37 AM, Jan Nijtmans wrote: > 2014-08-12 15:27 GMT+02:00 Richard Hipp : > > > But we cannot use Jan's changes directly because he lives in a > jurisdiction > > that does not recognize the ability of an author to contribute their

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem?

2014-08-12 Thread Jan Nijtmans
2014-08-12 15:27 GMT+02:00 Richard Hipp : > But we cannot use Jan's changes directly because he lives in a jurisdiction > that does not recognize the ability of an author to contribute their work > into the public domain. We can only use Jan's changes as a guideline for >

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem?

2014-08-12 Thread Richard Hipp
On Tue, Aug 12, 2014 at 9:23 AM, Andy Ling wrote: > > > I have been testing > the changes Jan has made and at the moment I am happy. > But we cannot use Jan's changes directly because he lives in a jurisdiction that does not recognize the ability of an author to

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem?

2014-08-12 Thread Andy Ling
From: drhsql...@gmail.com [mailto:drhsql...@gmail.com] On Behalf Of Richard Hipp Sent: 12 August 2014 13:27 > This is very awkward working through a proxy.  If Mr. Ling (or anybody else > with access > to a VxWorks development system) wants VxWorks support in SQLite, he can > come to > this

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem?

2014-08-12 Thread Jan Nijtmans
2014-08-12 14:26 GMT+02:00 Richard Hipp : > This is very awkward working through a proxy. If Mr. Ling (or anybody else > with access to a VxWorks development system) wants VxWorks support in > SQLite, he can come to this mailing list himself and submit suggestions > here, where

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem?

2014-08-12 Thread Richard Hipp
On Tue, Aug 12, 2014 at 8:10 AM, Jan Nijtmans wrote: > New attempt here, base on current SQLite trunk: > > I fixed the obvious errors in the fileHasMoved() routine. But as for the other patches, I don't understand

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem?

2014-08-12 Thread Jan Nijtmans
2014-08-03 9:56 GMT+02:00 Jan Nijtmans : > 2014-08-02 16:00 GMT+02:00 王庆刚 <2004wqg2...@163.com>: > > hi , Can Sqlite3.c and sqlite.h be compiled in Workbench3.2 for > Vxworks6.8 ? > > When I compile them , there have so many problems . > > You can find the

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem?

2014-08-04 Thread Andy Ling
> -Original Message- > > 2014-08-02 16:00 GMT+02:00 王庆刚 <2004wqg2...@163.com>: > > hi , Can Sqlite3.c and sqlite.h be compiled in Workbench3.2 for > Vxworks6.8 ? > > When I compile them , there have so many problems . > > ___ > >

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem?

2014-08-03 Thread Jan Nijtmans
2014-08-02 16:00 GMT+02:00 王庆刚 <2004wqg2...@163.com>: > hi , Can Sqlite3.c and sqlite.h be compiled in Workbench3.2 for > Vxworks6.8 ? > When I compile them , there have so many problems . > ___ > sqlite-users mailing list >

[sqlite] HELP sqlite3 used in vxworks has someproblem?

2014-08-02 Thread 王庆刚
hi , Can Sqlite3.c and sqlite.h be compiled in Workbench3.2 for Vxworks6.8 ? When I compile them , there have so many problems . ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users