Mautic 5 Upgrades Failing

[Dave Swift]

I am experiencing issues while upgrading Mautic from the dashboard on two different Cloudron instances. The upgrade process hangs, and I've encountered two distinct errors in the logs.

First Error: In AppKernelProdContainer.php line 11213, the log indicates a missing parameter with the message: The parameter "2B" must be defined.

Second Error: This involves a database migration issue. The logs show an exception related to executing a query during the migration process: An exception occurred while executing a query: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'point_groups' already exists. This error is from the migration Mautic\Migrations\Version20230621074925.

In the Cloudron UI, Mautic remains stuck at the "Starting..." phase and doesn't complete the upgrade process.

I have already restored back to Mautic 4 but I would appreciate any guidance or assistance you can provide in resolving these upgrade issues.

[girish]

@Dave-Swift The second error is open upstream at https://github.com/mautic/mautic/issues/12993 . The first one probably needs to be reported upstream as well. Do you have a complete log of the first error?

[micmc]

@girish said in Mautic 5 Upgrades Failing:

@Dave-Swift The second error is open upstream at https://github.com/mautic/mautic/issues/12993 . The first one probably needs to be reported upstream as well. Do you have a complete log of the first error?

Experiencing the same thing, yeah there might be a need for a few adjustment with a major update as such.

So here's essentially what shows up in the log and Mautic is actually not responding, and trying to restart it will respond the same as this in the log:

Jan 18 10:26:07doctrine:migrations:migrate [--write-sql [WRITE-SQL]] [--dry-run] [--query-time] [--allow-no-migration] [--all-or-nothing [ALL-OR-NOTHING]] [--configuration CONFIGURATION] [--em EM] [--conn CONN] [--] [<version>]
Jan 18 10:26:07In Connection.php line 70:
Jan 18 10:26:07In Exception.php line 28:
Jan 18 10:26:07In ExceptionConverter.php line 45:

Jan 18 10:26:07 An exception occurred while executing a query: SQLSTATE[42S01]: Base table
Jan 18 10:26:07 SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'point_group
Jan 18 10:26:07 SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'point_group
Jan 18 10:26:07 or view already exists: 1050 Table 'point_groups' already exists
Jan 18 10:26:07 s' already exists
Jan 18 10:26:07 s' already exists
Jan 18 10:26:07[error] Migration Mautic\Migrations\Version20230621074925 failed during Execution. Error: "An exception occurred while executing a query: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'point_groups' already exists"
Jan 18 10:26:07[2024-01-18 16:26:07] [notice] Column lead_points_change_log.group_id already exists
Jan 18 10:26:07[2024-01-18 16:26:07] [notice] Column point_triggers.group_id already exists
Jan 18 10:26:07[2024-01-18 16:26:07] [notice] Column points.group_id already exists
Jan 18 10:26:07[2024-01-18 16:26:07] [notice] Table plugin_citrix_events already exists
Jan 18 10:26:07[2024-01-18 16:26:07] [notice] Table point_group_contact_score already exists
Jan 18 10:26:07[2024-01-18 16:26:07] [notice] Table point_groups already exists
Jan 18 10:26:07[2024-01-18 16:26:07] [notice] Migrating up to Mautic\Migrations\Versionzz20230929183000
Jan 18 10:26:07[2024-01-18 16:26:07] [notice] Migration Mautic\Migrations\Version20221128145933 skipped during Pre-Checks. Reason: "Schema includes this migration"

Jan 18 10:27:10=> Healtheck error: Error: connect ECONNREFUSED 172.18.18.22:8000
Jan 18 10:27:12[2024-01-18 16:27:12]
Jan 18 10:27:12[2024-01-18 16:27:12]
Jan 18 10:27:12[2024-01-18 16:27:12] [WARNING] You have 183 previously executed migrations in the database that are
Jan 18 10:27:12[2024-01-18 16:27:12] not registered migrations.

It seems like the installation process attempts to create new tables and columns several times...