search

rackerlabs / peril

Match developers with questions with Rackers with answers!
Other
4 stars 2 forks source link

value too long for type character varying(255) #11

Closed smashwilson closed 10 years ago

smashwilson commented 10 years ago

I've been seeing this a lot in the Peril logs already:

/home/peril/.rbenv/versions/2.1.1/lib/ruby/gems/2.1.0/gems/activerecord-4.1.0/lib/active_record/connection_adapters/postgresql_adapter.rb:827:in `get_last_result': PG::StringDataRig
htTruncation: ERROR:  value too long for type character varying(255) (ActiveRecord::StatementInvalid)
: INSERT INTO "events" ("incident_id", "reporter", "tags", "title", "unique_id", "url") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id"
        from /home/peril/.rbenv/versions/2.1.1/lib/ruby/gems/2.1.0/gems/activerecord-4.1.0/lib/active_record/connection_adapters/postgresql_adapter.rb:827:in `block in exec_cache'
        from /home/peril/.rbenv/versions/2.1.1/lib/ruby/gems/2.1.0/gems/activerecord-4.1.0/lib/active_record/connection_adapters/abstract_adapter.rb:373:in `block in log'
        from /home/peril/.rbenv/versions/2.1.1/lib/ruby/gems/2.1.0/gems/activesupport-4.1.0/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
        from /home/peril/.rbenv/versions/2.1.1/lib/ruby/gems/2.1.0/gems/activerecord-4.1.0/lib/active_record/connection_adapters/abstract_adapter.rb:367:in `log'
        from /home/peril/.rbenv/versions/2.1.1/lib/ruby/gems/2.1.0/gems/activerecord-4.1.0/lib/active_record/connection_adapters/postgresql_adapter.rb:824:in `exec_cache'
        from /home/peril/.rbenv/versions/2.1.1/lib/ruby/gems/2.1.0/gems/activerecord-4.1.0/lib/active_record/connection_adapters/postgresql/database_statements.rb:138:in `exec_query
'
        from /home/peril/.rbenv/versions/2.1.1/lib/ruby/gems/2.1.0/gems/activerecord-4.1.0/lib/active_record/connection_adapters/postgresql/database_statements.rb:180:in `exec_inser
t'
        from /home/peril/.rbenv/versions/2.1.1/lib/ruby/gems/2.1.0/gems/activerecord-4.1.0/lib/active_record/connection_adapters/abstract/database_statements.rb:105:in `insert'

It looks like the default width of a character varying is 255 characters, and we're pulling in URLs larger than that (although which ones, I'm not sure about).