Possible networking bug in Win2008R2: tcp checksums in keepalives with timestamps
I think I've found a bug in Windows 2008R2: tcp keepalive packets with timestamps have an invalid checksum.
I use JDBC to connect from a Linux host to MS SQL Server 2008 on a Win2008R2 host. I execute a long-running statement that doesn't return a result set, and so Win2008 sends a tcp keepalive at 30 seconds. This keepalive is ignored by the Linux host, and after
sending 9 more keepalives at one second intervals, Win2008 resets the connection. When I run the same statement against SQL Server on Win2003, it completes successfully. When I disable timestamps on the Linux machine (which induces the Win2008 host not to
use timestamps), the statement also completes successfully.
I captured packets on the Linux host (which gets around the checksum offloading problem), and found that when tcp timestamps are included in keepalives, the checksums are invalid. Other packets from the Win2008 host with timestamps have good checksums. Win2003
doesn't include tcp timestamps, and its keepalives are ACKed.
You can see the packet dumps here:
Win2008 keep-alives with tcp timestamps: bogus checksums
http://pastebin.com/v6CpteJ9
Win2008 keep-alives without timestamps: valid checksums
http://pastebin.com/a0zTBEJL
Win2003 keep-alives without timestamps: valid checksums
http://pastebin.com/KVLb3Mzh
Before I realized the checksums in the keepalives were invalid, I pursued the question as a possible Linux kernel bug:
http://marc.info/?t=130763385400001&r=1&w=2
I thought you might like to know.
Chuck
June 13th, 2011 6:56pm
Hi,
We'd like to repro this scenario internally. Can you tell us the application which runs on the Linux machine including steps?
Let me know if you have more questions around this.
Ketan Thakkar | Microsoft Online Community Support
Free Windows Admin Tool Kit Click here and download it now
June 24th, 2011 7:20am
I am finding the same, is there a fix for this?
April 6th, 2012 10:57am
Any chance of Microsoft fixing this Windows bug? It is affecting our application development from *nix platforms to SQL Server.
Free Windows Admin Tool Kit Click here and download it now
May 17th, 2012 12:30pm