Describe the bug
There was an exception on our error tracking.
More information: https://sentry.io/share/issue/360e525ec8e44396bbd5fa1642f6c721/
Expected behavior
We shouldn't have exceptions nor errors 500 on production environment.
Stacktrace
PG::ProgramLimitExceeded: ERROR: index row size 4848 exceeds maximum 2712 for index "decidim_proposals_proposal_body_search"
HINT: Values larger than 1/3 of a buffer page cannot be indexed.
Consider a function index of an MD5 hash of the value, or use full text indexing.
active_record/connection_adapters/postgresql_adapter.rb:603:in async_exec' @connection.async_exec(sql, type_casted_binds) active_record/connection_adapters/postgresql_adapter.rb:603:in block (2 levels) in exec_no_cache'
@connection.async_exec(sql, type_casted_binds)
active_support/dependencies/interlock.rb:48:in block in permit_concurrent_loads' yield active_support/concurrency/share_lock.rb:187:in yield_shares'
yield
active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'
@lock.yield_shares(compatible: [:load]) do
...
Extra data (please complete the following information):
Device: Desktop
Device OS: Ubuntu
Browser: Firefox 62.0
Decidim Version: 0.14
Decidim installation: Decidim Barcelona
Describe the bug
There was an exception on our error tracking.
More information: https://sentry.io/share/issue/360e525ec8e44396bbd5fa1642f6c721/
Expected behavior
We shouldn't have exceptions nor errors 500 on production environment.
Stacktrace
PG::ProgramLimitExceeded: ERROR: index row size 4848 exceeds maximum 2712 for index "decidim_proposals_proposal_body_search"
HINT: Values larger than 1/3 of a buffer page cannot be indexed.
Consider a function index of an MD5 hash of the value, or use full text indexing.
active_record/connection_adapters/postgresql_adapter.rb:603:in
async_exec' @connection.async_exec(sql, type_casted_binds) active_record/connection_adapters/postgresql_adapter.rb:603:inblock (2 levels) in exec_no_cache'@connection.async_exec(sql, type_casted_binds)
active_support/dependencies/interlock.rb:48:in
block in permit_concurrent_loads' yield active_support/concurrency/share_lock.rb:187:inyield_shares'yield
active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'
@lock.yield_shares(compatible: [:load]) do
...
Extra data (please complete the following information):
Device: Desktop
Device OS: Ubuntu
Browser: Firefox 62.0
Decidim Version: 0.14
Decidim installation: Decidim Barcelona