Re: Bug#41277: postgresql 6.5.1-3 + sparc (sun4u) == nasty nasty crashes
[Background: PostgreSQL is causing extremely hard crashes on my Sun4u
(Ultra5) Debian SPARC system. Anyone should be able to reproduce this
by installing the postgresql-test environment, and running:
# cd /usr/lib/postgresql/test/regress
# chown -R postgres .
# su - postgres
$ cd /usr/lib/postgresql/test/regress
$ make runtest
BEWARE -- this hard crashes my system. You may crash hard; you may
lose data.
Note: I am running a mostly up-to-date 2.2.9 kernel (stock image from
potato) with the newest postgresql package (6.5.1-3 I believe).
]
That is very nasty -- and unexpected; I would like to report whatever
information is available to [EMAIL PROTECTED] However, they
will need to know exactly what was going on - logfile output, if available,
progress through the test, test output file, if it survived. It doesn't
seem at all like the problem that I thought I was asking you to look at.
We should investigate whether there is some entirely separate cause.
Yes. On followup, I am getting intermittant hard crashes when running
regress.sh or doing any operation with postgresql. Obviously, this is
more on the level of a sparc64 kernel problem, even, than a purely
postgres problem -- after all, no user process should be able to take
out the system this way.
My most recent crash has this output to 'make runtest':
path .. ok
polygon .. ok
circle .. ok
geometry .. failed
timespan ..
And in the postgres.log, with debugging at 4:
plan:
{ SEQSCAN :cost 43 :size 334 :width 16 :state :qptargetlist
({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 705 :restypmod -1
:resname one :reskey 0 :reskeyop 0 :resgroupref 0 :resjunk false }
:expr { CONST :consttype 705 :constlen -1 :constisnull false
:constvalue 4 [ 0 0 0 4 ] :constbyval false }} { TARGETENTRY
:resdom { RESDOM :resno 2 :restype 600 :restypmod -1 :resname f1
:reskey 0 :reskeyop 0 :resgroupref 0 :resjunk false } :expr { VAR
:varno 1 :varattno 1 :vartype 600 :vartypmod -1 :varlevelsup 0
:varnoold 1 :varoattno 1}}) :qpqual ({ EXPR :typeOid 16 :opType func
:oper { FUNC :funcid 1532 :functype 16 :funcisindex false :funcsize 0
:func_fcache @ 0x0 :func_tlist ({ TARGETENTRY :resdom { RESDOM :resno
1 :restype 16 :restypmod -1 :resname noname :reskey 0 :reskeyop 0
:resgroupref 0 :resjunk false } :expr { VAR :varno -1 :varattno 1
:vartype 16 :vartypmod -1 :varlevelsup 0 :varnoold -1 :varoattno 1}})
:func_planlist } :args ({ VAR :varno 1 :varattno 1 :vartype 600
:vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 1} { CONST
:consttype 600 :constlen 16 :constisnull false :constvalue 16 [ 64
20 102 102 102 102 102 102 64 65 64 0 0 0 0 0 ]
:constbyval false })}) :lefttree :righttree :extprm () :locprm
() :initplan :nprm 0 :scanrelid 1 }
ProcessQuery
CommitTransactionCommand
StartTransactionCommand
query: SELECT '' AS one, p1.f1
FROM POINT_TBL p1
WHERE p1.f1 ?| '(5.1,34.5)'::point;
parser outputs:
{ QUERY :command 1 :utility :resultRelation 0 :into :isPortal
false :isBinary false :isTemp false :unionall false :unique
:sortClause :rtable ({ RTE :relname point_tbl :refname p1 :relid
20864 :inh false :inFromCl true :skipAcl false}) :targetlist
({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 705 :restypmod -1
:resname one :reskey 0 :reskeyop 0 :resgroupref 0 :resjunk false }
:expr { CONST :consttype 705 :constlen -1 :constisnull false
:constvalue 4 [ 0 0 0 4 ] :constbyval false }} { TARGETENTRY
:resdom { RESDOM :resno 2 :restype 600 :restypmod -1
:resname f1 :reskey 0 :reskeyop 0 :resgroupref 0 :resjunk false }
:expr { VAR :varno 1 :varattno 1 :vartype 600 :vartypmod -1
:varlevelsup 0 :varnoold 1 :varoattno 1}}) :qual { EXPR :typeOid 16
:opType op :oper { OPER :opno 809
:opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype
--
Output just stops there, with a hard crash to the system.
--
.Adam Di [EMAIL PROTECTED]URL:http://www.onShore.com/
Re: offline for a month
Eric Delaunay [EMAIL PROTECTED] writes: I cannot connect from my home anymore, therefore I'm not be able to work on boot floppies now (all I can do is just reading my emails from my office). Moreover I will be on holidays tomorrow evening and will be offline for one month or so. Ugh, too bad. Feel free to upload a slink release of bootdisks for sparc if you need to. BTW, it could be wise to use 2.2.9 kernel from potato, but it requires to be recompiled first with the following features enabled: - iso9660 (not in module ;) - rarp, bootp - nfsroot for sparc32 at least (I guess nfsroot is not required/wanted for sparc64) - PCI support disabled for sparc32 (kbd conflicts between PS/2 Sun styles otherwise) Can you email me or the list the .config file you used fro the 2.2.5 based build you did before? Is it safe to build it on a potato system? I would guess not *sigh* It's very difficult for me to build a new boot-floppies since my link right now is so slow (28.8) and I'd need to reinstall slink I think. If anyone else wants to step forward, that would be great, otherwise, I'll make the attempt in a week or so. -- .Adam Di [EMAIL PROTECTED]URL:http://www.onShore.com/
Re: databases and potato
Teun Vink [EMAIL PROTECTED] writes: I'm working on a project which will use PHP3 and a database backend. Because of dependencies on PHP3 I run potato, but I can't seem to find a database server which runs on potato. Both MySQL and Postgres fail to install. PostgreSQL installs fine for me -- it just doesn't run to week, but I'm running a Sun4u -- maybe you'd have better luck. -- .Adam Di [EMAIL PROTECTED]URL:http://www.onShore.com/
Re: sparc 20
Huerta, Yectli A [EMAIL PROTECTED] writes: I am trying to install debian 2.1 on a sparc 20. I am booting from the cdrom. Once I am done through the process, I reboot the box as instructed, but it can not boot properly. It panics, and cycles trying to reboot every 10 seconds. I am looking at the partitions lists and it gives me all of them. My linux native and linux swap are active. The whole disk is not active. I am blaming this for my lack of success. Oh, you partitioned wrong? How can i make the whole disk partition active through the dbootstrap menu? Run fdisk on tty2 (press alt-F2). -- .Adam Di [EMAIL PROTECTED]URL:http://www.onShore.com/
Re: Diskless Sparc Clients, We Need -DNFSROOT
The devil himself [EMAIL PROTECTED] writes: After making NetBSD/OpenBSD diskless setups here for my Tadpole laptop I decided to try and setup a diskless Linux setup as well, Debian was a good choice since it even had a diskless install program that was quite krad. Anyway, i got through the install everything went fine. The problem arises when you try and boot the system with the kernel images provided on debian.org, none of them have nfsroot support! Not having any Linux Sparc boxes to build a kernel on I am kinda in the dark. That's very odd. I thought esp the TFTP images provided in the standard location has NFSROOT support, at least they are supposed to. Are you sure they don't? Were you trying the 2.0.x series kernels or the 2.2.x ones ? -- .Adam Di [EMAIL PROTECTED]URL:http://www.onShore.com/
Re: offline for a month
On Sat, Jul 31, 1999 at 09:46:55PM -0400, Adam Di Carlo wrote: Can you email me or the list the .config file you used fro the 2.2.5 based build you did before? Is it safe to build it on a potato system? I would guess not *sigh* It's very difficult for me to build a new boot-floppies since my link right now is so slow (28.8) and I'd need to reinstall slink I think. If anyone else wants to step forward, that would be great, otherwise, I'll make the attempt in a week or so. Shaleh has a slink box at VA on a fast dedicated connection. He does compiles as needed. I am sure he would be willing to help out :)
netbase 3.15-4 ports?
Hello world, Is netbase 3.15-4 failing to compile on sparc and/or alpha, or have the build daemons simply not gotten around to it yet? If the former, are there any failure logs I can check? Thanks, aj, who notes that m68k seem to have the power... ;) -- Anthony Towns [EMAIL PROTECTED] http://azure.humbug.org.au/~aj/ I don't speak for anyone save myself. PGP encrypted mail preferred. ``The thing is: trying to be too generic is EVIL. It's stupid, it results in slower code, and it results in more bugs.'' -- Linus Torvalds pgpcP4OeuaIsS.pgp Description: PGP signature
Re: Diskless Sparc Clients, We Need -DNFSROOT
Well since its a Sparcbook it needs 2.2.x kernel for the console to work (openprom console support). I heard the 2.2.x dont have NFSROOT. [EMAIL PROTECTED] http://openbsd.itgo.com On 31 Jul 1999, Adam Di Carlo wrote: The devil himself [EMAIL PROTECTED] writes: After making NetBSD/OpenBSD diskless setups here for my Tadpole laptop I decided to try and setup a diskless Linux setup as well, Debian was a good choice since it even had a diskless install program that was quite krad. Anyway, i got through the install everything went fine. The problem arises when you try and boot the system with the kernel images provided on debian.org, none of them have nfsroot support! Not having any Linux Sparc boxes to build a kernel on I am kinda in the dark. That's very odd. I thought esp the TFTP images provided in the standard location has NFSROOT support, at least they are supposed to. Are you sure they don't? Were you trying the 2.0.x series kernels or the 2.2.x ones ? -- .Adam Di [EMAIL PROTECTED]URL:http://www.onShore.com/
Formating a new drive.
Hi, I need to format and label a new drive. sformat appears to be the program I need but it requires the scg device driver. I can't seem to find the package that contains this driver. Any help in getting scg installed and working would be appreciated. I'm new to this list so sorry if this has already been covered. Thanks, Bob.
kernel 2.0.37 compilation failure
Hi Debian Team... Compilation of kernel 2.0.37 fails here. System is a Sun Sparc 1... Does anybody have a clue why this happens..? Kernel is 2.0.37. (Need this release, because in 2.2.x bwtwo support seems to be broken.) Kernel 2.0.35 compiled successfully after applying the Sparc patch (thanks to Christian Meder). For 2.0.37, there is no patch available (right??). However, compilation fails with...: (Sorry for the long output I appended.) see you ANDI THANK YOU for any hints!! :-) .. make ARCH=sparc vmlinux make[1]: Entering directory `/usr/src/linux-2.0.37' make[1]: Circular /usr/src/linux-2.0.37/include/asm/pgtable.h - /usr/src/linux-2.0.37/include/linux/mm.h dependency dropped. gcc -D__KERNEL__ -I/usr/src/linux-2.0.37/include -Wall -Wstrict-prototypes -O2 -fomit-frame-pointer -fno-strength-reduce -pipe -c -o init/main.o init/main.c /usr/src/linux-2.0.37/include/asm/posix_types.h: In function `__FD_ZERO': In file included from /usr/src/linux-2.0.37/include/linux/posix_types.h:48, from /usr/src/linux-2.0.37/include/linux/types.h:16, from init/main.c:17: /usr/src/linux-2.0.37/include/asm/posix_types.h:72: warning: initialization from incompatible pointer type /usr/src/linux-2.0.37/include/asm/posix_types.h:75: `__FDSET_INTS' undeclared (first use this function) /usr/src/linux-2.0.37/include/asm/posix_types.h:75: (Each undeclared identifier is reported only once /usr/src/linux-2.0.37/include/asm/posix_types.h:75: for each function it appears in.) /usr/include/asm/semaphore.h: In function `down': In file included from /usr/src/linux-2.0.37/include/linux/sched.h:22, from init/main.c:20: /usr/include/asm/semaphore.h:50: warning: implicit declaration of function `atomic_dec_return' /usr/include/asm/semaphore.h: In function `up': /usr/include/asm/semaphore.h:64: warning: implicit declaration of function `atomic_inc_return' /usr/src/linux-2.0.37/include/linux/string.h: At top level: In file included from init/main.c:25: /usr/src/linux-2.0.37/include/linux/string.h:31: warning: conflicting types for built-in function `memcpy' /usr/src/linux-2.0.37/include/linux/string.h:34: warning: conflicting types for built-in function `memcmp' /usr/src/linux-2.0.37/include/linux/mm.h: In function `expand_stack': In file included from init/main.c:33: /usr/src/linux-2.0.37/include/linux/mm.h:327: `RLIMIT_AS' undeclared (first use this function) make[1]: *** [init/main.o] Error 1 make[1]: Leaving directory `/usr/src/linux-2.0.37' make: *** [build] Error 2
