Job Queue Never Decreasing

classic Classic list List threaded Threaded
12 messages Options
Reply | Threaded
Open this post in threaded view
|

Job Queue Never Decreasing

APseudoUtopia
I'm running MW 1.15.1. I'm having a problem with the Job Queue. I
noticed that on Special:Statistics, the job queue length is always
1,200. Ever since I started the wiki, it has been the same thing -
1,200 - the entire time. The wiki does have a light load, so I tried
setting $wgJobRunRate to a higher number such as 5, then browsing the
site a bit and monitoring the JobQueue length. Nothing changed.

How can I get more information on this? Such as, what jobs are
actually in the queue? Why aren't they running?

Thanks.

_______________________________________________
MediaWiki-l mailing list
[hidden email]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Reply | Threaded
Open this post in threaded view
|

Re: Job Queue Never Decreasing

Andrew A
http://www.mediawiki.org/wiki/Manual_talk:Job_queue#How_to_empty_job_queue.3F

On Sat, Sep 19, 2009 at 8:49 AM, APseudoUtopia <[hidden email]> wrote:

> I'm running MW 1.15.1. I'm having a problem with the Job Queue. I
> noticed that on Special:Statistics, the job queue length is always
> 1,200. Ever since I started the wiki, it has been the same thing -
> 1,200 - the entire time. The wiki does have a light load, so I tried
> setting $wgJobRunRate to a higher number such as 5, then browsing the
> site a bit and monitoring the JobQueue length. Nothing changed.
>
> How can I get more information on this? Such as, what jobs are
> actually in the queue? Why aren't they running?
>
> Thanks.
>
> _______________________________________________
> MediaWiki-l mailing list
> [hidden email]
> https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
>

_______________________________________________
MediaWiki-l mailing list
[hidden email]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Reply | Threaded
Open this post in threaded view
|

Re: Job Queue Never Decreasing

APseudoUtopia
On Sat, Sep 19, 2009 at 10:37 AM, Andrew A <[hidden email]> wrote:

> http://www.mediawiki.org/wiki/Manual_talk:Job_queue#How_to_empty_job_queue.3F
>
> On Sat, Sep 19, 2009 at 8:49 AM, APseudoUtopia <[hidden email]> wrote:
>> I'm running MW 1.15.1. I'm having a problem with the Job Queue. I
>> noticed that on Special:Statistics, the job queue length is always
>> 1,200. Ever since I started the wiki, it has been the same thing -
>> 1,200 - the entire time. The wiki does have a light load, so I tried
>> setting $wgJobRunRate to a higher number such as 5, then browsing the
>> site a bit and monitoring the JobQueue length. Nothing changed.
>>
>> How can I get more information on this? Such as, what jobs are
>> actually in the queue? Why aren't they running?
>>
>> Thanks.
>>


I tried it:

# php maintenance/runJobs.php
Warning: xcache_get(): xcache.var_size is either 0 or too small to
enable var data caching in /usr/local/www/wiki/includes/BagOStuff.php
on line 639
Warning: xcache_set(): xcache.var_size is either 0 or too small to
enable var data caching in /usr/local/www/wiki/includes/BagOStuff.php
on line 654

I've tried changing xcache.var_size in my php.ini and it does not
affect runJobs.php (It gives that warning every time). I tried
increasing it to 256 MB and still no change.

_______________________________________________
MediaWiki-l mailing list
[hidden email]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Reply | Threaded
Open this post in threaded view
|

Re: Job Queue Never Decreasing

Andrew A
there must be a bunch of jews hiding in your job queue.

i advise you flush it with the vapors of zyklon b.

On Sat, Sep 19, 2009 at 9:52 AM, APseudoUtopia <[hidden email]> wrote:

