syncope-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Colm O hEigeartaigh <cohei...@apache.org>
Subject Re: Errors with latest installer
Date Tue, 13 Jun 2017 13:57:22 GMT
Thanks Francesco! It's working for me now - the problem was that I was
using "jdbc/syncopeDataSource" instead of "jdbc/syncopeMasterDataSource".

Colm.

On Tue, Jun 13, 2017 at 12:24 PM, Francesco Chicchiriccò <
ilgrosso@apache.org> wrote:

> On 13/06/2017 11:03, Francesco Chicchiriccò wrote:
>
>> On 12/06/2017 19:11, Colm O hEigeartaigh wrote:
>>
>>> Hi all,
>>>
>>> I'm seeing some errors when using the latest installer for 2.0.x. I'm
>>> using
>>> the installer with Tomcat + MySQL. It all works fine with the same setup
>>> using the 2.0.3 installer (with SYNCOPE-1107 applied locally).
>>>
>>> However, with 2.0.4-SNAPSHOT, the installer process completes
>>> successfully,
>>> but only the Quartz tables are in MySQL:
>>>
>>> +--------------------------+
>>> | Tables_in_syncope        |
>>> +--------------------------+
>>> | QRTZ_BLOB_TRIGGERS       |
>>> | QRTZ_CALENDARS           |
>>> | QRTZ_CRON_TRIGGERS       |
>>> | QRTZ_FIRED_TRIGGERS      |
>>> | QRTZ_JOB_DETAILS         |
>>> | QRTZ_LOCKS               |
>>> | QRTZ_PAUSED_TRIGGER_GRPS |
>>> | QRTZ_SCHEDULER_STATE     |
>>> | QRTZ_SIMPLE_TRIGGERS     |
>>> | QRTZ_SIMPROP_TRIGGERS    |
>>> | QRTZ_TRIGGERS            |
>>> +--------------------------+
>>>
>>> and in "core-rest.log" I see:
>>>
>>> 'org.apache.syncope.core.provisioning.java.job.JobManagerImpl#0':
>>> Unsatisfied dependency expressed through field 'scheduler'; nested
>>> exception is org.springframework.beans.factory.BeanCreationException:
>>> Error
>>> creating bean with name 'scheduler' defined in URL
>>> [jar:file:/home/colm/Desktop/tmp/apache-tomcat-8.5.12/webapp
>>> s/syncope/WEB-INF/lib/syncope-core-provisioning-java-2.0.4-
>>> SNAPSHOT.jar!/provisioningContext.xml]:
>>> Invocation of init method failed; nested exception is
>>> org.springframework.transaction.CannotCreateTransactionException: Could
>>> not
>>> open JPA EntityManager for transaction; nested exception is
>>> <openjpa-2.4.2-r422266:1777108 nonfatal general error>
>>> org.apache.openjpa.persistence.PersistenceException: Connection is
>>> closed
>>>
>>> Any ideas what could be causing this?
>>>
>>
>>
>> Hi Colm,
>> I have spent some time playing with installer on my laptop (Ubuntu
>> 16.04), with MySQL 5.7.
>>
>> I initially started by using the latest MySQL JDBC connector available
>> (6.0.6), but this turned to be a bad choice because of [1] [2] and God
>> knows how many more issues.
>>
>> Then I changed to the latest JDBC connector 5.1 I had on my local disk
>> (5.1.22), which made me run into [3]; finally, I have upgraded to the
>> latest 5.1 available (5.1.42) [4]: from there I have seen that version 6.X
>> is still considered "on development".
>>
>> In my local Tomcat instance I had no JDBC connection pool configuration
>> yet, so the application-managed db pool was in effect, based on HikariCP
>> since SYNCOPE-1084 [5].
>> With such configuration, I started getting exceptions in the logs like as
>> [6], so I finally decided to switch to container-managed db pool as
>> indicated by our docs [7] (well, nearly, since I have found out that name
>> should be jdbc/syncopeMasterDataSource, going to fix that immediately).
>>
>
> FYI I am currently discussing the problem with HikariCP in the dev@openjpa
> ML [8] and provided a workaround with commit [9].
> It seems that this problem is exclusively related to MySQL, not even
> MariaDB.
>
> At this point everything was (finally!) working as expected.
>>
>> In the meanwhile, I have also spotted some things to enhance / fix with
>> Installer, for which I am going to open some issue(s) soon.
>>
>> I was actually wondering who is using it, and considering whether to
>> start a discussion to deprecate it...
>>
>> Regards.
>>
>> [1] https://stackoverflow.com/questions/37719818/the-server-time
>> -zone-value-aest-is-unrecognized-or-represents-more-than-one-ti
>> [2] https://stackoverflow.com/questions/42084633/table-name-patt
>> ern-can-not-be-null-or-empty-in-java
>> [3] https://bugs.mysql.com/bug.php?id=66659
>> [4] https://dev.mysql.com/downloads/connector/j/
>> [5] https://issues.apache.org/jira/browse/SYNCOPE-1084
>> [6] https://stackoverflow.com/questions/36027250/java-sql-sqlexc
>> eption-connection-is-closed-pool-hikaricp
>> [7] https://syncope.apache.org/docs/reference-guide.html#apache-
>> tomcat-8-and-8-5
>> [8] https://lists.apache.org/thread.html/71333fcb9e02b30791cacaf
>> 7f3cd773cd6380119e39ec2db2b984430@%3Cdev.openjpa.apache.org%3E
>> [9] https://github.com/apache/syncope/commit/1bf49e3fd9f934c1bc4
>> e7d4ee0e715e49f1e2bc7
>>
>
> --
> Francesco Chicchiriccò
>
> Tirasa - Open Source Excellence
> http://www.tirasa.net/
>
> Member at The Apache Software Foundation
> Syncope, Cocoon, Olingo, CXF, OpenJPA, PonyMail
> http://home.apache.org/~ilgrosso/
>
>


-- 
Colm O hEigeartaigh

Talend Community Coder
http://coders.talend.com

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message