Potential issue with min/max values

This could be something weird with my database, but I saw this when upgrading from 2.10 to 2.11 (latest Jenkins build)

  • ERROR 2013-04-20 13:20:46,142 HHH000388: Unsuccessful: alter table minmaxdataelement add column minimumvalue int4 not null (SchemaUpdate.java [localhost-startStop-1])

  • ERROR 2013-04-20 13:20:46,143 ERROR: column “minimumvalue” contains null values (SchemaUpdate.java [localhost-startStop-1])

  • ERROR 2013-04-20 13:20:46,147 HHH000388: Unsuccessful: alter table minmaxdataelement add column maximumvalue int4 not null (SchemaUpdate.java [localhost-startStop-1])

  • ERROR 2013-04-20 13:20:46,147 ERROR: column “maximumvalue” contains null values (SchemaUpdate.java [localhost-startStop-1])

Hi yes it is sort of intentional. It is supposed to happen only once and then be taken care of by a startup routine. We had to rename columns from minvalue -> minimumvalue and maxvalue -> maximumvalue to avoid reserved words on mysql. Can you restart and confirm whether it goes away?

Lars

···

On Sat, Apr 20, 2013 at 1:24 PM, Jason Pickering jason.p.pickering@gmail.com wrote:

This could be something weird with my database, but I saw this when upgrading from 2.10 to 2.11 (latest Jenkins build)

  • ERROR 2013-04-20 13:20:46,142 HHH000388: Unsuccessful: alter table minmaxdataelement add column minimumvalue int4 not null (SchemaUpdate.java [localhost-startStop-1])
  • ERROR 2013-04-20 13:20:46,143 ERROR: column “minimumvalue” contains null values (SchemaUpdate.java [localhost-startStop-1])
  • ERROR 2013-04-20 13:20:46,147 HHH000388: Unsuccessful: alter table minmaxdataelement add column maximumvalue int4 not null (SchemaUpdate.java [localhost-startStop-1])
  • ERROR 2013-04-20 13:20:46,147 ERROR: column “maximumvalue” contains null values (SchemaUpdate.java [localhost-startStop-1])

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

Yes, seems to go away on the next startup.

···

On Sat, Apr 20, 2013 at 6:25 PM, Lars Helge Øverland larshelge@gmail.com wrote:

Lars

Hi yes it is sort of intentional. It is supposed to happen only once and then be taken care of by a startup routine. We had to rename columns from minvalue → minimumvalue and maxvalue → maximumvalue to avoid reserved words on mysql. Can you restart and confirm whether it goes away?

On Sat, Apr 20, 2013 at 1:24 PM, Jason Pickering jason.p.pickering@gmail.com wrote:

This could be something weird with my database, but I saw this when upgrading from 2.10 to 2.11 (latest Jenkins build)

  • ERROR 2013-04-20 13:20:46,142 HHH000388: Unsuccessful: alter table minmaxdataelement add column minimumvalue int4 not null (SchemaUpdate.java [localhost-startStop-1])
  • ERROR 2013-04-20 13:20:46,143 ERROR: column “minimumvalue” contains null values (SchemaUpdate.java [localhost-startStop-1])
  • ERROR 2013-04-20 13:20:46,147 HHH000388: Unsuccessful: alter table minmaxdataelement add column maximumvalue int4 not null (SchemaUpdate.java [localhost-startStop-1])
  • ERROR 2013-04-20 13:20:46,147 ERROR: column “maximumvalue” contains null values (SchemaUpdate.java [localhost-startStop-1])

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

Good.

···

On Sat, Apr 20, 2013 at 6:25 PM, Lars Helge Øverland larshelge@gmail.com wrote:

Lars

Hi yes it is sort of intentional. It is supposed to happen only once and then be taken care of by a startup routine. We had to rename columns from minvalue -> minimumvalue and maxvalue -> maximumvalue to avoid reserved words on mysql. Can you restart and confirm whether it goes away?

On Sat, Apr 20, 2013 at 1:24 PM, Jason Pickering jason.p.pickering@gmail.com wrote:

This could be something weird with my database, but I saw this when upgrading from 2.10 to 2.11 (latest Jenkins build)

  • ERROR 2013-04-20 13:20:46,142 HHH000388: Unsuccessful: alter table minmaxdataelement add column minimumvalue int4 not null (SchemaUpdate.java [localhost-startStop-1])
  • ERROR 2013-04-20 13:20:46,143 ERROR: column “minimumvalue” contains null values (SchemaUpdate.java [localhost-startStop-1])
  • ERROR 2013-04-20 13:20:46,147 HHH000388: Unsuccessful: alter table minmaxdataelement add column maximumvalue int4 not null (SchemaUpdate.java [localhost-startStop-1])
  • ERROR 2013-04-20 13:20:46,147 ERROR: column “maximumvalue” contains null values (SchemaUpdate.java [localhost-startStop-1])

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