1. Home
2. php - Laravel randomly losing mysql connection

338 votes

1 answers

php - Laravel randomly losing mysql connection

Get the solution ↓↓↓

I have a laravel 6 project built upon http://laravel-boilerplate.com/ which I recently deployed on a shared 1&1 server. It's working absolutely fine but randomly loses connection to the mysql database :

SQLSTATE[HY000] [2002] Connection refused (SQL: select * fromusers whereid = 1 andusers.deleted_at is null limit 1)

This never happens locally, the error occurs every now and then on the 1&1 server. (I have many other projects on this server, never had this issue before). What could be wrong here ?

Undefined asked

2021-09-10

Write your answer

---

479

votes

Answer

Solution:

Finally issue resolved itself..very strange..It never occurred the next day and it’s been fine since..maybe related to being hosted on a shared server.

Write your answer

---

Share solution ↓

Additional Information:

Date the issue was resolved:

2021-09-10

Link To Source
Link To Answer People are also looking for solutions of the problem: http failure during parsing for

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.

Ask a Question

---

Similar questions

Find the answer in similar questions on our website.

313 php - CDbConnection failed to open the DB connection Yii

474 php - Use mysql_fetch_array() with foreach() instead of while()

459 Laravel php artisan shows error of JWT

434 PHP + SQL - Using SQL Server 'Create To' scripts to create tables through PHP

243 php - Insert Variable into Laravel CSV file import array

983 php - Mysql to JSON, how to get a nested array?

576 php - Cakephp 2.8.4 ignoring hasMany

348 php - More efficient way to grab MySQL row populated with single value

499 php - Database Error mysqli_init()

766 PHP running out of memory when uploading to s3 bucket - Laravel 5.2

Write quick answer

Do you know the answer to this question? Write a quick response to it. With your help, we will make our community stronger.

About the technologies asked in this question

PHP

PHP (from the English Hypertext Preprocessor - hypertext preprocessor) is a scripting programming language for developing web applications. Supported by most hosting providers, it is one of the most popular tools for creating dynamic websites. The PHP scripting language has gained wide popularity due to its processing speed, simplicity, cross-platform, functionality and distribution of source codes under its own license.
https://www.php.net/

Laravel

Laravel is a free open source PHP framework that came out in 2011. Since then, it has been able to become the framework of choice for web developers. One of the main reasons for this is that Laravel makes it easier, faster, and safer to develop complex web applications than any other framework.
https://laravel.com/

MySQL

DBMS is a database management system. It is designed to change, search, add and delete information in the database. There are many DBMSs designed for similar purposes with different features. One of the most popular is MySQL. It is a software tool designed to work with relational SQL databases. It is easy to learn even for site owners who are not professional programmers or administrators. MySQL DBMS also allows you to export and import data, which is convenient when moving large amounts of information.
https://www.mysql.com/