Hi Saulo, I got the same issue on my side, here is the process I did to resolve: I have set both usage.aggregation.tiemzone to Europe/Paris and usage.execution.timezone to Europe/Paris And I have set usage.stats.job.aggregation.range to 10 In the logs I kept seeing "Not owner of usage job, skipping... " when execution time occur. However after waiting for about 30 min or so, usage data started populating and it started working.
Please keep me posted. Regards, Fabrice On Mon, May 26, 2014 at 5:10 PM, Saulo Zimbaro <[email protected]> wrote: > Fabrice, > > Doesnt work. Strange that pid on usage_job table is different that on OS. > > pid on table doesnt exist. > > -- > *Saulo Zimbaro* > > Mobile ) (+55) 21 99800-0100 > > *[email protected] > > *[email protected] > > > > 2014-05-26 10:22 GMT-03:00 Fabrice Brazier <[email protected]>: > > > Hi Saulo, > > > > - save mysqldumps of both cloud/cloud_usage Db in case you will have to > > revert > > - stop usage server > > - remove the record from usage_job table for the unprocessed job > > - start usage server again > > > > Regards, > > Fabrice > > > > > > > > > > On Mon, May 26, 2014 at 2:33 PM, Saulo Zimbaro <[email protected]> > wrote: > > > > > Fabrice, > > > > > > After create link I got another error: > > > > > > 2014-05-26 12:30:00,003 INFO [cloud.usage.UsageManagerImpl] > > > (Usage-Job-1:null) starting usage job... > > > 2014-05-26 12:30:00,009 DEBUG [cloud.usage.UsageManagerImpl] > > > (Usage-Job-1:null) Not owner of usage job, skipping... > > > 2014-05-26 12:30:00,010 INFO [cloud.usage.UsageManagerImpl] > > > (Usage-Job-1:null) usage job complete > > > > > > How can I fix this? > > > > > > > > > > > > -- > > > *Saulo Zimbaro* > > > > > > Mobile ) (+55) 21 99800-0100 > > > > > > *[email protected] > > > > > > *[email protected] > > > > > > > > > > > > 2014-05-25 14:30 GMT-03:00 Diego Spinola Castro < > [email protected] > > >: > > > > > > > i have a similar issue but only network usage is empty (types 4 and > 5). > > > > does anybody have seen that? > > > > > > > > > > > > 2014-05-23 23:53 GMT-03:00 Pierre-Luc Dion <[email protected]>: > > > > > > > > > I've fixed this issue on centos by installing java-1.6.0 > > > > > > > > > > yum install java-1.6.0 > > > > > > > > > > Le vendredi 23 mai 2014, Hollman Enciso R. < > [email protected] > > > > > > a > > > > > écrit : > > > > > > > > > > > Any idea with this error ? > > > > > > > > > > > > Starting CloudStack Usage Monitor cloudstack-usage23/05/2014 > > 15:15:22 > > > > > 22227 > > > > > > jsvc error: Cannot locate Java Home > > > > > > cat: /var/run/cloudstack-usage.pid: No such file or directory > > > > > > [FAILED] > > > > > > > > > > > > It's show starting the daemon cloudstack-usage. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > On Thu, May 22, 2014 at 11:37 PM, Rajani Karuturi < > > > > > > [email protected] <javascript:;>> wrote: > > > > > > > > > > > > > you might want to look at > > > > > > > https://issues.apache.org/jira/browse/CLOUDSTACK-6360 and the > > > > commits. > > > > > > > > > > > > > > > > > > > > > ~Rajani > > > > > > > > > > > > > > > > > > > > > > > > > > > > On 23-May-2014, at 3:49 am, Fabrice Brazier < > > > > > [email protected]<javascript:;> > > > > > > > <mailto:[email protected] <javascript:;>>> wrote: > > > > > > > > > > > > > > Hi Saulo, > > > > > > > > > > > > > > There was an issue with mysql connector. Starting 4.3 mysql > > > connector > > > > > is > > > > > > no > > > > > > > longer bundled with ACS. > > > > > > > I created a symbolic link to make it available to usage server: > > > > > > > ln -s /usr/share/java/mysql-connector-java.jar > > > > > > > /usr/share/cloudstack-usage/lib/mysql-connector-java.jar > > > > > > > > > > > > > > This issue is being added to 4.3 release docs. > > > > > > > > > > > > > > Usage server is working fine now. > > > > > > > > > > > > > > Regards, > > > > > > > Fabrice Brazier > > > > > > > Le 23 mai 2014 00:14, "Saulo Zimbaro" <[email protected] > > > > > <javascript:;> > > > > > > <mailto: > > > > > > > [email protected] <javascript:;>>> a écrit : > > > > > > > > > > > > > > My cloud_usage table still empty. When I start > cloudstack-usage I > > > got > > > > > > error > > > > > > > bellow: > > > > > > > > > > > > > > > > > > > > > Caused by: java.sql.SQLException: No suitable driver found for > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > jdbc:mysql://localhost:3306/cloud?autoReconnect=true&prepStmtCacheSize=517&cachePrepStmts=true > > > > > > > at > > > > java.sql.DriverManager.getConnection(DriverManager.java:635) > > > > > > > at > > > > java.sql.DriverManager.getConnection(DriverManager.java:195) > > > > > > > at > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:75) > > > > > > > at > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582) > > > > > > > at > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1188) > > > > > > > at > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106) > > > > > > > at > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > com.cloud.utils.db.TransactionLegacy.getConnection(TransactionLegacy.java:556) > > > > > > > at > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > com.cloud.utils.db.TransactionLegacy.prepareStatement(TransactionLegacy.java:467) > > > > > > > at > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > com.cloud.utils.db.TransactionLegacy.prepareAutoCloseStatement(TransactionLegacy.java:460) > > > > > > > at > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > com.cloud.utils.db.GenericDaoBase.searchIncludingRemoved(GenericDaoBase.java:394) > > > > > > > > > > > > > > > > > > > > > I use cloudstack 4.3 and works fine. > > > > > > > > > > > > > > > > > > > > > -- > > > > > > > *Saulo Zimbaro* > > > > > > > > > > > > > > Mobile ) (+55) 21 99800-0100 > > > > > > > > > > > > > > *[email protected] <javascript:;><mailto: > > > [email protected] > > > > > <javascript:;> > > > > > > > > > > > > > > > > > > > > > *[email protected] <javascript:;><mailto:[email protected] > > > > > <javascript:;> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > > Hollman Eduardo Enciso R. > > > > > > http://nexxuz.com > > > > > > http://algolibre.com > > > > > > @hollman > > > > > > > > > > > > > > > > > > > > > -- > > > > > > > > > > Pierre-Luc Dion > > > > > Architecte de Solution Cloud | Cloud Solutions Architect > > > > > 855-OK-CLOUD (855-652-5683) x1101 > > > > > - - - > > > > > > > > > > *CloudOps*420 rue Guy > > > > > Montréal QC H3J 1S6 > > > > > www.cloudops.com > > > > > @CloudOps_ > > > > > > > > > > > > > > > > > > > > -- > > Fabrice Brazier > > *Apalia*™ > > FR: +33-632-73-53-00 > > > > *http://www.apalia.net <http://www.apalia.net> > [email protected] > > <[email protected]>* > > > -- Fabrice Brazier *Apalia*™ FR: +33-632-73-53-00 *http://www.apalia.net <http://www.apalia.net> [email protected] <[email protected]>*
