2.16 Postgres Errors, First Startup vs Second

Support - Assistance technique
1

Hello Developers! Thank you again for the help in getting 2.16 running in our test environment. I had some additional questions about myriad Postgres errors I’m seeing both on the first startup and subsequent startups. The document found here: https://www.dhis2.org/216-upgrade said there would be some errors that would show up on the first startup, but I’m seeing even more the 2nd time. I’ve included the entire log file as an attachment to this email, I did some quick analysis below though. Note that none of these errors boiled up to Catalina.out, I found them in the Postgres log files. Also note that even though I am seeing these errors, I am still able to use 2.16.

1st startup:

Beginning around Step [4 of 14, runlevel 3]: TrackerIdentityPopulator and going until step [14 of 14, runlevel 9]: I18nLocalePopulator I’m seeing about

399 Postgres errors

  • 67 of ERROR: relation “[^ ]*” already exists$

  • 3 of ERROR: relation “[^ ]*” does not exist$

  • 3 of ERROR: relation "[^ ]" does not exist at character [0-9]$

  • 62 of ERROR: table “[^ ]*” does not exist$

  • 149 of ERROR: column “[^ ]" of relation "[^ ]” does not exist$

  • 3 of ERROR: column “[^ ]" of relation "[^ ]” already exists$

  • 8 of ERROR: column “[^ ]*” does not exist$

  • 59 of ERROR: column "[^ ]" does not exist at character [0-9]$

  • 29 of ERROR: constraint “[^ ]" of relation "[^ ]” does not exist$

  • 2 of ERROR: index “[^ ]*” does not exist$

  • 6 of ERROR: cannot alter type of a column used by a view or rule

And several more 1 off errors

2nd startup

Beginning and ending in the same spots

414 Postgres errors

  • 70 of ERROR: relation “[^ ]*” already exists$

  • 3 of ERROR: relation “[^ ]*” does not exist$

  • 3 of ERROR: relation "[^ ]" does not exist at character [0-9]$

  • 63 of ERROR: table “[^ ]*” does not exist$

  • 154 of ERROR: column “[^ ]" of relation "[^ ]” does not exist$

  • 3 of ERROR: column “[^ ]" of relation "[^ ]” already exists$

  • 8 of ERROR: column “[^ ]*” does not exist$

  • 65 of ERROR: column "[^ ]" does not exist at character [0-9]$

  • 29 of ERROR: constraint “[^ ]" of relation "[^ ]” does not exist$

  • 2 of ERROR: index “[^ ]*” does not exist$

  • 6 of ERROR: cannot alter type of a column used by a view or rule

And several more 1 off errors

Timothy Harding
PeaceCorps Volunteer

Republic of Vanuatu

hardingt@gmail.com

+678 5955137

2.16 FirstvsSecondStartup.txt (155 KB)