getLastPrimaryKeys() called before valid insert/replace/update operation has been performed

claudiobosticco
Registered Developer
Join Date: Sep 2008
Posts: 3091
getLastPrimaryKeys() called before valid insert/replace/update operation has been performed

6 Jun 2022, 01:32
SmartClient Version: v12.1p_2022-03-15/Enterprise Deployment (built 2022-03-15)

Hello Isomorphic
I've got some random errors like this:
Code:
2022-06-05T09:46:49,585 [ ] WARN DefaultValidators No size provided for binary field 'DOC'
2022-06-05T09:46:49,588 [ ] INFO SQLDriver Executing SQL query on 'DBJOFC': INSERT INTO DBJOFC.JOFC_DOCUMENTI_SOCI (CREATOR, CREATOR_TIMESTAMP, DOC, DOC_DATE_CREATED, DOC_FILENAME, DOC_FILESIZE, ID_CLUB_FK, ID_SOCIO_FK, IS_DOC_INVALIDITA, MODIFIER, MODIFIER_TIMESTAMP, ID_REC) VALUES ('', TO_DATE('2022-06-05 09:46:49','YYYY-MM-DD HH24:MI:SS'), ?, TO_DATE('2022-06-05 09:46:49','YYYY-MM-DD HH24:MI:SS'), 'BERTELLI DOMENICO 2.jpeg', 118881, 34198, 5521905, NULL, '', TO_DATE('2022-06-05 09:46:49','YYYY-MM-DD HH24:MI:SS'), DBJOFC.SEQUENCE_ID_JOFC.NextVal)
2022-06-05T09:46:49,723 [ ] WARN DataSourceDMI operationBinding for DataSource: JOFC_SOCI with operationType: fetchJOFC_SOCI_fetch does not have a <serverObject> in force and does not specify any operationBinding settings that could affect its behavior. This operation will almost certainly give the same result as a default operation, and so is almost certainly unnecessary
2022-06-05T09:46:49,725 [ ] INFO SQLDataSource derived query: SELECT $defaultSelectClause FROM $defaultTableClause
                $defaultAnsiJoinClause
                left outer JOIN DBJOFC.JOFC_ABBONAMENTI ON JOFC_SOCI.ID_REC = JOFC_ABBONAMENTI.ID_SOCIO_FK

                and JOFC_ABBONAMENTI.ID_STAGIONE_FK = $sessionAttributes.stagioneCorrente.ID_REC
             WHERE $defaultWhereClause
2022-06-05T09:46:49,728 [ ] INFO SQLDriver Executing SQL query on 'DBJOFC': SELECT JOFC_SOCI.ID_REC, JOFC_SOCI.FAN_SERVICE_USER, JOFC_SOCI.NOME, JOFC_SOCI.COGNOME, JOFC_SOCI.DATA_NASCITA, JOFC_SOCI.TELEFONO, JOFC_SOCI.ID_NAZIONE_NASCITA_FK, JOFC_SOCI.ID_COMUNE_NASCITA_FK, JOFC_SOCI.ID_CLUB_FK, JOFC_SOCI.LOCALITA_NASCITA, JOFC_SOCI.ID_NAZIONE_RESIDENZA_FK, JOFC_SOCI.ID_COMUNE_RESIDENZA_FK, JOFC_SOCI.LOCALITA_RESIDENZA, JOFC_SOCI.DA_LEFIMA, JOFC_SOCI.SESSO, JOFC_SOCI.TIPO_DOC, JOFC_SOCI.NUMERO_DOC, JOFC_SOCI.EMAIL, JOFC_SOCI.FIDELITY_CARD, JOFC_SOCI.NUMERO_MEMBERSHIP, JOFC_SOCI.FIDELITY_SCAD, JOFC_SOCI.MEMBERSHIP_SCAD, JOFC_SOCI.FLAG_PRIVACY_MKT, JOFC_SOCI.FLAG_PROFILAZIONE, JOFC_SOCI.FLAG_AUTORIZZAZIONE_MINORI, JOFC_SOCI.FLAG_USO_IMMAGINI, JOFC_SOCI.LOTTO, JOFC_SOCI.FL_STATUS, JOFC_SOCI.RUOLO, JOFC_SOCI.FL_DISABILITATO, JOFC_SOCI.COMUNE_RES_TXT, JOFC_SOCI.INDIRIZZO_RES_TXT, JOFC_SOCI.PROVINCIA_RES_TXT, JOFC_SOCI.CREATOR, JOFC_SOCI.CREATOR_TIMESTAMP, JOFC_SOCI.MODIFIER, JOFC_SOCI.MODIFIER_TIMESTAMP, JOFC_SOCI.NOTE_DISATTIVAZIONE, JOFC_SOCI.NOTE_ATTIVAZIONE, JOFC_SOCI.FLAG_VERIFICA_ID, JOFC_SOCI.TIMESTAMP_VERIFICA_ID, JOFC_SOCI.UTENTE_VERIFICA_ID, JOFC_SOCI.FLAG_VERIFICA_INVALIDITA, JOFC_SOCI.TIMESTAMP_VERIFICA_INVALIDITA, JOFC_SOCI.UTENTE_VERIFICA_INVALIDITA, JOFC_SOCI.TIMESTAMP_CONDIZIONI_JC, JOFC_SOCI.NOME_NORMALIZZATO, JOFC_SOCI.COGNOME_NORMALIZZATO, JOFC_SOCI.IS_NORMALIZZATO_DA_BO, JOFC_SOCI.IS_BONIFICATO, JOFC_SOCI.UTENTE_NORMALIZZAZIONE_BO, JOFC_SOCI.DATA_NORMALIZZAZIONE_BO, JOFC_SOCI.CODICE_FISCALE, JOFC_SOCI.NOTE_ELIMINAZIONE, JOFC_SOCI.CODICE_E_CARD, JOFC_SOCI.DATA_INVIO_E_CARD, JOFC_SOCI.LOTTO_E_CARD, JOFC_SOCI.MEMBERSHIP_TYPE, JOFC_SOCI.FRM_ID, JOFC_SOCI.UUID, JOFC_SOCI.OLD_UUID, JOFC_SOCI.UTENTE_RIMOZIONE_UUID, JOFC_SOCI.DATA_RIMOZIONE_UUID, JOFC_SOCI.COGNOME||' '||JOFC_SOCI.NOME AS NOMINATIVO, JOFC_ABBONAMENTI.SUPERAREA AS SUPERAREA, JOFC_ABBONAMENTI.CODICE_SETTORE AS CODICE_SETTORE, JOFC_ABBONAMENTI.NUMERO_FILA AS NUMERO_FILA, JOFC_ABBONAMENTI.NUMERO_POSTO AS NUMERO_POSTO, (case when JOFC_SOCI.NUMERO_DOC is not null then 'T' else 'F' end) AS DOC_INSERITO, CASE WHEN JOFC_SOCI.FLAG_VERIFICA_ID = 'M' THEN 'N' WHEN JOFC_SOCI.FLAG_VERIFICA_ID IS NOT NULL THEN JOFC_SOCI.FLAG_VERIFICA_ID ELSE '-' END AS STATO_DOC_INSERITO, (select count(*) from DBJOFC.JOFC_DOCUMENTI_SOCI where jofc_soci.ID_REC = JOFC_DOCUMENTI_SOCI.ID_SOCIO_FK) AS NUMERO_DOCUMENTI, JOFC_SOCI.USER_SOSTITUZIONE_JC, JOFC_SOCI.TIMESTAMP_SOSTITUZIONE_JC, NVL(COMUNI.NOME,JOFC_SOCI.LOCALITA_NASCITA) AS COMUNE_OR_LOCALITA_EXPORT, NAZION.NOME AS NAZIONE, NAZIONE_RES.DENOMINAZIONE_IT AS NAZIONE_RESIDENZA, NAZION.NOME_EN AS NAZIONE_EN, NAZION.IS_EUROPA, COMUNI.NOME AS COMUNE, COMUNE_RES.DENOMINAZIONE_IT AS COMUNE_RESIDENZA, JOFC_CLUB.NOME_FAN_CLUB AS CLUB,
                (select JOFC_STATI_CLUB.STATO
                from JOFC_PASSAGGI_STATO, JOFC_STATI_CLUB
                where JOFC_PASSAGGI_STATO.ID_CLUB_FK = JOFC_CLUB.ID_REC
                and JOFC_PASSAGGI_STATO.STATO = JOFC_STATI_CLUB.STATE_CODE
                order by JOFC_PASSAGGI_STATO.DATA
                desc offset 0 rows fetch next 1 rows only)
             AS STATO_CLUB,
                (select JOFC_PASSAGGI_STATO.STATO
                from JOFC_PASSAGGI_STATO
                where JOFC_PASSAGGI_STATO.ID_CLUB_FK = JOFC_CLUB.ID_REC
                order by JOFC_PASSAGGI_STATO.DATA
                desc offset 0 rows fetch next 1 rows only)
             AS STATE_CODE_CLUB, JOFC_CLUB.ID_NAZIONE_FK AS ID_NAZIONE_CLUB, JOFC_CLUB.LINGUA_COMUNICAZIONE, NAZIONE.IS_EUROPA AS IS_EUROPA_CLUB, COMUNE.NOME AS COMUNE_CLUB, JOFC_CLUB.LOCALITA AS LOCALITA_CLUB, JOFC_CLUB.UUID AS UUID_CLUB FROM DBJOFC.JOFC_SOCI
                 LEFT OUTER JOIN DBSALES.JPC_NAZIONI NAZION ON JOFC_SOCI.ID_NAZIONE_NASCITA_FK = NAZION.ID_REC LEFT OUTER JOIN DBJFRAME.GEO_NAZIONI NAZIONE_RES ON JOFC_SOCI.ID_NAZIONE_RESIDENZA_FK = NAZIONE_RES.ID_REC LEFT OUTER JOIN DBSALES.JPC_COMUNI COMUNI ON JOFC_SOCI.ID_COMUNE_NASCITA_FK = COMUNI.ID_REC LEFT OUTER JOIN DBJFRAME.GEO_COMUNI COMUNE_RES ON JOFC_SOCI.ID_COMUNE_RESIDENZA_FK = COMUNE_RES.ID_REC JOIN DBJOFC.JOFC_CLUB ON JOFC_SOCI.ID_CLUB_FK = JOFC_CLUB.ID_REC JOIN DBSALES.JPC_NAZIONI NAZIONE ON JOFC_CLUB.ID_NAZIONE_FK = NAZIONE.ID_REC LEFT OUTER JOIN DBSALES.JPC_COMUNI COMUNE ON JOFC_CLUB.ID_COMUNE_FK = COMUNE.ID_REC
                left outer JOIN DBJOFC.JOFC_ABBONAMENTI ON JOFC_SOCI.ID_REC = JOFC_ABBONAMENTI.ID_SOCIO_FK

                and JOFC_ABBONAMENTI.ID_STAGIONE_FK = 8137210
             WHERE ((JOFC_SOCI.ID_CLUB_FK = 34198 AND JOFC_SOCI.ID_CLUB_FK IS NOT NULL) AND (JOFC_SOCI.ID_CLUB_FK = 34198 AND JOFC_SOCI.ID_CLUB_FK IS NOT NULL))
