[CWB] Where to start looking for the problem?

Jörg Knappen j.knappen at mx.uni-saarland.de
Wed Apr 20 18:03:37 CEST 2022 


A few things to check ...

> "The query ran successfully in 0 seconds."

So the results may be cached, clear the cache in the admin interface to 
preclude a cache issue. I have experienced strange query failures from 
cached queries when the first query ran out of time because of a 
temporary server overload.

Try the queries on the cqp command line: are the results OK than?

--Jörg Knappen

Am 2022-04-20 17:51, schrieb 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ó:
> 
> 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] 
> [1][UNREADABLE] [1] [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 [2] 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
> [3] [4]
> Düngupeyem [5] | IECMap [6] | ISECMap [7] | NMT [8] | Corlexim [9]
> 
> Desarrollador de:
> Parles.upf [10] | IWCH [11] | Amind terapia [12] | Nocando [13] | IAC 
> [14] | CddZ [15] | ISAC [16] | CatCg [17]
> P No imprima innecesariamente. ¡Cuide el medio ambiente!
> 
> _______________________
> andrés chandía
> [18] [19]
> Düngupeyem [20] | IECMap [21] | ISECMap [22] | NMT [23] | Corlexim [24]
> 
> Desarrollador de:
> Parles.upf [25] | IWCH [26] | Amind terapia [27] | Nocando [28] | IAC 
> [29] | CddZ [30] | ISAC [31] | CatCg [32]
> P No imprima innecesariamente. ¡Cuide el medio ambiente!
> _______________________________________________
> CWB mailing list
> CWB at sslmit.unibo.it
> http://liste.sslmit.unibo.it/mailman/listinfo/cwb



Links:
------
[1] 
https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fcorptedig-glif.upf.edu%2Fcqpweb%2Fcoca%2Fcontext.php%3Fbatch%3D0%26qname%3Dh1feli3mdi%26uT%3Dy&data=05%7C01%7Chardiea%40live.lancs.ac.uk%7Cbed4548d504846ec1b3708da22d85d65%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637860611089742393%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=Gz%2BTXbGVXeC4K4iuxGWiuYz%2FeL63Mp1BsUpKhXgO2eY%3D&reserved=0
[2] 
https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fcorptedig-glif.upf.edu%2Fcqpweb%2Fcoca%2Fconcordance.php%3FtheData%3D%255Bword%253D%2522king%2522%2525c%255D%26qmode%3Dcqp%26uT%3Dy&data=05%7C01%7Chardiea%40live.lancs.ac.uk%7Cbed4548d504846ec1b3708da22d85d65%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637860611089742393%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=Cm8Bvjo9QMzs%2BHcy1lhfwYlEPNi1YQNCDy9sIy9ALxI%3D&reserved=0
[3] 
https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.chandia.net%2F&data=05%7C01%7Chardiea%40live.lancs.ac.uk%7Cbed4548d504846ec1b3708da22d85d65%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637860611089742393%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=AJg06XC5QspRKWRZgaKi4ozZjfl81Wf3yFgqIC4ISB4%3D&reserved=0
[4] 
https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Ftwitter.com%2Fchandianet&data=05%7C01%7Chardiea%40live.lancs.ac.uk%7Cbed4548d504846ec1b3708da22d85d65%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637860611089742393%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=aS%2FFt7woqrhYu2Fpu1m99U7GyKUZYfykunpNP5E2f6Y%3D&reserved=0
[5] 
https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fchandia.net%2Fdungupeyem&data=05%7C01%7Chardiea%40live.lancs.ac.uk%7Cbed4548d504846ec1b3708da22d85d65%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637860611089742393%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=lNXZaBYLRwkIuGtezeNTWxfvSmK2I1Dl%2BO%2Fwng8R%2B%2Fw%3D&reserved=0
[6] 
https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fchandia.net%2Fiecmap&data=05%7C01%7Chardiea%40live.lancs.ac.uk%7Cbed4548d504846ec1b3708da22d85d65%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637860611089742393%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=a8hADAYdOQhEBwAS9FfxCcqKtPB9SktZ7ckfI186lCA%3D&reserved=0
[7] 
https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fchandia.net%2Fisecmap&data=05%7C01%7Chardiea%40live.lancs.ac.uk%7Cbed4548d504846ec1b3708da22d85d65%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637860611089742393%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=vv9UO2EfUuPJfpBaE6uuFrVuLG%2BUXtvjnVAXmyqyWOk%3D&reserved=0
[8] 
https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fchandia.net%2Fnmt-norwirin-mapudungun-trapumwe&data=05%7C01%7Chardiea%40live.lancs.ac.uk%7Cbed4548d504846ec1b3708da22d85d65%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637860611089742393%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=SysQSToEsqmW7BjPel68l0vD2hBr4xPc8%2BJJ%2Fryadbo%3D&reserved=0
[9] 
https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fcorlexim.cl%2F&data=05%7C01%7Chardiea%40live.lancs.ac.uk%7Cbed4548d504846ec1b3708da22d85d65%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637860611089742393%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=9pifsSmI2MpgFS%2F9%2F5gX4ZvWA3qOTvFxZv3V4IJm%2B3k%3D&reserved=0
[10] 
https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fparles.upf.edu%2F&data=05%7C01%7Chardiea%40live.lancs.ac.uk%7Cbed4548d504846ec1b3708da22d85d65%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637860611089742393%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=R8HlJVd5GHVsGjFtGMBp18czJlXo3SBxg7LEbvdHOQQ%3D&reserved=0
[11] 
https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fiwch.upf.edu%2F&data=05%7C01%7Chardiea%40live.lancs.ac.uk%7Cbed4548d504846ec1b3708da22d85d65%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637860611089742393%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=AONFB2FoJCNeqi72WqMi01E2QsXvTqc4ySWoBsG077c%3D&reserved=0
[12] 
https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Famindterapia.com%2F&data=05%7C01%7Chardiea%40live.lancs.ac.uk%7Cbed4548d504846ec1b3708da22d85d65%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637860611089742393%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=5FygWzN0zggop%2Fl1tCK3VrMLAWbdlgcp6LO7Hnx%2FZOw%3D&reserved=0
[13] 
https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fparles.upf.edu%2Fllocs%2Fnocando&data=05%7C01%7Chardiea%40live.lancs.ac.uk%7Cbed4548d504846ec1b3708da22d85d65%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637860611089742393%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=rbtmoherJE0ww9kKzb8En%2BQKFe4tOnVmc9nFFt6BTDM%3D&reserved=0
[14] 
https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fiac.upf.edu%2F&data=05%7C01%7Chardiea%40live.lancs.ac.uk%7Cbed4548d504846ec1b3708da22d85d65%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637860611089742393%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=cUhjtD4UEdmBJJGhCxmUh%2BQCq6Y82eJpdlfG2rrcxFo%3D&reserved=0
[15] 
https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fiac.upf.edu%2Fcddz&data=05%7C01%7Chardiea%40live.lancs.ac.uk%7Cbed4548d504846ec1b3708da22d85d65%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637860611089898601%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=jAP%2Ft6kK8UBD1V%2BqE4zLN9PNyA7%2FmvdmyfeTH8v2rDY%3D&reserved=0
[16] 
https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fiac.upf.edu%2Fisac&data=05%7C01%7Chardiea%40live.lancs.ac.uk%7Cbed4548d504846ec1b3708da22d85d65%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637860611089898601%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=QBv32euV%2Btk37zv%2BPu5tdXF%2BPlZMTfL9aOqOPy6ry5s%3D&reserved=0
[17] 
https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fcatcg.upf.edu%2F&data=05%7C01%7Chardiea%40live.lancs.ac.uk%7Cbed4548d504846ec1b3708da22d85d65%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637860611089898601%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=hYB8LyGvwVRrJTwZM5WFIZf4SchBjoFXzuWwAsJu%2FBc%3D&reserved=0
[18] http://www.chandia.net
[19] https://twitter.com/chandianet
[20] http://chandia.net/dungupeyem
[21] http://chandia.net/iecmap
[22] http://chandia.net/isecmap
[23] http://chandia.net/nmt-norwirin-mapudungun-trapumwe
[24] http://corlexim.cl
[25] https://parles.upf.edu
[26] https://iwch.upf.edu
[27] http://amindterapia.com
[28] https://parles.upf.edu/llocs/nocando
[29] https://iac.upf.edu
[30] https://iac.upf.edu/cddz
[31] https://iac.upf.edu/isac
[32] http://catcg.upf.edu
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://liste.sslmit.unibo.it/pipermail/cwb/attachments/20220420/f9f6207f/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: blocked.gif
Type: image/gif
Size: 118 bytes
Desc: not available
URL: <http://liste.sslmit.unibo.it/pipermail/cwb/attachments/20220420/f9f6207f/attachment-0001.gif>

More information about the CWB mailing list