Andrea Patricelli created SYNCOPE-1482:
------------------------------------------
Summary: 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
Fix For: 2.0.14
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)
