Dumb question: are you sure you're only inserting one record at a time? Is it possible you're inserting records so fast that the timestamp is the same for two of them?
On Fri, Sep 14, 2018 at 3:30 PM Andrew Stewart <astew...@arguscontrols.com> wrote: > Hi, > I am having problems with a database reporting Unique > Constraint Failed when doing an insert. > Table consists of 3 columns: > ID, DateTime, data > Constraint is on ID,DateTime. > > DateTime trying to enter is current time. > > File is 200+ GB. > > I have tested this same to a 1.4TB file, but have updated > my copy of SQLite source since that test. > > Thanks, > Andrew Stewart > Software Designer > > ARGUS CONTROLS > 18445 53rd Avenue | Surrey, BC | V3S 7A4 | Canada > t +1.604.538.3531 ext. 108 | +1.800.667.2090 | f +1.604.538.4728 > www.arguscontrols.com<http://www.arguscontrols.com/> > > Notice: This electronic transmission contains confidential information, > intended only for the person(s) named above. If you are not the intended > recipient, you are hereby notified that any disclosure, copying, > distribution, or any other use of this email is strictly prohibited. If you > have received this transmission by error, please notify us immediately by > return email and destroy the original transmission immediately and all > copies thereof. > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users