# Upgrade application from rails 2.2.2 to 2.3.2 **URL:** \ **Category:** Rails\ **Created:** [March 24, 2009, 2:40pm UTC](https://www.ruby-forum.com/t/upgrade-application-from-rails-2-2-2-to-2-3-2/163737 "2009-03-24T14:40:37Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![guoliang](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/67e7ee/32.png) [@guoliang](https://www.ruby-forum.com/u/guoliang)\ **Post date:** [March 24, 2009, 2:40pm UTC](https://www.ruby-forum.com/t/upgrade-application-from-rails-2-2-2-to-2-3-2/163737/1 "2009-03-24T14:40:37Z")
Hi, We are upgrading our application to 2.3.2 recently and got a strange problem with session id. We uses ActiveRecord to store sessions and the session id column type was VARCHAR(255). After I started the server, I had problem with inserting into session table. It turns out that the session id value is really long and after I changed the column type to text, the application works. I also tried to switch to store sessions in cookies and it works. You’ll notice the session id is longer than 255 too though. Any comments? Here are session\_id and data I copied from my sessions table session\_id: BAh7FCIodmFsaWRhdGlvbl90cmFja2VyX2Zvcl9TaGlwcGluZ0luZm9vOixJcnJlc29sdXRlVmFsaWRhdGlvbjo6VmFsaWRhdGlvblRyYWNrZXIGOhpAYXR0cmlidXRlc192YWxpZGF0ZWR7BjoVc2hpcHBpbmdfYWRkcmVzc286PklycmVzb2x1dGVWYWxpZGF0aW9uOjpWYWxpZGF0aW9uVHJhY2tlcjo6QXR0cmlidXRlVHJhY2tlcgY6C0B0aW1lc2kAOg5yZXR1cm5fdG8iBi86D2V4cGlyZXNfYXRJdToJVGltZQ20ShuAlVjTQQY6H0BtYXJzaGFsX3dpdGhfdXRjX2NvZXJjaW9uRjoLbG9jYWxlIgpFTl9VUzoPc2Vzc2lvbl9pZCIlMGMxYjU0NzJiY2Y1MTc3NDlmZGVjYzJiMTBhNjYxMjg6GHN1YnNjcmliZV90eXBlX25hbWUiC0RpcmVjdDoec2hvd19idXNpbmVzc19wbGFuc19vbmx5P0Y6EF9jc3JmX3Rva2VuIjFvWVNpT2c1cDZCbXE0emZrM1FTaXlXZ1V5cWhhOUF3L1BmNDdDWkV2UC9BPSIndmFsaWRhdGlvbl90cmFja2VyX2Zvcl9CaWxsaW5nSW5mb287AAY7BnsJOhhiaWxsaW5nX3Bvc3RhbF9jb2RlbzsIBjsJaQA6F2JpbGxpbmdfZmlyc3RfbmFtZW87CAY7CWkAOhFwYXltZW50X3R5cGVvOwgGOwlpADoWYmlsbGluZ19sYXN0X25hbWVvOwgGOwlpADoObmF2aWdhdG9ybzoOTmF2aWdhdG9yCjoTQHByb3RldXNfcGFnZXNbDW86DUZsb3dQYWdlCjoTQHN0YXRlX2NsYXNzZXN7CDoLYWN0aXZlIgthY3RpdmU6DnVudmlzaXRlZCIOdW52aXNpdGVkOgx2aXNpdGVkIgx2aXNpdGVkOgpAbmFtZToVcGxhbnNfYnJlYWRjcnVtYjoPQGludmlzaWJsZUY6C0BzdGF0ZTscOglAa2V5OgpwbGFuc287Ggo7G0AaOx86HXNlbGVjdF9kZXZpY2VfYnJlYWRjcnVtYjshRjsiOx07IzoSc2VsZWN0X2RldmljZW87Ggo7G0AaOx86HXNlbGVjdF9udW1iZXJfYnJlYWRjcnVtYjshRjsiOx07IzoSc2VsZWN0X251bWJlcm87Ggo7G0AaOx86HGFjY291bnRfaW5mb19icmVhZGNydW1iOyFGOyI7HTsjOgxhY2NvdW50bzsaCjsbQBo7HzohZW1lcmdlbmN5X2FkZHJlc3NfYnJlYWRjcnVtYjshRjsiOx07IzoWZW1lcmdlbmN5X2FkZHJlc3NvOxoKOxtAGjsfOiRiaWxsaW5nX2FuZF9zaGlwcGluZ19icmVhZGNydW1iOyFGOyI7HTsjOhliaWxsaW5nX2FuZF9zaGlwcGluZ287Ggs7G0AaOx86F3N1bW1hcnlfYnJlYWRjcnVtYjshRjoKQGJhY2swOyI7HTsjOgxzdW1tYXJ5bzsaDDsbewg7HEAbOx0iDmludmlzaWJsZTseQB07HzocY29uZmlybWF0aW9uX2JyZWFkY3J1bWI7IVQ7MDA7IjsdOyM6EWNvbmZpcm1hdGlvbjoKQG5leHQwOhVAYWN0aXZlX3BhZ2Vfa2V5OyQ6F0BhbGxfcHJvdGV1c19wYWdlc3sTOzFAIzocZW1lcmdlbmN5X2FkZHJlc3NfdGVybXNvOxoKOxtAGjoMQHBhcmVudDssOyFGOyI7HTsjOzc7KEAfOhV0ZW1wb3JhcnlfbnVtYmVybzsaCzsbQBo7ODsoOyFGOzA6HHBvcnRfbnVtYmVyX3N1Y2Nlc3NfdXJsOyI7HTsjOzk7JkAeOzNAJDoZc2hpcHBpbmdfc3VnZ2VzdGlvbnNvOxoKOxtAGjs4Oy47IUY7IjsdOyM7OzskQBk6GHBvcnRfbnVtYmVyX3N1Y2Nlc3NvOxoKOxtAGjs4Oyg7IUY7IjsdOyM7PDssQCE7KkAgOiJlbWVyZ2VuY3lfYWRkcmVzc19zdWdnZXN0aW9uc287Ggs7G0AaOzg7LDshRjsiOx07Izs9OzQ6IGVtZXJnZW5jeV9hZGRyZXNzX3Rlcm1zX3VybDoYaW50ZXJuYXRpb25hbF9wbGFuc287Ggo7G0AaOzg7JDshRjsiOx07Izs/Oy5AIjoXQHByZXZpb3VzX3BhZ2Vfa2V5OyQ6D0BhbGxfcGFnZXNbDUAZQB5AH0AgQCFAIkAjQCQiN3ZhbGlkYXRpb25fdHJhY2tlcl9mb3JfQmlsbGluZ0FuZFNoaXBwaW5nUHJlc2VudGVybzsABjsGewY6EnRvc19hZ3JlZW1lbnRvOwgGOwlpADoMY2FydF9pZGkCfQ0iCmZsYXNoSUM6J0FjdGlvbkNvbnRyb2xsZXI6OkZsYXNoOjpGbGFzaEhhc2h7AAY6CkB1c2VkewA6F2phdmFzY3JpcHRfZW5hYmxlZCIJdHJ1ZToQbGFuZGluZ191cmwiFmh0dHA6Ly9sb2NhbGhvc3Qv–35e864c1c7f807e558a8a23590ae57dd22a634aa data: BAh7EDoMY2FydF9pZGkCfg06C2xvY2FsZSIKRU5fVVM6EGxhbmRpbmdfdXJs IhZodHRwOi8vbG9jYWxob3N0LzoXamF2YXNjcmlwdF9lbmFibGVkIgl0cnVl Og9leHBpcmVzX2F0SXU6CVRpbWUNtUobgDie08QGOh9AbWFyc2hhbF93aXRo X3V0Y19jb2VyY2lvbkY6DnJldHVybl90byIGLzoQX2NzcmZfdG9rZW4iMXVa ek5DTUhubGhTZ2tJaFZuYmc1emo4WmpJandQM0RXNDhNTG9lY0llQ3c9Ohhz dWJzY3JpYmVfdHlwZV9uYW1lIgtEaXJlY3Q6HnNob3dfYnVzaW5lc3NfcGxh bnNfb25seT9GOg5uYXZpZ2F0b3JvOg5OYXZpZ2F0b3ILOhdAcHJldmlvdXNf cGFnZV9rZXk6EnNlbGVjdF9kZXZpY2U6FUBhY3RpdmVfcGFnZV9rZXk6EnNl bGVjdF9udW1iZXI6D0B2ZGNfcGFnZXNbADoXQGFsbF9wcm90ZXVzX3BhZ2Vz exM6DHN1bW1hcnlvOg1GbG93UGFnZQs6E0BzdGF0ZV9jbGFzc2Vzewg6C2Fj dGl2ZSILYWN0aXZlOg51bnZpc2l0ZWQiDnVudmlzaXRlZDoMdmlzaXRlZCIM dmlzaXRlZDoKQG5hbWU6F3N1bW1hcnlfYnJlYWRjcnVtYjoPQGludmlzaWJs ZUY6C0BzdGF0ZTscOglAa2V5Oxg6CkBiYWNrMDoiZW1lcmdlbmN5X2FkZHJl c3Nfc3VnZ2VzdGlvbnNvOxkLOgpAbmV4dDogZW1lcmdlbmN5X2FkZHJlc3Nf dGVybXNfdXJsOxpAEToMQHBhcmVudDoWZW1lcmdlbmN5X2FkZHJlc3M7IEY7 ITscOyI7JDoYaW50ZXJuYXRpb25hbF9wbGFuc287GQo7GkAROyc6CnBsYW5z OyBGOyE7HDsiOyk6GWJpbGxpbmdfYW5kX3NoaXBwaW5nbzsZCjsaQBE7Hjok YmlsbGluZ19hbmRfc2hpcHBpbmdfYnJlYWRjcnVtYjsgRjshOxw7IjsrOhxl bWVyZ2VuY3lfYWRkcmVzc190ZXJtc287GQo7GkAROyc7KDsgRjshOxw7Ijst OxVvOxkKOxpAETseOh1zZWxlY3RfbnVtYmVyX2JyZWFkY3J1bWI7IEY7ITsb OyI7FToRY29uZmlybWF0aW9ubzsZDDslMDsaewg7G0ASOxwiDmludmlzaWJs ZTsdQBQ7HjocY29uZmlybWF0aW9uX2JyZWFkY3J1bWI7IFQ7ITscOyI7Lzsj MDoVdGVtcG9yYXJ5X251bWJlcm87GQs7GkAROyc7FTsgRjshOxw7IjsxOyM6 HHBvcnRfbnVtYmVyX3N1Y2Nlc3NfdXJsOxNvOxkKOxpAETseOh1zZWxlY3Rf ZGV2aWNlX2JyZWFkY3J1bWI7IEY7ITsdOyI7EzoZc2hpcHBpbmdfc3VnZ2Vz dGlvbnNvOxkKOxpAETsnOys7IEY7ITscOyI7NDsqbzsZCjsaQBE7HjoVcGxh bnNfYnJlYWRjcnVtYjsgRjshOx07IjsqOhhwb3J0X251bWJlcl9zdWNjZXNz bzsZCjsaQBE7JzsVOyBGOyE7HDsiOzY6DGFjY291bnRvOxkKOxpAETseOhxh Y2NvdW50X2luZm9fYnJlYWRjcnVtYjsgRjshOxw7Ijs3OyhvOxkKOxpAETse OiFlbWVyZ2VuY3lfYWRkcmVzc19icmVhZGNydW1iOyBGOyE7HDsiOyg6D0Bh bGxfcGFnZXNbDUAgQB5AGUAiQCNAF0AQQBo6E0Bwcm90ZXVzX3BhZ2VzWw1A IEAeQBlAIkAjQBdAEEAaIgpmbGFzaElDOidBY3Rpb25Db250cm9sbGVyOjpG bGFzaDo6Rmxhc2hIYXNoewAGOgpAdXNlZHsA Thank you. Cao ---
**Author:** ![guoliang](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/67e7ee/32.png) [@guoliang](https://www.ruby-forum.com/u/guoliang)\ **Post date:** [March 24, 2009, 2:50pm UTC](https://www.ruby-forum.com/t/upgrade-application-from-rails-2-2-2-to-2-3-2/163737/2 "2009-03-24T14:50:46Z")
On Mar 24, 1:40 pm, Guoliang C. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote: > You’ll notice the session id is longer than 255 too though. Any > comments? That looks like it’s taking cookie store type session\_ids (where the session\_id is the the entire session) and trying to insert it into the database. Not sure how that would happen unless you were switching back and forth between session store types (because then you would get a session cookie with that long session id). Fred ---
**Author:** ![guoliang](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/67e7ee/32.png) [@guoliang](https://www.ruby-forum.com/u/guoliang)\ **Post date:** [March 24, 2009, 3:35pm UTC](https://www.ruby-forum.com/t/upgrade-application-from-rails-2-2-2-to-2-3-2/163737/3 "2009-03-24T15:35:09Z")
Frederick C. wrote: > On Mar 24, 1:40�pm, Guoliang C. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) > wrote: > > > You’ll notice the session id is longer than 255 too though. Any > > comments? > > That looks like it’s taking cookie store type session\_ids (where the > session\_id is the the entire session) and trying to insert it into the > database. Not sure how that would happen unless you were switching > back and forth between session store types (because then you would get > a session cookie with that long session id). > > Fred Thank you. That sounds a reasonable guess. We do use cookies in a few places, it might trigger rails to generate session id differently. I’ll try to dig through rails code and see if I can find anything interesting. ---
**Author:** ![guoliang](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/67e7ee/32.png) [@guoliang](https://www.ruby-forum.com/u/guoliang)\ **Post date:** [March 24, 2009, 4:10pm UTC](https://www.ruby-forum.com/t/upgrade-application-from-rails-2-2-2-to-2-3-2/163737/4 "2009-03-24T16:10:07Z")
I reset my databases and the application works great now. Not sure what caused the original problem, maybe just some random thing related to session database. ---
**Author:** ![guoliang](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/67e7ee/32.png) [@guoliang](https://www.ruby-forum.com/u/guoliang)\ **Post date:** [April 25, 2009, 11:52am UTC](https://www.ruby-forum.com/t/upgrade-application-from-rails-2-2-2-to-2-3-2/163737/5 "2009-04-25T11:52:47Z")
The reason is well explained by differences between how session id is calculated for different session stores. You need to clear the cookies in the client web browser’s cache before they start using session ids compatible with your new session store. You don’t really need to reset any database. I believe you would have faced the same problem in previous rails releases as well. -erekyus Perry S.-5 wrote: > comments? – View this message in context: [http://www.nabble.com/Upgrade-application-from-rails-2.2.2-to-2.3.2-tp22680659p23230162.html](http://www.nabble.com/Upgrade-application-from-rails-2.2.2-to-2.3.2-tp22680659p23230162.html) Sent from the RubyOnRails Users mailing list archive at [Nabble.com](http://Nabble.com).