Ошибка сегментирования при использовании osm2pgsql

Ответить
Naihil
Новоприбывший
Сообщения: 7
Зарегистрирован: 17 фев 2012, 20:05
Репутация: 0

Ошибка сегментирования при использовании osm2pgsql

Сообщение Naihil » 24 сен 2014, 12:15

Здравствуйте!
Пытаюсь залить данные в PostGis с помощью osm2pgsql, но заканчивается всё ошибкой сегментирования.
Лог osm2pgsql:

Код: Выделить всё

~# osm2pgsql -c -d osm -U пользователь -W -H хост -s -v -C 100 -E EPSG:4326 -G RU-KO-140923.osm.pbf
osm2pgsql SVN version 0.80.0 (64bit id space)

Password:
Using projection SRS 4326 (Latlong)
Setting up table: planet_osm_point
ЗАМЕЧАНИЕ:  таблица "planet_osm_point" не существует, пропускается
ЗАМЕЧАНИЕ:  таблица "planet_osm_point_tmp" не существует, пропускается
Setting up table: planet_osm_line
ЗАМЕЧАНИЕ:  таблица "planet_osm_line" не существует, пропускается
ЗАМЕЧАНИЕ:  таблица "planet_osm_line_tmp" не существует, пропускается
Setting up table: planet_osm_polygon
ЗАМЕЧАНИЕ:  таблица "planet_osm_polygon" не существует, пропускается
ЗАМЕЧАНИЕ:  таблица "planet_osm_polygon_tmp" не существует, пропускается
Setting up table: planet_osm_roads
ЗАМЕЧАНИЕ:  таблица "planet_osm_roads" не существует, пропускается
ЗАМЕЧАНИЕ:  таблица "planet_osm_roads_tmp" не существует, пропускается
Allocating memory for dense node cache
Allocating dense node cache in one big chunk
Allocating memory for sparse node cache
Sharing dense sparse
Node-cache: cache=100MB, maxblocks=12801*8192, allocation method=11
Mid: pgsql, scale=10000000 cache=100
Setting up table: planet_osm_nodes
ЗАМЕЧАНИЕ:  таблица "planet_osm_nodes" не существует, пропускается
Setting up table: planet_osm_ways
ЗАМЕЧАНИЕ:  таблица "planet_osm_ways" не существует, пропускается
Setting up table: planet_osm_rels
ЗАМЕЧАНИЕ:  таблица "planet_osm_rels" не существует, пропускается

Reading in file: RU-KO-140923.osm.pbf
Ошибка сегментирования
Спойлер
2014-09-24 13:09:14 MSK ОТМЕТКА: система БД была выключена: 2014-09-24 13:09:03 MSK
2014-09-24 13:09:14 MSK ОТМЕТКА: система БД готова принимать подключения
2014-09-24 13:09:14 MSK ОТМЕТКА: процесс запуска автоочистки создан
2014-09-24 13:09:14 MSK ОТМЕТКА: неполный стартовый пакет
2014-09-24 13:09:34 MSK ОТМЕТКА: не удалось получить данные от клиента: Соединение сброшено другой стороной
2014-09-24 13:09:34 MSK КОНТЕКСТ: COPY planet_osm_point, строка 1
2014-09-24 13:09:34 MSK ОПЕРАТОР: COPY planet_osm_point (osm_id,"access","addr:housename","addr:housenumber","addr:interpolation","admin_level","aerialway","aeroway","amenity","area","barrier","bicycle","brand","bridge","boundary","building","capital","construction","covered","culvert","cutting","denomination","disused","ele","embankment","foot","generator:source","harbour","highway","historic","horse","intermittent","junction","landuse","layer","leisure","lock","man_made","military","motorcar","name","natural","oneway","operator","poi","population","power","power_source","place","railway","ref","religion","route","service","shop","sport","surface","toll","tourism","tower:type","tunnel","water","waterway","wetland","width","wood","z_order",way) FROM STDIN
2014-09-24 13:09:34 MSK ОШИБКА: неожиданный обрыв соединения с клиентом при открытой транзакции
2014-09-24 13:09:34 MSK КОНТЕКСТ: COPY planet_osm_point, строка 1
2014-09-24 13:09:34 MSK ОПЕРАТОР: COPY planet_osm_point (osm_id,"access","addr:housename","addr:housenumber","addr:interpolation","admin_level","aerialway","aeroway","amenity","area","barrier","bicycle","brand","bridge","boundary","building","capital","construction","covered","culvert","cutting","denomination","disused","ele","embankment","foot","generator:source","harbour","highway","historic","horse","intermittent","junction","landuse","layer","leisure","lock","man_made","military","motorcar","name","natural","oneway","operator","poi","population","power","power_source","place","railway","ref","religion","route","service","shop","sport","surface","toll","tourism","tower:type","tunnel","water","waterway","wetland","width","wood","z_order",way) FROM STDIN
2014-09-24 13:09:34 MSK ОТМЕТКА: не удалось получить данные от клиента: Соединение сброшено другой стороной
2014-09-24 13:09:34 MSK КОНТЕКСТ: COPY planet_osm_line, строка 1
2014-09-24 13:09:34 MSK ОПЕРАТОР: COPY planet_osm_line (osm_id,"access","addr:housename","addr:housenumber","addr:interpolation","admin_level","aerialway","aeroway","amenity","area","barrier","bicycle","brand","bridge","boundary","building","construction","covered","culvert","cutting","denomination","disused","embankment","foot","generator:source","harbour","highway","historic","horse","intermittent","junction","landuse","layer","leisure","lock","man_made","military","motorcar","name","natural","oneway","operator","population","power","power_source","place","railway","ref","religion","route","service","shop","sport","surface","toll","tourism","tower:type","tracktype","tunnel","water","waterway","wetland","width","wood","z_order","way_area",way) FROM STDIN
2014-09-24 13:09:34 MSK ОТМЕТКА: не удалось получить данные от клиента: Соединение сброшено другой стороной
2014-09-24 13:09:34 MSK КОНТЕКСТ: COPY planet_osm_ways, строка 1
2014-09-24 13:09:34 MSK ОПЕРАТОР: COPY planet_osm_ways FROM STDIN;

