Thread: ERROR from backend during send_query: 'ERROR: cursor "sql_cur0140cc48" does not exist'
ERROR from backend during send_query: 'ERROR: cursor "sql_cur0140cc48" does not exist'
From
"ngoncalves81@cantv.net"
Date:
The following errors only happen when using the "USE DECLARE/FETCH" option in the ODBC Driver. When DECLARE/FETCH is
set,the data sent to some of our programs is reduced from 2 MBytes to 100 KBytes. We want to achieve this reduction.
But,with the DECLARE/FETCH option set, implicit transactions are used ... and fail !!<br /><br /> This is a PRODUCTION
environment,with some 20 clients accessing the DB.<br /><br /> Can anyone help? Thanks in advance.<br /><br /> Nuno
Goncalves<br/><br /> ....<br /> The 4th item was truncated<br /> The buffer size = 17 and the value is
'DD13m '<br /> conn=20986272, query='declare SQL_CUR0140EF48 cursor for SELECT T1.CdUsr,
T1.Perfil,T2.DscPrf FROM UsrPrf T1 LEFT OUTER JOIN PrfTbl T2 ON T1.Perfil = T2.Perfil WHERE ( T1.CdUsr = 'Nuno
Goncalves') AND ( T1.Perfil = 'VC' ) ORDER BY T1.CdUsr, T1.Perfil '<br /> conn=20986272, query='fetch 64 in
SQL_CUR0140EF48'<br/> [ fetched 0 rows ]<br /> conn=20986272, query='close SQL_CUR0140EF48'<br /> conn=20986272,
query='closeSQL_CUR0140FA70'<br /> conn=20986272, query='declare SQL_CUR0140FA70 cursor for SELECT T1.CdUsr FROM UsrEsp
T1WHERE ( T1.CdUsr = 'Nuno Goncalves' ) ORDER BY T1.CdUsr '<br /> conn=20986272, query='fetch 64 in SQL_CUR0140FA70'<br
/> [ fetched 1 rows ]<br /> conn=20986272, query='declare SQL_CUR0140FC70 cursor for SELECT T1.CdUsr, T1.Perfil,
T2.DscPrfFROM UsrPrf T1 LEFT OUTER JOIN PrfTbl T2 ON T1.Perfil = T2.Perfil WHERE ( T1.CdUsr = 'Nuno Goncalves' )
ORDERBY T1.CdUsr, T1.Perfil '<br /> conn=20986272, query='fetch 64 in SQL_CUR0140FC70'<br /> [ fetched 0 rows ]<br
/>conn=20986272, query='close SQL_CUR0140FC70'<br /> conn=20986272, query='declare SQL_CUR0140EF48 cursor for SELECT
T1.CdUsr,T1.Perfil, T2.DscPrf FROM UsrPrf T1 LEFT OUTER JOIN PrfTbl T2 ON T1.Perfil = T2.Perfil WHERE ( T1.CdUsr =
'NunoGoncalves' ) AND ( T1.Perfil = 'VC' ) ORDER BY T1.CdUsr, T1.Perfil '<br /> conn=20986272, query='fetch 64 in
SQL_CUR0140EF48'<br/> [ fetched 0 rows ]<br /> conn=20986272, query='close SQL_CUR0140EF48'<br /> conn=20986272,
query='closeSQL_CUR0140FA70'<br /> conn=20986272, query='declare SQL_CUR0140FA70 cursor for SELECT T1.CdUsr FROM UsrEsp
T1WHERE ( T1.CdUsr = 'Nuno Goncalves' ) ORDER BY T1.CdUsr '<br /> conn=20986272, query='fetch 64 in SQL_CUR0140FA70'<br
/> [ fetched 1 rows ]<br /> conn=20986272, query='declare SQL_CUR0140FC70 cursor for SELECT T1.CdUsr, T1.Perfil,
T2.DscPrfFROM UsrPrf T1 LEFT OUTER JOIN PrfTbl T2 ON T1.Perfil = T2.Perfil WHERE ( T1.CdUsr = 'Nuno Goncalves' )
ORDERBY T1.CdUsr, T1.Perfil '<br /> conn=20986272, query='fetch 64 in SQL_CUR0140FC70'<br /> [ fetched 0 rows ]<br
/>conn=20986272, query='close SQL_CUR0140FC70'<br /> conn=20986272, query='declare SQL_CUR0140EF48 cursor for SELECT
T1.CdUsr,T1.Perfil, T2.DscPrf FROM UsrPrf T1 LEFT OUTER JOIN PrfTbl T2 ON T1.Perfil = T2.Perfil WHERE ( T1.CdUsr =
'NunoGoncalves' ) AND ( T1.Perfil = 'VC' ) ORDER BY T1.CdUsr, T1.Perfil '<br /> conn=20986272, query='fetch 64 in
SQL_CUR0140EF48'<br/> [ fetched 0 rows ]<br /> conn=20986272, query='close SQL_CUR0140EF48'<br /> conn=20986272,
query='closeSQL_CUR0140FA70'<br /> conn=20986272, query='declare SQL_CUR0140FA70 cursor for SELECT T1.CdUsr FROM UsrEsp
T1WHERE ( T1.CdUsr = 'Nuno Goncalves' ) ORDER BY T1.CdUsr '<br /> conn=20986272, query='fetch 64 in SQL_CUR0140FA70'<br
/> [ fetched 1 rows ]<br /> conn=20986272, query='declare SQL_CUR0140FC70 cursor for SELECT T1.CdUsr, T1.Perfil,
T2.DscPrfFROM UsrPrf T1 LEFT OUTER JOIN PrfTbl T2 ON T1.Perfil = T2.Perfil WHERE ( T1.CdUsr = 'Nuno Goncalves' )
ORDERBY T1.CdUsr, T1.Perfil '<br /> conn=20986272, query='fetch 64 in SQL_CUR0140FC70'<br /> [ fetched 0 rows ]<br
/>conn=20986272, query='close SQL_CUR0140FC70'<br /> conn=20986272, query='declare SQL_CUR01732D38 cursor for SELECT
T1.CnCiaR,T2.CdCia, T3.RazonSocial, T1.CnCarga, T1.TpCarga, T1.FileX, T1.RegTot, T1.RegOK, T1.FCarga, T1.HCarga,
T1.StCarga,T1.Usr, T1.Pgm, T1.FAud, T1.HAud, T1.CntMod FROM Carga T1 LEFT OUTER JOIN Persona T3 ON T1.CnCiaR =
T3.CnPerLEFT OUTER JOIN Compania T2 ON T1.CnCiaR = T2.CnCiaR WHERE ( T1.CnCiaR = '1' ) AND ( T1.TpCarga = '5' ) ORDER
BYT1.CnCiaR, T1.TpCarga, T1.CnCarga DESC, T1.StCarga DESC '<br /> conn=20986272, query='fetch 64 in
SQL_CUR01732D38'<br/> [ fetched 1 rows ]<br /> conn=20986272, query='close SQL_CUR01732D38'<br /> conn=20986272,
query='declareSQL_CUR01728CE8 cursor for SELECT * FROM cargar_pedido('EMB 74_2',1,'S','','Nuno Goncalves');<br />
VACUUMpddasm;'<br /> ERROR from backend during send_query: 'ERROR: VACUUM cannot run inside a transaction block'<br />
conn=20986272,query='ROLLBACK'<br /> STATEMENT ERROR: func=SC_execute, desc='', errnum=7, errmsg='Error while executing
thequery'<br /> &nbs p; ------------------------------------------------------------<br />
hdbc=20986272, stmt=24284392, result=24316648<br /> &nbs p;
manual_result=0,prepare=1, internal=0<br /> &nbs p; bindings=24284888, bindings_allocated=1<br />
parameters=0, parameters_allocated=0<br /> &nbs p; statement_type=0,
statement='SELECT* FROM cargar_pedido('EMB 74_2',1,'S','','Nuno Goncalves');<br /> VACUUM pddasm;'<br />
stmt_with_params='declare SQL_CUR01728CE8 cursor for SELECT * FROM cargar_pedido('EMB
74_2',1,'S','','NunoGoncalves');<br /> VACUUM pddasm;'<br /> &nbs p; data_at_exec=-1,
current_exec_param=-1,put_data=0<br /> &nbs p; currTuple=-1, current_col=-1, lobj_fd=-1<br />
maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0, scroll_concurrency=1<br />
cursor_name='SQL_CUR01728CE8'<br /> &nbs p; ----------------QResult Info
-------------------------------<br/> &nbs p; fields=24273768, manual_tuples=0, backend_tuples=0,
tupleField=0,conn=0<br /> &nbs p; fetch_count=0, num_total_rows=0, num_fields=0, cursor='(NULL)'<br
/> &nbs p; message='ERROR: VACUUM cannot run inside a transaction block', command='DECLARE CURSOR',
notice='(NULL)'<br/> &nbs p; status=7, inTuples=0<br /> CONN ERROR: func=SC_execute, desc='',
errnum=110,errmsg='ERROR: VACUUM cannot run inside a transaction block'<br />
------------------------------------------------------------<br/> henv=20981536, conn=20986272, status=1,
num_stmts=16<br/> sock=20981592, stmts=20981664, lobj_type=-999<br /> ---------------- Socket
Info-------------------------------<br /> socket=560, reverse=0, errornumber=0, errormsg='(NULL)'<br />
buffer_in=20997272, buffer_out=21001376<br /> buffer_filled_in=11, buffer_filled_out=0,
buffer_read_in=11<br/> conn=20986272, query='declare SQL_CUR01732D38 cursor for SELECT T1.CnCiaR, T2.CdCia,
T3.RazonSocial,T1.CnCarga, T1.TpCarga, T1.FileX, T1.RegTot, T1.RegOK, T1.FCarga, T1.HCarga, T1.StCarga, T1.Usr, T1.Pgm,
T1.FAud,T1.HAud, T1.CntMod FROM Carga T1 LEFT OUTER JOIN Persona T3 ON T1.CnCiaR = T3.CnPer LEFT OUTER JOIN Compania
T2ON T1.CnCiaR = T2.CnCiaR WHERE ( T1.CnCiaR = '1' ) AND ( T1.TpCarga = '5' ) ORDER BY T1.CnCiaR, T1.TpCarga,
T1.CnCarga DESC, T1.StCarga DESC '<br /> conn=20986272, query='fetch 64 in SQL_CUR01732D38'<br /> [ fetched 1 rows
]<br/> conn=20986272, query='close SQL_CUR01732D38'<br /> conn=20986272, query='declare SQL_CUR01732D38 cursor for
SELECTT1.CnCiaR, T2.CdCia, T3.RazonSocial, T1.CnCarga, T1.TpCarga, T1.FileX, T1.RegTot, T1.RegOK, T1.FCarga, T1.HCarga,
T1.StCarga,T1.Usr, T1.Pgm, T1.FAud, T1.HAud, T1.CntMod FROM Carga T1 LEFT OUTER JOIN Persona T3 ON T1.CnCiaR =
T3.CnPerLEFT OUTER JOIN Compania T2 ON T1.CnCiaR = T2.CnCiaR WHERE ( T1.CnCiaR = '1' ) AND ( T1.TpCarga = '5' ) ORDER
BYT1.CnCiaR, T1.TpCarga, T1.CnCarga DESC, T1.StCarga DESC '<br /> conn=20986272, query='fetch 64 in
SQL_CUR01732D38'<br/> [ fetched 1 rows ]<br /> conn=20986272, query='close SQL_CUR01732D38'<br /> conn=20986272,
query='declareSQL_CUR01728CE8 cursor for SELECT * FROM cargar_pedido('EMB 74_2',1,'S','','Nuno Goncalves');<br />
--VACUUMpddasm;'<br /> conn=20986272, query='fetch 64 in SQL_CUR01728CE8'<br /> [ fetched 3 rows ]<br />
conn=20986272,query='declare SQL_CUR01728F90 cursor for SELECT T1.CnCiaR, T2.CdCia, T3.RazonSocial, T1.CnCarga,
T1.TpCarga,T1.FileX, T1.RegTot, T1.RegOK, T1.FCarga, T1.HCarga, T1.StCarga, T1.Usr, T1.Pgm, T1.FAud, T1.HAud, T1.CntMod
FROM Carga T1 LEFT OUTER JOIN Persona T3 ON T1.CnCiaR = T3.CnPer LEFT OUTER JOIN Compania T2 ON T1.CnCiaR =
T2.CnCiaR WHERE ( T1.CnCiaR = '1' ) AND ( T1.CnCarga = '4' ) ORDER BY T1.CnCiaR, T1.CnCarga '<br /> conn=20986272,
query='fetch64 in SQL_CUR01728F90'<br /> [ fetched 1 rows ]<br /> conn=20986272, query='declare SQL_CUR01732238
cursorfor SELECT T1.CnCiaR, T1.CnCarga, T1.Crear FROM PddAsmH T1 WHERE ( T1.CnCiaR = '1' ) AND ( T1.CnCarga = '4' )
ORDERBY T1.CnCiaR, T1.CnCarga '<br /> conn=20986272, query='fetch 64 in SQL_CUR01732238'<br /> [ fetched 1 rows
]<br/> conn=20986272, query='close SQL_CUR01408548'<br /> ERROR from backend during send_query: 'ERROR: cursor
"sql_cur01408548"does not exist'<br /> conn=20986272, query='declare SQL_CUR01408548 cursor for SELECT T1.CdUsr,
T1.CnCiaR,T2.CdCia, T3.RazonSocial, T1.CnPer, T4.RazonSocial, T1.Alcance, T1.Usr, T1.Pgm, T1.FAud, T1.HAud, T1.CntMod
FROM UsrTbl T1 LEFT OUTER JOIN Persona T4 ON T1.CnPer = T4.CnPer LEFT OUTER JOIN Persona T3 ON T1.CnCiaR = T3.CnPer
LEFTOUTER JOIN Compania T2 ON T1.CnCiaR = T2.CnCiaR WHERE ( T1.CdUsr = 'Nuno Goncalves' ) ORDER BY T1.CdUsr '<br />
ERRORfrom backend during send_query: 'ERROR: current transaction is aborted, commands ignored until end of transaction
block'<br/> conn=20986272, query='ROLLBACK'<br /> STATEMENT ERROR: func=SC_execute, desc='', errnum=7, errmsg='Error
whileexecuting the query'<br /> &nbs p;
------------------------------------------------------------<br/> &nbs p; hdbc=20986272,
stmt=21005640,result=21005480<br /> &nbs p; manual_result=0, prepare=1, internal=0<br />
bindings=21013120, bindings_allocated=12<br /> &nbs p;
parameters=21011000,parameters_allocated=1<br /> &nbs p; statement_type=0, statement='SELECT
T1.CdUsr,T1.CnCiaR, T2.CdCia, T3.RazonSocial, T1.CnPer, T4.RazonSocial, T1.Alcance, T1.Usr, T1.Pgm, T1.FAud, T1.HAud,
T1.CntModFROM {oj UsrTbl T1 LEFT OUTER JOIN Persona T4 ON T1.CnPer = T4.CnPer LEFT OUTER JOIN Persona T3 ON
T1.CnCiaR= T3.CnPer LEFT OUTER JOIN Compania T2 ON T1.CnCiaR = T2.CnCiaR } WHERE ( T1.CdUsr = ? ) ORDER BY T1.CdUsr
'<br/> &nbs p; stmt_with_params='declare SQL_CUR01408548 cursor for SELECT T1.CdUsr, T1.CnCiaR,
T2.CdCia,T3.RazonSocial, T1.CnPer, T4.RazonSocial, T1.Alcance, T1.Usr, T1.Pgm, T1.FAud, T1.HAud, T1.CntMod FROM UsrTbl
T1LEFT OUTER JOIN Persona T4 ON T1.CnPer = T4.CnPer LEFT OUTER JOIN Persona T3 ON T1.CnCiaR = T3.CnPer LEFT OUTER
JOINCompania T2 ON T1.CnCiaR = T2.CnCiaR WHERE ( T1.CdUsr = 'Nuno Goncalves' ) ORDER BY T1.CdUsr '<br />
data_at_exec=-1, current_exec_param=-1, put_data=0<br /> &nbs p;
currTuple=-1,current_col=-1, lobj_fd=-1<br /> &nbs p; maxRows=0, rowset_size=1, keyset_size=0,
cursor_type=0,scroll_concurrency=1<br /> &nbs p; cursor_name='SQL_CUR01408548'<br />
----------------QResult Info -------------------------------<br /> &nbs p;
fields=24304304,manual_tuples=0, backend_tuples=0, tupleField=0, conn=0<br /> &nbs p; fetch_count=0,
num_total_rows=0,num_fields=0, cursor='(NULL)'<br /> &nbs p; message='ERROR: current transaction is
aborted,commands ignored until end of transaction block', command='(NULL)', notice='(NULL)'<br /> &nbs
p; status=7, inTuples=0<br /> CONN ERROR: func=SC_execute, desc='', errnum=110, errmsg='ERROR: VACUUM cannot run
insidea transaction block'<br /> ------------------------------------------------------------<br />
henv=20981536, conn=20986272, status=1, num_stmts=16<br /> sock=20981592, stmts=20981664,
lobj_type=-999<br/> ---------------- Socket Info -------------------------------<br />
socket=560,reverse=0, errornumber=0, errormsg='(NULL)'<br /> buffer_in=20997272, buffer_out=21001376<br />
buffer_filled_in=11, buffer_filled_out=0, buffer_read_in=11<br /> conn=20986272, query='declare
SQL_CUR016F3470cursor for SELECT T1.CnCiaR, T1.CnCarga, T1.CnData, T1.CdPddPrv, T1.AnoFiscal, T1.CdPedido, T1.RngPdd,
T1.ProdPres,T1.CdPrdT, T1.CdPrsT, T1.CnProd, T1.CnPres, T1.CdLinea, T1.TpET, T1.Escala, T1.BltsCnfT, T1.PrecTxt,
T1.FCarga,T1.StsPddA FROM PddAsm T1 WHERE ( T1.CnCiaR = '1' ) AND ( T1.CnCarga = '4' ) ORDER BY T1.CnCiaR, T1.CnCarga,
T1.CnData'<br /> conn=20986272, query='fetch 64 in SQL_CUR016F3470'<br /> [ fetched 0 rows ]<br /> conn=20986272,
query='closeSQL_CUR016F3470'<br /> conn=20986272, query='declare SQL_CUR01732D38 cursor for SELECT T1.CnCiaR, T2.CdCia,
T3.RazonSocial,T1.CnCarga, T1.TpCarga, T1.FileX, T1.RegTot, T1.RegOK, T1.FCarga, T1.HCarga, T1.StCarga, T1.Usr, T1.Pgm,
T1.FAud,T1.HAud, T1.CntMod FROM Carga T1 LEFT OUTER JOIN Persona T3 ON T1.CnCiaR = T3.CnPer LEFT OUTER JOIN Compania
T2ON T1.CnCiaR = T2.CnCiaR WHERE ( T1.CnCiaR = '1' ) AND ( T1.TpCarga = '5' ) ORDER BY T1.CnCiaR, T1.TpCarga,
T1.CnCarga DESC, T1.StCarga DESC '<br /> conn=20986272, query='fetch 64 in SQL_CUR01732D38'<br /> [ fetched 1 rows
]<br/> conn=20986272, query='close SQL_CUR01732D38'<br /> conn=20986272, query='declare SQL_CUR016F3470 cursor for
SELECTT1.CnCiaR, T1.CnCarga, T1.CnData, T1.CdPddPrv, T1.AnoFiscal, T1.CdPedido, T1.RngPdd, T1.ProdPres, T1.CdPrdT,
T1.CdPrsT,T1.CnProd, T1.CnPres, T1.CdLinea, T1.TpET, T1.Escala, T1.BltsCnfT, T1.PrecTxt, T1.FCarga, T1.StsPddA FROM
PddAsmT1 WHERE ( T1.CnCiaR = '1' ) AND ( T1.CnCarga = '4' ) ORDER BY T1.CnCiaR, T1.CnCarga, T1.CnData '<br />
conn=20986272,query='fetch 64 in SQL_CUR016F3470'<br /> [ fetched 0 rows ]<br /> conn=20986272, query='close
SQL_CUR016F3470'<br/> conn=20986272, query='declare SQL_CUR01732D38 cursor for SELECT T1.CnCiaR, T2.CdCia,
T3.RazonSocial,T1.CnCarga, T1.TpCarga, T1.FileX, T1.RegTot, T1.RegOK, T1.FCarga, T1.HCarga, T1.StCarga, T1.Usr, T1.Pgm,
T1.FAud,T1.HAud, T1.CntMod FROM Carga T1 LEFT OUTER JOIN Persona T3 ON T1.CnCiaR = T3.CnPer LEFT OUTER JOIN Compania
T2ON T1.CnCiaR = T2.CnCiaR WHERE ( T1.CnCiaR = '1' ) AND ( T1.TpCarga = '5' ) ORDER BY T1.CnCiaR, T1.TpCarga,
T1.CnCarga DESC, T1.StCarga DESC '<br /> conn=20986272, query='fetch 64 in SQL_CUR01732D38'<br /> [ fetched 1 rows
]<br/> conn=20986272, query='close SQL_CUR01732D38'<br /> conn=20986272, query='declare SQL_CUR01732D38 cursor for
SELECTT1.CnCiaR, T2.CdCia, T3.RazonSocial, T1.CnCarga, T1.TpCarga, T1.FileX, T1.RegTot, T1.RegOK, T1.FCarga, T1.HCarga,
T1.StCarga,T1.Usr, T1.Pgm, T1.FAud, T1.HAud, T1.CntMod FROM Carga T1 LEFT OUTER JOIN Persona T3 ON T1.CnCiaR =
T3.CnPerLEFT OUTER JOIN Compania T2 ON T1.CnCiaR = T2.CnCiaR WHERE ( T1.CnCiaR = '1' ) AND ( T1.TpCarga = '5' ) ORDER
BYT1.CnCiaR, T1.TpCarga, T1.CnCarga DESC, T1.StCarga DESC '<br /> conn=20986272, query='fetch 64 in
SQL_CUR01732D38'<br/> [ fetched 1 rows ]<br /> conn=20986272, query='close SQL_CUR01732D38'<br /> conn=20986272,
query='closeSQL_CUR0140CC48'<br /> ERROR from backend during send_query: 'ERROR: cursor "sql_cur0140cc48" does not
exist'<br/> conn=20986272, query='close SQL_CUR0140FA70'<br /> ERROR from backend during send_query: 'ERROR: current
transactionis aborted, commands ignored until end of transaction block'<br /> conn=20986272, query='close
SQL_CUR0140F550'<br/> ERROR from backend during send_query: 'ERROR: current transaction is aborted, commands ignored
untilend of transaction block'<br /> conn=20986272, query='close SQL_CUR016F44B0'<br /> ERROR from backend during
send_query:'ERROR: current transaction is aborted, commands ignored until end of transaction block'<br />
conn=20986272,query='close SQL_CUR016F6118'<br /> ERROR from backend during send_query: 'ERROR: current transaction is
aborted,commands ignored until end of transaction block'<br /> conn=20986272, query='close SQL_CUR0170DB30'<br /> ERROR
frombackend during send_query: 'ERROR: current transaction is aborted, commands ignored until end of transaction
block'<br/> conn=20986272, query='close SQL_CUR01722058'<br /> ERROR from backend during send_query: 'ERROR: current
transactionis aborted, commands ignored until end of transaction block'<br /> conn=20986272, query='close
SQL_CUR01728CE8'<br/> ERROR from backend during send_query: 'ERROR: current transaction is aborted, commands ignored
untilend of transaction block'<br /> conn=20986272, query='close SQL_CUR01728F90'<br /> ERROR from backend during
send_query:'ERROR: current transaction is aborted, commands ignored until end of transaction block'<br />
conn=20986272,query='close SQL_CUR01732238'<br /> ERROR from backend during send_query: 'ERROR: current transaction is
aborted,commands ignored until end of transaction block'<br /> conn=20986272, PGAPI_Disconnect<br /><br />