pthread_join() returned exception: Throw location unknown (consider using BOOST_THROW_EXCEPTION)
Dynamic exception type: boost::exception_detail::clone_impl<boost::exception_detail::current_exception_std_exception_wrapper<std::runtime_error> >
std::exception::what: CREATE TABLE planet_osm_roads_tmp AS SELECT * FROM planet_osm_roads ORDER BY CASE WHEN ST_IsEmpty(way) THEN NULL ELSE ST_GeoHash(ST_Transform(ST_Envelope(way),4326),10) END failed: ERROR: GetProj4StringSPI: Cannot find SRID (4326) in spatial_ref_sys
[boost::tag_original_exception_type*] = St13runtime_error
Error occurred, cleaning up
I search the answer long time and can’t find the solution.
Can someone give me a suggestion to solve the problem?
thanks~
It might also help to say what OS you’re running on and where you got osm2pgsql from, what version is it and how you built it (if you did build it yourself). Also what you did to create and prepare the database that you’re working with.
mkdir ~/src
cd ~/src
git clone git://github.com/openstreetmap/osm2pgsql.git
cd osm2pgsql
./autogen.sh
./configure
make
sudo make install
psql -f /usr/local/share/osm2pgsql/900913.sql -d gis
That list looks exactly like what I did to set things up on Ubuntu 12.04 when I last tried it about 3 years ago (but using git instead of svn). There have been changes to many things in the switch2osm 12.04 instructions since when I tried it of course - did any of the response to those commands suggest that something didn’t work, including the postgres/postgis setup?
The installation was very successful when I setup postgres/postgis.
I think it maybe the problem of osm2pgsql.How can I get elder version of osm2pgsql?