[Solved] SQL Failed: PROCEDURE PrepareGetProps already exists

[con356]

Hi everybody!

First off all i want to say: This is a nice forum with nice people in. Great to be here!

I’ve played arround with kopano (and zarafa) for a while, but now i have no idea with this problem:
2 weeks ago i installed kopano 8.5.81 from scratch in a fresh installed Debian 9. Everything went fine and the server was up an running for a while. Today i rebooted the Server, just without stopping kopano-server.service or mariadb.service in front of it. Systemd waited 60 seconds for kopano-server.service to stop and give no error.

Now kopano-server is not going to start anymore… :-|
Here is what i find:

systemctl status kopano-server

kopano-server.service - Kopano Core Storage Server
   Loaded: loaded (/lib/systemd/system/kopano-server.service; enabled; vendor preset: enabled)
   Active: failed (Result: exit-code) since Tue 2018-02-20 14:01:31 CET; 28min ago
     Docs: man:kopano-server(8)
           man:kopano-server.cfg(5)
           man:kopano-admin(8)
  Process: 1078 ExecStart=/usr/sbin/kopano-server -F (code=exited, status=255)
 Main PID: 1078 (code=exited, status=255)

Feb 20 14:01:31 kopano systemd[1]: Started Kopano Core Storage Server.
Feb 20 14:01:31 kopano kopano-server[1078]: An error occurred (80000007). Please check logfile "/var/log/kopano/server.lo
Feb 20 14:01:31 kopano systemd[1]: kopano-server.service: Main process exited, code=exited, status=255/n/a
Feb 20 14:01:31 kopano systemd[1]: kopano-server.service: Unit entered failed state.
Feb 20 14:01:31 kopano systemd[1]: kopano-server.service: Failed with result 'exit-code'.

/var/log/kopano/server.log

Tue Feb 20 14:01:31 2018: [info   ] Audit logging not enabled.
Tue Feb 20 14:01:31 2018: [=======] Starting kopano-server version 8.5.81 (pid 1078)
Tue Feb 20 14:01:31 2018: [info   ] Using epoll events
Tue Feb 20 14:01:31 2018: [notice ] Listening for TCP connections on port 236
Tue Feb 20 14:01:31 2018: [error  ] Coredumps will not be generated: kopano-server requires the fs.suid_dumpable sysctl to contain the value 2, not 0. See kopano-coredump(5) for details.
Tue Feb 20 14:01:31 2018: [notice ] Listening for priority pipe connections on /var/run/kopano/prio.sock
Tue Feb 20 14:01:31 2018: [notice ] Listening for pipe connections on /var/run/kopano/server.sock
Tue Feb 20 14:01:31 2018: [notice ] Connection to database 'kopano' succeeded
Tue Feb 20 14:01:31 2018: [error  ] SQL [00000016] Failed: PROCEDURE PrepareGetProps already exists, Query Size: 1660, Query: "CREATE PROCEDURE PrepareGetProps(IN hid integer)
BEGIN
  SELECT 0, tag, properties.type, val_ulong, val_string, val_binary, val_double, val_longint, val_hi, val_lo, hierarchy.id, names.nameid, names.namestring, names.guid
    FROM properties JOIN hierarchy ON properties.hierarchyid=hierarchy.id LEFT JOIN names ON properties.tag-34049=names.id WHERE hierarchy.parent=hid AND (tag <= 34048 OR names.id IS NOT NULL);
  SELECT count(*), tag, mvproperties.type, 
          group_concat(length(mvproperties.val_ulong),':', mvproperties.val_ulong ORDER BY mvproperties.orderid SEPARATOR ''), 
          group_concat(length(mvproperties.val_string),':', mvproperties.val_string ORDER BY mvproperties.orderid SEPARATOR ''), 
          group_concat(length(mvproperties.val_binary),':', mvproperties.val_binary ORDER BY mvproperties.orderid SEPARATOR ''), 
          group_concat(length(mvproperties.val_double),':', mvproperties.val_double ORDER BY mvproperties.orderid SEPARATOR ''), 
          group_concat(length(mvproperties.val_longint),':', mvproperties.val_longint ORDER BY mvproperties.orderid SEPARATOR ''), 
          group_concat(length(mvproperties.val_hi),':', mvproperties.val_hi ORDER BY mvproperties.orderid SEPARATOR ''), 
          group_concat(length(mvproperties.val_lo),':', mvproperties.val_lo ORDER BY mvproperties.orderid SEPARATOR ''), 
          hierarchy.id, names.nameid, names.namestring, names.guid 
    FROM mvproperties JOIN hierarchy ON mvproperties.hierarchyid=hierarchy.id LEFT JOIN names ON mvproperties.tag-34049=names.id WHERE hierarchy.parent=hid AND (tag <= 34048 OR names.id IS NOT NULL) GROUP BY tag, mvproperties.type; 
