Hi all,
I have an issue with CB 1.6: When a try to generate a report 4 out of the 5 times, it gives an error. The error reported is
Error reading data from data source for vCenter Chargeback Database
vCenterCB.log on the CB server shows:
2011-04-04 14:27:45,383 ERROR [pool-3-thread-2] stat.UsageCollectorImpl: Error in getting samples from CBDB for vc server 506, resources [1, 2, 6] and entities [vm-3984, vm-4030, vm-4230].com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 75) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196)at com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBuffer.nextRow(SQLServerResultSet.java:4700)at com.microsoft.sqlserver.jdbc.SQLServerResultSet.fetchBufferNext(SQLServerResultSet.java:1683)at com.microsoft.sqlserver.jdbc.SQLServerResultSet.next(SQLServerResultSet.java:956)at com.mchange.v2.c3p0.impl.NewProxyResultSet.next(NewProxyResultSet.java:2859)at com.vmware.vim.vcenter.datacollector.stat.UsageCollectorImpl$5.getSamplesForEntitiesFromCBDB(UsageCollectorImpl.java:508)at com.vmware.vim.vcenter.datacollector.stat.UsageCollectorImpl$5.executeInternal(UsageCollectorImpl.java:460)at com.vmware.vim.vcenter.datacollector.stat.UsageCollectorImpl$5.executeInternal(UsageCollectorImpl.java:443)
From the error I can see that there is a deadlock problem in the database. Has someone an idea what can cause this and how it can be prevented.
My Setup
Chargeback 1.6 with vCloud Director and vShield Manager data collectors
Chargeback database running on SQL Server 2008 Std Edition.
vCenter 4.1 managing around 50 ESX servers and 500 VMs.
Thanks for any feedback
Theo
Hi Theo,
I too have faced the same issue, the setup is similar to yours except mine is v1.5
Once I have the reports scheduled to be mailed to the recipients, I get 2 errors and like as you said it works 5 out of 8 times.
The errors I get is
(1) Unable to save information in the database &
(2) The other error is the one you have mentioned.
Chargeback seems to be a very buggy tool, it still needs a lot of fixes
Any new configuration a user tries, he ends up with a problem
While generating Reports or after scheduling the reports to be generated & mailed, the errors we encounter are
(1) Error reading data from data source for vCenter Chargeback Database
(2) Unable to save information in the database
Does anyone have any idea ? it seems to be a bug
Hi Deepak,
Could you please provide logs to debug this further?
Regards,
Hemanth
Hi,
No idea yet. I still have a support request open at vmWare to have it solved.
Regards,
Theo
