Getting errors while trying to use new Mysql 50 port and pkg

[N. Harrington]

Hello,
 I have 2 database servers running as slaves from a
Master database. One (db2) is running FreeBSD
6.2-PRERELEASE from October. The other, (db3) on a new
build of FreeBSD 6.2-STABLE. Both are AMD64.

 Db2 is running mysql 5.0.24a and has been working
fine.
 Db3 however, running mysql 5.0.33 keeps giving an
error 127 after awhile, for a couple of our tables.
The tables all check as ok.

 070227 11:24:48 [ERROR] Got error 127 when reading
table './user_info'

 We had this problem before with the ports built
version on db2, but when we switched to the pkg build
it went away. Now none of the build options seem to
work and sadly I do not have the old copy of mysql
5.024a to try on this server.  (forgot to use -K)

 I have tried the Ports build with and without various
optimizations, the Pkg build and a downloaded binary
from mysql. (5.0.27) All produced the errors within an
hour of running.

 perror shows this to mean:
 MySQL error code 127: Record-file is crashed.

 When the error is reported, the query that caused it
responds with an error, but all other queries work.
 Running a repair on the tables shows everything ok.


 Any suggestions greatly appreciated!


 Thanks!

  Nicole

--
 Free The Bound Periodicals!


 

_______________________________________________
freebsd-database@... mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-database
To unsubscribe, send any mail to "freebsd-database-unsubscribe@..."

[Gleb Paharenko-3]

Hello.

You could try find out which statement causes the problem.
Have a look here:
http://dev.mysql.com/doc/refman/5.0/en/reproducible-test-case.html

Please, provide the output of 'SHOW VARIABLES' and 'SHOW STATUS' statements.
There's another good point to start:
http://dev.mysql.com/doc/refman/5.0/en/debugging-server.html


Regards.

Nicole Harrington пишет:

> Hello,
>  I have 2 database servers running as slaves from a
> Master database. One (db2) is running FreeBSD
> 6.2-PRERELEASE from October. The other, (db3) on a new
> build of FreeBSD 6.2-STABLE. Both are AMD64.
>
>  Db2 is running mysql 5.0.24a and has been working
> fine.
>  Db3 however, running mysql 5.0.33 keeps giving an
> error 127 after awhile, for a couple of our tables.
> The tables all check as ok.
>
>  070227 11:24:48 [ERROR] Got error 127 when reading
> table './user_info'
>
>  We had this problem before with the ports built
> version on db2, but when we switched to the pkg build
> it went away. Now none of the build options seem to
> work and sadly I do not have the old copy of mysql
> 5.024a to try on this server.  (forgot to use -K)
>
>  I have tried the Ports build with and without various
> optimizations, the Pkg build and a downloaded binary
> from mysql. (5.0.27) All produced the errors within an
> hour of running.
>
>  perror shows this to mean:
>  MySQL error code 127: Record-file is crashed.
>
>  When the error is reported, the query that caused it
> responds with an error, but all other queries work.
>  Running a repair on the tables shows everything ok.
>
>
>  Any suggestions greatly appreciated!
>
>
>  Thanks!
>
>   Nicole
>
> --
>  Free The Bound Periodicals!
>
>
>  
>
> _______________________________________________
> freebsd-database@... mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-database
> To unsubscribe, send any mail to "freebsd-database-unsubscribe@..."
>  

--
Gleb Paharenko
gleban@...

_______________________________________________
freebsd-database@... mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-database
To unsubscribe, send any mail to "freebsd-database-unsubscribe@..."

[N. Harrington]

--- Gleb Paharenko <gpaharenko@...> wrote:
> Hello.
>
> You could try find out which statement causes the
> problem.
> Have a look here:
>
http://dev.mysql.com/doc/refman/5.0/en/reproducible-test-case.html
>
> Please, provide the output of 'SHOW VARIABLES' and
> 'SHOW STATUS' statements.
> There's another good point to start:
>
http://dev.mysql.com/doc/refman/5.0/en/debugging-server.html
>

 Hi,
 Thanks for the suggestions.

 Just to follow up. Copying the 5.0.24a mysql (c+s)
program from our older db server stopped the 127
errors.

 So, it seems it must be either a bug in mysql, or an
extra sensitivity to something in our tables,
introduced someplace between 5.0.24a and 5.0.27.

 Or, even perhaps around that time, since it is
interesting that it seems 5.0.24a only worked when
compiled non static and/or un-optimized compile (pkg
vs port w/options)


 Nicole

 

> Regards.
>
> Nicole Harrington пишет:
> > Hello,
> >  I have 2 database servers running as slaves from
> a
> > Master database. One (db2) is running FreeBSD
> > 6.2-PRERELEASE from October. The other, (db3) on a
> new
> > build of FreeBSD 6.2-STABLE. Both are AMD64.
> >
> >  Db2 is running mysql 5.0.24a and has been working
> > fine.
> >  Db3 however, running mysql 5.0.33 keeps giving an
> > error 127 after awhile, for a couple of our
> tables.
> > The tables all check as ok.
> >
> >  070227 11:24:48 [ERROR] Got error 127 when
> reading
> > table './user_info'
> >
> >  We had this problem before with the ports built
> > version on db2, but when we switched to the pkg
> build
> > it went away. Now none of the build options seem
> to
> > work and sadly I do not have the old copy of mysql
> > 5.024a to try on this server.  (forgot to use -K)
> >
> >  I have tried the Ports build with and without
> various
> > optimizations, the Pkg build and a downloaded
> binary
> > from mysql. (5.0.27) All produced the errors
> within an
> > hour of running.
> >
> >  perror shows this to mean:
> >  MySQL error code 127: Record-file is crashed.
> >
> >  When the error is reported, the query that caused
> it
> > responds with an error, but all other queries
> work.
> >  Running a repair on the tables shows everything
> ok.
> >
> >
> >  Any suggestions greatly appreciated!
> >
> >
> >  Thanks!
> >
> >   Nicole
> >
> > --
> >  Free The Bound Periodicals!
> >
> >
> --
> Gleb Paharenko
> gleban@...
>
>

_______________________________________________
freebsd-database@... mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-database
To unsubscribe, send any mail to "freebsd-database-unsubscribe@..."