On Fri, Dec 9, 2011 at 4:02 AM, Tal Tabakman <[email protected]> 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 on a sincle > 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 ? > Are you doing this from the command-line shell? Try using the ".log stdout" command in order to get a more detailed error message. > cheers > Tal > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
