Sorry! Your question is quite vague. What did you do? You manually run a select query but then it rollback or you did a request in which it runs the select query then it rollback? please make the question more clear and if you can provide more error details.
On Thu, 4 May 2017 at 7:37 AM, fugue ohu <[email protected]> wrote: > When I run the select that rolls back in mysql there's no problem How can > I debug this? > > Started POST "/artist/14/tour/3/press_releases/new" for 127.0.0.1 at > 2017-05-03 19:08:27 -0400 > Processing by UserPressReleasesController#tour_create as HTML > Parameters: > {"authenticity_token"=>"J/ZFBljt2V9q+yEV78t+L9BOjEkqpWHyFx29HSPdB0+/PKX7s4bxLhzcoP4mtepmoKJ2NY4JKCIOcfhJBQAMXg==", > "artist_id"=>"14", "tour_id"=>"3"} > [1m [36mUser Load (2.0ms) [0m [1m [34mSELECT `users`.* FROM `users` > WHERE `users`.`id` = 2 ORDER BY `users`.`id` ASC LIMIT 1 [0m > [1m [36mArtist Load (1.9ms) [0m [1m [34mSELECT `artists`.* FROM > `artists` WHERE `artists`.`id` = 14 LIMIT 1 [0m > [1m [36mTour Load (1.4ms) [0m [1m [34mSELECT `tours`.* FROM `tours` > WHERE `tours`.`id` = 3 LIMIT 1 [0m > [1m [35m (0.6ms) [0m [1m [35mBEGIN [0m > [1m [35m (3.0ms) [0m [1m [31mROLLBACK [0m > > -- > 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/0d6c0119-f666-4d8f-9ece-d2476e36dfe6%40googlegroups.com > <https://groups.google.com/d/msgid/rubyonrails-talk/0d6c0119-f666-4d8f-9ece-d2476e36dfe6%40googlegroups.com?utm_medium=email&utm_source=footer> > . > 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/CAPmpWefuuhoABzjZPX_i%2BqoTBjJ_%2BWKotPoOTURzV5_TVjAj1Q%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
