Postgres error

Sonatype Nexus Repository
,
1

I recently rebuilt my Nexus Repo Manager server for my home lab. I’m running this on CentOS 9 w/ the latest nexus.
I’m trying to migrate from H2 to PostgreSQL 17.

I’m currently getting this in the logs

Caused by: org.postgresql.util.PSQLException: ERROR: no schema has been selected to create in
  Position: 28
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2725)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2412)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:371)
	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:502)
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:419)
	at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:194)
	at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:180)
	at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
	at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:48)
	at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:75)
	at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50)
	at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
	at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
	at org.sonatype.nexus.datastore.mybatis.EntityExecutor.update(EntityExecutor.java:74)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:197)
	at org.sonatype.nexus.datastore.mybatis.DataAccessSqlSession.update(DataAccessSqlSession.java:83)
	... 62 common frames omitted

Here is the contents of my nexus-store.properties

password=$PASSWORD
jdbcUrl=jdbc\:postgresql\://$IP.AD.DR.ESS\:5432/sonatype?tcpKeepAlive\=true&advanced\=maximumPoolSize\=200&maxLifetime\=840000&currentSchema\=sonatype
maximumPoolSize=200
maxLifetime=840000
username=$USERNAME

nexus_log_errors.zip (34.7 KB)
Here is more of the errors.

2

Your JDBC URL has a misplaced parameter. Move currentSchema=sonatype before others like this:

ini

CopyEdit

jdbcUrl=jdbc:postgresql://$IP.AD.DR.ESS:5432/sonatype?currentSchema=sonatype&tcpKeepAlive=true

Also ensure the sonatype schema exists and your user has access to it.

1 Like