[horde] Horde suddenly started half-working

Thu Oct 16 00:50:17 UTC 2014

Quoting Louis-Philippe Allard <lp.allard.1 at gmail.com>:

> On Wed, Oct 15, 2014 at 12:57 PM, Michael J Rubinsky <mrubinsk at horde.org>
> wrote:
>
>>
>> Quoting Louis-Philippe Allard <lp.allard.1 at gmail.com>:
>>
>>  On Wed, Oct 15, 2014 at 11:11 AM, Michael J Rubinsky <mrubinsk at horde.org>
>>> wrote:
>>>
>>>
>>>> Quoting Louis-Philippe Allard <lp.allard.1 at gmail.com>:
>>>>
>>>> On Mon, Oct 6, 2014 at 12:51 PM, Jan Schneider <jan at horde.org> wrote:
>>>>
>>>>>
>>>>>
>>>>>  Zitat von Louis-Philippe Allard <lp.allard.1 at gmail.com>:
>>>>>>
>>>>>>  Hi
>>>>>>
>>>>>>
>>>>>>> Ive been using my current horde setup for about  3 months and all was
>>>>>>> fine
>>>>>>> until tonight where I tried to send an email and it never finished.
>>>>>>> This
>>>>>>> is the behavior and symptoms Ive observed:
>>>>>>>
>>>>>>> -Compose a test email to myself (send it to myself), press send, the
>>>>>>> window
>>>>>>> becomes gray and the spinning wheel spins forever
>>>>>>>
>>>>>>> -The spinner beside "Refresh" in the main email window keeps spinning
>>>>>>> forever
>>>>>>>
>>>>>>> -While this happens, the test email do not arrive in inbox (so as
>>>>>>> anything
>>>>>>> else)
>>>>>>>
>>>>>>> -Pressing F5 on browser (refresh) causes 10 to 20 red error alerts
>>>>>>> "Error
>>>>>>> communicating with server" to appear
>>>>>>>
>>>>>>> -Closing browser and reopening, the test email arrive in inbox and
>>>>>>> confirms
>>>>>>> that even if the compose window never finished and closed, the email
>>>>>>> was
>>>>>>> indeed sent.
>>>>>>>
>>>>>>> I tried restarting httpd,  flushing temp files on the server, looking
>>>>>>> at
>>>>>>> httpd logs, flushing firefox cache manually (although set to auto
>>>>>>> clean
>>>>>>> at
>>>>>>> shutdown) nothing helps.
>>>>>>>
>>>>>>> I swear yesterday all was fine but today this is broken. How to
>>>>>>> troubleshoot??
>>>>>>>
>>>>>>> Thanks!
>>>>>>>
>>>>>>>
>>>>>>>  HTTP logs are useless. Check JS, IMAP, Horde logs.
>>>>>>
>>>>>> --
>>>>>> Jan Schneider
>>>>>> The Horde Project
>>>>>> http://www.horde.org/
>>>>>> https://www.facebook.com/hordeproject
>>>>>>
>>>>>> --
>>>>>> Horde mailing list
>>>>>> Frequently Asked Questions: http://horde.org/faq/
>>>>>> To unsubscribe, mail: horde-unsubscribe at lists.horde.org
>>>>>>
>>>>>>
>>>>>>  I have tried to send this email with my Horde install and it failed,
>>>>> so if
>>>>> it was somehow sent already I apologize for repeating...
>>>>>
>>>>> Hello Jan,  I have tried to find error entries in various logs, except
>>>>> than
>>>>> Snort blocking Google servers therefore screwing things up, I have not
>>>>> found anything else except hundreds of error messages in
>>>>> /var/log/messages
>>>>> all related to database:
>>>>>
>>>>> Oct 14 07:28:29 centos-productive HORDE: [imp] SQL QUERY FAILED: Unknown
>>>>> column 'object_uid' in 'where clause'  #012#011SELECT * FROM
>>>>> horde_histories WHERE object_uid =#012#011
>>>>> 'imp:lp*allard*1 at gmail*com:<###################>'
>>>>> [pid 26940 on line 315 of "/usr/share/pear/Horde/Db/
>>>>> Adapter/Mysqli.php"]
>>>>> Oct 14 07:28:29 centos-productive HORDE: [imp] SQL QUERY FAILED: Unknown
>>>>> column 'object_uid' in 'where clause'  #012#011SELECT * FROM
>>>>> horde_histories WHERE object_uid =#012#011
>>>>> 'imp:lp*allard*1 at gmail*com:<###################>'
>>>>> [pid 26940 on line 315 of "/usr/share/pear/Horde/Db/
>>>>> Adapter/Mysqli.php"]
>>>>> Oct 14 07:28:39 centos-productive HORDE: [imp] SQL QUERY FAILED: Unknown
>>>>> column 'object_uid' in 'where clause'  #012#011SELECT * FROM
>>>>> horde_histories WHERE object_uid =#012#011  'imp:lp*allard*1 at gmail*com'
>>>>> [pid 26944 on line 315 of "/usr/share/pear/Horde/Db/
>>>>> Adapter/Mysqli.php"]
>>>>> Oct 14 07:28:39 centos-productive HORDE: [imp] SQL QUERY FAILED: Unknown
>>>>> column 'object_uid' in 'where clause'  #012#011SELECT * FROM
>>>>> horde_histories WHERE object_uid =#012#011
>>>>> 'imp:lp*allard*1 at gmail*com:<###################>'
>>>>> [pid 26944 on line 315 of "/usr/share/pear/Horde/Db/
>>>>> Adapter/Mysqli.php"]
>>>>> Oct 14 07:29:42 centos-productive HORDE: [imp] SQL QUERY FAILED: Unknown
>>>>> column 'object_uid' in 'where clause'  #012#011SELECT * FROM
>>>>> horde_histories WHERE object_uid =#012#011
>>>>> 'imp:lp*allard*1 at gmail*com:<###################>'
>>>>> [pid 26940 on line 315 of "/usr/share/pear/Horde/Db/
>>>>> Adapter/Mysqli.php"]
>>>>> Oct 14 18:43:43 centos-productive HORDE: [imp] SQL QUERY FAILED: Unknown
>>>>> column 'object_uid' in 'where clause'  #012#011SELECT * FROM
>>>>> horde_histories WHERE object_uid =#012#011
>>>>> 'imp:lp*allard*1 at gmail*com:<###################>'
>>>>> [pid 26937 on line 315 of "/usr/share/pear/Horde/Db/
>>>>> Adapter/Mysqli.php"]
>>>>> Oct 14 21:36:22 centos-productive HORDE: [imp] SQL QUERY FAILED: Unknown
>>>>> column 'object_uid' in 'where clause'  #012#011SELECT * FROM
>>>>> horde_histories WHERE object_uid =#012#011
>>>>> 'imp:lp*allard*1 at gmail*com:<###################>'
>>>>> [pid 31146 on line 315 of "/usr/share/pear/Horde/Db/
>>>>> Adapter/Mysqli.php"]
>>>>>
>>>>> I did upgrade the DB schemas when I installed horde.  Apparently the
>>>>> errors
>>>>> are dating back a while....
>>>>>
>>>>> I remember when I installed Horde I saw similar errors in the GUI in a
>>>>> red
>>>>> tooltip popping up at the bottom...
>>>>>
>>>>> What next?
>>>>>
>>>>>
>>>> Obviously something failed in the creation of the horde_histories table.
>>>> What does that table look like? What happens if you try to recreate the
>>>> table using horde-db-migrate?
>>>>
>>>>
>>>> --
>>>> mike
>>>> The Horde Project
>>>> http://www.horde.org
>>>> https://www.facebook.com/hordeproject
>>>> https://www.twitter.com/hordeproject
>>>>
>>>> --
>>>> Horde mailing list
>>>> Frequently Asked Questions: http://horde.org/faq/
>>>> To unsubscribe, mail: horde-unsubscribe at lists.horde.org
>>>>
>>>>
>>>>  Mike,
>>>
>>> I have no access to the server just now but within the next 6 hours I will
>>> try what you suggested.  In the meantime, can you tell me what is the
>>> purpose of the horde_histories table?  Can I fear data loss?
>>>
>>> Cheers!
>>>
>>
>> Histories maintains, well, history. It logs things like when a new item
>> (event, contact etc...) is created, deleted, edited. It's mostly used for
>> synchronization, but it also has uses with logging mail actions (when an
>> item was forwarded, for example).
>>
>> --
>> mike
>> The Horde Project
>> http://www.horde.org
>> https://www.facebook.com/hordeproject
>> https://www.twitter.com/hordeproject
>>
>
> Mike,  the horde-histories table has only one field called history_id and
> 7283 entries in it ... Im not a SQL Guru or anything like that, so please
> provide the proper SQL commands to provide what you need. The table
> definitely exists..
>
> I can try to recreate the table but should I?

Well, if that is truly the only field in that table, the table is  
useless. I would be more concerned about WHY it only contains that one  
column though...

-- 
mike
The Horde Project
http://www.horde.org
https://www.facebook.com/hordeproject
https://www.twitter.com/hordeproject
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 5869 bytes
Desc: S/MIME Signature
URL: <http://lists.horde.org/archives/horde/attachments/20141015/adc7bb16/attachment.bin>