ERROR: Zend_Db_Statement_Exception

[Graphrix]

Today I try to log into the admin control and get the following error.

ERROR: Zend_Db_Statement_Exception
SQLSTATE[HY000]: General error: 1030 Got error -1 from storage engine​

I have plenty of disc space

[root@host /]# df -h && df -hi
Filesystem Size Used Avail Use% Mounted on
/dev/md2 909G 31G 833G 4% /
tmpfs 1.8G 12K 1.8G 1% /dev/shm
/dev/md0 194M 147M 38M 80% /boot
Filesystem Inodes IUsed IFree IUse% Mounted on
/dev/md2 58M 327K 58M 1% /
tmpfs 454K 2 454K 1% /dev/shm
/dev/md0 50K 67 50K 1% /boot​

I have checked the permissions on the /tmp folder and restarted as suggested on the parallels website. http://kb.odin.com/en/6595

chmod 1777 /tmp

/etc/init.d/mysqld restart​

This has only happened since installing the latest Parallels update from the Parallels admin control panel.

OS - Centos 6.5
Parallels - version 12 with latest update - has the management and other packages as well.


There also seems to be a problem sending emails using webmail and a MySQL issue as databases don't seem to be working unless the server is rebooted every few hours.

Can I get some assistance with this ASAP please.



+++++++++++++++++++++++++++++++++++++++++++++++++

Have cleared out a bit and still have all the same issues.

[root@host /]# df -h && df -hi
Filesystem Size Used Avail Use% Mounted on
/dev/md2 909G 30G 834G 4% /
tmpfs 1.8G 12K 1.8G 1% /dev/shm
/dev/md0 194M 63M 122M 34% /boot
Filesystem Inodes IUsed IFree IUse% Mounted on
/dev/md2 58M 320K 58M 1% /
tmpfs 454K 2 454K 1% /dev/shm
/dev/md0 50K 46 50K 1% /boot

 

[Graphrix]

I ran the following command /usr/local/psa/bootstrapper/pp11.5.30-bootstrapper/bootstrapper.sh repair

This is the result .....

######################################


[root@host /]# /usr/local/psa/bootstrapper/pp11.5.30-bootstrapper/bootstrapper.s h repair
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...
===> Cumulative Plesk database upgrade and repair (revertable stage) has been started.
===> Preparing Plesk database upgrade (revertable stage).

**** Product repair started.

===> Checking for previous installation ... found.
Started bootstrapper repair procedure. This may take a while.
Certain actions may be skipped if not applicable.

Trying to start service mysqld... mysqld (pid 1535) is running...
done
Trying to establish test connection... connected
done
Trying to find psa database... version is 012000018
Trying to backup MySQL database... done
MySQL databases are dumped to /var/lib/psa/dumps/mysql.preupgrade.12.0.18-11.5.30.20140918-191556.dump.gz
Finishing up upgrade procedures and rerunning previously failed upgrade actions...
===> Cumulative Plesk database upgrade and repair (revertable stage) has been started.
Upgrade or repair for 'core' (stage 'prep') is not required
===> Preparing Plesk database upgrade (revertable stage).
Trying to resolve hostname 'host.gfxserver.com' and validate its IP address... done

Trying to set psa database version to 011005030... ERROR 1030 (HY000) at line 1: Got error -1 from storage engine
InnoDB
=====================================
140918 19:16:01 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 22 seconds
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 88, signal count 88
Mutex spin waits 0, rounds 21, OS waits 1
RW-shared spins 28, OS waits 14; RW-excl spins 74, OS waits 73
------------
TRANSACTIONS
------------
Trx id counter 0 24743311
Purge done for trx's n < 0 24612580 undo n < 0 0
History list length 5
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0 0, not started, process no 1535, OS thread id 140723069880064
MySQL thread id 48, query id 6741 localhost admin
SHOW ENGINE innodb status
---TRANSACTION 0 0, not started, process no 1535, OS thread id 140723070146304
MySQL thread id 2, query id 183 localhost admin
---TRANSACTION 0 24742920, not started, process no 1535, OS thread id 140723069613824
MySQL thread id 11, query id 31 localhost admin
--------
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
1306 OS file reads, 8 OS file writes, 8 OS fsyncs
51.09 reads/s, 20858 avg bytes/read, 0.05 writes/s, 0.05 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 0, seg size 2,
0 inserts, 0 merged recs, 0 merges
Hash table size 17393, node heap has 2 buffer(s)
15.86 hash searches/s, 87.22 non-hash searches/s
---
LOG
---
Log sequence number 0 1835139369
Log flushed up to 0 1835139369
Last checkpoint at 0 1835139359
0 pending log writes, 0 pending chkp writes
11 log i/o's done, 0.05 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 22635160; in additional pool allocated 1033472
Dictionary memory allocated 2116800
Buffer pool size 512
Free buffers 0
Database pages 510
Modified db pages 1
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages read 1607, created 0, written 1
65.04 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 987 / 1000
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
1 read views open inside InnoDB
Main thread process no. 1535, id 140722940389120, state: sleeping
Number of rows inserted 0, updated 0, deleted 0, read 82668
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 3705.83 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================


