gfix -replica read_write e:\baza4\test_REP.fdb -user SYSDBA -pass masterkey


isql.exe -ch WIN1251 -u SYSDBA -pas masterkey test

Database: test, User: SYSDBA
SQL> CREATE TABLE BRANCH (
CON> BRANCH_ID INTEGER NOT NULL,
CON> BRANCH_NAME VARCHAR(30) NOT NULL,
CON> COMMENT VARCHAR(50)
CON> );
SQL> commit;
SQL> show tables;
BRANCH

SQL> quit;

d:\Firebird-4.0.0.1433-0_x64>

MASTER

firebird.log:

MASTER Fri Mar 29 10:00:55 2019
Database: d:\Baza4\test.FDB
Replication is stopped due to critical error(s)
Replication error
Dynamic SQL Error
SQL error code = -104
Unexpected end of command - line 1, column 1

replication.log:

MASTER (origin) Fri Mar 29 10:00:55 2019
Database: d:\Baza4\test.FDB
ERROR: Dynamic SQL Error
SQL error code = -104
Unexpected end of command - line 1, column 1

REP

REP (replica) Fri Mar 29 10:00:54 2019
Database: e:\Baza4\test_REP.FDB
ERROR: Dynamic SQL Error
SQL error code = -104
Unexpected end of command - line 1, column 1



Database: localhost/3050:test, User: SYSDBA
SQL> show tables;
BRANCH

SQL> select * from branch;
SQL> INSERT INTO BRANCH (BRANCH_ID, BRANCH_NAME, COMMENT)
CON> VALUES (1, 'НПК', 'научно-производственный комплекс');
SQL> commit;
SQL>

firebird.log
MASTER Fri Mar 29 10:43:08 2019
Database: d:\Baza4\test.FDB
Replication is stopped due to critical error(s)
Replication error
Transaction 9 already exists

replication.log
WSSP670 (origin) Fri Mar 29 10:43:08 2019
Database: d:\Baza4\test.FDB
ERROR: Transaction 9 already exists

replication.log
REP (replica) Fri Mar 29 10:43:08 2019
Database: e:\Baza4\test_REP.FDB
ERROR: Transaction 9 already exists

isql.exe -ch WIN1251 -u SYSDBA -pas masterkey MASTER/3050:test

Database: MASTER/3050:test, User: SYSDBA
SQL> show tables;
There are no tables in this database
SQL> CREATE TABLE BRANCH (
CON> BRANCH_ID INTEGER NOT NULL,
CON> BRANCH_NAME VARCHAR(30) NOT NULL,
CON> COMMENT VARCHAR(50)
CON> );
SQL> commit;
SQL>

MASTER:
firebird.log
MASTER Fri Mar 29 14:07:42 2019
Database: d:\Baza4\test.FDB
Replication is stopped due to critical error(s)
Replication error
Dynamic SQL Error
SQL error code = -104
Unexpected end of command - line 1, column 1

replication.log
MASTER (origin) Fri Mar 29 14:07:42 2019
Database: d:\Baza4\test.FDB
ERROR: Dynamic SQL Error
SQL error code = -104
Unexpected end of command - line 1, column 1

REP - replication.log
REP5 (replica) Fri Mar 29 14:07:42 2019
Database: e:\Baza4\test_REP.FDB
ERROR: Dynamic SQL Error
SQL error code = -104
Unexpected end of command - line 1, column 1

WSSP675 Mon Apr 01 15:56:42 2019
INET/inet_error: read errno = 10054, server host = WSSP670, address = 192.168.53.107/3050


WSSP675 Mon Apr 01 15:56:42 2019
Database: e:\Baza4\test.FDB
Replication is stopped due to critical error(s)
Replication error
Error reading data from the connection.


WSSP675 Mon Apr 01 15:56:42 2019
REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
Uncommitted work may have been lost.
Error writing data to the connection.
send_packet/send


WSSP675 Mon Apr 01 15:56:42 2019
INET/inet_error: read errno = 10054, client host = wssp670, address = 192.168.53.107/52544, user = система