How to fix error 134 from storage engine

IPB WARNING [2] mysql_query() [function.mysql-query]: Unable to save
result set (Line: 457 of /ips_kernel/class_db_mysql.php)


There appears to be an error with the database.
You can try to refresh the page by clicking here.

Error Returned
mySQL query error: SELECT MIN(pid) as pid FROM ib_posts WHERE queued=0
AND topic_id=85734 AND post_date > 1160298086 LIMIT 0,1

SQL error: Got error 134 from storage engine
SQL error code:
Date: Wednesday 13th of October 2006 04:51:36 PM

How can I fix it?

Re: How to fix error 134 from storage engine

>IPB WARNING [2] mysql_query() [function.mysql-query]: Unable to save
>result set (Line: 457 of /ips_kernel/class_db_mysql.php)
>
>
>There appears to be an error with the database.
>You can try to refresh the page by clicking here.
>
>Error Returned
>mySQL query error: SELECT MIN(pid) as pid FROM ib_posts WHERE queued=0
>AND topic_id=85734 AND post_date > 1160298086 LIMIT 0,1
>
>SQL error: Got error 134 from storage engine
>SQL error code:
>Date: Wednesday 13th of October 2006 04:51:36 PM
>
>How can I fix it?

Try: REPAIR TABLE ib_posts;
Your table may be crashed.

Re: How to fix error 134 from storage engine

Yes, I agree with the previous responder. But before you do a repair
table, you can do a "check table .... extended" to see what the problem
is with the table... just in case you want to know.

Also... it is important to note that during the repair process several
records from the problematic table may be lost. I just went through
this a few weeks ago. I had a table with about 1500 records in it. I
was getting 134 error message. After repair... about 6 records were
lost. I'm not sure how to get around this, but I thought I would call
your attention to it so that it doesn't come as a surprise.

Andy


Thaqalainnaqvi@gmail.com wrote:
> IPB WARNING [2] mysql_query() [function.mysql-query]: Unable to save
> result set (Line: 457 of /ips_kernel/class_db_mysql.php)
>
>
> There appears to be an error with the database.
> You can try to refresh the page by clicking here.
>
> Error Returned
> mySQL query error: SELECT MIN(pid) as pid FROM ib_posts WHERE queued=0
> AND topic_id=85734 AND post_date > 1160298086 LIMIT 0,1
>
> SQL error: Got error 134 from storage engine
> SQL error code:
> Date: Wednesday 13th of October 2006 04:51:36 PM
>
> How can I fix it?

Re: How to fix error 134 from storage engine

torpecool wrote:

mySQL query error: DELETE FROM ib_sessions WHERE member_id=11089

SQL error: Can't open file: 'ib_sessions.MYI' (errno: 145)
SQL error code:
Date: Tuesday 17th of October 2006 09:27:20 PM

BBCode Errors

There is an error with your BBCode, the number of opening tags do not
meet the number of closing tags.
There is an error with your BBCode. It is possible that you have
incorrectly used a tag such as [TAG] when it is meant to be used as
[TAG=] or vice-versa.

How can I fix these errors ?

Repetitive SQL error: Got error 134 from storage engine

IPB WARNING [2] mysql_query() [function.mysql-query]: Unable to save
result set (Line: 457 of /ips_kernel/class_db_mysql.php)



There appears to be an error with the database.
You can try to refresh the page by clicking here.

Error Returned
mySQL query error: SELECT s.member_id, s.member_name, s.member_group,
s.id, s.login_type, s.location, s.running_time, t.forum_id
FROM ib_sessions s
LEFT JOIN ib_topics t ON ( t.tid=s.location_1_id)
WHERE s.location_2_type='forum' AND (s.location_2_id=45 OR
t.forum_id=45)
AND s.running_time > 1161976205
AND s.in_error=0

SQL error: Got error 134 from storage engine
SQL error code:
Date: Saturday 28th of October 2006 03:10:05 PM

---------------------------------------------------------
IPB WARNING [2] mysql_query() [function.mysql-query]: Unable to save
result set (Line: 457 of /ips_kernel/class_db_mysql.php)



There appears to be an error with the database.
You can try to refresh the page by clicking here.

Error Returned
mySQL query error: SELECT s.member_id, s.member_name, s.member_group,
s.id, s.login_type, s.location, s.running_time, t.forum_id
FROM ib_sessions s
LEFT JOIN ib_topics t ON ( t.tid=s.location_1_id)
WHERE s.location_2_type='forum' AND (s.location_2_id=17 OR
t.forum_id=17)
AND s.running_time > 1161976356
AND s.in_error=0

SQL error: Got error 134 from storage engine
SQL error code:

Error with the database

IPB WARNING [2] mysql_connect() [function.mysql-connect]: Can't connect
to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11)
(Line: 131 of /ips_kernel/class_db_mysql.php)



There appears to be an error with the database.
You can try to refresh the page by clicking here.

Error Returned
SQL error: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (11)
SQL error code:
Date: Tuesday 14th of November 2006 02:36:21 PM