You need to restore previous version of psa database from dump in /var/lib/psa/dumps and start bootstrapper repair. If you are not familiar with it I can recommend you ask free assistance here -
http://odin.com/products/plesk/free-migration-support/
Thank you for response
After doing database restore I het this:
Started bootstrapper repair procedure. This may take a while.
Certain actions may be skipped if not applicable.
-- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.
Finishing up upgrade procedures and rerunning previously failed upgrade actions...
**** Product repair started.
===> Checking for previous installation ... not found.
Started bootstrapper repair procedure. This may take a while.
Certain actions may be skipped if not applicable.
Trying to start service mysql... /usr/sbin/mysqld (pid 193) is running...
done
Trying to establish test connection... connected
done
Trying to start service mysql... /usr/sbin/mysqld (pid 193) is running...
done
Trying to establish test connection... connected
done
Trying to find psa database... not found
ERROR 1049 (42000): Unknown database 'psa'
ERROR 1049 (42000): Unknown database 'psa'
Trying to backup MySQL database... Warning: Not dumping MySQL database 'psa' as it doesn't exist
Warning: Not dumping MySQL database 'horde' as it doesn't exist
Warning: Not dumping MySQL database 'atmail' as it doesn't exist
done
MySQL databases are dumped to /var/lib/psa/dumps/mysql.preupgrade.-12.0.18.20140820-095610.dump.gz
Finishing up upgrade procedures and rerunning previously failed upgrade actions...
/opt/psa/bootstrapper/pp12.0.18-bootstrapper/bootstrapper.sh: line 888: /usr/lib/plesk-9.0/vps_optimized_aspects/mysql-innodb: No such file or directory
ERROR 1049 (42000): Unknown database 'psa'
ERROR 1049 (42000): Unknown database 'psa'
ERROR 1049 (42000): Unknown database 'psa'
ERROR 1049 (42000): Unknown database 'psa'
Trying to set up APS controller database... ERROR 1007 (HY000) at line 1: Can't create database 'apsc'; database exists
InnoDB
=====================================
140820 9:56:10 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 17 seconds
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 7, signal count 7
Mutex spin waits 0, rounds 414, OS waits 2
RW-shared spins 10, OS waits 5; RW-excl spins 4, OS waits 0
------------
TRANSACTIONS
------------
Trx id counter 0 14344261
Purge done for trx's n
< 0 14344256 undo n
< 0 0
History list length 14
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0 0, not started, process no 193, OS thread id 139734820013824
MySQL thread id 830, query id 12750 localhost admin
SHOW ENGINE innodb status
--------
FILE I/O
--------
I/O thread 0 state: waiting for i/o request (insert buffer thread)
I/O thread 1 state: waiting for i/o request (log thread)
I/O thread 2 state: waiting for i/o request (read thread)
I/O thread 3 state: waiting for i/o request (write thread)
Pending normal aio reads: 0, aio writes: 0,
ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
Pending flushes (fsync) log: 0; buffer pool: 0
5296 OS file reads, 1685 OS file writes, 468 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 5, seg size 7,
0 inserts, 0 merged recs, 0 merges
Hash table size 4441, node heap has 3 buffer(s)
0.00 hash searches/s, 0.00 non-hash searches/s
---
LOG
---
Log sequence number 1 22183045
Log flushed up to 1 22183045
Last checkpoint at 1 22183045
0 pending log writes, 0 pending chkp writes
309 log i/o's done, 0.00 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 11593546; in additional pool allocated 510208
Dictionary memory allocated 4262976
Buffer pool size 128
Free buffers 0
Database pages 125
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages read 5630, created 3, written 1529
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
1 read views open inside InnoDB
Main thread process no. 193, id 139734662006528, state: waiting for server activity
Number of rows inserted 1, updated 0, deleted 1, read 6782
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
ERROR 1396 (HY000) at line 1: Operation CREATE USER failed for 'apsc'@'localhost'
InnoDB
=====================================
140820 9:56:10 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 0 seconds
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 7, signal count 7
Mutex spin waits 0, rounds 414, OS waits 2
RW-shared spins 10, OS waits 5; RW-excl spins 4, OS waits 0
------------
TRANSACTIONS
------------
Trx id counter 0 14344261
Purge done for trx's n
< 0 14344256 undo n
< 0 0
History list length 14
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0 0, not started, process no 193, OS thread id 139734820214528
MySQL thread id 833, query id 12759 localhost admin
SHOW ENGINE innodb status
--------
FILE I/O
--------
I/O thread 0 state: waiting for i/o request (insert buffer thread)
I/O thread 1 state: waiting for i/o request (log thread)
I/O thread 2 state: waiting for i/o request (read thread)
I/O thread 3 state: waiting for i/o request (write thread)
Pending normal aio reads: 0, aio writes: 0,
ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
Pending flushes (fsync) log: 0; buffer pool: 0
5296 OS file reads, 1685 OS file writes, 468 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 5, seg size 7,
0 inserts, 0 merged recs, 0 merges
Hash table size 4441, node heap has 3 buffer(s)
0.00 hash searches/s, 0.00 non-hash searches/s
---
LOG
---
Log sequence number 1 22183045
Log flushed up to 1 22183045
Last checkpoint at 1 22183045
0 pending log writes, 0 pending chkp writes
309 log i/o's done, 0.00 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 11593546; in additional pool allocated 510208
Dictionary memory allocated 4262976
Buffer pool size 128
Free buffers 0
Database pages 125
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages read 5630, created 3, written 1529
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
1 read views open inside InnoDB
Main thread process no. 193, id 139734662006528, state: waiting for server activity
Number of rows inserted 1, updated 0, deleted 1, read 6782
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
APS db accessibility check was skipped.
ERROR while trying to can not find "register_apsc_database.php"
Check the error reason(see log file: /var/log/plesk/install/plesk_12.0.18_repair.log), fix and try again
***** problem report *****
ERROR while trying to can not find "register_apsc_database.php"
Check the error reason(see log file: /var/log/plesk/install/plesk_12.0.18_repair.log), fix and try again
Facebook
Twitter
