Subject Re: Problems with backup via service_mgr
Author Adam
--- In firebird-support@yahoogroups.com, Bogusław Brandys
<brandys@...> wrote:
>
> 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 ?

I can not rule this out. I will investigate this possibility but I
would hope it is nothing like this ;)

>
> "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 ?

Yes. It wrapped at an unfortunate position but the syntax of the
command executed was fine (works on other 1.5.5 servers).

Thanks

Adam