Logging conflicted queries on deadlocks - Mailing list pgsql-hackers
| From | Parag Goyal |
|---|---|
| Subject | Logging conflicted queries on deadlocks |
| Date | |
| Msg-id | 7d94d6630901220115o215c5a0bg78cd1ac44f07f97e@mail.gmail.com Whole thread Raw |
| List | pgsql-hackers |
Can you please help me solve the problem of ERROR deadlock detected
This is the log incurred in postgressqlXXXX.log
This is the log incurred in postgressqlXXXX.log
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "displet"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "screenscrapesource"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "squidmodeconfiguration"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "videosource"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "websource"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "decorator"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "display"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "application"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "audiodecorator"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "borderdecorator"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "display_snapshot"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "imagedecorator"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "labeldecorator"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "statusborderdecorator"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "window"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "applicationwindow"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "datetimedecorator"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "logodecorator"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "perspectivewindow"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "snapshot_window"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "sourcenamedecorator"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "statictextdecorator"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "statusborderdecorator_linestyle"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "statusimagedecorator"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "statuslabeldecorator"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "display"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "perspective"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "snapshot"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "application"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "display_snapshot"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "displet"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "message"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "perspectivewindow"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "snapshot_window"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "window"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "applicationwindow"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "decorator"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "audiodecorator"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "borderdecorator"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "imagedecorator"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "labeldecorator"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "statusborderdecorator"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "datetimedecorator"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "logodecorator"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "sourcenamedecorator"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "statictextdecorator"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "statusborderdecorator_linestyle"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "statusimagedecorator"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "statuslabeldecorator"
2009-01-21 15:47:21 IST NOTICE: truncate cascades to table "systemvariablebinding"
2009-01-21 15:47:21 IST NOTICE: truncate cascades to table "borderdecorator"
2009-01-21 15:47:21 IST NOTICE: truncate cascades to table "statusborderdecorator_linestyle"
2009-01-21 15:47:21 IST NOTICE: truncate cascades to table "display"
2009-01-21 15:47:21 IST NOTICE: truncate cascades to table "display_snapshot"
2009-01-21 15:47:21 IST NOTICE: truncate cascades to table "snapshot_window"
2009-01-21 15:47:21 IST NOTICE: truncate cascades to table "application"
2009-01-21 15:47:21 IST NOTICE: truncate cascades to table "window"
2009-01-21 15:47:21 IST NOTICE: truncate cascades to table "applicationwindow"
2009-01-21 15:47:21 IST NOTICE: truncate cascades to table "perspectivewindow"
2009-01-21 15:53:29 IST NOTICE: truncate cascades to table "displet"
2009-01-21 15:53:29 IST NOTICE: truncate cascades to table "screenscrapesource"
2009-01-21 15:53:30 IST ERROR: deadlock detected
2009-01-21 15:53:30 IST DETAIL: Process 12648 waits for AccessShareLock on relation 156727 of database 16403; blocked by process 11632.
Process 11632 waits for AccessExclusiveLock on relation 156745 of database 16403; blocked by process 12648.
2009-01-21 15:53:30 IST STATEMENT: select squidmodec0_.mId as mId24_5_, squidmodec0_.mHoverDelay as mHoverDe2_24_5_, squidmodec0_.mBorderWidth as mBorderW3_24_5_, squidmodec0_.mEnabled as mEnabled24_5_, squidmodec0_.mLeftSource_mId as mLeftSou8_24_5_, squidmodec0_.mRightSource_mId as mRightSo6_24_5_, squidmodec0_.mTopSource_mId as mTopSource7_24_5_, squidmodec0_.mBottomSource_mId as mBottomS5_24_5_, source1_.mId as mId32_0_, source1_.mName as mName32_0_, source1_.mType as mType32_0_, source1_.mTag as mTag32_0_, source1_.mDescription as mDescrip5_32_0_, source1_.mOnline as mOnline32_0_, source1_.mAcknowledged as mAcknowl7_32_0_, source1_.mAutoDetected as mAutoDet8_32_0_, source1_.mTimezone as mTimezone32_0_, source1_.width as width32_0_, source1_.height as height32_0_, source1_1_.mHost as mHost33_0_, source1_1_.mPassword as mPassword33_0_, source1_1_.mPort as mPort33_0_, source1_1_.mTargetType as mTargetT5_33_0_, source1_1_.mDesktopIdent as mDesktop6_33_0_, source1_1_.x as x33_0_, source1_1_.y as y33_0_, source1_1_.width as width33_0_, source1_1_.height as height33_0_, source1_1_.mWindowTitle as mWindow11_33_0_, source1_1_.mManualUpdateMode as mManual12_33_0_, source1_1_.mUpdateInterval as mUpdate13_33_0_, source1_2_.mURL as mURL34_0_, source1_2_.mAudioDelay as mAudioDe3_34_0_, source1_2_.mAudioURL as mAudioURL34_0_, source1_2_.mRemoteDesktopHost_mId as mRemoteD5_34_0_, source1_3_.mURL as mURL35_0_, case when source1_1_.mId is not null then 1 when source1_2_.mId is not null then 2 when source1_3_.mId is not null then 3 when source1_.mId is not null then 0 end as clazz_0_, screenscra2_.mId as mId32_1_, screenscra2_1_.mName as mName32_1_, screenscra2_1_.mType as mType32_1_, screenscra2_1_.mTag as mTag32_1_, screenscra2_1_.mDescription as mDescrip5_32_1_, screenscra2_1_.mOnline as mOnline32_1_, screenscra2_1_.mAcknowledged as mAcknowl7_32_1_, screenscra2_1_.mAutoDetected as mAutoDet8_32_1_, screenscra2_1_.mTimezone as mTimezone32_1_, screenscra2_1_.width as width32_1_, screenscra2_1_.height as height32_1_, screenscra2_.mHost as mHost33_1_, screenscra2_.mPassword as mPassword33_1_, screenscra2_.mPort as mPort33_1_, screenscra2_.mTargetType as mTargetT5_33_1_, screenscra2_.mDesktopIdent as mDesktop6_33_1_, screenscra2_.x as x33_1_, screenscra2_.y as y33_1_, screenscra2_.width as width33_1_, screenscra2_.height as height33_1_, screenscra2_.mWindowTitle as mWindow11_33_1_, screenscra2_.mManualUpdateMode as mManual12_33_1_, screenscra2_.mUpdateInterval as mUpdate13_33_1_, source3_.mId as mId32_2_, source3_.mName as mName32_2_, source3_.mType as mType32_2_, source3_.mTag as mTag32_2_, source3_.mDescription as mDescrip5_32_2_, source3_.mOnline as mOnline32_2_, source3_.mAcknowledged as mAcknowl7_32_2_, source3_.mAutoDetected as mAutoDet8_32_2_, source3_.mTimezone as mTimezone32_2_, source3_.width as width32_2_, source3_.height as height32_2_, source3_1_.mHost as mHost33_2_, source3_1_.mPassword as mPassword33_2_, source3_1_.mPort as mPort33_2_, source3_1_.mTargetType as mTargetT5_33_2_, source3_1_.mDesktopIdent as mDesktop6_33_2_, source3_1_.x as x33_2_, source3_1_.y as y33_2_, source3_1_.width as width33_2_, source3_1_.height as height33_2_, source3_1_.mWindowTitle as mWindow11_33_2_, source3_1_.mManualUpdateMode as mManual12_33_2_, source3_1_.mUpdateInterval as mUpdate13_33_2_, source3_2_.mURL as mURL34_2_, source3_2_.mAudioDelay as mAudioDe3_34_2_, source3_2_.mAudioURL as mAudioURL34_2_, source3_2_.mRemoteDesktopHost_mId as mRemoteD5_34_2_, source3_3_.mURL as mURL35_2_, case when source3_1_.mId is not null then 1 when source3_2_.mId is not null then 2 when source3_3_.mId is not null then 3 when source3_.mId is not null then 0 end as clazz_2_, source4_.mId as mId32_3_, source4_.mName as mName32_3_, source4_.mType as mType32_3_, source4_.mTag as mTag32_3_, source4_.mDescription as mDescrip5_32_3_, source4_.mOnline as mOnline32_3_, source4_.mAcknowledged as mAcknowl7_32_3_, source4_.mAutoDetected as mAutoDet8_32_3_, source4_.mTimezone as mTimezone32_3_, source4_.width as width32_3_, source4_.height as height32_3_, source4_1_.mHost as mHost33_3_, source4_1_.mPassword as mPassword33_3_, source4_1_.mPort as mPort33_3_, source4_1_.mTargetType as mTargetT5_33_3_, source4_1_.mDesktopIdent as mDesktop6_33_3_, source4_1_.x as x33_3_, source4_1_.y as y33_3_, source4_1_.width as width33_3_, source4_1_.height as height33_3_, source4_1_.mWindowTitle as mWindow11_33_3_, source4_1_.mManualUpdateMode as mManual12_33_3_, source4_1_.mUpdateInterval as mUpdate13_33_3_, source4_2_.mURL as mURL34_3_, source4_2_.mAudioDelay as mAudioDe3_34_3_, source4_2_.mAudioURL as mAudioURL34_3_, source4_2_.mRemoteDesktopHost_mId as mRemoteD5_34_3_, source4_3_.mURL as mURL35_3_, case when source4_1_.mId is not null then 1 when source4_2_.mId is not null then 2 when source4_3_.mId is not null then 3 when source4_.mId is not null then 0 end as clazz_3_, source5_.mId as mId32_4_, source5_.mName as mName32_4_, source5_.mType as mType32_4_, source5_.mTag as mTag32_4_, source5_.mDescription as mDescrip5_32_4_, source5_.mOnline as mOnline32_4_, source5_.mAcknowledged as mAcknowl7_32_4_, source5_.mAutoDetected as mAutoDet8_32_4_, source5_.mTimezone as mTimezone32_4_, source5_.width as width32_4_, source5_.height as height32_4_, source5_1_.mHost as mHost33_4_, source5_1_.mPassword as mPassword33_4_, source5_1_.mPort as mPort33_4_, source5_1_.mTargetType as mTargetT5_33_4_, source5_1_.mDesktopIdent as mDesktop6_33_4_, source5_1_.x as x33_4_, source5_1_.y as y33_4_, source5_1_.width as width33_4_, source5_1_.height as height33_4_, source5_1_.mWindowTitle as mWindow11_33_4_, source5_1_.mManualUpdateMode as mManual12_33_4_, source5_1_.mUpdateInterval as mUpdate13_33_4_, source5_2_.mURL as mURL34_4_, source5_2_.mAudioDelay as mAudioDe3_34_4_, source5_2_.mAudioURL as mAudioURL34_4_, source5_2_.mRemoteDesktopHost_mId as mRemoteD5_34_4_, source5_3_.mURL as mURL35_4_, case when source5_1_.mId is not null then 1 when source5_2_.mId is not null then 2 when source5_3_.mId is not null then 3 when source5_.mId is not null then 0 end as clazz_4_ from SquidModeConfiguration squidmodec0_ left outer join Source source1_ on squidmodec0_.mLeftSource_mId=source1_.mId left outer join ScreenScrapeSource source1_1_ on source1_.mId=source1_1_.mId left outer join VideoSource source1_2_ on source1_.mId=source1_2_.mId left outer join WebSource source1_3_ on source1_.mId=source1_3_.mId left outer join ScreenScrapeSource screenscra2_ on source1_2_.mRemoteDesktopHost_mId=screenscra2_.mId left outer join Source screenscra2_1_ on screenscra2_.mId=screenscra2_1_.mId left outer join Source source3_ on squidmodec0_.mRightSource_mId=source3_.mId left outer join ScreenScrapeSource source3_1_ on source3_.mId=source3_1_.mId left outer join VideoSource source3_2_ on source3_.mId=source3_2_.mId left outer join WebSource source3_3_ on source3_.mId=source3_3_.mId left outer join Source source4_ on squidmodec0_.mTopSource_mId=source4_.mId left outer join ScreenScrapeSource source4_1_ on source4_.mId=source4_1_.mId left outer join VideoSource source4_2_ on source4_.mId=source4_2_.mId left outer join WebSource source4_3_ on source4_.mId=source4_3_.mId left outer join Source source5_ on squidmodec0_.mBottomSource_mId=source5_.mId left outer join ScreenScrapeSource source5_1_ on source5_.mId=source5_1_.mId left outer join VideoSource source5_2_ on source5_.mId=source5_2_.mId left outer join WebSource source5_3_ on source5_.mId=source5_3_.mId where squidmodec0_.mId=$1
2009-01-21 15:53:30 IST ERROR: deadlock detected
2009-01-21 15:53:30 IST DETAIL: Process 11632 waits for AccessExclusiveLock on relation 156745 of database 16403; blocked by process 12832.
Process 12832 waits for AccessShareLock on relation 156727 of database 16403; blocked by process 11632.
2009-01-21 15:53:30 IST STATEMENT: TRUNCATE TABLE Source CASCADE
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "displet"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "screenscrapesource"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "squidmodeconfiguration"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "videosource"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "websource"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "decorator"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "display"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "application"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "audiodecorator"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "borderdecorator"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "display_snapshot"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "imagedecorator"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "labeldecorator"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "statusborderdecorator"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "window"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "applicationwindow"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "datetimedecorator"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "logodecorator"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "perspectivewindow"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "snapshot_window"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "sourcenamedecorator"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "statictextdecorator"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "statusborderdecorator_linestyle"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "statusimagedecorator"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "statuslabeldecorator"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "display"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "perspective"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "snapshot"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "application"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "display_snapshot"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "displet"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "message"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "perspectivewindow"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "snapshot_window"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "window"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "applicationwindow"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "decorator"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "screenscrapesource"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "squidmodeconfiguration"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "videosource"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "websource"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "decorator"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "display"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "application"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "audiodecorator"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "borderdecorator"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "display_snapshot"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "imagedecorator"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "labeldecorator"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "statusborderdecorator"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "window"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "applicationwindow"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "datetimedecorator"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "logodecorator"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "perspectivewindow"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "snapshot_window"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "sourcenamedecorator"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "statictextdecorator"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "statusborderdecorator_linestyle"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "statusimagedecorator"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "statuslabeldecorator"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "display"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "perspective"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "snapshot"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "application"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "display_snapshot"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "displet"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "message"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "perspectivewindow"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "snapshot_window"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "window"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "applicationwindow"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "decorator"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "audiodecorator"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "borderdecorator"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "imagedecorator"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "labeldecorator"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "statusborderdecorator"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "datetimedecorator"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "logodecorator"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "sourcenamedecorator"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "statictextdecorator"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "statusborderdecorator_linestyle"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "statusimagedecorator"
2009-01-21 15:47:20 IST NOTICE: truncate cascades to table "statuslabeldecorator"
2009-01-21 15:47:21 IST NOTICE: truncate cascades to table "systemvariablebinding"
2009-01-21 15:47:21 IST NOTICE: truncate cascades to table "borderdecorator"
2009-01-21 15:47:21 IST NOTICE: truncate cascades to table "statusborderdecorator_linestyle"
2009-01-21 15:47:21 IST NOTICE: truncate cascades to table "display"
2009-01-21 15:47:21 IST NOTICE: truncate cascades to table "display_snapshot"
2009-01-21 15:47:21 IST NOTICE: truncate cascades to table "snapshot_window"
2009-01-21 15:47:21 IST NOTICE: truncate cascades to table "application"
2009-01-21 15:47:21 IST NOTICE: truncate cascades to table "window"
2009-01-21 15:47:21 IST NOTICE: truncate cascades to table "applicationwindow"
2009-01-21 15:47:21 IST NOTICE: truncate cascades to table "perspectivewindow"
2009-01-21 15:53:29 IST NOTICE: truncate cascades to table "displet"
2009-01-21 15:53:29 IST NOTICE: truncate cascades to table "screenscrapesource"
2009-01-21 15:53:30 IST ERROR: deadlock detected
2009-01-21 15:53:30 IST DETAIL: Process 12648 waits for AccessShareLock on relation 156727 of database 16403; blocked by process 11632.
Process 11632 waits for AccessExclusiveLock on relation 156745 of database 16403; blocked by process 12648.
2009-01-21 15:53:30 IST STATEMENT: select squidmodec0_.mId as mId24_5_, squidmodec0_.mHoverDelay as mHoverDe2_24_5_, squidmodec0_.mBorderWidth as mBorderW3_24_5_, squidmodec0_.mEnabled as mEnabled24_5_, squidmodec0_.mLeftSource_mId as mLeftSou8_24_5_, squidmodec0_.mRightSource_mId as mRightSo6_24_5_, squidmodec0_.mTopSource_mId as mTopSource7_24_5_, squidmodec0_.mBottomSource_mId as mBottomS5_24_5_, source1_.mId as mId32_0_, source1_.mName as mName32_0_, source1_.mType as mType32_0_, source1_.mTag as mTag32_0_, source1_.mDescription as mDescrip5_32_0_, source1_.mOnline as mOnline32_0_, source1_.mAcknowledged as mAcknowl7_32_0_, source1_.mAutoDetected as mAutoDet8_32_0_, source1_.mTimezone as mTimezone32_0_, source1_.width as width32_0_, source1_.height as height32_0_, source1_1_.mHost as mHost33_0_, source1_1_.mPassword as mPassword33_0_, source1_1_.mPort as mPort33_0_, source1_1_.mTargetType as mTargetT5_33_0_, source1_1_.mDesktopIdent as mDesktop6_33_0_, source1_1_.x as x33_0_, source1_1_.y as y33_0_, source1_1_.width as width33_0_, source1_1_.height as height33_0_, source1_1_.mWindowTitle as mWindow11_33_0_, source1_1_.mManualUpdateMode as mManual12_33_0_, source1_1_.mUpdateInterval as mUpdate13_33_0_, source1_2_.mURL as mURL34_0_, source1_2_.mAudioDelay as mAudioDe3_34_0_, source1_2_.mAudioURL as mAudioURL34_0_, source1_2_.mRemoteDesktopHost_mId as mRemoteD5_34_0_, source1_3_.mURL as mURL35_0_, case when source1_1_.mId is not null then 1 when source1_2_.mId is not null then 2 when source1_3_.mId is not null then 3 when source1_.mId is not null then 0 end as clazz_0_, screenscra2_.mId as mId32_1_, screenscra2_1_.mName as mName32_1_, screenscra2_1_.mType as mType32_1_, screenscra2_1_.mTag as mTag32_1_, screenscra2_1_.mDescription as mDescrip5_32_1_, screenscra2_1_.mOnline as mOnline32_1_, screenscra2_1_.mAcknowledged as mAcknowl7_32_1_, screenscra2_1_.mAutoDetected as mAutoDet8_32_1_, screenscra2_1_.mTimezone as mTimezone32_1_, screenscra2_1_.width as width32_1_, screenscra2_1_.height as height32_1_, screenscra2_.mHost as mHost33_1_, screenscra2_.mPassword as mPassword33_1_, screenscra2_.mPort as mPort33_1_, screenscra2_.mTargetType as mTargetT5_33_1_, screenscra2_.mDesktopIdent as mDesktop6_33_1_, screenscra2_.x as x33_1_, screenscra2_.y as y33_1_, screenscra2_.width as width33_1_, screenscra2_.height as height33_1_, screenscra2_.mWindowTitle as mWindow11_33_1_, screenscra2_.mManualUpdateMode as mManual12_33_1_, screenscra2_.mUpdateInterval as mUpdate13_33_1_, source3_.mId as mId32_2_, source3_.mName as mName32_2_, source3_.mType as mType32_2_, source3_.mTag as mTag32_2_, source3_.mDescription as mDescrip5_32_2_, source3_.mOnline as mOnline32_2_, source3_.mAcknowledged as mAcknowl7_32_2_, source3_.mAutoDetected as mAutoDet8_32_2_, source3_.mTimezone as mTimezone32_2_, source3_.width as width32_2_, source3_.height as height32_2_, source3_1_.mHost as mHost33_2_, source3_1_.mPassword as mPassword33_2_, source3_1_.mPort as mPort33_2_, source3_1_.mTargetType as mTargetT5_33_2_, source3_1_.mDesktopIdent as mDesktop6_33_2_, source3_1_.x as x33_2_, source3_1_.y as y33_2_, source3_1_.width as width33_2_, source3_1_.height as height33_2_, source3_1_.mWindowTitle as mWindow11_33_2_, source3_1_.mManualUpdateMode as mManual12_33_2_, source3_1_.mUpdateInterval as mUpdate13_33_2_, source3_2_.mURL as mURL34_2_, source3_2_.mAudioDelay as mAudioDe3_34_2_, source3_2_.mAudioURL as mAudioURL34_2_, source3_2_.mRemoteDesktopHost_mId as mRemoteD5_34_2_, source3_3_.mURL as mURL35_2_, case when source3_1_.mId is not null then 1 when source3_2_.mId is not null then 2 when source3_3_.mId is not null then 3 when source3_.mId is not null then 0 end as clazz_2_, source4_.mId as mId32_3_, source4_.mName as mName32_3_, source4_.mType as mType32_3_, source4_.mTag as mTag32_3_, source4_.mDescription as mDescrip5_32_3_, source4_.mOnline as mOnline32_3_, source4_.mAcknowledged as mAcknowl7_32_3_, source4_.mAutoDetected as mAutoDet8_32_3_, source4_.mTimezone as mTimezone32_3_, source4_.width as width32_3_, source4_.height as height32_3_, source4_1_.mHost as mHost33_3_, source4_1_.mPassword as mPassword33_3_, source4_1_.mPort as mPort33_3_, source4_1_.mTargetType as mTargetT5_33_3_, source4_1_.mDesktopIdent as mDesktop6_33_3_, source4_1_.x as x33_3_, source4_1_.y as y33_3_, source4_1_.width as width33_3_, source4_1_.height as height33_3_, source4_1_.mWindowTitle as mWindow11_33_3_, source4_1_.mManualUpdateMode as mManual12_33_3_, source4_1_.mUpdateInterval as mUpdate13_33_3_, source4_2_.mURL as mURL34_3_, source4_2_.mAudioDelay as mAudioDe3_34_3_, source4_2_.mAudioURL as mAudioURL34_3_, source4_2_.mRemoteDesktopHost_mId as mRemoteD5_34_3_, source4_3_.mURL as mURL35_3_, case when source4_1_.mId is not null then 1 when source4_2_.mId is not null then 2 when source4_3_.mId is not null then 3 when source4_.mId is not null then 0 end as clazz_3_, source5_.mId as mId32_4_, source5_.mName as mName32_4_, source5_.mType as mType32_4_, source5_.mTag as mTag32_4_, source5_.mDescription as mDescrip5_32_4_, source5_.mOnline as mOnline32_4_, source5_.mAcknowledged as mAcknowl7_32_4_, source5_.mAutoDetected as mAutoDet8_32_4_, source5_.mTimezone as mTimezone32_4_, source5_.width as width32_4_, source5_.height as height32_4_, source5_1_.mHost as mHost33_4_, source5_1_.mPassword as mPassword33_4_, source5_1_.mPort as mPort33_4_, source5_1_.mTargetType as mTargetT5_33_4_, source5_1_.mDesktopIdent as mDesktop6_33_4_, source5_1_.x as x33_4_, source5_1_.y as y33_4_, source5_1_.width as width33_4_, source5_1_.height as height33_4_, source5_1_.mWindowTitle as mWindow11_33_4_, source5_1_.mManualUpdateMode as mManual12_33_4_, source5_1_.mUpdateInterval as mUpdate13_33_4_, source5_2_.mURL as mURL34_4_, source5_2_.mAudioDelay as mAudioDe3_34_4_, source5_2_.mAudioURL as mAudioURL34_4_, source5_2_.mRemoteDesktopHost_mId as mRemoteD5_34_4_, source5_3_.mURL as mURL35_4_, case when source5_1_.mId is not null then 1 when source5_2_.mId is not null then 2 when source5_3_.mId is not null then 3 when source5_.mId is not null then 0 end as clazz_4_ from SquidModeConfiguration squidmodec0_ left outer join Source source1_ on squidmodec0_.mLeftSource_mId=source1_.mId left outer join ScreenScrapeSource source1_1_ on source1_.mId=source1_1_.mId left outer join VideoSource source1_2_ on source1_.mId=source1_2_.mId left outer join WebSource source1_3_ on source1_.mId=source1_3_.mId left outer join ScreenScrapeSource screenscra2_ on source1_2_.mRemoteDesktopHost_mId=screenscra2_.mId left outer join Source screenscra2_1_ on screenscra2_.mId=screenscra2_1_.mId left outer join Source source3_ on squidmodec0_.mRightSource_mId=source3_.mId left outer join ScreenScrapeSource source3_1_ on source3_.mId=source3_1_.mId left outer join VideoSource source3_2_ on source3_.mId=source3_2_.mId left outer join WebSource source3_3_ on source3_.mId=source3_3_.mId left outer join Source source4_ on squidmodec0_.mTopSource_mId=source4_.mId left outer join ScreenScrapeSource source4_1_ on source4_.mId=source4_1_.mId left outer join VideoSource source4_2_ on source4_.mId=source4_2_.mId left outer join WebSource source4_3_ on source4_.mId=source4_3_.mId left outer join Source source5_ on squidmodec0_.mBottomSource_mId=source5_.mId left outer join ScreenScrapeSource source5_1_ on source5_.mId=source5_1_.mId left outer join VideoSource source5_2_ on source5_.mId=source5_2_.mId left outer join WebSource source5_3_ on source5_.mId=source5_3_.mId where squidmodec0_.mId=$1
2009-01-21 15:53:30 IST ERROR: deadlock detected
2009-01-21 15:53:30 IST DETAIL: Process 11632 waits for AccessExclusiveLock on relation 156745 of database 16403; blocked by process 12832.
Process 12832 waits for AccessShareLock on relation 156727 of database 16403; blocked by process 11632.
2009-01-21 15:53:30 IST STATEMENT: TRUNCATE TABLE Source CASCADE
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "displet"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "screenscrapesource"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "squidmodeconfiguration"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "videosource"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "websource"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "decorator"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "display"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "application"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "audiodecorator"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "borderdecorator"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "display_snapshot"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "imagedecorator"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "labeldecorator"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "statusborderdecorator"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "window"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "applicationwindow"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "datetimedecorator"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "logodecorator"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "perspectivewindow"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "snapshot_window"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "sourcenamedecorator"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "statictextdecorator"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "statusborderdecorator_linestyle"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "statusimagedecorator"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "statuslabeldecorator"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "display"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "perspective"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "snapshot"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "application"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "display_snapshot"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "displet"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "message"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "perspectivewindow"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "snapshot_window"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "window"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "applicationwindow"
2009-01-21 15:54:57 IST NOTICE: truncate cascades to table "decorator"
pgsql-hackers by date: