Hi,
On 13 Oct 2015, at 13:12 , Henne Vogelsang
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 --------------------------------------------------------------------------------