Skip to Content.
Sympa Menu

freetds - RE: [freetds] Problem with current snapshot

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Simon Talbot" <simont AT nse.co.uk>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] Problem with current snapshot
  • Date: Thu, 13 Nov 2003 16:35:58 -0000

ZIGLIO,

The statement being executed at the time of the error is:
UPDATE S SET DetroitShow = 4,AnyShow = 2 WHERE S_ID=3666

Although the system has executed some 10,000 Insert/Update statements by
the time it hits this Update statement, the statement on it's pwn does
not trigger the problem.


The primary error which is returned is:

DB-Library error:
iconv E2BIG: Error converting between character sets. Output
buffer exhausted.
Operating-system error:
OpenClient
agrep: dblib.c:416: buffer_transfer_bound_data: Assertion `idx >= 0'
failed.
Aborted



I am also getting a lot of the following WARNINGS whch don't happen when
using the Satble 0.61.2:

DB-Library error:
WARNING! Some character(s) could not be converted into client's
character set. Unconverted bytes were changed to question marks ('?').
Operating-system error:
OpenClient

Platform is Linux on i686, Kernel 2.4.22
gcc (GCC) 3.3.2

SQL Server is on Dual Processor Windows 2000 Intel
Microsoft SQL Server 2000 - 8.00.384 (Intel X86)
May 23 2001 00:02:52
Copyright (c) 1988-2000 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 2)

Database as follows:

db_size owner
AUTOSHOW_2003
Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER,
Recovery=FULL,
Version=539, Collation=SQL_Latin1_General_CP1_CI_AS, SQLSortOrder=52,
IsTornPageDetectionEnabled, IsAutoCreateStatistics,
IsAutoUpdateStatistics


Last 100 Lines of dump:

03:28:54.453151 processing row. column size is 4
03:28:54.453160 clearing column 1 NULL bit
03:28:54.453170 processing row. column is 2 varint size = 0
03:28:54.453181 processing row. column size is 4
03:28:54.453190 clearing column 2 NULL bit
03:28:54.453199 processing row. column is 3 varint size = 2
03:28:54.453210 processing row. column size is 251
03:28:54.453220 clearing column 3 NULL bit
tds_get_char_data: reading 251 on wire for 36 to client
03:28:54.453245 dbconvert() srctype = 56 desttype = 56
03:28:54.453256 dbconvert() srctype == desttype
03:28:54.453266 dbconvert() srctype = 56 desttype = 56
03:28:54.453322 dbconvert() srctype == desttype
03:28:54.453333 dbconvert() srctype = 56 desttype = 56
03:28:54.453343 dbconvert() srctype == desttype
03:28:54.453353 dbconvert() srctype = 39 desttype = 47
03:28:54.453362 dbconvert() calling tds_convert
03:28:54.453372 dbconvert() called tds_convert returned 251
03:28:54.453382 dbconvert() outputting 251 bytes character data destlen
= -1
03:28:54.453393 leaving dbnextrow() returning -1
03:28:54.453403 dbnextrow()
03:28:54.453412 processing row tokens. marker is d1(ROW)
03:28:54.453421 processing row. column is 0 varint size = 0
03:28:54.453431 processing row. column size is 4
03:28:54.453440 clearing column 0 NULL bit
03:28:54.453449 processing row. column is 1 varint size = 0
03:28:54.453459 processing row. column size is 4
03:28:54.453467 clearing column 1 NULL bit
03:28:54.453476 processing row. column is 2 varint size = 0
03:28:54.453486 processing row. column size is 4
03:28:54.453495 clearing column 2 NULL bit
03:28:54.453504 processing row. column is 3 varint size = 2
03:28:54.453513 processing row. column size is 250
03:28:54.453522 clearing column 3 NULL bit
tds_get_char_data: reading 250 on wire for 251 to client
Received header @ 03:28:54.453577
0000 04 00 02 00 00 3a c1 00- |.....:..|


Received packet @ 03:28:54.453843
0000 6e 20 64 65 63 20 2e 20-2c 20 31 39 39 39 20 2e |n dec . , 1999 .|
0010 20 79 65 74 20 61 6d 6f-6e 67 20 6d 65 64 63 6f | yet amo ng medco|
0020 20 27 20 73 20 6d 61 69-6c 20 2d 20 6f 72 64 65 | ' s mai l - orde|
0030 72 20 63 6c 69 65 6e 74-73 20 2c 20 7a 6f 63 6f |r client s , zoco|
0040 72 20 27 20 73 20 73 68-61 72 65 20 77 61 73 20 |r ' s sh are was |
0050 34 31 20 70 65 72 63 65-6e 74 20 2e 20 73 74 65 |41 perce nt . ste|
0060 76 65 20 67 65 6c 73 69-20 69 73 20 61 20 72 65 |ve gelsi is a re|
0070 70 6f 72 74 65 72 20 66-6f 72 20 63 62 73 20 2e |porter f or cbs .|
0080 20 6d 61 72 6b 65 74 77-61 74 63 68 20 2e 20 63 | marketw atch . c|
0090 6f 6d 20 69 6e 20 6e 65-77 20 79 6f 72 6b 20 2e |om in ne w york .|
00a0 20 d1 84 0c 01 00 52 0e-00 00 36 00 00 00 6f 01 | .....R. ..6...o.|
00b0 21 35 34 20 6d 6f 72 65-20 69 70 6f 20 72 65 70 |!54 more ipo rep|
00c0 6f 72 74 20 95 20 61 6f-6c 20 74 69 6d 65 20 77 |ort . ao l time w|
00d0 61 72 6e 65 72 20 63 61-62 6c 65 20 74 76 20 69 |arner ca ble tv i|
00e0 70 6f 20 74 6f 20 79 69-65 6c 64 20 62 69 67 20 |po to yi eld big |
00f0 70 61 79 64 61 79 20 35-20 3a 20 32 34 70 6d 20 |payday 5 : 24pm |
0100 65 74 20 30 31 20 2f 20-30 39 20 2f 20 30 33 20 |et 01 / 09 / 03 |
0110 95 20 72 65 67 75 6c 61-74 6f 72 73 20 66 69 6e |. regula tors fin|
0120 65 20 72 6f 62 65 72 74-73 6f 6e 20 73 74 65 70 |e robert son step|
0130 68 65 6e 73 20 66 6f 72-20 69 6c 6c 65 67 61 6c |hens for illegal|
0140 20 69 70 6f 20 66 65 65-73 20 31 20 3a 20 35 30 | ipo fee s 1 : 50|
0150 70 6d 20 65 74 20 30 31-20 2f 20 30 39 20 2f 20 |pm et 01 / 09 / |
0160 30 33 20 95 20 76 65 6e-74 75 72 65 20 61 63 74 |03 . ven ture act|
0170 69 76 69 74 79 20 73 6c-6f 77 65 64 20 69 6e 20 |ivity sl owed in |
0180 32 30 30 32 20 61 6c 6f-6e 67 20 77 69 74 68 20 |2002 alo ng with |
0190 69 70 6f 73 20 31 32 20-3a 20 32 32 70 6d 20 65 |ipos 12 : 22pm e|
01a0 74 20 30 31 20 2f 20 30-38 20 2f 20 30 33 20 95 |t 01 / 0 8 / 03 .|
01b0 20 66 69 72 73 74 20 69-70 6f 20 6f 66 20 32 30 | first i po of 20|
01c0 30 33 20 68 61 72 64 20-74 6f 20 73 70 6f 74 20 |03 hard to spot |
01d0 31 32 20 3a 20 30 33 70-6d 20 65 74 20 30 31 20 |12 : 03p m et 01 |
01e0 2f 20 30 37 20 2f 20 30-33 20 95 20 77 69 6e 65 |/ 07 / 0 3 . wine|
01f0 20 6d 61 6b 65 72 20 66- | maker f|


03:28:54.454084 dbconvert() srctype = 56 desttype = 56
03:28:54.454097 dbconvert() srctype == desttype
03:28:54.454107 dbconvert() srctype = 56 desttype = 56
03:28:54.454117 dbconvert() srctype == desttype
03:28:54.454126 dbconvert() srctype = 56 desttype = 56
03:28:54.454136 dbconvert() srctype == desttype
03:28:54.454146 dbconvert() srctype = 39 desttype = 47
03:28:54.454204 dbconvert() calling tds_convert
03:28:54.454217 dbconvert() called tds_convert returned 250
03:28:54.454241 dbconvert() outputting 250 bytes character data destlen
= -1
03:28:54.454255 leaving dbnextrow() returning -1
03:28:54.454267 dbnextrow()
03:28:54.454432 processing row tokens. marker is d1(ROW)
03:28:54.454450 processing row. column is 0 varint size = 0
03:28:54.454460 processing row. column size is 4
03:28:54.454471 clearing column 0 NULL bit
03:28:54.454481 processing row. column is 1 varint size = 0
03:28:54.454491 processing row. column size is 4
03:28:54.454500 clearing column 1 NULL bit
03:28:54.454509 processing row. column is 2 varint size = 0
03:28:54.454519 processing row. column size is 4
03:28:54.454528 clearing column 2 NULL bit
03:28:54.454538 processing row. column is 3 varint size = 2
03:28:54.454548 processing row. column size is 367
03:28:54.454558 clearing column 3 NULL bit
tds_get_char_data: reading 367 on wire for 250 to client


Hope this helps, please let me know if you would like me to look at
anything else,

Simon

Simon Talbot MEng, ACGI
(Chief Engineer)
Net Solutions Europe Limited


-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of ZIGLIO Frediano
Sent: 13 November 2003 16:02
To: FreeTDS Development Group
Subject: RE: [freetds] Problem with current snapshot

>
> Hi All,
>
> Just a quick note which hopefully may be of some use, I was carrying
> out some testing today with
> freetds-0.62.dev.20031113 (today's snapshot) and under load got a
> number of the following failures:
>
> dblib.c:416: buffer_transfer_bound_data: Assertion `idx >= 0' failed.
>
> I also receive some WARNING character data could not be translated to
> the target character set, data will be replaced by ??? Which is also
> odd as everything is english.
>

That's strange... could your post a dump (set TDSDUMP=out.txt, execute
program and send out.txt, removing security information inside log) What
platform are you using ?

> I realise that I have not provided much diagnostics here but my
> project deadline is short to for the moment I have reverted to stable
> 0.61.2 which runs perfectly with the self same code.
>
> I may have a little time to run some diagnostics if anyone feels that
> that would be useful -- let me know,
>
> Simon
>
> Simon Talbot MEng, ACGI
> (Chief Engineer)
> Net Solutions Europe Limited
>

If you find a way to reproduce the problem post it.

freddy77
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds






Archive powered by MHonArc 2.6.24.

Top of Page