[OSM-dev] Problem in rake db:migrate with postgre

[M Naveed Akram]

thanks to all
UTF8 issue resolved.

but now its osmosis


./osmosis --read-xml-0.6 file="/tmp/data.osm" --write-apidb-0.6
 host="localhost" database="openstreetmap" user="openstreetmap"
password="aopen" validateSchemaVersion=no

Jun 4, 2010 9:35:25 AM org.openstreetmap.osmosis.core.Osmosis run
INFO: Osmosis Version 0.31.2
Jun 4, 2010 9:35:26 AM org.openstreetmap.osmosis.core.Osmosis run
INFO: Preparing pipeline.
Jun 4, 2010 9:35:26 AM org.openstreetmap.osmosis.core.Osmosis run
INFO: Launching pipeline execution.
Jun 4, 2010 9:35:26 AM org.openstreetmap.osmosis.core.Osmosis run
INFO: Pipeline executing, waiting for completion.
Jun 4, 2010 9:35:26 AM
org.openstreetmap.osmosis.core.xml.v0_6.impl.OsmElementProcessor begin
WARNING: Expected version 0.6 but received 0.5.
Jun 4, 2010 9:35:26 AM
org.openstreetmap.osmosis.core.pipeline.common.ActiveTaskManager
waitForCompletion
SEVERE: Thread for task 1-read-xml-0.6 failed
org.openstreetmap.osmosis.core.OsmosisRuntimeException: Unable to insert
user with id -1 into the database.
    at
org.openstreetmap.osmosis.core.apidb.v0_6.impl.UserManager.insertUser(UserManager.java:143)
    at
org.openstreetmap.osmosis.core.apidb.v0_6.impl.UserManager.addOrUpdateUser(UserManager.java:191)
    at
org.openstreetmap.osmosis.core.apidb.v0_6.ApidbWriter.process(ApidbWriter.java:1049)
    at
org.openstreetmap.osmosis.core.xml.v0_6.impl.BoundElementProcessor.end(BoundElementProcessor.java:85)
    at
org.openstreetmap.osmosis.core.xml.v0_6.impl.OsmHandler.endElement(OsmHandler.java:108)
    at
com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.endElement(AbstractSAXParser.java:601)
    at
com.sun.org.apache.xerces.internal.parsers.AbstractXMLDocumentParser.emptyElement(AbstractXMLDocumentParser.java:180)
    at
com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanStartElement(XMLDocumentFragmentScannerImpl.java:1339)
    at
com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:2747)
    at
com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:648)
    at
com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:510)
    at
com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:807)
    at
com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:737)
    at
com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:107)
    at
com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1205)
    at
com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(SAXParserImpl.java:522)
    at javax.xml.parsers.SAXParser.parse(SAXParser.java:395)
    at javax.xml.parsers.SAXParser.parse(SAXParser.java:198)
    at
org.openstreetmap.osmosis.core.xml.v0_6.XmlReader.run(XmlReader.java:108)
    at java.lang.Thread.run(Thread.java:619)
Caused by: org.postgresql.util.PSQLException: ERROR: column "active" of
relation "users" does not exist
    at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
    at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
    at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
    at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
    at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
    at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:304)
    at
org.openstreetmap.osmosis.core.apidb.v0_6.impl.UserManager.insertUser(UserManager.java:140)
    ... 19 more
Jun 4, 2010 9:35:26 AM org.openstreetmap.osmosis.core.Osmosis main
SEVERE: Execution aborted.
org.openstreetmap.osmosis.core.OsmosisRuntimeException: One or more tasks
failed.
    at
org.openstreetmap.osmosis.core.pipeline.common.Pipeline.waitForCompletion(Pipeline.java:146)
    at org.openstreetmap.osmosis.core.Osmosis.run(Osmosis.java:85)
    at org.openstreetmap.osmosis.core.Osmosis.main(Osmosis.java:30)






On Fri, Jun 4, 2010 at 2:13 AM, Andy Allan <gravitystorm at gmail.com> wrote:

> On Thu, Jun 3, 2010 at 6:26 PM, M Naveed Akram <cmnajs at gmail.com> wrote:
> > i upgraded to 8.4
> > very thanks.
> > but there seems to be an issue with 8.4 for UTF8, it does not allow to
> > create database with UTF8 Encoding.
>
> Ah, I think I know this problem. It is very annoying.
>
> When postgres is installed, it sets a number of configurations based
> on your locale. I'm going to assume your running on linux, is that
> correct? Check the ouput of "locale". Everything should end with a
> .UTF-8, for example:
>
> LANG=en_GB.UTF-8
> LC_CTYPE="en_GB.UTF-8"
> LC_NUMERIC="en_GB.UTF-8"
> LC_TIME="en_GB.UTF-8"
> LC_COLLATE="en_GB.UTF-8"
>
> However, if yours don't end in .UTF-8, then postgres will install with
> non-UTF8 locales in lots of configuration files, such as
> /etc/postgresql/8.4/main/postgresql.conf , and won't let you create
> UTF8 databases.
>
> I find the easiest way to fix this is uninstall postgres, run
> "update-locale LANG=en_GB.UTF-8" and reinstall postgres. Obviously you
> can use any language you like, just make sure that the locale is fixed
> before you install postgres.
>
> Cheers,
> Andy
>



-- 
Regards
M Naveed Akram
http://www.google.com/profiles/cmnajs
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20100604/3900b948/attachment.html>