Re: [GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit
Hi, I'm not sure if this is good netiquette, or not. I'm reviving a month-old thread, because I'm trying to figure out how to resolve the issue. To summarize: when I run unit tests with eclipse (and with Ant) on Windows, at some point, I run out of available connections. I tried increasing the maximum number of connections, but then I started seeing the postgres server die and restart. I'm trying to fix this, yet again, but I don't have a clear idea of what to fix. On Tue, 23 Oct 2007 20:07:22 +0200, Magnus Hagander wrote: > Rainer Bauer wrote: >> After increasing the session heap size in the registry from 512KB to 1024KB >> the no. of connections was roughly doubled. So this might be a solution for >> people running out of Desktop heap. >> >> Alter the value of the following key >> >> >> The numeric values following "SharedSection=" control the heap management: >> On WinXP these are the default values: "SharedSection=1024,3072,512" >> Altering this to "SharedSection=1024,3072,1024" will increase the heap for >> all >> non-interactive window stations to 1024KB. > Does this allow creating more connections? At some point, the discussion became too technical for me, and I no longer could tell if the answer was for developers of for users. I saw other messages dealing with semaphores/connection relations, etc. But unless I really did not understand the discussion, none of them seemed to address the issue I was seeing. I'm thinking that the Java driver combined with Hibernate may be keeping handles open for too long, because my tests aren't supposed to maintain connections open for very long. I also would expect the connections to either be closed or released once the statements are executed. > This part should go in the FAQ, I think. It's valid for 8.2 as well, > from what I can tell, and it's valid for 8.3 both before and after the > patch I just applied. > > Dave, you're listed as maintainer :-P > > //Magnus > > ---(end of broadcast)--- > TIP 4: Have you searched our list archives? > >http://archives.postgresql.org/ -- Prenez la parole en public en étant Speak to an audience while being moins nerveux et plus convaincant! less nervous and more convincing! Abonnez-vous au bulletin gratuit! Sign up for the free newsletter! http://www.duperval.com (514) 902-0186 ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit
Hi, Sorry for top-posting but since I am answering questions that don't all appear in this message: - I installed the default download of Postgres. I didn't compile myself, so it's probably the mingw version - Max_connections is set to 500. I did that originally because I kept seeing a message about no connection available and I thought it was because I was not allocating enough connections. My machine has 2GB of RAM. - How do I determine what DLL is failing and what is causing it to fail in its initialization routine? Thanks, L On Tue, 16 Oct 2007 16:02:32 -0700, Trevor Talbot wrote: > On 10/16/07, Alvaro Herrera <[EMAIL PROTECTED]> wrote: >> Laurent Duperval wrote: > >> > >> I get en error in the logs that state: >> > >> >> > >> Server process exited with exit code -1073741502 > > FYI, this exit code means a DLL's initialization routine indicated > failure during process startup. > >> > If I run each test case separately, I don't see this issue. But when I run >> > them as a whole (i.e. run all tests defined in my application) I get the >> > same error every time. >> >> Maybe Eclipse is trying to run more of them at a time than ant, and the >> extra concurrency is killing the server for some reason. > > Sounds likely. > > ---(end of broadcast)--- > TIP 5: don't forget to increase your free space map settings -- Prenez la parole en public en étant Speak to an audience while being moins nerveux et plus convaincant! less nervous and more convincing! Éveillez l'orateur en vous!Bring out the speaker in you! Information: [EMAIL PROTECTED] http://www.duperval.com (514) 902-0186 ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit
I will add that speed may be a factor also. When I increase the amount of logging by the PG server, I see the problem less often. L On Mon, 15 Oct 2007 17:58:48 +, Laurent Duperval wrote: > Hi, > > I have a large amount of tests I run in Eclipse to test my application. > Many of them create and delete a lot of information in PG and at some > point, PG will crash and restart. > > I get en error in the logs that state: > > Server process exited with exit code -1073741502 > . > . > . > Terminating connection because of crash of another server process > > If it helps: > > - I am using Windows XP > - I have 2 GB of memory > - I am using JPA/Hibernate3 and the Postgres Java driver > > Any ideas? > > L > -- Prenez la parole en public en étant Speak to an audience while being moins nerveux et plus convaincant! less nervous and more convincing! Éveillez l'orateur en vous!Bring out the speaker in you! Information: [EMAIL PROTECTED] http://www.duperval.com (514) 902-0186 ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit
On Mon, 15 Oct 2007 15:06:37 -0400, Kris Jurka wrote: >> I get en error in the logs that state: >> >> Server process exited with exit code -1073741502 > > This is likely a server bug. If you can isolate the failing test and > extract a self contained example someone can probably fix it. > It seems to be some sort of interaction between Eclipse and Junit/Postgres driver. When I run my tests, just before the server crash, I have dozens and dozens of spawned Postgres processes. When the crash occurs, all processes are killed and restarted again. And this process continues until the tests complete. When I run the tests from an ant script I also see some spawned processes, but nothing like running it in Eclipse. If I run each test case separately, I don't see this issue. But when I run them as a whole (i.e. run all tests defined in my application) I get the same error every time. L > Kris Jurka > > ---(end of broadcast)--- > TIP 6: explain analyze is your friend -- Prenez la parole en public en étant Speak to an audience while being moins nerveux et plus convaincant! less nervous and more convincing! Éveillez l'orateur en vous!Bring out the speaker in you! Information: [EMAIL PROTECTED] http://www.duperval.com (514) 902-0186 ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
[GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit
Hi, I have a large amount of tests I run in Eclipse to test my application. Many of them create and delete a lot of information in PG and at some point, PG will crash and restart. I get en error in the logs that state: Server process exited with exit code -1073741502 . . . Terminating connection because of crash of another server process If it helps: - I am using Windows XP - I have 2 GB of memory - I am using JPA/Hibernate3 and the Postgres Java driver Any ideas? L -- Prenez la parole en public en étant Speak to an audience while being moins nerveux et plus convaincant! less nervous and more convincing! Éveillez l'orateur en vous!Bring out the speaker in you! Information: [EMAIL PROTECTED] http://www.duperval.com (514) 902-0186 ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
[GENERAL] Pgadmin III Qustion
HI, I'm using pgadmin III 1.2.0 Post Beta 1 (Sept 17 2004). I used it to execute a SQL script that creates tables and inserts data. At the end, I get a message saying that everything went through correctly. However, when I try to view the data in the pgadmin window, nothing shows up. My backend is PG 8.0 Beta 2 on Windows 2000. Any ideas on what the problem could be? Thanks, L ---(end of broadcast)--- TIP 8: explain analyze is your friend
[GENERAL] How to create a trigger
Hello, I know nothing about triggers so I need a little hand-holding here. I'm taking an Oracle script and converting it to pgsql. One of the things that the Oracle database supports is a trigger on dates. So there are two fields in the table, CREATION_DATE and UPDATE_DATE. In the CREAT TABLE statement, I can set both dates using DEFAULT (once I figure out how to get today's date in). But hoiw would I write a trigger that changes the update_date to use the current time? Basically, I guess it would be create trigger date_update before update on mytable for each statement execut procedure [procedure that inserts a date for me in the update_date column] So what would I be doing for the portion in brackets? Thanks, L -- Laurent Duperval <mailto:[EMAIL PROTECTED]> Les plus vigoureux coups de main au destin n'aboutissent pas toujours dans la vie, aux démarrages qu'on attendait. -Alambic Talon ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html