Article ID: 126048, created on Jun 29, 2015, last review on Jun 29, 2015

  • Applies to:
  • Odin Business Automation Standard 4.5

Symptoms

Al Containers registered in OBAS produce the application error under Top > Service Director > Virtuozzo Manager > Containers > Container number > Resources Problem report of the application error contains the following string:

DBD::mysql::st execute failed: Got error 134 from storage engine at /usr/lib/perl5/site_perl/5.8.8/HSPC/WebDB.pm line 286.

Customers with Virtuozzo Container subscriptions also see the Application error on the Home tab of their CPs.

Cause

A database table is corrupted.

Resolution

To resolve the issue, locate and repair the culprit table using ordinary MySQL means. The example is below.

# mysqlcheck -A
...
aspc.ve_net_stat_history
warning  : 1 client is using or hasn't closed the table properly
error    : Record-count is not ok; is 300821   Should be: 301031
warning  : Found 899316 deleted space.   Should be 887976
warning  : Found 16654 deleted blocks       Should be: 16444
error    : Corrupt
...
# mysql

mysql> use aspc;
Database changed

mysql> repair table ve_net_stat_history;
+--------------------------+--------+----------+----------------------------------------------+

| Table                    | Op     | Msg_type | Msg_text                                     |
+--------------------------+--------+----------+----------------------------------------------+

| aspc.ve_net_stat_history | repair | warning  | Number of rows changed from 301031 to 300821 |
| aspc.ve_net_stat_history | repair | status   | OK                                           |
+--------------------------+--------+----------+----------------------------------------------+
2 rows in set (1.19 sec)

Search Words

mysqlcheck

Got error 134 from storage engine

database corruption

Record-count is not ok

624ca542e40215e6f1d39170d8e7ec75 caea8340e2d186a540518d08602aa065 400e18f6ede9f8be5575a475d2d6b0a6 70a5401e8b9354cd1d64d0346f2c4a3e

Email subscription for changes to this article
Save as PDF