Hi Btrivieans!

Bill Bach wrote as reply to the problm described at the end of ths post:
Well, we do the upgrade and a couple of weeks there were no problms. But
yesterday we observe the following:

backup-agent was started exactly at 12:30 h, several datafiles where at this
moment not open especially a (btrieve-)file named pattest.dat.

While running PBA the datafiles are copied (with XCOPY). The copy job lastes
until 12:36 h. Meanwhile, at 12:33 h somebody used a function of the application
that needs pattest.dat, henceforce it was opened: in the PBA-Log appear

I 1612 04.10.2007 12:33:34 Backup Agent is now ON for this file:
"D:\project\DATS\PATTEST.DAT"

the strange thing is, that just after this at we get Error 46 on update and
add-operations on that file pattest.dat (not on open or read).
This Error 46 comes for every update/add until 12:59(! yes 59!) although the PBA
was OFF since 12:26 (as listed in the Log-File). The PBA is swiched off not
before the copy-action is finished (so the copy was ready at 12:26.).

There were also other btrieve-files opened at 12:33:34, but with them no problem
occur.

I can not explain this behavior. I guess, that at the moment of switching PBA on
for pattest.dat (12:33:34) the copy of that file was just in progress. But than
the error should be gone at leasat at 12:36.
But eaven if the error hat gone at 12:36 it remains the question: why occur this
error in the first place? I thgought, that PBA will tolerate copiing of the
originalfiles while running?

(of course *.^^^are not copied!).

As far as I know, the virusscanner is configured, so that *.dat and *.^^^ are
not scanned.

(In the PVSW.LOG file is nothing this time.)

Do you have any idea, what happens?

Sincerely
Mircea






Hallo Btrivieans!

since a couple of weeks we observe, that sometimes - not ever - PSQL engine 8.1
stops while Backup Agent is switched off:
Backup Agent runs twice a day, 12:30 and 20:00 a clock. Many times it work
without problm, but sometimes for some reasen I dont konow, the PSQL engine
simple stop work: here whats in the pvsw.log-file


07-10-2007 12:35:58 W3CACHE 00000620 W3DBSMGR.EXE TKHSERV I
MicroKernel is using default settings.
07-10-2007 12:35:59 W3CACHE 00000620 W3DBSMGR.EXE TKHSERV W
Resources allocated
07-10-2007 12:36:38 W3CACHE 00000620 W3DBSMGR.EXE TKHSERV I
Resources released


(entries before 12:35:58 are not from 07-10-2007!)

(We have already exclude the btrieve-datafiles from virus-scanning.)

Is this phenomenon known? Will it make sense to update to 8.6 (i.e. is it a
known issus in 8.1)?


Any hint will be welcome

Regards
Mircea

This is a common problem, caused purely by timing (i.e. backup up the
file at the same time it is being opened), and simply a functional
defect in the design of the Backup Agent software. We have documented
this issue in previous posts and in our newsletter.

The solution, until Pervasive implements a "White List" feature for
Backup Agent, is to ensure that ALL files are open at the start of the
backup process. The Goldstar Software utility HOLDOPEN can work in
conjunction with the Backup Agent to force a given set of files to be
opened at the same time the Backup is started, thus ensuring that these
files are properly protected.

Optionally, you can use the BUTIL -STARTBU process to ensure that all
files are protected manually, without using Backup Agent. (It MAY be
possible to do both at the same time, but the order may be important to
prevent failures.)
Goldstar Software Inc.
Pervasive-based Products, Training & Services
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Chicago: Pervasive Service & Support Class - 11/13/2007 ***

nmm wrote:



--

Bill Bach schrieb:
sorry I dont perceived that!
Thank you that you nonetheless give that answer.

In some sense Backup Agent is absurd with this bug: the advandatge from BA was
nothing than that one does *not* have to create and maintain a explicit list of
files to care of.

So I would like urge Pervasive to fix this bug, but I dont know how.

Thanks again Mr. Bach!

Mircea