linxd
(晓东 林)
10 September 2018 14:11
#1
hi,all
when I install a new fresh dhis2 ver 2.30, startup error:
Caused by: org.postgresql.util.PSQLException: ERROR: relation “programstageinstance” not exist
位置:22
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2422)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2167)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224)
at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:327)
at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:461)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:408)
… 159 more
···
–
此致
林晓东
莫愁前路无知己,天下谁人不识君。
Hi,
This is a confirmed issue, you can track the progress here: https://jira.dhis2.org/browse/DHIS2-4464
Best regards,
Lukas Wijgaart van Dijk
···
sep. 2018 kl. 16.11 skrev 林晓东 lin_xd@126.com :
hi,all
when I install a new fresh dhis2 ver 2.30, startup error:
Caused by: org.postgresql.util.PSQLException: ERROR: relation “programstageinstance” not exist
位置:22
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2422)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2167)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224)
at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:327)
at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:461)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:408)
… 159 more
–
此致
林晓东
莫愁前路无知己,天下谁人不识君。
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
bobj
(Bob Jolliffe)
10 September 2018 16:04
#3
I just made a quick comment on that issue.
The workaround is to to create the postgis extension manually in the
database and then restart the application server (tomcat), eg on
ubuntu:
echo "create extension if not exists postgis;" | sudo -u postgres psql dhis
···
On 10 September 2018 at 14:25, Lukas Wijgaart-van Dijk <lukasewvd@gmail.com > wrote:
Hi,
This is a confirmed issue, you can track the progress here:
https://jira.dhis2.org/browse/DHIS2-4464
Best regards,
Lukas Wijgaart van Dijk
10. sep. 2018 kl. 16.11 skrev 林晓东 <lin_xd@126.com >:
hi,all
when I install a new fresh dhis2 ver 2.30, startup error:
Caused by: org.postgresql.util.PSQLException: ERROR: relation
"programstageinstance" not exist
位置:22
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2422)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2167)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306)
at
org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
at
org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
at
org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
at
org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
at
org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224)
at
com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:327)
at
org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:461)
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:408)
... 159 more
--
此致
林晓东
莫愁前路无知己,天下谁人不识君。
_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp