> Try to run the same command on the now fixed database (making a copy to > be on the safe side). It should not show any results. If that is the > case, then you somehow got many duplicate files in directories. Are the > parent_inodes all the same (problem was only in one folder) or different? > > Produces zero rows on current DB.
pragma integrity_check produces: row 52535 missing from index sqlite_autoindex_contents_1 row 52536 missing from index sqlite_autoindex_contents_1 row 52537 missing from index sqlite_autoindex_contents_1 row 52538 missing from index sqlite_autoindex_contents_1 row 52539 missing from index sqlite_autoindex_contents_1 row 52540 missing from index sqlite_autoindex_contents_1 row 52541 missing from index sqlite_autoindex_contents_1 row 52542 missing from index sqlite_autoindex_contents_1 row 52543 missing from index sqlite_autoindex_contents_1 row 52544 missing from index sqlite_autoindex_contents_1 row 52545 missing from index sqlite_autoindex_contents_1 row 52546 missing from index sqlite_autoindex_contents_1 row 52547 missing from index sqlite_autoindex_contents_1 row 52548 missing from index sqlite_autoindex_contents_1 row 52549 missing from index sqlite_autoindex_contents_1 row 52550 missing from index sqlite_autoindex_contents_1 row 52551 missing from index sqlite_autoindex_contents_1 row 52552 missing from index sqlite_autoindex_contents_1 row 52553 missing from index sqlite_autoindex_contents_1 row 52554 missing from index sqlite_autoindex_contents_1 row 52555 missing from index sqlite_autoindex_contents_1 row 52556 missing from index sqlite_autoindex_contents_1 row 52557 missing from index sqlite_autoindex_contents_1 row 52558 missing from index sqlite_autoindex_contents_1 row 52559 missing from index sqlite_autoindex_contents_1 row 52560 missing from index sqlite_autoindex_contents_1 row 52561 missing from index sqlite_autoindex_contents_1 row 52562 missing from index sqlite_autoindex_contents_1 row 52563 missing from index sqlite_autoindex_contents_1 row 52564 missing from index sqlite_autoindex_contents_1 row 52565 missing from index sqlite_autoindex_contents_1 row 52566 missing from index sqlite_autoindex_contents_1 row 52567 missing from index sqlite_autoindex_contents_1 row 52568 missing from index sqlite_autoindex_contents_1 row 52569 missing from index sqlite_autoindex_contents_1 row 52570 missing from index sqlite_autoindex_contents_1 row 52571 missing from index sqlite_autoindex_contents_1 row 52572 missing from index sqlite_autoindex_contents_1 row 52573 missing from index sqlite_autoindex_contents_1 row 52574 missing from index sqlite_autoindex_contents_1 row 52575 missing from index sqlite_autoindex_contents_1 row 52576 missing from index sqlite_autoindex_contents_1 row 52577 missing from index sqlite_autoindex_contents_1 row 52578 missing from index sqlite_autoindex_contents_1 row 52579 missing from index sqlite_autoindex_contents_1 row 52580 missing from index sqlite_autoindex_contents_1 row 52581 missing from index sqlite_autoindex_contents_1 row 52582 missing from index sqlite_autoindex_contents_1 row 52583 missing from index sqlite_autoindex_contents_1 row 52584 missing from index sqlite_autoindex_contents_1 row 52585 missing from index sqlite_autoindex_contents_1 row 52586 missing from index sqlite_autoindex_contents_1 row 52587 missing from index sqlite_autoindex_contents_1 row 52588 missing from index sqlite_autoindex_contents_1 row 52589 missing from index sqlite_autoindex_contents_1 row 52590 missing from index sqlite_autoindex_contents_1 row 52591 missing from index sqlite_autoindex_contents_1 row 52592 missing from index sqlite_autoindex_contents_1 row 52593 missing from index sqlite_autoindex_contents_1 row 52594 missing from index sqlite_autoindex_contents_1 row 52595 missing from index sqlite_autoindex_contents_1 row 52596 missing from index sqlite_autoindex_contents_1 row 52597 missing from index sqlite_autoindex_contents_1 row 52598 missing from index sqlite_autoindex_contents_1 row 52599 missing from index sqlite_autoindex_contents_1 row 52600 missing from index sqlite_autoindex_contents_1 row 52601 missing from index sqlite_autoindex_contents_1 row 52602 missing from index sqlite_autoindex_contents_1 row 52603 missing from index sqlite_autoindex_contents_1 row 52604 missing from index sqlite_autoindex_contents_1 row 52605 missing from index sqlite_autoindex_contents_1 row 52606 missing from index sqlite_autoindex_contents_1 row 52607 missing from index sqlite_autoindex_contents_1 row 52608 missing from index sqlite_autoindex_contents_1 row 52609 missing from index sqlite_autoindex_contents_1 row 52610 missing from index sqlite_autoindex_contents_1 row 52611 missing from index sqlite_autoindex_contents_1 row 52612 missing from index sqlite_autoindex_contents_1 row 52613 missing from index sqlite_autoindex_contents_1 row 52614 missing from index sqlite_autoindex_contents_1 row 52615 missing from index sqlite_autoindex_contents_1 row 52616 missing from index sqlite_autoindex_contents_1 row 52617 missing from index sqlite_autoindex_contents_1 row 52618 missing from index sqlite_autoindex_contents_1 row 52619 missing from index sqlite_autoindex_contents_1 row 52620 missing from index sqlite_autoindex_contents_1 row 52621 missing from index sqlite_autoindex_contents_1 row 52622 missing from index sqlite_autoindex_contents_1 row 52623 missing from index sqlite_autoindex_contents_1 row 52624 missing from index sqlite_autoindex_contents_1 row 52625 missing from index sqlite_autoindex_contents_1 row 52626 missing from index sqlite_autoindex_contents_1 row 52627 missing from index sqlite_autoindex_contents_1 row 52628 missing from index sqlite_autoindex_contents_1 row 52629 missing from index sqlite_autoindex_contents_1 row 52630 missing from index sqlite_autoindex_contents_1 row 52631 missing from index sqlite_autoindex_contents_1 row 52632 missing from index sqlite_autoindex_contents_1 row 52633 missing from index sqlite_autoindex_contents_1 row 52634 missing from index sqlite_autoindex_contents_1 Further, while: select c.* from contents c join contents c1 on c1.parent_inode = c.parent_inode and c1.name_id = c.name_id and c1.rowid > c.rowid join names n on n.id=c.name_id; produces a lot of rows, the same query with just 'select c.parent_inode...' produces NO ROWS. Looks like a very messed up database; at least a corrupt index I suspect. -- You received this message because you are subscribed to the Google Groups "s3ql" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/s3ql/72985962-d8b1-48fd-a4f4-107fc3c728f0%40googlegroups.com.
