This page describes the known issues in Cloud Next. For known issues that apply to Cloud Platform generally and Cloud Classic specifically, see Known issues in Cloud Platform and Known issues in Cloud Classic respectively.

Copy or import of databases fails

If the definition of a VIEW contains the database name in its defining query, you cannot copy or import databases.

Workaround:

To remove any instances of the database name db-name-printed-here from the VIEW:

• Confirm the database name as follows:

  copy

  mysql> show databases;;;
  +----------------------------------+
  | Database                         |
  +----------------------------------+
  | information_schema               |
  | db-name-printed-here             |
  +----------------------------------+
  2 rows in set (0.02 sec)

• Identify the views that contain references of the database name as follows:

  copy

  mysql> SELECT TABLE_NAME AS VIEW_NAME,TABLE_SCHEMA AS DB_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE VIEW_DEFINITION like '%db-name-printed-here%';
  +-------------------------------------------+----------------------------------+
  | VIEW_NAME                                 | DB_NAME                          |
  +-------------------------------------------+----------------------------------+
  | some-view-name                            | db-name-printed-here             |
  +-------------------------------------------+----------------------------------+
  1 row in set (0.06 sec)

• Review the VIEW and remove all occurrences of the database name from the SQL query as follows:

  copy

  mysql> SHOW CREATE VIEW some-view-name \G
  *************************** 1. row ***************************
                  View: some-view-name
           Create View: CREATE ALGORITHM=UNDEFINED DEFINER=`s10628`@`%` SQL SECURITY DEFINER VIEW `some-view-name` AS select `db-name-printed-here`.`watchdog`.`wid` AS `wid`,`db-name-printed-here`.`watchdog`.`severity` AS `severity`,`db-name-printed-here`.`watchdog`.`message` AS `message` from `db-name-printed-here`.`watchdog` where (`db-name-printed-here`.`watchdog`.`type` = 'cron')
  character_set_client: utf8
  collation_connection: utf8_general_ci
  1 row in set (0.00 sec)

For more information on how to modify the VIEW, read the ALTER VIEW Statement.

Process limit for Drupal, SSHD, Scheduled Tasks, and Cloud Hooks

In Cloud Next, you cannot have more than 5000 processes for Drupal, SSHD, scheduled tasks, and Cloud Hooks. If you exceed the process limit, the system restarts the service. This interrupts running requests and results in 50x errors for Drupal.

Interruption in web requests taking longer than 10 minutes

In Cloud Next applications, web requests that take longer than 10 minutes might be interrupted by routine platform maintenance activities.

Two daily backups

The Cloud Platform user interface may occasionally display two daily backup tasks for the same day, indicating the backups taken at different times of the day.

“End of script output before headers” error occurs if the HTTP response header exceeds 8 KB

Cloud Next introduces a limit of 8 KB to HTTP response headers. When using HTTP headers, ensure that the header size does not exceed this limit. For example, this limit might be triggered when you use:

• Acquia Purge module that is configured to output debug headers
• Security Kit (seckit) module that is configured to output X-Content-Security-Policy headers

File copy operation takes longer in Cloud Next compared to Cloud Classic

The file copy operation in Cloud Next takes longer as compared to Cloud Classic. This occurs because the files are first copied from the production environment to an intermediate ODE environment, and then to a migration environment. After the copy operation is complete, the system deletes the ODE environment, thereby keeping only the migration environment. This additional step in the migration process consumes more time.

Change in mod_headers behavior in Cloud Next

In Cloud Classic, mod_headers directives in the .htaccess file are ignored for PHP and Drupal requests, and are only applied to static files. However, in Cloud Next, mod_headers directives in the .htaccess file are applied. This might result in unexpected or unwanted changes in application behavior. Acquia recommends that you review your .htaccess file for mod_headers usage.

MySQL 5.7 features incompatibilities on Cloud Next

Cloud Next leverages AWS Aurora MySQL. A few of the MySQL 5.7 features are not supported on Cloud Next. For more information, see list of unsupported MySQL 5.7 features.

Scheduled jobs must not use hardcoded host names in log paths

Scheduled jobs or cron jobs in Cloud Next must not use hardcoded host names in log paths. However, if you use /shared/logs as the directory, you can use hardcoded paths.

Limitations with scheduled jobs

When you create scheduled jobs in Cloud Next:

• You cannot set crons at frequencies of less than 5 minutes.
• Your cron task duration must not be more than 3 hours. If your cron job lasts longer than that, it terminates.

Limitations with Cloud Hooks

• The maximum duration of Cloud Hook scripts is 3 hours. If your Cloud Hook script lasts longer than that, it terminates.

• Cloud Hook scripts and all child processes have a maximum memory limit of 2000 MB. If these processes exceed the available memory, the Cloud Hook logs display messages such as Killed or Exit status 137.

TLS connection issues in Ubuntu 22.04

OpenSSL 3.0.x enforces strict TLS compliance in Ubuntu 22.04. This compliance causes connection errors with external services that have improper TLS implementation. For example, you might get the following error:

OpenSSL Error messages: error:0A000126:SSL routines::unexpected eof

Workaround: Ensure that your external services are updated to meet TLS standards.

Issues in connecting to Cloud Next environments with locally-installed MySQL Workbench

If you have MySQL Workbench installed locally, you might not be able to connect to Cloud Next environments. This issue occurs for a few versions of MySQL Workbench.

If you face issues connecting to Cloud Next environments from MySQL Workbench:

• Locate the database credentials listed on your Databases page.

• Open Terminal on your local machine and run:

  {ssh -L $LOCAL_PORT:$DB_HOST:3306 $SSH_STRING}

  Here,

  • LOCAL_PORT is the port to which Workbench must connect when using localhost.
  • DB_HOST is the hostname obtained from the Cloud Platform user interface.
  • SSH_STRING is the full connection string from the Cloud Platform user interface. For example, user@something.

Code deployment in Cloud Next 

Code deployment in Cloud Next can take a maximum of 1 hour. Environments on Cloud Next may intermittently experience code deployment times taking more than 5 minutes. Ensure that you close your SSH session before starting your code deployment. If you are in an SSH session and start code deployment, the process might fail.

Git repositories in Cloud Next must not exceed 2 GB. If your repository size exceeds this limit, code deployment tasks might fail without displaying any public logs. In such a case, you must verify that the combined size of all files in the specified Git branch or tag is less than 2 GB. For more information, visit Disk Storage in Cloud Next.

Unable to increase PHP file upload size

Currently, you cannot increase the PHP file upload size values beyond the limits available in the Cloud Platform user interface. The maximum size for Cloud Next is 1024 MB.

Workarounds: You can use either of the following workarounds:

• Use the contributed module, DropzoneJS, and specifically the chunked uploads patch in DropzoneJS. For more information, see Use contributed modules for file upload handling.
• Upload a small dummy file of the next version of your software through the Drupal user interface. After that, you can access the Acquia Cloud service through SSH or SFTP, push the actual file, replacing the original dummy file. This process enables you to reference the file in Drupal and utilize it visually according to your preferences in Drupal.

memcache_admin incompatibility for FedRAMP customers

For FedRAMP customers, Cloud Next uses individual mcrouter instances on each pod. This obscures information such as cache hits or misses and might misreport metrics on each report. Therefore, the memcache_admin module does not correctly report the status of memcache instances. Cumulative statistics, available memory, and evictions are reported as zero. In addition, other statistics might be misreported.

Workaround:

To gather memcache statistics, run the following command in an SSH session:

acquia-memcache stats                   

This command displays statistics from the available memcache instances.

Drupal watchdog logs not captured for SSH, Cloud Hooks, or Scheduled Jobs

Tasks executed through SSH, Cloud Hooks, or Scheduled Jobs do not run the syslog service. Logging done through the Drupal Logging API, also known as Watchdog, is only sent to the standard output and standard error channels, and not to the drupal-watchdog logs that can be downloaded from the Cloud Platform user interface or Cloud API. 

If an application uses the Log Forwarding feature, this same logging is not sent to a log forwarding destination.

Issues occur if codebases contain a CHARSET or COLLATE name

