cloudstack-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kishan Kavala (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CLOUDSTACK-2845) [DB upgrade] [ExternalLoadBalancer NetworkUsage] Duplicate entries in the database since upgrade to 4.1.0
Date Thu, 08 Aug 2013 09:38:49 GMT

    [ https://issues.apache.org/jira/browse/CLOUDSTACK-2845?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13733311#comment-13733311
] 

Kishan Kavala commented on CLOUDSTACK-2845:
-------------------------------------------

Reduced priority to Major. Priority can reviewed if we come across this issue again.
                
> [DB upgrade] [ExternalLoadBalancer NetworkUsage] Duplicate entries in the database since
upgrade to 4.1.0
> ---------------------------------------------------------------------------------------------------------
>
>                 Key: CLOUDSTACK-2845
>                 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-2845
>             Project: CloudStack
>          Issue Type: Bug
>      Security Level: Public(Anyone can view this level - this is the default.) 
>          Components: Management Server, Upgrade
>    Affects Versions: 4.1.0
>            Reporter: Francois Gaudreault
>             Fix For: 4.1.0, 4.2.0
>
>
> Getting duplicate key entries in the management log related to NetScaler load balancer
since our upgrade from 4.0.0 to 4.1.0.
> 2013-06-04 19:38:58,038 DEBUG [db.Transaction.Transaction] (ExternalNetworkMonitor-1:null)
Rolling back the transaction: Time = 5 Name =  -ExternalLoadBalancerUsageManagerImpl$ExternalDeviceNetworkUsageTask.manageStatsEntries:597-ExternalLoadBalancerUsageManagerImpl$ExternalDeviceNetworkUsageTask.runExternalDeviceNetworkUsageTask:462-ExternalLoadBalancerUsageManagerImpl$ExternalDeviceNetworkUsageTask.run:338-Executors$RunnableAdapter.call:471-FutureTask$Sync.innerRunAndReset:351-FutureTask.runAndReset:178-ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201:165-ScheduledThreadPoolExecutor$ScheduledFutureTask.run:267-ThreadPoolExecutor.runWorker:1146-ThreadPoolExecutor$Worker.run:615-Thread.run:679;
called by -Transaction.rollback:890-Transaction.removeUpTo:833-Transaction.close:657-TransactionContextBuilder.interceptException:63-ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept:133-ExternalLoadBalancerUsageManagerImpl$ExternalDeviceNetworkUsageTask.createStatsEntry:501-ExternalLoadBalancerUsageManagerImpl$ExternalDeviceNetworkUsageTask.createOrUpdateStatsEntry:582-ExternalLoadBalancerUsageManagerImpl$ExternalDeviceNetworkUsageTask.manageStatsEntries:653-ExternalLoadBalancerUsageManagerImpl$ExternalDeviceNetworkUsageTask.runExternalDeviceNetworkUsageTask:462-ExternalLoadBalancerUsageManagerImpl$ExternalDeviceNetworkUsageTask.run:338-Executors$RunnableAdapter.call:471-FutureTask$Sync.innerRunAndReset:351
> 2013-06-04 19:38:58,041 WARN  [cloud.network.ExternalLoadBalancerUsageManagerImpl] (ExternalNetworkMonitor-1:null)
Exception: 
> javax.persistence.EntityExistsException: Entity already exists: 
> 	at com.cloud.utils.db.GenericDaoBase.persist(GenericDaoBase.java:1340)
> 	at com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125)
> 	at com.cloud.network.ExternalLoadBalancerUsageManagerImpl$ExternalDeviceNetworkUsageTask.createStatsEntry(ExternalLoadBalancerUsageManagerImpl.java:501)
> 	at com.cloud.network.ExternalLoadBalancerUsageManagerImpl$ExternalDeviceNetworkUsageTask.createOrUpdateStatsEntry(ExternalLoadBalancerUsageManagerImpl.java:582)
> 	at com.cloud.network.ExternalLoadBalancerUsageManagerImpl$ExternalDeviceNetworkUsageTask.manageStatsEntries(ExternalLoadBalancerUsageManagerImpl.java:653)
> 	at com.cloud.network.ExternalLoadBalancerUsageManagerImpl$ExternalDeviceNetworkUsageTask.runExternalDeviceNetworkUsageTask(ExternalLoadBalancerUsageManagerImpl.java:462)
> 	at com.cloud.network.ExternalLoadBalancerUsageManagerImpl$ExternalDeviceNetworkUsageTask.run(ExternalLoadBalancerUsageManagerImpl.java:338)
> 	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
> 	at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:351)
> 	at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:178)
> 	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:165)
> 	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:267)
> 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1146)
> 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> 	at java.lang.Thread.run(Thread.java:679)
> Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:
Duplicate entry '5-1-74.121.246.133-8-ExternalLoadBalancer' for key 'account_id'
> 	at sun.reflect.GeneratedConstructorAccessor303.newInstance(Unknown Source)
> 	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> 	at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
> 	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
> 	at com.mysql.jdbc.Util.getInstance(Util.java:386)
> 	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1040)
> 	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4074)
> 	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006)
> 	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2468)
> 	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2629)
> 	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2719)
> 	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
> 	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2450)
> 	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2371)
> 	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2355)
> 	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
> 	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
> 	at com.cloud.utils.db.GenericDaoBase.persist(GenericDaoBase.java:1305)
> 	... 18 more

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message