server-start fails due to missing relations

14 views

Skip to first unread message

unread,

Dec 23, 2018, 10:00:30 AM12/23/18

to schedulix

OS: CentOS7.6 ppc64le

DB: PostgreSQL 11.1

Schedulix source downloaded with git from github

server-start fails with missing relations:

logfile snippet

ERROR [Thread-2] 21 Dec 2018 13:10:17 GMT SQL Error : ERROR: relation "trigger_parameter" does not exist

Position: 137

ERROR [Thread-2] 21 Dec 2018 13:10:17 GMT ****************** Start Stacktrace *********************

ERROR [Thread-2] 21 Dec 2018 13:10:17 GMT de.independit.scheduler.server.util.SDMSThread.doTrace(SDMSThread.java:168)

ERROR [Thread-2] 21 Dec 2018 13:10:17 GMT de.independit.scheduler.server.exception.FatalException.<init>(FatalException.java:50)

ERROR [Thread-2] 21 Dec 2018 13:10:17 GMT de.independit.scheduler.server.repository.TableLoader.SDMSrun(SDMSRepository.java:435)

ERROR [Thread-2] 21 Dec 2018 13:10:17 GMT de.independit.scheduler.server.util.SDMSThread.run(SDMSThread.java:225)

ERROR [Thread-2] 21 Dec 2018 13:10:17 GMT ****************** End Stacktrace *********************

and

ERROR [Thread-1] 21 Dec 2018 13:10:17 GMT SQL Error : ERROR: relation "interval_dispatcher" does not exist

Position: 161

ERROR [Thread-1] 21 Dec 2018 13:10:17 GMT ****************** Start Stacktrace *********************

ERROR [Thread-1] 21 Dec 2018 13:10:17 GMT de.independit.scheduler.server.util.SDMSThread.doTrace(SDMSThread.java:168)

ERROR [Thread-1] 21 Dec 2018 13:10:17 GMT de.independit.scheduler.server.exception.FatalException.<init>(FatalException.java:50)

ERROR [Thread-1] 21 Dec 2018 13:10:17 GMT de.independit.scheduler.server.repository.TableLoader.SDMSrun(SDMSRepository.java:435)

ERROR [Thread-1] 21 Dec 2018 13:10:17 GMT de.independit.scheduler.server.util.SDMSThread.run(SDMSThread.java:225)

ERROR [Thread-1] 21 Dec 2018 13:10:17 GMT ****************** End Stacktrace ********************

It turns out that files TRIGGER_PARAMETER.sql and INTERVAL_DISPATCHER.sql are not installed with install.sql, because they're missing in this file.

So add following lines to install.sql:

\i pg_gen/INTERVAL_DISPATCHER.sql

\i pg_gen/TRIGGER_PARAMETER.sql

unread,

Dec 24, 2018, 1:15:22 AM12/24/18

to schedulix

Hi Edwin,

oops, sorry about this.

I'll fix that immediately. Thank you for reporting!

Happy X-Mas days!

Best regards,

Ronald

Reply all

Reply to author

Forward

0 new messages