MySQL Bugs: #49579: IPv6 tests fail on FreeBSD

Bug #49579	IPv6 tests fail on FreeBSD
Submitted:	10 Dec 2009 10:14	Modified:	7 Mar 2010 1:25
Reporter:	Alexander Nozdrin	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: General	Severity:	S2 (Serious)
Version:	5.6 (Celosia)	OS:	FreeBSD
Assigned to:	Horst Hunger	CPU Architecture:	Any

Description:
IPv6 tests fail on FreeBSD as it's shown on PB-page.
daily-6.0-bugfixing for example.

Horst investigated the problem and here is the quote from his mail:
<quote>
the problem is that most unix systems can handle the mixed format of IPv4 and IPv6, which is e.g. "0:0:0:0:0:FFFF:127.0.0.1". Only Window doesn't allow that and obviously FreeBSD, too. That's the explanation for these failures.
I don't know if WIndows and FreeBSD can be configured to understand that format. Looking at Wlad's remark it might be.
</quote>

<quote>
I looked around in the internet and found the following:
On Windows the IPv4 mapped format is not supported.
On FreeBSD it is deactivated.
</quote>

Since the test suite is supposed to work on user boxes
(more or less default configuration), IPv6 tests should be updated
for FreeBSD to exclude the mixed IPv4/IPv6 format testing.

P.S.: Just for the records. Wlad found out how to enable that:
[16:35] <wlad> alik: just for the record, I solved the problem using "sysctl net.inet6.ipv6.v6only=0". It looks like the parameter also has some meaning for client sockets .Server was already listening on both IPv4 (127.0.0.1)  and IPv6 (::1), possibly due to the setsockopt (resetting V6ONLY) I introduced for Vista.

How to repeat:
Look at PB page.

I do not think we should try using sysctl on the client machine in order to make those tests pass. A safer solution would be to skip them using the appropriate include file.

I'll separate the IPv4 mapped format tests in an own test program, that checks with an include file if the format is available on the system.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/93867

2928 Horst.Hunger	2009-12-14
      Bug#49579: Restructured the IPv6 tests so that the IPv4 mapped formats run in an separate test depending on the availablity of that format. Especially on Windows and FreeBSD theses format are not available as default. Seperate Windows tests are not more needed.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/98581

2979 Horst.Hunger	2010-01-29
      New patch for bug#49579, now with "have_ipv4_mapped.inc".

pushed into mysql-next-mr-bugfixing. merged and pushed into mysql-6.0-codebase-bugfixing.

Pushed into 6.0.14-alpha (revid:alik@sun.com-20100213083436-9pesg4h55w1mekxc) (version source revid:luis.soares@sun.com-20100211135109-t63avry9fqpgyh78) (merge vers: 6.0.14-alpha) (pib:16)

Pushed into mysql-next-mr (revid:alik@sun.com-20100213083327-cee4ao3jpg33eggv) (version source revid:luis.soares@sun.com-20100211135018-1f9dbghg0itszigo) (pib:16)

Changes to test case. No changelog entry needed.

Setting report to Need Merge pending push of Celosia to release tree.

Pushed into 5.5.3-m3 (revid:alik@sun.com-20100306103849-hha31z2enhh7jwt3) (version source revid:vvaintroub@mysql.com-20100213160132-nx1vlocxuta76txh) (merge vers: 5.5.99-m3) (pib:16)

No changelog entry needed.