Errata

Understanding MySQL Internals

Errata for Understanding MySQL Internals

Submit your own errata for this product.

The errata list is a list of errors and their corrections that were found after the product was released.

The following errata were submitted by our customers and have not yet been approved or disproved by the author or editor. They solely represent the opinion of the customer.

Color Key: Serious technical mistake Minor technical mistake Language or formatting error Typo Question Note Update

Version Location Description Submitted by Date submitted
Printed Page 30
Item 8, second paragraph

After getting around the -host versus --host thing I noted earlier, I
also I found on the previous page for item 5 that --local is no longer a valid parameter for mysql-test-run

MySQL Version 5.1.44
Invalid option "--local"

(I'm using the latest mariadb source though so this is probably just a change and not technically a typo in the book). Seems to work fine by just omitting it.

So my question here is how to find out what port to use to connect with as 9306 doesn't work (any more possibly).

I have the server running. The gdb window is up and I see "call mtr.check_testcase()", length 25, found_semicolon=0xb61f20b4 at sql_parse.cc:5985

ok so now if I try this from within the client director:

~/mysql/maria/trunk/client$ ./mysql -uroot --host=127.0.0.1 --port=9306 test
ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (111)

I see this in the terminal where the server is running from: Using server port 56129

~/mysql/maria/trunk/client$ ./mysql -uroot --host=127.0.0.1 --port=56129 test
Error: Packets out of order (Found: 76, expected 0)
ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 0

and the server crashes. So wondering if this indicates a build problem on my end.

Note: my libthread_db.so is stripped unfortunately whereas libpthread.so isn't - something I'm hoping to fix later on but I'm assuming I should still be able to connect regardless.

Dave Drouin  Apr 11, 2010