timeout Archives - Magenaut

Getting “Lock wait timeout exceeded; try restarting transaction” even though I’m not using a transaction

November 23, 2022 by Magenaut

I’m running the following MySQL UPDATE statement:

MySQL server has gone away – in exactly 60 seconds

November 23, 2022 by Magenaut

I recently discovered that a sql query that was running fine earlier is now timing out after 60 seconds and throwing an error. The query is slow but runs as part of a nightly job so that’s not a problem in itself (so please don’t suggest I optimize it).

Terminating idle mysql connections

November 22, 2022 by Magenaut

I see a lot of connections are open and remain idle for a long time, say 5 minutes.

How to Prevent Connection Timeouts for Large MySQL Imports

November 22, 2022 by Magenaut

During development, how our local WAMP servers get up-to-date data from the test server is that a dump of the database is made and we upload that dump using the source command to load the .sql file.

mysql service fails to start/hangs up – timeout (Ubuntu, MariaDB)

November 21, 2022 by Magenaut

I set up my first Ubuntu Server with Ubuntu 16.04, nginx, php7.0, MariaDB, nextcloud and external DynDNS using this tutorial here: Install Nextcloud 9 on Ubuntu 16.04

MySQL rollback on transaction with lost/disconnected connection

November 21, 2022 by Magenaut

I need to make MySQL server to rollback transaction immediately after its client disconnected, because each client works concurrently. The problem can be reproduced like these (using an innodb table type)

MySQL Connection Timeout Issue – Grails Application on Tomcat using Hibernate and ORM

November 19, 2022 by Magenaut

I have a small grails application running on Tomcat in Ubuntu on a VPS. I use MySql as my datastore and everything works fine unless I leave the application for more than half a day (8 hours?). I did some searching and apparently this is the default wait_timeout in mysql.cnf so after 8 hours the connection will die but Tomcat won’t know so when the next user tries to view the site they will see the connection failure error. Refreshing the page will fix this but I want to get rid of the error altogether. For my version of MySql (5.0.75) I have only my.cnf and it doesn’t contain such a parameter, In any case changing this parameter doesn’t solve the problem.