Results 1 to 9 of 9

Thread: MySQL is not starting up

  1. #1
    phantom32i is offline Intermediate Member
    Join Date
    Apr 2007
    Posts
    21
    Rep Power
    7

    Default MySQL is not starting up

    I am using Network edition 4.5.6
    Everything was working fine until suddenly i could not log in.
    I tried restarting zimbra and when it came to stopping mailbox.. it says FAILED

    trying to Zmcontrol start will give me this error


    zimbra@chiuyi-server:/root$ zmcontrol start
    Host chiuyi.vn
    Starting ldap...Done.

    FAILED
    bdb_db_close: txn_checkpoint failed: Invalid argument (22)
    backend_startup_one: bi_db_open failed! (22)
    bdb_db_close: alock_close failed
    ERROR - failed to start slapd


    What Should I do...??? Please help I have 70 ppl that need this server to be working in 24 hrs.

  2. #2
    quanah is offline Zimbra Employee
    Join Date
    May 2007
    Location
    Zimbra
    Posts
    1,185
    Rep Power
    9

    Default

    Try removing the alock file in /opt/zimbra/openldap-data and then restarting slapd.
    Quanah Gibson-Mount
    Server Architect
    Zimbra, Inc
    --------------------
    Zimbra :: the leader in open source messaging and collaboration

  3. #3
    phantom32i is offline Intermediate Member
    Join Date
    Apr 2007
    Posts
    21
    Rep Power
    7

    Default still not working after removing alock

    Try removing the alock file in /opt/zimbra/openldap-data and then restarting slapd.
    __________________

    I removed the alock file but still not starting up.

  4. #4
    quanah is offline Zimbra Employee
    Join Date
    May 2007
    Location
    Zimbra
    Posts
    1,185
    Rep Power
    9

    Default

    Okay... Try this:

    cd ~/openldap-data
    /opt/zimbra/sleepycat/bin/db_recover
    Quanah Gibson-Mount
    Server Architect
    Zimbra, Inc
    --------------------
    Zimbra :: the leader in open source messaging and collaboration

  5. #5
    phantom32i is offline Intermediate Member
    Join Date
    Apr 2007
    Posts
    21
    Rep Power
    7

    Default Working!!!

    WOW!

    Working back as normal.
    What was that command for?


    Thanks a Million!!!

  6. #6
    quanah is offline Zimbra Employee
    Join Date
    May 2007
    Location
    Zimbra
    Posts
    1,185
    Rep Power
    9

    Default

    The alock file is used by slapd to track the state of the BDB database that is used to store the data. In your case, it appear something happened that made the alock file unstable. Sometimes removing it will allow slapd to recover. It didn't in your case. The db_recover command does a force recover on the underlying BDB database. It usually is not necessary to do that, as slapd uses the alock file to determine whether or not that is necessary, and will do it itself on startup if required.
    Quanah Gibson-Mount
    Server Architect
    Zimbra, Inc
    --------------------
    Zimbra :: the leader in open source messaging and collaboration

  7. #7
    phantom32i is offline Intermediate Member
    Join Date
    Apr 2007
    Posts
    21
    Rep Power
    7

    Default backup

    The alock file is used by slapd to track the state of the BDB database that is used to store the data. In your case, it appear something happened that made the alock file unstable. Sometimes removing it will allow slapd to recover. It didn't in your case. The db_recover command does a force recover on the underlying BDB database. It usually is not necessary to do that, as slapd uses the alock file to determine whether or not that is necessary, and will do it itself on startup if required.
    __________________

    Does that mean if i do not backup manually.. db_recover will still work most of the time?

  8. #8
    alexc1103 is offline Starter Member
    Join Date
    Oct 2006
    Posts
    2
    Rep Power
    8

    Default Nice One

    Nice one, this just saved my bacon!

    Thanks again

  9. #9
    quanah is offline Zimbra Employee
    Join Date
    May 2007
    Location
    Zimbra
    Posts
    1,185
    Rep Power
    9

    Default

    Quote Originally Posted by phantom32i View Post
    __________________

    Does that mean if i do not backup manually.. db_recover will still work most of the time?
    Depends on the type of failure. If your disk died, then no, there's nothing it could do about that.

    --Quanah
    Quanah Gibson-Mount
    Server Architect
    Zimbra, Inc
    --------------------
    Zimbra :: the leader in open source messaging and collaboration

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Zimbra fails after working for 2 weeks
    By Linsys in forum Administrators
    Replies: 10
    Last Post: 10-07-2008, 12:42 AM
  2. postfix stopped
    By riegersteve in forum Administrators
    Replies: 1
    Last Post: 05-15-2007, 03:25 PM
  3. Replies: 18
    Last Post: 03-20-2006, 02:22 PM
  4. Zimbra on Debian?
    By omry_y in forum Installation
    Replies: 25
    Last Post: 11-04-2005, 11:36 AM
  5. Can't start MySQL to init db - Gentoo
    By fak3r in forum Installation
    Replies: 3
    Last Post: 10-10-2005, 06:59 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •