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