CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • 2.2 > 3.2 - Problem with database upgrade
Pages: [1]

Author Topic: 2.2 > 3.2 - Problem with database upgrade  (Read 939 times)

kecker

  • I’m new here
  • *
  • Posts: 28
  • Karma: 1
2.2 > 3.2 - Problem with database upgrade
December 05, 2010, 09:23:33 pm
Was upgrading from CiviCRM 2.2 to 3.2 and made it through the install of the new version and then was running the database upgrade utility.  It ran for awhile and finally displayed this:

Sorry. A non-recoverable error has occurred.
DB Error: no database selected
Error Details
Database Error Code: Lost connection to MySQL server during query, 2013
Additional Details:
Array
(
    [callback] => Array
        (
           
  • => CRM_Core_Error
  • [1] => handle
            )

       
Code: [Select]
=> -14
    [message] => DB Error: no database selected
    [mode] => 16
    [debug_info] => SELECT @workflow_id := MAX(id) FROM civicrm_option_value WHERE name = 'contribution_online_receipt' [nativecode=2013 ** Lost connection to MySQL server during query]
    [type] => DB_Error
    [user_info] => SELECT @workflow_id := MAX(id) FROM civicrm_option_value WHERE name = 'contribution_online_receipt' [nativecode=2013 ** Lost connection to MySQL server during query]
    [to_string] => [db_error: message="DB Error: no database selected" code=-14 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT @workflow_id := MAX(id) FROM civicrm_option_value WHERE name = 'contribution_online_receipt' [nativecode=2013 ** Lost connection to MySQL server during query]"]
)

Looks like it timed out....what are my options at this point?? And what state is the database in??

kecker

  • I’m new here
  • *
  • Posts: 28
  • Karma: 1
Re: 2.2 > 3.2 - Problem with database upgrade
December 05, 2010, 09:28:19 pm
When I try to run the upgrade script all over again, I get the following:

Sorry. A non-recoverable error has occurred.
Database check failed - the database looks to have been partially upgraded. You may want to reload the database with the backup and try the upgrade process again.

Which makes sense....but if I restore from the backup and try to run again it's just going to timeout again.....my options?

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: 2.2 > 3.2 - Problem with database upgrade
December 05, 2010, 10:18:42 pm
Looks like some problem with your MySQL sever settings. You should check with your server admin

Kurund
Found this reply helpful? Support CiviCRM

kecker

  • I’m new here
  • *
  • Posts: 28
  • Karma: 1
Re: 2.2 > 3.2 - Problem with database upgrade
December 05, 2010, 10:23:11 pm
Could you be more specific...check with them regarding what exactly?

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: 2.2 > 3.2 - Problem with database upgrade
December 05, 2010, 10:27:36 pm
Quote
Lost connection to MySQL server during query

This error.

Kurund
Found this reply helpful? Support CiviCRM

kecker

  • I’m new here
  • *
  • Posts: 28
  • Karma: 1
Re: 2.2 > 3.2 - Problem with database upgrade
December 06, 2010, 03:54:43 pm
No idea what they did, but upgrade succeeded afterwards.  Presumably they temporarily extended the SQL timeout parameter.

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • 2.2 > 3.2 - Problem with database upgrade

This forum was archived on 2017-11-26.