END;
"
Tue Feb 20 14:01:31 2018: [error  ] KDatabase::I_Update() query failed: CREATE PROCEDURE PrepareGetProps(IN hid integer)
BEGIN
  SELECT 0, tag, properties.type, val_ulong, val_string, val_binary, val_double, val_longint, val_hi, val_lo, hierarchy.id, names.nameid, names.namestring, names.guid
    FROM properties JOIN hierarchy ON properties.hierarchyid=hierarchy.id LEFT JOIN names ON properties.tag-34049=names.id WHERE hierarchy.parent=hid AND (tag <= 34048 OR names.id IS NOT NULL);
  SELECT count(*), tag, mvproperties.type, 
          group_concat(length(mvproperties.val_ulong),':', mvproperties.val_ulong ORDER BY mvproperties.orderid SEPARATOR ''), 
          group_concat(length(mvproperties.val_string),':', mvproperties.val_string ORDER BY mvproperties.orderid SEPARATOR ''), 
          group_concat(length(mvproperties.val_binary),':', mvproperties.val_binary ORDER BY mvproperties.orderid SEPARATOR ''), 
          group_concat(length(mvproperties.val_double),':', mvproperties.val_double ORDER BY mvproperties.orderid SEPARATOR ''), 
          group_concat(length(mvproperties.val_longint),':', mvproperties.val_longint ORDER BY mvproperties.orderid SEPARATOR ''), 
          group_concat(length(mvproperties.val_hi),':', mvproperties.val_hi ORDER BY mvproperties.orderid SEPARATOR ''), 
          group_concat(length(mvproperties.val_lo),':', mvproperties.val_lo ORDER BY mvproperties.orderid SEPARATOR ''), 
          hierarchy.id, names.nameid, names.namestring, names.guid 
    FROM mvproperties JOIN hierarchy ON mvproperties.hierarchyid=hierarchy.id LEFT JOIN names ON mvproperties.tag-34049=names.id WHERE hierarchy.parent=hid AND (tag <= 34048 OR names.id IS NOT NULL) GROUP BY tag, mvproperties.type; 
END;
: PROCEDURE PrepareGetProps already exists
Tue Feb 20 14:01:31 2018: [error  ] The storage server is unable to create stored procedures, error 1304
Tue Feb 20 14:01:31 2018: [error  ] Can't initialize database settings
Tue Feb 20 14:01:31 2018: [notice ] Waiting for mysql_server_end
Tue Feb 20 14:01:31 2018: [notice ] Waiting for mysql_library_end
Tue Feb 20 14:01:31 2018: [=======] Server shutdown complete.

systemctl status mariadb

mariadb.service - MariaDB database server
   Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
   Active: active (running) since Tue 2018-02-20 12:20:01 CET; 2h 26min ago
  Process: 734 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  Process: 730 ExecStartPost=/etc/mysql/debian-start (code=exited, status=0/SUCCESS)
  Process: 397 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ]   
  Process: 385 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  Process: 373 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
 Main PID: 555 (mysqld)
   Status: "Taking your SQL requests now..."
    Tasks: 28 (limit: 4915)
   CGroup: /system.slice/mariadb.service
           └─555 /usr/sbin/mysqld

Feb 20 12:19:55 kopano systemd[1]: Starting MariaDB database server...
Feb 20 12:19:58 kopano mysqld[555]: 2018-02-20 12:19:58 139777618874944 [Note] /usr/sbin/mysqld (mysqld 10.1.26-MariaDB-0+deb9u1) sta
Feb 20 12:20:01 kopano systemd[1]: Started MariaDB database server.

mysqlcheck -u root -p --check --databases kopano

kopano.abchanges                                   OK
kopano.acl                                         OK
kopano.changes                                     OK
kopano.deferredupdate                              OK
kopano.hierarchy                                   OK
kopano.indexedproperties                           OK
kopano.lob                                         OK
kopano.mvproperties                                OK
kopano.names                                       OK
kopano.object                                      OK
kopano.objectmvproperty                            OK
kopano.objectproperty                              OK
kopano.objectrelation                              OK
kopano.outgoingqueue                               OK
kopano.properties                                  OK
kopano.receivefolder                               OK
kopano.searchresults                               OK
kopano.settings                                    OK
kopano.singleinstances                             OK
kopano.stores                                      OK
kopano.syncedmessages                              OK
kopano.syncs                                       OK
kopano.tproperties                                 OK
kopano.users                                       OK
kopano.versions                                    OK

/etc/kopano/server.cfg

##############################################################
# SERVER SETTINGS

# Space-separated list of address:port specifiers for where the server should
# listen for unencrypted connections.
#
#    "*:236" — port 236, all protocols
#    "[::]:236" — port 236 on IPv6 only
#    "[2a01:db1::1]:236" — port 236 on specific address only
#    To disable unencrypted connections, set to an empty value.
#
server_listen = *:236

# Space-separated list of paths for where to listen for AF_LOCAL
# connections.
# To disable, set to an empty value.
#
#server_pipe_name = /var/run/kopano/server.sock

# Space-separated list of paths for where to listen for AF_LOCAL
# connections to handle with raised priority.
# To disable, set to an empty value.
#
#server_pipe_priority = /var/run/kopano/prio.sock

# Name for identifying the server in a multi-server environment
server_name = Kopano

# Override the hostname of this server, used by Kerberos SSO if enabled
server_hostname =

# Database engine (mysql)
database_engine         = mysql

# Allow connections from normal users through the Unix socket
allow_local_users       = yes

# local admin users who can connect to any store (use this for the kopano-dagent)
# field is SPACE separated
# eg: local_admin_users = root vmail
local_admin_users       = root kopano

# The user has full rights on a folder by default, uncomment the following line to disable this. 
# owner_auto_full_access = false 
owner_auto_full_access = true

# e-mail address of the Kopano System user
system_email_address    = postmaster@127.0.0.1

# drop privileges and run the process as this user
#run_as_user            = kopano

# drop privileges and run the process as this group
#run_as_group           = kopano

# create a pid file for stopping the service via the init.d scripts
#pid_file               = /var/run/kopano/server.pid

# run server in this path (when not using the -F switch)
#running_path = /var/lib/kopano

# Use given allocator library. Values like libtcmalloc.so.4,
# libtcmalloc_minimal.so.4 and libjemalloc.so.2 would work.
#allocator_library = default

# create memory coredumps upon crash [no, systemdefault, yes]
#coredump_enabled = systemdefault

# session timeout for clients. Values lower than 300 will be upped to 300
# automatically. If the server hears nothing from a client in session_timeout
# seconds, then the session is killed.
session_timeout         = 300

# for temporary files
# consider mounting a `tmpfs' underneath this path (wherever you
# point it to)
tmp_path = /tmp

##############################################################
# LOG SETTINGS

# Logging method (syslog, file), syslog facility is 'mail'
log_method              = file

# Logfile (for log_method = file, '-' for stderr)
log_file                = /var/log/kopano/server.log

# Loglevel (0(none), 1(crit), 2(err), 3(warn), 4(notice), 5(info), 6(debug))
log_level               = 6

# Log timestamp - prefix each log line with timestamp in 'file' logging mode
log_timestamp           = 1

# Buffer logging in what sized blocks. 0 for line-buffered (syslog-style).
#log_buffer_size = 0

##############################################################
# AUDIT LOG SETTINGS

# Audit logging is by default not enabled
audit_log_enabled       = no

# Audit logging method (syslog, file), syslog facility is 'authpriv'
audit_log_method        = syslog

# Audit logfile (for log_method = file, '-' for stderr)
audit_log_file          = /var/log/kopano/audit.log

# Audit loglevel (0=no logging, 1=full logging)
audit_log_level         = 1

# Audit log timestamp - prefix each log line with timestamp in 'file' logging mode
audit_log_timestamp     = 1

##############################################################
# MYSQL SETTINGS (for database_engine = mysql)

# MySQL hostname to connect to for database access
#mysql_host             = localhost
mysql_host              = 127.0.0.1

# MySQL port to connect with (usually 3306)
mysql_port              = 3306

# The user under which we connect with MySQL
mysql_user              = kopano

# The password for the user (leave empty for no password)
mysql_password          =  <PASSWORD>

# Override the default MySQL socket to access mysql locally
# Works only if the mysql_host value is empty or 'localhost'
mysql_socket            =

# Database to connect to
mysql_database          = kopano

# MySQL engine, per default it is InnoDB, which is the only supported
# database engine. It is NOT advised to use a non-transactional engine
# like MyISAM, Aria, etc.
#mysql_engine = InnoDB

# Where to place attachments. Value can be 'database', 'files' or 's3'
attachment_storage      = files 

# Enable fsync as method to make sure attachments are stored on disk where
# supported and will not be buffered by OS and/or filesystem. Please note
# this setting will lower attachment write performance depending on your
# environment but enhances data safety with disaster recovery.
# Only affects 'files' attachment storage backend.
attachment_files_fsync  = yes

# When attachment_storage is 'files', use this path to store the files
# When attachment_storage is 's3', use this path to set a prefix to all
# attachment data of a certain cluster, for example 'attach'
attachment_path         = /var/lib/kopano/attachments

# Compression level for attachments when attachment_storage is 'files'.
# Set compression level for attachments disabled=0, max=9
attachment_compression  = 6

##############################################################
# S3 STORAGE SETTINGS (for attachment_storage = s3)

# The hostname of the entry point to the S3 cloud where the bucket is located
# If you are using minio or another S3 compatible implementation that
# is using another port, you can specify the port with hostname:port.
#attachment_s3_hostname = s3-eu-west-1.amazonaws.com

# The region where the bucket is located
#attachment_s3_region = eu-west-1

# The protocol that should be used to connect to S3, 'http' or 'https' (preferred)
#attachment_s3_protocol = https

# The URL style of the bucket, "virtualhost" or "path"
#attachment_s3_uristyle = virtualhost

# The access key id of your S3 account
#attachment_s3_accesskeyid =

# The secret access key of your S3 account
#attachment_s3_secretaccesskey =

# The bucket name in which the files will be stored
#attachment_s3_bucketname =

##############################################################
#  SSL SETTINGS

# Space-separated list of address:port specifiers for where to listen for
# TLS-encrypted connections. The same syntax as the "server_listen" directive
# applies.
#server_listen_tls =

# Required Server certificate, contains the certificate and the private key parts
server_ssl_key_file     = /etc/kopano/ssl/server.pem

# Password of Server certificate
server_ssl_key_pass     = replace-with-server-cert-password

# Required Certificate Authority of server
server_ssl_ca_file      = /etc/kopano/ssl/cacert.pem

# Path with CA certificates, e.g. /etc/ssl/certs
server_ssl_ca_path      =

# SSL protocols to use, space-separated list of protocols
# (SSLv3 TLSv1 TLSv1.1 TLSv1.2); prefix with ! to lock out a protocol.
#server_ssl_protocols =

# SSL ciphers to use, set to 'ALL' for backward compatibility
server_ssl_ciphers = ALL:!LOW:!SSLv2:!EXP:!aNULL

# Prefer the server's order of SSL ciphers over client's
server_ssl_prefer_server_ciphers = no

# Path of SSL Public keys of clients
sslkeys_path            = /etc/kopano/sslkeys

##############################################################
# THREAD SETTINGS

# Number of server threads
# default: 8
threads                         =       8

# Watchdog frequency. The number of watchdog checks per second.
# default: 1
watchdog_frequency      =       1

# Watchdog max age. The maximum age in ms of a task before a
# new thread is started.
# default: 500
watchdog_max_age        =       500

# SOAP recv timeout value (time between requests)
# default: 5
server_recv_timeout     =       5

# SOAP read timeout value (time during requests)
# default: 60
server_read_timeout     =       60

# SOAP send timeout value
# default: 60
server_send_timeout     =       60

##############################################################
#  OTHER SETTINGS

# Softdelete clean cycle (in days) 0=never running
softdelete_lifetime     = 30

# Sync lifetime, removes all changes remembered for a client after x days of inactivity
sync_lifetime           = 90

# Set to 'yes' if you have Kerberos or NTLM correctly configured for single sign-on
enable_sso = no

# Set to 'yes' if you want to show the GAB to your users
enable_gab = yes

# Authentication can be through plugin (default, recommended), pam or kerberos
auth_method = plugin

# If auth_method is set to pam, you should provide the pam service name
pam_service = passwd


#############################################################
# CACHE SETTINGS
#
# To see the live cache usage, use 'kopano-stats --system'.

# Size in bytes of the 'cell' cache (should be set as high as you can afford to set it)
cache_cell_size                         = 256M

# Size in bytes of the 'object' cache
#cache_object_size = 16M

# Size in bytes of the 'indexed object' cache
#cache_indexedobject_size = 32M

# Size in bytes of the userquota details
cache_quota_size                        = 1M

# Lifetime for userquota details
cache_quota_lifetime            = 1

# Size in bytes of the acl cache
cache_acl_size                          = 1M

# Size in bytes of the store id/guid cache
cache_store_size                        = 1M

# Size in bytes of the 'user id' cache (this is allocated twice)
cache_user_size                         = 1M

# Size in bytes of the 'user details' cache
cache_userdetails_size          = 25M

# Lifetime for user details
cache_userdetails_lifetime      = 0

# Size in bytes of the server details (multiserver setups only)
cache_server_size                       = 1M

# Lifetime for server details (multiserver setups only)
cache_server_lifetime   = 30


##############################################################
#  QUOTA SETTINGS

# The default Warning Quota Level. Set to 0 to disable this level.
# The user will receive an email when this level is reached. Value is in Mb. Default value is 0.
quota_warn              = 0

# The default Soft Quota Level. Set to 0 to disable this level.
# The user will still receive mail, but sending new mail is prohibited, until objects are removed from the store.
# VALUE is in Mb. Default value is 0.
quota_soft              = 0

# The default Hard Quota Level. Set to 0 to disable this level.
# The user can not receive and send mail, until objects are removed from the store.
# Value is in Mb. Default value is 0.
quota_hard              = 0

# The default Warning Quota Level for multitenant public stores. Set to 0 to disable this level.
# The tenant administrator will receive an email when this level is reached. Value is in Mb. Default value is 0.
companyquota_warn      = 0


##############################################################
#  USER PLUGIN SETTINGS

# Name of the plugin that handles users
# Required, default = db
# Values: ldap, unix, db
user_plugin             = db

# configuration file of the user plugin, examples can be found in /usr/share/doc/kopano/example-config
user_plugin_config      = /etc/kopano/ldap.cfg

# scripts which create stores for users from an external source
# used for ldap and unix plugins only
createuser_script               =       /etc/kopano/userscripts/createuser
deleteuser_script               =       /etc/kopano/userscripts/deleteuser
creategroup_script              =       /etc/kopano/userscripts/creategroup
deletegroup_script              =       /etc/kopano/userscripts/deletegroup
createcompany_script    =       /etc/kopano/userscripts/createcompany
deletecompany_script    =       /etc/kopano/userscripts/deletecompany

# Set this option to 'yes' to skip the creation and deletion of new users
# The action will be logged, so you can see if your changes to the plugin
# configuration are correct.
user_safe_mode = no

##############################################################
# MISC SETTINGS

