Postgres Pro
Downloads
Home   >   mailing lists

ODBC / Access causes "Stuck on TLB IPI wait (CPU#1)" - Mailing list pgsql-interfaces

From Simon Hardingham
Subject ODBC / Access causes "Stuck on TLB IPI wait (CPU#1)"
Date
Msg-id 4DCB16536FCBD311897000A0C92A02EDB5D2@sauron.netxtra.net
Whole thread Raw
Responses Re: [INTERFACES] ODBC / Access causes "Stuck on TLB IPI wait (CPU#1)"  ("Ross J. Reedstrom" <reedstrm@wallace.ece.rice.edu>)
List pgsql-interfaces
Tree view 
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@netxtra.co.uk _/
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/

pgsql-interfaces by date:

Previous
From: Michael Meskes
Date:
Subject: Re: [INTERFACES] libpq patch for binding tuples in a result set to user allocated memory
Next
From: Peter Mount
Date:
Subject: RE: [INTERFACES] DELETEs with jdbc