# Demo server is not very stable

**URL:** <https://talk.openmrs.org/t/demo-server-is-not-very-stable/9314>\
**Category:** Infrastructure\
**Created:** [December 29, 2016, 10:36am UTC](https://talk.openmrs.org/t/demo-server-is-not-very-stable/9314 "2016-12-29T10:36:28Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![cintiadr](https://talk.openmrs.org/user_avatar/talk.openmrs.org/cintiadr/32/8081_2.png) [@cintiadr](https://talk.openmrs.org/u/cintiadr)\
**Post date:** [December 29, 2016, 10:36am UTC](https://talk.openmrs.org/t/demo-server-is-not-very-stable/9314/1 "2016-12-29T10:36:28Z")

</div>

Since demo was upgraded to 2.5 ([Process to update the demo server](https://talk.openmrs.org/t/process-to-update-the-demo-server/8692) and [Dockerised demo refapp, and other questions about demo data](https://talk.openmrs.org/t/dockerised-demo-refapp-and-other-questions-about-demo-data/8829)), the demo service is sort in a pretty bad state.

We know that, and we plan on moving it to another server. Because of that, the database reset is currently not working.

If you think you can help on that task (docker, openmrs sdk, ansible or anything), please let me know.

---

<div class="post-metadata">

**Author:** ![dkayiwa](https://talk.openmrs.org/user_avatar/talk.openmrs.org/dkayiwa/32/179_2.png) [@dkayiwa](https://talk.openmrs.org/u/dkayiwa)\
**Post date:** [January 9, 2017, 8:12pm UTC](https://talk.openmrs.org/t/demo-server-is-not-very-stable/9314/2 "2017-01-09T20:12:54Z")

</div>

Did we fix the problem of the demo server database not getting reset every day? Here is an example of what results from not doing so. Switch to spanish as the current locale and then access this: [http://demo.openmrs.org/openmrs/coreapps/clinicianfacing/patient.page?patientId=7e3f7fb1-25ca-4d97-83fd-82fd4129fc85](http://demo.openmrs.org/openmrs/coreapps/clinicianfacing/patient.page?patientId=7e3f7fb1-25ca-4d97-83fd-82fd4129fc85)

---

<div class="post-metadata">

**Author:** ![cintiadr](https://talk.openmrs.org/user_avatar/talk.openmrs.org/cintiadr/32/8081_2.png) [@cintiadr](https://talk.openmrs.org/u/cintiadr)\
**Post date:** [January 10, 2017, 10:39am UTC](https://talk.openmrs.org/t/demo-server-is-not-very-stable/9314/3 "2017-01-10T10:39:00Z")

</div>

I’m still working to get the new demo server.

Are you able to send me an SQL of how the database should be for a demo server/refapp? It shouldn’t be hard to put the sql on the right place.

On the meantime, I had an SQL file I generated using the sdk. I imported it to the demo server, can you please confirm if it’s actually what we need there? If so, feel free to reenable the reset database build,

---

<div class="post-metadata">

**Author:** ![dkayiwa](https://talk.openmrs.org/user_avatar/talk.openmrs.org/dkayiwa/32/179_2.png) [@dkayiwa](https://talk.openmrs.org/u/dkayiwa)\
**Post date:** [January 11, 2017, 11:11am UTC](https://talk.openmrs.org/t/demo-server-is-not-very-stable/9314/4 "2017-01-11T11:11:57Z")

</div>

How does the sql file that you generated, look like? Or should i just try to reenable the reset database build and see what happens?

---

<div class="post-metadata">

**Author:** ![cintiadr](https://talk.openmrs.org/user_avatar/talk.openmrs.org/cintiadr/32/8081_2.png) [@cintiadr](https://talk.openmrs.org/u/cintiadr)\
**Post date:** [January 11, 2017, 12:08pm UTC](https://talk.openmrs.org/t/demo-server-is-not-very-stable/9314/5 "2017-01-11T12:08:38Z")

</div>

That’s the file:

[https://github.com/cintiadr/docker-openmrs/tree/master/dbdump](https://github.com/cintiadr/docker-openmrs/tree/master/dbdump)

I did use it on demo server, so I’d expect you’d be able to find all demo data there (I generated it using the options in openmrs.properties to generate the demo data on docker).