Skip to content

Instantly share code, notes, and snippets.

@adborden
Created October 2, 2014 19:03
Show Gist options
  • Save adborden/de92b19a2bbe1feebbdc to your computer and use it in GitHub Desktop.
Save adborden/de92b19a2bbe1feebbdc to your computer and use it in GitHub Desktop.
mosql TEXT ARRAY error
2014-10-02T17:09:34.821274+00:00 app[mosql.1]: ERROR MoSQL: Error processing {"id"=>"4fa0c49bc43e9e0700000085", "foodshed"=>"sfbay", "name"=>"Green Garlic & Asparagus Soup", "price"=>15.8, "tags"=>"[]"} for goodeggs-garbanzo.products.
2014-10-02T17:09:35.692222+00:00 app[mosql.1]: INFO Mongoriver: Starting oplog stream from seconds: 1412219293, increment: 0
2014-10-02T17:09:37.231531+00:00 app[mosql.1]: from /app/vendor/bundle/ruby/2.0.0/gems/sequel-4.12.0/lib/sequel/adapters/postgres.rb:148:in `block in execute'
2014-10-02T17:09:37.231533+00:00 app[mosql.1]: from /app/vendor/bundle/ruby/2.0.0/gems/sequel-4.12.0/lib/sequel/adapters/postgres.rb:124:in `check_disconnect_errors'
2014-10-02T17:09:37.231536+00:00 app[mosql.1]: from /app/vendor/bundle/ruby/2.0.0/gems/sequel-4.12.0/lib/sequel/adapters/postgres.rb:492:in `_execute'
2014-10-02T17:09:37.231535+00:00 app[mosql.1]: from /app/vendor/bundle/ruby/2.0.0/gems/sequel-4.12.0/lib/sequel/adapters/postgres.rb:148:in `execute'
2014-10-02T17:09:37.231497+00:00 app[mosql.1]: LINE 1: ...ini Pumpkin Spice Trio', "price" = 6.49, "tags" = '["Cookies...
2014-10-02T17:09:37.231499+00:00 app[mosql.1]: ^
2014-10-02T17:09:37.231525+00:00 app[mosql.1]: from /app/vendor/bundle/ruby/2.0.0/gems/sequel-4.12.0/lib/sequel/database/logging.rb:33:in `log_yield'
2014-10-02T17:09:37.231527+00:00 app[mosql.1]: from /app/vendor/bundle/ruby/2.0.0/gems/sequel-4.12.0/lib/sequel/adapters/postgres.rb:161:in `execute_query'
2014-10-02T17:09:37.174636+00:00 app[mosql.1]: INFO Mongoriver: Saved timestamp: seconds: 1412219293, increment: 1 (2014-10-02 03:08:13 +0000)
2014-10-02T17:09:37.231494+00:00 app[mosql.1]: /app/vendor/bundle/ruby/2.0.0/gems/sequel-4.12.0/lib/sequel/adapters/postgres.rb:161:in `async_exec': PG::InvalidTextRepresentation: ERROR: missing dimension value (Sequel::DatabaseError)
2014-10-02T17:09:37.231539+00:00 app[mosql.1]: from /app/vendor/bundle/ruby/2.0.0/gems/sequel-4.12.0/lib/sequel/adapters/postgres.rb:513:in `check_database_errors'
2014-10-02T17:09:37.231503+00:00 app[mosql.1]: from /app/vendor/bundle/ruby/2.0.0/gems/sequel-4.12.0/lib/sequel/adapters/postgres.rb:161:in `block in execute_query'
2014-10-02T17:09:37.231545+00:00 app[mosql.1]: from /app/vendor/bundle/ruby/2.0.0/gems/sequel-4.12.0/lib/sequel/database/connecting.rb:229:in `synchronize'
2014-10-02T17:09:37.231554+00:00 app[mosql.1]: from /app/vendor/bundle/ruby/2.0.0/gems/mosql-0.3.1/lib/mosql/sql.rb:50:in `upsert!'
2014-10-02T17:09:37.231541+00:00 app[mosql.1]: from /app/vendor/bundle/ruby/2.0.0/gems/sequel-4.12.0/lib/sequel/adapters/postgres.rb:316:in `block in execute'
2014-10-02T17:09:37.231542+00:00 app[mosql.1]: from /app/vendor/bundle/ruby/2.0.0/gems/sequel-4.12.0/lib/sequel/database/connecting.rb:229:in `block in synchronize'
2014-10-02T17:09:37.231550+00:00 app[mosql.1]: from /app/vendor/bundle/ruby/2.0.0/gems/sequel-4.12.0/lib/sequel/database/query.rb:50:in `execute_dui'
2014-10-02T17:09:37.231546+00:00 app[mosql.1]: from /app/vendor/bundle/ruby/2.0.0/gems/sequel-4.12.0/lib/sequel/adapters/postgres.rb:316:in `execute'
2014-10-02T17:09:37.231538+00:00 app[mosql.1]: from /app/vendor/bundle/ruby/2.0.0/gems/sequel-4.12.0/lib/sequel/adapters/postgres.rb:316:in `block (2 levels) in execute'
2014-10-02T17:09:37.231563+00:00 app[mosql.1]: from /app/vendor/bundle/ruby/2.0.0/gems/mosql-0.3.1/lib/mosql/streamer.rb:164:in `sync_object'
2014-10-02T17:09:37.231552+00:00 app[mosql.1]: from /app/vendor/bundle/ruby/2.0.0/gems/sequel-4.12.0/lib/sequel/dataset/actions.rb:773:in `update'
2014-10-02T17:09:37.231556+00:00 app[mosql.1]: from /app/vendor/bundle/ruby/2.0.0/gems/mosql-0.3.1/lib/mosql/sql.rb:38:in `upsert_ns'
2014-10-02T17:09:37.231558+00:00 app[mosql.1]: from /app/vendor/bundle/ruby/2.0.0/gems/mosql-0.3.1/lib/mosql/streamer.rb:165:in `block in sync_object'
2014-10-02T17:09:37.231559+00:00 app[mosql.1]: from /app/vendor/bundle/ruby/2.0.0/gems/mosql-0.3.1/lib/mosql/streamer.rb:39:in `unsafe_handle_exceptions'
2014-10-02T17:09:37.231551+00:00 app[mosql.1]: from /app/vendor/bundle/ruby/2.0.0/gems/sequel-4.12.0/lib/sequel/dataset/actions.rb:917:in `execute_dui'
2014-10-02T17:09:37.231572+00:00 app[mosql.1]: from /app/vendor/bundle/ruby/2.0.0/gems/mongoriver-0.3.1/lib/mongoriver/abstract_persistent_tailer.rb:27:in `stream'
2014-10-02T17:09:37.231543+00:00 app[mosql.1]: from /app/vendor/bundle/ruby/2.0.0/gems/sequel-4.12.0/lib/sequel/connection_pool/threaded.rb:104:in `hold'
2014-10-02T17:09:37.231568+00:00 app[mosql.1]: from /app/vendor/bundle/ruby/2.0.0/gems/mongoriver-0.3.1/lib/mongoriver/tailer.rb:107:in `stream'
2014-10-02T17:09:37.231573+00:00 app[mosql.1]: from /app/vendor/bundle/ruby/2.0.0/gems/mosql-0.3.1/lib/mosql/streamer.rb:153:in `optail'
2014-10-02T17:09:37.231567+00:00 app[mosql.1]: from /app/vendor/bundle/ruby/2.0.0/gems/mongoriver-0.3.1/lib/mongoriver/abstract_persistent_tailer.rb:28:in `block in stream'
2014-10-02T17:09:37.231575+00:00 app[mosql.1]: from /app/vendor/bundle/ruby/2.0.0/gems/mosql-0.3.1/lib/mosql/cli.rb:161:in `run'
2014-10-02T17:09:37.231576+00:00 app[mosql.1]: from /app/vendor/bundle/ruby/2.0.0/gems/mosql-0.3.1/lib/mosql/cli.rb:16:in `run'
2014-10-02T17:09:37.231580+00:00 app[mosql.1]: from /app/vendor/bundle/ruby/2.0.0/gems/mosql-0.3.1/bin/mosql:5:in `<top (required)>'
2014-10-02T17:09:37.231564+00:00 app[mosql.1]: from /app/vendor/bundle/ruby/2.0.0/gems/mosql-0.3.1/lib/mosql/streamer.rb:203:in `handle_op'
2014-10-02T17:09:37.231583+00:00 app[mosql.1]: from /app/vendor/bundle/ruby/2.0.0/bin/mosql:23:in `<main>'
2014-10-02T17:09:37.231566+00:00 app[mosql.1]: from /app/vendor/bundle/ruby/2.0.0/gems/mosql-0.3.1/lib/mosql/streamer.rb:154:in `block in optail'
2014-10-02T17:09:37.231581+00:00 app[mosql.1]: from /app/vendor/bundle/ruby/2.0.0/bin/mosql:23:in `load'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment