legacy-knowledge-base
公開されました Sep. 10, 2025

Deploys failing due to "requested flag is either misspelled or unsupported by this database type"

written-by

Giulianna Munoa

How To articles are not official guidelines or officially supported documentation. They are community-contributed content and may not always reflect the latest updates to Liferay DXP. We welcome your feedback to improve How To articles!

While we make every effort to ensure this Knowledge Base is accurate, it may not always reflect the most recent updates or official guidelines.We appreciate your understanding and encourage you to reach out with any feedback or concerns.

legacy-article

learn-legacy-article-disclaimer-text

Issue

  • New deploys fails due to the database service and backup restores too
  • Checking the database service logs you identify the following:
    INFO May 15 14:54:39.664 1904 database 75b864bd48-zzc6n [INFO] Instance status: available
    INFO May 15 14:54:44.856 1904 database 75b864bd48-zzc6n [INFO] Updating instance settings for dxpcloud-rzzjdmdfxrevzbmjif-tnmscjjytqvleijjgx: {"settings":{"databaseFlags":[{"name":"character_set_server","value":"utf8mb4"},{"name":"interactive_timeout","value":"30000"},{"name":"max_allowed_packet","value":"1073741824"},{"name":"wait_timeout","value":"10000"},{"name":"thread_cache_size","value":"96"},{"name":"query_cache_type","value":"1"},{"name":"query_cache_size","value":"67108864"},{"name":"innodb_lock_wait_timeout","value":"15"},{"name":"max_connections","value":"50000"},{"name":"table_open_cache","value":"100000"}],"edition":"ENTERPRISE"}}
    INFO May 15 14:54:45.199 1904 database 75b864bd48-zzc6n [INFO] Updating instance settings for dxpcloud-rzzjdmdfxrevzbmjif-database-2: {"settings":{"databaseFlags":[{"name":"character_set_server","value":"utf8mb4"},{"name":"interactive_timeout","value":"30000"},{"name":"max_allowed_packet","value":"1073741824"},{"name":"wait_timeout","value":"10000"},{"name":"thread_cache_size","value":"96"},{"name":"query_cache_type","value":"1"},{"name":"query_cache_size","value":"67108864"},{"name":"innodb_lock_wait_timeout","value":"15"},{"name":"max_connections","value":"50000"},{"name":"table_open_cache","value":"100000"}],"edition":"ENTERPRISE"}}
    ERROR May 15 14:54:45.216 1904 database 75b864bd48-zzc6n [ERROR] Error: The requested flag is either misspelled or unsupported by this database type.
    at Gaxios._request (/lcp/app/database/node_modules/gaxios/src/gaxios.ts:172:15)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async Compute.requestAsync (/lcp/app/database/node_modules/google-auth-library/build/src/auth/oauth2client.js:429:18)
    at retry (/lcp/app/database/src/api/google-api.ts:455:24)
    at GoogleApi.updateInstanceSettings (/lcp/app/database/src/api/google-api.ts:273:14)
    at InstanceManagerGoogle._maybeUpdateInstanceSettings (/lcp/app/database/src/manager/instance-manager-google.ts:317:7)
    at InstanceManagerGoogle.updateInstanceSettingsCustom (/lcp/app/database/src/manager/instance-manager-google.ts:78:7)
    at InstanceManagerGoogle.updateInstanceSettings (/lcp/app/database/src/manager/instance-manager.ts:57:28)
    at InstanceManagerGoogle.startOrCreate (/lcp/app/database/src/manager/instance-manager.ts:193:20)
    at async Promise.all (index 0)

 

Environment

  • Liferay PaaS  (MySQL8)

Resolution

  • This might happen if you previosly configured environment variables that are not valid anymore after the MySQL8 database.
  • Check the environment variables available for your database version
  • In this case there were two variables not supported anymore:
    LCP_GCP_DATABASE_FLAG_QUERY_CACHE_TYPE
    LCP_GCP_DATABASE_FLAG_QUERY_CACHE_SIZE

Additional Information

 

 

did-this-article-resolve-your-issue

legacy-knowledge-base