Índice de sintomas
Mensagens de erro e sintomas observáveis citados pelos artigos, em ordem alfabética. A pesquisa também os encontra.
0.1 + 0.2 is not 0.3- Floating-point numbers: why 0.1 + 0.2 is not 0.3
Chinese, Japanese or Korean substring search returns no result- Measured CJK substring retrieval with PostgreSQL simple full-text search and character bigrams
Concurrent queue consumers claim the same job- Measured PostgreSQL SKIP LOCKED claims with four concurrent queue consumers
current transaction is aborted- Savepoints and the aborted-transaction state in PostgreSQL
current transaction is aborted, commands ignored until end of transaction block- Measured PostgreSQL savepoint recovery after a duplicate-key error
Database connection pool exhausted- Database connection pooling and its limits
Dead tuples accumulate- VACUUM, autovacuum and table bloat
Deep OFFSET pagination becomes slow- Measured PostgreSQL deep pagination: 90,020 scanned rows with OFFSET versus 20 with a cursor
ERR_REQUIRE_ESM- ES modules versus CommonJS in Node.js
ES module and CommonJS interoperability problems- ES modules versus CommonJS in Node.js
Fetch request does not finish- Using fetch with timeouts and AbortController
Fetch request needs cancellation- Using fetch with timeouts and AbortController
Filesystem reports free space but writes fail- Diagnosing 'No space left on device' when df shows free space
Floating-point rounding errors in monetary calculations- Money and other exact quantities: use Decimal, not float
Git checkout contains LFS pointer instead of file content- Git LFS: pointer files, smudge filters and when not to use it
Git repository history contains large binary files- Removing large binaries from Git history with git filter-repo
Go interface containing a nil pointer is not nil- Go interfaces: implicit satisfaction and the non-nil nil
In-flight requests interrupted during service shutdown- Graceful shutdown: handling SIGTERM in services
JVM container exceeds memory limit- Sizing a JVM inside a container: heap percentage, non-heap memory and CPU count
Long JavaScript tasks block rendering- The JavaScript event loop: tasks, microtasks and rendering
Long-running transactions block database maintenance- Long-running and idle-in-transaction sessions in PostgreSQL: what they block and how to bound them
Missing page returns HTTP 200- Custom 404 pages and soft 404s: serve the error page with the error status
Model evaluation includes information from the test set- Data leakage in machine learning: how information from the future or the test set gets into a model
No space left on device- Diagnosing 'No space left on device' when df shows free space
NULL values pass a positive-value CHECK constraint- Measured PostgreSQL CHECK and UNIQUE behavior with two NULL values
OOMKilled- Kubernetes resource requests and limits: scheduling, throttling and OOM kills
PostgreSQL collation version mismatch after library upgrade- Collations in PostgreSQL: libc, ICU and the builtin provider, and why a library upgrade can corrupt an index
PostgreSQL deadlock- Diagnosing lock waits and deadlocks in PostgreSQL with pg_locks, pg_blocking_pids and lock_timeout
PostgreSQL idle in transaction- Long-running and idle-in-transaction sessions in PostgreSQL: what they block and how to bound them
PostgreSQL planner row estimates are wrong- Planner statistics in PostgreSQL: statistics targets, correlated columns and misestimates
PostgreSQL queries wait for locks- Diagnosing lock waits and deadlocks in PostgreSQL with pg_locks, pg_blocking_pids and lock_timeout
PostgreSQL table bloat- VACUUM, autovacuum and table bloat
PostgreSQL transaction remains aborted after an error- Savepoints and the aborted-transaction state in PostgreSQL
Public package shadows a private dependency- Dependency confusion: when a public package shadows a private one
Python memory usage keeps growing- Finding a memory leak with tracemalloc snapshots
Reused HTTP connection was closed by the server- HTTP keep-alive and connection reuse: pools, idle timeouts and the stale-connection race
Scheduled job failures go unnoticed- Scheduled jobs that do not silently fail
Slow PostgreSQL query- Reading a PostgreSQL query plan with EXPLAIN ANALYZE
Soft 404- Custom 404 pages and soft 404s: serve the error page with the error status
SQL NULL comparison does not match expected rows- NULL in SQL: three-valued logic and its traps
Text shifts when web font loads- Web font loading: font-display, preload, unicode-range subsetting and metric-matched fallbacks
Third-party script changed unexpectedly- Subresource integrity for third-party scripts and stylesheets
TLS certificate approaching expiry- Monitorizar o vencimento de certificados TLS em todos os endpoints, não só no site principal
TLS certificate chain validation fails- Checking a served TLS certificate chain and its expiry from the command line with openssl
TLS certificate expired- Checking a served TLS certificate chain and its expiry from the command line with openssl
Legível por máquina: JSON