Comments (2)
2022-12-01 19:30:09 UTC [915447]: user=,db=,app=,client= LOG: server process (PID 1350804) was terminated by signal 7: Bus error
2022-12-01 19:30:09 UTC [915447]: user=,db=,app=,client= DETAIL: Failed process was running:
SELECT
current_database() AS db, schemaname, tablename, reltuples::bigint AS tups, relpages::bigint AS pages, otta,
ROUND(CASE WHEN otta=0 OR sml.relpages=0 OR sml.relpages=otta THEN 0.0 ELSE sml.relpages/otta::numeric END,1) AS tbloat,
CASE WHEN relpages < otta THEN 0 ELSE relpages::bigint - otta END AS wastedpages,
CASE WHEN relpages < otta THEN 0 ELSE bs*(sml.relpages-otta)::bigint END AS wastedbytes,
CASE WHEN relpages < otta THEN '0 bytes'::text ELSE (bs*(relpages-otta))::bigint::text || ' bytes' END AS wastedsize,
iname, ituples::bigint AS itups, ipages::bigint AS ipages, iotta,
ROUND(CASE WHEN iotta=0 OR ipages=0 OR ipages=iotta THEN 0.0 ELSE ipages/iotta::numeric END,1) AS ibloat,
CASE WHEN ipages < iotta THEN 0 ELSE ipages::bigint - iotta END AS wastedipages,
CASE WHEN ipages < iotta THEN 0 ELSE (bs*(ipages-iotta))::bigint END AS wastedibytes,
CASE WHEN ipages < iotta THEN '0 bytes' ELSE (bs*(ipages-iotta))::bigint::text || ' bytes' END AS wastedisize,
CASE WHEN relpages < ott
2022-12-01 19:30:09 UTC [915447]: user=,db=,app=,client= LOG: terminating any other active server processes
Seems to be a common problem. I'm pretty sure pgwatch2 did something very similar
from pgmetrics.
It's not a pgmetrics and it's not a pgwatch2. You have misconfigured instance. Check your settings and tune memory, especially huge_pages
from pgmetrics.
Related Issues (20)
- Log parsing clarification HOT 4
- How to read some values reported by pgmetrics (e.g. shared_buffers, max_wal_size) HOT 6
- Postgres 13: wal_keep_segments displays no value HOT 2
- What determines the sort order for list of table details in pgmetrics output? HOT 2
- Incorrect min_wal_size displayed for PG ver >= 10 HOT 2
- Improve heuristic to check if PG is local HOT 4
- Slow bloat query HOT 4
- AWS RDS, Aurora cloudwatch collection error HOT 3
- pg_stat_archiver query failed: sql: Scan error on column index 6, name "date_part": converting NULL to int64 is unsupported HOT 2
- Omitting retrieval of index definition HOT 1
- Please, add building instructions HOT 2
- Support Citus 11 HOT 2
- Break up the Postgres shared memory is not available in pgmetrics/pgDash currently.
- how to collect system info with pgmetrics HOT 1
- [Feature] Support connect by Keyword/Value Connection Strings HOT 1
- support PG16 HOT 2
- PgMetrics not working for AWS Aurora Instances HOT 1
- PGBOUNCER 1.21 breaking change. HOT 1
- pg_stat(io)_user_tables query failed: ERROR: canceling statement due to lock timeout (SQLSTATE 55P03) HOT 1
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 pgmetrics.