You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@syncope.apache.org by Tech <te...@psynd.net> on 2017/04/26 17:16:19 UTC
Adding new fields over a MariaDB
Hello,
using the Syncope 203, when we try to add a new type, we get this error
at the moment of saving the change.
Here we just try to add an additional email with an EmailValidator, but
this happen with any new field that we try to add.
Regars
17:11:15.595 ERROR
org.apache.syncope.core.rest.cxf.RestServiceExceptionMapper - Exception
thrown
org.springframework.orm.jpa.JpaSystemException: The transaction has been
rolled back. See the nested exceptions for details on the errors that
occurred.; nested exception is <openjpa-2.4.2-r422266:1777108 fatal
general error> org.apache.openjpa.persistence.PersistenceException: The
transaction has been rolled back. See the nested exceptions for details
on the errors that occurred.
FailedObject:
org.apache.syncope.core.persistence.jpa.entity.JPAPlainSchema@ebe52d1
at
org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:418)
~[spring-orm-4.3.7.RELEASE.jar:4.3.7.RELEASE]
at
org.springframework.orm.jpa.DefaultJpaDialect.translateExceptionIfPossible(DefaultJpaDialect.java:122)
~[spring-orm-4.3.7.RELEASE.jar:4.3.7.RELEASE]
at
org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:521)
~[spring-orm-4.3.7.RELEASE.jar:4.3.7.RELEASE]
at
org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:761)
~[spring-tx-4.3.7.RELEASE.jar:4.3.7.RELEASE]
at
org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:730)
~[spring-tx-4.3.7.RELEASE.jar:4.3.7.RELEASE]
at
org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:504)
~[spring-tx-4.3.7.RELEASE.jar:4.3.7.RELEASE]
at
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:292)
~[spring-tx-4.3.7.RELEASE.jar:4.3.7.RELEASE]
at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
~[spring-tx-4.3.7.RELEASE.jar:4.3.7.RELEASE]
at
org.apache.syncope.core.persistence.jpa.spring.DomainTransactionInterceptor.invoke(DomainTransactionInterceptor.java:64)
~[syncope-core-persistence-jpa-2.0.3.jar:2.0.3]
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
~[spring-aop-4.3.7.RELEASE.jar:4.3.7.RELEASE]
at
org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
~[spring-aop-4.3.7.RELEASE.jar:4.3.7.RELEASE]
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
~[spring-aop-4.3.7.RELEASE.jar:4.3.7.RELEASE]
at
org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:656)
~[spring-aop-4.3.7.RELEASE.jar:4.3.7.RELEASE]
at
org.apache.syncope.core.logic.SchemaLogic$$EnhancerBySpringCGLIB$$9787cf5b.create(<generated>)
~[syncope-core-logic-2.0.3.jar:2.0.3]
at
org.apache.syncope.core.rest.cxf.service.SchemaServiceImpl.create(SchemaServiceImpl.java:41)
~[syncope-core-rest-cxf-2.0.3.jar:2.0.3]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[?:1.8.0_111]
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
~[?:1.8.0_111]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[?:1.8.0_111]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_111]
at
org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:180)
~[cxf-core-3.1.11.jar:3.1.11]
at
org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:96)
~[cxf-core-3.1.11.jar:3.1.11]
at
org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:189)
~[cxf-rt-frontend-jaxrs-3.1.11.jar:3.1.11]
at
org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:99)
~[cxf-rt-frontend-jaxrs-3.1.11.jar:3.1.11]
at
org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:59)
~[cxf-core-3.1.11.jar:3.1.11]
at
org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:96)
~[cxf-core-3.1.11.jar:3.1.11]
at
org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:308)
~[cxf-core-3.1.11.jar:3.1.11]
at
org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121)
~[cxf-core-3.1.11.jar:3.1.11]
at
org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:262)
~[cxf-rt-transports-http-3.1.11.jar:3.1.11]
at
org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:234)
~[cxf-rt-transports-http-3.1.11.jar:3.1.11]
at
org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:208)
~[cxf-rt-transports-http-3.1.11.jar:3.1.11]
at
org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:160)
~[cxf-rt-transports-http-3.1.11.jar:3.1.11]
at
org.apache.cxf.transport.servlet.CXFNonSpringServlet.invoke(CXFNonSpringServlet.java:180)
~[cxf-rt-transports-http-3.1.11.jar:3.1.11]
at
org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:299)
~[cxf-rt-transports-http-3.1.11.jar:3.1.11]
at
org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPost(AbstractHTTPServlet.java:218)
~[cxf-rt-transports-http-3.1.11.jar:3.1.11]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
~[servlet-api.jar:?]
at
org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:274)
~[cxf-rt-transports-http-3.1.11.jar:3.1.11]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292)
~[catalina.jar:8.0.43]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
~[catalina.jar:8.0.43]
at
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
~[tomcat-websocket.jar:8.0.43]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
~[catalina.jar:8.0.43]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
~[catalina.jar:8.0.43]
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:317)
~[spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE]
at
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
~[spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE]
at
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
~[spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE]
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
~[spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE]
at
org.apache.syncope.core.spring.security.MustChangePasswordFilter.doFilter(MustChangePasswordFilter.java:77)
~[syncope-core-spring-2.0.3.jar:2.0.3]
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
~[spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE]
at
org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114)
~[spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE]
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
~[spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE]
at
org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
~[spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE]
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
~[spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE]
at
org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170)
~[spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE]
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
~[spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE]
at
org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:158)
~[spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE]
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
~[spring-web-4.3.7.RELEASE.jar:4.3.7.RELEASE]
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
~[spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE]
at
org.apache.syncope.core.spring.security.JWTAuthenticationFilter.doFilterInternal(JWTAuthenticationFilter.java:102)
~[syncope-core-spring-2.0.3.jar:2.0.3]
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
~[spring-web-4.3.7.RELEASE.jar:4.3.7.RELEASE]
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
~[spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE]
at
org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
~[spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE]
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
~[spring-web-4.3.7.RELEASE.jar:4.3.7.RELEASE]
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
~[spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE]
at
org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
~[spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE]
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
~[spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE]
at
org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214)
~[spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE]
at
org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177)
~[spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE]
at
org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
~[spring-web-4.3.7.RELEASE.jar:4.3.7.RELEASE]
at
org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)
~[spring-web-4.3.7.RELEASE.jar:4.3.7.RELEASE]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
~[catalina.jar:8.0.43]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
~[catalina.jar:8.0.43]
at
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)
~[spring-web-4.3.7.RELEASE.jar:4.3.7.RELEASE]
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
~[spring-web-4.3.7.RELEASE.jar:4.3.7.RELEASE]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
~[catalina.jar:8.0.43]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
~[catalina.jar:8.0.43]
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)
~[catalina.jar:8.0.43]
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:94)
~[catalina.jar:8.0.43]
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)
~[catalina.jar:8.0.43]
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)
~[catalina.jar:8.0.43]
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
~[catalina.jar:8.0.43]
at
org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:620)
~[catalina.jar:8.0.43]
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
~[catalina.jar:8.0.43]
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:502)
~[catalina.jar:8.0.43]
at
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1132)
~[tomcat-coyote.jar:8.0.43]
at
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:684)
~[tomcat-coyote.jar:8.0.43]
at
org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1533)
~[tomcat-coyote.jar:8.0.43]
at
org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1489)
~[tomcat-coyote.jar:8.0.43]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
[?:1.8.0_111]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
[?:1.8.0_111]
at
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
~[tomcat-util.jar:8.0.43]
at java.lang.Thread.run(Thread.java:745) [?:1.8.0_111]
Caused by: org.apache.openjpa.persistence.PersistenceException: The
transaction has been rolled back. See the nested exceptions for details
on the errors that occurred.
at
org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2368)
~[openjpa-kernel-2.4.2.jar:2.4.2]
at
org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2205)
~[openjpa-kernel-2.4.2.jar:2.4.2]
at
org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2103)
~[openjpa-kernel-2.4.2.jar:2.4.2]
at
org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:2021)
~[openjpa-kernel-2.4.2.jar:2.4.2]
at
org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:81)
~[openjpa-kernel-2.4.2.jar:2.4.2]
at
org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1526)
~[openjpa-kernel-2.4.2.jar:2.4.2]
at
org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:932)
~[openjpa-kernel-2.4.2.jar:2.4.2]
at
org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:571)
~[openjpa-persistence-2.4.2.jar:2.4.2]
at
org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:517)
~[spring-orm-4.3.7.RELEASE.jar:4.3.7.RELEASE]
... 87 more
Caused by: org.apache.openjpa.persistence.PersistenceException:
(conn:34) Incorrect arguments to mysqld_stmt_execute
Query is: INSERT INTO PlainSchema (id, cipherAlgorithm,
conversionPattern, enumerationKeys, enumerationValues,
mandatoryCondition, mimeType, multivalue, readonly, secretKey, type,
uniqueConstraint, validatorClass, ANYTYPECLASS_ID) VALUES (?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?), parameters
['psy_p_emailWork',<null>,<null>,<Buffer:''>,<Buffer:''>,'false',<null>,0,0,<null>,'String',0,'org.apache.syncope.core.persistence.jpa.attrvalue.validation.EmailAddressValidator',<null>]
{prepstmnt 894668994 INSERT INTO PlainSchema (id, cipherAlgorithm,
conversionPattern, enumerationKeys, enumerationValues,
mandatoryCondition, mimeType, multivalue, readonly, secretKey, type,
uniqueConstraint, validatorClass, ANYTYPECLASS_ID) VALUES (?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?)} [code=1210, state=HY000]
at
org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:5003)
~[openjpa-jdbc-2.4.2.jar:2.4.2]
at
org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4963)
~[openjpa-jdbc-2.4.2.jar:2.4.2]
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:133)
~[openjpa-jdbc-2.4.2.jar:2.4.2]
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:75)
~[openjpa-jdbc-2.4.2.jar:2.4.2]
at
org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:144)
~[openjpa-jdbc-2.4.2.jar:2.4.2]
at
org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:79)
~[openjpa-jdbc-2.4.2.jar:2.4.2]
at
org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:100)
~[openjpa-jdbc-2.4.2.jar:2.4.2]
at
org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:88)
~[openjpa-jdbc-2.4.2.jar:2.4.2]
at
org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:357)
~[openjpa-jdbc-2.4.2.jar:2.4.2]
at
org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flushGraph(ConstraintUpdateManager.java:349)
~[openjpa-jdbc-2.4.2.jar:2.4.2]
at
org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:97)
~[openjpa-jdbc-2.4.2.jar:2.4.2]
at
org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:59)
~[openjpa-jdbc-2.4.2.jar:2.4.2]
at
org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:104)
~[openjpa-jdbc-2.4.2.jar:2.4.2]
at
org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:77)
~[openjpa-jdbc-2.4.2.jar:2.4.2]
at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:731)
~[openjpa-jdbc-2.4.2.jar:2.4.2]
at
org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:131)
~[openjpa-kernel-2.4.2.jar:2.4.2]
at
org.apache.openjpa.datacache.DataCacheStoreManager.flush(DataCacheStoreManager.java:668)
~[openjpa-kernel-2.4.2.jar:2.4.2]
at
org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:131)
~[openjpa-kernel-2.4.2.jar:2.4.2]
at
org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2205)
~[openjpa-kernel-2.4.2.jar:2.4.2]
at
org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2103)
~[openjpa-kernel-2.4.2.jar:2.4.2]
at
org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:2021)
~[openjpa-kernel-2.4.2.jar:2.4.2]
at
org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:81)
~[openjpa-kernel-2.4.2.jar:2.4.2]
at
org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1526)
~[openjpa-kernel-2.4.2.jar:2.4.2]
at
org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:932)
~[openjpa-kernel-2.4.2.jar:2.4.2]
at
org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:571)
~[openjpa-persistence-2.4.2.jar:2.4.2]
at
org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:517)
~[spring-orm-4.3.7.RELEASE.jar:4.3.7.RELEASE]
... 87 more
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: (conn:34)
Incorrect arguments to mysqld_stmt_execute
Query is: INSERT INTO PlainSchema (id, cipherAlgorithm,
conversionPattern, enumerationKeys, enumerationValues,
mandatoryCondition, mimeType, multivalue, readonly, secretKey, type,
uniqueConstraint, validatorClass, ANYTYPECLASS_ID) VALUES (?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?), parameters
['psy_p_emailWork',<null>,<null>,<Buffer:''>,<Buffer:''>,'false',<null>,0,0,<null>,'String',0,'org.apache.syncope.core.persistence.jpa.attrvalue.validation.EmailAddressValidator',<null>]
{prepstmnt 894668994 INSERT INTO PlainSchema (id, cipherAlgorithm,
conversionPattern, enumerationKeys, enumerationValues,
mandatoryCondition, mimeType, multivalue, readonly, secretKey, type,
uniqueConstraint, validatorClass, ANYTYPECLASS_ID) VALUES (?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?)} [code=1210, state=HY000]
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:218)
~[openjpa-lib-2.4.2.jar:2.4.2]
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:194)
~[openjpa-lib-2.4.2.jar:2.4.2]
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$1000(LoggingConnectionDecorator.java:58)
~[openjpa-lib-2.4.2.jar:2.4.2]
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:1133)
~[openjpa-lib-2.4.2.jar:2.4.2]
at
org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:275)
~[openjpa-lib-2.4.2.jar:2.4.2]
at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1791)
~[openjpa-jdbc-2.4.2.jar:2.4.2]
at
org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.executeUpdate(PreparedStatementManagerImpl.java:268)
~[openjpa-jdbc-2.4.2.jar:2.4.2]
at
org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:119)
~[openjpa-jdbc-2.4.2.jar:2.4.2]
at
org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:79)
~[openjpa-jdbc-2.4.2.jar:2.4.2]
at
org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:100)
~[openjpa-jdbc-2.4.2.jar:2.4.2]
at
org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:88)
~[openjpa-jdbc-2.4.2.jar:2.4.2]
at
org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:357)
~[openjpa-jdbc-2.4.2.jar:2.4.2]
at
org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flushGraph(ConstraintUpdateManager.java:349)
~[openjpa-jdbc-2.4.2.jar:2.4.2]
at
org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:97)
~[openjpa-jdbc-2.4.2.jar:2.4.2]
at
org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:59)
~[openjpa-jdbc-2.4.2.jar:2.4.2]
at
org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:104)
~[openjpa-jdbc-2.4.2.jar:2.4.2]
at
org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:77)
~[openjpa-jdbc-2.4.2.jar:2.4.2]
at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:731)
~[openjpa-jdbc-2.4.2.jar:2.4.2]
at
org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:131)
~[openjpa-kernel-2.4.2.jar:2.4.2]
at
org.apache.openjpa.datacache.DataCacheStoreManager.flush(DataCacheStoreManager.java:668)
~[openjpa-kernel-2.4.2.jar:2.4.2]
at
org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:131)
~[openjpa-kernel-2.4.2.jar:2.4.2]
at
org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2205)
~[openjpa-kernel-2.4.2.jar:2.4.2]
at
org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2103)
~[openjpa-kernel-2.4.2.jar:2.4.2]
at
org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:2021)
~[openjpa-kernel-2.4.2.jar:2.4.2]
at
org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:81)
~[openjpa-kernel-2.4.2.jar:2.4.2]
at
org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1526)
~[openjpa-kernel-2.4.2.jar:2.4.2]
at
org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:932)
~[openjpa-kernel-2.4.2.jar:2.4.2]
at
org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:571)
~[openjpa-persistence-2.4.2.jar:2.4.2]
at
org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:517)
~[spring-orm-4.3.7.RELEASE.jar:4.3.7.RELEASE]
... 87 more
Re: Adding new fields over a MariaDB
Posted by Francesco Chicchiriccò <il...@apache.org>.
On 26/04/2017 19:16, Tech wrote:
>
> Hello,
>
> using the Syncope 203, when we try to add a new type, we get this
> error at the moment of saving the change.
>
> Here we just try to add an additional email with an EmailValidator,
> but this happen with any new field that we try to add.
>
> Regars
>
> [...]
> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException:
> (conn:34) Incorrect arguments to mysqld_stmt_execute
> Query is: INSERT INTO PlainSchema (id, cipherAlgorithm,
> conversionPattern, enumerationKeys, enumerationValues,
> mandatoryCondition, mimeType, multivalue, readonly, secretKey, type,
> uniqueConstraint, validatorClass, ANYTYPECLASS_ID) VALUES (?, ?, ?, ?,
> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), parameters
> ['psy_p_emailWork',<null>,<null>,<Buffer:''>,<Buffer:''>,'false',<null>,0,0,<null>,'String',0,'org.apache.syncope.core.persistence.jpa.attrvalue.validation.EmailAddressValidator',<null>]
> {prepstmnt 894668994 INSERT INTO PlainSchema (id, cipherAlgorithm,
> conversionPattern, enumerationKeys, enumerationValues,
> mandatoryCondition, mimeType, multivalue, readonly, secretKey, type,
> uniqueConstraint, validatorClass, ANYTYPECLASS_ID) VALUES (?, ?, ?, ?,
> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)} [code=1210, state=HY000]
>
Just google a bit and you will find that such error is often caused by
some versions of the MySQL JDBC driver (I assume that is applicable to
MariaDB) as well.
More generally, I do believe that most of the troubles you are
experiencing lately are due to bad MySQL / MariaDB versions, tuning and
configuration, as your errors are hardly reproducible with recent
versions of MySQL, MariaDB or their respective JDBC drivers.
Regards.
--
Francesco Chicchiricc�
Tirasa - Open Source Excellence
http://www.tirasa.net/
Member at The Apache Software Foundation
Syncope, Cocoon, Olingo, CXF, OpenJPA, PonyMail
http://home.apache.org/~ilgrosso/