You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@syncope.apache.org by "Francesco Chicchiriccò (Jira)" <ji...@apache.org> on 2019/09/02 10:02:00 UTC
[jira] [Closed] (SYNCOPE-1482) Tables not found errors when
initializing PostgreSQL database
[ https://issues.apache.org/jira/browse/SYNCOPE-1482?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Francesco Chicchiriccò closed SYNCOPE-1482.
-------------------------------------------
> Tables not found errors when initializing PostgreSQL database
> -------------------------------------------------------------
>
> Key: SYNCOPE-1482
> URL: https://issues.apache.org/jira/browse/SYNCOPE-1482
> Project: Syncope
> Issue Type: Bug
> Components: core
> Affects Versions: 2.0.13
> Reporter: Andrea Patricelli
> Priority: Minor
>
> Start Syncope with PostgreSQL as DBMS and empty database and look at PostgreSQL logs. You'll se something like this
> {code:java}
> | 2019-08-30 13:00:07.420 UTC [67] ERROR: relation "qrtz_scheduler_state" does not exist at character 22
> db-pg_1 | 2019-08-30 13:00:07.420 UTC [67] STATEMENT: SELECT COUNT(0) FROM QRTZ_SCHEDULER_STATE
> db-pg_1 | 2019-08-30 13:00:07.906 UTC [67] WARNING: there is no transaction in progress
> db-pg_1 | 2019-08-30 13:00:08.536 UTC [67] ERROR: relation "act" does not exist
> db-pg_1 | 2019-08-30 13:00:08.536 UTC [67] STATEMENT: SELECT pg_get_serial_sequence($1, $2)
> db-pg_1 | 2019-08-30 13:00:08.537 UTC [67] ERROR: relation "act_evt" does not exist
> db-pg_1 | 2019-08-30 13:00:08.537 UTC [67] STATEMENT: SELECT pg_get_serial_sequence($1, $2)
> db-pg_1 | 2019-08-30 13:00:08.538 UTC [67] ERROR: column "log_nr" of relation "act_evt_log" does not exist
> db-pg_1 | 2019-08-30 13:00:08.538 UTC [67] STATEMENT: SELECT pg_get_serial_sequence($1, $2)
> db-pg_1 | 2019-08-30 13:00:08.539 UTC [67] ERROR: relation "act_evt_log_log" does not exist
> db-pg_1 | 2019-08-30 13:00:08.539 UTC [67] STATEMENT: SELECT pg_get_serial_sequence($1, $2)
> db-pg_1 | 2019-08-30 13:00:08.544 UTC [67] ERROR: relation "act" does not exist
> db-pg_1 | 2019-08-30 13:00:08.544 UTC [67] STATEMENT: SELECT pg_get_serial_sequence($1, $2)
> db-pg_1 | 2019-08-30 13:00:08.545 UTC [67] ERROR: relation "act_evt" does not exist
> db-pg_1 | 2019-08-30 13:00:08.545 UTC [67] STATEMENT: SELECT pg_get_serial_sequence($1, $2)
> db-pg_1 | 2019-08-30 13:00:08.545 UTC [67] ERROR: column "log_nr" of relation "act_evt_log" does not exist
> db-pg_1 | 2019-08-30 13:00:08.545 UTC [67] STATEMENT: SELECT pg_get_serial_sequence($1, $2)
> db-pg_1 | 2019-08-30 13:00:08.546 UTC [67] ERROR: relation "act_evt_log_log" does not exist{code}
--
This message was sent by Atlassian Jira
(v8.3.2#803003)