[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sogo-users
Subject:    Re: [SOGo] mysql select loop
From:       Hugo <mail () hugo ! ro>
Date:       2015-12-11 16:01:25
Message-ID: 566AF355.10006 () hugo ! ro
[Download RAW message or body]

hi there,

no one seen this? should I file a bug?

thanks,
hugo.-

On 21.11.2015 11:56, Hugo wrote:
> Hi list
> 
> I upgraded my sogo from 2.1.1 to the latest git build. it first didn't
> work as expected, so I tried to rum mysql update scripts. that didn't
> work either. so I dumped the DB and recreated it, created my user, and
> did a sogo-tool restore. now the contacts and events are there and seem
> to be ok, even thunderbird works ok, but I cannot get the calendar "tab"
> to load in the browser. mail/address book/settings/contacts all work,
> but when I switch to calendar, it starts these never ending queries in
> mysql:
> 
> 2015-11-21 11:43:01.398 sogod[400] <MySQL4Channel[0x0xb7524e20]
> connection=0x0xb7534fc0> SQL: SELECT
> b.c_name,b.c_content,b.c_creationdate,b.c_lastmodified,b.c_version,a.c_component,a.c \
> _title,a.c_location,a.c_orgmail,a.c_status,a.c_category,a.c_classification,a.c_isall \
> day,a.c_isopaque,a.c_participants,a.c_partmails,a.c_partstates,a.c_sequence,a.c_prio \
> rity,a.c_cycleinfo,a.c_iscycle,a.c_nextalarm,a.c_description,a.c_uid,a.c_startdate,a.c_enddate
>  FROM sogohugo0010a880c16_quick a, sogohugo0010a880c16 b WHERE
> ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate <=
> 1448233199)) AND ((c_cycleenddate IS NULL) OR (c_cycleenddate >=
> 1447628400)) AND (c_iscycle = 1)) AND a.c_name = b.c_name AND (c_deleted
> != 1 OR c_deleted IS NULL);
> 2015-11-21 11:43:01.398 sogod[400] <MySQL4Channel[0x0xb7524e20]
> connection=0x0xb7534fc0>   query has results, entering fetch-mode.
> Nov 21 11:43:01 sogod [4712]: |SOGo| starting method 'GET' on uri
> '/SOGo/so/hugo/Calendar/UIxCalMainFrame'
> 2015-11-21 11:43:01.404 sogod[4712] <MySQL4Channel[0x0xb74c1e70]
> connection=0x0xb74ce7d0> SQL: SELECT c_path4 FROM sogo_folder_info WHERE
> c_path2 = 'hugo' AND c_folder_type = 'Appointment';
> 2015-11-21 11:43:01.405 sogod[4712] <MySQL4Channel[0x0xb74c1e70]
> connection=0x0xb74ce7d0>   query has results, entering fetch-mode.
> Nov 21 11:43:01 sogod [4712]: |SOGo| request took 0.006723 seconds to
> execute
> Nov 21 11:43:01 sogod [4712]: 79.197.74.192 "GET
> /SOGo/so/hugo/Calendar/UIxCalMainFrame HTTP/1.1" 404 208/0 0.009 - - 0
> Nov 21 11:43:01 sogod [400]: |SOGo| request took 0.030983 seconds to
> execute
> Nov 21 11:43:01 sogod [400]: 79.197.74.192 "GET
> /SOGo/so/hugo/Calendar/eventsblocks?ed=20151122&sd=20151116&view=weekview HTTP/1.1"
> 200 448/0 0.035 - - 0
> Nov 21 11:43:01 sogod [400]: |SOGo| starting method 'GET' on uri
> '/SOGo/so/hugo/Calendar/UIxCalMainFrame'
> 2015-11-21 11:43:01.427 sogod[400] <MySQL4Channel[0x0xb74df968]
> connection=0x0xb722be48> SQL: SELECT c_path4 FROM sogo_folder_info WHERE
> c_path2 = 'hugo' AND c_folder_type = 'Appointment';
> 2015-11-21 11:43:01.428 sogod[400] <MySQL4Channel[0x0xb74df968]
> connection=0x0xb722be48>   query has results, entering fetch-mode.
> Nov 21 11:43:01 sogod [400]: |SOGo| request took 0.006718 seconds to
> execute
> Nov 21 11:43:01 sogod [400]: 79.197.74.192 "GET
> /SOGo/so/hugo/Calendar/UIxCalMainFrame HTTP/1.1" 404 208/0 0.009 - - 0
> Nov 21 11:43:01 sogod [400]: |SOGo| starting method 'GET' on uri
> '/SOGo/so/hugo/Calendar/UIxCalMainFrame'
> 2015-11-21 11:43:01.450 sogod[400] <MySQL4Channel[0x0xb7524e20]
> connection=0x0xb7534fc0> SQL: SELECT c_path4 FROM sogo_folder_info WHERE
> c_path2 = 'hugo' AND c_folder_type = 'Appointment';
> 2015-11-21 11:43:01.450 sogod[400] <MySQL4Channel[0x0xb7524e20]
> connection=0x0xb7534fc0>   query has results, entering fetch-mode.
> Nov 21 11:43:01 sogod [400]: |SOGo| request took 0.006516 seconds to
> execute
> Nov 21 11:43:01 sogod [400]: 79.197.74.192 "GET
> /SOGo/so/hugo/Calendar/UIxCalMainFrame HTTP/1.1" 404 208/0 0.009 - - 0
> Nov 21 11:43:01 sogod [400]: |SOGo| starting method 'GET' on uri
> '/SOGo/so/hugo/Calendar/UIxCalMainFrame'
> 
> 
> I tried the query on the DB and it returns this:
> mysql> SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'hugo' AND
> c_folder_type = 'Appointment';
> +-------------------------+
> > c_path4                 |
> +-------------------------+
> > F88-51B47200-1-2DFCE500 |
> > personal                |
> +-------------------------+
> 2 rows in set (0.00 sec)
> 
> what should I try next?
> 
> thanks,
> hugo.-
-- 
users@sogo.nu
https://inverse.ca/sogo/lists


[prev in list] [next in list] [prev in thread] [next in thread]