SQL [00000114] Failed



  • Hi,

    I keep getting the following error in kopano-server.log:

    kopano-server[13166]: SQL [00000114] Failed: Incorrect string value: ‘\xF0\x9F\x91\x8D\x0D\x0A…’ for column ‘val_string’ at row 31, Query Size: 11361, Query: "REPLACE INTO properties (hierarchyid,tag,type,properties.val_ulong,properties.val_string,properties.val_binary,properties.
    val_double,properties.val_longint,properties.val_hi,properties.val_lo) VALUES(255603,34057,30,null,’“Thu, 31 Jan 2019 11:13:58 +0100” “Re: [opensuse-factory] [PLEASE SPEAK UP] Disabling legacy file systems by default?” ((“H.Merijn Brand” NIL “h.m.brand” “xs4all.nl”)) ((“H.Merijn Brand” NIL “h.m.brand” “xs4all.nl”)) ((“H.Merijn Brand” NIL “h.m.brand” “xs4all.nl”)) ((“Ludwig Nussel” NIL “ludwig.nussel” “suse.de”)) ((NIL NIL “opensuse-factory” “opensuse.org”)) NIL “82bd99ce-8dc1-1565-d257-8576ac72563b@suse.de” “20190131111150.14fd07c0@pc09.procura.nl”’,null,null,null,null,null),(255603,26,30,null,‘IPM.Note’,null,null,null,null,null),(255603,55,30,null,‘Re: [opensuse-factory] [PLEASE SPEAK UP] Disabling legacy file systems by default?’,null,null,null,null,null),(255603,57,64,null,null,null,null,null,30718285,2915792640),(255603,59,258,null,null,‘SMTP:H.M.BRAND@XS4ALL.NL\0’,null,null,null,null),(255603,61,30,null,‘Re: ‘,null,null,null,null,null),(255603,63,258,null,null,’\0\0\0\0<AC>!<A9>P@<D3><EE>H<B3>#031<FB><A7>S0D%#001\0\0\0#006\0\0\0#003\0\0\0lJhG2PraQY+JsljtGr9wjg==\0\0\0\0’,null,null,null,null),(255603,64,30,null,‘Stefan Jakobs’,null,null,null,null,null),(255603,65,258,null,null,’\0\0\0\0<81>+#037<A4><BE><A3>#020#031<9D>n\0<DD>#001#017T#002\0\0#001<80>H\0.\0M\0e\0r\0i\0j\0n\0 \0B\0r\0a\0n\0d\0\0\0S\0M\0T\0P\0\0\0h\0.\0m\0.\0b\0r\0a\0n\0d\0@\0x\0s\04\0a\0l\0l\0.\0n\0l\0\0\0’,null,null,null,null),(255603,66,30,null,‘H.Merijn Brand’,null,null,null,null,null),(255603,81,258,null,null,‘ZARAFA:USER@EXAMPLE.COM\0’,null,null,null,null),(255603,87,11,0,null,null,null,null,null,null),(255603,88,11,0,null,null,null,null,null,null),(255603,89,11,0,null,null,null,null,null,null),(255603,100,30,null,‘SMTP’,null,null,null,null,null),(255603,101,30,null,‘h.m.brand@xs4all.nl’,null,null,null,null,null),(255603,112,30,null,’[opensuse-factory] [PLEASE SPEAK UP] Disabling legacy file systems by default?’,null,null,null,null,null),(255603,117,30,null,‘ZARAFA’,null,null,null,null,null),(255603,118,30,null,‘user’,null,null,null,null,null),(255603,125,30,null,‘Return-Path: <opensuse-factory+bounces-88656-USER@EXAMPLE.COM@opensuse.org>\r\nReceived: from host.example.com ([::ffff:127.0.0.1]:39330)\r\n#011by host.example.com (kopano-dagent) with LMTP;\r\n#011Mon, 04 Feb 2019 01:41:06 +0100 (CET)\r\nReceived: from localhost (localhost.localdomain [127.0.0.1])\r\n#011by host.example.com (Postfix) with ESMTP id 59B995E1AE5\r\n#011for USER@EXAMPLE.COM; Thu, 31 Jan 2019 11:14:28 +0100 (CET)\r\nReceived: from host.example.com ([127.0.0.1])\r\n#011by localhost (host.example.com [127.0.0.1]) (amavisd-new, port 10024)\r\n#011with ESMTP id s8kzaKvfM7CA for USER@EXAMPLE.COM;\r\n#011Thu, 31 Jan 2019 11:14:22 +0100 (CET)\r\nReceived: from hydra.opensuse.org (proxy-nue1.opensuse.org [195.135.221.145])\r\n#011by host.example.com (Postfix) with ESMTP\r\n#011for USER@EXAMPLE.COM; Thu, 31 Jan 2019 11:14:22 +0100 (CET)\r\nReceived: from lists5.opensuse.org (baloo.infra.opensuse.org [192.168.47.38])\r\n#011by hydra.opensuse.org (Postfix) with ESMTP id 796AC24150\r\n#011for USER@EXAMPLE.COM; Thu, 31 Jan 2019 10:14:14 +0000 (UTC)\r\nReceived: from baloo.infra.opensuse.org (localhost [127.0.0.1])\r\n#011by lists5.opensuse.org (Postfix) with ESMTP id 2F5231163D;\r\n#011Thu, 31 Jan 2019 10:14:13 +0000 (UTC)\r\nX-Original-To: opensuse-factory@lists5.opensuse.org\r\nDelivered-To: opensuse-factory@lists5.opensuse.org\r\nReceived: from relay2.suse.de (charybdis-ext.suse.de [195.135.221.2])\r\n#011by lists5.opensuse.org (Postfix) with ESMTP id 5F4F310F42\r\n#011for opensuse-factory@lists5.opensuse.org; Thu, 31 Jan 2019 10:14:12 +0000 (UTC)\r\nReceived: from localhost (localhost [127.0.0.1])\r\n#011by relay2.suse.de (Postfix) with ESMTP id 5ABCB2C1B7\r\n#011for opensuse-factory@lists5.opensuse.org; Thu, 31 Jan 2019 10:14:12 +0000 (UTC)\r\nX-Virus-Scanned: by amavisd-new at localhost\r\nReceived: from relay2.suse.de ([127.0.0.1])\r\n#011by localhost (localhost [127.0.0.1]) (amavisd-new, port 10026)\r\n#011with ESMTP id ZAJIkYbMTcX3 for opensuse-factory@lists5.opensuse.org;\r\n#011Thu, 31 Jan 2019 10:14:10 +0000 (UTC)\r\nReceived: from mx1.suse.de (mx2.suse.de [195.135.220.15])\r\n#011(using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits))\r\n#011(No client certificate requested)\r\n#011by relay2.suse.de (Postfix) with ESMTPS id 82EBC2C1A1\r\n#011for opensuse-factory@lists5.opensuse.org; Thu, 31 Jan 2019 10:14:10 +0000 (UTC)\r\nReceived: from lb1-smtp-cloud8.xs4all.net (lb1-smtp-cloud8.xs4all.net [194.109.24.21])\r\n#011(using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits))\r\n#011(No client certificate requested)\r\n#011by mx1.suse.de (Postfix) with ESMTPS id 6557AAE22\r\n#011for opensuse-factory@opensuse.org; Thu, 31 Jan 2019 10:14:09 +0000 (UTC)\r\nReceived: from pc09.procura.nl ([188.202.26.81])\r\n#011by smtp-cloud8.xs4all.net with ESMTPSA\r\n#011id p9MFgAK6lNR5yp9MGgP7hj; Thu, 31 Jan 2019 11:14:09 +0100\r\nDate: Thu, 31 Jan 2019 11:13:58 +0100\r\nFrom: “H.Merijn Brand” h.m.brand@xs4all.nl\r\nTo: Ludwig Nussel ludwig.nussel@suse.de\r\nCc: opensuse-factory@opensuse.org\r\nSubject: Re: [opensuse-factory] [PLEASE SPEAK UP] Disabling legacy file\r\n systems by default?\r\nMessage-ID: 20190131111150.14fd07c0@pc09.procura.nl\r\nIn-Reply-To: 82bd99ce-8dc1-1565-d257-8576ac72563b@suse.de\r\nReferences: 7171ba52c32bb33a20bb1edfe8dbb39a9f39e7ca.camel@suse.com\r\n#01182bd99ce-8dc1-1565-d257-8576ac72563b@suse.de\r\nX-Mailer: Claws Mail 3.17.3git67 (GTK+ 2.24.31; x86_64-suse-linux-gnu)\r\nFace: iVBORw0KGgoAAAANSUhEUgAAADAAAAAwEAIAAACI8LKTAAAACXBIWXMAAABIAAAASABGyWs+AAAC\r\n JElEQVRo3u2aMY4CMQxFczZ6RItEzRm4DBINDbRUSPRInIRbsNK6+dJfezN4kokn48IaCSjysL8d\r\n e9Knoj2fr9f9/gllqQ6U9/vxWK3EdwdIEGjRIVCu18NhuxUfK46SH81+fzrdbuKPx/P5ctHQdAdI\r\n TKAgpvV6s9ntBEfXEYSGgMQzIHnuFBBjkshCNJ2KtJZ04hHNAugP8bZr3NIHhbcF0AKoK0CoaHXU\r\n LUWBIs1n+jV+Fl8CVqOApEXAwyMO/DSR4XVntoAYDR7eBjQupuYAYTMph8Rj21D4m7MChN02tpqs\r\n NSnb/KqU2oHCXu5xDCgflj/RAgBiKBIXnICzAsSjWBsTz5K4/HeXYvb8yK5lY3VGEwPi2aONKT+5\r\n AlcxrTPOwcTiraGRChgMEKJh0bVVifGVTq6qgBiNVl8QE29EsK6VE+YJAOG2wz5AvsqUS6uqgHCA\r\n n4NGvBYpnJ64Jgg27sCtxtBk1CJIA4S/GhdWKh07QxUB48jWGhZ4jKamRRr/T8/M0AaEyctry6YB\r\n 4dTGj9iWZNs3DahES5kPCJOu0RQbF/fQOBprsB9gaO9JtPDzII9U5ySXX7AnuIt91y54AAW7rPpT\r\n LCe5gt3F+CLqr2UarGB3MXvMylWGq4+9RCx3TW1oJq1t3HPQlFs6N1fFNEB4s8dn7Ne7ACSm7TPQ\r\n I5quAWmw6qBpulHM33B0Csge4Nd8JTTYG2b1XyRe3lH8x34ABJ6aePuQ2N4AAAAASUVORK5CYII=\r\nPrecedence: bulk\r\nMailing-List: contact opensuse-factory+help@opensuse.org; run by mlmmj\r\nX-Mailinglist: opensuse-factory\r\nList-Post: mailto:opensuse-factory@opensuse.org\r\nList-Help: mailto:opensuse-factory+help@opensuse.org\r\nList-Subscribe: mailto:opensuse-factory+subscribe@opensuse.org\r\nList-Unsubscribe: mailto:opensuse-factory+unsubscribe@opensuse.org\r\nList-Owner: mailto:opensuse-factory+owner@opensuse.org\r\nList-Archive: http://lists.opensuse.org/opensuse-factory/\r\nX-MIME-Notice: attachments may have been removed from this message\r\nMIME-Version: 1.0\r\nContent-Type: multipart/signed; micalg=pgp-sha1;\r\n boundary=“Sig_/.o/4rUtPSQ=wFK_5fFb9DQc”; protocol=“application/pgp-signature”\r\nX-CMAE-Envelope: MS4wfERA5soP07xsA7SAoX/+C2S5EvEoRB5su0qs3gtnGC7nCNwaBxwXRCxZFrACQ1W6URfsISa2c/fgAVeLFcF0RClPIRRuta0HxUFe7I3HJ09vir1mjtDA\r\n 9gXI4xzgc9Y6m3wg0PfdDD1mPw6XJaNlF3jqIa+prR0v7YprocjB/Ek26v2XTHNdER4075yrS7zGVUsuGNd6aZ5/P0gSEnoMA1qARrujTAPW7Pm/LUdHEoFU’,null,null,null,null,null),(255603,3097,258,null,null,’\0\0\0\0<81>+#037<A4><BE><A3>#020#031<9D>n\0<DD>#001#017T#002\0\0#001<80>H\0.\0M\0e\0r\0i\0j\0n\0 \0B\0r\0a\0n\0d\0\0\0S\0M\0T\0P\0\0\0h\0.\0m\0.\0b\0r\0a\0n\0d\0@\0x\0s\04\0a\0l\0l\0.

    This is probably related:
    kopano-dagent[16785]: Rule "opensuse-factory@opensuse.org": Unable to copy/move message: disk error (80040116)
    kopano-dagent[16785]: Unable to commit message: disk error (80040116)
    kopano-dagent[16785]: Unable to deliver message to “user”: disk error (80040116)
    kopano-dagent[16785]: Unable to deliver all messages for server “default:”

    You might recognize this is a message from the opensuse mailing list, so nothing special. But one from 100 messages causes this error.

    I’m running Kopano Version 8.7.80.355.acad8ae1e

    Thanks and best regards
    Stefan


  • Kopano

    Hi @stef-jakobs ,

    can you provide an eml file of an email causing this?

    The version you are running is already a bit older. Can you still reproduce the issue after an update?



  • Hi fbartels,

    I upgraded to version 8.7.80.587.10057a. After restart of kopano-server it told me to run “kopano-dbadm usmp”. After an other kopano-server restart, the server accepted the messages. It was either the upgrade to a newer version or the dbadm fix.

    Thanks for your help.

    Regards
    Stefan