Menu
▾
▴
unity-idm-discuss — Unity discussion and support
You can subscribe to this list here.
| 2014 |
Jan
(3) |
Feb
(1) |
Mar
|
Apr
(1) |
May
|
Jun
|
Jul
(2) |
Aug
(2) |
Sep
|
Oct
(3) |
Nov
|
Dec
(1) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2015 |
Jan
(20) |
Feb
(3) |
Mar
|
Apr
|
May
|
Jun
(15) |
Jul
(1) |
Aug
(7) |
Sep
(13) |
Oct
(2) |
Nov
(10) |
Dec
(1) |
| 2016 |
Jan
|
Feb
(2) |
Mar
|
Apr
(2) |
May
(1) |
Jun
|
Jul
(1) |
Aug
(2) |
Sep
(11) |
Oct
(7) |
Nov
(6) |
Dec
(11) |
| 2017 |
Jan
(10) |
Feb
(5) |
Mar
(27) |
Apr
(34) |
May
(25) |
Jun
(14) |
Jul
(7) |
Aug
(17) |
Sep
(11) |
Oct
(6) |
Nov
(14) |
Dec
(10) |
| 2018 |
Jan
(8) |
Feb
(19) |
Mar
(40) |
Apr
(9) |
May
(16) |
Jun
(23) |
Jul
(31) |
Aug
(7) |
Sep
(9) |
Oct
(6) |
Nov
(14) |
Dec
(19) |
| 2019 |
Jan
(4) |
Feb
(6) |
Mar
(1) |
Apr
(2) |
May
(6) |
Jun
(3) |
Jul
|
Aug
|
Sep
|
Oct
(2) |
Nov
(19) |
Dec
(14) |
| 2020 |
Jan
(10) |
Feb
(24) |
Mar
(49) |
Apr
(26) |
May
(12) |
Jun
(4) |
Jul
(13) |
Aug
(32) |
Sep
(13) |
Oct
(10) |
Nov
(4) |
Dec
(16) |
| 2021 |
Jan
(2) |
Feb
(8) |
Mar
(15) |
Apr
(19) |
May
(5) |
Jun
(13) |
Jul
(6) |
Aug
(38) |
Sep
(11) |
Oct
(18) |
Nov
(11) |
Dec
(13) |
| 2022 |
Jan
(10) |
Feb
(21) |
Mar
(28) |
Apr
(3) |
May
(7) |
Jun
(9) |
Jul
(14) |
Aug
(13) |
Sep
(8) |
Oct
(29) |
Nov
(1) |
Dec
(21) |
| 2023 |
Jan
(19) |
Feb
(9) |
Mar
|
Apr
(10) |
May
(7) |
Jun
(10) |
Jul
(14) |
Aug
(17) |
Sep
(1) |
Oct
(9) |
Nov
(5) |
Dec
(14) |
| 2024 |
Jan
(12) |
Feb
(2) |
Mar
(8) |
Apr
(1) |
May
(6) |
Jun
(6) |
Jul
(24) |
Aug
(15) |
Sep
(1) |
Oct
(6) |
Nov
(20) |
Dec
(14) |
| 2025 |
Jan
(12) |
Feb
(2) |
Mar
(10) |
Apr
(11) |
May
(13) |
Jun
(1) |
Jul
(2) |
Aug
(2) |
Sep
(8) |
Oct
|
Nov
|
Dec
|
|
From: Krzysztof B. <kb...@un...> - 2017-09-04 20:42:30
|
Dear Subscribers, If you are not using Unity with UNICORE or haven't yet downloaded 2.2.0 you can ignore this message. In the originally uploaded distribution files of Unity 2.2.0 there were two outdated configuration files related to the UNICORE config module. If you happened to download 2.2.0 already, please replace the '/unicore/users' string with '/unicore' (i.e. remove trailing /users) in: conf/modules/unicore/tr-hostOS2UNICORE.json:28 conf/modules/unicore/saml-unicoreidp.properties:13 The distribution on the SF download site was already updated. Sorry for the inconvenience, Krzysztof |
|
From: Krzysztof B. <kb...@un...> - 2017-08-31 13:51:26
|
Dear Subscribers, Subsequent Unity feature release v2.2.0 is available for download. Release 2.2.0 brings major improvements in three areas: - Organization of default configuration is changed to use so called configuration modules. - A new PAM password verificator is available allowing you to rely on the host authN. Also importing users from host OS is possible. - UNICORE integration is now super easy with a new, dedicated configuration modules. What is more couple of bugs were fixed. For more detailed changelog see http://www.unity-idm.eu/downloads Best regards, Krzysztof |
|
From: Sander A. <sa....@fz...> - 2017-08-30 10:38:08
|
Hi Krzysztof, sorry for the late reply. I'll try to explain it with an bigger example. We have the following services: - A: external IdP - B: unity as proxy IdP - C: additional attribute service - D: some other service We have the following user: - 1: admin of C - 2: normal user, wants to use D Workflow: - Any user logged in into C or D is authenticated by B - C uses only attributes provided from B or A (through B) - 1 can create additional attributes or role for 2 in C, - B consumes and stores the additional attributes about 2 from C - if 2 uses D uses attributes provided by B and C (through B) Or with an more concrete example. Within C user 1 creates a quota for user 2. This quota is a storage limitation for Nextcloud (D). Unity get this additional attribute from C. If 2 sing in into Nextcloud unity provides the following attributes: - unity persisten identifier - email (provided from home IdP to unity) - CN (provided from home IdP to unity or entered during the registration) - quota (provided from additional attribute source to unity) Hopefully it is more understandable. If not let me know and I try to find another explanation after my holidays. Best regards, Sander Am Donnerstag, den 24.08.2017, 23:48 +0200 schrieb Krzysztof Benedyczak: > Sander, > > W dniu 23.08.2017 o 09:59, Sander Apweiler pisze: > > Hi, > > > > In our project is planed to use an additional attribute source for > > registered users. We want to extend authorization possibilities > > with > > this attribute source. > > > > Unity (A) is a proxy IdP and all services within the project use A > > for > > the authentication. The integration with other IdPs and SPs is > > already > > done. The attribute service (B) uses unity for authentication too. > > B is > > not an IdP, it is a SP of A. The situation would look like this: > > > > - The user authenticates at A (done) > > - The login into B is done with A (done; mapping by persistent > > identifier from A) > > - A get some additional information (e.g. group membership) about > > the > > user from B > > > > I know the possibility about adding attributes by the > > administration > > API. Is there another possibility to use additional attribute > > sources > > for registered users like described above? > > I don't think I can follow your scenario. Can you provide more > details? > What are those services (what protocols)? What is the sequence of > operations: when Unity should request those attributes? Reading your > example literally user logins to B via Unity, which asks B about > attributes of user - ? to provide them back to B? > > > Best > Krzysztof -- Federated Systems and Data Juelich Supercomputing Centre phone: +49 2461 61 8847 fax: +49 2461 61 6656 email: sa....@fz... ----------------------------------------------------------------------- ----------------------------------------------------------------------- Forschungszentrum Juelich GmbH 52425 Juelich Sitz der Gesellschaft: Juelich Eingetragen im Handelsregister des Amtsgerichts Dueren Nr. HR B 3498 Vorsitzender des Aufsichtsrats: MinDir Dr. Karl Eugen Huthmacher Geschaeftsfuehrung: Prof. Dr.-Ing. Wolfgang Marquardt (Vorsitzender), Karsten Beneke (stellv. Vorsitzender), Prof. Dr.-Ing. Harald Bolt, Prof. Dr. Sebastian M. Schmidt ----------------------------------------------------------------------- ----------------------------------------------------------------------- |
|
From: Krzysztof B. <kb...@un...> - 2017-08-24 21:48:39
|
Sander, W dniu 23.08.2017 o 09:59, Sander Apweiler pisze: > Hi, > > In our project is planed to use an additional attribute source for > registered users. We want to extend authorization possibilities with > this attribute source. > > Unity (A) is a proxy IdP and all services within the project use A for > the authentication. The integration with other IdPs and SPs is already > done. The attribute service (B) uses unity for authentication too. B is > not an IdP, it is a SP of A. The situation would look like this: > > - The user authenticates at A (done) > - The login into B is done with A (done; mapping by persistent > identifier from A) > - A get some additional information (e.g. group membership) about the > user from B > > I know the possibility about adding attributes by the administration > API. Is there another possibility to use additional attribute sources > for registered users like described above? I don't think I can follow your scenario. Can you provide more details? What are those services (what protocols)? What is the sequence of operations: when Unity should request those attributes? Reading your example literally user logins to B via Unity, which asks B about attributes of user - ? to provide them back to B? Best Krzysztof |
|
From: Sander A. <sa....@fz...> - 2017-08-23 08:01:27
|
Hi, In our project is planed to use an additional attribute source for registered users. We want to extend authorization possibilities with this attribute source. Unity (A) is a proxy IdP and all services within the project use A for the authentication. The integration with other IdPs and SPs is already done. The attribute service (B) uses unity for authentication too. B is not an IdP, it is a SP of A. The situation would look like this: - The user authenticates at A (done) - The login into B is done with A (done; mapping by persistent identifier from A) - A get some additional information (e.g. group membership) about the user from B I know the possibility about adding attributes by the administration API. Is there another possibility to use additional attribute sources for registered users like described above? Best regards, Sander -- Federated Systems and Data Juelich Supercomputing Centre phone: +49 2461 61 8847 fax: +49 2461 61 6656 email: sa....@fz... ----------------------------------------------------------------------- ----------------------------------------------------------------------- Forschungszentrum Juelich GmbH 52425 Juelich Sitz der Gesellschaft: Juelich Eingetragen im Handelsregister des Amtsgerichts Dueren Nr. HR B 3498 Vorsitzender des Aufsichtsrats: MinDir Dr. Karl Eugen Huthmacher Geschaeftsfuehrung: Prof. Dr.-Ing. Wolfgang Marquardt (Vorsitzender), Karsten Beneke (stellv. Vorsitzender), Prof. Dr.-Ing. Harald Bolt, Prof. Dr. Sebastian M. Schmidt ----------------------------------------------------------------------- ----------------------------------------------------------------------- |
|
From: Krzysztof B. <kb...@un...> - 2017-08-21 07:04:38
|
Hi Sander, Sorry for late answer - forgot little bit about it. W dniu 02.08.2017 o 16:22, Sander Apweiler pisze: > Hi Krzysztof, > > I got a report about using OIDC client. Unity seems to reserve a > mandatory attribute if not all requested scopes are available. Please > see the message below. In that case we did not define the scope > profile. > > WaTTS is requesting the scope 'email profile openid' (double checked in > the browser log) > > b2access displays the user that only 'email openid' was requested, > which > is wrong. > > User is returned to WaTTS without any 'scope' attribute (also double > checked with browser log), which MUST be present if it is not as > requested: Yes, that should be the case. In the next release it will be fixed, i.e. Unity will always include effective scope with access token response (any OAuth flow) when those are different then requested. Thanks for the report Krzysztof |
|
From: Piernik P. <pio...@gm...> - 2017-08-14 11:59:12
|
Hi Shiraz, Temporarily, your simple solution for adding attributes to the schema is ok. I created new ticked: https://app.assembla.com/spaces/unity-public/tickets/616-oauth-consent-screen-cannot-be-generated-with-dynamic-attributes-without-type-/details# We will fix it as soon as possible:) Cheers Piotr W dniu 14.08.2017 o 11:40, Shiraz Memon pisze: > Hi Piotr, > > Thanks for your reply. > > > On Mon, Aug 14, 2017 at 9:02 AM, Piernik Piotr <pio...@gm... > <mailto:pio...@gm...>> wrote: > > Hi Shiraz > > I checked this and I think I know what the problem is, but I have > to consult it with Krzysztof. > > Did you test this in 2.0.0 version or just in 2.1.0 ? > > > The error was occurred on version 2.1.0. > > Best, > Shiraz > > > Cheers > Piotr > > > > > > -- > Shiraz Memon > Federated Systems and Data > Jülich Supercomputing Centre (JSC) > > Phone: +49 2461 61 6899 <tel:02461%20616899> > Fax: +49 2461 61 6656 <tel:02461%20616656> > > > ------------------------------------------------------------------------------------------------ > ------------------------------------------------------------------------------------------------ > Forschungszentrum Juelich GmbH > 52425 Juelich > Sitz der Gesellschaft: Juelich > Eingetragen im Handelsregister des Amtsgerichts Dueren Nr. HR B 3498 > Vorsitzender des Aufsichtsrats: MinDir Dr. Karl Eugen Huthmacher > Geschaeftsfuehrung: Prof. Dr.-Ing. Wolfgang Marquardt (Vorsitzender), > Karsten Beneke (stellv. Vorsitzender), Prof. Dr.-Ing. Harald Bolt, > Prof. Dr. Sebastian M. Schmidt > ------------------------------------------------------------------------------------------------ > ------------------------------------------------------------------------------------------------ > |
|
From: Shiraz M. <a....@fz...> - 2017-08-07 13:24:01
|
Hi,
Finally I have managed to get it working by adding "unity:persistent" attribute (and others) through attribute types management. This behavior is however neither expected as unity used to create the attributes dynamically upon release, which are defined under the output translation profiles with action "createAttribute".
By the way, the "urn:oid:1.3.6.1.4.1.5923.1.1.1.13" attribute (in my previous email) was not causing the "attribute does not exist" error, the reason being is the attribute has not been defined in any of the oauth scopes. However the same error occurred after declaring the attribute inside the scopes. Having said that, is it a new feature in v2.1.0 that all the attributes unity releases to the oauth clients should be predefined in the attribute schema?
Cheers,
Shiraz
On Mon, Aug 7, 2017 at 1:58 PM, Shiraz Memon <a....@fz...<mailto:a....@fz...>> wrote:
Hi,
After successfully upgrading to v2.1.0, unity fails to create new attribute(s), which is being defined in the output translation profile.
2017-08-07T13:44:41,202 [qtp35624804-191] DEBUG unity.server.externaltranslation.CreateAttributeAction: [[TrProfile oauth], [r: 7], [certclient - eId: 139]]Created a new attribute: unity:persistent: [42ef9e66-cc26-49ac-a21e-1f789ab4e1a4] with meta [Persistent Unique Iden
tifier, EUDAT Persistent Unique Identifier, false]
2017-08-07T13:44:41,203 [qtp35624804-191] ERROR unity.server.oauth.OAuthAuthzUI: Engine problem when handling client request
java.lang.IllegalArgumentException: attribute type [unity:persistent] does not exist
at pl.edu.icm.unity.store.rdbms.GenericNamedRDBMSCRUD.get(GenericNamedRDBMSCRUD.java:97) ~[unity-server-storage-2.2.0-SNAPSHOT.jar:?]
at pl.edu.icm.unity.engine.attribute.AttributeTypeHelper.getTypeForAttributeName(AttributeTypeHelper.java:56) ~[unity-server-engine-2.1.0.jar:?]
at pl.edu.icm.unity.engine.attribute.AttributeTypeSupportImpl.getType(AttributeTypeSupportImpl.java:46) ~[unity-server-engine-2.1.0.jar:?]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_72-internal]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_72-internal]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_72-internal]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_72-internal]
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333) ~[spring-aop-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) ~[spring-aop-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) ~[spring-aop-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85) ~[spring-aop-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at pl.edu.icm.unity.store.rdbms.tx.SQLTransactionEngine.runInTransaction(SQLTransactionEngine.java:45) ~[unity-server-storage-2.2.0-SNAPSHOT.jar:?]
at pl.edu.icm.unity.store.tx.TransactionalAspect.retryIfNeeded4Class(TransactionalAspect.java:67) ~[unity-server-storage-2.2.0-SNAPSHOT.jar:?]
at sun.reflect.GeneratedMethodAccessor129.invoke(Unknown Source) ~[?:?]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_72-internal]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_72-internal]
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:629) ~[spring-aop-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:618) ~[spring-aop-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70) ~[spring-aop-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:168) ~[spring-aop-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) ~[spring-aop-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) ~[spring-aop-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213) ~[spring-aop-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at com.sun.proxy.$Proxy61.getType(Unknown Source) ~[?:?]
at pl.edu.icm.unity.webui.idpcommon.ExposedAttributesComponent.getAttributeComponent(ExposedAttributesComponent.java:123) ~[unity-server-web-common-2.1.0.jar:?]
at pl.edu.icm.unity.webui.idpcommon.ExposedAttributesComponent.getAttributesListComponent(ExposedAttributesComponent.java:114) ~[unity-server-web-common-2.1.0.jar:?]
snapshot of the rule
[Inline image 4]
Surprisingly, following rule works
[Inline image 2]
and corresponding log entry (upon creating the attribute)
2017-08-07T13:54:38,322 [qtp35624804-194] DEBUG unity.server.externaltranslation.OutputTranslationRule: [[TrProfile oauth], [r: 5]]Condition OK
2017-08-07T13:54:38,322 [qtp35624804-194] DEBUG unity.server.externaltranslation.CreateAttributeAction: [[TrProfile oauth], [r: 5], [certclient - eId: 139]]Created a new attribut
e: urn:oid:1.3.6.1.4.1.5923.1.1.1.13: [42e...@eu...<mailto:42e...@eu...>] with meta [eduPersonUniqueId, eduPersonUniqueId, false]
Do you how to resolve this?
Thanks,
Shiraz
--
Shiraz Memon
Federated Systems and Data
Jülich Supercomputing Centre (JSC)
Phone: +49 2461 61 6899<tel:02461%20616899>
Fax: +49 2461 61 6656<tel:02461%20616656>
--
Shiraz Memon
Federated Systems and Data
Jülich Supercomputing Centre (JSC)
Phone: +49 2461 61 6899
Fax: +49 2461 61 6656
------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------
Forschungszentrum Juelich GmbH
52425 Juelich
Sitz der Gesellschaft: Juelich
Eingetragen im Handelsregister des Amtsgerichts Dueren Nr. HR B 3498
Vorsitzender des Aufsichtsrats: MinDir Dr. Karl Eugen Huthmacher
Geschaeftsfuehrung: Prof. Dr.-Ing. Wolfgang Marquardt (Vorsitzender),
Karsten Beneke (stellv. Vorsitzender), Prof. Dr.-Ing. Harald Bolt,
Prof. Dr. Sebastian M. Schmidt
------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------
|
|
From: Shiraz M. <a....@fz...> - 2017-08-07 11:59:20
|
Hi,
After successfully upgrading to v2.1.0, unity fails to create new attribute(s), which is being defined in the output translation profile.
2017-08-07T13:44:41,202 [qtp35624804-191] DEBUG unity.server.externaltranslation.CreateAttributeAction: [[TrProfile oauth], [r: 7], [certclient - eId: 139]]Created a new attribute: unity:persistent: [42ef9e66-cc26-49ac-a21e-1f789ab4e1a4] with meta [Persistent Unique Iden
tifier, EUDAT Persistent Unique Identifier, false]
2017-08-07T13:44:41,203 [qtp35624804-191] ERROR unity.server.oauth.OAuthAuthzUI: Engine problem when handling client request
java.lang.IllegalArgumentException: attribute type [unity:persistent] does not exist
at pl.edu.icm.unity.store.rdbms.GenericNamedRDBMSCRUD.get(GenericNamedRDBMSCRUD.java:97) ~[unity-server-storage-2.2.0-SNAPSHOT.jar:?]
at pl.edu.icm.unity.engine.attribute.AttributeTypeHelper.getTypeForAttributeName(AttributeTypeHelper.java:56) ~[unity-server-engine-2.1.0.jar:?]
at pl.edu.icm.unity.engine.attribute.AttributeTypeSupportImpl.getType(AttributeTypeSupportImpl.java:46) ~[unity-server-engine-2.1.0.jar:?]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_72-internal]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_72-internal]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_72-internal]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_72-internal]
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333) ~[spring-aop-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) ~[spring-aop-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) ~[spring-aop-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85) ~[spring-aop-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at pl.edu.icm.unity.store.rdbms.tx.SQLTransactionEngine.runInTransaction(SQLTransactionEngine.java:45) ~[unity-server-storage-2.2.0-SNAPSHOT.jar:?]
at pl.edu.icm.unity.store.tx.TransactionalAspect.retryIfNeeded4Class(TransactionalAspect.java:67) ~[unity-server-storage-2.2.0-SNAPSHOT.jar:?]
at sun.reflect.GeneratedMethodAccessor129.invoke(Unknown Source) ~[?:?]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_72-internal]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_72-internal]
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:629) ~[spring-aop-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:618) ~[spring-aop-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70) ~[spring-aop-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:168) ~[spring-aop-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) ~[spring-aop-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) ~[spring-aop-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213) ~[spring-aop-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at com.sun.proxy.$Proxy61.getType(Unknown Source) ~[?:?]
at pl.edu.icm.unity.webui.idpcommon.ExposedAttributesComponent.getAttributeComponent(ExposedAttributesComponent.java:123) ~[unity-server-web-common-2.1.0.jar:?]
at pl.edu.icm.unity.webui.idpcommon.ExposedAttributesComponent.getAttributesListComponent(ExposedAttributesComponent.java:114) ~[unity-server-web-common-2.1.0.jar:?]
snapshot of the rule
[Inline image 4]
Surprisingly, following rule works
[Inline image 2]
and corresponding log entry (upon creating the attribute)
2017-08-07T13:54:38,322 [qtp35624804-194] DEBUG unity.server.externaltranslation.OutputTranslationRule: [[TrProfile oauth], [r: 5]]Condition OK
2017-08-07T13:54:38,322 [qtp35624804-194] DEBUG unity.server.externaltranslation.CreateAttributeAction: [[TrProfile oauth], [r: 5], [certclient - eId: 139]]Created a new attribut
e: urn:oid:1.3.6.1.4.1.5923.1.1.1.13: [42e...@eu...<mailto:42e...@eu...>] with meta [eduPersonUniqueId, eduPersonUniqueId, false]
Do you how to resolve this?
Thanks,
Shiraz
--
Shiraz Memon
Federated Systems and Data
Jülich Supercomputing Centre (JSC)
Phone: +49 2461 61 6899
Fax: +49 2461 61 6656
------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------
Forschungszentrum Juelich GmbH
52425 Juelich
Sitz der Gesellschaft: Juelich
Eingetragen im Handelsregister des Amtsgerichts Dueren Nr. HR B 3498
Vorsitzender des Aufsichtsrats: MinDir Dr. Karl Eugen Huthmacher
Geschaeftsfuehrung: Prof. Dr.-Ing. Wolfgang Marquardt (Vorsitzender),
Karsten Beneke (stellv. Vorsitzender), Prof. Dr.-Ing. Harald Bolt,
Prof. Dr. Sebastian M. Schmidt
------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------
|
|
From: Shiraz M. <a....@fz...> - 2017-08-05 13:23:27
|
Hi Krzysztof,
Indeed updating to mysql 5.6 did help and the server started smoothly. Thereafter I have tried to restore from v1.9.6 db dump but it led to another failure (see the logs below), so I cannot access admin UI now and start-up fails too :(
2017-08-05T15:10:41,747 [qtp609471415-42] INFO unity.server.db.DumpUpdater: Updating database dump from 1.9.x --> 2.0.0 [3]
2017-08-05T15:10:41,984 [qtp609471415-42] WARN org.eclipse.jetty.server.HttpChannel: /admin/
javax.servlet.ServletException: com.vaadin.server.ServiceException: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'groupsTree' defined in URL [jar:file:/home/eudat/unity-server-distribution-2.1.0/lib/unity-server-web-admin-2.1.0.j
ar!/pl/edu/icm/unity/webadmin/groupbrowser/GroupsTree.class]: Bean instantiation via constructor failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [pl.edu.icm.unity.webadmin.groupbrowser.GroupsTree]: Constructor threw
exception; nested exception is java.lang.IllegalArgumentException: entity with key [1] does not exist
at com.vaadin.server.VaadinServlet.service(VaadinServlet.java:366) ~[vaadin-server-7.6.4.jar:7.6.4]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) ~[javax.servlet-api-3.1.0.jar:3.1.0]
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:841) ~[jetty-servlet-9.4.6.v20170531.jar:9.4.6.v20170531]
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1650) ~[jetty-servlet-9.4.6.v20170531.jar:9.4.6.v20170531]
at pl.edu.icm.unity.webui.authn.InvocationContextSetupFilter.doFilter(InvocationContextSetupFilter.java:73) ~[unity-server-web-common-2.1.0.jar:?]
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1637) ~[jetty-servlet-9.4.6.v20170531.jar:9.4.6.v20170531]
at pl.edu.icm.unity.webui.authn.AuthenticationFilter.gotoProtectedResource(AuthenticationFilter.java:182) ~[unity-server-web-common-2.1.0.jar:?]
at pl.edu.icm.unity.webui.authn.AuthenticationFilter.doFilter(AuthenticationFilter.java:104) ~[unity-server-web-common-2.1.0.jar:?]
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1637) ~[jetty-servlet-9.4.6.v20170531.jar:9.4.6.v20170531]
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:533) ~[jetty-servlet-9.4.6.v20170531.jar:9.4.6.v20170531]
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:188) ~[jetty-server-9.4.6.v20170531.jar:9.4.6.v20170531]
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1595) ~[jetty-server-9.4.6.v20170531.jar:9.4.6.v20170531]
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:188) ~[jetty-server-9.4.6.v20170531.jar:9.4.6.v20170531]
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1253) ~[jetty-server-9.4.6.v20170531.jar:9.4.6.v20170531]
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:168) ~[jetty-server-9.4.6.v20170531.jar:9.4.6.v20170531]
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:473) ~[jetty-servlet-9.4.6.v20170531.jar:9.4.6.v20170531]
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1564) ~[jetty-server-9.4.6.v20170531.jar:9.4.6.v20170531]
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:166) ~[jetty-server-9.4.6.v20170531.jar:9.4.6.v20170531]
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1155) ~[jetty-server-9.4.6.v20170531.jar:9.4.6.v20170531]
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) ~[jetty-server-9.4.6.v20170531.jar:9.4.6.v20170531]
at org.eclipse.jetty.server.Dispatcher.forward(Dispatcher.java:203) ~[jetty-server-9.4.6.v20170531.jar:9.4.6.v20170531]
at org.eclipse.jetty.server.Dispatcher.forward(Dispatcher.java:73) ~[jetty-server-9.4.6.v20170531.jar:9.4.6.v20170531]
at pl.edu.icm.unity.webui.VaadinEndpoint$ForwadSerlvet.service(VaadinEndpoint.java:319) ~[unity-server-web-common-2.1.0.jar:?]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) ~[javax.servlet-api-3.1.0.jar:3.1.0]
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:841) ~[jetty-servlet-9.4.6.v20170531.jar:9.4.6.v20170531]
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1650) ~[jetty-servlet-9.4.6.v20170531.jar:9.4.6.v20170531]
at pl.edu.icm.unity.webui.authn.InvocationContextSetupFilter.doFilter(InvocationContextSetupFilter.java:73) ~[unity-server-web-common-2.1.0.jar:?]
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1637) ~[jetty-servlet-9.4.6.v20170531.jar:9.4.6.v20170531]
at pl.edu.icm.unity.webui.authn.AuthenticationFilter.gotoNotProtectedResource(AuthenticationFilter.java:190) ~[unity-server-web-common-2.1.0.jar:?]
at pl.edu.icm.unity.webui.authn.AuthenticationFilter.doFilter(AuthenticationFilter.java:77) ~[unity-server-web-common-2.1.0.jar:?]
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1637) ~[jetty-servlet-9.4.6.v20170531.jar:9.4.6.v20170531]
at pl.edu.icm.unity.engine.api.utils.HiddenResourcesFilter.doFilter(HiddenResourcesFilter.java:49) ~[unity-server-engine-api-2.1.0.jar:?]
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1637) ~[jetty-servlet-9.4.6.v20170531.jar:9.4.6.v20170531]
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:533) ~[jetty-servlet-9.4.6.v20170531.jar:9.4.6.v20170531]
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:188) ~[jetty-server-9.4.6.v20170531.jar:9.4.6.v20170531]
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1595) ~[jetty-server-9.4.6.v20170531.jar:9.4.6.v20170531]
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:188) ~[jetty-server-9.4.6.v20170531.jar:9.4.6.v20170531]
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1253) ~[jetty-server-9.4.6.v20170531.jar:9.4.6.v20170531]
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:168) ~[jetty-server-9.4.6.v20170531.jar:9.4.6.v20170531]
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:473) ~[jetty-servlet-9.4.6.v20170531.jar:9.4.6.v20170531]
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1564) ~[jetty-server-9.4.6.v20170531.jar:9.4.6.v20170531]
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:166) ~[jetty-server-9.4.6.v20170531.jar:9.4.6.v20170531]
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1155) ~[jetty-server-9.4.6.v20170531.jar:9.4.6.v20170531]
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) ~[jetty-server-9.4.6.v20170531.jar:9.4.6.v20170531]
at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:219) ~[jetty-server-9.4.6.v20170531.jar:9.4.6.v20170531]
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132) ~[jetty-server-9.4.6.v20170531.jar:9.4.6.v20170531]
at org.eclipse.jetty.rewrite.handler.RewriteHandler.handle(RewriteHandler.java:335) ~[jetty-rewrite-9.4.6.v20170531.jar:9.4.6.v20170531]
at org.eclipse.jetty.server.handler.gzip.GzipHandler.handle(GzipHandler.java:454) ~[jetty-server-9.4.6.v20170531.jar:9.4.6.v20170531]
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132) ~[jetty-server-9.4.6.v20170531.jar:9.4.6.v20170531]
at org.eclipse.jetty.server.Server.handle(Server.java:564) ~[jetty-server-9.4.6.v20170531.jar:9.4.6.v20170531]
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:317) [jetty-server-9.4.6.v20170531.jar:9.4.6.v20170531]
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:251) [jetty-server-9.4.6.v20170531.jar:9.4.6.v20170531]
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:317) [jetty-server-9.4.6.v20170531.jar:9.4.6.v20170531]
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:251) [jetty-server-9.4.6.v20170531.jar:9.4.6.v20170531]
at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:279) [jetty-io-9.4.6.v20170531.jar:9.4.6.v20170531]
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:110) [jetty-io-9.4.6.v20170531.jar:9.4.6.v20170531]
at org.eclipse.jetty.io.ssl.SslConnection.onFillable(SslConnection.java:289) [jetty-io-9.4.6.v20170531.jar:9.4.6.v20170531]
at org.eclipse.jetty.io.ssl.SslConnection$3.succeeded(SslConnection.java:149) [jetty-io-9.4.6.v20170531.jar:9.4.6.v20170531]
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:110) [jetty-io-9.4.6.v20170531.jar:9.4.6.v20170531]
at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:124) [jetty-io-9.4.6.v20170531.jar:9.4.6.v20170531]
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:673) [jetty-util-9.4.6.v20170531.jar:9.4.6.v20170531]
at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:591) [jetty-util-9.4.6.v20170531.jar:9.4.6.v20170531]
at java.lang.Thread.run(Thread.java:745) [?:1.8.0_72-internal]
Caused by: com.vaadin.server.ServiceException: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'groupsTree' defined in URL [jar:file:/home/eudat/unity-server-distribution-2.1.0/lib/unity-server-web-admin-2.1.0.jar!/pl/edu/icm/unity/
webadmin/groupbrowser/GroupsTree.class]: Bean instantiation via constructor failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [pl.edu.icm.unity.webadmin.groupbrowser.GroupsTree]: Constructor threw exception; nested ex
ception is java.lang.IllegalArgumentException: entity with key [1] does not exist
at com.vaadin.server.VaadinService.handleExceptionDuringRequest(VaadinService.java:1464) ~[vaadin-server-7.6.4.jar:7.6.4]
at com.vaadin.server.VaadinService.handleRequest(VaadinService.java:1421) ~[vaadin-server-7.6.4.jar:7.6.4]
at com.vaadin.server.VaadinServlet.service(VaadinServlet.java:364) ~[vaadin-server-7.6.4.jar:7.6.4]
... 60 more
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'groupsTree' defined in URL [jar:file:/home/eudat/unity-server-distribution-2.1.0/lib/unity-server-web-admin-2.1.0.jar!/pl/edu/icm/unity/webadmin/groupbrowser/GroupsTree.cla
ss]: Bean instantiation via constructor failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [pl.edu.icm.unity.webadmin.groupbrowser.GroupsTree]: Constructor threw exception; nested exception is java.lang.IllegalArgument
Exception: entity with key [1] does not exist
at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:279) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1193) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1083) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:513) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:325) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:208) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1138) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1066) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:835) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.ConstructorResolver.resolvePreparedArguments(ConstructorResolver.java:785) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:128) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1193) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1083) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:513) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:325) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:208) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1138) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1066) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:835) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:124) [jetty-io-9.4.6.v20170531.jar:9.4.6.v20170531]
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:673) [jetty-util-9.4.6.v20170531.jar:9.4.6.v20170531]
at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:591) [jetty-util-9.4.6.v20170531.jar:9.4.6.v20170531]
at java.lang.Thread.run(Thread.java:745) [?:1.8.0_72-internal]
Caused by: com.vaadin.server.ServiceException: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'groupsTree' defined in URL [jar:file:/home/eudat/unity-server-distribution-2.1.0/lib/unity-server-web-admin-2.1.0.jar!/pl/edu/icm/unity/
webadmin/groupbrowser/GroupsTree.class]: Bean instantiation via constructor failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [pl.edu.icm.unity.webadmin.groupbrowser.GroupsTree]: Constructor threw exception; nested ex
ception is java.lang.IllegalArgumentException: entity with key [1] does not exist
at com.vaadin.server.VaadinService.handleExceptionDuringRequest(VaadinService.java:1464) ~[vaadin-server-7.6.4.jar:7.6.4]
at com.vaadin.server.VaadinService.handleRequest(VaadinService.java:1421) ~[vaadin-server-7.6.4.jar:7.6.4]
at com.vaadin.server.VaadinServlet.service(VaadinServlet.java:364) ~[vaadin-server-7.6.4.jar:7.6.4]
... 60 more
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'groupsTree' defined in URL [jar:file:/home/eudat/unity-server-distribution-2.1.0/lib/unity-server-web-admin-2.1.0.jar!/pl/edu/icm/unity/webadmin/groupbrowser/GroupsTree.cla
ss]: Bean instantiation via constructor failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [pl.edu.icm.unity.webadmin.groupbrowser.GroupsTree]: Constructor threw exception; nested exception is java.lang.IllegalArgument
Exception: entity with key [1] does not exist
at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:279) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1193) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1083) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:513) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:325) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:208) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1138) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1066) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:835) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.ConstructorResolver.resolvePreparedArguments(ConstructorResolver.java:785) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:128) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1193) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1083) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:513) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:325) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:208) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1138) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1066) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:835) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.ConstructorResolver.resolvePreparedArguments(ConstructorResolver.java:785) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:128) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1193) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1083) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:513) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:325) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:208) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1138) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1066) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:835) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.ConstructorResolver.resolvePreparedArguments(ConstructorResolver.java:785) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:128) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1193) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1083) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:513) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:325) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1078) ~[spring-context-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at pl.edu.icm.unity.webui.VaadinUIProvider.createInstance(VaadinUIProvider.java:90) ~[unity-server-web-common-2.1.0.jar:?]
at com.vaadin.server.communication.UIInitHandler.getBrowserDetailsUI(UIInitHandler.java:191) ~[vaadin-server-7.6.4.jar:7.6.4]
at com.vaadin.server.communication.UIInitHandler.synchronizedHandleRequest(UIInitHandler.java:74) ~[vaadin-server-7.6.4.jar:7.6.4]
at com.vaadin.server.SynchronizedRequestHandler.handleRequest(SynchronizedRequestHandler.java:41) ~[vaadin-server-7.6.4.jar:7.6.4]
at com.vaadin.server.VaadinService.handleRequest(VaadinService.java:1409) ~[vaadin-server-7.6.4.jar:7.6.4]
at com.vaadin.server.VaadinServlet.service(VaadinServlet.java:364) ~[vaadin-server-7.6.4.jar:7.6.4]
... 60 more
Caused by: org.springframework.beans.BeanInstantiationException: Failed to instantiate [pl.edu.icm.unity.webadmin.groupbrowser.GroupsTree]: Constructor threw exception; nested exception is java.lang.IllegalArgumentException: entity with key [1] does not exist
at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:154) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:122) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:271) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1193) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1083) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:513) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:325) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.config.DependencyDescriptor.Aug 5, 2017 3:12:07 PM CEST: Starting UNITY Web Server
Exception in thread "main" org.springframework.context.ApplicationContextException: Failed to start bean 'engineInitialization'; nested exception is java.lang.IllegalArgumentException: group [/] does not exist
at org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:178)
at org.springframework.context.support.DefaultLifecycleProcessor.access$200(DefaultLifecycleProcessor.java:50)
at org.springframework.context.support.DefaultLifecycleProcessor$LifecycleGroup.start(DefaultLifecycleProcessor.java:348)
at org.springframework.context.support.DefaultLifecycleProcessor.startBeans(DefaultLifecycleProcessor.java:151)
at org.springframework.context.support.DefaultLifecycleProcessor.onRefresh(DefaultLifecycleProcessor.java:114)
at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:880)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:546)
at pl.edu.icm.unity.engine.server.UnityApplication.run(UnityApplication.java:60)
at pl.edu.icm.unity.engine.server.UnityApplication.main(UnityApplication.java:69)
Caused by: java.lang.IllegalArgumentException: group [/] does not exist
at pl.edu.icm.unity.store.rdbms.GenericNamedRDBMSCRUD.get(GenericNamedRDBMSCRUD.java:97)
at pl.edu.icm.unity.engine.attribute.AttributeClassUtil.getACHelper(AttributeClassUtil.java:112)
at pl.edu.icm.unity.engine.attribute.AttributesHelper.checkGroupAttributeClassesConsistency(AttributesHelper.java:474)
at pl.edu.icm.unity.engine.identity.IdentityHelper.addEntity(IdentityHelper.java:165)
at pl.edu.icm.unity.engine.identity.EntityManagementImpl.lambda$addEntity$0(EntityManagementImpl.java:150)
at pl.edu.icm.unity.store.tx.DefaultTransactionalRunner.runInTransactionRetThrowing(DefaultTransactionalRunner.java:63)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85)
at pl.edu.icm.unity.store.rdbms.tx.SQLTransactionEngine.runInTransaction(SQLTransactionEngine.java:45)
at pl.edu.icm.unity.store.tx.TransactionalAspect.retryIfNeeded4Method(TransactionalAspect.java:75)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
resolveCandidate(DependencyDescriptor.java:208) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1138) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1066) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:835) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.ConstructorResolver.resolvePreparedArguments(ConstructorResolver.java:785) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:128) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1193) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE
... 60 more
Caused by: java.lang.IllegalArgumentException: entity with key [1] does not exist
at pl.edu.icm.unity.store.rdbms.GenericRDBMSCRUD.getByKey(GenericRDBMSCRUD.java:117) ~[unity-server-storage-2.1.0.jar:?]
at pl.edu.icm.unity.engine.identity.EntityResolverImpl.getEntityId(EntityResolverImpl.java:52) ~[unity-server-engine-2.1.0.jar:?]
at pl.edu.icm.unity.engine.identity.EntityManagementImpl.getGroups(EntityManagementImpl.java:587) ~[unity-server-engine-2.1.0.jar:?]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_72-internal]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_72-internal]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_72-internal]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_72-internal]
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333) ~[spring-aop-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) ~[spring-aop-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) ~[spring-aop-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85) ~[spring-aop-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at pl.edu.icm.unity.store.rdbms.tx.SQLTransactionEngine.runInTransaction(SQLTransactionEngine.java:45) ~[unity-server-storage-2.1.0.jar:?]
at pl.edu.icm.unity.store.tx.TransactionalAspect.retryIfNeeded4Method(TransactionalAspect.java:75) ~[unity-server-storage-2.1.0.jar:?]
at sun.reflect.GeneratedMethodAccessor53.invoke(Unknown Source) ~[?:?]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_72-internal]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_72-internal]
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:629) ~[spring-aop-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:618) ~[spring-aop-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70) ~[spring-aop-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:168) ~[spring-aop-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.aop.aspectj.AspectJAfterAdvice.invoke(AspectJAfterAdvice.java:47) ~[spring-aop-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:168) ~[spring-aop-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.aop.aspectj.AspectJAfterThrowingAdvice.invoke(AspectJAfterThrowingAdvice.java:62) ~[spring-aop-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:168) ~[spring-aop-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) ~[spring-aop-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) ~[spring-aop-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213) ~[spring-aop-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at com.sun.proxy.$Proxy62.getGroups(Unknown Source) ~[?:?]
at pl.edu.icm.unity.webadmin.groupbrowser.GroupsTree.setupAccessibleRoots(GroupsTree.java:161) ~[unity-server-web-admin-2.1.0.jar:?]
at pl.edu.icm.unity.webadmin.groupbrowser.GroupsTree.setupRoot(GroupsTree.java:154) ~[unity-server-web-admin-2.1.0.jar:?]
at pl.edu.icm.unity.webadmin.groupbrowser.GroupsTree.<init>(GroupsTree.java:114) ~[unity-server-web-admin-2.1.0.jar:?]
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_72-internal]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[?:1.8.0_72-internal]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.8.0_72-internal]
at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[?:1.8.0_72-internal]
at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:142) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:122) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:271) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1193) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1083) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:513) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:325) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:208) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1138) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1066) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:835) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.ConstructorResolver.resolvePreparedArguments(ConstructorResolver.java:785) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(C..
unity-startup log while restarting the server (after restore):
Aug 5, 2017 3:12:07 PM CEST: Starting UNITY Web Server
Exception in thread "main" org.springframework.context.ApplicationContextException: Failed to start bean 'engineInitialization'; nested exception is java.lang.IllegalArgumentException: group [/] does not exist
at org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:178)
at org.springframework.context.support.DefaultLifecycleProcessor.access$200(DefaultLifecycleProcessor.java:50)
at org.springframework.context.support.DefaultLifecycleProcessor$LifecycleGroup.start(DefaultLifecycleProcessor.java:348)
at org.springframework.context.support.DefaultLifecycleProcessor.startBeans(DefaultLifecycleProcessor.java:151)
at org.springframework.context.support.DefaultLifecycleProcessor.onRefresh(DefaultLifecycleProcessor.java:114)
at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:880)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:546)
at pl.edu.icm.unity.engine.server.UnityApplication.run(UnityApplication.java:60)
at pl.edu.icm.unity.engine.server.UnityApplication.main(UnityApplication.java:69)
Caused by: java.lang.IllegalArgumentException: group [/] does not exist
at pl.edu.icm.unity.store.rdbms.GenericNamedRDBMSCRUD.get(GenericNamedRDBMSCRUD.java:97)
at pl.edu.icm.unity.engine.attribute.AttributeClassUtil.getACHelper(AttributeClassUtil.java:112)
at pl.edu.icm.unity.engine.attribute.AttributesHelper.checkGroupAttributeClassesConsistency(AttributesHelper.java:474)
at pl.edu.icm.unity.engine.identity.IdentityHelper.addEntity(IdentityHelper.java:165)
at pl.edu.icm.unity.engine.identity.EntityManagementImpl.lambda$addEntity$0(EntityManagementImpl.java:150)
at pl.edu.icm.unity.store.tx.DefaultTransactionalRunner.runInTransactionRetThrowing(DefaultTransactionalRunner.java:63)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85)
at pl.edu.icm.unity.store.rdbms.tx.SQLTransactionEngine.runInTransaction(SQLTransactionEngine.java:45)
at pl.edu.icm.unity.store.tx.TransactionalAspect.retryIfNeeded4Method(TransactionalAspect.java:75)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
Thanks in advance for any hints,
Shiraz
On Fri, Aug 4, 2017 at 5:43 PM, Krzysztof Benedyczak <kb...@un...<mailto:kb...@un...>> wrote:
Hi Shiraz,
W dniu 04.08.2017<tel:04.08.2017> o 16:19, Shiraz Memon pisze:
Hi,
I have dropped the existing db and created a new one (the error still persists though):
unity might be expecting a different version of mysql (?):
mysql Ver 14.14 Distrib 5.5.57, for debian-linux-gnu (x86_64) using readline 6.3
yes, at least 5.6 (or corresponding maria DB) is required - MySQL 5.5 does not support CURRENT_TIME parameters.
In general we test on MariaDB 10.1.
HTH,
Krzysztof
--
Shiraz Memon
Federated Systems and Data
Jülich Supercomputing Centre (JSC)
Phone: +49 2461 61 6899
Fax: +49 2461 61 6656
------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------
Forschungszentrum Juelich GmbH
52425 Juelich
Sitz der Gesellschaft: Juelich
Eingetragen im Handelsregister des Amtsgerichts Dueren Nr. HR B 3498
Vorsitzender des Aufsichtsrats: MinDir Dr. Karl Eugen Huthmacher
Geschaeftsfuehrung: Prof. Dr.-Ing. Wolfgang Marquardt (Vorsitzender),
Karsten Beneke (stellv. Vorsitzender), Prof. Dr.-Ing. Harald Bolt,
Prof. Dr. Sebastian M. Schmidt
------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------
|
|
From: Krzysztof B. <kb...@un...> - 2017-08-04 15:43:22
|
Hi Shiraz, W dniu 04.08.2017 o 16:19, Shiraz Memon pisze: > Hi, > > I have dropped the existing db and created a new one (the error still > persists though): > > unity might be expecting a different version of mysql (?): > mysql Ver 14.14 Distrib 5.5.57, for debian-linux-gnu (x86_64) using > readline 6.3 yes, at least 5.6 (or corresponding maria DB) is required - MySQL 5.5 does not support CURRENT_TIME parameters. In general we test on MariaDB 10.1. HTH, Krzysztof |
|
From: Shiraz M. <a....@fz...> - 2017-08-04 14:22:05
|
Hi,
I have dropped the existing db and created a new one (the error still persists though):
unity might be expecting a different version of mysql (?):
mysql Ver 14.14 Distrib 5.5.57, for debian-linux-gnu (x86_64) using readline 6.3
unity-server.log
#############
2017-08-04T16:09:20,768 [main] WARN org.springframework.context.support.ClassPathXmlApplicationContext: Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'serverManagementImpl' defined in
URL [jar:file:/home/eudat/unity-server-distribution-2.1.0/lib/unity-server-engine-2.1.0.jar!/pl/edu/icm/unity/engine/server/ServerManagementImpl.class]: Unsatisfied dependency expressed through constructor parameter 2; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creati
ng bean with name 'storageCleanerImpl' defined in URL [jar:file:/home/eudat/unity-server-distribution-2.1.0/lib/unity-server-storage-2.1.0.jar!/pl/edu/icm/unity/store/StorageCleanerImpl.class]: Unsatisfied dependency expressed through constructor parameter 0; nested exception is org.springframework.beans.factory.Uns
atisfiedDependencyException: Error creating bean with name 'StoreLoaderhz': Unsatisfied dependency expressed through field 'initDB'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'StoreLoaderrdbms' defined in URL [jar:file:/home/eudat/unity-server-distribu
tion-2.1.0/lib/unity-server-storage-2.1.0.jar!/pl/edu/icm/unity/store/rdbms/DB.class]: Bean instantiation via constructor failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [pl.edu.icm.unity.store.rdbms.DB]: Constructor threw exception; nested exception is org.apa
che.ibatis.exceptions.PersistenceException:
### Error committing transaction. Cause: org.apache.ibatis.executor.BatchExecutorException: pl.edu.icm.unity.store.rdbms.mapper.InitdbMapper.initdb-09 (batch index #8) failed. 7 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: (conn:61147) You have an erro
r in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(3)
DEFAULT CURRENT_TIMESTAMP(3) NOT NULL,
UNIQUE(NAME, TYPE)
) engi' at line 8
Query is : CREATE TABLE VAR_OBJECTS(
ID INTEGER PRIMARY KEY AUTO_INCREMENT,
NAME VARCHAR(200),
CONTENTS VARBINARY(60000)
,
TYPE VARCHAR(100),
LAST_UPDATE
DATETIME(3)
DEFAULT CURRENT_TIMESTAMP(3) NOT NULL,
UNIQUE(NAME, TYPE)
) engine=InnoDB, character set utf8
### Cause: org.apache.ibatis.executor.BatchExecutorException: pl.edu.icm.unity.store.rdbms.mapper.InitdbMapper.initdb-09 (batch index #8) failed. 7 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: (conn:61147) You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right syntax to use near '(3)
DEFAULT CURRENT_TIMESTAMP(3) NOT NULL,
UNIQUE(NAME, TYPE)
) engi' at line 8
Query is : CREATE TABLE VAR_OBJECTS(
ID INTEGER PRIMARY KEY AUTO_INCREMENT,
NAME VARCHAR(200),
CONTENTS VARBINARY(60000)
,
TYPE VARCHAR(100),
LAST_UPDATE
DATETIME(3)
DEFAULT CURRENT_TIMESTAMP(3) NOT NULL,
UNIQUE(NAME, TYPE)
) engine=InnoDB, character set utf8
unity-startup.log
#################
Aug 4, 2017 4:09:00 PM CEST: Starting UNITY Web Server
Exception in thread "main" org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'serverManagementImpl' defined in URL [jar:file:/home/eudat/unity-server-distribution-2.1.0/lib/unity-server-engine-2.1.0.jar!/pl/edu/icm/unity/engine/server/ServerManagementImpl.class]: Unsatis
fied dependency expressed through constructor parameter 2; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'storageCleanerImpl' defined in URL [jar:file:/home/eudat/unity-server-distribution-2.1.0/lib/unity-server-storage-2.1.0.jar!/pl/edu/icm/unity
/store/StorageCleanerImpl.class]: Unsatisfied dependency expressed through constructor parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'StoreLoaderhz': Unsatisfied dependency expressed through field 'initDB'; nested exception is org.spr
ingframework.beans.factory.BeanCreationException: Error creating bean with name 'StoreLoaderrdbms' defined in URL [jar:file:/home/eudat/unity-server-distribution-2.1.0/lib/unity-server-storage-2.1.0.jar!/pl/edu/icm/unity/store/rdbms/DB.class]: Bean instantiation via constructor failed; nested exception is org.spring
framework.beans.BeanInstantiationException: Failed to instantiate [pl.edu.icm.unity.store.rdbms.DB]: Constructor threw exception; nested exception is org.apache.ibatis.exceptions.PersistenceException:
### Error committing transaction. Cause: org.apache.ibatis.executor.BatchExecutorException: pl.edu.icm.unity.store.rdbms.mapper.InitdbMapper.initdb-09 (batch index #8) failed. 7 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: (conn:61147) You have an erro
r in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(3)
DEFAULT CURRENT_TIMESTAMP(3) NOT NULL,
UNIQUE(NAME, TYPE)
) engi' at line 8
Query is : CREATE TABLE VAR_OBJECTS(
ID INTEGER PRIMARY KEY AUTO_INCREMENT,
NAME VARCHAR(200),
CONTENTS VARBINARY(60000)
,
TYPE VARCHAR(100),
LAST_UPDATE
DATETIME(3)
DEFAULT CURRENT_TIMESTAMP(3) NOT NULL,
UNIQUE(NAME, TYPE)
) engine=InnoDB, character set utf8
### Cause: org.apache.ibatis.executor.BatchExecutorException: pl.edu.icm.unity.store.rdbms.mapper.InitdbMapper.initdb-09 (batch index #8) failed. 7 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: (conn:61147) You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right syntax to use near '(3)
DEFAULT CURRENT_TIMESTAMP(3) NOT NULL,
UNIQUE(NAME, TYPE)
) engi' at line 8
Query is : CREATE TABLE VAR_OBJECTS(
ID INTEGER PRIMARY KEY AUTO_INCREMENT,
NAME VARCHAR(200),
CONTENTS VARBINARY(60000)
,
TYPE VARCHAR(100),
LAST_UPDATE
DATETIME(3)
DEFAULT CURRENT_TIMESTAMP(3) NOT NULL,
UNIQUE(NAME, TYPE)
) engine=InnoDB, character set utf8
at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:749)
at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:189)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1193)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1095)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:513)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:761)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:867)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:543)
at pl.edu.icm.unity.engine.server.UnityApplication.run(UnityApplication.java:60)
at pl.edu.icm.unity.engine.server.UnityApplication.main(UnityApplication.java:69)
Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'storageCleanerImpl' defined in URL [jar:file:/home/eudat/unity-server-distribution-2.1.0/lib/unity-server-storage-2.1.0.jar!/pl/edu/icm/unity/store/StorageCleanerImpl.class]: Unsatisfied dependency expressed t
hrough constructor parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'StoreLoaderhz': Unsatisfied dependency expressed through field 'initDB'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bea
n with name 'StoreLoaderrdbms' defined in URL [jar:file:/home/eudat/unity-server-distribution-2.1.0/lib/unity-server-storage-2.1.0.jar!/pl/edu/icm/unity/store/rdbms/DB.class]: Bean instantiation via constructor failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [p
l.edu.icm.unity.store.rdbms.DB]: Constructor threw exception; nested exception is org.apache.ibatis.exceptions.PersistenceException:
### Error committing transaction. Cause: org.apache.ibatis.executor.BatchExecutorException: pl.edu.icm.unity.store.rdbms.mapper.InitdbMapper.initdb-09 (batch index #8) failed. 7 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: (conn:61147) You have an erro
r in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(3)
DEFAULT CURRENT_TIMESTAMP(3) NOT NULL,
UNIQUE(NAME, TYPE)
) engi' at line 8
Query is : CREATE TABLE VAR_OBJECTS(
ID INTEGER PRIMARY KEY AUTO_INCREMENT,
NAME VARCHAR(200),
CONTENTS VARBINARY(60000)
,
TYPE VARCHAR(100),
LAST_UPDATE
DATETIME(3)
DEFAULT CURRENT_TIMESTAMP(3) NOT NULL,
UNIQUE(NAME, TYPE)
) engine=InnoDB, character set utf8
### Cause: org.apache.ibatis.executor.BatchExecutorException: pl.edu.icm.unity.store.rdbms.mapper.InitdbMapper.initdb-09 (batch index #8) failed. 7 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: (conn:61147) You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right syntax to use near '(3)
DEFAULT CURRENT_TIMESTAMP(3) NOT NULL,
UNIQUE(NAME, TYPE)
) engi' at line 8
Query is : CREATE TABLE VAR_OBJECTS(
ID INTEGER PRIMARY KEY AUTO_INCREMENT,
NAME VARCHAR(200),
CONTENTS VARBINARY(60000)
,
TYPE VARCHAR(100),
LAST_UPDATE
DATETIME(3)
DEFAULT CURRENT_TIMESTAMP(3) NOT NULL,
UNIQUE(NAME, TYPE)
at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:189)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1193)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1095)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:513)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:208)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1138)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1066)
at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:835)
at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:741)
... 14 more
Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'StoreLoaderhz': Unsatisfied dependency expressed through field 'initDB'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'StoreLoaderrdbms' defined in
URL [jar:file:/home/eudat/unity-server-distribution-2.1.0/lib/unity-server-storage-2.1.0.jar!/pl/edu/icm/unity/store/rdbms/DB.class]: Bean instantiation via constructor failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [pl.edu.icm.unity.store.rdbms.DB]: Construc
tor threw exception; nested exception is org.apache.ibatis.exceptions.PersistenceException:
### Error committing transaction. Cause: org.apache.ibatis.executor.BatchExecutorException: pl.edu.icm.unity.store.rdbms.mapper.InitdbMapper.initdb-09 (batch index #8) failed. 7 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: (conn:61147) You have an erro
r in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(3)
DEFAULT CURRENT_TIMESTAMP(3) NOT NULL,
UNIQUE(NAME, TYPE)
) engi' at line 8
Query is : CREATE TABLE VAR_OBJECTS(
ID INTEGER PRIMARY KEY AUTO_INCREMENT,
NAME VARCHAR(200),
CONTENTS VARBINARY(60000)
,
TYPE VARCHAR(100),
LAST_UPDATE
DATETIME(3)
DEFAULT CURRENT_TIMESTAMP(3) NOT NULL,
UNIQUE(NAME, TYPE)
) engine=InnoDB, character set utf8
### Cause: org.apache.ibatis.executor.BatchExecutorException: pl.edu.icm.unity.store.rdbms.mapper.InitdbMapper.initdb-09 (batch index #8) failed. 7 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: (conn:61147) You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right syntax to use near '(3)
DEFAULT CURRENT_TIMESTAMP(3) NOT NULL,
UNIQUE(NAME, TYPE)
) engi' at line 8
Query is : CREATE TABLE VAR_OBJECTS(
ID INTEGER PRIMARY KEY AUTO_INCREMENT,
NAME VARCHAR(200),
CONTENTS VARBINARY(60000)
,
TYPE VARCHAR(100),
LAST_UPDATE
DATETIME(3)
DEFAULT CURRENT_TIMESTAMP(3) NOT NULL,
UNIQUE(NAME, TYPE)
) engine=InnoDB, character set utf8
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:588)
at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:88)
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:366)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1264)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:553)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:208)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.addCandidateEntry(DefaultListableBeanFactory.java:1316)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:1282)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveMultipleBeans(DefaultListableBeanFactory.java:1205)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1096)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1066)
at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:835)
at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:741)
... 28 more
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'StoreLoaderrdbms' defined in URL [jar:file:/home/eudat/unity-server-distribution-2.1.0/lib/unity-server-storage-2.1.0.jar!/pl/edu/icm/unity/store/rdbms/DB.class]: Bean instantiation via constructor failed; nested excep
tion is org.springframework.beans.BeanInstantiationException: Failed to instantiate [pl.edu.icm.unity.store.rdbms.DB]: Constructor threw exception; nested exception is org.apache.ibatis.exceptions.PersistenceException:
### Error committing transaction. Cause: org.apache.ibatis.executor.BatchExecutorException: pl.edu.icm.unity.store.rdbms.mapper.InitdbMapper.initdb-09 (batch index #8) failed. 7 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: (conn:61147) You have an erro
r in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(3)
DEFAULT CURRENT_TIMESTAMP(3) NOT NULL,
UNIQUE(NAME, TYPE)
) engi' at line 8
Query is : CREATE TABLE VAR_OBJECTS(
ID INTEGER PRIMARY KEY AUTO_INCREMENT,
NAME VARCHAR(200),
CONTENTS VARBINARY(60000)
,
TYPE VARCHAR(100),
LAST_UPDATE
DATETIME(3)
DEFAULT CURRENT_TIMESTAMP(3) NOT NULL,
UNIQUE(NAME, TYPE)
Cheers,
Shiraz
--
Shiraz Memon
Federated Systems and Data
Jülich Supercomputing Centre (JSC)
Phone: +49 2461 61 6899
Fax: +49 2461 61 6656
------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------
Forschungszentrum Juelich GmbH
52425 Juelich
Sitz der Gesellschaft: Juelich
Eingetragen im Handelsregister des Amtsgerichts Dueren Nr. HR B 3498
Vorsitzender des Aufsichtsrats: MinDir Dr. Karl Eugen Huthmacher
Geschaeftsfuehrung: Prof. Dr.-Ing. Wolfgang Marquardt (Vorsitzender),
Karsten Beneke (stellv. Vorsitzender), Prof. Dr.-Ing. Harald Bolt,
Prof. Dr. Sebastian M. Schmidt
------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------
|
|
From: Krzysztof B. <kb...@un...> - 2017-08-04 07:54:03
|
Hi Shiraz, W dniu 03.08.2017 o 17:17, Shiraz Memon pisze: > Hi Krzysztof, all, > > I am trying to deploy v2.1.0 while reusing the configuration (the entire > config folder) from an existing configured v1.9.6 instance, however > adapted it according to the instructions provided under howto-update > page > (http://www.unity-idm.eu/documentation/unity-2.0.0-SNAPSHOT/update-howto-v2.html). > Main changes are the db settings & initialisers in unityServer.conf, > logger configuration in startup.properties and finally copied the > scripts directory from original config folder. I have also created a new > database and assigned appropriate rights to the mysql user that is being > configured inside the configuration. The content from both log files > follows. > > unity-server.log: > ############# > ### Cause: org.apache.ibatis.executor.BatchExecutorException: > pl.edu.icm.unity.store.rdbms.mapper.InitdbMapper.initdb-01 (batch index > #1) failed. Cause: jav > a.sql.BatchUpdateException: (conn:57029) Table 'IDENTITY_TYPES' already > exists I guess somehow your database is corrupted (schema creation failed in the middle). Try to drop the DB, and recreate it - should help. Best, Krzysztof |
|
From: Shiraz M. <a....@fz...> - 2017-08-03 15:28:15
|
Hi Krzysztof, all, I am trying to deploy v2.1.0 while reusing the configuration (the entire config folder) from an existing configured v1.9.6 instance, however adapted it according to the instructions provided under howto-update page (http://www.unity-idm.eu/documentation/unity-2.0.0-SNAPSHOT/update-howto-v2.html). Main changes are the db settings & initialisers in unityServer.conf, logger configuration in startup.properties and finally copied the scripts directory from original config folder. I have also created a new database and assigned appropriate rights to the mysql user that is being configured inside the configuration. The content from both log files follows. unity-server.log: ############# 2017-08-03T16:56:42,159 [main] INFO unity.server.db.InitDB: Initializing DB schema 2017-08-03T16:56:42,488 [main] WARN org.springframework.context.support.ClassPathXmlApplicationContext: Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'serverManagementImpl' define d in URL [jar:file:/home/eudat/unity-server-distribution-2.1.0/lib/unity-server-engine-2.1.0.jar!/pl/edu/icm/unity/engine/server/ServerManagementImpl.class] : Unsatisfied dependency expressed through constructor parameter 2; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Er ror creating bean with name 'storageCleanerImpl' defined in URL [jar:file:/home/eudat/unity-server-distribution-2.1.0/lib/unity-server-storage-2.1.0.jar!/pl /edu/icm/unity/store/StorageCleanerImpl.class]: Unsatisfied dependency expressed through constructor parameter 0; nested exception is org.springframework.be<http://org.springframework.be> ans.factory.UnsatisfiedDependencyException: Error creating bean with name 'StoreLoaderhz': Unsatisfied dependency expressed through field 'initDB'; nested e xception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'StoreLoaderrdbms' defined in URL [jar:file:/home/eudat/u nity-server-distribution-2.1.0/lib/unity-server-storage-2.1.0.jar!/pl/edu/icm/unity/store/rdbms/DB.class]: Bean instantiation via constructor failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [pl.edu.icm.unity.store.rdbms.DB]: Constructor threw exception; ne sted exception is org.apache.ibatis.exceptions.PersistenceException: ### Error committing transaction. Cause: org.apache.ibatis.executor.BatchExecutorException: pl.edu.icm.unity.store.rdbms.mapper.InitdbMapper.initdb-01 (bat ch index #1) failed. Cause: java.sql.BatchUpdateException: (conn:57029) Table 'IDENTITY_TYPES' already exists Query is : CREATE TABLE IDENTITY_TYPES( ID INTEGER PRIMARY KEY AUTO_INCREMENT, NAME VARCHAR(200), CONTENTS VARBINARY(60000) , UNIQUE(NAME) ) engine=InnoDB, character set utf8 ### Cause: org.apache.ibatis.executor.BatchExecutorException: pl.edu.icm.unity.store.rdbms.mapper.InitdbMapper.initdb-01 (batch index #1) failed. Cause: jav a.sql.BatchUpdateException: (conn:57029) Table 'IDENTITY_TYPES' already exists Query is : CREATE TABLE IDENTITY_TYPES( ID INTEGER PRIMARY KEY AUTO_INCREMENT, NAME VARCHAR(200), CONTENTS VARBINARY(60000) , UNIQUE(NAME) ) engine=InnoDB, character set utf8 unity-startup.log ################# ug 3, 2017 4:56:30 PM CEST: Starting UNITY Web Server Exception in thread "main" org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'serverManagementImpl' defined in URL [jar:file:/home/eudat/unity-server-distribution-2.1.0/lib/unity-server-engine-2.1.0.jar!/pl/edu/icm/unity/engine/server/ServerManagementImpl.class]: Un satisfied dependency expressed through constructor parameter 2; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'storageCleanerImpl' defined in URL [jar:file:/home/eudat/unity-server-distribution-2.1.0/lib/unity-server-storage-2.1.0.jar!/pl/edu /icm/unity/store/StorageCleanerImpl.class]: Unsatisfied dependency expressed through constructor parameter 0; nested exception is org.springframework.beans. factory.UnsatisfiedDependencyException: Error creating bean with name 'StoreLoaderhz': Unsatisfied dependency expressed through field 'initDB'; nested excep tion is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'StoreLoaderrdbms' defined in URL [jar:file:/home/eudat/unity -server-distribution-2.1.0/lib/unity-server-storage-2.1.0.jar!/pl/edu/icm/unity/store/rdbms/DB.class]: Bean instantiation via constructor failed; nested exc eption is org.springframework.beans.BeanInstantiationException: Failed to instantiate [pl.edu.icm.unity.store.rdbms.DB]: Constructor threw exception; nested exception is org.apache.ibatis.exceptions.PersistenceException: ### Error committing transaction. Cause: org.apache.ibatis.executor.BatchExecutorException: pl.edu.icm.unity.store.rdbms.mapper.InitdbMapper.initdb-01 (bat ch index #1) failed. Cause: java.sql.BatchUpdateException: (conn:57029) Table 'IDENTITY_TYPES' already exists Query is : CREATE TABLE IDENTITY_TYPES( ID INTEGER PRIMARY KEY AUTO_INCREMENT, NAME VARCHAR(200), CONTENTS VARBINARY(60000) , UNIQUE(NAME) ) engine=InnoDB, character set utf8 ### Cause: org.apache.ibatis.executor.BatchExecutorException: pl.edu.icm.unity.store.rdbms.mapper.InitdbMapper.initdb-01 (batch index #1) failed. Cause: jav a.sql.BatchUpdateException: (conn:57029) Table 'IDENTITY_TYPES' already exists Query is : CREATE TABLE IDENTITY_TYPES( ID INTEGER PRIMARY KEY AUTO_INCREMENT, NAME VARCHAR(200), CONTENTS VARBINARY(60000) , UNIQUE(NAME) ) engine=InnoDB, character set utf8 at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:749) at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:189) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1193) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1095) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:513) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:761) at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:867) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:543) at pl.edu.icm.unity.engine.server.UnityApplication.run(UnityApplication.java:60) at pl.edu.icm.unity.engine.server.UnityApplication.main(UnityApplication.java:69) Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'storageCleanerImpl' defined in URL [jar:file:/home/eudat/unity-server-distribution-2.1.0/lib/unity-server-storage-2.1.0.jar!/pl/edu/icm/unity/store/StorageCleanerImpl.class]: Unsatisfied dependency expressed t hrough constructor parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'StoreLoaderhz': Unsatisfied dependency expressed through field 'initDB'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bea n with name 'StoreLoaderrdbms' defined in URL [jar:file:/home/eudat/unity-server-distribution-2.1.0/lib/unity-server-storage-2.1.0.jar!/pl/edu/icm/unity/store/rdbms/DB.class]: Bean instantiation via constructor failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [p l.edu.icm.unity.store.rdbms.DB]: Constructor threw exception; nested exception is org.apache.ibatis.exceptions.PersistenceException: ### Error committing transaction. Cause: org.apache.ibatis.executor.BatchExecutorException: pl.edu.icm.unity.store.rdbms.mapper.InitdbMapper.initdb-01 (batch index #1) failed. Cause: java.sql.BatchUpdateException: (conn:57029) Table 'IDENTITY_TYPES' already exists Query is : CREATE TABLE IDENTITY_TYPES( ID INTEGER PRIMARY KEY AUTO_INCREMENT, NAME VARCHAR(200), CONTENTS VARBINARY(60000) , UNIQUE(NAME) ) engine=InnoDB, character set utf8 ### Cause: org.apache.ibatis.executor.BatchExecutorException: pl.edu.icm.unity.store.rdbms.mapper.InitdbMapper.initdb-01 (batch index #1) failed. Cause: java.sql.BatchUpdateException: (conn:57029) Table 'IDENTITY_TYPES' already exists Query is : CREATE TABLE IDENTITY_TYPES( ID INTEGER PRIMARY KEY AUTO_INCREMENT, NAME VARCHAR(200), CONTENTS VARBINARY(60000) , UNIQUE(NAME) ) engine=InnoDB, character set utf8 at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:749) at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:189) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1193) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1095) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:513) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:208) at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1138) at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1066) at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:835) at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:741) ... 14 more Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'StoreLoaderhz': Unsatisfied dependency expressed through field 'initDB'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'StoreLoaderrdbms' defined in URL [jar:file:/home/eudat/unity-server-distribution-2.1.0/lib/unity-server-storage-2.1.0.jar!/pl/edu/icm/unity/store/rdbms/DB.class]: Bean instantiation via constructor failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [pl.edu.icm.unity.store.rdbms.DB]: Construc tor threw exception; nested exception is org.apache.ibatis.exceptions.PersistenceException: ### Error committing transaction. Cause: org.apache.ibatis.executor.BatchExecutorException: pl.edu.icm.unity.store.rdbms.mapper.InitdbMapper.initdb-01 (batch index #1) failed. Cause: java.sql.BatchUpdateException: (conn:57029) Table 'IDENTITY_TYPES' already exists Query is : CREATE TABLE IDENTITY_TYPES( ID INTEGER PRIMARY KEY AUTO_INCREMENT, NAME VARCHAR(200), CONTENTS VARBINARY(60000) , UNIQUE(NAME) ) engine=InnoDB, character set utf8 ### Cause: org.apache.ibatis.executor.BatchExecutorException: pl.edu.icm.unity.store.rdbms.mapper.InitdbMapper.initdb-01 (batch index #1) failed. Cause: java.sql.BatchUpdateException: (conn:57029) Table 'IDENTITY_TYPES' already exists Query is : CREATE TABLE IDENTITY_TYPES( ID INTEGER PRIMARY KEY AUTO_INCREMENT, NAME VARCHAR(200), CONTENTS VARBINARY(60000) , UNIQUE(NAME) ) engine=InnoDB, character set utf8 at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:588) at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:88) at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:366) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1264) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:553) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:208) at org.springframework.beans.factory.support.DefaultListableBeanFactory.addCandidateEntry(DefaultListableBeanFactory.java:1316) at org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:1282) at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveMultipleBeans(DefaultListableBeanFactory.java:1205) at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1096) at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1066) at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:835) at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:741) ... 28 more Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'StoreLoaderrdbms' defined in URL [jar:file:/home/eudat/unity-server-distribution-2.1.0/lib/unity-server-storage-2.1.0.jar!/pl/edu/icm/unity/store/rdbms/DB.class]: Bean instantiation via constructor failed; nested excep tion is org.springframework.beans.BeanInstantiationException: Failed to instantiate [pl.edu.icm.unity.store.rdbms.DB]: Constructor threw exception; nested exception is org.apache.ibatis.exceptions.PersistenceException: ### Error committing transaction. Cause: org.apache.ibatis.executor.BatchExecutorException: pl.edu.icm.unity.store.rdbms.mapper.InitdbMapper.initdb-01 (batch index #1) failed. Cause: java.sql.BatchUpdateException: (conn:57029) Table 'IDENTITY_TYPES' already exists Query is : CREATE TABLE IDENTITY_TYPES( ID INTEGER PRIMARY KEY AUTO_INCREMENT, NAME VARCHAR(200), CONTENTS VARBINARY(60000 ) engine=InnoDB, character set utf8 ### Cause: org.apache.ibatis.executor.BatchExecutorException: pl.edu.icm.unity.store.rdbms.mapper.InitdbMapper.initdb-01 (batch index #1) failed. Cause: java.sql.BatchUpdateException: (conn:57029) Table 'IDENTITY_TYPES' already exists Query is : CREATE TABLE IDENTITY_TYPES( ID INTEGER PRIMARY KEY AUTO_INCREMENT, NAME VARCHAR(200), CONTENTS VARBINARY(60000) , UNIQUE(NAME) ) engine=InnoDB, character set utf8 at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:279) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1193) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1095) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:513) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:208) at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1138) at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1066) at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:585) ... 45 more Caused by: org.springframework.beans.BeanInstantiationException: Failed to instantiate [pl.edu.icm.unity.store.rdbms.DB]: Constructor threw exception; nested exception is org.apache.ibatis.exceptions.PersistenceException: ### Error committing transaction. Cause: org.apache.ibatis.executor.BatchExecutorException: pl.edu.icm.unity.store.rdbms.mapper.InitdbMapper.initdb-01 (batch index #1) failed. Cause: java.sql.BatchUpdateException: (conn:57029) Table 'IDENTITY_TYPES' already exists Query is : CREATE TABLE IDENTITY_TYPES( ID INTEGER PRIMARY KEY AUTO_INCREMENT, NAME VARCHAR(200), CONTENTS VARBINARY(60000) , UNIQUE(NAME) ) engine=InnoDB, character set utf8 ### Cause: org.apache.ibatis.executor.BatchExecutorException: pl.edu.icm.unity.store.rdbms.mapper.InitdbMapper.initdb-01 (batch index #1) failed. Cause: java.sql.BatchUpdateException: (conn:57029) Table 'IDENTITY_TYPES' already exists Query is : CREATE TABLE IDENTITY_TYPES( ID INTEGER PRIMARY KEY AUTO_INCREMENT, NAME VARCHAR(200), CONTENTS VARBINARY(60000) , UNIQUE(NAME) ) engine=InnoDB, character set utf8 at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:154) at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:122) at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:271) ... 57 more Caused by: org.apache.ibatis.exceptions.PersistenceException: ### Error committing transaction. Cause: org.apache.ibatis.executor.BatchExecutorException: pl.edu.icm.unity.store.rdbms.mapper.InitdbMapper.initdb-01 (batch index #1) failed. Cause: java.sql.BatchUpdateException: (conn:57029) Table 'IDENTITY_TYPES' already exists Query is : CREATE TABLE IDENTITY_TYPES( ID INTEGER PRIMARY KEY AUTO_INCREMENT, NAME VARCHAR(200), CONTENTS VARBINARY(60000) , UNIQUE(NAME) ) engine=InnoDB, character set utf8 ### Cause: org.apache.ibatis.executor.BatchExecutorException: pl.edu.icm.unity.store.rdbms.mapper.InitdbMapper.initdb-01 (batch index #1) failed. Cause: java.sql.BatchUpdateException: (conn:57029) Table 'IDENTITY_TYPES' already exists Query is : CREATE TABLE IDENTITY_TYPES( ID INTEGER PRIMARY KEY AUTO_INCREMENT, NAME VARCHAR(200), CONTENTS VARBINARY(60000) , UNIQUE(NAME) ) engine=InnoDB, character set utf8 at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30) at org.apache.ibatis.session.defaults.DefaultSqlSession.commit(DefaultSqlSession.java:227) at org.apache.ibatis.session.defaults.DefaultSqlSession.commit(DefaultSqlSession.java:218) at pl.edu.icm.unity.store.rdbms.InitDB.performUpdate(InitDB.java:145) at pl.edu.icm.unity.store.rdbms.InitDB.initDB(InitDB.java:155) at pl.edu.icm.unity.store.rdbms.InitDB.initIfNeeded(InitDB.java:78) at pl.edu.icm.unity.store.rdbms.DB.initialize(DB.java:87) at pl.edu.icm.unity.store.rdbms.DB.<init>(DB.java:51) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:142) ... 59 more .... Any ideas? Cheers, Shiraz -- Shiraz Memon Federated Systems and Data Jülich Supercomputing Centre (JSC) Phone: +49 2461 61 6899 Fax: +49 2461 61 6656 ------------------------------------------------------------------------------------------------ ------------------------------------------------------------------------------------------------ Forschungszentrum Juelich GmbH 52425 Juelich Sitz der Gesellschaft: Juelich Eingetragen im Handelsregister des Amtsgerichts Dueren Nr. HR B 3498 Vorsitzender des Aufsichtsrats: MinDir Dr. Karl Eugen Huthmacher Geschaeftsfuehrung: Prof. Dr.-Ing. Wolfgang Marquardt (Vorsitzender), Karsten Beneke (stellv. Vorsitzender), Prof. Dr.-Ing. Harald Bolt, Prof. Dr. Sebastian M. Schmidt ------------------------------------------------------------------------------------------------ ------------------------------------------------------------------------------------------------ |
|
From: Sander A. <sa....@fz...> - 2017-08-02 14:24:09
|
Hi Krzysztof, I got a report about using OIDC client. Unity seems to reserve a mandatory attribute if not all requested scopes are available. Please see the message below. In that case we did not define the scope profile. WaTTS is requesting the scope 'email profile openid' (double checked in the browser log) b2access displays the user that only 'email openid' was requested, which is wrong. User is returned to WaTTS without any 'scope' attribute (also double checked with browser log), which MUST be present if it is not as requested: "[..] If the issued access token scope is different from the one requested by the client, the authorization server MUST include the "scope" response parameter to inform the client of the actual scope granted. " https://tools.ietf.org/html/rfc6749#section-3.3 Best regards, Sander -- Federated Systems and Data Juelich Supercomputing Centre phone: +49 2461 61 8847 fax: +49 2461 61 6656 email: sa....@fz... ----------------------------------------------------------------------- ----------------------------------------------------------------------- Forschungszentrum Juelich GmbH 52425 Juelich Sitz der Gesellschaft: Juelich Eingetragen im Handelsregister des Amtsgerichts Dueren Nr. HR B 3498 Vorsitzender des Aufsichtsrats: MinDir Dr. Karl Eugen Huthmacher Geschaeftsfuehrung: Prof. Dr.-Ing. Wolfgang Marquardt (Vorsitzender), Karsten Beneke (stellv. Vorsitzender), Prof. Dr.-Ing. Harald Bolt, Prof. Dr. Sebastian M. Schmidt ----------------------------------------------------------------------- ----------------------------------------------------------------------- |
|
From: Krzysztof B. <kb...@un...> - 2017-08-02 09:00:13
|
W dniu 02.08.2017 o 10:38, Sander Apweiler pisze: > Hi Krzysztof, > > I'm struggling on a new instance with oath clients. An user signs in to > the Oauth SP and the infromation to the SPs are not released. The SP > only says "Login Error! Your IdP returned you with the error > <<"server_error">>. Please contact your IdP.". In the response is > Unexpected server error. The unity log file shows the error below. > > 2017-08-01 15:40:38,827 [qtp1441014857-149] TRACE > unity.server.web.InvocationContextSetupFilter - A new invocation > context was set > 2017-08-01 15:40:38,827 [qtp1441014857-149] TRACE > unity.server.web.InvocationContextSetupFilter - Login session was set > for the invocation context > 2017-08-01 15:40:38,827 [qtp1441014857-149] TRACE > unity.server.web.InvocationContextSetupFilter - Default locale was set > for the invocation context > 2017-08-01 15:40:38,827 [qtp1441014857-149] DEBUG > unity.server.RoutingServlet - Routing request to DEFAULT destination > /oauth2-authz-consentdecider > 2017-08-01 15:40:38,827 [qtp1441014857-149] TRACE > unity.server.web.AuthenticationFilter - Request to not protected > address: /oauth2-as/oauth2-authz-consentdecider > 2017-08-01 15:40:38,827 [qtp1441014857-149] TRACE > unity.server.web.InvocationContextSetupFilter - A new invocation > context was set > 2017-08-01 15:40:38,827 [qtp1441014857-149] TRACE > unity.server.web.InvocationContextSetupFilter - Login session was set > for the invocation context > 2017-08-01 15:40:38,827 [qtp1441014857-149] TRACE > unity.server.web.InvocationContextSetupFilter - Default locale was set > for the invocation context > 2017-08-01 15:40:38,827 [qtp1441014857-149] TRACE > unity.server.TransactionalAspect - Starting sql session for > execution(PreferencesManagement.getPreference(..)) > 2017-08-01 15:40:38,832 [qtp1441014857-149] TRACE > unity.server.TransactionalAspect - Releassing sql session for > execution(PreferencesManagement.getPreference(..)) > 2017-08-01 15:40:38,832 [qtp1441014857-149] DEBUG > unity.server.web.IdPPreferences - It was impossible to establish > preferences for 9 will use defaults > pl.edu.icm.unity.exceptions.AuthorizationException: Access is denied. > The operation getPreference requires 'read' capability > at > pl.edu.icm.unity.engine.authz.AuthorizationManagerImpl.checkAuthorizationInternal(AuthorizationManagerImpl.java:252) > at > pl.edu.icm.unity.engine.authz.AuthorizationManagerImpl.checkAuthorization(AuthorizationManagerImpl.java:179) > > The same error message is shown for the operation getGroups. If I sing > in to the SP with an unity admin account it works. But I don't know > which access rights are wrong. Do you have a hint for this problem? Yes. Basically every entity that is actively using unity (whether this is oauth client or a user that authenticates via oauth) requires at least the read capability which is provided by the "Regular user" role. Please see Authorization section in documentation for more details. HTH Krzyszotf |
|
From: Sander A. <sa....@fz...> - 2017-08-02 08:55:41
|
Hi Krzysztof, the problem is solved. I forgot to assign the regular user role. Best regards, Sander Am Mittwoch, den 02.08.2017, 10:38 +0200 schrieb Sander Apweiler: > Hi Krzysztof, > > I'm struggling on a new instance with oath clients. An user signs in > to the Oauth SP and the infromation to the SPs are not released. The > SP only says "Login Error! Your IdP returned you with the error > <<"server_error">>. Please contact your IdP.". In the response is > Unexpected server error. The unity log file shows the error below. > > 2017-08-01 15:40:38,827 [qtp1441014857-149] TRACE > unity.server.web.InvocationContextSetupFilter - A new invocation > context was set > 2017-08-01 15:40:38,827 [qtp1441014857-149] TRACE > unity.server.web.InvocationContextSetupFilter - Login session was > set for the invocation context > 2017-08-01 15:40:38,827 [qtp1441014857-149] TRACE > unity.server.web.InvocationContextSetupFilter - Default locale was > set for the invocation context > 2017-08-01 15:40:38,827 [qtp1441014857-149] DEBUG > unity.server.RoutingServlet - Routing request to DEFAULT destination > /oauth2-authz-consentdecider > 2017-08-01 15:40:38,827 [qtp1441014857-149] TRACE > unity.server.web.AuthenticationFilter - Request to not protected > address: /oauth2-as/oauth2-authz-consentdecider > 2017-08-01 15:40:38,827 [qtp1441014857-149] TRACE > unity.server.web.InvocationContextSetupFilter - A new invocation > context was set > 2017-08-01 15:40:38,827 [qtp1441014857-149] TRACE > unity.server.web.InvocationContextSetupFilter - Login session was > set for the invocation context > 2017-08-01 15:40:38,827 [qtp1441014857-149] TRACE > unity.server.web.InvocationContextSetupFilter - Default locale was > set for the invocation context > 2017-08-01 15:40:38,827 [qtp1441014857-149] TRACE > unity.server.TransactionalAspect - Starting sql session for > execution(PreferencesManagement.getPreference(..)) > 2017-08-01 15:40:38,832 [qtp1441014857-149] TRACE > unity.server.TransactionalAspect - Releassing sql session for > execution(PreferencesManagement.getPreference(..)) > 2017-08-01 15:40:38,832 [qtp1441014857-149] DEBUG > unity.server.web.IdPPreferences - It was impossible to establish > preferences for 9 will use defaults > pl.edu.icm.unity.exceptions.AuthorizationException: Access is denied. > The operation getPreference requires 'read' capability > at > pl.edu.icm.unity.engine.authz.AuthorizationManagerImpl.checkAuthoriza > tionInternal(AuthorizationManagerImpl.java:252) > at > pl.edu.icm.unity.engine.authz.AuthorizationManagerImpl.checkAuthoriza > tion(AuthorizationManagerImpl.java:179) > > The same error message is shown for the operation getGroups. If I > sing in to the SP with an unity admin account it works. But I don't > know which access rights are wrong. Do you have a hint for this > problem? > > Best regards, > Sander > -- > Federated Systems and Data > Juelich Supercomputing Centre > > phone: +49 2461 61 8847 > fax: +49 2461 61 6656 > email: sa....@fz... > > ------------------------------------------------------------------- > ---- > ------------------------------------------------------------------- > ---- > Forschungszentrum Juelich GmbH > 52425 Juelich > Sitz der Gesellschaft: Juelich > Eingetragen im Handelsregister des Amtsgerichts Dueren Nr. HR B 3498 > Vorsitzender des Aufsichtsrats: MinDir Dr. Karl Eugen Huthmacher > Geschaeftsfuehrung: Prof. Dr.-Ing. Wolfgang Marquardt (Vorsitzender), > Karsten Beneke (stellv. Vorsitzender), Prof. Dr.-Ing. Harald Bolt, > Prof. Dr. Sebastian M. Schmidt > ------------------------------------------------------------------- > ---- > ------------------------------------------------------------------- > ---- > ------------------------------------------------------------------- > ----------- > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > _______________________________________________ > Unity-idm-discuss mailing list > Uni...@li... > https://lists.sourceforge.net/lists/listinfo/unity-idm-discuss -- Federated Systems and Data Juelich Supercomputing Centre phone: +49 2461 61 8847 fax: +49 2461 61 6656 email: sa....@fz... ----------------------------------------------------------------------- ----------------------------------------------------------------------- Forschungszentrum Juelich GmbH 52425 Juelich Sitz der Gesellschaft: Juelich Eingetragen im Handelsregister des Amtsgerichts Dueren Nr. HR B 3498 Vorsitzender des Aufsichtsrats: MinDir Dr. Karl Eugen Huthmacher Geschaeftsfuehrung: Prof. Dr.-Ing. Wolfgang Marquardt (Vorsitzender), Karsten Beneke (stellv. Vorsitzender), Prof. Dr.-Ing. Harald Bolt, Prof. Dr. Sebastian M. Schmidt ----------------------------------------------------------------------- ----------------------------------------------------------------------- |
|
From: Sander A. <sa....@fz...> - 2017-08-02 08:39:44
|
Hi Krzysztof,
I'm struggling on a new instance with oath clients. An user signs in to
the Oauth SP and the infromation to the SPs are not released. The SP
only says "Login Error! Your IdP returned you with the error
<<"server_error">>. Please contact your IdP.". In the response is
Unexpected server error. The unity log file shows the error below.
2017-08-01 15:40:38,827 [qtp1441014857-149] TRACE
unity.server.web.InvocationContextSetupFilter - A new invocation
context was set
2017-08-01 15:40:38,827 [qtp1441014857-149] TRACE
unity.server.web.InvocationContextSetupFilter - Login session was set
for the invocation context
2017-08-01 15:40:38,827 [qtp1441014857-149] TRACE
unity.server.web.InvocationContextSetupFilter - Default locale was set
for the invocation context
2017-08-01 15:40:38,827 [qtp1441014857-149] DEBUG
unity.server.RoutingServlet - Routing request to DEFAULT destination
/oauth2-authz-consentdecider
2017-08-01 15:40:38,827 [qtp1441014857-149] TRACE
unity.server.web.AuthenticationFilter - Request to not protected
address: /oauth2-as/oauth2-authz-consentdecider
2017-08-01 15:40:38,827 [qtp1441014857-149] TRACE
unity.server.web.InvocationContextSetupFilter - A new invocation
context was set
2017-08-01 15:40:38,827 [qtp1441014857-149] TRACE
unity.server.web.InvocationContextSetupFilter - Login session was set
for the invocation context
2017-08-01 15:40:38,827 [qtp1441014857-149] TRACE
unity.server.web.InvocationContextSetupFilter - Default locale was set
for the invocation context
2017-08-01 15:40:38,827 [qtp1441014857-149] TRACE
unity.server.TransactionalAspect - Starting sql session for
execution(PreferencesManagement.getPreference(..))
2017-08-01 15:40:38,832 [qtp1441014857-149] TRACE
unity.server.TransactionalAspect - Releassing sql session for
execution(PreferencesManagement.getPreference(..))
2017-08-01 15:40:38,832 [qtp1441014857-149] DEBUG
unity.server.web.IdPPreferences - It was impossible to establish
preferences for 9 will use defaults
pl.edu.icm.unity.exceptions.AuthorizationException: Access is denied.
The operation getPreference requires 'read' capability
at
pl.edu.icm.unity.engine.authz.AuthorizationManagerImpl.checkAuthorizati
onInternal(AuthorizationManagerImpl.java:252)
at
pl.edu.icm.unity.engine.authz.AuthorizationManagerImpl.checkAuthorizati
on(AuthorizationManagerImpl.java:179)
The same error message is shown for the operation getGroups. If I sing
in to the SP with an unity admin account it works. But I don't know
which access rights are wrong. Do you have a hint for this problem?
Best regards,
Sander
--
Federated Systems and Data
Juelich Supercomputing Centre
phone: +49 2461 61 8847
fax: +49 2461 61 6656
email: sa....@fz...
-----------------------------------------------------------------------
-----------------------------------------------------------------------
Forschungszentrum Juelich GmbH
52425 Juelich
Sitz der Gesellschaft: Juelich
Eingetragen im Handelsregister des Amtsgerichts Dueren Nr. HR B 3498
Vorsitzender des Aufsichtsrats: MinDir Dr. Karl Eugen Huthmacher
Geschaeftsfuehrung: Prof. Dr.-Ing. Wolfgang Marquardt (Vorsitzender),
Karsten Beneke (stellv. Vorsitzender), Prof. Dr.-Ing. Harald Bolt,
Prof. Dr. Sebastian M. Schmidt
-----------------------------------------------------------------------
----------------------------------------------------------------------- |
|
From: Krzysztof B. <kb...@un...> - 2017-07-31 14:04:00
|
Small correction: W dniu 29.07.2017 o 13:33, Krzysztof Benedyczak pisze: > Download links and detailed list of changes is available at: > http://www.unity-idm.eu/site/downloads The proper download link is: http://www.unity-idm.eu/downloads (no /site in the path) Sorry for the mistake! Krzysztof |
|
From: Krzysztof B. <kb...@un...> - 2017-07-29 11:33:48
|
Dear Subscribers, Subsequent Unity feature release v2.1.0 is available for download. This release brings important enhancements in the OAuth area. - The standard OAuth token refresh feature is now fully supported. - Unity supports now the OAuth token exchange protocol, allowing for simple multi-step delegation in OAuth environments. - REST API was enhanced with operations to manage all sorts of tokens maintained by Unity, including OAuth tokens. - Both AdminUI and HomeUI allows for managing OAuth tokens (all and owned respectively). It is therefore possible to revoke issued grants from UI. Naturally management of refresh tokens is also supported. - There were minor UX improvements on the login screen providing better focus behavior. Download links and detailed list of changes is available at: http://www.unity-idm.eu/site/downloads Best regards, Krzysztof |
|
From: Krzysztof B. <kb...@un...> - 2017-07-04 15:35:38
|
W dniu 04.07.2017 o 17:31, André Moreira pisze: > Hi Krzysztof, > > Just to clarify, the values I mentioned are in seconds. So the > strange boundary is actually 5 minutes 58 seconds! By what you wrote, > I assume your tests are covering update intervals far superior to > this boundary (“typically in a range of one hour”). This makes me > think that you are probably not able to reproduce the issue and that > it is most likely caused by some misconfiguration on our side. Do you > see anything wrong with the configuration bellow? Yes, you are correct. On our end: automated tests use a very short update interval (up to 10 seconds), but I run a deployment with one hour of update interval and it worked fine I believe. So bug is opened and I'll look into it. Your config looks fine. Best, Krzysztof |
|
From: André M. <an...@cl...> - 2017-07-04 15:31:45
|
Hi Krzysztof, Just to clarify, the values I mentioned are in seconds. So the strange boundary is actually 5 minutes 58 seconds! By what you wrote, I assume your tests are covering update intervals far superior to this boundary (“typically in a range of one hour”). This makes me think that you are probably not able to reproduce the issue and that it is most likely caused by some misconfiguration on our side. Do you see anything wrong with the configuration bellow? Full conf/endpoints/saml-webidp.properties file ####################################### # SAML web IdP SAML endpoint settings ####################################### unity.saml.issuerURI=https://idm.clarin.eu unity.saml.credential=IDP unity.saml.defaultGroup=/clarin unity.saml.spAcceptPolicy=validRequester unity.saml.signResponses=asRequest unity.saml.validityPeriod=3600 unity.saml.requestValidityPeriod=600 unity.saml.authenticationTimeout=20 unity.saml.acceptedSPMetadataSource.1.url=https://infra.clarin.eu/aai/md_about_spf_sps.xml unity.saml.acceptedSPMetadataSource.2.url=file:///opt/dev-sp.clarin.eu.xml unity.saml.acceptedSPMetadataSource.3.url=file:///opt/b2access.eudat.eu.xml unity.saml.refreshInterval=3600 # <== works if this is set to unity.saml.refreshInterval=358 or less unity.saml.translationProfile=SAML-Attributes unity.saml.skipConsent=true Regards, André > On 4 Jul 2017, at 16:33, Krzysztof Benedyczak <kb...@un...> wrote: > > Hi, > > W dniu 30.06.2017 o 17:53, André Moreira pisze: >> Hi Krzysztof, thank you very much for your answer. Based on the >> suggestions I ran some tests while setting the logging to TRACE but >> the results puzzled me even further. So when I set >> unity.saml.refreshInterval to a value <=358 , the auto refresh works >> just fine. If I set it to anything >358 it stops working. The logs >> still show the refresh action and the various entityIDs being updated >> but it behaves as if no changes were made to the metadata source. > > Indeed that's very strange. We test and use smaller values (typically in a range of one hour) so it is quite likely that > this is untested. Still the 378 boundary is very puzzling. I'll look into it. > > At least it seems you have a decent workaround for now ;-) > > Best > Krzysztof > |
|
From: Krzysztof B. <kb...@un...> - 2017-07-04 14:41:46
|
Hi Sander, W dniu 04.07.2017 o 15:28, Sander Apweiler pisze: > Hi Krzysztof, > > today we had some problems with SQL Session. The logfile output is > appended below. Nothing in logfile indicates a reason for this problem. > DB log shows no problem/error. One SQL session was kept for 1129 > seconds. Parallel to this warnings the CPU usage increased to 100%. > During the problem was a training course where 40 users created new > accounts and/or singed in. > > We use a mariadb on the same host. It was the first time we had this > problems. Do you have a hint when this error is shown in the log files? Nothing to worry about. This is an internal watchdog that suspicious transactions - those which take long to complete. Threshold (quite arbitrary) is set to >3s. If this happened during a peak load - then no problem. If this happens during regular operation, may mean that we have a bug/deadlock and then this stack trace is very valuable. Best Krzysztof |
|
From: Krzysztof B. <kb...@un...> - 2017-07-04 14:33:46
|
Hi, W dniu 30.06.2017 o 17:53, André Moreira pisze: > Hi Krzysztof, thank you very much for your answer. Based on the > suggestions I ran some tests while setting the logging to TRACE but > the results puzzled me even further. So when I set > unity.saml.refreshInterval to a value <=358 , the auto refresh works > just fine. If I set it to anything >358 it stops working. The logs > still show the refresh action and the various entityIDs being updated > but it behaves as if no changes were made to the metadata source. Indeed that's very strange. We test and use smaller values (typically in a range of one hour) so it is quite likely that this is untested. Still the 378 boundary is very puzzling. I'll look into it. At least it seems you have a decent workaround for now ;-) Best Krzysztof |
|
From: Sander A. <sa....@fz...> - 2017-07-04 13:28:31
|
Hi Krzysztof, today we had some problems with SQL Session. The logfile output is appended below. Nothing in logfile indicates a reason for this problem. DB log shows no problem/error. One SQL session was kept for 1129 seconds. Parallel to this warnings the CPU usage increased to 100%. During the problem was a training course where 40 users created new accounts and/or singed in. We use a mariadb on the same host. It was the first time we had this problems. Do you have a hint when this error is shown in the log files? Best regards,Sander 2017-07-04 08:57:51,116 [qtp1859956068-45] WARN unity.server.db.DBSessionManager - SqlSession is kept for more than 3s: 3.151s by pool-1-thread-4. Next report in at least 2000ms. Stacktrace is: java.lang.Thread.getStackTrace(Thread.java:1552) pl.edu.icm.unity.db.DBSessionManager.getSqlSession(DBSessionManager.jav a:119) pl.edu.icm.unity.db.DBSessionManager.getSqlSession(DBSessionManager.jav a:108) pl.edu.icm.unity.engine.transactions.TransactionalAspect.createNewSqlSe ssion(TransactionalAspect.java:135) pl.edu.icm.unity.engine.transactions.TransactionalAspect.setupTransacti onSession(TransactionalAspect.java:113) pl.edu.icm.unity.engine.transactions.TransactionalAspect.retryIfNeeded( TransactionalAspect.java:62) pl.edu.icm.unity.engine.transactions.TransactionalAspect.retryIfNeeded4 Method(TransactionalAspect.java:54) sun.reflect.GeneratedMethodAccessor21.invoke(Unknown Source) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccesso rImpl.java:43) java.lang.reflect.Method.invoke(Method.java:498) org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMetho dWithGivenArgs(AbstractAspectJAdvice.java:620) org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMetho d(AbstractAspectJAdvice.java:609) org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroun dAdvice.java:68) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Re flectiveMethodInvocation.java:168) org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke( ExposeInvocationInterceptor.java:92) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Re flectiveMethodInvocation.java:179) org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicA opProxy.java:208) com.sun.proxy.$Proxy26.runInTransaction(Unknown Source) pl.edu.icm.unity.engine.endpoints.EndpointsUpdater.updateInternal(Endpo intsUpdater.java:75) pl.edu.icm.unity.utils.ScheduledUpdaterBase.update(ScheduledUpdaterBase .java:53) pl.edu.icm.unity.utils.ScheduledUpdaterBase.run(ScheduledUpdaterBase.ja va:88) java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.ac cess$301(ScheduledThreadPoolExecutor.java:180) java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.ru n(ScheduledThreadPoolExecutor.java:294) java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.ja va:1142) java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.j ava:617) java.lang.Thread.run(Thread.java:745) -- Federated Systems and Data Juelich Supercomputing Centre phone: +49 2461 61 8847 fax: +49 2461 61 6656 email: sa....@fz... ----------------------------------------------------------------------- ----------------------------------------------------------------------- Forschungszentrum Juelich GmbH 52425 Juelich Sitz der Gesellschaft: Juelich Eingetragen im Handelsregister des Amtsgerichts Dueren Nr. HR B 3498 Vorsitzender des Aufsichtsrats: MinDir Dr. Karl Eugen Huthmacher Geschaeftsfuehrung: Prof. Dr.-Ing. Wolfgang Marquardt (Vorsitzender), Karsten Beneke (stellv. Vorsitzender), Prof. Dr.-Ing. Harald Bolt, Prof. Dr. Sebastian M. Schmidt ----------------------------------------------------------------------- ----------------------------------------------------------------------- |
