Database constraints are extremely valuable - it's the only way to guarantee certain conditions (especially uniqueness).
Have you tried increasing logging level, and checking logs for what queries are actually performed? You can also run `rake db:schema:dump` (or even db:structure:dump) on the production to get production database schema and verify it. Maybe loading dump of the production database locally (if that's possible for you - privacy, etc.) can help you debug those issues. Michal 2014-09-18 16:39 GMT+02:00 Jason Fleetwood-Boldt <t...@datatravels.com>: > It looks like there may be a unique constraint on the database (not the Ruby > code) > > Generally Rails is against database constraints (although there is some > disagreement about this in the community). I would look for a database > constraint, remove it, and see if that fixes the problem. > > -Jason > > > > On Sep 18, 2014, at 4:35 AM, kimda <tkk...@gmail.com> wrote: > > Hello, > > I have developed a small RoR app(ruby 1.8.7, rails 2.1.0, rubygem 0.9.4) a > few years ago and now I moved the app on Windows 2008 server. > > I have a weird issue that insert doesn't work all the time. This is the > error message and there is no duplicated PK insertion when I check DB table. > > ActiveRecord::StatementInvalid (OCIError: ORA-00001: unique constraint > (xxxxxxxx) violated: INSERT INTO xxxxxx (xxxx, xxxx, xxxx, xxxx, ......) > ... > ... > ... > > I am the only one who is testing and there are no opened sessions. I am sure > production DB schema and test DB schema are identical. I tested with all > three environments with test DB schema, but didn't help. > > One thing to note is that after I get the RoR error message, if I just hit > F5 key a few times, the insertion works and I get the next successful page. > > This same app is working fine on Windows 2003 server though. (I just copied > the app dir and all the RoR setup.) > > Any clues? > > thanks in advance. > > Daniel > > -- > You received this message because you are subscribed to the Google Groups > "Ruby on Rails: Talk" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to rubyonrails-talk+unsubscr...@googlegroups.com. > To post to this group, send email to rubyonrails-talk@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/rubyonrails-talk/1a85802e-a692-45c7-812c-9ed256a659b2%40googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > > > -- > You received this message because you are subscribed to the Google Groups > "Ruby on Rails: Talk" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to rubyonrails-talk+unsubscr...@googlegroups.com. > To post to this group, send email to rubyonrails-talk@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/rubyonrails-talk/6E5985EB-A8A2-41A9-872C-ACF9E97BA09E%40datatravels.com. > > For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscr...@googlegroups.com. To post to this group, send email to rubyonrails-talk@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/CABNBvv0xSKKFKvn%2BbQ4Cnriocp56dMqZt1YMr8_a0UXpuKO_zQ%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.