Error: Value too long for column

mje · March 4, 2026, 1:33pm

Operating system: Ubuntu 24.04.4 LTS
SonarQube for IntelliJ plugin version: 11.14.0.84231
IntelliJ version: IntelliJ IDEA 2025.3.3
Programming language you’re coding in: Java
Is connected mode used: Yes
- SonarQube Cloud, SonarQube Server, or SonarQube Community Build? (if one of the latter two, which version?): SonarQube Server (Enterprise Edition
  v2025.1.1 (104738))

And a thorough description of the problem / question:

When I start IntelliJ and immediately open up the SonarQube plugin logs I see this:

Starting the SonarQube for IDE service process...
Listing SonarQube for IDE service files:
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/JavaEWAH-1.2.3.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/protobuf-java-4.28.2.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/xodus-environment-2.0.1.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/gson-2.10.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/sonarlint-telemetry-10.46.0.84435.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/logback-classic-1.5.25.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/commons-codec-1.17.2.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/commons-text-1.13.1.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/jakarta.annotation-api-3.0.0.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/git-files-blame-2.0.1.17.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/sonar-plugin-api-13.4.2.4284.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/listenablefuture-9999.0-empty-to-avoid-conflict-with-guava.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/failureaccess-1.0.2.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/sonarlint-rule-extractor-10.46.0.84435.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/jakarta.inject-api-2.0.1.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/sonarlint-plugin-api-10.46.0.84435.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/sentry-8.20.0.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/jooq-3.19.15.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/ayza-10.0.0.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/xodus-compress-2.0.1.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/checker-qual-3.43.0.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/sonar-scanner-protocol-9.9.0.65466.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/reactive-streams-1.0.3.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/sonarlint-server-api-10.46.0.84435.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/org.eclipse.jgit-7.2.1.202505142326-r.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/spring-jcl-6.2.12.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/flyway-core-11.14.0.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/commons-io-2.18.0.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/jackson-databind-2.19.1.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/micrometer-commons-1.14.12.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/xodus-openAPI-2.0.1.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/slf4j-api-2.0.17.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/jackson-annotations-2.19.1.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/spring-context-6.2.12.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/sonarlint-commons-10.46.0.84435.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/httpclient5-5.4.4.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/xodus-vfs-2.0.1.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/sonarlint-rpc-protocol-10.46.0.84435.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/sonarlint-plugin-commons-10.46.0.84435.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/spring-beans-6.2.12.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/jsr305-3.0.2.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/xodus-entity-store-2.0.1.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/error_prone_annotations-2.36.0.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/spring-core-6.2.12.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/sonarlint-core-10.46.0.84435.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/commons-csv-1.13.0.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/jackson-core-2.19.1.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/sonar-channel-4.2.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/spring-aop-6.2.12.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/sonarlint-backend-cli-10.46.0.84435.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/kotlin-stdlib-common-1.9.21.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/org.eclipse.lsp4j.jsonrpc-0.22.0.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/httpcore5-5.3.2.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/sonar-classloader-1.2.1.2095.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/guava-33.4.0-jre.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/commons-compress-1.27.1.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/javax.annotation-api-1.3.2.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/h2-2.4.240.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/sonarlint-http-10.46.0.84435.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/j2objc-annotations-3.0.0.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/xodus-utils-2.0.1.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/sonarlint-rpc-impl-10.46.0.84435.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/r2dbc-spi-1.0.0.RELEASE.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/logback-core-1.5.25.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/kotlin-logging-1.7.9.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/kotlin-stdlib-1.9.21.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/spring-expression-6.2.12.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/annotations-13.0.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/picocli-4.7.6.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/httpcore5-h2-5.3.4.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/jul-to-slf4j-2.0.17.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/sonarlint-server-connection-10.46.0.84435.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/micrometer-observation-1.14.12.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/commons-lang3-3.18.0.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/sonar-markdown-25.3.0.104237.jar
/home/marc/.local/share/JetBrains/IntelliJIdea2025.3/sonarlint-intellij/sloop/lib/sonarlint-analysis-engine-10.46.0.84435.jar
 [2026-03-04T16:08:52.918821974] [ApplicationImpl pooled thread 2] INFO org.sonarsource.sonarlint.core.rpc.client.SloopLauncher - Using JRE from /home/marc/.local/share/JetBrains/Toolbox/apps/intellij-idea-ultimate/jbr
