Thanks. I took a guess that it was fixed in 3.7.3 and manually downloaded the source. Of course hitting refresh in my browser brought up the correct page. PEBKAC.
-Scott sqlite-users-boun...@sqlite.org wrote on 10/11/2010 04:04:32 PM: > See: > > http://www.sqlite.org/src/info/d1ed743b6e > > for changes for SQLITE_OMIT_WAL. > > 3.7.3 should be available from the downloads page: > > http://www.sqlite.org/download.html > > as of October 8, 2010. You might need to refresh your browser cache. > > Direct link to the amalgamation is: > > http://www.sqlite.org/sqlite-amalgamation-3_7_3.zip > > HTH. > -Shane > > On Mon, Oct 11, 2010 at 12:11 PM, Scott A Mintz <sami...@ra. > rockwell.com> wrote: > > I think there is a bug in 3.7.2 when you define SQLITE_OMIT_WAL. There > > are references to pagerPagecount() that cannot be resolved because that > > function is defined inside of a #ifndef SQLITE_OMIT_WAL. > > > > I also keep seeing references to 3.7.3 in this list. But the SQLite > > download page only has links for 3.7.2. Where can I download 3.7.3? > > > > -Scott > > > > sqlite-users-boun...@sqlite.org wrote on 10/09/2010 07:38:24 AM: > > > >> Hello Scott, > >> > >> I did some searching with these symbols, they should be in > > 'libos.a'. > >> > >> rtpLib.o - rtpVerifyAndLock > >> > >> pgMgrLib.o - pgMgrPageFree, pgMgrPageAllocAt > >> > >> you should modify kernel components with your VIP project. > >> > >> Best Regards, > >> > >> Huang ZhiHua > >> > >> 2010/10/9 Scott A Mintz <sami...@ra.rockwell.com> > >> > >> > Thank you. Those changes (modified slightly for 3.7.2) allowed me to > >> > create a DKM project that compiles sqlite3.c to libSQLite3.a. > >> > > >> > However, when I link my main VIP project, I get the following > > unresolved > >> > errors: > >> > dld: warning: Undefined symbol 'rtpVerifyAndLock' in file > > 'partialImage.o' > >> > dld: warning: Undefined symbol 'pgMgrPageFree' in file > > 'partialImage.o' > >> > dld: warning: Undefined symbol 'pgMgrPageAllocAt' in file > > 'partialImage.o' > >> > > >> > Those are not directly used by SQLite. But I have a feeling that one > > or > >> > more of the file I/O, semaphore, locking, or memory library system > > calls > >> > are... > >> > > >> > -Scott > >> > > >> > sqlite-users-boun...@sqlite.org wrote on 10/08/2010 07:38:45 AM: > >> > > >> > > Hello Scott, > >> > > > >> > > Below is my patch on the latest SQLite 3.7.3. Please notice that > > I > >> > only > >> > > verify it with GCC 4.1.2 compiler in VxWorks 6.6/6.7/6.8(I have not > >> > verify > >> > > it with my real target machine yet). > >> > > > >> > > *** sqlite3.c.orig 2010-10-08 10:42:22.000000000 +0800 > >> > > --- sqlite3.c 2010-10-08 19:24:18.390625000 +0800 > >> > > *************** > >> > > *** 17,22 **** > >> > > --- 17,26 ---- > >> > > ** language. The code for the "sqlite3" command-line shell is also > > in > >> > a > >> > > ** separate file. This file contains only code for the core SQLite > >> > > library. > >> > > */ > >> > > + #if defined(OS_VXWORKS) > >> > > + #include <vxWorks.h> > >> > > + #endif /* OS_VXWORKS */ > >> > > + > >> > > #define SQLITE_CORE 1 > >> > > #define SQLITE_AMALGAMATION 1 > >> > > #ifndef SQLITE_PRIVATE > >> > > *************** > >> > > *** 22795,22801 **** > >> > > --- 22799,22811 ---- > >> > > #include <sys/stat.h> > >> > > #include <fcntl.h> > >> > > #include <unistd.h> > >> > > + > >> > > + #if defined(OS_VXWORKS) && defined(_WRS_KERNEL) > >> > > + #include <sys/times.h> > >> > > + #else > >> > > #include <sys/time.h> > >> > > + #endif /* OS_VXWORKS */ > >> > > + > >> > > #include <errno.h> > >> > > #include <sys/mman.h> > >> > > > >> > > *************** > >> > > *** 24945,24951 **** > >> > > --- 24955,24965 ---- > >> > > /* > >> > > ** Close a file. > >> > > */ > >> > > + #if (OS_VXWORKS < 600) > >> > > static int semClose(sqlite3_file *id) { > >> > > + #else > >> > > + static int semClose_native(sqlite3_file *id) { > >> > > + #endif > >> > > if( id ){ > >> > > unixFile *pFile = (unixFile*)id; > >> > > semUnlock(id, NO_LOCK); > >> > > *************** > >> > > *** 25581,25587 **** > >> > > --- 25595,25607 ---- > >> > > } > >> > > return -1; > >> > > } > >> > > + > >> > > + #if defined(OS_VXWORKS) && defined(_WRS_KERNEL) > >> > > + got = write(id->h, (char *)pBuf, cnt); > >> > > + #else > >> > > got = write(id->h, pBuf, cnt); > >> > > + #endif /* OS_VXWORKS */ > >> > > + > >> > > #endif > >> > > TIMER_END; > >> > > if( got<0 ){ > >> > > *************** > >> > > *** 26762,26768 **** > >> > > --- 26782,26792 ---- > >> > > semIoFinder, /* Finder function name */ > >> > > semIoMethods, /* sqlite3_io_methods object name */ > >> > > 1, /* shared memory is disabled */ > >> > > + #if (OS_VXWORKS < 600) > >> > > semClose, /* xClose method */ > >> > > + #else > >> > > + semClose_native, /* xClose method */ > >> > > + #endif > >> > > semLock, /* xLock method */ > >> > > semUnlock, /* xUnlock method */ > >> > > semCheckReservedLock /* xCheckReservedLock method */ > >> > > *************** > >> > > *** 27517,27523 **** > >> > > noLock = eType!=SQLITE_OPEN_MAIN_DB; > >> > > > >> > > > >> > > ! #if defined(__APPLE__) || SQLITE_ENABLE_LOCKING_STYLE > >> > > struct statfs fsInfo; > >> > > if( fstatfs(fd, &fsInfo) == -1 ){ > >> > > ((unixFile*)pFile)->lastErrno = errno; > >> > > --- 27541,27547 ---- > >> > > noLock = eType!=SQLITE_OPEN_MAIN_DB; > >> > > > >> > > > >> > > ! #if (defined(__APPLE__) || SQLITE_ENABLE_LOCKING_STYLE) && > >> > > !defined(OS_VXWORKS) > >> > > struct statfs fsInfo; > >> > > if( fstatfs(fd, &fsInfo) == -1 ){ > >> > > ((unixFile*)pFile)->lastErrno = errno; > >> > > *************** > >> > > *** 27530,27536 **** > >> > > } > >> > > #endif > >> > > > >> > > ! #if SQLITE_ENABLE_LOCKING_STYLE > >> > > #if SQLITE_PREFER_PROXY_LOCKING > >> > > isAutoProxy = 1; > >> > > #endif > >> > > --- 27554,27560 ---- > >> > > } > >> > > #endif > >> > > > >> > > ! #if SQLITE_ENABLE_LOCKING_STYLE && !OS_VXWORKS > >> > > #if SQLITE_PREFER_PROXY_LOCKING > >> > > isAutoProxy = 1; > >> > > #endif > >> > > *************** > >> > > *** 27793,27799 **** > >> > > ** tests repeatable. > >> > > */ > >> > > memset(zBuf, 0, nBuf); > >> > > ! #if !defined(SQLITE_TEST) > >> > > { > >> > > int pid, fd; > >> > > fd = open("/dev/urandom", O_RDONLY); > >> > > --- 27817,27823 ---- > >> > > ** tests repeatable. > >> > > */ > >> > > memset(zBuf, 0, nBuf); > >> > > ! #if !defined(SQLITE_TEST) && !defined(OS_VXWORKS) > >> > > { > >> > > int pid, fd; > >> > > fd = open("/dev/urandom", O_RDONLY); > >> > > > >> > > I'v used definitions as below: > >> > > > >> > > EXTRA_DEFINE += -DOS_VXWORKS_660=660 > >> > > EXTRA_DEFINE += -DOS_VXWORKS_670=670 > >> > > EXTRA_DEFINE += -DOS_VXWORKS_680=680 > >> > > EXTRA_DEFINE += -DOS_VXWORKS=OS_VXWORKS_670 > >> > > EXTRA_DEFINE += -DSQLITE_HOMEGROWN_RECURSIVE_MUTEX > >> > > EXTRA_DEFINE += -DSQLITE_ENABLE_LOCKING_STYLE=1 > >> > > EXTRA_DEFINE += -DSQLITE_OMIT_LOAD_EXTENSION > >> > > > >> > > > >> > > Best Regards, > >> > > > >> > > Huang Zhihua > >> > > > >> > > 2010/10/8 Scott A Mintz <sami...@ra.rockwell.com> > >> > > > >> > > > I searched through all the mail archives to see if I could find > >> > someone > >> > > > that has ported SQLite to vxWorks in kernel mode. Apparently, > > there > >> > are a > >> > > > few folks attempting it. And fewer succeeding at it. > >> > > > > >> > > > I found an article published by ZhiHua Huang where he describes > > the > >> > mods > >> > > > he made to port SQLite 3.6.23.1 to vxWorks 6.5 > >> > > > http://www.mail-archive.com/sqlite-users@sqlite.org/msg51531.html > >> > > > > >> > > > Using that as a starting point, I modified my files but I get the > >> > > > following errors: > >> > > > > > "C:/CCViews/Mintz_NetlinxUCS_L7x/NetLinxUCS/SQLite3_LIB/sqlite3.c", > >> > line > >> > > > 27262: error (dcc:1633): parse error near 'struct' > >> > > > > > "C:/CCViews/Mintz_NetlinxUCS_L7x/NetLinxUCS/SQLite3_LIB/sqlite3.c", > >> > line > >> > > > 27262: error (dcc:1206): syntax error > >> > > > > > "C:/CCViews/Mintz_NetlinxUCS_L7x/NetLinxUCS/SQLite3_LIB/sqlite3.c", > >> > line > >> > > > 27262: fatal error (dcc:1340): can't recover from earlier errors > >> > > > > >> > > > This is the code it's complaining about. The "struct statfs > > fsInfo;" > >> > line > >> > > > is line 27262. > >> > > > > >> > > > #ifdef FD_CLOEXEC > >> > > > fcntl(fd, F_SETFD, fcntl(fd, F_GETFD, 0) | FD_CLOEXEC); > >> > > > #endif > >> > > > > >> > > > noLock = eType!=SQLITE_OPEN_MAIN_DB; > >> > > > > >> > > > > >> > > > #if defined(__APPLE__) || SQLITE_ENABLE_LOCKING_STYLE > >> > > > struct statfs fsInfo; > >> > > > if( fstatfs(fd, &fsInfo) == -1 ){ > >> > > > ((unixFile*)pFile)->lastErrno = errno; > >> > > > if( dirfd>=0 ) close(dirfd); /* silently leak if fail, in error > > */ > >> > > > close(fd); /* silently leak if fail, in error */ > >> > > > return SQLITE_IOERR_ACCESS; > >> > > > } > >> > > > if (0 == strncmp("msdos", fsInfo.f_fstypename, 5)) { > >> > > > ((unixFile*)pFile)->fsFlags |= SQLITE_FSFLAGS_IS_MSDOS; > >> > > > } > >> > > > #endif > >> > > > > >> > > > Any ideas? > >> > > > > >> > > > -Scott > >> > > > _______________________________________________ > >> > > > sqlite-users mailing list > >> > > > sqlite-users@sqlite.org > >> > > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > >> > > > > >> > > _______________________________________________ > >> > > sqlite-users mailing list > >> > > sqlite-users@sqlite.org > >> > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > >> > > >> > _______________________________________________ > >> > sqlite-users mailing list > >> > sqlite-users@sqlite.org > >> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > >> > > >> _______________________________________________ > >> sqlite-users mailing list > >> sqlite-users@sqlite.org > >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users