Why the Enterprise Dashboard log shows Pending Schema Version messages?
book
Article ID: 125553
calendar_today
Updated On:
Products
CA Application TestService VirtualizationCA Continuous Application Insight (PathFinder)CA Service Virtualization (DevTest / LISA / VSE / Application Test)
Issue/Introduction
Enterprise Dashboard log shows the "Pending Schema Version: 15" and what could cause these messages:
2019-01-29 10:55:01,371Z (11:55) [main] INFO dradis.DradisInitBean - Database Server: MySQL 2019-01-29 10:55:01,372Z (11:55) [main] INFO dradis.DradisInitBean - Database Server Version: 5.6.14 2019-01-29 10:55:01,373Z (11:55) [main] INFO dradis.DradisInitBean - Database Driver Name: MySQL Connector Java 2019-01-29 10:55:01,373Z (11:55) [main] INFO dradis.DradisInitBean - Database Driver Version: mysql-connector-java-5.1.36 ( Revision: 4fc1 f969f740409a4e03750316df2c0e429f3dc8 ) 2019-01-29 10:55:01,731Z (11:55) [main] INFO com.ca.dradis.db.FlywayDbMigration - Schema Version: 13 2019-01-29 10:55:01,796Z (11:55) [main] INFO com.ca.dradis.db.FlywayDbMigration - Pending Schema Version: 15 2019-01-29 10:55:06,761Z (11:55) [main] INFO quartz.QuartzGrailsPlugin - Quartz Scheduler - Started 2019-01-29 10:55:06,832Z (11:55) [main] INFO application - Initializing Spring FrameworkServlet 'groovyPagesServlet' 2019-01-29 10:55:06,832Z (11:55) [main] INFO application - GSP servlet initialized 2019-01-29 10:55:06,855Z (11:55) [main] INFO application - Initializing Spring FrameworkServlet 'grailsDispatcherServlet' 2019-01-29 10:55:06,897Z (11:55) [main] INFO dradis.Application - Started Application in 26.327 seconds (JVM running for 27.611)
Why the Enterprise Dashboard log shows Pending Schema Version messages like below?
2019-01-29 10:55:01,371Z (11:55) [main] INFO dradis.DradisInitBean - Database Server: MySQL 2019-01-29 10:55:01,372Z (11:55) [main] INFO dradis.DradisInitBean - Database Server Version: 5.6.14 2019-01-29 10:55:01,373Z (11:55) [main] INFO dradis.DradisInitBean - Database Driver Name: MySQL Connector Java 2019-01-29 10:55:01,373Z (11:55) [main] INFO dradis.DradisInitBean - Database Driver Version: mysql-connector-java-5.1.36 ( Revision: 4fc1 f969f740409a4e03750316df2c0e429f3dc8 ) 2019-01-29 10:55:01,731Z (11:55) [main] INFO com.ca.dradis.db.FlywayDbMigration - Schema Version: 13 2019-01-29 10:55:01,796Z (11:55) [main] INFO com.ca.dradis.db.FlywayDbMigration - Pending Schema Version: 15 2019-01-29 10:55:06,761Z (11:55) [main] INFO quartz.QuartzGrailsPlugin - Quartz Scheduler - Started 2019-01-29 10:55:06,832Z (11:55) [main] INFO application - Initializing Spring FrameworkServlet 'groovyPagesServlet' 2019-01-29 10:55:06,832Z (11:55) [main] INFO application - GSP servlet initialized 2019-01-29 10:55:06,855Z (11:55) [main] INFO application - Initializing Spring FrameworkServlet 'grailsDispatcherServlet' 2019-01-29 10:55:06,897Z (11:55) [main] INFO dradis.Application - Started Application in 26.327 seconds (JVM running for 27.611)
Environment
DevTest 10.3
Resolution
The INFO messages are by design. When Schema_version is updating information is logged.
schema_version is a table in the DB and it has 3/4 rows of data like below: . V13_create_DDL.sql . V14_update_DDL.sql . V14_update_DDL.sql
When Enterprise Dashboard is started, first it tries to run create DDL and then update DDL. First see the "INFO com.ca.dradis.db.FlywayDbMigration - Pending Schema Version: 15" message and then see "INFO com.ca.dradis.db.FlywayDbMigration - Schema Version: 15"
2019-01-29 10:55:01,371Z (11:55) [main] INFO dradis.DradisInitBean - Database Server: MySQL 2019-01-29 10:55:01,372Z (11:55) [main] INFO dradis.DradisInitBean - Database Server Version: 5.6.14 2019-01-29 10:55:01,373Z (11:55) [main] INFO dradis.DradisInitBean - Database Driver Name: MySQL Connector Java 2019-01-29 10:55:01,373Z (11:55) [main] INFO dradis.DradisInitBean - Database Driver Version: mysql-connector-java-5.1.36 ( Revision: 4fc1 f969f740409a4e03750316df2c0e429f3dc8 ) 2019-01-29 10:55:01,731Z (11:55) [main] INFO com.ca.dradis.db.FlywayDbMigration - Schema Version: 13 2019-01-29 10:55:01,796Z (11:55) [main] INFO com.ca.dradis.db.FlywayDbMigration - Pending Schema Version: 15 2019-01-29 10:55:06,761Z (11:55) [main] INFO quartz.QuartzGrailsPlugin - Quartz Scheduler - Started 2019-01-29 10:55:06,832Z (11:55) [main] INFO application - Initializing Spring FrameworkServlet 'groovyPagesServlet' 2019-01-29 10:55:06,832Z (11:55) [main] INFO application - GSP servlet initialized 2019-01-29 10:55:06,855Z (11:55) [main] INFO application - Initializing Spring FrameworkServlet 'grailsDispatcherServlet' 2019-01-29 10:55:06,897Z (11:55) [main] INFO dradis.Application - Started Application in 26.327 seconds (JVM running for 27.611)
Restarting Enterprise Dashboard should show only the "INFO com.ca.dradis.db.FlywayDbMigration - Schema Version: 15".