Uploaded image for project: 'SonarQube'
  1. SonarQube
  2. SONAR-4586

SonarQube purge on MSSQL can fail with the following error : "Prepared or callable statement has more than 2000 parameter markers"

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.7
    • Fix Version/s: 3.7.1
    • Component/s: Database
    • Labels:

      Description

      This seems to be a side effect of SONAR-4368
      Error stack trace :

      20:04:49 20:04:49.311 INFO  - <- Clean snapshot 1756118
      20:04:49 20:04:49.457 ERROR - Fail to purge data [id=109208]
      20:04:49 org.apache.ibatis.exceptions.PersistenceException: 
      20:04:49 ### Error updating database.  Cause: java.sql.SQLException: Prepared or callable statement has more than 2000 parameter markers.
      20:04:49 ### SQL: delete from dependencies where from_snapshot_id in      (           ?      ,          ?      ,          ?      ,          ?      ,          ?      ,          ?      ,          ?      ,          ?      ,          ?      ,          ?      ,          ?      ,          ?      ,          ?      ,          ?           ,          ?      ,          ?      ,          ?      ,          ?      ,          ?      ,          ?      ,          ?      ,          ?      
      ...
      20:04:49 ### Cause: java.sql.SQLException: Prepared or callable statement has more than 2000 parameter markers.
      20:04:49       at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23) ~[mybatis-3.1.1.jar:3.1.1]
      20:04:49       at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:147) ~[mybatis-3.1.1.jar:3.1.1]
      20:04:49       at org.apache.ibatis.session.defaults.DefaultSqlSession.delete(DefaultSqlSession.java:158) ~[mybatis-3.1.1.jar:3.1.1]
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              julien.lancelot Julien Lancelot
              Reporter:
              freddy.mallet Freddy Mallet (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: