Created
October 9, 2015 15:25
-
-
Save jcreed/6a4d23d1c62644489b25 to your computer and use it in GitHub Desktop.
Deleter Loader error on gpa_by_academic_years
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
==> loader/log/development.log <== | |
I, [2015-10-09T08:51:18.644949 #2520] INFO -- : Establishing connection to redis, queues = ["cas3_etl_loader_dev", "self_pipe_2520"] | |
==> loader/log/development.sql.log <== | |
E, [2015-10-09T08:51:18.648075 #2520] ERROR -- : PG::Error: ERROR: operator does not exist: integer = record | |
LINE 1: ... id FROM gpa_by_academic_years WHERE applicant_id = ('id-pro... | |
^ | |
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.: SELECT id FROM gpa_by_academic_years WHERE applicant_id = ('id-proxy', 'b8668aa0-bccc-419b-a39e-6f8eb85cab32') | |
I, [2015-10-09T08:51:18.648396 #2520] INFO -- : (0.000069s) ROLLBACK | |
==> loader/log/development.error.log <== | |
E, [2015-10-09T08:51:18.648588 #2520] ERROR -- : Error processing applicant 3233357924: | |
PG::Error: ERROR: operator does not exist: integer = record | |
LINE 1: ... id FROM gpa_by_academic_years WHERE applicant_id = ('id-pro... | |
^ | |
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. | |
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/sequel-4.0.0/lib/sequel/adapters/postgres.rb:161:in `async_exec' | |
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/sequel-4.0.0/lib/sequel/adapters/postgres.rb:161:in `block in execute_query' | |
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/sequel-4.0.0/lib/sequel/database/logging.rb:37:in `log_yield' | |
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/sequel-4.0.0/lib/sequel/adapters/postgres.rb:161:in `execute_query' | |
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/sequel-4.0.0/lib/sequel/adapters/postgres.rb:148:in `block in execute' | |
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/sequel-4.0.0/lib/sequel/adapters/postgres.rb:124:in `check_disconnect_errors' | |
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/sequel-4.0.0/lib/sequel/adapters/postgres.rb:148:in `execute' | |
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/sequel-4.0.0/lib/sequel/adapters/postgres.rb:458:in `_execute' | |
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/sequel-4.0.0/lib/sequel/adapters/postgres.rb:282:in `block (2 levels) in execute' | |
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/sequel-4.0.0/lib/sequel/adapters/postgres.rb:479:in `check_database_errors' | |
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/sequel-4.0.0/lib/sequel/adapters/postgres.rb:282:in `block in execute' | |
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/sequel-4.0.0/lib/sequel/database/connecting.rb:229:in `block in synchronize' | |
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/sequel-4.0.0/lib/sequel/connection_pool/threaded.rb:91:in `hold' | |
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/sequel-4.0.0/lib/sequel/database/connecting.rb:229:in `synchronize' | |
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/sequel-4.0.0/lib/sequel/adapters/postgres.rb:282:in `execute' | |
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/sequel-4.0.0/lib/sequel/dataset/actions.rb:794:in `execute' | |
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/sequel-4.0.0/lib/sequel/adapters/postgres.rb:601:in `fetch_rows' | |
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/sequel-4.0.0/lib/sequel/dataset/actions.rb:144:in `each' | |
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/sequel-4.0.0/lib/sequel/dataset/actions.rb:389:in `map' | |
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/sequel-4.0.0/lib/sequel/dataset/actions.rb:389:in `map' | |
/Users/jreed/Liaison/WebAdMIT-meta/loader/lib/loader/database/table.rb:11:in `ids_for_applicant' | |
/Users/jreed/Liaison/WebAdMIT-meta/loader/lib/loader/database/loaders/batch_implicit_delete_loader.rb:164:in `ids_from_database' | |
/Users/jreed/Liaison/WebAdMIT-meta/loader/lib/loader/database/loaders/batch_implicit_delete_loader.rb:126:in `ask_webadmit_to_delete' | |
/Users/jreed/Liaison/WebAdMIT-meta/loader/lib/loader/database/loaders/batch_implicit_delete_loader.rb:119:in `block in load!' | |
/Users/jreed/Liaison/WebAdMIT-meta/loader/lib/loader/database/loaders/batch_implicit_delete_loader.rb:117:in `each' | |
/Users/jreed/Liaison/WebAdMIT-meta/loader/lib/loader/database/loaders/batch_implicit_delete_loader.rb:117:in `load!' | |
/Users/jreed/Liaison/WebAdMIT-meta/loader/lib/loader/database/load_strategies/batch_load_strategy.rb:55:in `implicit_deletes' | |
/Users/jreed/Liaison/WebAdMIT-meta/loader/lib/loader/database/load_strategies/batch_load_strategy.rb:31:in `load' | |
/Users/jreed/Liaison/WebAdMIT-meta/loader/lib/loader/worker.rb:55:in `block (2 levels) in load' | |
/Users/jreed/Liaison/WebAdMIT-meta/loader/lib/loader/database/stager.rb:47:in `block in each' | |
/Users/jreed/Liaison/WebAdMIT-meta/loader/lib/loader/database/stager.rb:43:in `each' | |
/Users/jreed/Liaison/WebAdMIT-meta/loader/lib/loader/database/stager.rb:43:in `each' | |
/Users/jreed/Liaison/WebAdMIT-meta/loader/lib/loader/worker.rb:54:in `block in load' | |
/Users/jreed/Liaison/WebAdMIT-meta/loader/lib/loader/database/load_strategies/batch_with_reporters_load_strategy.rb:23:in `block in around_records' | |
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/sequel-4.0.0/lib/sequel/database/transactions.rb:118:in `_transaction' | |
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/sequel-4.0.0/lib/sequel/database/transactions.rb:93:in `block in transaction' | |
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/sequel-4.0.0/lib/sequel/database/connecting.rb:229:in `block in synchronize' | |
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/sequel-4.0.0/lib/sequel/connection_pool/threaded.rb:104:in `hold' | |
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/sequel-4.0.0/lib/sequel/database/connecting.rb:229:in `synchronize' | |
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/sequel-4.0.0/lib/sequel/database/transactions.rb:86:in `transaction' | |
/Users/jreed/Liaison/WebAdMIT-meta/loader/lib/loader/database/load_strategies/batch_with_reporters_load_strategy.rb:22:in `around_records' | |
/Users/jreed/Liaison/WebAdMIT-meta/loader/lib/loader/worker.rb:53:in `load' | |
/Users/jreed/Liaison/WebAdMIT-meta/loader/lib/loader/application.rb:76:in `block (2 levels) in the_usual' | |
/Users/jreed/.rvm/rubies/ruby-1.9.3-p551/lib/ruby/1.9.1/benchmark.rb:280:in `measure' | |
/Users/jreed/Liaison/WebAdMIT-meta/loader/lib/loader/application.rb:76:in `block in the_usual' | |
/Users/jreed/Liaison/WebAdMIT-meta/loader/lib/loader/transformer_listener.rb:41:in `next_record' | |
/Users/jreed/Liaison/WebAdMIT-meta/loader/lib/loader/application.rb:73:in `the_usual' | |
/Users/jreed/Liaison/WebAdMIT-meta/loader/lib/loader/application.rb:63:in `block in run' | |
/Users/jreed/Liaison/WebAdMIT-meta/loader/lib/loader/application.rb:48:in `loop' | |
/Users/jreed/Liaison/WebAdMIT-meta/loader/lib/loader/application.rb:48:in `run' | |
/Users/jreed/Liaison/WebAdMIT-meta/loader/lib/loader.rb:27:in `run' | |
/Users/jreed/Liaison/WebAdMIT-meta/loader/lib/loader/server/server.rb:15:in `<top (required)>' | |
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/daemons-1.1.9/lib/daemons/application.rb:203:in `load' | |
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/daemons-1.1.9/lib/daemons/application.rb:203:in `start_load' | |
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/daemons-1.1.9/lib/daemons/application.rb:298:in `start' | |
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/daemons-1.1.9/lib/daemons/controller.rb:70:in `run' | |
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/daemons-1.1.9/lib/daemons.rb:147:in `block in run' | |
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/daemons-1.1.9/lib/daemons/cmdline.rb:109:in `call' | |
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/daemons-1.1.9/lib/daemons/cmdline.rb:109:in `catch_exceptions' | |
/Users/jreed/.rvm/gems/ruby-1.9.3-p551/gems/daemons-1.1.9/lib/daemons.rb:146:in `run' | |
bin/loader:5:in `<main>' | |
==> loader/log/development.log <== | |
I, [2015-10-09T08:51:19.020145 #2520] INFO -- : Finished processing applicant: 3233357924 | |
I, [2015-10-09T08:51:19.020351 #2520] INFO -- : Done writing record, 0.8021490573883057 seconds |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment