On 3/9/05 18:30, "Data Man" <dataman [at] lists.troopeight.org> wrote:>
> Hi,
>
> I'm using perl 5.8.5 with DBI and Mysql 4.1 on FreeBSD 5.3. I am
> receiving an error 'Got error 134 from Storage engine' when executing
> many mysql queries in a loop. At random iterations under identical
> conditions the app fails with the above error.
>
> My loop looks like this
>
> foreach $itm ( [at] Items) {
>
> create query string with $itm
> prepare
> execute
> while ($sth->fetchrow_array)
>
> }
>
> I've googled around and cannot locate this error. Anyone know how to
> locate the problem? Thanks, DM.
>
% perror 134
MySQL error code 134: Record was already deleted (or record file crashed)
错误代码134:记录已删除(或表文件损坏)
Try REPAIR TABLE to see if that fixes the problem.
尝试修复表,看能否解决此问题
> Hi,
>
> I'm using perl 5.8.5 with DBI and Mysql 4.1 on FreeBSD 5.3. I am
> receiving an error 'Got error 134 from Storage engine' when executing
> many mysql queries in a loop. At random iterations under identical
> conditions the app fails with the above error.
>
> My loop looks like this
>
> foreach $itm ( [at] Items) {
>
> create query string with $itm
> prepare
> execute
> while ($sth->fetchrow_array)
>
> }
>
> I've googled around and cannot locate this error. Anyone know how to
> locate the problem? Thanks, DM.
>
% perror 134
MySQL error code 134: Record was already deleted (or record file crashed)
错误代码134:记录已删除(或表文件损坏)
Try REPAIR TABLE to see if that fixes the problem.
尝试修复表,看能否解决此问题
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货