General discussion on installation and configuration of SOGo

Text archives Help


Re: [SOGo] SQL errors in sogo.log - PQexec() failed


Chronological Thread 
  • From: Konrad Mauz < >
  • To:
  • Subject: Re: [SOGo] SQL errors in sogo.log - PQexec() failed
  • Date: Fri, 27 Nov 2015 07:53:02 +0100

Am 25.11.2015 13:01, schrieb Konrad Mauz:
Am 25.11.2015 09:33, schrieb Konrad Mauz:
Hi all,

randomly I have psql errors in my sogo.log like:

[ERROR] <0x0x7fa77f612bb8[GCSFolder]> -[GCSFolder
fetchAclWithSpecification:]: cannot execute acl-fetch SQL 'SELECT c_uid,
c_object, c_role FROM sogouser10015ddd297f_acl WHERE (c_object =
'/user1/Calendar/249-55EEE080-17-3238B500') AND ((c_uid = '<default>')
OR (c_uid LIKE '@%'))': <PostgreSQL72Exception: 0x7fa77f64fa88>
NAME:ExecutionFailed REASON:the PQexec() failed


or

Nov 25 06:26:32 sogod [7903]: [ERROR]
<0x0x7fa783392438[SOGoSQLUserProfile]> could not run SQL 'SELECT
c_defaults FROM sogo_user_profile WHERE c_uid = 'user2'':
<PostgreSQL72Exception: 0x7fa77f554a48> NAME:PostgreSQL72FatalError
REASON:fatal pgsql error
(channel=<0x0x7fa77f4f00d8[PostgreSQL72Channel]:
connection=<0x0x7fa77f715768[PGConnection]:
connection=0x0x7fa77f676890>>): SSL error: invalid mime type
2015-11-25 06:26:33.026 sogod[7903] -[PostgreSQL72Context
primaryBeginTransaction]: could not begin transaction:
<PostgreSQL72Exception: 0x7fa7833a9188> NAME:ExecutionFailed REASON:the
PQexec() failed


with random users at random times. If I try the select in psql directly,
everything is ok.

I have a sogo server ( version 2.3.2 ) on ubuntu 14.04 and a postgres
database ( version 9.3 ) on another ubuntu 14.04 server.

On same days I have 300 errors like this in the logs, on the other day I
have 2000 errors in the log.

Is this something to worry about?

Hi,

I answer to this by my self. It is to worry about. In some cases the
failed "acl-fetch" leads to unsubscription of subscribed calendars or
addressbooks.

Anyone else with this configuration and these errors?

OK, I have disabled the ssl/tls support on the postgresql database server. The PostgreSQL Exception disappeared completely.

Regards,

Konrad

--
Hochschule Konstanz - Rechenzentrum
Konrad Mauz

Tel: +497531206-472, Fax: -153
http://www.htwg-konstanz.de/rz.html

Attachment: smime.p7s
Description: S/MIME Cryptographic Signature




Archive powered by MHonArc 2.6.18.

Top of page