SOGo | BTS

Relationship Graph View Issue ] Dependency Graph ]
related to child of duplicate of


View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0001848SOGoBackend Calendarpublic2012-06-21 06:412012-07-18 11:38
ReporterDavid 
Assigned Tojraby 
PrioritynormalSeveritymajorReproducibilityalways
StatusresolvedResolutionfixed 
PlatformOSOS Version
Product Version1.3.16 
Target Version1.3.17Fixed in Version 
Summary0001848: Recurrent event can not be edited
DescriptionWhen deleting single occurrence of recurrent event nothing happens.
Additional InformationEvent attached

SOGo log presents this:

localhost.localdomain - - [21/Jun/2012:12:01:04 GMT] "GET /SOGo/so/don.joe/Calendar/alice_personal/8F6-4BBDDB00-1A3-266E6E40/edit HTTP/1.1" 200 10467/0 0.183 31382 66% 80K
2012-06-21 12:01:07.917 sogod[6997] WARNING(-[NSNull(misc) count]): called NSNull -count (returns 0) !!!
localhost.localdomain - - [21/Jun/2012:12:01:07 GMT] "GET /SOGo/so/don.joe/Calendar/editRecurrence HTTP/1.1" 200 9777/0 0.082 31507 68% 0
Jun 21 12:01:13 sogod [6997]: <0x0xfdab208[GCSFolder]> ERROR(-[GCSFolder writeContent:toName:baseVersion:]): cannot update content : <PostgreSQL72Exception: 0x10210338> NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=<0x0xfbc3018[PostgreSQL72Channel]: connection=<0x0xfbcb828[PGConnection]: connection=0x0xfdc27c0>>): ERROR: value too long for type character varying(1000)
Jun 21 12:01:13 sogod [6997]: [ERROR] <0x10356258[SOGoAppointmentObject]:8F6-4BBDDB00-1A3-266E6E40> write failed: <PostgreSQL72Exception: 0x10210338> NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=<0x0xfbc3018[PostgreSQL72Channel]: connection=<0x0xfbcb828[PGConnection]: connection=0x0xfdc27c0>>): ERROR: value too long for type character varying(1000)
localhost.localdomain - - [21/Jun/2012:12:01:13 GMT] "POST /SOGo/so/don.joe/Calendar/alice_personal/8F6-4BBDDB00-1A3-266E6E40/saveAsAppointment HTTP/1.1" 200 21/807 0.082 - - 60K
TagsNo tags attached.
Attached Files? file icon event.ics [^] (4,106 bytes) 2012-06-21 06:41

-  Notes
User avatar (0004086)
Christian Mack (developer)
2012-06-22 04:58

connection=<0x0xfbcb828[PGConnection]: connection=0x0xfdc27c0>>): ERROR: value too long for type character varying(1000)

Seems this event contains a really large text value (description?), which is too large for the corresponding postgres database field (1000 characters max).

Could you check this event via sogo-tool?
Or look into the postgres logs for the corresponding update?
(0004090)
David (reporter)
2012-06-25 08:31

Honestly, I do not know what do you mean by checking via sogo-tool.

I think there's no doubt the event contains large field. As you can see from the attached event there are many date exceptions. These are being stored in database field 'c_cycleinfo'. The field is in 'sogouserxxxx_quick' table and is limited to 1000 chars (character varying(1000)). This field prevents event changes.

I already have 2 users with error like this. When it happens they are unable to
manage their event in any way. The only solution is to shorten the field 'c_cycleinfo' manually in database.
(0004173)
jraby (viewer)
2012-07-18 11:38

I've added new scripts to the distribution: Scripts/sql-update-1.3.16_to_1.3.17*.sh

These will go through the table list and expand the c_cycleinfo column to its default size (1000000, since sogo 1.3.3).

Please note that this problem only occurs to accounts created with a really old version of sogo (pre 1.3.3). New users should already be fine.

- Issue History
Date Modified Username Field Change
2012-06-21 06:41 David New Issue
2012-06-21 06:41 David File Added: event.ics
2012-06-22 04:58 Christian Mack Note Added: 0004086
2012-06-25 08:31 David Note Added: 0004090
2012-06-27 09:09 francis Target Version => 1.3.17
2012-07-13 13:56 ludovic Status new => assigned
2012-07-13 13:56 ludovic Assigned To => jraby
2012-07-18 11:38 jraby Note Added: 0004173
2012-07-18 11:38 jraby Status assigned => resolved
2012-07-18 11:38 jraby Resolution open => fixed
2012-07-23 09:38 ludovic Relationship added related to 0001712


Copyright © 2000 - 2019 MantisBT Team
Powered by Mantis Bugtracker