Hi Jason That looks like the same script Tim says he has applied. Must be something else.
@Tim all those postgres processes represent the pool of connections between dhis and postgres. The pool parameters are fixed somewhere deep in the webapp but I think you can expect the default is going between something like 10(min) and 40(max). Postgres is traditionally multi-process rather than multi-threaded - a bit slower in terms of context switching but very stable. One crazy thread can't bring down the server process. Bob On 8 October 2014 01:08, Jason Pickering <jason.p.picker...@gmail.com> wrote: > Hi Tim, > You may want to look here for the necessary upgrade script. > > > http://www.dhis2.org/download/resources/sql/rename-patient-to-trackedentity.sql > > Regards, > Jason > On Oct 7, 2014 7:41 PM, "Timothy Harding" <hardi...@gmail.com> wrote: > >> Hello Developer's Group >> >> I'm now working on migrating from 2.14 to 2.16 in our test environment >> and the startup for tomcat is hanging on step 7. I've included some >> relevant snippets of logs below and have attached the full logs: >> >> - stdout.txt = Standard out during importing the DHIS2 2.14 database, >> running the upgrade script, and starting tomcat) >> - catalina.out = The tomcat log for the latest attempt to start up >> 2.16 >> >> My Notes: >> I can boot up 2.14 with the database dump without problem >> I can boot up 2.16 with a *blank* database without problem (it creates >> the live environment i.e. admin:district) >> The problem occurs when I try to boot up 2.16 with the 2.14 database >> (after I've run the 2.15 upgrade script found here: >> http://www.dhis2.org/download/resources/sql/rename-patient-to-trackedentity.sql >> ) >> It hangs at step 7 of 14 * INFO 2014-10-08 09:45:03,291 Executing >> startup routine [7 of 14, runlevel 4]: TrackedEntityTableAlteror >> (DefaultStartupRoutineExecutor.java [localhost-startStop-1]) >> The system, for having such meager hardware, is really snappy with both >> the live version of 2.16, and our full production mirror of 2.14. >> The com.hazelcast.util.HealthMonitor continues to function even after >> the initialization process hangs at step 7 of 14 (as you can see in >> catalina.out) Oct 08, 2014 10:36:58 AM com.hazelcast.util.HealthMonitor >> >> Both Java and Postgres are using no cpu cycles after the hang, so it >> doesn't *feel* like it is churning away at something: >> >> PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ >> COMMAND >> 1413 dhis 20 0 1895572 570840 16532 S 1.0 44.7 1:48.39 java >> 906 postgres 20 0 523944 30260 28868 S 0.0 2.4 0:00.47 >> postgres >> 908 postgres 20 0 524704 77648 75724 S 0.0 6.1 0:01.04 >> postgres >> 909 postgres 20 0 524140 4304 2904 S 0.0 0.3 0:00.16 >> postgres >> 910 postgres 20 0 524140 14056 12656 S 0.0 1.1 0:00.50 >> postgres >> 911 postgres 20 0 524980 3068 1096 S 0.0 0.2 0:00.11 >> postgres >> 912 postgres 20 0 103712 1984 352 S 0.0 0.2 0:00.71 >> postgres >> 1432 postgres 20 0 526508 7656 4524 S 0.0 0.6 0:00.00 >> postgres >> 1433 postgres 20 0 529308 14604 8948 S 0.0 1.1 0:00.22 >> postgres >> 1434 postgres 20 0 536664 46672 32832 S 0.0 3.7 0:08.00 >> postgres >> 1904 postgres 20 0 525372 5652 3204 S 0.0 0.4 0:00.00 >> postgres >> 1906 postgres 20 0 525256 4860 2548 S 0.0 0.4 0:00.00 >> postgres >> 1907 postgres 20 0 525256 4856 2540 S 0.0 0.4 0:00.00 >> postgres >> 2114 postgres 20 0 525372 5600 3192 S 0.0 0.4 0:00.00 >> postgres >> (there are a lot of postgres processes it seems like) >> >> I saw some errors on startup but the notes for 2.16 says to expect a few >> the first time. I also saw some errors when I ran the import and 2.15 >> upgrade script. >> Database import (grep for errors) >> ERROR: must be owner of extension plpgsql >> >> Upgrade script (grep for errors) >> ERROR: table "patientaggregatereportmembers" does not exist >> ERROR: table "patienttabularreportmembers" does not exist >> ERROR: table "patientregistrationform_attributes" does not exist >> ERROR: table "patientregistrationform_fixedattributes" does not exist >> ERROR: table "patientregistrationform_identifiertypes" does not exist >> ERROR: table "patientregistrationform_attributes" does not exist >> ERROR: table "patientmobilesetting" does not exist >> >> Any ideas? Is there an upgrade script I've forgotten to run or maybe a >> setting I've missed? >> >> Timothy Harding >> PeaceCorps Volunteer >> Republic of Vanuatu >> hardi...@gmail.com >> +678 5955137 >> >> _______________________________________________ >> 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 > >
_______________________________________________ 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
