New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
"error reading data from connection" before the gbak restore ends. [CORE3175] #3549
Comments
Commented by: @pmakowski please give more details |
Commented by: haydie rodriguez (kylix) first I made a gbak inside the Snow Leopard Server and backing up data from another server. The server version is SuperClassic. backup command: ./gbak -user sysdba -password masterkey 172.23.100.20:db1 /gbk/db1.gbk -V -G the source database is in Linux and running Firebird 2.1 Classic gbk file was created successfully without any error now, inside the same Snow Leopard server, I restored using the ff command: ./gbak -user sysdba -password masterkey /gbk/db1.gbk localhost:db1 -V -C the db1 alias is defined in aliases.conf the restore will go with the normal restore messages but at the last section |
Commented by: @pmakowski and what is the output of gstat -h on the Linux source database ? |
Commented by: haydie rodriguez (kylix) Database header page information:
|
Commented by: @pmakowski Implementation ID 31 and sorry, I tested, I can't reproduce your case and why are you still using this old Dialect 1 ? |
Commented by: haydie rodriguez (kylix) Sorry, I mistakenly copied from a different server. here's the gstat from the source database running in Linux, and Firebird 2.1 SS. --------------------------------------------------
-------------------------------------------------- I know about the dialect 1 as being old and not a good idea but can't switch right away to dialect 3 because we still have old windows apps that produces errors when doing queries with dialect 3 database. I'll switch dialect once those old apps are replaced. About my issue, I'm still looking into the server on what's possibly causing it. I tried to install 2.5.0 CS in my Macbook Pro with Snow Leopard and did same backup and restore process and I did not encounter the same error I'm getting in Xserve. |
Commented by: haydie rodriguez (kylix) Sorry, I mistakenly copied from a different server. here's the gstat from the source database running in Linux, and Firebird 2.1 SS. --------------------------------------------------
-------------------------------------------------- I know about the dialect 1 as being old and not a good idea but can't switch right away to dialect 3 because we still have old windows apps that produces errors when doing queries with dialect 3 database. I'll switch dialect once those old apps are replaced. About my issue, I'm still looking into the server on what's possibly causing it. I tried to install 2.5.0 CS in my Macbook Pro with Snow Leopard and did same backup and restore process and I did not encounter the same error I'm getting in Xserve. |
Commented by: @pmakowski > I tried to install 2.5.0 CS in my Macbook Pro with Snow Leopard and did same backup and restore process and I did not encounter the same error I'm getting in Xserve ok, I never did test in Xserve, that can be something to investigate |
Modified by: @pmakowskiassignee: Paul Beach [ pbeach ] |
Modified by: haydie rodriguez (kylix)environment: OSX Snow Leopard (10.6), Xserver hardware, 6GB Ram, Firebird Database file size is 3GB. Using the 64-bit 2.5 Release version of Firebird (latest) => OSX Snow Leopard (10.6), Xserve hardware, 6GB Ram, Firebird Database file size is 3GB. Using the 64-bit 2.5 Release version of Firebird (latest) |
Commented by: @pmakowski Xserve is using MacOsX Server version ? or do you have any solution so we can have access to a MacOsX Server edition ? I don't see how it could be hardware related |
Commented by: haydie rodriguez (kylix) Yes, the XServes uses the Server Version of snow leopard (64-bit mode). |
Modified by: haydie rodriguez (kylix)environment: OSX Snow Leopard (10.6), Xserve hardware, 6GB Ram, Firebird Database file size is 3GB. Using the 64-bit 2.5 Release version of Firebird (latest) => OSX Snow Leopard (10.6) - Server Version, Xserve hardware, 6GB Ram, Firebird Database file size is 3GB. Using the 64-bit 2.5.0 Release version of Firebird (latest) |
Commented by: @paulbeach Since |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
Submitted by: haydie rodriguez (kylix)
backup works fine in OS X Snow Leopard but when restoring using gbak, an error message "error reading data from connection" appears at the end of the restore process. Tested on 3 Xserves and got the same result. I don't encounter the problem on ver 2.1, 2.0 and 1.5 on the same servers.
I tried in Windows and Linux and did not encounter such problem.
below is the last portion of gbak from OS X Terminal:
gbak: activating and creating deferred index LOOKUPOPCODESUNQ2
gbak: activating and creating deferred index LOOKUPREJTYPESUNQ
gbak: activating and creating deferred index LOOKUPREJTYPESUNQ2
gbak: committing metadata
gbak: ERROR:Error reading data from the connection.
gbak:Exiting before completion due to errors
gbak: ERROR:Error reading data from the connection.
I tried doing the same with other databases and also getting the same error.
The database seems to be created even with the errors. However, gstat shows the ff:
Attributes single-user maintenance
This is ok since I can still use gfix to put the database in multi-user mode. However, I am not sure if the database is created completely and without any error. Because of this doubt, I cannot bring the database in production mode
The text was updated successfully, but these errors were encountered: