Why the Enterprise Dashboard log shows Pending Schema Version messages?

book

Article ID: 125553

calendar_today

Updated On:

Products

CA Application Test Service Virtualization CA Continuous Application Insight (PathFinder)

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".
Powered by Wolken Software