Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Mysql could not be started on Pentaho 3.7/linux

  1. #1
    Join Date
    Jun 2009
    Posts
    11

    Default Mysql could not be started on Pentaho 3.7/linux

    Hello Guys,

    I installed Pentaho 3.7 on a linux box. I didnt really change or try anything, sticked with the defaults. It was running fine for a couple days. Then I tried restarting the server using the ctlscript under Pentaho folder.

    It returned error saying cannot restart mysql... and these are the logs from mysqld file under mysql


    110315 17:53:34 mysqld_safe mysqld from pid file /home/pentaho/pentaho/mysql/data/bidev.buydomains.com.pid ended
    110315 17:59:18 mysqld_safe Starting mysqld.bin daemon with databases from /home/pentaho/pentaho/mysql/data
    110315 17:59:18 [Note] Plugin 'FEDERATED' is disabled.
    /home/pentaho/pentaho/mysql/bin/mysqld.bin: Can't find file: './mysql/plugin.frm' (errno: 13)
    110315 17:59:18 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
    /home/pentaho/pentaho/mysql/bin/mysqld.bin: Can't create/write to file '/home/pentaho/pentaho/mysql/tmp/ib6lWUOj' (Errcode: 13)
    110315 17:59:18 InnoDB: Error: unable to create temporary file; errno: 13
    110315 17:59:18 [ERROR] Plugin 'InnoDB' init function returned error.
    110315 17:59:18 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
    110315 17:59:18 [ERROR] Unknown/unsupported table type: InnoDB
    110315 17:59:18 [ERROR] Aborting


    After this User console wont load and returns 404 error and enterprise console shows

    test did not complete errors.
    PacProService.ERROR_0040

    Please help.

    Thanks,

    Praneeth

  2. #2

    Default

    Hi Praneeth,

    I checked with one of our MySQL gurus and it may be file permissions. If that doesn't work it might be something with user permissions. If that fails, you may want to resinstall MySQL.

    You may want to check with the MySQL forum to get a better understanding of the error.
    The best thing about a boolean is even if you are wrong, you are only off by a bit.
    Anonymous

  3. #3
    Join Date
    Jun 2007
    Posts
    260

    Default

    Did you run 'mysql_upgrade', as was suggested by the logs?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.