Comments (2)
This looks like it could be similar to #121828
from cockroach.
Repro:
CREATE SCHEMA schema_w1_22;
CREATE TYPE schema_w1_22.enum_w1_23 AS ENUM ('s', 't');
begin;
ALTER TYPE schema_w1_22.enum_w1_23 DROP VALUE 's';
DROP SCHEMA "schema_w1_22" CASCADE;
commit;
ERROR: transaction committed but schema change aborted with error: (42704): type with ID 109 does not exist
SQLSTATE: XXA00
HINT: Some of the non-DDL statements may have committed successfully, but some of the DDL statement(s) failed.
Manual inspection may be required to determine the actual state of the database.
--
See: https://go.crdb.dev/issue-v/42061/v24.1
This is happening since the ALTER TYPE is executed after DROP SCHEMA. Since this is in a transaction, the legacy schema changer is used for both. DROP SCHEMA doesn't run in a job, but ALTER TYPE does, and the job only runs on commit. By that point, the type no longer exists.
from cockroach.
Related Issues (20)
- sql: support print_strict_params option in PL/pgSQL
- sql: calling EXECUTE in PL/pgSQL should return more helpful error HOT 1
- ccl/streamingccl/streamingest: TestProtectedTimestampManagement failed
- cli: redact stacktrace information in debug.zip
- admission: integrate snapshot ingest with CPU limiter HOT 1
- cockroach-go-testserver-23_1_test: TestLogic_mixed_version_udf_mutations failed [inability to maintain liveness during initial cluster startup] HOT 3
- roachtest: unoptimized-query-oracle/disable-rules=half/rand-tables failed
- opt: improve query plans conjunctive filters operating on inverted indexes
- roachtest: tpcc/mixed-headroom/n5cpu16 failed HOT 1
- roachtest: schemachange/random-load failed HOT 1
- sqlstats: exec stats are always sampled when writing to sql stats is throttled
- bench/rttanalysis: TestBenchmarkExpectation failed
- sql, sqlstats: execution statistics count for explicit transactions are inflated
- sql-queries: 24.2 release checklist
- changefeedccl: improve test coverage of initial scans HOT 2
- pkg/sql/logictest/tests/cockroach-go-testserver-23.2/cockroach-go-testserver-23_2_test: TestLogic_upgrade_system_table_changes failed HOT 2
- ccl/changefeedccl: TestAlterChangefeedAddTargetsDuringBackfill failed HOT 1
- pg_catalog: fix up `pg_catalog.pg_am` table
- pg_catalog: fix up `pg_catalog.pg_attribute`
- cdc: TestChangefeedProgressMetrics failed HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from cockroach.