[horde] Horde suddenly started half-working

Wed Oct 15 16:45:56 UTC 2014

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!