DuplicateKeyException for spring_session_attributes_pk in spring-session-jdbc about spring-session HOT 8 CLOSED

@marcusdacoregio providing a minimal example might take w while. As written, we have two projects having identical configuration (at least to our knowlege) one showing this bug, one working fine. I'm not completely sure what might cause this; probably some parallel requests from frontend confuse the session creation (in the debug output there's three requests to the saml login when simply opening the page one time in the browser).

For the moment, using the trigger preventing a second insert works; but I'll try the customizer, which seems a cleaner solution.

Anyways, I'll get back to this case as soon possible to try providing an example.

from spring-session.

@romainlouvet have you tried the SessionRepositoryCustomizer as mentioned?

from spring-session.

Yes, the query itself would depend on the RDBMS and your business needs, see https://docs.spring.io/spring-session/reference/3.2-SNAPSHOT/configuration/jdbc.html#customize-sql-queries

from spring-session.

Hi, @jankoh. Can you provide a minimal, reproducible sample that demonstrates the issue? Note that you can expose the PostgreSqlJdbcIndexedSessionRepositoryCustomizer as a bean and that would customize the createSessionAttributeQuery to update if there is a conflict on the insert.

from spring-session.

If you would like us to look at this issue, please provide the requested information. If the information is not provided within the next 7 days this issue will be closed.

from spring-session.

Closing due to lack of requested feedback. If you would like us to look at this issue, please provide the requested information and we will re-open the issue.

from spring-session.

same problem for me @jankoh, Quite regularly we get a 500 with this error ... :/

did you manage to get around the problem ?

thanks

from spring-session.

@marcusdacoregio like this ?

import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.session.config.SessionRepositoryCustomizer;
import org.springframework.session.jdbc.JdbcIndexedSessionRepository;
import org.springframework.session.jdbc.config.annotation.web.http.EnableJdbcHttpSession;
import org.springframework.session.jdbc.config.annotation.web.http.JdbcHttpSessionConfiguration;

@Configuration
@EnableJdbcHttpSession
public class HttpSessionConfig extends JdbcHttpSessionConfiguration {

  @Bean
  public PostgreSqlJdbcHttpSessionCustomizer jdbcHttpSessionCustomizer() {
    return new PostgreSqlJdbcHttpSessionCustomizer();
  }

  public class PostgreSqlJdbcHttpSessionCustomizer
      implements SessionRepositoryCustomizer<JdbcIndexedSessionRepository> {

    private static final String CREATE_SESSION_ATTRIBUTE_QUERY = """
        INSERT INTO %TABLE_NAME%_ATTRIBUTES (SESSION_PRIMARY_ID, ATTRIBUTE_NAME, ATTRIBUTE_BYTES)
        VALUES (?, ?, ?)
        ON CONFLICT (SESSION_PRIMARY_ID, ATTRIBUTE_NAME)
        DO UPDATE SET ATTRIBUTE_BYTES = EXCLUDED.ATTRIBUTE_BYTES
        """;

    @Override
    public void customize(JdbcIndexedSessionRepository sessionRepository) {
      sessionRepository.setCreateSessionAttributeQuery(CREATE_SESSION_ATTRIBUTE_QUERY);
    }

  }
}

from spring-session.