Hi Gregory,
1) Yes, I added this line. Thanks.
2) I think what I can't convert the all data in my instance Jira.
Because
============================================
Instance health checks
Error
The database collation 'utf8_general_ci' and table collation 'utf8_general_ci' are not supported by JIRA.
=============================================
But in System Info -
System Encoding | UTF-8 |
Database collation utf8_bin
What encoding for MySQL DB you recommend for the new versions of Jira 7.5.x?
Hi Gregory,
1) I can't found string line <pool-test-on-borrow>false</pool-test-on-borrow> in the dbconfig.xml.
Only line <pool-test-while-idle>true</pool-test-while-idle>
2) I try run all sql scripts with youre note
And in propertys System Info -
System Encoding | UTF-8 |
Database collation utf8_bin
But in the Instance health checks
Error
Checks if the database and tables are configured using the required collation.
The database collation 'utf8_general_ci' and table collation 'utf8_general_ci' are not supported by JIRA.
Don't understand why ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Go ahead and add the line in to the dbconfig file. I believe in a clean build instance that line is included, but on an upgrade instance it may not be or may not have been noticed until the Atlassian tools did a better job detecting config issues.
Collation determines how results are sorted and ordered. In newer versions of Atlassian applications, collation changes may become more strict. This means, you may be able to get away with the collation notification currently, but in future updates Atlassian is likely expecting collation to be setup in a specific way to ensure consistent and expected results.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes, I replace parameter storage_engine on the default_storage_engine:
sessionVariables=default_storage_engine=InnoDB
But now the "pool-test-on-borrow" database configuration is not configured according to the recommended parameters.
And I have other error - Methods for sorting databases "utf8_general_ci" and tables "utf8_general_ci" are not supported by JIRA.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Correct, Add <pool-test-on-borrow>false</pool-test-on-borrow> line in the dbconfig.xml when instance with MySQL database is created.
did you fix the collation of the database?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The connection URL in your dbconfig.xml
file contains the storage_engine
parameter, which has been deprecated. This should be replaced with the default_storage_engine
parameter.
See our documentation for more information on changing your connection URL.
Your mysql database is currently using an unsupported collation: utf8_general_ci. You should change this to a supported collation:
Review our documentation for more information on supported collations.
THIS IS Critical message or I can ignore it and continue?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
you want to convert your database to the correct format. See documentation here
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Also, yes - adjust the dbconfig xml as suggested. Add default infront of storage_engine so it reads default_storage_engine.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I Can't found file dbconfig.xml...This file locate in /opt/atlassian/jira or /var/atlassian/application-data/jira directory?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
it's located at the root of your Jira Home directory.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
As Brian said, yup - go for it. Just watch the https connector - it got us, but it's well documented in the release notes.
Make sure you experiment with a staging copy of your production before you move your actual prod. That will save you some heartburn.
The overall process, start to finish, can take you somewhere between 12-16 hours depending on how long full indexing takes you after you upgrade.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi!
You can update directly from 7.1.9 to 7.5.
You will want to review all of the release notes as well as upgrade notes for all versions that you will be skipping though. This way no changes surprise you.
Jira Release and Upgrade Notes
The main items to look for are the HTTPS connector change in 7.3 and the Microsoft SQL Server database driver change in 7.5.
Hope that helps!
Best regards,
Brian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.