Bug 528822 - SQLException: Access denied for user sonar_rw
Summary: SQLException: Access denied for user sonar_rw
Status: CLOSED FIXED
Alias: None
Product: Community
Classification: Eclipse Foundation
Component: Sonar (show other bugs)
Version: unspecified   Edit
Hardware: PC Windows 10
: P3 major (vote)
Target Milestone: ---   Edit
Assignee: Generic Inbox CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-12-15 04:41 EST by Laurent Redor CLA
Modified: 2019-08-22 08:49 EDT (History)
3 users (show)

See Also:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Laurent Redor CLA 2017-12-15 04:41:04 EST
We created a Sonar job a long time (bug 464600), but not really monitored it. We try to re-enable it but we have an SQLException that seems link to the Sonar confifguration:

[ERROR] Failed to execute goal org.sonarsource.scanner.maven:sonar-maven-plugin:3.2:sonar (default-cli) on project sirius-parent: Fail to connect to database: Cannot create PoolableConnectionFactory (Could not create connection to database server. Attempted reconnect 3 times. Giving up.): Access denied for user 'sonar_rw'@'172.25.102.102' (using password: YES) -> [Help 1]
org.apache.maven.lifecycle.LifecycleExecutionException: Failed to execute goal org.sonarsource.scanner.maven:sonar-maven-plugin:3.2:sonar (default-cli) on project sirius-parent: Fail to connect to database
	at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:212)
...
Caused by: java.sql.SQLException: Access denied for user 'sonar_rw'@'172.25.102.102' (using password: YES)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078)
...

The complete error can be seen on the last job:  https://hudson.eclipse.org/sirius/view/All/job/sirius.sonar-master/658/consoleFull
Comment 1 Frederic Gurr CLA 2017-12-15 10:26:28 EST
Not sure why, but the Sonar password was missing.

I've added it and the Sonar call works again.

There is a OOM error though:
java.lang.OutOfMemoryError: GC overhead limit exceeded

Investigating now.
Comment 2 Laurent Redor CLA 2017-12-18 01:56:25 EST
OK thanks for the first fix.
For information, currently, for analysis, I've only enabled junit test (profile "junit"). In the end, there will be more (profile "junit,swtbot-sequence,swtbot-part1,swtbot-part2").
The OOM does not reassure me.
Comment 3 Laurent Redor CLA 2017-12-19 04:01:52 EST
The last job [1] finished as UNSTABLE (ie without OOM). For that, I replaced -Xmx3g by -Xmx4g.

It seems a lot to me for a project of the size of Sirius. Do you have other returns of this type?

There are many errors in the logs that amaze me:
1- ERROR - Fail to execute PMD. Following file is ignored: /path/Class.java
net.sourceforge.pmd.PMDException: Error while processing /path/Class.java
...
Caused by: java.lang.SecurityException: class "org.eclipse.core.runtime.IExecutableExtension" 's sign information does not match sign information of other classes in the same package

2- JaCoCoSensor: JaCoCo report not found : /home/hudson/genie.sirius/.hudson/jobs/sirius.sonar-master/workspace/plugins/org.eclipse.sirius.tests.rcptt.properties/target/jacoco.exec

3- 09:32:10.467 ERROR - Class not found: org.osgi.annotation.versioning.ConsumerType
09:32:10.468 ERROR - Class not found: org.osgi.annotation.versioning.ProviderType

4- ERROR - Reports path not found or is not a directory: /home/hudson/genie.sirius/.hudson/jobs/sirius.sonar-master/workspace/plugins/org.eclipse.sirius.ext.emf/target/surefire-reports
 --> It seems normal as there is no test in this plugin.

5- ERROR - Class not found: org.eclipse.sirius.ext.base.I18N
 --> This class is part of the Sirius source code.

6- WARN  - Class 'org/eclipse/sirius/diagram/ui/tools/api/part/IDiagramDialectGraphicalViewer' is not accessible through the ClassLoader.


Are all these kind of errors expected?


[1] https://hudson.eclipse.org/sirius/view/All/job/sirius.sonar-master/663/
Comment 4 Laurent Redor CLA 2017-12-19 04:44:18 EST
The same errors can be observed on other HIPP, but not all.

For Capella [1], I noticed the error kind 2 (but not for all plugins), 3, 4 but not 1, 2, 5 and 6.
For EMF-Compare [2], I noticed the error kinds 2 (but only once), 3, 4, 5 and 6 but not 1 and 2.


[1] https://hudson.polarsys.org/capella/view/Capella-master/job/capella-master-sonar
[2] https://hudson.eclipse.org/emfcompare/job/master-quality
Comment 5 Laurent Redor CLA 2017-12-19 08:04:30 EST
Another issue, bug 528950, has been created on Sirius side to try to resolve problems mentioned in comment 3.

The initial problem "SQLException: Access denied for user sonar_rw" is resolved. Fill free to close this issue, except if you prefer to analyze the OOM of comment 1 in this issue.

I'll also appreciate answers to the comment 3 if you have any.
Comment 6 Mikaël Barbero CLA 2019-08-22 08:49:17 EDT
My guess is that we're done here.