L3 - Default Environment (Required on creation):
- Camunda Spring Boot Starter 7.17.0-alpha6-ee
- CockroachDB 20.1.3
Description (Required on creation; please attach any relevant screenshots, stacktraces, log files, etc. to the ticket):
- In the Admin Webapps (System -> Diagnostics) the following is shown:
"database": { "vendor": "PostgreSQL", "version": "9.5.0" },
Steps to reproduce (Required on creation):
- Start Camunda Platform 7 (EE) with CockroachDB 20.1.3 as the database.
- Navigate to http://localhost:8080/camunda/app/admin/default/#/system?section=diagnostics-system-settings
Observed Behavior (Required on creation):
The used database is reported as PostgreSQL 9.5.
Expected behavior (Required on creation):
The used database should be reported as CockroachDB 20.1.3.
Root Cause (Required on prioritization):
CockroachDB 20.1.3 implements the PostgreSQL 9.5 wire-protocol, and uses the PostgreSQL JDBC driver. As a result, the JDBC connection meta-data provides PostgreSQL 9.5information. The problem lies in this code.
Solution Ideas (Optional):
We need to apply a workaround similar to this code.
This is the controller panel for Smart Panels app
[CAM-14514] Telemetry data reports CockroachDB as PostgreSQL 9.5
| Description |
Original:
h3. Environment (Required on creation):
* Camunda Spring Boot Starter 7.17.0-alpha6-ee * CockroachDB 20.1.3 h3. Description (Required on creation; please attach any relevant screenshots, stacktraces, log files, etc. to the ticket): * In the Admin Webapps (System -> Diagnostics) the following is shown: {code} "database": { "vendor": "PostgreSQL", "version": "9.5.0" }, {code} h3. Steps to reproduce (Required on creation): # Start Camunda Platform 7 (EE) with CockroachDB 20.1.3 as the database. # Navigate to http://localhost:8080/camunda/app/admin/default/#/system?section=diagnostics-system-settings h3. Observed Behavior (Required on creation): The used database is reported as PostgreSQL 9.5. h3. Expected behavior (Required on creation): The used database should be reported as CockroachDB 20.1.3. h3. Root Cause (Required on prioritization): CockroachDB implements the PostgreSQL wire-protocol, and uses the PostgreSQL JDBC driver. As a result, the JDBC connection meta-data provides PostgreSQL information. The problem lies in this [code|https://github.com/camunda/camunda-bpm-platform/blob/30c986ce27f871a330614ffef772dcf1b7936abd/engine/src/main/java/org/camunda/bpm/engine/impl/cfg/ProcessEngineConfigurationImpl.java#L1696-L1697]. h3. Solution Ideas (Optional): We need to apply a workaround similar to [this code|https://github.com/camunda/camunda-bpm-platform/blob/9550370014138b69bdab43ba89ecffed5c0c80c4/engine/src/main/java/org/camunda/bpm/engine/impl/cfg/ProcessEngineConfigurationImpl.java#L1678-L1693]. |
New:
h3. Environment (Required on creation):
* Camunda Spring Boot Starter 7.17.0-alpha6-ee * CockroachDB 20.1.3 h3. Description (Required on creation; please attach any relevant screenshots, stacktraces, log files, etc. to the ticket): * In the Admin Webapps (System -> Diagnostics) the following is shown: {code} "database": { "vendor": "PostgreSQL", "version": "9.5.0" }, {code} h3. Steps to reproduce (Required on creation): # Start Camunda Platform 7 (EE) with CockroachDB 20.1.3 as the database. # Navigate to http://localhost:8080/camunda/app/admin/default/#/system?section=diagnostics-system-settings h3. Observed Behavior (Required on creation): The used database is reported as PostgreSQL 9.5. h3. Expected behavior (Required on creation): The used database should be reported as CockroachDB 20.1.3. h3. Root Cause (Required on prioritization): CockroachDB 20.1.3 [implements the PostgreSQL 9.5 wire-protocol|https://www.cockroachlabs.com/docs/v20.1/postgresql-compatibility], and uses the PostgreSQL JDBC driver. As a result, the JDBC connection meta-data provides PostgreSQL 9.5information. The problem lies in this [code|https://github.com/camunda/camunda-bpm-platform/blob/30c986ce27f871a330614ffef772dcf1b7936abd/engine/src/main/java/org/camunda/bpm/engine/impl/cfg/ProcessEngineConfigurationImpl.java#L1696-L1697]. h3. Solution Ideas (Optional): We need to apply a workaround similar to [this code|https://github.com/camunda/camunda-bpm-platform/blob/9550370014138b69bdab43ba89ecffed5c0c80c4/engine/src/main/java/org/camunda/bpm/engine/impl/cfg/ProcessEngineConfigurationImpl.java#L1678-L1693]. |
| Assignee | New: Thorben Lindhauer [ thorben.lindhauer ] |
| Status | Original: Open [ 1 ] | New: Ready [ 10005 ] |
This ticket was migrated to github: https://github.com/camunda/camunda-bpm-platform/issues/2657. Please use this link for any future references and continue any discussion there.