We just implemented a Linux RedHat ES4 server with PSQL ver 9.2 and
Samba shares. We have a vb application that can run from the server OR
the desktop accessing the db through the PSQL ODBC client. In either
scenario, if more than one user is modifying data, the mkde crashes.
The only way I can recover the server from the crash to is to run mkded
-force, then mkded -start in a terminal session.

I am stumped where to start resolving this issue. Does anyone have any
similar experiences they have resolved??

Thanks!!

Liz

Hi Liz,

What does PVSW.LOG say?

Have you installed a client on your desktops (I assume they're Windows
clients)? If so then you can use Pervasive utilities to simulate the
same situation and possibly get some better responses prior to the mkde
crashing.

Liz ha scritto:

Hi Wayne...thanks for the reply.

I can check the log....users have an application installed locally on
their Wintel machines, but the executable can be run from the server on
a mapped drive as well. That is how we had it running on Novell in an
Oracle environment.

I know there is a pvsw.log on the local machine, what about any logs on
the psql share on Linux??

Thanks...I have been pulling out hair for a couple of days now...not a
pretty sight ;o)

Liz
Wayne wrote:

Hi Wayne...thanks for the reply.

I can check the log....users have an application installed locally on
their Wintel machines, but the executable can be run from the server on
a mapped drive as well. That is how we had it running on Novell in an
Oracle environment.

I know there is a pvsw.log on the local machine, what about any logs on
the psql share on Linux??

Thanks...I have been pulling out hair for a couple of days now...not a
pretty sight ;o)

Liz
Wayne wrote:

Oops! Sorry, there's no pvsw.log for the PSQL Linux version. It's in
the system logs.

For transactional engine entries, use: grep mkded /var/log/messages* |
less
For relational engine entries, use: grep sqlmgr /var/log/messages* |
less

Wayne

Liz ha scritto:

By the way, you have to grep those message logs as root.

Can you use the Pervasive Function Executer from two different
workstations to access the same file on the server? This would
eliminate all layers from the environment such as the relational engine
and ODBC.

Liz ha scritto: