Mailinglist Archive: opensuse-buildservice (96 mails)

< Previous Next >
Re: [opensuse-buildservice] mysqld consuming 100% CPU since updating to 2.6.5
Hi,

On 13 Oct 2015, at 13:12 , Henne Vogelsang <hvogel@xxxxxxxxxxxx> wrote:

Chöger!

On 13.10.2015 08:50, Carsten Höger wrote:

since I updated to 2.6.5, mysql is running amok.

/srv/www/obs/api/log/delayed_job.log

containing many entries and some like this:

E, [2015-10-13T08:32:45.780268 #5420] ERROR -- : 2015-10-13T08:32:45+0200:
[Worker(delayed_job.2 host:buildservice pid:5420)]

How old are your delayed_job processes?

$ ps aux|grep delayed_job

from this morning when I restarted it in hope to “fix” that:

wwwrun 5408 0.7 0.9 567708 297888 ? Sl 08:03 2:33 delayed_job.0
wwwrun 5414 0.2 0.4 411540 146536 ? Sl 08:03 0:39 delayed_job.1
wwwrun 5420 0.2 0.4 411696 147624 ? Sl 08:03 0:46 delayed_job.2
wwwrun 5434 0.0 0.3 256840 128824 ? Sl 08:03 0:05
delayed_job.1000
wwwrun 5465 0.0 0.3 393040 130744 ? Sl 08:04 0:06
delayed_job.1010
wwwrun 5484 0.3 0.4 412088 147344 ? Sl 08:04 1:04
delayed_job.1020

it appears to be working on a long queue of things:

buildservice:~> sudo mysql -pXXXXX api_production -e 'SELECT COUNT(*) FROM
delayed_jobs'
+----------+
| COUNT(*) |
+----------+
| 455697 |
+----------+

buildservice:~> sudo mysql -pXXXXX api_production -e 'SELECT COUNT(*) FROM
delayed_jobs’
+----------+
| COUNT(*) |
+----------+
| 455692 |
+----------+

so I hope that this will be over somewhen...

--
mit freundlichen Gruessen/with best regards,

Carsten Hoeger
Open-Xchange GmbH

--------------------------------------------------------------------------------
Open-Xchange AG, Rollnerstr. 14, 90408 Nürnberg, Amtsgericht Nürnberg HRB 24738
Vorstand: Rafael Laguna de la Vera, Carsten Dirks
Aufsichtsratsvorsitzender: Richard Seibt

European Office: Open-Xchange GmbH, Martinstr. 41, D-57462 Olpe, Germany
Amtsgericht Siegen, HRB 8718, Geschäftsführer: Frank Hoberg, Martin Kauss

US Office: Open-Xchange. Inc., 530 Lytton Avenue, Palo Alto, CA 94301, USA
--------------------------------------------------------------------------------

< Previous Next >
Follow Ups