Upgrade Sonar 9.9 LTS access.log

Amish_Gupta · April 8, 2023, 6:06pm

Make sure to tell us:

What version are you upgrading from? 8.9
System information (Operating system, Java version, Database provider/version) -Linux 3.10.0-1160.83.1.el7.x86_64 x86_64 x86_64 x86_64 GNU/Linux
What’s the issue you’re facing?
we upgraded Sonar from 8.9 LTS to 9.9 LTS . we are using same DB and application is up and running after upgrading DB.
However, access.log is still keep writing logs since last more then 18 hrs. DB size is 1.7 TB with 73M LOCs .

access.log looks like this

10.229.172.11 - - [08/Apr/2023:18:03:53 +0000] "GET /api/components/show?component=com.ge.hc.ifabric:configuration-provider-lib-cpp&branch=master HTTP/1.1" 200 - "-" "curl/7.47.0" "AYdhKbwYoVr1LLtsAKKO"
10.229.172.11 - - [08/Apr/2023:18:03:53 +0000] "GET / HTTP/1.1" 200 - "-" "Go-http-client/1.1" "AYdhKbwYoVr1LLtsAKKP"
10.229.172.11 - - [08/Apr/2023:18:03:53 +0000] "GET /api/measures/component?metricKeys=tests,coverage,line_coverage,branch_coverage,bugs,code_smells&componentKey=com.ge.hc.ifabric:configuration-provider-lib-cpp&branch=master HTTP/1.1" 400 - "-" "curl/7.47.0" "AYdhKbwYoVr1LLtsAKKQ"
10.229.172.11 - - [08/Apr/2023:18:03:54 +0000] "GET /api/developers/search_events?projects=com.ge.med.mr.mruiappng2%3Amruiappng2&from=2023-04-07T13%3A03%3A43-0500 HTTP/1.1" 401 - "-" "SonarLint VSCode 3.12.0" "AYdhKbwYoVr1LLtsAKKS"
10.229.172.11 - - [08/Apr/2023:18:03:54 +0000] "GET /api/components/show?component=mvc-toolkit&branch=master HTTP/1.1" 404 - "-" "curl/7.47.0" "AYdhKbwYoVr1LLtsAKKT"
10.229.172.11 - - [08/Apr/2023:18:03:55 +0000] "GET /api/measures/component?metricKeys=tests,coverage,line_coverage,branch_coverage,bugs,code_smells&componentKey=mvc-toolkit&branch=master HTTP/1.1" 400 - "-" "curl/7.47.0" "AYdhKbwYoVr1LLtsAKKU"
10.229.172.11 - - [08/Apr/2023:18:03:55 +0000] "GET /api/developers/search_events?projects=com.ge.med.mr.physics%3Aphysics&from=2023-04-07T13%3A03%3A54-0500 HTTP/1.1" 200 - "-" "SonarLint IntelliJ 8.1.0.65508" "AYdhKbwYoVr1LLtsAKKR"
10.229.172.11 - - [08/Apr/2023:18:03:55 +0000] "GET /api/components/show?component=TBD&branch=master HTTP/1.1" 404 - "-" "curl/7.47.0" "AYdhKbwYoVr1LLtsAKKV"
10.229.172.11 - - [08/Apr/2023:18:03:56 +0000] "GET /api/measures/component?metricKeys=tests,coverage,line_coverage,branch_coverage,bugs,code_smells&componentKey=TBD&branch=master HTTP/1.1" 400 - "-" "curl/7.47.0" "AYdhKbwYoVr1LLtsAKKW"
10.229.172.11 - - [08/Apr/2023:18:03:57 +0000] "GET /api/components/show?component=TBD&branch=master HTTP/1.1" 404 - "-" "curl/7.47.0" "AYdhKbwYoVr1LLtsAKKX"
10.177.218.204 - - [08/Apr/2023:18:03:57 +0000] "GET / HTTP/1.1" 200 - "-" "Statping" "AYdhKbwYoVr1LLtsAKKY"
10.229.172.11 - - [08/Apr/2023:18:03:57 +0000] "GET /api/developers/search_events?projects=com.ge.med.mr.mruiapp%3Amruiapp&from=2023-04-07T13%3A03%3A50-0500 HTTP/1.1" 401 - "-" "SonarLint VSCode 3.7.0" "AYdhKbwYoVr1LLtsAKKZ"
10.229.172.11 - - [08/Apr/2023:18:03:57 +0000] "GET /api/measures/component?metricKeys=tests,coverage,line_coverage,branch_coverage,bugs,code_smells&componentKey=TBD&branch=master HTTP/1.1" 400 - "-" "curl/7.47.0" "AYdhKbwYoVr1LLtsAKKa"
10.229.172.11 - - [08/Apr/2023:18:03:58 +0000] "GET /api/developers/search_events?projects=com.ge.med.mr.mruiappng2%3Amruiappng2&from=2023-04-07T23%3A33%3A47%2B0530 HTTP/1.1" 401 - "-" "SonarLint VSCode 3.13.0" "AYdhKbwYoVr1LLtsAKKb"
10.229.172.11 - - [08/Apr/2023:18:03:58 +0000] "GET /api/components/show?component=TBD&branch=master HTTP/1.1" 404 - "-" "curl/7.47.0" "AYdhKbwYoVr1LLtsAKKc"
10.229.172.11 - - [08/Apr/2023:18:03:58 +0000] "GET /api/developers/search_events?projects=com.ge.med.mr.mruiappng2%3Amruiappng2&from=2023-04-08T16%3A18%3A56%2B0000 HTTP/1.1" 200 - "-" "SonarLint VSCode" "AYdhKbwYoVr1LLtsAKKd"
^C
[root@h13928-2 logs]# uname -a

