Subject | Re: Firebird 2.0.3 on Solaris 10 sparc backup problem |
---|---|
Author | mr.susi |
Post date | 2008-10-31T07:57:02Z |
--- In firebird-support@yahoogroups.com, "Nigel Weeks" <nweeks@...> wrote:
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.
--- 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
>running, or
> By the looks of it, you haven't actually got the Firebird Service
> 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 withIBExpert,
> you did a direct filesystem connect to the database file, not thedatabase
> server itself.might be
>
> Take a look at services that are running, and any firewalling that
> blocking port 3050 from localhost and external hosts.for example more complect log
>
> 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
--- 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