Subject Re: Problems with backup via service_mgr
Author Adam
--- In firebird-support@yahoogroups.com, "Adam" <s3057043@...> wrote:
>
> --- In firebird-support@yahoogroups.com, "Vlad Khorsun" <hvlad@> wrote:
> >
> > > I am not used to using gbak as a wrapper around services API. When I
> > > remove the host name, it doesn't work on my laptop either:
> > >
> > > gbak -b -se localhost:service_mgr myalias c:\test.fbk -user sysdba
> > > -password masterke -v -g
> > >
> > > gbak: ERROR: unavailable database
> > > gbak: Exiting before completion due to errors
> >
> > It seems Firebird is not running on localhost. Or some software
> blocked
> > it from run (NOD32 for example)
>
> It is certainly running on my laptop. As I said, include localhost and
> it works again, but not on the server. The only unusual factors in my
> laptops install is that the registry key is deleted and Firebird is
> running as an application (because I switch between 1.5 and 2.1). The
> server is a vanilla classic install.
>
> I have no problems connecting to the database from our app or via
> flamerobin etc, it is just the services API that doesn't seem to work
> and only on that particular server.
>
> >
> > > (I presumed this to be because I am using Classic server, prepending
> > > localhost works on my laptop, but not on the server).
> > >
> > > I now have a remote desktop connection to the server, and it is
> > > throwing the following error
> > >
> > > ---
> > > C:\Program Files\Firebird\Firebird_1_5\bin>gbak -b -se
> > > localhost:service_mgr myalias c:\test.fbk -user sysdba -password
> > > masterke -v -g
> > > gbak: ERROR: operating system directive CreateProcess failed
> > > gbak: ERROR: unknown Win32 error 193
> > > gbak: Exiting before completion due to errors
> > > ---
> >
> > MSDN :
> > ERROR_BAD_EXE_FORMAT (193)
> > is not a valid Win32 application
> >
> > In FB 1.5 Services API just run corresponding utilities by the
> engine
> > process. It seems your copy of gbak.exe is corrupted (or server tried
> > to run it from another location where it is not exists).
> >
>
> Yet when I run gbak without the -se tag it works fine? It can't be
> that corrupt then. The server is a standard classic service install,
> they haven't even changed anything inside firebird.conf.
>
> I will install Filemon tomorrow and take a look at what it is trying
> to execute. I don't believe there is any virus scanners on the box
> (didn't see any), but I will check this as well. I will also do a
> binary comparison on gbak, or possibly schedule an upgrade to 1.5.5
> and see if that helps.

More feedback:

It was harder than expected to monitor using Filemon. Even after
excluding the drive that the databases live on and only considering
fb_inet_server and gbak executables, there was about 1000 items
recorded in the four seconds it took me to start capturing, execute
gbak, stop capturing.

I could not see any evidence of not being able to find particular
files (except a .Manifest and .Local file, but I am pretty sure that
is irrelevant).

The server was upgraded to 1.5.5 and rebooted (so presumably gbak is
not corrupt and the registry keys should be fine), however the problem
still occurs.

I could not see any anti-virus/anti-spyware type applications,
although I am still waiting for their technical department to respond
about whether anything was done (environmentally) between the
successful backups on Tuesday night and the problem backups on
Wednesday night onwards.

Any further suggestions are greatly appreciated.

Adam