Re: Still seeing hangs in xlog_grant_log_space

Dave Chinner
2012-05-18T09:31:25Z

On Wed, May 09, 2012 at 04:07:52PM -0500, Mark Tinguely wrote:
> On 05/09/12 02:35, Dave Chinner wrote:
>
> >
> >Transaction Wait queues Grant head Write Head Log head Log tail
> >-----------------------------------------------------------------------------------------
> >INACTIVE empty empty 118 438024 118 438024 118 802 118 697
> >INACTIVE empty empty 119 20240 119 20240 118 802 118 697
> >REMOVE empty empty 118 438456 118 438456 118 802 118 697
> >REMOVE empty empty 118 438772 118 438772 118 802 118 697
> >CREATE empty empty 119 35872 119 35872 118 802 118 697
> >FSYNC_TS active empty 119 205428 119 205428 118 802 118 697
> >FSYNC_TS active empty 119 202944 119 202944 118 802 118 697
> >FSYNC_TS active empty 119 200664 119 200664 118 802 118 697
> >REMOVE empty empty 118 380316 118 380316 118 724 118 652
> >INACTIVE empty empty 118 552532 118 552532 118 724 118 652
> >FSYNC_TS empty empty 118 382140 118 382140 118 724 118 652
> >INACTIVE empty empty 118 565968 118 565968 118 724 118 652
> >REMOVE empty empty 119 25404 119 25404 118 802 118 697
> >INACTIVE active empty 119 25580 119 25580 118 802 118 697
>
>
>
> Just so you don't go down a blind alley, the timestamp on the log
> went backwards there. If you resort on the time stamps this does not
> go backwards.

Yup, you are right, timestamps jump around, so that may not be the cause.

Cheers,

Dave.
--
Dave Chinner
david@fromorbit.com