We make accounting easy. So you can focus on your business.
Simply Accounting Support Community
Search in

MYSQL already running

Last post 01-06-2009 2:03 PM by bbuchanan. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next
  • 10-06-2008 8:36 AM

    MYSQL already running

    Periodically users get the unable to find connection manager error. When I go to the server the connection manager is running when I try to open a database from the server I get the same error. Further investigation show an event error relating to mysqld already running. When I look in taskmgr no mysqld processes. If I reboot the server everything is fine for a day or so. Below is the actual event that I see.

    Event Type: Error
    Event Source: MySQL
    Event Category: None
    Event ID: 100
    Date:  06/10/2008
    Time:  7:50:27 AM
    User:  N/A
    Computer: SERVER06
    Description:
    Do you already have another mysqld server running on port: 13540 ?

    For more information, see Help and Support Center at http://www.mysql.com

     I'm assuming that the mysqld process is hung somewhere in the shutdown after the last user disconnects. Has anyone seen this issue and if so is there a solution. My users are getting tired of me rebooting the server just as they are getting their days started.

     

    Thanks for any insight.

     

    Brian

  • 10-07-2008 2:42 PM In reply to

    Re: MYSQL already running

     Hi Brian,

    When looking in the task manager, make sure you check the box, on the bottom left, that says "Show processes from all users" 

    The most common cause of this is a users workstation crashing or Simply Accounting crashing.  Basically, when Simply Accounting isn't closed properly, the server does not know that the program has shut down so it keeps the process running.  

    Nemanja
    Customer Support Analyst
    Simply Accounting by Sage
  • 10-21-2008 10:11 AM In reply to

    Re: MYSQL already running

    Sorry for the long delay in replying it has been behaving. This morning it was back to the old tricks again. When I look in task manager and click on show other users processes it's still not there.

    I'm trying to narrow it down to a specific user.

    Is there a way to kill this process that I can't see without rebooting the server?

     

    Thanks

  • 01-06-2009 2:03 PM In reply to

    Re: MYSQL already running

    Haven't posted in a while I was hoping 2009 would fix my problem. Not so.

     I have eliminated all but 2 users and have instructed the on proper shut down. Is there a reason that restarting the Connection Manager Service doesn't at the very leasy give the option to clean up open connections.

     I'm at a loss and my users are getting very frustrated with me rebooting the server every few days.

     

Page 1 of 1 (4 items)