Re: [aerogear-dev] Unified Push - status

... oh :D sorry ... I found /model <https://github.com/aerogear/aerogear-unifiedpush-server/commits/master/mo... /jpa <https://github.com/aerogear/aerogear-unifiedpush-server/commits/master/mo... /testData <https://github.com/aerogear/aerogear-unifiedpush-server/commits/master/mo... /*create_db_content.ddl ... *I try it ... *Mgr. Ivan Gürtler* Mobile software developer AHEAD iTec, s.r.o., Botanická 554/68a, 602 00 Brno (Czech Republic) www.ahead-itec.com | twitter <https://www.twitter.com/AHEADiTec> | mobile security solutions 2015-04-23 15:30 GMT+02:00 Ivan Gürtler <ivan.gurtler(a)ahead-itec.com&gt;: > In report file for PushApplicationDaoTest ... i found: > > ... > javax.persistence.PersistenceException: > org.hibernate.exception.DataException: could not initialize a collection: > [org.jboss.aerogear.unifiedpush.api.PushApplication.variants#1] > at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown > Source) > at > org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown > Source) > at > org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown > Source) > at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown > Source) > at org.apache.derby.impl.jdbc.ConnectionChild.newSQLException(Unknown > Source) > at org.apache.derby.impl.jdbc.EmbedResultSet.dataTypeConversion(Unknown > Source) > at org.apache.derby.impl.jdbc.EmbedResultSet.getClob(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedResultSet.getClob(Unknown Source) > at > org.hibernate.type.descriptor.sql.ClobTypeDescriptor$1.doExtract(ClobTypeDescriptor.java:60) > at > org.hibernate.type.descriptor.sql.BasicExtractor.extract(BasicExtractor.java:64) > at > org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:265) > at > org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:261) > at > org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:251) > at > org.hibernate.type.AbstractStandardBasicType.hydrate(AbstractStandardBasicType.java:336) > at > org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:2924) > at org.hibernate.loader.Loader.loadFromResultSet(Loader.java:1695) > at org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1627) > at org.hibernate.loader.Loader.getRow(Loader.java:1509) > at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:719) > at org.hibernate.loader.Loader.processResultSet(Loader.java:949) > at org.hibernate.loader.Loader.doQuery(Loader.java:917) > at > org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:348) > at > org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:318) > at org.hibernate.loader.Loader.loadCollection(Loader.java:2262) > at > org.hibernate.loader.collection.CollectionLoader.initialize(CollectionLoader.java:65) > at > org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:674) > at > org.hibernate.event.internal.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:86) > at > org.hibernate.internal.SessionImpl.initializeCollection(SessionImpl.java:1774) > at > org.hibernate.collection.internal.AbstractPersistentCollection.forceInitialization(AbstractPersistentCollection.java:696) > at > org.hibernate.engine.internal.StatefulPersistenceContext.initializeNonLazyCollections(StatefulPersistenceContext.java:1037) > at > org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:353) > at org.hibernate.loader.Loader.doList(Loader.java:2550) > at org.hibernate.loader.Loader.doList(Loader.java:2536) > at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2366) > at org.hibernate.loader.Loader.list(Loader.java:2361) > at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:495) > at > org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:357) > at > org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:198) > at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1194) > at org.hibernate.internal.QueryImpl.list(QueryImpl.java:101) > at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:264) > at > org.jboss.aerogear.unifiedpush.jpa.dao.impl.JPABaseDao.getSingleResultForQuery(JPABaseDao.java:93) > at > org.jboss.aerogear.unifiedpush.jpa.dao.impl.JPAPushApplicationDao.findByPushApplicationID(JPAPushApplicationDao.java:73) > at > org.jboss.aerogear.unifiedpush.jpa.PushApplicationDaoTest.updatePushApplication(PushApplicationDaoTest.java:125) > ... > > > In aerogear:master version two mounth ago it was without problems. I > found commit "Use JMS message queues for sending notifications in > batches AGPUSH-1348" ... in this commit was changed orm.xml file ... but > I dont know background of commit change. > > *Mgr. Ivan Gürtler* > Mobile software developer > > AHEAD iTec, s.r.o., Botanická 554/68a, > 602 00 Brno (Czech Republic) > > www.ahead-itec.com | twitter <https://www.twitter.com/AHEADiTec> | > mobile security solutions > > 2015-04-23 15:05 GMT+02:00 Erik Jan de Wit <edewit(a)redhat.com&gt;: > >> Hi Ivan, >> >> Try running without the test `mvn install -DskipTests`, because they >> are testing against another schema. Or see why the tests fail in the >> >> C:\Users\Ivan\Documents\aerogear-unifiedpush-server\model\jpa\target\surefire-reports >> directory and fix those tests, by changing >> model\jpa\test\create_db_content.ddl >> >> On Thu, Apr 23, 2015 at 2:58 PM, Ivan Gürtler >> <ivan.gurtler(a)ahead-itec.com&gt; wrote: >> > Hi, >> > We have own fork ... and I sync with "aerogear:master". Master branch >> in >> > fork is OK. >> > I merge master to second branch. We changed >> > model/jpa/src/main/resources/META-INF/orm.xml file in second branch >> because >> > we use ORACLE >> > ... >> > <entity class="iOSVariant" access="FIELD"> >> > <discriminator-value>ios</discriminator-value> >> > <attributes> >> > <basic name="certificateData"> >> > <column name="cert_data"/> <!--length="100000"/> >> BECAUSE >> > ORACLE !!!--> >> > <lob/> >> > </basic> >> > </attributes> >> > </entity> >> > ... >> > (Second change in orm.xml file was because of Installation class, it >> was >> > bigger than 4000 -> problem in ORACLE ... but in "aerogear:master" it >> was >> > removed from orm.xml file) >> > but when ... Run as ... Maven insall ... In console: >> > ... >> > Tests run: 12, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 2.366 >> sec >> > Results : >> > Failed tests: >> > Expected exception: javax.persistence.PersistenceException >> > Tests in error: >> > PushApplicationDaoTest.updatePushApplication:125 » Persistence >> > org.hibernate.e... >> > PushApplicationDaoTest.pushApplicationIDUnmodifiedAfterUpdate:159 » >> > Persistence >> > >> > >> PushApplicationDaoTest.deletePushApplicationIncludingVariantAndInstallations:194 >> > » Persistence >> > PushApplicationDaoTest.findByPushApplicationID:116 » Persistence >> > org.hibernate... >> > PushApplicationDaoTest.findAllForDeveloper:72 » Persistence >> > org.hibernate.exce... >> > PushApplicationDaoTest.primaryKeyUnmodifiedAfterUpdate:174 » >> Persistence >> > org.h... >> > PushApplicationDaoTest.findAllIDsForDeveloper:96 » Persistence >> > org.hibernate.e... >> > PushApplicationDaoTest.findByPushApplicationIDForDeveloper:103 » >> > Persistence o... >> > PushApplicationDaoTest.updateAndDeletePushApplication:140 » >> Persistence >> > org.hi... >> > Tests run: 75, Failures: 1, Errors: 9, Skipped: 0 >> > [INFO] >> > >> ------------------------------------------------------------------------ >> > [INFO] Reactor Summary: >> > [INFO] >> > [INFO] AeroGear UnifiedPush Server ....................... SUCCESS [ >> 2.833 >> > s] >> > [INFO] UnifiedPush Model Layer ........................... SUCCESS [ >> 0.058 >> > s] >> > [INFO] UnifiedPush Server Model API ...................... SUCCESS [ >> 2.886 >> > s] >> > [INFO] UnifiedPush Server Model JPA implementation ....... FAILURE [ >> 32.992 >> > s] >> > [INFO] UnifiedPush Service Layer ......................... SKIPPED >> > [INFO] UnifiedPush Sender Module ......................... SKIPPED >> > [INFO] UnifiedPush Push Message Model .................... SKIPPED >> > [INFO] UnifiedPush Push Notification Networks ............ SKIPPED >> > [INFO] UnifiedPush RESTful Endpoint ...................... SKIPPED >> > [INFO] UnifiedPush Server (Admin UI) ..................... SKIPPED >> > [INFO] UnifiedPush Dependencies Parent ................... SKIPPED >> > [INFO] UnifiedPush Server Dependencies Server ............ SKIPPED >> > [INFO] UnifiedPush Auth Server ........................... SKIPPED >> > [INFO] UnifiedPush Server for JBossAS (WAR) .............. SKIPPED >> > [INFO] UnifiedPush Server for Wildfly (WAR) .............. SKIPPED >> > [INFO] UnifiedPush Servers Parent ........................ SKIPPED >> > [INFO] >> > >> ------------------------------------------------------------------------ >> > [INFO] BUILD FAILURE >> > [INFO] >> > >> ------------------------------------------------------------------------ >> > [INFO] Total time: 40.717 s >> > [INFO] Finished at: 2015-04-23T14:35:45+01:00 >> > [INFO] Final Memory: 21M/420M >> > [INFO] >> > >> ------------------------------------------------------------------------ >> > [ERROR] Failed to execute goal >> > org.apache.maven.plugins:maven-surefire-plugin:2.14.1:test >> (default-test) on >> > project unifiedpush-model-jpa: There are test failures. >> > [ERROR] >> > [ERROR] Please refer to >> > >> C:\Users\Ivan\Documents\aerogear-unifiedpush-server\model\jpa\target\surefire-reports >> > for the individual test results. >> > [ERROR] -> [Help 1] >> > [ERROR] >> > [ERROR] To see the full stack trace of the errors, re-run Maven with >> the -e >> > switch. >> > [ERROR] Re-run Maven using the -X switch to enable full debug logging. >> > [ERROR] >> > [ERROR] For more information about the errors and possible solutions, >> please >> > read the following articles: >> > [ERROR] [Help 1] >> > http://cwiki.apache.org/confluence/display/MAVEN/MojoFailureException >> > [ERROR] >> > [ERROR] After correcting the problems, you can resume the build with >> the >> > command >> > [ERROR] mvn <goals> -rf :unifiedpush-model-jpa >> > >> --------------------------------------------------------------------------------------------------------------------------------------------------------------- >> > Do you have any idea where is the problem and how to solve it? >> > Thanks >> > >> > Mgr. Ivan Gürtler >> > Mobile software developer >> > >> > AHEAD iTec, s.r.o., Botanická 554/68a, >> > 602 00 Brno (Czech Republic) >> > >> > www.ahead-itec.com | twitter | mobile security solutions >> > >> > 2015-04-23 8:55 GMT+02:00 Erik Jan de Wit <edewit(a)redhat.com&gt;: >> >> >> >> Hi Ivan, >> >> >> >> We have functionality for this available in the master branch on >> >> github. Go to <server>/ag-push/rest/sys/info/health it will return >> >> json with the push network status and db status. This PR >> >> https://github.com/aerogear/aerogear-unifiedpush-server/pull/519 >> >> includes details about the returned json. >> >> >> >> Hope this helps... >> >> >> >> --- >> >> Cheers, >> >> Erik Jan >> >> >> >> On Thu, Apr 23, 2015 at 8:39 AM, Ivan Gürtler >> >> <ivan.gurtler(a)ahead-itec.com&gt; wrote: >> >> > Hi, >> >> > I have some questions about server status. >> >> > Is possible to check with some kind of ping (or something else) >> that DB >> >> > is >> >> > available from push server? >> >> > How to check if platform push server (APNS...) is also available? >> >> > >> >> > >> >> > Thanks >> >> > >> >> > Mgr. Ivan Gürtler >> >> > Mobile software developer >> >> > >> >> > AHEAD iTec, s.r.o., Botanická 554/68a, >> >> > 602 00 Brno (Czech Republic) >> >> > >> >> > www.ahead-itec.com | twitter | mobile security solutions >> >> > >> >> > _______________________________________________ >> >> > aerogear-dev mailing list >> >> > aerogear-dev(a)lists.jboss.org >> >> > https://lists.jboss.org/mailman/listinfo/aerogear-dev >> >> >> >> >> >> >> >> -- >> >> Cheers, >> >> Erik Jan >> >> >> >> _______________________________________________ >> >> aerogear-dev mailing list >> >> aerogear-dev(a)lists.jboss.org >> >> https://lists.jboss.org/mailman/listinfo/aerogear-dev >> > >> > >> > >> > _______________________________________________ >> > aerogear-dev mailing list >> > aerogear-dev(a)lists.jboss.org >> > https://lists.jboss.org/mailman/listinfo/aerogear-dev >> >> >> >> -- >> Cheers, >> Erik Jan >> >> _______________________________________________ >> aerogear-dev mailing list >> aerogear-dev(a)lists.jboss.org >> https://lists.jboss.org/mailman/listinfo/aerogear-dev >> > >