Re: [SMW-devel] MediaWiki Job queue problem

[James HK <jam...@gm...>]

Hi,

The likelihood that it is related to SMW 1.8.0.5 is rather slim and
looking at [0] did not reveal related issues.

> entries in the row "job_token" which results in the jobs not being done by the script.

According to [1], "job_token" is a "field that conveys process locks
on rows via process UUIDs"  but it doesn't help much either.

[0] https://bugzilla.wikimedia.org/buglist.cgi?quicksearch=runjobs
[1] https://www.mediawiki.org/wiki/Manual:Job_table

Cheers

On 9/24/14, Krabina Bernhard <kr...@kd...> wrote:
> Hi James,
>
> thank you, I am aware of [0], but as far as I understand it, it only tackles
> with the issue of automatically running jobs on page requests. "jobs will no
> longer run on page requests, and you must explicitly run runJobs.php to
> periodically run pending jobs."
>
> There is no hint that there is a problem with runJobs.php - and this is what
> we're having problems with, it just won't do anything.
>
> regards,
> Bernhard
>
>
> ----- Ursprüngliche Mail -----
>> Hi,
>>
>> As you are running MW 1.22.* [0], you may have an interest in reading
>> [0].
>>
>> [0] https://www.wien.gv.at/wiki/index.php/Spezial:Version
>>
>> [1]
>> https://www.mediawiki.org/wiki/Manual:Job_queue#Changes_introduced_in_MediaWiki_1.22
>>
>> Cheers
>>
>> On 9/24/14, Krabina Bernhard <kr...@kd...> wrote:
>> > Dear SMW users,
>> >
>> > this might not be a directly SMW related question, but maybe some of
>> > you
>> > have experience with the job queue and job table?
>> >
>> > In the Vienna History wiki, jobs do not get done when running
>> > runJobs.php.
>> > The Job table shows that the jobs currently in the queue are locked:
>> > there
>> > are entries in the row "job_token" which results in the jobs not being
>> > done
>> > by the script.
>> >
>> > How can I know why and what locked these jobs, how to unlock them or
>> > what
>> > else to do?
>> >
>> > There have been 12400 jobs sitting around for a week:
>> > https://www.wien.gv.at/wiki/api.php?action=query&meta=siteinfo&siprop=statistics&format=jsonfm
>> > Suddenly, without anybody knowing why, ~ 5000 have been done, but >
>> > 7000
>> > are
>> > still sitting there
>> >
>> > showJobs.php always shows "0" and runJobs.php executes without error
>> > and
>> > without doing anything.
>> >
>> > regards,
>> > Bernhard
>> >
>> > ------------------------------------------------------------------------------
>> > Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
>> > Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS
>> > Reports
>> > Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
>> > Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
>> > http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk
>> > _______________________________________________
>> > Semediawiki-devel mailing list
>> > Sem...@li...
>> > https://lists.sourceforge.net/lists/listinfo/semediawiki-devel
>> >
>>
>