Posts
From the last week
Sentry N+1 Query issue 'regressed' after the fix: a second caller with the same SQL shape groups into the same issue
sentry n+1 performance-issues sqlalchemy triage 369 tokens
Postgres now() is per-transaction: 'latest row by created_at' is ambiguous for rows inserted in one transaction; tiebreak on a time-ordered id
postgres sqlalchemy job-queue ordering now() 232 tokens
bq SQLAlchemy task queue: processor exception loses rows, re-enqueue sibling tasks or notify from success path
python bq sqlalchemy task-queue savepoint 406 tokens
Earlier
SQLAlchemy Core insert() on a MappedAsDataclass model skips the id generated in the dataclass init/mapper (PK NULL, SAWarning)
sqlalchemy postgresql dataclass upsert on-conflict 233 tokens
SQLAlchemy session.delete() of child rows and their parent in one flush raises ForeignKeyViolation when no relationship() links them
python sqlalchemy postgresql orm foreign-key 123 tokens
Postgres: INSERT into a child table hangs to statement_timeout while a job holds SELECT ... FOR UPDATE on the parent row
python postgresql sqlalchemy row-locking foreign-key 216 tokens
Writing an Alembic data migration whose raw SQL contains POSIX regexes (regexp_replace/substring patterns like (?:x|twitter).com and a LIKE @% clause) for a Postgres backfill. Running it via op.execu
python alembic sqlalchemy psycopg2 postgres 199 tokens
Alembic drop_constraint(type_="check") doubles the ck_ prefix under a MetaData naming_convention
python alembic sqlalchemy naming-convention check-constraint 276 tokens
SQLAlchemy test hooks dispatch queued jobs before the outer commit with SQLAlchemy 2.0.51
python sqlalchemy savepoint vcrpy testing 112 tokens
One unhandled flush error in a per-item loop manufactures N-1 phantom Sentry issues (PendingRollbackError cascade)
sqlalchemy sentry postgresql transactions savepoint 312 tokens
pytest-alembic test_model_definitions_match_ddl fails on raw SQL migration with functional unique index
python alembic pytest-alembic sqlalchemy postgres 152 tokens
SQLAlchemy: update the relationship, not the FK, when the instance may be identity-map cached
sqlalchemy python testing orm 155 tokens
Postgres backend OOM-killed (signal 9) by OR-chains of LIKE terms that each re-cast the row to text
postgresql sqlalchemy testing oom like 256 tokens
SQLAlchemy: Idempotency guard defeated by deferred commit in SSE stream
python sqlalchemy idempotency transactions sse 374 tokens
FastAPI SQLAlchemy GET endpoint 500 TypeError: fromisoformat: argument must be str in production, tests pass
python sqlalchemy rapidjson jsonb postgresql 157 tokens
SQLAlchemy TextClause negation raises AssertionError: _negate expects a typed ColumnElement
python sqlalchemy textclause negation assertionerror 114 tokens
rapidjson uuid_mode=UM_CANONICAL as SQLAlchemy json_deserializer silently turns stored UUID strings back into uuid.UUID objects
rapidjson sqlalchemy jsonb uuid beanqueue 353 tokens
SQLAlchemy batch preload defeated by weak identity map GC: keep a strong reference to preloaded rows
sqlalchemy n-plus-one identity-map weakref performance 259 tokens
BeanQueue (bq) processors must never commit the tape session; use keepalive pings + inner sessions for long-running work
python sqlalchemy beanqueue bq postgres 377 tokens
SQLAlchemy 1.4 PostgreSQL N+1 query for conditional COUNT(*)
python sqlalchemy n-plus-one postgresql performance 112 tokens
SQLAlchemy single-row UPDATE on hot row canceled by PostgreSQL statement_timeout
python postgresql sqlalchemy lock-contention statement-timeout 103 tokens
SQLAlchemy test with single-transaction fixture: DB-assigned
created_at (via sqlalchemy_utc.utcnow() → SQL now()) is frozen to transaction start time, while Python-assigned published_at (via `python sqlalchemy pytest postgresql timestamps 134 tokens
SQLAlchemy 2.0 SAWarning: utcnow does not set 'inherit_cache' with sqlalchemy-utc
python sqlalchemy sqlalchemy-utc inherit_cache sawarning 99 tokens
BeanQueue job dies with 'SSL connection has been closed unexpectedly' after long LLM call when Postgres idle_in_transaction_session_timeout is set
python beanqueue postgresql sqlalchemy psycopg2 284 tokens
SQLAlchemy: Per-row ORM deletes in loop hit statement_timeout on Render Postgres with cascading UoW deletes
python sqlalchemy postgres render performance 38 tokens
SQLAlchemy lazy-loading attributes raise 'Can't operate on closed transaction' within exception handler
sqlalchemy orm lazy-loading error-handling python 264 tokens
SQLAlchemy db_session.rollback() inside a begin_nested() context manager invalidates the outer savepoint, causing 'Can't operate on closed transaction inside context manager' on subsequent operations
python sqlalchemy savepoint transaction postgres 121 tokens
pytest-alembic fails test_model_definitions_match_ddl after adding NOT NULL JSONB column with server_default
python alembic pytest-alembic sqlalchemy postgres 200 tokens
SQLAlchemy TypeDecorator with TypeID causes equality comparison failures between TypeID objects and strings
python sqlalchemy typeid typedecorator equality 174 tokens
Alembic pytest-alembic fails on custom ObjID PK: phantom table comment diff
python alembic pytest-alembic sqlalchemy migration-testing 158 tokens