Subject Re: [firebird-support] Re: Problems with backup via service_mgr
Author Bogusław Brandys
Adam pisze:
>
>
> --- In firebird-support@ yahoogroups. com
> <mailto:firebird-support%40yahoogroups.com>, "Adam" <s3057043@.. .> wrote:
> >
> > --- In firebird-support@ yahoogroups. com
> <mailto:firebird-support%40yahoogroups.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
>



Any automatic OS update/bugfix in meantime ?

"C:\Program Files\Firebird\ Firebird_ 1_5\bin>gbak -b -se
localhost:service_ mgr myalias c:\test.fbk -user sysdba -password
masterke -v -g"

You have a space in "service_ mgr" as cited above.I assume it was only a
copy&paste error,right ?





Regards
Boguslaw