[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