[CWB] Where to start looking for the problem?

["Andrés Chandía"]

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!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://liste.sslmit.unibo.it/pipermail/cwb/attachments/20220420/edb7c4dc/attachment.html>