Re: [PORTS] Port Bug Report: Backend crashes daily.
От | The Hermit Hacker |
---|---|
Тема | Re: [PORTS] Port Bug Report: Backend crashes daily. |
Дата | |
Msg-id | Pine.BSF.4.05.9903091449210.7045-100000@thelab.hub.org обсуждение исходный текст |
Ответ на | Port Bug Report: Backend crashes daily. (Unprivileged user <nobody>) |
Список | pgsql-ports |
You have a new version of the ODBC driver, but you might want to upgrade to the newest version of the server, which is currently v6.4.2 ... On Tue, 9 Mar 1999, Unprivileged user wrote: > > ============================================================================ > POSTGRESQL BUG REPORT TEMPLATE > ============================================================================ > > > Your name : David Secret > Your email address : secret@kearneydev.com > > Category : runtime: back-end > Severity : serious > > Summary: Backend crashes daily. > > System Configuration > -------------------- > Operating System : Linux 2.0.36 ELF/Redhat 5.2 > > PostgreSQL version : 6.4 > > Compiler used : gcc 2.7.2.3 > > Hardware: > --------- > Linux tau.kearneydev.com 2.0.36 #1 Tue Oct 13 22:17:11 EDT 1998 i686 unknown > Pentium-II 266MHz 64M RAM > > Versions of other tools: > ------------------------ > GNU Make version 3.76.1, by Richard Stallman and Roland McGrath. > > -------------------------------------------------------------------------- > > Problem Description: > -------------------- > At least once daily my visual basic 5 program using ODBC version > 6.40.0004 kills the backend, all postmaster processes immediately > zombie and I'm dead in the water. There doesn't seem to be > a way to reproduce it regularly, as if I do the exact same thing > again it won't happen. > > Here is an excerpt from the end of a -d 3 log: > > <Normal queries & such for about 3 megs before this> > query: SELECT "material_id" ,"name" ,"short_name" ,"legacy" FROM "material" ORDE > R BY "legacy" DESC,"name" > ProcessQuery > CommitTransactionCommand > ERROR: postmaster: StreamConnection: accept: Invalid argument > pmdie 3 > SignalChildren: sending signal 15 to process 11590 > SignalChildren: sending signal 15 to process 11589 > proc_exit(0) [#0] > shmem_exit(0) [#0] > .. <Everything dies from here> > > I'll definately help by providing a sample of my program or > whatever debug level log files you'd like, I really love > PostgreSQL and will support it if I can use it in my projects, > except for large joins(7 tables) the performance is > impressive. > > > -------------------------------------------------------------------------- > > Test Case: > ---------- > Unfortunately I haven't found a way to reproduce the problem, > I think there is a small chance the ODBC driver is sending > something funky to the backend(as it mentions a failed > stream connect before dying), but no idea how to reproduce > this. I'll attempt to capture a log file from the ODBC > driver, but this is difficult as it only happens on 1 of 3 > machines daily. > > -------------------------------------------------------------------------- > > Solution: > --------- > > > -------------------------------------------------------------------------- > > Marc G. Fournier Systems Administrator @ hub.org primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
В списке pgsql-ports по дате отправления: