Double send transactions!

Hello,

This is not normally possible. The transactions are first marked as done and then this is rolled back only in case there is an error coming from the wallet. See here: https://github.com/dashed-slug/wallets/blob/3.4.1/includes/transactions.php#L449-L503

Please tell me the following:

1. Which adapter are you using? Is it an RPC wallet?

2. Which version of the plugin are you using?

3. Do the two transactions you see have different TXIDs? If so, do you see the first or the second TXID in the plugin’s transactions list?

4. Did you withdraw via the [wallets_withdraw] shortcode or via the cold storage feature?

5. If possible, can you check for any other errors in your server logs at the time the withdrawals were performed? Did your web server or database crash near that time?

Please let me know. Thanks.

1. Yes, using an RPC wallet – was not doing this until the last update of 3.4.1
EOT Wallet – the wallet is responding correctly and the transactions are working correctly directly from the command line.
Also have the bitcoin wallet running.

2. Bitcoin and Altcoin Wallets Version 3.4.1

Bitcoin and Altcoin Wallets: Airdrop extension 1.0.1

Bitcoin and Altcoin Wallets: Full Node Multi Coin Adapter extension 1.0.4

3. Only first TxID logged in the database

4. wallets_withdraw shortcode

5. Server didn’t crash, but are still having database errors from previous post

• This reply was modified 6 years, 5 months ago by eotwallet.
• This reply was modified 6 years, 5 months ago by eotwallet.

[Thu Jun 07 14:18:23.163223 2018] [:error] [pid 14215] [client 207.154.197.212:53068] WordPress database error Duplicate entry ’06a936b86bdf67a25b5a7eb033bf1cb7453ec6ef1138e8ec1916d6d9f6afce09′ for key ‘uq_tx_idx’ for query INSERT INTO wp_wallets_txs (blog_id, category, account, address, extra, txid, symbol, amount, fee, created_time, updated_time, confirmations, status, retries) VALUES (1, ‘deposit’, 10188, ‘EXSyerNTAh14UkZ2Yisjqo4CB29ZKPDwWR’, ”, ’06a936b86bdf67a25b5a7eb033bf1cb7453ec6ef1138e8ec1916d6d9f6afce09′, ‘EOT’, ‘3.0000000000’, ‘0’, ‘2018-06-07T14:14:43+0000’, ‘2018-06-07 14:18:23’, 0, ‘pending’, 255) made by do_action_ref_array, WP_Hook->do_action, WP_Hook->apply_filters, Dashed_Slug_Wallets_Cron->cron, Dashed_Slug_Wallets_Cron->call_cron_on_all_adapters, Dashed_Slug_Wallets_Coin_Adapter_RPC->cron, Dashed_Slug_Wallets_Coin_Adapter_RPC->cron_scrape_listtransactions, do_action(‘wallets_notify_wallet_EOT’), WP_Hook->do_action, WP_Hook->apply_filters, Dashed_Slug_Wallets_Multi_Coin_Adapter->action_wallets_notify_wallet, Dashed_Slug_Wallets_Coin_Adapter_RPC->action_wallets_notify_wallet, do_action(‘wallets_transaction’), WP_Hook->do_action, WP_Hook->apply_filters, Dashed_Slug_Wallets_TXs->action_wallets_transaction, W3TC\\DbCache_Wpdb->insert, W3TC\\DbCache_WpdbInjection_QueryCaching->insert, W3TC\\_CallUnderlying->insert, W3TC\\DbCache_Wpdb->insert, W3TC\\DbCache_WpdbInjection->insert, W3TC\\DbCache_Wpdb->default_insert, W3TC\\DbCache_Wpdb->query, W3TC\\DbCache_WpdbInjection->query, W3TC\\DbCache_Wpdb->default_query, referer: https://eotwallet.com/wp-cron.php?doing_wp_cron=1528381067.4390549659729003906250
[Thu Jun 07 14:18:23.163316 2018] [:error] [pid 14215] [client 207.154.197.212:53068] action_wallets_transaction Transaction could not be inserted! Array\n(\n [blog_id] => 1\n [category] => deposit\n [account] => 10188\n [address] => EXSyerNTAh14UkZ2Yisjqo4CB29ZKPDwWR\n [extra] => \n [txid] => 06a936b86bdf67a25b5a7eb033bf1cb7453ec6ef1138e8ec1916d6d9f6afce09\n [symbol] => EOT\n [amount] => 3.0000000000\n [fee] => 0\n [created_time] => 2018-06-07T14:14:43+0000\n [updated_time] => 2018-06-07 14:18:23\n [confirmations] => 0\n [status] => pending\n [retries] => 255\n)\n, referer: https://eotwallet.com/wp-cron.php?doing_wp_cron=1528381067.4390549659729003906250
[Thu Jun 07 14:18:23.163329 2018] [:error] [pid 14215] [client 207.154.197.212:53068] action_wallets_transaction Last DB error: Duplicate entry ’06a936b86bdf67a25b5a7eb033bf1cb7453ec6ef1138e8ec1916d6d9f6afce09′ for key ‘uq_tx_idx’, referer: https://eotwallet.com/wp-cron.php?doing_wp_cron=1528381067.4390549659729003906250
[Thu Jun 07 14:18:23.420644 2018] [:error] [pid 14215] [client 207.154.197.212:53068] WordPress database error Duplicate entry ’06a936b86bdf67a25b5a7eb033bf1cb7453ec6ef1138e8ec1916d6d9f6afce09′ for key ‘uq_tx_idx’ for query INSERT INTO wp_wallets_txs (blog_id, category, account, address, extra, txid, symbol, amount, fee, created_time, updated_time, confirmations, status, retries) VALUES (1, ‘deposit’, 11718, ‘EWejF4HouWb5aaHNpEEcNwYiSqDFL4575e’, ”, ’06a936b86bdf67a25b5a7eb033bf1cb7453ec6ef1138e8ec1916d6d9f6afce09′, ‘EOT’, ‘4.0000000000’, ‘0’, ‘2018-06-07T14:14:43+0000’, ‘2018-06-07 14:18:23’, 0, ‘pending’, 255) made by do_action_ref_array, WP_Hook->do_action, WP_Hook->apply_filters, Dashed_Slug_Wallets_Cron->cron, Dashed_Slug_Wallets_Cron->call_cron_on_all_adapters, Dashed_Slug_Wallets_Coin_Adapter_RPC->cron, Dashed_Slug_Wallets_Coin_Adapter_RPC->cron_scrape_listtransactions, do_action(‘wallets_notify_wallet_EOT’), WP_Hook->do_action, WP_Hook->apply_filters, Dashed_Slug_Wallets_Multi_Coin_Adapter->action_wallets_notify_wallet, Dashed_Slug_Wallets_Coin_Adapter_RPC->action_wallets_notify_wallet, do_action(‘wallets_transaction’), WP_Hook->do_action, WP_Hook->apply_filters, Dashed_Slug_Wallets_TXs->action_wallets_transaction, W3TC\\DbCache_Wpdb->insert, W3TC\\DbCache_WpdbInjection_QueryCaching->insert, W3TC\\_CallUnderlying->insert, W3TC\\DbCache_Wpdb->insert, W3TC\\DbCache_WpdbInjection->insert, W3TC\\DbCache_Wpdb->default_insert, W3TC\\DbCache_Wpdb->query, W3TC\\DbCache_WpdbInjection->query, W3TC\\DbCache_Wpdb->default_query, referer: https://eotwallet.com/wp-cron.php?doing_wp_cron=1528381067.4390549659729003906250
[Thu Jun 07 14:18:23.420731 2018] [:error] [pid 14215] [client 207.154.197.212:53068] action_wallets_transaction Transaction could not be inserted! Array\n(\n [blog_id] => 1\n [category] => deposit\n [account] => 11718\n [address] => EWejF4HouWb5aaHNpEEcNwYiSqDFL4575e\n [extra] => \n [txid] => 06a936b86bdf67a25b5a7eb033bf1cb7453ec6ef1138e8ec1916d6d9f6afce09\n [symbol] => EOT\n [amount] => 4.0000000000\n [fee] => 0\n [created_time] => 2018-06-07T14:14:43+0000\n [updated_time] => 2018-06-07 14:18:23\n [confirmations] => 0\n [status] => pending\n [retries] => 255\n)\n, referer: https://eotwallet.com/wp-cron.php?doing_wp_cron=1528381067.4390549659729003906250

Thanks for providing this info.

The logs that you report are actually normal, see my earlier post here: https://www.ads-software.com/support/topic/wordpress-database-error-125/page/2/#post-10339171

The problem you report might actually be caused by a bug in the code that occurs only in rare situations, but since you have high traffic you observed this.

There were no changes in 3.4.1 that are related to this. I am still testing and will hopefully release a patch later today if my suspicions are confirmed.

kind regards

OK, turns out that this was caused by a bug that had remain undetected.

Please see https://www.dashed-slug.net/security-update-required-3-4-2/

You will continue to see the SQL warnings that you reported before. The double send error should not occur again.

The new update is not showing up in the WordPress backend yet?

Ok. It is there now. Will test this for a while and let you know.