Pages:
Author

Topic: [ANNOUNCE] Abe 0.7: Open Source Block Explorer Knockoff - page 23. (Read 221031 times)

member
Activity: 90
Merit: 10
Hi,

is the blobk.block_nTime and block.block_ss_destroyed is the data for Bitcoin Days Destroyed?

But strange most of the block.block_ss_destroyed is NULL

TIA,

Mike
member
Activity: 90
Merit: 10
Guys,

ive been running this for 10 days now. The current `block`.`block_nTime`  is 2013-05-13 23:35:31

Is there anyway i can make it faster?

TIA,

Mike
legendary
Activity: 1792
Merit: 1008
/dev/null
Hi! I have a problem with ppcoin. Quantities seems to require a 100 multiplication to be right. For example, a transaction that ABE stores as 0.100 should be 0.100*100= 10 PPC

With bitcoin, litecoin and testnet ABE works very well

PS: I'm using the ppcoin branch merged to the master from git


This problem still exists. For example, http://ppc.cryptocoinexplorer.com/address/PLifetQ51s7WYHr4WCdHmWaALUzyWNmXdP needs a 100 multiplication on all values.
still exists -.-
anyone got a solution?

EDIT: nvm. hotfix -> https://github.com/bitcoin-abe/bitcoin-abe/issues/48#issuecomment-31317058
newbie
Activity: 28
Merit: 0
was this ever completed?
member
Activity: 90
Merit: 10
Hi,

how may i know if its working correctly.

Currently

[root@CentOS-63-64-minimal bitcoin-abe]# python -m Abe.abe --config abe.conf
no chain_id
catch_up_rpc: abort
Opened /root/.bitcoin/blocks/blk00000.dat
Abe initialized.
Listening on http://localhost:2750
...then stops here

Is this correct i mean its downloading block or something?

Thanks,

Mike


ok, seems working now, i saw some display

commit
block_tx 3658 3714
commit
block_tx 3659 3715
commit
block_tx 3660 3716
commit
block_tx 3661 3717
commit
block_tx 3662 3718
commit
...

question, possible i can get data of bitcoins days destroyed?

Thanks,

Mike

Guys,

anyone who can help me if ABE, possible i can get data of bitcoins days destroyed?

Thanks,

Mike
member
Activity: 76
Merit: 10
Hi! I have a problem with ppcoin. Quantities seems to require a 100 multiplication to be right. For example, a transaction that ABE stores as 0.100 should be 0.100*100= 10 PPC

With bitcoin, litecoin and testnet ABE works very well

PS: I'm using the ppcoin branch merged to the master from git


This problem still exists. For example, http://ppc.cryptocoinexplorer.com/address/PLifetQ51s7WYHr4WCdHmWaALUzyWNmXdP needs a 100 multiplication on all values.
member
Activity: 90
Merit: 10
Hi,

how may i know if its working correctly.

Currently

[root@CentOS-63-64-minimal bitcoin-abe]# python -m Abe.abe --config abe.conf
no chain_id
catch_up_rpc: abort
Opened /root/.bitcoin/blocks/blk00000.dat
Abe initialized.
Listening on http://localhost:2750
...then stops here

Is this correct i mean its downloading block or something?

Thanks,

Mike


ok, seems working now, i saw some display

commit
block_tx 3658 3714
commit
block_tx 3659 3715
commit
block_tx 3660 3716
commit
block_tx 3661 3717
commit
block_tx 3662 3718
commit
...

question, possible i can get data of bitcoins days destroyed?

Thanks,

Mike
member
Activity: 90
Merit: 10
Hi,

how may i know if its working correctly.

Currently

[root@CentOS-63-64-minimal bitcoin-abe]# python -m Abe.abe --config abe.conf
no chain_id
catch_up_rpc: abort
Opened /root/.bitcoin/blocks/blk00000.dat
Abe initialized.
Listening on http://localhost:2750
...then stops here

Is this correct i mean its downloading block or something?

Thanks,

Mike
newbie
Activity: 18
Merit: 0
I love abe and it is giving me some incredible capabilities. Thank you for developing it!

