Thread

1. Postgres 7 on Alpha

   Roger Wernersson <roger.wernersson@mindark.com> — 2000-11-07T15:10:13Z

   Hi!
   
   I have an old Alpha system which I use as a database server. I have 
   successufully run Postgres 6.5 on it but needed to upgrade to Postgres 7 
   to solve some problems. I downloaded the source of 7.0.2 as I could not 
   find any RPM of Postgres 7 for Alpha.
   
   I compiled and installed it without a glitch but I can not initialize the 
   database. I get the following error:
   
   
   bash$ /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
   This database system will be initialized with username "postgres".
   This user will own all the data files and must also own the server 
   process.
   
   Creating database system directory /usr/local/pgsql/data
   Creating database system directory /usr/local/pgsql/data/base
   Creating database XLOG directory /usr/local/pgsql/data/pg_xlog
   Creating template database in /usr/local/pgsql/data/base/template1
   
   FATAL: s_lock(20306f80) at spin.c:116, stuck spinlock. Aborting.
   
   FATAL: s_lock(20306f80) at spin.c:116, stuck spinlock. Aborting.
   
   initdb failed.
   Removing /usr/local/pgsql/data.
   Removing temp file /tmp/initdb.26953.
   
   
   I run Red Hat Linux release 6.2 (Zoot), Kernel 2.2.14-6.0 on an alpha. 
   What do I do now? What is a spinlock?
   
   /Roger
   
   
   

2. Re: Postgres 7 on Alpha

   Tom Lane <tgl@sss.pgh.pa.us> — 2000-11-07T15:47:51Z

   Roger Wernersson <roger.wernersson@mindark.com> writes:
   > I have an old Alpha system which I use as a database server. I have 
   > successufully run Postgres 6.5 on it but needed to upgrade to Postgres 7 
   > to solve some problems. I downloaded the source of 7.0.2 as I could not 
   > find any RPM of Postgres 7 for Alpha.
   
   > FATAL: s_lock(20306f80) at spin.c:116, stuck spinlock. Aborting.
   
   According to my notes, this happens if you compile with -O2 on at least
   some versions of Alpha egcs.  Try -O0 instead.  There are still some
   glitches exposed by the regress tests, though, particularly in date/time
   handling.  Now that we have an Alpha box available to the project, the
   problems in this port should get cleaned up for 7.1.  (Given a favorable
   tailwind or 25 hours in the day, that is ;-))
   
   			regards, tom lane
   
   

3. Re: Postgres 7 on Alpha

   Lamar Owen <lamar.owen@wgcr.org> — 2000-11-07T18:40:16Z

   Roger Wernersson wrote:
   > I run Red Hat Linux release 6.2 (Zoot), Kernel 2.2.14-6.0 on an alpha.
   > What do I do now? What is a spinlock?
   
   Apply Ryan Kirkpatrick's patches for PostgreSQL 7.0.x, available at
   http://www.rkirkpat.net/software/#linux-alpha and rebuild.
   
   You will need to start with a fresh tarball extraction, pre-configure,
   then apply the patches according to Ryan's instructions.
   
   The RPMset does this automatically if you are building on an alpha.
   --
   Lamar Owen
   WGCR Internet Radio
   1 Peter 4:11