on 08-18-2015 9:33 PM
Hi
I'm getting this email alert from the HANA tenant database:
snapshot : 2015-08-18 16:42:52.0000000
Alert Name : Connection between systems in system replication setup
Rating : Error
Details : At 2015-08-18 18:35:45.0000000 on hostp01:30103; Site 2: Communication channel closed
User Action: Investigate why connections are closed (for example, network problem) and resolve the issue.
I see more alerts in the trace files, don't know if they are related:
Tenant's database trace files:
[178728]{419183}[119/-1] 2015-08-18 20:56:11.225670 e cePlanExec cePlanExecutor.cpp(07183) : Error during Plan execution of model _SYS_STATISTICS:_SYS_SS_CE_1402084_140190768844608_4_INS (-1), reason: executor: plan operation failed;CalculationNode ($$_SYS_SS2_RESULT$$) -> operation (CustomLOp):Compilation failed; OpenChannelException at network layer:
message: an error occured while opening the channel
info: connection refused
param: 127.0.0.1:30110
Replication database trace files:
nameserver_alert_hostp01.trc
[42096]{-1}[-1/-1] 2015-08-18 18:45:18.355758 e TrexNet EndPoint.cpp(00260) : ERROR: failed to open channel 127.0.0.1:30107! reason: (connection refused)
Please assist.
This seems to be communication problem between your primary and secondary. Check if your secondary system is up and running.
Mostly the above error will cause due to un avaibality of secondary system.
Manually start the secondary system if it is down and see if the error ocurs again.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Thanks, the secondary database is up and running, and in the primary's HANA studio on the System Replication TAB the status is ACTIVE, and the LAST_LOG_POSTITION_TIME is up to date.
Unfortunately I still continue to receive the alert above every 5 min.
What else should I check?
Kind Regards
Willem
Can you please set the below parameter keep_old_style_alert = false (default=true) . I belive you are still getting old fashion alerts.
See if it resolves the issue. If the issue still exists . Please execute below commands and paste the output
hdbcons -e hdbindexserver "replication info"
lsof –n –p
Regards,
Pavan Gunda
Hi Willem,
Do you see the communication channel closed errors on the SYSTEM Replication TAB of the SYSTEMDB?
Do you get this error after SYSTEM Replication has completed the Full Sync of data or at the very first stage of System replication?
The common cause of the communication channel closed errors is a loss of connectivity or the unavailability of the secondary tier of system replication, please provide more details to understand your errors
Sunil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.