ERROR from backend during send_query: 'ERROR: cursor "sql_cur0140cc48" does not exist' - Mailing list pgsql-general

From ngoncalves81@cantv.net
Subject ERROR from backend during send_query: 'ERROR: cursor "sql_cur0140cc48" does not exist'
Date
Msg-id 410-22005951604351988@cantv.net
Whole thread Raw
List pgsql-general
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           &nbsp;        '<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 />
            &nbsp;    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 />
            &nbsp;    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 />
            &nbsp;    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 />
            &nbsp;    maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0, scroll_concurrency=1<br />
            &nbsp;    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 />
            &nbsp;    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 />
            &nbsp;    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 />
            &nbsp;    ----------------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 /> 

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Deadlock
Next
From: Greg Stark
Date:
Subject: Re: Asychronous database replication