Okay, this thread is a month old, but hey...I have (had) a similar problem with failing to import, and it now seems to me to be directly tied into the "high cpu usage" problem outlined in this thread:
viewtopic.php?f=44&t=32356Here's how it all went down...
I was running 6.42 and had a problem with it not finishing file saves. To this Quade suggested I upgrade to 6.53, which I did, and that effectively made my initial problem go away. At this point, I thought all was fine...until later on when I did a "local" search for a set of files that I KNEW DAMNED WELL were there in one of my subscribed groups just a couple of days ago, but my search came up empty. This is my "WTF" moment that has been driving me crazy since.
Now hold on, because my description here will be really tedious.
The first thing I did was to search for the files manually, group by group, and I was shocked to find that almost ALL my groups were EMPTY. When I tried to update the groups, nothing appeared in the download window indicating it was doing anything. In one of the few groups that had a few paltry hundred files instead of the expected thousands, I tried downloading a small file with the same result: The system just sat there and stared at me.
Now 6.53 has a new feature when you view the "servers" tab, in that it shows all the threads for all the servers and whether they are connected or not. Mine were all disconnected.
This is when I brought up my task manager to see if anything else was going on that might be interfering with communications - and this is when I discovered the OVER 50% CPU usage, and paging going on to the tune of 800MB!!!
And yet there was NOTHING visible going on with NB. Clearly there was something seriously wrong here.
So I started sniffing around the forums here, and first I found the above mentioned "high CPU" thread. There were clues, but not enough for me to work with.
I also found a thread about having to manually import files from earlier versions into 6.5, but the described option wasn't in my "post storage" selection. Now it's interesting to note that AT THIS POINT IN TIME, there was no spool_v6 directory, and there WERE group-named subdirectories in spool_v1, each of which had database files in them.
Ya with me so far? Because now is when it gets interesting...and kinda weird...
So after more sniffing around, I finally found this thread, which sorta-kinda fits the problem I'm having. When I saw Wayne's "resolution", I couldn't quite follow what he was talking about, so I went looking for an "import" folder on my system.
And I found it. And it was loaded with the gz files he menmtioned.
And oh yeah - the weird part - now a spool_v6 folder was there, and all the directories were in it and the spool_v1 directory was empty. Looking through the spool_v6 directories, I noticed some of the database files were downright dinky and others had relatively large ones. As it turns out, the "dinky" databases showed no files in the group when I looked at them, while there were files in the groups that had larger databases,
So I took wayne's experiment a step further.
First I shut down NB, and then I renamed my "import" directory to "junk" and created an empty "Import" directory.
Next I renamed "spool_v6" to "xxxspoolv6" hoping that NB wouldn't find it (I first tried zipping it up, but it was 13 gigs, so I tried it this way instead).
Then I loaded NB again and looked at my task manager. NB was being quiet as a mouse.
And then I took ONE of the gz files and moved it into the empty import directory.
Poof! CPU activity went to 60% and my page file went to 650mb. This lasted for about 2 minutes, after which the gz file disappeared, a directory spool_v6 was created, and a group directory was created inside that.
This happened much the same way for other gz files, but not predictably.
The gz files are named with the following convention:
groupname-servername-message#range.gz
So I might get multiple gz files for the same group, named something like:
alt.binaries.putz-astraweb-23456-123456.gz
alt.binaries.putz-astraweb-123456-223456.gz
alt.binaries.putz-astraweb-223456-323456.gz
alt.binaries.putz-usenet-news-7654-17654.gz
alt.binaries.putz-usenet-news-17654-27654.gz
Although most weren't quite that clean and had gaps, you get the gist.
Now these gz files range in size from 2 or 3mb up to 60mb. Frustratingly, NB's processing times for these files seem to have little to do with their size.
While many of the files process inside of in under 10 minutes, there are some that get ridiculous.
I have one group that had 3 gz files, all were 20-30mb in length (these 3 are all from usenet-news. I have 2 more files for the same group from astraweb, and they are 31mb and 2*KB*, but after the last brutal hour, maybe I'll just skip them and have the group updated directly from the server).
The first one took about 10 minutes to process, the second one took about 2 minutes, and the 3rd one is still processing after an HOUR.
And it doesn't appear to be "hung", since the "Storage.db3" and "StorageData.db3" files are still incrementing. They are currently up to 205,620KB and 181,928KB respectively, and gain about a meg every 2-3 minutes.
The point here is that this may well explain both the "high CPU usage" AND the apparent (but not real) failure to import previous folders.
I have over 50 groups subscribed, and probably 80% of them had well in excess of 100K headers under 6.42, and a couple had over a million.
Can you imagine NB actually trying to convert such a massive database? Why, it could sit there and stare at you like an idiot while it burned up massive CPU cycles while maxing out your pagefile. Moreover, it might just sit there and ignore you if you tried to download anything since it has better things to do...for the next week and a half...
You might say "we are NB, and your computer are belong to us!"
But seriously, I'm wondering if the particular newsgroup I'm currently importing wouldn't have been faster if I had simply deleted the group entirely, recreated it and "download(ed) all headers", even from all 4 of my servers?
I just checked the time difference from this import from the previous import: This import has now been going on for 3 hrs 15mins. This is becoming insufferable.
So that's it then. I'm done, and I'm tired. I only hope that this tome may be of some help to someone.
