why queued for download

Technical support and discussion of Newsbin Version 6 series.

why queued for download

Postby fred95901 » Sun Aug 01, 2021 1:34 pm

When I upgraded to 6.90b12 I started getting this status. Before it downloaded on double click.

Help Thanks
fred95901
n00b
n00b
 
Posts: 9
Joined: Wed Jun 16, 2021 7:27 am

Registered Newsbin User since: 01/11/12

Re: why queued for download

Postby Quade » Sun Aug 01, 2021 3:26 pm

I'm not sure what you mean.
User avatar
Quade
Eternal n00b
Eternal n00b
 
Posts: 44867
Joined: Sat May 19, 2001 12:41 am
Location: Virginia, US

Registered Newsbin User since: 10/24/97

Re: why queued for download

Postby stavros » Mon Aug 02, 2021 1:16 am

Hi Quade,

I'm getting this too....

I just upgraded my install to RC1 on my main machine - installed fine, started fine - although it truncated my files list from 11,000 plus to 2486 files :-(
I loaded a group of headers - from before the upgrade - and I have yet to try downloading new headers.
I double click on a post and I get a white tick icon and a 'queued for download' in the status column - then nothing.
Nothing appears in the downloading files tab, nothing appears in the Files list and no messages about this appears in the debug list - just the usual spam.
I've left it for 10 mins - still nothing.

I loaded another group and repeated - this worked - d/l fine. on checking the log, the first attempt at d/l did not get as far as connecting to the server.

I had a look at the spool for some of these - a very small sample - but ones that failed had both a Storage.db3 and a StorageData.db3, while ones that worked only had a Storage.db3 - could be a red herring.
Another thing in common - when I try to expand a compacted set of headers by clicking on the + icon - nothing happens in the groups that get the 'queued for download' status.
Any pointers welcome, also if you would like some more info or testing, glad to try (non-destructive) things out.
I'm planning on doing a sqlite3 pragma integrity_check across my spool - but that will take some time (2.5 TB of spool).

I'm going to revert back to 6.82 for now.

regards
Stavros
Last edited by stavros on Mon Aug 02, 2021 1:19 am, edited 1 time in total.
stavros
Seasoned User
Seasoned User
 
Posts: 118
Joined: Wed Dec 24, 2003 2:07 am

Registered Newsbin User since: 12/24/03

Re: why queued for download

Postby Quade » Mon Aug 02, 2021 1:19 am

although it truncated my files list from 11,000 plus to 2486 files


Files list maxes out at 5000 entries. If it got to more than that, that's a bug.

The comment about the two DB's is likely the clue I need. I'll have to look at it, thanks. I don't believe it upgraded to single file automatically.
User avatar
Quade
Eternal n00b
Eternal n00b
 
Posts: 44867
Joined: Sat May 19, 2001 12:41 am
Location: Virginia, US

Registered Newsbin User since: 10/24/97

Re: why queued for download

Postby stavros » Fri Aug 13, 2021 11:01 am

Quade wrote:The comment about the two DB's is likely the clue I need. I'll have to look at it, thanks. I don't believe it upgraded to single file automatically.


Hi Quade,

is there anything I can do to trigger the upgrade to a single storage db file?

I'd like to make sure that I don't loose any data from my spool files.

How much free space is needed for the merge/update to a single file? and what happens if the process runs out of space?
Some of my spool files are quite large, > 250GB.

I've also noticed that some of them are zero length - that's something new - I've not seen that before - any thoughts?

regards
Stavros
stavros
Seasoned User
Seasoned User
 
Posts: 118
Joined: Wed Dec 24, 2003 2:07 am

Registered Newsbin User since: 12/24/03

Re: why queued for download

Postby Quade » Sat Aug 14, 2021 8:49 am

I was actually working just now on supporting the old format. So without my change there's nothing you can do.

You could use sqlite3.exe to do it but you'd have to know how. You'd have to load "Storage.db3" then attach "StorageData.db3" then to copy using an insert "FileData_V4 from 'StorageData to "Storage".

The fix I'm putting in is that it'll first check storage then it'll check storage data when it comes to resolve downloads.
User avatar
Quade
Eternal n00b
Eternal n00b
 
Posts: 44867
Joined: Sat May 19, 2001 12:41 am
Location: Virginia, US

Registered Newsbin User since: 10/24/97

Re: why queued for download

Postby stavros » Sat Aug 14, 2021 8:42 pm

Thanks Quade - I'll give sqlite3 a go and see what happens :-)
I'll try it out on some of the smaller ones, then if that goes ok, I'll automate it and run through the rest.
stavros
Seasoned User
Seasoned User
 
Posts: 118
Joined: Wed Dec 24, 2003 2:07 am

Registered Newsbin User since: 12/24/03

Re: why queued for download

Postby Quade » Sun Aug 15, 2021 10:39 am

As long as you copy a group out of the data folder, leaving the old data then work on the copy, you can't really go wrong.
User avatar
Quade
Eternal n00b
Eternal n00b
 
Posts: 44867
Joined: Sat May 19, 2001 12:41 am
Location: Virginia, US

Registered Newsbin User since: 10/24/97


Return to V6 Technical Support

Who is online

Users browsing this forum: No registered users and 2 guests

cron