View Issue Details

IDProjectCategoryView StatusLast Update
0003424SymmetricDSBugpublic2019-04-24 17:34
Reporterjflambert Assigned To 
Prioritynormal 
Status newResolutionopen 
Summary0003424: Unable to uninstall SymmetricDS PostgreSQL node when using dedicated schema
Descriptionsymadmin uninstall fails when PostgreSQL node is on a dedicated schema (instead of public).
Steps To ReproduceInstall SymmetricDS "staging" node to a dedicated sym_schema schema (as per official documentation). Here is staging.properties:

external.id=staging
engine.name=staging
group.id=staging
sync.url=http\://localhost\:31415/sync/staging
db.url=jdbc\:postgresql\://localhost/nserver?protocolVersion\=2&stringtype\=unspecified&socketTimeout\=300&tcpKeepAlive\=true
db.driver=org.postgresql.Driver
db.user=sym_user
auto.registration=true
registration.url=
db.init.sql=
db.validation.query=select 1
db.password=XXXXXXXXXxxx
db.connection.properties=


Confirm that table sym_parameter table does exist under sym_schema.

Attempt to uninstall SymmetricDS node, an exception will be raised.

root@newtrax78:/opt/symmetric-server-3.9.3/bin# ./symadmin --engine staging uninstall
SLF4J: The following set of substitute loggers may have been accessed
SLF4J: during the initialization phase. Logging calls during this
SLF4J: phase were not honored. However, subsequent logging calls to these
SLF4J: loggers will work as normally expected.
SLF4J: See also http://www.slf4j.org/codes.html#substituteLogger
SLF4J: org.jumpmind.symmetric.AbstractSymmetricEngine
Log output will be written to /var/log/newtrax/symmetric.log
[] - AbstractCommandLauncher - Option: name=engine, value={staging}
[staging] - AbstractSymmetricEngine - Initializing connection to database
[staging] - JdbcDatabasePlatformFactory - Detected database 'PostgreSQL', version '9', protocol 'postgresql'
[staging] - JdbcDatabasePlatformFactory - The IDatabasePlatform being used is org.jumpmind.db.platform.postgresql.PostgreSqlDatabasePlatform
[staging] - ParameterService - Could not read database parameters and they have not yet been initialized
[staging] - AbstractSymmetricEngine - Stopping SymmetricDS externalId=staging version=3.9.3 database=?
-------------------------------------------------------------------------------
An exception occurred. Please see the following for details:
-------------------------------------------------------------------------------
org.postgresql.util.PSQLException: ERROR: relation "sym_parameter" does not exist
  Position: 36
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2455)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2155)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:288)
    at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:430)
    at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:356)
    at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:168)
    at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:116)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
    at org.jumpmind.db.sql.JdbcSqlReadCursor.<init>(JdbcSqlReadCursor.java:97)
 [wrapped] org.jumpmind.db.sql.SqlException: Failed to execute sql: select param_key, param_value from sym_parameter where external_id=? and node_group_id=?
    at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:300)
    at org.jumpmind.db.sql.JdbcSqlReadCursor.<init>(JdbcSqlReadCursor.java:120)
    at org.jumpmind.db.sql.JdbcSqlTemplate.queryForCursor(JdbcSqlTemplate.java:140)
    at org.jumpmind.db.sql.AbstractSqlTemplate.query(AbstractSqlTemplate.java:199)
    at org.jumpmind.db.sql.AbstractSqlTemplate.query(AbstractSqlTemplate.java:195)
    at org.jumpmind.db.sql.AbstractSqlTemplate.query(AbstractSqlTemplate.java:185)
    at org.jumpmind.db.sql.AbstractSqlTemplate.query(AbstractSqlTemplate.java:121)
    at org.jumpmind.symmetric.service.impl.ParameterService.readParametersFromDatabase(ParameterService.java:156)
    at org.jumpmind.symmetric.service.impl.ParameterService.getDatabaseParameters(ParameterService.java:198)
    at org.jumpmind.symmetric.service.impl.AbstractParameterService.rereadDatabaseParameters(AbstractParameterService.java:282)
    at org.jumpmind.symmetric.service.impl.ParameterService.rereadApplicationParameters(ParameterService.java:181)
    at org.jumpmind.symmetric.service.impl.AbstractParameterService.getParameters(AbstractParameterService.java:167)
    at org.jumpmind.symmetric.service.impl.AbstractParameterService.rereadParameters(AbstractParameterService.java:156)
    at org.jumpmind.symmetric.AbstractSymmetricEngine.init(AbstractSymmetricEngine.java:320)
    at org.jumpmind.symmetric.ClientSymmetricEngine.init(ClientSymmetricEngine.java:202)
    at org.jumpmind.symmetric.ClientSymmetricEngine.<init>(ClientSymmetricEngine.java:148)
    at org.jumpmind.symmetric.ClientSymmetricEngine.<init>(ClientSymmetricEngine.java:152)
    at org.jumpmind.symmetric.AbstractCommandLauncher.getSymmetricEngine(AbstractCommandLauncher.java:389)
    at org.jumpmind.symmetric.AbstractCommandLauncher.getSymmetricEngine(AbstractCommandLauncher.java:381)
    at org.jumpmind.symmetric.SymmetricAdmin.uninstall(SymmetricAdmin.java:569)
    at org.jumpmind.symmetric.SymmetricAdmin.executeWithOptions(SymmetricAdmin.java:335)
    at org.jumpmind.symmetric.AbstractCommandLauncher.execute(AbstractCommandLauncher.java:194)
    at org.jumpmind.symmetric.SymmetricAdmin.main(SymmetricAdmin.java:144)
-------------------------------------------------------------------------------
Additional InformationMay be related to issue 0003418

Adding "&currentSchema\=sym_schema" to db.url allows uninstall to proceed.
Tagsdialect: postgresql, install

Activities

jflambert

2018-02-14 18:23

reporter   ~0001128

Using 3.9.3

Issue History

Date Modified Username Field Change
2018-02-14 18:22 jflambert New Issue
2018-02-14 18:22 jflambert Tag Attached: postgresql
2018-02-14 18:23 jflambert Note Added: 0001128
2019-04-23 20:50 admin Tag Renamed postgresql => dialect: postgresql
2019-04-24 17:34 elong Tag Attached: install