← Back to team overview

dhis2-users team mailing list archive

Re: Avoid database errors during first bootstrap

 

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@xxxxxxxxx>
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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>

References