ODBC query problem
От | Luis Magaña |
---|---|
Тема | ODBC query problem |
Дата | |
Msg-id | 1058373160.9218.18.camel@kerberus.santarita.intranet обсуждение исходный текст |
Ответы |
Re: ODBC query problem
(Andrew Sullivan <andrew@libertyrms.info>)
|
Список | pgsql-general |
Hi, yesterday I ran vaccumdb on one of our postgresql databases. As of today, whenever I try to connect to the postmaster from Windows using the latest ODBC driver the postmaster crashes and restarts itself again, here the log output: 2003-07-16 11:26:48 [1629] LOG: connection authorized: user=sentinell database=thot 2003-07-16 11:26:48 [1629] LOG: query: select version() 2003-07-16 11:26:48 [1629] LOG: duration: 0.007115 sec 2003-07-16 11:26:48 [1629] LOG: query: set DateStyle to 'ISO' 2003-07-16 11:26:48 [1629] LOG: duration: 0.001107 sec 2003-07-16 11:26:48 [1629] LOG: query: set geqo to 'OFF' 2003-07-16 11:26:48 [1629] LOG: duration: 0.000814 sec 2003-07-16 11:26:48 [1629] LOG: query: select oid from pg_type where typname='lo' 2003-07-16 11:26:48 [1629] LOG: duration: 0.018918 sec 2003-07-16 11:26:48 [1629] LOG: query: select pg_client_encoding() 2003-07-16 11:26:48 [1629] LOG: duration: 0.002753 sec 2003-07-16 11:26:48 [1629] LOG: query: select relname, nspname, relkind from pg_catalog.pg_class, pg_catalog.pg_namespace where relkind in ('r', 'v') and nspname like 'public' and relname like 'diario_factura_embarque' and relname !~ '^pg_|^dd_' and pg_namespace.oid = relnamespace order by nspname, relname 2003-07-16 11:26:49 [1623] LOG: server process (pid 1629) was terminated by signal 11 2003-07-16 11:26:49 [1623] LOG: terminating any other active server processes 2003-07-16 11:26:49 [1623] LOG: all server processes terminated; reinitializing shared memory and semaphores 2003-07-16 11:26:49 [1630] LOG: database system was interrupted at 2003-07-16 11:26:27 CDT 2003-07-16 11:26:49 [1630] LOG: checkpoint record is at 0/501001E0 2003-07-16 11:26:49 [1630] LOG: redo record is at 0/501001E0; undo record is at 0/0; shutdown TRUE 2003-07-16 11:26:49 [1630] LOG: next transaction id: 1973685; next oid: 1644084 2003-07-16 11:26:49 [1630] LOG: database system was not properly shut down; automatic recovery in progress 2003-07-16 11:26:49 [1630] LOG: ReadRecord: record with zero length at 0/50100220 2003-07-16 11:26:49 [1630] LOG: redo is not required 2003-07-16 11:26:51 [1630] LOG: database system is ready as I can see the long query crashes the post master for some unknown reason. I've tried this on 7.3.2 and 7.3.3 with the same results. There is a lot of space in the hard disks so I assume that is not the problem. Also is to note that I can connect with no problems from PHP, psql and some other programs running on linux. But, If I run that query from psql the postmaster also crashes. Best Regards. -- Luis Magaña. Gnovus Networks & Software. www.gnovus.com
В списке pgsql-general по дате отправления: