[CWB] CWB Digest, Vol 84, Issue 20

Andres Chandia andres at chandia.net
Wed Jan 29 18:22:03 CET 2014 


Hi there, 

I retake this issue because is something similar what is happening to me
now, the corpus is bigger though, 18Gb.
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: 
| text_id | words | cqp_begin | cqp_end |
| 10038  
|     0 |         0
|       0 |
| 6570   
|     0 |         0
|       0 |
| 4099   
|     0 |         0
|       0 |
| 9887   
|     0 |         0
|       0 |
| 819    
|     0 |         0
|       0 |
| 4910   
|     0 |         0
|       0 |
| 7669   
|     0 |         0
|       0 |
| 2889   
|     0 |         0
|       0 |
| 9627   
|     0 |         0
|       0 |
| 5265   
|     0 |         0
|       0 |
| 1076   
|     0 |         0
|       0 |
| 6196   
|     0 |         0
|       0 |
| 4213   
|     0 |         0
|       0 |
| 1212   
|     0 |         0
|       0 |
| 4688   
|     0 |         0
|       0 |

so the interface for this corpus always
says : The text metadata table has not yet been populated   									with
begin/end offset positions.
I have put the interface in debug mode and here you have what
I get: sdewac-debug.7z

Can I populate this table some other way?


On Fri, January 24, 2014 17:29, Hardie, Andrew wrote:
 <style type="text/css">-></style>


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 not the problem.


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.


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.


best


Andrew.


From:
Andres Chandia [mailto:andres at chandia.net] 
 Sent: 24 January 2014
16:21
 To: Hardie, Andrew
 Cc: Open source
development of the Corpus WorkBench
 Subject: RE: [CWB] CWB Digest, Vol
84, Issue 20
 
ok you can download the debug file from
here: http://parles.upf.edu/llocs/cqp/wikifr/cqp.execute.php.debug.html.tar.gz
 and the
query says this:

MySQL returned an empty result set (i.e. zero rows). ( Query took 0.0003
sec )

SELECT
*

 FROM
`text_metadata_for_wikifr` 
 LIMIT 0  , 30
 
 El Vie, 24 de Enero de 2014, 13:08, Hardie,
Andrew escribió:


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. 
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.
Second
suggestion: copy-paste the output of select * from {your text
metadata table} into a text file and send it me off list.
best
Andrew.
From: 
cwb-bounces at sslmit.unibo.it [mailto:cwb-bounces at sslmit.unibo.it] On Behalf Of
Andres Chandia
 Sent: 24 January
2014 11:55
 To: Open source
development of the Corpus WorkBench
 Subject: Re:
[CWB] CWB Digest, Vol 84, Issue 20
As I told you, now I get no error, but still the text
metadata
table does not get populated,
I press the button
"Generate CWB text-position
records", the browser show as it is in process, but 
when it finishes, it
still
say
"The text metadata table has not yet been populated" and
checking
the db I see there is nothing.
can I populated from command line?
how?


Hi, It maybe a problem due to disk space. You may check if the
system
files  and
user files are in different partitions. df -h will give a details. If you don't have
enough
disk space for mysql temporary files in the  partition that mysql uses, try changing
/tmp
location in my.conf to  another location.  Best   On 01/24/2014 01:00 PM, cwb-request at sslmit.unibo.it
wrote: > Send CWB mailing list submissions to >         cwb at sslmit.unibo.it
> > To subscribe
or
unsubscribe via
the World Wide Web, visit >
        http://devel.sslmit.unibo.it/mailman/listinfo/cwb
> or, via email, send a message with subject or body
'help'
to
>         cwb-request at sslmit.unibo.it
> > You can reach
the
person managing
the list at >         cwb-owner at sslmit.unibo.it
> > When
replying,
please edit your
Subject line so it is more specific > than "Re: Contents
of CWB digest..." > > > Today's Topics: > >     1. text metadata table population
(Andres Chandia) >
> 
> 
----------------------------------------------------------------------
> > Message: 1
> Date: Fri, 24 Jan 2014 11:49:50 +0100 >
From: "Andres Chandia"
andres at chandia.net>
> To: "Open source development of the Corpus
WorkBench" >       

cwb at sslmit.unibo.it>
> Subject: [CWB] text metadata table population > Message-ID: >       

b5b32fb6ac80f2d9e0716eab4b4369b9.squirrel at mail.chandia.net>
> Content-Type: text/plain;
charset="iso-8859-1"
> > > > Hi there again, > > text metadata table
never
gets
populated, I think it is because the > corpuse is too big, as
a consequence (myabe I'm wrong) I get this error when I go
to
"View corpus
metadata": >
> A mySQL
query did not run successfully! > Error # 3: Error writing
file '/tmp/MYMRH0KR' (Errcode: 28) > How can I solve
this? > > thanks > > _______________________ >
????????????????????????andr??s >
chand??a > > administrador
de >
parles.upf.edu
> 
psicoaching.net >
mapuche
koyaktu > ong mapuche
koyaktu > P No imprima
innecesariamente. ??Cuide el medio ambiente! > --------------
next part -------------- >
An HTML attachment was
scrubbed... >
URL:
http://devel.sslmit.unibo.it/pipermail/cwb/attachments/20140124/d70439b8/attachment-0001.html>
> >
------------------------------ > >
_______________________________________________ > CWB
mailing list > CWB at sslmit.unibo.it
> http://devel.sslmit.unibo.it/mailman/listinfo/cwb
> > >
End of CWB Digest, Vol 84, Issue 20 >
*********************************** 
_______________________________________________
CWB mailing list CWB at sslmit.unibo.it
http://devel.sslmit.unibo.it/mailman/listinfo/cwb

 


 
 _______________________
 andrés chandía
 [IMAGE REMOVED]
 administrador de
 parles.upf.edu
 psicoaching.net
 mapuche koyaktu
 ong mapuche
koyaktu
 P
No imprima innecesariamente. ¡Cuide
el medio ambiente!



 
 
 _______________________
            
andrés chandía
 
 administrador de
 parles.upf.edu
 psicoaching.net
 mapuche koyaktu
 ong mapuche koyaktu
 P No imprima innecesariamente. ¡Cuide el medio
ambiente!


 


_______________________
            andrés
chandía

administrador de
parles.upf.edu
psicoaching.net
mapuche koyaktu
ong mapuche koyaktu
P No imprima innecesariamente. ¡Cuide el medio ambiente!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://devel.sslmit.unibo.it/pipermail/cwb/attachments/20140129/97147974/attachment-0001.html>

More information about the CWB mailing list