Migrating the storage...
Listening for SonarQube for IDE service exit...
Initializing the SonarQube for IDE service...
 [2026-03-04T16:08:55.128] [SonarLint Server RPC sequential executor] INFO sonarlint - Initializing Sentry
 [2026-03-04T16:08:56.216] [SonarLint Server RPC sequential executor] INFO org.flywaydb.core.FlywayExecutor - Database: jdbc:h2:/home/marc/.cache/JetBrains/IntelliJIdea2025.3/sonarlint/storage/h2/sq-ide (H2 2.4)
 [2026-03-04T16:08:56.227] [SonarLint Server RPC sequential executor] WARN org.flywaydb.core.internal.database.base.Database - Using H2 2.4.240 which is newer than the version Flyway has been verified with. The latest verified version of H2 is 2.3.232.
 [2026-03-04T16:08:56.3] [SonarLint Server RPC sequential executor] INFO org.flywaydb.core.internal.command.DbValidate - Successfully validated 5 migrations (execution time 00:00.036s)
 [2026-03-04T16:08:56.309] [SonarLint Server RPC sequential executor] INFO org.flywaydb.core.internal.command.DbMigrate - Current version of schema "PUBLIC": 5
 [2026-03-04T16:08:56.312] [SonarLint Server RPC sequential executor] INFO org.flywaydb.core.internal.command.DbMigrate - Schema "PUBLIC" is up to date. No migration necessary.
 [2026-03-04T16:08:56.798] [SonarLint Server RPC sequential executor] INFO org.jooq.impl.DefaultExecuteContext.logVersionSupport - Version                  : Database version is supported by dialect H2: 2.4.240 (2025-09-22)
 [2026-03-04T16:08:57.961] [SonarLint Server RPC sequential executor] INFO sonarlint - Started embedded server on port 64120
SonarQube for IDE service initialized...
 [2026-03-04T16:09:06.609] [SonarLint Local Storage Synchronizer] INFO sonarlint - Downloaded settings in 126ms
 [2026-03-04T16:09:06.782] [SonarLint Local Storage Synchronizer] INFO sonarlint - Downloaded plugin list in 76ms
 [2026-03-04T16:09:06.832] [SonarLint Local Storage Synchronizer] INFO sonarlint - [SYNC] Synchronizing analyzer configuration for project 'someproject_e3975191-5f32-406c-1467-a6e71c1514b1'
 [2026-03-04T16:09:06.832] [SonarLint Local Storage Synchronizer] INFO sonarlint - [SYNC] Languages enabled for synchronization: [kubernetes, css, scala, kotlin, js, py, secrets, plsql, ruby, docker, ansible, java, web, xml, php, terraform, text, cloudformation, swift, ts, yaml, githubactions]
 [2026-03-04T16:09:06.918] [SonarLint Local Storage Synchronizer] INFO sonarlint - Downloaded settings in 76ms
 [2026-03-04T16:09:07.009] [SonarLint Local Storage Synchronizer] INFO sonarlint - [SYNC] Active rules for 'ansible' are up-to-date
 [2026-03-04T16:09:07.009] [SonarLint Local Storage Synchronizer] INFO sonarlint - [SYNC] Active rules for 'cloudformation' are up-to-date
 [2026-03-04T16:09:07.009] [SonarLint Local Storage Synchronizer] INFO sonarlint - [SYNC] Active rules for 'css' are up-to-date
 [2026-03-04T16:09:07.009] [SonarLint Local Storage Synchronizer] INFO sonarlint - [SYNC] Active rules for 'docker' are up-to-date
 [2026-03-04T16:09:07.009] [SonarLint Local Storage Synchronizer] INFO sonarlint - [SYNC] Active rules for 'java' are up-to-date
 [2026-03-04T16:09:07.009] [SonarLint Local Storage Synchronizer] INFO sonarlint - [SYNC] Active rules for 'js' are up-to-date
 [2026-03-04T16:09:07.009] [SonarLint Local Storage Synchronizer] INFO sonarlint - [SYNC] Active rules for 'kotlin' are up-to-date
 [2026-03-04T16:09:07.009] [SonarLint Local Storage Synchronizer] INFO sonarlint - [SYNC] Active rules for 'kubernetes' are up-to-date
 [2026-03-04T16:09:07.009] [SonarLint Local Storage Synchronizer] INFO sonarlint - [SYNC] Active rules for 'php' are up-to-date
 [2026-03-04T16:09:07.009] [SonarLint Local Storage Synchronizer] INFO sonarlint - [SYNC] Active rules for 'plsql' are up-to-date
 [2026-03-04T16:09:07.009] [SonarLint Local Storage Synchronizer] INFO sonarlint - [SYNC] Active rules for 'py' are up-to-date
 [2026-03-04T16:09:07.009] [SonarLint Local Storage Synchronizer] INFO sonarlint - [SYNC] Active rules for 'ruby' are up-to-date
 [2026-03-04T16:09:07.009] [SonarLint Local Storage Synchronizer] INFO sonarlint - [SYNC] Active rules for 'scala' are up-to-date
 [2026-03-04T16:09:07.009] [SonarLint Local Storage Synchronizer] INFO sonarlint - [SYNC] Active rules for 'secrets' are up-to-date
 [2026-03-04T16:09:07.009] [SonarLint Local Storage Synchronizer] INFO sonarlint - [SYNC] Active rules for 'swift' are up-to-date
 [2026-03-04T16:09:07.009] [SonarLint Local Storage Synchronizer] INFO sonarlint - [SYNC] Active rules for 'terraform' are up-to-date
 [2026-03-04T16:09:07.009] [SonarLint Local Storage Synchronizer] INFO sonarlint - [SYNC] Active rules for 'text' are up-to-date
 [2026-03-04T16:09:07.009] [SonarLint Local Storage Synchronizer] INFO sonarlint - [SYNC] Active rules for 'ts' are up-to-date
 [2026-03-04T16:09:07.009] [SonarLint Local Storage Synchronizer] INFO sonarlint - [SYNC] Active rules for 'web' are up-to-date
 [2026-03-04T16:09:07.009] [SonarLint Local Storage Synchronizer] INFO sonarlint - [SYNC] Active rules for 'xml' are up-to-date
 [2026-03-04T16:09:07.009] [SonarLint Local Storage Synchronizer] INFO sonarlint - [SYNC] Active rules for 'yaml' are up-to-date
 [2026-03-04T16:09:07.491] [SonarLint Local Storage Synchronizer] INFO sonarlint - Synchronizing project branches for project 'someproject_e3975191-5f32-406c-1467-a6e71c1514b1'
 [2026-03-04T16:09:07.947] [SonarLint Local Storage Synchronizer] INFO sonarlint - [SYNC] Synchronizing issues for project 'someproject_e3975191-5f32-406c-1467-a6e71c1514b1' on branch 'master'
 [2026-03-04T16:09:08.294] [SonarLint Local Storage Synchronizer] INFO sonarlint - [SYNC] Synchronizing taint issues for project 'someproject_e3975191-5f32-406c-1467-a6e71c1514b1' on branch 'master'
 [2026-03-04T16:09:20.429] [SonarLint Local Storage Synchronizer] ERROR sonarlint - Error during synchronization
