Cchetty: 1 revision

2011-10-08T20:19:33Z

1 revision

← Older revision

Revision as of 20:19, 8 October 2011

Gloriaxu: /* Database no longer accepts data */

2011-09-13T21:00:26Z

Database no longer accepts data

New page

== Database no longer accepts data ==

{| border="1"
|-
! '''Problem Summary'''
|
The Cisco MediaSense Enterprise Replication Smart Blob (Binary Large Object) space, referred to as ora_ersb, does not accept any more data.<br>

|-
! '''Error Message'''
|
Informix log:
<pre>08/27/11 19:20:56 CDR QUEUER: Send Queue space is FULL - waiting for space in CDR_QDATA_SBSPACE
08/27/11 19:21:57 CDR WARNING:RQM sbspace ora_ersb is full, Please add the space. error number = 13
</pre>
Application log:
<pre>
java.sql.BatchUpdateException: Long transaction aborted.
</pre>
|-
! '''Possible Cause'''
|
When the primary or secondary server is down, data continues to be written to the other server. Data replication does not happen until the affected server starts running again. Until that point, the data is accumulated in a designated space on the hard disk (in this case, the ora_ersb). When the ora_ersb is full, no more data can be written to the surviving server.

|-
! '''Recommended Action'''
|
The only viable action is to bring up the affected node. You could also try to delete some existing data to make room for new data. See the Considerations for Failure Conditions section in the Cisco MediaSense Installation and Administration Guide.<br>

The following two actions will not solve this problem:

#Disabling replication: curently, Cisco MediaSense does not have a CLI for this action.
#Adding more space to ora_ersb requires root access and Database Administrator privileges.

|-
! '''Release'''
|
Release 8.5(3).

|-
! '''Associated CDETS #'''
|
None.

|}

<br>

[[Category:Cisco_MediaSense,_Release_8.5]]

Database: Database no longer accepts data - Revision history

Cchetty: 1 revision

Gloriaxu: /* Database no longer accepts data */