I am reliably getting this error: Failed to decompress a compressed packet when both COMP=YES and values for PBUF & PROWS are specified in a connection string.

It seems to depend on the relative values of PROWS & PBUF used, and the size of the result set. It seems that once PBUF is more than approx 100k, any value of PROWS more than about 40 will cause the error, with a decent size result set (1000 rows+). There is no problem with any combination of PBUF and PROWS if COMP=NO.

The behaviour is the same on the latest ebf of 9.0.2 and 10.0.1.3680 (server), 10.0.1.3931 (client). I can't find any refrence to a similar problem in the 10.0.1 fix list.

An example of the error from the client log:

18:15:01 [   22] Failed to decompress a compressed packet
18:15:01 [   22] Received bad packet (type: 24, received length: 1062, header length: 1062), disconnecting
18:15:01 [   22] Connection terminated abnormally; error code 100001
18:15:01 [   22] Communication function i_cs_HandleSQLPresError code 5
18:15:01 [   22] Communication function StrmGetInd code 2
18:15:01 [   22] Client disconnected

At the server end you just get:

Connection terminated abnormally

I've found this while testing wide area performance, for which both prefetching and compression are clearly important. I wonder if anyone else has seen something similar?

asked 16 Dec '09, 18:35

Justin%20Willey's gravatar image

Justin Willey
6.5k106135203
accept rate: 21%

closed 27 Mar '11, 16:02

The question has been closed for the following reason "The question is answered, right answer was accepted" by Justin Willey 27 Mar '11, 16:02


Fixed in 10.0.1.4116 Many thanks to everyone involved in identifying and sorting the problem.

permanent link

answered 15 Sep '10, 13:23

Justin%20Willey's gravatar image

Justin Willey
6.5k106135203
accept rate: 21%

1

A good idea to report here when bugs have been fixed, obviously:)

(15 Sep '10, 13:54) Volker Barth

A couple of quick tests (using comp=yes;pbuf=150k;prows=50, selecting 5000 rows of ~5000 bytes each) worked properly for me. I would recommend that you open an issue with tech support. If you give them a repro, they should be able to help diagnose the problem.

permanent link

answered 16 Dec '09, 20:49

Graeme%20Perrow's gravatar image

Graeme Perrow
8.5k371108
accept rate: 51%

1

Does tech support have a mechanism for easily testing "wide area performance", which may be a critical phrase in Justin's description.

(17 Dec '09, 09:26) Breck Carter

Finally got back to this one - case + repro submitted as Case Id: 11611636

(10 Jun '10, 18:27) Justin Willey

Support have identified two bugs - should be fixed soon

(05 Aug '10, 19:52) Justin Willey

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×14
×14
×10
×9
×1

question asked: 16 Dec '09, 18:35

question was seen: 1,332 times

last updated: 27 Mar '11, 16:02