Here is a bug report and a recommendation. 
There is an error in how chain summary generates the table. You can see this at block_id 278440 the block_height 278271 skips to 278160. Also as a comment would be convenient if abe.block had the previous block hash, allowing construction of the chain from one db entry.
newbie
Activity: 12
Merit: 0
Hi again.

The problem appears to be in the big size of pubkey table. Aprox 24.270.000 inputs, so mysqld can't handle it and go away.

I have an small amazon ec2 ubuntu server 13.10 64bits with 300Gb HDD. The only difference I can see is that some days ago I was using a 1Tb HDD instead of 300Gb but there are some space remaining yet in 300Gb HDD.

For example:
SELECT COUNT(*) FROM pubkey = MySQL Server gone away
SELECT * FROM pubkey LIMIT 10000000 (aprox half of data amount) =  Output data without problems.

Some idea?? Thanks again.

newbie
Activity: 12
Merit: 0
Hi, and happy new year.

Everything was working fine with abe, and I had to stop it for some days. We are talking about an Ubuntu 13.10 Server on Amazon EC2 small with mysql server running on it (not RDS) and apache (think is not important) and a 300Gb Volume.

Now when I try to restart (sudo python -m Abe.abe --config abe-my.conf) I'm getting this error:

Code:
catch_up_rpc: abort
Opened /home/ubuntu/.bitcoin/blocks/blk00105.dat
Exception at 62110992
Failed to catch up {'blkfile_offset': 61209101, 'blkfile_number': 100105, 'chain_id': None, 'loader': None, 'dirname': '/home/ubuntu/.bitcoin', 'id': Decimal('1')}
Traceback (most recent call last):
  File "Abe/DataStore.py", line 2639, in catch_up
    store.catch_up_dir(dircfg)
  File "Abe/DataStore.py", line 2897, in catch_up_dir
    store.import_blkdat(dircfg, ds, blkfile['name'])
  File "Abe/DataStore.py", line 3027, in import_blkdat
    store.import_block(b, chain_ids = chain_ids)
  File "Abe/DataStore.py", line 1741, in import_block
    tx['tx_id'] = store.import_tx(tx, pos == 0)
  File "Abe/DataStore.py", line 2195, in import_tx
    pubkey_id = store.script_to_pubkey_id(txout['scriptPubKey'])
  File "Abe/DataStore.py", line 2563, in script_to_pubkey_id
    return store.pubkey_hash_to_id(match.group(1))
  File "Abe/DataStore.py", line 2596, in pubkey_hash_to_id
    return store._pubkey_id(pubkey_hash, None)
  File "Abe/DataStore.py", line 2607, in _pubkey_id
    WHERE pubkey_hash = ?""", (dbhash,))
  File "Abe/DataStore.py", line 638, in selectrow
    store.sql(stmt, params)
  File "Abe/DataStore.py", line 510, in sql
    store._execute(cached, params)
  File "Abe/DataStore.py", line 487, in _execute
    store.cursor.execute(stmt, params)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
OperationalError: (2013, 'Lost connection to MySQL server during query')
Reconnecting after rollback error: (2006, 'MySQL server has gone away')
Reconnecting to database.
Traceback (most recent call last):
  File "/usr/lib/python2.7/runpy.py", line 162, in _run_module_as_main
    "__main__", fname, loader, pkg_name)
  File "/usr/lib/python2.7/runpy.py", line 72, in _run_code
    exec code in run_globals
  File "/var/www/abe/Abe/abe.py", line 2248, in
    sys.exit(main(sys.argv[1:]))
  File "/var/www/abe/Abe/abe.py", line 2242, in main
    store = make_store(args)
  File "/var/www/abe/Abe/abe.py", line 157, in make_store
    store.catch_up()
  File "Abe/DataStore.py", line 2647, in catch_up
    store.rollback()
  File "Abe/DataStore.py", line 871, in rollback
    store.reconnect()
  File "Abe/DataStore.py", line 271, in reconnect
    store.init_conn()
  File "Abe/DataStore.py", line 213, in init_conn
    store.conn = store.connect()
  File "Abe/DataStore.py", line 224, in connect
    conn = store._connect(cargs)
  File "Abe/DataStore.py", line 256, in _connect
    return store.module.connect(**cargs)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/__init__.py", line 81, in Connect
    return Connection(*args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 187, in __init__
    super(Connection, self).__init__(*args, **kwargs2)
_mysql_exceptions.OperationalError: (2002, "Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)")

Mysql server is running, I can access trough mysql -u user -p and show my tables and databases, insert, select, etc. I can do it trough a python script, so I think is not a problem with python or mysql server.

I tried this too:
Code:
sudo find / -name '*.sock'
/run/mysqld/mysqld.sock
sudo ln -s /run/mysqld/mysqld.sock /var/run/mysqld/mysqld.sock
ln: failed to create symbolic link ‘/var/run/mysqld/mysqld.sock’: File exists

So, I'm a little bit lost... Of course, I restarted mysql server sometimes, and entire server, and nothing...

Any idea?? Thanks a lot.
donator
Activity: 2772
Merit: 1019
Hello,

I really miss my abe database since I threw it away.

I've been trying to rebuild it from scratch, but starting around block 180,000 it gets really really slow (something like 1000 blocks per night). It seems almost undoable.

I'm using postgres and increased the buffers generously.

Is this (1000 block per 8 hours) a speed that can be confirmed by others?

Any suggestions as to what I could do to speed up the process?
full member
Activity: 182
Merit: 100
I can setup and run Abe successfully. (All blocks are loaded during installation)

However, it just shows 0 block at homepage. Is there anything wrong? Embarrassed

Details can be find here:
https://github.com/bitcoin-abe/bitcoin-abe/issues/49

Using "ppcoin" branch.
newbie
Activity: 26
Merit: 0
Hi! I have a problem with ppcoin. Quantities seems to require a 100 multiplication to be right. For example, a transaction that ABE stores as 0.100 should be 0.100*100= 10 PPC

With bitcoin, litecoin and testnet ABE works very well

PS: I'm using the ppcoin branch merged to the master from git


How did you get past this ?
Chain not found for magic number e6e8e9e5 in block file /home/dirrk/.ppcoin/blk0001.dat at offset 0.[/u][/u]



Nevermind I was able to fix the issue.  I was not using the peercoin branch.  Now my issue is that the address are in the wrong format.  I changed the config to reference the 0x0037 type but it still displays incorrectly.  I am rebuilding the database now in hopes that it will fix it.
full member
Activity: 547
Merit: 105
Bitcoin ya no es el futuro, es el presente
Hi! I have a problem with ppcoin. Quantities seems to require a 100 multiplication to be right. For example, a transaction that ABE stores as 0.100 should be 0.100*100= 10 PPC

With bitcoin, litecoin and testnet ABE works very well

PS: I'm using the ppcoin branch merged to the master from git
legendary
Activity: 1001
Merit: 1005
... OSX doesn't like python...

Neither does windows. I lost a weekend too but could not get pycrypto to install. So in the end .. no abe.
A java version would be awesome!
legendary
Activity: 1001
Merit: 1005
How realtime are Abe's updates?

Anyone willing to run "Abe as a service" for various alt coins? Its too much resources for me to host Abe but I need a private instance running all the time.
legendary
Activity: 1792
Merit: 1008
/dev/null
4 days
SSD/i7 2600 16Gb ram
mysql InnoDb
bitcoin base
current on: block_tx 206973 8681883
is this ok?
Can anybody upload the dump of bitcoin mysql database. Would be very grateful.
Or share your my.ini settings  , maybe I'am something doing wrong.
Btw, i'am using this command line options :
 --commit-bytes=1000000
so sad... use tmpfs!
newbie
Activity: 18
Merit: 0
FWIW, I got abe up and running natively on Mac OS 10.9. It was painful, OSX doesn't like python... I lost a weekend, if anyone wants a discussion of how and what I used to get the binaries compiled give me a shout.

Abe through MySQL allows me to directly access the database using Mathematica for data analytics.  Very nice tool.  Thanks John!

BTW, where is the data for the number of bitcoins in circulation? I can't seem to find the correct db location.
member
Activity: 98
Merit: 10
nearly dead
4 days

4 days for starting up this block explorer ? I wasn't aware it was that slow.
Pages:
Jump to: