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













1















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



enter image description here



enter image description here










share|improve this question



























    1















    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



    enter image description here



    enter image description here










    share|improve this question

























      1












      1








      1








      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



      enter image description here



      enter image description here










      share|improve this question














      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



      enter image description here



      enter image description here







      magento2 cron magento2.1.5






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Aug 9 '17 at 11:44









      ChrisChris

      62




      62






















          2 Answers
          2






          active

          oldest

          votes


















          0














          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.






          share|improve this answer































            0














            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






            share|improve this answer








            New contributor




            Rendy Harimayco is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
            Check out our Code of Conduct.




















              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
              });


              }
              });














              draft saved

              draft discarded


















              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









              0














              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.






              share|improve this answer




























                0














                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.






                share|improve this answer


























                  0












                  0








                  0







                  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.






                  share|improve this answer













                  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.







                  share|improve this answer












                  share|improve this answer



                  share|improve this answer










                  answered Sep 21 '17 at 12:55









                  ol'bob doleol'bob dole

                  316217




                  316217

























                      0














                      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






                      share|improve this answer








                      New contributor




                      Rendy Harimayco is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
                      Check out our Code of Conduct.

























                        0














                        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






                        share|improve this answer








                        New contributor




                        Rendy Harimayco is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
                        Check out our Code of Conduct.























                          0












                          0








                          0







                          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






                          share|improve this answer








                          New contributor




                          Rendy Harimayco is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
                          Check out our Code of Conduct.










                          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







                          share|improve this answer








                          New contributor




                          Rendy Harimayco is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
                          Check out our Code of Conduct.









                          share|improve this answer



                          share|improve this answer






                          New contributor




                          Rendy Harimayco is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
                          Check out our Code of Conduct.









                          answered 20 mins ago









                          Rendy HarimaycoRendy Harimayco

                          1




                          1




                          New contributor




                          Rendy Harimayco is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
                          Check out our Code of Conduct.





                          New contributor





                          Rendy Harimayco is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
                          Check out our Code of Conduct.






                          Rendy Harimayco is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
                          Check out our Code of Conduct.






























                              draft saved

                              draft discarded




















































                              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.




                              draft saved


                              draft discarded














                              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





















































                              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







                              Popular posts from this blog

                              “%fieldName is a required field.”, in Magento2 REST API Call for GET Method Type The Next...

                              How to change City field to a dropdown in Checkout step Magento 2Magento 2 : How to change UI field(s)...

                              變成蝙蝠會怎樣? 參考資料 外部連結 导航菜单Thomas Nagel, "What is it like to be a...