subject:"\[jira\] \[Commented\] \(CLOUDSTACK\-2452\) Usage\:F5\:SRX\:usage manager failed with db exception due to undefiled field account.default \(cloud_usage.account.default field is missing\)"

[jira] [Commented] (CLOUDSTACK-2452) Usage:F5:SRX:usage manager failed with db exception due to undefiled field account.default (cloud_usage.account.default field is missing)

2013-05-24 Thread ASF subversion and git services (JIRA)


[ 
https://issues.apache.org/jira/browse/CLOUDSTACK-2452?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13666184#comment-13666184
 ] 

ASF subversion and git services commented on CLOUDSTACK-2452:
-

Commit ba67e5d56ed9e960e947925f82d2dda2204389ce in branch refs/heads/master 
from [~kishan]
[ https://git-wip-us.apache.org/repos/asf?p=cloudstack.git;h=ba67e5d ]

CLOUDSTACK-2452: Fixed account upgrade for usage. Added cloumn default. Updated 
usage response for PF , LB and VPN to return UUID instead of Id


 Usage:F5:SRX:usage manager failed with db exception due to undefiled field 
 account.default (cloud_usage.account.default field is missing)
 ---

 Key: CLOUDSTACK-2452
 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-2452
 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: sadhu suresh
Priority: Critical

 Noticed usage manager failed with runtime exception: a undefined filed  
 account.default  exits in the request sql query by the usage manager , due 
 to this usage statistics job fail  with 
 i.e  account.default field is missing in the cloud_usage.account table.
 1.install the usage server
 2.configure the usage serve to query the usage statistics for every 10 min
 3.configure the lb and generate the load form VM 
 4.observe the usage statistics.
 actual results:
 usage job failed with runtime exception
 013-05-13 10:45:09,191 ERROR [cloud.usage.UsageManagerImpl] 
 (Usage-Job-1:null) Exception in usage manager
 com.cloud.utils.exception.CloudRuntimeException: DB Exception on: 
 com.mysql.jdbc.JDBC4PreparedStatement@5508e44d: SELECT account.id, 
 account.account_name, account.type, account.domain_id, account.state, 
 account.removed, account.cleanup_needed, account.network_domain, 
 account.uuid, account.default_zone_id, account.default FROM account WHERE 
 account.id = 2
 at com.cloud.utils.db.GenericDaoBase.findById(GenericDaoBase.java:979)
 at 
 com.cloud.user.dao.AccountDaoImpl_EnhancerByCloudStack_c97e9195.CGLIB$findById$35(generated)
 at 
 com.cloud.user.dao.AccountDaoImpl_EnhancerByCloudStack_c97e9195_FastClassByCloudStack_e3754c48.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.user.dao.AccountDaoImpl_EnhancerByCloudStack_c97e9195.findById(generated)
 at 
 com.cloud.utils.db.GenericDaoBase.findByIdIncludingRemoved(GenericDaoBase.java:939)
 at 
 com.cloud.user.dao.AccountDaoImpl_EnhancerByCloudStack_c97e9195.CGLIB$findByIdIncludingRemoved$36(generated)
 at 
 com.cloud.user.dao.AccountDaoImpl_EnhancerByCloudStack_c97e9195_FastClassByCloudStack_e3754c48.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.user.dao.AccountDaoImpl_EnhancerByCloudStack_c97e9195.findByIdIncludingRemoved(generated)
 at 
 com.cloud.usage.UsageManagerImpl.createVolumeHelperEvent(UsageManagerImpl.java:1075)
 at 
 com.cloud.usage.UsageManagerImpl.createHelperRecord(UsageManagerImpl.java:764)
 at com.cloud.usage.UsageManagerImpl.parse(UsageManagerImpl.java:509)
 at com.cloud.usage.UsageManagerImpl.run(UsageManagerImpl.java:323)
 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.MySQLSyntaxErrorException: Unknown 
 column 'account.default' in 'field list'
 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native 
 Method)
 at

[jira] [Commented] (CLOUDSTACK-2452) Usage:F5:SRX:usage manager failed with db exception due to undefiled field account.default (cloud_usage.account.default field is missing)

2013-05-13 Thread sadhu suresh (JIRA)


[ 
https://issues.apache.org/jira/browse/CLOUDSTACK-2452?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13655817#comment-13655817
 ] 

sadhu suresh commented on CLOUDSTACK-2452:
--

work around:

use below query to update the missing field in cloud_usage.account tables:
mysqluse cloud_usage;
 mysqlalter table account add column `default` int(1) unsigned NOT NULL 
DEFAULT '0';


 Usage:F5:SRX:usage manager failed with db exception due to undefiled field 
 account.default (cloud_usage.account.default field is missing)
 ---

 Key: CLOUDSTACK-2452
 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-2452
 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: sadhu suresh
