[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [ gpsdrive ] geoinfo.pl and external link to OSM repository
I let the geoinfo command run through to completion and came across a
few problems. It took about 24 hours to run and it looked to me like it
wasn't plain I/O. More like virtual memory type of disk thrashing but I
have no proof of that. (other programs running at the same time were
extreemly slow)
There were a couple of "gast" permission errors at the top of the output
but it had scrolled off the top of my terminal session by the time the
script had completed.
The streets db table was also empty at the end. I hadn't fiddeled with
the database since I last did a --fill-defaults a few days ago.
The .osm file that was downloaded was about 900mb
So it looks like the default database has some permission issues.
David P
<huge snip>
Writing Segment 3067000 to DB ( -8202%) -3104393 Segments missing;
estimating -1Writing Segment 3068000 to DB ( -8204%) -3105393 Segments
missing; estimating 0.Writing Segment 3069000 to DB ( -8207%) -3106393
Segments missing; estimating -5Writing Segment 3070000 to DB ( -8210%)
-3107393 Segments missing; estimating 0.Writing Segment 3071000 to DB
( -8212%) -3108393 Segments missing; estimating -5Writing Segment
3072000 to DB ( -8215%) -3109393 Segments missing; estimating -5Writing
Segment 3073000 to DB ( -8218%) -3110393 Segments missing; estimating
-5Writing Segment 3074000 to DB ( -8220%) -3111393 Segments missing;
estimating 0.Writing Segment 3075000 to DB ( -8223%) -3112393 Segments
missing; estimating 0.Writing Segment 3076000 to DB ( -8226%) -3113393
Segments missing; estimating -5Writing Segment 3077000 to DB ( -8228%)
-3114393 Segments missing; estimating -5Writing Segment 3078000 to DB
( -8231%) -3115393 Segments missing; estimating 0.Writing Segment
3079000 to DB ( -8234%) -3116393 Segments missing; estimating -5Writing
Segment 3080000 to DB ( -8236%) -3117393 Segments missing; estimating
-5Writing Segment 3081000 to DB ( -8239%) -3118393 Segments missing;
estimating -5Writing Segment 3082000 to DB ( -8242%) -3119393 Segments
missing; estimating -5Writing Segment 3083000 to DB ( -8244%) -3120393
Segments missing; estimating 0.Writing Segment 3084000 to DB ( -8247%)
-3121393 Segments missing; estimating -5Writing Segment 3085000 to DB
( -8250%) -3122393 Segments missing; estimating -5Writing Segment
3086000 to DB ( -8252%) -3123393 Segments missing; estimating -5Writing
Segment 3087000 to DB ( -8255%) -3124393 Segments missing; estimating
0.Writing Segment 3088000 to DB ( -8258%) -3125393 Segments missing;
estimating 0.Writing Segment 3089000 to DB ( -8260%) -3126393 Segments
missing; estimating -5DBD::mysql::st execute failed: ALTER command
denied to user 'gast'@'localhost' for table 'streets'
at /opt/gpsdrive/share/perl5/Geo/Gpsdrive/DBFuncs.pm line 759.
Error in query 'ALTER TABLE streets ENABLE KEYS;'
Download and import of OSM Data FINISHED
On Sun, 2006-12-31 at 13:11 +1100, David wrote:
> I ran geoinfo.pl in debug mode and here is the output.
> It looks a bit odd to me that it is looking for a relative path in the
> perl path.
>
> find_file_in_perl_path(../planet.osm/C/UTF8sanitizer)
>
> I created those folders and stuck the sanitizer in there and it worked.
> I'm not shure where to do a propper fix for this as I can't find where
> the ../planet.osm/C path is specified
>
> =========================================================
> david@debian:/opt/gpsdrive/bin$ ./geoinfo.pl --osm --area=australia
> --debug
>
> Import OSM Data
> Import OSM Data ''
> Download planet-xxxxxx.osm
> mirror_file(http://planet.openstreetmap.org//?C=M;O=D
> --> /home/david/osm/planet/planet_index.html)
> LWP: Not proxied
> LWP: got 806 Bytes (0.0008 MB)
> Simple response: OK
> mirror_file(http://planet.openstreetmap.org//?C=M;O=D): OK
>
> Mirror OSM Data from
> http://planet.openstreetmap.org/planet-061227.osm.bz2
> mirror_file(http://planet.openstreetmap.org/planet-061227.osm.bz2
> --> /home/david/osm/planet/planet-061227.osm.bz2)
> LWP: Not proxied
> LWP: Simple response: Not Modified
> mirror_file(http://planet.openstreetmap.org/planet-061227.osm.bz2): NOT
> MODIFIED
> Choosen File: /home/david/osm/planet/planet-061227.osm.bz2
> UTF8sanitize(/home/david/osm/planet/planet-061227.osm.bz2)
> UTF8 Sanitize /home/david/osm/planet/planet-061227.osm.bz2 ...
> find_file_in_perl_path(../planet.osm/C/UTF8sanitizer): -->
> Sanitizer not found
> =========================================================
>
>
> On Sun, 2006-12-31 at 11:38 +1100, David wrote:
> > On Sun, 2006-12-31 at 00:11 +0100, Joerg Ostertag (gpsdrive
> > Munich/Germany) wrote:
> > > On Saturday 30 December 2006 23:46, Guenther Meyer wrote:
> > > > Am Samstag 30 Dezember 2006 23:28 schrieb David:
> > > > > I'm not sure how the other external files are copied into gpsdrive but
> > > > > perhaps it would be easy to just grab that executable file at the same
> > > > > time and put it somewhere appropriate. It's only 8.5kb
> > > >
> > > > not a good idea IMHO. some people use different platforms/architectures...
> > >
> > > Version 2.10pre3-svn-1181 already containes these changes. And there also is a
> > > new debian x86 package out with it.
> > >
> >
> > I did a fresh checkout and recompile of gpsdrive.
> > I still get the same message. It looks like the sanitizer gets built
> > and installs ok.
> >
> > ======================================================================
> > david@debian:~/build/gpsdrive/trunk/scripts$ ./geoinfo.pl --osm
> > --area=australia
> >
> > Import OSM Data
> > Import OSM Data ''
> > Download planet-xxxxxx.osm
> > UTF8 Sanitize /home/david/osm/planet/planet-061227.osm.bz2 ...
> > Sanitizer not found
> > =======================================================================
> >
> > I also tried running it from the installed location (/opt/gpsdrive/bin)
> > with the same result.
> >
> > David P
> >
> > --
> > This message was part of the gpsdrive mailinglist
> > unsubscribing can be done by sending a mail containing a body of:
> > -quote--
> > unsubscribe gpsdrive
> > -unquote--
> > to majordomo@warbase.selwerd.nl
>
> --
> This message was part of the gpsdrive mailinglist
> unsubscribing can be done by sending a mail containing a body of:
> -quote--
> unsubscribe gpsdrive
> -unquote--
> to majordomo@warbase.selwerd.nl
--
This message was part of the gpsdrive mailinglist
unsubscribing can be done by sending a mail containing a body of:
-quote--
unsubscribe gpsdrive
-unquote--
to majordomo@warbase.selwerd.nl