← Back to team overview

dhis2-devs team mailing list archive

Re: disappearing tables

 

BTW, next time anyone needs to create a new hibernate.properties file  the
correct/recommended settings are always available here:

http://dhis2.org/development#databasesetup

Ola,


On 14 December 2010 15:17, Ola Hodne Titlestad <olati@xxxxxxxxxx> wrote:

> Not sure, but I think this create-drop setting has to do with providing
> connections to the tests at build time.
>
> Ola,
>
>
> On 14 December 2010 14:52, Bob Jolliffe <bobjolliffe@xxxxxxxxx> wrote:
>
>> On 14 December 2010 13:33, Jan Henrik Øverland
>> <janhenrik.overland@xxxxxxxxx> wrote:
>> > Looks like create-drop is deafult..
>>
>> Yup I see it in
>>
>> ./dhis-support/dhis-support-hibernate/src/main/resources/hibernate-default.properties:hibernate.hbm2ddl.auto
>> = create-drop
>>
>> I wonder is this the right default to value to have.  It gave me a
>> nasty shock.  And could do damage to somebody's production db with a
>> naive hibernate.properties file like mine :-)
>>
>> Either we should set it to 'update' if we want to ease configuration
>> or to 'validate' if we want to be cautious not to mess peoples
>> database - or cause them to mess their own.
>>
>> Thanks for the heads up.  Should have asked earlier before turning my
>> machine upside down.
>>
>> Cheers
>> Bob
>>
>> >
>> > 2010/12/14 Bob Jolliffe <bobjolliffe@xxxxxxxxx>
>> >>
>> >> Good long shot.  Included hbm2ddl.auto=true and everything is fine
>> >> again :-)  But I've never had to set this before (I see what it does
>> >> now).  Shouldn't this be coming from one of our base inherited
>> >> properties?
>> >>
>> >> 2010/12/14 Bob Jolliffe <bobjolliffe@xxxxxxxxx>:
>> >> > Could well be.  I just cut and paste a generic postgres
>> hibernate/c3p0
>> >> > setup.
>> >> >
>> >> > hibernate.connection.driver_class = org.postgresql.Driver
>> >> > hibernate.connection.url = jdbc:postgresql://localhost/dhis2_ke
>> >> > hibernate.connection.username = postgres
>> >> > hibernate.connection.password = postgres
>> >> > hibernate.c3p0.min_size=5
>> >> > hibernate.c3p0.max_size=20
>> >> > hibernate.c3p0.timeout=1800
>> >> > hibernate.c3p0.max_statements=50
>> >> > hibernate.dialect = org.hibernate.dialect.PostgreSQLDialect
>> >> >
>> >> > Not sure what the hbm2ddl.auto property does.  Will look it up.
>> >> >
>> >> > Cheers
>> >> > bob
>> >> >
>> >> > 2010/12/14 Lars Helge Øverland <larshelge@xxxxxxxxx>:
>> >> >> Can we see the hibernate.properties in use? A long shot: it might be
>> >> >> related
>> >> >> to the hibernate.hbm2ddl.auto property, usually should be set to
>> >> >> "update".
>> >> >> On Tue, Dec 14, 2010 at 1:52 PM, Bob Jolliffe <
>> bobjolliffe@xxxxxxxxx>
>> >> >> wrote:
>> >> >>>
>> >> >>> This is so weird i am even a bit embarressed sharing on the list
>> but I
>> >> >>> have had a very strange morning.  I've been trying to set up a new
>> >> >>> dhis development environment in windoze (which i know is a bad idea
>> >> >>> but anyway ..).  What seems to be happening is that dhis, when it
>> >> >>> starts up, is clobbering tables in my database.  I was using
>> postgres
>> >> >>> 9 and figured maybe that was too brave so I downgraded back to
>> 8.4.5.
>> >> >>> Same issue.
>> >> >>>
>> >> >>> What happens is this:  if I start with a blank database, then when
>> >> >>> dhis runs the tables are created as normal - 164 of them.  But
>> after i
>> >> >>> shut down dhis I am left with only 5 timetables -
>> >> >>> aggregateddatavalues, aggregateddatasetcompleteness,
>> >> >>> aggregatedindicatorvalue, datavaluearchive and
>> >> >>> patientdatavaluearchive.  Everything else is just gone :-(
>> >> >>>
>> >> >>> What is worse is that when I start with an existing database (with
>> 169
>> >> >>> tables and lots of data) it does the same thing.  Clobbers most of
>> my
>> >> >>> tables.  Interesting while dhis is running I have lots of empty
>> tables
>> >> >>> which used to be full plus an oddly named _temp_dataelement table.
>> >> >>> Then when I shutdown dhis and look at my db again most of the
>> tables
>> >> >>> have just gone and I'm left with the above plus a couple of
>> _resource
>> >> >>> tables.
>> >> >>>
>> >> >>> Environment:
>> >> >>> dhis.war latest build 1676 - both my own and download from hudson
>> >> >>> postgres8.4.5
>> >> >>> java 1.6.0_22
>> >> >>> tomcat 6.0.29
>> >> >>>
>> >> >>> Has anyone else seen something like this or wasI just plagued by db
>> >> >>> spirits this morning.
>> >> >>>
>> >> >>> Regards
>> >> >>> Bob
>> >> >>>
>> >> >>> _______________________________________________
>> >> >>> Mailing list: https://launchpad.net/~dhis2-devs
>> >> >>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> >> >>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> >> >>> More help   : https://help.launchpad.net/ListHelp
>> >> >>
>> >> >>
>> >> >
>> >>
>> >> _______________________________________________
>> >> Mailing list: https://launchpad.net/~dhis2-devs
>> >> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> >> Unsubscribe : https://launchpad.net/~dhis2-devs
>> >> More help   : https://help.launchpad.net/ListHelp
>> >
>> >
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>
>

References