Database, stability, Bitcoin fixes

NOTE:
See v1.3.3 release notes regarding database reshaping and Windows EXE-wrapper updating!

Changes in this release:

• RU translations thanks to Alexander45
• Fix for Bitcoin P2SH-B dust issue
• Revert back from HSQLDB v2.5.1 to HSQLDB v2.5.0-fixed pending research into out-of-memory issue
• Bitcoin refunds now sent back to first unused wallet 'receive' address instead of address derived from tradePrivateKey
• Updated ElectrumX nodes list thanks to tcallahan14 (pull request #16)
• Improved handling of chain comparison during synchronization where blocks signed by subsequently cancelled reward-share
• Improved trade SQL queries
• Reduced BlockMinter log spam
• Refactored websockets for UI to reduce load

qortal.jar

If built using OpenJDK 11:
MD5: 1bc3c41634d805120702624064afe6ea
SHA1: fc555aaa40a225ab76c483d8b82e697c302b82bd
SHA256: 60aa03bc85c3d145b5ec75e27e10790531f044a54c5e8f504d4144368ab4e6a0

Qortal-1.3.4.exe

MD5: 8fc24a0a11e58278fa50c614174fd760
SHA1: f5ed42ab4e0d6bdc72379cd4cbc8b2701290f48f
SHA256: e6f2da3222f7ef8ce035a4b99bf594eabae6c6d00e3e1a8345fe5ca20591a320

VirusTotal report for Qortal-1.3.4.exe

qortal-1.3.4.zip

Contains bare minimum of:

• built qortal.jar
• log4j2.properties from git repo
• run.sh from git repo
• printf "{\n}\n" > settings.json

All timestamps set to same date-time as commit, obtained via git show --no-patch --format=%cI
Packed with 7z a -r -tzip qortal-1.3.4.zip qortal/

MD5: d978d895fb3269ea55435ce879dd42ce
SHA1: 2333749a9a1aa99b84964d969dffb1ba9d10f911
SHA256: 9e4e15a494e14e7bf18c30c85aed1daa06c9365e33d313e401b0d09411348513

API bug-fix and other minor (partial release)

NOTE:
If you have an existing pre-v1.3.1 then the first start-up of v1.3.2 will "reshape" your database.
This can take some time, varying from about 30 seconds with high-powered desktops to even 30 minutes with low-powered devices or older computers.

If you look at your log files (e.g. log.txt.1), database reshaping occurs when you will see this line:
2020-08-12 16:57:38 INFO Controller:308 - Starting repository
and is finished when this line appears (which should be next):
2020-08-12 16:59:38 INFO HSQLDBDatabaseUpdates:660 - HSQLDB repository updated to version 23

If you interrupt this process, there is a chance your database will end up corrupt.

UPDATING (Windows users)
Because of the change to the EXE wrapper that starts Qortal on Windows machines, you are advised to download and launch the Windows installer at your earliest convenience!

Changes in this release:

• Fix for slow API call GET /crosschain/trades due to slow SQL query
• Added minimumTimestamp param to above API call
• Fixed race condition between Network.start() and Controller calling Network.prunePeers() resulting in NPE
• Modified ApplyUpdate (2nd stage of auto-update) to pass JVM heap options to Windows launcher EXE

CPU improvements, especially for Windows users!

NOTE:
If you have an existing pre-v1.3.1 then the first start-up of v1.3.2 will "reshape" your database.
This can take some time, varying from about 30 seconds with high-powered desktops to even 30 minutes with low-powered devices or older computers.

If you look at your log files (e.g. log.txt.1), database reshaping occurs when you will see this line:
2020-08-12 16:57:38 INFO Controller:308 - Starting repository
and is finished when this line appears (which should be next):
2020-08-12 16:59:38 INFO HSQLDBDatabaseUpdates:660 - HSQLDB repository updated to version 23

If you interrupt this process, there is a chance your database will end up corrupt.

UPDATING (Windows users)
Because of the change to the EXE wrapper that starts Qortal on Windows machines, it is not enough to simply replace the JAR, you actually need to download and run the latest installer (below).

Changes in this release:

• The EXE wrapper provided by the Windows installer run starts Java JVM in 'server' context, allowing use of more than 256MB!
• Auto-updates after v1.3.2 will not create a database backup unless enabled in settings
• HSQLDB CHECKPOINT commands added between each DB-reshape statement to reduce risk of failure
• Start-up blockchain validity checking restricted to top 1440 blocks (for now) for faster start-up
• Improved HSQLDB query relating to fetching AT state data
• More efficient CIYAM AT v1.3.7 with reduced byte-array copying and other improvements

qortal.jar

If built using OpenJDK 11:
MD5: 0211a4d4448f0e140399036741cba590
SHA1: 69568028cb7c30b8c9c284d509304d74fe60bcef
SHA256: 88bf5e24b13ce67199a6f3d21da25e230affe07d0897204bc9fdca845003dc73

Qortal-1.3.2.exe

MD5: 31e97acdda4e21d931e27293b8be617b
SHA1: 698432b876a327619e02beb4b1334718c1555bd4
SHA256: 3082201360fdbb87830945e900509160abbaad295c0b5d27848c6165bcb22aa7

VirusTotal report for Qortal-1.3.2.exe

qortal-1.3.2.zip

Contains bare minimum of:

• built qortal.jar
• log4j2.properties from git repo
• run.sh from git repo
• printf "{\n}\n" > settings.json

All timestamps set to same date-time as commit, obtained via git show --no-patch --format=%cI
Packed with 7z a -r -tzip qortal-1.3.2.zip qortal/

MD5: ca6763cb0219c3e1594f00a2bab595dc
SHA1: e30e0894039367d7bfa10a925e3714d5da672264
SHA256: a69369806d6f2b1eb923d2dc4846ac5d5f7276fb2d6a1f7a768de3ab319fd11e

db-bootstrap-58239.zip

This is a 'bootstrap' database containing blockchain up to block height 58239.
This is for new installations to avoid the time/hassle of synchronizing your node from scratch.
WARNING: If you have any active, or on-going, trades then these will be lost if you replace your DB!
It has no minting accounts added, so if you have a minting account you need to re-add this via UI or API.
It has an initial list of various community-run peers to help connect your node to the network.

The ZIP file contains:

• db/blockchain.data (1.4GB)
• db/blockchain.properties (99B)
• db/blockchain.script (33K)

For Windows users, unpack into %LOCALAPPDATA%\Qortal\ folder.
For other users, unpack while in the same folder as qortal.jar.
In both cases, you should end up with a db folder with the actual files inside.

v1.3.1

NOTE:
If you have an existing pre-v1.3.1 then the first start-up of v1.3.1 will "reshape" your database.
This can take some time, varying from about 30 seconds with high-powered desktops to even 30 minutes with low-powered devices or older computers.

If you look at your log files (e.g. log.txt.1), database reshaping occurs when you will see this line:
2020-08-10 12:57:38 INFO Controller:308 - Starting repository
and is finished when this line appears (which should be next):
2020-08-10 12:59:38 INFO HSQLDBDatabaseUpdates:655 - HSQLDB repository updated to version 23

If you interrupt this process, there is a chance your database will end up corrupt.

Changes in this release:

• Updated CIYAM AT subsystem to use lambda-based logging, reducing CPU load if logging disabled
• Reworked synchronizer strategy when switching chains to reduce work
• Converted HSQLDB LOBs to VARBINARYs to reduce DB workload and space usage
• Disabled peer-buffer dealloc to reduce GC pressure
• Reduced network handshake PoW requirements for v1.3.1+ peers
• Caching of top two blocks' "online accounts data" to reduce Ed25519 verifications
• Added a form of "block unknown" response to avoid peer timeouts/disconnections

qortal.jar

If built using OpenJDK 11:
MD5: 141fbd15a351f181dce9e7304f7e22d5
SHA1: dc986a30ce2bc58284f0d5892546fb236c7bc3e1
SHA256: 03e6a659868a53cb715264674d33b672db6f939c8d12360d0908393043cee8b5

Qortal-1.3.1.exe

MD5: 123a7d8ffead1dcff9fef306717a8274
SHA1: 69c92504d8d3c097523ba5e1f24f6a691a78493e
SHA256: 22b8a2350fb01128d2467e0b6b95b6b3594a49fdac5c0cb023de804cf178f4ad

VirusTotal report for Qortal-1.3.1.exe

qortal-1.3.1.zip

Contains bare minimum of:

• built qortal.jar
• log4j2.properties from git repo
• run.sh from git repo
• printf "{\n}\n" > settings.json

All timestamps set to same date-time as commit, obtained via git show --no-patch --format=%cI
Packed with 7z a -r -tzip qortal-1.3.1.zip qortal/

MD5: ace64310e6f26782860848d9028875f2
SHA1: e09f5dae0fc2fdf9241ced4fa574c7355e1e497e
SHA256: ae489b6d61a20be47d10554cd5e9cb760bee8e303d166a2ae9793af448e7d38d

New feature: trade-portal! Based on commit 7bb0607

Changes in this release:

• Trade-portal

qortal.jar

If built using OpenJDK 11:
MD5: 83520fa0c57320a47db04f1dfc0d5a07
SHA1: 16ad73772a7b4e2bf54863281946225c7ff49471
SHA256: 84b8618ee8d7a1f4d2a0ba088e170a42a5dea2560a2d8646c1340d3026bbb993

Qortal-1.3.0.exe

MD5: 2b02d5e4f49f2a70674026c8204cf871
SHA1: ca31ebe68048bcfbed8b88499b43874f01519ee4
SHA256: 7481d778829736c0b195d917fac521af1e360436eab287f85df8b4d694e02d3e

VirusTotal report for Qortal-1.3.0.exe

qortal-1.3.0.zip

Contains bare minimum of:

• built qortal.jar
• log4j2.properties from git repo
• run.sh from git repo
• printf "{\n}\n" > settings.json

All timestamps set to same date-time as commit, obtained via git show --no-patch --format=%cI
Packed with 7z a -r -tzip qortal-1.3.0.zip qortal/

MD5: d51282332c8c668a2dd80d099c5242c6
SHA1: a45b85627891555cf4ce78105079bda251a8c0b5
SHA256: 8de063f7865aaee45870166f190ff6f86be31ec197cc6d325ad137e1a9953753

db-51243.zip

This is a 'bootstrap' database containing blockchain up to block height 51243.
WARNING: If you have any active, or on-going, trades then these will be lost if you replace your DB!
It has no minting accounts added, so if you have a minting account you need to re-add this via UI or API.
It has an initial list of various community-run peers to help connect your node to the network.

The ZIP file contains:

• db/blockchain.data (48M)
• db/blockchain.lobs (1.0G)
• db/blockchain.properties (99B)
• db/blockchain.script (18M)

For Windows users, unpack into %LOCALAPPDATA%\Qortal\ folder.
For other users, unpack while in the same folder as qortal.jar.
In both cases, you should end up with a db folder with the actual files inside.

Based on commit d81729d9

Changes in this release:

• Improved networking

qortal.jar

If built using OpenJDK 11:
MD5: 9912245ae4f8ce47ea3c621a69aa855a
SHA1: ea95b7f4d9dbb4ed91b548e3d9b191e71ff0c48e
SHA256: ed55d6a2a5f919dd6571b66abb9757fa7a22feed853078e552fb710b15e59f9e

Qortal-1.2.2.exe

MD5: 88d0e62a771915b9a4c16b8032040c76
SHA1: f2aa54a6175c20e3d1a4d7e3b78105449b874dd3
SHA256: 06b87c2f588901ad4adf27b12996b57a01a2e5070fa525c65da2a8f58630c29a

VirusTotal report for Qortal-1.2.2.exe

qortal-1.2.2.zip

Contains bare minimum of:

• built qortal.jar
• log4j2.properties from git repo
• run.sh from git repo
• printf "{\n}\n" > settings.json

All timestamps set to same date-time as commit, obtained via git show --no-patch --format=%cI
Packed with 7z a -r -tzip qortal-1.2.2.zip qortal/

MD5: 91d9dadafd084d57eb97e541f0fe65e0
SHA1: 1fe0dd804d237ef36208eef7cb4dd6c9ca859b82
SHA256: 4a9c454c8ef28e43441cecb8d16aa1d715699d5c7e66a3bf9a78fac850dc2444

Initial "genesis" / launch / go-live version!

This is the initial "genesis" / launch / go-live version!

qortal.jar

If built using OpenJDK 11:
MD5: 61cd8534f7208a46e1285ac7c149d6aa
SHA1: e70d0925ceb43d1b82d213685c2ed10e6603bdd3
SHA256: 9a8b459df888447762677cb9b9d584ace5551b685eb4c3f8dc11f6b1a412a000

Qortal-1.2.0.exe

MD5: 6dceba1f9342b0cd92f9e84eb737bb66
SHA1: 08f49ee2e0cec050ec75a37ae4062da062046ab9
SHA256: 7d295e13101260f51d78fcb5bb569f06c0ff1f9c299867ba68aa14794d1dfff9

VirusTotal report for Qortal-1.2.0.exe

qortal-1.2.0.zip

Contains bare minimum of:

• built qortal.jar
• log4j2.properties from git repo
• run.sh from git repo
• printf "{\n}\n" > settings.json

All timestamps set to same date-time as commit, obtained via git show --no-patch --format=%cI
Packed with 7z a -r -tzip qortal-1.2.0.zip qortal/

MD5: 85270c45803e98e2c083a2a67a051bd1
SHA1: 896b9f3aa31e72907358e1c5456b1d7931b3d385
SHA256: 425e8d25eded7913e8643cb3a362a54a7acca31bb58314f77b537ccfc18b889c