SolidCoin is on Abe: http://abe.john-edwin-tobey.org/Note: this site exists for demonstration purposes and will not handle heavy loads. Please consider hosting a copy of Abe. |
|
|
|
I have not seen anything like this has anyone else?
My miners are hosted, I don't have access to their logs. But I am seeing less than half the expected hash rate (3.25G) and a good deal of traffic to my failover pool. |
|
|
|
Thinking about also hosting a copycat of this... posting here to remind me to check up on it later.  If you do, it could be abe.john-edwin-tobey.org, since the hosting arrangement there is ending. I'm switching DNS back to my pathetic excuse for a server, but if it can't take the load, I'll punt to whoever wants to run it. Of course, anyone with serious uptime requirements is welcome to run a private or public instance. |
|
|
|
It returned this. C:\abe>python ab.py
at 169336263 of 698256440: '\x00\x00\x00\x00'
at 169394422: '\xf9\xbe\xb4\xd9'
Thanks. I've committed a fix that I think will get you past this error. I've had some problem with format_satoshis (worked around them by casting to UNSIGNED in the sql query)
The problem was that format_satoshis expected the caller to cast its first argument to int. I decided it would be better for the function to do the casting. (txout_value is in 1e-8 BTC, so all values are integer.) I could put the sql string directly into the call to selectrow(...). The sql variable was only used for debugging output, which doesn't make too much sense any more anyways since the values are to filled in any more (% -> ?)
I like little variables like that, they help document the intent and aid future tinkerers. Anything else?
Just some minor reformatting which I did. Thanks! |
|
|
|
- SQL Query correct? (longest chain only, correct joining of txout in getsentbyaddress?)
- Handling of decimal values correct? Is it "your way"? Probably not since I needed to "import decimal"
I didn't implement the "confirmations" filter yet. The joining looks correct. My "way" to format decimals is format_satoshis(satoshis, chain) . Couple of requests. Instead of IFNULL, use the portable COALESCE with the same arguments. Instead of '%s' and the % operator, use an unquoted question mark (?) and pass a tuple of bind values as the second argument to selectrow. (selectrow is the same as selectall but returns just the first row.) (Abe's database abstraction layer converts the standard qmark parameter style to whatever the driver needs.) Please capitalize SQL keywords like SELECT FROM JOIN ON WHERE AND for easier readability. Please prefix error messages with "ERROR:" as per BBE convention. And please show the usage message if address is None, even if chain is given. This is my convention where address is required, as in q_translate_address. Thanks! |
|
|
|
chain not found for magic '\x00\x00\x00\x00' in block file C:\Users\user\AppData\Roaming\Bitcoin\blk0001.dat at offset 169336263 Though i am not running bitcoin at the moment. Hmm, running will not help with this error. Have you redownloaded the block chain since the last abe.py run? If so, UPDATE datadir SET blkfile_number = 1, blkfile_offset = 0 will force a rescan. If not, well, now would be a good time to implement scanning for the magic number sequence, but that is not trivial. Maybe skipping past '\x00' would solve it here. I am curious what this program prints if you run it in the bitcoin-abe directory: #!/usr/bin/env python
import BCDataStream
ds = BCDataStream.BCDataStream()
ds.map_file(open(r"C:\Users\user\AppData\Roaming\Bitcoin\blk0001.dat", "rb"),
169336263)
offset = ds.read_cursor
magic = ds.read_bytes(4)
print "at %d of %d: %s" % (offset, len(ds.input), repr(magic))
if magic[0] == chr(0):
ds.read_cursor = offset
while ds.read_cursor < len(ds.input):
b = ds.read_bytes(1)[0]
if b != chr(0):
ds.read_cursor -= 1
break
if ds.read_cursor + 4 <= len(ds.input):
magic = ds.read_bytes(4)
print "at %d: %s" % (ds.read_cursor, repr(magic))
else:
print "%d near end %d" % (ds.read_cursor, len(ds.input))
|
|
|
|
|
c. 3 Gh/s starting tonight until this thing clears the tower.
Let's send those banksters packing!
|
|
|
|
Come to think of it, in Linux Abe reads the block file even if Bitcoin is running, but Windows may not allow that. Anyway, your next step would be to run the client, let it catch up, and let Abe keep loading.
And of course please report whether this is indeed the problem. Abe will resume loading if you either restart it with the same arguments as before or try to load a page in your browser. Sometimes Abe stops loading because of a miscellaneous error such as a full disk, and it would output the error message but serve the incomplete history as you observed. So we have to rule that out. |
|
|
|
Now that you mentioned it, It shows block 124783
Ah! I guess it's not clear: Abe will not download the block chain but relies on a recent run of bitcoin.exe or bitcoind.exe to have done so. Another item for the readme. Come to think of it, in Linux Abe reads the block file even if Bitcoin is running, but Windows may not allow that. Anyway, your next step would be to run the client, let it catch up, and let Abe keep loading. |
|
|
|
I'm curious, is it always later transactions missing? Could you have loaded only part of the block chain? Is the current block number (reported on the home page) at least 133634? I'm testing a setup partly like yours. I have Python 2.7 for Windows under Wine but with a Linux MySQL server. I've loaded about half the transactions so far, to Block 127735, not far enough to check the missing transactions to my donation address. I'll try loading the rest tonight. Thanks for the report. -John |
|
|
|
abe.john-edwin-tobey.org is more than accurate, for some reason my main address [in localhost] shows no history ;(
I suspect it has to do with Python's treatment of binary data on Windows. I'll say more when I've had time to investigate. If you can post any addresses that have this problem, that may help. |
|
|
|
The http is working fine.
I see alot of addresses have the right balances, but mine has 0 balance lulz
You didn't say if 0 was right.  Let me know if there's a difference from BlockExplorer.com or abe.john-edwin-tobey.org. I made a big update to the readme files. I guess next will be Deb/RPM/MSI packaging. But no promises on that. |
|
|
|
I uncommented default-storage-engine=INNODB and commented out skip-innodb and BAM!! It seems to be working, i am seeing block_tx 1 1 <= tons of that
Excellent! You might want to comment default-storage-engine back out and start over, especially if you are using this MySQL instance for anything other than Abe. Starting over is optional, but Abe currently assumes database defaults won't change after it configures itself. You could "fix" the installation with some SQL, though. (Do this only if changing default storage engine.) mysql> UPDATE configvar SET configvar_value = ' ENGINE=InnoDB' WHERE configvar_name = 'create_table_epilogue' AND configvar_value = '';
Query OK, 1 row affected (0.13 sec)
Rows matched: 1 Changed: 1 Warnings: 0
I appreciate your patience and generous contribution (doubling the donations to date!) Hope the web server works on Windows, you may be the first. I think FastCGI mode will need fixing, but if you do plain HTTP ("port NNNN") I expect it to work. Now I must document the skip-innodb snag... |
|
|
|
|
Thanks. Apparently this command failed:
mysql> CREATE TABLE abe_test_1 (a NUMERIC(12)) ENGINE=InnoDB;
I'm curious to know if the command succeeds outside of Abe. Can you give me MySQL, MySQL-Python, and Python version numbers? Do you know whether your database includes InnoDB support? I've assumed that most do, but perhaps this needs documenting.
Thanks again for the report.
|
|
|
|
Exception: Can not create a transactional table. Hmm, it means Abe could not get rollback working, even with "engine=InnoDB". I do not get this error with a Abe v0.5 and a fresh database. I am this close | | to giving up ;( I sent a little something onto your way, awesome projects like this should get lots of support to be better and continue rocking  Thanks for your kind support. I suggest grabbing the latest (commit 9fd704b8, which supports --log-sql) and running "python abe.py --config myabe.conf --log-sql --no-serve --datadir /" Then paste me the last 10-20 lines, if you will. You could also try configuring MySQL with "default-storage-engine=InnoDB" and restarting it, but it should not be necessary. Abe is supposed to detect and override this default when needed. |
|
|
|
I am running this on windows btw, could that be the problem? super(Connection, self).__init__(*args, **kwargs2)
_mysql_exceptions.OperationalError: (2005, "Unknown MySQL server host ''{user:root,host:127.0.0.1,db:abe,passwd:password}'' (11004)") Yes, the command line parser does not recognise single-quote as a delimiter. Try "./abe.py --config myabe.conf" where myabe.conf contains the following text, adjusted for your connection parameters: # Abe configuration file for MySQL
dbtype MySQLdb
connect-args {"user":"abe","host":"127.0.0.1","db":"abe","passwd":"Bitcoin"}
port 2750
upgrade
I appreciate the feedback. I will summarise this discussion in documentation to make it easier for the next person. |
|
|
|
I can't get this to run on mysql or even pgsql.
How do i pass the host,user,pass,db again?
mysql> create database abe; Query OK, 1 row affected (0.03 sec) mysql> CREATE USER abe IDENTIFIED BY 'Bitcoin'; Query OK, 0 rows affected (0.00 sec) mysql> grant all on abe.* to abe; Query OK, 0 rows affected (0.00 sec) mysql> Then run: ./abe.py --dbtype MySQLdb --connect-args '{"user":"abe","host":"127.0.0.1","db":"abe","passwd":"Bitcoin"}' --port 2750 --upgrade Let me know how it goes. |
|
|
|
Happy to see someone doing interesting things. Thanks for the donation. |
|
|
|
|
Maybe the MM was using the resources of an unsympathetic employer and was discovered/fired after a week. I'm sure hundreds of people have access to big hash power for "free" (others pay electricity etc.).
Cool graphs, and thanks for the donation!
|
|
|
|
I hope this is the right place to ask this and not considered offtopic.
I don't object if moderators don't. I guess we could also use the Github issue system. (The issue here is a lack of database documentation or user guide.) Now I know I'm making the mistake of including blocks from orphaned chains.
Is there an easy way to exclude blocks from orphaned chains in a sql query?
Yes, well not too hard: select b.* from block b join chain_candidate cc on (b.block_id = cc.block_id) where cc.chain_id = ? and cc.in_longest = 1 |
|
|
|
|
Show Posts
