Closed JoshdotNew closed 9 years ago
I am getting the below error, a record from one collection facebook_post_insights is somehow tying to save to another table (facebook_posts) in postgresql. This just started happening, I have not changed the configuration file.
INFO Mongoriver: Saved state: {"time"=>foo, "position"=>#<BSON::Timestamp:0x000000035eee78 @seconds=1439413736, @increment=1>} ERROR MoSQL: Error processing {"_id"=>BSON::ObjectId('55cbb7bc6e69673684000000'), "post_id"=>"foo", "post_story_adds_unique"=>foo, "post_story_adds"=>foo, "post_story_adds_by_action_type_unique"=>{"like"=>foo, "comment"=foo, "other"=>foo}, "post_story_adds_by_action_type"=>{"like"=>foo, "comment"=>foo, "other"=>foo}, "post_impressions_unique"=>foo, "post_impressions"=>foo, "post_impressions_paid_unique"=>foo, "post_impressions_paid"=>0, "post_impressions_organic_unique"=>foo, "post_impressions_organic"=>0, "post_impressions_viral_unique"=>0, "post_impressions_viral"=>0, "post_impressions_by_story_type_unique"=>[], "post_impressions_by_story_type"=>[], "post_impressions_fan_unique"=>0, "post_impressions_fan"=>0, "post_impressions_fan_paid_unique"=>0, "post_impressions_fan_paid"=>0, "post_impressions_by_paid_non_paid_unique"=>{"total"=>0, "unpaid"=>0, "paid"=>0}, "post_impressions_by_paid_non_paid"=>{"total"=>0, "unpaid"=>3926, "paid"=>0}, "post_video_length"=>0, "post_video_avg_time_watched"=>0, "post_consumptions_unique"=>0, "post_consumptions"=>0, "post_consumptions_by_type_unique"=>{"other clicks"=>0}, "post_consumptions_by_type"=>{"other clicks"=>0}, "post_negative_feedback_unique"=>0, "post_negative_feedback"=>0, "post_negative_feedback_by_type_unique"=>{"hide_clicks"=>0, "hide_all_clicks"=>0}, "post_negative_feedback_by_type"=>{"hide_clicks"=>0, "hide_all_clicks"=>0}, "post_engaged_fan"=>0, "post_fan_reach"=>0, "post_storytellers"=>0, "post_storytellers_by_action_type"=>{"like"=>0, "comment"=>0, "other"=>0}, "post_engaged_users"=>0, "post_stories"=>0, "post_stories_by_action_type"=>{"like"=>0, "comment"=>58, "other"=>0}, "client_id"=>BSON::ObjectId('556723e648e07b332200000c'), "class_type"=>"FacebookPostInsight", "updated_at"=>foo, "created_at"=>foo} for ck-analytics-clients.facebook_post_insights. /home/ngadmin/.rvm/gems/ruby-2.2.1/gems/sequel-4.23.0/lib/sequel/adapters/postgres.rb:180:in `async_exec': PG::UndefinedColumn: ERROR: column "post_story_adds_unique" of relation "facebook_posts" does not exist (Sequel::DatabaseError) LINE 1: ..., "post_id" = '8675309_8675309', "post_stor...
I am getting the below error, a record from one collection facebook_post_insights is somehow tying to save to another table (facebook_posts) in postgresql. This just started happening, I have not changed the configuration file.
INFO Mongoriver: Saved state: {"time"=>foo, "position"=>#<BSON::Timestamp:0x000000035eee78 @seconds=1439413736, @increment=1>} ERROR MoSQL: Error processing {"_id"=>BSON::ObjectId('55cbb7bc6e69673684000000'), "post_id"=>"foo", "post_story_adds_unique"=>foo, "post_story_adds"=>foo, "post_story_adds_by_action_type_unique"=>{"like"=>foo, "comment"=foo, "other"=>foo}, "post_story_adds_by_action_type"=>{"like"=>foo, "comment"=>foo, "other"=>foo}, "post_impressions_unique"=>foo, "post_impressions"=>foo, "post_impressions_paid_unique"=>foo, "post_impressions_paid"=>0, "post_impressions_organic_unique"=>foo, "post_impressions_organic"=>0, "post_impressions_viral_unique"=>0, "post_impressions_viral"=>0, "post_impressions_by_story_type_unique"=>[], "post_impressions_by_story_type"=>[], "post_impressions_fan_unique"=>0, "post_impressions_fan"=>0, "post_impressions_fan_paid_unique"=>0, "post_impressions_fan_paid"=>0, "post_impressions_by_paid_non_paid_unique"=>{"total"=>0, "unpaid"=>0, "paid"=>0}, "post_impressions_by_paid_non_paid"=>{"total"=>0, "unpaid"=>3926, "paid"=>0}, "post_video_length"=>0, "post_video_avg_time_watched"=>0, "post_consumptions_unique"=>0, "post_consumptions"=>0, "post_consumptions_by_type_unique"=>{"other clicks"=>0}, "post_consumptions_by_type"=>{"other clicks"=>0}, "post_negative_feedback_unique"=>0, "post_negative_feedback"=>0, "post_negative_feedback_by_type_unique"=>{"hide_clicks"=>0, "hide_all_clicks"=>0}, "post_negative_feedback_by_type"=>{"hide_clicks"=>0, "hide_all_clicks"=>0}, "post_engaged_fan"=>0, "post_fan_reach"=>0, "post_storytellers"=>0, "post_storytellers_by_action_type"=>{"like"=>0, "comment"=>0, "other"=>0}, "post_engaged_users"=>0, "post_stories"=>0, "post_stories_by_action_type"=>{"like"=>0, "comment"=>58, "other"=>0}, "client_id"=>BSON::ObjectId('556723e648e07b332200000c'), "class_type"=>"FacebookPostInsight", "updated_at"=>foo, "created_at"=>foo} for ck-analytics-clients.facebook_post_insights. /home/ngadmin/.rvm/gems/ruby-2.2.1/gems/sequel-4.23.0/lib/sequel/adapters/postgres.rb:180:in `async_exec': PG::UndefinedColumn: ERROR: column "post_story_adds_unique" of relation "facebook_posts" does not exist (Sequel::DatabaseError) LINE 1: ..., "post_id" = '8675309_8675309', "post_stor...