database - PostgreSQL 9.4 suddenly invalid memory alloc request size -

-

i'm building website used handle excel files stores , manipulate them (merging, view, etc.). i'm using postgresql 9.4 database, running on centos 6.6 vm 4gb ram. has 3 databases follow:

  • postgres database
  • db_raw, used placeholder data. excel uploaded website parsed, , data stored here. database consists of few tables used keep data required process excel, , huge table storing excel data >140 column , 1 million row
  • db_processed, main database website. has few small tables operational of website (user table, access list, logging, etc), , 8 tables store processed excel data db_raw. each of 8 tables have around 40 column , million row.

the databases running fine until morning. tried connecting db_processed through pgadmin , putty, , postgresql gave me message

fatal:  invalid memory alloc request size 144115188075856068

db_raw works fine, , nothing has been changed since 3 days ago far know. should can connect database again?

update : did @craigringer said , restarted service. manage connect database, tables gone :| keeps appearing in log

< 2015-09-21 12:27:22.155 wib >debug:  performing replication slot checkpoint < 2015-09-21 12:27:22.158 wib >log:  request flush past end of generated wal; request 46/9e0981d8, currpos 46/771c69b0 < 2015-09-21 12:27:22.158 wib >context:  writing block 2 of relation base/18774/12766 < 2015-09-21 12:27:22.158 wib >error:  xlog flush request 46/9e0981d8 not satisfied --- flushed 46/771c69b0 < 2015-09-21 12:27:22.158 wib >context:  writing block 2 of relation base/18774/12766 < 2015-09-21 12:27:22.158 wib >warning:  not write block 2 of base/18774/12766 < 2015-09-21 12:27:22.158 wib >detail:  multiple failures --- write error might permanent.

this indicates corrupted data. faced problem , discovered @ least ways of how solve it.

the first way described here: https://confluence.atlassian.com/jirakb/invalid-memory-alloc-request-size-440107132.html
second described here: http://blog.dob.sk/2012/05/19/fixing-pg_dump-invalid-memory-alloc-request-size/

it cool improve function of second approach make automatic, though.


Comments

Post a Comment

Popular posts from this blog

java - Date formats difference between yyyy-MM-dd'T'HH:mm:ss and yyyy-MM-dd'T'HH:mm:ssXXX -

-
i trying parse date 2014-12-03t10:05:59.5646+08:00 using these 2 formats: yyyy-mm-dd't'hh:mm:ss yyyy-mm-dd't'hh:mm:ssxxx when parse using yyyy-mm-dd't'hh:mm:ss works fine, when parse yyyy-mm-dd't'hh:mm:ssxxx parseexception thrown. which correct format parse date , difference between these 2 formats? note : cannot use joda :( those valid formats: yyyy-mm-dd't'hh:mm:ss.sssz >>> e.g.: 2001-07-04t12:08:56.235-0700 yyyy-mm-dd't'hh:mm:ss.sssxxx >>> e.g.: 2001-07-04t12:08:56.235-07:00 edit: btw, "x" refer (iso 8601 time zone)
Read more

c# - Get rid of xmlns attribute when adding node to existing xml -

-
i have xml-file: <ns2:root xmlns:ns2="namespace"> <ns2:a> <ns2:b>some content</b> <ns2:c>some content</c> <ns2:d>some content</d> </a> </root> i need add new node in specific place, code is: var doc = xdocument.load(file); xnamespace ns2 = "namespace"; doc.element(ns2 + "root").element(ns2 + "a").element(ns2 + "c").addafterself( new xelement(ns2+"new", new xelement("new1", new xelement("new2","some content"), new xelement("new3", "some content")))); the output is: <ns2:root xmlns:ns2="namespace"> <ns2:a> <ns2:b>some content</b> <ns2:c>some content</c> <ns2:new> <new1 xmlns=""> <new2>some content</new2> ...
Read more