Hello, as I have a repository where I have reproduced the problem http://fossil-scm.org/index.html/tktview?name=fbea61caf0 , I'm investigating a bit.
I found this: sqlite> .schema orphan CREATE TABLE orphan( rid INTEGER PRIMARY KEY, baseline INTEGER ); CREATE INDEX orphan_baseline ON orphan(baseline); sqlite> select * from orphan; 8024|8031 sqlite> select * from blob where rid=8024 or rid=8031; 8024|26|257565|5d6a9957808c417aae6f41c8c9cda1dc6e3bffbb| 8031|26|347|66514ffdad03438ddda7145dbedbed7f2e72a294| The first, 8024, is the BASELINE manifest artifact, that shows fine in all fossil operations. 8031 is the next DELTA manifest artifact, that does not show. No artifact after that shows, either. And as I told before, in the many times I've hit this problem, "fossil rebuild" fixes the situation. I keep on investigating, although of course I don't know much about what fossil should be doing in terms of sql operations/function calls. I'm only trying to ring a bell to drh. Regards, Lluís. _______________________________________________ fossil-users mailing list fossil-users@lists.fossil-scm.org http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users