[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[EP-tech] IR-Stats not processing

Spoke too soon!
For some reason I'm getting double entries in irstats2_cache_downloads - e.g. for item 43210 I've got two entries of
uid          eprintid                datestamp          value     count
12840    43210                    0                              type       143
54345    43210                    0                              type       143

If I total up the columns on the graph I get 143, but the activity overview shows 286...  It does this for other items I've checked too.
Any thoughts as to why, or how to easily fix it? E.g. can I just delete all the duplicates from irstat2_cache_downloads?


From: eprints-tech-bounces at ecs.soton.ac.uk [mailto:eprints-tech-bounces at ecs.soton.ac.uk] On Behalf Of Alan.Stiles
Sent: 14 June 2017 12:04
To: eprints-tech at ecs.soton.ac.uk
Subject: Re: [EP-tech] IR-Stats not processing

This sender failed our fraud detection checks and may not be who they appear to be. Learn about spoofing<http://aka.ms/LearnAboutSpoofing>


Thanks Enio and John,
Turns out it was a combination of the lock row being present due to a previously broken process, and the current_accessid missing which had caused some double counting of stats, hence the rebuild.  Glad not to have to do that again any time soon! (and to have learned something new about IRStats2)


From: eprints-tech-bounces at ecs.soton.ac.uk<mailto:eprints-tech-bounces at ecs.soton.ac.uk> [mailto:eprints-tech-bounces at ecs.soton.ac.uk] On Behalf Of Enio Carboni
Sent: 09 June 2017 10:05
To: eprints-tech at ecs.soton.ac.uk<mailto:eprints-tech at ecs.soton.ac.uk>
Subject: Re: [EP-tech] IR-Stats not processing

Hi Alan,
 first, you should be careful not to have another active irstats2 process then connect to the mysql database to see if the lock exists:
  select value from irstats2_internal where objectid='access.lock';

If lock exists you may try to delete the row:
  delete from irstats2_internal where objectid='access.lock';

Il 09/06/2017 10:26, Alan.Stiles ha scritto:
Hi all,
I'm trying to update the stats on our new servers but every time I run the job I get the message

Dataset 'access' is currently locked by another process.

Any clues what might be locking it - I'm rather confused now.


-- The Open University is incorporated by Royal Charter (RC 000391), an exempt charity in England & Wales and a charity registered in Scotland (SC 038302). The Open University is authorised and regulated by the Financial Conduct Authority.

*** Options: http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech

*** Archive: http://www.eprints.org/tech.php/

*** EPrints community wiki: http://wiki.eprints.org/

*** EPrints developers Forum: http://forum.eprints.org/

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.ecs.soton.ac.uk/pipermail/eprints-tech/attachments/20170621/5292d73c/attachment.html