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
)
);
I am wondering what could cause this. The database does have
the compression attribute turned on. The database time/date is still getting
adjusted.
Andrew Stewart
Software Designer
Argus Control Systems Ltd.
Tel: (604) 536-9100 ext. 108
astewart at arguscontrols.com<mailto:astewart at arguscontrols.com>
#101 - 18445 53rd Avenue | Surrey BC | CANADA | V3S 7A4
(604) 538-3531 | (800) 667-2090 | Fax (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.