The database copy, backup, and restore operations are updated to maintain compatibility between MySQL 5.7 and MySQL 8. This ensures that these operations continue to function as expected during database version upgrade of MySQL. This update modifies any data in your database from utf8mb4_0900_ai_ci to utf8mb4_general_ci during these operations. Acquia could not target the specific collation or charset. Therefore, if your database contains content with the utf8mb4_0900_ai_ci collation, the system updates it to utf8mb4_general_ci.

This update does not apply to database dumps and restores that are done manually with Drush. Therefore, such operations might fail when you copy them between databases on different MySQL versions. 

Workaround:

If you have a database dump that you have exported manually and you cannot import it properly, you can convert the file by running a command similar to the following:

zcat EDIT_ME_your_db_dump_file.sql.gz | sed -e 's/CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci/CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci/g' -e '/CHARSET=utf8mb4/!b' -e '/COLLATE/!s/CHARSET=utf8mb4/CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci/' | gzip -f >EDIT_ME_new_database_backup_file.sql.gz

The preceding example command assumes that:

• You have a database backup file that is gzip-compressed in the current folder.
• You are running a Cloud Platform SSH connection or Cloud IDE.

Therefore, you must update the command depending on your requirements.

Custom Varnish configurations with Acquia Purge

If your Cloud Next application uses a Custom Varnish Configuration (cVCL) file to restrict access based on IP addresses, you might experience issues with the Acquia Purge module. This occurs because purge requests originate from Web EIP addresses in Cloud Next. By default, such requests are blocked if you do not explicitly allowlist the Web EIPs in your cVCL.

Workaround:

• Contact Acquia Support to enable Web EIPs.

• Update your custom VCL to allowlist the Web EIP addresses.

Extra or missing logs in log downloads

When you download logs in Cloud Next, you might get extra entries or missing logs in your downloaded file. However, the time displayed on the downloaded logs is correct.

Workaround:
If you are missing specific logs, try to download logs for the previous or next day in addition to your original date range. Therefore, you can access logs that did not appear in your initial download.

Known issues with MySQL 5.7 to MySQL 8.0 upgrades

Before the platform database upgrade to MySQL 8.0, Acquia performs a series of automated pre-upgrade checks to identify any compatibility issues that can block or impact a successful upgrade. These checks scan Cloud Platform database clusters and individual databases for a range of potential issues, such as unsupported objects, deprecated features, or internal database artifacts left behind from previous upgrades or schema changes. Acquia's engineering team proactively resolves these incompatibilities where possible. For information about all the pre-check error descriptions, visit AWS Aurora MySQL. 

A few common issues are:

• Dangling FULLTEXT indexes or orphaned auxiliary columns

• Unsupported storage engines

• Invalid or deprecated data types

• Tables with reserved keywords

• Tables referencing removed features or system variables

I use the tx_isolation and tx_read_only variables in MySQL 5.7. Are these variables supported in MySQL 8.0?

No, the MySQL transaction variables, tx_isolation and tx_read_only are supported in MySQL 5.7 but are not supported in MySQL 8.0. Therefore, if you continue to use the legacy variables after you upgrade your application to MySQL 8.0, you might encounter the following errors:

• Drupal might fail to connect to the database and log an error message. For example,

  copy

  SQLSTATE[HY000]: General error: 1193 Unknown system variable 'tx_isolation'

• If you use Drush to connect to Drupal, you might get different error messages based on your use case. For example,

  copy

  SQLSTATE[HY000]: General error: 1193 Unknown system variable 'tx_isolation

  or

  copy

  Failed to connect to any database servers for database [DB UUID]

Workaround:

Replace the legacy variables, tx_isolation and tx_read_only with their aliases, transaction_isolation and transaction_read_only in your application code. These aliases are supported in MySQL 8.0 as well as MySQL 5.7. For example, if your settings.php file has the following:

$databases['default']['default']['init_commands'] = array(    'isolation' => "SET SESSION tx_isolation='READ-COMMITTED'", );

You must update it as follows:

$databases['default']['default']['init_commands'] = array(    'isolation' => "SET SESSION transaction_isolation='READ-COMMITTED'",  );

I use the sql_mode value NO_AUTO_CREATE_USER in MySQL 5.7. Is this supported in MySQL 8.0?

