Hello, We are running sqlite version below on AX 7.2 TL 1. We have a database around 430MB and was trying to export the contents to a file shown below, done this with other databases but it seems there is some type of limitation possibly with the version of sqlite we are running? We did open a ticket with IBM which looked at the core dump and said it was on the application side, sqlite. We ended up doing 3 select statements using a unique number to pull files of about 500k of rows to finally clear the table. Wanted to see if anyone has come across this type of issue before.
SQLite version 3.7.14.1 2012-10-04 19:37:12 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> select count(*) from EpicADT; 1457871 sqlite> .output finalAllHospTable.txt sqlite> select * from EpicADT ORDER BY acctNum; Memory fault(coredump) iscax_testcis02@hci (/cistest/cis6.2/integrator/sqlLiteDbs/JGD) />ls -altr total 1378760 -rw-r--r-- 1 hci staff 436788224 Oct 29 15:46 EpicADT_PROD1TBL.db drwxrwxr-x 20 hci staff 4096 Oct 29 15:48 .. -rw-rw-r-- 1 hci staff 0 Oct 29 15:48 finalAllHospTable.txt drwxrwxr-x 2 hci staff 256 Oct 29 15:49 . -rw-rw-r-- 1 hci staff 269121503 Oct 29 15:49 core Table schema sqlite> .schema CREATE TABLE EpicADT (msgDT TEXT, msgID TEXT, hosp TEXT, FirstName TEXT, MI TEXT, LastName TEXT, DOB TEXT, Gender TEXT, pt AIX Power 8 + server 16 cpu's running />ulimit -a time(seconds) unlimited file(blocks) unlimited data(kbytes) unlimited stack(kbytes) unlimited memory(kbytes) unlimited coredump(blocks) unlimited nofiles(descriptors) 20000 threads(per process) unlimited processes(per user) unlimited Thanks, Jeff WARNING! – This email is from an external sender. Do not click links or open attachments unless you know the sender. Never give out your username and password. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