# Enable multi-tenancy environment
# When set to true it is possible to create tenants within the
# kopano instance and assign all users and groups to particular
# tenants.
# When set to false, the normal single-tenancy environment is created.
enable_hosted_kopano = false

# Enable multi-server environment
# When set to true it is possible to place users and tenants on
# specific servers.
# When set to false, the normal single-server environment is created.
enable_distributed_kopano = false

# Display format of store name
# Allowed variables:
#  %u Username
#  %f Full name
#  %c Tenant's name
# default: %f
storename_format = %f
# Loginname format (for Multi-tenancy installations)
# When the user does not login through a system-wide unique
# username (like the email address) a unique name is created
# by combining the username and the tenantname.
# With this configuration option you can set how the
# loginname should be built up.
#
# Note: Do not use the = character in the format.
#
# Allowed variables:
#  %u Username
#  %c Teantname 
#
# default: %u
loginname_format = %u

# Everyone is a special internal group, which contains every user and group
# You may want to disable this group from the Global Addressbook by setting
# this option to 'yes'. Administrators will still be able to see the group.
hide_everyone = no

# System is a special internal user, which has super-admin privileges
# You may want to disable this user from the Global Addressbook by setting
# this option to 'yes'. Administrators will still be able to see the user.
hide_system = yes 

# Use Indexing service for faster searching.
# Enabling this option requires the kopano-search service to
# be running.
search_enabled = yes

# Path to the kopano-search service, this option is only required
# if the server is going to make use of the indexing service.
search_socket = file:///var/run/kopano/search.sock

# Time (in seconds) to wait for a connection to the kopano-search service
# before terminating the indexed search request.
search_timeout = 10

# Allow enhanced ICS operations to speedup synchronization with cached profiles.
# default: yes
enable_enhanced_ics = yes

# SQL Procedures allow for some optimized queries when streaming with enhanced ICS.
# This is default disabled because you must set 'thread_stack = 256k' in your
# MySQL server config under the [mysqld] tag and restart your MySQL server.
enable_sql_procedures = no

# Synchronize GAB users on every open of the GAB (otherwise, only on 
# kopano-admin --sync)
sync_gab_realtime = yes

# Disable features for users. This list is space separated.
# Currently valid values: imap pop3 mobile outlook webapp
disabled_features = imap pop3

# Maximum number of deferred records in total
max_deferred_records = 0

# Maximum number of deferred records per folder
max_deferred_records_folder = 20

# Restrict the permissions that admins receive to folder permissions only. Please
# read the server.cfg manpage before enabling this option so you really understand
# the implications
restrict_admin_permissions = no

# The maximum level of attachment recursion; Defines the number of
# attachment-in-attachment in-attachment levels are allowed when saving and
# replicating objects in the database. If you really want a higher level of
# recursion than about 20, you probably have to increase MySQL's stack_size
# to allow replication to work properly.
embedded_attachment_limit = 20

# Header to detect whether a connection has been received through a proxy. The
# value of the header is not inspected. If the header exists then the connection
# is taken to be received via a proxy. An empty value disables proxy detection
# and the value of '*' is used to indicate that all connections are proxied
proxy_header = 

# Enable/disable reminders for shared stores
shared_reminders = yes

I’ve searched the forum and with google: just nothing! I do not know what to do next. Therefore I ask you for your help.

Some aditional info:
OS: Debian 9 - stretch; running in virtualbox
kopano: core-8.5.81.197_0+27-Debian_9.0-amd64
MariaDB: Ver 15.1 Distrib 10.1.26

I hope you find this information useful.

Thanks in advance
Enno

[con356]

OK, this was not everything…
The log shows more Information during shutdown:

