cloudstack-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Marc Cirauqui <mcirau...@gmail.com>
Subject Re: timezone and end_date
Date Tue, 13 Nov 2012 07:03:05 GMT
I think there's a global setting (or maybe usage server configuration file)
where you specify the timezone for usage jobs...


On Fri, Nov 9, 2012 at 7:54 PM, David Nalley <david@gnsa.us> wrote:

> So not sure that this is a definitive answer, and doesn't answer both
> of your quesitons but:
>
> There is (IMO) only one timezone for system purposes, and that is UTC.
>
> --David
>
> On Thu, Nov 1, 2012 at 5:57 AM, psjia <psjia@travelsky.com> wrote:
> > hello,
> >   there are two questions.please help me.
> >
> >
> *********************************************************************************
> >   the first problem, something with the datetime in table
> usage_vm_instance。
> >   i noticed that the datetime in usage_vm_instance is wrong。i think
> maybe there is  a timezone problem。
> >   the status 1:
> >   mysql> select * from usage_vm_instance where vm_instance_id=76;
> >
> +------------+---------+------------+----------------+---------+---------------------+-------------+-----------------+---------------------+----------+
> > | usage_type | zone_id | account_id | vm_instance_id | vm_name |
> service_offering_id | template_id | hypervisor_type | start_date          |
> end_date |
> >
> +------------+---------+------------+----------------+---------+---------------------+-------------+-----------------+---------------------+----------+
> > |          1 |       1 |          2 |             76 | abc2    |
>           1 |         225 | VMware          | 2012-10-31 03:43:04 | NULL
>   |
> > |          2 |       1 |          2 |             76 | abc2    |
>           1 |         225 | VMware          | 2012-10-31 03:41:09 | NULL
>   |
> >
> +------------+---------+------------+----------------+---------+---------------------+-------------+-----------------+---------------------+----------+
> > 2 rows in set (0.00 sec)
> >   then,i stopped this vm in 2012-11-01 15:00(maybe in 14:40--15:20,i
> forgot the actual time )。And start it 5 minutes later。
> >
> >   the status 2:
> >   mysql> select * from usage_vm_instance where vm_instance_id=85;
> >
> +------------+---------+------------+----------------+---------+---------------------+-------------+-----------------+---------------------
> >
> > +---------------------+
> > | usage_type | zone_id | account_id | vm_instance_id | vm_name |
> service_offering_id | template_id | hypervisor_type | start_date          |
> end_date
> >
> >         |
> >
> +------------+---------+------------+----------------+---------+---------------------+-------------+-----------------+---------------------
> >
> > +---------------------+
> > |          1 |       1 |          2 |             85 | lin1    |
>           1 |         230 | VMware          | 2012-10-31 09:04:03 |
> 2012-11-01
> >
> > 07:44:34 |
> > |          1 |       1 |          2 |             85 | lin1    |
>           1 |         230 | VMware          | 2012-11-01 07:50:49 | NULL
> >
> >         |
> > |          2 |       1 |          2 |             85 | lin1    |
>           1 |         230 | VMware          | 2012-10-31 09:02:14 | NULL
> >
> >         |
> >
> +------------+---------+------------+----------------+---------+---------------------+-------------+-----------------+---------------------
> >
> > +---------------------+
> > 3 rows in set (0.00 sec)
> >   The end_date in line1 and the start_date in line2 is 2012-11-01
> 07:xx:xx。these time is wrong。please help me where is the problem。
> >
> >   i provide you some things to analyse this。if there is something wrong
> whit usage_server or mysql?
> >   (1)timezone in mysql and system:
> >    mysql> show global variables like '%time_zone%';
> > +------------------+--------+
> > | Variable_name    | Value  |
> > +------------------+--------+
> > | system_time_zone | CST    |
> > | time_zone        | SYSTEM |
> > +------------------+--------+
> > 2 rows in set (0.00 sec)
> >
> >   [root@cloudmanager ~]# date
> > Thu Nov  1 17:20:54 CST 2012
> >   (2)i did a test
> >   mysql> desc shijian;
> > +-------+----------+------+-----+---------+-------+
> > | Field | Type     | Null | Key | Default | Extra |
> > +-------+----------+------+-----+---------+-------+
> > | id    | int(11)  | YES  |     | NULL    |       |
> > | sj    | datetime | YES  |     | NULL    |       |
> > +-------+----------+------+-----+---------+-------+
> > 2 rows in set (0.00 sec)
> >
> > mysql> delete from shijian;
> > Query OK, 2 rows affected (0.00 sec)
> >
> > mysql> insert into shijian values(1,now());
> > Query OK, 1 row affected (0.00 sec)
> >
> > mysql> select * from shijian;
> > +------+---------------------+
> > | id   | sj                  |
> > +------+---------------------+
> > |    1 | 2012-11-01 17:22:40 |
> > +------+---------------------+
> > 1 row in set (0.00 sec)
> >
> > [root@cloudmanager ~]# date
> > Thu Nov  1 17:23:03 CST 2012
> >
> > the datetime in table shijian is right。but the datetime in table
> usage_vm_instance is wrong。
> >
> >   (3)the global settings in cloudstack
> >   usage.aggregation.timezone Asia/Shanghai
> >   usage.execution.timezone  Asia/Shanghai
> >   usage.stats.job.aggregation.range 60
> >   usage.stats.job.exec.time 11:22
> >   expunge.delay 3600
> >   expunge.interval 3600
> >
> >
> *********************************************************************************
> >
> >   the second problem
> >   i knew that the variable expunge.delay and expunge.interval。and i knew
> the difference between usage_type=1 and usage_type=2。i don't know the
> >
> > end_date in usage_vm_instance。
> >   (1)the time i click button destroy。(in that time,the vm is not
> destroyed because expunge.delay)。
> >   (2)some secondes later(expunge.delay),in that time the vm is actually
> destroyed。
> >   the end_date is (1) or (2)?
> >
> >   please help me,thanks。
> >
> >
> >
> >
> > psjia
>

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