[eluser]slowgary[/eluser]
It's really strange that it would be inconsistent. Is it a single database server, or a cluster? Is it possible that the connection is just failing part of the time? Maybe there's some sort of corruption that has happened to your table. I couldn't find must information about the error and I find it VERY strange that it gives you an error number '1'.
I have no experience with SQLITE and personally I would recommend switching to MySQL for a lack of SQLITE documentation. As to solving your problem, have you tried dropping the table and recreating it?