EMS Probe stopped responding
Article ID: 216432
Updated On:
Products
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
Feedback
