GitHub user zergawcloud closed the discussion with a comment: An error getting 
clusters resources information on GUI ACS 4.22

@rajujith ,  I am using MariaDB database cluster, and yes my db.cloud.uri is 
jdbc:mariadb
```
# CloudStack database settings
db.cloud.username=cloud
db.cloud.password=ENC(fK02lSie3Z2AlGd6dnJGfjmZiMSCG1pcvfgGzsUSsuPEUK0Ba8QQ)
db.cloud.host=172.28.236.31
db.cloud.driver=jdbc:mysql
db.cloud.port=3306
db.cloud.name=cloud

# Connection URI to the database "cloud". When this property is set, only the 
following properties will be used along with it: db.cloud.maxActive, 
db.cloud.maxIdle, db.cloud.maxWait, db.cloud.username, db.cloud.password, 
db.cloud.driver, db.cloud.validationQuery, db.cloud.isolation.level. Other 
properties will be ignored.
db.cloud.uri=jdbc:mariadb:sequential://172.28.236.31:3306,172.28.236.32:3306,172.28.236.33:3306/cloud?autoReconnect=true&prepStmtCacheSize=517&cachePrepStmts=true&sessionVariables=sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'&serverTimezone=UTC
```
But currently, I'm not really sure on how i can translate my db.cloud.uri from 
the jdbc:mariadb to jdbc:mysql.  Just changing mariadb to mysql in the uri and 
removing `sequential` shows `2026-03-03 07:28:36,085 ERROR [c.c.u.d.DbUtil] 
(main:[]) (logid:) GET_LOCK() throws exception java.sql.SQLException: Operation 
not allowed for a result set of type ResultSet.TYPE_FORWARD_ONLY.`

GitHub link: 
https://github.com/apache/cloudstack/discussions/12498#discussioncomment-15981365

----
This is an automatically sent email for [email protected].
To unsubscribe, please send an email to: [email protected]

Reply via email to