🤖[ANN][BIS]Bismuth 2.0 - Beyond DeFi - page 127.

yousaid

newbie

Activity: 2

Merit: 0

Quote from: prix on August 24, 2017, 08:50:33 PM

Quote from: yousaid on August 24, 2017, 06:58:22 PM

I keep getting this error when trying to run Node on Windows: execute(227) Retrying database execute due to no such table: transactions

I've tried removing and reinstalling the latest version (3.926). I also tried installing it on a different machine and I still get that same error. ledger.db & mempool.db both exist, but are only 1kb & 2kb, respectively. I'm guessing they just aren't updating. Any ideas?

I got same error once. The problem was in the mempool.db, it was empty.
I added the table using sqliteadmin:

Code:

CREATE TABLE transactions (timestamp, address, recipient, amount, signature, public_key, keep, openfield)

If it difficult, you can ask devs in the slack to upload a correct mempool.db to github.
Or you should try move ledger.db to another place (or delete it if it empty) and run node. Maybe it's work, but I don't not sure.
At least in the sources there is a file genesis.py which check only ledger.db and if it found the mempool.db will not be initialized.
But I don't know the node use this code or not.

P.S. https://ufile.io/z0q0g - mempool.db with table, 2KB - press "slow download (free)"

Thank you so much for the help! I checked mempool.db and the transactions table was in there. I ended up deleting ledger.db and mempool.db again. I'm not sure what changed, but this time it was able to rebuild.

Thanks again!

Islapdonkey

sr. member

Activity: 882

Merit: 277

If i had a dollar for every "had i known"

Quote from: mig6r on August 25, 2017, 12:20:41 AM

Quote from: Islapdonkey on August 25, 2017, 12:16:31 AM

I can't wait for this to hit the exchange. The mass wake up call to this miners with regards to price will be too real. Yes Jesus! I will be waiting downstream.

Is this coin on no exchange so far? Bittrex requires a fee I think.

it's not on an exchange yet but it seems that it might be heading to Topia really soon.

mig6r

sr. member

Activity: 826

Merit: 250

Quote from: Islapdonkey on August 25, 2017, 12:16:31 AM

I can't wait for this to hit the exchange. The mass wake up call to this miners with regards to price will be too real. Yes Jesus! I will be waiting downstream.

Is this coin on no exchange so far? Bittrex requires a fee I think.

Islapdonkey

sr. member

Activity: 882

Merit: 277

If i had a dollar for every "had i known"

I can't wait for this to hit the exchange. The mass wake up call to this miners with regards to price will be too real. Yes Jesus! I will be waiting downstream.

forzendiablo

legendary

Activity: 1526

Merit: 1000

the grandpa of cryptos

can we get bittrex now or so? coin is mature enough imo

prix

hero member

Activity: 750

Merit: 511

Quote from: yousaid on August 24, 2017, 06:58:22 PM

I keep getting this error when trying to run Node on Windows: execute(227) Retrying database execute due to no such table: transactions

I've tried removing and reinstalling the latest version (3.926). I also tried installing it on a different machine and I still get that same error. ledger.db & mempool.db both exist, but are only 1kb & 2kb, respectively. I'm guessing they just aren't updating. Any ideas?

I got same error once. The problem was in the mempool.db, it was empty.
I added the table using sqliteadmin:

Code:

CREATE TABLE transactions (timestamp, address, recipient, amount, signature, public_key, keep, openfield)

If it difficult, you can ask devs in the slack to upload a correct mempool.db to github.
Or you should try move ledger.db to another place (or delete it if it empty) and run node. Maybe it's work, but I don't not sure.
At least in the sources there is a file genesis.py which check only ledger.db and if it found the mempool.db will not be initialized.
But I don't know the node use this code or not.

P.S. https://ufile.io/z0q0g - mempool.db with table, 2KB - press "slow download (free)"

yousaid

newbie

Activity: 2

Merit: 0

I keep getting this error when trying to run Node on Windows: execute(227) Retrying database execute due to no such table: transactions

I've tried removing and reinstalling the latest version (3.926). I also tried installing it on a different machine and I still get that same error. ledger.db & mempool.db both exist, but are only 1kb & 2kb, respectively. I'm guessing they just aren't updating. Any ideas?

cyberspacemonkey

legendary

Activity: 1288

Merit: 1002

Quote from: NoBit on August 24, 2017, 11:40:30 AM

Interesting times ahead

Finally. Many people are very eager to buy the coin and this gives a chance for GPU miners to dump their stash Grin

NoBit

sr. member

Activity: 326

Merit: 250

Interesting times ahead

philnatic

newbie

Activity: 1

Merit: 0

I have a problem with the connection of node.py. I can't connect any peers. I have also tried to delete ledger.db and I also tried the newest client. This is the output when I enable debugging:

Code:

