Received: from acc.nensi.cherkassy.ua (acc.nensi.cherkassy.ua [195.64.231.2]) by hub.org (8.9.3/8.9.3) with ESMTP id LAA90673 for ; Wed, 28 Jul 1999 11:15:05 -0400 (EDT) (envelope-from andrei@mart.cherkassy.ua) Received: from andrei ([195.64.231.239]) by acc.nensi.cherkassy.ua (8.8.5/8.8.5) with SMTP id SAA18197 for ; Wed, 28 Jul 1999 18:14:43 +0300 (EEST) Message-ID: <000801bed90c$4360b9c0$0101a8c0@andrei> From: "Andrei N.Sobchuck" To: Subject: Date: Wed, 28 Jul 1999 18:16:12 +0300 MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_NextPart_000_0005_01BED925.4601E820" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2615.200 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 This is a multi-part message in MIME format. ------=_NextPart_000_0005_01BED925.4601E820 Content-Type: text/plain; charset="koi8-r" Content-Transfer-Encoding: 7bit I use PostgreSQL v.6.5 linux 2.2.10, glibc 2. PgSQL ODBC Driver v06-40-0004. KSQO is 'ON' but postgres start swapping and crashes when I try to browse table with filds that is NULL. This filds are marked as primary key in MS Access. My program is not ready yet and i can generate such row by mistake. After this my server falls down :( Andrei. ------=_NextPart_000_0005_01BED925.4601E820 Content-Type: application/octet-stream; name="psqlodbc_4294752541.log" Content-Transfer-Encoding: quoted-printable Content-Disposition: attachment; filename="psqlodbc_4294752541.log" Global Options: Version=3D'06.40.0004', fetch=3D100, socket=3D4096, = unknown_sizes=3D0, max_varchar_size=3D254, max_longvarchar_size=3D4094 disable_optimizer=3D1, ksqo=3D1, unique_index=3D1, = use_declarefetch=3D0 text_as_longvarchar=3D1, unknowns_as_longvarchar=3D0, = bools_as_char=3D0 extra_systable_prefixes=3D'dd_;', conn_settings=3D'set = client_encoding to 'WIN';' conn=3D122488956, query=3D' ' conn=3D122488956, query=3D'set DateStyle to 'ISO'' conn=3D122488956, query=3D'set geqo to 'OFF'' conn=3D122488956, query=3D'set ksqo to 'ON'' conn=3D122488956, query=3D'set client_encoding to 'WIN'' conn=3D122488956, query=3D'select oid from pg_type where typname=3D'lo'' [ fetched 0 rows ] conn=3D122488956, = SQLDriverConnect(out)=3D'DSN=3Dgitlo;DATABASE=3Dgitlo2;SERVER=3Dserver1;P= ORT=3D5432;UID=3Dpostgres;PWD=3D;READONLY=3D0;PROTOCOL=3D6.4;FAKEOIDINDEX= =3D0;SHOWOIDCOLUMN=3D0;ROWVERSIONING=3D0;SHOWSYSTEMTABLES=3D0;CONNSETTING= S=3D' conn=3D122488956, query=3D'SELECT Config, nValue FROM MSysConf' ERROR from backend during send_query: 'ERROR: msysconf: Table does not = exist.' STATEMENT ERROR: func=3DSC_execute, desc=3D'', errnum=3D1, = errmsg=3D'Error while executing the query' = ------------------------------------------------------------ hdbc=3D122488956, stmt=3D122503484, result=3D0 manual_result=3D0, prepare=3D0, internal=3D0 bindings=3D0, bindings_allocated=3D0 parameters=3D0, parameters_allocated=3D0 statement_type=3D0, statement=3D'SELECT Config, nValue = FROM MSysConf' stmt_with_params=3D'SELECT Config, nValue FROM = MSysConf' data_at_exec=3D-1, current_exec_param=3D-1, = put_data=3D0 currTuple=3D-1, current_col=3D-1, lobj_fd=3D-1 maxRows=3D0, rowset_size=3D1, keyset_size=3D0, = cursor_type=3D0, scroll_concurrency=3D1 cursor_name=3D'SQL_CUR074D413C' ----------------QResult Info = ------------------------------- CONN ERROR: func=3DSC_execute, desc=3D'', errnum=3D110, errmsg=3D'ERROR: = msysconf: Table does not exist.' ------------------------------------------------------------ henv=3D123535700, conn=3D122488956, status=3D1, = num_stmts=3D16 sock=3D123535716, stmts=3D123535508, lobj_type=3D-999 ---------------- Socket Info ------------------------------- socket=3D296, reverse=3D0, errornumber=3D0, = errormsg=3D'(null)' buffer_in=3D122495284, buffer_out=3D122499384 buffer_filled_in=3D42, buffer_filled_out=3D0, = buffer_read_in=3D42 conn=3D122488956, query=3D'SELECT = "person_kalendar"."id_person","person_kalendar"."data","person_kalendar".= "tip","person_kalendar"."txt" FROM "person_kalendar" ' [ fetched 1 rows ] conn=3D122488956, query=3D'SELECT = "id_person","data","tip","txt","otvetstveni","sdelano" FROM = "person_kalendar" WHERE "id_person" =3D 1 AND "data" =3D '1999-07-27' = AND "tip" IS NULL AND "txt" IS NULL OR "id_person" =3D 1 AND "data" =3D = '1999-07-27' AND "tip" IS NULL AND "txt" IS NULL OR "id_person" =3D 1 = AND "data" =3D '1999-07-27' AND "tip" IS NULL AND "txt" IS NULL OR = "id_person" =3D 1 AND "data" =3D '1999-07-27' AND "tip" IS NULL AND = "txt" IS NULL OR "id_person" =3D 1 AND "data" =3D '1999-07-27' AND "tip" = IS NULL AND "txt" IS NULL OR "id_person" =3D 1 AND "data" =3D = '1999-07-27' AND "tip" IS NULL AND "txt" IS NULL OR "id_person" =3D 1 = AND "data" =3D '1999-07-27' AND "tip" IS NULL AND "txt" IS NULL OR = "id_person" =3D 1 AND "data" =3D '1999-07-27' AND "tip" IS NULL AND = "txt" IS NULL OR "id_person" =3D 1 AND "data" =3D '1999-07-27' AND "tip" = IS NULL AND "txt" IS NULL OR "id_person" =3D 1 AND "data" =3D = '1999-07-27' AND "tip" IS NULL AND "txt" IS NULL' STATEMENT ERROR: func=3DSC_execute, desc=3D'', errnum=3D1, = errmsg=3D'Error while executing the query' = ------------------------------------------------------------ hdbc=3D122488956, stmt=3D122569224, result=3D0 manual_result=3D0, prepare=3D1, internal=3D0 bindings=3D0, bindings_allocated=3D0 parameters=3D122635804, parameters_allocated=3D20 statement_type=3D0, statement=3D'SELECT = "id_person","data","tip","txt","otvetstveni","sdelano" FROM = "person_kalendar" WHERE "id_person" =3D ? AND "data" =3D ? AND "tip" IS = NULL AND "txt" IS NULL OR "id_person" =3D ? AND "data" =3D ? AND "tip" = IS NULL AND "txt" IS NULL OR "id_person" =3D ? AND "data" =3D ? AND = "tip" IS NULL AND "txt" IS NULL OR "id_person" =3D ? AND "data" =3D ? = AND "tip" IS NULL AND "txt" IS NULL OR "id_person" =3D ? AND "data" =3D = ? AND "tip" IS NULL AND "txt" IS NULL OR "id_person" =3D ? AND "data" = =3D ? AND "tip" IS NULL AND "txt" IS NULL OR "id_person" =3D ? AND = "data" =3D ? AND "tip" IS NULL AND "txt" IS NULL OR "id_person" =3D ? = AND "data" =3D ? AND "tip" IS NULL AND "txt" IS NULL OR "id_person" =3D = ? AND "data" =3D ? AND "tip" IS NULL AND "txt" IS NULL OR "id_person" = =3D ? AND "data" =3D ? AND "tip" IS NULL AND "txt" IS NULL' stmt_with_params=3D'SELECT = "id_person","data","tip","txt","otvetstveni","sdelano" FROM = "person_kalendar" WHERE "id_person" =3D 1 AND "data" =3D '1999-07-27' = AND "tip" IS NULL AND "txt" IS NULL OR "id_person" =3D 1 AND "data" =3D = '1999-07-27' AND "tip" IS NULL AND "txt" IS NULL OR "id_person" =3D 1 = AND "data" =3D '1999-07-27' AND "tip" IS NULL AND "txt" IS NULL OR = "id_person" =3D 1 AND "data" =3D '1999-07-27' AND "tip" IS NULL AND = "txt" IS NULL OR "id_person" =3D 1 AND "data" =3D '1999-07-27' AND "tip" = IS NULL AND "txt" IS NULL OR "id_person" =3D 1 AND "data" =3D = '1999-07-27' AND "tip" IS NULL AND "txt" IS NULL OR "id_person" =3D 1 = AND "data" =3D '1999-07-27' AND "tip" IS NULL AND "txt" IS NULL OR = "id_person" =3D 1 AND "data" =3D '1999-07-27' AND "tip" IS NULL AND = "txt" IS NULL OR "id_person" =3D 1 AND "data" =3D '1999-07-27' AND "tip" = IS NULL AND "txt" IS NULL OR "id_person" =3D 1 AND "data" =3D = '1999-07-27' AND "tip" IS NULL AND "txt" IS NULL' data_at_exec=3D-1, current_exec_param=3D-1, = put_data=3D0 currTuple=3D-1, current_col=3D-1, lobj_fd=3D-1 maxRows=3D0, rowset_size=3D1, keyset_size=3D0, = cursor_type=3D0, scroll_concurrency=3D1 cursor_name=3D'SQL_CUR074E4208' ----------------QResult Info = ------------------------------- CONN ERROR: func=3DSC_execute, desc=3D'', errnum=3D107, errmsg=3D'No = response from the backend' ------------------------------------------------------------ henv=3D123535700, conn=3D122488956, status=3D1, = num_stmts=3D16 sock=3D123535716, stmts=3D123535508, lobj_type=3D-999 ---------------- Socket Info ------------------------------- socket=3D296, reverse=3D0, errornumber=3D10, = errormsg=3D'Socket has been closed.' buffer_in=3D122495284, buffer_out=3D122499384 buffer_filled_in=3D0, buffer_filled_out=3D0, = buffer_read_in=3D1 conn=3D122488956, SQLDisconnect ------=_NextPart_000_0005_01BED925.4601E820--