View Issue Details

IDProjectCategoryView StatusLast Update
0005685SOGoBackend Calendarpublic2023-06-05 07:36
ReporterMIT Assigned Tosebastien  
PrioritynormalSeveritycrashReproducibilityhave not tried
Status resolvedResolutionfixed 
Product Version5.8.0 
Fixed in Version5.9.0 
Summary0005685: Calendar entry from Outlook via CalDav Synchronizer leads to SQL error "integer out of range"
Description

When using Outlook 2021 with CalDav Synchronizer a brithday entry (which is send to the calendar) leads to the following error:

<code>
Jan 25 13:11:15 sogod [121490]: <0x0x55fb19443610[GCSFolder]> ERROR(-[GCSFolder writeContent:fromComponent:container:toName:baseVersion:]): cannot update content : <PostgreSQL72Exception: 0x55fb196f3c80> NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=<0x0x55fb195eb980[PostgreSQL72Channel]: connection=<0x0x55fb1a02c550[PGConnection]: connection=0x0x55fb1a02c730>>): ERROR: integer out of range
</code>

The error comes from the sql statement (data removed):

<code>
update
sogoRemoved_quick
set
[...]
c_startdate = 4202346496,
[...]
where
c_name = 'removed.ics';
</code>

The c_startdate column is of type INT4. I don't know if the error was introduced by updating to SOGo 5.8.0 or an Outlook / CalDav Synchronizer update. The brithday entry has been in Outlook for years, hasn't been changed and looks ok (no "big" dates entered).

TagsNo tags attached.

Relationships

related to 0005770 closedsebastien PG-SQl-Error "integer out of range" in Logfile 

Activities

sebastien

sebastien

2023-01-25 15:41

administrator   ~0016598

No changes on SOGo db in 5.8.0.

Waschbuesch

Waschbuesch

2023-05-08 06:56

reporter   ~0016946

Just to confirm it is not an isolated problem: I get those errors as well.

schmirl

schmirl

2023-05-09 07:36

reporter   ~0016950

Probably related to 0004914

sebastien

sebastien

2023-05-10 07:09

administrator   ~0016951

Hi @MIT can you provide the data structure of the table ?

Sebastien

MIT

MIT

2023-05-10 07:20

reporter   ~0016952

Hi Sebastien, of course:

<code sql>
sogo=# \d sogobco00164c4ae58_quick;
Table "public.sogobco00164c4ae58_quick"
Column | Type | Collation | Nullable | Default
------------------+-------------------------+-----------+----------+---------
c_name | character varying(255) | | not null |
c_uid | character varying(255) | | not null |
c_startdate | integer | | |
c_enddate | integer | | |
c_cycleenddate | integer | | |
c_title | character varying(1000) | | not null |
c_participants | text | | |
c_isallday | integer | | |
c_iscycle | integer | | |
c_cycleinfo | text | | |
c_classification | integer | | not null |
c_isopaque | integer | | not null |
c_status | integer | | not null |
c_priority | integer | | |
c_location | character varying(255) | | |
c_orgmail | character varying(255) | | |
c_partmails | text | | |
c_partstates | text | | |
c_category | character varying(255) | | |
c_sequence | integer | | |
c_component | character varying(10) | | not null |
c_nextalarm | integer | | |
c_description | text | | |
Indexes:
"sogobco00164c4ae58_quick_pkey" PRIMARY KEY, btree (c_name)
</code>

sebastien

sebastien

2023-05-17 09:51

administrator   ~0016963

Commit https://github.com/Alinto/sogo/commit/158a5becc902b1d241575ac5098ceb527a0011ff and https://github.com/Alinto/sogo/commit/32a04998e50cc4adbc72b7dc36de67b8e9e4b0f2?

Will be in nightly build after 5.8.3 release

Seabstien

MIT

MIT

2023-05-18 19:14

reporter   ~0016964

Thanks! I'll test it when its available in a release.

sebastien

sebastien

2023-05-31 06:48

administrator   ~0016987

Hi,

Now available in nightly build

Any feedback is welcome

Sebastien

MIT

MIT

2023-06-01 09:59

reporter   ~0016988

Hi Sebastien,

great, thanks! I've installed sogo=5.8.3.20230531-1 and will report in the next days if this solves the problem.

Kind regards Markus

sebastien

sebastien

2023-06-01 19:15

administrator   ~0016993

Hi Markus, there is still an issue fixed in ticket 0005777. Please test next nightly build

Sebastien

MIT

MIT

2023-06-02 07:29

reporter   ~0016994

Hi Sebastien,

thanks for the hint, installed sogo=5.8.3.20230601-1.

Kind regards Markus

Issue History

Date Modified Username Field Change
2023-01-25 13:18 MIT New Issue
2023-01-25 15:41 sebastien Note Added: 0016598
2023-05-08 06:56 Waschbuesch Note Added: 0016946
2023-05-09 07:36 schmirl Note Added: 0016950
2023-05-10 07:09 sebastien Note Added: 0016951
2023-05-10 07:20 MIT Note Added: 0016952
2023-05-17 09:51 sebastien Note Added: 0016963
2023-05-17 09:51 sebastien Assigned To => sebastien
2023-05-17 09:51 sebastien Status new => feedback
2023-05-17 09:52 sebastien Relationship added related to 0005770
2023-05-18 19:14 MIT Note Added: 0016964
2023-05-18 19:14 MIT Status feedback => assigned
2023-05-31 06:48 sebastien Note Added: 0016987
2023-05-31 06:48 sebastien Status assigned => feedback
2023-06-01 09:59 MIT Note Added: 0016988
2023-06-01 09:59 MIT Status feedback => assigned
2023-06-01 19:15 sebastien Note Added: 0016993
2023-06-01 19:15 sebastien Status assigned => feedback
2023-06-02 07:29 MIT Note Added: 0016994
2023-06-02 07:29 MIT Status feedback => assigned
2023-06-05 07:36 sebastien Status assigned => resolved
2023-06-05 07:36 sebastien Resolution open => fixed
2023-06-05 07:36 sebastien Fixed in Version => 5.9.0