Forum Replies Created

Viewing 15 replies - 1 through 15 (of 19 total)
  • Thread Starter eotwallet

    (@eotwallet)

    We would be willing to pay for this development. You can e-mail me at [redacted]. Specifically EOT Token that is on the waves platform.

    Thread Starter eotwallet

    (@eotwallet)

    Thanks,

    One problem is that I have 785,535 transactions in history. If I run this command
    listtransactions “*” 100000 | grep txid | cut -d'”‘ -f4 | uniq | xargs -I %s curl -v https://www.eotwallet.com/wallets/api2/notify/EOT/wallet/%s

    The daemon server does not respond. I can at most do 50000.

    Thread Starter eotwallet

    (@eotwallet)

    Hi,

    1. I have this walletnotify in the .conf file as was instructed.
    2. I did run this manually and the transaction is now recovered.

    So, even though I did have this walletnotify in my .conf file it did not happen automatically. The problem is that I don’t know how many other transactions is also missing.

    Regards,

    Thread Starter eotwallet

    (@eotwallet)

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

    Thread Starter eotwallet

    (@eotwallet)

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

    Thread Starter eotwallet

    (@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

    Thread Starter eotwallet

    (@eotwallet)

    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, 9 months ago by eotwallet.
    • This reply was modified 6 years, 9 months ago by eotwallet.
    Thread Starter eotwallet

    (@eotwallet)

    Increasing it didn’t help – still getting the error

    Thread Starter eotwallet

    (@eotwallet)

    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

    (@eotwallet)

    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

    (@eotwallet)

    Hello,

    Even after upgrade to version 3.3.6 I am still facing the same issue:

    Tue May 29 06:58:06.217334 2018] [:error] [pid 6900] [client 207.154.197.212:60858] WordPress database error Duplicate entry ‘b5b669117771cd4a4a6a21c945a22784d4ff7889af37ab2fcb4237a66fde8880’ 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’, 10307, ‘ERShErn3h2iJgwUuJAcLDeDhJGKQoGBeEs’, ”, ‘b5b669117771cd4a4a6a21c945a22784d4ff7889af37ab2fcb4237a66fde8880’, ‘EOT’, ‘3.0000000000’, ‘0’, ‘2018-05-29T06:54:40+0000’, ‘2018-05-29 06:58:06’, 2, ‘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=1527577080.2362229824066162109375

    Thread Starter eotwallet

    (@eotwallet)

    Even with your latest version 3.3.5

    Fri May 25 08:28:46.452073 2018] [:error] [pid 26872] [client 207.154.197.212:46450] WordPress database error BIGINT UNSIGNED value is out of range in ‘(eotwallet_wordpress.wp_wallets_txs.retries – 1)’ for query \n\t\t\t\t\t\tUPDATE\n\t\t\t\t\t\t\twp_wallets_txs\n\t\t\t\t\t\tSET\n\t\t\t\t\t\t\tstatus = ‘pending’,\n\t\t\t\t\t\t\tretries = retries – 1\n\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\tid = 837503\n\t\t\t\t\t\t made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, Dashed_Slug_Wallets_Cron::trigger_cron, do_action(‘wallets_periodic_checks’), WP_Hook->do_action, WP_Hook->apply_filters, Dashed_Slug_Wallets_TXs->cron, Dashed_Slug_Wallets_TXs->execute_pending_withdrawals, W3TC\\DbCache_Wpdb->query, W3TC\\DbCache_WpdbInjection_QueryCaching->query, W3TC\\_CallUnderlying->query, W3TC\\DbCache_Wpdb->query, W3TC\\DbCache_WpdbInjection->query, W3TC\\DbCache_Wpdb->default_query

    Thread Starter eotwallet

    (@eotwallet)

    After running for a while with the new update, got the database error again:

    [Tue May 22 16:57:50.083965 2018] [:error] [pid 2292] [client 207.154.197.212:58282] action_wallets_transaction Last DB error: Duplicate entry ‘7bbd3bc4685e77745fc660f835750f89f21496734da8ff17cb368f21a40c768a’ for key ‘uq_tx_idx’, referer: https://eotwallet.com/wp-cron.php?doing_wp_cron=1527008236.4876289367675781250000
    [Tue May 22 16:57:50.087500 2018] [:error] [pid 2292] [client 207.154.197.212:58282] WordPress database error Duplicate entry ‘7bbd3bc4685e77745fc660f835750f89f21496734da8ff17cb368f21a40c768a’ 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’, 10440, ‘EcZ2NPqkT8Fv4KYorwAp8pPrcX9FRn9YDL’, ”, ‘7bbd3bc4685e77745fc660f835750f89f21496734da8ff17cb368f21a40c768a’, ‘EOT’, ‘6.0000000000’, ‘0’, ‘2018-05-22T16:54:58+0000’, ‘2018-05-22 16:57:50’, 1, ‘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=1527008236.4876289367675781250000
    [Tue May 22 16:57:50.087551 2018] [:error] [pid 2292] [client 207.154.197.212:58282] action_wallets_transaction Transaction could not be inserted! Array\n(\n [blog_id] => 1\n [category] => deposit\n [account] => 10440\n [address] => EcZ2NPqkT8Fv4KYorwAp8pPrcX9FRn9YDL\n [extra] => \n [txid] => 7bbd3bc4685e77745fc660f835750f89f21496734da8ff17cb368f21a40c768a\n [symbol] => EOT\n [amount] => 6.0000000000\n [fee] => 0\n [created_time] => 2018-05-22T16:54:58+0000\n [updated_time] => 2018-05-22 16:57:50\n [confirmations] => 1\n [status] => pending\n [retries] => 255\n)\n, referer: https://eotwallet.com/wp-cron.php?doing_wp_cron=1527008236.4876289367675781250000
    [Tue May 22 16:57:50.087560 2018] [:error] [pid 2292] [client 207.154.197.212:58282] action_wallets_transaction Last DB error: Duplicate entry ‘7bbd3bc4685e77745fc660f835750f89f21496734da8ff17cb368f21a40c768a’ for key ‘uq_tx_idx’, referer: https://eotwallet.com/wp-cron.php?doing_wp_cron=1527008236.4876289367675781250000
    [Tue May 22 16:57:50.089672 2018] [:error] [pid 2292] [client 207.154.197.212:58282] WordPress database error Duplicate entry ‘7bbd3bc4685e77745fc660f835750f89f21496734da8ff17cb368f21a40c768a’ 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’, 9805, ‘EUfr4jUPVKW3khmHnZ9ZYDeCfCVPVvHRJq’, ”, ‘7bbd3bc4685e77745fc660f835750f89f21496734da8ff17cb368f21a40c768a’, ‘EOT’, ‘7.0000000000’, ‘0’, ‘2018-05-22T16:54:58+0000’, ‘2018-05-22 16:57:50’, 1, ‘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=1527008236.4876289367675781250000
    [Tue May 22 16:57:50.089716 2018] [:error] [pid 2292] [client 207.154.197.212:58282] action_wallets_transaction Transaction could not be inserted! Array\n(\n [blog_id] => 1\n [category] => deposit\n [account] => 9805\n [address] => EUfr4jUPVKW3khmHnZ9ZYDeCfCVPVvHRJq\n [extra] => \n [txid] => 7bbd3bc4685e77745fc660f835750f89f21496734da8ff17cb368f21a40c768a\n [symbol] => EOT\n [amount] => 7.0000000000\n [fee] => 0\n [created_time] => 2018-05-22T16:54:58+0000\n [updated_time] => 2018-05-22 16:57:50\n [confirmations] => 1\n [status] => pending\n [retries] => 255\n)\n, referer: https://eotwallet.com/wp-cron.php?doing_wp_cron=1527008236.4876289367675781250000
    [Tue May 22 16:57:50.089732 2018] [:error] [pid 2292] [client 207.154.197.212:58282] action_wallets_transaction Last DB error: Duplicate entry ‘7bbd3bc4685e77745fc660f835750f89f21496734da8ff17cb368f21a40c768a’ for key ‘uq_tx_idx’, referer: https://eotwallet.com/wp-cron.php?doing_wp_cron=1527008236.4876289367675781250000

    Thread Starter eotwallet

    (@eotwallet)

    mysql> SHOW INDEX FROM wp_wallets_txs;
    +—————-+————+————-+————–+————-+———–+————-+———-+——–+——+————+———+—————+
    | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
    +—————-+————+————-+————–+————-+———–+————-+———-+——–+——+————+———+—————+
    | wp_wallets_txs | 0 | PRIMARY | 1 | id | A | 157047 | NULL | NULL | | BTREE | | |
    | wp_wallets_txs | 0 | uq_tx_idx | 1 | txid | A | 110339 | NULL | NULL | YES | BTREE | | |
    | wp_wallets_txs | 0 | uq_tx_idx | 2 | address | A | 127234 | NULL | NULL | | BTREE | | |
    | wp_wallets_txs | 0 | uq_tx_idx | 3 | symbol | A | 146973 | NULL | NULL | | BTREE | | |
    | wp_wallets_txs | 1 | account_idx | 1 | account | A | 9816 | NULL | NULL | | BTREE | | |
    | wp_wallets_txs | 1 | blogid_idx | 1 | blog_id | A | 1 | NULL | NULL | | BTREE | | |
    +—————-+————+————-+————–+————-+———–+————-+———-+——–+——+————+———+—————+
    6 rows in set (0.00 sec)

    Thread Starter eotwallet

    (@eotwallet)

    Some errors I am getting in apache2 error log

    [Tue May 22 12:18:42.307574 2018] [:error] [pid 1449] [client 207.154.197.212:54660] WordPress database error Duplicate entry ‘568eda84a986129efaa87575216e13875cdfc7d14118e1f384d9fe643d578214’ 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’, 9805, ‘EUfr4jUPVKW3khmHnZ9ZYDeCfCVPVvHRJq’, ”, ‘568eda84a986129efaa87575216e13875cdfc7d14118e1f384d9fe643d578214’, ‘EOT’, ‘2.0000000000’, ‘0’, ‘2018-05-22T12:14:38+0000’, ‘2018-05-22 12:18:42’, 1, ‘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=1526991510.1889190673828125000000
    [Tue May 22 12:18:42.309991 2018] [:error] [pid 1449] [client 207.154.197.212:54660] action_wallets_transaction Transaction could not be inserted! Array\n(\n [blog_id] => 1\n [category] => deposit\n [account] => 9805\n [address] => EUfr4jUPVKW3khmHnZ9ZYDeCfCVPVvHRJq\n [extra] => \n [txid] => 568eda84a986129efaa87575216e13875cdfc7d14118e1f384d9fe643d578214\n [symbol] => EOT\n [amount] => 2.0000000000\n [fee] => 0\n [created_time] => 2018-05-22T12:14:38+0000\n [updated_time] => 2018-05-22 12:18:42\n [confirmations] => 1\n [status] => pending\n [retries] => 255\n)\n, referer: https://eotwallet.com/wp-cron.php?doing_wp_cron=1526991510.1889190673828125000000
    [Tue May 22 12:18:42.311921 2018] [:error] [pid 1449] [client 207.154.197.212:54660] action_wallets_transaction Last DB error: Duplicate entry ‘568eda84a986129efaa87575216e13875cdfc7d14118e1f384d9fe643d578214’ for key ‘uq_tx_idx’, referer: https://eotwallet.com/wp-cron.php?doing_wp_cron=1526991510.1889190673828125000000
    [Tue May 22 13:38:41.387791 2018] [:error] [pid 7192] [client 207.154.197.212:46156] WordPress database error BIGINT UNSIGNED value is out of range in ‘(eotwallet_wordpress.wp_wallets_txs.retries – 1)’ for query \n\t\t\t\t\t\tUPDATE\n\t\t\t\t\t\t\twp_wallets_txs\n\t\t\t\t\t\tSET\n\t\t\t\t\t\t\tstatus = ‘pending’,\n\t\t\t\t\t\t\tretries = retries – 1\n\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\tid = 766363\n\t\t\t\t\t\t made by do_action_ref_array, WP_Hook->do_action, WP_Hook->apply_filters, Dashed_Slug_Wallets_TXs->cron, Dashed_Slug_Wallets_TXs->execute_pending_withdrawals, W3TC\\DbCache_Wpdb->query, W3TC\\DbCache_WpdbInjection_QueryCaching->query, W3TC\\_CallUnderlying->query, W3TC\\DbCache_Wpdb->query, W3TC\\DbCache_WpdbInjection->query, W3TC\\DbCache_Wpdb->default_query, referer: https://eotwallet.com/wp-cron.php?doing_wp_cron=1526996312.6995460987091064453125
    [Tue May 22 13:38:42.210531 2018] [:error] [pid 8032] [client 207.154.197.212:46042] WordPress database error BIGINT UNSIGNED value is out of range in ‘(eotwallet_wordpress.wp_wallets_txs.retries – 1)’ for query \n\t\t\t\t\t\tUPDATE\n\t\t\t\t\t\t\twp_wallets_txs\n\t\t\t\t\t\tSET\n\t\t\t\t\t\t\tstatus = ‘failed’,\n\t\t\t\t\t\t\tretries = retries – 1\n\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\tid = 766363\n\t\t\t\t\t\t made by do_action_ref_array, WP_Hook->do_action, WP_Hook->apply_filters, Dashed_Slug_Wallets_TXs->cron, Dashed_Slug_Wallets_TXs->execute_pending_withdrawals, W3TC\\DbCache_Wpdb->query, W3TC\\DbCache_WpdbInjection_QueryCaching->query, W3TC\\_CallUnderlying->query, W3TC\\DbCache_Wpdb->query, W3TC\\DbCache_WpdbInjection->query, W3TC\\DbCache_Wpdb->default_query, referer: https://eotwallet.com/wp-cron.php?doing_wp_cron=1526996311.9633519649505615234375
    [Tue May 22 13:38:43.140770 2018] [:error] [pid 7327] [client 207.154.197.212:46352] WordPress database error BIGINT UNSIGNED value is out of range in ‘(eotwallet_wordpress.wp_wallets_txs.retries – 1)’ for query \n\t\t\t\t\t\tUPDATE\n\t\t\t\t\t\t\twp_wallets_txs\n\t\t\t\t\t\tSET\n\t\t\t\t\t\t\tstatus = ‘failed’,\n\t\t\t\t\t\t\tretries = retries – 1\n\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\tid = 766363\n\t\t\t\t\t\t made by do_action_ref_array, WP_Hook->do_action, WP_Hook->apply_filters, Dashed_Slug_Wallets_TXs->cron, Dashed_Slug_Wallets_TXs->execute_pending_withdrawals, W3TC\\DbCache_Wpdb->query, W3TC\\DbCache_WpdbInjection_QueryCaching->query, W3TC\\_CallUnderlying->query, W3TC\\DbCache_Wpdb->query, W3TC\\DbCache_WpdbInjection->query, W3TC\\DbCache_Wpdb->default_query, referer: https://eotwallet.com/wp-cron.php?doing_wp_cron=1526996313.4660971164703369140625

Viewing 15 replies - 1 through 15 (of 19 total)