Errors for sequences

[mhenrixon]

So, on our staging environment it looks like sequences prevents the dashboard from loading at all. After some debugging with Claude Opus, I was able to replicate it with:

PgHero.databases[:primary].sequences

(wm):12:in '<main>': PG::SyntaxError: ERROR:  Error decoding result: failed to decode Protobuf message: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: Node.node: RawStmt.stmt: ParseResult.stmts: recursion limit reached (ActiveRecord::StatementInvalid)
/usr/local/bundle/ruby/3.4.0/gems/activerecord-8.0.2/lib/active_record/connection_adapters/postgresql/database_statements.rb:160:in 'PG::Connection#exec': ERROR:  Error decoding result: failed to decode Protobuf message: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: SelectStmt.larg: Node.node: RawStmt.stmt: ParseResult.stmts: recursion limit reached (PG::SyntaxError)
	from /usr/local/bundle/ruby/3.4.0/gems/activerecord-8.0.2/lib/active_record/connection_adapters/postgresql/database_statements.rb:160:in 'ActiveRecord::ConnectionAdapters::PostgreSQL::DatabaseStatements#perform_query'
	from /usr/local/bundle/ruby/3.4.0/gems/activerecord-8.0.2/lib/active_record/connection_adapters/abstract/database_statements.rb:556:in 'block (2 levels) in ActiveRecord::ConnectionAdapters::DatabaseStatements#raw_execute'
	from /usr/local/bundle/ruby/3.4.0/gems/activerecord-8.0.2/lib/active_record/connection_adapters/abstract_adapter.rb:1015:in 'block in ActiveRecord::ConnectionAdapters::AbstractAdapter#with_raw_connection'
	from /usr/local/bundle/ruby/3.4.0/gems/activesupport-8.0.2/lib/active_support/concurrency/null_lock.rb:9:in 'ActiveSupport::Concurrency::NullLock#synchronize'
	from /usr/local/bundle/ruby/3.4.0/gems/activerecord-8.0.2/lib/active_record/connection_adapters/abstract_adapter.rb:984:in 'ActiveRecord::ConnectionAdapters::AbstractAdapter#with_raw_connection'
	from /usr/local/bundle/ruby/3.4.0/gems/activerecord-8.0.2/lib/active_record/connection_adapters/abstract/database_statements.rb:555:in 'block in ActiveRecord::ConnectionAdapters::DatabaseStatements#raw_execute'
	from /usr/local/bundle/ruby/3.4.0/gems/activesupport-8.0.2/lib/active_support/notifications/instrumenter.rb:58:in 'ActiveSupport::Notifications::Instrumenter#instrument'
	from /usr/local/bundle/ruby/3.4.0/gems/activerecord-8.0.2/lib/active_record/connection_adapters/abstract_adapter.rb:1135:in 'ActiveRecord::ConnectionAdapters::AbstractAdapter#log'
	from /usr/local/bundle/ruby/3.4.0/gems/activerecord-8.0.2/lib/active_record/connection_adapters/abstract/database_statements.rb:554:in 'ActiveRecord::ConnectionAdapters::DatabaseStatements#raw_execute'
	from /usr/local/bundle/ruby/3.4.0/gems/activerecord-8.0.2/lib/active_record/connection_adapters/abstract/database_statements.rb:591:in 'ActiveRecord::ConnectionAdapters::DatabaseStatements#internal_execute'
	from /usr/local/bundle/ruby/3.4.0/gems/activerecord-8.0.2/lib/active_record/connection_adapters/abstract/database_statements.rb:547:in 'ActiveRecord::ConnectionAdapters::DatabaseStatements#internal_exec_query'
	from /usr/local/bundle/ruby/3.4.0/gems/activerecord-8.0.2/lib/active_record/connection_adapters/abstract/database_statements.rb:693:in 'ActiveRecord::ConnectionAdapters::DatabaseStatements#select'
	from /usr/local/bundle/ruby/3.4.0/gems/activerecord-8.0.2/lib/active_record/connection_adapters/abstract/database_statements.rb:73:in 'ActiveRecord::ConnectionAdapters::DatabaseStatements#select_all'
	from /usr/local/bundle/ruby/3.4.0/gems/activerecord-8.0.2/lib/active_record/connection_adapters/abstract/query_cache.rb:251:in 'ActiveRecord::ConnectionAdapters::QueryCache#select_all'
	from /usr/local/bundle/ruby/3.4.0/gems/pghero-3.7.0/lib/pghero/methods/basic.rb:49:in 'PgHero::Methods::Basic#select_all_leased'
	from /usr/local/bundle/ruby/3.4.0/gems/pghero-3.7.0/lib/pghero/methods/basic.rb:41:in 'block in PgHero::Methods::Basic#select_all'
	... 39 levels...

Question is, can I disable just the sequences somehow?

[ankane]

Hi @mhenrixon, I'm not sure how to reproduce the error (Postgres doesn't use protocol buffers, so it may be caused by an extension).

[mhenrixon]

What extension? I dont have any extensions loaded apart from hatore and pg stat statements and nothing uses protobuf on our side so where would it be coming from?