Daily Archives: Thursday 30/09/2010

My Little Growing Daughter My Life 30 SEP 2010

As you may have noticed, I haven’t exactly been hanging around these pages for the last month so, purely because of all the current work around the new house that is going on in my life. Which of course means I haven’t exactly been keeping you up to date with the progress of little unborn Jessica, who has slowly but happily been growing and developing whilst nestled safely in her mommy’s womb.

I felt her kick for the first time a little while ago, and boy is my little girl a fighter! I honestly have no idea how Chantelle’s insides can withstands those constant, powerful little blows (because believe me, she kicks like a mule already – and a lot at that!). It must be her particularly long legs that generate all the power (something picked up on by the doctor and something that befuddles us slightly as neither Chantelle nor I are particularly blessed in the long legs department!).

Happily everything is progressing as planned and according to all the tests, little Jessica is as healthy as can be and steaming ahead towards the estimated due date of 10 January 2011, though the doctor is eager to induce her a little earlier, just for safety sake when you take Chantelle’s high blood pressure into account. Obviously we’ll push to make sure Jessica only arrives in January and not December (for eventual school-going purposes), but I guess when it comes to these things one really can’t do all that much planning. We’ll just have to wait and see what the Lord has in mind for us.

As for calling her my little fighter, I’m really not exaggerating! I’ve already mentioned her long legs and awesome kicking ability, not to mention her penchant for putting up both fists in front of her face like a blocking boxer and then there is of course the fact that she lashes out whenever the doctor tries to prod in to close with her big ultrasound wand!

Little Jessica Lotter.

I really can’t wait to meet her! :)

MySQL: Got a packet bigger than ‘max_allowed_packet’ bytes Error Tips, Tricks and Tutorials 30 SEP 2010

mysql-girl-black-halter-topI came across a nasty little bug in my image upload to MySQL blob in base 64 encode function the other day – basically the database was spitting back the following error to me:

Error code: 1153 – Got a packet bigger than ‘max_allowed_packet’ bytes

So of course I looked it up.

It turns out that MySQL views a single SQL statement as a communication packet, with a built in limit of 1GB. However, servers usually have a set maximum packet size they are allowed to accept and clients a maximum packet size they are allowed to send, both of which is controlled by a variable called max_allowed_packet. If it receives a packet bigger than this limit, the server will spit back a 1153 error and close the connection.

If you wish to check what your current maximum packet size is, run the following query:

SHOW VARIABLES LIKE ‘max_allowed_packet’

Of course, you would also want to increase these limits at some point in time, something which is easily achieved like so:

To increase a client program’s default, run: shell> mysql –max_allowed_packet=32MB.

To increase a server’s default, run: shell> mysqld –max_allowed_packet=16M.

Note that this is fairly safe to increase this value as memory is allocated only when needed. So now you know! :)