{"record":{"id":"8eb09730b415db08","repo":"Budibase/budibase","slug":"unable-to-search-by-sql-msg","errorCode":null,"errorMessage":"Unable to search by SQL - ${msg}","messagePattern":"Unable to search by SQL - (.+?)","errorType":"exception","errorClass":"Error","httpStatus":null,"severity":"error","filePath":"packages/server/src/sdk/workspace/rows/search/internal/sqs.ts","lineNumber":583,"sourceCode":"    if (msg?.includes(\"ECONNREFUSED\")) {\n      throw new HTTPError(\"Search is temporarily unavailable\", 503)\n    }\n    if (!opts?.retrying && resyncDefinitionsRequired(err.status, msg)) {\n      await locks.doWithLock(\n        {\n          type: LockType.AUTO_EXTEND,\n          name: LockName.SQS_SYNC_DEFINITIONS,\n          resource: context.getWorkspaceId(),\n        },\n        sdk.tables.sqs.syncDefinition\n      )\n      return search(options, source, { retrying: true })\n    }\n    // previously the internal table didn't error when a column didn't exist in search\n    if (err.status === 400 && msg?.match(MISSING_COLUMN_REGEX)) {\n      return { rows: [] }\n    }\n    throw new Error(`Unable to search by SQL - ${msg}`, { cause: err })\n  }\n}\n","sourceCodeStart":565,"sourceCodeEnd":586,"githubUrl":"https://github.com/Budibase/budibase/blob/a81a902e9a8fe55b467d106765f6638f12e35c49/packages/server/src/sdk/workspace/rows/search/internal/sqs.ts#L565-L586","documentation":"Error \"Unable to search by SQL - ${msg}\" thrown in Budibase/budibase.","triggerScenarios":"Thrown at packages/server/src/sdk/workspace/rows/search/internal/sqs.ts:583 when the library encounters an invalid state.","commonSituations":"See trigger scenarios.","solutions":[],"exampleFix":null,"handlingStrategy":null,"validationCode":null,"typeGuard":null,"tryCatchPattern":null,"preventionTips":[],"tags":[],"backgroundTag":null,"analyzedSha":"a81a902e9a8fe55b467d106765f6638f12e35c49","analyzedAt":"2026-08-29T01:03:10.972Z","schemaVersion":2},"datasetVersion":"2026-08-29T02:17:18.158Z"}