From:
Zoltán Böszörményi <zb(at)cybertec(dot)at>
To:
Hari Babu <haribabu(dot)kommi(at)huawei(dot)com>
Cc:
'Craig Ringer' <craig(at)2ndQuadrant(dot)com>, 'Hans-Jürgen Schönig' <hs(at)cybertec(dot)at>, 'Ants Aasma' <ants(at)cybertec(dot)at>, 'Tom Lane' <tgl(at)sss(dot)pgh(dot)pa(dot)us>, 'PostgreSQL Hackers' <pgsql-hackers(at)postgresql(dot)org>, 'Amit kapila' <amit(dot)kapila(at)huawei(dot)com>
Subject:
Re: Strange Windows problem, lock_timeout test request
Date:
2013-01-30 14:29:04
Message-ID:
51092E30.9040405@cybertec.at (view raw or flat )
Thread:
2013-01-18 22:43:15 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2013-01-19 00:13:07 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2013-01-19 07:36:04 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2013-01-19 20:15:31 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2013-01-23 13:31:06 from Zoltán Böszörményi <zb(at)cybertec(dot)at>
2013-01-24 18:44:09 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
2013-01-24 19:41:18 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2013-01-24 20:08:14 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2013-01-25 01:44:28 from Craig Ringer <craig(at)2ndQuadrant(dot)com>
2013-01-26 16:04:35 from james <james(at)mansionfamily(dot)plus(dot)com>
2013-01-26 23:38:11 from Craig Ringer <craig(at)2ndQuadrant(dot)com>
2013-01-25 00:55:17 from Craig Ringer <craig(at)2ndQuadrant(dot)com>
2013-01-19 07:51:00 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2013-01-19 23:15:39 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2013-01-23 13:28:25 from Zoltán Böszörményi <zb(at)cybertec(dot)at>
2013-01-19 05:52:41 from Amit kapila <amit(dot)kapila(at)huawei(dot)com>
2013-01-19 07:36:48 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2013-01-28 14:20:33 from Hari Babu <haribabu(dot)kommi(at)huawei(dot)com>
2013-01-30 14:29:04 from Zoltán Böszörményi <zb(at)cybertec(dot)at>
2013-01-30 14:45:42 from Zoltán Böszörményi <zb(at)cybertec(dot)at>
2013-01-30 15:06:36 from Hari Babu <haribabu(dot)kommi(at)huawei(dot)com>
2013-01-30 16:45:54 from Zoltán Böszörményi <zb(at)cybertec(dot)at>
2013-01-31 13:55:14 from Zoltán Böszörményi <zb(at)cybertec(dot)at>
2013-01-31 14:22:46 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
2013-01-31 14:55:46 from Zoltán Böszörményi <zb(at)cybertec(dot)at>
2013-01-31 15:38:04 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2013-01-31 15:39:38 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-01-31 17:27:22 from Zoltán Böszörményi <zb(at)cybertec(dot)at>
2013-01-31 18:38:07 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-01-31 21:12:01 from Zoltán Böszörményi <zb(at)cybertec(dot)at>
2013-02-12 18:32:48 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2013-02-12 18:35:17 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-02-12 18:41:42 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2013-02-12 18:45:50 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-02-12 18:51:45 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2013-02-12 18:55:37 from Andres Freund <andres(at)2ndquadrant(dot)com>
2013-02-12 18:56:23 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-02-12 18:58:12 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2013-02-12 19:00:13 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2013-02-23 01:55:23 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-02-23 18:15:06 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2013-02-24 02:23:29 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-02-24 08:27:01 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2013-02-24 14:03:44 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-02-24 15:14:41 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2013-02-25 08:23:34 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2013-02-25 14:05:24 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-02-27 18:07:02 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-02-27 18:28:46 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-02-27 18:38:44 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2013-02-27 19:06:34 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-02-27 19:38:29 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2013-02-28 08:22:18 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2013-03-15 17:53:40 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-03-16 15:59:27 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2013-03-16 16:42:51 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-03-16 17:17:00 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2013-03-16 17:48:35 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-03-16 18:04:25 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-03-16 18:26:34 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-03-17 00:35:40 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
2013-03-17 03:53:50 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-03-17 03:48:16 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-03-17 08:00:50 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2013-03-17 15:07:12 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-03-17 19:06:13 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2013-03-18 02:52:11 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-03-18 05:22:42 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2013-03-18 05:29:37 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2013-03-18 05:47:30 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-03-18 10:40:48 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2013-03-18 14:09:06 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-03-21 18:24:10 from Robert Haas <robertmhaas(at)gmail(dot)com>
2013-03-22 00:16:39 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-03-22 14:29:15 from Robert Haas <robertmhaas(at)gmail(dot)com>
2013-03-22 16:49:29 from Greg Stark <stark(at)mit(dot)edu>
2013-02-24 03:07:13 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2013-02-24 03:15:08 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-02-24 08:44:54 from Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
2013-02-24 14:08:34 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-02-24 17:39:38 from Claudio Freire <klaussfreire(at)gmail(dot)com>
2013-02-24 19:42:02 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2013-02-24 21:31:44 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-02-25 12:56:40 from Robert Haas <robertmhaas(at)gmail(dot)com>
2013-02-25 14:11:27 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-02-25 14:17:25 from Andres Freund <andres(at)2ndquadrant(dot)com>
2013-02-25 14:25:50 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-02-25 14:38:12 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-02-25 16:48:08 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-02-25 16:39:12 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2013-02-24 20:08:33 from Peter Geoghegan <peter(dot)geoghegan86(at)gmail(dot)com>
2013-02-24 12:30:15 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2013-02-27 03:06:44 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-02-27 09:40:16 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
2013-02-27 13:58:15 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-03-04 03:28:36 from Craig Ringer <craig(at)2ndquadrant(dot)com>
2013-03-04 03:34:49 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-03-06 18:23:24 from Robert Haas <robertmhaas(at)gmail(dot)com>
2013-03-06 18:53:49 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-03-06 18:58:06 from Boszormenyi Zoltan <zb(at)cybertec(dot)at>
Lists:
pgsql-hackers
2013-01-28 15:20 keltezéssel, Hari Babu írta:
> On Saturday, January 19, 2013 11:23 AM Amit kapila wrote:
>> On Saturday, January 19, 2013 4:13 AM Boszormenyi Zoltan wrote:
>>> Hi,
>>>
>>> Unfortunately, I won't have time to do anything with my lock_timeout
> patch
>>> for about 3 weeks. Does anyone have a little spare time to test it on
> Windows?
>> I shall try to do it, probably next week.
>> Others are also welcome to test the patch.
> I have carried out some windows testing of the lock timeout patch.
Thanks very much. It means it didn't crash for you and
it waited the expected amount of time as well.
> The extra tests which are carried out on the patch are attached in the mail.
The patch itself contained regression tests to run by itself
and compete with statement_timeout as well, although
it waits only 2 seconds instead of 60 as in your test.
> Some observations on the patch:
>
> 1. Patch needs a rebase as it causing some rejections.
On a fresh GIT pull, it only caused a reject for the documentation
parts of the patch. No other rejects and no fuzz, only line shift
warnings were indicated by the patch. Anyway, a refreshed one
is attached.
> 2. regress check failed because the expected ".out" file is not updated
> properly.
Which regress check failed? The .out file was updated in the patch
for prepared_xacts.sql where the regression tests for lock_timeout
were added. Or do you mean the one for the sql file you sent?
Thanks,
Zoltán Böszörményi
--
----------------------------------
Zoltán Böszörményi
Cybertec Schönig & Schönig GmbH
Gröhrmühlgasse 26
A-2700 Wiener Neustadt, Austria
Web: http://www.postgresql-support.de
http://www.postgresql.at/
In response to
Responses
pgsql-hackers by date
Next :From: Zoltán BöszörményiDate: 2013-01-30 14:45:42Subject : Re: Strange Windows problem, lock_timeout test requestPrevious :From : MauMauDate : 2013-01-30 14:11:04Subject : backend hangs at immediate shutdown (Re: Back-branch update releases coming in a couple weeks)