ERROR while trying to execute SQL query, the query was: replace into misc (param,val) values('version', '011005030')
Check the error reason(see log file: /tmp/plesk_11.5.30_repair.log), fix and try again

***** problem report *****
ERROR while trying to execute SQL query, the query was: replace into misc (param,val) values('version', '011005030')
Check the error reason(see log file: /tmp/plesk_11.5.30_repair.log), fix and try again

 

[Graphrix]

Have tried the following commands:


# /usr/local/psa/admin/bin/webmailmng --install --name=horde
# /usr/local/psa/admin/bin/webmailmng --enable --name=horde
# /usr/local/psa/admin/sbin/httpdmng --reconfigure-all

I get the following errors.

[root@host /]# /usr/local/psa/admin/bin/webmailmng --install --name=horde
Unable to change record into database, details are in mail log. Check it, please.
[root@host /]# /usr/local/psa/admin/bin/webmailmng --enable --name=horde
Unable to change record into database, details are in mail log. Check it, please.
[root@host /]# /usr/local/psa/admin/sbin/httpdmng --reconfigure-all
SQLSTATE[HY000]: General error: 1030 Got error -1 from storage engine

 

[Graphrix]

/usr/local/psa/admin/conf/php.ini

short_open_tag = On
y2k_compliance = Off
output_buffering = Off
max_execution_time = 600
max_input_time = 600
memory_limit = 256M
max_file_uploads = 99999
max_input_vars = 2000

; error_reporting = E_ALL & ~E_NOTICE & ~E_STRICT & ~E_DEPRECATED
error_reporting = E_ALL & ~E_STRICT & ~E_DEPRECATED
log_errors = On
display_errors = Off
warn_plus_overloading = Off
expose_php = Off

variables_order = "ECGPS"
register_argc_argv = On
post_max_size = 2147483647
magic_quotes_gpc = Off
magic_quotes_runtime = Off

include_path = "/usr/local/psa/admin/plib:/usr/local/psa/admin/externals"
upload_tmp_dir = "/tmp"
upload_max_filesize = 2147483647

opcache.enabled=1
opcache.memory_consumption=100
opcache.fast_shutdown=1

swkey.repository_dir = "/etc/sw/keys"

psasem.semfile = "/usr/local/psa/var/psasem.sem"

zend_extension = "/usr/lib64/php/modules/sw-engine/ioncube_loader_lin_5.5.so"
zend_extension = "/usr/lib64/php/modules/sw-engine/opcache.so"


'/etc/my.cnf':

[mysqld]
local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
innodb_force_recovery = 1


[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

 

[Graphrix]

I cannot log in to get the plsk key for support.

Any help please?

 

[IgorG]

There are two possible causes:

- Databases are corrupted and require repair.
- After repair of databases has been completed, innodb_force_recovery was not disabled and prevents update/delete operations with Plesk database.

I see that innodb_force_recovery is enabled in your /etc/my.cnf. Disable it and restart mysqld (or mysql) service.

If service does not start or crashes with crash reports in MySQL log file (/var/log/mysqld.log or other file defined as value to configuration parameter log-error in /etc/my.cnf), then InnoDB storage engine requires repair. Repair can be done following instructions from KB article http://kb.odin.com/6586