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

Help :( - Plesk admin died: ERROR: Unable to query: Can't open file: 'sessions.ibd' (

Discussion in 'Plesk for Linux - 8.x and Older' started by WebDork, Apr 2, 2006.

  1. WebDork

    WebDork Guest

    0
     
    Just in case anyone else has encountered similar...

    I have been trying to optimise my box. When I went to bed all seemed fine, when I woke up and tried to enter PLESK admin I got:

    I think I was playing with my.cnf last. I have tried different my.cnf to fix but no luck. Here is current content in case it is relevant.

    I tried to reload PLESK via the /var/lib/psa/dump but when I restored
    these again there seems to be lots of tables missing.

    I think the problem is MyISAM / InnoDB. When I look at the database in phpmyadmin it seems a mess of the two.

    Any ideas greatly appreciated.
     
  2. wagnerch

    wagnerch Guest

    0
     
  3. WebDork

    WebDork Guest

    0
     
    Thanks Wagnerch - no - Im not deliberatley using grant-tables - was just modifying bits and pieces to try and cope with load better.

    I have 2Gb ram and a heavily loaded box running a couple of large forums. Any suggestions on my.cnf ?

    I'll check out the link and hope it helps - thanks.

     
  4. servertune

    servertune Guest

    0
     
    This message means that psa data in /var/lib/mysql/psa is corrupted and you need to retrieve a copy form the backup at: /var/lib/psa/dumps
    gunzip one of the *.gz files and insert tables back to the psa
    database and you should be good.
     
  5. WebDork

    WebDork Guest

    0
     
    Thanks servertune. I tried that before, but basically gave me same error. I tried it again however and basically it would keep telling me certain tables were missing. So I added them manually. Had to to do this for maybe 5 or 6 tables. Would click something in plesk and it would tell me table was missing. Any reason why it wouldnt import them all reliably ? I turned off PSA. Im just worried one that I havent spotted yet will bite me down the track :)
     
  6. servertune

    servertune Guest

    0
     
    Repairing a table is not the best option. Any way, run these 3 commands at the prompt (in this order):

    Code:
    gunzip /var/lib/psa/dumps/mysql.preupgrade.dump.gz
    Code:
    mysql -uadmin -p`cat /etc/psa/.psa.shadow` -e"DROP DATABASE psa;"
    Code:
    mysql -uadmin -p`cat /etc/psa/.psa.shadow` < /var/lib/psa/dumps/mysql.preupgrade.dump
    See if that helps :)
     
  7. WebDork

    WebDork Guest

    0
     
    Thanks Andy, ended up being a corrupt table missing some data. I fixed it and all seems to be fine again.

    I removed the skip-grant-tables line from my.cnf

    Is there anything anyone else would recommend or change with my current config ? Remember I have 2Gb Ram.
     
  8. wagnerch

    wagnerch Guest

    0
     
    I would definately tune your query cache, since it sounds like:

    a) you have lots of memory (actually you mentioned it twice :) )
    b) you are running mysql 4.0 or later


    The query cache may have a big pay off, or not. It depends if your database is doing heavy writes then the query cache may just be flushed too frequently.

    http://www.mysql.com/news-and-events/newsletter/2003-01/a0000000108.html


    Before tuning too many things, I would recommend profiling what your server is doing *now*. Take a look at
    mysqlreport, and generally at http://hackmysql.com/. This link will help you understand what is coming out of mysqlreport.

    Another decent tool is mytop, which is useful for watching the server live.


    I must say I am not a huge fan of mysql, it has some very very awkward things that just seem strange to me for good database design. The lack of a real buffer cache is very disturbing to me.
     
Loading...