Skip to content

Error 5502 (42602) on initializing with StarRocks #1035

@Ferroman

Description

@Ferroman

goose_db_version creation — goose wraps it in a transaction; StarRocks rejects DDL in transactions resulting in error:

✗ goose -dir migrations/starrocks starrocks "root:password@tcp(starrocks-mysql.domain.co:9030)/analytics?interpolateParams=true" up
2026/02/23 12:08:58 goose run: Error 5502 (42602): Getting analyzing error. Detail message: Unknown table 'analytics.goose_db_version'.; Error 5305 (25P01): Getting analyzing error. Detail message: Explicit transaction only support begin/commit/rollback/insert/update/delete/set/select statements.

Used version:

goose --version
goose version: v3.27.0

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions