Quantcast

MYSQL Problem

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

MYSQL Problem

Alexander Haase | WSP GmbH Aachen

Hello,

 

in our ASSP Installation we have the following problem:

 

After a restart of MYSQL the ASSP doesn`t reconnect the Databases automatically. After the restart of the ASSP, the connection to the MYSQL is up again.

Please Note: the MYSQL Server isn`t installed on the same host like the ASSP.

 

Which switch must be set in the ASSP config to reconnect the Database automatically after loss of the connection? Or is there another solution to solve the problem?

 

In the ASSP we set the database driver name to following phrase: mysql,PORT=3306,mysql_auto_reconnect=1

 

ASSP-Version in use: ASSP version 2.5.5(16366)

MYSQL Version: 14.14 Distrib 5.5.53, for debian-linux-gnu (x86_64) using readline 6.3

 

 

Regards Alexander

 

 

 

Alexander Haase
IT-Services

Tel. +49 241 879703 - 97
Fax.
+49 241 879703 - 20
Email: [hidden email]

WSP GmbH
Anlagenbau für die Thermoprozesstechnik
Thermoprocessing Plants

An der Glashütte 10
52074 Aachen
Deutschland / Germany

Geschäftsführer: Dr.-Ing. Thomas Kramer (Vorsitz), Dipl.-Ing Martin Hansen
Wissenschaftlicher Beirat:
Prof. Dr.-Ing. Carl Kramer (Vorsitzender),
Prof. Dr.-Ing. Reinhard Grundmann,
Dr.-Ing. Thomas Berrenberg
Amtsgericht Aachen HRB 4062

 

 


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Assp-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/assp-user
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: MYSQL Problem

Thomas Eckardt/eck
Within two minutes after MySQL is up again, each worker should reconnect to the DB. Have a look in to the maillog.txt for this point in time.

mysql_auto_reconnect=1 will not help in this case. This parameter is used by the driver, if the connection drops within a query. Or drops within two queries. If the driver reports that the connection is down (mysql_auto_reconnect=1 failed), assp switches to flat files and will try to reconnect every two minutes.

Leaves me the question, who would bring down a production database engine (controlled) without stopping the application server first?

>Or is there another solution to solve the problem?

Use a MySQL cluster.

Thomas





Von:        Alexander Haase | WSP GmbH Aachen <[hidden email]>
An:        "'[hidden email]'" <[hidden email]>
Datum:        16.03.2017 09:56
Betreff:        [Assp-user] MYSQL Problem




Hello,
 
in our ASSP Installation we have the following problem:
 
After a restart of MYSQL the ASSP doesn`t reconnect the Databases automatically. After the restart of the ASSP, the connection to the MYSQL is up again.
Please Note: the MYSQL Server isn`t installed on the same host like the ASSP.
 
Which switch must be set in the ASSP config to reconnect the Database automatically after loss of the connection? Or is there another solution to solve the problem?
 
In the ASSP we set the database driver name to following phrase: mysql,PORT=3306,mysql_auto_reconnect=1
 
ASSP-Version in use: ASSP version 2.5.5(16366)
MYSQL Version: 14.14 Distrib 5.5.53, for debian-linux-gnu (x86_64) using readline 6.3
 
 
Regards Alexander
 
 
 


Alexander Haase
IT-Services

Tel. +49 241 879703 - 97
Fax. +49 241 879703 - 20
Email:
[hidden email]
WSP GmbH
Anlagenbau für die Thermoprozesstechnik
Thermoprocessing Plants

An der Glashütte 10
52074 Aachen
Deutschland / Germany

Geschäftsführer: Dr.-Ing. Thomas Kramer (Vorsitz), Dipl.-Ing Martin Hansen
Wissenschaftlicher Beirat:
Prof. Dr.-Ing. Carl Kramer (Vorsitzender),
Prof. Dr.-Ing. Reinhard Grundmann,
Dr.-Ing. Thomas Berrenberg
Amtsgericht Aachen HRB 4062

 
 ------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org!
http://sdm.link/slashdot_______________________________________________
Assp-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/assp-user




DISCLAIMER:
*******************************************************
This email and any files transmitted with it may be confidential, legally privileged and protected in law and are intended solely for the use of the
individual to whom it is addressed.
This email was multiple times scanned for viruses. There should be no known virus in this email!
*******************************************************


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Assp-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/assp-user
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: MYSQL Problem

pcaceresz
This post has NOT been accepted by the mailing list yet.
In reply to this post by Alexander Haase | WSP GmbH Aachen
Hello,

I can not reconnect mysql without having to modify the perl code of ASSP, and so far it has worked perfectly, if you want I can tell you what modifications to make

regards
Loading...