[CWB] Where to start looking for the problem?

["Andrés Chandía"]

Hi Andrew,

Thanks for your help, I have changed $print_debug_messages = true;

but all I see besides all that I have reported before is: "The query ran
successfully in 0 seconds."

"BTW While 3.2.27 is old, it’s not that
old relative to the latest in the branch"

Yes, I have not been in charge of
this server for a long time, actually the corpus I'm having the problem with was not istalled
by me, and the state of the server is as I have left it long time ago.

At first I
thought it could be an issue of unupdated things and I did the updating of the SO, having some
issues with "AppArmor+MySql" which I could solve, but that didn't help in the corpus
issue, by the way, I have checked the corpus I have installed when I was in charge of this
server and all of them work correctly...

So, as I see it, I think the best solution
is to install this corpus again, what do you think about?








El Mie, 20 de Abril de 2022, 16:47, Hardie, Andrew escribió:
 <style type="text/css">-></style>


Hi
Andrés, 


Wow,
what a pile of issues!


The
key point is this one: 



         There is a corpus that I've been told it was working correctly, but all of a
sudden queries started to give back [UNREADABLE]


This
can’t happen without cause. Something must have changed. The range of other error
messages suggests that the setup of the operating  system has changed. Perhaps it has been
upgraded, or default settings restored. In any case, the issues would seem to be with
configuration of either the filesystem, or the MySQL daemon, or both.



         So, my question is where and how should I start to try to find out the cause
of this problem?


Turn
on showing debug messages in the config file. This should help. 


Note
that “[UNREADABLE]” is caused by failure to parse concordance output from CQP. So,
seeing what is actually being passed back and  forth will probably give you a hint.



BTW
While  3.2.27 is old, it’s not that old relative to the latest in the branch.



best


Andrew.




From:
cwb-bounces at sslmit.unibo.it  On Behalf Of "Andrés
Chandía"
 Sent: 20 April 2022 14:59

To: Open source development of the Corpus WorkBench 

Subject: [CWB] Where to start looking for the problem?


 


Hi there,


 


At a cqpweb installation (CQPweb v3.2.27)


 


There is a corpus that I've been told it was working correctly, but all
of a sudden queries started to give back [UNREADABLE]


 


Like:


 


[UNREADABLE] [UNREADABLE] [UNREADABLE] [UNREADABLE] [UNREADABLE]
[UNREADABLE] [UNREADABLE] [UNREADABLE] [UNREADABLE][UNREADABLE] [UNREADABLE]  [UNREADABLE] [UNREADABLE] [UNREADABLE]
[UNREADABLE] [UNREADABLE] [UNREADABLE] [UNREADABLE] [UNREADABLE] [UNREADABLE] [UNREADABLE]
[UNREADABLE] [UNREADABLE] [UNREADABLE] [UNREADABLE] [UNREADABLE] [UNREADABLE] [UNREADABLE]



 


So, my question is where and how should I start to try to find out the
cause of this problem?


 


Things I've done/notice:


 


If I click on the linked results and the switch to the alternative view
(pos), I get:


 


i ge mc fo ) rr , rr21 rr22 , pn1 vvd np1 np1 , cc np1 np1 vvd ii21 ii22
nn1 ii21 ii22 nnt1 cs pphs1 vdd xx vvi to vbi rl to vvi ppge at _appge - appge nn1 vvg dd1 nn1 .

  
 rr pph1 vbdz xx rr at1 nn1 nnt1 . 
  
 ccb md - md_nnt1 nn2 vh0 vbn -
vh0 vbn jj . 
  
 cs ppis1 vbdr np1 , ppis1 vm xx vbi vvg_jj@ nn1 ii dd1 io dd2 nn2
. 
  


 


If I go to the Admin Control Panel I see:


 


Corpus: coca | Indexing date: 2019-04-11 15:29:37 | Size Tokens: 0 |
Types: 1,274,893 | Texts: 0 | Disk space Indexes: 0.0 MB | Freq tables: 57.4 MB


 


Frequency list search show results correctly: 


1 king  11,825 


 


and all derived from king...


 


A word lookup will fail giving this output: A MySQL query did not run
successfully!



Original query: select count(concat(node,'_',tagnode)) as tokens,
count(distinct(concat(node,'_',tagnode))) as types from db_sort_h1fel9jyg4 /* from User: admin
| Function: require() | 2022-Apr-20 13:37:27 */ 

Error # 1054: Unknown column 'tagnode' in 'field list' 


 

Generate CWB text-position records outputs: A MySQL query did not run
successfully!
 Original query: insert into `___temp_cqp_text_positions_for_coca`
(text_id, cqp_begin, cqp_end) VALUES ('4122770', 0, 5307), .... etc. a lot of numbers...

Error # 1062: Duplicate entry '4166449' for key 'PRIMARY' 

 


Update Word and file counts outputs "the connections has
expired", on retrying page keeps loading until is done


 


Recreate CWB Frequency table outputs: "the connections has
expired" on retrying I get: CQPweb could not create a directory for the frequency index.
Check filesystem permissions!


 


I've checked the directories and all of them are owned by www-data


 


 


Recreate Frequency tables outpus: "the connections has expired"
on retry finally outpus;


 



A MySQL query did not run successfully!

Original query: CREATE TABLE __tempfreq_coca ( freq int(11) unsigned default NULL, word
varchar(255) NOT NULL, lemma varchar(255) NOT NULL, pos varchar(255) NOT NULL, key (word), key
(lemma), key (pos) ) CHARACTER SET utf8 COLLATE utf8_general_ci /* from  User: admin |
Function: corpus_make_freqtables() | 2022-Apr-20 13:53:57 */  

Error # 1050: Table '__tempfreq_coca' already exists 


 


I will appreciate any guidance, thanks a lot!!


 


 


 

_______________________
             andrés chandía
 
 Düngupeyem
 |  IECMap |  ISECMap |  NMT |  Corlexim


Desarrollador de:
 Parles.upf  |
 IWCH |  Amind terapia
|  Nocando |  IAC |  CddZ |  ISAC |  CatCg

P  No imprima innecesariamente. ¡Cuide el medio
ambiente!



 


_______________________

            andrés
chandía
 
Düngupeyem | IECMap | ISECMap | NMT | Corlexim

Desarrollador de:
Parles.upf | IWCH | Amind terapia | Nocando | IAC | CddZ | ISAC | CatCg
P No imprima innecesariamente. ¡Cuide el
medio ambiente!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://liste.sslmit.unibo.it/pipermail/cwb/attachments/20220420/8b17dfea/attachment-0001.html>