Databases
StackOverflow2013
Postsdbo
POSonar 3.5.1/sonar-runner 2.2 fails with BadDatabaseVersion
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSonar 3.5.1/sonar-runner 2.2 fails with BadDatabaseVersion
    text
    copied!<p>I have installed Sonar 3.5.1 on a brand new PostgreSQL 9.2 database. The server seems to run fine, but sonar-runner (v2.2) fails with the following error:</p> <pre><code>Caused by: org.sonar.core.persistence.BadDatabaseVersion: The current batch process and the configured remote server do not share the same DB configuration. - Batch side: jdbc:postgresql://10.1.0.210/sonar (postgres / *****) - Server side: check the configuration at http://sonar.kopitoto/system </code></pre> <p>I am pretty confident that there is no other concurrent installation of Sonar pointing to the same database, because:</p> <ul> <li>This is the first Sonar installation in this organization, ever</li> <li>The value of <code>sonar.core.id</code> in the DB matches the value returned by the Sonar server:</li> </ul> <p>Getting the value from the DB:</p> <pre><code>sonar=# SELECT text_value FROM properties WHERE prop_key = 'sonar.core.id'; text_value ---------------- 20130525192736 (1 row) </code></pre> <p>Getting the value from the server:</p> <pre><code>$ curl http://sonar.kopitoto/api/server &lt;?xml version="1.0" encoding="UTF-8"?&gt; &lt;server&gt; &lt;id&gt;20130525192736&lt;/id&gt; &lt;version&gt;3.5.1&lt;/version&gt; &lt;status&gt;UP&lt;/status&gt; &lt;/server&gt; </code></pre> <p>Sonar-runner's properties:</p> <pre><code>sonar.host.url: http://sonar.kopitoto sonar.jdbc.driverClassName: org.postgresql.Driver sonar.jdbc.password: ***** sonar.jdbc.schema: public sonar.jdbc.url: jdbc:postgresql://10.1.0.210/sonar sonar.jdbc.username: postgres </code></pre> <p>Of course, the password is not five stars, but I checked it twice. If I change it a little bit, the runner fails earlier with authentication error. So a password mismatch is ruled out.</p> <p>Server's <code>sonar.properties</code>:</p> <pre><code>sonar.jdbc.username: postgres sonar.jdbc.password: ***** sonar.jdbc.url: jdbc:postgresql://10.1.0.210/sonar sonar.jdbc.driverClassName: org.postgresql.Driver sonar.jdbc.schema: public </code></pre> <p>Again, the password above is not five stars, but I am pretty sure it is correct. The server logs say nothing about errors, and shows how the database schema is initialized when I stop the thing, drop the database, create an empty one, and then start the Sonar server again.</p> <p>Am I missing something?</p> <p>At this point, I am thinking that this is a bug in Sonar (probably in sonar-runner). Unfortunately, Sonar's issue-tracking system is littered with such reports, all closed with "Not a bug" resolution. I guess I will be dismissed similarly if I reopen one of those issues.</p> <p>So I hope I am really missing something here.</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload