mynodebtc / mynodebtc.github.io

Github Pages for myNode Docs
4 stars 6 forks source link

Mempool #3

Open rhst1 opened 1 year ago

rhst1 commented 1 year ago

The Mempool app on myNode has been red for weeks. It doesn't get fixed when I upgrade to the next myNode version, which has happened several times, since it went red.

Disabling, restarting, uninstalling reinstalling Mempool - all have been down several times with no change - still red.

One person on Telegram thought it might be due to having only 4GB of RAM, but after upgrading to 8GB there is no change - still red.

When clicking on Mempool, it attempts to open, but eventually gives a 502 Error.

rhst1 commented 1 year ago

MEMPOOL STATUS Error Running Containers: mempool_web_1 mempool_db_1 mempool_api_1 -- Logs begin at Sat 2023-06-03 06:17:55 CDT, end at Sat 2023-06-03 16:06:53 CDT. -- Jun 03 16:06:52 myNode mempool[29098]: mempool_api_1 exited with code 1 Jun 03 16:06:52 myNode mempool[29099]: + sleep 5s Jun 03 16:06:52 myNode mempool[29099]: + '[' true == true ']' Jun 03 16:06:52 myNode mempool[29099]: + isRunning=true Jun 03 16:06:52 myNode mempool[29099]: ++ docker inspect '--format={{.State.Running}}' mempool_db1 Jun 03 16:06:52 myNode mempool[29099]: + '[' 1 ']' Jun 03 16:06:52 myNode mempool[29099]: + [[ '' == *\i\n\f\o\r\m\a\t\i\o\n\\s\c\h\e\m\a* ]] Jun 03 16:06:52 myNode mempool[29099]: + databases= Jun 03 16:06:51 myNode mempool[29098]: db_1 | 2023-06-03 21:06:51 8 [Warning] Access denied for user 'root'@'localhost' (using password: YES) Jun 03 16:06:51 myNode mempool[29099]: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) Jun 03 16:06:51 myNode mempool[29098]: api_1 | Jun 3 21:06:51 [109] ERR: Could not connect to database: Host '172.26.0.3' is not allowed to connect to this MariaDB server Jun 03 16:06:51 myNode mempool[29098]: db_1 | 2023-06-03 21:06:51 7 [Warning] Aborted connection 7 to db: 'unconnected' user: 'unauthenticated' host: '172.26.0.3' (This connection closed normally without authentication) Jun 03 16:06:51 myNode mempool[29099]: ++ docker exec -i mempool_db_1 mysql -uroot -padmin -e 'SHOW DATABASES;' Jun 03 16:06:51 myNode mempool[29098]: api_1 | Jun 3 21:06:51 [109] NOTICE: Starting Mempool Server... (57eddac) Jun 03 16:06:48 myNode mempool[29098]: db_1 | 2023-06-03 21:06:48 6 [Warning] Aborted connection 6 to db: 'unconnected' user: 'unauthenticated' host: '172.26.0.3' (This connection closed normally without authentication) Jun 03 16:06:46 myNode mempool[29099]: + sleep 5s Jun 03 16:06:46 myNode mempool[29099]: + '[' true == true ']' Jun 03 16:06:46 myNode mempool[29099]: + isRunning=true Jun 03 16:06:46 myNode mempool[29099]: ++ docker inspect '--format={{.State.Running}}' mempool_db_1 Jun 03 16:06:46 myNode mempool[29099]: + '[' 1 ']' Jun 03 16:06:46 myNode mempool[29099]: + isRunning= Jun 03 16:06:46 myNode mempool[29098]: api_1 | Jun 3 21:06:46 [113] ERR: Could not connect to database: Host '172.26.0.3' is not allowed to connect to this MariaDB server Jun 03 16:06:45 myNode mempool[29098]: db_1 | 2023-06-03 21:06:45 5 [Warning] Aborted connection 5 to db: 'unconnected' user: 'unauthenticated' host: '172.26.0.3' (This connection closed normally without authentication) Jun 03 16:06:45 myNode mempool[29098]: api_1 | Jun 3 21:06:45 [113] NOTICE: Starting Mempool Server... (57eddac) Jun 03 16:06:42 myNode mempool[29098]: api_1 | wait-for-it.sh: db:3306 is available after 2 seconds Jun 03 16:06:42 myNode mempool[29098]: db_1 | 2023-06-03 21:06:42 4 [Warning] Aborted connection 4 to db: 'unconnected' user: 'unauthenticated' host: '172.26.0.3' (This connection closed normally without authentication) Jun 03 16:06:42 myNode mempool[29098]: db_1 | 2023-06-03 21:06:42 3 [Warning] Aborted connection 3 to db: 'unconnected' user: 'unauthenticated' host: '172.26.0.4' (This connection closed normally without authentication) Jun 03 16:06:42 myNode mempool[29098]: db_1 | 2023-06-03 21:06:42 0 [Note] InnoDB: Buffer pool(s) load completed at 230603 21:06:42 Jun 03 16:06:42 myNode mempool[29098]: db_1 | Version: '10.9.3-MariaDB-1:10.9.3+maria~ubu2204' socket: '/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution Jun 03 16:06:42 myNode mempool[29098]: db_1 | 2023-06-03 21:06:42 0 [Note] mariadbd: ready for connections. Jun 03 16:06:42 myNode mempool[29098]: db_1 | 2023-06-03 21:06:42 0 [Warning] 'proxies_priv' entry '@% root@96fd21e273f0' ignored in --skip-name-resolve mode. Jun 03 16:06:42 myNode mempool[29098]: db_1 | 2023-06-03 21:06:42 0 [Warning] 'user' entry 'root@96fd21e273f0' ignored in --skip-name-resolve mode. Jun 03 16:06:42 myNode mempool[29098]: db_1 | 2023-06-03 21:06:42 0 [Note] Server socket created on IP: '::'. Jun 03 16:06:42 myNode mempool[29098]: db_1 | 2023-06-03 21:06:42 0 [Note] Server socket created on IP: '0.0.0.0'. Jun 03 16:06:42 myNode mempool[29098]: db_1 | 2023-06-03 21:06:42 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work. Jun 03 16:06:42 myNode mempool[29098]: db_1 | 2023-06-03 21:06:42 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool Jun 03 16:06:42 myNode mempool[29098]: db_1 | 2023-06-03 21:06:42 0 [Note] Plugin 'FEEDBACK' is disabled. Jun 03 16:06:42 myNode mempool[29098]: db_1 | 2023-06-03 21:06:42 0 [Note] InnoDB: log sequence number 46790; transaction id 14 Jun 03 16:06:42 myNode mempool[29098]: db_1 | 2023-06-03 21:06:42 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB. Jun 03 16:06:42 myNode mempool[29098]: db_1 | 2023-06-03 21:06:42 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ... Jun 03 16:06:42 myNode mempool[29098]: db_1 | 2023-06-03 21:06:42 0 [Note] InnoDB: 128 rollback segments are active. Jun 03 16:06:42 myNode mempool[29098]: db_1 | 2023-06-03 21:06:42 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes) Jun 03 16:06:41 myNode mempool[29098]: db_1 | 2023-06-03 21:06:41 0 [Note] InnoDB: Completed initialization of buffer pool Jun 03 16:06:41 myNode mempool[29098]: db_1 | 2023-06-03 21:06:41 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB Jun 03 16:06:41 myNode mempool[29098]: db_1 | 2023-06-03 21:06:41 0 [Warning] InnoDB: liburing disabled: falling back to innodb_use_native_aio=OFF Jun 03 16:06:41 myNode mempool[29098]: db_1 | 2023-06-03 21:06:41 0 [Warning] mariadbd: io_uring_queue_init() failed with ENOSYS: check seccomp filters, and the kernel version (newer than 5.1 required) Jun 03 16:06:41 myNode mempool[29098]: db_1 | 2023-06-03 21:06:41 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts) Jun 03 16:06:41 myNode mempool[29098]: db_1 | 2023-06-03 21:06:41 0 [Note] InnoDB: Using ARMv8 crc32 instructions Jun 03 16:06:41 myNode mempool[29098]: db_1 | 2023-06-03 21:06:41 0 [Note] InnoDB: Number of transaction pools: 1 Jun 03 16:06:41 myNode mempool[29098]: db_1 | 2023-06-03 21:06:41 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 Jun 03 16:06:41 myNode mempool[29098]: db_1 | 2023-06-03 21:06:41 0 [Note] mariadbd (server 10.9.3-MariaDB-1:10.9.3+maria~ubu2204) starting as process 1 ... Jun 03 16:06:41 myNode mempool[29098]: db_1 | 2023-06-03 21:06:41+00:00 [Note] [Entrypoint]: MariaDB upgrade (mariadb-upgrade) required, but skipped due to $MARIADB_AUTO_UPGRADE setting Jun 03 16:06:41 myNode mempool[29098]: db_1 | 2023-06-03 21:06:41+00:00 [Note] [Entrypoint]: MariaDB upgrade information missing, assuming required Jun 03 16:06:41 myNode mempool[29098]: web_1 | /var/www/mempool/browser/resources Jun 03 16:06:41 myNode mempool[29098]: db_1 | 2023-06-03 21:06:40+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.9.3+maria~ubu2204 started. Jun 03 16:06:41 myNode mempool[29098]: db_1 | 2023-06-03 21:06:40+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql' Jun 03 16:06:41 myNode mempool[29098]: db_1 | 2023-06-03 21:06:39+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.9.3+maria~ubu2204 started. Jun 03 16:06:41 myNode mempool[29098]: api_1 | wait-for-it.sh: waiting 720 seconds for db:3306 Jun 03 16:06:41 myNode mempool[29098]: Attaching to mempool_db_1, mempool_api_1, mempool_web_1 Jun 03 16:06:41 myNode mempool[29098]: Starting mempool_web_1 ... done Jun 03 16:06:41 myNode mempool[29098]: Starting mempool_api_1 ... done Jun 03 16:06:40 myNode mempool[29098]: Starting mempool_db_1 ... done Jun 03 16:06:38 myNode mempool[29098]: Starting mempool_api_1 ... Jun 03 16:06:38 myNode mempool[29098]: Starting mempool_db_1 ... Jun 03 16:06:38 myNode mempool[29098]: Starting mempool_web_1 ... Jun 03 16:06:36 myNode mempool[29099]: + sleep 10s Jun 03 16:06:36 myNode mempool[29099]: ++ '[' -f /usr/share/mynode/mynode_config_debian.sh ']' Jun 03 16:06:36 myNode mempool[29099]: ++ source /usr/share/mynode/mynode_config_raspi.sh Jun 03 16:06:36 myNode mempool[29099]: ++ '[' -f /usr/share/mynode/mynode_config_raspi.sh ']' Jun 03 16:06:36 myNode mempool[29099]: ++ UPGRADE_PUBKEY_URL=https://raw.githubusercontent.com/mynodebtc/pubkey/master/mynode_release.pub Jun 03 16:06:36 myNode mempool[29099]: ++ UPGRADE_BETA_DOWNLOAD_SIGNATURE_URL='https://www.mynodebtc.com/device_api/download_latest_standard.php?type=raspi4&product_key=CSA4F3LRQ393&beta=1&hash=1' Jun 03 16:06:36 myNode mempool[29099]: ++ UPGRADE_BETA_DOWNLOAD_URL='https://www.mynodebtc.com/device_api/download_latest_standard.php?type=raspi4&product_key=CSA4F3LRQ393&beta=1' Jun 03 16:06:36 myNode mempool[29099]: ++ UPGRADE_DOWNLOAD_SIGNATURE_URL='https://www.mynodebtc.com/device_api/download_latest_standard.php?type=raspi4&product_key=CSA4F3LRQ393&hash=1' Jun 03 16:06:36 myNode mempool[29099]: ++ UPGRADE_DOWNLOAD_URL='https://www.mynodebtc.com/device_api/download_latest_standard.php?type=raspi4&product_key=CSA4F3LRQ393' Jun 03 16:06:36 myNode mempool[29099]: ++ IS_PREMIUM=1 Jun 03 16:06:36 myNode mempool[29099]: ++ '[' '!' -f /mnt/hdd/mynode/settings/.product_key_error ']' Jun 03 16:06:36 myNode mempool[29099]: ++ '[' '!' -f /home/bitcoin/.mynode/.product_key_error ']' Jun 03 16:06:36 myNode mempool[29099]: ++ '[' '!' -f /mnt/hdd/mynode/settings/.product_key_skipped ']' Jun 03 16:06:36 myNode mempool[29099]: ++ '[' '!' -f /home/bitcoin/.mynode/.product_key_skipped ']' Jun 03 16:06:36 myNode mempool[29099]: ++ PRODUCT_KEY=CSA4F3LRQ393 Jun 03 16:06:36 myNode mempool[29099]: +++ cat /home/bitcoin/.mynode/.product_key Jun 03 16:06:36 myNode mempool[29099]: ++ '[' -f /home/bitcoin/.mynode/.product_key ']' Jun 03 16:06:36 myNode mempool[29099]: ++ PRODUCT_KEY=not_found Jun 03 16:06:36 myNode mempool[29099]: ++ IS_PREMIUM=0 Jun 03 16:06:36 myNode mempool[29099]: ++ QUICKSYNC_COMPLETE_FILE=/mnt/hdd/mynode/quicksync/.quicksync_complete Jun 03 16:06:36 myNode mempool[29099]: ++ BITCOIN_SYNCED_FILE=/mnt/hdd/mynode/.mynode_bitcoin_synced Jun 03 16:06:36 myNode mempool[29099]: ++ '[' -f /mnt/hdd/mynode/settings/.testnet_enabled ']' Jun 03 16:06:36 myNode mempool[29099]: ++ IS_TESTNET_ENABLED_FILE=/mnt/hdd/mynode/settings/.testnet_enabled Jun 03 16:06:36 myNode mempool[29099]: ++ PRODUCT_KEY_FILE=/home/bitcoin/.mynode/.product_key Jun 03 16:06:36 myNode mempool[29099]: ++ LND_ADMIN_MACAROON_FILE=/mnt/hdd/mynode/lnd/data/chain/bitcoin/mainnet/admin.macaroon Jun 03 16:06:36 myNode mempool[29099]: ++ LND_CHANNEL_FILE_BACKUP=/home/bitcoin/lnd_backup/channel.backup Jun 03 16:06:36 myNode mempool[29099]: ++ LND_CHANNEL_FILE=/mnt/hdd/mynode/lnd/data/chain/bitcoin/mainnet/channel.backup Jun 03 16:06:36 myNode mempool[29099]: ++ LND_WALLET_FILE=/mnt/hdd/mynode/lnd/data/chain/bitcoin/mainnet/wallet.db Jun 03 16:06:36 myNode mempool[29099]: ++ LND_TLS_CERT_FILE=/mnt/hdd/mynode/lnd/tls.cert Jun 03 16:06:36 myNode mempool[29099]: ++ LND_BACKUP_FOLDER=/home/bitcoin/lnd_backup/ Jun 03 16:06:36 myNode mempool[29099]: ++ UPGRADE_ERROR_FILE=/mnt/hdd/mynode/settings/upgrade_error Jun 03 16:06:36 myNode mempool[29099]: ++ UPLOADER_FILE=/mnt/hdd/mynode/settings/uploader Jun 03 16:06:36 myNode mempool[29099]: ++ LATEST_BETA_VERSION_URL='https://www.mynodebtc.com/device_api/get_latest_version.php?type=raspi4&beta=1' Jun 03 16:06:36 myNode mempool[29099]: ++ LATEST_VERSION_URL='https://www.mynodebtc.com/device_api/get_latest_version.php?type=raspi4' Jun 03 16:06:36 myNode mempool[29099]: ++ QUICKSYNC_BACKGROUND_DOWNLOAD_RATE_FILE=/mnt/hdd/mynode/settings/quicksync_background_download_rate Jun 03 16:06:36 myNode mempool[29099]: ++ QUICKSYNC_UPLOAD_RATE_FILE=/mnt/hdd/mynode/settings/quicksync_upload_rate Jun 03 16:06:36 myNode mempool[29099]: ++ QUICKSYNC_TORRENT_BETA_URL=https://mynodebtc.com/device/blockchain_beta.tar.gz.torrent Jun 03 16:06:36 myNode mempool[29099]: ++ QUICKSYNC_TORRENT_URL=https://mynodebtc.com/device/blockchain.tar.gz.torrent Jun 03 16:06:36 myNode mempool[29099]: ++ QUICKSYNC_CONFIG_DIR=/mnt/hdd/mynode/.config/transmission Jun 03 16:06:36 myNode mempool[29099]: ++ QUICKSYNC_DIR=/mnt/hdd/mynode/quicksync Jun 03 16:06:36 myNode mempool[29099]: ++ VPN_BACKUP_DIR=/mnt/hdd/mynode/vpn Jun 03 16:06:36 myNode mempool[29099]: ++ DEVICE_ARCHITECTURE_FILE=/mnt/hdd/mynode/settings/.device_arch Jun 03 16:06:36 myNode mempool[29099]: ++ MYNODE_STATUS_FILE=/tmp/.mynode_status Jun 03 16:06:36 myNode mempool[29099]: ++ MYNODE_DIR=/mnt/hdd/mynode Jun 03 16:06:36 myNode mempool[29099]: +++ SERIAL_NUM=100000008439368b Jun 03 16:06:36 myNode mempool[29099]: ++++ mynode-get-device-serial Jun 03 16:06:36 myNode mempool[29099]: +++ TOTAL_RAM_GB=8 Jun 03 16:06:36 myNode mempool[29099]: ++++ awk '{print $2}' Jun 03 16:06:36 myNode mempool[29099]: ++++ free --giga Jun 03 16:06:36 myNode mempool[29099]: ++++ grep Mem Jun 03 16:06:36 myNode mempool[29099]: +++ DEVICE_TYPE=raspi4 Jun 03 16:06:36 myNode mempool[29099]: +++ '[' 1 -eq 1 ']' Jun 03 16:06:36 myNode mempool[29099]: +++ '[' 0 -eq 1 ']' Jun 03 16:06:36 myNode mempool[29099]: +++ IS_64_BIT=1 Jun 03 16:06:36 myNode mempool[29099]: +++ IS_32_BIT=0 Jun 03 16:06:36 myNode mempool[29099]: +++ IS_RASPI4_ARM64=1 Jun 03 16:06:36 myNode mempool[29099]: +++ [[ Linux myNode 5.10.103-v8+ #1529 SMP PREEMPT Tue Mar 8 12:26:46 GMT 2022 aarch64 GNU/Linux == \a\a\r\c\h\6\4 ]] Jun 03 16:06:36 myNode mempool[29099]: +++ UNAME='Linux myNode 5.10.103-v8+ #1529 SMP PREEMPT Tue Mar 8 12:26:46 GMT 2022 aarch64 GNU/Linux' Jun 03 16:06:36 myNode mempool[29099]: ++++ uname -a Jun 03 16:06:36 myNode mempool[29099]: +++ IS_32_BIT=1 Jun 03 16:06:36 myNode mempool[29099]: +++ IS_RASPI4=1 Jun 03 16:06:36 myNode mempool[29099]: +++ IS_RASPI=1 Jun 03 16:06:36 myNode mempool[29099]: +++ [[ Raspberry Pi 4 Model B Rev 1.5 == \R\a\s\p\b\e\r\r\y\ \P\i\ \4 ]] Jun 03 16:06:36 myNode mempool[29099]: +++ [[ Raspberry Pi 4 Model B Rev 1.5 == \R\a\s\p\b\e\r\r\y\ \P\i\ \3 ]] Jun 03 16:06:36 myNode mempool[29099]: +++ [[ Raspberry Pi 4 Model B Rev 1.5 == \R\o\c\k\P\r\o\6\4 ]] Jun 03 16:06:36 myNode mempool[29099]: +++ [[ Raspberry Pi 4 Model B Rev 1.5 == \R\o\c\k\6\4 ]] Jun 03 16:06:36 myNode mempool[29099]: +++ true Jun 03 16:06:36 myNode mempool[29099]: +++ grep amd64 Jun 03 16:06:36 myNode mempool[29099]: +++ uname -a Jun 03 16:06:36 myNode mempool[29099]: +++ DEBIAN_VERSION=buster Jun 03 16:06:35 myNode mempool[29099]: ++++ lsb_release -c -s Jun 03 16:06:35 myNode mempool[29099]: +++ MODEL='Raspberry Pi 4 Model B Rev 1.5' Jun 03 16:06:35 myNode mempool[29099]: ++++ tr -d '\0' Jun 03 16:06:35 myNode mempool[29099]: +++ DEVICE_ARCH=aarch64 Jun 03 16:06:35 myNode mempool[29099]: ++++ uname -m Jun 03 16:06:35 myNode mempool[29099]: +++ DEVICE_TYPE=unknown Jun 03 16:06:35 myNode mempool[29099]: +++ IS_64_BIT=0 Jun 03 16:06:35 myNode mempool[29099]: +++ IS_32_BIT=0 Jun 03 16:06:35 myNode mempool[29099]: +++ IS_X86=0 Jun 03 16:06:35 myNode mempool[29099]: +++ IS_ROCKPI4=0 Jun 03 16:06:35 myNode mempool[29099]: +++ IS_RASPI4_ARM64=0 Jun 03 16:06:35 myNode mempool[29099]: +++ IS_RASPI4=0 Jun 03 16:06:35 myNode mempool[29099]: +++ IS_RASPI3=0 Jun 03 16:06:35 myNode mempool[29099]: +++ IS_RASPI=0 Jun 03 16:06:35 myNode mempool[29099]: +++ IS_ROCKPRO64=0 Jun 03 16:06:35 myNode mempool[29099]: +++ IS_ROCK64=0 Jun 03 16:06:35 myNode mempool[29099]: +++ IS_ARMBIAN=0 Jun 03 16:06:35 myNode mempool[29099]: ++ source /usr/share/mynode/mynode_device_info.sh Jun 03 16:06:35 myNode mempool[29099]: + source /usr/share/mynode/mynode_config.sh Jun 03 16:06:35 myNode mempool[29032]: + sed -i 's|MARIA_DB_IMAGE=.|MARIA_DB_IMAGE=mariadb:10.9.3|g' /mnt/hdd/mynode/mempool/.env Jun 03 16:06:35 myNode mempool[29032]: + '[' 1 -eq 0 ']' Jun 03 16:06:35 myNode mempool[29032]: + '[' 1 -eq 1 ']' Jun 03 16:06:35 myNode mempool[29032]: + sed -i 's/BITCOIN_RPC_PASS=./BITCOIN_RPC_PASS=V1Jo2Syj9hGnfbJdCaig5XBr/g' /mnt/hdd/mynode/mempool/.env Jun 03 16:06:35 myNode mempool[29032]: + sed -i 's/VERSION=./VERSION=v2.5.0/g' /mnt/hdd/mynode/mempool/.env Jun 03 16:06:35 myNode mempool[29032]: + cp -f /usr/share/mynode/mempool.env /mnt/hdd/mynode/mempool/.env Jun 03 16:06:35 myNode mempool[29032]: + cp -f /usr/share/mynode/mempool-docker-compose.yml /mnt/hdd/mynode/mempool/docker-compose.yml Jun 03 16:06:35 myNode mempool[29032]: + BTCRPCPW=V1Jo2Syj9hGnfbJdCaig5XBr Jun 03 16:06:35 myNode mempool[29032]: ++ cat /mnt/hdd/mynode/settings/.btcrpcpw Jun 03 16:06:35 myNode mempool[28963]: + exit 0 Jun 03 16:06:35 myNode mempool[28963]: + '[' -f /tmp/installing_docker_images ']' Jun 03 16:06:35 myNode mempool[28963]: Checking if docker images have been installed... Jun 03 16:06:35 myNode mempool[28963]: + echo 'Checking if docker images have been installed...' Jun 03 16:06:20 myNode mempool[28963]: + sleep 15s Jun 03 16:06:20 myNode mempool[28961]: + exit 0 Jun 03 16:06:20 myNode mempool[28961]: } Jun 03 16:06:20 myNode mempool[28961]: "warnings": "" Jun 03 16:06:20 myNode mempool[28961]: "pruned": false, Jun 03 16:06:20 myNode mempool[28961]: "size_on_disk": 551215635894, Jun 03 16:06:20 myNode mempool[28961]: "chainwork": "00000000000000000000000000000000000000004a893e723dd5229d7576e8c4", Jun 03 16:06:20 myNode mempool[28961]: "initialblockdownload": false, Jun 03 16:06:20 myNode mempool[28961]: "verificationprogress": 0.99999601317836, Jun 03 16:06:20 myNode mempool[28961]: "mediantime": 1685822512, Jun 03 16:06:20 myNode mempool[28961]: "time": 1685825225, Jun 03 16:06:20 myNode mempool[28961]: "difficulty": 51234338863442.89, Jun 03 16:06:20 myNode mempool[28961]: "bestblockhash": "0000000000000000000536f803bf18013feb5002763ad73b6f921d838eddc671", Jun 03 16:06:20 myNode mempool[28961]: "headers": 792729, Jun 03 16:06:20 myNode mempool[28961]: "blocks": 792729, Jun 03 16:06:20 myNode mempool[28961]: "chain": "main", Jun 03 16:06:20 myNode mempool[28961]: { Jun 03 16:06:20 myNode mempool[28961]: + bitcoin-cli -datadir=/mnt/hdd/mynode/bitcoin -rpcwait getblockchaininfo Jun 03 16:06:20 myNode mempool[28961]: + '[' '!' -f /mnt/hdd/mynode/.mynode_bitcoin_synced ']' Jun 03 16:06:20 myNode mempool[28961]: Checking if Bitcoin is synced... Jun 03 16:06:20 myNode mempool[28961]: + echo 'Checking if Bitcoin is synced...' Jun 03 16:06:20 myNode mempool[28961]: + set -e Jun 03 16:06:20 myNode mempool[28960]: Not shutting down! Jun 03 16:06:20 myNode mempool[28960]: Checking if device is shutting down... Jun 03 16:06:20 myNode systemd[1]: Starting Mempool... Jun 03 16:06:20 myNode systemd[1]: Stopped Mempool. Jun 03 16:06:20 myNode systemd[1]: mempool.service: Scheduled restart job, restart counter is at 400. Jun 03 16:06:20 myNode systemd[1]: mempool.service: Service RestartSec=30s expired, scheduling restart. Jun 03 16:05:50 myNode systemd[1]: Failed to start Mempool. Jun 03 16:05:50 myNode systemd[1]: mempool.service: Failed with result 'timeout'. Jun 03 16:05:49 myNode mempool[24722]: Gracefully stopping... (press Ctrl+C again to force) Jun 03 16:05:49 myNode mempool[24722]: Stopping mempool_db_1 ... done Jun 03 16:05:49 myNode mempool[24722]: Stopping mempool_web_1 ... done Jun 03 16:05:47 myNode mempool[24722]: Stopping mempool_api_1 ... done Jun 03 16:05:47 myNode mempool[24722]: Stopping mempool_db_1 ... Jun 03 16:05:47 myNode mempool[24722]: Stopping mempool_api_1 ... Jun 03 16:05:47 myNode mempool[24722]: Stopping mempool_web_1 ... Jun 03 16:05:47 myNode systemd[1]: mempool.service: Control process exited, code=killed, status=15/TERM Jun 03 16:05:47 myNode systemd[1]: mempool.service: Start-post operation timed out. Stopping. Jun 03 16:05:45 myNode mempool[24723]: + sleep 5s Jun 03 16:05:45 myNode mempool[24723]: + '[' true == true ']' Jun 03 16:05:45 myNode mempool[24723]: + isRunning=true Jun 03 16:05:45 myNode mempool[24723]: ++ docker inspect '--format={{.State.Running}}' mempool_db_1 Jun 03 16:05:45 myNode mempool[24723]: + '[' 1 ']' Jun 03 16:05:45 myNode mempool[24723]: + [[ '' == \i\n\f\o\r\m\a\t\i\o\n_\s\c\h\e\m\a ]] Jun 03 16:05:45 myNode mempool[24723]: + databases= Jun 03 16:05:45 myNode mempool[24722]: db_1 | 2023-06-03 21:05:45 43 [Warning] Access denied for user 'root'@'localhost' (using password: YES) Jun 03 16:05:45 myNode mempool[24723]: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) Jun 03 16:05:45 myNode mempool[24723]: ++ docker exec -i mempool_db_1 mysql -uroot -padmin -e 'SHOW DATABASES;' Jun 03 16:05:40 myNode mempool[24723]: + sleep 5s Jun 03 16:05:40 myNode mempool[24723]: + '[' true == true ']' Jun 03 16:05:40 myNode mempool[24723]: + isRunning=true Jun 03 16:05:39 myNode mempool[24723]: ++ docker inspect '--format={{.State.Running}}' mempool_db_1 Jun 03 16:05:39 myNode mempool[24723]: + '[' 1 ']' Jun 03 16:05:39 myNode mempool[24723]: + [[ '' == \i\n\f\o\r\m\a\t\i\o\n_\s\c\h\e\m\a ]] Jun 03 16:05:39 myNode mempool[24723]: + databases= Jun 03 16:05:39 myNode mempool[24722]: db_1 | 2023-06-03 21:05:39 42 [Warning] Access denied for user 'root'@'localhost' (using password: YES) Jun 03 16:05:39 myNode mempool[24723]: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) Jun 03 16:05:39 myNode mempool[24723]: ++ docker exec -i mempool_db_1 mysql -uroot -padmin -e 'SHOW DATABASES;' Jun 03 16:05:36 myNode mempool[24722]: mempool_api_1 exited with code 1 Jun 03 16:05:35 myNode mempool[24722]: api_1 | Jun 3 21:05:35 [110] ERR: Could not connect to database: Host '172.26.0.4' is not allowed to connect to this MariaDB server Jun 03 16:05:35 myNode mempool[24722]: db_1 | 2023-06-03 21:05:35 41 [Warning] Aborted connection 41 to db: 'unconnected' user: 'unauthenticated' host: '172.26.0.4' (This connection closed normally without authentication) Jun 03 16:05:35 myNode mempool[24722]: api_1 | Jun 3 21:05:35 [110] NOTICE: Starting Mempool Server... (57eddac) Jun 03 16:05:34 myNode mempool[24723]: + sleep 5s Jun 03 16:05:34 myNode mempool[24723]: + '[' true == true ']' Jun 03 16:05:34 myNode mempool[24723]: + isRunning=true Jun 03 16:05:34 myNode mempool[24723]: ++ docker inspect '--format={{.State.Running}}' mempool_db_1 Jun 03 16:05:34 myNode mempool[24723]: + '[' 1 ']' Jun 03 16:05:34 myNode mempool[24723]: + [[ '' == \i\n\f\o\r\m\a\t\i\o\n_\s\c\h\e\m\a ]] Jun 03 16:05:34 myNode mempool[24723]: + databases= Jun 03 16:05:34 myNode mempool[24723]: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) Jun 03 16:05:34 myNode mempool[24722]: db_1 | 2023-06-03 21:05:34 40 [Warning] Access denied for user 'root'@'localhost' (using password: YES) Jun 03 16:05:34 myNode mempool[24723]: ++ docker exec -i mempool_db_1 mysql -uroot -padmin -e 'SHOW DATABASES;' Jun 03 16:05:32 myNode mempool[24722]: db_1 | 2023-06-03 21:05:32 39 [Warning] Aborted connection 39 to db: 'unconnected' user: 'unauthenticated' host: '172.26.0.4' (This connection closed normally without authentication) Jun 03 16:05:29 myNode mempool[24723]: + sleep 5s Jun 03 16:05:29 myNode mempool[24723]: + '[' true == true ']' Jun 03 16:05:29 myNode mempool[24723]: + isRunning=true Jun 03 16:05:29 myNode mempool[24723]: ++ docker inspect '--format={{.State.Running}}' mempool_db_1 Jun 03 16:05:29 myNode mempool[24723]: + '[' 1 ']' Jun 03 16:05:29 myNode mempool[24723]: + [[ '' == \i\n\f\o\r\m\a\t\i\o\n_\s\c\h\e\m\a ]] Jun 03 16:05:29 myNode mempool[24723]: + databases= Jun 03 16:05:29 myNode mempool[24723]: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) Jun 03 16:05:29 myNode mempool[24722]: db_1 | 2023-06-03 21:05:29 38 [Warning] Access denied for user 'root'@'localhost' (using password: YES) Jun 03 16:05:28 myNode mempool[24723]: ++ docker exec -i mempool_db_1 mysql -uroot -padmin -e 'SHOW DATABASES;' Jun 03 16:05:23 myNode mempool[24723]: + sleep 5s Jun 03 16:05:23 myNode mempool[24723]: + '[' true == true ']' Jun 03 16:05:23 myNode mempool[24723]: + isRunning=true Jun 03 16:05:23 myNode mempool[24723]: ++ docker inspect '--format={{.State.Running}}' mempool_db_1 Jun 03 16:05:23 myNode mempool[24723]: + '[' 1 ']' Jun 03 16:05:23 myNode mempool[24723]: + [[ '' == \i\n\f\o\r\m\a\t\i\o\n_\s\c\h\e\m\a ]] Jun 03 16:05:23 myNode mempool[24723]: + databases= Jun 03 16:05:23 myNode mempool[24723]: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) Jun 03 16:05:23 myNode mempool[24722]: db_1 | 2023-06-03 21:05:23 37 [Warning] Access denied for user 'root'@'localhost' (using password: YES) Jun 03 16:05:23 myNode mempool[24723]: ++ docker exec -i mempool_db_1 mysql -uroot -padmin -e 'SHOW DATABASES;' Jun 03 16:05:18 myNode mempool[24723]: + sleep 5s Jun 03 16:05:18 myNode mempool[24723]: + '[' true == true ']' Jun 03 16:05:18 myNode mempool[24723]: + isRunning=true Jun 03 16:05:18 myNode mempool[24723]: ++ docker inspect '--format={{.State.Running}}' mempool_db_1 Jun 03 16:05:18 myNode mempool[24723]: + '[' 1 ']' Jun 03 16:05:18 myNode mempool[24723]: + [[ '' == \i\n\f\o\r\m\a\t\i\o\n_\s\c\h\e\m\a ]] Jun 03 16:05:18 myNode mempool[24723]: + databases= Jun 03 16:05:18 myNode mempool[24723]: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) Jun 03 16:05:18 myNode mempool[24722]: db_1 | 2023-06-03 21:05:18 36 [Warning] Access denied for user 'root'@'localhost' (using password: YES) Jun 03 16:05:17 myNode mempool[24723]: ++ docker exec -i mempool_db_1 mysql -uroot -padmin -e 'SHOW DATABASES;' Jun 03 16:05:12 myNode mempool[24723]: + sleep 5s Jun 03 16:05:12 myNode mempool[24723]: + '[' true == true ']' Jun 03 16:05:12 myNode mempool[24723]: + isRunning=true Jun 03 16:05:12 myNode mempool[24723]: ++ docker inspect '--format={{.State.Running}}' mempool_db_1 Jun 03 16:05:12 myNode mempool[24723]: + '[' 1 ']' Jun 03 16:05:12 myNode mempool[24723]: + [[ '' == \i\n\f\o\r\m\a\t\i\o\n_\s\c\h\e\m\a ]] Jun 03 16:05:12 myNode mempool[24723]: + databases= Jun 03 16:05:12 myNode mempool[24723]: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) Jun 03 16:05:12 myNode mempool[24722]: db_1 | 2023-06-03 21:05:12 35 [Warning] Access denied for user 'root'@'localhost' (using password: YES) Jun 03 16:05:12 myNode mempool[24723]: ++ docker exec -i mempool_db_1 mysql -uroot -padmin -e 'SHOW DATABASES;' Jun 03 16:05:07 myNode mempool[24723]: + sleep 5s Jun 03 16:05:07 myNode mempool[24723]: + '[' true == true ']' Jun 03 16:05:07 myNode mempool[24723]: + isRunning=true Jun 03 16:05:07 myNode mempool[24723]: ++ docker inspect '--format={{.State.Running}}' mempool_db_1 Jun 03 16:05:07 myNode mempool[24723]: + '[' 1 ']' Jun 03 16:05:07 myNode mempool[24723]: + [[ '' == \i\n\f\o\r\m\a\t\i\o\n_\s\c\h\e\m\a* ]] Jun 03 16:05:07 myNode mempool[24723]: + databases= Jun 03 16:05:07 myNode mempool[24722]: db_1 | 2023-06-03 21:05:07 34 [Warning] Access denied for user 'root'@'localhost' (using password: YES) Jun 03 16:05:07 myNode mempool[24723]: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) Jun 03 16:05:06 myNode mempool[24722]: mempool_api_1 exited with code 1 Jun 03 16:05:06 myNode mempool[24723]: ++ docker exec -i mempool_db_1 mysql -uroot -padmin -e 'SHOW DATABASES;' Jun 03 16:05:05 myNode mempool[24722]: api_1 | Jun 3 21:05:05 [109] ERR: Could not connect to database: Host '172.26.0.4' is not allowed to connect to this MariaDB server Jun 03 16:05:05 myNode mempool[24722]: db_1 | 2023-06-03 21:05:05 33 [Warning] Aborted connection 33 to db: 'unconnected' user: 'unauthenticated' host: '172.26.0.4' (This connection closed normally without authentication) Jun 03 16:05:05 myNode mempool[24722]: api_1 | Jun 3 21:05:05 [109] NOTICE: Starting Mempool Server... (57eddac) Jun 03 16:05:02 myNode mempool[24722]: db_1 | 2023-06-03 21:05:02 32 [Warning] Aborted connection 32 to db: 'unconnected' user: 'unauthenticated' host: '172.26.0.4' (This connection closed normally without authentication) Jun 03 16:05:01 myNode mempool[24723]: + sleep 5s Jun 03 16:05:01 myNode mempool[24723]: + '[' true == true ']' Jun 03 16:05:01 myNode mempool[24723]: + isRunning=true

rhst1 commented 1 year ago

This issue can be closed. Mempool is finally working again after reinstalling myNode OS at version 3.03, upgrading to current version and then deleting and reinstalling Mempool.

tehelsper commented 1 year ago

Glad it's working. It looks like the database didn't initialize properly and that prevented further setup from running. You could have tried clearing the data to see if it reset itself and initialized properly by deleting data under /mnt/hdd/mynode/mempool and then potentially rebooting and/or re-installing mempool.