> On Sat, Sep 19, 2009 at 10:37 AM, Andrew A <[hidden email]> wrote:
>> http://www.mediawiki.org/wiki/Manual_talk:Job_queue#How_to_empty_job_queue.3F
>>
>> On Sat, Sep 19, 2009 at 8:49 AM, APseudoUtopia <[hidden email]> wrote:
>>> I'm running MW 1.15.1. I'm having a problem with the Job Queue. I
>>> noticed that on Special:Statistics, the job queue length is always
>>> 1,200. Ever since I started the wiki, it has been the same thing -
>>> 1,200 - the entire time. The wiki does have a light load, so I tried
>>> setting $wgJobRunRate to a higher number such as 5, then browsing the
>>> site a bit and monitoring the JobQueue length. Nothing changed.
>>>
>>> How can I get more information on this? Such as, what jobs are
>>> actually in the queue? Why aren't they running?
>>>
>>> Thanks.
>>>
>
>
> I tried it:
>
> # php maintenance/runJobs.php
> Warning: xcache_get(): xcache.var_size is either 0 or too small to
> enable var data caching in /usr/local/www/wiki/includes/BagOStuff.php
> on line 639
> Warning: xcache_set(): xcache.var_size is either 0 or too small to
> enable var data caching in /usr/local/www/wiki/includes/BagOStuff.php
> on line 654
>
> I've tried changing xcache.var_size in my php.ini and it does not
> affect runJobs.php (It gives that warning every time). I tried
> increasing it to 256 MB and still no change.
>
> _______________________________________________
> MediaWiki-l mailing list
> [hidden email]
> https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
>

_______________________________________________
MediaWiki-l mailing list
[hidden email]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Reply | Threaded
Open this post in threaded view
|

Re: Job Queue Never Decreasing

APseudoUtopia
On Sat, Sep 19, 2009 at 11:11 AM, Andrew A <[hidden email]> wrote:

> there must be a bunch of jews hiding in your job queue.
>
> i advise you flush it with the vapors of zyklon b.
>
> On Sat, Sep 19, 2009 at 9:52 AM, APseudoUtopia <[hidden email]> wrote:
>> On Sat, Sep 19, 2009 at 10:37 AM, Andrew A <[hidden email]> wrote:
>>> http://www.mediawiki.org/wiki/Manual_talk:Job_queue#How_to_empty_job_queue.3F
>>>
>>> On Sat, Sep 19, 2009 at 8:49 AM, APseudoUtopia <[hidden email]> wrote:
>>>> I'm running MW 1.15.1. I'm having a problem with the Job Queue. I
>>>> noticed that on Special:Statistics, the job queue length is always
>>>> 1,200. Ever since I started the wiki, it has been the same thing -
>>>> 1,200 - the entire time. The wiki does have a light load, so I tried
>>>> setting $wgJobRunRate to a higher number such as 5, then browsing the
>>>> site a bit and monitoring the JobQueue length. Nothing changed.
>>>>
>>>> How can I get more information on this? Such as, what jobs are
>>>> actually in the queue? Why aren't they running?
>>>>
>>>> Thanks.
>>>>
>>
>>
>> I tried it:
>>
>> # php maintenance/runJobs.php
>> Warning: xcache_get(): xcache.var_size is either 0 or too small to
>> enable var data caching in /usr/local/www/wiki/includes/BagOStuff.php
>> on line 639
>> Warning: xcache_set(): xcache.var_size is either 0 or too small to
>> enable var data caching in /usr/local/www/wiki/includes/BagOStuff.php
>> on line 654
>>
>> I've tried changing xcache.var_size in my php.ini and it does not
>> affect runJobs.php (It gives that warning every time). I tried
>> increasing it to 256 MB and still no change.
>>

First of all, stop top-posting. It's bad mailing-list etiquette.

Also, your second reply was both entirely offensive and immature, as
well as completely unhelpful and useless.

I advise that you grow up.

_______________________________________________
MediaWiki-l mailing list
[hidden email]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Reply | Threaded
Open this post in threaded view
|

Re: Job Queue Never Decreasing

Andrew A
White protestant men should always top post. As God's chosen race, it
is our obligation to have our words reign supreme above the lesser
texts of liberals, queers and mud people.

We must secure the existence of our people and a future for white children.

On Sat, Sep 19, 2009 at 10:52 AM, APseudoUtopia <[hidden email]> wrote:

> On Sat, Sep 19, 2009 at 11:11 AM, Andrew A <[hidden email]> wrote:
>> there must be a bunch of jews hiding in your job queue.
>>
>> i advise you flush it with the vapors of zyklon b.
>>
>> On Sat, Sep 19, 2009 at 9:52 AM, APseudoUtopia <[hidden email]> wrote:
>>> On Sat, Sep 19, 2009 at 10:37 AM, Andrew A <[hidden email]> wrote:
>>>> http://www.mediawiki.org/wiki/Manual_talk:Job_queue#How_to_empty_job_queue.3F
>>>>
>>>> On Sat, Sep 19, 2009 at 8:49 AM, APseudoUtopia <[hidden email]> wrote:
>>>>> I'm running MW 1.15.1. I'm having a problem with the Job Queue. I
>>>>> noticed that on Special:Statistics, the job queue length is always
>>>>> 1,200. Ever since I started the wiki, it has been the same thing -
>>>>> 1,200 - the entire time. The wiki does have a light load, so I tried
>>>>> setting $wgJobRunRate to a higher number such as 5, then browsing the
>>>>> site a bit and monitoring the JobQueue length. Nothing changed.
>>>>>
>>>>> How can I get more information on this? Such as, what jobs are
>>>>> actually in the queue? Why aren't they running?
>>>>>
>>>>> Thanks.
>>>>>
>>>
>>>
>>> I tried it:
>>>
>>> # php maintenance/runJobs.php
>>> Warning: xcache_get(): xcache.var_size is either 0 or too small to
>>> enable var data caching in /usr/local/www/wiki/includes/BagOStuff.php
>>> on line 639
>>> Warning: xcache_set(): xcache.var_size is either 0 or too small to
>>> enable var data caching in /usr/local/www/wiki/includes/BagOStuff.php
>>> on line 654
>>>
>>> I've tried changing xcache.var_size in my php.ini and it does not
>>> affect runJobs.php (It gives that warning every time). I tried
>>> increasing it to 256 MB and still no change.
>>>
>
> First of all, stop top-posting. It's bad mailing-list etiquette.
>
> Also, your second reply was both entirely offensive and immature, as
> well as completely unhelpful and useless.
>
> I advise that you grow up.
>
> _______________________________________________
> MediaWiki-l mailing list
> [hidden email]
> https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
>

_______________________________________________
MediaWiki-l mailing list
[hidden email]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Reply | Threaded
Open this post in threaded view
|

Re: Job Queue Never Decreasing

Svip
2009/9/19 Andrew A <[hidden email]>:
> White protestant men should always top post. As God's chosen race, it
> is our obligation to have our words reign supreme above the lesser
> texts of liberals, queers and mud people.
>
> We must secure the existence of our people and a future for white children.

Hitler would not approve of your topposting.  He would have sent you
along with the other topposters to Auschwitz.  In fact, I wish Hitler
was here today, so he could rid the world of people like you.  Along
with the Jews.  Oh, but his ambitions into Russia was too ambitious.

As for some actually serious response to the issue; check if your
database doesn't have some corruption in it or try and turn your cache
up insanely.

_______________________________________________
MediaWiki-l mailing list
[hidden email]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Reply | Threaded
Open this post in threaded view
|

Re: Job Queue Never Decreasing

Chad
(Apologies for top-posting, e-mailing from my phone)
Can we get the idiot put on moderation please?

-Chad

On Sep 19, 2009 1:01 PM, "Svip" <[hidden email]> wrote:

2009/9/19 Andrew A <[hidden email]>:

> White protestant men should always top post. As God's chosen race, it > is
our obligation to have ...
Hitler would not approve of your topposting.  He would have sent you
along with the other topposters to Auschwitz.  In fact, I wish Hitler
was here today, so he could rid the world of people like you.  Along
with the Jews.  Oh, but his ambitions into Russia was too ambitious.

As for some actually serious response to the issue; check if your
database doesn't have some corruption in it or try and turn your cache
up insanely.

_______________________________________________ MediaWiki-l mailing list
[hidden email]...
_______________________________________________
MediaWiki-l mailing list
[hidden email]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Reply | Threaded
Open this post in threaded view
|

