failed to get scan from db. id=xxx: failed to query DB: ERROR: cannot extract elements from a scalar (SQLSTATE 22023)

[akpsgit]

Description

After deploying the CFN stack from the main branch (commit 1652f7e), getting a UI error and the following errors in VMClarity logs upon scan drill down in the UI:

Jun 12 07:12:27 ip-10-0-0-11 docker[5115]: {"time":"2023-06-12T07:12:27.596313084Z","id":"","remote_ip":"172.18.0.1","host":"10.0.0.11:8888","method":"GET","uri":"/api/scans/048da54d-620f-4a07-9265-6d062912e0cd?%24expand=scanConfig","user_agent":"Go-http-client/1.1","status":500,"error":"","latency":656940,"latency_human":"656.94µs","bytes_in":0,"bytes_out":165}
Jun 12 07:12:27 ip-10-0-0-11 docker[5115]: time="2023-06-12T07:12:27Z" level=error msg="failed to get scan from db. id=048da54d-620f-4a07-9265-6d062912e0cd: failed to query DB: ERROR: cannot extract elements from a scalar (SQLSTATE 22023)"
Jun 12 07:12:27 ip-10-0-0-11 docker[5115]: time="2023-06-12T07:12:27Z" level=error msg="Failed to reconcile item: failed to fetch Scan. ScanID=048da54d-620f-4a07-9265-6d062912e0cd: failed to get a scan status. status code=500: failed to get scan from db. id=048da54d-620f-4a07-9265-6d062912e0cd: failed to query DB: ERROR: cannot extract elements from a scalar (SQLSTATE 22023)" controller=ScanWatcher
Jun 12 07:12:27 ip-10-0-0-11 docker[4634]: 2023-06-12 07:12:27.596 GMT [168] ERROR:  cannot extract elements from a scalar

Affected Version

(commit 1652f7e)

Steps to Reproduce

1. Install CFN from main (commit 1652f7e)
2. Create a scan configuration
3. Click on the scan once it's created from the config.

[github-actions]

Thank you for your contribution! This issue has been automatically marked as stale because it has no recent activity in the last 60 days. It will be closed in 14 days, if no further activity occurs. If this issue is still relevant, please leave a comment to let us know, and the stale label will be automatically removed.

[Tehsmash]

This was an issue with Postgres and we fixed this with PR #440