The following is the result od pragma integrity check:
sqlite> PRAGMA integrity_check;
*** in database main ***
Main freelist: 38 of 38 pages missing from overflow list starting at 0
On tree page 608 cell 13: Rowid 1309 out of order (min less than parent min
of 1315)
Page 943 is never used
Page
The following is observed
sqlite> SELECT * FROM objects WHERE obj_id = 1309;
1309|155|entryId=62,tableId=CPGMembersTable,CSId=1|0
sqlite>
If i try to select it from different column here i can see two rows having
same obj_ids
sqlite> SELECT * FROM objects WHERE class_id=155;
here the Duplication means the object table obj_id which is a primary key i
duplicated twice
Here my question is for primary key (obj_id) , we are getting two entries
for the same primary id which must be unique
since the database is large i am pasting the db bump output
CREATE TABLE objects
I am using sqlite3 along with drbd. I found the primary key for the table is
inserted twice and the UNIQUE attribute of the table is also not unique.
The application is inserting the objects into the table, and the machine got
rebooted. After coming up from reboot, when i looked into the database
4 matches
Mail list logo