Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

pq: remaining connection slots are reserved for non-replication superuser connections

Description

We are getting the below errors in the Postgresql.log and Grafana log file. All of sudden dashboards not working.

 

logger=context userId=1 orgId=1 uname=admin t=2023-12-14T04:56:10.737469066Z level=info msg="Request Completed" method=GET path=/api/live/ws status=400 remote_addr=10.143.28.21 time_ms=3 duration=3.204522ms size=12 referer= handler=/api/live/ws
logger=context userId=7 orgId=1 uname="Joseph Kutse" t=2023-12-14T04:56:11.210090841Z level=info msg="Request Completed" method=GET path=/api/live/ws status=400 remote_addr=10.153.28.22 time_ms=5 duration=5.855509ms size=12 referer= handler=/api/live/ws
logger=context userId=1 orgId=1 uname=admin t=2023-12-14T04:56:11.971281607Z level=info msg="Request Completed" method=GET path=/api/live/ws status=400 remote_addr=10.143.28.21 time_ms=3 duration=3.213956ms size=12 referer= handler=/api/live/ws
logger=context userId=1 orgId=1 uname=admin t=2023-12-14T04:56:12.927761804Z level=info msg="Request Completed" method=GET path=/api/live/ws status=400 remote_addr=10.143.28.21 time_ms=3 duration=3.390884ms size=12 referer= handler=/api/live/ws
logger=context userId=1 orgId=1 uname=admin t=2023-12-14T04:56:13.895015239Z level=info msg="Request Completed" method=GET path=/api/live/ws status=400 remote_addr=10.143.28.21 time_ms=3 duration=3.133541ms size=12 referer= handler=/api/live/ws
logger=context userId=43 orgId=1 uname="Terrence Bolden" t=2023-12-14T04:56:15.890676747Z level=info msg="Request Completed" method=GET path=/api/live/ws status=400 remote_addr=10.8.56.138 time_ms=3 duration=3.181196ms size=12 referer= handler=/api/live/ws
logger=context userId=1 orgId=1 uname=admin t=2023-12-14T04:56:16.157327161Z level=info msg="Request Completed" method=GET path=/api/live/ws status=400 remote_addr=10.143.28.21 time_ms=3 duration=3.830801ms size=12 referer= handler=/api/live/ws
logger=context userId=1 orgId=1 uname=admin t=2023-12-14T04:56:17.114410238Z level=info msg="Request Completed" method=GET path=/api/live/ws status=400 remote_addr=10.143.28.21 time_ms=4 duration=4.199249ms size=12 referer= handler=/api/live/ws
logger=context userId=8 orgId=1 uname="Reddi Bharath Velakaturi1" t=2023-12-14T04:56:17.643539172Z level=info msg="Request Completed" method=GET path=/api/live/ws status=400 remote_addr=10.153.28.21 time_ms=249 duration=249.531258ms size=12 referer= handler=/api/live/ws
logger=context userId=1 orgId=1 uname=admin t=2023-12-14T04:56:18.328303315Z level=info msg="Request Completed" method=GET path=/api/live/ws status=400 remote_addr=10.143.28.21 time_ms=7 duration=7.324861ms size=12 referer= handler=/api/live/ws
logger=context userId=14 orgId=1 uname="Sri Teja Mogili" t=2023-12-14T04:56:18.764766404Z level=info msg="Request Completed" method=GET path=/api/live/ws status=400 remote_addr=10.153.28.21 time_ms=6 duration=6.097371ms size=12 referer= handler=/api/live/ws
logger=context userId=1 orgId=1 uname=admin t=2023-12-14T04:56:20.060928669Z level=info msg="Request Completed" method=GET path=/api/live/ws status=400 remote_addr=10.143.28.21 time_ms=3 duration=3.562308ms size=12 referer= handler=/api/live/ws
logger=context userId=1 orgId=1 uname=admin t=2023-12-14T04:56:21.26523628Z level=info msg="Request Completed" method=GET path=/api/live/ws status=400 remote_addr=10.143.28.21 time_ms=3 duration=3.272782ms size=12 referer= handler=/api/live/ws
logger=context userId=14 orgId=1 uname="Sri Teja Mogili" t=2023-12-14T04:56:21.76221663Z level=info msg="Request Completed" method=GET path=/api/live/ws status=400 remote_addr=10.153.28.21 time_ms=3 duration=3.93829ms size=12 referer= handler=/api/live/ws
logger=context userId=1 orgId=1 uname=admin t=2023-12-14T04:56:22.22522896Z level=info msg="Request Completed" method=GET path=/api/live/ws status=400 remote_addr=10.143.28.21 time_ms=7 duration=7.786627ms size=12 referer= handler=/api/live/ws
logger=context userId=7 orgId=1 uname="Joseph Kutse" t=2023-12-14T04:56:22.404602919Z level=info msg="Request Completed" method=GET path=/api/live/ws status=400 remote_addr=10.153.28.22 time_ms=7 duration=7.332952ms size=12 referer= handler=/api/live/ws
logger=context userId=8 orgId=1 uname="Reddi Bharath Velakaturi1" t=2023-12-14T04:56:22.627734247Z level=info msg="Request Completed" method=GET path=/api/live/ws status=400 remote_addr=10.153.28.21 time_ms=2 duration=2.208827ms size=12 referer= handler=/api/live/ws
logger=context userId=85 orgId=1 uname="Swapna Minnakanti" t=2023-12-14T04:56:22.729177454Z level=info msg="Request Completed" method=GET path=/api/live/ws status=400 remote_addr=10.153.28.22 time_ms=3 duration=3.391783ms size=12 referer= handler=/api/live/ws
logger=context userId=1 orgId=1 uname=admin t=2023-12-14T04:56:23.43178779Z level=info msg="Request Completed" method=GET path=/api/live/ws status=400 remote_addr=10.143.28.21 time_ms=3 duration=3.17107ms size=12 referer= handler=/api/live/ws
logger=context userId=14 orgId=1 uname="Sri Teja Mogili" t=2023-12-14T04:56:23.77324262Z level=info msg="Request Completed" method=GET path=/api/live/ws status=400 remote_addr=10.153.28.21 time_ms=3 duration=3.161427ms size=12 referer= handler=/api/live/ws
logger=context userId=43 orgId=1 uname="Terrence Bolden" t=2023-12-14T04:56:23.918257606Z level=info msg="Request Completed" method=GET path=/api/live/ws status=400 remote_addr=10.8.56.138 time_ms=4 duration=4.394062ms size=12 referer= handler=/api/live/ws
logger=context userId=1 orgId=1 uname=admin t=2023-12-14T04:56:24.394840478Z level=info msg="Request Completed" method=GET path=/api/live/ws status=400 remote_addr=10.143.28.21 time_ms=4 duration=4.585472ms size=12 referer= handler=/api/live/ws
logger=context userId=1 orgId=1 uname=admin t=2023-12-14T04:56:25.366179318Z level=info msg="Request Completed" method=GET path=/api/live/ws status=400 remote_addr=10.143.28.21 time_ms=9 duration=9.96836ms size=12 referer= handler=/api/live/ws
logger=context userId=14 orgId=1 uname="Sri Teja Mogili" t=2023-12-14T04:56:25.746011834Z level=info msg="Request Completed" method=GET path=/api/live/ws status=400 remote_addr=10.153.28.21 time_ms=3 duration=3.647624ms size=12 referer= handler=/api/live/ws
logger=context userId=1 orgId=1 uname=admin t=2023-12-14T04:56:26.428856333Z level=info msg="Request Completed" method=GET path=/api/live/ws status=400 remote_addr=10.143.28.21 time_ms=3 duration=3.296408ms size=12 referer= handler=/api/live/ws
logger=context userId=0 orgId=1 uname= t=2023-12-14T04:56:26.992251232Z level=error msg="Failed to list api keys" error="pq: remaining connection slots are reserved for non-replication superuser connections" remote_addr=127.0.0.1 traceID=
logger=context userId=0 orgId=1 uname= t=2023-12-14T04:56:26.993014956Z level=error msg="Request Completed" method=GET path=/api/auth/key status=500 remote_addr=127.0.0.1 time_ms=15 duration=15.973896ms size=74 referer= handler=/api/auth/key/
logger=context t=2023-12-14T04:56:27.07889279Z level=error msg="invalid API key" error="pq: remaining connection slots are reserved for non-replication superuser connections" traceID=
logger=context userId=0 orgId=0 uname= t=2023-12-14T04:56:27.079679281Z level=error msg="Request Completed" method=GET path=/api/auth/key status=500 remote_addr=127.0.0.1 time_ms=3 duration=3.582663ms size=67 referer=
logger=context t=2023-12-14T04:56:27.082635887Z level=error msg="invalid API key" error="pq: remaining connection slots are reserved for non-replication superuser connections" traceID=
logger=context userId=0 orgId=0 uname= t=2023-12-14T04:56:27.083360972Z level=error msg="Request Completed" method=GET path=/api/auth/key status=500 remote_addr=127.0.0.1 time_ms=2 duration=2.913722ms size=67 referer=
logger=context t=2023-12-14T04:56:27.086747096Z level=error msg="invalid API key" error="pq: remaining connection slots are reserved for non-replication superuser connections" traceID=
logger=context userId=0 orgId=0 uname= t=2023-12-14T04:56:27.087442648Z level=error msg="Request Completed" method=GET path=/api/auth/key status=500 remote_addr=127.0.0.1 time_ms=2 duration=2.657483ms size=67 referer=
logger=context t=2023-12-14T04:56:27.089863012Z level=error msg="invalid API key" error="pq: remaining connection slots are reserved for non-replication superuser connections" traceID=
logger=context userId=0 orgId=0 uname= t=2023-12-14T04:56:27.09055884Z level=error msg="Request Completed" method=GET path=/api/auth/key status=500 remote_addr=127.0.0.1 time_ms=2 duration=2.445703ms size=67 referer=
logger=context t=2023-12-14T04:56:27.101182051Z level=error msg="invalid API key" error="pq: remaining connection slots are reserved for non-replication superuser connections" traceID=
logger=context userId=0 orgId=0 uname= t=2023-12-14T04:56:27.101926245Z level=error msg="Request Completed" method=GET path=/api/auth/key status=500 remote_addr=127.0.0.1 time_ms=2 duration=2.722001ms size=67 referer=
logger=context t=2023-12-14T04:56:27.102566051Z level=error msg="invalid API key" error="pq: remaining connection slots are reserved for non-replication superuser connections" traceID=
logger=context userId=0 orgId=0 uname= t=2023-12-14T04:56:27.103297929Z level=error msg="Request Completed" method=GET path=/api/auth/key status=500 remote_addr=127.0.0.1 time_ms=2 duration=2.686523ms size=67 referer=
logger=context t=2023-12-14T04:56:27.10421831Z level=error msg="invalid API key" error="pq: remaining connection slots are reserved for non-replication superuser connections" traceID=

logger=context t=2023-12-14T04:56:27.104775703Z level=error msg="invalid API key" error="pq: remaining connection slots are reserved for non-replication superuser connections" traceID=
logger=context userId=0 orgId=0 uname= t=2023-12-14T04:56:27.105007496Z level=error msg="Request Completed" method=GET path=/api/auth/key status=500 remote_addr=127.0.0.1 time_ms=2 duration=2.721525ms size=67 referer=
logger=context userId=0 orgId=0 uname= t=2023-12-14T04:56:27.105598755Z level=error msg="Request Completed" method=GET path=/api/auth/key status=500 remote_addr=127.0.0.1 time_ms=2 duration=2.92642ms size=67 referer=
logger=context t=2023-12-14T04:56:27.105883748Z level=error msg="invalid API key" error="pq: remaining connection slots are reserved for non-replication superuser connections" traceID=
logger=context userId=0 orgId=0 uname= t=2023-12-14T04:56:27.10659147Z level=error msg="Request Completed" method=GET path=/api/auth/key status=500 remote_addr=127.0.0.1 time_ms=2 duration=2.636931ms size=67 referer=
logger=context t=2023-12-14T04:56:27.107566688Z level=error msg="invalid API key" error="pq: remaining connection slots are reserved for non-replication superuser connections" traceID=
logger=context userId=0 orgId=0 uname= t=2023-12-14T04:56:27.10835659Z level=error msg="Request Completed" method=GET path=/api/auth/key status=500 remote_addr=127.0.0.1 time_ms=2 duration=2.591884ms size=67 referer=
logger=context t=2023-12-14T04:56:27.123168817Z level=error msg="invalid API key" error="pq: remaining connection slots are reserved for non-replication superuser connections" traceID=
logger=context userId=0 orgId=0 uname= t=2023-12-14T04:56:27.123905088Z level=error msg="Request Completed" method=GET path=/api/auth/key status=500 remote_addr=127.0.0.1 time_ms=2 duration=2.684764ms size=67 referer=
logger=context t=2023-12-14T04:56:27.126284211Z level=error msg="invalid API key" error="pq: remaining connection slots are reserved for non-replication superuser connections" traceID=
logger=context userId=0 orgId=0 uname= t=2023-12-14T04:56:27.127019954Z level=error msg="Request Completed" method=GET path=/api/auth/key status=500 remote_addr=127.0.0.1 time_ms=2 duration=2.58279ms size=67 referer=
logger=context t=2023-12-14T04:56:27.129821969Z level=error msg="invalid API key" error="pq: remaining connection slots are reserved for non-replication superuser connections" traceID=
logger=context userId=0 orgId=0 uname= t=2023-12-14T04:56:27.130625073Z level=error msg="Request Completed" method=GET path=/api/auth/key status=500 remote_addr=127.0.0.1 time_ms=2 duration=2.550233ms size=67 referer=
logger=context t=2023-12-14T04:56:27.133147437Z level=error msg="invalid API key" error="pq: remaining connection slots are reserved for non-replication superuser connections" traceID=
logger=context userId=0 orgId=0 uname= t=2023-12-14T04:56:27.133912967Z level=error msg="Request Completed" method=GET path=/api/auth/key status=500 remote_addr=127.0.0.1 time_ms=2 duration=2.676263ms size=67 referer=
logger=searchIndex t=2023-12-14T04:56:27.205967682Z level=error msg="can't load events" error="pq: remaining connection slots are reserved for non-replication superuser connections"
logger=context userId=1 orgId=1 uname=admin t=2023-12-14T04:56:27.390816908Z level=info msg="Request Completed" method=GET path=/api/live/ws status=400 remote_addr=10.143.28.21 time_ms=3 duration=3.91122ms size=12 referer= handler=/api/live/ws
logger=context userId=1 orgId=1 uname=admin t=2023-12-14T04:56:30.455238095Z level=info msg="Request Completed" method=GET path=/api/live/ws status=400 remote_addr=10.143.28.21 time_ms=3 duration=3.030685ms size=12 referer= handler=/api/live/ws
logger=context userId=1 orgId=1 uname=admin t=2023-12-14T04:56:31.427177975Z level=info msg="Request Completed" method=GET path=/api/live/ws status=400 remote_addr=10.143.28.21 time_ms=3 duration=3.498207ms size=12 referer= handler=/api/live/ws
logger=context userId=8 orgId=1 uname="Reddi Bharath Velakaturi1" t=2023-12-14T04:56:34.400486602Z level=info msg="Request Completed" method=GET path=/api/live/ws status=400 remote_addr=10.153.28.21 time_ms=5 duration=5.896629ms size=12 referer= handler=/api/live/ws
logger=context userId=1 orgId=1 uname=admin t=2023-12-14T04:56:35.026026194Z level=info msg="Request Completed" method=GET path=/api/live/ws status=400 remote_addr=10.143.28.21 time_ms=3 duration=3.167399ms size=12 referer= handler=/api/live/ws

