raise notice causes driver to crash

raise notice causes driver to crash

am 28.09.2010 20:32:23 von Alex Balan

This is a multi-part message in MIME format.
--------------090603050700050008070908
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

raise notice - displaying string having length over 4096 characters
causes crash in ODBC ANSI driver but seems to be ok on 7.4.3 driver.

Driver: psqlODBC ANSI ver. 8.4.2
Database: PostgreSQL 8.1.5 on i686-redhat-linux-gnu
Error: Faulting application vb6.exe, version 6.0.97.82,
faulting module psqlodbc30a.dll, version 8.4.2.0, fault
address 0x00045431.

Notes: Version 7.4.3 of psqlodbc driver driver does not expose
this issue

Calling procedure from VB

Const strConnect = "DRIVER={PostgreSQL
ANSI};DATABASE=test-medsql-alder;SERVER=192.168.100.77;PORT= 5432;

UID=postgres;PWD=secret;ByteaAsLongVarBinary=1;MaxLongVarcha rSize=-4;"
conn.ConnectionString = strConnect
conn.Open
Set RCS = conn.Execute("SELECT * FROM
select_patient_all_visit_data(77.00,'')")


Called pl/pgsql function


--sqltext is dynamically built here with a LENGTH OVER 4096 characters

--next line if enabled causes crash
--*********************************
--raise notice '%',sqltext;
--*********************************

FOR ret_row IN EXECUTE sqltext LOOP
return next ret_row;
END LOOP;
return;


Hope this helps track down the issue(s) if any...
Alex Balan

--------------090603050700050008070908
Content-Type: text/plain;
name="mylog_3260.log"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
filename="mylog_3260.log"

[2100-0.000]globals.extra_systable_prefixes = 'dd_;'
[2100-0.000]exe name=vb6 plaformId=2
[2100-0.000][[SQLAllocHandle]][2100-0.000]**** in PGAPI_AllocEnv **
[2100-0.016]** exit PGAPI_AllocEnv: phenv = 039120B0 **
[2100-0.016][[SQLSetEnvAttr]] att=200,2
[2100-0.016][[SQLAllocHandle]][2100-0.016]PGAPI_AllocConnect : entering...
[2100-0.016]**** PGAPI_AllocConnect: henv = 039120B0, conn = 03913FE0
[2100-0.016]EN_add_connection: self = 039120B0, conn = 03913FE0
[2100-0.016] added at 0, conn->henv = 039120B0, conns[0]->henv = 039120B0
[2100-0.032][SQLGetInfo(30)][2100-0.032]PGAPI_GetInfo: entering...fInfoType=77
[2100-0.032]PGAPI_GetInfo: p='03.50', len=0, value=0, cbMax=12
[2100-0.032][[SQLSetConnectAttr]] 103
[2100-0.032]PGAPI_SetConnectAttr for 03913FE0: 103 0000000F
[2100-0.032]PGAPI_SetConnectOption: entering fOption = 103 vParam = 15
[2100-0.047][SQLDriverConnect][2100-0.047]PGAPI_DriverConnec t: entering...
[2100-0.047]**** PGAPI_DriverConnect: fDriverCompletion=0, connStrIn='DRIVER={PostgreSQL ANSI};UID=postgres;PWD=xxxxxxxx;DATABASE=test-medsql-alder;S ERVER=192.168.100.77;PORT=5432;ByteaAsLongVarBinary=1;MaxLon gVarcharSize=-4;'
[2100-0.047]our_connect_string = 'DRIVER={PostgreSQL ANSI};UID=postgres;PWD=xxxxxxxx;DATABASE=test-medsql-alder;S ERVER=192.168.100.77;PORT=5432;ByteaAsLongVarBinary=1;MaxLon gVarcharSize=-4;'
[2100-0.063]attribute = 'DRIVER', value = '{PostgreSQL ANSI}'
[2100-0.063]copyAttributes: DSN='',server='',dbase='',user='',passwd='xxxxx',port='',onl yread='',protocol='',conn_settings='',disallow_premature=-1)
[2100-0.063]attribute = 'UID', value = 'postgres'
[2100-0.079]copyAttributes: DSN='',server='',dbase='',user='postgres',passwd='xxxxx',por t='',onlyread='',protocol='',conn_settings='',disallow_prema ture=-1)
[2100-0.079]attribute = 'PWD', value = 'xxxxx'
[2100-0.079]copyAttributes: DSN='',server='',dbase='',user='postgres',passwd='xxxxx',por t='',onlyread='',protocol='',conn_settings='',disallow_prema ture=-1)
[2100-0.079]attribute = 'DATABASE', value = 'test-medsql-alder'
[2100-0.079]copyAttributes: DSN='',server='',dbase='test-medsql-alder',user='postgres',p asswd='xxxxx',port='',onlyread='',protocol='',conn_settings= '',disallow_premature=-1)
[2100-0.094]attribute = 'SERVER', value = '192.168.100.77'
[2100-0.094]copyAttributes: DSN='',server='192.168.100.77',dbase='test-medsql-alder',use r='postgres',passwd='xxxxx',port='',onlyread='',protocol='', conn_settings='',disallow_premature=-1)
[2100-0.094]attribute = 'PORT', value = '5432'
[2100-0.094]copyAttributes: DSN='',server='192.168.100.77',dbase='test-medsql-alder',use r='postgres',passwd='xxxxx',port='5432',onlyread='',protocol ='',conn_settings='',disallow_premature=-1)
[2100-0.110]attribute = 'ByteaAsLongVarBinary', value = '1'
[2100-0.110]copyAttributes: DSN='',server='192.168.100.77',dbase='test-medsql-alder',use r='postgres',passwd='xxxxx',port='5432',onlyread='',protocol ='',conn_settings='',disallow_premature=-1)
[2100-0.110]attribute = 'MaxLongVarcharSize', value = '-4'
[2100-0.110]copyAttributes: DSN='',server='192.168.100.77',dbase='test-medsql-alder',use r='postgres',passwd='xxxxx',port='5432',onlyread='',protocol ='',conn_settings='',disallow_premature=-1)
[2100-0.110]getDSNinfo: DSN= overwrite=0
[2100-0.125]our_connect_string = 'DRIVER={PostgreSQL ANSI};UID=postgres;PWD=xxxxxxxx;DATABASE=test-medsql-alder;S ERVER=192.168.100.77;PORT=5432;ByteaAsLongVarBinary=1;MaxLon gVarcharSize=-4;'
[2100-0.125]attribute = 'DRIVER', value = '{PostgreSQL ANSI}'
[2100-0.125]copyCommonAttributes: A7=100;A8=4096;A9=0;B0=255;B1=8190;B2=1;B3=0;B4=0;B5=1;B6=0; B7=1;B8=0;B9=1;C0=0;C1=0;C2=dd_;[2100-0.125]attribute = 'UID', value = 'postgres'
[2100-0.125]copyCommonAttributes: A7=100;A8=4096;A9=0;B0=255;B1=8190;B2=1;B3=0;B4=0;B5=1;B6=0; B7=1;B8=0;B9=1;C0=0;C1=0;C2=dd_;[2100-0.141]attribute = 'PWD', value = 'xxxxx'
[2100-0.141]copyCommonAttributes: A7=100;A8=4096;A9=0;B0=255;B1=8190;B2=1;B3=0;B4=0;B5=1;B6=0; B7=1;B8=0;B9=1;C0=0;C1=0;C2=dd_;[2100-0.141]attribute = 'DATABASE', value = 'test-medsql-alder'
[2100-0.141]copyCommonAttributes: A7=100;A8=4096;A9=0;B0=255;B1=8190;B2=1;B3=0;B4=0;B5=1;B6=0; B7=1;B8=0;B9=1;C0=0;C1=0;C2=dd_;[2100-0.141]attribute = 'SERVER', value = '192.168.100.77'
[2100-0.141]copyCommonAttributes: A7=100;A8=4096;A9=0;B0=255;B1=8190;B2=1;B3=0;B4=0;B5=1;B6=0; B7=1;B8=0;B9=1;C0=0;C1=0;C2=dd_;[2100-0.157]attribute = 'PORT', value = '5432'
[2100-0.157]copyCommonAttributes: A7=100;A8=4096;A9=0;B0=255;B1=8190;B2=1;B3=0;B4=0;B5=1;B6=0; B7=1;B8=0;B9=1;C0=0;C1=0;C2=dd_;[2100-0.157]attribute = 'ByteaAsLongVarBinary', value = '1'
[2100-0.157]copyCommonAttributes: A7=100;A8=4096;A9=0;B0=255;B1=8190;B2=1;B3=0;B4=0;B5=1;B6=0; B7=1;B8=0;B9=1;C0=0;C1=0;C2=dd_;[2100-0.157]attribute = 'MaxLongVarcharSize', value = '-4'
[2100-0.157]copyCommonAttributes: A7=100;A8=4096;A9=0;B0=255;B1=-4;B2=1;B3=0;B4=0;B5=1;B6=0;B7 =1;B8=0;B9=1;C0=0;C1=0;C2=dd_;[2100-0.172]calling getDSNdefaults
[2100-0.172]CC_connect: entering...
[2100-0.172]sslmode=disable
[2100-0.172]original_CC_connect: entering...
[2100-0.172]Driver Version='08.04.0200,200912260001' linking 1500 static Multithread library
[2100-0.172]original_CC_connect: DSN = '', server = '192.168.100.77', port = '5432', database = 'test-medsql-alder', username = 'postgres', password='xxxxx'
[2100-0.172]connecting to the server socket...
[2100-0.204](0)(null) ERRNO=0
[2100-0.204]connection to the server socket succeeded.
[2100-0.204]sizeof startup packet = 89
[2100-0.204]sent the authentication block successfully.
[2100-0.204]gonna do authentication
[2100-0.204]read 13, global_socket_buffersize=4096
[2100-0.204]auth got 'R'
[2100-0.204]areq = 5 salt=4377c37100
[2100-0.204]in AUTH_REQ_MD5
[2100-0.204]read -1, global_socket_buffersize=4096
[2100-0.219]Lasterror=10035
[2100-0.219]read 290, global_socket_buffersize=4096
[2100-0.219]auth got 'R'
[2100-0.219]areq = 0 salt=0000000000
[2100-0.219]auth got 'S'
[2100-0.219]auth got 'S'
[2100-0.219]auth got 'S'
[2100-0.219]auth got 'S'
[2100-0.219]auth got 'S'
[2100-0.219]auth got 'S'
[2100-0.219]Got the PostgreSQL version string: '8.1.5'
[2100-0.219]Extracted PostgreSQL version number: '8.1'
[2100-0.219]auth got 'S'
[2100-0.219]auth got 'S'
[2100-0.235]standard_conforming_strings=off
[2100-0.235]auth got 'S'
[2100-0.235]auth got 'K'
[2100-0.235]auth got 'Z'
[2100-0.235]CC_send_settings: entering...
[2100-0.235]PGAPI_AllocStmt: entering...
[2100-0.235]**** PGAPI_AllocStmt: hdbc = 03913FE0, stmt = 03918FA8
[2100-0.235]CC_add_statement: self=03913FE0, stmt=03918FA8
[2100-0.235]PGAPI_FreeStmt: entering...hstmt=03918FA8, fOption=1
[2100-0.235]QResult: enter DESTRUCTOR
[2100-0.235]SC_init_Result(3918fa8)[2100-0.235]SC_Destructor : self=03918FA8, self->result=00000000, self->hdbc=03913FE0
[2100-0.250]APD_free_params: ENTER, self=039190A8
[2100-0.250]IPD_free_params: ENTER, self=039190E8
[2100-0.250]PDATA_free_params: ENTER, self=0391914C
[2100-0.250]SC_Destructor: EXIT
[2100-0.250]CC_lookup_lo: entering...
[2100-0.250]CC_send_query: conn=03913FE0, query='select oid, typbasetype from pg_type where typname = 'lo''
[2100-0.250]send_query: done sending query 63bytes flushed
[2100-0.250]in QR_Constructor
[2100-0.250]exit QR_Constructor
[2100-0.250]read -1, global_socket_buffersize=4096
[2100-0.250]Lasterror=10035
[2100-0.266]read 77, global_socket_buffersize=4096
[2100-0.266]send_query: got id = 'T'
[2100-0.266]QR_fetch_tuples: cursor = '', self->cursor=00000000
[2100-0.266]num_fields = 2
[2100-0.266]READING ATTTYPMOD
[2100-0.266]CI_read_fields: fieldname='oid', adtid=26, adtsize=4, atttypmod=-1 (rel,att)=(1247,65534)
[2100-0.266]READING ATTTYPMOD
[2100-0.266]CI_read_fields: fieldname='typbasetype', adtid=26, adtsize=4, atttypmod=-1 (rel,att)=(1247,19)
[2100-0.282]QR_fetch_tuples: past CI_read_fields: num_fields = 2
[2100-0.282]MALLOC: tuple_size = 100, size = 1600
[2100-0.282]QR_next_tuple: inTuples = true, falling through: fcount = 0, fetch_number = 0
[2100-0.282]end of tuple list -- setting inUse to false: this = 039191D8 SELECT
[2100-0.282]_QR_next_tuple: 'C' fetch_total = 0 & this_fetch = 0
[2100-0.282]QR_next_tuple: backend_rows < CACHE_SIZE: brows = 0, cache_size = 0
[2100-0.282]QR_next_tuple: reached eof now
[2100-0.282]_QR_next_tuple: 'C': DONE (fcount == 0)
[2100-0.282]send_query: got id = 'Z'
[2100-0.297]QResult: enter DESTRUCTOR
[2100-0.297]QResult: in QR_close_result
[2100-0.297]QResult: free memory in, fcount=0
[2100-0.297]QResult: free memory out
[2100-0.297]QResult: enter DESTRUCTOR
[2100-0.297]QResult: exit close_result
[2100-0.297]QResult: exit DESTRUCTOR
[2100-0.297]Got the large object oid: -999
[2100-0.297]CC_lookup_characterset: entering...
[2100-0.297]conn->unicode=0
[2100-0.297]CC_connect: returning...1
[2100-0.297]szConnStrOut = 'DRIVER={PostgreSQL ANSI};DATABASE=test-medsql-alder;SERVER=192.168.100.77;PORT= 5432;UID=postgres;PWD=xxxxxxxx;SSLmode=disable;ReadOnly=0;Pr otocol=7.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;Sh owSystemTables=0;ConnSettings=;Fetch=100;Socket=4096;Unknown Sizes=0;MaxVarcharSize=255;MaxLongVarcharSize=-4;Debug=1;Com mLog=0;Optimizer=0;Ksqo=1;UseDeclareFetch=0;TextAsLongVarcha r=1;UnknownsAsLongVarchar=0;BoolsAsChar=1;Parse=0;CancelAsFr eeStmt=0;ExtraSysTablePrefixes=dd_;;LFConversion=1;Updatable Cursors=1;DisallowPremature=0;TrueIsMinus1=0;BI=0;ByteaAsLon gVarBinary=1;UseServerSidePrepare=0;LowerCaseIdentifier=0;Xa Opt=1' len=624,1024
[2100-0.329]PGAPI_DriverConnect: returning 0
[2100-0.329][[SQLGetDiagRec]]
[2100-0.329]PGAPI_GetDiagRec entering type=2 rec=1
[2100-0.329]**** PGAPI_ConnectError: hdbc=03913FE0 <0>
[2100-0.329]enter CC_get_error
[2100-0.329]enter CC_create_errormsg
[2100-0.329]msg = ''
[2100-0.329]exit CC_create_errormsg
[2100-0.329]exit CC_get_error
[2100-0.329]CC_Get_error returned nothing.
[2100-0.329]PGAPI_GetDiagRec exiting 100
[2100-0.329][SQLGetFunctions][2100-0.329][SQLGetInfo(30)][21 00-0.329]PGAPI_GetInfo: entering...fInfoType=23
[2100-0.344]PGAPI_GetInfo: p='', len=2, value=2, cbMax=2
[2100-0.344][SQLGetInfo(30)][2100-0.344]PGAPI_GetInfo: entering...fInfoType=24
[2100-0.344]PGAPI_GetInfo: p='', len=2, value=2, cbMax=2
[2100-0.344][SQLGetInfo(30)][2100-0.344]PGAPI_GetInfo: entering...fInfoType=79
[2100-0.344]PGAPI_GetInfo: p='', len=4, value=31, cbMax=4
[2100-0.344][SQLGetInfo(30)][2100-0.344]PGAPI_GetInfo: entering...fInfoType=83
[2100-0.344]PGAPI_GetInfo: p='', len=4, value=7, cbMax=4
[2100-0.344][SQLGetInfo(30)][2100-0.344]PGAPI_GetInfo: entering...fInfoType=78
[2100-0.360]PGAPI_GetInfo: p='', len=4, value=1, cbMax=4
[2100-0.360][SQLGetInfo(30)][2100-0.360]PGAPI_GetInfo: entering...fInfoType=81
[2100-0.360]PGAPI_GetInfo: p='', len=4, value=15, cbMax=4
[2100-0.360][SQLGetInfo(30)][2100-0.360]PGAPI_GetInfo: entering...fInfoType=72
[2100-0.360]PGAPI_GetInfo: p='', len=4, value=10, cbMax=4
[2100-0.360][SQLGetInfo(30)][2100-0.360]PGAPI_GetInfo: entering...fInfoType=82
[2100-0.360]PGAPI_GetInfo: p='', len=4, value=90, cbMax=4
[2100-0.360][SQLGetInfo(30)][2100-0.375]PGAPI_GetInfo: entering...fInfoType=44
[2100-0.375]PGAPI_GetInfo: p='', len=4, value=19, cbMax=4
[2100-0.375][SQLGetInfo(30)][2100-0.375]PGAPI_GetInfo: entering...fInfoType=43
[2100-0.375]PGAPI_GetInfo: p='', len=4, value=5, cbMax=4
[2100-0.375][SQLGetInfo(30)][2100-0.375]PGAPI_GetInfo: entering...fInfoType=144
[2100-0.375]CC_error_statements: self=03913FE0
[2100-0.375]PGAPI_GetInfo30: p='', len=4, value=0, cbMax=4
[2100-0.375][SQLGetInfo(30)][2100-0.375]PGAPI_GetInfo: entering...fInfoType=150
[2100-0.375]CC_error_statements: self=03913FE0
[2100-0.391]PGAPI_GetInfo30: p='', len=4, value=990799, cbMax=4
[2100-0.391][SQLGetInfo(30)][2100-0.391]PGAPI_GetInfo: entering...fInfoType=167
[2100-0.391]CC_error_statements: self=03913FE0
[2100-0.391]PGAPI_GetInfo30: p='', len=4, value=990799, cbMax=4
[2100-0.391][SQLGetInfo(30)][2100-0.391]PGAPI_GetInfo: entering...fInfoType=146
[2100-0.391]CC_error_statements: self=03913FE0
[2100-0.391]PGAPI_GetInfo30: p='', len=4, value=1, cbMax=4
[2100-0.391][SQLGetInfo(30)][2100-0.391]PGAPI_GetInfo: entering...fInfoType=151
[2100-0.407]CC_error_statements: self=03913FE0
[2100-0.407]PGAPI_GetInfo30: p='', len=4, value=4213, cbMax=4
[2100-0.407][SQLGetInfo(30)][2100-0.407]PGAPI_GetInfo: entering...fInfoType=168
[2100-0.407]CC_error_statements: self=03913FE0
[2100-0.407]PGAPI_GetInfo30: p='', len=4, value=4213, cbMax=4
[2100-0.407][SQLGetInfo(30)][2100-0.407]PGAPI_GetInfo: entering...fInfoType=111
[2100-0.407]PGAPI_GetInfo: p='N', len=0, value=0, cbMax=512
[2100-0.407][SQLGetInfo(30)][2100-0.407]PGAPI_GetInfo: entering...fInfoType=16
[2100-0.422]PGAPI_GetInfo: p='test-medsql-alder', len=0, value=0, cbMax=0
[2100-0.422][SQLGetInfo(30)][2100-0.422]PGAPI_GetInfo: entering...fInfoType=23
[2100-0.422]PGAPI_GetInfo: p='', len=2, value=2, cbMax=4
[2100-0.422][SQLGetInfo(30)][2100-0.422]PGAPI_GetInfo: entering...fInfoType=24
[2100-0.422]PGAPI_GetInfo: p='', len=2, value=2, cbMax=4
[2100-0.422][SQLGetInfo(30)][2100-0.422]PGAPI_GetInfo: entering...fInfoType=46
[2100-0.422]PGAPI_GetInfo: p='', len=2, value=2, cbMax=4
[2100-0.422][[SQLSetConnectAttr]] 1
[2100-0.438]PGAPI_SetConnectAttr for 03913FE0: 1 00000000
[2100-0.438]PGAPI_SetConnectOption: entering fOption = 1 vParam = 0
[2100-0.438]SetStmtOption(): SQL_MAX_ROWS, vParam = 0
[2100-0.438][[SQLSetConnectAttr]] 0
[2100-0.438]PGAPI_SetConnectAttr for 03913FE0: 0 00000000
[2100-0.438]PGAPI_SetConnectOption: entering fOption = 0 vParam = 0
[2100-0.438]SetStmtOption: SQL_QUERY_TIMEOUT, vParam = 0
[2100-0.438][SQLGetInfo(30)][2100-0.438]PGAPI_GetInfo: entering...fInfoType=6
[2100-0.438]PGAPI_GetInfo: p='PSQLODBC.DLL', len=0, value=0, cbMax=52
[2100-0.454][SQLGetInfo(30)][2100-0.454]PGAPI_GetInfo: entering...fInfoType=6
[2100-0.454]PGAPI_GetInfo: p='PSQLODBC.DLL', len=0, value=0, cbMax=52
[2100-0.454][SQLGetInfo(30)][2100-0.454]PGAPI_GetInfo: entering...fInfoType=6
[2100-0.454]PGAPI_GetInfo: p='PSQLODBC.DLL', len=0, value=0, cbMax=52
[2100-0.454][SQLGetInfo(30)][2100-0.454]PGAPI_GetInfo: entering...fInfoType=6
[2100-0.454]PGAPI_GetInfo: p='PSQLODBC.DLL', len=0, value=0, cbMax=48
[2100-0.454][SQLGetInfo(30)][2100-0.454]PGAPI_GetInfo: entering...fInfoType=1
[2100-0.454]PGAPI_GetInfo: p='', len=2, value=0, cbMax=4
[2100-0.469][[SQLGetConnectAttr]] 109
[2100-0.469]PGAPI_GetConnectAttr 109
[2100-0.469]PGAPI_GetConnectOption: entering...
[2100-0.469][SQLGetInfo(30)][2100-0.469]PGAPI_GetInfo: entering...fInfoType=26
[2100-0.469]PGAPI_GetInfo: p='', len=4, value=2, cbMax=4
[2100-0.469][[SQLAllocHandle]][2100-0.469]PGAPI_AllocStmt: entering...
[2100-0.469]**** PGAPI_AllocStmt: hdbc = 03913FE0, stmt = 03918FA8
[2100-0.469]CC_add_statement: self=03913FE0, stmt=03918FA8
[2100-0.469][[SQLGetStmtAttr]] Handle=59871144 10010
[2100-0.485]PGAPI_GetStmtAttr Handle=03918FA8 10010
[2100-0.485][[SQLGetStmtAttr]] Handle=59871144 10011
[2100-0.485]PGAPI_GetStmtAttr Handle=03918FA8 10011
[2100-0.485][[SQLGetStmtAttr]] Handle=59871144 10012
[2100-0.485]PGAPI_GetStmtAttr Handle=03918FA8 10012
[2100-0.485][[SQLGetStmtAttr]] Handle=59871144 10013
[2100-0.485]PGAPI_GetStmtAttr Handle=03918FA8 10013
[2100-0.500][[SQLSetStmtAttr]] Handle=03918FA8 18,10
[2100-0.500]PGAPI_SetStmtAttr Handle=03918FA8 18,10(0000000A)
[2100-0.500][[SQLSetStmtAttr]] Handle=03918FA8 18,0
[2100-0.500]PGAPI_SetStmtAttr Handle=03918FA8 18,0(00000000)
[2100-0.500][[SQLSetStmtAttr]] Handle=03918FA8 17,1306612
[2100-0.500]PGAPI_SetStmtAttr Handle=03918FA8 17,1306612(0013EFF4)
[2100-0.516][[SQLSetStmtAttr]] Handle=03918FA8 17,0
[2100-0.516]PGAPI_SetStmtAttr Handle=03918FA8 17,0(00000000)
[2100-0.516][[SQLSetDescField]] h=03919088 rec=1 field=1004 val=0013EFF4
[2100-0.516]PGAPI_SetDescField h=03919088(10011) rec=1 field=1004 val=0013EFF4,0
[2100-0.516]extend_parameter_bindings: entering ... self=039190A8, parameters_allocated=0, num_params=1,00000000
[2100-0.532]exit extend_parameter_bindings=039195B8
[2100-0.532][[SQLSetDescField]] h=03919088 rec=1 field=1004 val=00000000
[2100-0.532]PGAPI_SetDescField h=03919088(10011) rec=1 field=1004 val=00000000,0
[2100-0.532][SQLGetInfo(30)][2100-0.532]PGAPI_GetInfo: entering...fInfoType=36
[2100-0.547]PGAPI_GetInfo: p='Y', len=0, value=0, cbMax=4
[2100-0.547][[SQLGetStmtAttr]] Handle=59871144 6
[2100-0.547]PGAPI_GetStmtAttr Handle=03918FA8 6
[2100-0.547]PGAPI_GetStmtOption: entering...
[2100-0.547]GetStmtOption(): SQL_CURSOR_TYPE 0
[2100-0.547][[SQLGetStmtAttr]] Handle=59871144 7
[2100-0.547]PGAPI_GetStmtAttr Handle=03918FA8 7
[2100-0.563]PGAPI_GetStmtOption: entering...
[2100-0.563]GetStmtOption(): SQL_CONCURRENCY 1
[2100-0.563][[SQLGetConnectAttr]] 108
[2100-0.563]PGAPI_GetConnectAttr 108
[2100-0.563]PGAPI_GetConnectOption: entering...
[2100-0.563][[SQLSetStmtAttr]] Handle=03918FA8 0,30
[2100-0.563]PGAPI_SetStmtAttr Handle=03918FA8 0,30(0000001E)
[2100-0.563]PGAPI_SetStmtOption: entering...
[2100-0.579]SetStmtOption: SQL_QUERY_TIMEOUT, vParam = 30
[2100-0.579][[SQLSetStmtAttr]] Handle=03918FA8 22,1
[2100-0.579]PGAPI_SetStmtAttr Handle=03918FA8 22,1(00000001)
[2100-0.579][[SQLSetStmtAttr]] Handle=03918FA8 21,0
[2100-0.579]PGAPI_SetStmtAttr Handle=03918FA8 21,0(00000000)
[2100-0.579][SQLExecDirect][2100-0.579]PGAPI_ExecDirect: entering...1
[2100-0.594]SC_recycle_statement: self= 03918FA8
[2100-0.594]**** PGAPI_ExecDirect: hstmt=03918FA8, statement='SELECT * FROM select_patient_all_visit_data(77.00,'') '
[2100-0.594]PGAPI_ExecDirect: calling PGAPI_Execute...
[2100-0.594]PGAPI_Execute: entering...1
[2100-0.594]PGAPI_Execute: clear errors...
[2100-0.594]PGAPI_NumParams: entering...
[2100-0.594]SC_scanQueryAndCountParams: entering...
[2100-0.610]prepareParameters was not called, prepare state:2
[2100-0.610]SC_recycle_statement: self= 03918FA8
[2100-0.610]Exec_with_parameters_resolved: copying statement params: trans_status=1, len=54, stmt='SELECT * FROM select_patient_all_visit_data(77.00,'') '
[2100-0.610] stmt_with_params = 'SELECT * FROM select_patient_all_visit_data(77.00,'') '
[2100-0.625]about to begin SC_execute
[2100-0.625] Sending SELECT statement on stmt=03918FA8, cursor_name='SQL_CUR03918FA8' qflag=0,1
[2100-0.625]CC_send_query: conn=03913FE0, query='SELECT * FROM select_patient_all_visit_data(77.00,'') '
[2100-0.625]send_query: done sending query 60bytes flushed
[2100-0.641]in QR_Constructor
[2100-0.641]exit QR_Constructor
[2100-0.641]read -1, global_socket_buffersize=4096
[2100-0.641]Lasterror=10035
[2100-0.641]read 1202, global_socket_buffersize=4096
[2100-0.641]send_query: got id = 'T'
[2100-0.641]QR_fetch_tuples: cursor = '', self->cursor=00000000
[2100-0.657]num_fields = 37
[2100-0.657]READING ATTTYPMOD
[2100-0.657]CI_read_fields: fieldname='vis_pat_id', adtid=1700, adtsize=-1, atttypmod=524290 (rel,att)=(0,0)
[2100-0.657]READING ATTTYPMOD
[2100-0.657]CI_read_fields: fieldname='vis_detail_id', adtid=20, adtsize=8, atttypmod=-1 (rel,att)=(0,0)
[2100-0.657]READING ATTTYPMOD
[2100-0.657]CI_read_fields: fieldname='vis_date', adtid=1082, adtsize=4, atttypmod=-1 (rel,att)=(0,0)
[2100-0.657]READING ATTTYPMOD
[2100-0.657]CI_read_fields: fieldname='vis_soap_code', adtid=1042, adtsize=-1, atttypmod=5 (rel,att)=(0,0)
[2100-0.672]READING ATTTYPMOD
[2100-0.672]CI_read_fields: fieldname='vis_comments', adtid=1042, adtsize=-1, atttypmod=50 (rel,att)=(0,0)
[2100-0.672]READING ATTTYPMOD
[2100-0.672]CI_read_fields: fieldname='vis_scan_type', adtid=1042, adtsize=-1, atttypmod=3 (rel,att)=(0,0)
[2100-0.672]READING ATTTYPMOD
[2100-0.672]CI_read_fields: fieldname='pat_init_name', adtid=1042, adtsize=-1, atttypmod=1 (rel,att)=(0,0)
[2100-0.672]READING ATTTYPMOD
[2100-0.672]CI_read_fields: fieldname='pat_mid_name', adtid=1042, adtsize=-1, atttypmod=20 (rel,att)=(0,0)
[2100-0.688]READING ATTTYPMOD
[2100-0.688]CI_read_fields: fieldname='pat_last_name', adtid=1042, adtsize=-1, atttypmod=20 (rel,att)=(0,0)
[2100-0.688]READING ATTTYPMOD
[2100-0.688]CI_read_fields: fieldname='pat_first_name', adtid=1042, adtsize=-1, atttypmod=20 (rel,att)=(0,0)
[2100-0.688]READING ATTTYPMOD
[2100-0.688]CI_read_fields: fieldname='pat_id', adtid=1700, adtsize=-1, atttypmod=524290 (rel,att)=(0,0)
[2100-0.688]READING ATTTYPMOD
[2100-0.688]CI_read_fields: fieldname='pat_phn_no', adtid=1042, adtsize=-1, atttypmod=12 (rel,att)=(0,0)
[2100-0.704]READING ATTTYPMOD
[2100-0.704]CI_read_fields: fieldname='pat_pin_no', adtid=1700, adtsize=-1, atttypmod=393216 (rel,att)=(0,0)
[2100-0.704]READING ATTTYPMOD
[2100-0.704]CI_read_fields: fieldname='pat_birthdate', adtid=1082, adtsize=4, atttypmod=-1 (rel,att)=(0,0)
[2100-0.704]READING ATTTYPMOD
[2100-0.704]CI_read_fields: fieldname='pat_tel_home', adtid=1042, adtsize=-1, atttypmod=14 (rel,att)=(0,0)
[2100-0.704]READING ATTTYPMOD
[2100-0.719]CI_read_fields: fieldname='pat_tel_buss', adtid=1042, adtsize=-1, atttypmod=14 (rel,att)=(0,0)
[2100-0.719]READING ATTTYPMOD
[2100-0.719]CI_read_fields: fieldname='pat_blood_type', adtid=1042, adtsize=-1, atttypmod=14 (rel,att)=(0,0)
[2100-0.719]READING ATTTYPMOD
[2100-0.719]CI_read_fields: fieldname='pat_address1', adtid=1042, adtsize=-1, atttypmod=30 (rel,att)=(0,0)
[2100-0.719]READING ATTTYPMOD
[2100-0.719]CI_read_fields: fieldname='pat_address2', adtid=1042, adtsize=-1, atttypmod=30 (rel,att)=(0,0)
[2100-0.719]READING ATTTYPMOD
[2100-0.735]CI_read_fields: fieldname='pat_address3', adtid=1042, adtsize=-1, atttypmod=30 (rel,att)=(0,0)
[2100-0.735]READING ATTTYPMOD
[2100-0.735]CI_read_fields: fieldname='pat_city', adtid=1042, adtsize=-1, atttypmod=30 (rel,att)=(0,0)
[2100-0.735]READING ATTTYPMOD
[2100-0.735]CI_read_fields: fieldname='pat_zip', adtid=1042, adtsize=-1, atttypmod=10 (rel,att)=(0,0)
[2100-0.735]READING ATTTYPMOD
[2100-0.735]CI_read_fields: fieldname='pat_sex', adtid=1042, adtsize=-1, atttypmod=1 (rel,att)=(0,0)
[2100-0.735]READING ATTTYPMOD
[2100-0.735]CI_read_fields: fieldname='pro_desc', adtid=1042, adtsize=-1, atttypmod=30 (rel,att)=(0,0)
[2100-0.750]READING ATTTYPMOD
[2100-0.750]CI_read_fields: fieldname='pro_country', adtid=1042, adtsize=-1, atttypmod=30 (rel,att)=(0,0)
[2100-0.750]READING ATTTYPMOD
[2100-0.750]CI_read_fields: fieldname='ldetail_text', adtid=25, adtsize=-1, atttypmod=-1 (rel,att)=(0,0)
[2100-0.750]READING ATTTYPMOD
[2100-0.750]CI_read_fields: fieldname='adetail_text', adtid=25, adtsize=-1, atttypmod=-1 (rel,att)=(0,0)
[2100-0.750]READING ATTTYPMOD
[2100-0.750]CI_read_fields: fieldname='cdetail_text', adtid=25, adtsize=-1, atttypmod=-1 (rel,att)=(0,0)
[2100-0.766]READING ATTTYPMOD
[2100-0.766]CI_read_fields: fieldname='xdetail_text', adtid=25, adtsize=-1, atttypmod=-1 (rel,att)=(0,0)
[2100-0.766]READING ATTTYPMOD
[2100-0.766]CI_read_fields: fieldname='detail_lab_code', adtid=1042, adtsize=-1, atttypmod=30 (rel,att)=(0,0)
[2100-0.766]READING ATTTYPMOD
[2100-0.766]CI_read_fields: fieldname='detail_results', adtid=1042, adtsize=-1, atttypmod=50 (rel,att)=(0,0)
[2100-0.766]READING ATTTYPMOD
[2100-0.766]CI_read_fields: fieldname='detail_comments', adtid=1042, adtsize=-1, atttypmod=66 (rel,att)=(0,0)
[2100-0.782]READING ATTTYPMOD
[2100-0.782]CI_read_fields: fieldname='lab_range_male', adtid=1042, adtsize=-1, atttypmod=15 (rel,att)=(0,0)
[2100-0.782]READING ATTTYPMOD
[2100-0.782]CI_read_fields: fieldname='lab_range_female', adtid=1042, adtsize=-1, atttypmod=15 (rel,att)=(0,0)
[2100-0.782]READING ATTTYPMOD
[2100-0.782]CI_read_fields: fieldname='lab_range_child', adtid=1042, adtsize=-1, atttypmod=15 (rel,att)=(0,0)
[2100-0.782]READING ATTTYPMOD
[2100-0.782]CI_read_fields: fieldname='grp_desc', adtid=1042, adtsize=-1, atttypmod=40 (rel,att)=(0,0)
[2100-0.797]READING ATTTYPMOD
[2100-0.797]CI_read_fields: fieldname='lab_seq_code', adtid=23, adtsize=4, atttypmod=-1 (rel,att)=(0,0)
[2100-0.797]QR_fetch_tuples: past CI_read_fields: num_fields = 37
[2100-0.797]MALLOC: tuple_size = 100, size = 29600
[2100-0.797]QR_next_tuple: inTuples = true, falling through: fcount = 0, fetch_number = 0
[2100-0.797]next_tuple: 'N' - SNOTICE
[2100-0.797]next_tuple: 'N' - C00000
[2100-0.797]next_tuple: 'N' - MALL
[2100-0.813]next_tuple: 'N' - Fpl_exec.c
[2100-0.813]next_tuple: 'N' - L2110
[2100-0.813]next_tuple: 'N' - Rexec_stmt_raise
[2100-0.813]read 4096, global_socket_buffersize=4096
[2100-0.813]next_tuple: 'N' - SNOTICE
[2100-0.813]next_tuple: 'N' - C00000
[2100-0.813]read 1093, global_socket_buffersize=4096
[2100-0.813]next_tuple: 'N' - MSELECT visit.vis_pat_id, vis_detail_id, visit.vis_date, visit.vis_soap_code, visit.vis_comments, visit.vis_scan_type,
patient.pat_init_name, patient.pat_mid_name, patient.pat_last_name, patient.pat_first_name, patient.pat_id,
patient.pat_phn_no, patient.pat_pin_no, patient.pat_birthdate, patient.pat_tel_home, patient.pat_tel_buss,
patient.pat_blood_type, patient.pat_address1, patient.pat_address2, patient.pat_address3, patient.pat_city,
patient.pat_zip, patient.pat_sex,
province.pro_desc, province.pro_country,
ldetail.detail_text as ldetail_text,
adetail.detail_text as adetail_text,
cdetail.detail_text as cdetail_text,
xdetail.detail_text as xdetail_text,
'' as detail_lab_code,
'' as detail_results,
'' as detail_comments,
'' as lab_range_male,
'' as lab_range_female,
'' as lab_range_child,
'' as grp_desc,
999999999 as lab_seq_code
FROM public.visit visit
LEFT OUTER JOIN public.patient patient ON visit.vis_pat_id = patient.pat_id
LEFT OUTER JOIN public.ldetail ldetail ON visit.vis_detail_id = ldetail.detail_id
LEFT OUTER JOIN public.adetail adetail ON visit.vis_detail_id = adetail.detail_id
LEFT OUTER JOIN public.cdetail cdetail ON visit.vis_detail_id = cdetail.detail_id
LEFT OUTER JOIN public.xdetail xdetail ON visit.vis_detail_id = xdetail.detail_id
LEFT OUTER JOIN public.province province ON patient.pat_mail_pro_id = province.pro_id
LEFT OUTER JOIN public.scan_h scan_h ON scan_h.scan_id = visit.vis_detail_id
WHERE (trim(both '' from coalesce(ldetail.detail_text,''))<>'' or
trim(both '' from coalesce(adetail.detail_text,''))<>'' or
trim(both '' from coalesce(cdetail.detail_text,''))<>'' or
trim(both '' from coalesce(xdetail.detail_text,''))<>'' or
trim(both '' from coalesce(visit.vis_scan_type,'')) ='HTM' or
trim(both '' from coalesce(visit.vis_scan_type,'')) ='TIF' and scan_pg_cnt <> 0)
AND vis_detail_id NOT IN (SELECT detail_id FROM select_inr_data_only(77.00)) AND visit.vis_pat_id = 77.00
UNION
SELECT visit.vis_pat_id, vis_detail_id, visit.vis_date, visit.vis_soap_code, visit.vis_comments, visit.vis_scan_type,
patient.pat_init_name, patient.pat_mid_name, patient.pat_last_name, patient.pat_first_name, patient.pat_id,
patient.pat_phn_no, patient.pat_pin_no, patient.pat_birthdate, patient.pat_tel_home, patient.pat_tel_buss,
patient.pat_blood_type, patient.pat_address1, patient.pat_address2, patient.pat_address3, patient.pat_city,
patient.pat_zip, patient.pat_sex,
province.pro_desc, province.pro_country,
'' as ldetail_text,
'' as adetail_text,
'' as cdetail_text,
'' as xdetail_text,
lrdetail.detail_lab_code, lrdetail.detail_results, lrdetail.detail_comments,
lab.lab_range_male, lab.lab_range_female, lab.lab_range_child,
labgroup.grp_desc,
lab.lab_seq_code
FROM public.visit visit
LEFT OUTER JOIN public.patient patient ON visit.vis_pat_id = patient.pat_id
LEFT OUTER JOIN public.lrdetail lrdetail ON visit.vis_detail_id = lrdetail.detail_id
LEFT OUTER JOIN public.lab lab ON lrd

--------------090603050700050008070908
Content-Type: text/plain
Content-Disposition: inline
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable


--=20
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

--------------090603050700050008070908--

Re: raise notice causes driver to crash

am 29.09.2010 02:04:26 von Hiroshi Inoue

Hi Alex,

(2010/09/29 3:32), Alex Balan wrote:
> raise notice - displaying string having length over 4096 characters
> causes crash in ODBC ANSI driver but seems to be ok on 7.4.3 driver.
>
> Driver: psqlODBC ANSI ver. 8.4.2
> Database: PostgreSQL 8.1.5 on i686-redhat-linux-gnu
> Error: Faulting application vb6.exe, version 6.0.97.82,
> faulting module psqlodbc30a.dll, version 8.4.2.0, fault address 0x00045431.

Maybe this bug was already fixed.
Could you please try the drivers on testing for 8.4.0202 at
http://www.ne.jp/asahi/inocchichichi/entrance/psqlodbc/
?

regards,
Hiroshi Inoue

> Notes: Version 7.4.3 of psqlodbc driver driver does not expose this issue
>
> Calling procedure from VB
>
> Const strConnect = "DRIVER={PostgreSQL
> ANSI};DATABASE=test-medsql-alder;SERVER=192.168.100.77;PORT= 5432;
> UID=postgres;PWD=secret;ByteaAsLongVarBinary=1;MaxLongVarcha rSize=-4;"
> conn.ConnectionString = strConnect
> conn.Open
> Set RCS = conn.Execute("SELECT * FROM
> select_patient_all_visit_data(77.00,'')")
>
>
> Called pl/pgsql function
>
>
> --sqltext is dynamically built here with a LENGTH OVER 4096 characters
>
> --next line if enabled causes crash
> --*********************************
> --raise notice '%',sqltext;
> --*********************************
>
> FOR ret_row IN EXECUTE sqltext LOOP
> return next ret_row;
> END LOOP;
> return;
>
>
> Hope this helps track down the issue(s) if any...
> Alex Balan


--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc