Received: from u1.abs.net (root@u1.abs.net [207.114.0.131]) by hub.org (8.8.8/8.7.5) with ESMTP id KAA14144 for ; Thu, 27 Aug 1998 10:25:01 -0400 (EDT) Received: from insightdist.com (nobody@localhost) by u1.abs.net (8.9.0/8.9.0) with UUCP id KAA25681 for pgsql-interfaces@postgreSQL.org; Thu, 27 Aug 1998 10:04:08 -0400 (EDT) X-Authentication-Warning: u1.abs.net: nobody set sender to insightdist.com!daveh using -f Received: from ceodev by insightdist.com (AIX 3.2/UCB 5.64/4.03) id AA13837; Thu, 27 Aug 1998 09:55:50 -0400 Received: from daveh by ceodev (AIX 4.1/UCB 5.64/4.03) id AA62940; Thu, 27 Aug 1998 09:55:50 -0400 Message-Id: <35E5665B.81422A34@insightdist.com> Date: Thu, 27 Aug 1998 09:59:56 -0400 From: David Hartwig Organization: Insight Distribution Systems X-Mailer: Mozilla 4.05 [en] (Win95; I) Mime-Version: 1.0 To: "John J. Boris, Sr." , pgsql-interfaces Subject: Re: [INTERFACES] new odbc fails References: <199808260313.XAA27714@hub.org> <199808262336.TAA00679@u1.abs.net> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Byron was correct. That message comes from the backend. If you cut out that last query with all the ANDs and OR's, you will see what I mean. There will be something in 6.4 to handle this. I am awaiting Bruce's comments to see what form the solution will take. John J. Boris, Sr. wrote: > > Version of PostgreSQL server? > PostgreSQL 6.3.1 > > > > Version of ODBC Driver? I know you say you have the latest, but we have > >had some confusion in the past with old FTP sites. > PostgreSQL 6.30.0247 from Insight Distribution Systems > > > >Could you turn the CommLog under the Advanced Driver Options and send the > >results of your interaction. The log file is C:\psqlodbc.log. You must > >close the application before the logging activity is flushed. > conn=156310432, > SQLDriverConnect(out)='DRIVER={PostgreSQL};DATABASE=gsyfl;SERVER=bcs-2.onlin > esvc.com;PORT=5432;UID=postgres;READONLY=0;PWD=onlinesvc;PROTOCOL=;FAKEOIDIN > DEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=1;SHOWSYSTEMTABLES=1;CONNSETTINGS=' > Global Options: fetch=100, socket=4096, unknown_sizes=0, > max_varchar_size=254, max_longvarchar_size=4094 > disable_optimizer=0, unique_index=0, use_declarefetch=1 > text_as_longvarchar=1, unknowns_as_longvarchar=1, > bools_as_char=1 > extra_systable_prefixes='dd_;', conn_settings='' > conn=156310432, query=' ' > conn=156310432, query='BEGIN' > conn=156310432, query='set DateStyle to 'ISO'' > conn=156310432, query='declare SQL_CUR156368960 cursor for select oid from > pg_type where typname='lo'' > conn=156310432, query='fetch 100 in SQL_CUR156368960' > [ fetched 0 rows ] > conn=156310432, query='close SQL_CUR156368960' > conn=156310432, query='END' > conn=156310432, query='BEGIN' > conn=156310432, query='declare SQL_CUR156368960 cursor for SELECT Config, > nValue FROM MSysConf' > ERROR from backend during send_query: 'ERROR: msysconf: Table does not > exist.' > conn=156310432, query='ABORT' > STATEMENT ERROR: func=SC_execute, desc='', errnum=1, errmsg='Error while > executing the query' > ------------------------------------------------------------ > hdbc=156310432, stmt=156368960, result=0 > manual_result=0, prepare=0, internal=0 > bindings=0, bindings_allocated=0 > parameters=0, parameters_allocated=0 > statement_type=0, statement='SELECT Config, nValue FROM > MSysConf' > stmt_with_params='declare SQL_CUR156368960 cursor for > SELECT Config, nValue FROM MSysConf' > data_at_exec=-1, current_exec_param=-1, put_data=0 > currTuple=-1, current_col=-1, lobj_fd=-1 > maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0, > scroll_concurrency=1 > cursor_name='SQL_CUR156368960' > ----------------QResult Info ------------------------------- > CONN ERROR: func=SC_execute, desc='', errnum=10, errmsg='ERROR: msysconf: > Table does not exist.' > ------------------------------------------------------------ > henv=156304960, conn=156310432, status=1, num_stmts=16 > sock=156304976, stmts=156305024, lobj_type=-999 > ---------------- Socket Info ------------------------------- > socket=352, reverse=0, errornumber=0, errormsg='(null)' > buffer_in=156316448, buffer_out=156320552 > buffer_filled_in=2, buffer_filled_out=0, buffer_read_in=2 > conn=156310432, query='BEGIN' > conn=156310432, query='declare SQL_CUR156368960 cursor for SELECT > "schedule"."sweek","schedule"."hteam","schedule"."vteam" FROM "schedule" ' > conn=156310432, query='fetch 100 in SQL_CUR156368960' > [ fetched 90 rows ] > conn=156310432, query='close SQL_CUR156368960' > conn=156310432, query='END' > conn=156310432, query='BEGIN' > conn=156310432, query='declare SQL_CUR156439880 cursor for SELECT > "sdate","sweek","hteam","vteam","stimes" FROM "schedule" WHERE "sweek" = > 1 AND "hteam" = 'LINDENBORO' AND "vteam" = 'G.T.LIONS' OR "sweek" = 1 AND > "hteam" = 'VOORHEES' AND "vteam" = 'STERLING' OR "sweek" = 1 AND "hteam" = > 'MARLTON' AND "vteam" = 'PYAA PANTHERS' OR "sweek" = 1 AND "hteam" = 'WASH. > TWP. PATRIOTS' AND "vteam" = '' OR "sweek" = 1 AND "hteam" = 'HADDONFIELD' > AND "vteam" = 'WINSLOW' OR "sweek" = 1 AND "hteam" = 'INTERBORO' AND > "vteam" = 'WASH. TWP. MINUTEMAN' OR "sweek" = 1 AND "hteam" = 'BELLMAWR' > AND "vteam" = 'GLOUCESTER' OR "sweek" = 1 AND "hteam" = 'WILLIAMSTOWN' AND > "vteam" = 'GLASSBORO' OR "sweek" = 1 AND "hteam" = 'DEPTFORD' AND "vteam" = > 'OAKLYN' OR "sweek" = 1 AND "hteam" = 'WILLINGBORO' AND "vteam" = 'PYAA > LIONS'' > ERROR from backend during send_query: 'FATAL 1: palloc failure: memory > exhausted' > STATEMENT ERROR: func=SC_execute, desc='', errnum=1, errmsg='Error while > executing the query' > ------------------------------------------------------------ > hdbc=156310432, stmt=156439880, result=0 > manual_result=0, prepare=1, internal=0 > bindings=0, bindings_allocated=0 > parameters=156368960, parameters_allocated=30 > statement_type=0, statement='SELECT > "sdate","sweek","hteam","vteam","stimes" FROM "schedule" WHERE "sweek" = > ? AND "hteam" = ? AND "vteam" = ? OR "sweek" = ? AND "hteam" = ? AND > "vteam" = ? OR "sweek" = ? AND "hteam" = ? AND "vteam" = ? OR "sweek" = ? > AND "hteam" = ? AND "vteam" = ? OR "sweek" = ? AND "hteam" = ? AND "vteam" > = ? OR "sweek" = ? AND "hteam" = ? AND "vteam" = ? OR "sweek" = ? AND > "hteam" = ? AND "vteam" = ? OR "sweek" = ? AND "hteam" = ? AND "vteam" = ? > OR "sweek" = ? AND "hteam" = ? AND "vteam" = ? OR "sweek" = ? AND "hteam" = > ? AND "vteam" = ?' > stmt_with_params='declare SQL_CUR156439880 cursor for > SELECT "sdate","sweek","hteam","vteam","stimes" FROM "schedule" WHERE > "sweek" = 1 AND "hteam" = 'LINDENBORO' AND "vteam" = 'G.T.LIONS' OR "sweek" > = 1 AND "hteam" = 'VOORHEES' AND "vteam" = 'STERLING' OR "sweek" = 1 AND > "hteam" = 'MARLTON' AND "vteam" = 'PYAA PANTHERS' OR "sweek" = 1 AND > "hteam" = 'WASH. TWP. PATRIOTS' AND "vteam" = '' OR "sweek" = 1 AND "hteam" > = 'HADDONFIELD' AND "vteam" = 'WINSLOW' OR "sweek" = 1 AND "hteam" = > 'INTERBORO' AND "vteam" = 'WASH. TWP. MINUTEMAN' OR "sweek" = 1 AND "hteam" > = 'BELLMAWR' AND "vteam" = 'GLOUCESTER' OR "sweek" = 1 AND "hteam" = > 'WILLIAMSTOWN' AND "vteam" = 'GLASSBORO' OR "sweek" = 1 AND "hteam" = > 'DEPTFORD' AND "vteam" = 'OAKLYN' OR "sweek" = 1 AND "hteam" = > 'WILLINGBORO' AND "vteam" = 'PYAA LIONS'' > data_at_exec=-1, current_exec_param=-1, put_data=0 > currTuple=-1, current_col=-1, lobj_fd=-1 > maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0, > scroll_concurrency=1 > cursor_name='SQL_CUR156439880' > ----------------QResult Info ------------------------------- > CONN ERROR: func=SC_execute, desc='', errnum=8, errmsg='FATAL 1: palloc > failure: memory exhausted' > ------------------------------------------------------------ > henv=156304960, conn=156310432, status=1, num_stmts=16 > sock=156304976, stmts=156305024, lobj_type=-999 > ---------------- Socket Info ------------------------------- > socket=352, reverse=0, errornumber=0, errormsg='(null)' > buffer_in=156316448, buffer_out=156320552 > buffer_filled_in=45, buffer_filled_out=0, buffer_read_in=45 > conn=156310432, SQLDisconnect > > John J. Boris, Sr. Boris Computer Services/ONLine Services > email:john.boris@onlinesvc.com.com > bbs: The Bleeding Edge 609-858-9221 > http:\\www.onlinesvc.com > telnet:www.onlinesvc.com > Busines Phone 609-869-9620