Answers.Body: <p>If you're getting an installation canary error, that means you tried upgrading once and it failed - and then when you upgraded a second time, you got the installation canary error.  The original error is the "true" error.  You can probably ffind it in your <a href="https://civicrm.stackexchange.com/questions/15931/where-are-the-configandlog-and-templates-c-directories">ConfigAndLog logs</a>.  However, you should restore your pre-upgrade backup before attempting another upgrade.  Fixing a broken upgrade is a very advanced topic.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-10-10T23:15:07.987Z
Answers.LastActivityDate: 2019-10-10T23:15:07.987Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Body: <p>I am upgrading 4.2.9 to 4.7.23. But while database upgrade i got error as "Found installation canary. This suggests that something went wrong with tracking installation process. Please post to forum or JIRA". As I researched, I deleted the table "civicrm_install_canary" but again the table creating dynamically. I didn't get any solution.  Please help me.</p>
  
  <p>Thanks in advance. </p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-10-11T09:13:43.823Z
Comments.Text: are you upgrading civicrm directly to 4.7.23 ? if yes, 4.2.9 is quite old version, should upgrade it into multiple steps, and take backup at completion of each step.
  4.2.9 -> 4.2.recent,
  4.2.recent -> 4.4.recent,
  4.4.recent -> 4.6.recent,
  4.6.recent -> 4.7.23.
Comments.UserDisplayName: Sunil Pawar
Tags: <civicrm.settings.php>
Title: Civicrm upgrade from 4.2.9 to 4.7.23
ThreadText: # Civicrm upgrade from 4.2.9 to 4.7.23
  
  (Asked by: username_0 on 2019-10-10)
  
  I am upgrading 4.2.9 to 4.7.23. But while database upgrade i got error as "Found installation canary. This suggests that something went wrong with tracking installation process. Please post to forum or JIRA". As I researched, I deleted the table "civicrm\_install\_canary" but again the table creating dynamically. I didn't get any solution. Please help me.
  
  Thanks in advance.
  
  **Tags:** civicrm.settings.php
  
  > **Comments:**
  > **username_1**: are you upgrading civicrm directly to 4.7.23 ? if yes, 4.2.9 is quite old version, should upgrade it into multiple steps, and take backup at completion of each step. 4.2.9 -> 4.2.recent, 4.2.recent -> 4.4.recent, 4.4.recent -> 4.6.recent, 4.6.recent -> 4.7.23.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2019-10-10. Score: 1
  
  If you're getting an installation canary error, that means you tried upgrading once and it failed - and then when you upgraded a second time, you got the installation canary error. The original error is the "true" error. You can probably ffind it in your [ConfigAndLog logs](https://civicrm.stackexchange.com/questions/15931/where-are-the-configandlog-and-templates-c-directories). However, you should restore your pre-upgrade backup before attempting another upgrade. Fixing a broken upgrade is a very advanced topic.
  
  
  ---
  
  