errors after upgrading from 6.5 to 6.15

[Paul Tan]

had performed an upgrade from 6.5 to 6.15 yesterday.

1) how do i go about changing the database collation? do i need to export the db and recreate it? if so, please let me know how to

2) also, where is the config file that defines the db connection values. like server IP, userid, password

3) do not know where to update the MaxTotal as i can't find it in the server.xml

thanks!

[Craig Castle-Mead]

Hi Paul,

1 - Assuming you’re using a mysql database - https://confluence.atlassian.com/jirakb/health-check-database-collation-in-mysql-943951422.html

2 - you’re looking for the confluence.cfg.xml file - https://confluence.atlassian.com/doc/confluence-home-and-other-important-directories-590259707.html

3 - please refer to the above link to explain where server.xml is

CCM

[Paul Tan]

Hi, am using postgresql . is it possible to migrate to mysql?

[Paul Tan]

i know where the server.xml is, i just can't find the line inside it that allows me to update the MaxTotal values.

[Craig Castle-Mead]

Hi Paul,

have a look at https://github.com/jenkins-infra/confluence/blob/master/confluence/site/conf/server.xml

it will show you where the maxThreads setting goes (in the connector node).

also, stick with postgres. While mysql is supported by Atlassian, development happens against postgres, so it’s tested more, and just seems to be less problematic. We’re in the process of migrating from mysql to Postgres and after years of mysql and a large environment, it’s painful.

Check out the below on fixing psql collation issues

https://confluence.atlassian.com/confkb/how-to-fix-the-collation-of-a-postgres-confluence-database-966676071.html

CCM