Online Error Analytics

5 views
Skip to first unread message

Thomas Mueller

unread,
Jan 31, 2008, 4:50:53 PM1/31/08
to h2-da...@googlegroups.com
Hi,

Could you try out the new error analytics tool at
http://h2database.com/html/sourceError.html and send feedback?

As the name says, it helps analyzing error messages:
- Provides more information (the Javadoc; unfortunately incomplete)
- Cool is: you can browse the source code from the subversion repository

Any feedback would be very welcome (usability, bugs, ideas how to
improve it, whatever). I have some ideas already of course (a link to
this tool should be included in each error message; other source
repositories could be added so you can see any kind of source; Apache
Commons, Hibernate,... anything open source; create a log4j adapter
that includes version information).

Browser compatiblity: Firefox and Safari on Windows XP seem to work.
Source code view doesn't work with Internet Explorer 7.0; I didn't
test other browsers or OSes. If somebody knows how to make it work
with IE (or other browsers) please tell me.

Regards,
Thomas

Volk

unread,
Feb 1, 2008, 5:54:04 AM2/1/08
to H2 Database
Hello, Thomas.
Nice tool. It's more convenient than looking into sources to find out
the description of the problem.
But I've got this message when tried to see source codes :
"Not Found
The requested URL /svn/tags/version-1.0.63/h2/src/main/org/h2/store/
DiskFile@1a99347 blockCount:0<br/> org/h2/message/Message.java was not
found on this server".

Regards,
Kirill.

On Jan 31, 11:50 pm, "Thomas Mueller" <thomas.tom.muel...@gmail.com>
wrote:
> Hi,
>
> Could you try out the new error analytics tool athttp://h2database.com/html/sourceError.htmland send feedback?

Thomas Mueller

unread,
Feb 1, 2008, 6:37:52 AM2/1/08
to h2-da...@googlegroups.com
Hi,

Now all browsers work (I only changed the subversion link).

> I've got this message when tried to see source codes :
> "Not Found
> The requested URL /svn/tags/version-1.0.63/h2/src/main/org/h2/store/
> DiskFile@1a99347 blockCount:0<br/> org/h2/message/Message.java was not
> found on this server".

I fixed it. Could you try again, and if still doesn't work post the
exception and stack trace you have tried with?

Regards,
Thomas

Volk

unread,
Feb 1, 2008, 7:06:35 AM2/1/08
to H2 Database
I found the reason, it seems to be a bug in stack trace parsing.
Try to see sources for "org.h2.message.Message.getInternalError" for
this one :

at org.h2.store.Storage.getRecord(Storage.java:58)
at org.h2.index.ScanIndex.getRow(ScanIndex.java:86)
at org.h2.table.TableData.getRow(TableData.java:69)
at org.h2.index.BtreeIndex.getRow(BtreeIndex.java:240)
...
Caused by: java.lang.Error: File ID mismatch got=0 expected=103
pos=17412 true org.h2.store.DiskFile@ab3a93 blockCount:0
at org.h2.message.Message.getInternalError(Message.java:117)
at org.h2.store.DiskFile.getRecord(DiskFile.java:399)
at org.h2.store.Storage.getRecord(Storage.java:58)
at org.h2.index.ScanIndex.getRow(ScanIndex.java:86)
at org.h2.table.TableData.getRow(TableData.java:69)
at org.h2.index.BtreeIndex.getRow(BtreeIndex.java:240)
...

And if you try just :
Caused by: java.lang.Error: File ID mismatch got=0 expected=103
pos=17412 true org.h2.store.DiskFile@ab3a93 blockCount:0
at org.h2.message.Message.getInternalError(Message.java:117)
at org.h2.store.DiskFile.getRecord(DiskFile.java:399)
at org.h2.store.Storage.getRecord(Storage.java:58)
at org.h2.index.ScanIndex.getRow(ScanIndex.java:86)
at org.h2.table.TableData.getRow(TableData.java:69)
at org.h2.index.BtreeIndex.getRow(BtreeIndex.java:240)

