[rt-users] RT 4.0.5 fulltext errors

Poulter, Dale dale.poulter at Vanderbilt.Edu
Fri Mar 23 15:01:49 EDT 2012


Nothing is appearing in the mysql error log.

When I go into mysql the AttachmentsIndex is empty -- although the indexing appeared to succeed.


indexing index 'rt'...
WARNING: Attribute count is 0: switching to none docinfo
collected 110222 docs, 96.0 MB
sorted 14.9 Mhits, 100.0% done
total 110222 docs, 95954943 bytes
total 48.936 sec, 1960788 bytes/sec, 2252.32 docs/sec
total 12 reads, 0.046 sec, 3133.3 kb/call avg, 3.8 msec/call avg
total 95 writes, 0.322 sec, 940.1 kb/call avg, 3.3 msec/call avg


-----Original Message-----
From: rt-users-bounces at lists.bestpractical.com [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Kevin Falcone
Sent: Friday, March 23, 2012 1:37 PM
To: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] RT 4.0.5 fulltext errors

On Fri, Mar 23, 2012 at 12:51:35PM -0500, Poulter,   Dale wrote:
>    We have just install 4.0.5 in a test environment and migrated our data from 3.8.7.  The system
>    was working with 4.0.4 with the same configuration before our dev server crashed. The system
>    seems to be working well until we attempt to do a full text search.  Sphinx is enabled in
>    mysql and the indexer has ran successfully.  I can do a basic simple search without any
>    problems but when I do a fulltext search (fulltext: test) mysql restarts and I get the error
>    below.  Has anyone encountered this issue?

What's in the mysql error log?  RT is just reporting that there was an error, mysql will be able to tell you what's really going on.

Also, what happens when you try to select from your AttachmentsIndex table manually?

-kevin




More information about the rt-users mailing list