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; 1086|155|entryId=0,tableId=CPIdTable,CSId=1|0 1087|155|entryId=1,tableId=CPGMembersTable,CSId=1|0 1088|155|entryId=1,tableId=CPGNamesTable,CSId=1|0 1089|155|entryId=1,tableId=CPIdTable,CSId=1|0 1090|155|entryId=1,tableId=HWCTable,CSId=1|0 1091|155|entryId=1,tableId=NETable,CSId=1|0 1092|155|entryId=10,tableId=CPGMembersTable,CSId=1|0 1093|155|entryId=10,tableId=CPGNamesTable,CSId=1|0 1094|155|entryId=10,tableId=CPIdTable,CSId=1|0 1095|155|entryId=10,tableId=HWCTable,CSId=1|0 1096|155|entryId=100,tableId=CPGMembersTable,CSId=1|0 1097|155|entryId=1001,tableId=CPIdTable,CSId=1|0 1098|155|entryId=101,tableId=CPGMembersTable,CSId=1|0 1099|155|entryId=102,tableId=CPGMembersTable,CSId=1|0 1100|155|entryId=103,tableId=CPGMembersTable,CSId=1|0 1101|155|entryId=104,tableId=CPGMembersTable,CSId=1|0 1102|155|entryId=105,tableId=CPGMembersTable,CSId=1|0 1103|155|entryId=106,tableId=CPGMembersTable,CSId=1|0 1104|155|entryId=107,tableId=CPGMembersTable,CSId=1|0 1105|155|entryId=108,tableId=CPGMembersTable,CSId=1|0 1106|155|entryId=109,tableId=CPGMembersTable,CSId=1|0 1107|155|entryId=11,tableId=CPGMembersTable,CSId=1|0 1108|155|entryId=11,tableId=CPGNamesTable,CSId=1|0 1109|155|entryId=11,tableId=CPIdTable,CSId=1|0 1110|155|entryId=11,tableId=HWCTable,CSId=1|0 1111|155|entryId=110,tableId=CPGMembersTable,CSId=1|0 1112|155|entryId=111,tableId=CPGMembersTable,CSId=1|0 1113|155|entryId=112,tableId=CPGMembersTable,CSId=1|0 1114|155|entryId=113,tableId=CPGMembersTable,CSId=1|0 1115|155|entryId=114,tableId=CPGMembersTable,CSId=1|0 1116|155|entryId=115,tableId=CPGMembersTable,CSId=1|0 1117|155|entryId=116,tableId=CPGMembersTable,CSId=1|0 1118|155|entryId=117,tableId=CPGMembersTable,CSId=1|0 1119|155|entryId=118,tableId=CPGMembersTable,CSId=1|0 1120|155|entryId=119,tableId=CPGMembersTable,CSId=1|0 1121|155|entryId=12,tableId=CPGMembersTable,CSId=1|0 1122|155|entryId=12,tableId=CPGNamesTable,CSId=1|0 1123|155|entryId=12,tableId=CPIdTable,CSId=1|0 1124|155|entryId=120,tableId=CPGMembersTable,CSId=1|0 1125|155|entryId=121,tableId=CPGMembersTable,CSId=1|0 1126|155|entryId=122,tableId=CPGMembersTable,CSId=1|0 1127|155|entryId=123,tableId=CPGMembersTable,CSId=1|0 1128|155|entryId=124,tableId=CPGMembersTable,CSId=1|0 1129|155|entryId=125,tableId=CPGMembersTable,CSId=1|0 1130|155|entryId=126,tableId=CPGMembersTable,CSId=1|0 1131|155|entryId=127,tableId=CPGMembersTable,CSId=1|0 1132|155|entryId=128,tableId=CPGMembersTable,CSId=1|0 1133|155|entryId=129,tableId=CPGMembersTable,CSId=1|0 1134|155|entryId=13,tableId=CPGMembersTable,CSId=1|0 1135|155|entryId=13,tableId=CPGNamesTable,CSId=1|0 1136|155|entryId=13,tableId=CPIdTable,CSId=1|0 1137|155|entryId=130,tableId=CPGMembersTable,CSId=1|0 1138|155|entryId=131,tableId=CPGMembersTable,CSId=1|0 1139|155|entryId=132,tableId=CPGMembersTable,CSId=1|0 1140|155|entryId=133,tableId=CPGMembersTable,CSId=1|0 1141|155|entryId=134,tableId=CPGMembersTable,CSId=1|0 1142|155|entryId=135,tableId=CPGMembersTable,CSId=1|0 1143|155|entryId=136,tableId=CPGMembersTable,CSId=1|0 1144|155|entryId=137,tableId=CPGMembersTable,CSId=1|0 1145|155|entryId=138,tableId=CPGMembersTable,CSId=1|0 1146|155|entryId=139,tableId=CPGMembersTable,CSId=1|0 1147|155|entryId=14,tableId=CPGMembersTable,CSId=1|0 1148|155|entryId=14,tableId=CPGNamesTable,CSId=1|0 1149|155|entryId=14,tableId=CPIdTable,CSId=1|0 1150|155|entryId=140,tableId=CPGMembersTable,CSId=1|0 1151|155|entryId=141,tableId=CPGMembersTable,CSId=1|0 1152|155|entryId=142,tableId=CPGMembersTable,CSId=1|0 1153|155|entryId=143,tableId=CPGMembersTable,CSId=1|0 1154|155|entryId=144,tableId=CPGMembersTable,CSId=1|0 1155|155|entryId=145,tableId=CPGMembersTable,CSId=1|0 1156|155|entryId=146,tableId=CPGMembersTable,CSId=1|0 1157|155|entryId=147,tableId=CPGMembersTable,CSId=1|0 1158|155|entryId=148,tableId=CPGMembersTable,CSId=1|0 1159|155|entryId=149,tableId=CPGMembersTable,CSId=1|0 1160|155|entryId=15,tableId=CPGMembersTable,CSId=1|0 1161|155|entryId=15,tableId=CPGNamesTable,CSId=1|0 1162|155|entryId=15,tableId=CPIdTable,CSId=1|0 1163|155|entryId=150,tableId=CPGMembersTable,CSId=1|0 1164|155|entryId=151,tableId=CPGMembersTable,CSId=1|0 1165|155|entryId=152,tableId=CPGMembersTable,CSId=1|0 1166|155|entryId=153,tableId=CPGMembersTable,CSId=1|0 1167|155|entryId=154,tableId=CPGMembersTable,CSId=1|0 1168|155|entryId=155,tableId=CPGMembersTable,CSId=1|0 1169|155|entryId=156,tableId=CPGMembersTable,CSId=1|0 1170|155|entryId=157,tableId=CPGMembersTable,CSId=1|0 1171|155|entryId=158,tableId=CPGMembersTable,CSId=1|0 1172|155|entryId=159,tableId=CPGMembersTable,CSId=1|0 1173|155|entryId=16,tableId=CPGMembersTable,CSId=1|0 1174|155|entryId=16,tableId=CPGNamesTable,CSId=1|0 1175|155|entryId=16,tableId=CPIdTable,CSId=1|0 1176|155|entryId=160,tableId=CPGMembersTable,CSId=1|0 1177|155|entryId=161,tableId=CPGMembersTable,CSId=1|0 1178|155|entryId=162,tableId=CPGMembersTable,CSId=1|0 1179|155|entryId=163,tableId=CPGMembersTable,CSId=1|0 1180|155|entryId=164,tableId=CPGMembersTable,CSId=1|0 1181|155|entryId=165,tableId=CPGMembersTable,CSId=1|0 1182|155|entryId=166,tableId=CPGMembersTable,CSId=1|0 1183|155|entryId=167,tableId=CPGMembersTable,CSId=1|0 1184|155|entryId=168,tableId=CPGMembersTable,CSId=1|0 1185|155|entryId=169,tableId=CPGMembersTable,CSId=1|0 1186|155|entryId=17,tableId=CPGMembersTable,CSId=1|0 1187|155|entryId=17,tableId=CPGNamesTable,CSId=1|0 1188|155|entryId=17,tableId=CPIdTable,CSId=1|0 1189|155|entryId=170,tableId=CPGMembersTable,CSId=1|0 1190|155|entryId=171,tableId=CPGMembersTable,CSId=1|0 1191|155|entryId=172,tableId=CPGMembersTable,CSId=1|0 1192|155|entryId=173,tableId=CPGMembersTable,CSId=1|0 1193|155|entryId=174,tableId=CPGMembersTable,CSId=1|0 1194|155|entryId=175,tableId=CPGMembersTable,CSId=1|0 1195|155|entryId=176,tableId=CPGMembersTable,CSId=1|0 1196|155|entryId=177,tableId=CPGMembersTable,CSId=1|0 1197|155|entryId=178,tableId=CPGMembersTable,CSId=1|0 1198|155|entryId=179,tableId=CPGMembersTable,CSId=1|0 1199|155|entryId=18,tableId=CPGMembersTable,CSId=1|0 1200|155|entryId=180,tableId=CPGMembersTable,CSId=1|0 1201|155|entryId=181,tableId=CPGMembersTable,CSId=1|0 1202|155|entryId=182,tableId=CPGMembersTable,CSId=1|0 1203|155|entryId=183,tableId=CPGMembersTable,CSId=1|0 1204|155|entryId=184,tableId=CPGMembersTable,CSId=1|0 1205|155|entryId=185,tableId=CPGMembersTable,CSId=1|0 1206|155|entryId=186,tableId=CPGMembersTable,CSId=1|0 1207|155|entryId=187,tableId=CPGMembersTable,CSId=1|0 1208|155|entryId=188,tableId=CPGMembersTable,CSId=1|0 1209|155|entryId=189,tableId=CPGMembersTable,CSId=1|0 1210|155|entryId=19,tableId=CPGMembersTable,CSId=1|0 1211|155|entryId=190,tableId=CPGMembersTable,CSId=1|0 1212|155|entryId=191,tableId=CPGMembersTable,CSId=1|0 1213|155|entryId=192,tableId=CPGMembersTable,CSId=1|0 1214|155|entryId=193,tableId=CPGMembersTable,CSId=1|0 1215|155|entryId=194,tableId=CPGMembersTable,CSId=1|0 1216|155|entryId=195,tableId=CPGMembersTable,CSId=1|0 1217|155|entryId=196,tableId=CPGMembersTable,CSId=1|0 1218|155|entryId=197,tableId=CPGMembersTable,CSId=1|0 1219|155|entryId=198,tableId=CPGMembersTable,CSId=1|0 1220|155|entryId=199,tableId=CPGMembersTable,CSId=1|0 1221|155|entryId=2,tableId=CPGNamesTable,CSId=1|0 1222|155|entryId=2,tableId=CPIdTable,CSId=1|0 1223|155|entryId=2,tableId=HWCTable,CSId=1|0 1224|155|entryId=2,tableId=NETable,CSId=1|0 1225|155|entryId=20,tableId=CPGMembersTable,CSId=1|0 1226|155|entryId=200,tableId=CPGMembersTable,CSId=1|0 1227|155|entryId=201,tableId=CPGMembersTable,CSId=1|0 1228|155|entryId=202,tableId=CPGMembersTable,CSId=1|0 1229|155|entryId=203,tableId=CPGMembersTable,CSId=1|0 1230|155|entryId=21,tableId=CPGMembersTable,CSId=1|0 1231|155|entryId=21,tableId=HWCTable,CSId=1|0 1232|155|entryId=22,tableId=CPGMembersTable,CSId=1|0 1233|155|entryId=22,tableId=HWCTable,CSId=1|0 1234|155|entryId=23,tableId=CPGMembersTable,CSId=1|0 1235|155|entryId=23,tableId=HWCTable,CSId=1|0 1236|155|entryId=24,tableId=CPGMembersTable,CSId=1|0 1237|155|entryId=24,tableId=HWCTable,CSId=1|0 1238|155|entryId=25,tableId=CPGMembersTable,CSId=1|0 1239|155|entryId=25,tableId=HWCTable,CSId=1|0 1240|155|entryId=26,tableId=CPGMembersTable,CSId=1|0 1241|155|entryId=26,tableId=HWCTable,CSId=1|0 1242|155|entryId=27,tableId=CPGMembersTable,CSId=1|0 1243|155|entryId=27,tableId=HWCTable,CSId=1|0 1244|155|entryId=28,tableId=CPGMembersTable,CSId=1|0 1245|155|entryId=28,tableId=HWCTable,CSId=1|0 1246|155|entryId=29,tableId=CPGMembersTable,CSId=1|0 1247|155|entryId=29,tableId=HWCTable,CSId=1|0 1248|155|entryId=3,tableId=CPGMembersTable,CSId=1|0 1249|155|entryId=3,tableId=CPGNamesTable,CSId=1|0 1250|155|entryId=3,tableId=CPIdTable,CSId=1|0 1251|155|entryId=3,tableId=HWCTable,CSId=1|0 1252|155|entryId=3,tableId=NETable,CSId=1|0 1253|155|entryId=30,tableId=CPGMembersTable,CSId=1|0 1254|155|entryId=30,tableId=HWCTable,CSId=1|0 1255|155|entryId=31,tableId=CPGMembersTable,CSId=1|0 1256|155|entryId=31,tableId=HWCTable,CSId=1|0 1257|155|entryId=32,tableId=CPGMembersTable,CSId=1|0 1258|155|entryId=32,tableId=HWCTable,CSId=1|0 1259|155|entryId=33,tableId=CPGMembersTable,CSId=1|0 1260|155|entryId=33,tableId=HWCTable,CSId=1|0 1261|155|entryId=34,tableId=CPGMembersTable,CSId=1|0 1262|155|entryId=34,tableId=HWCTable,CSId=1|0 1263|155|entryId=35,tableId=CPGMembersTable,CSId=1|0 1264|155|entryId=35,tableId=HWCTable,CSId=1|0 1265|155|entryId=36,tableId=CPGMembersTable,CSId=1|0 1266|155|entryId=36,tableId=HWCTable,CSId=1|0 1267|155|entryId=37,tableId=CPGMembersTable,CSId=1|0 1268|155|entryId=37,tableId=HWCTable,CSId=1|0 1269|155|entryId=38,tableId=CPGMembersTable,CSId=1|0 1270|155|entryId=38,tableId=HWCTable,CSId=1|0 1271|155|entryId=39,tableId=CPGMembersTable,CSId=1|0 1272|155|entryId=4,tableId=CPGMembersTable,CSId=1|0 1273|155|entryId=4,tableId=CPGNamesTable,CSId=1|0 1274|155|entryId=4,tableId=CPIdTable,CSId=1|0 1275|155|entryId=4,tableId=HWCTable,CSId=1|0 1276|155|entryId=4,tableId=NETable,CSId=1|0 1277|155|entryId=40,tableId=CPGMembersTable,CSId=1|0 1278|155|entryId=41,tableId=CPGMembersTable,CSId=1|0 1279|155|entryId=42,tableId=CPGMembersTable,CSId=1|0 1280|155|entryId=43,tableId=CPGMembersTable,CSId=1|0 1281|155|entryId=44,tableId=CPGMembersTable,CSId=1|0 1282|155|entryId=45,tableId=CPGMembersTable,CSId=1|0 1283|155|entryId=46,tableId=CPGMembersTable,CSId=1|0 1284|155|entryId=47,tableId=CPGMembersTable,CSId=1|0 1285|155|entryId=48,tableId=CPGMembersTable,CSId=1|0 1286|155|entryId=49,tableId=CPGMembersTable,CSId=1|0 1287|155|entryId=5,tableId=CPGMembersTable,CSId=1|0 1288|155|entryId=5,tableId=CPGNamesTable,CSId=1|0 1289|155|entryId=5,tableId=CPIdTable,CSId=1|0 1290|155|entryId=5,tableId=HWCTable,CSId=1|0 1291|155|entryId=5,tableId=NETable,CSId=1|0 1292|155|entryId=50,tableId=CPGMembersTable,CSId=1|0 1293|155|entryId=51,tableId=CPGMembersTable,CSId=1|0 1294|155|entryId=52,tableId=CPGMembersTable,CSId=1|0 1295|155|entryId=53,tableId=CPGMembersTable,CSId=1|0 1296|155|entryId=54,tableId=CPGMembersTable,CSId=1|0 1297|155|entryId=55,tableId=CPGMembersTable,CSId=1|0 1298|155|entryId=56,tableId=CPGMembersTable,CSId=1|0 1299|155|entryId=57,tableId=CPGMembersTable,CSId=1|0 1300|155|entryId=58,tableId=CPGMembersTable,CSId=1|0 1301|155|entryId=59,tableId=CPGMembersTable,CSId=1|0 1302|155|entryId=6,tableId=CPGMembersTable,CSId=1|0 1303|155|entryId=6,tableId=CPGNamesTable,CSId=1|0 1304|155|entryId=6,tableId=CPIdTable,CSId=1|0 1305|155|entryId=6,tableId=HWCTable,CSId=1|0 1306|155|entryId=6,tableId=NETable,CSId=1|0 1307|155|entryId=60,tableId=CPGMembersTable,CSId=1|0 1308|155|entryId=61,tableId=CPGMembersTable,CSId=1|0 1309|155|entryId=62,tableId=CPGMembersTable,CSId=1|0 1310|155|entryId=63,tableId=CPGMembersTable,CSId=1|0 1311|155|entryId=64,tableId=CPGMembersTable,CSId=1|0 1312|155|entryId=65,tableId=CPGMembersTable,CSId=1|0 1313|155|entryId=66,tableId=CPGMembersTable,CSId=1|0 1314|155|entryId=67,tableId=CPGMembersTable,CSId=1|0 1315|155|entryId=68,tableId=CPGMembersTable,CSId=1|0 1309|155|entryId=99,tableId=CPGMembersTable,CSId=1|0 1335|155|entryId=8,tableId=HWCTable,CSId=1|0 1336|155|entryId=8,tableId=NETable,CSId=1|0 1337|155|entryId=80,tableId=CPGMembersTable,CSId=1|0 1338|155|entryId=81,tableId=CPGMembersTable,CSId=1|0 1339|155|entryId=82,tableId=CPGMembersTable,CSId=1|0 1340|155|entryId=83,tableId=CPGMembersTable,CSId=1|0 1341|155|entryId=84,tableId=CPGMembersTable,CSId=1|0 1342|155|entryId=85,tableId=CPGMembersTable,CSId=1|0 1343|155|entryId=86,tableId=CPGMembersTable,CSId=1|0 1344|155|entryId=87,tableId=CPGMembersTable,CSId=1|0 1345|155|entryId=88,tableId=CPGMembersTable,CSId=1|0 1346|155|entryId=89,tableId=CPGMembersTable,CSId=1|0 1347|155|entryId=9,tableId=CPGMembersTable,CSId=1|0 1348|155|entryId=9,tableId=CPGNamesTable,CSId=1|0 1349|155|entryId=9,tableId=CPIdTable,CSId=1|0 1350|155|entryId=9,tableId=HWCTable,CSId=1|0 1351|155|entryId=90,tableId=CPGMembersTable,CSId=1|0 1352|155|entryId=91,tableId=CPGMembersTable,CSId=1|0 1353|155|entryId=92,tableId=CPGMembersTable,CSId=1|0 1354|155|entryId=93,tableId=CPGMembersTable,CSId=1|0 1355|155|entryId=94,tableId=CPGMembersTable,CSId=1|0 1356|155|entryId=95,tableId=CPGMembersTable,CSId=1|0 1357|155|entryId=96,tableId=CPGMembersTable,CSId=1|0 1358|155|entryId=97,tableId=CPGMembersTable,CSId=1|0 1359|155|entryId=98,tableId=CPGMembersTable,CSId=1|0 1360|155|entryId=99,tableId=CPGMembersTable,CSId=1|0 sqlite> My question when we are writing to the sqlite we writing in a order, when the write happens the node went for reboot. Then after reboot we see that the objects are corrupted.If the reboot happens is there a possibility of sqlite corruption? is there any other case at reboot can cause sqlite3 corruption. -Neelakanta _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users