Page 1 of 1

Problem with Scheduler

Posted: 14 Apr 2016, 13:26
by goerch
hello, its me again.
i have some trouble with the scheduler. The cronjob starts all e-mail - relevant actions for shop. But no mail will send. The status is green, "currently running". When i start it manuell, the order confirmation mail will be send. According to the topic from crazyforster 31.3.2016 could it be the same problem?
System: Typo3 6.2.9, Aimeos 16.4.1 updated yesterday from 16.2.0 b34 . By the way, this is the first time i try to work with scheduler and aimeos, and yes, a parallel scheduler test task is working well. (sending every 5 minutes an e-mail notification).
Maybe you can help me?
Jörg

Re: Problem with Scheduler

Posted: 14 Apr 2016, 13:33
by aimeos
Can you post a screenshot of your Aimeos e-mail scheduler task settings?
Are any related error messages in the logs (either look at admin interface -> Overview -> second panel or directly into the madmin_log table)?

Re: Problem with Scheduler

Posted: 14 Apr 2016, 14:34
by goerch
Here is the screenshot. I looked madmin_log, nothing to see, in sys_log ifound the following entry: "[scheduler]: Start execution. Class: Aimeos\Aimeos\Scheduler\Task\Email6, UID: 4". The timestamp is today. It seems, that in the syslog there is no "[scheduler] Task executed". The cronjob started every 5 minutes, but the task frequency is set 60 seconds. Could this be the problem? Testing this configuration with test-task it was no problem, task status go to "Late, will run with next execution". And then after 5 minutes or so, it was executed. But the aimeos task gives me nothing, only the notice, that the task is running. See screeshot 2.

Thanks a lot. Jörg

Re: Problem with Scheduler

Posted: 14 Apr 2016, 15:20
by aimeos
goerch wrote:The cronjob started every 5 minutes, but the task frequency is set 60 seconds. Could this be the problem?
No, not at all. This is quite normal in most setups. The only thing you shouldn't do is to allow the Aimeos tasks to run in parallel! (checkbox in the second screenshot)
goerch wrote:But the aimeos task gives me nothing, only the notice, that the task is running.
The task is in an error state. What's displayed if you move the mouse over the red light image left of the task ID in the list of scheduler tasks? Does it work if you execute the Aimeos e-mail task by hand?

Re: Problem with Scheduler

Posted: 14 Apr 2016, 17:19
by goerch
OK, the red button on the left side of the task-id seems to be a stop -button. On mouseover it gives me "stop". The right green dot gives me "currently running". When i click on the red button i will asked "Are you sure you want to mark this task as not running? Note that this will not stop the actual script (if unsure please refer to the manual)." Confirming ok it gives me the 404-error-page of the frontend. The called url is "http://www.XXX.com/typo3/mod.php?M=syst ... ecute][]=4". Crazy ...

Jörg

Re: Problem with Scheduler

Posted: 14 Apr 2016, 19:53
by aimeos
Extremely strange! Is there any error message in the Apache error log?

Re: Problem with Scheduler

Posted: 15 Apr 2016, 09:13
by goerch
So, the next information:

Its a nginx Server, in the log-files there is only an error about a preview image which can't be found.
Then i check the detail-shop page, disable the login for this page and have a look in plugin catalog-detail plugin. There was a missing information about "catalog-page with session-plugin". i added this info.
The i start the scheduler per hand and voila, there is an error message: "Execution of task "Planer für Aimeos Shop E-Mails (aimeos)" failed with the following message: Executing statement "UPDATE madmin_queue SET cname = '320286284709b51408840fa49c1079a4', rtime = '2016-04-15 10:59:58' WHERE queue = 'customer/email/account' AND rtime < '2016-04-15 10:59:58' LIMIT 1" failed: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'xxx.madmin_queue' doesn't exist". And in fact, there is no madmin_queue in database. Could it be, that version 16.4.1 have a madmin_queue, and 16.2.0 b34 has not? Then, i think have to start the update script per hand?

Jörg

Jörg

Re: Problem with Scheduler

Posted: 15 Apr 2016, 10:08
by aimeos
goerch wrote:Could it be, that version 16.4.1 have a madmin_queue, and 16.2.0 b34 has not? Then, i think have to start the update script per hand?
I guess, you've uploaded the new Aimeos version by hand instead of downloading it in the extension manager from the TER. In this case, TYPO3 doesn't execute the update script automatically and yes, you now have to do it by hand.

Re: Problem with Scheduler

Posted: 15 Apr 2016, 10:19
by goerch
So adding the madmin_queue solved the scheduler problem, but i think i have a misconfiguration.
The detail-page (the uid of this page is set in scheduler-task) with login restriction (set in page setting for the whole page) stops the scheduler doing his job. You can see it in the screenshot i sent yesterday. Disabling the login restriction in detail-page and the scheduler works well. What i want: every user have to login, before he can go to catalog and so on. So there is a page restriction for every page set in page settings. I think now, this is the wrong way, but what is the right way ...

Jörg

Re: Problem with Scheduler

Posted: 16 Apr 2016, 11:52
by aimeos
goerch wrote:What i want: every user have to login, before he can go to catalog and so on. So there is a page restriction for every page set in page settings.
Interesting question :-)
The guys from the Aimeos company should be able to help you with that specific problem:
https://aimeos.com/usd/aimeos-gmbh/contact/