At one customer site, we have big problems running Pervasive. This
installation have rune fine for years, but about a year ago, we began
having
problems. This customer have deadlines to keep, and because the Pervasive
server crashes (sometimes several times a day. Today it have crashed 4
times), this is pretty serious to them (and us).
Server:
Pervasicve.SQL 95.
Windows server 2003 R2 Service pack 1.
Clients:
Windows XP SP2.
There are about 10 to 15 active clients connected to the server, and
sometimes the load is pretty high. The database consist of a bit more than
700 tables, and a total of about 100GB data. The largest table is around
47
GB in size.
Our programs is programmed in Visual Dataflex 9.1 (guess nobody have heard
of it), and we use the transactional interface. We have some web access
that
uses the relational interface.
At random intervals, the clients looses the connection to the server. The
only solution seems to restart the services on the server. There are no
indication of the problem in the Pervasive, or Windows event logs (makes
it
hard to debug).
We have had a similar situation in our developement environment. We all
lost
the connection to the pervasive server (9.5), and when I had a look at the
server, the NTDBSMGR.EXE had stoppet without any logging to the Pervasive
or Windows event log. I don't know if this is happening at the customer
site, but will be checking this the next days.
Lately we have also been getting some error 146:
"146: Duplicate system key. The same key number was generated by two
different threads generating system keys. "
Any ide what to do ?
TIA
Karl
|
