DrunkenBlog

10.3 server + mysql = hairpulling

Going kind of nutty here, been spending part of a day helping a friend get their Xserve up and running on panther. Most things went fine, but mysql was throwing hissies. Code that worked fine on other boxes/platforms was borking big time after installing 10.3.x server. It looks to be confined to inserts & ordering by datetime.

That at least gave us a clue, as there is a well-known bug in the earlier 4.x series of MySQL that got caught very fast and was fixed, involving just the above. Turns out yeah, Apple is shipping the borked version with 10.3.x, specifically 4.0.14. Ew. Downloaded and installed 4.0.16 and everything is back to normal.

This is just so fricking lame, we wasted a huge amount of time tracking this down, which is partially our fault as we just dismissed them shipping that broken of an install. It'd be caught in any real testing whatsoever, and gives a feeling of "download, slap together, $$$profit!!!" to OSX Server, and still hasn't been fixed.

There are prolly lots of people out there hitting the same thing and having no clue as to what's going on.

 Posted by drunkenbatman
    January 19, 2004, at 02:24 PM