<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.E-MailFormatvorlage17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="DE" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal">Hello,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span lang="EN-US">I get a lot of disk I/O errors using exec commands like:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">“C:\OSGeo4W\bin\ogr2ogr -f gpkg E:\OSM\vektor_gpkg\Kontinente\europe-latest.osm.noAuthor_-44-46.gpkg E:\OSM\Kontinente\europe-latest.osm.noAuthor_-44-46.pbf multipolygons -select "name,aeroway,amenity,building,historic,landuse,office,tourism,shop,landuse"
-where @ogr2ogr_condition.txt”<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">The error message is very generic. The external hard drive is of good quality and brand new formatted with NTFS so I wouldn’t think of a damaged HDD.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Sometimes I did simultaneous processing with ogr2ogr but never with the same source or output files.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">I had set up a temporary directory on a large external hard drive that is connected via USB3 using “set temp=E:\OSM\temp” to cover for very large temporary files during ogr2ogr osm processing.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Might the reason be that during processing the algorithm outputs data faster than the external HDD is able to write it so I shouldn’t set the external HDD as a temp directory?<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">These are the errors that occurred:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">ERROR 1: failed to execute insert : disk I/O error<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">ERROR 1: Unable to write feature 617369107 from layer multipolygons.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">ERROR 1: Terminating translation prematurely after failed<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">translation of layer multipolygons (use -skipfailures to skip errors)<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">ERROR 1: sqlite3_exec(CREATE TABLE gpkg_extensions (table_name TEXT,column_name TEXT,extension_name TEXT NOT NULL,definition TEXT NOT NULL,scope TEXT NOT NULL,CONSTRAINT ge_tce UNIQUE (table_name, column_name, extension_name)))
failed: disk I/O error<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">ERROR 1: sqlite3_exec(UPDATE gpkg_contents SET min_x = -31.2625834, min_y = 32.6335129, max_x = 46.66876959999999, max_y = 45.99999699999999 WHERE lower(table_name) = lower('multipolygons') AND Lower(data_type) = 'features')
failed: disk I/O error<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">ERROR 1: sqlite3_exec(UPDATE gpkg_contents SET last_change = strftime('%Y-%m-%dT%H:%M:%fZ','now') WHERE lower(table_name) = lower('multipolygons')) failed: disk I/O error<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">ERROR 1: sqlite3_exec(ROLLBACK) failed: cannot rollback - no transaction is active<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">…<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">ERROR 1: Cannot read node 5100255009<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">ERROR 1: Cannot read node 5100255010<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">ERROR 1: Cannot read node 5100255011<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">ERROR 1: Cannot read node 5100255020<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">ERROR 1: Cannot read node 5100255044<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">ERROR 1: Cannot read node 5100255045<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">…<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">0...10...20...30...40...50...60.ERROR 1: Failed inserting way 11064599: disk I/O error<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">ERROR 1: Failed inserting way 11064601: disk I/O error<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">ERROR 1: Failed inserting way 11064602: disk I/O error<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">ERROR 1: Failed inserting way 11064603: disk I/O error<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">ERROR 1: Failed inserting way 11064605: disk I/O error<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">…<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Any ideas?<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:"Arial",sans-serif;mso-fareast-language:DE">Regards, Tobias Schmetzer<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:8.0pt;font-family:"Arial",sans-serif;mso-fareast-language:DE"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Arial",sans-serif;mso-fareast-language:DE">ZAE Bayern<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Arial",sans-serif;mso-fareast-language:DE">Tobias Schmetzer, Dipl. Ing.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Arial",sans-serif;mso-fareast-language:DE">Wissenschaftlicher Mitarbeiter Systementwicklung
</span><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:black;mso-fareast-language:DE">|
</span><span style="font-size:8.0pt;font-family:"Arial",sans-serif;mso-fareast-language:DE">Scientific Staff Member Systems Engineering<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Arial",sans-serif;mso-fareast-language:DE">Bereich Energiespeicherung| Division Energy Storage<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Arial",sans-serif;mso-fareast-language:DE"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Arial",sans-serif;mso-fareast-language:DE">Walther-Meißner-Str.
</span><span lang="EN-US" style="font-size:8.0pt;font-family:"Arial",sans-serif;mso-fareast-language:DE">6<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:8.0pt;font-family:"Arial",sans-serif;mso-fareast-language:DE">85748 Garching<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:8.0pt;font-family:"Arial",sans-serif;mso-fareast-language:DE"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:8.0pt;font-family:"Arial",sans-serif;mso-fareast-language:DE">Tel.: +49 89 329442-65<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:8.0pt;font-family:"Arial",sans-serif;mso-fareast-language:DE">Fax: +49 89 329442-12<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:8.0pt;font-family:"Arial",sans-serif;mso-fareast-language:DE"><a href="mailto:tobias.schmetzer@zae-bayern.de"><span style="color:blue">tobias.schmetzer@zae-bayern.de</span></a><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Arial",sans-serif;mso-fareast-language:DE"><a href="http://www.zae-bayern.de/"><span style="color:blue">http://www.zae-bayern.de</span></a><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Arial",sans-serif;mso-fareast-language:DE"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Arial",sans-serif;mso-fareast-language:DE"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Arial",sans-serif;mso-fareast-language:DE">ZAE Bayern - Bayerisches Zentrum für Angewandte Energieforschung e. V.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Arial",sans-serif;mso-fareast-language:DE">Vorstand
</span><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:black;mso-fareast-language:DE">|
</span><span style="font-size:8.0pt;font-family:"Arial",sans-serif;mso-fareast-language:DE">Board: Dr. Andreas Hauer (Vorsitzender
</span><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:black;mso-fareast-language:DE">|
</span><span style="font-size:8.0pt;font-family:"Arial",sans-serif;mso-fareast-language:DE">Chairman), Dr. Hans-Peter Ebert<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Arial",sans-serif;mso-fareast-language:DE">Sitz/Registered Office: Würzburg<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Arial",sans-serif;mso-fareast-language:DE">Registergericht/Register Court: Amtsgericht Würzburg<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Arial",sans-serif;mso-fareast-language:DE">Registernummer/Register Number: VR 1386<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Arial",sans-serif;mso-fareast-language:DE"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Arial",sans-serif;mso-fareast-language:DE">Sämtliche Willenserklärungen, z. B. Angebote, Aufträge, Anträge und Verträge, sind für das ZAE Bayern nur in schriftlicher und ordnungsgemäß unterschriebener
Form rechtsverbindlich. Diese E-Mail ist ausschließlich zur Nutzung durch den/die vorgenannten Empfänger bestimmt. Jegliche unbefugte Offenbarung, Nutzung oder Verbreitung, sei es insgesamt oder teilweise, ist untersagt. Sollten Sie diese E-Mail irrtümlich
erhalten haben, benachrichtigen Sie bitte unverzüglich den Absender und löschen Sie diese E-Mail.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Arial",sans-serif;mso-fareast-language:DE"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:8.0pt;font-family:"Arial",sans-serif;mso-fareast-language:DE">Any declarations of intent, such as quotations, orders, applications and contracts, are legally binding for ZAE Bayern only if expressed in
a written and duly signed form. This e-mail is intended solely for use by the recipient(s) named above. Any unauthorised disclosure, use or dissemination, whether in whole or in part, is prohibited. If you have received this e-mail in error, please notify
the sender immediately and delete this e-mail.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
</div>
</body>
</html>