Ok, DBA and I figured this out. The test schema and prod schema were not identical and the sequence has been messed up. I still don't know why the pk key constraint name (that was only in prod db schema at that time) appeared on the error message during testing. Anyway, thank you all for your help...!
Daniel On Sat, Sep 20, 2014 at 11:12 AM, Walter Lee Davis <[email protected]> wrote: > On Sep 18, 2014, at 5:48 PM, kimda <[email protected]> wrote: > > > If I write the error message instead of xxxxxx, it is: > > OCIError: ORA-00001: unique constraint (ABCSIGN_DBA.PK_ATTEND_IP) > violated: INSERT INTO attend_ip (xxx, xxx, xxx, .........) > > > > The PK prefix looks like a violation of the primary key. Maybe, > inserting same row again or some kind of replay happens. If so, why this is > not happening in production with same code??? > > > > How do I check if that case happens? > > > > Daniel > > > > In the config/environments/production.rb file, turn the log level up to > debug, and restart the server, and tail the log. You should be able to see > full queries and all as you hit various test pages in the site. > > Walter > > > > > On Thursday, September 18, 2014 3:35:50 AM UTC-5, kimda 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 [email protected]. > > To post to this group, send email to [email protected]. > > To view this discussion on the web visit > https://groups.google.com/d/msgid/rubyonrails-talk/3daf3e0a-c703-41ac-b3e5-9fbec634462b%40googlegroups.com > . > > For more options, visit https://groups.google.com/d/optout. > > -- > You received this message because you are subscribed to a topic in the > Google Groups "Ruby on Rails: Talk" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/rubyonrails-talk/PfHk13BmBXk/unsubscribe > . > To unsubscribe from this group and all its topics, send an email to > [email protected]. > To post to this group, send email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/rubyonrails-talk/8D4717F2-8441-4C98-897E-DE65101E6756%40wdstudio.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 [email protected]. To post to this group, send email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/CALdcBk2nDPNUwRutXDcu%2B3YKV-BNQuT8EzpL57H3ormjsP%2Bk6w%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
