You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cloudstack.apache.org by "Marco1221 (via GitHub)" <gi...@apache.org> on 2026/07/29 08:25:09 UTC

[I] CloudStack Installer creates an incompatible database schema, causing Unknown column 'configuration.default_value' on startup [cloudstack-installer]

Marco1221 opened a new issue, #10:
URL: https://github.com/apache/cloudstack-installer/issues/10

   ### Description
   
   I encountered an issue when deploying Apache CloudStack using the official `cloudstack-installer` project.
   
   The installation completed successfully, but the CloudStack Management Server fails to start correctly. The web UI is inaccessible, and the management log reports SQL errors indicating that the application expects database columns that do not exist.
   
   ### Environment
   
   - OS: Ubuntu 22.04.5 LTS
   - Installation method: cloudstack-installer
   - Fresh installation on a clean VM
   - Database: MySQL (installed by the installer)
   
   ### Error
   ```
   2026-07-29 08:24:57,137 ERROR [o.a.c.f.c.d.ConfigurationDaoImpl] (qtp1404565079-49:[]) (logid:) DB Exception on: HikariProxyPreparedStatement@671901636 wrapping com.mysql.cj.jdbc.ClientPreparedStatement: SELECT configuration.instance, configuration.component, configuration.name, configuration.value, configuration.default_value, configuration.description, configuration.category, configuration.is_dynamic, configuration.scope, configuration.updated, configuration.group_id, configuration.subgroup_id, configuration.parent, configuration.display_text, configuration.kind, configuration.options FROM configuration WHERE configuration.name = x'70726f78792e6865616465722e766572696679' java.sql.SQLSyntaxErrorException: Unknown column 'configuration.default_value' in 'field list'
   	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121)
   	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
   	at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)
   	at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:972)
   	at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
   	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
   	at com.cloud.utils.db.GenericDaoBase.findById(GenericDaoBase.java:1086)
   	at com.cloud.utils.db.GenericDaoBase.lockRow(GenericDaoBase.java:1062)
   	at com.cloud.utils.db.GenericDaoBase.findById(GenericDaoBase.java:997)
   	at jdk.internal.reflect.GeneratedMethodAccessor7.invoke(Unknown Source)
   	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   	at java.base/java.lang.reflect.Method.invoke(Method.java:569)
   	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
   	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
   	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
   	at com.cloud.utils.db.TransactionContextInterceptor.invoke(TransactionContextInterceptor.java:34)
   	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:175)
   	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)
   	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
   	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:215)
   	at jdk.proxy3/jdk.proxy3.$Proxy39.findById(Unknown Source)
   	at org.apache.cloudstack.framework.config.impl.ConfigDepotImpl.getConfigStringValueInternal(ConfigDepotImpl.java:289)
   	at com.github.benmanes.caffeine.cache.LocalLoadingCache.lambda$newMappingFunction$3(LocalLoadingCache.java:183)
   	at com.github.benmanes.caffeine.cache.BoundedLocalCache.lambda$doComputeIfAbsent$14(BoundedLocalCache.java:2687)
   	at java.base/java.util.concurrent.ConcurrentHashMap.compute(ConcurrentHashMap.java:1916)
   	at com.github.benmanes.caffeine.cache.BoundedLocalCache.doComputeIfAbsent(BoundedLocalCache.java:2685)
   	at com.github.benmanes.caffeine.cache.BoundedLocalCache.computeIfAbsent(BoundedLocalCache.java:2668)
   	at com.github.benmanes.caffeine.cache.LocalCache.computeIfAbsent(LocalCache.java:112)
   	at com.github.benmanes.caffeine.cache.LocalLoadingCache.get(LocalLoadingCache.java:58)
   	at org.apache.cloudstack.utils.cache.LazyCache.get(LazyCache.java:38)
   	at org.apache.cloudstack.framework.config.impl.ConfigDepotImpl.getConfigStringValue(ConfigDepotImpl.java:302)
   	at org.apache.cloudstack.framework.config.ConfigKey.value(ConfigKey.java:390)
   	at com.cloud.api.ApiServlet.doUseForwardHeaders(ApiServlet.java:686)
   	at com.cloud.api.ApiServlet.getClientAddress(ApiServlet.java:695)
   	at org.apache.cloudstack.ACSRequestLog.log(ACSRequestLog.java:56)
   	at org.eclipse.jetty.server.HttpChannel.onCompleted(HttpChannel.java:911)
   	at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:467)
   	at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:277)
   	at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311)
   	at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105)
   	at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104)
   	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:338)
   	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:315)
   	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:173)
   	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131)
   	at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:409)
   	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:883)
   	at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1034)
   	at java.base/java.lang.Thread.run(Thread.java:840)
   
   ```


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@cloudstack.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Re: [I] CloudStack Installer creates an incompatible database schema, causing Unknown column 'configuration.default_value' on startup [cloudstack-installer]

Posted by "Marco1221 (via GitHub)" <gi...@apache.org>.
Marco1221 commented on issue #10:
URL: https://github.com/apache/cloudstack-installer/issues/10#issuecomment-5250063338

   It works!  thank you!


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@cloudstack.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Re: [I] CloudStack Installer creates an incompatible database schema, causing Unknown column 'configuration.default_value' on startup [cloudstack-installer]

Posted by "Marco1221 (via GitHub)" <gi...@apache.org>.
Marco1221 closed issue #10: CloudStack Installer creates an incompatible database schema, causing Unknown column 'configuration.default_value' on startup
URL: https://github.com/apache/cloudstack-installer/issues/10


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@cloudstack.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Re: [I] CloudStack Installer creates an incompatible database schema, causing Unknown column 'configuration.default_value' on startup [cloudstack-installer]

Posted by "sudo87 (via GitHub)" <gi...@apache.org>.
sudo87 commented on issue #10:
URL: https://github.com/apache/cloudstack-installer/issues/10#issuecomment-5224315916

   @Marco1221 which ACS version did you try to install?
   
   I was able to install ACS 4.22 without any issue on Ubuntu 22.04.5 LTS
   ```
   root@abc:~# cat /etc/os-release
   PRETTY_NAME="Ubuntu 22.04.5 LTS"
   NAME="Ubuntu"
   VERSION_ID="22.04"
   VERSION="22.04.5 LTS (Jammy Jellyfish)"
   VERSION_CODENAME=jammy
   ID=ubuntu
   ID_LIKE=debian
   HOME_URL="https://www.ubuntu.com/"
   SUPPORT_URL="https://help.ubuntu.com/"
   BUG_REPORT_URL="https://bugs.launchpad.net/ubuntu/"
   PRIVACY_POLICY_URL="https://www.ubuntu.com/legal/terms-and-policies/privacy-policy"
   UBUNTU_CODENAME=jammy
   root@abc:~# systemctl status cloudstack-management
   ● cloudstack-management.service - CloudStack Management Server
        Loaded: loaded (/lib/systemd/system/cloudstack-management.service; enabled; vendor preset: enabled)
        Active: active (running) since Sat 2026-08-08 03:25:21 UTC; 5min ago
      Main PID: 26151 (java)
         Tasks: 231 (limit: 11504)
        Memory: 1.4G
           CPU: 1min 39.311s
        CGroup: /system.slice/cloudstack-management.service
                └─26151 /usr/bin/java -Djava.security.properties=/etc/cloudstack/management/java.security.ciphers -Djava.awt.headless=true -Xmx2G -XX:+UseParallelGC -XX:MaxGCPauseMillis=500 -XX:+HeapDumpOnOutOf>
   ```
   
   <img width="2914" height="1640" alt="Image" src="https://github.com/user-attachments/assets/9abd4692-a0f7-49a4-84e4-2d43cfd6849a" />


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@cloudstack.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org