MySql Service Stopper while Execution of SP RRS feed

  • Question

  • 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

  • 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
  • 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
  • User-1694870838 posted


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


    Best Regards,


    Wednesday, June 29, 2011 9:52 PM