Subject Re: Firebird 2.0.3 on Solaris 10 sparc backup problem
Author mr.susi
--- In firebird-support@yahoogroups.com, "Nigel Weeks" <nweeks@...> wrote:
>
> By the looks of it, you haven't actually got the Firebird Service
running, or
> it's firewalled off from receiving network connections.

that be so easy,
I'm beginner work with Solaris, believe this problem with pipe, but
not firewall.

To database connect is ok and file database restore 80,100,150 Mb for
the everyone backup. I tested 5 individual backups and every time had
error in same point of file and log, this stable for unique backup.

Sometime gfix not found error in restored database, sometime found.

> I'm guessing by the absence of the '127.0.0.1' in your connect with
IBExpert,
> you did a direct filesystem connect to the database file, not the
database
> server itself.
>
> Take a look at services that are running, and any firewalling that
might be
> blocking port 3050 from localhost and external hosts.
>
> Nige.

> > ...
> > gbak: writing data for table SALARY_HISTORY
> > gbak: ERROR:Unable to complete network request to host "127.0.0.1".
> > gbak: ERROR: Error reading data from the connection.
> > gbak: ERROR:gds_$start_request failed
> > gbak:Exiting before completion due to errors
> > Broken Pipe

for example more complect log
--- 8< ------------------------------------------
gbak:gbak version SO-V2.0.3.12981 Firebird 2.0
gbak:opened file /d1/gdb/MediaContent.bak
gbak:transportable backup -- data in XDR format
gbak: backup file is compressed
gbak: Version(s) for database "127.0.0.1:/d1/gdb/MediaContent.gdb"
Firebird/sun4 (access method), version "SO-V2.0.3.12981
Firebird 2.0"
Firebird/sun4 (remote server), version "SO-V2.0.3.12981
Firebird 2.0/tcp
(unknosun)/P10"
Firebird/sun4 (remote interface), version "SO-V2.0.3.12981
Firebird 2.0/
tcp (unknosun)/P10"
on disk structure version 11.0
gbak:created database 127.0.0.1:/d1/gdb/MediaContent.gdb, page_size
8192 bytes
gbak:started transaction
gbak:restoring domain RDB$1
gbak:restoring domain RDB$2
gbak:restoring domain RDB$3
gbak:restoring domain RDB$51
gbak:restoring domain RDB$61
...
gbak: restoring privilege for user SYSDBA
gbak: restoring privilege for user MRSUSI
gbak: restoring privilege for user MRSUSI
gbak: restoring privilege for user MRSUSI
gbak: restoring privilege for user MRSUSI
gbak: restoring privilege for user MRSUSI
gbak: ERROR:Unable to complete network request to host "127.0.0.1".
gbak: ERROR: Error reading data from the connection.
gbak:Exiting before completion due to errors
Broken Pipe
--- 8< firebird.log ------------------------------------------
unknosun Tue Oct 28 17:10:10 2008
REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
Uncommitted work may have been lost
--- 8< ls -l ------------------------------------------
-rw-r--r-- 1 root root 151846912 Oct 27 14:26 MediaContent0.gdb
-rw-r--r-- 1 root root 151846912 Oct 27 14:54 MediaContent1.gdb
-rw-r--r-- 1 root root 129429504 Oct 28 16:39 MediaContent.bak
-rw-r--r-- 1 root root 151846912 Oct 28 17:10 MediaContent.gdb
--- 8< ls -l ------------------------------------------
--- source database ---
-rw-r--r-- 1 firebird firebird 158752768 Îêò 30 17:08 MediaContent.gdb
--- 8< ------------------------------------------
# /opt/firebird/bin/gfix -validate -full /d1/gdb/MediaContent.gdb
Summary of validation errors
Number of database page errors : 1
#

I don't know what else I can view in logs ;-(

Susi