ER Issue - txns stuck in send queue

Posted in 2008

Topics: Installation, Setup & Upgrades, Storage & Space Management, Platform-Specific Issues

PETE DICKSON — Sat, 23 Feb 2008 22:32:06 — source: IIUG Forums & Mailing Lists

Hi, we are using IDS ver 9.21.UC5XF (AIX 5.2 talking to AIX 4.3.3),(yeah, I know, I don't wanna hear "it's old, upgrade", we will be upgrading this year, long story), using ER. We had a system crash monday and had to end up rebuilding ER via the CDRBLOCKOUT steps. We were able to rebuild everything, took us awhile, but got it done. There are 2 systems replicating both ways. Last nite, ROOTDBS filled up to 99% on BOTH servers and we added a 256 meg chunk to both servers. That cleared the ROOTDBS issue, but ER was not talking either way. This morning (Saturday), we rebooted both servers. All users are currently on one server (west). This server sent all the data from west to the other server (east). The issue now is that nothing is flowing from east to west. It sits in the trg_send queue. We believe the only option at this point is to blow away ER again with "cdr delete" steps and rebuild ER from stratch again. I believe something got messed up when rootdbs filled up. Anybody ever run into this before? We're going to be whacking and re-buildin' shortly. Pete

↪ replying to PETE DICKSON

PETE DICKSON — Sat, 01 Mar 2008 15:14:07 — source: IIUG Forums & Mailing Lists

Well thanks for all the "expert" advice. We blew away ER and rebuilt from scratch.

Glossary

IDS (Informix Dynamic Server)