Home » Performance » FullText » Sphinx as built-in SE causes server crashes?
Sphinx as built-in SE causes server crashes? [message #541] Fri, 05 January 2007 13:57 Go to next message
mushu  is currently offline mushu
Messages: 3
Registered: December 2006
Location: Krakow, Poland
Junior Member
Hey,

I've been using MySQL 5.1.14 for last few weeks without any problems. Yesterday I compiled it with Sphinx storage engine (built-in, not as a pluggable module) and weird things started to show up. The server crashes randomly on deletes and updates to MyISAM(!) tables *if any* Sphinx table has been accessed since mysqld startup. Does anyone else experience such behaviour? I'm not sure if it's Sphinx SE falut or not, but that is the only thing that changed, so this would be the most obvious.

Another thing is the warning that server logs at each startup:
[Warning] Storage engine 'SPHINX' has conflicting typecode. Assigning value 42.

Maciek
Re: Sphinx as built-in SE causes server crashes? [message #568 is a reply to message #541 ] Tue, 09 January 2007 18:14 Go to previous messageGo to next message
bluesaga  is currently offline bluesaga
Messages: 20
Registered: December 2006
Junior Member
Thank you for the replies, but unfortunatelly the posts are empty. Something ate their bodies. :/

[Updated on: Thu, 24 May 2007 18:40] by Moderator

Re: Sphinx as built-in SE causes server crashes? [message #592 is a reply to message #541 ] Sun, 14 January 2007 17:22 Go to previous messageGo to next message
mushu  is currently offline mushu
Messages: 3
Registered: December 2006
Location: Krakow, Poland
Junior Member
Thank you for the replies, but unfortunatelly the posts are empty. Something ate their bodies. :/

Maciek
Re: Sphinx as built-in SE causes server crashes? [message #593 is a reply to message #592 ] Mon, 15 January 2007 01:37 Go to previous message
shodan  is currently offline shodan
Messages: 1
Registered: January 2007
Junior Member
Long story short, this seems like a known bug in 0.9.6 SE vs 5.1.x MySQL, so please contact me for for a beta version of forthcoming 0.9.7.

Hope this one gets through...
Previous Topic:Sphinx features
Next Topic:Setup Sphinx
Goto Forum:
  



Current Time: Wed Jan 7 17:05:14 EST 2009

Total time taken to generate the page: 0.01501 seconds
.:: Contact :: Home :: MySQL Support by Percona.com ::.

Powered by: FUDforum 2.7.5.
Copyright ©2001-2006 FUD Forum Bulletin Board Software

MySQL Performance | Forum authority Badge