cloudstack-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dean Kamali <dean.kam...@gmail.com>
Subject Re: Urgent - usage databae always empty
Date Wed, 30 Oct 2013 17:52:13 GMT
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.kamali@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 <tgraham@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.kamali@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 <tgraham@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.kamali@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 <tgraham@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.kamali@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.patnala@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.kamali@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
>> >>>>>>
>> >>>>>>
>> >>>>
>> >>>>
>> >>
>> >>
>>
>>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message