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

Critical problem when trying to update to version 8.0

Discussion in 'Plesk for Linux - 8.x and Older' started by BillieGDJoe, May 9, 2006.

  1. BillieGDJoe

    BillieGDJoe Guest

    0
     
    Hi guys,



    Im having a critical problem when trying to update to new version (8.0) from 7.5.4. The problem is:


    This night, my Plesk 7.5.4 stop to work properly, e-mail service stops, with a error of relay denied. So I try to upgrade to Plesk 8.0. Then, the update from graphical interface not work. So, I try for the command line, with the autoinstaller:

    # /usr/local/psa/admin/sbin/autoinstaller --select-release-id PLESK_8_0_0 --install-everything

    The process starts well, until I got this error:

    ===> Installing and configuring Named Server

    Stop running named daemon

    Now BIND server shutting down...

    Trying to stop BIND server... done
    Trying to untar named run-root directory structure... done
    Trying to set up default permissions... done
    Trying to start BIND server... done

    BIND server starts Ok.


    Now BIND server shutting down...

    Trying to stop BIND server... done
    Trying to define super-server internet daemon type... xinetd
    Trying to comment out old record for service poppassd... done
    Trying to set up record for service poppassd... done
    Trying to restart xinetd daemon... Trying to install chrooted environment... done
    ===> Installing phpMyAdmin
    done
    ===> Cumulative upgrade has been started
    Trying to install a new key... Installing /etc/psa/psa.key.
    done
    Trying to apply 8.0.0 changes to database...
    ERROR while trying to upgrade SQL database from 750
    Check the error reason(see log file: /tmp/psa_8.0.0_RedHat_el4_build80060331.13_upgrade.log), fix and try again

    Aborting...

    error: %post(psa-8.0.0-rhel4.build80060331.13.i586) scriptlet failed, exit status 1



    The file /tmp/psa_8.0.0_RedHat_el4_build80060331.13_upgrade.log have:

    ===> Installing phpMyAdmin
    done
    Trying to install a new key... Installing /etc/psa/psa.key.
    done
    Trying to apply 8.0.0 changes to database... ERROR 1062 (23000) at line 179: Duplicate entry 'Teste-mysql' for key 2

    =====================================
    060509 15:45:37 INNODB MONITOR OUTPUT
    =====================================
    Per second averages calculated from the last 19 seconds
    ----------
    SEMAPHORES
    ----------
    OS WAIT ARRAY INFO: reservation count 119386, signal count 104761
    Mutex spin waits 5775874, rounds 12735914, OS waits 56139
    RW-shared spins 81828, OS waits 21020; RW-excl spins 257081, OS waits 17021
    ------------
    TRANSACTIONS
    ------------
    Trx id counter 0 17274081
    Purge done for trx's n:eek: < 0 17271311 undo n:eek: < 0 0
    History list length 107







    Anyone please can help me ?? Thanks in advance !





    BJ
     
  2. CiViX

    CiViX Guest

    0
     
    I had the same problem only my error was:

    Code:
    Trying to apply 8.0.0 changes to database... ERROR 1062 (23000) at line 179: Duplicate entry 'Joomla-mysql' for key 2
    The problem seems to be that it finds entries in the table called "data_bases" (in the database "psa") which have the same name... earlier "joomla" and "Joomla" were considered different, but with PLESK8 it 's now case-insensitive, so these two name are treated as the same, hence the "duplicate error".

    First delete the psa database and restore the original database. You'll find a dump of the original psa, mysql and horde databases here:
    /var/lib/psa/dump/mysql.preupgrade.dump.gz

    If there are multiple files ending with .1, .2 an so forth, use the oldest one (the one which was taken when your tried to upgrade to PLESK8 the first time).

    First make a backupcopy and then unzip it:
    # cp /var/lib/psa/dump/mysql.preupgrade.dump.gz /root
    # gunzip -d /root/mysql.preupgrade.dump.gz

    You'll now have the file /root/mysql.preupgrade.dump

    Delete psa:
    # mysql -uadmin -p psa
    (Enter your admin-password when requested.)

    mysql> drop database psa;
    mysql> create database psa;
    mysql> quit

    Import the backup:
    # mysql -uadmin -p < /root/mysql.preupgrade.dump
    (Enter your admin-password when requested.)

    When the original database have been restored, it's time to fix the problem.

    You need to delete on of the values that are causing the problem. In your case these values are "teste" and "Teste". Log into mysql again and find the offending values:

    # mysql -uadmin -p psa
    mysql> select * from data_bases where name = 'Teste';

    Remember the id og this row. Write down (or copy'n'paste) the values for this row so that you can put it back later.

    Delete the row:
    mysql> delete from data_bases where id = XXX;
    (Where XXX is the id of the row with Teste.)

    mysql> quit

    Now change to the directory where the base-packages of PLESK8 are. If necessary download the tar.gz from the swsoft site, unpack and then change to the base-directory. Then force a reinstall:
    # rpm -Uhv --force *.rpm

    After the install is finished, you have to put back the rows you deleted. You can do this either in the shell or by logging into PLESK and using the administrators phpMyAdmin (DB WebAdmin).

    I hope this helps!
     
Loading...