Title: WordPress Database error
Last modified: May 21, 2018

---

# WordPress Database error

 *  [eotwallet](https://wordpress.org/support/users/eotwallet/)
 * (@eotwallet)
 * [8 years ago](https://wordpress.org/support/topic/wordpress-database-error-125/)
 * Hi our site has grown very fast to 10000 users and we are consistently getting
   WordPress database errors.
 * action_wallets_transaction Transaction could not be inserted! Array\n(\n [blog_id]
   => 1\n [category] => deposit\n
 * It seems that there are too many transactions and that the plugin can’t keep 
   up to write to the database. I have played with different settings on the cron
   job, but nothing seems to help.
 * Any advice or ideas?
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fwordpress-database-error-125%2Fpage%2F2%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

Viewing 5 replies - 16 through 20 (of 20 total)

[←](https://wordpress.org/support/topic/wordpress-database-error-125/?output_format=md)
[1](https://wordpress.org/support/topic/wordpress-database-error-125/?output_format=md)
2

 *  Plugin Author [dashed-slug.net](https://wordpress.org/support/users/dashedslug/)
 * (@dashedslug)
 * [8 years ago](https://wordpress.org/support/topic/wordpress-database-error-125/page/2/#post-10339171)
 * Thanks for sending me the complete stack trace.
 * This error is expected in normal operation. For robustness the plugin rediscovers
   some transactions that have already been discovered. It then attempts to insert
   them into the database, but if they already exist it fails and moves on.
 * Are you observing any issues such as transactions failing? If not, then this 
   error should not be a problem.
 * These error messages can quickly fill up your logs. There are two possible solutions
   to this:
 * 1. Disable logging with `define( 'WP_DEBUG_LOG', true );` in your `wp-config.
   php`.
 * 2. Install logrotate on your `wp-content/debug.log` to minimize the amount of
   disk space that logs take.
 * Do let me know if you observe any problems in plugin operation. Thanks.
 *  Thread Starter [eotwallet](https://wordpress.org/support/users/eotwallet/)
 * (@eotwallet)
 * [8 years ago](https://wordpress.org/support/topic/wordpress-database-error-125/page/2/#post-10340630)
 * Hi,
 * Yes, we are experiencing issues where the website is consistently giving Database
   Errors – Users can not access the site.
 * Browser message: Error establishing a database connection
 * It is nearly impossible to see if there are failing transactions, we have over
   315k transactions and there is no way to search the transaction list.
 *  Thread Starter [eotwallet](https://wordpress.org/support/users/eotwallet/)
 * (@eotwallet)
 * [8 years ago](https://wordpress.org/support/topic/wordpress-database-error-125/page/2/#post-10341184)
 * Ok. I found an issue with the max number of connections to the my SQL database.
   I have increase the number for max connections, so hopefully this solves it. 
   It would still be nice to be able to search through the transaction list.
 *  Thread Starter [eotwallet](https://wordpress.org/support/users/eotwallet/)
 * (@eotwallet)
 * [8 years ago](https://wordpress.org/support/topic/wordpress-database-error-125/page/2/#post-10341772)
 * Increasing it didn’t help – still getting the error
 *  Plugin Author [dashed-slug.net](https://wordpress.org/support/users/dashedslug/)
 * (@dashedslug)
 * [8 years ago](https://wordpress.org/support/topic/wordpress-database-error-125/page/2/#post-10344203)
 * OK thanks for keeping me in the loop.
 * Increasing the connections sounds like a good idea even if it did not solve your
   problem on its own. In fact this whole problem sounds like a matter of scaling
   your infrastructure, and is a DBA task. If you can point to some error that the
   plugin produces as you did before, then I can help you with that.
 * If I were you I would very carefully read the server logs, including the mysql
   logs, the webserver logs and the wordpress logs around the time when the site
   start failing.
 * If you need to exclude some lines from your logs you can use `grep -v` and pipes
   to remove some patterns that repeat frequently. Hopefully the real error will
   stand out and you will be able to know what to do to scale the services.
 * For example to remove lines that have `foo` or `bar` in them I would do the following
   on my setup:
 * `tail -f /var/log/nginx/access.log /var/log/mysql/{mysql,error}.log /var/www/
   wordpress/wp-content/debug.log | fgrep -v foo | fgrep -v bar`
 * This would let me observe all the services for any errors in real time but without
   having the screen cluttered with irrelevant messages. Your log paths may vary.
 * Keep in mind that the plugin’s frontend hits the webserver (and therefore the
   database) pretty hard due to the polling feature. One idea would be to disable
   polling. This would cause the frontend to not update automatically. See _Admin_
   → _Wallets_ → _Frontend settings_ → _Live polling settings_. Set the two polling
   intervals to 0 (disable) and also disable loading when page becomes visible. 
   That should reduce the load on your server by a lot.
 * If you do find any other error in the logs, please share it with me.
 * best of luck!
 * kind regards

Viewing 5 replies - 16 through 20 (of 20 total)

[←](https://wordpress.org/support/topic/wordpress-database-error-125/?output_format=md)
[1](https://wordpress.org/support/topic/wordpress-database-error-125/?output_format=md)
2

The topic ‘WordPress Database error’ is closed to new replies.

 * ![](https://ps.w.org/wallets/assets/icon-256x256.png?rev=1570088)
 * [Bitcoin and Altcoin Wallets](https://wordpress.org/plugins/wallets/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wallets/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wallets/)
 * [Active Topics](https://wordpress.org/support/plugin/wallets/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wallets/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wallets/reviews/)

## Tags

 * [db](https://wordpress.org/support/topic-tag/db/)
 * [scaling](https://wordpress.org/support/topic-tag/scaling/)
 * [transactions](https://wordpress.org/support/topic-tag/transactions/)

 * 20 replies
 * 2 participants
 * Last reply from: [dashed-slug.net](https://wordpress.org/support/users/dashedslug/)
 * Last activity: [8 years ago](https://wordpress.org/support/topic/wordpress-database-error-125/page/2/#post-10344203)
 * Status: not resolved