{"id":16467,"date":"2020-07-21T16:14:37","date_gmt":"2020-07-21T16:14:37","guid":{"rendered":"https:\/\/www.devopsschool.com\/blog\/?p=16467"},"modified":"2021-10-30T06:05:47","modified_gmt":"2021-10-30T06:05:47","slug":"sonarqube-errors-and-database","status":"publish","type":"post","link":"https:\/\/www.devopsschool.com\/blog\/sonarqube-errors-and-database\/","title":{"rendered":"Sonarqube Errors and Database"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Error 1<\/h2>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-1\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\"><span class=\"hljs-number\">2020.07<\/span><span class=\"hljs-number\">.21<\/span> <span class=\"hljs-number\">15<\/span>:<span class=\"hljs-number\">08<\/span>:<span class=\"hljs-number\">24<\/span> INFO  es&#91;]&#91;o.e.t.TransportService] publish_address {<span class=\"hljs-number\">127.0<\/span><span class=\"hljs-number\">.0<\/span><span class=\"hljs-number\">.1<\/span>:<span class=\"hljs-number\">9001<\/span>}, bound_a\nddresses {<span class=\"hljs-number\">127.0<\/span><span class=\"hljs-number\">.0<\/span><span class=\"hljs-number\">.1<\/span>:<span class=\"hljs-number\">9001<\/span>}\n<span class=\"hljs-number\">2020.07<\/span><span class=\"hljs-number\">.21<\/span> <span class=\"hljs-number\">15<\/span>:<span class=\"hljs-number\">08<\/span>:<span class=\"hljs-number\">24<\/span> INFO  es&#91;]&#91;o.e.b.BootstrapChecks] explicitly enforcing bootstrap checks\n<span class=\"hljs-number\">2020.07<\/span><span class=\"hljs-number\">.21<\/span> <span class=\"hljs-number\">15<\/span>:<span class=\"hljs-number\">08<\/span>:<span class=\"hljs-number\">24<\/span> ERROR es&#91;]&#91;o.e.b.Bootstrap] node validation <span class=\"hljs-keyword\">exception<\/span>\n&#91;<span class=\"hljs-number\">1<\/span>] bootstrap checks failed\n&#91;<span class=\"hljs-number\">1<\/span>]: max file descriptors &#91;<span class=\"hljs-number\">4096<\/span>] <span class=\"hljs-keyword\">for<\/span> elasticsearch process is too low, increase to at least &#91;<span class=\"hljs-number\">655<\/span>\n<span class=\"hljs-number\">35<\/span>]\n<span class=\"hljs-number\">2020.07<\/span><span class=\"hljs-number\">.21<\/span> <span class=\"hljs-number\">15<\/span>:<span class=\"hljs-number\">08<\/span>:<span class=\"hljs-number\">24<\/span> INFO  es&#91;]&#91;o.e.n.Node] stopping ...\n<span class=\"hljs-number\">2020.07<\/span><span class=\"hljs-number\">.21<\/span> <span class=\"hljs-number\">15<\/span>:<span class=\"hljs-number\">08<\/span>:<span class=\"hljs-number\">24<\/span> INFO  es&#91;]&#91;o.e.n.Node] stopped\n<span class=\"hljs-number\">2020.07<\/span><span class=\"hljs-number\">.21<\/span> <span class=\"hljs-number\">15<\/span>:<span class=\"hljs-number\">08<\/span>:<span class=\"hljs-number\">24<\/span> INFO  es&#91;]&#91;o.e.n.Node] closing ...\n<span class=\"hljs-number\">2020.07<\/span><span class=\"hljs-number\">.21<\/span> <span class=\"hljs-number\">15<\/span>:<span class=\"hljs-number\">08<\/span>:<span class=\"hljs-number\">24<\/span> INFO  es&#91;]&#91;o.e.n.Node] closed\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-1\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<h2 class=\"wp-block-heading\">Solution 1<\/h2>\n\n\n\n<ol class=\"wp-block-list\"><li>https:\/\/www.devopsschool.com\/blog\/elastic-search-error-max-virtual-memory-areas-vm-max_map_count-65530-is-too-low-increase-to-at-least-262144\/<\/li><li>https:\/\/www.devopsschool.com\/blog\/elastic-search-error-max-file-descriptors-4096-for-elasticsearch-process-is-too-low-increase-to-at-least-65535\/<\/li><\/ol>\n\n\n\n<h2 class=\"wp-block-heading\">Error 2<\/h2>\n\n\n<pre class=\"wp-block-code\"><span><code class=\"hljs\">&#91;centos@ip-172-31-13-50 logs]$ more web.log | grep -i error\n2020.07.21 15:47:00 ERROR web&#91;]&#91;o.s.s.p.PlatformImpl] Web server startup failed\nCaused by: org.postgresql.util.PSQLException: ERROR: no schema has been selected to create in\n        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2532)\n&#91;centos@ip-172-31-13-50 logs]$<\/code><\/span><\/pre>\n\n\n<h2 class=\"wp-block-heading\">Solution 2:<\/h2>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-2\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\"><span class=\"hljs-comment\">#sonar.jdbc.url=jdbc:postgresql:\/\/localhost\/sonarqube?currentSchema=my_schema<\/span>\nTO\nsonar.jdbc.url=jdbc:postgresql:<span class=\"hljs-comment\">\/\/localhost\/sonarqube<\/span>\n\nWhere <span class=\"hljs-string\">\"sonarqube\"<\/span> is a name of the DB.<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-2\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>SonarQube Tutorial &amp; OWASP SonarQube Tutorial Securing Code (SAST) Crash Course:- https:\/\/bit.ly\/3x5ZOmA<\/p>\n\n\n<div class=\"epyt-gallery\" data-currpage=\"1\" id=\"epyt_gallery_89229\"><iframe loading=\"lazy\"  id=\"_ytid_65972\"  width=\"760\" height=\"427\"  data-origwidth=\"760\" data-origheight=\"427\" src=\"https:\/\/www.youtube.com\/embed\/?enablejsapi=1&#038;autoplay=0&#038;cc_load_policy=0&#038;cc_lang_pref=&#038;iv_load_policy=1&#038;loop=0&#038;rel=1&#038;fs=1&#038;playsinline=0&#038;autohide=2&#038;theme=dark&#038;color=red&#038;controls=1&#038;disablekb=0&#038;\" class=\"__youtube_prefs__  no-lazyload\" title=\"YouTube player\"  data-epytgalleryid=\"epyt_gallery_89229\"  allow=\"fullscreen; accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen data-no-lazy=\"1\" data-skipgform_ajax_framebjll=\"\"><\/iframe><div class=\"epyt-gallery-list\"><div>Sorry, there was a YouTube error.<\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>Error 1 Solution 1 https:\/\/www.devopsschool.com\/blog\/elastic-search-error-max-virtual-memory-areas-vm-max_map_count-65530-is-too-low-increase-to-at-least-262144\/ https:\/\/www.devopsschool.com\/blog\/elastic-search-error-max-file-descriptors-4096-for-elasticsearch-process-is-too-low-increase-to-at-least-65535\/ Error 2 Solution 2: SonarQube Tutorial &amp; OWASP SonarQube Tutorial Securing Code (SAST) Crash Course:- https:\/\/bit.ly\/3x5ZOmA<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_joinchat":[],"footnotes":""},"categories":[1],"tags":[],"class_list":["post-16467","post","type-post","status-publish","format-standard","hentry","category-sql"],"_links":{"self":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/16467","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/comments?post=16467"}],"version-history":[{"count":3,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/16467\/revisions"}],"predecessor-version":[{"id":24652,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/16467\/revisions\/24652"}],"wp:attachment":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/media?parent=16467"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/categories?post=16467"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/tags?post=16467"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}