View Issue Details

IDProjectCategoryView StatusLast Update
0003031SOGoBackend Address Bookpublic2016-04-21 20:05
Reporteralessandro.bono Assigned Toludovic  
PrioritynormalSeverityfeatureReproducibilityhave not tried
Status closedResolutionno change required 
Platform[Server] LinuxOSRHEL/CentOSOS Version6
Product Version2.2.11a 
Summary0003031: sogo problems with big photo in address book
Description

A user attempted to add a large picture (about 1M) to a contact from thunderbird, but you can not synchronize contacts
On server there are these logs

10.12.18.74 - - [18/Dec/2014:14:43:43 GMT] "PROPFIND /SOGo/dav/info/Contacts/25EC-50ACE300-15-33512880/ HTTP/1.1" 207 437/175 0.031 1046 58% 0
Dec 18 14:43:47 sogod [6516]: <0x0x7f77b841a378[GCSFolder]> ERROR(-[GCSFolder writeContent:fromComponent:container:toName:baseVersion:]): cannot update content : <MySQL4Exception: 0x7f77b8e976a8> NAME:ExecutionFailed REASON:Got a packet bigger than 'max_allowed_packet' bytes
Dec 18 14:43:47 sogod [6516]: [ERROR] <0xB8262418[SOGoContactGCSEntry]:08d5aafd-6a82-4344-b60f-97a0fae04783.vcf> write failed: <MySQL4Exception: 0x7f77b8e976a8> NAME:ExecutionFailed REASON:Got a packet bigger than 'max_allowed_packet' bytes
10.12.18.74 - - [18/Dec/2014:14:43:47 GMT] "PUT /SOGo/dav/info/Contacts/25EC-50ACE300-15-33512880/08d5aafd-6a82-4344-b60f-97a0fae04783.vcf HTTP/1.1" 500 219/1656269 3.392 - - 7M
Dec 18 14:43:47 sogod [6531]: <0x0x7f77b83e91c8[GCSFolder]> ERROR(-[GCSFolder writeContent:fromComponent:container:toName:baseVersion:]): cannot update content : <MySQL4Exception: 0x7f77b86ae0e8> NAME:ExecutionFailed REASON:Got a packet bigger than 'max_allowed_packet' bytes
Dec 18 14:43:47 sogod [6531]: [ERROR] <0xB83AFC88[SOGoContactGCSEntry]:439c30e8-4851-4058-b35d-de3f46716c3f.vcf> write failed: <MySQL4Exception: 0x7f77b86ae0e8> NAME:ExecutionFailed REASON:Got a packet bigger than 'max_allowed_packet' bytes
10.12.18.74 - - [18/Dec/2014:14:43:47 GMT] "PUT /SOGo/dav/info/Contacts/25EC-50ACE300-15-33512880/439c30e8-4851-4058-b35d-de3f46716c3f.vcf HTTP/1.1" 500 219/1656444 3.357 - - 4K
Dec 18 14:43:47 sogod [6527]: <0x0x7f77b81df778[GCSFolder]> ERROR(-[GCSFolder writeContent:fromComponent:container:toName:baseVersion:]): cannot insert content : <MySQL4Exception: 0x7f77b9fb87e8> NAME:ExecutionFailed REASON:Got a packet bigger than 'max_allowed_packet' bytes
Dec 18 14:43:47 sogod [6527]: [ERROR] <0xB99908D8[SOGoContactGCSEntry]:C58A0F94-21F0-0001-4CC3-3F301B801775.vcf> write failed: <MySQL4Exception: 0x7f77b9fb87e8> NAME:ExecutionFailed REASON:Got a packet bigger than 'max_allowed_packet' bytes
10.12.18.74 - - [18/Dec/2014:14:43:47 GMT] "PUT /SOGo/dav/info/Contacts/25EC-50ACE300-15-33512880/C58A0F94-21F0-0001-4CC3-3F301B801775.vcf HTTP/1.1" 500 219/1656337 3.421 - - -3440K
2014-12-18 14:43:47.901 sogod[6527] File NSKeyValueCoding.m: 913. In -[NSObject(KeyValueCoding) valuesForKeys:] This method is deprecated, use -dictionaryWithValuesForKeys:
10.12.18.74 - - [18/Dec/2014:14:43:47 GMT] "PROPFIND /SOGo/dav/info/Contacts/25EC-50ACE300-15-33512880/ HTTP/1.1" 207 328/133 0.041 - - 72K

after which the only solution to solve the problem is to delete the contact and re-create it from scratch
simply removing photo raises this error

10.12.18.74 - - [18/Dec/2014:14:50:54 GMT] "PROPFIND /SOGo/dav/info/Contacts/25EC-50ACE300-15-33512880/ HTTP/1.1" 207 438/175 0.025 1046 58% 0
Dec 18 14:50:54 sogod [6516]: <0x0x7f77b813c758[GCSFolder]> ERROR(-[GCSFolder writeContent:fromComponent:container:toName:baseVersion:]): cannot insert content : <MySQL4Exception: 0x7f77b811a0f8> NAME:ExecutionFailed REASON:Duplicate entry 'C58A0F94-21F0-0001-4CC3-3F301B801775.vcf' for key 'PRIMARY'
Dec 18 14:50:54 sogod [6516]: [ERROR] <0xB8481898[SOGoContactGCSEntry]:C58A0F94-21F0-0001-4CC3-3F301B801775.vcf> write failed: <MySQL4Exception: 0x7f77b811a0f8> NAME:ExecutionFailed REASON:Duplicate entry 'C58A0F94-21F0-0001-4CC3-3F301B801775.vcf' for key 'PRIMARY'
10.12.18.74 - - [18/Dec/2014:14:50:54 GMT] "PUT /SOGo/dav/info/Contacts/25EC-50ACE300-15-33512880/C58A0F94-21F0-0001-4CC3-3F301B801775.vcf HTTP/1.1" 500 244/165940 0.147 - - 0
10.12.18.74 - - [18/Dec/2014:14:50:54 GMT] "PROPFIND /SOGo/dav/info/Contacts/25EC-50ACE300-15-33512880/ HTTP/1.1" 207 328/133 0.023 - - 0

TagsNo tags attached.

Activities

ludovic

ludovic

2014-12-18 14:11

administrator   ~0007880

Configure your MySQL servert correctly. SOGo gives you a hint:

NAME:ExecutionFailed REASON:Got a packet bigger than 'max_allowed_packet' bytes

alessandro.bono

alessandro.bono

2014-12-18 14:46

reporter   ~0007882

Yes I can define a bigger max_allowed_packet but it's always possibile to insert a bigger photo than my max_allowed_packet
imho sogo should define a configurable limit and check this before try to insert to mysql
sogo should also better manage the problem and avoid duplicate key

alessandro.bono

alessandro.bono

2014-12-18 14:58

reporter   ~0007883

I checked and there is the same problem with mac os x 10.10 so it's reproducible

ludovic

ludovic

2014-12-18 14:59

administrator   ~0007884

The DAV client is irrelevant here.

Issue History

Date Modified Username Field Change
2014-12-18 14:07 alessandro.bono New Issue
2014-12-18 14:11 ludovic Note Added: 0007880
2014-12-18 14:11 ludovic Status new => closed
2014-12-18 14:11 ludovic Assigned To => ludovic
2014-12-18 14:11 ludovic Resolution open => no change required
2014-12-18 14:46 alessandro.bono Note Added: 0007882
2014-12-18 14:46 alessandro.bono Status closed => feedback
2014-12-18 14:46 alessandro.bono Resolution no change required => reopened
2014-12-18 14:49 ludovic Severity major => feature
2014-12-18 14:58 alessandro.bono Note Added: 0007883
2014-12-18 14:58 alessandro.bono Status feedback => assigned
2014-12-18 14:59 ludovic Note Added: 0007884
2016-04-21 20:05 ludovic Status assigned => closed
2016-04-21 20:05 ludovic Resolution reopened => no change required