org.jooq.exception.DataException: SQL [merge into "PUBLIC"."SERVER_FINDINGS" using (select cast(? as uuid) "ID", cast(? as varchar(255)) "CONNECTION_ID", cast(? as varchar(255)) "SONAR_PROJECT_KEY", cast(? as varchar(255)) "SERVER_KEY", cast(? as varchar(255)) "RULE_KEY", cast(? as varchar(10000)) "MESSAGE", cast(? as varchar(1000000000)) "FILE_PATH", cast(? as timestamp(6)) "CREATION_DATE", cast(? as varchar(255)) "USER_SEVERITY", cast(? as varchar(255)) "RULE_TYPE", cast(? as varchar(255)) "RULE_DESCRIPTION_CONTEXT_KEY", cast(? as varchar(255)) "CLEAN_CODE_ATTRIBUTE", cast(? as varchar(255)) "FINDING_TYPE", cast(? as varchar(255)) "BRANCH_NAME", cast(? format json as json) "IMPACTS", cast(? format json as json) "FLOWS", cast(? as boolean) "RESOLVED", cast(? as int) "START_LINE", cast(? as int) "START_LINE_OFFSET", cast(? as int) "END_LINE", cast(? as int) "END_LINE_OFFSET", cast(? as varchar(255)) "TEXT_RANGE_HASH") "t" on "PUBLIC"."SERVER_FINDINGS"."SERVER_KEY" = "t"."SERVER_KEY" when matched then update set "PUBLIC"."SERVER_FINDINGS"."ID" = "t"."ID", "PUBLIC"."SERVER_FINDINGS"."CONNECTION_ID" = "t"."CONNECTION_ID", "PUBLIC"."SERVER_FINDINGS"."SONAR_PROJECT_KEY" = "t"."SONAR_PROJECT_KEY", "PUBLIC"."SERVER_FINDINGS"."SERVER_KEY" = "t"."SERVER_KEY", "PUBLIC"."SERVER_FINDINGS"."RULE_KEY" = "t"."RULE_KEY", "PUBLIC"."SERVER_FINDINGS"."MESSAGE" = "t"."MESSAGE", "PUBLIC"."SERVER_FINDINGS"."FILE_PATH" = "t"."FILE_PATH", "PUBLIC"."SERVER_FINDINGS"."CREATION_DATE" = "t"."CREATION_DATE", "PUBLIC"."SERVER_FINDINGS"."USER_SEVERITY" = "t"."USER_SEVERITY", "PUBLIC"."SERVER_FINDINGS"."RULE_TYPE" = "t"."RULE_TYPE", "PUBLIC"."SERVER_FINDINGS"."RULE_DESCRIPTION_CONTEXT_KEY" = "t"."RULE_DESCRIPTION_CONTEXT_KEY", "PUBLIC"."SERVER_FINDINGS"."CLEAN_CODE_ATTRIBUTE" = "t"."CLEAN_CODE_ATTRIBUTE", "PUBLIC"."SERVER_FINDINGS"."FINDING_TYPE" = "t"."FINDING_TYPE", "PUBLIC"."SERVER_FINDINGS"."BRANCH_NAME" = "t"."BRANCH_NAME", "PUBLIC"."SERVER_FINDINGS"."IMPACTS" = "t"."IMPACTS", "PUBLIC"."SERVER_FINDINGS"."FLOWS" = "t"."FLOWS", "PUBLIC"."SERVER_FINDINGS"."RESOLVED" = "t"."RESOLVED", "PUBLIC"."SERVER_FINDINGS"."START_LINE" = "t"."START_LINE", "PUBLIC"."SERVER_FINDINGS"."START_LINE_OFFSET" = "t"."START_LINE_OFFSET", "PUBLIC"."SERVER_FINDINGS"."END_LINE" = "t"."END_LINE", "PUBLIC"."SERVER_FINDINGS"."END_LINE_OFFSET" = "t"."END_LINE_OFFSET", "PUBLIC"."SERVER_FINDINGS"."TEXT_RANGE_HASH" = "t"."TEXT_RANGE_HASH" when not matched then insert ("ID", "CONNECTION_ID", "SONAR_PROJECT_KEY", "SERVER_KEY", "RULE_KEY", "MESSAGE", "FILE_PATH", "CREATION_DATE", "USER_SEVERITY", "RULE_TYPE", "RULE_DESCRIPTION_CONTEXT_KEY", "CLEAN_CODE_ATTRIBUTE", "FINDING_TYPE", "BRANCH_NAME", "IMPACTS", "FLOWS", "RESOLVED", "START_LINE", "START_LINE_OFFSET", "END_LINE", "END_LINE_OFFSET", "TEXT_RANGE_HASH") values ("t"."ID", "t"."CONNECTION_ID", "t"."SONAR_PROJECT_KEY", "t"."SERVER_KEY", "t"."RULE_KEY", "t"."MESSAGE", "t"."FILE_PATH", "t"."CREATION_DATE", "t"."USER_SEVERITY", "t"."RULE_TYPE", "t"."RULE_DESCRIPTION_CONTEXT_KEY", "t"."CLEAN_CODE_ATTRIBUTE", "t"."FINDING_TYPE", "t"."BRANCH_NAME", "t"."IMPACTS", "t"."FLOWS", "t"."RESOLVED", "t"."START_LINE", "t"."START_LINE_OFFSET", "t"."END_LINE", "t"."END_LINE_OFFSET", "t"."TEXT_RANGE_HASH")]; Value too long for column "FLOWS JSON(10000000)": "JSON '[{""locations"":[{""filePath"":""commons/src/main/java/ch/someproject/upp/transac... (1000000000)"; SQL statement:
merge into "PUBLIC"."SERVER_FINDINGS" using (select cast(? as uuid) "ID", cast(? as varchar(255)) "CONNECTION_ID", cast(? as varchar(255)) "SONAR_PROJECT_KEY", cast(? as varchar(255)) "SERVER_KEY", cast(? as varchar(255)) "RULE_KEY", cast(? as varchar(10000)) "MESSAGE", cast(? as varchar(1000000000)) "FILE_PATH", cast(? as timestamp(6)) "CREATION_DATE", cast(? as varchar(255)) "USER_SEVERITY", cast(? as varchar(255)) "RULE_TYPE", cast(? as varchar(255)) "RULE_DESCRIPTION_CONTEXT_KEY", cast(? as varchar(255)) "CLEAN_CODE_ATTRIBUTE", cast(? as varchar(255)) "FINDING_TYPE", cast(? as varchar(255)) "BRANCH_NAME", cast(? format json as json) "IMPACTS", cast(? format json as json) "FLOWS", cast(? as boolean) "RESOLVED", cast(? as int) "START_LINE", cast(? as int) "START_LINE_OFFSET", cast(? as int) "END_LINE", cast(? as int) "END_LINE_OFFSET", cast(? as varchar(255)) "TEXT_RANGE_HASH") "t" on "PUBLIC"."SERVER_FINDINGS"."SERVER_KEY" = "t"."SERVER_KEY" when matched then update set "PUBLIC"."SERVER_FINDINGS"."ID" = "t"."ID", "PUBLIC"."SERVER_FINDINGS"."CONNECTION_ID" = "t"."CONNECTION_ID", "PUBLIC"."SERVER_FINDINGS"."SONAR_PROJECT_KEY" = "t"."SONAR_PROJECT_KEY", "PUBLIC"."SERVER_FINDINGS"."SERVER_KEY" = "t"."SERVER_KEY", "PUBLIC"."SERVER_FINDINGS"."RULE_KEY" = "t"."RULE_KEY", "PUBLIC"."SERVER_FINDINGS"."MESSAGE" = "t"."MESSAGE", "PUBLIC"."SERVER_FINDINGS"."FILE_PATH" = "t"."FILE_PATH", "PUBLIC"."SERVER_FINDINGS"."CREATION_DATE" = "t"."CREATION_DATE", "PUBLIC"."SERVER_FINDINGS"."USER_SEVERITY" = "t"."USER_SEVERITY", "PUBLIC"."SERVER_FINDINGS"."RULE_TYPE" = "t"."RULE_TYPE", "PUBLIC"."SERVER_FINDINGS"."RULE_DESCRIPTION_CONTEXT_KEY" = "t"."RULE_DESCRIPTION_CONTEXT_KEY", "PUBLIC"."SERVER_FINDINGS"."CLEAN_CODE_ATTRIBUTE" = "t"."CLEAN_CODE_ATTRIBUTE", "PUBLIC"."SERVER_FINDINGS"."FINDING_TYPE" = "t"."FINDING_TYPE", "PUBLIC"."SERVER_FINDINGS"."BRANCH_NAME" = "t"."BRANCH_NAME", "PUBLIC"."SERVER_FINDINGS"."IMPACTS" = "t"."IMPACTS", "PUBLIC"."SERVER_FINDINGS"."FLOWS" = "t"."FLOWS", "PUBLIC"."SERVER_FINDINGS"."RESOLVED" = "t"."RESOLVED", "PUBLIC"."SERVER_FINDINGS"."START_LINE" = "t"."START_LINE", "PUBLIC"."SERVER_FINDINGS"."START_LINE_OFFSET" = "t"."START_LINE_OFFSET", "PUBLIC"."SERVER_FINDINGS"."END_LINE" = "t"."END_LINE", "PUBLIC"."SERVER_FINDINGS"."END_LINE_OFFSET" = "t"."END_LINE_OFFSET", "PUBLIC"."SERVER_FINDINGS"."TEXT_RANGE_HASH" = "t"."TEXT_RANGE_HASH" when not matched then insert ("ID", "CONNECTION_ID", "SONAR_PROJECT_KEY", "SERVER_KEY", "RULE_KEY", "MESSAGE", "FILE_PATH", "CREATION_DATE", "USER_SEVERITY", "RULE_TYPE", "RULE_DESCRIPTION_CONTEXT_KEY", "CLEAN_CODE_ATTRIBUTE", "FINDING_TYPE", "BRANCH_NAME", "IMPACTS", "FLOWS", "RESOLVED", "START_LINE", "START_LINE_OFFSET", "END_LINE", "END_LINE_OFFSET", "TEXT_RANGE_HASH") values ("t"."ID", "t"."CONNECTION_ID", "t"."SONAR_PROJECT_KEY", "t"."SERVER_KEY", "t"."RULE_KEY", "t"."MESSAGE", "t"."FILE_PATH", "t"."CREATION_DATE", "t"."USER_SEVERITY", "t"."RULE_TYPE", "t"."RULE_DESCRIPTION_CONTEXT_KEY", "t"."CLEAN_CODE_ATTRIBUTE", "t"."FINDING_TYPE", "t"."BRANCH_NAME", "t"."IMPACTS", "t"."FLOWS", "t"."RESOLVED", "t"."START_LINE", "t"."START_LINE_OFFSET", "t"."END_LINE", "t"."END_LINE_OFFSET", "t"."TEXT_RANGE_HASH") [22001-240]
	at org.jooq_3.19.15.H2.debug(Unknown Source)
	at org.jooq.impl.Tools.translate(Tools.java:3637)
	at org.jooq.impl.Tools.translate(Tools.java:3629)
	at org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:827)
	at org.jooq.impl.BatchSingle.executePrepared(BatchSingle.java:272)
	at org.jooq.impl.BatchSingle.execute(BatchSingle.java:184)
	at org.jooq.impl.BatchCRUD.lambda$executePrepared$3(BatchCRUD.java:167)
	at java.base/java.util.LinkedHashMap.forEach(LinkedHashMap.java:986)
	at org.jooq.impl.BatchCRUD.executePrepared(BatchCRUD.java:161)
	at org.jooq.impl.BatchCRUD.execute(BatchCRUD.java:102)
	at org.sonarsource.sonarlint.core.serverconnection.storage.ServerFindingRepository.batchMergeTaints(ServerFindingRepository.java:583)
	at org.sonarsource.sonarlint.core.serverconnection.storage.ServerFindingRepository.lambda$mergeTaintIssues$5(ServerFindingRepository.java:187)
	at org.jooq.impl.DefaultDSLContext.lambda$transaction$5(DefaultDSLContext.java:592)
	at org.jooq.impl.DefaultDSLContext.lambda$transactionResult0$3(DefaultDSLContext.java:530)
	at org.jooq.impl.Tools$3$1.block(Tools.java:6370)
	at java.base/java.util.concurrent.ForkJoinPool.unmanagedBlock(ForkJoinPool.java:4013)
	at java.base/java.util.concurrent.ForkJoinPool.managedBlock(ForkJoinPool.java:3961)
	at org.jooq.impl.Tools$3.get(Tools.java:6367)
	at org.jooq.impl.DefaultDSLContext.transactionResult0(DefaultDSLContext.java:578)
	at org.jooq.impl.DefaultDSLContext.transactionResult(DefaultDSLContext.java:502)
	at org.jooq.impl.DefaultDSLContext.transaction(DefaultDSLContext.java:591)
	at org.sonarsource.sonarlint.core.serverconnection.storage.ServerFindingRepository.mergeTaintIssues(ServerFindingRepository.java:177)
	at org.sonarsource.sonarlint.core.serverconnection.ServerIssueUpdater.syncTaints(ServerIssueUpdater.java:81)
	at org.sonarsource.sonarlint.core.sync.TaintSynchronizationService.updateServerTaintIssuesForProject(TaintSynchronizationService.java:93)
	at org.sonarsource.sonarlint.core.sync.TaintSynchronizationService.synchronizeTaintVulnerabilities(TaintSynchronizationService.java:76)
	at org.sonarsource.sonarlint.core.sync.SynchronizationService.lambda$synchronizeProjectWithProgress$5(SynchronizationService.java:214)
	at java.base/java.util.Optional.ifPresent(Optional.java:178)
	at org.sonarsource.sonarlint.core.sync.SynchronizationService.lambda$synchronizeProjectWithProgress$6(SynchronizationService.java:208)
	at java.base/java.util.HashMap.forEach(HashMap.java:1429)
	at org.sonarsource.sonarlint.core.sync.SynchronizationService.synchronizeProjectWithProgress(SynchronizationService.java:208)
	at org.sonarsource.sonarlint.core.sync.SynchronizationService.lambda$synchronizeProjectsOfTheSameConnection$3(SynchronizationService.java:196)
	at org.sonarsource.sonarlint.core.connection.SonarQubeClient.withClientApi(SonarQubeClient.java:76)
	at org.sonarsource.sonarlint.core.SonarQubeClientManager.lambda$withActiveClient$1(SonarQubeClientManager.java:80)
	at java.base/java.util.Optional.ifPresent(Optional.java:178)
	at org.sonarsource.sonarlint.core.SonarQubeClientManager.withActiveClient(SonarQubeClientManager.java:80)
	at org.sonarsource.sonarlint.core.sync.SynchronizationService.synchronizeProjectsOfTheSameConnection(SynchronizationService.java:192)
	at org.sonarsource.sonarlint.core.sync.SynchronizationService.lambda$synchronizeProjectsSync$2(SynchronizationService.java:177)
	at org.sonarsource.sonarlint.core.commons.progress.TaskManager.runExistingTask(TaskManager.java:47)
	at org.sonarsource.sonarlint.core.commons.progress.TaskManager.createAndRunTask(TaskManager.java:35)
	at org.sonarsource.sonarlint.core.sync.SynchronizationService.synchronizeProjectsSync(SynchronizationService.java:169)
	at org.sonarsource.sonarlint.core.sync.SynchronizationService.synchronizeConnectionAndProjectsIfNeededSync(SynchronizationService.java:352)
	at org.sonarsource.sonarlint.core.sync.SynchronizationService.lambda$synchronizeConnectionAndProjectsIfNeededAsync$11(SynchronizationService.java:309)
	at org.sonarsource.sonarlint.core.connection.SonarQubeClient.withClientApi(SonarQubeClient.java:76)
	at org.sonarsource.sonarlint.core.SonarQubeClientManager.lambda$withActiveClient$1(SonarQubeClientManager.java:80)
	at java.base/java.util.Optional.ifPresent(Optional.java:178)
	at org.sonarsource.sonarlint.core.SonarQubeClientManager.withActiveClient(SonarQubeClientManager.java:80)
	at org.sonarsource.sonarlint.core.sync.SynchronizationService.lambda$synchronizeConnectionAndProjectsIfNeededAsync$12(SynchronizationService.java:309)
	at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:572)
	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:317)
	at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:304)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
	at java.base/java.lang.Thread.run(Thread.java:1583)
