Re: cloudstack-usage no longer working / error saving account to cloud_usage db

2016-08-18 Thread Rohit Yadav
dstack-usage no longer working / error saving account to cloud_usage db Hi Rohit, thanks! Having a recent DB backup at hand and only based on guesses, I did some further experiments yesterday :) - Rerun /usr/share/cloudstack-common/scripts/util/migrate- dynamicroles.py - Checked cloudstack-usage 4.8

Re: cloudstack-usage no longer working / error saving account to cloud_usage db

2016-08-18 Thread Stephan Seitz
Hi Rohit, thanks! Having a recent DB backup at hand and only based on guesses, I did some further experiments yesterday :) - Rerun /usr/share/cloudstack-common/scripts/util/migrate- dynamicroles.py - Checked cloudstack-usage 4.8.0.1 instead of 4.9 - Updated back to cloudstack-usage 4.9 ... and ma

Re: cloudstack-usage no longer working / error saving account to cloud_usage db

2016-08-18 Thread Rohit Yadav
Hi Stephan, In cloud_usage.account `role_id` can be NULL as there is no user of this field within the usage server. In cloud.account, the `role_id` should be automatically populated/migrated when you upgraded. From your shared db query result, I'm not sure if that's a select query on cloud.acc

Re: cloudstack-usage no longer working / error saving account to cloud_usage db

2016-08-17 Thread Rajani Karuturi
role_id in account table shouldn't be null. If the upgrade was successful, it should have updated it with proper mapping from account type. (check the db upgrade log for any exceptions) I suggest you do the update manually following the logic at https://github.com/apache/cloudstack/blob/4.9/engine

cloudstack-usage no longer working / error saving account to cloud_usage db

2016-08-16 Thread Stephan Seitz
Hi! We've recently noticed cloudstack-usage is no longer able to write usage data into mysql. I assume this happened after updateing to 4.8.0.1 or 4.9 - we missed that error in our testsetup... Here's the usage.log: http://pastebin.com/Zpvnw4xX Finally it fails with following message: ERROR [us