View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0003292SOGoBackend Calendarpublic2015-07-23 13:142016-12-15 20:02
Reportertbals Assigned To 
PrioritynormalSeverityminorReproducibilityunable to reproduce
Status newResolutionopen 
Platform[Server] LinuxOSDebianOS Version7 (Wheezy)
Product Version2.3.0 
Summary0003292: cannot insert content: value too long
Description

In a unpredictable case a ics filename is too long, so the Database reject to insert data:

2015-07-22 12:03:47.041 sogod[22165] PG0x0x7fac4103b700 SQL: BEGIN TRANSACTION
2015-07-22 12:03:47.042 sogod[22165] PG0x0x7fac4167a8a0 SQL: BEGIN TRANSACTION
2015-07-22 12:03:47.042 sogod[22165] PG0x0x7fac4103b700 SQL: INSERT INTO sogodare00279ba94bd_quick (c_isopaque, c_partstates, c_isallday, c_nextalarm, c_participants, c_status, c_sequence, c_component, c_priority, c_enddate, c_description, c_category, c_iscycle, c_location, c_title, c_uid, c_partmails, c_classification, c_startdate, c_orgmail, c_name) VALUES (1, '0', 0, 0, '''Local User''', 1, 0, 'vevent', 5, 1438164000, 'Subject: Meeting
Location: somewhere
When: 2015-07-29, 10:30 - 12:00 GMT +2:00 (90 minutes)
Organizer: Bob (bob@foobar.de <mailto:bob@foobar.de> )
Required Attendees: Local User (local.user@company.de <mailto:local.user@company.de> )

', null, 0, 'somewhere', 'Meeting', '80462778A326E04EBD831336D01F2A2F7E77E3298A742744B8B82849A119175B040000008200E00074C5B7101A82E00800000000E0B84911B7C3D001000000000000000010000000', 'local.user@company.de', 0, 1438158600, 'bob@foobar.de', '040000008200E00074C5B7101A82E00800000000000000000000000000000000000000009D0000007643616C2D5569640100000038303436323737384133323645303445424438333133333644303146324132463745373745333239384137343237343442384238323834394131313931373542303430303030303038323030453030303734433542373130314138324530303830303030303030304530423834393131423743334430303130303030303030303030303030303030313030303030303000.ics')
2015-07-22 12:03:47.043 sogod[22165] PG0x0x7fac4167a8a0 SQL: ROLLBACK TRANSACTION
2015-07-22 12:03:47.043 sogod[22165] PG0x0x7fac4103b700 SQL: ROLLBACK TRANSACTION
Jul 22 12:03:47 sogod [22165]: <0x0x7fac44721f40[GCSFolder]> ERROR(-[GCSFolder writeContent:fromComponent:container:toName:baseVersion:]): cannot insert content : <PostgreSQL72Exception: 0x7fac41585850> NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=<0x0x7fac4103b700[PostgreSQL72Channel]: connection=<0x0x7fac41126840[PGConnection]: connection=0x0x7fac41632df0>>): ERROR: value too long for type character varying(255)

Jul 22 12:03:47 sogod [22165]: [ERROR] <0x41113FC0[SOGoAppointmentObject]:040000008200E00074C5B7101A82E00800000000000000000000000000000000000000009D0000007643616C2D5569640100000038303436323737384133323645303445424438333133333644303146324132463745373745333239384137343237343442384238323834394131313931373542303430303030303038323030453030303734433542373130314138324530303830303030303030304530423834393131423743334430303130303030303030303030303030303030313030303030303000.ics> write failed: <PostgreSQL72Exception: 0x7fac41585850> NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=<0x0x7fac4103b700[PostgreSQL72Channel]: connection=<0x0x7fac41126840[PGConnection]: connection=0x0x7fac41632df0>>): ERROR: value too long for type character varying(255)

Jul 22 12:03:47 sogod [22165]: |SOGo| request took 0.160368 seconds to execute

Tagscalender, CardDAV

Activities

tbals

tbals

2015-07-23 13:25

reporter   ~0008763

The impact varying. In this case SOGo send an email to the Organizer every 5 Minutes that the Attendees haven choice if he wants to join.

Issue History

Date Modified Username Field Change
2015-07-23 13:14 tbals New Issue
2015-07-23 13:25 tbals Note Added: 0008763
2015-07-27 13:35 tbals Tag Attached: calender
2015-07-27 13:35 tbals Tag Attached: CardDAV
2016-12-15 20:02 ludovic Severity major => minor