Caused by: org.h2.jdbc.JdbcBatchUpdateException: Value too long for column "FLOWS JSON(10000000)": "JSON '[{""locations"":[{""filePath"":""commons/src/main/java/ch/someproject/upp/transac... (1000000000)"; SQL statement:
merge into "PUBLIC"."SERVER_FINDINGS" using (select cast(? as uuid) "ID", cast(? as varchar(255)) "CONNECTION_ID", cast(? as varchar(255)) "SONAR_PROJECT_KEY", cast(? as varchar(255)) "SERVER_KEY", cast(? as varchar(255)) "RULE_KEY", cast(? as varchar(10000)) "MESSAGE", cast(? as varchar(1000000000)) "FILE_PATH", cast(? as timestamp(6)) "CREATION_DATE", cast(? as varchar(255)) "USER_SEVERITY", cast(? as varchar(255)) "RULE_TYPE", cast(? as varchar(255)) "RULE_DESCRIPTION_CONTEXT_KEY", cast(? as varchar(255)) "CLEAN_CODE_ATTRIBUTE", cast(? as varchar(255)) "FINDING_TYPE", cast(? as varchar(255)) "BRANCH_NAME", cast(? format json as json) "IMPACTS", cast(? format json as json) "FLOWS", cast(? as boolean) "RESOLVED", cast(? as int) "START_LINE", cast(? as int) "START_LINE_OFFSET", cast(? as int) "END_LINE", cast(? as int) "END_LINE_OFFSET", cast(? as varchar(255)) "TEXT_RANGE_HASH") "t" on "PUBLIC"."SERVER_FINDINGS"."SERVER_KEY" = "t"."SERVER_KEY" when matched then update set "PUBLIC"."SERVER_FINDINGS"."ID" = "t"."ID", "PUBLIC"."SERVER_FINDINGS"."CONNECTION_ID" = "t"."CONNECTION_ID", "PUBLIC"."SERVER_FINDINGS"."SONAR_PROJECT_KEY" = "t"."SONAR_PROJECT_KEY", "PUBLIC"."SERVER_FINDINGS"."SERVER_KEY" = "t"."SERVER_KEY", "PUBLIC"."SERVER_FINDINGS"."RULE_KEY" = "t"."RULE_KEY", "PUBLIC"."SERVER_FINDINGS"."MESSAGE" = "t"."MESSAGE", "PUBLIC"."SERVER_FINDINGS"."FILE_PATH" = "t"."FILE_PATH", "PUBLIC"."SERVER_FINDINGS"."CREATION_DATE" = "t"."CREATION_DATE", "PUBLIC"."SERVER_FINDINGS"."USER_SEVERITY" = "t"."USER_SEVERITY", "PUBLIC"."SERVER_FINDINGS"."RULE_TYPE" = "t"."RULE_TYPE", "PUBLIC"."SERVER_FINDINGS"."RULE_DESCRIPTION_CONTEXT_KEY" = "t"."RULE_DESCRIPTION_CONTEXT_KEY", "PUBLIC"."SERVER_FINDINGS"."CLEAN_CODE_ATTRIBUTE" = "t"."CLEAN_CODE_ATTRIBUTE", "PUBLIC"."SERVER_FINDINGS"."FINDING_TYPE" = "t"."FINDING_TYPE", "PUBLIC"."SERVER_FINDINGS"."BRANCH_NAME" = "t"."BRANCH_NAME", "PUBLIC"."SERVER_FINDINGS"."IMPACTS" = "t"."IMPACTS", "PUBLIC"."SERVER_FINDINGS"."FLOWS" = "t"."FLOWS", "PUBLIC"."SERVER_FINDINGS"."RESOLVED" = "t"."RESOLVED", "PUBLIC"."SERVER_FINDINGS"."START_LINE" = "t"."START_LINE", "PUBLIC"."SERVER_FINDINGS"."START_LINE_OFFSET" = "t"."START_LINE_OFFSET", "PUBLIC"."SERVER_FINDINGS"."END_LINE" = "t"."END_LINE", "PUBLIC"."SERVER_FINDINGS"."END_LINE_OFFSET" = "t"."END_LINE_OFFSET", "PUBLIC"."SERVER_FINDINGS"."TEXT_RANGE_HASH" = "t"."TEXT_RANGE_HASH" when not matched then insert ("ID", "CONNECTION_ID", "SONAR_PROJECT_KEY", "SERVER_KEY", "RULE_KEY", "MESSAGE", "FILE_PATH", "CREATION_DATE", "USER_SEVERITY", "RULE_TYPE", "RULE_DESCRIPTION_CONTEXT_KEY", "CLEAN_CODE_ATTRIBUTE", "FINDING_TYPE", "BRANCH_NAME", "IMPACTS", "FLOWS", "RESOLVED", "START_LINE", "START_LINE_OFFSET", "END_LINE", "END_LINE_OFFSET", "TEXT_RANGE_HASH") values ("t"."ID", "t"."CONNECTION_ID", "t"."SONAR_PROJECT_KEY", "t"."SERVER_KEY", "t"."RULE_KEY", "t"."MESSAGE", "t"."FILE_PATH", "t"."CREATION_DATE", "t"."USER_SEVERITY", "t"."RULE_TYPE", "t"."RULE_DESCRIPTION_CONTEXT_KEY", "t"."CLEAN_CODE_ATTRIBUTE", "t"."FINDING_TYPE", "t"."BRANCH_NAME", "t"."IMPACTS", "t"."FLOWS", "t"."RESOLVED", "t"."START_LINE", "t"."START_LINE_OFFSET", "t"."END_LINE", "t"."END_LINE_OFFSET", "t"."TEXT_RANGE_HASH") [22001-240]
	at org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1277)
	at org.jooq.tools.jdbc.DefaultStatement.executeBatch(DefaultStatement.java:122)
	at org.jooq.impl.BatchSingle.lambda$executePrepared$3(BatchSingle.java:251)
	at org.jooq.impl.Tools.lambda$checkedFunction$73(Tools.java:2492)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197)
	at java.base/java.util.Spliterators$ArraySpliterator.forEachRemaining(Spliterators.java:1024)
	at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:509)
	at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:499)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:575)
	at java.base/java.util.stream.AbstractPipeline.evaluateToArrayNode(AbstractPipeline.java:260)
	at java.base/java.util.stream.IntPipeline.toArray(IntPipeline.java:562)
	at org.jooq.impl.BatchSingle.executePrepared(BatchSingle.java:258)
	... 48 more

Any idea what could cause this?

mje · March 4, 2026, 1:44pm

Is it possible that the project has so many errors/warnings that the syncing does not work? Maybe it’s too much to handle for the local h2 db. Hence the “Value too long for column” error.

ganncamp · March 4, 2026, 2:07pm

Hi,

Welcome to the community and thanks for this report!

It looks like you’ve redacted parts of the log to focus on the error. Could we have the whole thing, please?

Thx,
Ann

mje · March 4, 2026, 3:11pm

I updated now my original post with the full strack traces.

mje · March 4, 2026, 3:18pm

This is what AI tells me when I give it the entire error:

H2 rejects the MERGE because SERVER_FINDINGS.FLOWS is defined as JSON(10000000) (~10 MB), and at least one incoming FLOWS JSON document is larger.
Most likely causes in this stack: SonarLint taint sync stores a very large flow graph, and the local embedded H2 schema is too small.

ganncamp · March 4, 2026, 4:43pm

Hi,

Wait, what? You’re using H2 in production? That’s not supported, not updatable (you’ll lose your data when you want to move past 2025.1.1), and not a good idea.

Ann

nicolas.quinquenel · March 4, 2026, 5:42pm

Hey, sorry for the confusion @ganncamp, we do use H2 in SonarQube for IDE to manage part of our local storage, for several reasons.