2022-06-05T09:46:49,876 [ ] INFO SQLDriver Executing SQL query on 'DBJOFC': SELECT DBJOFC.SEQUENCE_ID_JOFC.CurrVal FROM DUAL
2022-06-05T09:46:49,877 [ ] INFO SQLDataSource primaryKeys: {ID_REC=5521909}
2022-06-05T09:46:49,879 [ ] ERROR ConteggiSociDMI Errore durante il caricemento del documento d'identit�
java.lang.Exception: getLastPrimaryKeys() called before valid insert/replace/update operation has been performed
    at com.isomorphic.sql.SQLDataSource.getLastPrimaryKeys(SQLDataSource.java:830) ~[isomorphic-sql-12.1-p20220315.jar:?]
    at com.isomorphic.sql.SQLDataSource.getLastRow(SQLDataSource.java:679) ~[isomorphic-sql-12.1-p20220315.jar:?]
    at com.isomorphic.sql.SQLDataSource.SQLExecute(SQLDataSource.java:2026) ~[isomorphic-sql-12.1-p20220315.jar:?]
    at com.isomorphic.sql.SQLDataSource.processRequest(SQLDataSource.java:449) ~[isomorphic-sql-12.1-p20220315.jar:?]
    at com.isomorphic.sql.SQLDataSource.executeAdd(SQLDataSource.java:402) ~[isomorphic-sql-12.1-p20220315.jar:?]
    at com.isomorphic.datasource.DataSource.execute(DataSource.java:2556) ~[isomorphic-core-rpc-12.1-p20220315.jar:?]
    at com.isomorphic.application.AppBase.executeDefaultDSOperation(AppBase.java:658) ~[isomorphic-core-rpc-12.1-p20220315.jar:?]
    at com.isomorphic.application.AppBase.executeAppOperation(AppBase.java:555) ~[isomorphic-core-rpc-12.1-p20220315.jar:?]
    at com.isomorphic.application.AppBase.execute(AppBase.java:498) ~[isomorphic-core-rpc-12.1-p20220315.jar:?]
    at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:3093) ~[isomorphic-core-rpc-12.1-p20220315.jar:?]
    at com.juve.jofc.ConteggiSociDMI.insDocSimple(ConteggiSociDMI.java:607) [classes/:build 957]
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_292]
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_292]
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_292]
    at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_292]
    at com.isomorphic.base.Reflection._invokeMethod(Reflection.java:581) [isomorphic-core-rpc-12.1-p20220315.jar:?]
    at com.isomorphic.base.Reflection.adaptArgsAndInvoke(Reflection.java:896) [isomorphic-core-rpc-12.1-p20220315.jar:?]
    at com.isomorphic.datasource.DataSourceDMI.execute(DataSourceDMI.java:434) [isomorphic-core-rpc-12.1-p20220315.jar:?]
    at com.isomorphic.datasource.DataSourceDMI.execute(DataSourceDMI.java:64) [isomorphic-core-rpc-12.1-p20220315.jar:?]
    at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:3088) [isomorphic-core-rpc-12.1-p20220315.jar:?]
    at com.isomorphic.servlet.IDACall.handleDSRequest(IDACall.java:226) [isomorphic-core-rpc-12.1-p20220315.jar:?]
    at com.juve.jofc.SecureIDACall.handleDSRequest(SecureIDACall.java:100) [classes/:build 957]
    at com.isomorphic.servlet.IDACall.processRPCTransaction(IDACall.java:183) [isomorphic-core-rpc-12.1-p20220315.jar:?]
    at com.isomorphic.servlet.IDACall.processRequest(IDACall.java:148) [isomorphic-core-rpc-12.1-p20220315.jar:?]
    at com.isomorphic.servlet.IDACall._processRequest(IDACall.java:119) [isomorphic-core-rpc-12.1-p20220315.jar:?]
    at com.isomorphic.servlet.IDACall.doPost(IDACall.java:79) [isomorphic-core-rpc-12.1-p20220315.jar:?]
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:661) [servlet-api.jar:?]
    at com.isomorphic.servlet.BaseServlet.service(BaseServlet.java:178) [isomorphic-core-rpc-12.1-p20220315.jar:?]
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:742) [servlet-api.jar:?]
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [catalina.jar:8.5.41]
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.41]
    at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) [tomcat-websocket.jar:8.5.41]
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.41]
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.41]
    at com.isomorphic.servlet.CompressionFilter._doFilter(CompressionFilter.java:263) [isomorphic-core-rpc-12.1-p20220315.jar:?]
    at com.isomorphic.servlet.BaseFilter.doFilter(BaseFilter.java:91) [isomorphic-core-rpc-12.1-p20220315.jar:?]
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.41]
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.41]
    at com.juve.jofc.auth.FrameOriginFilter.doFilter(FrameOriginFilter.java:35) [classes/:build 957]
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.41]
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.41]
    at com.juve.utils.Log4j2SessionFilter.doFilter(Log4j2SessionFilter.java:85) [classes/:build 957]
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.41]
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.41]
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:119) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:158) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.jasig.cas.client.session.SingleSignOutFilter.doFilter(SingleSignOutFilter.java:97) [cas-client-core-3.5.1.jar:3.5.1]
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.csrf.CsrfFilter.doFilterInternal(CsrfFilter.java:124) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:74) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.access.channel.ChannelProcessingFilter.doFilter(ChannelProcessingFilter.java:157) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178) [spring-security-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:357) [spring-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:270) [spring-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.41]
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.41]
    at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200) [spring-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.41]
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.41]
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:186) [catalina.jar:8.5.41]
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [catalina.jar:8.5.41]
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493) [catalina.jar:8.5.41]
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) [catalina.jar:8.5.41]
    at org.apache.catalina.ha.session.JvmRouteBinderValve.invoke(JvmRouteBinderValve.java:182) [catalina-ha.jar:8.5.41]
    at org.apache.catalina.ha.tcp.ReplicationValve.invoke(ReplicationValve.java:322) [catalina-ha.jar:8.5.41]
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) [catalina.jar:8.5.41]
    at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:660) [catalina.jar:8.5.41]
    at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:679) [catalina.jar:8.5.41]
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) [catalina.jar:8.5.41]
    at org.apache.catalina.valves.CrawlerSessionManagerValve.invoke(CrawlerSessionManagerValve.java:235) [catalina.jar:8.5.41]
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [catalina.jar:8.5.41]
    at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:798) [tomcat-coyote.jar:8.5.41]
    at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) [tomcat-coyote.jar:8.5.41]
    at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:808) [tomcat-coyote.jar:8.5.41]
    at org.apache.tomcat.util.net.Nio2Endpoint$SocketProcessor.doRun(Nio2Endpoint.java:1773) [tomcat-coyote.jar:8.5.41]
    at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote.jar:8.5.41]
    at org.apache.tomcat.util.net.AbstractEndpoint.processSocket(AbstractEndpoint.java:1069) [tomcat-coyote.jar:8.5.41]
    at org.apache.tomcat.util.net.Nio2Endpoint$Nio2SocketWrapper$2.completed(Nio2Endpoint.java:567) [tomcat-coyote.jar:8.5.41]
    at org.apache.tomcat.util.net.Nio2Endpoint$Nio2SocketWrapper$2.completed(Nio2Endpoint.java:545) [tomcat-coyote.jar:8.5.41]
    at org.apache.tomcat.util.net.SecureNio2Channel$1.completed(SecureNio2Channel.java:968) [tomcat-coyote.jar:8.5.41]
    at org.apache.tomcat.util.net.SecureNio2Channel$1.completed(SecureNio2Channel.java:897) [tomcat-coyote.jar:8.5.41]
    at sun.nio.ch.Invoker.invokeUnchecked(Invoker.java:126) [?:1.8.0_292]
    at sun.nio.ch.Invoker$2.run(Invoker.java:218) [?:1.8.0_292]
    at sun.nio.ch.AsynchronousChannelGroupImpl$1.run(AsynchronousChannelGroupImpl.java:112) [?:1.8.0_292]
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_292]
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_292]
    at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util.jar:8.5.41]
    at java.lang.Thread.run(Thread.java:748) [?:1.8.0_292]
any clue on what could be happening here? For now I haven't been able to really reproduce it.
Tags: None
Isomorphic

Administrator

Join Date: May 2006

Posts: 54650
#2

8 Jun 2022, 05:44

This most likely happens when your app ends up using the same DataSource instance in multiple concurrent threads, so they are messing up the internals of the DataSource instance eventually leading to the error above. We think this is what happened, assuming both threads are using the same DataSource instance:
- First thread starts performing add operation by executing the insert and storing some temporary internal data
- Second thread performs fetch operation and cleans up the internal data when it is done
- First thread attempts to perform cache sync, but the internal data it is relying on is missing

DataSource is not designed to be used like that as is described here. Can you please check how your application ends up obtaining the DataSources involved? Considering Spring is present in the stack trace, please pay attention to the Spring-injected dataSources part of the same doc.
Comment
Previous template Next
Announcement

getLastPrimaryKeys() called before valid insert/replace/update operation has been performed

Comment
