DB_VISTA error -24

[Anonymous]

Hi clovertechies,

yesterday in one of our test sites, several processes went down after the maintenance. During the maintenance I take the sites down, cleanup and restarted it.

In this morning, when I came I noticed that several threads and processes down. In looking at the processes directory, I see following error.  The processes that went down are not communicating in inter-processes communication. All of them were configured within individual separate processes.

That mean therad_A to Thread_b (process1) and the like.

Has anyone seen similar errors? Does anyone what is the cause of it?

11/30/2006 16:12:06 [dbi :dbi :ERR /0:hmm_ord_adtmfn_in] Db_Vista database error  -24: ‘PROGRAMMER/USER error: -24

attempt to access unlocked set/record

C errno = 32: Broken pipe’

11/30/2006 16:12:06 [dbi :dbi :ERR /0:hmm_ord_adtmfn_in] dbiMidExists: status dt

_keyfind = -24

11/30/2006 16:12:06 [dbi :dbi :ERR /0:hmm_ord_adtmfn_in] Db_Vista database error  -24: ‘PROGRAMMER/USER error: -24

attempt to access unlocked set/record

C errno = 32: Broken pipe

Thanks in advance.

Reggie

Topic

[Russ Ross]

I’m not sure if any of these will help but here is my how to file I’ve used with success on occasion to solve database issues.

Code:

How to clear HCI database
————————-

lmclear -u TEST -mp (if the user locks the database by doing ctrl-c during a hcidbdump -r

lmclear -s -mp (that gives you a list of active database users)

hcilmclear -p ris    (if the ris process hangs the database)

hcidbinit -fi
keybuild rlog; dchain rlog
keybuild elog; dchain elog

I have not had a database issues in a long time and I’m not sure if some of these are outdated commands.

Nor can I say that I have any idea what a -24 error really means.

About the only database problem we still ever see is doing a ctrl-c before hcidbdump -r finishes.

For those that don’t know always let any hcidbdump output to screen finish and don’t break out.

Russ Ross
RussRoss318@gmail.com

[Anonymous]

Thanks Russ.

I had to shutdown the entire site and bring them up and I have not seen any db-vista error for the last 3 days.

Thanks

Reggie

[Author]

Replies