Thread Details
  • State Not Answered
  • +1 person also asked this people also asked this
  • Replies 21 replies
  • Subscribers 356 subscribers
  • Views 5264 views
  • Users 0 members are here
Forum Actions
Related

Upgrade 11.0.3 -> 12 failed in post rebuild: Invalid favorite_link

Jeroen Somhorst

Hi, 

currently upgrading an instance from 11.0.3 to 12. On 11.0.3 with PHP: 7.4.3 and Mysql: 5.7.38. Everything seems to work correctly. When we start the upgrade with the silent installer (or ui installer doesn't matter much) we eventually hit the following error: 

Tue, 14 Jun 2022 07:08:46 +0000 [Upgrader] - Verifying audit tables for modules: Leads,Cases,Bugs,ProjectTask,Campaigns,Prospects,Contacts,Accounts,Opportunities,Notes,Calls,Meetings,Tasks,EmailAddresses,Contracts,ProductTemplates,Quotes,Products,RevenueLineItems,ForecastManagerWorksheets,Quotas,BusinessCenters,Shifts,ShiftExceptions,Messages,Purchases,PurchasedLineItems,DataPrivacy,ReportSchedules,Tags,KBContents,KBContentTemplates,Escalations,DocumentTemplates,DocumentMerges,aconf_Configurator,aconf_Import_Match,aconf_Import_Auto_Fill
Tue, 14 Jun 2022 07:08:46 +0000 [Upgrader] - Database repaired
Tue, 14 Jun 2022 07:08:46 +0000 [Upgrader] - Start rebuilding relationships
Tue, 14 Jun 2022 07:09:33 +0000 [Upgrader] - ERROR: Exception: Invalid link favorite_link
Tue, 14 Jun 2022 07:09:33 +0000 [Upgrader] - Finished script 2_Rebuild
Tue, 14 Jun 2022 07:09:33 +0000 [Upgrader] - ERROR: Post-upgrade stage failed! Error executing post scripts

We already tried the following but without any luch: 

- truncate the relationships table in the database (it's not used anymore to my knowledge)

- prior upgrade hit the repair relationships and do a quick repair / rebuild. 

Does anyone else have any idea what the cause could be and most importantly a solution. 

Parents
  • 0

    Encountered similar issues with 11.0.3 to 12.0.0 upgrade at the script 2_Rebuild stage and then at other points after.  Tried both strategies with php 7.4/mysql 5.7 as well as php 8/mysql 8... had to use the -S continue flag and step through various script failures, made it feel super untested in general.  It would be helpful if we could have clarity on which versions are supported/required for the upgrade silent installer itself at the time the scripts are run (vs which versions of php/mysql are supported post-upgrade). Thanks Jeroen for sharing some of your experience here.

Reply
  • 0

    Encountered similar issues with 11.0.3 to 12.0.0 upgrade at the script 2_Rebuild stage and then at other points after.  Tried both strategies with php 7.4/mysql 5.7 as well as php 8/mysql 8... had to use the -S continue flag and step through various script failures, made it feel super untested in general.  It would be helpful if we could have clarity on which versions are supported/required for the upgrade silent installer itself at the time the scripts are run (vs which versions of php/mysql are supported post-upgrade). Thanks Jeroen for sharing some of your experience here.

Children
  • 0 in reply to Sean Nakamura

    I usually check the Supported Platforms documentation and go for the highest version supported by both the old and the new version, there is always an overlap.

    In this case MySQL v8.0 and PHP 7.4

    See: 

    https://support.sugarcrm.com/Resources/Supported_Platforms/Sugar_11.0.x_Supported_Platforms/

    and

    https://support.sugarcrm.com/Resources/Supported_Platforms/Sugar_12.0.x_Supported_Platforms/

    I then perform the Sugar Upgrade.
    And only after that perform any further upgrades to the stack (like moving to PHP 8.0)

    FrancescaS

  • 0 in reply to Sean Nakamura

    Here's the details of the script 2_Rebuild error I was facing: 

    Mon, 13 Jun 2022 20:56:11 +0000 [Upgrader] - Start rebuilding relationships
    Mon, 13 Jun 2022 20:56:14 +0000 [Upgrader] - PHP: [2] mysqli::prepare(): Couldn't fetch mysqli in /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php at 96
    Mon, 13 Jun 2022 20:56:14 +0000 [Upgrader] - PHP: [2] Doctrine\DBAL\Driver\Mysqli\Exception\ConnectionError::new(): Couldn't fetch mysqli in /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/Exception/ConnectionError.php at 19
    Mon, 13 Jun 2022 20:56:14 +0000 [Upgrader] - PHP: [2] Doctrine\DBAL\Driver\Mysqli\Exception\ConnectionError::new(): Couldn't fetch mysqli in /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/Exception/ConnectionError.php at 19
    Mon, 13 Jun 2022 20:56:14 +0000 [Upgrader] - PHP: [2] Doctrine\DBAL\Driver\Mysqli\Exception\ConnectionError::new(): Couldn't fetch mysqli in /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/Exception/ConnectionError.php at 19
    Mon, 13 Jun 2022 20:56:14 +0000 [Upgrader] - ERROR: Exception: An exception occurred while executing 'DELETE FROM system_process_lock WHERE unique_id = ? AND additional_key = ?' with params ["MetaDataManager::loadAndCacheMetadata", "#"]:
    Wrong parameters for Doctrine\DBAL\Driver\Mysqli\Exception\ConnectionError([string $message [, long $code [, Throwable $previous = NULL]]])
    Mon, 13 Jun 2022 20:56:14 +0000 [Upgrader] - Finished script 2_Rebuild
    Mon, 13 Jun 2022 20:56:14 +0000 [Upgrader] - ERROR: Post-upgrade stage failed! Error executing post scripts