In MySQL 8.0, the NO_AUTO_CREATE_USER sql_mode is deprecated. If you have this mode in your codebase, you might get the following error after you upgrade to MySQL 8.0:

AH_WARNING: The connection to database default on db-x.x.x failed after 3 attempts and is now failing over. Error was: SQLSTATE[42000]: Syntax error or access violation: 1231 Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER' request_id=""

Workaround: You must remove NO_AUTO_CREATE_USER from your sql_mode settings in any application code. You must do it prior to your application upgrade to MySQL 8.0 to prevent site downtime. For more information, visit Drupal throws MySQL "expression [...] of ORDER BY clause is not in SELECT list" errors.

Frequently asked questions

Known issues in Cloud Next

OpenSSL Error messages: error:0A000126:SSL routines::unexpected eof

acquia-memcache stats                   

zcat EDIT_ME_your_db_dump_file.sql.gz | sed -e 's/CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci/CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci/g' -e '/CHARSET=utf8mb4/!b' -e '/COLLATE/!s/CHARSET=utf8mb4/CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci/' | gzip -f >EDIT_ME_new_database_backup_file.sql.gz

$databases['default']['default']['init_commands'] = array(    'isolation' => "SET SESSION tx_isolation='READ-COMMITTED'", );

$databases['default']['default']['init_commands'] = array(    'isolation' => "SET SESSION transaction_isolation='READ-COMMITTED'",  );

AH_WARNING: The connection to database default on db-x.x.x failed after 3 attempts and is now failing over. Error was: SQLSTATE[42000]: Syntax error or access violation: 1231 Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER' request_id=""

Frequently asked questions

No, Fast 404 is incompatible with MySQL 8.0 and later. This impacts only the 7.x versions of Drupal and Fast 404.

If your sites use this module after they are upgraded to MySQL 8.0 and later, such sites might encounter degraded functionality and the following errors:

• SQL errors: This occurs because of deprecated or incompatible SQL syntax. For example, SQLSTATE[42000]: Syntax error or access violation: 1064.

• Broken 404 pages: This occurs as the system displays blank pages and error messages because of missing files or inaccurate 404 pages.

• Site instability: This causes unstable websites because of a large number of 404 errors. Such errors are caused by missing files, images, or bots, and can trigger memory use, "white screen of death" (WSOD), or inaccessible pages.

• Performance degradation: This occurs because the site becomes non-responsive as 404s are not efficiently handled.

• Inability to uninstall modules: After you upgrade to MySQL 8.0, you might not be able to update or uninstall this module correctly.

Workaround: 

• Uninstall or disable Fast 404 before upgrading to MySQL 8.0 and later.

• Implement the code changes mentioned in the Fast 404 pages section in the Drupal core default.settings.php file.

Can I use certain reserved keywords in MySQL 8.0?

If your database or SQL queries use certain reserved keywords as unquoted column names, table names, or aliases, your code will fail in MySQL 8.0 with SQL syntax errors. For example:

• RANK
• SYSTEM
• WINDOW

Such failures result in application features, deployments, or database migrations to break or become unavailable after the upgrade.

For example, the following SQL queries break in MySQL 8.0:

