If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > ONSTAT_DEADLOCK file

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 02-09-04, 17:36
stjacqd stjacqd is offline
Registered User
 
Join Date: Jul 2003
Location: Boisbriand, Qc, Canada
Posts: 25
ONSTAT_DEADLOCK file

Hello gurus

I did notice that I do have several files in my /tmp directory begin by:

Size Date file
7076745 Feb 9 15:55 ONSTAT_DEADLOCK.15805.0
7076380 Feb 9 15:55 ONSTAT_DEADLOCK.15805.1
7075779 Feb 9 15:56 ONSTAT_DEADLOCK.15805.2
7076680 Feb 9 15:56 ONSTAT_DEADLOCK.15805.3
7076975 Feb 9 15:56 ONSTAT_DEADLOCK.15805.4

That file looks like a dump of onstat.

Is anyone have an idea how those file are created an if there is anything I should do with it?

If onstat generat a deadlock, how can I know if there is not damaged done to the database?

Is there anything I have to do? If I am deleting those files is that can create some problems? And before deleting those files, what is the meaning of it?
Reply With Quote
  #2 (permalink)  
Old 03-23-04, 10:59
stjacqd stjacqd is offline
Registered User
 
Join Date: Jul 2003
Location: Boisbriand, Qc, Canada
Posts: 25
Re: ONSTAT_DEADLOCK file

I did post that question over a month ago.

Am I the only one that have that kind of question?

Did my question wasn't clear?

Or there is no body else than me that have that problem?

Is my question is that complicated?

Or it is that simple for the gurus that nobody took the time to answer it.

Is anyone out there that can give me some advice to solve that problem?

I will highly appreciate all comment.

A desperate guy

Quote:
Originally posted by stjacqd
Hello gurus

I did notice that I do have several files in my /tmp directory begin by:

Size Date file
7076745 Feb 9 15:55 ONSTAT_DEADLOCK.15805.0
7076380 Feb 9 15:55 ONSTAT_DEADLOCK.15805.1
7075779 Feb 9 15:56 ONSTAT_DEADLOCK.15805.2
7076680 Feb 9 15:56 ONSTAT_DEADLOCK.15805.3
7076975 Feb 9 15:56 ONSTAT_DEADLOCK.15805.4

That file looks like a dump of onstat.

Is anyone have an idea how those file are created an if there is anything I should do with it?

If onstat generat a deadlock, how can I know if there is not damaged done to the database?

Is there anything I have to do? If I am deleting those files is that can create some problems? And before deleting those files, what is the meaning of it?
Reply With Quote
  #3 (permalink)  
Old 03-24-04, 14:15
RobP RobP is offline
Registered User
 
Join Date: Mar 2004
Location: Netherlands
Posts: 183
Sory for the late answer but here some insight (I hope):

I don't know exactly how these are generated but I think they are created with some monitoring/debug feature, like your sysalarmprogram or a script someone has written. The format looks a lot like the assert failure files of informix (af7346732.0 for example).
Sorry that I can't tell this at this time (I have no machine available at home to check the evidence.sh script for this)

Just let me continue answering your other questions:

If onstat generat a deadlock, how can I know if there is not damaged done to the database?

Informix cannot have deadlock. Within the engine this is detected with an internal algorytm, between engines this is handled with a deadlock timeout. So no harm doen to your database.

Is there anything I have to do? If I am deleting those files is that can create some problems? And before deleting those files, what is the meaning of it?

Deleting it can do no harm. However it would be interesting to know where it is coming from.

Sorry that I couldn't answer all your questions,

Rob Prop
Reply With Quote
  #4 (permalink)  
Old 03-24-04, 17:29
stjacqd stjacqd is offline
Registered User
 
Join Date: Jul 2003
Location: Boisbriand, Qc, Canada
Posts: 25
Thank you RobP for your answer

At least, I do have something to work with now.

Quote:
Originally posted by RobP
Sory for the late answer but here some insight (I hope):

I don't know exactly how these are generated but I think they are created with some monitoring/debug feature, like your sysalarmprogram or a script someone has written. The format looks a lot like the assert failure files of informix (af7346732.0 for example).
Sorry that I can't tell this at this time (I have no machine available at home to check the evidence.sh script for this)

Just let me continue answering your other questions:

If onstat generat a deadlock, how can I know if there is not damaged done to the database?

Informix cannot have deadlock. Within the engine this is detected with an internal algorytm, between engines this is handled with a deadlock timeout. So no harm doen to your database.

Is there anything I have to do? If I am deleting those files is that can create some problems? And before deleting those files, what is the meaning of it?

Deleting it can do no harm. However it would be interesting to know where it is coming from.

Sorry that I couldn't answer all your questions,

Rob Prop
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On