Data Aggregator Excpetion.log SwapPartitionEvent errors
Article ID: 375303
Updated On:
Products
DX NetOps
CA Performance Management - Usage and Administration
Issue/Introduction
We have found the follolwing Error in the DA Exception.log:
2024-08-01 10:19:00,7992024-08-01T10:19:00,799 | ERROR | ExceptionLog | A NEW application exception occurred (Key=############) : Exception encountered while performing dimension items batch job. :
StatementCallback; uncategorized SQLException for SQL [CREATE LOCAL TEMPORARY TABLE stg_item_and_device_context ON COMMIT PRESERVE ROWS AS /*+DIRECT*/ SELECT LEFT(d.hostname,200) as device_hostname,
LEFT(v6_ntoa(d.primary_ip_address),50) as device_primary_ip, q.item_id, gi.global_item_id, CASE WHEN d.device_item_id IS NULL THEN 0 ELSE d.device_item_id END as device_item_id,
q.item_name, q.item_description, q.item_display_name, q.item_display_description, LEFT(di.item_name,200) as device_name, LEFT(di.description,200) as device_description,
LEFT(di.item_display_name,200) as device_display_name, LEFT(di.item_display_description,200) as device_display_description FROM ( SELECT i.item_id, p.device_item_id,
LEFT(i.item_name,200) as item_name, LEFT(i.description,200) as item_description, LEFT(i.item_display_name,200) item_display_name,
LEFT(i.item_display_description,200) as item_display_description FROM item AS i JOIN ( SELECT item_id, device_item_id FROM poll_item WHERE
is_filtered=0 ORDER BY item_id, device_item_id ) as p ON i.item_id = p.item_id JOIN ( SELECT distinct item_id from dim_item_type ORDER by item_id ) AS t ON (t.item_id=i.item_id) ORDER by
p.device_item_id, i.item_id ) as q LEFT OUTER JOIN v_etl_global_item_id gi ON (q.item_id=gi.local_item_id) LEFT OUTER JOIN ( SELECT item_id as device_item_id, hostname, primary_ip_address FROM device ) AS
d ON d.device_item_id=q.device_item_id LEFT OUTER JOIN item di ON di.item_id=d.device_item_id AND q.item_id<>d.device_item_id ORDER BY q.item_id]; SQL state [55006]; error code [7888];
[Vertica][VJDBC](7888) ERROR: DDL statement (SwapPartitionEvent) interfered with this statement; nested exception is java.sql.SQLNonTransientException:
[Vertica][VJDBC](7888) ERROR: DDL statement (SwapPartitionEvent) interfered with this statement | (ExceptionLogger.java:99)
StatementCallback; uncategorized SQLException for SQL [CREATE LOCAL TEMPORARY TABLE stg_item_and_device_context ON COMMIT PRESERVE ROWS AS /*+DIRECT*/ SELECT LEFT(d.hostname,200) as device_hostname,
LEFT(v6_ntoa(d.primary_ip_address),50) as device_primary_ip, q.item_id, gi.global_item_id, CASE WHEN d.device_item_id IS NULL THEN 0 ELSE d.device_item_id END as device_item_id,
q.item_name, q.item_description, q.item_display_name, q.item_display_description, LEFT(di.item_name,200) as device_name, LEFT(di.description,200) as device_description,
LEFT(di.item_display_name,200) as device_display_name, LEFT(di.item_display_description,200) as device_display_description FROM ( SELECT i.item_id, p.device_item_id,
LEFT(i.item_name,200) as item_name, LEFT(i.description,200) as item_description, LEFT(i.item_display_name,200) item_display_name,
LEFT(i.item_display_description,200) as item_display_description FROM item AS i JOIN ( SELECT item_id, device_item_id FROM poll_item WHERE
is_filtered=0 ORDER BY item_id, device_item_id ) as p ON i.item_id = p.item_id JOIN ( SELECT distinct item_id from dim_item_type ORDER by item_id ) AS t ON (t.item_id=i.item_id) ORDER by
p.device_item_id, i.item_id ) as q LEFT OUTER JOIN v_etl_global_item_id gi ON (q.item_id=gi.local_item_id) LEFT OUTER JOIN ( SELECT item_id as device_item_id, hostname, primary_ip_address FROM device ) AS
d ON d.device_item_id=q.device_item_id LEFT OUTER JOIN item di ON di.item_id=d.device_item_id AND q.item_id<>d.device_item_id ORDER BY q.item_id]; SQL state [55006]; error code [7888];
[Vertica][VJDBC](7888) ERROR: DDL statement (SwapPartitionEvent) interfered with this statement; nested exception is java.sql.SQLNonTransientException:
[Vertica][VJDBC](7888) ERROR: DDL statement (SwapPartitionEvent) interfered with this statement | (ExceptionLogger.java:99)
org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [CREATE LOCAL TEMPORARY TABLE stg_item_and_device_context ON COMMIT PRESERVE ROWS AS
/*+DIRECT*/ SELECT LEFT(d.hostname,200) as device_hostname, LEFT(v6_ntoa(d.primary_ip_address),50) as device_primary_ip, q.item_id, gi.global_item_id, CASE WHEN d.device_item_id IS NULL THEN 0 ELSE
d.device_item_id END as device_item_id, q.item_name, q.item_description, q.item_display_name, q.item_display_description, LEFT(di.item_name,200) as device_name, LEFT(di.description,200) as
device_description, LEFT(di.item_display_name,200) as device_display_name, LEFT(di.item_display_description,200) as device_display_description FROM ( SELECT i.item_id, p.device_item_id,
LEFT(i.item_name,200) as item_name, LEFT(i.description,200) as item_description, LEFT(i.item_display_name,200) item_display_name, LEFT(i.item_display_description,200) as item_display_description FROM
item AS i JOIN ( SELECT item_id, device_item_id FROM poll_item WHERE is_filtered=0 ORDER BY item_id, device_item_id ) as p ON i.item_id = p.item_id JOIN ( SELECT distinct item_id from dim_item_type ORDER by
item_id ) AS t ON (t.item_id=i.item_id) ORDER by p.device_item_id, i.item_id ) as q LEFT OUTER JOIN v_etl_global_item_id gi ON (q.item_id=gi.local_item_id) LEFT OUTER JOIN ( SELECT item_id as device_item_id,
hostname, primary_ip_address FROM device ) AS d ON d.device_item_id=q.device_item_id LEFT OUTER JOIN item di ON di.item_id=d.device_item_id AND q.item_id<>d.device_item_id ORDER BY q.item_id];
SQL state [55006]; error code [7888]; [Vertica][VJDBC](7888) ERROR: DDL statement (SwapPartitionEvent) interfered with this statement; nested exception is java.sql.SQLNonTransientException:
[Vertica][VJDBC](7888) ERROR: DDL statement (SwapPartitionEvent) interfered with this statement
/*+DIRECT*/ SELECT LEFT(d.hostname,200) as device_hostname, LEFT(v6_ntoa(d.primary_ip_address),50) as device_primary_ip, q.item_id, gi.global_item_id, CASE WHEN d.device_item_id IS NULL THEN 0 ELSE
d.device_item_id END as device_item_id, q.item_name, q.item_description, q.item_display_name, q.item_display_description, LEFT(di.item_name,200) as device_name, LEFT(di.description,200) as
device_description, LEFT(di.item_display_name,200) as device_display_name, LEFT(di.item_display_description,200) as device_display_description FROM ( SELECT i.item_id, p.device_item_id,
LEFT(i.item_name,200) as item_name, LEFT(i.description,200) as item_description, LEFT(i.item_display_name,200) item_display_name, LEFT(i.item_display_description,200) as item_display_description FROM
item AS i JOIN ( SELECT item_id, device_item_id FROM poll_item WHERE is_filtered=0 ORDER BY item_id, device_item_id ) as p ON i.item_id = p.item_id JOIN ( SELECT distinct item_id from dim_item_type ORDER by
item_id ) AS t ON (t.item_id=i.item_id) ORDER by p.device_item_id, i.item_id ) as q LEFT OUTER JOIN v_etl_global_item_id gi ON (q.item_id=gi.local_item_id) LEFT OUTER JOIN ( SELECT item_id as device_item_id,
hostname, primary_ip_address FROM device ) AS d ON d.device_item_id=q.device_item_id LEFT OUTER JOIN item di ON di.item_id=d.device_item_id AND q.item_id<>d.device_item_id ORDER BY q.item_id];
SQL state [55006]; error code [7888]; [Vertica][VJDBC](7888) ERROR: DDL statement (SwapPartitionEvent) interfered with this statement; nested exception is java.sql.SQLNonTransientException:
[Vertica][VJDBC](7888) ERROR: DDL statement (SwapPartitionEvent) interfered with this statement
at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1542) ~[bundleFile:?]
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:393) ~[bundleFile:?]
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:558) ~[bundleFile:?]
at com.ca.im.dm.core.database.dao.impl.DimItemLoaderDAOImpl.jdbcUpdate(DimItemLoaderDAOImpl.java:694) ~[?:?]
at com.ca.im.dm.core.database.dao.impl.DimItemLoaderDAOImpl.createTemporaryTableWithItemAndDeviceContext(DimItemLoaderDAOImpl.java:487) ~[?:?]
at com.ca.im.dm.core.database.dao.impl.DimItemLoaderDAOImpl.performDimItemETL(DimItemLoaderDAOImpl.java:122) ~[?:?]
at jdk.internal.reflect.GeneratedMethodAccessor1279.invoke(Unknown Source) ~[?:?]
at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[?:?]
at java.lang.reflect.Method.invoke(Unknown Source) ~[?:?]
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344) ~[bundleFile:?]
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198) ~[bundleFile:?]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[bundleFile:?]
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123) ~[bundleFile:?]
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388) ~[bundleFile:?]
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119) ~[bundleFile:?]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[bundleFile:?]
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:241) ~[bundleFile:?]
at com.sun.proxy.$Proxy194.performDimItemETL(Unknown Source) ~[?:?]
at jdk.internal.reflect.GeneratedMethodAccessor1279.invoke(Unknown Source) ~[?:?]
at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[?:?]
at java.lang.reflect.Method.invoke(Unknown Source) ~[?:?]
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344) ~[bundleFile:?]
at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:56) ~[?:?]
at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.invoke(ServiceInvoker.java:60) ~[?:?]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[bundleFile:?]
at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:137) ~[bundleFile:?]
at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:124) ~[bundleFile:?]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[bundleFile:?]
at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invokeUnprivileged(ServiceTCCLInterceptor.java:70) ~[?:?]
at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invoke(ServiceTCCLInterceptor.java:53) ~[?:?]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[bundleFile:?]
at org.eclipse.gemini.blueprint.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:57) ~[bundleFile:3.0.0.M01]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[bundleFile:?]
at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:137) ~[bundleFile:?]
at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:124) ~[bundleFile:?]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[bundleFile:?]
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:241) ~[bundleFile:?]
at com.sun.proxy.$Proxy442.performDimItemETL(Unknown Source) ~[?:?]
at com.ca.im.dm.core.aggregator.batch.dimitems.impl.DimItemsJob.execute(DimItemsJob.java:82) ~[bundleFile:?]
at org.quartz.core.JobRunShell.run(JobRunShell.java:202) ~[quartz-2.3.2.jar:?]
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573) ~[quartz-2.3.2.jar:?]
Caused by: java.sql.SQLNonTransientException: [Vertica][VJDBC](7888) ERROR: DDL statement (SwapPartitionEvent) interfered with this statement
at com.vertica.util.ServerErrorData.buildException(Unknown Source) ~[?:?]
at com.vertica.dataengine.VQueryExecutor.executeSimpleProtocol(Unknown Source) ~[?:?]
at com.vertica.dataengine.VQueryExecutor.execute(Unknown Source) ~[?:?]
at com.vertica.jdbc.common.SStatement.executeNoParams(SStatement.java:3349) ~[?:?]
at com.vertica.jdbc.common.SStatement.executeAnyUpdate(SStatement.java:1266) ~[?:?]
at com.vertica.jdbc.common.SStatement.executeUpdate(SStatement.java:1215) ~[?:?]
at jdk.internal.reflect.GeneratedMethodAccessor727.invoke(Unknown Source) ~[?:?]
at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[?:?]
at java.lang.reflect.Method.invoke(Unknown Source) ~[?:?]
at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:118) ~[bundleFile:?]
at com.sun.proxy.$Proxy138.executeUpdate(Unknown Source) ~[?:?]
at org.springframework.jdbc.core.JdbcTemplate$1UpdateStatementCallback.doInStatement(JdbcTemplate.java:546) ~[bundleFile:?]
at org.springframework.jdbc.core.JdbcTemplate$1UpdateStatementCallback.doInStatement(JdbcTemplate.java:543) ~[bundleFile:?]
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:381) ~[bundleFile:?]
... 39 more
Caused by: com.vertica.support.exceptions.NonTransientException: [Vertica][VJDBC](7888) ERROR: DDL statement (SwapPartitionEvent) interfered with this statement
at com.vertica.util.ServerErrorData.buildException(Unknown Source) ~[?:?]
at com.vertica.dataengine.VQueryExecutor.executeSimpleProtocol(Unknown Source) ~[?:?]
at com.vertica.dataengine.VQueryExecutor.execute(Unknown Source) ~[?:?]
at com.vertica.jdbc.common.SStatement.executeNoParams(SStatement.java:3349) ~[?:?]
at com.vertica.jdbc.common.SStatement.executeAnyUpdate(SStatement.java:1266) ~[?:?]
at com.vertica.jdbc.common.SStatement.executeUpdate(SStatement.java:1215) ~[?:?]
at jdk.internal.reflect.GeneratedMethodAccessor727.invoke(Unknown Source) ~[?:?]
at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[?:?]
at java.lang.reflect.Method.invoke(Unknown Source) ~[?:?]
at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:118) ~[bundleFile:?]
at com.sun.proxy.$Proxy138.executeUpdate(Unknown Source) ~[?:?]
at org.springframework.jdbc.core.JdbcTemplate$1UpdateStatementCallback.doInStatement(JdbcTemplate.java:546) ~[bundleFile:?]
at org.springframework.jdbc.core.JdbcTemplate$1UpdateStatementCallback.doInStatement(JdbcTemplate.java:543) ~[bundleFile:?]
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:381) ~[bundleFile:?]
... 39 more
Environment
Dx NetOps pre 23.3.11
Cause
Vertica db defect
Resolution
Upgrade to DX NetOps 23.3.11 or above
Additional Information
Feedback
Yes
No
Powered by
