Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: mysqldump hanging only when started by mysql-zrm

  1. #1

    Default mysqldump hanging only when started by mysql-zrm

    This is on opensolaris
    mysqldump 5.0.67
    mysql-zrm 2.1.1

    This seems to be an intermittent issue - as it only happens for cron jobs and large db.

    I have tried running mysqldump with the same input of mysql-zrm and it works just fine - i have run it from a perl script and it worked fine.

    So I am thinking it must have something to do with the env when its running in mysql-zrm.

    From the logs there is nothing of note. The logs just stop when it stops download from the db.

    On db site there are no errors.

    So I am pretty stuck.

    So any help would be great.

  2. #2
    Join Date
    Oct 2005
    Posts
    1,559

    Default

    1. Did you try running "mysqldump" as mysql user?
    2. Did you try running "mysqldump" from crontab?

    Paddy

  3. #3

    Default

    Quote Originally Posted by paddy View Post
    1. Did you try running "mysqldump" as mysql user?
    No - to clarify that this is user that you define in the mysql-zrm.conf?
    If this is true, then i can't as that user does not exist on the box thats running mysql-zrm.

    mysql-zrm run as root user, and that is what i have been using to test.

    Quote Originally Posted by paddy View Post
    2. Did you try running "mysqldump" from crontab?
    Paddy
    No will try this on monday

    For a db with the size of 66mb mysqldump keeps hanging on between 1st and 5th table.

    I run mysqldump in root console with the details from mysql-zrm is produces the correct dump.

    In same console I run mysql-zrm-schedule --now --backup-set XXXX and the mysqldump hangs

  4. #4

    Default

    Quote Originally Posted by paddy View Post
    1. Did you try running "mysqldump" as mysql user?
    2. Did you try running "mysqldump" from crontab?

    Paddy
    I have run mysqldump from crontab and it worked fine - copied the database as expected.

    So something is broke in the env of mysql-zrm.

    Really need some help on this as only a 1/4 of the databases were backed up.

  5. #5

    Question Back

    Right its broke again.

    Really need some help paddy...

    Again mysql-zrm-schedule is failing for the large dbs - mysqldump seems to just hang.

    Running mysqldump on its own brings down the db just fine

  6. #6
    Join Date
    Oct 2005
    Posts
    1,559

    Default

    Any information in mysqld logs? Do you know if mysqldump is waiting for read lock?

    What is the version of mysql server?

    Paddy

  7. #7

    Default

    Thanks for the reply.

    Can't find anything in the logs.

    Any idea how you can tell that mysqldump is waiting for read lock?

    its mysql 5.0.20 and 5.0.27

  8. #8

    Default still not clue whats going on

    Some more observations.

    when trying to do a full copy of the database with mysqldump, mysqldump seems to just stop.

    The file it is dumping to stops increasing in size, cpu usage goes to zero.

    There are no errors produced from it on why it has stopped.

    On the db side there are no errors in the logs - nothing in mysqld.log, mysql.error

    processlist states that the query is still running, with the State of "Writing to net"

  9. #9
    Join Date
    Oct 2005
    Posts
    1,559

    Default

    This is probably related to mysqldump options used by ZRM. Set verbose=1 in mysql-zrm.conf, run a backup. You will find the mysqldump options used by ZRM.

    Paddy

  10. #10

    Default

    Thanks for the reply.

    That was on of the first things I tried.

    If I copy the mysqldump link from the mysql-zrm verbose and run it on the cli it works fine, every time.

    I run mysql-zrm and it hangs on just about the same point.

    I have now been going these errors:
    mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `XXXXXX` at row: 31532

Posting Permissions

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