search cancel

EMS Probe stopped responding

book

Article ID: 216432

calendar_today

Updated On:

Products

DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

EMS probe version 10.23

EMS probe started consuming more than 70% CPU, when restarting it, problems of connection with the database are observed in the logs.

May 26 22:10:11:704 [main, ems] EMS database schema migration failed!  This may cause ems to not work correctly.

 

Environment

Release : 20.1

Component : UIM - EMS

Resolution

Deactivated and activated ems probe and it started working properly again. 

 

Additional Information

Error under ems.log :

May 26 22:10:11:704 [main, ems] EMS database schema migration failed!  This may cause ems to not work correctly.
May 26 22:10:11:705 [main, ems] org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException: 
Script failed
-------------
SQL State  : null
Error Code : 0
Message    : The connection is closed.
Line       : 17
Statement  : CREATE TABLE [dbo].[nas_database_migrations] (
    [version_rank] INT NOT NULL,
    [installed_rank] INT NOT NULL,
    [version] NVARCHAR(50) NOT NULL,
    [description] NVARCHAR(200),
    [type] NVARCHAR(20) NOT NULL,
    [script] NVARCHAR(1000) NOT NULL,
    [checksum] INT,
    [installed_by] NVARCHAR(100) NOT NULL,
    [installed_on] DATETIME NOT NULL DEFAULT GETDATE(),
    [execution_time] INT NOT NULL,
    [success] BIT NOT NULL
);
ALTER TABLE [dbo].[nas_database_migrations] ADD CONSTRAINT [nas_database_migrations_pk] PRIMARY KEY ([version]);

CREATE INDEX [nas_database_migrations_vr_idx] ON [dbo].[nas_database_migrations] ([version_rank]);
CREATE INDEX [nas_database_migrations_ir_idx] ON [dbo].[nas_database_migrations] ([installed_rank]);
CREATE INDEX [nas_database_migrations_s_idx] ON [dbo].[nas_database_migrations] ([success]);


 at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:117)
 at org.flywaydb.core.internal.metadatatable.MetaDataTableImpl.createIfNotExists(MetaDataTableImpl.java:93)
 at org.flywaydb.core.internal.metadatatable.MetaDataTableImpl.hasSchemasMarker(MetaDataTableImpl.java:301)
 at org.flywaydb.core.Flyway$1.execute(Flyway.java:1018)
 at org.flywaydb.core.Flyway$1.execute(Flyway.java:1006)
 at org.flywaydb.core.Flyway.execute(Flyway.java:1418)
 at org.flywaydb.core.Flyway.migrate(Flyway.java:1006)
 at com.nimsoft.events.common.services.AbstractFlywayMigrationService.migrate(AbstractFlywayMigrationService.java:53)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.lang.reflect.Method.invoke(Method.java:498)
 at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleElement.invoke(InitDestroyAnnotationBeanPostProcessor.java:365)
 at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPostProcessor.java:310)
 at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:133)
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:408)
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1575)
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:545)
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)
 at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)
 at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)
 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
 at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:751)
 at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:861)
 at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:541)
 at org.springframework.context.annotation.AnnotationConfigApplicationContext.<init>(AnnotationConfigApplicationContext.java:84)
 at com.nimsoft.events.common.beans.SpringContext.<init>(SpringContext.java:27)
 at com.nimsoft.events.probe.EMSProbe.main(EMSProbe.java:78)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.
 at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:227)
 at com.microsoft.sqlserver.jdbc.SQLServerConnection.checkClosed(SQLServerConnection.java:796)
 at com.microsoft.sqlserver.jdbc.SQLServerStatement.checkClosed(SQLServerStatement.java:1012)
 at com.microsoft.sqlserver.jdbc.SQLServerStatement.getWarnings(SQLServerStatement.java:1132)
 at org.apache.commons.dbcp2.DelegatingStatement.getWarnings(DelegatingStatement.java:602)
 at org.apache.commons.dbcp2.DelegatingStatement.getWarnings(DelegatingStatement.java:602)
 at org.flywaydb.core.internal.dbsupport.JdbcTemplate.executeStatement(JdbcTemplate.java:240)
 at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:114)
 ... 28 more