ganncamp · April 10, 2023, 2:41pm

Hi,

I don’t understand the question.

Ann

Amish_Gupta · April 10, 2023, 4:36pm

Please look at the logs. Its keep generating from last 3 days . unstoppable.
Sonar is up and running but access logs are growing since we migrated from 8.9 to 9.9 and there is no scans running

ganncamp · April 10, 2023, 4:38pm

Hi,

It looks like there’s a script making requests against your instance?

Ann

Amish_Gupta · April 10, 2023, 4:50pm

i am not aware of any such script running as this is fresh new upgrade

ganncamp · April 10, 2023, 5:17pm

Hi,

You probably want to track down the IP address in the logs. This is not coming from us.

Ann

Amish_Gupta · April 10, 2023, 7:02pm

i updated the parameter reqAttribute in Sonar.properties file and now i can see a Login id in logs… Here are some latest logs

10.229.172.11 - - [10/Apr/2023:19:02:09 +0000] “GET /api/developers/search_events?projects=commandcenter%3Acom.ge.woa.adventhealth%3Apatient-manager&from=2023-04-09T14%3A02%3A09-0500 HTTP/1.1” 200 - “-” “SonarLint IntelliJ 7.0.0.52289” “AYdsKycmfwI8Ni0QAHmx” “212762186”
10.229.172.11 - - [10/Apr/2023:19:02:09 +0000] “GET /api/developers/search_events?projects=commandcenter%3Acom.ge.woa.adventhealth%3Afeeds-processor&from=2023-04-09T14%3A02%3A09-0500 HTTP/1.1” 200 - “-” “SonarLint IntelliJ 7.0.0.52289” “AYdsKycmfwI8Ni0QAHmy” “212762186”
10.229.172.11 - - [10/Apr/2023:19:02:10 +0000] “GET /api/components/show?component=TBD&branch=master HTTP/1.1” 404 - “-” “curl/7.47.0” “AYdsKycmfwI8Ni0QAHmz” “100029950”
10.229.172.11 - - [10/Apr/2023:19:02:10 +0000] “GET /api/measures/component?metricKeys=tests,coverage,line_coverage,branch_coverage,bugs,code_smells&componentKey=TBD&branch=master HTTP/1.1” 400 - “-” “curl/7.47.0” “AYdsKycmfwI8Ni0QAHm0” “100029950”
10.229.172.11 - - [10/Apr/2023:19:02:11 +0000] “GET /api/developers/search_events?projects=com.ge.med.mr.mruiappng2%3Amruiappng2&from=2023-04-10T18%3A20%3A38%2B0000 HTTP/1.1” 200 - “-” “SonarLint VSCode” “AYdsKycmfwI8Ni0QAHm1” “503241177”
10.229.172.11 - - [10/Apr/2023:19:02:11 +0000] “GET /api/components/show?component=TBD&branch=master HTTP/1.1” 404 - “-” “curl/7.47.0” “AYdsKycmfwI8Ni0QAHm2” “100029950”
10.229.172.11 - - [10/Apr/2023:19:02:11 +0000] “GET /api/developers/search_events?projects=com.ge.med.mr.mruiappng2%3Amruiappng2&from=2023-04-10T18%3A20%3A38%2B0000 HTTP/1.1” 200 - “-” “SonarLint VSCode” “AYdsKycmfwI8Ni0QAHm3” “503241177”
10.229.172.11 - - [10/Apr/2023:19:02:11 +0000] “GET /api/developers/search_events?projects=com.ge.med.mr.mruiappng2%3Amruiappng2&from=2023-04-10T00%3A32%3A00%2B0530 HTTP/1.1” 401 - “-” “SonarLint VSCode 3.13.0” “AYdsKycmfwI8Ni0QAHm4” “-”
10.229.172.11 - - [10/Apr/2023:19:02:12 +0000] “GET /api/measures/component?metricKeys=tests,coverage,line_coverage,branch_coverage,bugs,code_smells&componentKey=TBD&branch=master HTTP/1.1” 400 - “-” “curl/7.47.0” “AYdsKycmfwI8Ni0QAHm5” “100029950”
10.229.172.11 - - [10/Apr/2023:19:02:12 +0000] “GET /api/developers/search_events?projects=com.ge.med.mr.mruiappng2%3Amruiappng2&from=2023-04-10T17%3A04%3A11%2B0530 HTTP/1.1” 401 - “-” “SonarLint VSCode 3.10.0” “AYdsKycmfwI8Ni0QAHm6” “-”
10.229.172.11 - - [10/Apr/2023:19:02:12 +0000] “GET /api/components/show?component=TBD&branch=master HTTP/1.1” 404 - “-” “curl/7.47.0” “AYdsKycmfwI8Ni0QAHm7” “100029950”
10.229.172.11 - - [10/Apr/2023:19:02:13 +0000] “GET /api/developers/search_events?projects=com.ge.med.mr.mruiappng2%3Amruiappng2&from=2023-04-10T00%3A32%3A01%2B0530 HTTP/1.1” 401 - “-” “SonarLint VSCode 3.13.0” “AYdsKycmfwI8Ni0QAHm8” “-”
10.229.172.11 - - [10/Apr/2023:19:02:13 +0000] “GET /api/measures/component?metricKeys=tests,coverage,line_coverage,branch_coverage,bugs,code_smells&componentKey=TBD&branch=master HTTP/1.1” 400 - “-” “curl/7.47.0” “AYdsKycmfwI8Ni0QAHm9” “100029950”
10.229.172.11 - - [10/Apr/2023:19:02:14 +0000] “GET /api/developers/search_events?projects=com.ge.med.mr.mruiappng2%3Amruiappng2&from=2023-04-09T14%3A02%3A13-0500 HTTP/1.1” 401 - “-” “SonarLint VSCode 3.12.0” “AYdsKycmfwI8Ni0QAHm+” “-”
10.229.172.11 - - [10/Apr/2023:19:02:14 +0000] “GET /api/components/show?component=TBD&branch=master HTTP/1.1” 404 - “-” “curl/7.47.0” “AYdsKycmfwI8Ni0QAHm/” “100029950”
10.229.172.11 - - [10/Apr/2023:19:02:15 +0000] “GET / HTTP/1.1” 200 - “-” “Go-http-client/1.1” “AYdsKycmfwI8Ni0QAHnA” “-”
10.229.172.11 - - [10/Apr/2023:19:02:15 +0000] “GET /api/measures/component?metricKeys=tests,coverage,line_coverage,branch_coverage,bugs,code_smells&componentKey=TBD&branch=master HTTP/1.1” 400 - “-” “curl/7.47.0” “AYdsKycmfwI8Ni0QAHnB” “100029950”
10.229.172.11 - - [10/Apr/2023:19:02:15 +0000] “GET /api/components/show?component=TBD&branch=master HTTP/1.1” 404 - “-” “curl/7.47.0” “AYdsKycmfwI8Ni0QAHnC” “100029950”
10.229.172.11 - - [10/Apr/2023:19:02:15 +0000] “GET / HTTP/1.1” 200 - “-” “Go-http-client/1.1” “AYdsKycmfwI8Ni0QAHnD” “-”
10.229.172.11 - - [10/Apr/2023:19:02:16 +0000] “GET /api/measures/component?metricKeys=tests,coverage,line_coverage,branch_coverage,bugs,code_smells&componentKey=TBD&branch=master HTTP/1.1” 400 - “-” “curl/7.47.0” “AYdsKycmfwI8Ni0QAHnE” “100029950”
10.229.172.11 - - [10/Apr/2023:19:02:17 +0000] “GET /api/components/show?component=TBD&branch=master HTTP/1.1” 404 - “-” “curl/7.47.0” “AYdsKycmfwI8Ni0QAHnF” “100029950”
10.229.172.11 - - [10/Apr/2023:19:02:17 +0000] “GET /api/measures/component?metricKeys=tests,coverage,line_coverage,branch_coverage,bugs,code_smells&componentKey=TBD&branch=master HTTP/1.1” 400 - “-” “curl/7.47.0” “AYdsKycmfwI8Ni0QAHnG” “100029950”

Can you please analyze these and suggest what could best solution ?

ganncamp · April 11, 2023, 12:02pm

Hi,

That’s helpful.

Can you have your SonarLint users upgrade to the latest version? For IntelliJ, that’s 8.1.0.65508.

Ann