Hi All,

We are currently running replication between several sites (hub and
spoke). We are using the following setup:

Replicator: IBReplicator v2.1.11-4 for Linux.
Firebird Version: Firebird 2.0.1 CS
Operating System: Centos release 4.5 (final)

The following error appears and disappears randomly for a variable
length of time.

ErrorNo: 21 - no permission for (ACL unrecognized) access to
security_class SQL$REPL_LOG This user does not have privilege to
perform this operation on this object.

Does anybody know what this error could be? I have included a full
description of the problem below.

Thanks and Regards,
David

===================================================================

In this configuration, the head office is the hub and at the end of
each spoke is a branch. Each branch has its own configuration database
and runs its own replicator which pulls and pushes data from the head
office (bi-directional). Therefore, branch1 would have the following
schemas:

1) Branch1->HO
2) HO->Branch1

Generally, replication runs without too many difficulties, however,
there is one problem that I cannot resolve or find any information
about. This error seems to occur randomly, last for a random period of
time and then resolve itself without any intervention. The only way to
manually resolve the issue so far appears to be a backup and restore.
The problem occurs when replicating in either direction (ie:
HO->Branch1 or Branch1->HO), but oddly enough only one schema displays
the problem at a time - the other replicates without trouble.


Below an example from the replicate.log (log level 5):


Replicate - 1, Branch1 -> HeadOffice
Old user - REPL_1, new user - sysdba
Old role - administrator, new role - ADMINISTRATOR
Must reconnect...
Fri Oct 19 12:17:40 2007: Disconnected from DB:
127.0.0.1:/pperfect/sqldata/database.gdb
Fri Oct 19 12:17:40 2007: Connected to DB:
127.0.0.1:/pperfect/sqldata/database.gdb
Char Set: NONE; Dialect: 3
Old user - SYSDBA, new user - REPL_1
Old role - administrator, new role - ADMINISTRATOR
Must reconnect...
Fri Oct 19 12:17:41 2007: Disconnected from DB:
headoffice.samplesite.com:/pperfect/sqldata/database.gdb
Fri Oct 19 12:17:41 2007: Connected to DB:
headoffice.samplesite.com:/pperfect/sqldata/database.gdb
Char Set: NONE; Dialect: 3
Insert into WAYEDIT 2007-10-19*10:21:12.9260*2703963081
Fri Oct 19 12:17:43 2007: ErrorNo: 21 - no permission for (ACL
unrecognized)
access to security_class SQL$REPL_LOG
This user does not have privilege to perform this operation on this
object.
STATISTICS FOR SOURCE DATABASE:
0 Hours, 0 Minutes, 0 Seconds
Inserts : 0
Updates : 0
Deletes : 0
Conflicts: 0
Errors : 1


Below an example from the replicate.log (debug mode):

Replicate - 1, Branch1 -> HeadOffice
TIBDatabase::Connect
Old user - REPL_1, new user - sysdba
Old role - administrator, new role - ADMINISTRATOR
Must reconnect...
TIBDatabase::InternalDisconnect
Fri Oct 19 12:25:54 2007: Disconnected from DB:
127.0.0.1:/pperfect/sqldata/database.gdb
Trying to connect with UN = sysdba, UP = xxxxxxxx, UR = ADMINISTRATOR
Fri Oct 19 12:25:54 2007: Connected to DB:
127.0.0.1:/pperfect/sqldata/database.gdb
Char Set: NONE; Dialect: 3
TIBDatabase::Connect
Old user - SYSDBA, new user - REPL_1
Old role - administrator, new role - ADMINISTRATOR
Must reconnect...
TIBDatabase::InternalDisconnect
Fri Oct 19 12:25:55 2007: Disconnected from DB:
headoffice.samplesite.com:/pperfect/sqldata/database.gdb
Trying to connect with UN = REPL_1, UP = xxxxxxxx, UR = ADMINISTRATOR
Fri Oct 19 12:25:55 2007: Connected to DB:
headoffice.samplesite.com:/pperfect/sqldata/database.gdb
Char Set: NONE; Dialect: 3
TIBDatabase::Disconnect
TIBDatabase::Disconnect
REPLINFO::Start IB-IB transaction
Start IB-IB transaction
IB_PrepareAndExecuteLogSelect
Logstmt need to be prepared
IB_FetchLogRow
TRelation::AssureFields
Insert into WAYEDIT 2007-10-19*10:21:12.9260*2703963081
TIBDatabase::ExecuteSelect
SetKeys0
Set string value (length 10) "2007-10-19" to field 0
Set string value (length 13) "10:21:12.9260" to field 1
Set string value (length 10) "2703963081" to field 2
TIBDatabase::PrepareInsert
ShowIBStatus
Fri Oct 19 12:25:56 2007: ErrorNo: 21 - no permission for (ACL
unrecognized)
access to security_class SQL$REPL_LOG
This user does not have privilege to perform this operation on this
object.
Rollback IB Transaction
DisplayDBStats
STATISTICS FOR SOURCE DATABASE:
0 Hours, 0 Minutes, 0 Seconds
Inserts : 0
Updates : 0
Deletes : 0
Conflicts: 0
Errors : 1