I think @mje is correct about the AI’s investigation, we try to insert a taint vulnerability that is way larger than what we can store currently.

Moreover, there are 2 issues:

The way we handle such problems - we should not suddenly crash
Why is there such a large taint vulnerability - does it even make sense to report such a large flow?

We will further investigate and hopefully fix the problem, thank you

mje · March 5, 2026, 7:51am

Thank you. Please let me know if you have more questions.

nicolas.quinquenel · March 8, 2026, 5:21pm

We would like to investigate why such a large taint vulnerability was raised. Based on the logs or the files from your project, would you be able to identify which taint vulnerability this error corresponds to?

It would be very helpful if we could determine the rule key associated with this taint vulnerability, and possibly the type of flows involved, so that we can review it on our side.

mje · March 10, 2026, 8:57am

And how would I debug this best? Locally there is IMO not enough information from the IntelliJ plugin. I am trying something like this now:

curl -u token: “https://sonar.company.com/api/issues/search?componentKeys=some_project&types=VULNERABILITY&s=FILE_LINE&ps=500”
| jq ‘[.issues[] | {key, component, message, flowCount: (.flows | length)}] | sort_by(-.flowCount) | .[0:3]’

This fetches one page and sorts client-side by flow count, showing the top 3. The output:

[
{
“key”: “0e42ca8c-e810-4ef0-a62c-092825c96a20”,
“component”: “foobar_project:some_file_1.java”,
“message”: “Change this code to not log user-controlled data.”,
“flowCount”: 103
},
{
“key”: “99a8a066-3d26-4fad-b41d-8ac70ca9eae5”,
“component”: “foobar_project:some_file_2.java”,
“message”: “Change this code to not log user-controlled data.”,
“flowCount”: 68
},
{
“key”: “e87658b2-5c93-4c02-926c-27b5b0c65e9b”,
“component”: “foobar_project:some_file_3.java”,
“message”: “Change this code to not construct SQL queries directly from user-controlled data.”,
“flowCount”: 9
}
]

Is this a good approach? What else could I do?

nicolas.quinquenel · March 10, 2026, 12:35pm

Thank you, I think this is exactly the data we were looking for!

Topic		Replies	Views
SonarLint for Eclipse (v:4.0.0.2018.10170711) fails to bind to local SonarQube Eclipse eclipse , sonarqube-ide	18	9232	January 29, 2019
Error updating database. Cause: org.postgresql.util.PSQLException during background tasks SonarQube Server / Community Build java , sonarqube , maven	5	2633	September 6, 2018
SonarLint 10.5: File system cache errors cause crash IntelliJ Platform	24	642	November 22, 2024
How come that a tool / framework bothering me with clean code issues is itself so buggy? SonarQube Server / Community Build sonarqube	51	542	July 14, 2025
Error in SonarLint for IntelliJ: ResponseErrorException: Internal error IntelliJ Platform intellij , me-too , sonarqube-ide	37	4369	May 29, 2024

Error: Value too long for column

Related topics