bahmni openmrs not working

dan · August 19, 2023, 12:45pm

Hi! I’m trying to run bahmni with docker and everytime I get the same error with database connection, I tried reinstalling bahmni many times but it doesn’t help. Can someone help me?

The error:

2023-08-19 15:21:57 bahmni-lite-openmrs-1                | ERROR - Listener.contextInitialized(251) |2023-08-19T12:21:57,429| Failed to obtain JDBC connection
2023-08-19 15:21:57 bahmni-lite-openmrs-1                | org.openmrs.module.ModuleException: Unable to start OpenMRS. Error thrown was: Should not be here because updates were run previously
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at org.openmrs.web.WebDaemon.startOpenmrs(WebDaemon.java:65) ~[openmrs-web-2.5.10.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at org.openmrs.web.Listener.contextInitialized(Listener.java:243) ~[openmrs-web-2.5.10.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4759) ~[catalina.jar:8.5.85]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5229) ~[catalina.jar:8.5.85]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) ~[catalina.jar:8.5.85]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:753) ~[catalina.jar:8.5.85]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:727) ~[catalina.jar:8.5.85]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:695) ~[catalina.jar:8.5.85]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1016) ~[catalina.jar:8.5.85]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1903) ~[catalina.jar:8.5.85]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[?:1.8.0_362]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_362]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_362]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_362]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at java.lang.Thread.run(Thread.java:750) ~[?:1.8.0_362]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                | Caused by: javax.servlet.ServletException: Should not be here because updates were run previously
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at org.openmrs.web.Listener.startOpenmrs(Listener.java:291) ~[openmrs-web-2.5.10.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at org.openmrs.web.WebDaemon$1.run(WebDaemon.java:42) ~[openmrs-web-2.5.10.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                | Caused by: org.openmrs.util.DatabaseUpdateException: There was an error while updating the database to the latest. file: org/openmrs/liquibase/updates/liquibase-update-to-latest-2.0.x.xml. Error: liquibase.exception.LiquibaseException: Unable to execute change set: liquibase-update-to-latest.xml::1::upul
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:192) ~[openmrs-api-2.5.10.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:152) ~[openmrs-api-2.5.10.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at org.openmrs.api.context.Context.checkForDatabaseUpdates(Context.java:1206) ~[openmrs-api-2.5.10.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at org.openmrs.api.context.Context.startup(Context.java:909) ~[openmrs-api-2.5.10.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at org.openmrs.web.Listener.startOpenmrs(Listener.java:288) ~[openmrs-web-2.5.10.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at org.openmrs.web.WebDaemon$1.run(WebDaemon.java:42) ~[openmrs-web-2.5.10.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                | Caused by: liquibase.exception.LiquibaseException: liquibase.exception.LiquibaseException: Unable to execute change set: liquibase-update-to-latest.xml::1::upul
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:124) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:237) ~[openmrs-api-2.5.10.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:188) ~[openmrs-api-2.5.10.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:152) ~[openmrs-api-2.5.10.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at org.openmrs.api.context.Context.checkForDatabaseUpdates(Context.java:1206) ~[openmrs-api-2.5.10.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at org.openmrs.api.context.Context.startup(Context.java:909) ~[openmrs-api-2.5.10.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at org.openmrs.web.Listener.startOpenmrs(Listener.java:288) ~[openmrs-web-2.5.10.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at org.openmrs.web.WebDaemon$1.run(WebDaemon.java:42) ~[openmrs-web-2.5.10.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                | Caused by: liquibase.exception.LiquibaseException: Unable to execute change set: liquibase-update-to-latest.xml::1::upul
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at org.openmrs.util.DatabaseUpdater$OpenmrsUpdateVisitor.visit(DatabaseUpdater.java:858) ~[openmrs-api-2.5.10.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.changelog.ChangeLogIterator$2.lambda$null$0(ChangeLogIterator.java:111) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.lambda$child$0(Scope.java:166) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.child(Scope.java:175) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.child(Scope.java:165) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.child(Scope.java:144) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.changelog.ChangeLogIterator$2.lambda$run$1(ChangeLogIterator.java:110) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.lambda$child$0(Scope.java:166) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.child(Scope.java:175) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.child(Scope.java:165) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.child(Scope.java:144) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.child(Scope.java:228) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.changelog.ChangeLogIterator$2.run(ChangeLogIterator.java:94) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.lambda$child$0(Scope.java:166) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.child(Scope.java:175) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.child(Scope.java:165) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.child(Scope.java:144) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.child(Scope.java:228) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.child(Scope.java:232) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:66) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:237) ~[openmrs-api-2.5.10.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:188) ~[openmrs-api-2.5.10.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:152) ~[openmrs-api-2.5.10.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at org.openmrs.api.context.Context.checkForDatabaseUpdates(Context.java:1206) ~[openmrs-api-2.5.10.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at org.openmrs.api.context.Context.startup(Context.java:909) ~[openmrs-api-2.5.10.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at org.openmrs.web.Listener.startOpenmrs(Listener.java:288) ~[openmrs-web-2.5.10.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at org.openmrs.web.WebDaemon$1.run(WebDaemon.java:42) ~[openmrs-web-2.5.10.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                | Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set liquibase-update-to-latest.xml::1::upul:
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      Reason: liquibase.exception.DatabaseException: Table 'openmrs.person_attribute_type' doesn't exist [Failed SQL: (1146) ALTER TABLE openmrs.person_attribute_type ADD edit_privilege VARCHAR(255) NULL]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.changelog.ChangeSet.execute(ChangeSet.java:695) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:49) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at org.openmrs.util.DatabaseUpdater$OpenmrsUpdateVisitor.visit(DatabaseUpdater.java:855) ~[openmrs-api-2.5.10.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.changelog.ChangeLogIterator$2.lambda$null$0(ChangeLogIterator.java:111) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.lambda$child$0(Scope.java:166) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.child(Scope.java:175) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.child(Scope.java:165) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.child(Scope.java:144) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.changelog.ChangeLogIterator$2.lambda$run$1(ChangeLogIterator.java:110) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.lambda$child$0(Scope.java:166) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.child(Scope.java:175) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.child(Scope.java:165) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.child(Scope.java:144) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.child(Scope.java:228) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.changelog.ChangeLogIterator$2.run(ChangeLogIterator.java:94) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.lambda$child$0(Scope.java:166) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.child(Scope.java:175) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.child(Scope.java:165) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.child(Scope.java:144) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.child(Scope.java:228) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.child(Scope.java:232) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:66) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:237) ~[openmrs-api-2.5.10.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:188) ~[openmrs-api-2.5.10.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:152) ~[openmrs-api-2.5.10.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at org.openmrs.api.context.Context.checkForDatabaseUpdates(Context.java:1206) ~[openmrs-api-2.5.10.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at org.openmrs.api.context.Context.startup(Context.java:909) ~[openmrs-api-2.5.10.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at org.openmrs.web.Listener.startOpenmrs(Listener.java:288) ~[openmrs-web-2.5.10.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at org.openmrs.web.WebDaemon$1.run(WebDaemon.java:42) ~[openmrs-web-2.5.10.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                | Caused by: liquibase.exception.DatabaseException: Table 'openmrs.person_attribute_type' doesn't exist [Failed SQL: (1146) ALTER TABLE openmrs.person_attribute_type ADD edit_privilege VARCHAR(255) NULL]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:393) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:82) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:150) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1279) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1261) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.changelog.ChangeSet.execute(ChangeSet.java:660) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:49) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at org.openmrs.util.DatabaseUpdater$OpenmrsUpdateVisitor.visit(DatabaseUpdater.java:855) ~[openmrs-api-2.5.10.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.changelog.ChangeLogIterator$2.lambda$null$0(ChangeLogIterator.java:111) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.lambda$child$0(Scope.java:166) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.child(Scope.java:175) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.child(Scope.java:165) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.child(Scope.java:144) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.changelog.ChangeLogIterator$2.lambda$run$1(ChangeLogIterator.java:110) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.lambda$child$0(Scope.java:166) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.child(Scope.java:175) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.child(Scope.java:165) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.child(Scope.java:144) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.child(Scope.java:228) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.changelog.ChangeLogIterator$2.run(ChangeLogIterator.java:94) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.lambda$child$0(Scope.java:166) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.child(Scope.java:175) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.child(Scope.java:165) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.child(Scope.java:144) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.child(Scope.java:228) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.child(Scope.java:232) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:66) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:237) ~[openmrs-api-2.5.10.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:188) ~[openmrs-api-2.5.10.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:152) ~[openmrs-api-2.5.10.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at org.openmrs.api.context.Context.checkForDatabaseUpdates(Context.java:1206) ~[openmrs-api-2.5.10.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at org.openmrs.api.context.Context.startup(Context.java:909) ~[openmrs-api-2.5.10.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at org.openmrs.web.Listener.startOpenmrs(Listener.java:288) ~[openmrs-web-2.5.10.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at org.openmrs.web.WebDaemon$1.run(WebDaemon.java:42) ~[openmrs-web-2.5.10.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                | Caused by: java.sql.SQLSyntaxErrorException: Table 'openmrs.person_attribute_type' doesn't exist
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) ~[mysql-connector-java-8.0.26.jar:8.0.26]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-8.0.26.jar:8.0.26]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:764) ~[mysql-connector-java-8.0.26.jar:8.0.26]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648) ~[mysql-connector-java-8.0.26.jar:8.0.26]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:389) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:82) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:150) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1279) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1261) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.changelog.ChangeSet.execute(ChangeSet.java:660) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:49) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at org.openmrs.util.DatabaseUpdater$OpenmrsUpdateVisitor.visit(DatabaseUpdater.java:855) ~[openmrs-api-2.5.10.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.changelog.ChangeLogIterator$2.lambda$null$0(ChangeLogIterator.java:111) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.lambda$child$0(Scope.java:166) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.child(Scope.java:175) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.child(Scope.java:165) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.child(Scope.java:144) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.changelog.ChangeLogIterator$2.lambda$run$1(ChangeLogIterator.java:110) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.lambda$child$0(Scope.java:166) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.child(Scope.java:175) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.child(Scope.java:165) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.child(Scope.java:144) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.child(Scope.java:228) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.changelog.ChangeLogIterator$2.run(ChangeLogIterator.java:94) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.lambda$child$0(Scope.java:166) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.child(Scope.java:175) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.child(Scope.java:165) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.child(Scope.java:144) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.child(Scope.java:228) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.Scope.child(Scope.java:232) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:66) ~[liquibase-core-4.4.3.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:237) ~[openmrs-api-2.5.10.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:188) ~[openmrs-api-2.5.10.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:152) ~[openmrs-api-2.5.10.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at org.openmrs.api.context.Context.checkForDatabaseUpdates(Context.java:1206) ~[openmrs-api-2.5.10.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at org.openmrs.api.context.Context.startup(Context.java:909) ~[openmrs-api-2.5.10.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at org.openmrs.web.Listener.startOpenmrs(Listener.java:288) ~[openmrs-web-2.5.10.jar:?]
2023-08-19 15:21:57 bahmni-lite-openmrs-1                |      at org.openmrs.web.WebDaemon$1.run(WebDaemon.java:42) ~[openmrs-web-2.5.10.jar:?]
2023-08-19 15:22:00 bahmni-lite-openmrs-1                | WARN - OpenmrsUtil.getRuntimePropertiesFilePathName(2032) |2023-08-19T12:22:00,221| Unable to find a runtime properties file at /openmrs/openmrs-runtime.properties
2023-08-19 15:22:00 bahmni-lite-openmrs-1                | 19-Aug-2023 12:22:00.490 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deployment of web application archive [/usr/local/tomcat/webapps/openmrs.war] has finished in [323,242] ms
2023-08-19 15:22:01 bahmni-lite-openmrs-1                | 19-Aug-2023 12:22:01.549 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["http-nio-8080"]
2023-08-19 15:22:02 bahmni-lite-openmrs-1                | 19-Aug-2023 12:22:02.376 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in 325950 ms

Here you can check the full log:

gsluthra · August 19, 2023, 12:56pm

What command did you type to bring Bahmni up?
Seems like the DB is not coming up, and hence OpenMRS is unable to connect. Maybe you can try bringing the openmrs DB container up first, ensure its up, and then bring up rest of Bahmni.
Check the logs of openmrsDB to see its up fine or not.
Which host OS are you running on?

dan · August 19, 2023, 1:02pm

docker compose up -d, as it says in the documentation
yes. I tried and the result is the same
I’ve got some errors in the DB, but idk how to fix them (db log - Pastebin.com)
It’s docker so it’s linux I think (I’m new to docker)

gsluthra · August 19, 2023, 1:25pm

I remember we had encountered this issue in DB earlier, and had fixed it. (cc: @mohant - Do you remember this?)

2023-08-19 15:51:30 2023-08-19T12:51:30.556205Z 9 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade

I believe it was something about the right version of mysql image.

Meanwhile, please try the following:

Stop all docker containers.
Delete the current databases of Bahmni using this command (basically deletes all docker volumes): docker volume rm $(docker volume ls -q) (See this documentation: How to reset and clean everything and start again.
Pull the latest v1.0.0 images docker compose pull. Ensure the version of images are v1.0.0 as mentioned here: [Announcement] Bahmni Lite 1.0.0 Release (you should not be using older images)
Restart Bahmni to recreate the DB and see.

You can also use the ./run-bahmni.sh script for the above steps.

Please confirm back if this doesn’t work and what steps you performed, and what image versions are you running.

Also which OS are you using? Windows/Linux/Mac?

dan · August 20, 2023, 2:00pm

I am using Windows 10 pro 22H2. The images are 1.0.0 but still doesn’t work.

mohant · August 21, 2023, 4:57am

I too remember this issue happened sometime back with one of the implementation. The reason being the performance_schema database on MySQL server has been corrupted somehow. @dan Can you please check if you can login into the openmrs mysql database ? You can exec into the openmrsdb container and run mysql -u openmrs-user -p

gsluthra · August 21, 2023, 6:25am

Hi @dan

It seems somehow the DB version on your machine is not 5.6. I just brought up Bahmni v1.0.0 on my machine and this is what the initial logs say on MY MACHINE

Enter the SERVICE name whose logs you wish to see:
openmrsdb
bahmni-lite-openmrsdb-1  | 2023-08-21 06:15:19+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.6.51-1debian9 started.
bahmni-lite-openmrsdb-1  | 2023-08-21 06:15:20+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
bahmni-lite-openmrsdb-1  | 2023-08-21 06:15:20+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.6.51-1debian9 started.
bahmni-lite-openmrsdb-1  | 2023-08-21 06:15:21+00:00 [Note] [Entrypoint]: Initializing database files

Note the DB says: 5.6.51

Whereas your logs say 5.7.42 :

2023-08-19 15:00:02 2023-08-19 12:00:02+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.42-1.el7 started.
2023-08-19 15:00:10 2023-08-19 12:00:10+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2023-08-19 15:00:11 2023-08-19 12:00:11+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.42-1.el7 started.
2023-08-19 15:00:11 '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
2023-08-19 15:00:11 2023-08-19T12:00:11.887294Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2023-08-19 15:00:11 2023-08-19T12:00:11.920352Z 0 [Note] mysqld (mysqld 5.7.42) starting as process 1 ...

Can you please recheck the output of the command: docker images and see that the DB image is same as what I have mentioned here (1.0.0-lite-mysql-5.6):

bahmni/openmrs-db              1.0.0-lite-mysql5.6      f6076a0d13a6   3 months ago   330MB

If not, then

please ensure you have pulled latest code from github bahmni-docker repository.
Then use the ./run-bahmni.sh script with option 8: 8) RESET and ERASE All Volumes/Databases And from docker!
Then use the option 7. to pull the latest images (to ensure u have right images on your machine)
Then use the option 1. to start Bahmni services.
The use the option 4. to see logs of openmrs-db service.

I hope this helps.