Magento2 2.1.5 Cronjob doesn't get executed. ID always 0How do I set up cron job in Magento for Google...
How to say "Brexit" in Latin?
Can making a creature unable to attack after it has been assigned as an attacker remove it from combat?
How to prevent users from executing commands through browser URL
Word or phrase for showing great skill at something WITHOUT formal training in it
Why zero tolerance on nudity in space?
Writing a character who is going through a civilizing process without overdoing it?
Digits in an algebraic irrational number
Are there any modern advantages of a fire piston?
Find some digits of factorial 17
How do Chazal know that the descendants of a Mamzer may never marry into the general populace?
How long is the D&D Starter Set campaign?
Dilemma of explaining to interviewer that he is the reason for declining second interview
Difference between `vector<int> v;` and `vector<int> v = vector<int>();`
Does SQL Server 2017, including older versions, support 8k disk sector sizes?
CREATE ASSEMBLY System.DirectoryServices.AccountManagement.dll without enabling TRUSTWORTHY
What are "industrial chops"?
Publishing research using outdated methods
Is it a fallacy if someone claims they need an explanation for every word of your argument to the point where they don't understand common terms?
Am I a Rude Number?
Can a hotel cancel a confirmed reservation?
Table formatting top left corner caption
How much mayhem could I cause as a sentient fish?
Strange Sign on Lab Door
A starship is travelling at 0.9c and collides with a small rock. Will it leave a clean hole through, or will more happen?
Magento2 2.1.5 Cronjob doesn't get executed. ID always 0
How do I set up cron job in Magento for Google product feed?How do I register a modules' cronjobMagento 1.9.2.1 Cron Not WorkingWhat is the correct way to properly register & run automated cronjobs in Magento 2?Does Magento cron maintain tasks order?AOE Scheduler - No heartbeat task found. Check if cron is configured correctlyWhich concrete job does reset catalogrule rules every day?Uninstalled module still populating in cron_schedule tableMagento 2: Cron logs not generatedMagento 2: CronJob bug? MySQL is always running at 30% usage and many php processes are running
My magento cronjob stopped working. It gets executed from system. Checked that in the logs. But magento just shedules the cronjobs and don't execute them. Also the schedule_id of the cronjobs is always 0. Manually run the cron task gives me an execption. See images from cli and database.
What could cause this issue ? And how to fix?
PHP 7 on ubuntu
Magento 2.1.5
magento2 cron magento2.1.5
add a comment |
My magento cronjob stopped working. It gets executed from system. Checked that in the logs. But magento just shedules the cronjobs and don't execute them. Also the schedule_id of the cronjobs is always 0. Manually run the cron task gives me an execption. See images from cli and database.
What could cause this issue ? And how to fix?
PHP 7 on ubuntu
Magento 2.1.5
magento2 cron magento2.1.5
add a comment |
My magento cronjob stopped working. It gets executed from system. Checked that in the logs. But magento just shedules the cronjobs and don't execute them. Also the schedule_id of the cronjobs is always 0. Manually run the cron task gives me an execption. See images from cli and database.
What could cause this issue ? And how to fix?
PHP 7 on ubuntu
Magento 2.1.5
magento2 cron magento2.1.5
My magento cronjob stopped working. It gets executed from system. Checked that in the logs. But magento just shedules the cronjobs and don't execute them. Also the schedule_id of the cronjobs is always 0. Manually run the cron task gives me an execption. See images from cli and database.
What could cause this issue ? And how to fix?
PHP 7 on ubuntu
Magento 2.1.5
magento2 cron magento2.1.5
magento2 cron magento2.1.5
asked Aug 9 '17 at 11:44
ChrisChris
62
62
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
As far as I can see this is an open issue for Magento2.x in github.
https://github.com/magento/magento2/issues/5836
There are some solutions that some people suggest in the above link such as truncating the cron_schedule
table - but I can't be certain as to whether this will work.
add a comment |
your cron_schedule
table has missing index key.
you need to run
ALTER TABLE `cron_schedule`
ADD PRIMARY KEY (`schedule_id`),
ADD KEY `CRON_SCHEDULE_JOB_CODE` (`job_code`),
ADD KEY `CRON_SCHEDULE_SCHEDULED_AT_STATUS` (`scheduled_at`,`status`);
ALTER TABLE `cron_schedule`
MODIFY `schedule_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Schedule Id';
https://github.com/magento/magento2/issues/21523
New contributor
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "479"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f188500%2fmagento2-2-1-5-cronjob-doesnt-get-executed-id-always-0%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
As far as I can see this is an open issue for Magento2.x in github.
https://github.com/magento/magento2/issues/5836
There are some solutions that some people suggest in the above link such as truncating the cron_schedule
table - but I can't be certain as to whether this will work.
add a comment |
As far as I can see this is an open issue for Magento2.x in github.
https://github.com/magento/magento2/issues/5836
There are some solutions that some people suggest in the above link such as truncating the cron_schedule
table - but I can't be certain as to whether this will work.
add a comment |
As far as I can see this is an open issue for Magento2.x in github.
https://github.com/magento/magento2/issues/5836
There are some solutions that some people suggest in the above link such as truncating the cron_schedule
table - but I can't be certain as to whether this will work.
As far as I can see this is an open issue for Magento2.x in github.
https://github.com/magento/magento2/issues/5836
There are some solutions that some people suggest in the above link such as truncating the cron_schedule
table - but I can't be certain as to whether this will work.
answered Sep 21 '17 at 12:55
ol'bob doleol'bob dole
316217
316217
add a comment |
add a comment |
your cron_schedule
table has missing index key.
you need to run
ALTER TABLE `cron_schedule`
ADD PRIMARY KEY (`schedule_id`),
ADD KEY `CRON_SCHEDULE_JOB_CODE` (`job_code`),
ADD KEY `CRON_SCHEDULE_SCHEDULED_AT_STATUS` (`scheduled_at`,`status`);
ALTER TABLE `cron_schedule`
MODIFY `schedule_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Schedule Id';
https://github.com/magento/magento2/issues/21523
New contributor
add a comment |
your cron_schedule
table has missing index key.
you need to run
ALTER TABLE `cron_schedule`
ADD PRIMARY KEY (`schedule_id`),
ADD KEY `CRON_SCHEDULE_JOB_CODE` (`job_code`),
ADD KEY `CRON_SCHEDULE_SCHEDULED_AT_STATUS` (`scheduled_at`,`status`);
ALTER TABLE `cron_schedule`
MODIFY `schedule_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Schedule Id';
https://github.com/magento/magento2/issues/21523
New contributor
add a comment |
your cron_schedule
table has missing index key.
you need to run
ALTER TABLE `cron_schedule`
ADD PRIMARY KEY (`schedule_id`),
ADD KEY `CRON_SCHEDULE_JOB_CODE` (`job_code`),
ADD KEY `CRON_SCHEDULE_SCHEDULED_AT_STATUS` (`scheduled_at`,`status`);
ALTER TABLE `cron_schedule`
MODIFY `schedule_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Schedule Id';
https://github.com/magento/magento2/issues/21523
New contributor
your cron_schedule
table has missing index key.
you need to run
ALTER TABLE `cron_schedule`
ADD PRIMARY KEY (`schedule_id`),
ADD KEY `CRON_SCHEDULE_JOB_CODE` (`job_code`),
ADD KEY `CRON_SCHEDULE_SCHEDULED_AT_STATUS` (`scheduled_at`,`status`);
ALTER TABLE `cron_schedule`
MODIFY `schedule_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Schedule Id';
https://github.com/magento/magento2/issues/21523
New contributor
New contributor
answered 20 mins ago
Rendy HarimaycoRendy Harimayco
1
1
New contributor
New contributor
add a comment |
add a comment |
Thanks for contributing an answer to Magento Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f188500%2fmagento2-2-1-5-cronjob-doesnt-get-executed-id-always-0%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown