Oninit cdi / Archive
Talk to an expert →

DEADLOCK

Posted in 2009

Topics: Transactions, Locking & Isolation, Logging & Checkpoints

ANTONIO VARRICCHIO — — source: IIUG Forums & Mailing Lists

Hi, On occassion (3 times in a year), our Informix 7.31 system running SAP will dump a number of files within the /tmp filesystem. All files have the same naming convention ONSTAT_DEADLOCK and will be anywhere from 370Mb to 578Mb. Does anyone know under what conditions will the database dump these files. The online log shows 8Gb of logical logs were created during the time period, nothing else. Thank you, Antonio ls -lat ONSTAT* -rw-r--r-- 1 pr1adm sapsys 48586752 Jan 30 06:29 ONSTAT_DEADLOCK.9841.7 -rw-r--r-- 1 pr1adm sapsys 57829184 Jan 30 06:29 ONSTAT_DEADLOCK.9838.2 -rw-r--r-- 1 pr1adm sapsys 57833075 Jan 30 06:29 ONSTAT_DEADLOCK.9840.2 -rw-r--r-- 1 pr1adm sapsys 57822706 Jan 30 06:29 ONSTAT_DEADLOCK.9842.2 -rw-r--r-- 1 pr1adm sapsys 57814849 Jan 30 06:29 ONSTAT_DEADLOCK.9843.1 -rw-r--r-- 1 pr1adm sapsys 57815161 Jan 30 06:28 ONSTAT_DEADLOCK.9841.6 -rw-r--r-- 1 pr1adm sapsys 57839108 Jan 30 06:23 ONSTAT_DEADLOCK.9841.5 -rw-r--r-- 1 pr1adm sapsys 57839603 Jan 30 06:23 ONSTAT_DEADLOCK.9840.1 -rw-r--r-- 1 pr1adm sapsys 57841040 Jan 30 06:23 ONSTAT_DEADLOCK.9843.0 -rw-r--r-- 1 pr1adm sapsys 57841670 Jan 30 06:22 ONSTAT_DEADLOCK.9838.1 -rw-r--r-- 1 pr1adm sapsys 57840789 Jan 30 06:22 ONSTAT_DEADLOCK.9841.4 -rw-r--r-- 1 pr1adm sapsys 57766523 Jan 30 06:16 ONSTAT_DEADLOCK.9841.3 -rw-r--r-- 1 pr1adm sapsys 57752874 Jan 30 06:10 ONSTAT_DEADLOCK.9857.1 -rw-r--r-- 1 pr1adm sapsys 57772916 Jan 30 06:10 ONSTAT_DEADLOCK.9857.0 -rw-r--r-- 1 pr1adm sapsys 57843141 Jan 30 06:01 ONSTAT_DEADLOCK.9842.1 -rw-r--r-- 1 pr1adm sapsys 57843508 Jan 30 06:01 ONSTAT_DEADLOCK.9841.2 -rw-r--r-- 1 pr1adm sapsys 57838066 Jan 30 06:01 ONSTAT_DEADLOCK.9838.0 -rw-r--r-- 1 pr1adm sapsys 57839946 Jan 30 06:00 ONSTAT_DEADLOCK.9839.2 -rw-r--r-- 1 pr1adm sapsys 57829600 Jan 30 06:00 ONSTAT_DEADLOCK.9841.1 -rw-r--r-- 1 pr1adm sapsys 57834627 Jan 30 06:00 ONSTAT_DEADLOCK.9839.1 -rw-r--r-- 1 pr1adm sapsys 57815486 Jan 30 06:00 ONSTAT_DEADLOCK.9841.0 -rw-r--r-- 1 pr1adm sapsys 57762021 Jan 30 05:53 ONSTAT_DEADLOCK.9840.0 -rw-r--r-- 1 pr1adm sapsys 57827332 Jan 30 05:53 ONSTAT_DEADLOCK.9842.0 -rw-r--r-- 1 pr1adm sapsys 57826315 Jan 30 05:53 ONSTAT_DEADLOCK.9839.0

↪ replying to ANTONIO VARRICCHIO
Art Kagel — — source: IIUG Forums & Mailing Lists

IDS isn't creating them, they have nothing to do with the logical logs that are being referred to in the online log. Probably SAP is. What's in them? Art On Fri, Jan 30, 2009 at 3:25 PM, ANTONIO VARRICCHIO < antonio.varricchio@domtar.com> wrote: > Hi, > > On occassion (3 times in a year), our Informix 7.31 system running SAP will > dump a number of files within the /tmp filesystem. All files have the same > naming convention ONSTAT_DEADLOCK and will be anywhere from 370Mb to 578Mb. > Does anyone know under what conditions will the database dump these files. > The > online log shows 8Gb of logical logs were created during the time period, > nothing else. > > Thank you, > Antonio > > ls -lat ONSTAT* > -rw-r--r-- 1 pr1adm sapsys 48586752 Jan 30 06:29 ONSTAT_DEADLOCK.9841.7 > -rw-r--r-- 1 pr1adm sapsys 57829184 Jan 30 06:29 ONSTAT_DEADLOCK.9838.2 > -rw-r--r-- 1 pr1adm sapsys 57833075 Jan 30 06:29 ONSTAT_DEADLOCK.9840.2 > -rw-r--r-- 1 pr1adm sapsys 57822706 Jan 30 06:29 ONSTAT_DEADLOCK.9842.2 > -rw-r--r-- 1 pr1adm sapsys 57814849 Jan 30 06:29 ONSTAT_DEADLOCK.9843.1 > -rw-r--r-- 1 pr1adm sapsys 57815161 Jan 30 06:28 ONSTAT_DEADLOCK.9841.6 > -rw-r--r-- 1 pr1adm sapsys 57839108 Jan 30 06:23 ONSTAT_DEADLOCK.9841.5 > -rw-r--r-- 1 pr1adm sapsys 57839603 Jan 30 06:23 ONSTAT_DEADLOCK.9840.1 > -rw-r--r-- 1 pr1adm sapsys 57841040 Jan 30 06:23 ONSTAT_DEADLOCK.9843.0 > -rw-r--r-- 1 pr1adm sapsys 57841670 Jan 30 06:22 ONSTAT_DEADLOCK.9838.1 > -rw-r--r-- 1 pr1adm sapsys 57840789 Jan 30 06:22 ONSTAT_DEADLOCK.9841.4 > -rw-r--r-- 1 pr1adm sapsys 57766523 Jan 30 06:16 ONSTAT_DEADLOCK.9841.3 > -rw-r--r-- 1 pr1adm sapsys 57752874 Jan 30 06:10 ONSTAT_DEADLOCK.9857.1 > -rw-r--r-- 1 pr1adm sapsys 57772916 Jan 30 06:10 ONSTAT_DEADLOCK.9857.0 > -rw-r--r-- 1 pr1adm sapsys 57843141 Jan 30 06:01 ONSTAT_DEADLOCK.9842.1 > -rw-r--r-- 1 pr1adm sapsys 57843508 Jan 30 06:01 ONSTAT_DEADLOCK.9841.2 > -rw-r--r-- 1 pr1adm sapsys 57838066 Jan 30 06:01 ONSTAT_DEADLOCK.9838.0 > -rw-r--r-- 1 pr1adm sapsys 57839946 Jan 30 06:00 ONSTAT_DEADLOCK.9839.2 > -rw-r--r-- 1 pr1adm sapsys 57829600 Jan 30 06:00 ONSTAT_DEADLOCK.9841.1 > -rw-r--r-- 1 pr1adm sapsys 57834627 Jan 30 06:00 ONSTAT_DEADLOCK.9839.1 > -rw-r--r-- 1 pr1adm sapsys 57815486 Jan 30 06:00 ONSTAT_DEADLOCK.9841.0 > -rw-r--r-- 1 pr1adm sapsys 57762021 Jan 30 05:53 ONSTAT_DEADLOCK.9840.0 > -rw-r--r-- 1 pr1adm sapsys 57827332 Jan 30 05:53 ONSTAT_DEADLOCK.9842.0 > -rw-r--r-- 1 pr1adm sapsys 57826315 Jan 30 05:53 ONSTAT_DEADLOCK.9839.0 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. --001636c5ae0163aac50461b92e5d

↪ replying to Art Kagel
tilleul17@web.de — — source: IIUG Forums & Mailing Lists

Art Kagel wrote: > IDS isn't creating them, they have nothing to do with the logical logs that > are being referred to in the online log. Probably SAP is. What's in them? > > Art > > On Fri, Jan 30, 2009 at 3:25 PM, ANTONIO VARRICCHIO < > antonio.varricchio@domtar.com> wrote: > >> Hi, >> >> On occassion (3 times in a year), our Informix 7.31 system running SAP will >> dump a number of files within the /tmp filesystem. All files have the same >> naming convention ONSTAT_DEADLOCK and will be anywhere from 370Mb to 578Mb. >> Does anyone know under what conditions will the database dump these files. >> The >> online log shows 8Gb of logical logs were created during the time period, >> nothing else. >> >> Thank you, >> Antonio >> >> ls -lat ONSTAT* >> -rw-r--r-- 1 pr1adm sapsys 48586752 Jan 30 06:29 ONSTAT_DEADLOCK.9841.7 >> -rw-r--r-- 1 pr1adm sapsys 57829184 Jan 30 06:29 ONSTAT_DEADLOCK.9838.2 ... >> >> >> > ******************************************************************************* >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> > The SAP kernel for IDS does generate them, these files are meant to help identifiying the root cause of a deadlock, however, in practice the files are probably of little help. The files mostly contain a number of 'onstat' outputs. If you are not concerned about finding the root cause of a deadlock in SAP programs, you may delete them right awway. Rgds Tilman --

Glossary