You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@cloudstack.apache.org by "shweta agarwal (JIRA)" <ji...@apache.org> on 2013/08/13 08:18:47 UTC
[jira] [Created] (CLOUDSTACK-4279) java.sql.SQLException: Parameter
index out of range (18 > number of parameters, which is 17) in usage
manager
shweta agarwal created CLOUDSTACK-4279:
------------------------------------------
Summary: java.sql.SQLException: Parameter index out of range (18 > number of parameters, which is 17) in usage manager
Key: CLOUDSTACK-4279
URL: https://issues.apache.org/jira/browse/CLOUDSTACK-4279
Project: CloudStack
Issue Type: Bug
Security Level: Public (Anyone can view this level - this is the default.)
Components: Usage
Affects Versions: 4.2.0
Reporter: shweta agarwal
Priority: Blocker
Fix For: 4.2.0
usage server failing with following exception
java.sql.SQLException: Parameter index out of range (18 > number of parameters, which is 17) in usage manager
2013-08-13 00:00:01,631 ERROR [usage.dao.UsageDaoImpl] (Usage-Job-1:null) error saving usage records to cloud_usage db
java.sql.SQLException: Parameter index out of range (18 > number of parameters, which is 17).
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)
at com.mysql.jdbc.PreparedStatement.checkBounds(PreparedStatement.java:3805)
at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:3787)
at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:3832)
at com.mysql.jdbc.PreparedStatement.setNull(PreparedStatement.java:3872)
at org.apache.commons.dbcp.DelegatingPreparedStatement.setNull(DelegatingPreparedStatement.java:108)
at org.apache.commons.dbcp.DelegatingPreparedStatement.setNull(DelegatingPreparedStatement.java:108)
at org.apache.commons.dbcp.DelegatingPreparedStatement.setNull(DelegatingPreparedStatement.java:108)
at com.cloud.usage.dao.UsageDaoImpl.saveUsageRecords(UsageDaoImpl.java:436)
at com.cloud.usage.dao.UsageDaoImpl_EnhancerByCloudStack_50cf8aaa.CGLIB$saveUsageRecords$12(<generated>)
at com.cloud.usage.dao.UsageDaoImpl_EnhancerByCloudStack_50cf8aaa_FastClassByCloudStack_90525759.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228)
at com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125)
at com.cloud.usage.dao.UsageDaoImpl_EnhancerByCloudStack_50cf8aaa.saveUsageRecords(<generated>)
at com.cloud.usage.parser.NetworkUsageParser.parse(NetworkUsageParser.java:133)
at com.cloud.usage.UsageManagerImpl.parseHelperTables(UsageManagerImpl.java:795)
at com.cloud.usage.UsageManagerImpl.parse(UsageManagerImpl.java:695)
at com.cloud.usage.UsageManagerImpl.run(UsageManagerImpl.java:334)
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:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:679)
2013-08-13 00:00:01,632 ERROR [usage.parser.NetworkUsageParser] (Usage-Job-1:null) Exception in usage manager
com.cloud.utils.exception.CloudRuntimeException: Parameter index out of range (18 > number of parameters, which is 17).
at com.cloud.usage.dao.UsageDaoImpl.saveUsageRecords(UsageDaoImpl.java:445)
at com.cloud.usage.dao.UsageDaoImpl_EnhancerByCloudStack_50cf8aaa.CGLIB$saveUsageRecords$12(<generated>)
at com.cloud.usage.dao.UsageDaoImpl_EnhancerByCloudStack_50cf8aaa_FastClassByCloudStack_90525759.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228)
at com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125)
at com.cloud.usage.dao.UsageDaoImpl_EnhancerByCloudStack_50cf8aaa.saveUsageRecords(<generated>)
at com.cloud.usage.parser.NetworkUsageParser.parse(NetworkUsageParser.java:133)
at com.cloud.usage.UsageManagerImpl.parseHelperTables(UsageManagerImpl.java:795)
at com.cloud.usage.UsageManagerImpl.parse(UsageManagerImpl.java:695)
at com.cloud.usage.UsageManagerImpl.run(UsageManagerImpl.java:334)
--
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