Hi Dean, Can you summarise the issue occurred and how you solved it. It helps people to quickly look into the similar problem and solution.
Thanks Harikrishna On 30-Oct-2013, at 11:22 pm, Dean Kamali <dean.kam...@gmail.com> wrote: > Well, it seems that all what I needed was more patience, even tho the above > message shows in the logs, I waited for 10 minutes and usage data started > populating in an interval of 10 mins. > > Thanks everyone for your help! > > > On Wed, Oct 30, 2013 at 12:11 PM, Dean Kamali <dean.kam...@gmail.com> wrote: > >> I have tried your suggestion, and I see that usage_job gets updated after >> I delete the entry there, and restart the usage service. >> I have also truncated all tables, "nice feature in sqlyog" and, I'm still >> not able to see any data. >> >> I'm still seeing the following in the logs: >> >> 2013-10-30 16:06:58,941 INFO [cloud.usage.UsageServer] (main:null) >> UsageServer ready... >> 2013-10-30 16:08:00,001 INFO [cloud.usage.UsageManagerImpl] >> (Usage-Job-1:null) starting usage job... >> 2013-10-30 16:08:00,007 DEBUG [cloud.usage.UsageManagerImpl] >> (Usage-Job-1:null) Not owner of usage job, skipping... >> 2013-10-30 16:08:00,007 INFO [cloud.usage.UsageManagerImpl] >> (Usage-Job-1:null) usage job complete >> >> I have re-deployed the management server on Ubuntu / Center with same >> results. >> >> Dean >> >> >> On Wed, Oct 30, 2013 at 10:47 AM, Travis Graham <tgra...@tgraham.us>wrote: >> >>> Can you try stopping the cloudstack-usage process, removing any records >>> you have in the usage_job table, then restarting cloudstack-usage and >>> change your settings to get it to run again if needed? >>> >>> Just to be safe, do db dumps on both your cloud and cloud_usage databases >>> before removing any records. >>> >>> Travis >>> >>> On Oct 30, 2013, at 10:17 AM, Dean Kamali <dean.kam...@gmail.com> wrote: >>> >>>> Thanks Marty, Travis >>>> >>>> I have changed the default GMT, and I have set both aggregation and >>>> execution timezone to America/New_York, yet, and I have restarted both >>>> management and usage servers. >>>> >>>> still getting this stupid error "Not owner of usage job, skipping... " >>> when >>>> execution time occur" >>>> >>>> Any other ideas? >>>> >>>> Dean >>>> >>>> >>>> On Wed, Oct 30, 2013 at 9:24 AM, Travis Graham <tgra...@tgraham.us> >>> wrote: >>>> >>>>> Can you check your timezone settings in the global configs to make sure >>>>> there's a correct timezone? >>>>> >>>>> usage.aggregation.tiemzone >>>>> usage.execution.timezone >>>>> >>>>> >>>>> >>> http://cloudstack.apache.org/docs/en-US/Apache_CloudStack/4.0.2/html/Admin_Guide/time-zones.html >>>>> >>>>> We had issues with the default GMT setting where the jobs wouldn't run >>>>> until we set both of those settings to our current timezone. >>>>> >>>>> You'll notice the default GMT isn't an exact match in the list >>> provided in >>>>> the link above. >>>>> >>>>> Search for usage in the Global Settings section of the UI and verify >>> all >>>>> the settings are sane. >>>>> >>>>> Travis >>>>> >>>>> On Oct 30, 2013, at 9:13 AM, Dean Kamali <dean.kam...@gmail.com> >>> wrote: >>>>> >>>>>> Yes it is running >>>>>> >>>>>> /etc/init.d/cloudstack-usage status >>>>>> >>>>>> cloudstack-usage (pid 3435) is running... >>>>>> >>>>>> checking usage db, usage_job table it shows the following >>>>>> >>>>>> it shows pid number (however its different from pid id 3435, which >>> shows >>>>>> when running status command), heartbeat info along with start and >>>>> end_date >>>>>> >>>>>> I have checked the logs, I keep seeing "Not owner of usage job, >>>>>> skipping... " when execution time occur. >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> On Wed, Oct 30, 2013 at 8:32 AM, Travis Graham <tgra...@tgraham.us> >>>>> wrote: >>>>>> >>>>>>> Is the usage agent actually running? >>>>>>> >>>>>>> # service cloudstack-usage status >>>>>>> >>>>>>> And do you have the cloudstack-usage init script in /etc/init.d/ ? >>>>>>> >>>>>>> Travis >>>>>>> >>>>>>> On Oct 30, 2013, at 8:20 AM, Dean Kamali <dean.kam...@gmail.com> >>> wrote: >>>>>>> >>>>>>>> in my centos 6.4 , I find a I see a symbolic link in >>>>>>> /etc/cloudstack/usage >>>>>>>> which points to /etc/cloudstack/management/db.properties >>>>>>>> >>>>>>>> I checked the content of the file and seems okay ( it contain db >>> name, >>>>>>>> username, password), I have deployed cloudstack management server on >>>>>>> Ubuntu >>>>>>>> with exact behavior. >>>>>>>> >>>>>>>> I think its a bug! >>>>>>>> >>>>>>>> Can someone help? >>>>>>>> >>>>>>>> Dean >>>>>>>> >>>>>>>> >>>>>>>> On Wed, Oct 30, 2013 at 2:24 AM, Harikrishna Patnala < >>>>>>>> harikrishna.patn...@citrix.com> wrote: >>>>>>>> >>>>>>>>> Hi, >>>>>>>>> Can you check db.properties file for correct db connection >>>>>>> configurations. >>>>>>>>> >>>>>>>>> Thanks >>>>>>>>> Harikrishna >>>>>>>>> On 30-Oct-2013, at 9:02 am, Dean Kamali <dean.kam...@gmail.com> >>>>> wrote: >>>>>>>>> >>>>>>>>>> Hello everyone >>>>>>>>>> >>>>>>>>>> I never seen issue with 4.1.1 but with 4.2, I'm not able to get >>> usage >>>>>>>>>> database to work. >>>>>>>>>> >>>>>>>>>> it has been very frustrating day for me, and no sign of hope! >>>>>>>>>> >>>>>>>>>> cloud_usage database is empty >>>>>>>>>> >>>>>>>>>> checking the logs I always get UsageServer ready... and no errors >>> or >>>>>>>>>> exceptions. >>>>>>>>>> >>>>>>>>>> I have restarted usage server many times, with no luck. >>>>>>>>>> >>>>>>>>>> usage_job table which suppose to show host and pid number for >>> usuage >>>>>>>>> server >>>>>>>>>> is always Null. >>>>>>>>>> >>>>>>>>>> Any ideas on what I need to check. >>>>>>>>>> >>>>>>>>>> Please help! >>>>>>>>>> >>>>>>>>>> Thank you >>>>>>>>> >>>>>>>>> >>>>>>> >>>>>>> >>>>> >>>>> >>> >>> >>