You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Доброго времени суток!
Сегодня pgSqlBlocks 1.7.5 завалил БД с ошибкой:
2021-05-03 13:54:24.844 EEST [107289] [pgSqlBlocks 1.7.5] [pgadmin] [postgres] [1.1.1.1]ERROR: out of shared memory 2021-05-03 13:54:24.844 EEST [107289] [pgSqlBlocks 1.7.5] [pgadmin] [postgres] [1.1.1.1]]HINT: You might need to increase max_locks_per_transaction. 2021-05-03 13:54:24.844 EEST [107289] [pgSqlBlocks 1.7.5] [pgadmin] [postgres] [1.1.1.1]]STATEMENT: WITH blocks AS ( SELECT blocking_locks.pid as pid, blocked_locks.p id as blocked_pid, blocking_locks.locktype as locktype, blocking_locks.relation::regclass as relation, blocking_locks.granted as granted FROM pg_catalog.pg_l ocks blocked_locks JOIN pg_catalog.pg_locks blocking_locks ON blocking_locks.locktype = blocked_locks.locktype AND blocking_locks.DATABASE IS NOT DISTINCT FROM blocked_locks.DATABASE AND blocking_locks.relation IS NOT DISTINCT FROM blocked_locks.relation AND blocking_locks.page IS NOT DISTINCT FROM blocked_locks.page AND bloc king_locks.tuple IS NOT DISTINCT FROM blocked_locks.tuple AND blocking_locks.virtualxid IS NOT DISTINCT FROM blocked_locks.virtualxid AND blocking_locks.transactionid IS NOT D ISTINCT FROM blocked_locks.transactionid AND blocking_locks.classid IS NOT DISTINCT FROM blocked_locks.classid AND blocking_locks.objid IS NOT DISTINCT FROM blocked_locks.obji d AND blocking_locks.objsubid IS NOT DISTINCT FROM blocked_locks.objsubid AND blocking_locks.pid != blocked_locks.pid WHERE NOT blocked_locks.granted)SELECT procs.pid A S pid, application_name, datname, usename, backend_type, CASE WHEN client_port=-1 THEN 'local pipe' WHEN length(client_hostname)>0 THEN client_hostname||':'||clie nt_port ELSE textin(inet_out(client_addr))||':'||client_port END AS client, date_trunc('second', backend_start) AS backend_start, CASE WHEN state='active' THEN date_tru nc('second', query_start)::text ELSE '' END AS query_start, date_trunc('second', xact_start) AS xact_start, state, date_trunc('second', state_change) AS state_chang e, blocks.pid AS blockedby, /* deprecated null::text AS blocking_locks,*/ blocks.locktype AS locktype, blocks.relation AS relation, blocks.granted AS granted, query AS query, CASE WHEN query_start IS NULL OR state<>'active' THEN false ELSE query_start < now() - '10 seconds'::interval END AS slowquery FROM pg_stat_activity procs LEFT JOIN blocks ON blocks.blocked_pid = procs.pid ORDER BY pid 2021-05-03 13:54:25.192 EEST [18617] [] [] [] []LOG: startup process (PID 18619) exited with exit code 1 2021-05-03 13:54:25.192 EEST [18617] [] [] [] []LOG: terminating any other active server processes 2021-05-03 13:54:27.116 EEST [18617] [] [] [] []LOG: database system is shut down
Впервые с таким столкнулся, PostgreSQL 10.9
The text was updated successfully, but these errors were encountered:
Доброго времени суток!
Сегодня pgSqlBlocks 1.7.5 завалил БД с ошибкой:
2021-05-03 13:54:24.844 EEST [107289] [pgSqlBlocks 1.7.5] [pgadmin] [postgres] [1.1.1.1]ERROR: out of shared memory
2021-05-03 13:54:24.844 EEST [107289] [pgSqlBlocks 1.7.5] [pgadmin] [postgres] [1.1.1.1]]HINT: You might need to increase max_locks_per_transaction.
2021-05-03 13:54:24.844 EEST [107289] [pgSqlBlocks 1.7.5] [pgadmin] [postgres] [1.1.1.1]]STATEMENT: WITH blocks AS ( SELECT blocking_locks.pid as pid, blocked_locks.p id as blocked_pid, blocking_locks.locktype as locktype, blocking_locks.relation::regclass as relation, blocking_locks.granted as granted FROM pg_catalog.pg_l ocks blocked_locks JOIN pg_catalog.pg_locks blocking_locks ON blocking_locks.locktype = blocked_locks.locktype AND blocking_locks.DATABASE IS NOT DISTINCT FROM blocked_locks.DATABASE AND blocking_locks.relation IS NOT DISTINCT FROM blocked_locks.relation AND blocking_locks.page IS NOT DISTINCT FROM blocked_locks.page AND bloc king_locks.tuple IS NOT DISTINCT FROM blocked_locks.tuple AND blocking_locks.virtualxid IS NOT DISTINCT FROM blocked_locks.virtualxid AND blocking_locks.transactionid IS NOT D ISTINCT FROM blocked_locks.transactionid AND blocking_locks.classid IS NOT DISTINCT FROM blocked_locks.classid AND blocking_locks.objid IS NOT DISTINCT FROM blocked_locks.obji d AND blocking_locks.objsubid IS NOT DISTINCT FROM blocked_locks.objsubid AND blocking_locks.pid != blocked_locks.pid WHERE NOT blocked_locks.granted)SELECT procs.pid A S pid, application_name, datname, usename, backend_type, CASE WHEN client_port=-1 THEN 'local pipe' WHEN length(client_hostname)>0 THEN client_hostname||':'||clie nt_port ELSE textin(inet_out(client_addr))||':'||client_port END AS client, date_trunc('second', backend_start) AS backend_start, CASE WHEN state='active' THEN date_tru nc('second', query_start)::text ELSE '' END AS query_start, date_trunc('second', xact_start) AS xact_start, state, date_trunc('second', state_change) AS state_chang e, blocks.pid AS blockedby, /* deprecated null::text AS blocking_locks,*/ blocks.locktype AS locktype, blocks.relation AS relation, blocks.granted AS granted, query AS query, CASE WHEN query_start IS NULL OR state<>'active' THEN false ELSE query_start < now() - '10 seconds'::interval END AS slowquery FROM pg_stat_activity procs LEFT JOIN blocks ON blocks.blocked_pid = procs.pid ORDER BY pid
2021-05-03 13:54:25.192 EEST [18617] [] [] [] []LOG: startup process (PID 18619) exited with exit code 1
2021-05-03 13:54:25.192 EEST [18617] [] [] [] []LOG: terminating any other active server processes
2021-05-03 13:54:27.116 EEST [18617] [] [] [] []LOG: database system is shut down
Впервые с таким столкнулся, PostgreSQL 10.9
The text was updated successfully, but these errors were encountered: