Hi, thanks for the reply.
so, I don't have TMPDIR defined in my env. what is the behaviour of sqlite in such cases ? is there a default ? cheers Tal On 12/09/2011 04:02 PM, Tal Tabakman wrote: >* Hi Guys,*>* I have an SQLITE database of 1.5 million rows in a single >table*>* each raw looks like:*>**>* >1499999|25|439198507|-1|0|1|44954|24|17|31|9|9|-1|-1|*>**>* now, from the >sqlite command line interface I am creating an INDEX on a sinGle*>* integer >column*>**>* CREATE INDEX IND1 ON ENTRIES (snum)*>**>* the result I get >is:*>**>* Error: disk I/O error*>**>* can you advice how to debug this one ?* You might be running out of space wherever temporary tables are stored on your system. If you're on unix, try changing environment variable TMPDIR to point to somewhere you have lots of free disk space (say three times the size of the eventual index). Or (I think) environment variable TMP or TEMP on Windows. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users