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:45:42
Message-ID:
51093216.3030405@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-30 15:29 keltezéssel, Zoltán Böszörményi írta:
> 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?
If the failed regression test is indeed the prepared_xacts.sql that is
in my patch, can you attach the regression.diff file after the failed
"make check"? Thanks.
>
> 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
pgsql-hackers by date
Next :From: Andres FreundDate: 2013-01-30 14:55:21Subject : Re: autovacuum not prioritising for-wraparound tablesPrevious :From : Zoltán BöszörményiDate : 2013-01-30 14:29:04Subject : Re: Strange Windows problem, lock_timeout test request
