Page 1 of 2

Duplicate issues in Mylar Page

Posted: Thu Jul 25, 2019 4:57 pm
by leaderdog
Ok, Mylar hasn't been moving files manually or moving only the odd one, (resorted to that because it's just not finding, or looking for files). But now the manual process isn't working either. I've seen some issues just aren't updated, perhaps the guy that does it for comicvine is on vacation at the moment.

However, I have issue 05 of Dark Red from Aftershock. But when I went to the page (no it's not updated on comicvine). but it shows issue 4 three times.

Link to the image:
https://www.dropbox.com/s/guelgnwq9j0p7 ... e.jpg?dl=0

And Mylar is crazy slow. I've killed the instance a few times.

Mylar Version: development
-- git build 6a1f96167cf9cad6bf2e0ef7881b398e75b98169.
Python Version : 2.7.14

I've been tempted to just reinstall everything for Mylar, but I don't want to have to mess with the database, 3705 titles, I don't want to have to reinitialize any of that. ;)

Here's the log.
https://www.dropbox.com/s/qfkcsia07tlfw ... 9.rar?dl=0

Re: Duplicate issues in Mylar Page

Posted: Thu Jul 25, 2019 5:06 pm
by barbequesauce
That is not good.

I think the best approach will be to shut mylar down, bring it back up in maintenance mode, export the database, shut it back down again, move the file out of the way, then restart in maintenance again and import the previous export. Instructions can be found here.

Re: Duplicate issues in Mylar Page

Posted: Fri Jul 26, 2019 4:17 am
by leaderdog
Thanks for the reply BBQsauce.

I'm a touch confused tho.

You think that just running maintenance and then saving the database, and reinstalling the database should clean the issues up?

Or should I save the database (and cache?)
delete Mylar totally,
reinstall it and then move the database and cache back in, I'll have to redo the settings, but that's not that big a deal.

Hitting refresh on Dark Red got rid of the duplicates. I had noticed a couple other issues had done the same thing too.

I did just update both Mylar and Python:
Mylar Version: development
-- git build 15aadaaa23ba8c48aa34b5e3bc9d7a9287d00ce5.
Python Version : 2.7.16

Is Mylar struggling with such a large database? or that shouldn't be an issue regardless?

Re: Duplicate issues in Mylar Page

Posted: Fri Jul 26, 2019 10:15 am
by barbequesauce
How big is your database, that you’re concerned?

Re: Duplicate issues in Mylar Page

Posted: Fri Jul 26, 2019 12:56 pm
by leaderdog
The Database is 605 Megs. 3705 titles.
The cache is 1.64 GB

Re: Duplicate issues in Mylar Page

Posted: Fri Jul 26, 2019 8:41 pm
by barbequesauce
Yeah, there's a problem in there somewhere. A couple of us have 3500-4000 titles being watched and our databases are less than 50MB...

Re: Duplicate issues in Mylar Page

Posted: Sat Jul 27, 2019 3:55 am
by leaderdog
Oh Wow, ya something has gone really wrong some where.

Should I still follow the instructions Evilhero posted in the link you provided? Or is my database to screwed up to use for that?

Re: Duplicate issues in Mylar Page

Posted: Sat Jul 27, 2019 9:24 am
by barbequesauce
I’d say give it a try... what do you have to lose, other than a few hours of effort?

Re: Duplicate issues in Mylar Page

Posted: Sat Jul 27, 2019 6:13 pm
by leaderdog
Ok, so I'm giving it a whirl.

1) Shutdown Mylar
2) I copied my whole Mylar folder just for backup reasons.
3) opened command Prompt
4) I ran

Code: Select all

python Mylar.py maintenance -xj list.json
5) I moved mylar.db out of the folder to desktop
6) I then ran in the command prompt

Code: Select all

python Mylar.py maintenance -ij list.json
7) it's doing something. Retrieving info for each Title.

Just recapping for anyone else with this problem. I'll edit/post again in thread when it's done to see if anything has improved.

Re: Duplicate issues in Mylar Page

Posted: Sat Jul 27, 2019 8:00 pm
by leaderdog
Ok, so it seemed to go well until it didn't.

Here's a jpeg of the log. https://www.dropbox.com/s/xvo18k8c33dzd ... r.jpg?dl=0

Traceback error. does that just mean I exceeded the API limit on Comicvine?
and it keeps saying something about adding a certificate verification. which I don't understand.

So yeah, it didn't make it through, do I just start it up again? or does that just go from the beginning again?

Edit:

Ok, so ran it again, and it halted at the same place. I removed

Code: Select all

Quantum and Woody v3 - 0.0001½
which seems to be the offending issue.

So running again. I'm sure there are other 1/2 characters in other titles too. Which means this isn't likely to ever finish its maintenance?