Postgres SQL Fatal Errors

[WahineLil]

I'm having an issue with Postgres SQL not initializing. Searched the FAQ's & couldn't find anything about this.

When I launch Holdem Manager, I get an error that the program "failed to establish connection to 127.0.0.1

The program then launches the Database Control Panel. I hit the "connect" button and get the error message that "A connection to PostgresSQL could not be made. Would you like to have Holdem Manager attempt to start the service?" I hit Yes. I get the message that the program has started the service and to please try again. I hit connect.

I get the following long error message:

Connection Error: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.

System.IO.IOException: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. ---> System.Net.Sockets.SocketException: An existing connection was forcibly closed by the remote host

at System.Net>Sockets>Socket.Receive(Byte[]buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
at System.Net,Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
--End of inner exception stack trace--
at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
at System.IO.BufferedStream.ReadByte[]
at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext[]
...

There's more -- I hope I don't have to type all the rest of that out. There's no apparent way to copy/paste the text of the message.

I've tried uninstalling & reinstalling PostgresSql, but that accomplished nothing.

If it's useful, I'm getting an "unable to initialize" error for PostgresSql when I reboot the computer as well - and weirdly enough, I was getting the same error message even when I reboot after I'd uninstalled PostgresSql and BEFORE I'd reinstalled it.

I'm at my wit's end. :(

EDIT:

Took a look at the log files -- at the end of the log file for the last session in which I was able to run the program successfully, I found this:

(I have no idea how to do that "code" paste thing)


2008-11-23 18:23:28 EST LOG: could not receive data from client: No connection could be made because the target machine actively refused it.


2008-11-23 18:23:28 EST LOG: unexpected EOF on client connection
2008-11-23 18:23:30 EST LOG: could not receive data from client: No connection could be made because the target machine actively refused it.


2008-11-23 18:23:30 EST LOG: unexpected EOF on client connection
2008-11-23 18:24:04 EST LOG: received fast shutdown request
2008-11-23 18:24:04 EST LOG: aborting any active transactions
2008-11-23 18:24:04 EST LOG: autovacuum launcher shutting down
2008-11-23 18:24:25 EST LOG: shutting down
2008-11-23 18:24:26 EST LOG: database system is shut down

Then all the log files created following that session begin with:

2008-11-23 18:25:58 EST LOG: database system was shut down at 2008-11-23 18:24:26 EST
2008-11-23 18:25:58 EST LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2008-11-23 18:25:58 EST FATAL: the database system is starting up
2008-11-23 18:25:58 EST LOG: unexpected pageaddr 1/58000000 in log file 1, segment 96, offset 0
2008-11-23 18:25:58 EST LOG: invalid primary checkpoint record
2008-11-23 18:25:58 EST LOG: unexpected pageaddr 1/58000000 in log file 1, segment 96, offset 0
2008-11-23 18:25:58 EST LOG: invalid secondary checkpoint record
2008-11-23 18:25:58 EST PANIC: could not locate a valid checkpoint record


This application has requested the Runtime to terminate it in an unusual way.
Please contact the application's support team for more information.

Hopefully that log file info will be helpful.

[Al1]

Try that:
http://208.109.95.123/faq/afmviewfaq.aspx?faqid=34

[WahineLil]

OK - that was no help at all. I'm not having a firewall issue -- I'm having an issue with PostgresSql being unable to initialize. When I attempt to start it manually I get a "encountered a fatal error" message, including a "send this error report to Microsoft" dialogue.

The problem is a SQL problem -- not a firewall problem. I've been running Holdem Manager with no problems whatsoever until Nov. 23rd when I had what appeared to be some sort of crash as shown in the log files I copied & pasted into my original message.

I'm running version 8.3 of PostgresSql. I'm running Windows XP Pro. My firewall is properly configured. There are no other programs on this machine that use PostgresSql -- if there were, they'd have exactly the same problem.

Please re-read my initial post.

[fabio]

Please go to Control panel -> administrative tools -> event viewer and doubleclick on the postgresql error in the list and paste the error message

[WahineLil]

There are several:

Fault bucket 941241750.

Faulting application postgres.exe, version 8.3.4.8262, faulting module postgres.exe, version 8.3.4.8262, fault address 0x0024a529.

2008-11-26 16:43:11 GMT FATAL: lock file "postmaster.pid" already exists
2008-11-26 16:43:11 GMT HINT: Is another postmaster (PID 4416) running in data directory "C:/Program Files/PostgreSQL/8.3/data"?

Those error files are repeated several times. I'm assuming they exist for each time the error occurred.

[fabio]

Delete the postmaster.pid in C:/Program Files/PostgreSQL/8.3/data and restart the service, that should fix your problem

[WahineLil]

I've searched every file & folder in the C:/Program Files/PostgreSQL folder and all subfolders and can't find any file named postmaster.pid. I also searched for any file with the .pid extension -- no dice. I've searched hidden files as well as normal files.

The only postmaster file is postmaster.opts

[fabio]

Please email me at fabio@holdemmanager.net to arrange a date and time for a Teamviewer session so I can help you.

[WahineLil]

Email sent. Thanks.

[iNsano]

Did you get this problem sorted out? I am currently having the same problem.

Any help would be greatly appreciated.

Thanks

[WahineLil]

I did get it resolved, but only with the help of a remote connect session with the great tech support folks here. You might want to post your own thread or send an email to tech support so they can help you out. I'm not exactly sure what they did to get it working.

I think they had to reconfigure the database or create a new one, and I did lose the data I had in the old database (I still have the hand history files & can import those if I need to). Since I didn't have a ton of data collected already, that was an acceptable solution for me.

[fauzul_azmi]

I got error when start postgresql service with linux. message showed :
2010-05-26 20:04:18 WITHINT: This probably means that some data is corrupted and you will have to use the last backup for recovery.
2010-05-26 20:04:18 WITLOG: database system was not properly shut down; automatic recovery in progress
2010-05-26 20:04:18 WITLOG: redo starts at 25/E93C6B18
2010-05-26 20:04:18 WITLOG: unexpected pageaddr 25/E2490000 in log file 37, segment 233, offset 4784128
2010-05-26 20:04:18 WITLOG: redo done at 25/E948DCA0
2010-05-26 20:04:18 WITPANIC: cannot make new WAL entries during recovery
2010-05-26 20:04:18 WITLOG: startup process (PID 1995) was terminated by signal 6: Aborted
2010-05-26 20:04:18 WITLOG: aborting startup due to startup process failure


somebody please help me so that I wouldn't be lost data

Thanks in advance

[morny]

Sounds like the database is corrupt, can you create a new database FAQ - Hold'em Manager Poker Tracking Software :: Create / Delete Database (http://faq.holdemmanager.com/questions/75/Create+%7B47%7D+Delete+Database) and reimport your archived hands into the new database

[scoop05333]

am at with my wits end with trying to get HEM to work again. went away for a week and came back, had lots of updates etc and now it wont work. have done all the walkthroughs etc, including http://forums.holdemmanager.com/manager-general/8182-fix-postgresql-cannot-start-error-127-0-0-1-a.html and nothing. any thoughts or chance of a TV session?

[netsrak]

Did you reboot your computer 1-2 times after installing all the windows updates?
Did you check the FAQ? FAQ - Hold'em Manager Poker Tracking Software :: Can&#039;t Connect / Failed to Start PostgreSQL (http://faq.holdemmanager.com/questions/91/Can%27t+Connect+%7B47%7D+Failed+to+Start+PostgreSQ L+)

If you can't figure it out you can arrange a teamviewer session via support@holdemmanager.net. Please add a link to this thread and a problem description.

[scoop05333]

pimp, its all good now. thank you very much for all your help.

ty