thingsboard: Upgrade from version 2.4.3 to 2.5 error
Hello! I have 2.4.3 CE version installation and tried to upgrade to 2.5 but running upgrade.sh throws an error:
Upgrading ThingsBoard from version 2.4.3 to 2.5 ...
Check the current PostgreSQL version...
PostgreSQL version is valid!
Load upgrade functions ...
Functions successfully loaded!
Updating timeseries schema ...
Failed to execute query: call create_partition_ts_kv_table() due to: ERROR: no existe la restricción «ts_kv_pkey» para la tabla «ts_kv_old»
Where: sentencia SQL: «ALTER TABLE ts_kv_old
RENAME CONSTRAINT ts_kv_pkey TO ts_kv_pkey_old»
función PL/pgSQL create_partition_ts_kv_table() en la línea 6 en sentencia SQL
Unexpected error during ThingsBoard installation!
java.lang.RuntimeException: Failed to execute query:call create_partition_ts_kv_table() due to:
at org.thingsboard.server.service.install.AbstractSqlTsDatabaseUpgradeService.executeQuery(AbstractSqlTsDatabaseUpgradeService.java:113)
at org.thingsboard.server.service.install.PsqlTsDatabaseUpgradeService.upgradeDatabase(PsqlTsDatabaseUpgradeService.java:93)
at org.thingsboard.server.install.ThingsboardInstallService.performInstall(ThingsboardInstallService.java:139)
at org.thingsboard.server.ThingsboardInstallApplication.main(ThingsboardInstallApplication.java:43)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:48)
at org.springframework.boot.loader.Launcher.launch(Launcher.java:87)
at org.springframework.boot.loader.Launcher.launch(Launcher.java:51)
at org.springframework.boot.loader.PropertiesLauncher.main(PropertiesLauncher.java:597)
Caused by: org.postgresql.util.PSQLException: ERROR: no existe la restricción «ts_kv_pkey» para la tabla «ts_kv_old»
Where: sentencia SQL: «ALTER TABLE ts_kv_old
RENAME CONSTRAINT ts_kv_pkey TO ts_kv_pkey_old»
función PL/pgSQL create_partition_ts_kv_table() en la línea 6 en sentencia SQL
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.PgStatement.executeWithFlags(PgStatement.java:303)
at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:289)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:266)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:262)
at org.thingsboard.server.service.install.AbstractSqlTsDatabaseUpgradeService.executeQuery(AbstractSqlTsDatabaseUpgradeService.java:99)
... 11 common frames omitted
Unexpected error during ThingsBoard installation!
ThingsBoard upgrade failed!
The machine had Postgres 9.6 installed and before upgrading to TB2.5 I’ve followed the instructions to upgrade Postgres to v11 and his cluster.
About this issue
- Original URL
- State: closed
- Created 4 years ago
- Comments: 17 (15 by maintainers)
Hi @ShvaykaD! First I’ve checked tables to be dropped have NO data, and checked ts_kv_old exists with old data. As @ashvayka says this can lead to people executing wrong commands and delete their telemetries.
After renaming and dropping the tables, upgrade script went perfectly and now installation is working.
Thank you for your great support and great software