ERROR: Failed to upload report - 500: An error has occurred. Please contact your administrator

[LnT]

Hi,

in Vertual machine 'A' - installed jenkins master 2.20 and SonarQube6.5.   
in Virutual Machine 'B' - installed  MySQL5.7.

SonarQube run as windows service and I see sonarqube default tables populated in MySQL DB.
Tried to run sonarqube scanned on source code files (js) from jenkins. Size of source code is about 30MB.

please find below tail log of SonarQube scanner

 ================================================================================

 INFO: CPD calculation finished

 INFO: Analysis report generated in 96690ms, dir size=108 MB

 INFO: Analysis reports compressed in 43993ms, zip size=34 MB

 INFO: ------------------------------------------------------------------------

 INFO: EXECUTION FAILURE

 INFO: ------------------------------------------------------------------------

 INFO: Total time: 11:42.237s

 INFO: Final Memory: 58M/1288M

 INFO: ------------------------------------------------------------------------

 ERROR: Error during SonarQube Scanner execution

 ERROR: Failed to upload report - 500: An error has occurred. Please contact your administrator

 ERROR:

 ERROR: Re-run SonarQube Scanner using the -X switch to enable full debug logging.

 ERROR: SonarQube scanner exited with non-zero code: 1

 ================================================================================

I tried to increase max_allowed_packets in MySQL server

Before increase, max_allowed_packet value is like below

 ====================================================

 mysql> Select @@global.max_allowed_packet;

 +-----------------------------+

 | @@global.max_allowed_packet |

 +-----------------------------+

 |                     4194304 |

 +-----------------------------+

 1 row in set (0.00 sec)

 ====================================================

 

Updated F:\mysql\my.ini file in mysql server. Restarted Mysql server and sonarqube as well.

After increase, max_allowed_packet value is like below

 ====================================================

 mysql> Select @@global.max_allowed_packet;

 +-----------------------------+

 | @@global.max_allowed_packet |

 +-----------------------------+

 |                     4194304 |

 +-----------------------------+

 1 row in set (0.00 sec)

 ====================================================

I dont see max_allowed_packet value is getting changed.

Please help.

Regards,
LnT 

[Daniel Schwarz]

Dear LnT,

The scanner logs says:

 ERROR: Failed to upload report - 500: An error has occurred. Please contact your administrator

If we are lucky, we might find something interesting in the server's web.log. Could you please check, whether there is something special in there, and if so, paste that log lines here?

Thanks!

Daniel

--
You received this message because you are subscribed to the Google Groups "SonarQube" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sonarqube+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/sonarqube/4f1372fa-2668-45c1-bf30-d7ef2f80ec51%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Daniel Schwarz | SonarSource

Developer

https://sonarsource.com

[LnT]

Hi Daniel,

I'm happy to share. PFA web.log

Regards,

Lnt

[Daniel Schwarz]

Hi Lnt,

To me it seems to be a MySQL administration question. I've little knowledge in that area.

However I found a Stackoverflow with people facing similar issues:

* https://stackoverflow.com/questions/8062496/how-to-change-max-allowed-packet-size

* especially this answer sound promising: https://stackoverflow.com/a/32840664/476791

Did you add the max_allowed_packet setting inside your [mysqld] section in you my.ini? Please double check, that this my.ini is used by your MySQL instance.

Cheers

Daniel

To view this discussion on the web visit https://groups.google.com/d/msgid/sonarqube/a9491fdd-e19a-4109-8f03-0629913296c3%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

[LnT]

Dear Daniel,

  yes , added the max_allowed_packet setting inside your [mysqld] section in you my.ini

  PFA

  I'm also novice w.r.t MySQL  :-(

Regards,

LnT

[Daniel Schwarz]

Hi LnT,

I'm only guessing, but could you maybe give this a try:

- - - - - - - - - - - - - - - - 8< - -

[mysqld]

basedir=F:\\mysql

datadir=F:\\mydata\\data

bind-address=127.0.0.1

max_allowed_packet=128M

explicit_defaults_for_timestamp=TRUE

- - >8 - - - - - - - - - - - - - - - -

The MySQL documentation for trouble shooting uses the "...M" notation: https://dev.mysql.com/doc/refman/5.6/en/packet-too-large.html

The property's documentations on the other hand states, that non-multiples of 1024 numbers will be rounded down: https://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_max_allowed_packet

Did you double check, that the my.ini file you update is the one, used by your running mysql instance? (you could for example rename that file and check, whether mysql complains about it during startup)

Cheers

Daniel

To view this discussion on the web visit https://groups.google.com/d/msgid/sonarqube/5dd7b50c-389c-4698-84b2-faad9229341d%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

[LnT]

Sorry Daniel. My Bad.

I found right my.ini file @ C:\ProgramData\MySQL\MySQL Server 5.7.

Its working now.... :)

[Daniel Schwarz]

No problem :) - I'm glad I could help!

Cheers

Daniel

To view this discussion on the web visit https://groups.google.com/d/msgid/sonarqube/821dbbbc-1568-48bf-9b9b-95640809f398%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.