SAP Knowledge Base Article - Preview

2618490 - Rep Agent reports "The size of the stream buffer is too small (<value1> bytes" with Error 406 and 9414 - SAP ASE

Symptom

  • Implement the HADRS environment, in some circumstances, the repagent may see the 406 & 9414 errors in the errorlog with the below messages.
  • The following messages are seen when replicating data in sync mode:


Rep Agent detected error 406 with message 'CI API call DropLastMetaObj() failed ' at line 9670 in file ra_ci_cmd.c.
RepAgent(9): Warning: The size of the stream buffer is too small (1572864 bytes). Use sp_config_rep_agent 'xxxxxxxxx', 'stream buffer size', '<new_value>' to increase it.
00:0045:00000:00098:2018/03/08 11:59:46.81 server Error: 9414, Severity: 20, State: 3
00:0045:00000:00098:2018/03/08 11:59:46.81 server RepAgent(9): Streaming replication distribution CI Library error -3 with severity 2 and message 'Package(c000000908fed990, 6:96, 1179648:0:0) buffer is depleted. Total XXXXXXX, used XXXXXX, requesting XXXXXX.'. Rep Agent detected error 406 with message 'CI API call DropLastMetaObj() failed ' at line 9670 in file ra_ci_cmd.c.
00:0045:00000:00098:2018/03/08 11:59:46.81 server RepAgent(9): Warning: The size of the stream buffer is too small (1572864 bytes). Use sp_config_rep_agent 'xxxxxxxxx', 'stream buffer size', '<new_value>' to increase it.
00:0045:00000:00049:2018/03/08 11:59:46.81 server Shutting down Rep Agent for database, 'xxxxxxxxx' (dbid = 9).

  • Even if you increase the 'stream buffer size' the errors may keep on coming:
    sp_config_rep_agent 'xxxxxxxxx', 'stream buffer size', '<new value>'

The old value of this property is '1572864', the new value is '3145728'. The changes will take effect the next time the Replication Agent thread is started.
00:0054:00000:00431:2018/03/08 12:30:48.54 server Started Rep Agent on database, 'xxxxxxxxx' (dbid = X) using streaming replication (sync mode) with library version: SAP CI-Library/16.0/EBF 27614 SP03 PL03 rs160sp03pl03/CI 1.10.0/Intel Itanium/HP-UX B.11.31/2191/OPT64/Sun Dec 10 19:01:51 2017
00:0037:00000:00965:2018/03/08 12:30:48.57 kernel (CI-Info) Message: 1002, Severity: 2 (xxxxxxxxx)STAllocSendBuf: Failed to allocate xdr buffer size 2359304.
00:0037:00000:00965:2018/03/08 12:30:48.57 kernel (CI-Info) Message: 1002, Severity: 2 (xxxxxxxxx)Failed to allocate package, ask 200, allocated 38, maxDObj 100, szPkgBuf 786432, szXmitBuf 2359296
00:0045:00000:00965:2018/03/08 12:30:50.60 server RepAgent(X): Autoscaling: Warning: The maximum configured buffer pool size:8 is less than the allocated buffer pool size:200. The maximum is set to 200.


Read bytes" with Error 406 and 9414 - SAP ASE">more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 16.0

Keywords

813994, CR#813994, CR813994, repagent, DropLastMetaObj, HADRS, Always-on , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.