Is firewall involved ???
Main Topics
Browse All TopicsI've run into a problem which I'm having a hard time fixing... a few couple of months ago I've switched from a jsp reporting scheme to one using datavision. I've field tested it for a few weeks and it was ok. However, when writing a very complex script it started creating errors on the client side which came up something like:
Could not create Connection: Cannot create PoolableConnectionFactory (
An I/O error occured while reading from backend - Exception: java.net.SocketException:
Connection reset Stack Trace: java.net.SocketException:
Connection reset at java.net.SocketInputStream
java.io.BufferedInputStrea
java.io.BufferedInputStrea
org.postgresql.core.PGStre
org.postgresql.jdbc1.Abstr
org.postgresql.jdbc1.Abstr
org.postgresql.Driver.conn
.....
At first, I thought maybe it was my script... so I tried running the script from PgAdmin (at this point I haven't done anything with the connection) and the script ran fine... so I tried restarting postmaster.. which didn't work. After which I tried restarting the server, this seemed to have remedied the problem. This was a couple of days after the problem surfaced... now I get this message almost every time and restarting doesn't seem to help, PgAdmin likewise cannot access the database as well. I've been looking around and initially thought it may be just a jdbc problem... however when I took a look at the postmaster logs I got...
2005-04-29 20:18:56 LOG: database system was shut down at 2005-04-29 20:18:34 China Standard Time
2005-04-29 20:18:56 LOG: checkpoint record is at 0/201A178
2005-04-29 20:18:56 LOG: redo record is at 0/201A178; undo record is at 0/0; shutdown TRUE
2005-04-29 20:18:56 LOG: next transaction ID: 6344; next OID: 18598
2005-04-29 20:18:56 LOG: database system is ready
2005-04-29 20:23:47 LOG: could not receive data from client: An operation was attempted on something that is not a socket.
2005-04-29 20:23:47 LOG: incomplete startup packet
2005-04-29 20:23:48 LOG: could not receive data from client: An operation was attempted on something that is not a socket.
2005-04-29 20:23:48 LOG: incomplete startup packet
I am unsure if my complex scripts had anything to do with this, however, I don't believe this that was the root of the problem. Has anyone encountered similar scenarios?
I placed this problem on the back-burner since it was for non-essential upgrades... needless to say, I have more time on my hands now so I'm revisiting the problem...
--
Regards,
Kal Chung
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.

Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Nope not a problem with the SSL keys... yes I have a firewall installed Zonealarm Security Suite version 6.0.631 . Although I don't think the firewall is the issue since I'm pretty sure I got the settings right and the firewall has been there since the time I built the application, and I've only run into problems that one time.
Just an added info.. the production version of the application runs fine... however, the problem is specific to the development machine (which is my laptop, formatting and reinstalling everything is not an option for me right now)..
Could it be due to a dump file or some config file on the postgeSQL side that hasn't been cleaned up properly?
Ahhhh.... ok... but I was referring to uncleaned files let say from a bad program termination... such as power failure and the such. Since I remember from my tests before that the postmaster.pid sometimes gets left behind and prevents postgreSQL from starting... was just wondering if perhaps a similar situation is happening here... except with a different file...
I have also tried using 127.0.0.1, ping doesn't work... haven't tried psql yet though.... I'm a bit iffy on the driver though since the latest PgAdmin III which was supposedly paired with version 8 of postgres so it should be using the same drivers (I've tried reinstalling PgAdmin III as well)...
In anycase, I was going to try reinstalling postgres... however, while downloading a more up to date copy of postgres I also tried downloading phpPgAdmin from sourceforge... funny thing is after I've downloaded both I tried installing phpPgAdmin then did a quick reboot (actually there was a power failure and since my laptop's battery is already dead it died). When power was restored I started the laptop and lo and behold it started working again... quite weird....
I haven't reinstalled postgreSQL yet at this point, only phpPgAdmin I used phpPgAdmin first, since I was hoping that would at least work... when it worked I tried the existing installation of PgAdmin III then my application(all seemed to work). A very weird set of circumstances... and I have no idea what fixed it.... I'll keep monitoring it for a while and post back some status on the forum for documentation purposes...
gheist, earthman2 thanks for your input... I'll keep you posted on this and will post back again if there are any recurring problems...
Apparently that was wishful thinking, after a week or two the problem resurfaced... I have also attemped to reinstall PostgreSQL with no avail. I noted seeing something regarding this problem in msn just yesterday... I will have a look at that and update my findings here...
If anyone has any other suggestions please feel free to add your two cents :)
Earthman2 & gheist,
Thanks for helping me out... although I had the question closed... I'd like to award each of you 50 points for your time and effort...
http://www.experts-exchang
when you have both placed posts on the thread I'll go ahead and award them...
Business Accounts
Answer for Membership
by: earthman2Posted on 2005-08-20 at 06:21:08ID: 14715529
Is this a problem with your SSL keys ?