Database connection issues

Moderator: crythias

Post Reply
fullhouse
OTRS newbie
Posts: 36
Joined: 13 Sep 2018, 11:58
OTRS Version?: 6.0.12

Database connection issues

Post by fullhouse »

Hello,

the syslog of our system is showing errors concerning the mysql connection about every half an hour:

OTRS-otrs.Console.pl-Maint::Ticket::FulltextIndexRebuildWorker-12 Lost connection to MySQL server during query, SQL: '
OTRS-otrs.Console.pl-Maint::Ticket::FulltextIndexRebuildWorker-12 MySQL server has gone away, SQL: '

I tried changing variables like wait_timeout, interactive_timeout, connect_timeout etc. but that didn't help. Any ideas where those errors are coming from?

wurzel
OTRS guru
Posts: 2924
Joined: 08 Jul 2010, 22:25
OTRS Version?: 6.0.x

Re: Database connection issues

Post by wurzel »

Hi,

Lost connection (MySQL server has gone away) is usually MySQL issue. It is too slow, or min package size is wrong or network down.

You have to look into mysql :(

regards
Flo
OTRS 8 SILVER (Prod)
OTRS 8 auf Debian 10 (Test)
    ((OTRS)) Community Edition 6.0.x, LAMP LIVE auf Debian 10

    -- Ich beantworte keine Forums-Fragen PN - No PN please

    I won't answer to unfriendly users any more. A greeting and regards are just polite.

    fullhouse
    OTRS newbie
    Posts: 36
    Joined: 13 Sep 2018, 11:58
    OTRS Version?: 6.0.12

    Re: Database connection issues

    Post by fullhouse »

    Alright, thanks for the reply.
    I was hoping this might be a known issue within otrs because I can't figure out a way to solve it troubleshooting mysql issues.

    root
    Moderator
    Posts: 2163
    Joined: 18 Dec 2007, 12:23
    OTRS Version?: 4/5/6
    Real Name: Roy Kaldung
    Company: Znuny Inc.
    Contact:

    Re: Database connection issues

    Post by root »

    Hi,

    Check kernel messages for kernel OOM killer, MySQL error log, etc.

    - Roy
    OTRS 5/6 CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO

    Do you need professional services for the ((OTRS)) Community Edition? Check out https://www.znuny.com/

    crythias
    Moderator
    Posts: 10121
    Joined: 04 May 2010, 18:38
    OTRS Version?: 5.0.x
    Location: SouthWest Florida, USA
    Contact:

    Re: Database connection issues

    Post by crythias »

    fullhouse wrote:
    27 Mar 2019, 10:04
    I was hoping this might be a known issue within otrs because I can't figure out a way to solve it troubleshooting mysql issues.
    No, it's most probably mysql. OTRS is doing something that exceeds MySQL parameters.
    wurzel wrote:
    26 Mar 2019, 19:21
    min package size is wrong
    OTRS 5.0.x (private/testing/public) on Linux with MySQL database. Also on github.
    Please edit your signature to include your OTRS version, Operating System, and database type.
    Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
    Need help? Before you ask

    Post Reply