Search Postgresql Archives

Re: invalid memory alloc request size

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

 




On 12/10/2014 02:34 PM, Adrian Klaver wrote:
On 12/10/2014 10:08 AM, Gabriel Sánchez Martínez wrote:

On 12/10/2014 01:00 PM, Adrian Klaver wrote:
On 12/10/2014 09:54 AM, Gabriel Sánchez Martínez wrote:

On 12/10/2014 12:47 PM, Adrian Klaver wrote:
On 12/10/2014 09:25 AM, Gabriel Sánchez Martínez wrote:

On 12/10/2014 11:49 AM, Adrian Klaver wrote:
On 12/10/2014 08:31 AM, Gabriel Sánchez Martínez wrote:

On 12/10/2014 11:16 AM, Adrian Klaver wrote:
On 12/10/2014 08:07 AM, Gabriel Sánchez Martínez wrote:
Hi all,



Also how did the Postgres server get installed?

apt-get install

Install from what repo?

The default Ubuntu repository.







The database was
upgraded to 9.3 when Ubuntu was upgraded to 14.04.  But I ran it for a
while without issues.  This issue is recent.

So what was the version before?

9.1.  It has always been whatever was on the Ubuntu repos.


Where I am going with this, is trying to determine whether you have a
'contaminated' data directory.

I appreciate it!  Perhaps it is worth mentioning that the server had
some issues with the linux md raid a while back.  Two disks failed in
quick succession and some data was corrupted.  Those disks have been
replaced and the RAID has been fine ever since.  The database cluster
was recreated from scratch after that, from backups of a few months
before the disks started misbehaving.  This is when that table was
created with pg_restore.  There were no issues with the restore, and the
backup was from a few months before the disk issue, so I don't suspect
corruption in the backup.

I would investigate the possibility that the raid is having problems again.

Everything looks good right now. I ran SMART checks on all drives and there were no errors. I will restore the table from an earlier backup and let you know if that takes care of the issue. Thanks for your help, and please let me know if there is anything else I could do. I'll reply to the list if there are any developments.









--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[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