| Newsgroups |
gmane.comp.web.mnogosearch.general |
| Message-ID |
<[email protected]> |
Author: Alexander Barkov
Email: [email protected]
Message:
Hi,
You can try to active MySQL query log and see what's happening.
Another option to see the queries being sent is to add
DebugSQL=yes parameter into DBAddr command.
> 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} Res
ponse.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=21287>