Turso Schema Database migration with drizzle-orm/libsql/migrator
hi all, having this issue with migrations using drizzle for turso schema databases (--type schema), is this somehow affected by turso running these migrations as transactions internally, and drizzle trying to run the migrations in transactions too, causing "the migration is already run within a transaction" error?
6 | rawCode;
7 | constructor(message, code, rawCode, cause) {
8 | if (code !== undefined) {
9 | message =
10 | }
11 | super(message, { cause });
^
LibsqlError: SCHEMA_MIGRATION_ERROR: Schema migration error: migration is invalid: it contains transaction items (BEGIN, COMMIT, SAVEPOINT...) which are not allowed. The migration is already run within a transaction
code: "SCHEMA_MIGRATION_ERROR"
at new LibsqlError (/node_modules/@libsql/core/lib-esm/api.js:11:9)
at mapHranaError (/node_modules/@libsql/client/lib-esm/hrana.js:257:16)
at /node_modules/@libsql/client/lib-esm/http.js:85:19
1 | / Generic error produced by the Hrana client. */
2 | export class ClientError extends Error {
3 | / @private */
4 | constructor(message) {
^
ResponseError: Schema migration error: migration is invalid: it contains transaction items (BEGIN, COMMIT, SAVEPOINT...) which are not allowed. The migration is already run within a transaction
code: "SCHEMA_MIGRATION_ERROR"
at /node_modules/@libsql/hrana-client/lib-esm/errors.js:4:11
6 | rawCode;
7 | constructor(message, code, rawCode, cause) {
8 | if (code !== undefined) {
9 | message =
${code}: ${message}10 | }
11 | super(message, { cause });
^
LibsqlError: SCHEMA_MIGRATION_ERROR: Schema migration error: migration is invalid: it contains transaction items (BEGIN, COMMIT, SAVEPOINT...) which are not allowed. The migration is already run within a transaction
code: "SCHEMA_MIGRATION_ERROR"
at new LibsqlError (/node_modules/@libsql/core/lib-esm/api.js:11:9)
at mapHranaError (/node_modules/@libsql/client/lib-esm/hrana.js:257:16)
at /node_modules/@libsql/client/lib-esm/http.js:85:19
1 | / Generic error produced by the Hrana client. */
2 | export class ClientError extends Error {
3 | / @private */
4 | constructor(message) {
^
ResponseError: Schema migration error: migration is invalid: it contains transaction items (BEGIN, COMMIT, SAVEPOINT...) which are not allowed. The migration is already run within a transaction
code: "SCHEMA_MIGRATION_ERROR"
at /node_modules/@libsql/hrana-client/lib-esm/errors.js:4:11
The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!
11,959Members
Resources
Similar Threads
Was this page helpful?