From the PostgreSQL log file:

===================

2023-12-14 05:24:22.895 UTC [45911] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:22.896 UTC [45912] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:22.898 UTC [45913] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:22.905 UTC [45914] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:22.906 UTC [45915] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:22.908 UTC [45916] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:22.931 UTC [45917] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:22.933 UTC [45918] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.115 UTC [45935] ERROR:  permission denied for function pg_ls_waldir
2023-12-14 05:24:23.115 UTC [45935] STATEMENT:  
            SELECT
                COUNTYellow Star AS segments,
                SUM(size) AS size
            FROM pg_ls_waldir()
            WHERE name ~ '^[0-9A-F]

{24}$'
2023-12-14 05:24:23.169 UTC [45955] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.181 UTC [45957] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.193 UTC [45958] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.196 UTC [45959] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.218 UTC [45960] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.226 UTC [45961] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.253 UTC [45962] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.271 UTC [45963] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.272 UTC [45964] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.273 UTC [45965] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.273 UTC [45966] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.277 UTC [45967] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.418 UTC [45978] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.437 UTC [45979] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.450 UTC [45980] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.450 UTC [45981] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.451 UTC [45982] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.453 UTC [45983] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.454 UTC [45984] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.463 UTC [45985] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.466 UTC [45986] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.504 UTC [45987] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.505 UTC [45988] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.505 UTC [45989] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.508 UTC [45990] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.508 UTC [45991] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.509 UTC [45992] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.512 UTC [45993] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.515 UTC [45994] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.557 UTC [45995] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.560 UTC [45996] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.590 UTC [45997] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.591 UTC [45998] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.594 UTC [45999] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.594 UTC [46000] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.597 UTC [46001] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.598 UTC [46002] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.598 UTC [46003] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.599 UTC [46004] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.600 UTC [46005] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.600 UTC [46006] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.604 UTC [46007] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.605 UTC [46008] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.605 UTC [46009] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.606 UTC [46010] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.606 UTC [46011] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.607 UTC [46012] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.607 UTC [46013] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.608 UTC [46014] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.608 UTC [46015] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.609 UTC [46016] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.610 UTC [46017] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.611 UTC [46018] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.613 UTC [46019] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.616 UTC [46020] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.623 UTC [46021] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.625 UTC [46022] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.626 UTC [46023] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.627 UTC [46024] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.629 UTC [46025] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:23.630 UTC [46026] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:25.394 UTC [46111] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:25.395 UTC [46112] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:25.424 UTC [46114] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:25.424 UTC [46113] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:25.427 UTC [46115] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:25.428 UTC [46116] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:25.428 UTC [46117] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:25.430 UTC [46118] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:25.445 UTC [46119] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:25.447 UTC [46120] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:25.448 UTC [46121] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:25.448 UTC [46122] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:25.449 UTC [46123] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:25.449 UTC [46124] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:25.451 UTC [46125] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:25.452 UTC [46126] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:25.477 UTC [46127] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:25.480 UTC [46128] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:25.480 UTC [46129] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:25.483 UTC [46130] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:28.118 UTC [46225] ERROR:  permission denied for function pg_ls_waldir
2023-12-14 05:24:28.118 UTC [46225] STATEMENT:  
            SELECT
                COUNTYellow Star AS segments,
                SUM(size) AS size
            FROM pg_ls_waldir()
            WHERE name ~ '^[0-9A-F]{24}

$'
2023-12-14 05:24:33.108 UTC [46394] ERROR:  permission denied for function pg_ls_waldir
2023-12-14 05:24:33.108 UTC [46394] STATEMENT:  
            SELECT
                COUNTYellow Star AS segments,
                SUM(size) AS size
            FROM pg_ls_waldir()
            WHERE name ~ '^[0-9A-F]

{24}$'
2023-12-14 05:24:34.462 UTC [46464] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:34.464 UTC [46465] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:34.473 UTC [46466] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:34.499 UTC [46467] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:34.499 UTC [46468] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:34.505 UTC [46469] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:34.511 UTC [46470] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:34.514 UTC [46471] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:34.515 UTC [46472] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:34.521 UTC [46473] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:34.526 UTC [46474] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:34.526 UTC [46475] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:34.527 UTC [46476] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:34.527 UTC [46477] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:34.528 UTC [46478] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:34.529 UTC [46479] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:34.529 UTC [46480] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:34.531 UTC [46481] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:34.532 UTC [46482] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:34.533 UTC [46483] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:34.533 UTC [46484] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:34.535 UTC [46485] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:34.554 UTC [46486] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:34.557 UTC [46487] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:34.586 UTC [46488] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:34.589 UTC [46489] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:34.589 UTC [46490] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:34.593 UTC [46491] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:34.596 UTC [46492] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:34.599 UTC [46493] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:34.639 UTC [46494] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:34.642 UTC [46495] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:34.694 UTC [46496] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:34.696 UTC [46497] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:34.741 UTC [46498] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:34.744 UTC [46499] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:34.744 UTC [46500] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:34.833 UTC [46501] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:34.835 UTC [46502] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:35.414 UTC [46516] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:37.505 UTC [46585] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:37.526 UTC [46586] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:37.527 UTC [46587] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:37.528 UTC [46588] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:37.531 UTC [46589] FATAL:  remaining connection slots are reserved for non-replication superuser connections
2023-12-14 05:24:38.111 UTC [46603] ERROR:  permission denied for function pg_ls_waldir
2023-12-14 05:24:38.111 UTC [46603] STATEMENT:  
            SELECT
                COUNTYellow Star AS segments,
                SUM(size) AS size
            FROM pg_ls_waldir()
            WHERE name ~ '^[0-9A-F]{24}

