Skip to content

Instantly share code, notes, and snippets.

@juliend2
Created November 7, 2015 00:33
Show Gist options
  • Save juliend2/2517f6b2d3f3405ca8c8 to your computer and use it in GitHub Desktop.
Save juliend2/2517f6b2d3f3405ca8c8 to your computer and use it in GitHub Desktop.
I, [2015-11-07T00:32:44.446905 #27591] INFO -- : (0.008129s) INSERT INTO "pages" ("site_id", "crawl_type", "url", "status_code", "page_rank") VALUES ('6d28f8b9-1370-45f1-8aa1-ad
b4b236a934', 'links', 'http://st-charles-borromee.org/_evenements/a/2088/m/1', 200, 0.00018537578930627734) RETURNING "page_id"
/home/deploy/statusmachine/vendor/bundle/ruby/2.1.0/gems/sequel-4.22.0/lib/sequel/adapters/postgres.rb:180:in `exec': PG::Error: ERROR: invalid input syntax for type json (Seque
l::DatabaseError)
LINE 1: ...count" = 0, "concerned_pages_count" = 0, "data" = '', "schem...
^
DETAIL: The input string ended unexpectedly.
CONTEXT: JSON data, line 1:
from /home/deploy/statusmachine/vendor/bundle/ruby/2.1.0/gems/sequel-4.22.0/lib/sequel/adapters/postgres.rb:180:in `block in execute_query'
from /home/deploy/statusmachine/vendor/bundle/ruby/2.1.0/gems/sequel-4.22.0/lib/sequel/database/logging.rb:37:in `log_yield'
from /home/deploy/statusmachine/vendor/bundle/ruby/2.1.0/gems/sequel-4.22.0/lib/sequel/adapters/postgres.rb:180:in `execute_query'
from /home/deploy/statusmachine/vendor/bundle/ruby/2.1.0/gems/sequel-4.22.0/lib/sequel/adapters/postgres.rb:167:in `block in execute'
from /home/deploy/statusmachine/vendor/bundle/ruby/2.1.0/gems/sequel-4.22.0/lib/sequel/adapters/postgres.rb:143:in `check_disconnect_errors'
from /home/deploy/statusmachine/vendor/bundle/ruby/2.1.0/gems/sequel-4.22.0/lib/sequel/adapters/postgres.rb:167:in `execute'
from /home/deploy/statusmachine/vendor/bundle/ruby/2.1.0/gems/sequel-4.22.0/lib/sequel/adapters/postgres.rb:511:in `_execute'
from /home/deploy/statusmachine/vendor/bundle/ruby/2.1.0/gems/sequel-4.22.0/lib/sequel/adapters/postgres.rb:335:in `block (2 levels) in execute'
from /home/deploy/statusmachine/vendor/bundle/ruby/2.1.0/gems/sequel-4.22.0/lib/sequel/adapters/postgres.rb:532:in `check_database_errors'
from /home/deploy/statusmachine/vendor/bundle/ruby/2.1.0/gems/sequel-4.22.0/lib/sequel/adapters/postgres.rb:335:in `block in execute'
from /home/deploy/statusmachine/vendor/bundle/ruby/2.1.0/gems/sequel-4.22.0/lib/sequel/database/connecting.rb:250:in `block in synchronize'
from /home/deploy/statusmachine/vendor/bundle/ruby/2.1.0/gems/sequel-4.22.0/lib/sequel/connection_pool/threaded.rb:95:in `hold'
from /home/deploy/statusmachine/vendor/bundle/ruby/2.1.0/gems/sequel-4.22.0/lib/sequel/database/connecting.rb:250:in `synchronize'
from /home/deploy/statusmachine/vendor/bundle/ruby/2.1.0/gems/sequel-4.22.0/lib/sequel/adapters/postgres.rb:335:in `execute'
from /home/deploy/statusmachine/vendor/bundle/ruby/2.1.0/gems/sequel-4.22.0/lib/sequel/database/query.rb:50:in `execute_dui'
from /home/deploy/statusmachine/vendor/bundle/ruby/2.1.0/gems/sequel-4.22.0/lib/sequel/dataset/actions.rb:932:in `execute_dui'
from /home/deploy/statusmachine/vendor/bundle/ruby/2.1.0/gems/sequel-4.22.0/lib/sequel/dataset/actions.rb:778:in `update'
from /home/deploy/statusmachine/workers/main/main_persister.rb:182:in `block in save_issue'
from /home/deploy/statusmachine/vendor/bundle/ruby/2.1.0/gems/sequel-4.22.0/lib/sequel/database/transactions.rb:105:in `block in transaction'
from /home/deploy/statusmachine/vendor/bundle/ruby/2.1.0/gems/sequel-4.22.0/lib/sequel/database/connecting.rb:250:in `block in synchronize'
from /home/deploy/statusmachine/vendor/bundle/ruby/2.1.0/gems/sequel-4.22.0/lib/sequel/connection_pool/threaded.rb:95:in `hold'
from /home/deploy/statusmachine/vendor/bundle/ruby/2.1.0/gems/sequel-4.22.0/lib/sequel/database/connecting.rb:250:in `synchronize'
from /home/deploy/statusmachine/vendor/bundle/ruby/2.1.0/gems/sequel-4.22.0/lib/sequel/database/transactions.rb:97:in `transaction'
from /home/deploy/statusmachine/workers/main/main_persister.rb:167:in `save_issue'
from ./workers/main/json_persister.rb:81:in `block in persist_issues'
from ./workers/main/json_persister.rb:79:in `each'
from ./workers/main/json_persister.rb:79:in `persist_issues'
from ./workers/main/json_persister.rb:36:in `block in run'
from /home/deploy/statusmachine/vendor/bundle/ruby/2.1.0/gems/sequel-4.22.0/lib/sequel/database/transactions.rb:134:in `_transaction'
from /home/deploy/statusmachine/vendor/bundle/ruby/2.1.0/gems/sequel-4.22.0/lib/sequel/database/transactions.rb:108:in `block in transaction'
from /home/deploy/statusmachine/vendor/bundle/ruby/2.1.0/gems/sequel-4.22.0/lib/sequel/database/connecting.rb:250:in `block in synchronize'
from /home/deploy/statusmachine/vendor/bundle/ruby/2.1.0/gems/sequel-4.22.0/lib/sequel/connection_pool/threaded.rb:99:in `hold'
from /home/deploy/statusmachine/vendor/bundle/ruby/2.1.0/gems/sequel-4.22.0/lib/sequel/database/connecting.rb:250:in `synchronize'
from /home/deploy/statusmachine/vendor/bundle/ruby/2.1.0/gems/sequel-4.22.0/lib/sequel/database/transactions.rb:97:in `transaction'
from ./workers/main/json_persister.rb:35:in `run'
from ./workers/main/json_persister.rb:87:in `block in loop!'
from ./workers/main/json_persister.rb:86:in `loop'
from ./workers/main/json_persister.rb:86:in `loop!'
from ./workers/main/json_persister.rb:107:in `<main>'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment