Re: ArticleIDs gone missing

--- In [email protected], Lenny_Nero <Lenny_Nero@...> wrote:
>
> bobellsmore said
> 
> 
> > Well, I've solved the problem:
> > Poking around at anything that would respond, I found that the
> > Newsgroups Window was empty.
> > 
> > I wasn't able to find a "re-load the available newsgroups from this
> > server" command anywhere and the "Reload" tab in the Newsgroups window
> > is greyed out (as are the two Force... tabs) so I created a new instance
> > of the existing server and got an automatic download of the groups.
> > 
> > Is anybody able to tell me a better way than this?
> > 
> > With the Newsgroups window re-populated, I loaded the .nzb file again
> > and all the Article IDs were in place and I could carry on.
> 
> Glad you got it fixed. Other way is to "Force Exist" a group and then you
> will be able to click on it and "Reload Groups", or turn off the group cmd
> and then the servers (If they can run without that cmd) dont care about
> groups, but they must be set for MSGID only all the way.
> 
> Sounded like something just got damaged in BNR's database, or a problem
> with the .nzb file something that can often happen with some indexing
> sites.
> 
> I have stopped using one site altogther because they had some problem and
> I kept getting missing areas like you said with this...
> 
>  (Beta)): Exception Access violation at address 005159CF in module 'BNR3.exe'. Read of address 07DE8000 in ReadNZBFile | </file> tag!
>  (Beta)): Exception Access violation at address 005159CF in module 'BNR3.exe'. Read of address 07DE8000 in ReadNZBFile | <file> tag!
>  (Beta)): Exception Access violation at address 005159CF in module 'BNR3.exe'. Read of address 04824000 in ReadNZBFile | </file> tag!
> 
> in the logs, I go to another site and they are fine.
> 
> When did you last do a vac (SQL vacuum cmd) on the database ?
> Might be worth doing so, I do it every few months with the .bat files I
> have posted to this group and they keep the DB clean and tight, here is
> one again put into txt file save and call/re-name "zz-Vac & Frg.bat" you
> need the sqLite.exe file and Contig.exe (only if you want to de-frag the
> files after)...
> http://en.wikipedia.org/wiki/Contig_(defragmentation_utility)
> http://forum.sysinternals.com/topic10769.html
> 
> file start---
> pause
> sqlite msgdb.bnr "vacuum;"
> sqlite grpdb.bnr "vacuum;"
> 
> 
> sqlite msgdb.bnr "pragma integrity_check;"
> sqlite grpdb.bnr "pragma integrity_check;"
> 
> 
> pause
> contig *.* -v
> pause
> ---file end
> 
> Hope this can be of some help.
> 
> L_N
> 
> -- 
> New Labour
> ...Tough on freedom, tough on the causes of freedom.
>
Lenny,
Thanks for the info, I'll keep that on file in case it ever happens again. Given that I've never before encountered this problem in years of using BNR2/3, I'm hopeful that I won't need it again :-)

I downloaded your .bat files some years ago but don't use them any more. Ever since I found the http://www.binsearch.info/ site, I've stopped downloading headers completely for the sites that I'm interested in. This reduces the importance of the databases to the point where deleting them completely (actually, adding .old to the end of the filename)is often a first step in the event of problems.



------------------------------------

Important Addresses:
Post message: [email protected]
Group owner:  [email protected]
BNR homepage: http://www.bnr2.org/
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/bnr1/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/bnr1/join
    (Yahoo! ID required)

<*> To change settings via email:
    [email protected] 
    [email protected]

<*> To unsubscribe from this group, send an email to:
    [email protected]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/