$'

How to test

None

How to document

None

Attachments

4
  • 14 Dec 2023, 09:17 AM
  • 14 Dec 2023, 06:09 AM
  • 14 Dec 2023, 06:07 AM
  • 14 Dec 2023, 05:25 AM

Activity

Naresh November 13, 2024 at 5:27 AM

I can see no of parallel updates during the issue but i am not sure.

33325+00 | 2024-11-13 05:25:28.23345+00 | 2024-11-13 05:25:28.23345+00 | Lock | transactionid | active | 946862455 | 946855673 | -826731047580049144 | UPDATE "api_k
ey" SET "last_used_at" = $1 WHERE "id"=$2

| client backend

18416 | grafana | 3370803 | | 16774 | grafana | | ::1 | | 38066 | 2024-11-13 05:25:58.193686+00 | 2024-11-13 05:25:58.2
24428+00 | 2024-11-13 05:25:58.22455+00 | 2024-11-13 05:25:58.224551+00 | Lock | transactionid | active | 946864077 | 946855673 | -826731047580049144 | UPDATE "api_k
ey" SET "last_used_at" = $1 WHERE "id"=$2

| client backend

18416 | grafana | 3371749 | | 16774 | grafana | | ::1 | | 49594 | 2024-11-13 05:26:05.60979+00 | 2024-11-13 05:26:05.6
5049+00 | 2024-11-13 05:26:05.650597+00 | 2024-11-13 05:26:05.650598+00 | LWLock | WALWrite | active | 946864435 | | -826731047580049144 | UPDATE "api_k
ey" SET "last_used_at" = $1 WHERE "id"=$2

