Page 1 of 1

why queued for download

PostPosted: Sun Aug 01, 2021 1:34 pm
by fred95901
When I upgraded to 6.90b12 I started getting this status. Before it downloaded on double click.

Help Thanks

Re: why queued for download

PostPosted: Sun Aug 01, 2021 3:26 pm
by Quade
I'm not sure what you mean.

Re: why queued for download

PostPosted: Mon Aug 02, 2021 1:16 am
by stavros
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

Re: why queued for download

PostPosted: Mon Aug 02, 2021 1:19 am
by Quade
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.

Re: why queued for download

PostPosted: Fri Aug 13, 2021 11:01 am
by stavros
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

Re: why queued for download

PostPosted: Sat Aug 14, 2021 8:49 am
by Quade
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.

Re: why queued for download

PostPosted: Sat Aug 14, 2021 8:42 pm
by stavros
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.

Re: why queued for download

PostPosted: Sun Aug 15, 2021 10:39 am
by Quade
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.