[sqlite] Disk IO ERROR on AIX

Hi, I'm getting a Disk I/O error when committing a transaction on an AIX system. The extended result code is 1290. Which i believe means that the extended code is a SQLITE_IOERR_DIR_FSYNC error. Any ideas why this is happening or how to track it down? Thanks, Ken __

[sqlite] Auditing

Hi list, I'd like ideas / recommendations on implementing and auditing to track delta changes to tables. I have about 6 tables in my db with different fields/columns and PK's. My original thought was to have a single audit table for all of them such as audit_delta ( id integer, tab text, oper

[sqlite] pagecache?

Hi list, I'm trying to get sqlite to utilize the pagecache and scratch buffers. But when the code exits it returns pagecache overflow and scratch buffer overflow . The to configure the pagecache and scratch are done in the main section of code  as follows: Then connections to sqlite are made i

[sqlite] memsys5 MallocInit

Hi list. Just thought I'd pass this along as a suggestion: I mistakenly called: sz = pgSz * pgCache... pBuf = malloc (sz).    sqlite3_config(SQLITE_CONFIG_PAGECACHE,pBuf, sz,  pgCache  ); This functioned however the sqlite MallocInit cored due to a pageSize of 32Meg. The doucmentation does clea

Re: [sqlite] Memory Leak

Problem fixed... It was in the compile/reset logic.. it just kept compiling without resetting. Ken __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com --

Re: [sqlite] Memory Leak

ngs up, and that is probably why your > memory usage increased > over time. > > I don't see a problem. > > -- Darren Duncan > > At 10:11 AM -0700 6/25/04, kenneth long wrote: > >Hi all, > >I'm curious if anyone has experience a memory leak >

[sqlite] SQLite website hacked

I recall, recently the CVS website posting a "security bulletin" They had to entirely rebuild their site. This was because the pserver (cvs bacground server) had a serious security flaw that allowed an attacker to run commands on the host. Here is a link to the details!!! http://www.cve.mitre.org

[sqlite] Memory Leak

Hi all, I'm curious if anyone has experience a memory leak with sqlite? Here is the program outline: sqlite_open create table create unique index begin transaction loop 1 SqlStmt "insert into x (a,b) values (? ? ) " first time sqlite_compile