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

Reply via email to