search

yugabyte / yugabyte-db

YugabyteDB - the cloud native distributed SQL database for mission-critical applications.
https://www.yugabyte.com
Other
8.87k stars 1.05k forks source link

[YSQL] SHARE UPDATE EXCLUSIVE not supported yet #8012

Open timothyvanderaerden opened 3 years ago

timothyvanderaerden commented 3 years ago

Jira Link: DB-2577 It seems that the following query: LOCK TABLE \"schema_migrations\" IN SHARE UPDATE EXCLUSIVE MODE is not supported. It is used by Ecto (since version 3.6.0) for database migrations.

Full error message:

code: :feature_not_supported,
file: "gram.y",
hint: "Please report the issue on https://github.com/YugaByte/yugabyte-db/issues",
line: "17395",
message: "SHARE UPDATE EXCLUSIVE not supported yet",
pg_code: "0A000",
position: "35",
routine: "raise_feature_not_supported_signal",
severity: "ERROR", unknown: "ERROR"},
query: "LOCK TABLE \"schema_migrations\" IN SHARE UPDATE EXCLUSIVE MODE"
fire commented 1 year ago

I am affected by this. https://github.com/elixir-ecto/ecto_sql/issues/527

almirsarajcic commented 1 week ago

Me too.

Thanks to @fire, I was able to run migrations with the :pg_advisory_lock migration lock strategy.