Avoid database errors during first bootstrap

Support - Assistance technique
1

Hi,

does anyone know the best way to get rid of the following errors during the first bootstrap?

db_1 | 2015-02-25 23:43:37 UTC [728-1] dhis@dhis2 ERROR: column "bounds" of relation "mapview" does not exist db_1 | 2015-02-25 23:43:37 UTC [728-2] dhis@dhis2 STATEMENT: alter table mapview drop column bounds db_1 | 2015-02-25 23:43:37 UTC [729-1] dhis@dhis2 ERROR: column "code" of relation "mapview" does not exist db_1 | 2015-02-25 23:43:37 UTC [729-2] dhis@dhis2 STATEMENT: alter table mapview drop column code db_1 | 2015-02-25 23:43:37 UTC [730-1] dhis@dhis2 ERROR: column "periodtypeid" of relation "mapview" does not exist db_1 | 2015-02-25 23:43:37 UTC [730-2] dhis@dhis2 STATEMENT: alter table mapview drop column periodtypeid db_1 | 2015-02-25 23:43:37 UTC [732-1] dhis@dhis2 ERROR: column "valuetype" does not exist at character 50 db_1 | 2015-02-25 23:43:37 UTC [732-2] dhis@dhis2 STATEMENT: update mapview set valuetype='dataElement' where valuetype='dataelement' db_1 | 2015-02-25 23:43:37 UTC [735-1] dhis@dhis2 ERROR: column "name" does not exist at character 19 db_1 | 2015-02-25 23:43:37 UTC [735-2] dhis@dhis2 STATEMENT: select mapviewid, name, userid, longitude, latitude, zoom from mapview where mapviewid not in (select mapviewid from mapmapviews)

Regards,

···

Paulo Grácio

https://github.com/pgracio/dhis2-docker

2

Hi Paulo,

these are part of the table update statements that the system runs on startup, they are designed to fail after the first time so nothing we can do about it right now, you can safely ignore it.

regards,

Lars

···

On Sat, Apr 25, 2015 at 11:31 AM, Paulo Grácio paulogracio@gmail.com wrote:

Hi,

does anyone know the best way to get rid of the following errors during the first bootstrap?

db_1 | 2015-02-25 23:43:37 UTC [728-1] dhis@dhis2 ERROR: column "bounds" of relation "mapview" does not exist db_1 | 2015-02-25 23:43:37 UTC [728-2] dhis@dhis2 STATEMENT: alter table mapview drop column bounds db_1 | 2015-02-25 23:43:37 UTC [729-1] dhis@dhis2 ERROR: column "code" of relation "mapview" does not exist db_1 | 2015-02-25 23:43:37 UTC [729-2] dhis@dhis2 STATEMENT: alter table mapview drop column code db_1 | 2015-02-25 23:43:37 UTC [730-1] dhis@dhis2 ERROR: column "periodtypeid" of relation "mapview" does not exist db_1 | 2015-02-25 23:43:37 UTC [730-2] dhis@dhis2 STATEMENT: alter table mapview drop column periodtypeid db_1 | 2015-02-25 23:43:37 UTC [732-1] dhis@dhis2 ERROR: column "valuetype" does not exist at character 50 db_1 | 2015-02-25 23:43:37 UTC [732-2] dhis@dhis2 STATEMENT: update mapview set valuetype='dataElement' where valuetype='dataelement' db_1 | 2015-02-25 23:43:37 UTC [735-1] dhis@dhis2 ERROR: column "name" does not exist at character 19 db_1 | 2015-02-25 23:43:37 UTC [735-2] dhis@dhis2 STATEMENT: select mapviewid, name, userid, longitude, latitude, zoom from mapview where mapviewid not in (select mapviewid from mapmapviews)

Regards,

Paulo Grácio

https://github.com/pgracio/dhis2-docker

–

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp