Could not create connection to database server.Attempted reconnect 3 times. Giving up.

[chuan huang]

I upgraded my JIRA and MySQL

jira - from 7.2.x to 8.1.1

mysql - from 5.1.x to 5.7.26 (local)

bugzilla mysql - 5.1.x (Remote database，not change)

when I try to import bugs from bugzilla,there's error msg on the website:Could not create connection to database server.Attempted reconnect 3 times. Giving up.

(while I have succeeded before upgrade）

there's two warning msg in the catalina.out

Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.

com.sun.jersey.spi.container.servlet.WebComponent.filterFormParameters A servlet request, to the URI http://10.46.100.110:8080/rest/activity-stream/1.0/preferences?_=1558602953230, contains form parameters in the request body but the request body has been consumed by the servlet or a servlet filter accessing the request parameters. Only resource methods using @FormParam will work as expected. Resource methods consuming the request body by other means will not work as expected.

however,i'm not sure if these warnings relate to the bug

how to resolve it? or where can I find more info?

[Jakub Sławiński]

Hi @chuan huang

can you post the full log? Can you verify that you can connect to your database via command line?

[chuan huang]

I have resolved these warnings，but the error still exist.this time I clear the sys-init log and there are no added log when I failed connect to bugzilla database.
I have succeeded connect with 7.2.15(jira) and 7.1.8(Jira Importers Plugin)in the same machine
I'm using version 8.2.1 JIRA downloaded from the official website, and the plug-in is also included in the installation package.
Do I need to modify some configuration files? or can I find the Jira Importers Plugin log in somewhere?

[chuan huang]

thank u for anwser me.
I have resolved these warnings，but the error still exist.this time I clear the sys-init log and there are no added log when I failed connect to bugzilla database.
I have succeeded connect with 7.2.15(jira) and 7.1.8(Jira Importers Plugin)in the same machine
I'm using version 8.2.1 JIRA downloaded from the official website, and the plug-in is also included in the installation package.
Do I need to modify some configuration files? or can I find the Jira Importers Plugin log in somewhere?