================================================== ==========================
POSTGRESQL BUG REPORT TEMPLATE
================================================== ==========================


Your name : Micah Yoder
Your email address : micah (AT) yoderdev (DOT) com


System Configuration
---------------------
Architecture (example: Intel Pentium) : Pentium 3 (Coppermine), SMP 2 CPUs

Operating System (example: Linux 2.0.26 ELF) : Linux sol.yoderdev.com
2.4.16-010stab017.17.777-smp #1 SMP Wed Mar 19 16:25:17 MSK 2003 i686 i686
i386 GNU/Linux
(This is a version of Linux running virtual servers. I have root on a virtual
server.)

PostgreSQL version (example: PostgreSQL-7.3.4): PostgreSQL-7.3.4

Compiler used (example: gcc 2.95.2) : gcc version 3.2 20020903 (Red Hat
Linux 8.0 3.2-7)


Please enter a FULL description of your problem:
------------------------------------------------
Postgres hard crashes once or twice a week!

It was running fine with 7.3.2 for several months. Then I installed
a phpBB site with a fair amount of traffic. That was over a month ago, and
Postgres has probably crashed maybe 6 to 8 times. Bind has also crashed a
couple times since then (and not before the phpBB install) so it's
possible that this isn't a PG issue. I've upgraded to 7.3.4 in the mean time,
and it still happens.

Here's what I get in my log file when it crashes:

LOG: ServerLoop: select failed: Cannot allocate memory
IpcSemaphoreInitialize: semctl(id=2392067, 10, SETVAL, 0) failed: Invalid
argument

[ Followed by several pages of this: ^@^@^@^@^@
and finally: ]

PGSemaphoreUnlock: semop(id=2228227) failed: Identifier removed
PGSemaphoreLock: semop(id=2228227) failed: Identifier removed
PGSemaphoreLock: semop(id=2195458) failed: Identifier removed
PGSemaphoreLock: semop(id=2228227) failed: Identifier removed

Also recently there have been some weird database issues, probably related to
the improper shutdown:

1. One of the topics in my phpBB database had a duplicate entry. The two were
the same in most fields INCLUDING THE PRIMARY KEY!!! At least one field was
different, the one that contained the number of views of that topic.

2. On another site, new users are usually not listed in the user list until
you hit Refresh on the browser a couple times. This behavior is recent and
seems inexplicable except for internal database weirdness. (There isn't any
caching, the user list comes from a straight DB query.)

Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------

I don't think that's possible. It seems pretty random and likely unique to my
site. Please let me know if there's anything I can check or any settings I
can try changing.


If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------

Really no idea. I am wondering if you all think this sounds like a hardware
problem. If so, I'd appreciate knowing that. If not, I'll try to collect
more info for you.

Thanks!



--
Yoder Internet Development
Honest and Affordable Web Development and Linux consulting
http://yoderdev.com


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

Micah Yoder <micah (AT) yoderdev (DOT) com> writes:
Yeah, it does. Have you tried running memtest86?

It could also be a kernel problem --- I'm not sure 2.4.16 had all the
SMP bugs flushed out of it. Consider getting a later kernel.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org

On Saturday 08 November 2003 12:53 pm, Tom Lane wrote:
Thanks.

It's a virtual server and I don't run it, so none of that is up to me. But I
think they'll move me to another box.


--
Yoder Internet Development
Honest and Affordable Web Development and Linux consulting
http://yoderdev.com


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend