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 <sa...@zimbaro.com> 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 > > *saulozimb...@gmail.com > > *sa...@zimbaro.com > > > > 2014-05-26 10:22 GMT-03:00 Fabrice Brazier <fabrice.braz...@apalia.net>: > > > 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 <sa...@zimbaro.com> > 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 > > > > > > *saulozimb...@gmail.com > > > > > > *sa...@zimbaro.com > > > > > > > > > > > > 2014-05-25 14:30 GMT-03:00 Diego Spinola Castro < > spinolacas...@gmail.com > > >: > > > > > > > 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 <pd...@cloudops.com>: > > > > > > > > > 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. < > hollman.enc...@gmail.com > > > > > > 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 < > > > > > > rajani.karut...@citrix.com <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 < > > > > > fabrice.braz...@apalia.net<javascript:;> > > > > > > > <mailto:fabrice.braz...@apalia.net <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" <saulozimb...@gmail.com > > > > > <javascript:;> > > > > > > <mailto: > > > > > > > saulozimb...@gmail.com <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 > > > > > > > > > > > > > > *saulozimb...@gmail.com <javascript:;><mailto: > > > saulozimb...@gmail.com > > > > > <javascript:;> > > > > > > > > > > > > > > > > > > > > > *sa...@zimbaro.com <javascript:;><mailto:sa...@zimbaro.com > > > > > <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> > fabrice.braz...@apalia.net > > <fabrice.braz...@apalia.net>* > > > -- Fabrice Brazier *Apalia*™ FR: +33-632-73-53-00 *http://www.apalia.net <http://www.apalia.net> fabrice.braz...@apalia.net <fabrice.braz...@apalia.net>*
