9c6f1d896167b69c5bd07f8da82bad2b808fcafd
[citadel.git] / citadel / serv_fulltext.c
1 /*
2  * $Id$
3  *
4  * This module handles fulltext indexing of the message base.
5  *
6  */
7
8
9 #include "sysdep.h"
10 #include <stdlib.h>
11 #include <unistd.h>
12 #include <stdio.h>
13 #include <fcntl.h>
14 #include <signal.h>
15 #include <pwd.h>
16 #include <errno.h>
17 #include <sys/types.h>
18
19 #if TIME_WITH_SYS_TIME
20 # include <sys/time.h>
21 # include <time.h>
22 #else
23 # if HAVE_SYS_TIME_H
24 #  include <sys/time.h>
25 # else
26 #  include <time.h>
27 # endif
28 #endif
29
30 #include <sys/wait.h>
31 #include <string.h>
32 #include <limits.h>
33 #include "citadel.h"
34 #include "server.h"
35 #include "sysdep_decls.h"
36 #include "citserver.h"
37 #include "support.h"
38 #include "config.h"
39 #include "serv_extensions.h"
40 #include "database.h"
41 #include "msgbase.h"
42 #include "control.h"
43 #include "room_ops.h"
44 #include "tools.h"
45 #include "serv_fulltext.h"
46 #include "ft_wordbreaker.h"
47
48
49 long ft_newhighest = 0L;
50 long *ft_newmsgs = NULL;
51 int ft_num_msgs = 0;
52 int ft_num_alloc = 0;
53
54
55 int ftc_num_msgs[65536];
56 long *ftc_msgs[65536];
57
58
59 /*
60  * Compare function
61  */
62 int longcmp(const void *rec1, const void *rec2) {
63         long i1, i2;
64
65         i1 = *(const long *)rec1;
66         i2 = *(const long *)rec2;
67
68         if (i1 > i2) return(1);
69         if (i1 < i2) return(-1);
70         return(0);
71 }
72
73 /*
74  * Flush our index cache out to disk.
75  */
76 void ft_flush_cache(void) {
77         int i;
78         time_t last_update = 0;
79
80         for (i=0; i<65536; ++i) {
81                 if ((time(NULL) - last_update) >= 10) {
82                         lprintf(CTDL_INFO,
83                                 "Flushing index cache to disk (%d%% complete)\n",
84                                 (i * 100 / 65536)
85                         );
86                         last_update = time(NULL);
87                 }
88                 if (ftc_msgs[i] != NULL) {
89                         cdb_store(CDB_FULLTEXT, &i, sizeof(int), ftc_msgs[i],
90                                 (ftc_num_msgs[i] * sizeof(long)));
91                         ftc_num_msgs[i] = 0;
92                         free(ftc_msgs[i]);
93                         ftc_msgs[i] = NULL;
94                 }
95         }
96         lprintf(CTDL_INFO, "Flushed index cache to disk (100%% complete)\n");
97 }
98
99
100 /*
101  * Index or de-index a message.  (op == 1 to index, 0 to de-index)
102  */
103 void ft_index_message(long msgnum, int op) {
104         int num_tokens = 0;
105         int *tokens = NULL;
106         int i, j;
107         struct cdbdata *cdb_bucket;
108         char *msgtext;
109         int tok;
110
111         lprintf(CTDL_DEBUG, "ft_index_message() %s msg %ld\n",
112                 (op ? "adding" : "removing") , msgnum
113         );
114
115         /* Output the message as text before indexing it, so we don't end up
116          * indexing a bunch of encoded base64, etc.
117          */
118         CC->redirect_buffer = malloc(SIZ);
119         CC->redirect_len = 0;
120         CC->redirect_alloc = SIZ;
121         CtdlOutputMsg(msgnum, MT_CITADEL, HEADERS_ALL, 0, 1, NULL);
122         msgtext = CC->redirect_buffer;
123         CC->redirect_buffer = NULL;
124         CC->redirect_len = 0;
125         CC->redirect_alloc = 0;
126         lprintf(CTDL_DEBUG, "Wordbreaking message %ld...\n", msgnum);
127         wordbreaker(msgtext, &num_tokens, &tokens);
128         free(msgtext);
129
130         lprintf(CTDL_DEBUG, "Indexing message %ld [%d tokens]\n", msgnum, num_tokens);
131         if (num_tokens > 0) {
132                 for (i=0; i<num_tokens; ++i) {
133
134                         /* Add the message to the relevant token bucket */
135
136                         /* search for tokens[i] */
137                         tok = tokens[i];
138
139                         if ( (tok >= 0) && (tok <= 65535) ) {
140                                 /* fetch the bucket, Liza */
141                                 if (ftc_msgs[tok] == NULL) {
142                                         cdb_bucket = cdb_fetch(CDB_FULLTEXT, &tok, sizeof(int));
143                                         if (cdb_bucket != NULL) {
144                                                 ftc_num_msgs[tok] = cdb_bucket->len / sizeof(long);
145                                                 ftc_msgs[tok] = (long *)cdb_bucket->ptr;
146                                                 cdb_bucket->ptr = NULL;
147                                                 cdb_free(cdb_bucket);
148                                         }
149                                         else {
150                                                 ftc_num_msgs[tok] = 0;
151                                                 ftc_msgs[tok] = malloc(sizeof(long));
152                                         }
153                                 }
154         
155         
156                                 if (op == 1) {  /* add to index */
157                                         ++ftc_num_msgs[tok];
158                                         ftc_msgs[tok] = realloc(ftc_msgs[tok],
159                                                                 ftc_num_msgs[tok]*sizeof(long));
160                                         ftc_msgs[tok][ftc_num_msgs[tok] - 1] = msgnum;
161                                 }
162         
163                                 if (op == 0) {  /* remove from index */
164                                         if (ftc_num_msgs[tok] >= 1) {
165                                                 for (j=0; j<ftc_num_msgs[tok]; ++j) {
166                                                         if (ftc_msgs[tok][j] == msgnum) {
167                                                                 memmove(&ftc_msgs[tok][j], &ftc_msgs[tok][j+1], ((ftc_num_msgs[tok] - j - 1)*sizeof(long)));
168                                                                 --ftc_num_msgs[tok];
169                                                                 --j;
170                                                         }
171                                                 }
172                                         }
173                                 }
174                         }
175                         else {
176                                 lprintf(CTDL_ALERT, "Invalid token %d !!\n", tok);
177                         }
178
179                         /* FIXME do we need to unlock the file here? */
180                 }
181
182                 free(tokens);
183         }
184 }
185
186
187
188 /*
189  * Add a message to the list of those to be indexed.
190  */
191 void ft_index_msg(long msgnum, void *userdata) {
192
193         if ((msgnum > CitControl.MMfulltext) && (msgnum <= ft_newhighest)) {
194                 ++ft_num_msgs;
195                 if (ft_num_msgs > ft_num_alloc) {
196                         ft_num_alloc += 1024;
197                         ft_newmsgs = realloc(ft_newmsgs,
198                                 (ft_num_alloc * sizeof(long)));
199                 }
200                 ft_newmsgs[ft_num_msgs - 1] = msgnum;
201         }
202
203 }
204
205 /*
206  * Scan a room for messages to index.
207  */
208 void ft_index_room(struct ctdlroom *qrbuf, void *data)
209 {
210         getroom(&CC->room, qrbuf->QRname);
211         CtdlForEachMessage(MSGS_ALL, 0L, NULL, NULL, ft_index_msg, NULL);
212 }
213
214
215 /*
216  * Begin the fulltext indexing process.  (Called as an EVT_TIMER event)
217  */
218 void do_fulltext_indexing(void) {
219         int i;
220         static time_t last_index = 0L;
221         static time_t last_progress = 0L;
222
223         /*
224          * Don't do this if the site doesn't have it enabled.
225          */
226         if (!config.c_enable_fulltext) {
227                 return;
228         }
229
230         /*
231          * Make sure we don't run the indexer too frequently.
232          * FIXME move the setting into config
233          */
234         if ( (time(NULL) - last_index) < 300L) {
235                 return;
236         }
237
238         /*
239          * Check to see whether the fulltext index is up to date; if there
240          * are no messages to index, don't waste any more time trying.
241          */
242         if (CitControl.MMfulltext >= CitControl.MMhighest) {
243                 return;         /* nothing to do! */
244         }
245
246         lprintf(CTDL_DEBUG, "do_fulltext_indexing() started\n");
247         
248         /*
249          * If we've switched wordbreaker modules, burn the index and start
250          * over.
251          */
252         begin_critical_section(S_CONTROL);
253         lprintf(CTDL_DEBUG, "wb ver on disk = %d, code ver = %d\n",
254                         CitControl.fulltext_wordbreaker, FT_WORDBREAKER_ID);
255         if (CitControl.fulltext_wordbreaker != FT_WORDBREAKER_ID) {
256                 lprintf(CTDL_INFO, "(re)initializing full text index\n");
257                 cdb_trunc(CDB_FULLTEXT);
258                 CitControl.MMfulltext = 0L;
259                 put_control();
260         }
261         end_critical_section(S_CONTROL);
262
263         /*
264          * Now go through each room and find messages to index.
265          */
266         ft_newhighest = CitControl.MMhighest;
267         ForEachRoom(ft_index_room, NULL);       /* load all msg pointers */
268
269         if (ft_num_msgs > 0) {
270                 qsort(ft_newmsgs, ft_num_msgs, sizeof(long), longcmp);
271                 for (i=0; i<(ft_num_msgs-1); ++i) { /* purge dups */
272                         if (ft_newmsgs[i] == ft_newmsgs[i+1]) {
273                                 memmove(&ft_newmsgs[i], &ft_newmsgs[i+1],
274                                         ((ft_num_msgs - i - 1)*sizeof(long)));
275                                 --ft_num_msgs;
276                                 --i;
277                         }
278                 }
279
280                 /* Here it is ... do each message! */
281                 for (i=0; i<ft_num_msgs; ++i) {
282                         if ((time(NULL) - last_progress) > 10) {
283                                 lprintf(CTDL_DEBUG,
284                                         "Indexed %d of %d messages (%d%%)\n",
285                                                 i, ft_num_msgs,
286                                                 ((i*100) / ft_num_msgs)
287                                 );
288                                 last_progress = time(NULL);
289                         }
290                         ft_index_message(ft_newmsgs[i], 1);
291
292                         /* Check to see if we need to quit early */
293                         if (time_to_die) {
294                                 lprintf(CTDL_DEBUG, "Indexer quitting early\n");
295                                 ft_newhighest = ft_newmsgs[i];
296                                 break;
297                         }
298
299                         /* Check to see if we have to maybe flush to disk */
300                         if (i >= FT_MAX_CACHE) {
301                                 lprintf(CTDL_DEBUG, "Time to flush.\n");
302                                 ft_newhighest = ft_newmsgs[i];
303                                 break;
304                         }
305
306                 }
307
308                 free(ft_newmsgs);
309                 ft_num_msgs = 0;
310                 ft_num_alloc = 0;
311                 ft_newmsgs = NULL;
312         }
313
314         /* Save our place so we don't have to do this again */
315         ft_flush_cache();
316         begin_critical_section(S_CONTROL);
317         CitControl.MMfulltext = ft_newhighest;
318         CitControl.fulltext_wordbreaker = FT_WORDBREAKER_ID;
319         put_control();
320         end_critical_section(S_CONTROL);
321         last_index = time(NULL);
322
323         lprintf(CTDL_DEBUG, "do_fulltext_indexing() finished\n");
324         return;
325 }
326
327 /*
328  * Main loop for the indexer thread.
329  */
330 void *indexer_thread(void *arg) {
331         struct CitContext indexerCC;
332
333         lprintf(CTDL_DEBUG, "indexer_thread() initializing\n");
334
335         memset(&indexerCC, 0, sizeof(struct CitContext));
336         indexerCC.internal_pgm = 1;
337         indexerCC.cs_pid = 0;
338         pthread_setspecific(MyConKey, (void *)&indexerCC );
339
340         cdb_allocate_tsd();
341
342         while (!time_to_die) {
343                 do_fulltext_indexing();
344                 sleep(1);
345         }
346
347         lprintf(CTDL_DEBUG, "indexer_thread() exiting\n");
348         pthread_exit(NULL);
349 }
350
351
352
353 /*
354  * API call to perform searches.
355  * (This one does the "all of these words" search.)
356  * Caller is responsible for freeing the message list.
357  */
358 void ft_search(int *fts_num_msgs, long **fts_msgs, char *search_string) {
359         int num_tokens = 0;
360         int *tokens = NULL;
361         int i, j;
362         struct cdbdata *cdb_bucket;
363         int num_all_msgs = 0;
364         long *all_msgs = NULL;
365         int num_ret_msgs = 0;
366         int num_ret_alloc = 0;
367         long *ret_msgs = NULL;
368         int tok;
369
370         wordbreaker(search_string, &num_tokens, &tokens);
371         if (num_tokens > 0) {
372                 for (i=0; i<num_tokens; ++i) {
373
374                         /* search for tokens[i] */
375                         tok = tokens[i];
376
377                         /* fetch the bucket, Liza */
378                         if (ftc_msgs[tok] == NULL) {
379                                 cdb_bucket = cdb_fetch(CDB_FULLTEXT, &tok, sizeof(int));
380                                 if (cdb_bucket != NULL) {
381                                         ftc_num_msgs[tok] = cdb_bucket->len / sizeof(long);
382                                         ftc_msgs[tok] = (long *)cdb_bucket->ptr;
383                                         cdb_bucket->ptr = NULL;
384                                         cdb_free(cdb_bucket);
385                                 }
386                                 else {
387                                         ftc_num_msgs[tok] = 0;
388                                         ftc_msgs[tok] = malloc(sizeof(long));
389                                 }
390                         }
391
392                         num_all_msgs += ftc_num_msgs[tok];
393                         if (num_all_msgs > 0) {
394                                 all_msgs = realloc(all_msgs, num_all_msgs*sizeof(long) );
395                                 memcpy(&all_msgs[num_all_msgs-ftc_num_msgs[tok]],
396                                         ftc_msgs[tok], ftc_num_msgs[tok]*sizeof(long) );
397                         }
398
399                 }
400                 free(tokens);
401                 qsort(all_msgs, num_all_msgs, sizeof(long), longcmp);
402
403                 /*
404                  * At this point, if a message appears num_tokens times in the
405                  * list, then it contains all of the search tokens.
406                  */
407                 if (num_all_msgs >= num_tokens)
408                    for (j=0; j<(num_all_msgs-num_tokens+1); ++j) {
409                         if (all_msgs[j] == all_msgs[j+num_tokens-1]) {
410
411                                 ++num_ret_msgs;
412                                 if (num_ret_msgs > num_ret_alloc) {
413                                         num_ret_alloc += 64;
414                                         ret_msgs = realloc(ret_msgs,
415                                                 (num_ret_alloc*sizeof(long)) );
416                                 }
417                                 ret_msgs[num_ret_msgs - 1] = all_msgs[j];
418
419                         }
420                 }
421
422                 free(all_msgs);
423         }
424
425         *fts_num_msgs = num_ret_msgs;
426         *fts_msgs = ret_msgs;
427 }
428
429
430 /*
431  * This search command is for diagnostic purposes and may be removed or replaced.
432  */
433 void cmd_srch(char *argbuf) {
434         int num_msgs = 0;
435         long *msgs = NULL;
436         int i;
437         char search_string[256];
438
439         if (CtdlAccessCheck(ac_logged_in)) return;
440
441         if (!config.c_enable_fulltext) {
442                 cprintf("%d Full text index is not enabled on this server.\n",
443                         ERROR + CMD_NOT_SUPPORTED);
444                 return;
445         }
446
447         extract_token(search_string, argbuf, 0, '|', sizeof search_string);
448         ft_search(&num_msgs, &msgs, search_string);
449
450         cprintf("%d %d msgs match all search words:\n",
451                 LISTING_FOLLOWS, num_msgs);
452         if (num_msgs > 0) {
453                 for (i=0; i<num_msgs; ++i) {
454                         cprintf("%ld\n", msgs[i]);
455                 }
456         }
457         if (msgs != NULL) free(msgs);
458         cprintf("000\n");
459 }
460
461 /*
462  * Zero out our index cache.
463  */
464 void initialize_ft_cache(void) {
465         memset(ftc_num_msgs, 0, (65536 * sizeof(int)));
466         memset(ftc_msgs, 0, (65536 * sizeof(long *)));
467 }
468
469
470 /*****************************************************************************/
471
472 char *serv_fulltext_init(void)
473 {
474         initialize_ft_cache();
475         CtdlRegisterProtoHook(cmd_srch, "SRCH", "Full text search");
476         return "$Id$";
477 }