Workaround:
Use backticks (`) to quote reserved words:

Solution:

• Review the list of keywords new in MySQL 8.0 to identify any that may conflict with your existing database tables, columns, or aliases. For more information, visit MySQL 8.0 New Keywords and Reserved Words.

• Audit your custom and contributed SQL queries, and your database schema, for use of these reserved words as unquoted identifiers.

• Enclose these identifiers in backticks, or rename fields and tables to avoid reserved words.

• Make these changes before upgrading to MySQL 8.0 to prevent SQL errors and application disruptions.

Can I use emojis or non-BMP Unicode in column comments with the UTF-8 character set in MySQL 8.0?

No. Before upgrading to MySQL 8.0, Cloud Platform checks for column comments that contain emojis or other non-BMP Unicode characters stored with the legacy UTF-8 character set, such as utf8mb3. If such characters are found, the system removes or replaces the comments so that the MySQL 8.0 upgrade does not block due to stricter character set validation. For more information visit Check for invalid utf8mb3 column comments.

Workaround:

Do one of the following:

• Remove or replace all emojis and non-BMP Unicode characters from column comments before upgrading to MySQL 8.0.
• Convert your table or column to use the utf8mb4 character set, which supports all Unicode characters.

How do I confirm that my Drupal version is compatible with MySQL 8.0?

Acquia will upgrade the MySQL version for Cloud Next infrastructure from Aurora MySQL 5.7 to Aurora MySQL 8.0. The following Drupal versions are compatible with MySQL 8.0:

• Drupal 7: Drupal 7.7.6 and later

• Drupal 8: Drupal 8.6 and later

Workaround:
If you are running an incompatible version of Drupal, upgrade to at least Drupal 7.76 or Drupal 8.6 before migrating to Cloud Next. This will ensure compatibility with Aurora MySQL 8.0. For more information, visit Amazon Aurora major versions.

No, Fast 404 is incompatible with MySQL 8.0 and later. This impacts only the 7.x versions of Drupal and Fast 404.

If your sites use this module after they are upgraded to MySQL 8.0 and later, such sites might encounter degraded functionality and the following errors:

• SQL errors: This occurs because of deprecated or incompatible SQL syntax. For example, SQLSTATE[42000]: Syntax error or access violation: 1064.

• Broken 404 pages: This occurs as the system displays blank pages and error messages because of missing files or inaccurate 404 pages.

• Site instability: This causes unstable websites because of a large number of 404 errors. Such errors are caused by missing files, images, or bots, and can trigger memory use, "white screen of death" (WSOD), or inaccessible pages.

• Performance degradation: This occurs because the site becomes non-responsive as 404s are not efficiently handled.

• Inability to uninstall modules: After you upgrade to MySQL 8.0, you might not be able to update or uninstall this module correctly.

Workaround: 

• Uninstall or disable Fast 404 before upgrading to MySQL 8.0 and later.

• Implement the code changes mentioned in the Fast 404 pages section in the Drupal core default.settings.php file.

Can I use certain reserved keywords in MySQL 8.0?

If your database or SQL queries use certain reserved keywords as unquoted column names, table names, or aliases, your code will fail in MySQL 8.0 with SQL syntax errors. For example:

• RANK
• SYSTEM
• WINDOW

Such failures result in application features, deployments, or database migrations to break or become unavailable after the upgrade.

For example, the following SQL queries break in MySQL 8.0:

Workaround:
Use backticks (`) to quote reserved words:

Solution:

• Review the list of keywords new in MySQL 8.0 to identify any that may conflict with your existing database tables, columns, or aliases. For more information, visit MySQL 8.0 New Keywords and Reserved Words.

• Audit your custom and contributed SQL queries, and your database schema, for use of these reserved words as unquoted identifiers.

• Enclose these identifiers in backticks, or rename fields and tables to avoid reserved words.

• Make these changes before upgrading to MySQL 8.0 to prevent SQL errors and application disruptions.

Can I use emojis or non-BMP Unicode in column comments with the UTF-8 character set in MySQL 8.0?

No. Before upgrading to MySQL 8.0, Cloud Platform checks for column comments that contain emojis or other non-BMP Unicode characters stored with the legacy UTF-8 character set, such as utf8mb3. If such characters are found, the system removes or replaces the comments so that the MySQL 8.0 upgrade does not block due to stricter character set validation. For more information visit Check for invalid utf8mb3 column comments.

Workaround:

Do one of the following:

• Remove or replace all emojis and non-BMP Unicode characters from column comments before upgrading to MySQL 8.0.
• Convert your table or column to use the utf8mb4 character set, which supports all Unicode characters.

How do I confirm that my Drupal version is compatible with MySQL 8.0?

Acquia will upgrade the MySQL version for Cloud Next infrastructure from Aurora MySQL 5.7 to Aurora MySQL 8.0. The following Drupal versions are compatible with MySQL 8.0:

• Drupal 7: Drupal 7.7.6 and later

• Drupal 8: Drupal 8.6 and later

Workaround:
If you are running an incompatible version of Drupal, upgrade to at least Drupal 7.76 or Drupal 8.6 before migrating to Cloud Next. This will ensure compatibility with Aurora MySQL 8.0. For more information, visit Amazon Aurora major versions.