Re: [rt-users] fulltext index update failure (RT 4.2.12)

2016-01-22 Thread Jim Brandt 
How much free disk space do you have? You can often get the "server gone 
away" message when MySQL runs out of disk space.


On 1/22/16 5:22 AM, elif...@free.fr wrote:

Good morning,

This is a follow-up of my problem :

This morning I decided to shred the attachment 602620.
But after execution of rt-fulltext-indexer it fails again at the next 
number of attachment : 602621 !


So this was clearly not the solution. But now I have not idea of what 
is the problem.


Any clue or help is greatly appreciated.
Thanks and have a good day,
Elisabeth



*De: *elif...@free.fr
*À: *rt-users@lists.bestpractical.com
*Envoyé: *Jeudi 21 Janvier 2016 15:57:08
*Objet: *fulltext index update failure (RT 4.2.12)

Hello,

We have juste upgraded our RT this morning to version 4.2.12 (from
4.2.6) and MySQL to 5.6 (from 5.5) in order to implement the full
text indexing.

It works, but when running /appli/rt4/sbin/rt-fulltext-indexer to
update the table AttachmentsIndex, it stops with an error :

extract from the log file :

Jan 21 14:50:01 helpdesk.inria.fr CRON[9668]: (root) CMD
(/appli/rt4/sbin/rt-fulltext-indexer --quiet)

Jan 21 14:50:03 helpdesk.inria.fr RT: [9669] DBD::mysql::st
execute failed: MySQL server has gone away at
/appli/rt4/sbin/rt-fulltext-indexer line 216.
Jan 21 14:50:03 helpdesk.inria.fr RT: [9669] DBD::mysql::st
execute failed: MySQL server has gone away at
/appli/rt4/sbin/rt-fulltext-indexer line 222.
Jan 21 14:50:03 helpdesk.inria.fr RT: [9669] Attachment 602620
cannot be indexed: MySQL server has gone away at
/appli/rt4/sbin/rt-fulltext-indexer line 254.

The result is that new attachments are not indexed.

I don't know what to do : should I just shred the attachment
602620 ? Is this at risk ?

Thanks a lot for your help,
Elisabeth

Re: [rt-users] fulltext index update failure (RT 4.2.12)

2016-01-22 Thread elifree 
Good morning, 

This is a follow-up of my problem : 

This morning I decided to shred the attachment 602620. 
But after execution of rt-fulltext-indexer it fails again at the next number of 
attachment : 602621 ! 

So this was clearly not the solution. But now I have not idea of what is the 
problem. 

Any clue or help is greatly appreciated. 
Thanks and have a good day, 
Elisabeth 

- Mail original -

| De: elif...@free.fr
| À: rt-users@lists.bestpractical.com
| Envoyé: Jeudi 21 Janvier 2016 15:57:08
| Objet: fulltext index update failure (RT 4.2.12)

| Hello,

| We have juste upgraded our RT this morning to version 4.2.12 (from
| 4.2.6) and MySQL to 5.6 (from 5.5) in order to implement the full
| text indexing.

| It works, but when running /appli/rt4/sbin/rt-fulltext-indexer to
| update the table AttachmentsIndex, it stops with an error :

| extract from the log file :

| Jan 21 14:50:01 helpdesk.inria.fr CRON[9668]: (root) CMD
| (/appli/rt4/sbin/rt-fulltext-indexer --quiet)

| Jan 21 14:50:03 helpdesk.inria.fr RT: [9669] DBD::mysql::st execute
| failed: MySQL server has gone away at
| /appli/rt4/sbin/rt-fulltext-indexer line 216.
| Jan 21 14:50:03 helpdesk.inria.fr RT: [9669] DBD::mysql::st execute
| failed: MySQL server has gone away at
| /appli/rt4/sbin/rt-fulltext-indexer line 222.
| Jan 21 14:50:03 helpdesk.inria.fr RT: [9669] Attachment 602620 cannot
| be indexed: MySQL server has gone away at
| /appli/rt4/sbin/rt-fulltext-indexer line 254.

| The result is that new attachments are not indexed.

| I don't know what to do : should I just shred the attachment 602620 ?
| Is this at risk ?

| Thanks a lot for your help,
| Elisabeth

[rt-users] fulltext index update failure (RT 4.2.12)

2016-01-21 Thread elifree 
Hello, 

We have juste upgraded our RT this morning to version 4.2.12 (from 4.2.6) and 
MySQL to 5.6 (from 5.5) in order to implement the full text indexing. 

It works, but when running /appli/rt4/sbin/rt-fulltext-indexer to update the 
table AttachmentsIndex, it stops with an error : 

extract from the log file : 

Jan 21 14:50:01 helpdesk.inria.fr CRON[9668]: (root) CMD 
(/appli/rt4/sbin/rt-fulltext-indexer --quiet) 

Jan 21 14:50:03 helpdesk.inria.fr RT: [9669] DBD::mysql::st execute failed: 
MySQL server has gone away at /appli/rt4/sbin/rt-fulltext-indexer line 216. 
Jan 21 14:50:03 helpdesk.inria.fr RT: [9669] DBD::mysql::st execute failed: 
MySQL server has gone away at /appli/rt4/sbin/rt-fulltext-indexer line 222. 
Jan 21 14:50:03 helpdesk.inria.fr RT: [9669] Attachment 602620 cannot be 
indexed: MySQL server has gone away at /appli/rt4/sbin/rt-fulltext-indexer line 
254. 

The result is that new attachments are not indexed. 

I don't know what to do : should I just shred the attachment 602620 ? Is this 
at risk ? 

Thanks a lot for your help, 
Elisabeth