WahineLil
11-26-2008, 02:09 AM
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.
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.