If you are not using flatnodes, then select max(id) from planet_osm_nodes Įlse select max(osm_id) from planet_osm_point I apologize up front if I'm missing something easy or obvious.įirst, find the highest node ID in your database. In my searching, I've found some directions on how to get the current timestamp of a file, but not how to determine the current timestamp of the database. Assuming I'm correct, how can I reset osmosis expire stamp?Ĭan I simply run openstreetmap-tiles-update-expire with a timestamp of the last successful expiration? In this case: ? Instead, I'm guessing something didn't shut down cleanly which is why osmosis.log shows a problem with the timestamp of the replication state. OsmosisRuntimeException: One or more tasks failed.Īt .(Pipeline.java:146)Īt .n(Osmosis.java:92)Īt .Osmosis.main(Osmosis.java:37)Īt java.base/.invoke0(Native Method)Īt java.base/.invoke(NativeMethodAccessorImpl.java:62)Īt java.base/.invoke(DelegatingMethodAccessorImpl.java:43)Īt java.base/.invoke(Method.java:564)Īt .(Launcher.java:330)Īt .(Launcher.java:238)Īt .(Launcher.java:415)Īt .(Launcher.java:356)Īt .main(Launcher.java:47)Īdmittedly, I had not changed the timezone on the server, so I'm not thinking it would have known I moved. 7:15:03 PM. waitForCompletion SEVERE: Thread for task 1-read-replication-interval failed .OsmosisRuntimeException: The replication state doesn't contain a timestamp property.Īt .(ReplicationState.java:65)Īt .(ReplicationState.java:78)Īt .common.ReplicationState.(ReplicationState.java:59)Īt .v0_6.nImpl(BaseReplicationDownloader.java:268)Īt .v0_6.n(BaseReplicationDownloader.java:350)Īt java.base/(Thread.java:844)ħ:15:03 PM .Osmosis main SEVERE: Execution aborted. 7:15:02 PM .Osmosis run INFO: Pipeline executing, waiting for completion. 7:15:02 PM .Osmosis run INFO: Launching pipeline execution. Here is the relevant portion of the log file:Ī current osmosis.log shows this: 7:15:01 PM .Osmosis run INFO: Osmosis Version 0.46 7:15:02 PM .Osmosis run INFO: Preparing pipeline. However, the process stopped working, and when I analyzed the logs, it appears that when I shut down the server (in order to move to a new timezone), the update process stopped working.

I have a tile server set up, and was using osmosis to update the database.

Pdoxusrsnet windows 7