| client backend

18416 | grafana | 3363890 | | 16774 | grafana | | ::1 | | 33554 | 2024-11-13 05:24:51.171143+00 | 2024-11-13 05:24:51.2
04178+00 | 2024-11-13 05:24:51.207357+00 | 2024-11-13 05:24:51.207358+00 | Lock | transactionid | active | 946860355 | 946855263 | -826731047580049144 | UPDATE "api_k
ey" SET "last_used_at" = $1 WHERE "id"=$2

| client backend

18416 | grafana | 3371750 | | 16774 | grafana | | ::1 | | 49604 | 2024-11-13 05:26:05.610123+00 | 2024-11-13 05:26:05.6
12448+00 | 2024-11-13 05:26:05.612847+00 | 2024-11-13 05:26:05.612848+00 | Lock | tuple | active | 946864434 | 946855673 | -826731047580049144 | UPDATE "api_k
ey" SET "last_used_at" = $1 WHERE "id"=$2

| client backend

18416 | grafana | 3362195 | | 16774 | grafana | | ::1 | | 49052 | 2024-11-13 05:24:28.170423+00 | 2024-11-13 05:24:28.1
89094+00 | 2024-11-13 05:24:28.189284+00 | 2024-11-13 05:24:28.189285+00 | Lock | transactionid | active | 946859163 | 946855250 | -826731047580049144 | UPDATE "api_k
ey" SET "last_used_at" = $1 WHERE "id"=$2

| client backend

18416 | grafana | 3357013 | | 16774 | grafana | | ::1 | | 37922 | 2024-11-13 05:23:28.205547+00 | 2024-11-13 05:23:28.2
22521+00 | 2024-11-13 05:23:28.223098+00 | 2024-11-13 05:23:28.223099+00 | Lock | transactionid | active | 946855695 | 946855135 | -826731047580049144 | UPDATE "api_k
ey" SET "last_used_at" = $1 WHERE "id"=$2

Naresh November 6, 2024 at 5:28 PM

Thanks for the update.

Aaditya Dubey November 6, 2024 at 4:54 PM

Hi

We will proceed further with the bug as soon as I can repeat the issue, we will keep you posted.

Naresh November 6, 2024 at 4:50 PM

Hi

I have already shared all the info in our previous conversation, but I see postgresql.log file, its continuously showing the below errors. I am not sure, how to reproduce the steps.

Aaditya Dubey November 6, 2024 at 4:36 PM

Hi

Would it be possible to share all the steps that will help us to repeat the issue so we can debug the issue further?

Details

Assignee

Reporter

Priority

Labels

Needs QA

Yes

Needs Doc

Yes

Affects versions

Smart Checklist

Created December 14, 2023 at 5:06 AM
Updated December 13, 2024 at 3:04 PM

Flag notifications