drolbr / Overpass-API

A database engine to query the OpenStreetMap data.
http://overpass-api.de
GNU Affero General Public License v3.0
692 stars 90 forks source link

Block_Backend: an item's size exceeds block size. #651

Open mmd-osm opened 2 years ago

mmd-osm commented 2 years ago

I’m creating this issue to track the db update failure caused by a 200k member relation across a number of overpass instances.

Flushing to database .......File error caught: /mnt/home-ssdd/overpass/db/relations_attic.bin Block_Backend: an item's size exceeds block size.

Related issues:

dakotabenjamin commented 2 years ago

We have also experienced this issue on the HOTOSM Export Tool Overpass server. Happy to provide any additional details if needed.

mmd-osm commented 2 years ago

Quoting from: https://listes.openstreetmap.fr/wws/arc/overpass/2022-01/msg00001.html

From version 0.7.57 on, the database backend can handle very large objects.

Is there any way to proceed with the current installation?

There is an automatic migration from 0.7.56 to 0.7.57. If you start the update process of 0.7.57 on a 0.7.56 database, it will write back the 0.7.57 format.

So I guess all Overpass instance which stopped updating on January 14 were running some pre-0.7.57 release.