Problem with my.ini recognition between confluence and mysql 5.7 connection

[Yunju Jung]

Hello, l'm yunju.

l've done the installation via confluence and linking with mysql5.7.

I'll share the configuration environment once.

There are 5 total servers, JIRA / Confluence / Bitbucket / Crowd / DB Server.

Currently there are no errors on Jira, Bitbucket, Crowd, and only on Confluence.

I do not seem to recognize my.ini,  

innodb_log_file_size = 2048M

max_allowed_packet = 256M

-----------------------------------------------------------------

The currently configured my.ini looks like this:

[mysqld]
basedir=C:/Program Files/mysql
datadir=C:/Program Files/mysql/data
port=3306

character-set-server=utf8
default-storage-engine=INNODB
collation-server=utf8_bin
transaction-isolation = READ-COMMITTED
innodb_lock_wait_timeout = 500
innodb_log_file_size=2048M
max_allowed_packet=256M
max_connections=1024
max_connect_errors=1000000

------------------------------------------------------------------

I can not find these two values. So if you go to trouble shooting, it will not load. I'll attach the log and capture bones.

Please do it soon.

Thank u

The currently configured atlassian-confluence.log looks like this:

----------------------------------------------------------------------------------

2019-05-15 14:34:28,306 INFO [http-nio-8090-exec-2] [confluence.importexport.actions.ImportLongRunningTask] runInternal Beginning import by user admin
2019-05-15 14:34:28,637 WARN [http-nio-8090-exec-2] [confluence.importexport.xmlimport.DeferredOperations] reportOutstandingOperations Uncompleted deferred operations waiting for:[class = com.atlassian.confluence.user.ConfluenceUserImpl, id = ]
-- referer: http://localhost:8090/welcome.action | url: /rest/onboarding/1/space | traceId: 617a0bb308108ee7 | userName: admin
2019-05-15 14:34:28,638 WARN [http-nio-8090-exec-2] [confluence.importexport.xmlimport.DeferredOperations] reportOutstandingOperations Set property lastModifier on class = com.atlassian.confluence.spaces.Space, id = 2228225 to class = com.atlassian.confluence.user.ConfluenceUserImpl, id =
-- referer: http://localhost:8090/welcome.action | url: /rest/onboarding/1/space | traceId: 617a0bb308108ee7 | userName: admin
2019-05-15 14:34:28,639 WARN [http-nio-8090-exec-2] [confluence.importexport.xmlimport.DeferredOperations] reportOutstandingOperations Set property creator on class = com.atlassian.confluence.spaces.Space, id = 2228225 to class = com.atlassian.confluence.user.ConfluenceUserImpl, id =
-- referer: http://localhost:8090/welcome.action | url: /rest/onboarding/1/space | traceId: 617a0bb308108ee7 | userName: admin
2019-05-15 14:34:28,809 INFO [http-nio-8090-exec-2] [confluence.importexport.actions.ImportLongRunningTask] runInternal Finished import.
2019-05-15 14:35:35,140 INFO [synchrony-interop-executor:thread-1] [plugins.synchrony.bootstrap.DefaultSynchronyProcessManager] lambda$stop$9 Stopping Synchrony...
2019-05-15 14:35:35,157 INFO [ListenableFutureAdapter-thread-3] [plugins.synchrony.bootstrap.DefaultSynchronyProcessManager] startup Starting Synchrony and enabling Collaborative Editing
2019-05-15 14:35:35,158 WARN [http-nio-8090-exec-5] [confluence.util.profiling.DurationThresholdWarningTimingHelperFactory] logMessage Execution time for publishing event com.atlassian.confluence.event.events.admin.GlobalSettingsChangedEvent[source=com.atlassian.confluence.admin.actions.GeneralConfigurationAction@b22e8d2] took 24583 ms (warning threshold is 5000 ms)
-- referer: http://localhost:8090/admin/editgeneralconfig.action | url: /admin/doeditgeneralconfig.action | traceId: d15b098f6c02c442 | userName: admin | action: doeditgeneralconfig
2019-05-15 14:35:35,167 INFO [329:StdOutHandler [E:\atlassian\confluence\jre\bin\java.exe]] [plugins.synchrony.bootstrap.DefaultSynchronyProcessManager] startup Starting Synchrony and enabling Collaborative Editing
2019-05-15 14:35:35,407 INFO [synchrony-interop-executor:thread-1] [plugins.synchrony.bootstrap.DefaultSynchronyProcessManager] isSynchronyProxyEnabled proxy port present: false
2019-05-15 14:35:35,407 INFO [synchrony-interop-executor:thread-3] [plugins.synchrony.bootstrap.DefaultSynchronyProcessManager] isSynchronyProxyEnabled proxy port present: false
2019-05-15 14:35:35,407 INFO [synchrony-interop-executor:thread-1] [plugins.synchrony.bootstrap.DefaultSynchronyProcessManager] isSynchronyProxyEnabled app config synchrony.proxy.enabled: true
2019-05-15 14:35:35,407 INFO [synchrony-interop-executor:thread-3] [plugins.synchrony.bootstrap.DefaultSynchronyProcessManager] isSynchronyProxyEnabled app config synchrony.proxy.enabled: true
2019-05-15 14:35:35,620 INFO [synchrony-interop-executor:thread-3] [plugins.synchrony.bootstrap.DefaultSynchronyProcessManager] debugPrintEnvironment Synchrony working dir: E:\atlassian\application-data\confluence
2019-05-15 14:35:35,620 INFO [synchrony-interop-executor:thread-1] [plugins.synchrony.bootstrap.DefaultSynchronyProcessManager] debugPrintEnvironment Synchrony working dir: E:\atlassian\application-data\confluence
2019-05-15 14:35:35,620 INFO [synchrony-interop-executor:thread-1] [plugins.synchrony.bootstrap.DefaultSynchronyProcessManager] debugPrintEnvironment E:\atlassian\confluence\jre\bin\java.exe -classpath E:\atlassian\confluence\temp\2.1.0-master-9d112c9d.jar;E:\atlassian\confluence\lib\mysql-connector-java-5.1.47-bin.jar -Xss2048k -Xmx1g synchrony.core sql
2019-05-15 14:35:35,620 INFO [synchrony-interop-executor:thread-3] [plugins.synchrony.bootstrap.DefaultSynchronyProcessManager] debugPrintEnvironment E:\atlassian\confluence\jre\bin\java.exe -classpath E:\atlassian\confluence\temp\2.1.0-master-9d112c9d.jar;E:\atlassian\confluence\lib\mysql-connector-java-5.1.47-bin.jar -Xss2048k -Xmx1g synchrony.core sql
2019-05-15 14:35:35,871 INFO [ListenableFutureAdapter-thread-3] [plugins.synchrony.bootstrap.DefaultSynchronyProcessManager] isSynchronyProxyEnabled proxy port present: false
2019-05-15 14:35:35,871 INFO [ListenableFutureAdapter-thread-3] [plugins.synchrony.bootstrap.DefaultSynchronyProcessManager] isSynchronyProxyEnabled app config synchrony.proxy.enabled: true
2019-05-15 14:35:35,878 INFO [ListenableFutureAdapter-thread-3] [plugins.synchrony.bootstrap.DefaultSynchronyProcessManager] updateSynchronyConfiguration Synchrony External Base URL: http://confluence.kaonmedia.com:8090/synchrony-proxy,http://confluence.kaonmedia.com:8090/synchrony-proxy
2019-05-15 14:35:35,878 INFO [ListenableFutureAdapter-thread-3] [plugins.synchrony.bootstrap.DefaultSynchronyProcessManager] updateSynchronyConfiguration Synchrony External Service URL: http://confluence.kaonmedia.com:8090/synchrony-proxy/v1
2019-05-15 14:35:35,878 INFO [ListenableFutureAdapter-thread-3] [plugins.synchrony.bootstrap.DefaultSynchronyProcessManager] updateSynchronyConfiguration Synchrony Internal Service URL: http://127.0.0.1:8091/synchrony/v1
2019-05-15 14:35:36,489 ERROR [http-nio-8090-exec-1] [atlassian.troubleshooting.confluence.ConfluenceApplicationInfo] addSynchronyConfiguration com.atlassian.confluence.core.ConfluenceSystemProperties.isSynchronyProxyEnabled()
-- referer: http://confluence.kaonmedia.com:8090/plugins/servlet/troubleshooting/view?source=notification&healthCheck=maxAllowedPacketsCheck | url: /plugins/servlet/troubleshooting/view/atst-detect-issues/view | traceId: e2ae8f326b806dd3 | userName: admin
2019-05-15 14:35:36,496 ERROR [http-nio-8090-exec-1] [confluence.status.service.DefaultSystemInformationService] getModifications
-- referer: http://confluence.kaonmedia.com:8090/plugins/servlet/troubleshooting/view?source=notification&healthCheck=maxAllowedPacketsCheck | url: /plugins/servlet/troubleshooting/view/atst-detect-issues/view | traceId: e2ae8f326b806dd3 | userName: admin
2019-05-15 14:35:43,969 WARN [ListenableFutureAdapter-thread-3] [plugins.synchrony.config.DefaultSynchronyConfigurationManager] enableSharedDrafts [Collab editing plugin] Enabling Shared Drafts
-- referer: http://localhost:8090/admin/editgeneralconfig.action | url: /admin/doeditgeneralconfig.action | traceId: d15b098f6c02c442 | userName: admin | action: doeditgeneralconfig
2019-05-15 14:36:39,905 WARN [http-nio-8090-exec-5] [atlassian.upm.pac.PacClientImpl] getUpdates The request to check for add-on updates may take longer than expected because 200 user-installed add-ons are installed. This may impact the performance of loading the Manage Add-ons page.
-- referer: http://confluence.kaonmedia.com:8090/plugins/servlet/upm | url: /rest/plugins/1.0/installed-marketplace | traceId: 0f0f090707d6c20b | userName: admin
2019-05-15 14:36:53,178 ERROR [http-nio-8090-exec-8] [atlassian.troubleshooting.confluence.ConfluenceApplicationInfo] addSynchronyConfiguration com.atlassian.confluence.core.ConfluenceSystemProperties.isSynchronyProxyEnabled()
-- referer: http://confluence.kaonmedia.com:8090/plugins/servlet/troubleshooting/view/ | url: /plugins/servlet/troubleshooting/view/atst-detect-issues/view | traceId: 25cb699fcba17ca2 | userName: admin
2019-05-15 14:36:53,182 ERROR [http-nio-8090-exec-8] [confluence.status.service.DefaultSystemInformationService] getModifications
-- referer: http://confluence.kaonmedia.com:8090/plugins/servlet/troubleshooting/view/ | url: /plugins/servlet/troubleshooting/view/atst-detect-issues/view | traceId: 25cb699fcba17ca2 | userName: admin
2019-05-15 14:38:31,416 WARN [Caesium-1-1] [impl.schedule.caesium.JobRunnerWrapper] runJob Scheduled job LaasPerformanceLoggingJob#LaasPerformanceLoggingJob completed unsuccessfully with response JobRunnerResponse[runOutcome=ABORTED,message='LaaS performance logging is turned off']
-- referer: http://localhost:8090/setup/setupdata-start.action | url: /setup/setupdata.action | traceId: de89a12461f859fb | userName: anonymous | action: setupdata
2019-05-15 14:42:49,132 ERROR [http-nio-8090-exec-9] [atlassian.troubleshooting.confluence.ConfluenceApplicationInfo] addSynchronyConfiguration com.atlassian.confluence.core.ConfluenceSystemProperties.isSynchronyProxyEnabled()
-- referer: http://confluence.kaonmedia.com:8090/plugins/servlet/troubleshooting/view?source=notification&healthCheck=innoDBLogFileSizeCheck | url: /plugins/servlet/troubleshooting/view/atst-detect-issues/view | traceId: 143b3b6873b3d7e0 | userName: admin
2019-05-15 14:43:31,414 WARN [Caesium-1-1] [impl.schedule.caesium.JobRunnerWrapper] runJob Scheduled job LaasPerformanceLoggingJob#LaasPerformanceLoggingJob completed unsuccessfully with response JobRunnerResponse[runOutcome=ABORTED,message='LaaS performance logging is turned off']
-- referer: http://localhost:8090/setup/setupdata-start.action | url: /setup/setupdata.action | traceId: de89a12461f859fb | userName: anonymous | action: setupdata
2019-05-15 14:44:44,452 ERROR [http-nio-8090-exec-2] [atlassian.troubleshooting.confluence.ConfluenceApplicationInfo] addSynchronyConfiguration com.atlassian.confluence.core.ConfluenceSystemProperties.isSynchronyProxyEnabled()
-- referer: http://confluence.kaonmedia.com:8090/plugins/servlet/troubleshooting/view/ | url: /plugins/servlet/troubleshooting/view/atst-detect-issues/view | traceId: 940e9fbe70f5a5ea | userName: admin
2019-05-15 14:48:31,414 WARN [Caesium-1-1] [impl.schedule.caesium.JobRunnerWrapper] runJob Scheduled job LaasPerformanceLoggingJob#LaasPerformanceLoggingJob completed unsuccessfully with response JobRunnerResponse[runOutcome=ABORTED,message='LaaS performance logging is turned off']
-- referer: http://localhost:8090/setup/setupdata-start.action | url: /setup/setupdata.action | traceId: de89a12461f859fb | userName: anonymous | action: setupdata
2019-05-15 14:53:31,415 WARN [Caesium-1-3] [impl.schedule.caesium.JobRunnerWrapper] runJob Scheduled job LaasPerformanceLoggingJob#LaasPerformanceLoggingJob completed unsuccessfully with response JobRunnerResponse[runOutcome=ABORTED,message='LaaS performance logging is turned off']
-- referer: http://localhost:8090/setup/setupdata-start.action | url: /setup/setupdata.action | traceId: de89a12461f859fb | userName: anonymous | action: setupdata

----------------------------------------------------------------------------------

[Andrew · Accepted solution]

Hi @Yunju Jung ,

Did You restart DB after change parameters? 

Maybe exist my.cnf with other parameters?

Look also here https://confluence.atlassian.com/confkb/exceeds-max-allowed-packet-for-mysql-179443425.html

B.R.

[Yunju Jung]

Currently running os is window.

And after applying the parameters, I restarted it again because I did not restart it and reinstalled it.

I applied and applied the URL I sent, but my.ini is already applied

mysqld --max_allowed_packet = 256M in the shell. I also restarted the Confluence service. But the problem of trouble shooting still seems to be. Is there any other solution?

[Andrew]

Hi @Yunju Jung ,

I misunderstand, the problem resolved or not? 
You mark question as resolved but ask other solution. :-)

B.R..

[Yunju Jung]

Sorry for the confusion :(

The problem's not resolve yet.

Troubled shooting, like capturing, shows that loading is not complete.

[Andrew]

Not sure You correct added parameter in console.

Where placed your my.ini? For example I have C:\my.ini and C:\my.cnf.

my.ini should be equal to my.cnf. And then try restart service.

B.R.

[Andrew]

C:\..>mysqld --max_allowed_packet = 256M

I'm afraid than it run mysqld.exe process, but 'net stop mysql' might not stop process. 

I recommend use only one way to run mysql: 'service' or 'cmd'.
For example I use only 'cmd':

Could You please check process.

B.R.

[Yunju Jung]

hi @Andrew 

Thank you so much It was a simple matter, but it worked out well.

really really Thanks!!:)