Re: Recent 027_streaming_regress.pl hangs

From: Andres Freund <andres(at)anarazel(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, Alexander Lakhin <exclusion(at)gmail(dot)com>, Michael Paquier <michael(at)paquier(dot)xyz>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>
Subject: Re: Recent 027_streaming_regress.pl hangs
Date: 2024-03-26 07:59:12
Message-ID: 20240326075912.sia3wlvnaqnbf47u@awork3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

On 2024-03-26 00:54:54 -0400, Tom Lane wrote:
> > I guess I'll try to write a buildfarm database query to extract how long that
> > phase of the test took from all runs on my menagerie, not just the failing
> > one, and see if there's a visible trend.
>
> +1

Only the query for successful runs has finished, and it looks like the error
cse is still going to take a while longer, so here are excerpts from a query
showing how long 027_stream_regress.pl took to succeed:

sysname | date | count | avg_duration
---------------+------------+-------+--------------

calliphoridae | 2024-01-29 | 10 | 435
calliphoridae | 2024-02-05 | 25 | 496
calliphoridae | 2024-02-12 | 36 | 522
calliphoridae | 2024-02-19 | 25 | 445
calliphoridae | 2024-02-26 | 35 | 516
calliphoridae | 2024-03-04 | 53 | 507
calliphoridae | 2024-03-11 | 51 | 532
calliphoridae | 2024-03-18 | 53 | 548
calliphoridae | 2024-03-25 | 13 | 518

culicidae | 2024-01-29 | 11 | 420
culicidae | 2024-02-05 | 31 | 485
culicidae | 2024-02-12 | 35 | 513
culicidae | 2024-02-19 | 29 | 489
culicidae | 2024-02-26 | 36 | 512
culicidae | 2024-03-04 | 63 | 541
culicidae | 2024-03-11 | 62 | 597
culicidae | 2024-03-18 | 56 | 603
culicidae | 2024-03-25 | 16 | 550

tamandua | 2024-01-29 | 13 | 420
tamandua | 2024-02-05 | 29 | 433
tamandua | 2024-02-12 | 34 | 431
tamandua | 2024-02-19 | 27 | 382
tamandua | 2024-02-26 | 36 | 492
tamandua | 2024-03-04 | 60 | 475
tamandua | 2024-03-11 | 56 | 533
tamandua | 2024-03-18 | 54 | 527
tamandua | 2024-03-25 | 21 | 507

Particularly on tamandua it does look like there has been an upwards trend.

Late, will try to look more in the next few days.

Greetings,

Andres Freund

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alexander Lakhin 2024-03-26 08:00:00 Re: ALTER TABLE SET ACCESS METHOD on partitioned tables
Previous Message Andres Freund 2024-03-26 07:56:32 Re: make dist using git archive