locked
MySql Service Stopper while Execution of SP RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    User-2030397957 posted

    Hi All

    I have written a store procedure where I have used 4 temp table for joining purpose.I am using MySql 5.1 and Running locally.

    While executing SP for the first time it executing successfully.

    But While I am trying to execute the sp 2 times simultanously then MySql service getting stopped.

    Please any sorts of help are welcome

    Saturday, June 25, 2011 3:36 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    User-693248168 posted

    Are you running the SP simultaneously 2 times or are you running one after other.

    Did you forgot to delete temp tables that gets created?

    Saturday, June 25, 2011 4:24 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    User-2030397957 posted

    Thanks a lot for your response.

    I have dropper all the temporary table at the end of procedure.

    This things happen executing same SP 2 times means one  after other.means execute same SP againg second time.

    this things happen when I am execution in My sql which has installed in locally.When I am executing SP while connecting to server its creating no issues.

    Saturday, June 25, 2011 4:55 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    User-1694870838 posted

    Hi,

    Could you please show your SP codes in the forums so that we can help you as soon as possble.

    Thanks!

    Best Regards,

    Damon

    Wednesday, June 29, 2011 9:52 PM