All of what Richard asked and said, plus, my question of where the file stored in relation to the application? (Network attached storage?)
On Tue, Jan 5, 2016 at 10:22 AM, Richard Hipp <drh at sqlite.org> wrote: > On 1/5/16, Andrew Stewart <AStewart at arguscontrols.com> wrote: > > Hi, > > I am getting the following error on a database. The > > database is 78GB large when this started. I am adding data to it via > insert > > statements. I believe that this is the second time that I have seen > this. > > It has been running for about 2 weeks adding data to it constantly. The > > database structure is simple. Following is the code for the create > table: > > CREATE TABLE dataStreamRecord ( > > fwParameterID INTEGER NOT NULL, > > dateTime INTEGER NOT NULL, > > data INTEGER NOT NULL, > > UNIQUE ( > > fwParameterID, > > dateTime > > ) > > ); > > FWIW, a more efficient schema might be: > > CREATE TABLE dataStreamRecord ( > fwParameterId INT, > dateTime INT, > data INT NOT NULL, > PRIMARY KEY(fwParameterId,dateTime) > ) WITHOUT ROWID; > > > > > I am wondering what could cause this. The database does > > have the compression attribute turned on. The database time/date is > still > > getting adjusted. > > "compression attribute"? SQLite doesn't have any such thing. Is this > a feature of your filesystem? > > Have you run "PRAGMA quick_check" on the faulty database to gather > more information about the problem? > > Have you enabled error logging as described at > (https://www.sqlite.org/errlog.html)? > > -- > D. Richard Hipp > drh at sqlite.org > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
