org.springframework.jdbc.UncategorizedSQLException: CallableStatementCallback; uncategorized SQLException for SQL [{? = call get_next_oai_id(?)}]; SQL state [HY000]; error code [1436]; Thread stack overrun: 8548 bytes used of a 131072 byte stack, and 128000 bytes needed. Use 'mysqld -O thread_stack=#' to specify a bigger stack.; nested exception is java.sql.SQLException: Thread stack overrun: 8548 bytes used of a 131072 byte stack, and 128000 bytes needed. Use 'mysqld -O thread_stack=#' to specify a bigger stack.

GitHub | patrickzurek | 3 months ago
  1. 0

    GitHub comment 571#253589301

    GitHub | 3 months ago | patrickzurek
    org.springframework.jdbc.UncategorizedSQLException: CallableStatementCallback; uncategorized SQLException for SQL [{? = call get_next_oai_id(?)}]; SQL state [HY000]; error code [1436]; Thread stack overrun: 8548 bytes used of a 131072 byte stack, and 128000 bytes needed. Use 'mysqld -O thread_stack=#' to specify a bigger stack.; nested exception is java.sql.SQLException: Thread stack overrun: 8548 bytes used of a 131072 byte stack, and 128000 bytes needed. Use 'mysqld -O thread_stack=#' to specify a bigger stack.
  2. 0

    Re: [OpenOLAT] Re: problem with statistics

    Google Groups | 1 year ago | Florian Gn├Ągi
    org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [ update o_stat_hourofday as old, (select businesspath,hour(creationdate) hour, count(*) cnt from o_stat_temptable group by businesspath,hour) as delta SET old.value=old.value+delta.cnt where old.hour=delta.hour and old.businesspath=delta.businesspath; ]; SQL state [HY000]; error code [1267]; Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='; nested exception is java.sql.SQLException: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' ^%^ >>>stack of 1.cause::org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [ update o_stat_hourofday as old, (select businesspath,hour(creationdate) hour, count(*) cnt from o_stat_temptable group by businesspath,hour) as delta SET old.value=old.value+delta.cnt where old.hour=delta.hour and old.businesspath=delta.businesspath;

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. org.springframework.jdbc.UncategorizedSQLException

      CallableStatementCallback; uncategorized SQLException for SQL [{? = call get_next_oai_id(?)}]; SQL state [HY000]; error code [1436]; Thread stack overrun: 8548 bytes used of a 131072 byte stack, and 128000 bytes needed. Use 'mysqld -O thread_stack=#' to specify a bigger stack.; nested exception is java.sql.SQLException: Thread stack overrun: 8548 bytes used of a 131072 byte stack, and 128000 bytes needed. Use 'mysqld -O thread_stack=#' to specify a bigger stack.

      at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate()
    2. Spring Framework
      SimpleJdbcCall.executeObject
      1. org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
      2. org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
      3. org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
      4. org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:969)
      5. org.springframework.jdbc.core.JdbcTemplate.call(JdbcTemplate.java:1003)
      6. org.springframework.jdbc.core.simple.AbstractJdbcCall.executeCallInternal(AbstractJdbcCall.java:389)
      7. org.springframework.jdbc.core.simple.AbstractJdbcCall.doExecute(AbstractJdbcCall.java:363)
      8. org.springframework.jdbc.core.simple.SimpleJdbcCall.executeObject(SimpleJdbcCall.java:159)
      8 frames
    3. xc.mst.repo
      RepositoryDAO.injectId
      1. xc.mst.repo.RepositoryDAO.getNextIdAndIncr(RepositoryDAO.java:224)
      2. xc.mst.repo.RepositoryDAO.injectId(RepositoryDAO.java:217)
      2 frames