Thread Details
  • State Not Answered
  • +1 person also asked this people also asked this
  • Replies 21 replies
  • Subscribers 356 subscribers
  • Views 5277 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.

  • 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

Reply
  • 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

Children
No Data