Hi there, <br /><br />I retake this issue because is something similar what is happening to me
now, the corpus is bigger though, 18Gb.<br />when I try to populate the text metadata table
with begin/end offset positions, I get no results, I mean I get the table created but all the
velues are like this: <br />| text_id | words | cqp_begin | cqp_end |<br />| 10038
| 0 | 0
| 0 |<br />| 6570
| 0 | 0
| 0 |<br />| 4099
| 0 | 0
| 0 |<br />| 9887
| 0 | 0
| 0 |<br />| 819
| 0 | 0
| 0 |<br />| 4910
| 0 | 0
| 0 |<br />| 7669
| 0 | 0
| 0 |<br />| 2889
| 0 | 0
| 0 |<br />| 9627
| 0 | 0
| 0 |<br />| 5265
| 0 | 0
| 0 |<br />| 1076
| 0 | 0
| 0 |<br />| 6196
| 0 | 0
| 0 |<br />| 4213
| 0 | 0
| 0 |<br />| 1212
| 0 | 0
| 0 |<br />| 4688
| 0 | 0
| 0 |<br /><br />so the interface for this corpus always
says : The text metadata table <strong>has not yet been populated </strong>                                                                         with
begin/end offset positions.<br />I have put the interface in debug mode and here you have what
I get: sdewac-debug.7z<br /><br />Can I populate this table some other way?<br /><br /><br
/>On Fri, January 24, 2014 17:29, Hardie, Andrew wrote:<br /> <!-- begin sanitized html -->
<style type="text/css">-></style>
<div class="bodyclass">
<div class="WordSection1">
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">I
get an “archive corrupt” message when I try to download, but it doesn’t
matter, since the MySQL error message makes it clear that the “Generate CWB
text-position records” is <strong><u>not</u></strong> the problem.</span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">
</span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">The
problem is at the previous stage, i.e. creation of the text metadata table in the first place.
A table has been created, but no text information has been loaded. You need to delete the
existing metadata table, and the “manage metadata” page will revert back to its
initial state, offering you different options for creating & loading a text metadata
table.</span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">
</span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">Remember
you must either (a) have an actual metadata file to load, or else (b) create a
“minimal” table automatically using just the text id, or (c) have XML in your
corpus form which metadata can be extracted.</span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">
</span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">best</span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">
</span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">Andrew.</span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">
</span></p>
<p class="MsoNormal"><strong><span lang="EN-US"
style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></strong><span
lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">
Andres Chandia [mailto:andres@chandia.net] <br /> <strong>Sent:</strong> 24 January 2014
16:21<br /> <strong>To:</strong> Hardie, Andrew<br /> <strong>Cc:</strong> Open source
development of the Corpus WorkBench<br /> <strong>Subject:</strong> RE: [CWB] CWB Digest, Vol
84, Issue 20</span></p>
<p class="MsoNormal"> </p>
<p style="margin-bottom:12.0pt" class="MsoNormal">ok you can download the debug file from
here: http://parles.upf.edu/llocs/cqp/wikifr/cqp.execute.php.debug.html.tar.gz<br /> and the
query says this:</p>
<div>
<p class="MsoNormal">MySQL returned an empty result set (i.e. zero rows). ( Query took 0.0003
sec )</p>
</div>
<p class="MsoNormal"><span class="syntaxalphasyntaxalphareservedword"><span
style="font-size:10.0pt;font-family:"Courier
New","serif"">SELECT</span></span><span class="syntax"><span
style="font-size:10.0pt;font-family:"Courier New","serif"">
</span></span><span class="syntaxpunct"><span
style="font-size:10.0pt;font-family:"Courier
New","serif"">*</span></span><span class="syntax"><span
style="font-size:10.0pt;font-family:"Courier New","serif"">
</span></span><span style="font-size:10.0pt;font-family:"Courier
New","serif""><br /> <span class="syntaxalpha">FROM</span><span class="syntax">
</span><span class="syntaxquotesyntaxquotebacktick">`text_metadata_for_wikifr`</span><span
class="syntax"> </span><br /> <span
class="syntaxalphasyntaxalphareservedword">LIMIT</span><span class="syntax"> </span><span
class="syntaxdigitsyntaxdigitinteger">0</span><span class="syntax"> </span> <span
class="syntaxpunct">,</span><span class="syntax"> </span><span
class="syntaxdigit">30</span></span><br /> <br /> El Vie, 24 de Enero de 2014, 13:08, Hardie,
Andrew escribió:</p>
<div>
<div>
<p style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto" class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">Almost
certainly there is a deeper problem here, since clicking that button ought always to result
in the metadata table containing begin-end points. If it doesn’t, something is clearly
very askew. </span></p>
<p style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto" class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">I
suggest you turn on debug message printing in the config file, then press the button again,
and see if you get any useful hints from the debug messages.</span></p>
<p style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto" class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">Second
suggestion: copy-paste the output of <strong><span
style="font-family:"Verdana","sans-serif"">select * from {your text
metadata table}</span></strong> into a text file and send it me off list.</span></p>
<p style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto" class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">best</span></p>
<p style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto" class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">Andrew.</span></p>
<p style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto" class="MsoNormal"><strong><span
lang="EN-US"
style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></strong><span
lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">
cwb-bounces@sslmit.unibo.it [mailto:cwb-bounces@sslmit.unibo.it] <strong><span
style="font-family:"Tahoma","sans-serif"">On Behalf Of
</span></strong>Andres Chandia<br /> <strong><span
style="font-family:"Tahoma","sans-serif"">Sent:</span></strong> 24 January
2014 11:55<br /> <strong><span
style="font-family:"Tahoma","sans-serif"">To:</span></strong> Open source
development of the Corpus WorkBench<br /> <strong><span
style="font-family:"Tahoma","sans-serif"">Subject:</span></strong> Re:
[CWB] CWB Digest, Vol 84, Issue 20</span></p>
<pre>As I told you, now I get no error, but still the <span style="color:black">text</span></pre>
<pre><span style="color:black">metadata</span></pre>
<pre><span style="color:black">table</span> does not get populated,<br />I press the button</pre>
<pre>"Generate CWB text-position</pre>
<pre>records", the browser show as it is in process, but <br />when it finishes, it
still</pre>
<pre>say</pre>
<pre>"The text metadata table <strong><span style="font-family:"Courier
New","serif"">has not yet been populated"</span></strong> and</pre>
<pre>checking<br />the db I see there is nothing.<br />can I populated from command line?</pre>
<pre>how?<br /><br /><br />Hi, It maybe a problem due to disk space. You may check if the
system</pre>
<pre>files and</pre>
<pre>user files are in different partitions. df -h will give a details. If you don't have</pre>
<pre>enough</pre>
<pre>disk space for mysql temporary files in the partition that mysql uses, try changing</pre>
<pre>/tmp</pre>
<pre>location in my.conf to another location. Best On 01/24/2014 01:00 PM, <a
target="_blank" title="This external link will open in a new window"
href="http://mail.chandia.net/src/compose.php?send_to=cwb-request%40sslmit.unibo.it">cwb-request@sslmit.unibo.it</a></pre>
<pre>wrote: <span style="color:black">> Send CWB mailing list submissions to</span> <span
style="color:black">> <a target="_blank" title="This external link will open in a
new window"
href="http://mail.chandia.net/src/compose.php?send_to=cwb%40sslmit.unibo.it">cwb@sslmit.unibo.it</a></span></pre>
<pre><span style="color:black">></span> <span style="color:black">> To subscribe
or</span></pre>
<pre><span style="color:black">unsubscribe via</span></pre>
<pre><span style="color:black">the World Wide Web, visit</span> <span
style="color:black">></span></pre>
<pre><span style="color:black"> <a target="_blank" title="This external link will open
in a new window"
href="http://devel.sslmit.unibo.it/mailman/listinfo/cwb">http://devel.sslmit.unibo.it/mailman/listinfo/cwb</a></span></pre>
<pre><span style="color:black">> or, via email, send a message with subject or body
'help'</span></pre>
<pre><span style="color:black">to</span></pre>
<pre><span style="color:black">> <a target="_blank" title="This external link will
open in a new window"
href="http://mail.chandia.net/src/compose.php?send_to=cwb-request%40sslmit.unibo.it">cwb-request@sslmit.unibo.it</a></span></pre>
<pre><span style="color:black">></span> <span style="color:black">> You can reach
the</span></pre>
<pre><span style="color:black">person managing</span></pre>
<pre><span style="color:black">the list at</span> <span style="color:black">> <a
target="_blank" title="This external link will open in a new window"
href="http://mail.chandia.net/src/compose.php?send_to=cwb-owner%40sslmit.unibo.it">cwb-owner@sslmit.unibo.it</a></span></pre>
<pre><span style="color:black">></span> <span style="color:black">> When
replying,</span></pre>
<pre><span style="color:black">please edit your</span></pre>
<pre><span style="color:black">Subject line so it is more specific</span> <span
style="color:black">> than "Re: Contents</span></pre>
<pre><span style="color:black">of CWB digest..."</span> <span
style="color:black">></span> <span style="color:black">></span> <span
style="color:black">> Today's Topics:</span> <span style="color:black">></span> <span
style="color:black">> 1. text metadata table population</span></pre>
<pre><span style="color:black">(Andres Chandia)</span> <span
style="color:black">></span></pre>
<pre><span style="color:black">></span> </pre>
<pre><span style="color:black">> </span></pre>
<pre><span
style="color:black">----------------------------------------------------------------------</span></pre>
<pre><span style="color:black">></span> <span style="color:black">> Message: 1</span>
<span style="color:black">> Date: Fri, 24 Jan 2014 11:49:50 +0100</span> <span
style="color:black">></span></pre>
<pre><span style="color:black">From: "Andres Chandia"</span></pre>
<pre><span style="color:black">andres@chandia.net></span></pre>
<pre><span style="color:black">> To: "Open source development of the Corpus</span></pre>
<pre><span style="color:black">WorkBench"</span> <span style="color:black">>
</span></pre>
<pre><span style="color:black">cwb@sslmit.unibo.it></span></pre>
<pre><span style="color:black">> Subject: [CWB] text metadata table population</span> <span
style="color:black">> Message-ID:</span> <span style="color:black">>
</span></pre>
<pre><span
style="color:black">b5b32fb6ac80f2d9e0716eab4b4369b9.squirrel@mail.chandia.net></span></pre>
<pre><span style="color:black">> Content-Type: text/plain;</span></pre>
<pre><span style="color:black">charset="iso-8859-1"</span></pre>
<pre><span style="color:black">></span> <span style="color:black">></span> <span
style="color:black">></span> <span style="color:black">> Hi there again,</span> <span
style="color:black">></span> <span style="color:black">> text metadata table
never</span></pre>
<pre><span style="color:black">gets</span></pre>
<pre><span style="color:black">populated, I think it is because the</span> <span
style="color:black">> corpuse is too big, as</span></pre>
<pre><span style="color:black">a consequence (myabe I'm wrong) I get this error when I go
to</span></pre>
<pre><span style="color:black">"View corpus</span></pre>
<pre><span style="color:black">metadata":</span> <span style="color:black">></span></pre>
<pre><span style="color:black">> A mySQL</span></pre>
<pre><span style="color:black">query did not run successfully!</span> <span
style="color:black">> Error # 3: Error writing</span></pre>
<pre><span style="color:black">file '/tmp/MYMRH0KR' (Errcode: 28)</span> <span
style="color:black">> How can I solve</span></pre>
<pre><span style="color:black">this?</span> <span style="color:black">></span> <span
style="color:black">> thanks</span> <span style="color:black">></span> <span
style="color:black">> _______________________</span> <span
style="color:black">></span></pre>
<pre><span style="color:black">????????????????????????andr??s</span> <span
style="color:black">></span></pre>
<pre><span style="color:black">chand??a</span> <span style="color:black">></span> <span
style="color:black">> administrador</span></pre>
<pre><span style="color:black">de</span> <span style="color:black">>
parles.upf.edu</span></pre>
<pre><span style="color:black">></span> </pre>
<pre><span style="color:black">psicoaching.net</span> <span style="color:black">>
mapuche</span></pre>
<pre><span style="color:black">koyaktu</span> <span style="color:black">> ong mapuche
koyaktu</span> <span style="color:black">> P No imprima</span></pre>
<pre><span style="color:black">innecesariamente. ??Cuide el medio ambiente!</span> <span
style="color:black">> --------------</span></pre>
<pre><span style="color:black">next part --------------</span> <span
style="color:black">></span></pre>
<pre><span style="color:black">An HTML attachment was</span></pre>
<pre><span style="color:black">scrubbed...</span> <span style="color:black">>
URL:</span></pre>
<pre><span
style="color:black">http://devel.sslmit.unibo.it/pipermail/cwb/attachments/20140124/d70439b8/attachment-0001.html></span></pre>
<pre><span style="color:black">></span> <span style="color:black">></span></pre>
<pre><span style="color:black">------------------------------</span> <span
style="color:black">></span> <span style="color:black">></span></pre>
<pre><span style="color:black">_______________________________________________</span> <span
style="color:black">> CWB</span></pre>
<pre><span style="color:black">mailing list</span> <span style="color:black">> <a
target="_blank" title="This external link will open in a new window"
href="http://mail.chandia.net/src/compose.php?send_to=CWB%40sslmit.unibo.it">CWB@sslmit.unibo.it</a></span></pre>
<pre><span style="color:black">> <a target="_blank" title="This external link will open in
a new window"
href="http://devel.sslmit.unibo.it/mailman/listinfo/cwb">http://devel.sslmit.unibo.it/mailman/listinfo/cwb</a></span></pre>
<pre><span style="color:black">></span> <span style="color:black">></span> <span
style="color:black">></span></pre>
<pre><span style="color:black">End of CWB Digest, Vol 84, Issue 20</span> <span
style="color:black">></span></pre>
<pre><span style="color:black">***********************************</span> </pre>
<pre>_______________________________________________</pre>
<pre>CWB mailing list <a target="_blank" title="This external link will open in a new window"
href="http://mail.chandia.net/src/compose.php?send_to=CWB%40sslmit.unibo.it">CWB@sslmit.unibo.it</a></pre>
<pre><a target="_blank" title="This external link will open in a new window"
href="http://devel.sslmit.unibo.it/mailman/listinfo/cwb">http://devel.sslmit.unibo.it/mailman/listinfo/cwb</a></pre>
<p style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto" class="MsoNormal"><br /> <br />
<br /> <br /> _______________________<br /> andrés chandía<br /> <a
target="_blank" title="This external link will open in a new window"
href="http://www.chandia.net"><span style="border:solid windowtext
1.0pt;padding:0cm;text-decoration:none">[IMAGE REMOVED]</span></a><br /> administrador de<br
/> <a target="_blank" title="This external link will open in a new window"
href="http://parles.upf.edu">parles.upf.edu</a><br /> <a target="_blank" title="This external
link will open in a new window" href="http://psicoaching.net">psicoaching.net</a><br /> <a
target="_blank" title="This external link will open in a new window"
href="http://koyaktumapuche.net">mapuche koyaktu</a><br /> <a target="_blank" title="This
external link will open in a new window" href="http://corporacionkoyaktu.net">ong mapuche
koyaktu</a><br /> <span style="font-size:18.0pt;font-family:Webdings;color:#4F6228">P
</span><span style="font-size:10.0pt;color:#4F6228">No imprima innecesariamente. ¡Cuide
el medio ambiente!</span></p>
</div>
</div>
<p class="MsoNormal"><br /> <br /> <br /> _______________________<br />
andrés chandía<br /> <a title="This external link will open in a new window"
target="_blank" href="http://www.chandia.net"><span style="border:solid windowtext
1.0pt;padding:0cm;text-decoration:none">[IMAGE REMOVED]</span></a><br /> administrador de<br /> <a title="This external link will
open in a new window" target="_blank" href="http://parles.upf.edu">parles.upf.edu</a><br /> <a
title="This external link will open in a new window" target="_blank"
href="http://psicoaching.net">psicoaching.net</a><br /> <a title="This external link will open
in a new window" target="_blank" href="http://koyaktumapuche.net">mapuche koyaktu</a><br /> <a
title="This external link will open in a new window" target="_blank"
href="http://corporacionkoyaktu.net">ong mapuche koyaktu</a><br /> <span
style="font-size:18.0pt;font-family:Webdings;color:#4F6228">P </span><span
style="font-size:10.0pt;color:#4F6228">No imprima innecesariamente. ¡Cuide el medio
ambiente!</span></p>
</div>
</div>
<!-- end sanitized html --> <br /><br /><br />_______________________<br
/> andrés
chandía<br /><a target="_blank" href="http://www.chandia.net"><img border="0"
alt="chandia.net" src="http://www.chandia.net/sites/default/files/images/chandia.netd.png"
/></a><a target="_blank" href="https://twitter.com/andreschandia"><img
src="http://www.upf.edu/universitat/_img/ico_tw.png" alt="" /></a><br />administrador de<br
/><a href="http://parles.upf.edu">parles.upf.edu</a><br /><a
href="http://psicoaching.net">psicoaching.net</a><br /><a
href="http://koyaktumapuche.net">mapuche koyaktu</a><br /><a
href="http://corporacionkoyaktu.net">ong mapuche koyaktu</a><br /><span style="font-size:
18pt; color: rgb(79, 98, 40); font-family: Webdings;">P </span><span style="font-size: 10pt;
color: rgb(79, 98, 40);">No imprima innecesariamente. ¡Cuide el medio ambiente!</span>