offline transactions – What im supposed to do to run Core in airgapped computer?

What do you do? Just open it and leave it trying to sync indefinitely and just use it to create and store keys and sign them?

Can I stop it from trying to sync?

Also as you sign the unsigned transactions by opening the generated PSBT files in your online laptop, does this offline wallet save the history and record that this transaction was made even tho it isn’t reflected because its offline? just to keep track of it.

Also don’t you get paranoid to see 0 BTC in there? even if the watch-only online wallet shows the funds, it just feels weird.

miner configuration – How to detect data insertion transactions in Bitcoin Blockchain?


Your privacy


By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.




MySQL Replication stop after a huge amount of transactions on Master

Running MySQL 8 for months now, without much troubles, I still have randomly some problem of replication between the Master and its Slave.

mysql> show master statusG
*************************** 1. row ***************************
             File: mysql-bin.003987
         Position: 82938366
     Binlog_Do_DB: main_db,old_db,metabase
 Binlog_Ignore_DB:
Executed_Gtid_Set:
1 row in set (0.00 sec)

While I have this for the Slave:

mysql> show replica  statusG
*************************** 1. row ***************************
             Replica_IO_State: Waiting for master to send event
                  Source_Host: xx.xx.xx.xx
                  Source_User: reporting-slave
                  Source_Port: 3306
                Connect_Retry: 60
              Source_Log_File: mysql-bin.003987
          Read_Source_Log_Pos: 80302413
               Relay_Log_File: mysql-relay-bin.001414
                Relay_Log_Pos: 103664748
        Relay_Source_Log_File: mysql-bin.003949
           Replica_IO_Running: Yes
          Replica_SQL_Running: No
              Replicate_Do_DB:
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 0
                   Last_Error:
                 Skip_Counter: 0
          Exec_Source_Log_Pos: 103664533
              Relay_Log_Space: 4108295738
              Until_Condition: None
               Until_Log_File:
                Until_Log_Pos: 0
           Source_SSL_Allowed: No
           Source_SSL_CA_File:
           Source_SSL_CA_Path:
              Source_SSL_Cert:
            Source_SSL_Cipher:
               Source_SSL_Key:
        Seconds_Behind_Source: NULL
Source_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error:
               Last_SQL_Errno: 0
               Last_SQL_Error:
  Replicate_Ignore_Server_Ids:
             Source_Server_Id: 1
                  Source_UUID: 553a1b76-ec6d-11ea-a311-fa163e097e80
             Source_Info_File: mysql.slave_master_info
                    SQL_Delay: 0
          SQL_Remaining_Delay: NULL
    Replica_SQL_Running_State:
           Source_Retry_Count: 86400
                  Source_Bind:
      Last_IO_Error_Timestamp:
     Last_SQL_Error_Timestamp:
               Source_SSL_Crl:
           Source_SSL_Crlpath:
           Retrieved_Gtid_Set:
            Executed_Gtid_Set:
                Auto_Position: 0
         Replicate_Rewrite_DB:
                 Channel_Name:
           Source_TLS_Version:
       Source_public_key_path:
        Get_Source_public_key: 0
            Network_Namespace:
1 row in set (0.00 sec)

and

mysql> SHOW RELAYLOG EVENTSg
+------------------------+-----+----------------+-----------+-------------+----------------------------------------------------+
| Log_name               | Pos | Event_type     | Server_id | End_log_pos | Info                                               |
+------------------------+-----+----------------+-----------+-------------+----------------------------------------------------+
| mysql-relay-bin.001416 |   4 | Format_desc    |         2 |         125 | Server ver: 8.0.22-0ubuntu0.20.04.2, Binlog ver: 4 |
| mysql-relay-bin.001416 | 125 | Previous_gtids |         2 |         156 |                                                    |
| mysql-relay-bin.001416 | 156 | Rotate         |         1 |   107184471 | mysql-bin.003950;pos=4                             |
| mysql-relay-bin.001416 | 203 | Rotate         |         2 |         256 | mysql-relay-bin.001417;pos=4                       |
+------------------------+-----+----------------+-----------+-------------+----------------------------------------------------+
4 rows in set (0.00 sec)

I know how to fix it, by stoping the replication, then dumping again the master, and reimport the whole stuff, however, the Database is huge, even with an high speed connection between those 2 servers, it may takes over half an hour to reimport the Database on the Replication Server.

Here are my questions:

  1. Is the command SHOW RELAYLOG EVENTS can really explain a replication from being stucked? It seems to be ok the position is really different between master and slave
  2. Is there a way, to let MySQL 8 go forward and leave this state of not replicated any more?
  3. It seems this issue occurs when I have to handle a large amount of traffic on the server (we are recording Live sessions for Sportsmen), but I still don’t understand why it stops like that randomly. Is there anything I could change in the whole Replication Configuration, to prevent us from this issue?

Thanks for any tips

transactions – Sending “generalized” secret messages over LN using “Lightning messages”

In the Mastering Lightning Network book section 3, it describes the Lightning Network as being “… so much more than the cryptographic protocols on top of the Bitcoin scripting language. It is a comprehensive communication protocol that allows peers to exchange Lightning messages to achieve the transfer of bitcoin. The communication protocol defines how Lightning messages are encrypted and exchanged.”