Priority: Blocker

 Noticed usage manager failed with runtime exception: a undefined filed  
 account.default  exits in the request sql query by the usage manager , due 
 to this usage statistics job fail  with 
 i.e  account.default field is missing in the cloud_usage.account table.
 1.install the usage server
 2.configure the usage serve to query the usage statistics for every 10 min
 3.configure the lb and generate the load form VM 
 4.observe the usage statistics.
 actual results:
 usage job failed with runtime exception
 013-05-13 10:45:09,191 ERROR [cloud.usage.UsageManagerImpl] 
 (Usage-Job-1:null) Exception in usage manager
 com.cloud.utils.exception.CloudRuntimeException: DB Exception on: 
 com.mysql.jdbc.JDBC4PreparedStatement@5508e44d: SELECT account.id, 
 account.account_name, account.type, account.domain_id, account.state, 
 account.removed, account.cleanup_needed, account.network_domain, 
 account.uuid, account.default_zone_id, account.default FROM account WHERE 
 account.id = 2
 at com.cloud.utils.db.GenericDaoBase.findById(GenericDaoBase.java:979)
 at 
 com.cloud.user.dao.AccountDaoImpl_EnhancerByCloudStack_c97e9195.CGLIB$findById$35(generated)
 at 
 com.cloud.user.dao.AccountDaoImpl_EnhancerByCloudStack_c97e9195_FastClassByCloudStack_e3754c48.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.user.dao.AccountDaoImpl_EnhancerByCloudStack_c97e9195.findById(generated)
 at 
 com.cloud.utils.db.GenericDaoBase.findByIdIncludingRemoved(GenericDaoBase.java:939)
 at 
 com.cloud.user.dao.AccountDaoImpl_EnhancerByCloudStack_c97e9195.CGLIB$findByIdIncludingRemoved$36(generated)
 at 
 com.cloud.user.dao.AccountDaoImpl_EnhancerByCloudStack_c97e9195_FastClassByCloudStack_e3754c48.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.user.dao.AccountDaoImpl_EnhancerByCloudStack_c97e9195.findByIdIncludingRemoved(generated)
 at 
 com.cloud.usage.UsageManagerImpl.createVolumeHelperEvent(UsageManagerImpl.java:1075)
 at 
 com.cloud.usage.UsageManagerImpl.createHelperRecord(UsageManagerImpl.java:764)
 at com.cloud.usage.UsageManagerImpl.parse(UsageManagerImpl.java:509)
 at com.cloud.usage.UsageManagerImpl.run(UsageManagerImpl.java:323)
 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.MySQLSyntaxErrorException: Unknown 
 column 'account.default' in 'field list'
 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native 
 Method)
 at 
 sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
 at 
 sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

[jira] [Commented] (CLOUDSTACK-2452) Usage:F5:SRX:usage manager failed with db exception due to undefiled field account.default (cloud_usage.account.default field is missing)

2013-05-13 Thread sadhu suresh (JIRA)


[ 
https://issues.apache.org/jira/browse/CLOUDSTACK-2452?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13655845#comment-13655845
 ] 

sadhu suresh commented on CLOUDSTACK-2452:
--

mysqlupdate account set `default`=1 where id in(1,2);


 Usage:F5:SRX:usage manager failed with db exception due to undefiled field 
 account.default (cloud_usage.account.default field is missing)
 ---

 Key: CLOUDSTACK-2452
 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-2452
 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: sadhu suresh
Priority: Critical

 Noticed usage manager failed with runtime exception: a undefined filed  
 account.default  exits in the request sql query by the usage manager , due 
 to this usage statistics job fail  with 
 i.e  account.default field is missing in the cloud_usage.account table.
 1.install the usage server
 2.configure the usage serve to query the usage statistics for every 10 min
 3.configure the lb and generate the load form VM 
 4.observe the usage statistics.
 actual results:
 usage job failed with runtime exception
 013-05-13 10:45:09,191 ERROR [cloud.usage.UsageManagerImpl] 
 (Usage-Job-1:null) Exception in usage manager
 com.cloud.utils.exception.CloudRuntimeException: DB Exception on: 
 com.mysql.jdbc.JDBC4PreparedStatement@5508e44d: SELECT account.id, 
 account.account_name, account.type, account.domain_id, account.state, 
 account.removed, account.cleanup_needed, account.network_domain, 
 account.uuid, account.default_zone_id, account.default FROM account WHERE 
 account.id = 2
 at com.cloud.utils.db.GenericDaoBase.findById(GenericDaoBase.java:979)
 at 
 com.cloud.user.dao.AccountDaoImpl_EnhancerByCloudStack_c97e9195.CGLIB$findById$35(generated)
 at 
 com.cloud.user.dao.AccountDaoImpl_EnhancerByCloudStack_c97e9195_FastClassByCloudStack_e3754c48.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.user.dao.AccountDaoImpl_EnhancerByCloudStack_c97e9195.findById(generated)
 at 
 com.cloud.utils.db.GenericDaoBase.findByIdIncludingRemoved(GenericDaoBase.java:939)
 at 
 com.cloud.user.dao.AccountDaoImpl_EnhancerByCloudStack_c97e9195.CGLIB$findByIdIncludingRemoved$36(generated)
 at 
 com.cloud.user.dao.AccountDaoImpl_EnhancerByCloudStack_c97e9195_FastClassByCloudStack_e3754c48.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.user.dao.AccountDaoImpl_EnhancerByCloudStack_c97e9195.findByIdIncludingRemoved(generated)
 at 
 com.cloud.usage.UsageManagerImpl.createVolumeHelperEvent(UsageManagerImpl.java:1075)
 at 
 com.cloud.usage.UsageManagerImpl.createHelperRecord(UsageManagerImpl.java:764)
 at com.cloud.usage.UsageManagerImpl.parse(UsageManagerImpl.java:509)
 at com.cloud.usage.UsageManagerImpl.run(UsageManagerImpl.java:323)
 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.MySQLSyntaxErrorException: Unknown 
 column 'account.default' in 'field list'
 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native 
 Method)
 at 
 sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
 at 
 sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
 at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
 at

[jira] [Commented] (CLOUDSTACK-2452) Usage:F5:SRX:usage manager failed with db exception due to undefiled field account.default (cloud_usage.account.default field is missing)

[jira] [Commented] (CLOUDSTACK-2452) Usage:F5:SRX:usage manager failed with db exception due to undefiled field account.default (cloud_usage.account.default field is missing)

[jira] [Commented] (CLOUDSTACK-2452) Usage:F5:SRX:usage manager failed with db exception due to undefiled field account.default (cloud_usage.account.default field is missing)

3 matches

Site Navigation

Mail list logo

Footer information