SOGo | BTS

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0004542SOGoGUIpublic2018-09-13 18:122018-09-14 13:33
Reporterardichoke 
Assigned Tofrancis 
PrioritynormalSeveritymajorReproducibilityalways
StatusresolvedResolutionfixed 
Platform[Server] LinuxOSDebianOS Version8 (Jessie)
Product Version4.0.2 
Target VersionFixed in Version 
Summary0004542: Unable to Log In After Upgrade
DescriptionI upgraded my sogo install from the most current v3 nightly in the Debian repositories to the latest v4 nightly build from the Debian repositories. Post-upgrade, I ran the upgrade script to upgrade the database. When trying to log in I get an "Unhandled error response" in the web interface. The sogo logs on the server have the following on each login attempt:

Sep 13 17:54:59 sogod [12585]: [ERROR] <0x0x559203621e60[GCSFolder]> -[GCSFolder _generateInsertStatementForRow:adaptor:tableName
:]: no type found for column name c_folder_id
Sep 13 17:54:59 sogod [12585]: <0x0x559203621e60[GCSFolder]> ERROR(-[GCSFolder writeContent:fromComponent:container:toName:baseVe
rsion:]): cannot insert content : <PostgreSQL72Exception: 0x5592038338b0> NAME:PostgreSQL72FatalError REASON:fatal pgsql error (c
hannel=<0x0x559202eb9000[PostgreSQL72Channel]: connection=<0x0x559202bf69d0[PGConnection]: connection=0x0x559202dd23a0>>): ERROR
: INSERT has more target columns than expressions
LINE 1: ..._component, c_partstates, c_location, c_isopaque, c_enddate)...
                                                             ^

Sep 13 17:54:59 sogod [12585]: [ERROR] <0x5592033e23f0[SOGoAppointmentObject]:340gln5itbaojcjtt65s1jalci@google.com.ics> write fa
iled: <PostgreSQL72Exception: 0x5592038338b0> NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=<0x0x559202eb9000[Pos
tgreSQL72Channel]: connection=<0x0x559202bf69d0[PGConnection]: connection=0x0x559202dd23a0>>): ERROR: INSERT has more target co
lumns than expressions
LINE 1: ..._component, c_partstates, c_location, c_isopaque, c_enddate)...
                                                             ^

Sep 13 17:54:59 sogod [12585]: [ERROR] <0x0x559203621e60[GCSFolder]> -[GCSFolder _generateInsertStatementForRow:adaptor:tableName
:]: no type found for column name c_folder_id
Sep 13 17:54:59 sogod [12585]: <0x0x559203621e60[GCSFolder]> ERROR(-[GCSFolder writeContent:fromComponent:container:toName:baseVe
rsion:]): cannot insert content : <PostgreSQL72Exception: 0x55920398fb60> NAME:PostgreSQL72FatalError REASON:fatal pgsql error (c
hannel=<0x0x559202eb9000[PostgreSQL72Channel]: connection=<0x0x559202bf69d0[PGConnection]: connection=0x0x559202dd23a0>>): ERROR
: INSERT has more target columns than expressions
LINE 1: ..._component, c_partstates, c_location, c_isopaque, c_enddate)...
                                                             ^

Sep 13 17:54:59 sogod [12585]: [ERROR] <0x5592038bc390[SOGoAppointmentObject]:1bjcj7fqu4pg32h4mtmtt4rekb@google.com.ics> write fa
iled: <PostgreSQL72Exception: 0x55920398fb60> NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=<0x0x559202eb9000[Pos
tgreSQL72Channel]: connection=<0x0x559202bf69d0[PGConnection]: connection=0x0x559202dd23a0>>): ERROR: INSERT has more target co
lumns than expressions
LINE 1: ..._component, c_partstates, c_location, c_isopaque, c_enddate)...
                                                             ^

Sep 13 17:54:59 sogod [12585]: [ERROR] <0x0x559203621e60[GCSFolder]> -[GCSFolder _generateInsertStatementForRow:adaptor:tableName
:]: no type found for column name c_folder_id
Sep 13 17:54:59 sogod [12585]: <0x0x559203621e60[GCSFolder]> ERROR(-[GCSFolder writeContent:fromComponent:container:toName:baseVe
rsion:]): cannot insert content : <PostgreSQL72Exception: 0x5592033eb320> NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=<0x0x559202eb9000[PostgreSQL72Channel]: connection=<0x0x559202bf69d0[PGConnection]: connection=0x0x559202dd23a0>>): ERROR: INSERT has more target columns than expressions
LINE 1: ..._component, c_partstates, c_location, c_isopaque, c_enddate)...
                                                             ^

Sep 13 17:54:59 sogod [12585]: [ERROR] <0x55920350bd00[SOGoAppointmentObject]:7kukuqrfedlm2f9tpvqd0e47ijteh3nmrotb19ibt388ho6qsf8rp0dspaob3t2hg19g.ics> write failed: <PostgreSQL72Exception: 0x5592033eb320> NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=<0x0x559202eb9000[PostgreSQL72Channel]: connection=<0x0x559202bf69d0[PGConnection]: connection=0x0x559202dd23a0>>): ERROR: INSERT has more target columns than expressions
LINE 1: ..._component, c_partstates, c_location, c_isopaque, c_enddate)...
                                                             ^

Sep 13 17:54:59 sogod [12585]: [ERROR] <0x0x559203621e60[GCSFolder]> -[GCSFolder _generateInsertStatementForRow:adaptor:tableName:]: no type found for column name c_folder_id
Sep 13 17:54:59 sogod [12585]: <0x0x559203621e60[GCSFolder]> ERROR(-[GCSFolder writeContent:fromComponent:container:toName:baseVersion:]): cannot insert content : <PostgreSQL72Exception: 0x5592033bdb90> NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=<0x0x559202eb9000[PostgreSQL72Channel]: connection=<0x0x559202bf69d0[PGConnection]: connection=0x0x559202dd23a0>>): ERROR: INSERT has more target columns than expressions
LINE 1: ..._component, c_partstates, c_location, c_isopaque, c_enddate)...
                                                             ^

Sep 13 17:54:59 sogod [12585]: [ERROR] <0x55920396f0c0[SOGoAppointmentObject]:7kukuqrfedlm2f9tdllbfg58f2eb5os27ksa50eiui1sgnidr44411am8s0diovlo2kg.ics> write failed: <PostgreSQL72Exception: 0x5592033bdb90> NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=<0x0x559202eb9000[PostgreSQL72Channel]: connection=<0x0x559202bf69d0[PGConnection]: connection=0x0x559202dd23a0>>): ERROR: INSERT has more target columns than expressions
LINE 1: ..._component, c_partstates, c_location, c_isopaque, c_enddate)...
                                                             ^

Sep 13 17:54:59 sogod [12585]: [ERROR] <0x0x559203621e60[GCSFolder]> -[GCSFolder _generateInsertStatementForRow:adaptor:tableName:]: no type found for column name c_folder_id
Sep 13 17:54:59 sogod [12585]: <0x0x559203621e60[GCSFolder]> ERROR(-[GCSFolder writeContent:fromComponent:container:toName:baseVersion:]): cannot insert content : <PostgreSQL72Exception: 0x559203c695b0> NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=<0x0x559202eb9000[PostgreSQL72Channel]: connection=<0x0x559202bf69d0[PGConnection]: connection=0x0x559202dd23a0>>): ERROR: INSERT has more target columns than expressions
LINE 1: ..._component, c_partstates, c_location, c_isopaque, c_enddate)...
                                                             ^

Sep 13 17:54:59 sogod [12585]: [ERROR] <0x559203c88c90[SOGoAppointmentObject]:7kukuqrfedlm2f9tu8f8tpm80alckn984jn0qkqbbsfipbk39f9p5ebrdpdfd4fbhj80.ics> write failed: <PostgreSQL72Exception: 0x559203c695b0> NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=<0x0x559202eb9000[PostgreSQL72Channel]: connection=<0x0x559202bf69d0[PGConnection]: connection=0x0x559202dd23a0>>): ERROR: INSERT has more target columns than expressions
LINE 1: ..._component, c_partstates, c_location, c_isopaque, c_enddate)...
                                                             ^

Sep 13 17:54:59 sogod [12585]: [ERROR] <0x0x559203621e60[GCSFolder]> -[GCSFolder _generateInsertStatementForRow:adaptor:tableName:]: no type found for column name c_folder_id
Sep 13 17:54:59 sogod [12585]: <0x0x559203621e60[GCSFolder]> ERROR(-[GCSFolder writeContent:fromComponent:container:toName:baseVersion:]): cannot insert content : <PostgreSQL72Exception: 0x55920397aa20> NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=<0x0x559202eb9000[PostgreSQL72Channel]: connection=<0x0x559202bf69d0[PGConnection]: connection=0x0x559202dd23a0>>): ERROR: INSERT has more target columns than expressions
LINE 1: ..._component, c_partstates, c_location, c_isopaque, c_enddate)...
                                                             ^
Sep 13 17:54:59 sogod [12585]: [ERROR] <0x5592036d8d60[SOGoAppointmentObject]:6k5vqb2433uva292fq37i5g0l4@google.com.ics> write failed: <PostgreSQL72Exception: 0x55920397aa20> NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=<0x0x559202eb9000[PostgreSQL72Channel]: connection=<0x0x559202bf69d0[PGConnection]: connection=0x0x559202dd23a0>>): ERROR: INSERT has more target columns than expressions
LINE 1: ..._component, c_partstates, c_location, c_isopaque, c_enddate)...


This leads me to believe there was a schema change for the sogo_quick_appointment table which was missed in the upgrade script, but I'm unsure of what the missing change is.
Steps To ReproduceUpgrade an existing nightly sogo debian host with data from 3.10 -> 4
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
has duplicate 0004544resolvedfrancis enable to create new contacts list after upgrading from 3.2.10 to 4.0.2 
has duplicate 0004545resolvedfrancis unable to create an event after upgrade 3.2.10 to 4.0.2 
has duplicate 0004543resolvedfrancis Cannot create event with Mysql backend 

-  Notes
(0013025)
ardichoke (reporter)
2018-09-13 18:30

After further digging, I was able to get logins to work by going into the database and removing some remote calendars the account in question was subscribed to. However, Attempting to create calendar events under that account still produces the same error about INSERT having more target columns than expressions.
User avatar (0013026)
ludovic (administrator)
2018-09-13 20:12

Try the upcoming nightly build.
(0013028)
ardichoke (reporter)
2018-09-14 08:44

Upgraded to the latest nightly build this morning, but the issues persists. Attempting to create calendar event fails and results in the following error in the sogo logs:

Sep 14 08:41:15 sogod [2889]: [ERROR] <0x55c9f6e32c80[SOGoAppointmentObject]:B4A-5B9BAC80-1-1C7A5900.ics> write failed: <PostgreSQL72Exception: 0x55c9f6e95eb0> NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=<0x0x55c9f6e77080[PostgreSQL72Channel]: connection=<0x0x55c9f6e77750[PGConnection]: connection=0x0x55c9f6e77960>>): ERROR: INSERT has more target columns than expressions
LINE 1: ..._component, c_partstates, c_location, c_isopaque, c_enddate)...
(0013031)
jisse44 (reporter)
2018-09-14 09:55
edited on: 2018-09-14 09:57

As I said here: https://sogo.nu/bugs/view.php?id=4545#c13030, [^]
problem is not the upgrade.
With August 31 nightly it works well, but since at least September 13 nightly it's broken.

When I put back August 31 nighly libs in /usr/lib/sogo/ it works again

User avatar (0013032)
francis (administrator)
2018-09-14 13:29

https://github.com/inverse-inc/sogo/commit/d05e1fed5de900640a7383f269c9d29e87b3b278 [^]

- Issue History
Date Modified Username Field Change
2018-09-13 18:12 ardichoke New Issue
2018-09-13 18:30 ardichoke Note Added: 0013025
2018-09-13 20:12 ludovic Note Added: 0013026
2018-09-14 08:44 ardichoke Note Added: 0013028
2018-09-14 09:30 francis Relationship added has duplicate 0004544
2018-09-14 09:30 francis Relationship added has duplicate 0004545
2018-09-14 09:55 jisse44 Note Added: 0013031
2018-09-14 09:57 jisse44 Note Edited: 0013031 View Revisions
2018-09-14 13:29 francis Note Added: 0013032
2018-09-14 13:29 francis Status new => resolved
2018-09-14 13:29 francis Resolution open => fixed
2018-09-14 13:29 francis Assigned To => francis
2018-09-14 13:33 francis Relationship added has duplicate 0004543


Copyright © 2000 - 2018 MantisBT Team
Powered by Mantis Bugtracker