platform
platform copied to clipboard
hcengineering
Some account related exception
{"_class":"contact:mixin:Employee","err":{"code":"22023","file":"type_check.go","line":"2374","message":"unsupported comparison operator: _id = ANY $2::JSONB: op ANY <right> requires array, tuple or subquery on right side","name":"PostgresError","routine":"typeCheckComparisonOpWithSubOperator","severity":"ERROR","severity_local":"ERROR","stack":"PostgresError: unsupported comparison operator: _id = ANY $2::JSONB: op ANY <right> requires array, tuple or subquery on right side\n at ErrorResponse (/usr/src/app/bundle.js:102255:31)\n at handle (/usr/src/app/bundle.js:102012:11)\n at TLSSocket.data (/usr/src/app/bundle.js:101825:13)\n at TLSSocket.emit (node:events:518:28)\n at addChunk (node:internal/streams/readable:561:12)\n at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)\n at Readable.push (node:internal/streams/readable:392:5)\n at TLSWrap.onStreamRead (node:internal/stream_base_commons:189:23)\n at TLSWrap.callbackTrampoline (node:internal/async_hooks:130:17)"},"level":"error","message":"Error in findAll","query":{"_id":{"$in":[null]},"active":true},"sql":"SELECT contact.* FROM contact WHERE contact.\"workspaceId\" = $1::uuid AND contact.\"_id\" = ANY($2::jsonb) AND contact.data#>>'{contact:mixin:Employee,active}' = $3::text AND (contact.data->>'contact:mixin:Employee')::text IS NOT NULL AND contact.\"_class\" = $4::text","sqlFull":"SELECT contact.* FROM contact WHERE contact.\"workspaceId\" = 'bb793ec1-252e-4419-8998-7f220ababdfa'::uuid AND contact.\"_id\" = ANY(ARRAY[]::jsonb) AND contact.data#>>'{contact:mixin:Employee,active}' = 'true'::text AND (contact.data->>'contact:mixin:Employee')::text IS NOT NULL AND contact.\"_class\" = 'contact:class:Person'::text","timestamp":"2025-04-15T09:04:13.612Z"}
{"err":{"code":"22023","file":"type_check.go","line":"2374","message":"unsupported comparison operator: _id = ANY $2::JSONB: op ANY <right> requires array, tuple or subquery on right side","name":"PostgresError","routine":"typeCheckComparisonOpWithSubOperator","severity":"ERROR","severity_local":"ERROR","stack":"PostgresError: unsupported comparison operator: _id = ANY $2::JSONB: op ANY <right> requires array, tuple or subquery on right side\n at ErrorResponse (/usr/src/app/bundle.js:102255:31)\n at handle (/usr/src/app/bundle.js:102012:11)\n at TLSSocket.data (/usr/src/app/bundle.js:101825:13)\n at TLSSocket.emit (node:events:518:28)\n at addChunk (node:internal/streams/readable:561:12)\n at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)\n at Readable.push (node:internal/streams/readable:392:5)\n at TLSWrap.onStreamRead (node:internal/stream_base_commons:189:23)\n at TLSWrap.callbackTrampoline (node:internal/async_hooks:130:17)"},"level":"error","message":"failed to process trigger","timestamp":"2025-04-15T09:04:13.613Z","trigger":"server-activity:trigger:ActivityMessagesHandler"}
{
message: 'failed to process sql',
error: 'unsupported comparison operator: _id = ANY $2::JSONB: op ANY <right> requires array, tuple or subquery on right side',
cause: PostgresError: unsupported comparison operator: _id = ANY $2::JSONB: op ANY <right> requires array, tuple or subquery on right side
at ErrorResponse (/usr/src/app/bundle.js:102255:31)
at handle (/usr/src/app/bundle.js:102012:11)
at TLSSocket.data (/usr/src/app/bundle.js:101825:13)
at TLSSocket.emit (node:events:518:28)
at addChunk (node:internal/streams/readable:561:12)
at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
at Readable.push (node:internal/streams/readable:392:5)
at TLSWrap.onStreamRead (node:internal/stream_base_commons:189:23)
at TLSWrap.callbackTrampoline (node:internal/async_hooks:130:17) {
severity_local: 'ERROR',
severity: 'ERROR',
code: '22023',
file: 'type_check.go',
line: '2374',
routine: 'typeCheckComparisonOpWithSubOperator'
}
}
{"_class":"contact:mixin:Employee","err":{"code":"22023","file":"type_check.go","line":"2374","message":"unsupported comparison operator: _id = ANY $2::JSONB: op ANY <right> requires array, tuple or subquery on right side","name":"PostgresError","routine":"typeCheckComparisonOpWithSubOperator","severity":"ERROR","severity_local":"ERROR","stack":"PostgresError: unsupported comparison operator: _id = ANY $2::JSONB: op ANY <right> requires array, tuple or subquery on right side\n at ErrorResponse (/usr/src/app/bundle.js:102255:31)\n at handle (/usr/src/app/bundle.js:102012:11)\n at TLSSocket.data (/usr/src/app/bundle.js:101825:13)\n at TLSSocket.emit (node:events:518:28)\n at addChunk (node:internal/streams/readable:561:12)\n at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)\n at Readable.push (node:internal/streams/readable:392:5)\n at TLSWrap.onStreamRead (node:internal/stream_base_commons:189:23)\n at TLSWrap.callbackTrampoline (node:internal/async_hooks:130:17)"},"level":"error","message":"Error in findAll","query":{"_id":{"$in":[null]},"active":true},"sql":"SELECT contact.* FROM contact WHERE contact.\"workspaceId\" = $1::uuid AND (contact.\"_id\" = ANY($2::jsonb) OR contact.\"_id\" IS NULL) AND contact.data#>>'{contact:mixin:Employee,active}' = $3::text AND (contact.data->>'contact:mixin:Employee')::text IS NOT NULL AND contact.\"_class\" = $4::text","sqlFull":"SELECT contact.* FROM contact WHERE contact.\"workspaceId\" = 'bb793ec1-252e-4419-8998-7f220ababdfa'::uuid AND (contact.\"_id\" = ANY(ARRAY[]::jsonb) OR contact.\"_id\" IS NULL) AND contact.data#>>'{contact:mixin:Employee,active}' = 'true'::text AND (contact.data->>'contact:mixin:Employee')::text IS NOT NULL AND contact.\"_class\" = 'contact:class:Person'::text","timestamp":"2025-04-15T09:04:14.414Z"}
{"err":{"code":"22023","file":"type_check.go","line":"2374","message":"unsupported comparison operator: _id = ANY $2::JSONB: op ANY <right> requires array, tuple or subquery on right side","name":"PostgresError","routine":"typeCheckComparisonOpWithSubOperator","severity":"ERROR","severity_local":"ERROR","stack":"PostgresError: unsupported comparison operator: _id = ANY $2::JSONB: op ANY <right> requires array, tuple or subquery on right side\n at ErrorResponse (/usr/src/app/bundle.js:102255:31)\n at handle (/usr/src/app/bundle.js:102012:11)\n at TLSSocket.data (/usr/src/app/bundle.js:101825:13)\n at TLSSocket.emit (node:events:518:28)\n at addChunk (node:internal/streams/readable:561:12)\n at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)\n at Readable.push (node:internal/streams/readable:392:5)\n at TLSWrap.onStreamRead (node:internal/stream_base_commons:189:23)\n at TLSWrap.callbackTrampoline (node:internal/async_hooks:130:17)"},"level":"error","message":"failed to process trigger","timestamp":"2025-04-15T09:04:14.416Z","trigger":"server-activity:trigger:ActivityMessagesHandler"}
Another similar one:
{
_class: "contact:class:Person",
err: {
code: "22023",
file: "type_check.go",
line: "2407",
message: "unsupported comparison operator: <varchar> = ANY <jsonb[]>",
name: "PostgresError",
routine: "subOpCompError",
severity: "ERROR",
severity_local: "ERROR",
stack:
"PostgresError: unsupported comparison operator: <varchar> = ANY <jsonb[]>\n at ErrorResponse (/usr/src/app/bundle.js:102291:31)\n at handle (/usr/src/app/bundle.js:102048:11)\n at TLSSocket.data (/usr/src/app/bundle.js:101861:13)\n at TLSSocket.emit (node:events:518:28)\n at addChunk (node:internal/streams/readable:561:12)\n at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)\n at Readable.push (node:internal/streams/readable:392:5)\n at TLSWrap.onStreamRead (node:internal/stream_base_commons:189:23)\n at TLSWrap.callbackTrampoline (node:internal/async_hooks:130:17)",
},
level: "error",
message: "Error in findAll",
query: { _id: { $in: [null, null, null] } },
sql: 'SELECT contact.* FROM contact INNER JOIN space AS sec ON sec._id = contact.space AND sec."workspaceId" = $1::uuid AND (sec.members @> \'{"cd4a651f-1e2d-4bdc-b4ac-442fcc547f4e"}\' OR sec."_class" = \'core:class:SystemSpace\') AND sec.archived = false WHERE contact."workspaceId" = $1::uuid AND (contact."_id" = ANY($2::jsonb[]) OR contact."_id" IS NULL) AND contact."_class" = $3::text',
sqlFull:
'SELECT contact.* FROM contact INNER JOIN space AS sec ON sec._id = contact.space AND sec."workspaceId" = \'bb793ec1-252e-4419-8998-7f220ababdfa\'::uuid AND (sec.members @> \'{"cd4a651f-1e2d-4bdc-b4ac-442fcc547f4e"}\' OR sec."_class" = \'core:class:SystemSpace\') AND sec.archived = false WHERE contact."workspaceId" = \'bb793ec1-252e-4419-8998-7f220ababdfa\'::uuid AND (contact."_id" = ANY(ARRAY[]::jsonb[]) OR contact."_id" IS NULL) AND contact."_class" = \'contact:class:Person\'::text',
timestamp: "2025-04-25T06:36:34.140Z",
}
![huly-github-staging[bot] avatar](https://avatars.githubusercontent.com/in/811546?v=4 "Published by a pub.dev verified publisher"){kind=small}
"_class": "contact:mixin:Employee", "query": { "_id": { "$in": [null, null, null, null] }, "active": true },
{
"attr": {
"_class": "core:class:Attribute",
"_id": "github:class:GithubPullRequest_reviewers",
"attributeOf": "github:class:GithubPullRequest",
"createdBy": "core:account:System",
"createdOn": 1746507792250,
"label": "embedded:embedded:Reviewers",
"modifiedBy": "core:account:System",
"modifiedOn": 1746507792250,
"name": "reviewers",
"space": "core:space:Model",
"type": {
"_class": "core:class:ArrOf",
"icon": "core:icon:TypeArray",
"label": "core:string:Array",
"of": {
"_class": "core:class:RefTo",
"icon": "core:icon:TypeRef",
"label": "core:string:Ref",
"to": "contact:class:Person"
}
}
},
"level": "error",
"message": "Null-values array of person refs when getting value collaborators",
"timestamp": "2025-05-06T15:11:53.958Z",
"value": [null]
}