[DERBY-1595] Network server fails with DRDAProtocolException if a BLOB with size 2147483647 is streamed from client

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 10.0.2.1, 10.1.3.1, 10.2.2.0, 10.3.3.0, 10.4.2.0, 10.5.3.0, 10.6.1.0, 10.7.1.1
• Fix Version/s: 10.6.2.1, 10.7.1.1
• Component/s: Network Server
• Labels: LOB derby_backport_reject_10_5
• Urgency: Normal
• Assignee: Kristian Waagan
• Reporter: Andreas Korneliussen
• Created: 26/Jul/06 14:21
• Updated: 02/May/13 02:29
• Resolved: 15/Mar/11 21:36

Description

When executing a program which inserts a BLOB of size 2GB-1, the Network server fails with DRDAProtocolException. This happens before it starts handling the actual LOB data:

java org.apache.derby.drda.NetworkServerControl start
Apache Derby Network Server - 10.2.0.4 alpha started and ready to accept connections on port 1527 at 2006-07-26 14:15:21.284 GMT
Execution failed because of a Distributed Protocol Error: DRDA_Proto_SYNTAXRM; CODPNT arg = 0; Error Code Value = c
org.apache.derby.impl.drda.DRDAProtocolException
at org.apache.derby.impl.drda.DRDAConnThread.throwSyntaxrm(DRDAConnThread.java:441)
at org.apache.derby.impl.drda.DDMReader.readLengthAndCodePoint(DDMReader.java:554)
at org.apache.derby.impl.drda.DDMReader.getCodePoint(DDMReader.java:617)
at org.apache.derby.impl.drda.DRDAConnThread.parseSQLDTA_work(DRDAConnThread.java:4072)
at org.apache.derby.impl.drda.DRDAConnThread.parseSQLDTA(DRDAConnThread.java:3928)
at org.apache.derby.impl.drda.DRDAConnThread.parseEXCSQLSTTobjects(DRDAConnThread.java:3806)
at org.apache.derby.impl.drda.DRDAConnThread.parseEXCSQLSTT(DRDAConnThread.java:3640)
at org.apache.derby.impl.drda.DRDAConnThread.processCommands(DRDAConnThread.java:928)
at org.apache.derby.impl.drda.DRDAConnThread.run(DRDAConnThread.java:254)
null
org.apache.derby.impl.drda.DRDAProtocolException
at org.apache.derby.impl.drda.DRDAConnThread.throwSyntaxrm(DRDAConnThread.java:441)
at org.apache.derby.impl.drda.DDMReader.readLengthAndCodePoint(DDMReader.java:554)
at org.apache.derby.impl.drda.DDMReader.getCodePoint(DDMReader.java:617)
at org.apache.derby.impl.drda.DRDAConnThread.parseSQLDTA_work(DRDAConnThread.java:4072)
at org.apache.derby.impl.drda.DRDAConnThread.parseSQLDTA(DRDAConnThread.java:3928)
at org.apache.derby.impl.drda.DRDAConnThread.parseEXCSQLSTTobjects(DRDAConnThread.java:3806)
at org.apache.derby.impl.drda.DRDAConnThread.parseEXCSQLSTT(DRDAConnThread.java:3640)
at org.apache.derby.impl.drda.DRDAConnThread.processCommands(DRDAConnThread.java:928)
at org.apache.derby.impl.drda.DRDAConnThread.run(DRDAConnThread.java:254)

Issue Links

• depends upon: DERBY-4706 Remove stale and potentially unused code Request.writeEncryptedScalarStream