Обсуждение: Windows buildfarm support, or lack of it

What's wrong with this picture?

http://www.pgbuildfarm.org/cgi-bin/show_status.pl

Notice how all the red is at the bottom of the report?  That's because
all the Windows machines are at the bottom, indicating that they haven't
reported recently.  AFAICT, snake is the only Windows machine that
actually runs the buildfarm on a regular schedule, and even it is just
running once a day.  So, while the timescale for finding out if a commit
breaks or fixes other platforms is just a couple hours, we generally
need a full day to find out about Windows.  For a platform that requires
as much special-case care and feeding as the Windows code does, that's
not very acceptable.  For a platform that's as ubiquitous as Windows
allegedly is, that's pretty surprising.  You'd think we could find a
couple of people willing to run buildfarm tests every four hours or
so, as many of the Unix buildfarm members do.

(Yeah, I'm a bit ticked off after waiting overnight to find out if
yesterday's commits fixed Windows, and getting up to find no new
data.)
        regards, tom lane

On Sun, 16 Jul 2006, Tom Lane wrote:

> [windows buildfarm machines run irregularly]

For my part the difficulty is scheduling.  As a primarily unix user I 
understand cron, but have no idea what the windows equivalent is.  For my 
cygwin buildfarm member I setup cron, but the make step failed for every 
build for unknown reasons while succeeding if not run from cron.  That 
further demotivated me from scheduling mingw builds.  Perhaps snake's 
maintainer could share his configuration?

Kris Jurka

-----Original Message-----
From: pgsql-hackers-owner@postgresql.org on behalf of Tom Lane
Sent: Sun 7/16/2006 3:29 PM
To: pgsql-hackers@postgresql.org
Subject: [HACKERS] Windows buildfarm support, or lack of it
> AFAICT, snake is the only Windows machine that
> actually runs the buildfarm on a regular schedule, and even it is just
> running once a day.

I can bump that up as high as you'd like within reason. 4? 6 times a day?

I have spare licences for most versions of Windows as well, so if Microsoft's virtual server product is not too
expensivefor us I can probably add a few platform variations to that box. I'll look into it. 

Regards, Dave.

-----Original Message-----
From: Kris Jurka [mailto:books@ejurka.com]
Sent: Sun 7/16/2006 3:44 PM
To: Tom Lane
Cc: pgsql-hackers@postgreSQL.org; Dave Page
Subject: Re: [HACKERS] Windows buildfarm support, or lack of it

> For my part the difficulty is scheduling.  As a primarily unix user I
> understand cron, but have no idea what the windows equivalent is.  For my
> cygwin buildfarm member I setup cron, but the make step failed for every
> build for unknown reasons while succeeding if not run from cron.  That
> further demotivated me from scheduling mingw builds.  Perhaps snake's
> maintainer could share his configuration?

I run a simple batch script that fires the run off under msys from the Windows Task Scheduler. I'll happily help out
anyonewho wants to get a build running. 

Regards, Dave.

Kris Jurka wrote:
> 
> 
> On Sun, 16 Jul 2006, Tom Lane wrote:
> 
>> [windows buildfarm machines run irregularly]
> 
> For my part the difficulty is scheduling.  As a primarily unix user I 
> understand cron, but have no idea what the windows equivalent is.  For 
> my cygwin buildfarm member I setup cron, but the make step failed for 
> every build for unknown reasons while succeeding if not run from cron.  
> That further demotivated me from scheduling mingw builds.  Perhaps 
> snake's maintainer could share his configuration?

There is job schedulers for Windows. I have no idea how good or bad they 
are.

Joshua D. Drake


> 
> Kris Jurka
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly
> 


-- 
   === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240   Providing the most comprehensive  PostgreSQL
solutionssince 1997             http://www.commandprompt.com/
 

Dave Page wrote:
> 
> I have spare licences for most versions of Windows as well, so if Microsoft's virtual server product is not too
expensivefor us I can probably add a few platform variations to that box. I'll look into it.
 

In fact MS released Virtual PC 2004 for free a couple days ago 
(http://www.microsoft.com/windows/virtualpc/default.mspx)


-- 
Regards
Petr Jelinek (PJMODOS)

Dave Page wrote:
>
> -----Original Message-----
> From: pgsql-hackers-owner@postgresql.org on behalf of Tom Lane
> Sent: Sun 7/16/2006 3:29 PM
> To: pgsql-hackers@postgresql.org
> Subject: [HACKERS] Windows buildfarm support, or lack of it
>  
>   
>> AFAICT, snake is the only Windows machine that
>> actually runs the buildfarm on a regular schedule, and even it is just
>> running once a day.  
>>     
>
> I can bump that up as high as you'd like within reason. 4? 6 times a day?
>
>   

Let's go for 6, at least for HEAD. Under normal use buildfarm doesn't 
actually do anything unless it detects a change in the source, and it 
makes sure there isn't a collision by using a lockfile. That means it is 
safe to schedule builds fairly frequently.


cheers

andrew

Andrew Dunstan <andrew@dunslane.net> writes:
> Dave Page wrote:
>> I can bump that up as high as you'd like within reason. 4? 6 times a day?

> Let's go for 6, at least for HEAD.

There's probably no need to check the back branches oftener than once a
day, but if you can do HEAD every 4 hours that'd be great ...
        regards, tom lane

-----Original Message-----
From: "Petr Jelinek" <pjmodos@pjmodos.net>
To: "Dave Page" <dpage@vale-housing.co.uk>
Cc: "PostgreSQL-development" <pgsql-hackers@postgresql.org>
Sent: 16/07/06 18:05
Subject: Re: Windows buildfarm support, or lack of it

> In fact MS released Virtual PC 2004 for free a couple days ago
> (http://www.microsoft.com/windows/virtualpc/default.mspx)

Yeah - I have licences for it, but it's more of an interactive emulator. I think I'll need the server version to run
fullyunattended. 

/D

Andrew, Tom:

I'm putting a solicitation in this week's PWN for more Windows buildfarm 
members.  With 250,000 Windows+PostgreSQL users out there, you'd think a few 
people would step up.

Dave, I think you may need to give Andrew Windows buildfarm instructions to 
put up at www.pgbuildfarm.org.

-- 
Josh Berkus
PostgreSQL @ Sun
San Francisco

Tom Lane wrote:
> Andrew Dunstan <andrew@dunslane.net> writes:
>> Dave Page wrote:
>>> I can bump that up as high as you'd like within reason. 4? 6 times a day?
> 
>> Let's go for 6, at least for HEAD.
> 
> There's probably no need to check the back branches oftener than once a
> day, but if you can do HEAD every 4 hours that'd be great ...

I will have seahorse doing Windows builds at the same rate then ...


Stefan

> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> Sent: 16 July 2006 18:47
> To: Andrew Dunstan
> Cc: Dave Page; pgsql-hackers@postgresql.org
> Subject: Re: [HACKERS] Windows buildfarm support, or lack of it
>
> Andrew Dunstan <andrew@dunslane.net> writes:
> > Dave Page wrote:
> >> I can bump that up as high as you'd like within reason. 4?
> 6 times a day?
>
> > Let's go for 6, at least for HEAD.
>
> There's probably no need to check the back branches oftener
> than once a
> day, but if you can do HEAD every 4 hours that'd be great ...

NP - next run is at 2200BST.

Regards, Dave.

> -----Original Message-----
> From: Stefan Kaltenbrunner [mailto:stefan@kaltenbrunner.cc]
> Sent: 16 July 2006 18:17
> To: Dave Page
> Subject: Re: [HACKERS] Windows buildfarm support, or lack of it
>
> care to share that script ? I set up seahorse on friday but as a
> unix-sysadmin I have not yet managed to get it to do
> automatic builds ...

Sure. It's pretty simply. I run one for each branch (used to do one for
all runs, but a problem in an early run can prevent later ones running
at all then

Regards, Dave.


@echo off

echo
========================================================================
====== >> \msys\1.0\local\build-farm\run-head.log
\msys\1.0\bin\date >> \msys\1.0\local\build-farm\run-head.log

echo Starting HEAD run... >> \msys\1.0\local\build-farm\run-head.log
\msys\1.0\bin\sh --login -c "cd /usr/local/build-farm; ./run_build.pl
--verbose HEAD" >> \msys\1.0\local\build-farm\run-head.log

echo Finished. >> \msys\1.0\local\build-farm\run-head.log
\msys\1.0\bin\date >> \msys\1.0\local\build-farm\run-head.log

echo
========================================================================
====== >> \msys\1.0\local\build-farm\run-head.log
echo. >> \msys\1.0\local\build-farm\run-head.log

> -----Original Message-----
> From: Josh Berkus [mailto:josh@agliodbs.com]
> Sent: 16 July 2006 19:04
> To: pgsql-hackers@postgresql.org
> Cc: Tom Lane; Andrew Dunstan; Dave Page
> Subject: Re: [HACKERS] Windows buildfarm support, or lack of it
>
> Andrew, Tom:
>
> I'm putting a solicitation in this week's PWN for more
> Windows buildfarm
> members.  With 250,000 Windows+PostgreSQL users out there,
> you'd think a few
> people would step up.
>
> Dave, I think you may need to give Andrew Windows buildfarm
> instructions to
> put up at www.pgbuildfarm.org.

<grin>It was Andrew that gave me instructions! I'll see if I can write
up the important points though.

/D

"Dave Page" <dpage@vale-housing.co.uk> writes:
>> In fact MS released Virtual PC 2004 for free a couple days ago 
>> (http://www.microsoft.com/windows/virtualpc/default.mspx)

> Yeah - I have licences for it, but it's more of an interactive emulator. I think I'll need the server version to run
fullyunattended.
 

Surely we can dredge up enough Windows users that Dave need not futz
with putting multiple versions onto his one machine ...
        regards, tom lane

Kris Jurka wrote:
>   For my cygwin buildfarm member I setup cron, but the make step 
> failed for every build for unknown reasons while succeeding if not run 
> from cron.  


Is this still happening? We should try to get to the bottom of it.

cheers

andrew

> -----Original Message-----
> From: Petr Jelinek [mailto:pjmodos@pjmodos.net]
> Sent: 16 July 2006 18:05
> To: Dave Page
> Cc: PostgreSQL-development
> Subject: Re: Windows buildfarm support, or lack of it
>
> Dave Page wrote:
> >
> > I have spare licences for most versions of Windows as well,
> so if Microsoft's virtual server product is not too expensive
> for us I can probably add a few platform variations to that
> box. I'll look into it.
>
> In fact MS released Virtual PC 2004 for free a couple days ago
> (http://www.microsoft.com/windows/virtualpc/default.mspx)

It seems that VMWare are following suit - their entry level VMWare
Server is now free for Windows and Linux :-)

http://www.vmware.com/products/server/

Regards, Dave.

Dave Page wrote:

> 
>
>It seems that VMWare are following suit - their entry level VMWare
>Server is now free for Windows and Linux :-)
>
>http://www.vmware.com/products/server/
>
>  
>


It has been for some time, at least in Beta, so I'm not sure who really 
went first.

We should be supplying a sample applicance for VMware server that 
showcases our stuff - maybe the LiveCD project guys could do that?

cheers

andrew

On Jul 16, 2006, at 3:08 PM, Andrew Dunstan wrote:
> Kris Jurka wrote:
>>   For my cygwin buildfarm member I setup cron, but the make step  
>> failed for every build for unknown reasons while succeeding if not  
>> run from cron.
>
>
> Is this still happening? We should try to get to the bottom of it.

Try setting a more complete $PATH; there's a good chance that make  
isn't able to find something it needs.
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

> > I have spare licences for most versions of Windows as well, so if
> Microsoft's virtual server product is not too expensive for us I
> can probably add a few platform variations to that box. I'll look
> into it.
>
> In fact MS released Virtual PC 2004 for free a couple days ago
> (http://www.microsoft.com/windows/virtualpc/default.mspx)

FWIW, Virtual Server 2005 R2 Enterprise Edition (how's that for a
product name) is also a free download from MS (provided you have a
license for the underlying OS, but since it runs only on Win2k3, what'd
they expect..)

//Magnus