2014-09-24 13:09:34 MSK ОШИБКА: неожиданный обрыв соединения с клиентом при открытой транзакции
2014-09-24 13:09:34 MSK КОНТЕКСТ: COPY planet_osm_ways, строка 1
2014-09-24 13:09:34 MSK ОПЕРАТОР: COPY planet_osm_ways FROM STDIN;

2014-09-24 13:09:34 MSK ОШИБКА: неожиданный обрыв соединения с клиентом при открытой транзакции
2014-09-24 13:09:34 MSK КОНТЕКСТ: COPY planet_osm_line, строка 1
2014-09-24 13:09:34 MSK ОПЕРАТОР: COPY planet_osm_line (osm_id,"access","addr:housename","addr:housenumber","addr:interpolation","admin_level","aerialway","aeroway","amenity","area","barrier","bicycle","brand","bridge","boundary","building","construction","covered","culvert","cutting","denomination","disused","embankment","foot","generator:source","harbour","highway","historic","horse","intermittent","junction","landuse","layer","leisure","lock","man_made","military","motorcar","name","natural","oneway","operator","population","power","power_source","place","railway","ref","religion","route","service","shop","sport","surface","toll","tourism","tower:type","tracktype","tunnel","water","waterway","wetland","width","wood","z_order","way_area",way) FROM STDIN
2014-09-24 13:09:34 MSK ОТМЕТКА: не удалось получить данные от клиента: Соединение сброшено другой стороной
2014-09-24 13:09:34 MSK КОНТЕКСТ: COPY planet_osm_nodes, строка 1
2014-09-24 13:09:34 MSK ОПЕРАТОР: COPY planet_osm_nodes FROM STDIN;

2014-09-24 13:09:34 MSK ОШИБКА: неожиданный обрыв соединения с клиентом при открытой транзакции
2014-09-24 13:09:34 MSK КОНТЕКСТ: COPY planet_osm_nodes, строка 1
2014-09-24 13:09:34 MSK ОПЕРАТОР: COPY planet_osm_nodes FROM STDIN;

2014-09-24 13:09:34 MSK ОТМЕТКА: не удалось получить данные от клиента: Соединение сброшено другой стороной
2014-09-24 13:09:34 MSK ОТМЕТКА: не удалось получить данные от клиента: Соединение сброшено другой стороной
2014-09-24 13:09:34 MSK ОТМЕТКА: не удалось получить данные от клиента: Соединение сброшено другой стороной
2014-09-24 13:09:34 MSK КОНТЕКСТ: COPY planet_osm_polygon, строка 1
2014-09-24 13:09:34 MSK ОПЕРАТОР: COPY planet_osm_polygon (osm_id,"access","addr:housename","addr:housenumber","addr:interpolation","admin_level","aerialway","aeroway","amenity","area","barrier","bicycle","brand","bridge","boundary","building","construction","covered","culvert","cutting","denomination","disused","embankment","foot","generator:source","harbour","highway","historic","horse","intermittent","junction","landuse","layer","leisure","lock","man_made","military","motorcar","name","natural","oneway","operator","population","power","power_source","place","railway","ref","religion","route","service","shop","sport","surface","toll","tourism","tower:type","tracktype","tunnel","water","waterway","wetland","width","wood","z_order","way_area",way) FROM STDIN
2014-09-24 13:09:34 MSK ОШИБКА: неожиданный обрыв соединения с клиентом при открытой транзакции
2014-09-24 13:09:34 MSK КОНТЕКСТ: COPY planet_osm_polygon, строка 1
2014-09-24 13:09:34 MSK ОПЕРАТОР: COPY planet_osm_polygon (osm_id,"access","addr:housename","addr:housenumber","addr:interpolation","admin_level","aerialway","aeroway","amenity","area","barrier","bicycle","brand","bridge","boundary","building","construction","covered","culvert","cutting","denomination","disused","embankment","foot","generator:source","harbour","highway","historic","horse","intermittent","junction","landuse","layer","leisure","lock","man_made","military","motorcar","name","natural","oneway","operator","population","power","power_source","place","railway","ref","religion","route","service","shop","sport","surface","toll","tourism","tower:type","tracktype","tunnel","water","waterway","wetland","width","wood","z_order","way_area",way) FROM STDIN
2014-09-24 13:09:34 MSK ОТМЕТКА: не удалось получить данные от клиента: Соединение сброшено другой стороной
2014-09-24 13:09:34 MSK ОТМЕТКА: не удалось получить данные от клиента: Соединение сброшено другой стороной
2014-09-24 13:09:34 MSK ОТМЕТКА: не удалось получить данные от клиента: Соединение сброшено другой стороной
2014-09-24 13:09:34 MSK КОНТЕКСТ: COPY planet_osm_rels, строка 1
2014-09-24 13:09:34 MSK ОПЕРАТОР: COPY planet_osm_rels FROM STDIN;

2014-09-24 13:09:34 MSK ОШИБКА: неожиданный обрыв соединения с клиентом при открытой транзакции
2014-09-24 13:09:34 MSK КОНТЕКСТ: COPY planet_osm_rels, строка 1
2014-09-24 13:09:34 MSK ОПЕРАТОР: COPY planet_osm_rels FROM STDIN;

2014-09-24 13:09:34 MSK ОТМЕТКА: не удалось получить данные от клиента: Соединение сброшено другой стороной
2014-09-24 13:09:34 MSK ОТМЕТКА: не удалось получить данные от клиента: Соединение сброшено другой стороной
2014-09-24 13:09:34 MSK КОНТЕКСТ: COPY planet_osm_roads, строка 1
2014-09-24 13:09:34 MSK ОПЕРАТОР: COPY planet_osm_roads (osm_id,"access","addr:housename","addr:housenumber","addr:interpolation","admin_level","aerialway","aeroway","amenity","area","barrier","bicycle","brand","bridge","boundary","building","construction","covered","culvert","cutting","denomination","disused","embankment","foot","generator:source","harbour","highway","historic","horse","intermittent","junction","landuse","layer","leisure","lock","man_made","military","motorcar","name","natural","oneway","operator","population","power","power_source","place","railway","ref","religion","route","service","shop","sport","surface","toll","tourism","tower:type","tracktype","tunnel","water","waterway","wetland","width","wood","z_order","way_area",way) FROM STDIN
2014-09-24 13:09:34 MSK ОШИБКА: неожиданный обрыв соединения с клиентом при открытой транзакции
2014-09-24 13:09:34 MSK КОНТЕКСТ: COPY planet_osm_roads, строка 1
2014-09-24 13:09:34 MSK ОПЕРАТОР: COPY planet_osm_roads (osm_id,"access","addr:housename","addr:housenumber","addr:interpolation","admin_level","aerialway","aeroway","amenity","area","barrier","bicycle","brand","bridge","boundary","building","construction","covered","culvert","cutting","denomination","disused","embankment","foot","generator:source","harbour","highway","historic","horse","intermittent","junction","landuse","layer","leisure","lock","man_made","military","motorcar","name","natural","oneway","operator","population","power","power_source","place","railway","ref","religion","route","service","shop","sport","surface","toll","tourism","tower:type","tracktype","tunnel","water","waterway","wetland","width","wood","z_order","way_area",way) FROM STDIN
2014-09-24 13:09:34 MSK ОТМЕТКА: не удалось получить данные от клиента: Соединение сброшено другой стороной
2014-09-24 13:09:34 MSK ОТМЕТКА: не удалось получить данные от клиента: Соединение сброшено другой стороной
Файл брал с http://be.gis-lab.info/data/osm_dump/dump/RU-KO/ за 23 число, перекачивал 2 раза для верности.
Кто-то с подобным сталкивался?

Naihil
Новоприбывший
Сообщения: 7
Зарегистрирован: 17 фев 2012, 20:05
Репутация: 0

Re: Ошибка сегментирования при использовании osm2pgsql

Сообщение Naihil » 24 сен 2014, 15:11

Собрал версию из гит, она выдала сообщение о нехватке памяти:
Out of memory for node cache dense index, try using "--cache-strategy sparse" instead
Данная опция помогла, импорт прошёл

Ответить

Вернуться в «PostGIS/PostgreSQL»

Кто сейчас на конференции

Сейчас этот форум просматривают: нет зарегистрированных пользователей и 9 гостей