Results 1 to 4 of 4
  1. #1
    Join Date
    May 2013
    Posts
    6

    Post Unanswered: mysql database server issue

    Hi All,

    I tried to run mysql database server like below,i am getting pid ended.

    [mysql@TEST-LSM-R app] $ ./bin/mysqld_safe&
    [1] 6724
    [mysql@TEST-LSM-R app] $ 130503 09:07:32 mysqld_safe logging to '/db/mysql/data/TEST-LSM-R.err'.
    130503 09:07:33 mysqld_safe Starting mysqld daemon with database from /db/mysql/data
    130503 09:07:33 mysqld_safe mysqld from pid file /db/mysql/data/TEST-LSM-R.pid ended



    [mysql@TEST-LSM-R app] $ /bin/mysqld_safe --console --user=mysql
    130503 12:44:29 mysqld_safe Logging to '/db/mysql/data/TEST-LSM-R.log'.
    130503 12:44:29 mysqld_safe Starting mysqld daemon with databases from /db/mysql/data
    130503 12:44:29 mysqld_safe mysqld from pid file /db/mysql/data/TEST-LSM-R.pid ended

    plz can any one let me know why this issue coming.

    Regards,
    Hari

  2. #2
    Join Date
    May 2013
    Posts
    6

    mysql database server startup issue

    Here is the error logs,

    I check error log. log files located in the data directory, ifound the below errors,

    [root@TEST-R data]# tail -f TEST-R.err /db/mysql/app/bin/mysqld: Can't create/write to file '/db/mysql/tmp/ib3xHqRO' (Errcode: 2)

    130503 12:38:17 InnoDB: Error: unable to create temporary file; errno: 2

    130503 12:38:17 [ERROR] Plugin 'InnoDB' init function returned error.

    130503 12:38:17 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

    130503 12:38:17 [ERROR] Unknown/unsupported storage engine: InnoDB

    130503 12:38:17 [ERROR] Aborting

    130503 12:38:17 [Note] /db/mysql/app/bin/mysqld: Shutdown complete

    130503 12:38:17 mysqld_safe mysqld from pid /db/mysql/data/TEST-LSM-R.pid ended

    Can any one give me the solution how to fix this issue.

    Regards, Hari

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    In general, error number 2 indicates that the file or directory does not exist.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Based on http://www.dbforums.com/mysql/169251...es-failed.html I would guess that the questions there are the root cause of this problem.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

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