[GENERAL] ABRUPT CLOSURE OF POSTGRESQL SOCKET
Hi, I am running postgresql 7.1.3 in RedHat Linux 7.2. From an external C application, three connections are established with postmaster (it is started with -i option) through unix sockets. Two times I received EPIPE error when trying to send a query to postmaster. This is because of the abrupt closure of pgsql backend. The query sent is formed dynamically and hence I'm unable to get the query whose processing may have led to such abrupt closure. But this application is working for 2 years till now without any such problems. So I don't really suspect the query. The postgresql todo lists that usage of views can lead to such abrupt closure. But there are no views used in my application. The another possbile reason for abnormal closure that I understand is if the hard disk is full. But this is also not the case. Pgsql log shows the following message : = DEBUG: ProcessQuery DEBUG: CommitTransactionCommand NOTICE: RelationBuildDesc: can't open pg_trigger: Too many open files in system pq_recvbuf: unexpected EOF on client connection DEBUG: proc_exit(0) DEBUG: shmem_exit(0) DEBUG: exit(0) /usr/bin/postmaster: reaping dead processes... /usr/bin/postmaster: CleanupProc: pid 28312 exited with status 11 Server process (pid 28312) exited with status 11 at Wed Oct 27 17:00:02 2004 Terminating any active server processes... /usr/bin/postmaster: CleanupProc: sending SIGQUIT to process 28250 /usr/bin/postmaster: CleanupProc: sending SIGQUIT to process 28248 /usr/bin/postmaster: CleanupProc: sending SIGQUIT to process 28204 /usr/bin/postmaster: CleanupProc: sending SIGQUIT to process 28162 /usr/bin/postmaster: CleanupProc: sending SIGQUIT to process 20173 /usr/bin/postmaster: CleanupProc: sending SIGQUIT to process 20171 /usr/bin/postmaster: CleanupProc: sending SIGQUIT to process 20170 /usr/bin/postmaster: CleanupProc: pid 28162 exited with status 0 /usr/bin/postmaster: reaping dead processes... /usr/bin/postmaster: ServerLoop:handling reading 5 /usr/bin/postmaster: ServerLoop:handling reading 5 NOTICE: Message from PostgreSQL backend: The Postmaster has informed me that some other backend died abnormally and possibly corrupted shared memory. I have rolled back the current transaction and am going to terminate your database system connection and exit. Please reconnect to the database system and repeat your query. /usr/bin/postmaster: reaping dead processes... Coming to the question, == a. What could be the reason for abnormal closure of postmaster socket? b. How can the application detect such a abnormal closure of socket? -- regards, Deepa K ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
[GENERAL] How to connect with postmaster through TCP socket
Hi, I am using postgresql 7.1.3 in RedHatLinux 7.2. Can anyone tell me how to connect with postmaster through TCP socket (it is started with -i option) using libpq from an external application. (written in C) -- regards, Deepa K ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[GENERAL] [Fwd: Abrupt close of pgsql backend]
Original Message Subject: Abrupt close of pgsql backend From:Deepa K [EMAIL PROTECTED] Date:Mon, October 25, 2004 8:04 pm To: [EMAIL PROTECTED] -- Hi, I am running postgresql 7.1.3 in RedHat Linux 7.2. From an external C application, three connections are established with postmaster (it is started with -i option) through unix sockets. Two times I received EPIPE error when trying to send a query to postmaster. This is because of the abrupt closure of pgsql backend. The query sent is formed dynamically and hence I'm unable to get the query whose processing may have led to such abrupt closure. But this application is working for 2 years till now without any such problems. So I don't really suspect the query. The postgresql todo lists that usage of views can lead to such abrupt closure. But there are no views used in my application. The last reason, for abnormal closure that I understand is if the hard disk is full. But this is also not the case under study. Coming to the question, a. What are the (other) reasons for postmaster closing sockets abnormally? b. How can the application detect such a abnormal closure of socket? -- regards, Deepa K -- regards, Deepa K ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [GENERAL] IP clash in the PC
Hi, Yes, in other PC, PG is running. But, PG load is not getting load. And also I think it is possible to reach the other PC from this PC as Eth0 is not up (because of clash). 1. Load running PC - Eth0 is not up 2. Other PC- Eth0 is up The only thing *I* can think of is... is the other computer using your IP address running a PG database? Is it possible the other computer is getting the PG load? -Ben On Wednesday 25 August 2004 06:32, you wrote: Hi, In my PC, eth0 is not up because of IP address clash (another PC is using the same IP address). I tried to execute a file which has set of insert commands. After executing the file, when I go and see the database, no rows are inserted. I redirected the output to another file. It shows success for all inserts, but no rows in database. This is happening only when the PC has IP clash, that too not all times. I wasn't able to trace out the problem as it is occuring rarely. Steps followed : == 1. Linux installation (PC with IP adderss clash) 2. Running psql -U corview manager -f filename out Can any one help me regarding this. -- regards, Deepa K ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED]) -- I kept looking around for somebody to solve the problem. Then I realized I am somebody -Anonymous -- regards, Deepa K -- regards, Deepa K ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
[Fwd: Re: [GENERAL] IP clash in the PC]
Original Message Subject: Re: [GENERAL] IP clash in the PC From:Deepa K [EMAIL PROTECTED] Date:Thu, August 26, 2004 10:56 am To: Jan Wieck [EMAIL PROTECTED] -- Hi, Yes I am contacting right database server. I am sure, because when tried to execute two files simulataneously, one file got executed and other one failed. On 8/25/2004 9:32 AM, Deepa K wrote: Hi, In my PC, eth0 is not up because of IP address clash (another PC is using the same IP address). I tried to execute a file which has set of insert commands. After executing the file, when I go and see the database, no rows are inserted. I redirected the output to another file. It shows success for all inserts, but no rows in database. This is happening only when the PC has IP clash, that too not all times. I wasn't able to trace out the problem as it is occuring rarely. So the database server is responding with transaction commits while ignoring what you updated? I have a hard time to believe that. Are you sure that you are contacting the right database server while there is an IP address clash in progress? Jan Steps followed : == 1. Linux installation (PC with IP adderss clash) 2. Running psql -U corview manager -f filename out Can any one help me regarding this. -- #==# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #== [EMAIL PROTECTED] # -- regards, Deepa K -- regards, Deepa K ---(end of broadcast)--- TIP 3: 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
[GENERAL] COPY COMMAND
Hi All, Is it possible to insert n rows with 1 or 2 invalid rows using copy command. I used it, it rollbacks everything even if 1 row gets an error. Is their any other way to do it. TIA -- regards, Deepa K.
[GENERAL] About Pgdump
Hi all, I want to take backup of our online system on daily basis using crontab. But actually the pg_hba.conf is configured with password security. How I can take the backup without setting password. Or is their any other way to take backup. TIA regards, Deepa K ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[GENERAL] Arrays is stored procedure
Hi all, Is it possible to declare a bit array in pgsql procedure. If so how to read and write values in that array. regards, Deepa K. ---(end of broadcast)--- TIP 3: 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
[GENERAL] PQgetResultSet Problem
Hi all, I am using postgresql 7.1.3 and a client using libpq. I am executing a statement with muliple SQL commands semicolon seperated. If any one of the query in between fails, pqGetResultset returns NULL on the failed query. So i am unable to process the rest of the queries. Also the queries which were before the failed query, which were successful, were also not commited to the database. (eg) query1;query2;query3;query4 If query1 is successful and query2 fails, the pqGetResultset returns NULL on query2. So my client comes out of while (pqGetResultSet). The query1 which was successful was also not commited to the database. If i run the same from psql client, the query2 alone fails, the rest other are inserted to the database. I am expecting the same behaviour as that of psql. Plz somebody help me in this regard. TIA. Regards, Deepa ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
[GENERAL] ERROR STRINGS IN PGSQL
Hi All, Is proper error numbers are defined for all error strings returned by pgsql c library. Is so, where can I get those error numbers and is it possible to return error strings using error numbers. regards, Deepa K. ---(end of broadcast)--- TIP 3: 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
[GENERAL] Can trigger return value
Hi, Thanks for your prompt reply. I think I didn't explained the problem clearly. Actually when a client (from an application like java) tries to access the server database which is in network How could I solve the problem. Is 'RAISE EXCEPTION' solves the above problem. If so please explain me. regards, Deepa K. ---(end of broadcast)--- TIP 8: explain analyze is your friend