Tue Feb 20 10:44:16 2018: [warning] Shutting down
Tue Feb 20 10:44:47 2018: [crit   ] ----------------------------------------------------------------------
Tue Feb 20 10:44:47 2018: [crit   ] Fatal error detected. Please report all following information.
Tue Feb 20 10:44:47 2018: [crit   ] Application kopano-server version: 8.5.81
Tue Feb 20 10:44:47 2018: [crit   ] OS: Linux, release: 4.9.0-5-amd64, version: #1 SMP Debian 4.9.65-3+deb9u2 (2018-01-04), hardware: x86_64
Tue Feb 20 10:44:47 2018: [crit   ] Thread name: NotificationMan
Tue Feb 20 10:44:47 2018: [crit   ] Peak RSS: 169572
Tue Feb 20 10:44:47 2018: [crit   ] Pid 732 caught SIGSEGV (11), traceback:
Tue Feb 20 10:44:47 2018: [crit   ] Backtrace:
Tue Feb 20 10:44:47 2018: [crit   ] #0. /usr/lib/libkcutil.so.0(+0x2933d) [0x7fd19eb1b33d]
Tue Feb 20 10:44:47 2018: [crit   ] #1. /usr/lib/libkcutil.so.0(+0x21fc5) [0x7fd19eb13fc5]
Tue Feb 20 10:44:47 2018: [crit   ] #2. /usr/lib/libkcutil.so.0(_ZN2KC23generic_sigsegv_handlerEPNS_8ECLoggerEPKcS3_iPK9siginfo_tPKv+0x1c1) [0x7fd19eb142a1]
Tue Feb 20 10:44:47 2018: [crit   ] #3. /lib/x86_64-linux-gnu/libpthread.so.0(+0x110c0) [0x7fd199da30c0]
Tue Feb 20 10:44:47 2018: [crit   ] #4. /usr/sbin/kopano-server(+0x3793f) [0x55b3a519793f]
Tue Feb 20 10:44:47 2018: [crit   ] #5. /usr/lib/libkcserver.so.0(+0x7c595) [0x7fd19e361595]
Tue Feb 20 10:44:47 2018: [crit   ] #6. /lib/x86_64-linux-gnu/libpthread.so.0(+0x7494) [0x7fd199d99494]
Tue Feb 20 10:44:47 2018: [crit   ] #7. /lib/x86_64-linux-gnu/libc.so.6(clone+0x3f) [0x7fd19923eaff]
Tue Feb 20 10:44:47 2018: [crit   ] Signal errno: Success, signal code: 1
Tue Feb 20 10:44:47 2018: [crit   ] Sender pid: 456, sender uid: 0, si_status: 0
Tue Feb 20 10:44:47 2018: [crit   ] Signal value: 0, faulting address: 0x1c8
Tue Feb 20 10:44:47 2018: [crit   ] When reporting this traceback, please include Linux distribution name (and version), system architecture and Kopano version.
^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@

And yes, these funny things shows the log at the end.

[con356]

So in the end i found a solution to get around this error:

First make a backup of the database:
(it’s not necessary, but you never know )

mysqldump -p --single-transaction --routines kopano >  <somewhere>/backup/kopano/mysql/kopano.sql

drop the database “kopano”:

mysql -u root -p
   drop database kopano;
quit

If some error is shown like “ERROR 1010 (HY000): Error dropping database (can’t rmdir ‘./kopano’, errno: 39 “Directory not empty”)” you have to delete some files:

rm  /var/lib/mysql/kopano/*

Now stop mariadb and remove ibdata1 and ib_logfiles

systemctl stop mariadb

mv /var/lib/mysql/ib_logfile* <somewhere>/backup/kopano/mysql/

mv /var/lib/mysql/ibdata1 <somewhere>/backup/kopano/mysql/

systemctl start mariadb

Create a new empty database “kopano”:

mysql -u root -p
   create database kopano;
quit

Restore a backup of the database:
(this can take a long time)

mysql -u root -p kopano < <somewhere>/backup/kopano/mysql/kopano.sql

After the import the Kopano server was restarted correctly. Access is now possible again.

I give it a try to use a backup (mysqldump) that i made after the crash. It works also. So in my opinion the error lived in those (log)files of mariadb. Anyway: I’m glad to be back again. :-)

Never the less:
Be always sure to have a valid Backup!!

This sites where useful:
1.: Big Problem, Kopano server could not connect to MariaDB-Server
2.: Backup and restore mysql (innodb)

Excuse me for my funny English!

Regards
Enno