K9MAX, German

Running pg_dump produced the following error message:
pg_dump: detail: Error message from server: ERROR: invalid memory alloc request size 18446744073709551613
pg_dump: detail: Command was: COPY public.preview_cards (id, url, title, description, image_file_name, image_content_type, image_file_size, image_updated_at, type, html, .... TO stdout;

Dump File has been created but obviously without the preview card table. Any idea what causes the above error?

michael,
@michael@thms.uk avatar

@K9MAX it means you don’t have enough free memory.

K9MAX,

@michael That‘s what I thought too. However - database size is approximately 1.8 GB and RAM is 16GB at the moment. For a dump it should be sufficient - or not? Can you recommend something which I can do (e. g. stop everything except postgresql) and retry the dump? I would like to avoid upgrading the server now.

michael,
@michael@thms.uk avatar

@K9MAX what else is consuming memory on that server? htop might be able to tell you.

But yes, theoretically if you stop everything but postgres you might have better chances.

K9MAX,

@michael Elasticsearch is running on the same machine with a memory limit of 4GB. I stopped elasticsearch but got the same error message.

michael,
@michael@thms.uk avatar

@K9MAX what’s the output of free -h?

K9MAX,

@michael Good morning!
This is what free -h is telling me:
total 15Gi
used 6.4Gi
free 6.2Gi
shared 1.5Gi
buff/cache 3.0Gi
available 7.4Gi

This should be enough to run a dump I guess. The worst situation would then be a corrupted table.

michael,
@michael@thms.uk avatar

@K9MAX have a look at what @nik suggested yesterday: I think their comment might be more helpful than mine:

https://toot.teckids.org/@nik/112226437317415309

  • All
  • Subscribed
  • Moderated
  • Favorites
  • PostgreSQL
  • DreamBathrooms
  • ngwrru68w68
  • tester
  • magazineikmin
  • thenastyranch
  • rosin
  • khanakhh
  • InstantRegret
  • Youngstown
  • slotface
  • Durango
  • kavyap
  • mdbf
  • tacticalgear
  • JUstTest
  • osvaldo12
  • normalnudes
  • cubers
  • cisconetworking
  • everett
  • GTA5RPClips
  • ethstaker
  • Leos
  • provamag3
  • anitta
  • modclub
  • megavids
  • lostlight
  • All magazines