Search Postgresql Archives

Re: Trouble Upgrading Postgres

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 11/4/18 8:38 AM, Charles Martin wrote:

Adtrian said:
pg_dump: Error message from server: server closed the connection unexpectedly

 >Is this error the client reporting?
 >Is this the same that is showing up in the server log?

Yes, that's the client message, i.e. what appeared in the terminal window that gave the command. The server log shows:

2018-11-02 20:30:46 EDT [20405]: [4-1] user=,db= LOG:  server process (PID 30438) was terminated by signal 9: Killed

2018-11-02 20:30:46 EDT [20405]: [5-1] user=,db= DETAIL:  Failed process was running: COPY public.docfile (docfile_pkey, docfileoriginalname, ordernumber, versionnum, docfilecontents, docfilepath, d$

2018-11-02 20:30:46 EDT [20405]: [6-1] user=,db= LOG:  terminating any other active server processes

2018-11-02 20:30:46 EDT [20415]: [10-1] user=,db= WARNING:  terminating connection because of crash of another server process

2018-11-02 20:30:46 EDT [20415]: [11-1] user=,db= DETAIL:  The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnor$



So where is the server located relative to the pg_dump client?
On the same machine?
If so is it a virtual machine e.g AWS?
Across a local or remote network?


 I gave the command in a terminal session after SSHing to the server from the same network. It is not a virtual machine.


Lsaurenz said:


You probably have a corrupted database.
You should get that fixed first, then you can upgrade.
Maybe you should hire a professional for that.


I suspect this is is correct, both that there is corruption in the table and that I need a professional to help. If someone here is available, I'm interested.

Given that this involves your largest table I would confirm that the signal 9 kill was not coming from the system OOM killer. Take a look at the system logs to see what they show over the same time period.



Andreas said:


 >which exact minor version please?


PostgreSQL 9.6.10 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-23), 64-bit




--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux