PG::DuplicatePstatement: ERROR: prepared statement already exists

[swilkinson1]

I'm running an app that is connecting to a Supabase Postgres DB, and it's hit and miss if i get the actual admin pages loading properly, or a PG::DuplicatePstatement: ERROR: prepared statement "a1" already exists error. The prepared statement number just increases when I try to reload the page (ie, a2, a3, a4, ...). But then occasionally it just starts working. Happens regardless of the view I am on (root, any dashboard, show, etc.) Any ideas of what may be causing this issue?

• Rails 7.0.8.4
• Ruby 3.3.0
• Administrate 0.20.1

Full stack trace is:

ActionView::Template::Error (PG::DuplicatePstatement: ERROR:  prepared statement "a6" already exists
):
    56:   </thead>
    57: 
    58:   <tbody>
    59:     <% resources.each do |resource| %>
    60:       <tr class="js-table-row"
    61:           <% if accessible_action?(resource, :show) %>
    62:             <%= %(tabindex=0 role=link data-url=#{polymorphic_path([namespace, resource])}) %>

activerecord (7.0.8.4) lib/active_record/connection_adapters/postgresql_adapter.rb:837:in `prepare'
activerecord (7.0.8.4) lib/active_record/connection_adapters/postgresql_adapter.rb:837:in `block in prepare_statement'
activesupport (7.0.8.4) lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `handle_interrupt'
activesupport (7.0.8.4) lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `block in synchronize'
activesupport (7.0.8.4) lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `handle_interrupt'
activesupport (7.0.8.4) lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `synchronize'
activerecord (7.0.8.4) lib/active_record/connection_adapters/postgresql_adapter.rb:832:in `prepare_statement'
activerecord (7.0.8.4) lib/active_record/connection_adapters/postgresql_adapter.rb:778:in `exec_cache'
activerecord (7.0.8.4) lib/active_record/connection_adapters/postgresql_adapter.rb:747:in `execute_and_clear'
activerecord (7.0.8.4) lib/active_record/connection_adapters/postgresql/database_statements.rb:54:in `exec_query'
activerecord (7.0.8.4) lib/active_record/connection_adapters/abstract/database_statements.rb:560:in `select'
activerecord (7.0.8.4) lib/active_record/connection_adapters/abstract/database_statements.rb:66:in `select_all'
activerecord (7.0.8.4) lib/active_record/connection_adapters/abstract/query_cache.rb:107:in `block in select_all'
activerecord (7.0.8.4) lib/active_record/connection_adapters/abstract/query_cache.rb:137:in `block in cache_sql'
activesupport (7.0.8.4) lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `handle_interrupt'
activesupport (7.0.8.4) lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `block in synchronize'
activesupport (7.0.8.4) lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `handle_interrupt'
activesupport (7.0.8.4) lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `synchronize'
activerecord (7.0.8.4) lib/active_record/connection_adapters/abstract/query_cache.rb:128:in `cache_sql'
activerecord (7.0.8.4) lib/active_record/connection_adapters/abstract/query_cache.rb:107:in `select_all'
activerecord (7.0.8.4) lib/active_record/querying.rb:54:in `_query_by_sql'
activerecord (7.0.8.4) lib/active_record/relation.rb:942:in `block in exec_main_query'
activerecord (7.0.8.4) lib/active_record/relation.rb:962:in `skip_query_cache_if_necessary'
activerecord (7.0.8.4) lib/active_record/relation.rb:928:in `exec_main_query'
activerecord (7.0.8.4) lib/active_record/relation.rb:914:in `block in exec_queries'
activerecord (7.0.8.4) lib/active_record/relation.rb:962:in `skip_query_cache_if_necessary'
activerecord (7.0.8.4) lib/active_record/relation.rb:908:in `exec_queries'
activerecord (7.0.8.4) lib/active_record/relation.rb:695:in `load'
activerecord (7.0.8.4) lib/active_record/relation.rb:250:in `records'
activerecord (7.0.8.4) lib/active_record/relation/delegation.rb:88:in `each'
administrate (0.20.1) app/views/administrate/application/_collection.html.erb:59
actionview (7.0.8.4) lib/action_view/base.rb:244:in `public_send'
actionview (7.0.8.4) lib/action_view/base.rb:244:in `_run'
actionview (7.0.8.4) lib/action_view/template.rb:157:in `block in render'
activesupport (7.0.8.4) lib/active_support/notifications.rb:208:in `instrument'
actionview (7.0.8.4) lib/action_view/template.rb:361:in `instrument_render_template'
actionview (7.0.8.4) lib/action_view/template.rb:155:in `render'
actionview (7.0.8.4) lib/action_view/renderer/partial_renderer.rb:251:in `block in render_partial_template'
activesupport (7.0.8.4) lib/active_support/notifications.rb:206:in `block in instrument'
activesupport (7.0.8.4) lib/active_support/notifications/instrumenter.rb:24:in `instrument'
activesupport (7.0.8.4) lib/active_support/notifications.rb:206:in `instrument'
actionview (7.0.8.4) lib/action_view/renderer/partial_renderer.rb:246:in `render_partial_template'
actionview (7.0.8.4) lib/action_view/renderer/partial_renderer.rb:237:in `render'
actionview (7.0.8.4) lib/action_view/renderer/renderer.rb:81:in `render_partial_to_object'
actionview (7.0.8.4) lib/action_view/renderer/renderer.rb:53:in `render_partial'
actionview (7.0.8.4) lib/action_view/helpers/rendering_helper.rb:44:in `render'
administrate (0.20.1) app/views/administrate/application/index.html.erb:36
actionview (7.0.8.4) lib/action_view/base.rb:244:in `public_send'
actionview (7.0.8.4) lib/action_view/base.rb:244:in `_run'
actionview (7.0.8.4) lib/action_view/template.rb:157:in `block in render'
activesupport (7.0.8.4) lib/active_support/notifications.rb:208:in `instrument'
actionview (7.0.8.4) lib/action_view/template.rb:361:in `instrument_render_template'
actionview (7.0.8.4) lib/action_view/template.rb:155:in `render'
actionview (7.0.8.4) lib/action_view/renderer/template_renderer.rb:65:in `block (2 levels) in render_template'
activesupport (7.0.8.4) lib/active_support/notifications.rb:206:in `block in instrument'
activesupport (7.0.8.4) lib/active_support/notifications/instrumenter.rb:24:in `instrument'
activesupport (7.0.8.4) lib/active_support/notifications.rb:206:in `instrument'
actionview (7.0.8.4) lib/action_view/renderer/template_renderer.rb:60:in `block in render_template'
actionview (7.0.8.4) lib/action_view/renderer/template_renderer.rb:75:in `block in render_with_layout'
activesupport (7.0.8.4) lib/active_support/notifications.rb:206:in `block in instrument'
activesupport (7.0.8.4) lib/active_support/notifications/instrumenter.rb:24:in `instrument'
activesupport (7.0.8.4) lib/active_support/notifications.rb:206:in `instrument'
actionview (7.0.8.4) lib/action_view/renderer/template_renderer.rb:74:in `render_with_layout'
actionview (7.0.8.4) lib/action_view/renderer/template_renderer.rb:59:in `render_template'
actionview (7.0.8.4) lib/action_view/renderer/template_renderer.rb:11:in `render'
actionview (7.0.8.4) lib/action_view/renderer/renderer.rb:61:in `render_template_to_object'
actionview (7.0.8.4) lib/action_view/renderer/renderer.rb:29:in `render_to_object'
actionview (7.0.8.4) lib/action_view/rendering.rb:117:in `block in _render_template'
actionview (7.0.8.4) lib/action_view/base.rb:270:in `in_rendering_context'
actionview (7.0.8.4) lib/action_view/rendering.rb:116:in `_render_template'
actionpack (7.0.8.4) lib/action_controller/metal/streaming.rb:216:in `_render_template'
actionview (7.0.8.4) lib/action_view/rendering.rb:103:in `render_to_body'
actionpack (7.0.8.4) lib/action_controller/metal/rendering.rb:158:in `render_to_body'
actionpack (7.0.8.4) lib/action_controller/metal/renderers.rb:141:in `render_to_body'
actionpack (7.0.8.4) lib/abstract_controller/rendering.rb:27:in `render'
actionpack (7.0.8.4) lib/action_controller/metal/rendering.rb:139:in `render'
actionpack (7.0.8.4) lib/action_controller/metal/instrumentation.rb:22:in `block (2 levels) in render'
/Users/Simon/.rbenv/versions/3.3.0/lib/ruby/3.3.0/benchmark.rb:313:in `realtime'
activesupport (7.0.8.4) lib/active_support/core_ext/benchmark.rb:14:in `ms'
actionpack (7.0.8.4) lib/action_controller/metal/instrumentation.rb:22:in `block in render'
actionpack (7.0.8.4) lib/action_controller/metal/instrumentation.rb:91:in `cleanup_view_runtime'
activerecord (7.0.8.4) lib/active_record/railties/controller_runtime.rb:34:in `cleanup_view_runtime'
actionpack (7.0.8.4) lib/action_controller/metal/instrumentation.rb:21:in `render'
administrate (0.20.1) app/controllers/administrate/application_controller.rb:14:in `index'
actionpack (7.0.8.4) lib/action_controller/metal/basic_implicit_render.rb:6:in `send_action'
actionpack (7.0.8.4) lib/abstract_controller/base.rb:215:in `process_action'
actionpack (7.0.8.4) lib/action_controller/metal/rendering.rb:165:in `process_action'
actionpack (7.0.8.4) lib/abstract_controller/callbacks.rb:234:in `block in process_action'
activesupport (7.0.8.4) lib/active_support/callbacks.rb:118:in `block in run_callbacks'
turbo-rails (2.0.5) lib/turbo-rails.rb:24:in `with_request_id'
turbo-rails (2.0.5) app/controllers/concerns/turbo/request_id_tracking.rb:10:in `turbo_tracking_request_id'
activesupport (7.0.8.4) lib/active_support/callbacks.rb:127:in `block in run_callbacks'
actiontext (7.0.8.4) lib/action_text/rendering.rb:20:in `with_renderer'
actiontext (7.0.8.4) lib/action_text/engine.rb:69:in `block (4 levels) in <class:Engine>'
activesupport (7.0.8.4) lib/active_support/callbacks.rb:127:in `instance_exec'
activesupport (7.0.8.4) lib/active_support/callbacks.rb:127:in `block in run_callbacks'
activesupport (7.0.8.4) lib/active_support/callbacks.rb:138:in `run_callbacks'
actionpack (7.0.8.4) lib/abstract_controller/callbacks.rb:233:in `process_action'
actionpack (7.0.8.4) lib/action_controller/metal/rescue.rb:23:in `process_action'
actionpack (7.0.8.4) lib/action_controller/metal/instrumentation.rb:67:in `block in process_action'
activesupport (7.0.8.4) lib/active_support/notifications.rb:206:in `block in instrument'
activesupport (7.0.8.4) lib/active_support/notifications/instrumenter.rb:24:in `instrument'
activesupport (7.0.8.4) lib/active_support/notifications.rb:206:in `instrument'
actionpack (7.0.8.4) lib/action_controller/metal/instrumentation.rb:66:in `process_action'
actionpack (7.0.8.4) lib/action_controller/metal/params_wrapper.rb:259:in `process_action'
activerecord (7.0.8.4) lib/active_record/railties/controller_runtime.rb:27:in `process_action'
actionpack (7.0.8.4) lib/abstract_controller/base.rb:151:in `process'
actionview (7.0.8.4) lib/action_view/rendering.rb:39:in `process'
actionpack (7.0.8.4) lib/action_controller/metal.rb:188:in `dispatch'
actionpack (7.0.8.4) lib/action_controller/metal.rb:251:in `dispatch'
actionpack (7.0.8.4) lib/action_dispatch/routing/route_set.rb:49:in `dispatch'
actionpack (7.0.8.4) lib/action_dispatch/routing/route_set.rb:32:in `serve'
actionpack (7.0.8.4) lib/action_dispatch/journey/router.rb:50:in `block in serve'
actionpack (7.0.8.4) lib/action_dispatch/journey/router.rb:32:in `each'
actionpack (7.0.8.4) lib/action_dispatch/journey/router.rb:32:in `serve'
actionpack (7.0.8.4) lib/action_dispatch/routing/route_set.rb:852:in `call'
rack (2.2.9) lib/rack/tempfile_reaper.rb:15:in `call'
rack (2.2.9) lib/rack/etag.rb:27:in `call'
rack (2.2.9) lib/rack/conditional_get.rb:27:in `call'
rack (2.2.9) lib/rack/head.rb:12:in `call'
actionpack (7.0.8.4) lib/action_dispatch/http/permissions_policy.rb:38:in `call'
actionpack (7.0.8.4) lib/action_dispatch/http/content_security_policy.rb:36:in `call'
rack (2.2.9) lib/rack/session/abstract/id.rb:266:in `context'
rack (2.2.9) lib/rack/session/abstract/id.rb:260:in `call'
actionpack (7.0.8.4) lib/action_dispatch/middleware/cookies.rb:704:in `call'
activerecord (7.0.8.4) lib/active_record/migration.rb:638:in `call'
actionpack (7.0.8.4) lib/action_dispatch/middleware/callbacks.rb:27:in `block in call'
activesupport (7.0.8.4) lib/active_support/callbacks.rb:99:in `run_callbacks'
actionpack (7.0.8.4) lib/action_dispatch/middleware/callbacks.rb:26:in `call'
actionpack (7.0.8.4) lib/action_dispatch/middleware/executor.rb:14:in `call'
actionpack (7.0.8.4) lib/action_dispatch/middleware/actionable_exceptions.rb:17:in `call'
actionpack (7.0.8.4) lib/action_dispatch/middleware/debug_exceptions.rb:28:in `call'
web-console (4.2.1) lib/web_console/middleware.rb:132:in `call_app'
web-console (4.2.1) lib/web_console/middleware.rb:28:in `block in call'
web-console (4.2.1) lib/web_console/middleware.rb:17:in `catch'
web-console (4.2.1) lib/web_console/middleware.rb:17:in `call'
actionpack (7.0.8.4) lib/action_dispatch/middleware/show_exceptions.rb:29:in `call'
railties (7.0.8.4) lib/rails/rack/logger.rb:40:in `call_app'
railties (7.0.8.4) lib/rails/rack/logger.rb:25:in `block in call'
activesupport (7.0.8.4) lib/active_support/tagged_logging.rb:99:in `block in tagged'
activesupport (7.0.8.4) lib/active_support/tagged_logging.rb:37:in `tagged'
activesupport (7.0.8.4) lib/active_support/tagged_logging.rb:99:in `tagged'
railties (7.0.8.4) lib/rails/rack/logger.rb:25:in `call'
sprockets-rails (3.5.1) lib/sprockets/rails/quiet_assets.rb:17:in `call'
actionpack (7.0.8.4) lib/action_dispatch/middleware/remote_ip.rb:93:in `call'
actionpack (7.0.8.4) lib/action_dispatch/middleware/request_id.rb:26:in `call'
rack (2.2.9) lib/rack/method_override.rb:24:in `call'
rack (2.2.9) lib/rack/runtime.rb:22:in `call'
activesupport (7.0.8.4) lib/active_support/cache/strategy/local_cache_middleware.rb:29:in `call'
actionpack (7.0.8.4) lib/action_dispatch/middleware/server_timing.rb:61:in `block in call'
actionpack (7.0.8.4) lib/action_dispatch/middleware/server_timing.rb:26:in `collect_events'
actionpack (7.0.8.4) lib/action_dispatch/middleware/server_timing.rb:60:in `call'
actionpack (7.0.8.4) lib/action_dispatch/middleware/executor.rb:14:in `call'
actionpack (7.0.8.4) lib/action_dispatch/middleware/static.rb:23:in `call'
rack (2.2.9) lib/rack/sendfile.rb:110:in `call'
actionpack (7.0.8.4) lib/action_dispatch/middleware/host_authorization.rb:138:in `call'
railties (7.0.8.4) lib/rails/engine.rb:530:in `call'
puma (5.6.8) lib/puma/configuration.rb:252:in `call'
puma (5.6.8) lib/puma/request.rb:77:in `block in handle_request'
puma (5.6.8) lib/puma/thread_pool.rb:340:in `with_force_shutdown'
puma (5.6.8) lib/puma/request.rb:76:in `handle_request'
puma (5.6.8) lib/puma/server.rb:443:in `process_client'
puma (5.6.8) lib/puma/thread_pool.rb:147:in `block in spawn_thread'