yeti-web icon indicating copy to clipboard operation
yeti-web copied to clipboard

Destination import PG::NotNullViolation: ERROR: null value in column "enabled"

Open dmitry-sinina opened this issue 4 years ago • 0 comments

PG::NotNullViolation: ERROR: null value in column "enabled" of relation "destinations" violates not-null constraint DETAIL: Failing row contains (4201704, null, 67572, 26, 0.47, 0.0, 60, 60, 0, 0, 1, 0.47, f, f, 2020-11-23 12:18:00+00, 2025-11-23 12:18:00+00, null, 16973, null, 0, 0, 0.5, f, b413ab61-c873-11eb-99d1-0a5813a3d01a, 11, 11, f, {}, 0). : INSERT INTO "class4"."destinations" ("prefix", "rate_group_id", "next_rate", "initial_interval", "next_interval", "initial_rate", "valid_from", "valid_till", "network_prefix_id", "short_calls_limit", "dst_number_min_length", "dst_number_max_length") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12) RETURNING "id" /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.5/lib/active_record/connection_adapters/postgresql_adapter.rb:611:in `async_exec' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.5/lib/active_record/connection_adapters/postgresql_adapter.rb:611:in `block (2 levels) in exec_no_cache' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.4.5/lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.4.5/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.4.5/lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.5/lib/active_record/connection_adapters/postgresql_adapter.rb:610:in `block in exec_no_cache' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.5/lib/active_record/connection_adapters/abstract_adapter.rb:581:in `block (2 levels) in log' /usr/lib/ruby/2.6.0/monitor.rb:235:in `mon_synchronize' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.5/lib/active_record/connection_adapters/abstract_adapter.rb:580:in `block in log' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.4.5/lib/active_support/notifications/instrumenter.rb:23:in `instrument' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.5/lib/active_record/connection_adapters/abstract_adapter.rb:571:in `log' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.5/lib/active_record/connection_adapters/postgresql_adapter.rb:609:in `exec_no_cache' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.5/lib/active_record/connection_adapters/postgresql_adapter.rb:598:in `execute_and_clear' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.5/lib/active_record/connection_adapters/postgresql/database_statements.rb:81:in `exec_query' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.5/lib/active_record/connection_adapters/abstract/database_statements.rb:130:in `exec_insert' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.5/lib/active_record/connection_adapters/postgresql/database_statements.rb:115:in `exec_insert' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.5/lib/active_record/connection_adapters/abstract/database_statements.rb:162:in `insert' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.5/lib/active_record/connection_adapters/abstract/query_cache.rb:21:in `insert' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.5/lib/active_record/persistence.rb:187:in `_insert_record' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.5/lib/active_record/persistence.rb:734:in `_create_record' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.5/lib/active_record/counter_cache.rb:184:in `_create_record' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.5/lib/active_record/locking/optimistic.rb:70:in `_create_record' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.5/lib/active_record/attribute_methods/dirty.rb:140:in `_create_record' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.5/lib/active_record/callbacks.rb:346:in `block in _create_record' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.4.5/lib/active_support/callbacks.rb:132:in `run_callbacks' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.4.5/lib/active_support/callbacks.rb:816:in `_run_create_callbacks' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.5/lib/active_record/callbacks.rb:346:in `_create_record' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.5/lib/active_record/timestamp.rb:102:in `_create_record' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.5/lib/active_record/persistence.rb:705:in `create_or_update' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.5/lib/active_record/callbacks.rb:342:in `block in create_or_update' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.4.5/lib/active_support/callbacks.rb:132:in `run_callbacks' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.4.5/lib/active_support/callbacks.rb:816:in `_run_save_callbacks' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.5/lib/active_record/callbacks.rb:342:in `create_or_update' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.5/lib/active_record/persistence.rb:308:in `save!' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.5/lib/active_record/validations.rb:52:in `save!' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.5/lib/active_record/transactions.rb:315:in `block in save!' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.5/lib/active_record/transactions.rb:387:in `block in with_transaction_returning_status' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.5/lib/active_record/connection_adapters/abstract/database_statements.rb:265:in `transaction' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.5/lib/active_record/transactions.rb:212:in `transaction' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.5/lib/active_record/transactions.rb:385:in `with_transaction_returning_status' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.5/lib/active_record/transactions.rb:315:in `save!' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.5/lib/active_record/suppressor.rb:48:in `save!' /opt/yeti-web/app/models/importing/base.rb:86:in `move_one!' /opt/yeti-web/app/models/importing/base.rb:74:in `block (3 levels) in move_batch' /opt/yeti-web/app/models/importing/base.rb:74:in `each' /opt/yeti-web/app/models/importing/base.rb:74:in `block (2 levels) in move_batch' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.5/lib/active_record/relation/batches.rb:136:in `block in find_in_batches' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.5/lib/active_record/relation/batches.rb:238:in `block in in_batches' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.5/lib/active_record/relation/batches.rb:222:in `loop' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.5/lib/active_record/relation/batches.rb:222:in `in_batches' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.5/lib/active_record/relation/batches.rb:135:in `find_in_batches' /opt/yeti-web/app/models/importing/base.rb:73:in `block in move_batch' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.5/lib/active_record/connection_adapters/abstract/database_statements.rb:267:in `block in transaction' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.5/lib/active_record/connection_adapters/abstract/transaction.rb:239:in `block in within_new_transaction' /usr/lib/ruby/2.6.0/monitor.rb:235:in `mon_synchronize' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.5/lib/active_record/connection_adapters/abstract/transaction.rb:236:in `within_new_transaction' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.5/lib/active_record/connection_adapters/abstract/database_statements.rb:267:in `transaction' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.5/lib/active_record/transactions.rb:212:in `transaction' /opt/yeti-web/app/models/importing/base.rb:72:in `move_batch' /opt/yeti-web/app/models/importing/importing_delayed_job.rb:26:in `perform' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/delayed_job-4.1.5/lib/delayed/backend/base.rb:81:in `block in invoke_job' /opt/yeti-web/vendor/bundle/ruby/2.6.0/bundler/gems/prometheus_exporter-d8cd0abd6163/lib/prometheus_exporter/instrumentation/delayed_job.rb:35:in `call' /opt/yeti-web/vendor/bundle/ruby/2.6.0/bundler/gems/prometheus_exporter-d8cd0abd6163/lib/prometheus_exporter/instrumentation/delayed_job.rb:18:in `block (3 levels) in register_plugin' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/delayed_job-4.1.5/lib/delayed/lifecycle.rb:79:in `block (2 levels) in add' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/delayed_job-4.1.5/lib/delayed/lifecycle.rb:61:in `block in initialize' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/delayed_job-4.1.5/lib/delayed/lifecycle.rb:79:in `block in add' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/delayed_job-4.1.5/lib/delayed/lifecycle.rb:66:in `execute' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/delayed_job-4.1.5/lib/delayed/lifecycle.rb:40:in `run_callbacks' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/delayed_job-4.1.5/lib/delayed/backend/base.rb:78:in `invoke_job' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/delayed_job-4.1.5/lib/delayed/worker.rb:230:in `block (2 levels) in run' /usr/lib/ruby/2.6.0/timeout.rb:93:in `block in timeout' /usr/lib/ruby/2.6.0/timeout.rb:103:in `timeout' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/delayed_job-4.1.5/lib/delayed/worker.rb:230:in `block in run' /usr/lib/ruby/2.6.0/benchmark.rb:308:in `realtime' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/delayed_job-4.1.5/lib/delayed/worker.rb:229:in `run' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/delayed_job-4.1.5/lib/delayed/worker.rb:312:in `block in reserve_and_run_one_job' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/delayed_job-4.1.5/lib/delayed/lifecycle.rb:61:in `block in initialize' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/delayed_job-4.1.5/lib/delayed/lifecycle.rb:66:in `execute' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/delayed_job-4.1.5/lib/delayed/lifecycle.rb:40:in `run_callbacks' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/delayed_job-4.1.5/lib/delayed/worker.rb:312:in `reserve_and_run_one_job' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/delayed_job-4.1.5/lib/delayed/worker.rb:213:in `block in work_off' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/delayed_job-4.1.5/lib/delayed/worker.rb:212:in `times' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/delayed_job-4.1.5/lib/delayed/worker.rb:212:in `work_off' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/delayed_job-4.1.5/lib/delayed/worker.rb:175:in `block (4 levels) in start' /usr/lib/ruby/2.6.0/benchmark.rb:308:in `realtime' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/delayed_job-4.1.5/lib/delayed/worker.rb:174:in `block (3 levels) in start' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/delayed_job-4.1.5/lib/delayed/lifecycle.rb:61:in `block in initialize' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/delayed_job-4.1.5/lib/delayed/lifecycle.rb:66:in `execute' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/delayed_job-4.1.5/lib/delayed/lifecycle.rb:40:in `run_callbacks' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/delayed_job-4.1.5/lib/delayed/worker.rb:173:in `block (2 levels) in start' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/delayed_job-4.1.5/lib/delayed/worker.rb:172:in `loop' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/delayed_job-4.1.5/lib/delayed/worker.rb:172:in `block in start' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/delayed_job-4.1.5/lib/delayed/plugins/clear_locks.rb:7:in `block (2 levels) in <class:ClearLocks>' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/delayed_job-4.1.5/lib/delayed/lifecycle.rb:79:in `block (2 levels) in add' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/delayed_job-4.1.5/lib/delayed/lifecycle.rb:61:in `block in initialize' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/delayed_job-4.1.5/lib/delayed/lifecycle.rb:79:in `block in add' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/delayed_job-4.1.5/lib/delayed/lifecycle.rb:66:in `execute' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/delayed_job-4.1.5/lib/delayed/lifecycle.rb:40:in `run_callbacks' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/delayed_job-4.1.5/lib/delayed/worker.rb:171:in `start' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/delayed_job-4.1.5/lib/delayed/command.rb:137:in `run' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/delayed_job-4.1.5/lib/delayed/command.rb:125:in `block in run_process' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/daemons-1.2.6/lib/daemons/application.rb:270:in `block in start_proc' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/daemons-1.2.6/lib/daemons/daemonize.rb:84:in `call_as_daemon' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/daemons-1.2.6/lib/daemons/application.rb:274:in `start_proc' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/daemons-1.2.6/lib/daemons/application.rb:300:in `start' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/daemons-1.2.6/lib/daemons/controller.rb:56:in `run' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/daemons-1.2.6/lib/daemons.rb:197:in `block in run_proc' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/daemons-1.2.6/lib/daemons/cmdline.rb:92:in `catch_exceptions' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/daemons-1.2.6/lib/daemons.rb:196:in `run_proc' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/delayed_job-4.1.5/lib/delayed/command.rb:123:in `run_process' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/delayed_job-4.1.5/lib/delayed/command.rb:104:in `block in daemonize' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/delayed_job-4.1.5/lib/delayed/command.rb:102:in `times' /opt/yeti-web/vendor/bundle/ruby/2.6.0/gems/delayed_job-4.1.5/lib/delayed/command.rb:102:in `daemonize' /opt/yeti-web/bin/delayed_job:6:in `<top (required)>' /opt/yeti-web/vendor/bundler/gems/bundler-2.1.4/lib/bundler/cli/exec.rb:63:in `load' /opt/yeti-web/vendor/bundler/gems/bundler-2.1.4/lib/bundler/cli/exec.rb:63:in `kernel_load' /opt/yeti-web/vendor/bundler/gems/bundler-2.1.4/lib/bundler/cli/exec.rb:28:in `run' /opt/yeti-web/vendor/bundler/gems/bundler-2.1.4/lib/bundler/cli.rb:476:in `exec' /opt/yeti-web/vendor/bundler/gems/bundler-2.1.4/lib/bundler/vendor/thor/lib/thor/command.rb:27:in `run' /opt/yeti-web/vendor/bundler/gems/bundler-2.1.4/lib/bundler/vendor/thor/lib/thor/invocation.rb:127:in `invoke_command' /opt/yeti-web/vendor/bundler/gems/bundler-2.1.4/lib/bundler/vendor/thor/lib/thor.rb:399:in `dispatch' /opt/yeti-web/vendor/bundler/gems/bundler-2.1.4/lib/bundler/cli.rb:30:in `dispatch' /opt/yeti-web/vendor/bundler/gems/bundler-2.1.4/lib/bundler/vendor/thor/lib/thor/base.rb:476:in `start' /opt/yeti-web/vendor/bundler/gems/bundler-2.1.4/lib/bundler/cli.rb:24:in `start' /opt/yeti-web/vendor/bundler/gems/bundler-2.1.4/exe/bundle:46:in `block in <top (required)>' /opt/yeti-web/vendor/bundler/gems/bundler-2.1.4/lib/bundler/friendly_errors.rb:123:in `with_friendly_errors' /opt/yeti-web/vendor/bundler/gems/bundler-2.1.4/exe/bundle:34:in `<top (required)>' /opt/yeti-web/vendor/bundler/bin/bundle:23:in `load' /opt/yeti-web/vendor/bundler/bin/bundle:23:in `<main>'

dmitry-sinina avatar Jun 23 '21 21:06 dmitry-sinina