Question Re: remote checkpoint failure in Technology Q&A

remote checkpoint failure

former_member280303 — Thu, 15 Jan 2015 17:29:51 GMT

Hi all,

Yesterday a frind on mine received error 3514 "command dump transaction is aborted because of the error: remote checkpoint failure"

Remote checkpoint failed on instance 2 for dbid 30 with reply_status -1, reply_plasterror -1.

He asked me about this error and I did not find any information related. He is working with ASE CE 15.7 EBF 22238 SP 121 AIX .

Does anyone have any idea of what could happen?

Thanks in advance

Luz Rodriguez

Re: remote checkpoint failure

jong-un_seo — Fri, 16 Jan 2015 04:51:25 GMT

Hi Luz Rodriguez,

Dump tran command is fired distributed checkpoint for each node
and then it can be processing continuously after recieving successful message from remote node.

Please check both nodes to have an incompleted transaction.

select * from master..syslogshold
go

And if there is no one, run checkpoint command for each node and then try to run dump tran command.

Please check ASE CE User's Guilde(SyBooks Online) for distributed checkpoint.

Thanks,
Jongun Seo

Re: remote checkpoint failure

former_member280303 — Tue, 03 Feb 2015 18:21:25 GMT

Hi Jongun,

I read the information and it makes sense. Unfortunately they did not search the old transactions.

I send the link, they are going to verify it next time.

Regards,

Luz Rodriguez