They're okay. There were two produced at the same time, but for different hourly periods. You need to open the corresponding state file to know what time each one is for. 324.state.txt contains <br><pre>timestamp=2010-06-29T18\:00\:00Z<br>
</pre>but 325.state.txt contains<br><pre>timestamp=2010-06-29T19\:00\:00Z<br></pre><br><br><div class="gmail_quote">On Sat, Aug 14, 2010 at 7:17 PM, bernhard zwischenbrugger <span dir="ltr"><<a href="mailto:bz@datenkueche.com">bz@datenkueche.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div bgcolor="#ffffff" text="#000000">
Hi<br>
<br>
It looks like the hour diffs also have a problem.<br>
They are on time but sometimes there are zwo files.<br>
<br>
example:<br>
<a href="http://324.osc.gz" target="_blank">324.osc.gz</a> 29-Jun-2010 20:02 6.0<span style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Times; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; font-size: medium;"></span>M<br>
<a href="http://325.osc.gz" target="_blank">325.osc.gz</a> 29-Jun-2010 20:02 46K <span style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Times; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; font-size: medium;"></span><br>
<br>
Bernhard<br>
<br>
<br>
Am 14.08.10 03:38, schrieb Brett Henderson:
<blockquote type="cite"><div><div></div><div class="h5">
<div class="gmail_quote">On Sat, Aug 14, 2010 at 9:30 AM, Tom Hughes <span dir="ltr"><<a href="mailto:tom@compton.nu" target="_blank">tom@compton.nu</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>
<div>On 14/08/10 00:19, Grant Slater wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
On 14 August 2010 00:10, Brett Henderson<<a href="mailto:brett@bretth.com" target="_blank">brett@bretth.com</a>>
wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>
Is anybody aware of anything that happened on that day *other* than the<br>
database upgrade? Any new imports, etc.<br>
<br>
</blockquote>
<br>
The database was fully re-imported (planned and triple backed up) and<br>
the transaction IDs were reset due to this.<br>
zere was able to set the transaction id used by osmosis diff export<br>
because I believe you were not around or weren't available at the<br>
time.<br>
<br>
Also: Postgresql 8.3 -> 8.4. RAID10 on 10 disk to RAID 10 on 16
disks.<br>
RAID stripe size changed from 256KB to 64KB.<br>
</blockquote>
<br>
</div>
</div>
There's not really any great mystery here, we know it was the upgrade
to postgres 8.4 (or just as likely the reimport of the db) that
triggered it.<br>
</blockquote>
<div><br>
Okay. I didn't realise that a database upgrade had occurred, I thought
it was only disk/RAID changes.<br>
<br>
</div>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><br>
We just need to get to the bottom of what is making some of the queries
run slowly, but it's not a very easy thing to do.<br>
</blockquote>
<div><br>
Is it only Osmosis queries that are running slowly?<br>
<br>
</div>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><br>
My assumption was that it was choosing a bad execution plan as the way
our schema works tends to confuse Postgres's statistics, but the plan I
looked at didn't show any sign of that.<br>
<br>
Equally it doesn't seem to be a lock contention issue.<br>
</blockquote>
</div>
<br>
Is there anything I can add that might make it easier to investigate
such as additional query options, log query timings, etc? I'm not sure
what to try at this point. About the only thing I can think to do is
to set up a local database and try to replicate the problem. I've been
meaning to do that but it's not a quick task and I haven't had much
time to spend on it.<br>
<br>
Brett<br>
<br>
</div></div><pre><fieldset></fieldset>
_______________________________________________
dev mailing list
<div class="im"><a href="mailto:dev@openstreetmap.org" target="_blank">dev@openstreetmap.org</a>
<a href="http://lists.openstreetmap.org/listinfo/dev" target="_blank">http://lists.openstreetmap.org/listinfo/dev</a>
</div></pre>
</blockquote>
<br>
</div>
</blockquote></div><br>