Problem: "Unknown error 1040"

Moderator: crythias

Locked
charlin88
Znuny newbie
Posts: 5
Joined: 16 Oct 2020, 19:04
Znuny Version: 6.0.28
Real Name: Charles

Problem: "Unknown error 1040"

Post by charlin88 »

Hi,

An "Unknown error 1040" has appeared in the event log and I cannot identify what the problem is.

In the "SystemConfigurationSyncManagerERR.log" the message appears: "[...] otrs.Daemon.pl: DBI connect('database=<DB>;host='<IP>','<user_DB>',...) failed: Unknown error 1040 at /opt/otrs/Kernel/System/DB.pm line 208."
----
"There are invalid deployments in the database that could not be removed!"
----

Could anyone help?
root
Administrator
Posts: 4251
Joined: 18 Dec 2007, 12:23
Znuny Version: Znuny and Znuny LTS
Real Name: Roy Kaldung
Company: Znuny
Contact:

Re: Problem: "Unknown error 1040"

Post by root »

Hi,

Since the lack of more information, I guess 1040 is a MySQL error no and means 'too many connections'. Check your database settings.

- Roy
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO

Use a test system - always.

Do you need professional services? Check out https://www.znuny.com/

Do you want to contribute or want to know where it goes ?
charlin88
Znuny newbie
Posts: 5
Joined: 16 Oct 2020, 19:04
Znuny Version: 6.0.28
Real Name: Charles

Re: Problem: "Unknown error 1040"

Post by charlin88 »

Thanks!

I increased the number of connections in the database.

Is there a log that I can confirm if this is the cause of the error?
zzz
Znuny superhero
Posts: 914
Joined: 15 Dec 2016, 15:13
Znuny Version: All
Real Name: Emin
Company: Efflux GmbH
Contact:

Re: Problem: "Unknown error 1040"

Post by zzz »

Check the error log of your database (/var/log/).
Professional Znuny and OTRS services: efflux.de | efflux.de/en/

Free and premium add-ons: German | English
Locked