Re: MSC: why "Checking list of deleted records ..." persists?
https://doc.4d.com/4Dv17/4D/17/Compact-page.300-3743562.en.html check out "Compact address table" > 2019/01/13 1:29、Spencer Hinsdale via 4D_Tech <4d_tech@lists.4d.com>のメール: > > Isn’t there an option for Compact to drop Address Tables? This invalidates > any Log Files but gives table(s) a clean start. There is a function like > Table Fragmentation which returns ratio of remaining record to total address > table. Sorry not at computer... ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: MSC: why "Checking list of deleted records ..." persists?
If it is just one table you can export the records, TRUNCATE TABLE, and import. This is basically a one table compact and resets the address table too. > On Jan 12, 2019, at 11:29 AM, Spencer Hinsdale via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Hi Kirk, > > Isn’t there an option for Compact to drop Address Tables? This invalidates > any Log Files but gives table(s) a clean start. There is a function like > Table Fragmentation which returns ratio of remaining record to total address > table. Sorry not at computer... > > Spencer > >> On Jan 12, 2019, at 8:12 AM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> >> wrote: >> >> A few months ago a bug resulted in a large number of records being created >> in a table ([email_que]) by mistake. Bug was fixed and 1 or 2 million bogus >> records were deleted. >> >> Since then the data file has been verified and compacted at least once. >> >> Just now I was running a verify on the data file again and notice 4D >> spending a - very - long - time verifying that table. Looking at the verify >> log I notice a few, but not all, tables with this message listed by them. >> >> The table property "Records are definitively deleted" is not checked for >> [email_que]. At least one other table with the message do have it checked. >> >> I have to assume it's connected with the the large selection that was >> deleted. But given that I would expect a repair/compact operations to have >> resolved it. >> >> Anyone else run into this? >> >> Thanks >> -- >> Kirk Brooks >> San Francisco, CA >> === >> >> *We go vote - they go home* >> ** >> 4D Internet Users Group (4D iNUG) >> Archive: http://lists.4d.com/archives.html >> Options: https://lists.4d.com/mailman/options/4d_tech >> Unsub: mailto:4d_tech-unsubscr...@lists.4d.com >> ** > ** > 4D Internet Users Group (4D iNUG) > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ** ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: MSC: why "Checking list of deleted records ..." persists?
Hi Kirk, Isn’t there an option for Compact to drop Address Tables? This invalidates any Log Files but gives table(s) a clean start. There is a function like Table Fragmentation which returns ratio of remaining record to total address table. Sorry not at computer... Spencer > On Jan 12, 2019, at 8:12 AM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > A few months ago a bug resulted in a large number of records being created > in a table ([email_que]) by mistake. Bug was fixed and 1 or 2 million bogus > records were deleted. > > Since then the data file has been verified and compacted at least once. > > Just now I was running a verify on the data file again and notice 4D > spending a - very - long - time verifying that table. Looking at the verify > log I notice a few, but not all, tables with this message listed by them. > > The table property "Records are definitively deleted" is not checked for > [email_que]. At least one other table with the message do have it checked. > > I have to assume it's connected with the the large selection that was > deleted. But given that I would expect a repair/compact operations to have > resolved it. > > Anyone else run into this? > > Thanks > -- > Kirk Brooks > San Francisco, CA > === > > *We go vote - they go home* > ** > 4D Internet Users Group (4D iNUG) > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ** ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
MSC: why "Checking list of deleted records ..." persists?
A few months ago a bug resulted in a large number of records being created in a table ([email_que]) by mistake. Bug was fixed and 1 or 2 million bogus records were deleted. Since then the data file has been verified and compacted at least once. Just now I was running a verify on the data file again and notice 4D spending a - very - long - time verifying that table. Looking at the verify log I notice a few, but not all, tables with this message listed by them. The table property "Records are definitively deleted" is not checked for [email_que]. At least one other table with the message do have it checked. I have to assume it's connected with the the large selection that was deleted. But given that I would expect a repair/compact operations to have resolved it. Anyone else run into this? Thanks -- Kirk Brooks San Francisco, CA === *We go vote - they go home* ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **