API tools faq
paste
amuj

Untitled

amuj
May 17th, 2021 (edited)
44
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 16.66 KB | None | 0 0
raw download clone embed print report
  1. openmrs_1 | INFO - Slf4jLogger.info(42) |2021-05-17T09:43:38,283| CREATE TABLE openmrs.reporting_report_design (id INT AUTO_INCREMENT NOT NULL, uuid CHAR(38) NOT NULL, name VARCHAR(255) NOT NULL, `description` VARCHAR(1000) NULL, report_definition_id INT DEFAULT 0 NOT NULL, renderer_type VARCHAR(255) NOT NULL, properties TEXT NULL, creator INT DEFAULT 0 NOT NULL, date_created datetime NOT NULL, changed_by INT NULL, date_changed datetime NULL, retired TINYINT(1) DEFAULT 0 NOT NULL, retired_by INT NULL, date_retired datetime NULL, retire_reason VARCHAR(255) NULL, CONSTRAINT PK_REPORTING_REPORT_DESIGN PRIMARY KEY (id), UNIQUE (uuid))
  2. openmrs_1 | INFO - Slf4jLogger.info(42) |2021-05-17T09:43:51,984| Table reporting_report_design created
  3. openmrs_1 | INFO - Slf4jLogger.info(42) |2021-05-17T09:43:51,985| ALTER TABLE openmrs.reporting_report_design ADD CONSTRAINT report_definition_id_for_reporting_report_design FOREIGN KEY (report_definition_id) REFERENCES openmrs.serialized_object (serialized_object_id)
  4. frontend_1 | 127.0.0.1 - - [17/May/2021:09:43:53 +0000] "GET /ui HTTP/1.1" 301 233
  5. openmrs_1 | INFO - Slf4jLogger.info(42) |2021-05-17T09:44:01,180| Foreign key constraint added to reporting_report_design (report_definition_id)
  6. openmrs_1 | INFO - Slf4jLogger.info(42) |2021-05-17T09:44:01,181| ALTER TABLE openmrs.reporting_report_design ADD CONSTRAINT creator_for_reporting_report_design FOREIGN KEY (creator) REFERENCES openmrs.users (user_id)
  7. openmrs_1 | INFO - Slf4jLogger.info(42) |2021-05-17T09:44:18,113| Foreign key constraint added to reporting_report_design (creator)
  8. openmrs_1 | INFO - Slf4jLogger.info(42) |2021-05-17T09:44:18,114| ALTER TABLE openmrs.reporting_report_design ADD CONSTRAINT changed_by_for_reporting_report_design FOREIGN KEY (changed_by) REFERENCES openmrs.users (user_id)
  9. openmrs_1 | INFO - Slf4jLogger.info(42) |2021-05-17T09:44:22,547| Foreign key constraint added to reporting_report_design (changed_by)
  10. openmrs_1 | INFO - Slf4jLogger.info(42) |2021-05-17T09:44:22,548| ALTER TABLE openmrs.reporting_report_design ADD CONSTRAINT retired_by_for_reporting_report_design FOREIGN KEY (retired_by) REFERENCES openmrs.users (user_id)
  11. frontend_1 | 127.0.0.1 - - [17/May/2021:09:44:24 +0000] "GET /ui HTTP/1.1" 301 233
  12. openmrs_1 | INFO - Slf4jLogger.info(42) |2021-05-17T09:44:29,155| Foreign key constraint added to reporting_report_design (retired_by)
  13. openmrs_1 | INFO - Slf4jLogger.info(42) |2021-05-17T09:44:29,155| ChangeSet liquibase.xml::reporting_report_design_1::mseaton ran successfully in 50879ms
  14. openmrs_1 | INFO - Slf4jLogger.info(42) |2021-05-17T09:44:29,155| SELECT MAX(ORDEREXECUTED) FROM openmrs.liquibasechangelog
  15. openmrs_1 | INFO - Slf4jLogger.info(42) |2021-05-17T09:44:29,156| INSERT INTO openmrs.liquibasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, `DESCRIPTION`, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('reporting_report_design_1', 'mseaton', 'liquibase.xml', NOW(), 975, '8:fb867a325b165f44658ad2124ec0a307', 'createTable tableName=reporting_report_design; addForeignKeyConstraint baseTableName=reporting_report_design, constraintName=report_definition_id_for_reporting_report_design, referencedTableName=serialized_object; addForeignKeyConstraint baseTable...', 'Create table to persist report design specifications', 'EXECUTED', NULL, NULL, '3.10.2', NULL)
  16. openmrs_1 | INFO - Slf4jLogger.info(42) |2021-05-17T09:44:29,320| CREATE TABLE TMP_QNEZWXPITGIVMCHW (
  17. openmrs_1 | id INT PRIMARY KEY,
  18. openmrs_1 | self_ref INT NOT NULL,
  19. openmrs_1 | CONSTRAINT c_self_ref FOREIGN KEY(self_ref) REFERENCES TMP_QNEZWXPITGIVMCHW(id)
  20. openmrs_1 | )
  21. openmrs_1 | INFO - Slf4jLogger.info(42) |2021-05-17T09:44:30,037| DROP TABLE TMP_QNEZWXPITGIVMCHW
  22. openmrs_1 | INFO - Slf4jLogger.info(42) |2021-05-17T09:44:30,415| select const.CONSTRAINT_NAME, COLUMN_NAME from information_schema.table_constraints const join information_schema.key_column_usage col on const.constraint_schema=col.constraint_schema and const.table_name=col.table_name and const.constraint_name=col.constraint_name where const.constraint_schema='openmrs' and const.table_name='serialized_object' and const.constraint_name='uuid'order by ordinal_position
  23. openmrs_1 | INFO - Slf4jLogger.info(42) |2021-05-17T09:44:30,501| select const.CONSTRAINT_NAME, COLUMN_NAME from information_schema.table_constraints const join information_schema.key_column_usage col on const.constraint_schema=col.constraint_schema and const.table_name=col.table_name and const.constraint_name=col.constraint_name where const.constraint_schema='openmrs' and const.table_name='users' and const.constraint_name='email'order by ordinal_position
  24. openmrs_1 | INFO - Slf4jLogger.info(42) |2021-05-17T09:44:30,521| select const.CONSTRAINT_NAME, COLUMN_NAME from information_schema.table_constraints const join information_schema.key_column_usage col on const.constraint_schema=col.constraint_schema and const.table_name=col.table_name and const.constraint_name=col.constraint_name where const.constraint_schema='openmrs' and const.table_name='person' and const.constraint_name='uuid'order by ordinal_position
  25. openmrs_1 | INFO - Slf4jLogger.info(42) |2021-05-17T09:44:30,540| select const.CONSTRAINT_NAME, COLUMN_NAME from information_schema.table_constraints const join information_schema.key_column_usage col on const.constraint_schema=col.constraint_schema and const.table_name=col.table_name and const.constraint_name=col.constraint_name where const.constraint_schema='openmrs' and const.table_name='concept' and const.constraint_name='uuid'order by ordinal_position
  26. openmrs_1 | INFO - Slf4jLogger.info(42) |2021-05-17T09:44:30,546| select const.CONSTRAINT_NAME, COLUMN_NAME from information_schema.table_constraints const join information_schema.key_column_usage col on const.constraint_schema=col.constraint_schema and const.table_name=col.table_name and const.constraint_name=col.constraint_name where const.constraint_schema='openmrs' order by ordinal_position
  27. openmrs_1 | INFO - Slf4jLogger.info(42) |2021-05-17T09:44:30,653| ALTER TABLE openmrs.reporting_report_design DROP FOREIGN KEY report_definition_id_for_reporting_report_design
  28. openmrs_1 | INFO - Slf4jLogger.info(42) |2021-05-17T09:44:31,095| Foreign key report_definition_id_for_reporting_report_design dropped
  29. openmrs_1 | INFO - Slf4jLogger.info(42) |2021-05-17T09:44:31,096| ChangeSet liquibase.xml::reporting_report_design_4::mseaton ran successfully in 1861ms
  30. openmrs_1 | INFO - Slf4jLogger.info(42) |2021-05-17T09:44:31,097| INSERT INTO openmrs.liquibasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, `DESCRIPTION`, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('reporting_report_design_4', 'mseaton', 'liquibase.xml', NOW(), 976, '8:6dcc76696a102db9641cf24cf0f27a86', 'dropForeignKeyConstraint baseTableName=reporting_report_design, constraintName=report_definition_id_for_reporting_report_design', '', 'EXECUTED', NULL, NULL, '3.10.2', NULL)
  31. openmrs_1 | INFO - Slf4jLogger.info(42) |2021-05-17T09:44:31,256| CREATE INDEX report_definition_uuid_for_reporting_report_design ON openmrs.reporting_report_design(report_definition_uuid)
  32. openmrs_1 | ERROR - Slf4jLogger.severe(22) |2021-05-17T09:44:31,256| Change Set liquibase.xml::reporting_report_design_5::mseaton failed. Error: Key column 'report_definition_uuid' doesn't exist in table [Failed SQL: (1072) CREATE INDEX report_definition_uuid_for_reporting_report_design ON openmrs.reporting_report_design(report_definition_uuid)]
  33. openmrs_1 | INFO - Slf4jLogger.info(42) |2021-05-17T09:44:31,323| Successfully released change log lock
  34. openmrs_1 | WARN - ModuleFactory.startModuleInternal(788) |2021-05-17T09:44:31,323| Error while trying to start module: reporting
  35. openmrs_1 | org.openmrs.module.ModuleException: Unable to update data model using liquibase.xml. Module: Reporting
  36. openmrs_1 | at org.openmrs.module.ModuleFactory.runLiquibase(ModuleFactory.java:997) ~[openmrs-api-2.4.0.jar:?]
  37. openmrs_1 | at org.openmrs.module.ModuleFactory.startModuleInternal(ModuleFactory.java:728) [openmrs-api-2.4.0.jar:?]
  38. openmrs_1 | at org.openmrs.api.context.Daemon$1.run(Daemon.java:80) [openmrs-api-2.4.0.jar:?]
  39. openmrs_1 | Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set liquibase.xml::reporting_report_design_5::mseaton:
  40. openmrs_1 | Reason: liquibase.exception.DatabaseException: Key column 'report_definition_uuid' doesn't exist in table [Failed SQL: (1072) CREATE INDEX report_definition_uuid_for_reporting_report_design ON openmrs.reporting_report_design(report_definition_uuid)]
  41. openmrs_1 | at liquibase.changelog.ChangeSet.execute(ChangeSet.java:659) ~[liquibase-core-3.10.2.jar:?]
  42. openmrs_1 | at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:53) ~[liquibase-core-3.10.2.jar:?]
  43. openmrs_1 | at org.openmrs.util.DatabaseUpdater$OpenmrsUpdateVisitor.visit(DatabaseUpdater.java:850) ~[openmrs-api-2.4.0.jar:?]
  44. openmrs_1 | at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:97) ~[liquibase-core-3.10.2.jar:?]
  45. openmrs_1 | at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:232) ~[openmrs-api-2.4.0.jar:?]
  46. openmrs_1 | at org.openmrs.module.ModuleFactory.runLiquibase(ModuleFactory.java:989) ~[openmrs-api-2.4.0.jar:?]
  47. openmrs_1 | ... 2 more
  48. openmrs_1 | Caused by: liquibase.exception.DatabaseException: Key column 'report_definition_uuid' doesn't exist in table [Failed SQL: (1072) CREATE INDEX report_definition_uuid_for_reporting_report_design ON openmrs.reporting_report_design(report_definition_uuid)]
  49. openmrs_1 | at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:430) ~[liquibase-core-3.10.2.jar:?]
  50. openmrs_1 | at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:87) ~[liquibase-core-3.10.2.jar:?]
  51. openmrs_1 | at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:159) ~[liquibase-core-3.10.2.jar:?]
  52. openmrs_1 | at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1276) ~[liquibase-core-3.10.2.jar:?]
  53. openmrs_1 | at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1258) ~[liquibase-core-3.10.2.jar:?]
  54. openmrs_1 | at liquibase.changelog.ChangeSet.execute(ChangeSet.java:622) ~[liquibase-core-3.10.2.jar:?]
  55. openmrs_1 | at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:53) ~[liquibase-core-3.10.2.jar:?]
  56. openmrs_1 | at org.openmrs.util.DatabaseUpdater$OpenmrsUpdateVisitor.visit(DatabaseUpdater.java:850) ~[openmrs-api-2.4.0.jar:?]
  57. openmrs_1 | at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:97) ~[liquibase-core-3.10.2.jar:?]
  58. openmrs_1 | at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:232) ~[openmrs-api-2.4.0.jar:?]
  59. openmrs_1 | at org.openmrs.module.ModuleFactory.runLiquibase(ModuleFactory.java:989) ~[openmrs-api-2.4.0.jar:?]
  60. openmrs_1 | ... 2 more
  61. openmrs_1 | Caused by: java.sql.SQLSyntaxErrorException: Key column 'report_definition_uuid' doesn't exist in table
  62. openmrs_1 | at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) ~[mysql-connector-java-8.0.21.jar:8.0.21]
  63. openmrs_1 | at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.21.jar:8.0.21]
  64. openmrs_1 | at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-8.0.21.jar:8.0.21]
  65. openmrs_1 | at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:764) ~[mysql-connector-java-8.0.21.jar:8.0.21]
  66. openmrs_1 | at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648) ~[mysql-connector-java-8.0.21.jar:8.0.21]
  67. openmrs_1 | at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:426) ~[liquibase-core-3.10.2.jar:?]
  68. openmrs_1 | at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:87) ~[liquibase-core-3.10.2.jar:?]
  69. openmrs_1 | at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:159) ~[liquibase-core-3.10.2.jar:?]
  70. openmrs_1 | at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1276) ~[liquibase-core-3.10.2.jar:?]
  71. openmrs_1 | at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1258) ~[liquibase-core-3.10.2.jar:?]
  72. openmrs_1 | at liquibase.changelog.ChangeSet.execute(ChangeSet.java:622) ~[liquibase-core-3.10.2.jar:?]
  73. openmrs_1 | at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:53) ~[liquibase-core-3.10.2.jar:?]
  74. openmrs_1 | at org.openmrs.util.DatabaseUpdater$OpenmrsUpdateVisitor.visit(DatabaseUpdater.java:850) ~[openmrs-api-2.4.0.jar:?]
  75. openmrs_1 | at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:97) ~[liquibase-core-3.10.2.jar:?]
  76. openmrs_1 | at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:232) ~[openmrs-api-2.4.0.jar:?]
  77. openmrs_1 | at org.openmrs.module.ModuleFactory.runLiquibase(ModuleFactory.java:989) ~[openmrs-api-2.4.0.jar:?]
  78. openmrs_1 | ... 2 more
  79. openmrs_1 | INFO - LoggingAdvice.invoke(117) |2021-05-17T09:44:31,456| In method AlertService.saveAlert. Arguments: Alert=Alert: #null,
  80. openmrs_1 | INFO - LoggingAdvice.invoke(157) |2021-05-17T09:44:31,462| Exiting method saveAlert
  81. openmrs_1 | ERROR - ModuleFactory.startModules(257) |2021-05-17T09:44:31,549| Module EMR API Module cannot be started because it requires the following module(s): reporting ${reportingModuleVersion} Please install and start these modules first.
  82. openmrs_1 | INFO - LoggingAdvice.invoke(117) |2021-05-17T09:44:31,557| In method AlertService.saveAlert. Arguments: Alert=Alert: #null,
  83. openmrs_1 | INFO - LoggingAdvice.invoke(157) |2021-05-17T09:44:31,785| Exiting method saveAlert
  84. openmrs_1 | INFO - Slf4jLogger.info(42) |2021-05-17T09:44:32,205| SELECT MD5SUM FROM openmrs.liquibasechangelog WHERE MD5SUM IS NOT NULL LIMIT 1
  85. openmrs_1 | INFO - Slf4jLogger.info(42) |2021-05-17T09:44:32,256| SELECT COUNT(*) FROM openmrs.liquibasechangelog
  86. openmrs_1 | INFO - Slf4jLogger.info(42) |2021-05-17T09:44:32,257| Reading from openmrs.liquibasechangelog
  87. openmrs_1 | INFO - Slf4jLogger.info(42) |2021-05-17T09:44:32,257| SELECT * FROM openmrs.liquibasechangelog ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC
  88. openmrs_1 | INFO - Slf4jLogger.info(42) |2021-05-17T09:44:32,267| SELECT COUNT(*) FROM openmrs.liquibasechangeloglock
  89. openmrs_1 | INFO - Slf4jLogger.info(42) |2021-05-17T09:44:32,268| SELECT COUNT(*) FROM openmrs.liquibasechangeloglock
  90. openmrs_1 | INFO - Slf4jLogger.info(42) |2021-05-17T09:44:32,275| SELECT `LOCKED` FROM openmrs.liquibasechangeloglock WHERE ID=1
  91. openmrs_1 | INFO - Slf4jLogger.info(42) |2021-05-17T09:44:32,346| Successfully acquired change log lock
  92. openmrs_1 | INFO - Slf4jLogger.info(42) |2021-05-17T09:44:32,373| CREATE TABLE openmrs.idgen_identifier_source (id INT AUTO_INCREMENT NOT NULL, uuid CHAR(38) NOT NULL, name VARCHAR(255) NOT NULL, `description` VARCHAR(1000) NULL, identifier_type INT NOT NULL, creator INT NOT NULL, date_created datetime NOT NULL, changed_by INT NULL, date_changed datetime NULL, retired TINYINT(1) DEFAULT 0 NOT NULL, retired_by INT NULL, date_retired datetime NULL, retire_reason VARCHAR(255) NULL, CONSTRAINT PK_IDGEN_IDENTIFIER_SOURCE PRIMARY KEY (id), CONSTRAINT `identifier_type for idgen_identifier_source` FOREIGN KEY (identifier_type) REFERENCES openmrs.patient_identifier_type(patient_identifier_type_id), CONSTRAINT `creator for idgen_identifier_source` FOREIGN KEY (creator) REFERENCES openmrs.users(user_id), CONSTRAINT `changed_by for idgen_identifier_source` FOREIGN KEY (changed_by) REFERENCES openmrs.users(user_id), CONSTRAINT `retired_by for idgen_identifier_source` FOREIGN KEY (retired_by) REFERENCES openmrs.users(user_id), UNIQUE (id), UNIQUE (uuid))
  93. openmrs_1 | INFO - Slf4jLogger.info(42) |2021-05-17T09:44:37,408| Table idgen_identifier_source created
  94. openmrs_1 | INFO - Slf4jLogger.info(42) |2021-05-17T09:44:37,409| ChangeSet liquibase.xml::43889130-55c2-49e9-b72b-a9eae9a31da7::Partners In Health ran successfully in 5048ms
  95. openmrs_1 | INFO - Slf4jLogger.info(42) |2021-05-17T09:44:37,410| SELECT MAX(ORDEREXECUTED) FROM openmrs.liquibasechangelog
  96. openmrs_1 | INFO - Slf4jLogger.info(42) |2021-05-17T09:44:37,416| INSERT INTO openmrs.liquibasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, `DESCRIPTION`, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('43889130-55c2-49e9-b72b-a9eae9a31da7', 'Partners In Health', 'liquibase.xml', NOW(), 977, '8:373516eb011f344c988f9f5c8c121ec9', 'createTable tableName=idgen_identifier_source', '', 'EXECUTED', NULL, NULL, '3.10.2', NULL)
  97.  
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!