# Falha na exportação de dados do usuário (transação abortada)
**URL:** https://meta.discourse.org/t/user-data-export-failing-transaction-aborted/165838
**Category:** Support
**Created:** [Setembro 30, 2020, 10:47am UTC](https://meta.discourse.org/t/user-data-export-failing-transaction-aborted/165838 "2020-09-30T10:47:16Z")
**Posts on this page:** 10
**Page:** 1
### Author:  [@piratdavid](https://meta.discourse.org/u/piratdavid)
#### Post date: [Setembro 30, 2020, 10:47am UTC](https://meta.discourse.org/t/user-data-export-failing-transaction-aborted/165838/1 "2020-09-30T10:47:16Z")
Olá!
Esse plugin está quebrado na versão estável mais recente (2.5.2)? Estou recebendo:
> Exceção de Job: PG::InFailedSqlTransaction: ERRO: transação atual foi abortada, comandos ignorados até o final do bloco de transação
David
---
### Author:  [@RGJ](https://meta.discourse.org/u/RGJ)
#### Post date: [Setembro 30, 2020, 12:03pm UTC](https://meta.discourse.org/t/user-data-export-failing-transaction-aborted/165838/2 "2020-09-30T12:03:12Z")
Funciona para mim na versão 2.5.2.
Você poderia detalhar o que está fazendo quando recebe esse erro?
---
### Author:  [@piratdavid](https://meta.discourse.org/u/piratdavid)
#### Post date: [Setembro 30, 2020, 2:31pm UTC](https://meta.discourse.org/t/user-data-export-failing-transaction-aborted/165838/3 "2020-09-30T14:31:47Z")
Recebo este erro ao tentar baixar os dados de um usuário. A instalação está em um servidor de teste auto-hospedado e o envio de e-mails está desativado para membros que não são da equipe. Atualizei a versão durante a instalação. Foi solicitado que eu atualizasse o Postgres, mas optei por não fazê-lo, apontando para outro arquivo de modelo em app.yml, conforme sugerido ao executar a instalação.
---
### Author:  [@RGJ](https://meta.discourse.org/u/RGJ)
#### Post date: [Setembro 30, 2020, 2:37pm UTC](https://meta.discourse.org/t/user-data-export-failing-transaction-aborted/165838/4 "2020-09-30T14:37:12Z")
Duvido que isso esteja sendo causado por este plugin.
Há [mais alguns relatórios sobre esse erro do PG](https://meta.discourse.org/search?q=InFailedSqlTransaction) e acho que se trata de algo genérico do tipo ‘seu banco de dados está com algum problema’.
---
### Author:  [@piratdavid](https://meta.discourse.org/u/piratdavid)
#### Post date: [Setembro 30, 2020, 2:41pm UTC](https://meta.discourse.org/t/user-data-export-failing-transaction-aborted/165838/5 "2020-09-30T14:41:44Z")
OK. Tenho vários plugins desenvolvidos por mim que fazem inserções em campos personalizados, mas não vejo como o banco de dados poderia ser danificado por isso. Tudo feito corretamente.
---
### Author:  [@piratdavid](https://meta.discourse.org/u/piratdavid)
#### Post date: [Setembro 30, 2020, 2:43pm UTC](https://meta.discourse.org/t/user-data-export-failing-transaction-aborted/165838/6 "2020-09-30T14:43:06Z")
Mas obrigado pelo link, vou me informar sobre esse erro.
---
### Author:  [@riking](https://meta.discourse.org/u/riking)
#### Post date: [Setembro 30, 2020, 3:16pm UTC](https://meta.discourse.org/t/user-data-export-failing-transaction-aborted/165838/7 "2020-09-30T15:16:50Z")
Você pode postar também o backtrace e o nome do job do erro?
---
### Author:  [@piratdavid](https://meta.discourse.org/u/piratdavid)
#### Post date: [Outubro 1, 2020, 6:40am UTC](https://meta.discourse.org/t/user-data-export-failing-transaction-aborted/165838/8 "2020-10-01T06:40:33Z")
Trabalho
> Jobs::ExportCsvFile
Rastreamento de volta
```
rack-mini-profiler-2.0.2/lib/patches/db/pg.rb:69:in `exec_params'
rack-mini-profiler-2.0.2/lib/patches/db/pg.rb:69:in `exec_params'
activerecord-6.0.3.1/lib/active_record/connection_adapters/postgresql_adapter.rb:675:in `block (2 levels) in exec_no_cache'
activesupport-6.0.3.1/lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'
activesupport-6.0.3.1/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
activesupport-6.0.3.1/lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'
activerecord-6.0.3.1/lib/active_record/connection_adapters/postgresql_adapter.rb:674:in `block in exec_no_cache'
activerecord-6.0.3.1/lib/active_record/connection_adapters/abstract_adapter.rb:722:in `block (2 levels) in log'
activesupport-6.0.3.1/lib/active_support/concurrency/load_interlock_aware_monitor.rb:26:in `block (2 levels) in synchronize'
activesupport-6.0.3.1/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `handle_interrupt'
activesupport-6.0.3.1/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `block in synchronize'
activesupport-6.0.3.1/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `handle_interrupt'
activesupport-6.0.3.1/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `synchronize'
activerecord-6.0.3.1/lib/active_record/connection_adapters/abstract_adapter.rb:721:in `block in log'
activesupport-6.0.3.1/lib/active_support/notifications/instrumenter.rb:24:in `instrument'
activerecord-6.0.3.1/lib/active_record/connection_adapters/abstract_adapter.rb:712:in `log'
activerecord-6.0.3.1/lib/active_record/connection_adapters/postgresql_adapter.rb:673:in `exec_no_cache'
activerecord-6.0.3.1/lib/active_record/connection_adapters/postgresql_adapter.rb:654:in `execute_and_clear'
activerecord-6.0.3.1/lib/active_record/connection_adapters/postgresql/database_statements.rb:98:in `exec_query'
activerecord-6.0.3.1/lib/active_record/connection_adapters/abstract/database_statements.rb:489:in `select'
activerecord-6.0.3.1/lib/active_record/connection_adapters/abstract/database_statements.rb:70:in `select_all'
activerecord-6.0.3.1/lib/active_record/connection_adapters/abstract/query_cache.rb:107:in `select_all'
activerecord-6.0.3.1/lib/active_record/querying.rb:46:in `find_by_sql'
activerecord-6.0.3.1/lib/active_record/statement_cache.rb:134:in `execute'
activerecord-6.0.3.1/lib/active_record/core.rb:204:in `find_by'
/var/www/discourse/app/models/concerns/has_url.rb:34:in `get_from_url'
/var/www/discourse/app/models/topic_link.rb:271:in `ensure_entry_for'
/var/www/discourse/app/models/topic_link.rb:128:in `block (2 levels) in extract_from'
activerecord-6.0.3.1/lib/active_record/connection_adapters/abstract/database_statements.rb:278:in `transaction'
activerecord-6.0.3.1/lib/active_record/transactions.rb:212:in `transaction'
/var/www/discourse/app/models/topic_link.rb:126:in `block in extract_from'
/var/www/discourse/app/models/topic_link.rb:124:in `each'
/var/www/discourse/app/models/topic_link.rb:124:in `extract_from'
/var/www/discourse/lib/post_creator.rb:576:in `extract_links'
/var/www/discourse/lib/post_creator.rb:180:in `block in create'
/var/www/discourse/lib/post_creator.rb:359:in `block in transaction'
activerecord-6.0.3.1/lib/active_record/connection_adapters/abstract/database_statements.rb:280:in `block in transaction'
activerecord-6.0.3.1/lib/active_record/connection_adapters/abstract/transaction.rb:280:in `block in within_new_transaction'
activesupport-6.0.3.1/lib/active_support/concurrency/load_interlock_aware_monitor.rb:26:in `block (2 levels) in synchronize'
activesupport-6.0.3.1/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `handle_interrupt'
activesupport-6.0.3.1/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `block in synchronize'
activesupport-6.0.3.1/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `handle_interrupt'
activesupport-6.0.3.1/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `synchronize'
activerecord-6.0.3.1/lib/active_record/connection_adapters/abstract/transaction.rb:278:in `within_new_transaction'
activerecord-6.0.3.1/lib/active_record/connection_adapters/abstract/database_statements.rb:280:in `transaction'
activerecord-6.0.3.1/lib/active_record/transactions.rb:212:in `transaction'
/var/www/discourse/lib/post_creator.rb:358:in `transaction'
/var/www/discourse/lib/post_creator.rb:174:in `create'
/var/www/discourse/lib/system_message.rb:44:in `block in create'
i18n-1.8.3/lib/i18n.rb:313:in `with_locale'
/var/www/discourse/lib/system_message.rb:44:in `create'
/var/www/discourse/lib/system_message.rb:13:in `create_from_system_user'
/var/www/discourse/app/jobs/regular/export_csv_file.rb:471:in `notify_user'
/var/www/discourse/app/jobs/regular/export_csv_file.rb:102:in `execute'
/var/www/discourse/app/jobs/base.rb:232:in `block (2 levels) in perform'
rails_multisite-2.3.0/lib/rails_multisite/connection_management.rb:68:in `with_connection'
/var/www/discourse/app/jobs/base.rb:221:in `block in perform'
/var/www/discourse/app/jobs/base.rb:217:in `each'
/var/www/discourse/app/jobs/base.rb:217:in `perform'
sidekiq-6.0.7/lib/sidekiq/processor.rb:196:in `execute_job'
sidekiq-6.0.7/lib/sidekiq/processor.rb:164:in `block (2 levels) in process'
sidekiq-6.0.7/lib/sidekiq/middleware/chain.rb:138:in `block in invoke'
/var/www/discourse/lib/sidekiq/pausable.rb:138:in `call'
sidekiq-6.0.7/lib/sidekiq/middleware/chain.rb:140:in `block in invoke'
sidekiq-6.0.7/lib/sidekiq/middleware/chain.rb:143:in `invoke'
sidekiq-6.0.7/lib/sidekiq/processor.rb:163:in `block in process'
sidekiq-6.0.7/lib/sidekiq/processor.rb:136:in `block (6 levels) in dispatch'
sidekiq-6.0.7/lib/sidekiq/job_retry.rb:111:in `local'
sidekiq-6.0.7/lib/sidekiq/processor.rb:135:in `block (5 levels) in dispatch'
sidekiq-6.0.7/lib/sidekiq.rb:37:in `block in '
sidekiq-6.0.7/lib/sidekiq/processor.rb:131:in `block (4 levels) in dispatch'
sidekiq-6.0.7/lib/sidekiq/processor.rb:257:in `stats'
sidekiq-6.0.7/lib/sidekiq/processor.rb:126:in `block (3 levels) in dispatch'
sidekiq-6.0.7/lib/sidekiq/job_logger.rb:13:in `call'
sidekiq-6.0.7/lib/sidekiq/processor.rb:125:in `block (2 levels) in dispatch'
sidekiq-6.0.7/lib/sidekiq/job_retry.rb:78:in `global'
sidekiq-6.0.7/lib/sidekiq/processor.rb:124:in `block in dispatch'
sidekiq-6.0.7/lib/sidekiq/logger.rb:10:in `with'
sidekiq-6.0.7/lib/sidekiq/job_logger.rb:33:in `prepare'
sidekiq-6.0.7/lib/sidekiq/processor.rb:123:in `dispatch'
sidekiq-6.0.7/lib/sidekiq/processor.rb:162:in `process'
sidekiq-6.0.7/lib/sidekiq/processor.rb:78:in `process_one'
sidekiq-6.0.7/lib/sidekiq/processor.rb:68:in `run'
sidekiq-6.0.7/lib/sidekiq/util.rb:15:in `watchdog'
sidekiq-6.0.7/lib/sidekiq/util.rb:24:in `block in safe_thread'
```
---
### Author:  [@piratdavid](https://meta.discourse.org/u/piratdavid)
#### Post date: [Outubro 15, 2020, 3:29pm UTC](https://meta.discourse.org/t/user-data-export-failing-transaction-aborted/165838/9 "2020-10-15T15:29:49Z")
Desinstalei todos os plugins para ver se conseguia resolver, mas o erro persiste. Tem mais alguma ideia do que poderia estar errado? Você está dizendo que o banco de dados está corrompido; isso pode ser corrigido de alguma forma? Fazer backup, excluir e restaurar, talvez?
---
### Author:  [@angus](https://meta.discourse.org/u/angus)
#### Post date: [Outubro 16, 2020, 3:06am UTC](https://meta.discourse.org/t/user-data-export-failing-transaction-aborted/165838/10 "2020-10-16T03:06:10Z")
Isso não tem relação com o plugin de ferramentas legais, pois ele não (e não poderia) alterar nenhum dado no banco de dados. Ele apenas lê dados com base em tabelas e colunas padrão.
@piratdavid Quais outros plugins você tinha instalados? Posso ajudá-lo ainda mais se você se sentir confortável em enviar um dump dos dados para [angus@thepavilion.io](mailto:angus@thepavilion.io).