cloudstack-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "shweta agarwal (JIRA)" <j...@apache.org>
Subject [jira] [Closed] (CLOUDSTACK-4280) java.sql.SQLException: Parameter index out of range (18 > number of parameters, which is 17) in usage manager
Date Tue, 13 Aug 2013 06:20:47 GMT

     [ https://issues.apache.org/jira/browse/CLOUDSTACK-4280?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

shweta agarwal closed CLOUDSTACK-4280.
--------------------------------------

    Resolution: Duplicate
    
> java.sql.SQLException: Parameter index out of range (18 > number of parameters, which
is 17) in usage manager 
> --------------------------------------------------------------------------------------------------------------
>
>                 Key: CLOUDSTACK-4280
>                 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-4280
>             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

Mime
View raw message