Sending attachments fails

Zoldan

Hello,

when i want to send an E-Mail with attachment i get the following error in server.log. Note that the Query ist not complete. The ') at the end is missing. Before the error i see in the mysql log, that the chunks 0 and 1 are inserted. Why is this chunk failing? Any ideas?

Regards

Mon Jun 18 18:17:27 2018: [error  ] SQL [00000085] Failed: MySQL server has gone away, Query Size: 403471, Query: "INSERT INTO lob (instanceid, chunkid, tag, val_binary) VALUES (139536, 2, 14081, '###binary###
Mon Jun 18 18:17:27 2018: [error  ] KDatabase::I_Update() query failed: INSERT INTO lob (instanceid, chunkid, tag, val_binary) VALUES (139536, 2, 14081, '###binary###
Mon Jun 18 18:17:27 2018: [error  ] ECAttachmentStorage::SaveAttachmentInstance(): DoInsert failed 80000007

I have Kopano Core
WebApp:
3.4.10.1330+755.1
Kopano Core:
8.6.80

fbartels

Hi @Zoldan ,

@zoldan said in Sending attachments fails:

Note that the Query ist not complete. The ') at the end is missing.

yes that is expected, we only log what fits into the log buffer and this might indeed not be the full query.

@zoldan said in Sending attachments fails:

Failed: MySQL server has gone away

You specify the Kopano version, but not your os/mysql/mariadb version. We had a similar error message early with the Debian 9 builds, but this was adjusted in our build dependencies.

Have you performed any adjustments/tuning with you mysql settings? https://kb.kopano.io/display/WIKI/Basic+MySQL+tuning

Last but not least: it seems you are storing you attachments in the database, while this has been the default in a time long ago it is meanwhile recommended to store attachments in the filesystem.

Zoldan

I orginially started with an early Zarafa version. The installtion has been migrated several times. I store the attachments in the database as it was default when i installed zarafa the first time.

I use debian stretch with mariadb 10.1.
I did not do any adjustments.

Is it possible to move attachments from the database to filesystem?

Zoldan

I found the description for the movement.
https://documentation.kopano.io/kopanocore_administrator_manual/configure_kc_components.html#storing-attachments-outside-the-database