Find the answer to your Linux question:
Results 1 to 3 of 3
I am doing a backup server for an already existing servers set up, I use to ubuntu linux. it is DRBD (protocol C) together with heartbeat used, which is configured ...
  1. #1
    Just Joined!
    Join Date
    Jun 2010
    Posts
    4

    Smile mysql fails to start

    I am doing a backup server for an already existing servers set up, I use to ubuntu linux.
    it is DRBD (protocol C) together with heartbeat used, which is configured so that in case of error including the MySQL5 Server on the backup server starts
    I want to start mysql server after replication using drbd and heartbeat.
    I changed datadir in my.cnf file and in apparmor.d/usr.bin.mysqld also.
    Mysql starts when drbd device is not mounted.

    My logs shows as follows:

    Oct 26 12:55:28 twyford-hambc2 mysqld[27627]: 101026 12:55:28 InnoDB: Operating system error number 13 in a file operation.
    Oct 26 12:55:28 twyford-hambc2 mysqld[27627]: InnoDB: The error means mysqld does not have the access rights to
    Oct 26 12:55:28 twyford-hambc2 mysqld[27627]: InnoDB: the directory.
    Oct 26 12:55:28 twyford-hambc2 mysqld[27627]: InnoDB: File name ./ibdata1
    Oct 26 12:55:28 twyford-hambc2 mysqld[27627]: InnoDB: File operation call: 'open'.
    Oct 26 12:55:28 twyford-hambc2 mysqld[27627]: InnoDB: Cannot continue operation.
    Oct 26 12:55:28 twyford-hambc2 mysqld_safe[27634]: ended

    Oct 26 12:55:42 twyford-hambc2 kernel: [ 2876.791880] type=1503 audit(1288094142.991:53: operation="inode_permission" requested_mask="::r" denied_mask="::r" fsuid=0 $
    Oct 26 12:55:42 twyford-hambc2 /etc/init.d/mysql[27799]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
    Oct 26 12:55:42 twyford-hambc2 /etc/init.d/mysql[27799]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
    Oct 26 12:55:42 twyford-hambc2 /etc/init.d/mysql[27799]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
    Oct 26 12:55:42 twyford-hambc2 /etc/init.d/mysql[27799]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
    Oct 26 12:55:42 twyford-hambc2 /etc/init.d/mysql[27799]:
    Oct 26 12:56:46 twyford-hambc2 lrmd: [17345]: WARN: mysql:start process (PID 2732 timed out (try 1). Killing with signal SIGTERM (15).
    Oct 26 12:56:46 twyford-hambc2 lrmd: [17345]: WARN: operation start[139] on ocf::mysql::mysql for client 17348, its parameters: socket=[/var/run/mysqld/mysqld.sock] bi$


    Please help in solving this....

  2. #2
    Linux Guru Rubberman's Avatar
    Join Date
    Apr 2009
    Location
    I can be found either 40 miles west of Chicago, or in a galaxy far, far away.
    Posts
    8,977
    Seems clear enough - MySQL doesn't have permissions to access the database itself. If mounted on a remote system, then that is likely the problem - you may need to alter the mount parameters, or the file permissions on the hosting system.
    Sometimes, real fast is almost as good as real time.
    Just remember, Semper Gumbi - always be flexible!

  3. #3
    Just Joined!
    Join Date
    Jun 2010
    Posts
    4

    regarding mysql replication using drbd heartbeat

    Thanks for your reply.
    I am new to linux.
    So please tell the exact location to check the mount parameters .

    Mythili

Posting Permissions

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