1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

New innodb tables stop PSA from loading

Discussion in 'Plesk for Linux - 8.x and Older' started by justinrossetti, Jan 20, 2006.

  1. justinrossetti

    justinrossetti Guest

    I just changed my /etc/my.cnf (mysql database config file)

    from the default


    # Data files must be able to hold your data and indexes.
    # Make sure that you have enough free disk space.
    innodb_data_file_path = ibdata1:200M:autoextend
    # Set buffer pool size to 50-80% of your computer's memory
    set-variable = innodb_buffer_pool_size=256M
    set-variable = innodb_additional_mem_pool_size=100M
    # Set the log file size to about 25% of the buffer pool size
    set-variable = innodb_log_file_size=100M
    set-variable = innodb_log_buffer_size=50M
    by first stoping mysql with "/etc/rc.d/init.d/mysqld stop", then changing the file, the starting mysql with "/etc/rc.d/init.d/mysqld start"

    now I get the errors:


    ERROR: Unable to query: Can't open file: 'misc.InnoDB'. (errno: 1) 0: /usr/local/psa/admin/plib/common_func.php3:203 psaerror(string "Unable to query: Can't open file: 'misc.InnoDB'. (errno: 1)") 1: /usr/local/psa/admin/plib/common_func.php3:390 db_query(string "select param, val from misc") 2: /usr/local/psa/admin/plib/class.Session.php:113 get_param(string "login_timeout") 3: /usr/local/psa/admin/auto_prepend/auth.php3:139 Session->Session()
    and when I try to restart PSA i get the error:

    [root@z mysql]# service psa stop1
    /usr/local/psa/admin/bin/httpsdctl stop: httpd stopped
    Stopping Plesk:                                            [  OK  ]
    [root@z mysql]# service psa start
    Unable to fetch SpamAssassin config from database: Can't open file: 'sa_conf.InnoDB'. (errno: 1)
    Starting psa-spamassassin service:                         [FAILED]
    ERROR 1016 at line 1: Can't open file: 'DomainServices.InnoDB'. (errno: 1)
    ERROR 1016 at line 1: Can't open file: 'sessions.InnoDB'. (errno: 1)
    Mysql error: Can't open file: 'key_history.InnoDB'. (errno: 1)
    Processing config directory: /usr/local/psa/admin/conf/httpsd.*.include
    /usr/local/psa/admin/bin/httpsdctl start: httpd started
    Starting Plesk:                                            [  OK  ]
    how do I have plesk use these new innodb files without using a backup or re-configuring my old plesk?

  2. justinrossetti

    justinrossetti Guest

    Ok, i didn't relize was set to use InnoDB. I did not even know what InnoDB was, thought all databases were store in there directory.

    So I deleted my old files below

    -rw-rw----   1 mysql mysql 209715200 Jan 21 03:07 ibdata1
    -rw-rw----   1 mysql mysql 104857600 Jan 21 03:07 ib_logfile0
    -rw-rw----   1 mysql mysql 104857600 Jan 21 01:53 ib_logfile1
    and now I can't open the PSA database with phpMyAdmin because new InnoDB files exsist.

    But I still see PSA files under


    So does my database still exist, if so how do I propergate InnoDB?

    If I did indeed delete my PSA database, how can I undelete those 3 files in linux? (i don't know the undelete command)

    will continue to research, any help would be great!
  3. justinrossetti

    justinrossetti Guest


    wow, let me try that. will report back.
    ok, that sucked all my files are *.frm. so no database?

    much search for backup ?

    wget [url]http://recover.sourceforge.net/linux/recover/download/recover-1.3c.tar.gz[/url]
    tar zxvf recover-1.3c.tar.gz
    cd recover-1.3c
    make install
    Getting inodes (this can take some time)...
    debugfs 1.35 (28-Feb-2004)
    (waited 5 minutes....)
    (answered questions....)
    did not work
  4. justinrossetti

    justinrossetti Guest

    from /var/log/mysqld.log


    060121 04:07:02  mysqld started
    InnoDB: The first specified data file ./ibdata1 did not exist:
    InnoDB: a new database to be created!
    060121  4:07:09  InnoDB: Setting file ./ibdata1 size to 200 MB
    InnoDB: Database physically writes the file full: wait...
    060121  4:07:56  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
    InnoDB: Setting log file ./ib_logfile0 size to 100 MB
    InnoDB: Database physically writes the file full: wait...
    060121  4:08:21  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
    InnoDB: Setting log file ./ib_logfile1 size to 100 MB
    InnoDB: Database physically writes the file full: wait...
    InnoDB: Doublewrite buffer not found: creating new
    InnoDB: Doublewrite buffer created
    InnoDB: Creating foreign key constraint system tables
    InnoDB: Foreign key constraint system tables created
    060121  4:08:49  InnoDB: Started
    /usr/libexec/mysqld: ready for connections
    so in atempt to make mysql faster by creating a larger InnoDB, i delete PSA database because I didn't relize that was where the data was stored.

    and I have zero restore options!! so i am lame. but atleast I understand how it works now right?
  5. justinrossetti

    justinrossetti Guest

    guess my next question is,

    do you have a database schema import script I can use to get pleask running again (with no settings ofcorse)

    and if I do run this, whats going to happen to my current clients setup ? will plesk delete all clients and vitural hosting because they are not in the database?

    is it safe to reinstall plesk without losing current system configs?
  6. justinrossetti

    justinrossetti Guest

    after all of that, no commets or help?
  7. AlleyKat

    AlleyKat Guest