<html><head><meta http-equiv="Content-Type" content="text/html charset=windows-1252"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><div>Hi everyone</div><div><br></div><div>I’m having issues with SQLITE as the db driver - I encounter this BUSY warning. Only occurs when patching a particular map, in this case “<span style="font-family: Menlo; font-size: 11px;">temp_nbt_cleaned" which is the largest of the datasets being patched.</span> <span style="font-family: Menlo; font-size: 11px;"> </span>If I work with smaller datasets, it works fine. Pre-patching, SQLITE DB size is only 170MB.</div><div><br></div><div>I’ve come across various threads reporting something similar with db locking. But couldn’t find a resolution.</div><div>I’m running grass70 on Centos65, hosted on AWS.. <span style="font-family: Menlo; font-size: 11px;">SQLite is version 3.6.23.1 </span></div><div><span style="font-family: Menlo; font-size: 11px;"><br></span></div><div><span style="font-family: Menlo; font-size: 11px;">This is the error message.</span></div><div><br></div><div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">GRASS 7.0.0svn (nodeclean):/var/tmp > v.patch -e input=temp_t_cleaned,temp_b_cleaned,temp_nbt_cleaned out=temp_patched</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">Patching vector map <temp_t_cleaned>...</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">Patching vector map <temp_b_cleaned>...</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">Patching vector map <temp_nbt_cleaned>...</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">WARNING: Busy SQLITE db, already waiting for 10 seconds…</div></div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">WARNING: Busy SQLITE db, already waiting for 20 seconds…</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">etc</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">etc</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"><br></div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">I encounter no problems patching the maps, including “temp_nbt_cleaned" if I use PG db driver, or DBF driver.</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"><br></div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"><div style="margin: 0px;">building topology for vector map <temp_patched@PERMANENT>...</div><div style="margin: 0px;">Registering primitives...</div><div style="margin: 0px;">1860504 primitives registered</div><div style="margin: 0px;">9027638 vertices registered</div><div style="margin: 0px;">Building areas...</div><div style="margin: 0px;"> 100%</div><div style="margin: 0px;">0 areas built</div><div style="margin: 0px;">0 isles built</div><div style="margin: 0px;">Attaching islands...</div><div style="margin: 0px;">Attaching centroids...</div><div style="margin: 0px;"> 100%</div><div style="margin: 0px;">Number of nodes: 1457611</div><div style="margin: 0px;">Number of primitives: 1860504</div><div style="margin: 0px;">Number of points: 0</div><div style="margin: 0px;">Number of lines: 1860504</div><div style="margin: 0px;">Number of boundaries: 0</div><div style="margin: 0px;">Number of centroids: 0</div><div style="margin: 0px;">Number of areas: 0</div><div style="margin: 0px;">Number of isles: 0</div><div style="margin: 0px;">Intersections at borders will have to be snapped</div><div style="margin: 0px;">Lines common between files will have to be edited</div><div style="margin: 0px;">The header information also may have to be edited</div><div style="margin: 0px;">v.patch complete. 3 vector maps patched</div><div><br></div></div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"><br></div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">I’m more than comfortable using PG in the backend, but I find v.out.postgis too slow when exporting the resultant dataset back to postgis (possibly because its simultaneously trying to read and write to the same db). I haven’t tested whether v.out.ogr quicker than v.out.postgis.</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"><br></div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">Any assistance resolving the SQLite issue would be greatly appreciated.</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"><br></div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">Kind regards</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"><br></div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">Mark</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"><br></div></body></html>