you won't see the "Caused by: java.lang.Error: File ID mismatch got=0
expected=103 pos=17412 true org.h2.store.DiskFile@ab3a93 blockCount:0
at" in the source code window.

Regards,
Kirill.

Thomas Mueller

unread,
Feb 1, 2008, 7:14:24 AM2/1/08
to h2-da...@googlegroups.com
You may need to refresh the page.

Volk

unread,
Feb 1, 2008, 7:30:46 AM2/1/08
to H2 Database
On Feb 1, 2:14 pm, "Thomas Mueller" <thomas.tom.muel...@gmail.com>
wrote:
> You may need to refresh the page.
>
> On Feb 1, 2008 1:06 PM, Volk <k.vol...@gmail.com> wrote:
>
>

I refreshed the page and even open it two different browsers, for now
there are no links in "Source Code" window are showed:

org.h2.jdbc.JdbcSQLException: General error: java.lang.Error: File ID
mismatch got=0 expected=103 pos=17412 true
org.h2.store.DiskFile@ab3a93 blockCount:0 [HY000-63]
at org.h2.message.Message.getSQLException(Message.java:84)
at org.h2.message.Message.convert(Message.java:386)
at org.h2.command.Command.executeQueryLocal(Command.java:71)
at org.h2.command.Command.executeQuery(Command.java:58)
at
org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:
89)
...
at java.lang.Thread.run(Thread.java:595)
Caused by: java.lang.Error: File ID mismatch got=0 expected=103
pos=17412 true org.h2.store.DiskFile@ab3a93 blockCount:0
at org.h2.message.Message.getInternalError(Message.java:117)
at org.h2.store.DiskFile.getRecord(DiskFile.java:399)
at org.h2.store.Storage.getRecord(Storage.java:58)
at org.h2.index.ScanIndex.getRow(ScanIndex.java:86)
at org.h2.table.TableData.getRow(TableData.java:69)
at org.h2.index.BtreeIndex.getRow(BtreeIndex.java:240)
at org.h2.index.BtreeCursor.get(BtreeCursor.java:58)
at org.h2.table.TableFilter.getValue(TableFilter.java:543)
at org.h2.expression.ExpressionColumn.getValue(ExpressionColumn.java:
160)
at org.h2.expression.Alias.getValue(Alias.java:34)
at org.h2.command.dml.Select.queryFlat(Select.java:280)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:331)
at org.h2.command.dml.Query.query(Query.java:96)
at org.h2.command.CommandContainer.query(CommandContainer.java:73)
at org.h2.command.Command.executeQueryLocal(Command.java:69)
... 86 more

Volk

unread,
Feb 1, 2008, 7:34:15 AM2/1/08
to H2 Database
I tried it once more, now it starts working fine!
Thanks.

t603

unread,
Feb 1, 2008, 8:00:00 AM2/1/08
to H2 Database
Hi,Thomas,

it is nice tool. However "Source code" button does not work for me. I
am using (Cut&Paste from menu -> Help -> About Mozilla Firexox)

Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.8.1.11) Gecko/
20071127 Firefox/2.0.0.11

The following error appears:

Not Found
The requested URL /p/h2database/source/browse/tags/version-1.0.64/h2/
src/main/org/h2/message/Message.java was not found on this server.

Url of page is
"http://h2database.com/html/sourceError.html"
and url of right inner frame is
"http://code.google.com/p/h2database/source/browse/tags/version-1.0.64/
h2/src/main/org/h2/message/Message.java#93"

But even "Details" button is useful. Regards, Stepan

Thomas Mueller

unread,
Feb 1, 2008, 12:37:19 PM2/1/08
to h2-da...@googlegroups.com
Hi,

Fixed. The problem is, the label for version 1.0.64 is different - I
made a workaround.
The 'fast mode' is back, but it is now an option, and labelled 'Firefox only'.
You will have to click 'refresh' in the browser (not sure how this
problem can be solved...).

Thanks a lot!
Thomas

Reply all
Reply to author
Forward
0 new messages