Webboard: "bdict" table gets lost

Author: Amar Bouchibane
Email: 
Message:
We have a problem with a mnoGoSearch-table in our database: the "bdict" table is no longer available at some point.

This happened since anyone has changed access rights to some MySQL files and has undoed it later. We don't know if this is related to the table problem at all.



We have tried the following:

 - Restart the MySQL server

 - Repairing all mnogosearch-tables (in MySQL)

 - Rebuild the table indexes

 - Delete all mnogosearch-tables and rebuilding all tables (with -Ecreate)



With a "-v 5" verbose level the indexer outputs this when the "bdict" table becomes unavailable:



--- begin ---

indexer from mnogosearch-3.3.9-mysql-DB2-solid-SAPDB-ibase-ctlib-freetds-oracle8-oracle8i started with '/tmp/mnogosearch-gsfPHO'

[17683]{01} URL: htdb:/tx_helpzag_main/1/415 [17683]{01} Server Allow 'htdb:/tx_helpzag_main/'

[17683]{01} Allow by default

[17683]{01} Request.Accept-Charset: utf-8;q=1.0, *;q=0.9, utf-8;q=0.8 [17683]{01} Request.Accept-Encoding: gzip,deflate,compress [17683]{01} Request.Accept-Language: de, en [17683]{01} Request.If-Modified-Since: Mon, 15 Aug 2011 11:45:59 GMT [17683]{01} Request.User-Agent: MnoGoSearch/3.3.9 [17683]{01} Request.X-TYPO3-mnogosearch: 13c7e6b2c994cda93e35cece1bb5a747 [17683]{01} HTDBDoc: SELECT zag_title AS title,zag_description AS 'meta.description',tstamp AS last_mod_time,zag_keywords AS body FROM tx_helpzag_main WHERE uid=415



[17683]{01} Response.body: <NULL>

[17683]{01} Response.case_sense: 1

[17683]{01} Response.Content-Length: 216 [17683]{01} Response.Content-Type: mnogosearch/htdb [17683]{01} Response.crc32: 513908883 [17683]{01} Response.crc32old: 513908883 [17683]{01} Response.DefaultLang: de [17683]{01} Response.DetectClones: 0 [17683]{01} Response.Follow: 1 [17683]{01} Response.HoldBadHrefs: 86400 [17683]{01} Response.Hops: 0 [17683]{01} Response.HTDBAddr: mysql://uttguidebase:XXXXXXXXXXXX@localhost/ttguidebase_helpzagportal/?setnames=UTF8

[17683]{01} Response.HTDBDoc: SELECT zag_title AS title,zag_description AS 'meta.description',tstamp AS last_mod_time,zag_keywords AS body FROM tx_helpzag_main WHERE uid=$3 [17683]{01} Response.HTDBLimit: 4096 [17683]{01} Response.HTDBList: SELECT CONCAT('htdb:/tx_helpzag_main/1/', uid) FROM tx_helpzag_main WHERE pid=4 AND tx_helpzag_main.hidden=0 AND (tx_helpzag_main.starttime<=1313412360)

[17683]{01} Response.ID: 782

[17683]{01} Response.Last-Modified: Mon, 15 Aug 2011 11:45:59 GMT [17683]{01} Response.match_type: 1 [17683]{01} Response.MaxDocPerSite: 0 [17683]{01} Response.MaxHops: 256 [17683]{01} Response.meta.description: <NULL> [17683]{01} Response.meta.keywords: <NULL> [17683]{01} Response.Method: Allow [17683]{01} Response.nomatch: 0 [17683]{01} Response.Period: 3600 [17683]{01} Response.PrevStatus: 200 [17683]{01} Response.RemoteCharset: utf-8 [17683]{01} Response.Request.Accept-Language: de, en [17683]{01} Response.Request.X-TYPO3-mnogosearch: 13c7e6b2c994cda93e35cece1bb5a747 [17683]{01} Response.ResponseLine: HTTP/1.0 200 OK [17683]{01} Response.ResponseSize: 97 [17683]{01} Response.Server_id: 53193042 [17683]{01} Response.Site_id: -1212446494 [17683]{01} Response.Status: 200 [17683]{01} Respo
 nse.title: <NULL> [17683]{01} Response.URL: htdb:/tx_helpzag_main/1/415 [17683]{01} Response.URL_ID: 1031150279 [17683]{01} Response.VaryLang: ab aa af sq am ar hy as ay az ba eu bn dz bh bi br bg my be km ca za zh co hr cs da nl en eo et fo fa fj fi fr fy gl gd gv ka de el kl gn gu ha he hi hu is id ia ie iu ik ga it ja kn ks kk rw ky rn ko ku lo la lv ln lt mk m [17683]{01} Status: 200 OK [17683]{01} Guesser: Lang: , Charset: utf-8 [17683]{01} Done (0 seconds, 1 documents, 313 bytes,  0.00 Kbytes/sec.) Converting to blob Loading URL list URL list loaded: 506 urls, 0.00 sec Not using deflate MySQL driver: #1146: Table 'ttguidebase_mnogosearch.bdict' doesn't exist Calculating word statistics {suggest.c:47} Query: SELECT word, sum(octet_length(intag)) FROM bdict GROUP BY word



Word statistics done

MySQL driver: #1146: Table 'ttguidebase_mnogosearch.bdict' doesn't exist

--- end ---





We use a socket connection with MySQL and max_allowed_packet = 30M.

MnoGoSearch is installed on a SUSE Enterprise Linux 64-Bit OS.



This problem occurs with 3.3.9 and 3.3.11.



Does anybody know what we can do even more?



best regards,

Amar

Reply: <http://www.mnogosearch.org/board/message.php?id=21280>