Skip site navigation (1) Skip section navigation (2)

ODBC / Access causes "Stuck on TLB IPI wait (CPU#1)"

From: "Simon Hardingham" <simon(at)netxtra(dot)net>
To: <pgsql-interfaces(at)postgreSQL(dot)org>
Subject: ODBC / Access causes "Stuck on TLB IPI wait (CPU#1)"
Date: 2000-02-15 09:17:03
Message-ID: 4DCB16536FCBD311897000A0C92A02EDB5D2@sauron.netxtra.net (view raw or flat)
Thread:
Lists: pgsql-interfaces
Hi,

Have a reasonable sized postgres database with a number of tables.  I have
set up an Access 97 database with ODBC links to these table and queries so
they can manage the database.  However, increasingly when opening these
linked tables we are getting server crashes (and Access hangs) with

Stuck on TLB IPI wait (CPU#1)

The database works fine with all the JDBC manipulation and psql, never had a
crash from these.  Can anyone suggest a solution as the alternative is
create some sort of web front-end to do all the manipulation, slow, complex
etc. etc.

System is:
Dual PIII 450, 128MB Ram,
RedHat 6.0 (no kernel upgrades etc)
PostgreSQL 6.5.1
PostgreSQL ODBC v06-40-0006
Access 97 & 2000

Many thanks

Simon

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
_/         Simon Hardingham - netXtra Ltd - UK          _/
_/ Tel: +44 (0) 1787 319393    Fax: +44 (0) 1787 319394 _/
_/ http://www.netxtra.co.uk         simon(at)netxtra(dot)co(dot)uk _/
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/


Responses

pgsql-interfaces by date

Next:From: Peter MountDate: 2000-02-15 09:43:46
Subject: RE: [INTERFACES] DELETEs with jdbc
Previous:From: Tom LaneDate: 2000-02-15 07:59:40
Subject: Re: [INTERFACES] libpq patch for binding tuples in a result set to user allocated memory

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group