Re: Job Queue Never Decreasing

Andrew A
In reply to this post by Svip
On Sat, Sep 19, 2009 at 12:01 PM, Svip <[hidden email]> wrote:
> Hitler would not approve of your topposting.  He would have sent you
> along with the other topposters to Auschwitz.  In fact, I wish Hitler
> was here today, so he could rid the world of people like you.  Along
> with the Jews.  Oh, but his ambitions into Russia was too ambitious.
>
> As for some actually serious response to the issue; check if your
> database doesn't have some corruption in it or try and turn your cache
> up insanely.

Brother,

I had never considered how disorderly and destructive to a nation top
posting is. Now that i have been informed by a comrade about its
insidious Judaic nature, I will never be found top posting again.
Thank you for informing me of the Fuhrer's desire to put top-posting
swine in the ovens.

14/88, WPWW

_______________________________________________
MediaWiki-l mailing list
[hidden email]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Reply | Threaded
Open this post in threaded view
|

Re: Job Queue Never Decreasing

Tim Starling-2
In reply to this post by APseudoUtopia
APseudoUtopia wrote:
> I'm running MW 1.15.1. I'm having a problem with the Job Queue. I
> noticed that on Special:Statistics, the job queue length is always
> 1,200. Ever since I started the wiki, it has been the same thing -
> 1,200 - the entire time. The wiki does have a light load, so I tried
> setting $wgJobRunRate to a higher number such as 5, then browsing the
> site a bit and monitoring the JobQueue length. Nothing changed.
>
> How can I get more information on this? Such as, what jobs are
> actually in the queue? Why aren't they running?

This is most likely due to a known bug in Special:Statistics, which
causes it to give inaccurate numbers for the number of jobs remaining
in the queue. You can get an accurate count by running an SQL query,
say using phpMyAdmin:

SELECT COUNT(*) FROM jobs;

-- Tim Starling


_______________________________________________
MediaWiki-l mailing list
[hidden email]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Reply | Threaded
Open this post in threaded view
|

Re: Job Queue Never Decreasing

Chad
On that note, is there really any better way we could
do this? Right now if I'm remember correctly we check
the results of an EXPLAIN for an estimate. Is select
count(*) just impossibly slow, even if we cached the
result for an hour or whatever?

-Chad

On Sep 20, 2009 10:49 PM, "Tim Starling" <[hidden email]> wrote:

APseudoUtopia wrote: > I'm running MW 1.15.1. I'm having a problem with the
Job Queue. I > noticed t...
This is most likely due to a known bug in Special:Statistics, which
causes it to give inaccurate numbers for the number of jobs remaining
in the queue. You can get an accurate count by running an SQL query,
say using phpMyAdmin:

SELECT COUNT(*) FROM jobs;

-- Tim Starling

_______________________________________________ MediaWiki-l mailing list
[hidden email]...
_______________________________________________
MediaWiki-l mailing list
[hidden email]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Reply | Threaded
Open this post in threaded view
|

Re: Job Queue Never Decreasing

Tim Starling-2
Chad wrote:

> On Sep 20, 2009 10:49 PM, "Tim Starling" <[hidden email]> wrote:
>> APseudoUtopia wrote: > I'm running MW 1.15.1. I'm having a problem with the
>> Job Queue. I > noticed t...
>> This is most likely due to a known bug in Special:Statistics, which
>> causes it to give inaccurate numbers for the number of jobs remaining
>> in the queue. You can get an accurate count by running an SQL query,
>> say using phpMyAdmin:
>>
>> SELECT COUNT(*) FROM jobs;
>
> On that note, is there really any better way we could
> do this? Right now if I'm remember correctly we check
> the results of an EXPLAIN for an estimate. Is select
> count(*) just impossibly slow, even if we cached the
> result for an hour or whatever?

It's only slow if there are a large number of jobs. We could just do
the EXPLAIN, and if it's less than say 10000, then we could follow it
up with a COUNT(*) to get a more accurate result.

-- Tim Starling


_______________________________________________
MediaWiki-l mailing list
[hidden email]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l