freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
RE: [freetds] Read from SQL server failed. Problem in pool
- From: "Carlos S. Alonso de Linaje" <calonso AT i-network.com>
- To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
- Subject: RE: [freetds] Read from SQL server failed. Problem in pool
- Date: Thu, 31 Jul 2003 10:12:31 +0200
tsql input
1> SELECT c.idCampana,c.nombre,c.salesgroup,c.idAgency,c.idAdvertiser,c.idCampanaMain,c.salesperson,c.idInvoiceTo,
2> convert(char, c.fechaInicio,105) as fechaInicio,
3> convert(char, c.fechaFin,105) as fechaFin,c.idOrderNum,c.campType,ct.campTypeShortName,sg.SG_ShortName,c.OrderStatus,c.OrderSubStatus, c.VolumeDiscount, c.CashDiscount,(cda.Discount+c.ExtraDiscount) as AgencyDiscount, RefAgency
4> FROM campanas c,campaign_types ct,cd_sales_groups sg,cd_users cda
5> WHERE c.campType=ct.campTypeID AND c.salesgroup=sg.IDsgroup AND c.idAgency=cda.IDuser AND c.idCampana='1450'
6> go
Segmentation fault
freetds.log (query truncated)
Sending packet @ 2003-07-31 09:43:32.253700
0000 01 00 02 00 00 00 00 00 53 45 4c 45 43 54 20 63 |........ SELECT c|
0010 2e 69 64 43 61 6d 70 61 6e 61 2c 63 2e 6e 6f 6d |.idCampa na,c.nom|
0020 62 72 65 2c 63 2e 73 61 6c 65 73 67 72 6f 75 70 |bre,c.sa lesgroup|
0030 2c 63 2e 69 64 41 67 65 6e 63 79 2c 63 2e 69 64 |,c.idAge ncy,c.id|
0040 41 64 76 65 72 74 69 73 65 72 2c 63 2e 69 64 43 |Advertis er,c.idC|
0050 61 6d 70 61 6e 61 4d 61 69 6e 2c 63 2e 73 61 6c |ampanaMa in,c.sal|
0060 65 73 70 65 72 73 6f 6e 2c 63 2e 69 64 49 6e 76 |esperson ,c.idInv|
0070 6f 69 63 65 54 6f 2c 0a 63 6f 6e 76 65 72 74 28 |oiceTo,. convert(|
0080 63 68 61 72 2c 20 63 2e 66 65 63 68 61 49 6e 69 |char, c. fechaIni|
0090 63 69 6f 2c 31 30 35 29 20 61 73 20 66 65 63 68 |cio,105) as fech|
00a0 61 49 6e 69 63 69 6f 2c 0a 63 6f 6e 76 65 72 74 |aInicio, .convert|
00b0 28 63 68 61 72 2c 20 63 2e 66 65 63 68 61 46 69 |(char, c .fechaFi|
00c0 6e 2c 31 30 35 29 20 61 73 20 66 65 63 68 61 46 |n,105) a s fechaF|
00d0 69 6e 2c 63 2e 69 64 4f 72 64 65 72 4e 75 6d 2c |in,c.idO rderNum,|
00e0 63 2e 63 61 6d 70 54 79 70 65 2c 63 74 2e 63 61 |c.campTy pe,ct.ca|
00f0 6d 70 54 79 70 65 53 68 6f 72 74 4e 61 6d 65 2c |mpTypeSh ortName,|
0100 73 67 2e 53 47 5f 53 68 6f 72 74 4e 61 6d 65 2c |sg.SG_Sh ortName,|
0110 63 2e 4f 72 64 65 72 53 74 61 74 75 73 2c 63 2e |c.OrderS tatus,c.|
0120 4f 72 64 65 72 53 75 62 53 74 61 74 75 73 2c 20 |OrderSub Status, |
0130 63 2e 56 6f 6c 75 6d 65 44 69 73 63 6f 75 6e 74 |c.Volume Discount|
0140 2c 20 63 2e 43 61 73 68 44 69 73 63 6f 75 6e 74 |, c.Cash Discount|
0150 2c 28 63 64 61 2e 44 69 73 63 6f 75 6e 74 2b 63 |,(cda.Di scount+c|
0160 2e 45 78 74 72 61 44 69 73 63 6f 75 6e 74 29 20 |.ExtraDi scount) |
0170 61 73 20 41 67 65 6e 63 79 44 69 73 63 6f 75 6e |as Agenc yDiscoun|
0180 74 2c 20 52 65 66 41 67 65 6e 63 79 20 0a 46 52 |t, RefAg ency .FR|
0190 4f 4d 20 63 61 6d 70 61 6e 61 73 20 63 2c 63 61 |OM campa nas c,ca|
01a0 6d 70 61 69 67 6e 5f 74 79 70 65 73 20 63 74 2c |mpaign_t ypes ct,|
01b0 63 64 5f 73 61 6c 65 73 5f 67 72 6f 75 70 73 20 |cd_sales _groups |
01c0 73 67 2c 63 64 5f 75 73 65 72 73 20 63 64 61 20 |sg,cd_us ers cda |
01d0 0a 57 48 45 52 45 20 63 2e 63 61 6d 70 54 79 70 |.WHERE c .campTyp|
01e0 65 3d 63 74 2e 63 61 6d 70 54 79 70 65 49 44 20 |e=ct.cam pTypeID |
01f0 41 4e 44 20 63 2e 73 61 6c 65 73 67 72 6f 75 70 |AND c.sa lesgroup|
pool.log (standar output for pools),(query truncated)
waiting for a connect
0000 01 00 02 00 00 00 00 00 53 45 4c 45 43 54 20 63 |........SELECT c|
0010 2e 69 64 43 61 6d 70 61 6e 61 2c 63 2e 6e 6f 6d |.idCampana,c.nom|
0020 62 72 65 2c 63 2e 73 61 6c 65 73 67 72 6f 75 70 |bre,c.salesgroup|
0030 2c 63 2e 69 64 41 67 65 6e 63 79 2c 63 2e 69 64 |,c.idAgency,c.id|
0040 41 64 76 65 72 74 69 73 65 72 2c 63 2e 69 64 43 |Advertiser,c.idC|
0050 61 6d 70 61 6e 61 4d 61 69 6e 2c 63 2e 73 61 6c |ampanaMain,c.sal|
0060 65 73 70 65 72 73 6f 6e 2c 63 2e 69 64 49 6e 76 |esperson,c.idInv|
0070 6f 69 63 65 54 6f 2c 0a 63 6f 6e 76 65 72 74 28 |oiceTo,.convert(|
0080 63 68 61 72 2c 20 63 2e 66 65 63 68 61 49 6e 69 |char, c.fechaIni|
0090 63 69 6f 2c 31 30 35 29 20 61 73 20 66 65 63 68 |cio,105) as fech|
00a0 61 49 6e 69 63 69 6f 2c 0a 63 6f 6e 76 65 72 74 |aInicio,.convert|
00b0 28 63 68 61 72 2c 20 63 2e 66 65 63 68 61 46 69 |(char, c.fechaFi|
00c0 6e 2c 31 30 35 29 20 61 73 20 66 65 63 68 61 46 |n,105) as fechaF|
00d0 69 6e 2c 63 2e 69 64 4f 72 64 65 72 4e 75 6d 2c |in,c.idOrderNum,|
00e0 63 2e 63 61 6d 70 54 79 70 65 2c 63 74 2e 63 61 |c.campType,ct.ca|
00f0 6d 70 54 79 70 65 53 68 6f 72 74 4e 61 6d 65 2c |mpTypeShortName,|
0100 73 67 2e 53 47 5f 53 68 6f 72 74 4e 61 6d 65 2c |sg.SG_ShortName,|
0110 63 2e 4f 72 64 65 72 53 74 61 74 75 73 2c 63 2e |c.OrderStatus,c.|
0120 4f 72 64 65 72 53 75 62 53 74 61 74 75 73 2c 20 |OrderSubStatus, |
0130 63 2e 56 6f 6c 75 6d 65 44 69 73 63 6f 75 6e 74 |c.VolumeDiscount|
0140 2c 20 63 2e 43 61 73 68 44 69 73 63 6f 75 6e 74 |, c.CashDiscount|
0150 2c 28 63 64 61 2e 44 69 73 63 6f 75 6e 74 2b 63 |,(cda.Discount+c|
0160 2e 45 78 74 72 61 44 69 73 63 6f 75 6e 74 29 20 |.ExtraDiscount) |
0170 61 73 20 41 67 65 6e 63 79 44 69 73 63 6f 75 6e |as AgencyDiscoun|
0180 74 2c 20 52 65 66 41 67 65 6e 63 79 20 0a 46 52 |t, RefAgency .FR|
0190 4f 4d 20 63 61 6d 70 61 6e 61 73 20 63 2c 63 61 |OM campanas c,ca|
01a0 6d 70 61 69 67 6e 5f 74 79 70 65 73 20 63 74 2c |mpaign_types ct,|
01b0 63 64 5f 73 61 6c 65 73 5f 67 72 6f 75 70 73 20 |cd_sales_groups |
01c0 73 67 2c 63 64 5f 75 73 65 72 73 20 63 64 61 20 |sg,cd_users cda |
01d0 0a 57 48 45 52 45 20 63 2e 63 61 6d 70 54 79 70 |.WHERE c.campTyp|
01e0 65 3d 63 74 2e 63 61 6d 70 54 79 70 65 49 44 20 |e=ct.campTypeID |
01f0 41 4e 44 20 63 2e 73 61 6c 65 73 67 72 6f 75 70 |AND c.salesgroup|
trying again writing diferent...
1> SELECT c.idCampana,c.nombre,c.salesgroup,c.idAgency,c.idAdvertiser,c.idCampanaMain,c.salesperson,c.idInvoiceTo,
2> convert(char, c.fechaInicio,105) as fechaInicio,
3> convert(char, c.fechaFin,105) as fechaFin,c.idOrderNum,c.campType,ct.campTypeShortName,sg.SG_ShortName,
4> c.OrderStatus,c.OrderSubStatus, c.VolumeDiscount, c.CashDiscount,(cda.Discount+c.ExtraDiscount) as AgencyDiscount, RefAgency
5> FROM campanas c,campaign_types ct,cd_sales_groups sg,cd_users cda
6> WHERE c.campType=ct.campTypeID AND c.salesgroup=sg.IDsgroup AND c.idAgency=cda.IDuser AND c.idCampana='1450'
7> go
Msg 170, Level 15, State 1, Server SQLSRV1, Line 1
Line 1: Incorrect syntax near '='.
freetds.conf have no log
pool.log
0000 01 00 02 00 00 00 00 00 53 45 4c 45 43 54 20 63 |........SELECT c|
0010 2e 69 64 43 61 6d 70 61 6e 61 2c 63 2e 6e 6f 6d |.idCampana,c.nom|
0020 62 72 65 2c 63 2e 73 61 6c 65 73 67 72 6f 75 70 |bre,c.salesgroup|
0030 2c 63 2e 69 64 41 67 65 6e 63 79 2c 63 2e 69 64 |,c.idAgency,c.id|
0040 41 64 76 65 72 74 69 73 65 72 2c 63 2e 69 64 43 |Advertiser,c.idC|
0050 61 6d 70 61 6e 61 4d 61 69 6e 2c 63 2e 73 61 6c |ampanaMain,c.sal|
0060 65 73 70 65 72 73 6f 6e 2c 63 2e 69 64 49 6e 76 |esperson,c.idInv|
0070 6f 69 63 65 54 6f 2c 0a 63 6f 6e 76 65 72 74 28 |oiceTo,.convert(|
0080 63 68 61 72 2c 20 63 2e 66 65 63 68 61 49 6e 69 |char, c.fechaIni|
0090 63 69 6f 2c 31 30 35 29 20 61 73 20 66 65 63 68 |cio,105) as fech|
00a0 61 49 6e 69 63 69 6f 2c 0a 63 6f 6e 76 65 72 74 |aInicio,.convert|
00b0 28 63 68 61 72 2c 20 63 2e 66 65 63 68 61 46 69 |(char, c.fechaFi|
00c0 6e 2c 31 30 35 29 20 61 73 20 66 65 63 68 61 46 |n,105) as fechaF|
00d0 69 6e 2c 63 2e 69 64 4f 72 64 65 72 4e 75 6d 2c |in,c.idOrderNum,|
00e0 63 2e 63 61 6d 70 54 79 70 65 2c 63 74 2e 63 61 |c.campType,ct.ca|
00f0 6d 70 54 79 70 65 53 68 6f 72 74 4e 61 6d 65 2c |mpTypeShortName,|
0100 73 67 2e 53 47 5f 53 68 6f 72 74 4e 61 6d 65 2c |sg.SG_ShortName,|
0110 0a 63 2e 4f 72 64 65 72 53 74 61 74 75 73 2c 63 |.c.OrderStatus,c|
0120 2e 4f 72 64 65 72 53 75 62 53 74 61 74 75 73 2c |.OrderSubStatus,|
0130 20 63 2e 56 6f 6c 75 6d 65 44 69 73 63 6f 75 6e | c.VolumeDiscoun|
0140 74 2c 20 63 2e 43 61 73 68 44 69 73 63 6f 75 6e |t, c.CashDiscoun|
0150 74 2c 28 63 64 61 2e 44 69 73 63 6f 75 6e 74 2b |t,(cda.Discount+|
0160 63 2e 45 78 74 72 61 44 69 73 63 6f 75 6e 74 29 |c.ExtraDiscount)|
0170 20 61 73 20 41 67 65 6e 63 79 44 69 73 63 6f 75 | as AgencyDiscou|
0180 6e 74 2c 20 52 65 66 41 67 65 6e 63 79 20 0a 46 |nt, RefAgency .F|
0190 52 4f 4d 20 63 61 6d 70 61 6e 61 73 20 63 2c 63 |ROM campanas c,c|
01a0 61 6d 70 61 69 67 6e 5f 74 79 70 65 73 20 63 74 |ampaign_types ct|
01b0 2c 63 64 5f 73 61 6c 65 73 5f 67 72 6f 75 70 73 |,cd_sales_groups|
01c0 20 73 67 2c 63 64 5f 75 73 65 72 73 20 63 64 61 | sg,cd_users cda|
01d0 20 0a 57 48 45 52 45 20 63 2e 63 61 6d 70 54 79 | .WHERE c.campTy|
01e0 70 65 3d 63 74 2e 63 61 6d 70 54 79 70 65 49 44 |pe=ct.campTypeID|
01f0 20 41 4e 44 20 63 2e 73 61 6c 65 73 67 72 6f 75 | AND c.salesgrou|
waiting for a connect
0000 01 01 00 47 00 00 00 00 70 3d 73 67 2e 49 44 73 |...G....p=sg.IDs|
0010 67 72 6f 75 70 20 41 4e 44 20 63 2e 69 64 41 67 |group AND c.idAg|
0020 65 6e 63 79 3d 63 64 61 2e 49 44 75 73 65 72 20 |ency=cda.IDuser |
0030 41 4e 44 20 63 2e 69 64 43 61 6d 70 61 6e 61 3d |AND c.idCampana=|
0040 27 31 34 35 30 27 0a |'1450'.|
Another format
1> SELECT c.idCampana,c.nombre,c.salesgroup,c.idAgency,c.idAdvertiser,c.idCampanaMain,c.salesperson,c.idInvoiceTo,convert(char, c.fechaInicio,105) as fechaInicio,convert(char, c.fechaFin,105) as fechaFin,c.idOrderNum,c.campType,ct.campTypeShortName,sg.SG_ShortName,c.OrderStatus,c.OrderSubStatus, c.VolumeDiscount, c.CashDiscount,(cda.Discount+c.ExtraDiscount) as AgencyDiscount, RefAgency FROM campanas c,campaign_types ct,cd_sales_groups sg,cd_users cda WHERE c.campType=ct.campTypeID AND c.salesgroup=sg.IDsgroup AND c.idAgency=cda.IDuser AND c.idCampana='1454'
2> go
Msg 156, Level 15, State 1, Server SQLSRV1, Line 1
Incorrect syntax near the keyword 'AND'.
freetds.log
==> freetds.log: file truncated <==
Received header @ 2003-07-31 10:07:13.823398
0000 04 01 00 4f 00 00 00 00 |...O....|
Received packet @ 2003-07-31 10:07:13.823488
0000 aa 3b 00 9c 00 00 00 01 0f 28 00 49 6e 63 6f 72 |.;...... .(.Incor|
0010 72 65 63 74 20 73 79 6e 74 61 78 20 6e 65 61 72 |rect syn tax near|
0020 20 74 68 65 20 6b 65 79 77 6f 72 64 20 27 41 4e | the key word 'AN|
0030 44 27 2e 07 53 51 4c 53 52 56 31 00 01 00 fd 02 |D'..SQLS RV1.....|
0040 00 fd 00 00 00 00 00 |.......|
2003-07-31 10:07:13.823637 processing result tokens. marker is aa(ERROR)
2003-07-31 10:07:13.823678 inside tds_process_default_tokens() marker is aa(ERROR)
2003-07-31 10:07:13.823790 processing result tokens. marker is fd(DONE)
2003-07-31 10:07:13.823829 inside tds_process_end() more_results = 0, was_cancelled = 0
2003-07-31 10:07:13.823865 inside tds_process_result_tokens() state is COMPLETED
No log in pool.log
It looks like tsql by pool truncate the query string....
If i tried directly without pool the query works fine...
1> SELECT c.idCampana,c.nombre,c.salesgroup,c.idAgency,c.idAdvertiser,c.idCampanaMain,c.salesperson,c.idInvoiceTo,convert(char, c.fechaInicio,105) as fechaInicio,convert(char, c.fechaFin,105) as fechaFin,c.idOrderNum,c.campType,ct.campTypeShortName,sg.SG_ShortName,c.OrderStatus,c.OrderSubStatus,c.VolumeDiscount, c.CashDiscount,(cda.Discount+c.ExtraDiscount) as AgencyDiscount,RefAgency FROM campanas c,campaign_types ct,cd_sales_groups sg,cd_users cda WHERE c.campType=ct.campTypeID AND c.salesgroup=sg.IDsgroup AND c.idAgency=cda.IDuser AND c.idCampana='1450'
2> go
idCampana nombre salesgroup idAgency idAdvertiser idCampanaMain salesperson idInvoiceTo fechaIniciofechaFin idOrderNum campType campTypeShortName SG_ShortName OrderStatus OrderSubStatus VolumeDiscount CashDiscount AgencyDiscount RefAgency
1450 msniespanaagosto 1 2258 2587 ESXXXXXXXX 372 2258 24-07-2003 24-08-2003 ES03PUB01450 1 PUB ES 2 0 0 0 0
1>
freetds.log
Sending packet @ 2003-07-31 10:12:23.301629
0000 01 00 02 00 00 00 00 00 53 45 4c 45 43 54 20 63 |........ SELECT c|
0010 2e 69 64 43 61 6d 70 61 6e 61 2c 63 2e 6e 6f 6d |.idCampa na,c.nom|
0020 62 72 65 2c 63 2e 73 61 6c 65 73 67 72 6f 75 70 |bre,c.sa lesgroup|
0030 2c 63 2e 69 64 41 67 65 6e 63 79 2c 63 2e 69 64 |,c.idAge ncy,c.id|
0040 41 64 76 65 72 74 69 73 65 72 2c 63 2e 69 64 43 |Advertis er,c.idC|
0050 61 6d 70 61 6e 61 4d 61 69 6e 2c 63 2e 73 61 6c |ampanaMa in,c.sal|
0060 65 73 70 65 72 73 6f 6e 2c 63 2e 69 64 49 6e 76 |esperson ,c.idInv|
0070 6f 69 63 65 54 6f 2c 63 6f 6e 76 65 72 74 28 63 |oiceTo,c onvert(c|
0080 68 61 72 2c 20 63 2e 66 65 63 68 61 49 6e 69 63 |har, c.f echaInic|
0090 69 6f 2c 31 30 35 29 20 61 73 20 66 65 63 68 61 |io,105) as fecha|
00a0 49 6e 69 63 69 6f 2c 63 6f 6e 76 65 72 74 28 63 |Inicio,c onvert(c|
00b0 68 61 72 2c 20 63 2e 66 65 63 68 61 46 69 6e 2c |har, c.f echaFin,|
00c0 31 30 35 29 20 61 73 20 66 65 63 68 61 46 69 6e |105) as fechaFin|
00d0 2c 63 2e 69 64 4f 72 64 65 72 4e 75 6d 2c 63 2e |,c.idOrd erNum,c.|
00e0 63 61 6d 70 54 79 70 65 2c 63 74 2e 63 61 6d 70 |campType ,ct.camp|
00f0 54 79 70 65 53 68 6f 72 74 4e 61 6d 65 2c 73 67 |TypeShor tName,sg|
0100 2e 53 47 5f 53 68 6f 72 74 4e 61 6d 65 2c 63 2e |.SG_Shor tName,c.|
0110 4f 72 64 65 72 53 74 61 74 75 73 2c 63 2e 4f 72 |OrderSta tus,c.Or|
0120 64 65 72 53 75 62 53 74 61 74 75 73 2c 63 2e 56 |derSubSt atus,c.V|
0130 6f 6c 75 6d 65 44 69 73 63 6f 75 6e 74 2c 20 63 |olumeDis count, c|
0140 2e 43 61 73 68 44 69 73 63 6f 75 6e 74 2c 28 63 |.CashDis count,(c|
0150 64 61 2e 44 69 73 63 6f 75 6e 74 2b 63 2e 45 78 |da.Disco unt+c.Ex|
0160 74 72 61 44 69 73 63 6f 75 6e 74 29 20 61 73 20 |traDisco unt) as |
0170 41 67 65 6e 63 79 44 69 73 63 6f 75 6e 74 2c 52 |AgencyDi scount,R|
0180 65 66 41 67 65 6e 63 79 20 46 52 4f 4d 20 63 61 |efAgency FROM ca|
0190 6d 70 61 6e 61 73 20 63 2c 63 61 6d 70 61 69 67 |mpanas c ,campaig|
01a0 6e 5f 74 79 70 65 73 20 63 74 2c 63 64 5f 73 61 |n_types ct,cd_sa|
01b0 6c 65 73 5f 67 72 6f 75 70 73 20 73 67 2c 63 64 |les_grou ps sg,cd|
01c0 5f 75 73 65 72 73 20 63 64 61 20 57 48 45 52 45 |_users c da WHERE|
01d0 20 63 2e 63 61 6d 70 54 79 70 65 3d 63 74 2e 63 | c.campT ype=ct.c|
01e0 61 6d 70 54 79 70 65 49 44 20 41 4e 44 20 63 2e |ampTypeI D AND c.|
01f0 73 61 6c 65 73 67 72 6f 75 70 3d 73 67 2e 49 44 |salesgro up=sg.ID|
Sending packet @ 2003-07-31 10:12:23.302591
0000 01 01 00 40 00 00 00 00 73 67 72 6f 75 70 20 41 |...@.... sgroup A|
0010 4e 44 20 63 2e 69 64 41 67 65 6e 63 79 3d 63 64 |ND c.idA gency=cd|
0020 61 2e 49 44 75 73 65 72 20 41 4e 44 20 63 2e 69 |a.IDuser AND c.i|
0030 64 43 61 6d 70 61 6e 61 3d 27 31 34 35 30 27 0a |dCampana ='1450'.|
Received header @ 2003-07-31 10:12:23.451386
0000 04 00 02 00 00 00 00 00 |........|
Received packet @ 2003-07-31 10:12:23.451484
0000 a0 f0 00 09 69 64 43 61 6d 70 61 6e 61 06 6e 6f |....idCa mpana.no|
0010 6d 62 72 65 0a 73 61 6c 65 73 67 72 6f 75 70 08 |mbre.sal esgroup.|
0020 69 64 41 67 65 6e 63 79 0c 69 64 41 64 76 65 72 |idAgency .idAdver|
0030 74 69 73 65 72 0d 69 64 43 61 6d 70 61 6e 61 4d |tiser.id CampanaM|
0040 61 69 6e 0b 73 61 6c 65 73 70 65 72 73 6f 6e 0b |ain.sale sperson.|
0050 69 64 49 6e 76 6f 69 63 65 54 6f 0b 66 65 63 68 |idInvoic eTo.fech|
0060 61 49 6e 69 63 69 6f 08 66 65 63 68 61 46 69 6e |aInicio. fechaFin|
0070 0a 69 64 4f 72 64 65 72 4e 75 6d 08 63 61 6d 70 |.idOrder Num.camp|
0080 54 79 70 65 11 63 61 6d 70 54 79 70 65 53 68 6f |Type.cam pTypeSho|
0090 72 74 4e 61 6d 65 0c 53 47 5f 53 68 6f 72 74 4e |rtName.S G_ShortN|
00a0 61 6d 65 0b 4f 72 64 65 72 53 74 61 74 75 73 0e |ame.Orde rStatus.|
00b0 4f 72 64 65 72 53 75 62 53 74 61 74 75 73 0e 56 |OrderSub Status.V|
00c0 6f 6c 75 6d 65 44 69 73 63 6f 75 6e 74 0c 43 61 |olumeDis count.Ca|
00d0 73 68 44 69 73 63 6f 75 6e 74 0e 41 67 65 6e 63 |shDiscou nt.Agenc|
00e0 79 44 69 73 63 6f 75 6e 74 09 52 65 66 41 67 65 |yDiscoun t.RefAge|
00f0 6e 63 79 a1 76 00 07 00 10 00 38 02 00 08 00 27 |ncy.v... ..8....'|
0100 14 05 00 08 00 30 0d 00 09 00 26 02 0d 00 09 00 |.....0.. ..&.....|
0110 26 02 02 00 08 00 27 0b 0d 00 09 00 26 02 0d 00 |&.....'. ....&...|
0120 09 00 26 02 01 00 01 00 27 1e 01 00 01 00 27 1e |..&..... '.....'.|
0130 02 00 09 00 27 0f 0d 00 09 00 26 01 02 00 08 00 |....'... ..&.....|
0140 27 03 02 00 08 00 27 03 0d 00 09 00 26 01 0d 00 |'.....'. ....&...|
0150 09 00 26 01 0e 00 09 00 6d 08 0e 00 09 00 6d 08 |..&..... m.....m.|
0160 0e 00 01 00 6d 08 02 00 09 00 27 19 d1 aa 05 00 |....m... ..'.....|
0170 00 10 6d 73 6e 69 65 73 70 61 6e 61 61 67 6f 73 |..msnies panaagos|
0180 74 6f 01 02 d2 08 02 1b 0a 0a 45 53 58 58 58 58 |to...... ..ESXXXX|
0190 58 58 58 58 02 74 01 02 d2 08 1e 32 34 2d 30 37 |XXXX.t.. ...24-07|
01a0 2d 32 30 30 33 20 20 20 20 20 20 20 20 20 20 20 |-2003 |
01b0 20 20 20 20 20 20 20 20 20 1e 32 34 2d 30 38 2d | .24-08-|
01c0 32 30 30 33 20 20 20 20 20 20 20 20 20 20 20 20 |2003 |
01d0 20 20 20 20 20 20 20 20 0c 45 53 30 33 50 55 42 | .ES03PUB|
01e0 30 31 34 35 30 01 01 03 50 55 42 02 45 53 01 02 |01450... PUB.ES..|
01f0 01 00 08 00 00 00 00 00 |........|
2003-07-31 10:12:23.452347 processing result tokens. marker is a0(COLNAME)
2003-07-31 10:12:23.452494 processing result tokens. marker is a1(COLFMT)
2003-07-31 10:12:23.452541 processing result. type = 56(int), varint_size 0
2003-07-31 10:12:23.452576 processing result. type = 39(varchar), varint_size
1
2003-07-31 10:12:23.452609 processing result. type = 48(tinyint), varint_size 0
2003-07-31 10:12:23.452641 processing result. type = 38(integer-null), varint_size 1
2003-07-31 10:12:23.452673 processing result. type = 38(integer-null), varint_size 1
2003-07-31 10:12:23.452705 processing result. type = 39(varchar), varint_size
1
2003-07-31 10:12:23.452736 processing result. type = 38(integer-null), varint_size 1
2003-07-31 10:12:23.452768 processing result. type = 38(integer-null), varint_size 1
2003-07-31 10:12:23.452821 processing result. type = 39(varchar), varint_size
1
2003-07-31 10:12:23.452857 processing result. type = 39(varchar), varint_size
1
2003-07-31 10:12:23.452888 processing result. type = 39(varchar), varint_size
1
2003-07-31 10:12:23.452919 processing result. type = 38(integer-null), varint_size 1
2003-07-31 10:12:23.452950 processing result. type = 39(varchar), varint_size
1
2003-07-31 10:12:23.452981 processing result. type = 39(varchar), varint_size
1
2003-07-31 10:12:23.453013 processing result. type = 38(integer-null), varint_size 1
2003-07-31 10:12:23.453044 processing result. type = 38(integer-null), varint_size 1
2003-07-31 10:12:23.453076 processing result. type = 109(float-null), varint_size 1
2003-07-31 10:12:23.453107 processing result. type = 109(float-null), varint_size 1
2003-07-31 10:12:23.453139 processing result. type = 109(float-null), varint_size 1
2003-07-31 10:12:23.453170 processing result. type = 39(varchar), varint_size
1
2003-07-31 10:12:23.453350 processing result tokens. marker is d1(ROW)
2003-07-31 10:12:23.453404 processing row tokens. marker is d1(ROW)
2003-07-31 10:12:23.453437 processing row. column is 0 varint size = 0
2003-07-31 10:12:23.453467 processing row. column size is 4
2003-07-31 10:12:23.453494 clearing column 0 NULL bit
2003-07-31 10:12:23.453520 processing row. column is 1 varint size = 1
2003-07-31 10:12:23.453550 processing row. column size is 16
2003-07-31 10:12:23.453576 clearing column 1 NULL bit
2003-07-31 10:12:23.453601 processing row. column is 2 varint size = 0
2003-07-31 10:12:23.453630 processing row. column size is 1
2003-07-31 10:12:23.453656 clearing column 2 NULL bit
2003-07-31 10:12:23.453681 processing row. column is 3 varint size = 1
2003-07-31 10:12:23.453710 processing row. column size is 2
2003-07-31 10:12:23.453735 clearing column 3 NULL bit
2003-07-31 10:12:23.453760 processing row. column is 4 varint size = 1
2003-07-31 10:12:23.453789 processing row. column size is 2
2003-07-31 10:12:23.453814 clearing column 4 NULL bit
2003-07-31 10:12:23.453839 processing row. column is 5 varint size = 1
2003-07-31 10:12:23.453868 processing row. column size is 10
2003-07-31 10:12:23.453893 clearing column 5 NULL bit
2003-07-31 10:12:23.453920 processing row. column is 6 varint size = 1
2003-07-31 10:12:23.453949 processing row. column size is 2
2003-07-31 10:12:23.453975 clearing column 6 NULL bit
2003-07-31 10:12:23.454000 processing row. column is 7 varint size = 1
2003-07-31 10:12:23.454028 processing row. column size is 2
2003-07-31 10:12:23.454054 clearing column 7 NULL bit
2003-07-31 10:12:23.454078 processing row. column is 8 varint size = 1
2003-07-31 10:12:23.454107 processing row. column size is 30
2003-07-31 10:12:23.454132 clearing column 8 NULL bit
2003-07-31 10:12:23.454157 processing row. column is 9 varint size = 1
2003-07-31 10:12:23.454186 processing row. column size is 30
2003-07-31 10:12:23.454212 clearing column 9 NULL bit
2003-07-31 10:12:23.454237 processing row. column is 10 varint size = 1
2003-07-31 10:12:23.454266 processing row. column size is 12
2003-07-31 10:12:23.454291 clearing column 10 NULL bit
2003-07-31 10:12:23.454316 processing row. column is 11 varint size = 1
2003-07-31 10:12:23.454345 processing row. column size is 1
2003-07-31 10:12:23.454370 clearing column 11 NULL bit
2003-07-31 10:12:23.454395 processing row. column is 12 varint size = 1
2003-07-31 10:12:23.454424 processing row. column size is 3
2003-07-31 10:12:23.454449 clearing column 12 NULL bit
2003-07-31 10:12:23.454474 processing row. column is 13 varint size = 1
2003-07-31 10:12:23.454503 processing row. column size is 2
2003-07-31 10:12:23.454529 clearing column 13 NULL bit
2003-07-31 10:12:23.454553 processing row. column is 14 varint size = 1
2003-07-31 10:12:23.454582 processing row. column size is 1
2003-07-31 10:12:23.454608 clearing column 14 NULL bit
2003-07-31 10:12:23.454633 processing row. column is 15 varint size = 1
2003-07-31 10:12:23.454662 processing row. column size is 1
2003-07-31 10:12:23.454709 clearing column 15 NULL bit
2003-07-31 10:12:23.454739 processing row. column is 16 varint size = 1
2003-07-31 10:12:23.454768 processing row. column size is 8
2003-07-31 10:12:23.454793 clearing column 16 NULL bit
Received header @ 2003-07-31 10:12:23.454837
0000 04 01 00 28 00 00 00 00 |...(....|
Received packet @ 2003-07-31 10:12:23.454903
0000 00 00 00 08 00 00 00 00 00 00 00 00 08 00 00 00 |........ ........|
0010 00 00 00 00 00 01 20 fd 10 00 c1 00 01 00 00 00 |...... . ........|
2003-07-31 10:12:23.454987 processing row. column is 17 varint size = 1
2003-07-31 10:12:23.455017 processing row. column size is 8
2003-07-31 10:12:23.455042 clearing column 17 NULL bit
2003-07-31 10:12:23.455068 processing row. column is 18 varint size = 1
2003-07-31 10:12:23.455096 processing row. column size is 8
2003-07-31 10:12:23.455122 clearing column 18 NULL bit
2003-07-31 10:12:23.455147 processing row. column is 19 varint size = 1
2003-07-31 10:12:23.455175 processing row. column size is 1
2003-07-31 10:12:23.455201 clearing column 19 NULL bit
2003-07-31 10:12:23.455755 processing row tokens. marker is fd(DONE)
2003-07-31 10:12:23.455798 inside tds_process_end() more_results = 0, was_cancelled = 0
2003-07-31 10:12:23.455833 inside tds_process_result_tokens() state is COMPLETED
Im sorry if the email is too large :-(
Regards.
At 11:59 AM 7/30/2003 -0400, you wrote:
> From: Carlos S. Alonso de Linaje [mailto:calonso AT i-network.com]
> Sent: July 30, 2003 11:42 AM
>
> Hi... we are running pool (with all comments in free clauses
> in source)
:-)
> But when we have some large queries the connection to the
> pool response..
:-(
> Msg 20004, Level 9, State 0, Server OpenClient, Line 0
> Read from SQL server failed.
Could you post a TDSDUMP log of the tsql session that fails? I'm interested
in the conversation between tsql and the pool server, for now. Let's see if
anthing's wrong at the TDS level.
--jkl
-----------------------------------------
The information contained in this transmission may contain privileged and confidential information and is intended only for the use of the person(s) named above. If you are not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender immediately by reply e-mail and destroy all copies of the original message. Please note that we do not accept account orders and/or instructions by e-mail, and therefore will not be responsible for carrying out such orders and/or instructions.
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.505 / Virus Database: 302 - Release Date: 7/30/2003
Carlos S. Alonso de Linaje García
Director Técnico
I-network
C/Marqués de Riscal 11, 2ª planta
28010 Madrid
Tel: +34. 91.702.17.57
"Si buscas resultados distintos, no hagas lo mismo" (Albert Einstein)
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.505 / Virus Database: 302 - Release Date: 7/30/2003
-
RE: [freetds] Read from SQL server failed. Problem in pool,
Lowden, James K, 07/30/2003
- <Possible follow-up(s)>
- RE: [freetds] Read from SQL server failed. Problem in pool, Carlos S. Alonso de Linaje, 07/31/2003
Archive powered by MHonArc 2.6.24.