xxx@xxx:~/Bismuth-3.957$ python3 node.py
2017-08-24 12:02:26,952 (91) Configuration settings loaded
2017-08-24 12:02:26,952 (1094) privkey.der found
2017-08-24 12:02:26,953 (1134) Local address: xxx
2017-08-24 12:02:26,954 ledger_convert(116) Converting ledger to Hyperblocks
2017-08-24 12:06:51,131 (1167) Moving database to RAM
2017-08-24 12:06:52,437 (1180) Moved database to RAM
2017-08-24 12:06:52,438 (1206) Starting up...
2017-08-24 12:06:52,823 (1987) Server loop running in thread: Thread-1
2017-08-24 12:06:52,824 manager(710) Will attempt to connect to 94.113.207.67:5658
2017-08-24 12:06:52,824 manager(713) ---Starting a client thread <_MainThread(MainThread, started 140178015856384)>---
2017-08-24 12:06:52,825 manager(710) Will attempt to connect to 78.28.250.56:5658
2017-08-24 12:06:52,825 manager(713) ---Starting a client thread <_MainThread(MainThread, started 140178015856384)>---
2017-08-24 12:06:52,826 manager(710) Will attempt to connect to 66.70.181.150:5658
2017-08-24 12:06:52,827 manager(713) ---Starting a client thread <_MainThread(MainThread, started 140178015856384)>---
2017-08-24 12:06:52,827 manager(710) Will attempt to connect to 78.28.250.81:5658
2017-08-24 12:06:52,828 manager(713) ---Starting a client thread <_MainThread(MainThread, started 140178015856384)>---
2017-08-24 12:06:52,828 manager(710) Will attempt to connect to 45.63.64.36:5658
2017-08-24 12:06:52,829 manager(713) ---Starting a client thread <_MainThread(MainThread, started 140178015856384)>---
2017-08-24 12:06:52,830 manager(719) Only 0 connections active, resetting the try list and banlist
2017-08-24 12:06:52,830 manager(724) Connection manager: Banlist: []
2017-08-24 12:06:52,831 manager(725) Connection manager: Syncing nodes: []
2017-08-24 12:06:52,831 manager(726) Connection manager: Syncing nodes: 0/3
2017-08-24 12:06:52,831 manager(727) Connection manager: Database locked: False
2017-08-24 12:06:52,831 manager(728) Connection manager: Threads at 7 / 150
2017-08-24 12:06:52,831 manager(729) Connection manager: Tried: []
2017-08-24 12:06:52,832 manager(730) Connection manager: List of outgoing connections: []
2017-08-24 12:06:52,832 manager(731) Connection manager: Number of outgoing connections: 0
2017-08-24 12:06:52,854 manager(740) Connection manager: Last block was generated 15.94 minutes ago
2017-08-24 12:06:52,869 worker(1667) Outgoing: Connected to 78.28.250.56:5658
2017-08-24 12:06:52,870 worker(1687) Could not connect to 78.28.250.56:5658 because 'NoneType' object is not subscriptable
2017-08-24 12:06:52,871 worker(1667) Outgoing: Connected to 78.28.250.81:5658
2017-08-24 12:06:52,872 worker(1687) Could not connect to 78.28.250.81:5658 because 'NoneType' object is not subscriptable
2017-08-24 12:06:52,880 worker(1667) Outgoing: Connected to 94.113.207.67:5658
2017-08-24 12:06:52,881 worker(1687) Could not connect to 94.113.207.67:5658 because 'NoneType' object is not subscriptable
2017-08-24 12:06:52,937 worker(1667) Outgoing: Connected to 66.70.181.150:5658
2017-08-24 12:06:52,938 worker(1687) Could not connect to 66.70.181.150:5658 because 'NoneType' object is not subscriptable
2017-08-24 12:06:52,943 worker(1667) Outgoing: Connected to 45.63.64.36:5658
2017-08-24 12:06:52,944 worker(1687) Could not connect to 45.63.64.36:5658 because 'NoneType' object is not subscriptable
2017-08-24 12:07:52,904 manager(710) Will attempt to connect to 94.113.207.67:5658

Dies anyone know how to fix this issue?

Greets,
philnatic

NoBit

sr. member

Activity: 326

Merit: 250

Quote from: kiddo on August 23, 2017, 01:38:23 AM

Quote from: NoBit on August 23, 2017, 01:04:39 AM

Quote from: aziernest on August 17, 2017, 02:48:37 PM

I am seeing every pool going up and down randomly, any stats for pool uptime? and which pool is most reliable and stable?

Acc-pool is pretty reliable lately.

Can anyone tell me since when is the mainnet live?

Mainnet is live from May 1, 2017. Did the payout of the acc-pool return to the normal? I know the payout was to low like a week ago and I stopped mining Bismuth.

the payout is low because the difficulty is now stable and higher than before.

kiddo

full member

Activity: 546

Merit: 137

Quote from: NoBit on August 23, 2017, 01:04:39 AM

Quote from: aziernest on August 17, 2017, 02:48:37 PM

I am seeing every pool going up and down randomly, any stats for pool uptime? and which pool is most reliable and stable?

Acc-pool is pretty reliable lately.

Can anyone tell me since when is the mainnet live?

Mainnet is live from May 1, 2017. Did the payout of the acc-pool return to the normal? I know the payout was to low like a week ago and I stopped mining Bismuth.

NoBit

sr. member

Activity: 326

Merit: 250