Upstream request timeout on very simple ALTER TABLE statement
🤷other
Solved🟢SQL
Solved🟢SQLI'm trying to use Python alembic migrations or even the SQL Editor to run a simple SQL query that create three columns over a table that has only 28 rows but it keeps running into timeouts after near 1 minute. The statement:
ALTER TABLE users ADD COLUMN browser VARCHAR;
ALTER TABLE users ADD COLUMN browser_version VARCHAR;
ALTER TABLE users ADD COLUMN last_login_at TIMESTAMP WITH TIME ZONE DEFAULT now() NOT NULL;
I have a dev database with the same configurations, only with fewer rows, and it runs the same query seamlessly. I'm suspecting that upgrading PostgreSQL version should fix it. It's v15.8.1.085 vs v17.6.1.052 of the dev db, though I don't think this is really the problem. The table is small and the query is ok. I don't believe that raising statement timeout would be the fix neither.
ALTER TABLE users ADD COLUMN browser VARCHAR;
ALTER TABLE users ADD COLUMN browser_version VARCHAR;
ALTER TABLE users ADD COLUMN last_login_at TIMESTAMP WITH TIME ZONE DEFAULT now() NOT NULL;
I have a dev database with the same configurations, only with fewer rows, and it runs the same query seamlessly. I'm suspecting that upgrading PostgreSQL version should fix it. It's v15.8.1.085 vs v17.6.1.052 of the dev db, though I don't think this is really the problem. The table is small and the query is ok. I don't believe that raising statement timeout would be the fix neither.
