[kronolith] Event notification from another user private calendar
Luis Felipe Marzagao
lfbm.andamentos at gmail.com
Thu Feb 18 23:31:25 UTC 2016
Em 18/02/16 20:18, Michael J Rubinsky escreveu:
>
> Quoting Luis Felipe Marzagao <lfbm.andamentos at gmail.com>:
>
>> Em 18/02/2016 18:31, Michael J Rubinsky escreveu:
>>>
>>> Quoting Jens Wahnes <wahnes at uni-koeln.de>:
>>>
>>>> Michael J Rubinsky wrote:
>>>>
>>>>> Quoting Jens Wahnes <wahnes at uni-koeln.de>:
>>>>>
>>>>>> On Tue, Feb 16 2016, at 11:49:41 -0200, Luis Felipe Marzagao wrote:
>>>>>>
>>>>>>> Em 15/02/2016 11:47, Luis Felipe Marzagao escreveu:
>>>>>>>> Hello:
>>>>>>>>
>>>>>>>> I´ve just been notified in kronolith (the orange bottom-right box)
>>>>>>>> about
>>>>>>>> an event that was created by another user in his private calendar.
>>>>>>>>
>>>>>>>> I do not have access to that calendar. It´s not listed in my
>>>>>>>> shared
>>>>>>>> calendars.
>>>>>>>>
>>>>>>>> If I click on the event name at the orange notification box I
>>>>>>>> get a
>>>>>>>> "Event not found" error (red box). Probably because I don´t have
>>>>>>>> access
>>>>>>>> to that event, as expected, since it´s private for that user.
>>>>>>>>
>>>>>>>> We are using kronolith 4.2.14.
>>>>>>>
>>>>>>> Today it has happened again.
>>>>>>
>>>>>> I didn't notice this on our test server, but since we updated our
>>>>>> main
>>>>>> server to the latest versions of Horde (including Kronolith 4.2.15),
>>>>>> this is happening to us as well.
>>>>>>
>>>>>> The problem seems to stem from the horde-alarms script being run (a
>>>>>> cronjob in our case). After the update, the horde-alarms script
>>>>>> consumes way more memory than before and takes ages to run (before:
>>>>>> less than a second, after the upgrade: more than a minute).
>>>>>
>>>>> There was a bug in the code that polls each application for
>>>>> alarms. We
>>>>> weren't actually polling the applications at all in certain cases.
>>>>> This
>>>>> commit:
>>>>>
>>>>> https://github.com/horde/horde/commit/4b482074340bf4e7ddc469d69172c5c0a2c761f8
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> fixed the issue, and probably explains the longer execution time,
>>>>> since
>>>>> each application is now actually polled. I'm not seeing your other
>>>>> issue, but will look into it further.
>>>>
>>>> I did some testing with higher debug levels during a run of the
>>>> horde-alarms script which generated a ton of output which I've been
>>>> wading through. One thing that caught my attention was a query that
>>>> was logged and looks like this:
>>>>
>>>> SELECT * FROM kronolith_sharesng WHERE share_name = 0 [pid 18524 on
>>>> line 321 of "/usr/share/pear/Horde/Db/Adapter/Mysqli.php"]
>>>
>>> This is probably coming from Kronolith_Application::listAlarms().
>>>
>>> As an admin user, execute the following from the admin phpshell page,
>>> using kronolith's scope:
>>>
>>>
>
>>>
>>>
>>> You should see an array of share_names. If I'm right, one of these will
>>> be '0' for some unknown reason.
>>
>> Yep, for me it does. The 23th item:
>>
>> array(24) {
>> [0]=>
>> string(23) "0ZiHPQiFsvBP6PWQoSL0iwA"
>> [1]=>
>> string(32) "11e3b9f2f49fab07664945d4cede8469"
>> [2]=>
>> string(32) "57f3b572c7d8276e65b91e3cd346b172"
>> [3]=>
>> string(32) "5bdc6fa2c97cecef501b34c47c14d9f9"
>> [4]=>
>> string(2) "ac"
>> [5]=>
>> string(4) "acfs"
>> [6]=>
>> string(13) "Administrator"
>> [7]=>
>> string(3) "aps"
>> [8]=>
>> string(3) "cel"
>> [9]=>
>> string(3) "daa"
>> [10]=>
>> string(2) "em"
>> [11]=>
>> string(23) "FmzDcAiFsvBP1WO3OgIwOPA"
>> [12]=>
>> string(23) "f_B_EAlE4RdL8ZGJ9IzxuQ5"
>> [13]=>
>> string(3) "ibl"
>> [14]=>
>> string(4) "lfbm"
>> [15]=>
>> string(3) "mes"
>> [16]=>
>> string(4) "rabm"
>> [17]=>
>> string(5) "rabmj"
>> [18]=>
>> string(4) "robm"
>> [19]=>
>> string(23) "SZtmkeuHIuoMv74QHovb1A1"
>> [20]=>
>> string(4) "veri"
>> [21]=>
>> string(4) "vmlr"
>> [22]=>
>> string(3) "vsg"
>> [23]=>
>> int(0)
>
>
> This means that the share in the database doesn't have a share_name
> for some reason. Can you see which share that is in the
> kronolith_sharesng table?
>
>
Apparently, there is no such entry without share_name in my tables. Here
they are:
mysql> select share_id, share_name from kronolith_shares;
+----------+----------------------------------+
| share_id | share_name |
+----------+----------------------------------+
| 1 | lfbm |
| 2 | robm |
| 3 | 57f3b572c7d8276e65b91e3cd346b172 |
| 4 | cel |
| 5 | aps |
| 6 | em |
| 7 | daa |
| 8 | rabm |
| 9 | rabmj |
| 10 | veri |
| 11 | ac |
| 13 | mes |
| 14 | Administrator |
| 16 | 5bdc6fa2c97cecef501b34c47c14d9f9 |
| 17 | 11e3b9f2f49fab07664945d4cede8469 |
| 27 | vmlr |
| 22 | ibl |
| 23 | vsg |
| 26 | acfs |
+----------+----------------------------------+
19 rows in set (0.00 sec)
mysql> select share_id, share_name from kronolith_sharesng;
+----------+----------------------------------+
| share_id | share_name |
+----------+----------------------------------+
| 29 | 0ZiHPQiFsvBP6PWQoSL0iwA |
| 17 | 11e3b9f2f49fab07664945d4cede8469 |
| 3 | 57f3b572c7d8276e65b91e3cd346b172 |
| 16 | 5bdc6fa2c97cecef501b34c47c14d9f9 |
| 11 | ac |
| 26 | acfs |
| 14 | Administrator |
| 5 | aps |
| 4 | cel |
| 7 | daa |
| 6 | em |
| 28 | FmzDcAiFsvBP1WO3OgIwOPA |
| 30 | f_B_EAlE4RdL8ZGJ9IzxuQ5 |
| 22 | ibl |
| 1 | lfbm |
| 13 | mes |
| 8 | rabm |
| 9 | rabmj |
| 2 | robm |
| 31 | SZtmkeuHIuoMv74QHovb1A1 |
| 10 | veri |
| 27 | vmlr |
| 23 | vsg |
+----------+----------------------------------+
23 rows in set (0.00 sec)
What else should I check?
Thanks a lot!
>
>
More information about the kronolith
mailing list