Hi guys,

i seem to be having a bit of an issue importing Europe PBF

terminate called after throwing an instance of 'std::runtime_error'
  what():  CREATE INDEX planet_osm_ways_nodes ON planet_osm_ways USING gin (nodes) WITH (FASTUPDATE=OFF) ;
 failed: ERROR:  could not extend file "base/16385/4138500.7": No space left on device
HINT:  Check free disk space.

osm@osm-tiles:~$ df -h
Filesystem      Size  Used Avail Use% Mounted on
/dev/root       440G  313G  105G  75% /
devtmpfs         16G     0   16G   0% /dev
tmpfs            16G  4.0K   16G   1% /dev/shm
tmpfs            16G  1.6G   15G  10% /run
tmpfs           5.0M     0  5.0M   0% /run/lock
tmpfs            16G     0   16G   0% /sys/fs/cgroup

As you can see, i have 25% of my disk space available, or has it removed stuff once its realised its not enough space?

asked 01 May '18, 10:09

gaza1994's gravatar image

accept rate: 0%


Could you give us more of a clue - starting with what software you were actually running?

Can you import something smaller? Does that work OK?

(01 May '18, 10:20) SomeoneElse ♦

Yes, Postgres will remove the intermediate files. CREATE INDEX is an atomic operation, so there is no point in keeping files of the failed operation around. watch df -h / while the import is ongoing will show you how far it goes. There may also be quotas or mount options that prevent non-root users from filling up the disk completely, but the threshold is certainly higher than 25%.

permanent link

answered 01 May '18, 10:22

Vincent%20de%20Phily's gravatar image

Vincent de P... ♦
accept rate: 19%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 01 May '18, 10:09

question was seen: 708 times

last updated: 01 May '18, 10:22

powered by OSQA