Hi..I am upgrading upgrading vCD to 10.0..Its a single cell env with external Postgres DB. Cell upgrade works fine, but DB upgrade fails with 'Unable to upgrade the database: java.lang.IllegalStateException: Exception encountered while altering idle transaction session timeout in vcloud database'.
As a troubleshoot, I updated the postgres config file (connection idle_in_transaction_session_timeout, max_connections, shared_buffers etc)..Confirmed vcloud is the DB owner..my DB name is not vCloud though..
Here is the error in DB log
2022-03-15 03:33:49.355 UTC [65] WARNING: there is already a transaction in progress
2022-03-15 03:33:49.439 UTC [65] WARNING: there is already a transaction in progress
2022-03-15 03:33:49.685 UTC [65] ERROR: must be owner of database cl1vcddb
2022-03-15 03:33:49.685 UTC [65] STATEMENT: ALTER DATABASE "XXX" SET idle_in_transaction_session_timeout = 300000
2022-03-15 03:33:49.732 UTC [65] LOG: unexpected EOF on client connection with an open transaction
Please let me know if I am missing on something or any further troubleshooting tip will be appreciated..Thanks
What version of postgres DB are you on currently? You need to upgrade it to 10 I believe.
I am running on Postgre10. I was able to resolve the issue last night. I used vcduser account when I set up vCD few years ago. My upgrade to 10.0 was failing with idle_session_timeout..as a fix, I made changes in postgresconf as well as changed the owner of DB to vcloud. But apparently, it was not changed at all places (global.properties) so I reverted back the owner to vcduser last night and I was able to upgrade successfully.
