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>*
