Welcome to the new Gigaspaces XAP forum. To recover your account, please follow these instructions.

Ask Your Question
0

ActLog replication to Mysql is slow, eventually causing a lot of redo-logs overflowing to the disk and causing system failure - Crash with error :RedoLogCapacityExceededException

ActLog replication to Mysql is slow (as compared to MSSQL server) , eventually causing a lot of redo-logs overflowing to the disk and causing system failure - Crash with error RedoLogCapacityExceededException

The customer has a lot of projects running in parallel.

Customer has experienced crash in production environment. They have provided logs,we do observe redo-log size crossed above a threshold messages in the logs.

See attached production logs for details of logs investigated.

asked 2018-11-22 05:23:39 -0600

rajp gravatar image
edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
0

Hi, 1. redolog capacity can be configured and redolog can overflow to disk see:https://docs.gigaspaces.com/xap/14.0/admin/controlling-the-replication-redo-log.html 2. If the application crashed due to OOM you must change the above configuration. 3. MySql is slow, they might try to see root cause for that.

Regards, Ester.

answered 2018-11-26 02:57:57 -0600

Ester gravatar image
edit flag offensive delete link more

Comments

Thanks for your response.Application crashed due to RedoLogCapacityExceededException We have not get any OOM error here Following are the PU.xml we have used.

<beans beans="" http:="" schema="" spring-beans.xsd"="" www.springframework.org="" xmlns="http://www.springframework.org/schema/beans" xmlns:context="http://www.springframework.org/schema/context" xmlns:os-core="http://www.openspaces.org/schema/core" xmlns:os-events="http://www.openspaces.org/schema/events" xmlns:os-jms="http://www.openspaces.org/schema/jms" xmlns:os-remoting="http://www.openspaces.org/schema/remoting" xmlns:os-sla="http://www.openspaces.org/schema/sla" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemalocation="http://www.springframework.org/schema/beans &lt;a href=">http://www.springframework.org/schema... http://www.springframework.org/schema...http://www.springframework.org/schema...http://www.openspaces.org/schema/corehttp://www.openspaces.org/schema/core...http://www.openspaces.org/schema/eventshttp://www.openspaces.org/schema/even...http://www.openspaces.org/schema/remo...http://www.openspaces.org/schema/remo...http://www.openspaces.org/schema/slahttp://www.openspaces.org/schema/sla/...http://www.openspaces.org/schema/jmshttp://www.openspaces.org/schema/jms/...></beans>

<os-sla:sla number-of-instances="1"/>

<bean id="hibernateSpaceSynchronizationEndpoint" class="org.openspaces.persistency.hibernate.DefaultHibernateSpaceSynchronizationEndpointFactoryBean">
    <property name="sessionFactory" ref="sessionFactory"/>
</bean>

<os-core:space id="mirrorSpace" url="/./mirror-service" schema="mirror" space-sync-endpoint="hibernateSpaceSynchronizationEndpoint">
    <os-core:properties>
    <props>
        <prop key="space-config.mirror-service.cluster.name">MAGIC_INFO</prop>
        <prop key="space-config.mirror-service.cluster.partitions">${magic_info.partitions}</prop>
        <prop key="space-config.mirror-service.cluster.backups-per-partition">${magic_info.backups_per_partition}</prop>
        <prop key="space-config.mirror-service.operation-grouping">group-by-replication-bulk</prop>
    </props>
    </os-core:properties>
</os-core:space>
<bean id="dataSource" class="com.magicsoftware.xpi.server.services.SpaceInfoDataSource" destroy-method="close" scope="singleton">
    <property name="driverClassName" value="${driverClassName}" />
    <property name="url"
        value="${url};${property1};${property2};${property3};${property4};${property5};${property6};${property7};${property8};${property9};${property10}"/>
    <property name="username" value="${username}" />
    <property name="password" value="${password}" />
</bean>
<bean id="sessionFactory" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
    <property name="dataSource" ref="dataSource"/>

    <property name="annotatedClasses">
        <list>
            <value>com.magicsoftware.xpi.info.data.ActivityLog</value>
            <value>com.magicsoftware.xpi.info.data.ODSData</value>
        </list>
    </property>

    <property name="hibernateProperties">
        <props>
        <prop key="hibernate.default_schema">${hibernate.default_schema}</prop>
        <prop key="hibernate.dialect">${hibernate.dialect}</prop>
        <prop key="hibernate.connection.useUnicode">true</prop>

</props> </property>
</bean>

</beans>

Do you have any further advice on what is going wrong? Thanks rajp

rajp gravatar imagerajp ( 2018-12-03 23:58:16 -0600 )edit

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Question Tools

1 follower

Stats

Asked: 2018-11-21 08:05:35 -0600

Seen: 134 times

Last updated: Nov 26