{"action":"opened","issue":{"url":"https://api.github.com/repos/tootsuite/mastodon/issues/7559","repository_url":"https://api.github.com/repos/tootsuite/mastodon","labels_url":"https://api.github.com/repos/tootsuite/mastodon/issues/7559/labels{/name}","comments_url":"https://api.github.com/repos/tootsuite/mastodon/issues/7559/comments","events_url":"https://api.github.com/repos/tootsuite/mastodon/issues/7559/events","html_url":"https://github.com/tootsuite/mastodon/issues/7559","id":324739848,"number":7559,"title":"ActiveRecord::StatementInvalid errors on 2.4.0rc4","user":{"login":"Reverite","id":515462,"avatar_url":"https://avatars2.githubusercontent.com/u/515462?v=4","gravatar_id":"","url":"https://api.github.com/users/Reverite","html_url":"https://github.com/Reverite","followers_url":"https://api.github.com/users/Reverite/followers","following_url":"https://api.github.com/users/Reverite/following{/other_user}","gists_url":"https://api.github.com/users/Reverite/gists{/gist_id}","starred_url":"https://api.github.com/users/Reverite/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Reverite/subscriptions","organizations_url":"https://api.github.com/users/Reverite/orgs","repos_url":"https://api.github.com/users/Reverite/repos","events_url":"https://api.github.com/users/Reverite/events{/privacy}","received_events_url":"https://api.github.com/users/Reverite/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-05-20T20:27:23Z","updated_at":"2018-05-20T20:27:23Z","closed_at":null,"author_association":"CONTRIBUTOR","body":"I've started to get some StatementInvalid errors for some reason, starting in 2.4.0rc4. Stack trace attached:\r\n\r\n```\r\nsidekiq_1    | 2018-05-20T20:22:44.183Z 5 TID-gtjgr08j1 WARN: ActiveRecord::StatementInvalid: PG::ProgramLimitExceeded: ERROR:  index row size 6792 exceeds maximum 2712 for index \"index_preview_cards_on_url\"\r\nsidekiq_1    | HINT:  Values larger than 1/3 of a buffer page cannot be indexed.\r\nsidekiq_1    | Consider a function index of an MD5 hash of the value, or use full text indexing.\r\nsidekiq_1    | : INSERT INTO \"preview_cards\" (\"url\", \"title\", \"created_at\", \"updated_at\") VALUES ($1, $2, $3, $4) RETURNING \"id\"\r\nsidekiq_1    | 2018-05-20T20:22:44.183Z 5 TID-gtjgr08j1 WARN: /mastodon/vendor/bundle/ruby/2.4.0/gems/activerecord-5.2.0/lib/active_record/connection_adapters/postgresql_adapter.rb:603:in `async_exec'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/activerecord-5.2.0/lib/active_record/connection_adapters/postgresql_adapter.rb:603:in `block (2 levels) in exec_no_cache'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/activesupport-5.2.0/lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/activesupport-5.2.0/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/activesupport-5.2.0/lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/activerecord-5.2.0/lib/active_record/connection_adapters/postgresql_adapter.rb:602:in `block in exec_no_cache'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/activerecord-5.2.0/lib/active_record/connection_adapters/abstract_adapter.rb:579:in `block (2 levels) in log'\r\nsidekiq_1    | /usr/local/lib/ruby/2.4.0/monitor.rb:214:in `mon_synchronize'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/activerecord-5.2.0/lib/active_record/connection_adapters/abstract_adapter.rb:578:in `block in log'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/activesupport-5.2.0/lib/active_support/notifications/instrumenter.rb:23:in `instrument'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/activerecord-5.2.0/lib/active_record/connection_adapters/abstract_adapter.rb:569:in `log'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/activerecord-5.2.0/lib/active_record/connection_adapters/postgresql_adapter.rb:601:in `exec_no_cache'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/activerecord-5.2.0/lib/active_record/connection_adapters/postgresql_adapter.rb:590:in `execute_and_clear'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/activerecord-5.2.0/lib/active_record/connection_adapters/postgresql/database_statements.rb:81:in `exec_query'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/activerecord-5.2.0/lib/active_record/connection_adapters/abstract/database_statements.rb:117:in `exec_insert'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/activerecord-5.2.0/lib/active_record/connection_adapters/postgresql/database_statements.rb:115:in `exec_insert'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/activerecord-5.2.0/lib/active_record/connection_adapters/abstract/database_statements.rb:149:in `insert'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/activerecord-5.2.0/lib/active_record/connection_adapters/abstract/query_cache.rb:21:in `insert'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/activerecord-5.2.0/lib/active_record/persistence.rb:187:in `_insert_record'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/activerecord-5.2.0/lib/active_record/persistence.rb:733:in `_create_record'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/activerecord-5.2.0/lib/active_record/counter_cache.rb:180:in `_create_record'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/activerecord-5.2.0/lib/active_record/locking/optimistic.rb:70:in `_create_record'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/activerecord-5.2.0/lib/active_record/attribute_methods/dirty.rb:137:in `_create_record'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/activerecord-5.2.0/lib/active_record/callbacks.rb:342:in `block in _create_record'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/activesupport-5.2.0/lib/active_support/callbacks.rb:132:in `run_callbacks'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/activesupport-5.2.0/lib/active_support/callbacks.rb:816:in `_run_create_callbacks'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/activerecord-5.2.0/lib/active_record/callbacks.rb:342:in `_create_record'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/activerecord-5.2.0/lib/active_record/timestamp.rb:95:in `_create_record'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/activerecord-5.2.0/lib/active_record/persistence.rb:704:in `create_or_update'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/activerecord-5.2.0/lib/active_record/callbacks.rb:338:in `block in create_or_update'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/activesupport-5.2.0/lib/active_support/callbacks.rb:132:in `run_callbacks'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/activesupport-5.2.0/lib/active_support/callbacks.rb:816:in `_run_save_callbacks'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/activerecord-5.2.0/lib/active_record/callbacks.rb:338:in `create_or_update'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/activerecord-5.2.0/lib/active_record/persistence.rb:308:in `save!'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/activerecord-5.2.0/lib/active_record/validations.rb:52:in `save!'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/activerecord-5.2.0/lib/active_record/transactions.rb:315:in `block in save!'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/activerecord-5.2.0/lib/active_record/transactions.rb:386:in `block in with_transaction_returning_status'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/activerecord-5.2.0/lib/active_record/connection_adapters/abstract/database_statements.rb:254:in `block in transaction'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/activerecord-5.2.0/lib/active_record/connection_adapters/abstract/transaction.rb:230:in `block in within_new_transaction'\r\nsidekiq_1    | /usr/local/lib/ruby/2.4.0/monitor.rb:214:in `mon_synchronize'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/activerecord-5.2.0/lib/active_record/connection_adapters/abstract/transaction.rb:227:in `within_new_transaction'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/activerecord-5.2.0/lib/active_record/connection_adapters/abstract/database_statements.rb:254:in `transaction'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/activerecord-5.2.0/lib/active_record/transactions.rb:212:in `transaction'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/activerecord-5.2.0/lib/active_record/transactions.rb:383:in `with_transaction_returning_status'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/activerecord-5.2.0/lib/active_record/transactions.rb:315:in `save!'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/activerecord-5.2.0/lib/active_record/suppressor.rb:48:in `save!'\r\nsidekiq_1    | /mastodon/app/models/preview_card.rb:49:in `save_with_optional_image!'\r\nsidekiq_1    | /mastodon/app/services/fetch_link_card_service.rb:153:in `attempt_opengraph'\r\nsidekiq_1    | /mastodon/app/services/fetch_link_card_service.rb:60:in `process_url'\r\nsidekiq_1    | /mastodon/app/services/fetch_link_card_service.rb:25:in `block in call'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/mario-redis-lock-1.2.1/lib/redis_lock.rb:44:in `acquire'\r\nsidekiq_1    | /mastodon/app/services/fetch_link_card_service.rb:22:in `call'\r\nsidekiq_1    | /mastodon/app/workers/link_crawl_worker.rb:9:in `perform'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/sidekiq-5.1.3/lib/sidekiq/processor.rb:187:in `execute_job'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/sidekiq-5.1.3/lib/sidekiq/processor.rb:169:in `block (2 levels) in process'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/sidekiq-5.1.3/lib/sidekiq/middleware/chain.rb:128:in `block in invoke'\r\nsidekiq_1    | /mastodon/app/lib/sidekiq_error_handler.rb:5:in `call'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/sidekiq-5.1.3/lib/sidekiq/middleware/chain.rb:130:in `block in invoke'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/sidekiq-unique-jobs-5.0.10/lib/sidekiq_unique_jobs/server/middleware.rb:17:in `call'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/sidekiq-5.1.3/lib/sidekiq/middleware/chain.rb:130:in `block in invoke'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/sidekiq-5.1.3/lib/sidekiq/middleware/chain.rb:133:in `invoke'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/sidekiq-5.1.3/lib/sidekiq/processor.rb:168:in `block in process'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/sidekiq-5.1.3/lib/sidekiq/processor.rb:139:in `block (6 levels) in dispatch'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/sidekiq-5.1.3/lib/sidekiq/job_retry.rb:98:in `local'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/sidekiq-5.1.3/lib/sidekiq/processor.rb:138:in `block (5 levels) in dispatch'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/sidekiq-5.1.3/lib/sidekiq/rails.rb:42:in `block in call'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/activesupport-5.2.0/lib/active_support/execution_wrapper.rb:87:in `wrap'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/activesupport-5.2.0/lib/active_support/reloader.rb:73:in `block in wrap'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/activesupport-5.2.0/lib/active_support/execution_wrapper.rb:87:in `wrap'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/activesupport-5.2.0/lib/active_support/reloader.rb:72:in `wrap'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/sidekiq-5.1.3/lib/sidekiq/rails.rb:41:in `call'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/sidekiq-5.1.3/lib/sidekiq/processor.rb:134:in `block (4 levels) in dispatch'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/sidekiq-5.1.3/lib/sidekiq/processor.rb:199:in `stats'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/sidekiq-5.1.3/lib/sidekiq/processor.rb:129:in `block (3 levels) in dispatch'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/sidekiq-5.1.3/lib/sidekiq/job_logger.rb:8:in `call'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/sidekiq-5.1.3/lib/sidekiq/processor.rb:128:in `block (2 levels) in dispatch'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/sidekiq-5.1.3/lib/sidekiq/job_retry.rb:73:in `global'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/sidekiq-5.1.3/lib/sidekiq/processor.rb:127:in `block in dispatch'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/sidekiq-5.1.3/lib/sidekiq/logging.rb:48:in `with_context'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/sidekiq-5.1.3/lib/sidekiq/logging.rb:42:in `with_job_hash_context'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/sidekiq-5.1.3/lib/sidekiq/processor.rb:126:in `dispatch'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/sidekiq-5.1.3/lib/sidekiq/processor.rb:167:in `process'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/sidekiq-5.1.3/lib/sidekiq/processor.rb:85:in `process_one'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/sidekiq-5.1.3/lib/sidekiq/processor.rb:73:in `run'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/sidekiq-5.1.3/lib/sidekiq/util.rb:16:in `watchdog'\r\nsidekiq_1    | /mastodon/vendor/bundle/ruby/2.4.0/gems/sidekiq-5.1.3/lib/sidekiq/util.rb:25:in `block in safe_thread'\r\n```\r\n\r\n* * * *\r\n\r\n- [x] I searched or browsed the repo’s other issues to ensure this is not a duplicate.\r\n- [x] This bug happens on a [tagged release](https://github.com/tootsuite/mastodon/releases) and not on `master` (If you're a user, don't worry about this).\r\n"}}
{"actor":{"display_login":"Reverite"}}