[
https://issues.apache.org/jira/browse/SYNCOPE-1482?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Andrea Patricelli resolved SYNCOPE-1482.
----------------------------------------
Resolution: Not A Problem
Exceptions reported are harmless and do not affect quartz and Activiti/Flowable
functionalities.
> 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
> 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)
