Budibase/budibase · error · Error

Unable to search by SQL - ${msg}

Error message

Unable to search by SQL - ${msg}

What it means

Error "Unable to search by SQL - ${msg}" thrown in Budibase/budibase.

Source

Thrown at packages/server/src/sdk/workspace/rows/search/internal/sqs.ts:583

    if (msg?.includes("ECONNREFUSED")) {
      throw new HTTPError("Search is temporarily unavailable", 503)
    }
    if (!opts?.retrying && resyncDefinitionsRequired(err.status, msg)) {
      await locks.doWithLock(
        {
          type: LockType.AUTO_EXTEND,
          name: LockName.SQS_SYNC_DEFINITIONS,
          resource: context.getWorkspaceId(),
        },
        sdk.tables.sqs.syncDefinition
      )
      return search(options, source, { retrying: true })
    }
    // previously the internal table didn't error when a column didn't exist in search
    if (err.status === 400 && msg?.match(MISSING_COLUMN_REGEX)) {
      return { rows: [] }
    }
    throw new Error(`Unable to search by SQL - ${msg}`, { cause: err })
  }
}

View on GitHub (pinned to a81a902e9a)

When it happens

Trigger: Thrown at packages/server/src/sdk/workspace/rows/search/internal/sqs.ts:583 when the library encounters an invalid state.

Common situations: See trigger scenarios.

AI-assisted analysis of Budibase/budibase@a81a902e9a (2026-08-29). Data as JSON: /api/errors/8eb09730b415db08. Report an issue: GitHub.