I had something similar a while back on a 64bit HPUX box compiled with gcc. I was getting a core dump / seg fault on big table select when I did count(*)'s and sum()'s in the query. It wasn't all queries but it was consist ant and repeatable.
I was able to get the queries to work with SQLite 2.8.16. It seemed odd to me but I couldn't figure it out or get an answer as to why it was happening. Being under the gun I ended up going live on 2.8.16. Could you download 2.8.16 and let us know if your process works with that version? If so it may be the same issue and might raise the visibility. With the performance improvements I'd much rather be on the latest version. One side note: when I did compile using 32 bit it worked fine on version 3.2.1 but that wasn't an option I could use on those machines. Thanks, Patrick -----Original Message----- From: scunacc [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 02, 2005 7:16 AM To: Christian Smith Cc: sqlite-users@sqlite.org Subject: Re: [sqlite] Segmentation fault on large selects Dear Christian, > Doesn't matter how much memory you have. If ulimits restrict how much > memory a process can have, something has to give. Try: The process has unlimited ulimits. Thanks for the suggestion, but other Perl scripts that run already use huge amounts of memory on this machine, so that's something that was tackled months back. Appreciate the contribution - but - no nearer. Kind regards Derek Jones.
