Quantcast

Lasso 8.3.1-1, error communicating with MySQL 5.7.15, OS12

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Lasso 8.3.1-1, error communicating with MySQL 5.7.15, OS12

beaniite
Every day I get a critical error

Message: MySQLDS failed connecting to MySQL. errno=2013 "Lost connection to MySQL server at 'reading initial communication packet', systemerror:0”

Lasso 8.3.1-1 and MySQL 5.7.15 running on  a Mac mini Sierra.

Any idea if this is a lasso problem or a MySQL problem or just  my problem.

Only solution so far is restart the mini.
---------------------------------
Gordon Nord




#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Lasso 8.3.1-1, error communicating with MySQL 5.7.15, OS12

Steffan Cline
Have you checked your my.cnf file to make sure you have sufficient packet sizes and memory allocated?

Thanks,
Steffan Cline
[hidden email]
602-793-0014

> On Nov 11, 2016, at 12:58 PM, Gordon Nord <[hidden email]> wrote:
>
> Every day I get a critical error
>
> Message: MySQLDS failed connecting to MySQL. errno=2013 "Lost connection to MySQL server at 'reading initial communication packet', systemerror:0”
>
> Lasso 8.3.1-1 and MySQL 5.7.15 running on  a Mac mini Sierra.
>
> Any idea if this is a lasso problem or a MySQL problem or just  my problem.
>
> Only solution so far is restart the mini.
> ---------------------------------
> Gordon Nord
>
>
>
>
> #############################################################
>
> This message is sent to you because you are subscribed to
>  the mailing list Lasso [hidden email]
> Official list archives available at http://www.lassotalk.com
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>
>


#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Lasso 8.3.1-1, error communicating with MySQL 5.7.15, OS12

beaniite
There is a mysql_config_editor and a mysql_config file.
I think Oracle has changed MySQL quite a bit.


On Nov 11, 2016, at 3:03 PM, Steffan Cline <[hidden email]> wrote:

> Have you checked your my.cnf file to make sure you have sufficient packet sizes and memory allocated?
>
> Thanks,
> Steffan Cline
> [hidden email]
> 602-793-0014
>
>> On Nov 11, 2016, at 12:58 PM, Gordon Nord <[hidden email]> wrote:
>>
>> Every day I get a critical error
>>
>> Message: MySQLDS failed connecting to MySQL. errno=2013 "Lost connection to MySQL server at 'reading initial communication packet', systemerror:0”
>>
>> Lasso 8.3.1-1 and MySQL 5.7.15 running on  a Mac mini Sierra.
>>
>> Any idea if this is a lasso problem or a MySQL problem or just  my problem.
>>
>> Only solution so far is restart the mini.
>> ---------------------------------
>> Gordon Nord
>>
>>
>>
>>
>> #############################################################
>>
>> This message is sent to you because you are subscribed to
>> the mailing list Lasso [hidden email]
>> Official list archives available at http://www.lassotalk.com
>> To unsubscribe, E-mail to: <[hidden email]>
>> Send administrative queries to  <[hidden email]>
>>
>
>
> #############################################################
>
> This message is sent to you because you are subscribed to
>  the mailing list Lasso [hidden email]
> Official list archives available at http://www.lassotalk.com
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>



---------------------------------
Gordon Nord
Nord Consultants
20933 Killawog Ter.
Ashburn VA 20147-7148
[hidden email]
703-723-2798 Office
703-403-2776 Cell




#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Lasso 8.3.1-1, error communicating with MySQL 5.7.15, OS12

Wade Maxfield
In reply to this post by beaniite
> On 12/11/2016, at 8:58 AM, Gordon Nord <[hidden email]> wrote:
>
> Message: MySQLDS failed connecting to MySQL. errno=2013 "Lost connection to MySQL server at 'reading initial communication packet', systemerror:0”
>
> Lasso 8.3.1-1 and MySQL 5.7.15 running on  a Mac mini Sierra.
>
> Any idea if this is a lasso problem or a MySQL problem or just  my problem.

That’s a mysql problem.

If you try connecting to mysql via another client around the same time (say via navicat) you’ll probably not be able to login at all.  If that’s the case check your open files limits.  Recent changes to mysql have switched innodb to use separate files per table, which increases the number of open files quite drastically if you use innodb at all.

Not my area of expertise, but google has lots of suggestions on how to “fix” it. There are performance and storage space implications to be aware of either way (https://dev.mysql.com/doc/refman/5.6/en/innodb-multiple-tablespaces.html)

 - Wade


#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Lasso 8.3.1-1, error communicating with MySQL 5.7.15, OS12

Johan Solve
I have this problem occasionally on my local MySQL 5.7.11 (luckily it only
affects my local dev so I haven't bothered too much about it). Restarting
mysqld fixes it.

I'll try Wade's suggestion.

On 11 November 2016 at 22:07, Wade Maxfield <[hidden email]>
wrote:

> > On 12/11/2016, at 8:58 AM, Gordon Nord <[hidden email]> wrote:
> >
> > Message: MySQLDS failed connecting to MySQL. errno=2013 "Lost connection
> to MySQL server at 'reading initial communication packet', systemerror:0”
> >
> > Lasso 8.3.1-1 and MySQL 5.7.15 running on  a Mac mini Sierra.
> >
> > Any idea if this is a lasso problem or a MySQL problem or just  my
> problem.
>
> That’s a mysql problem.
>
> If you try connecting to mysql via another client around the same time
> (say via navicat) you’ll probably not be able to login at all.  If that’s
> the case check your open files limits.  Recent changes to mysql have
> switched innodb to use separate files per table, which increases the number
> of open files quite drastically if you use innodb at all.
>
> Not my area of expertise, but google has lots of suggestions on how to
> “fix” it. There are performance and storage space implications to be aware
> of either way (https://dev.mysql.com/doc/refman/5.6/en/innodb-multiple-
> tablespaces.html)
>
>  - Wade
>
>
> #############################################################
>
> This message is sent to you because you are subscribed to
>   the mailing list Lasso [hidden email]
> Official list archives available at http://www.lassotalk.com
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>
>



--
Mvh
Johan Sölve
____________________________________
Montania System AB
Halmstad   Stockholm
http://www.montania.se

Johan Sölve
Mobil +46 709-51 55 70
[hidden email]

Kristinebergsvägen 17, S-302 41 Halmstad, Sweden
Telefon +46 35-136800 |  Fax +46 35-136801

#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Loading...