My question is: can Lightning messages be leveraged for purposes other than “to achieve the transfer of bitcoin” (i.e. generalized communication messages)? Can Lightning messages be sent over the network using the LN protocol to an address of, for example, a friend of yours? Seems like the network could have an extendable purpose in this way; however, since I am new to the LN and learning as I go, I’m unsure of the technical feasibility of this.

transactions – Possible to secret messages to other LN nodes over the LN using “Lightning messages” for purposes other than the “transfer of bitcoin?”

In the Mastering Lightning Network book section 3, it describes the Lightning Network as being “… so much more than the cryptographic protocols on top of the Bitcoin scripting language. It is a comprehensive communication protocol that allows peers to exchange Lightning messages to achieve the transfer of bitcoin. The communication protocol defines how Lightning messages are encrypted and exchanged.”

My question is: can this protocol be leveraged for generalized communication other than sending bitcoin transfer information? Can messages to friends be encrypted and sent using the protocol as well? Seems like the network could have extendable purpose in this way; however, since I am new to the LN and learning as I go, I’m unsure of the technical feasibility of this.

postgresql – How can I design efficient db for fund transactions?

I was thinking about a simple fund transaction from one user to another. All users will be on one table and transactons on another table. But could not figure out what is the efficient way to show a user‘s all (send & received) transactions in one row.

How can I join them at one table like to get something like this

  {
    "user_id": "1",
    "user_name ": "aaa",
    "transactions": (
      {
        "tx_id": 1,
        "tx_amount": 5.00,
        "tx_to_user": 3
      },
      {
        "tx_id": 3,
        "tx_amount": 1.00,
        "tx_from_user": 2
      },
    ),
  }

Users Table

+---------+-----------+--------------+
| user_id | user_name | user_balance |
+---------+-----------+--------------+
| 1       | aaa       | 10.00        |
+---------+-----------+--------------+
| 2       | bbb       | 50.00        |
+---------+-----------+--------------+
| 3       | ccc       | 40.00        |
+---------+-----------+--------------+

Transactions Table

+-------+--------------+------------+-----------+
| tx_id | tx_from_user | tx_to_user | tx_amount |
+-------+--------------+------------+-----------+
| 1     | 1            | 3          | 5.00      |
+-------+--------------+------------+-----------+
| 2     | 3            | 2          | 1.00      |
+-------+--------------+------------+-----------+
| 3     | 2            | 1          | 1.00      |
+-------+--------------+------------+-----------+

Am learning with Express and Postgres. Thanks ❤

Finding all BTC transactions from Dec,2017

I am doing a research and for that i need all successful BTC transactions that happened in Dec,2017. Is there a way to download this data ?

javascript – Bitcore-Lib generate OmniLayer Transactions

I am trying to create OmniLayer Transaction with Bitcore-Lib , but the OP_RETURN format using Bitcore-Lib Transaction.addData() like:

const simple_send = (
        "6f6d6e69", // omni 4bytes
        "0000", //Version: 0 : 2bytes
        "0000", // Type : 0 : 2bytes
        property_id.toString(16).padStart(8,'0') , // PropertyID : 4bytes
        (property_amount*100000000).toString(16).padStart(16,'0') // Amount: 8Bytes
    ).join('')

and addthis data in the transaction as:

const tx = new Transaction()
            .from(utxos)
            .addData(simple_send);

But it generates transaction data (in Explorer) as (Using Property_id = 1 and amount as 1):

OP_RETURN (6f6d6e69000000000000000000010000000005f5e100)

In raw transaction it comes out as :

OP_RETURN 3666366436653639303030303030303030303030303030303030303430303030303030303035663565313030

Instead of expected:

OP_RETURN 6f6d6e6900000000000000040000000005f5e100

I believe the encoding is not proper but not sure how to get it correct , as i have tried few things already to get the correct OP_RETURN

transactions – Send bitcoins directly from exchange to vendor

You should be able to as long as the vendor provides you with a BTC address in a format that the exchange you’re using supports.

Also, some exchanges are known to censor transactions to some addresses, so there’s a slight chance your payment might get denied. That’s a risk you take when sending from a custodial exchange… not your keys, not your coins. On the flip side, if the exchange pays the outgoing bitcoin network fee, you’ll save that cost.

Hopefully it will work for you.

transactions – Help analyzing this color coded hexdump of the Bitcoin blockchain

Sample of genesis, growth, and current height
blk0_10_2655.dat

Sample of the latter part and the end of blk02655.dat. This probably covers parts of the last 10000 blocks.
blk02655.dat

Process here:
https://twitter.com/bitcoinanatomy/status/1416891318232551428?s=20

$ pip install pixd
$ python -m pixd path/blk00000.dat

https://pypi.org/project/pixd/

Trying to understand:

  • How many bytes per line and how 1MB looks
  • Recognizing block headers, transaction data,
  • Categorizing the patterns found
  • Confirm order of blocks
  • Locate special blocks and transactions (first segwit block, first transaction, batch transactions, multisig, coinjoins, LN channel opens)

Anyone else curious?

Thanks!