Hi,
There was no date or time change.
I assume the trace output is wrong.
03-27 13:45:13 jdbc[2]:
/*SQL t:1332848713975*/SET TRACE_LEVEL_FILE 2;
^^^^^^^^^^^^^
03-27 13:45:13 command: slow query: 1,332,848,713,975 ms
After ConvertTraceFile the SQL Statement Statistics is useless.
SET TRACE_LEVEL_FILE shows 100%
Regards
Wolfgang
-----Original Message-----
From: h2-database@googlegroups.com [mailto:h2-database@googlegroups.com] On
Behalf Of Thomas Mueller
Sent: Wednesday, March 28, 2012 7:17 PM
To: h2-database@googlegroups.com
Subject: Re: Exception when running ConvertTraceFile
Hi,
Was it really such a long running query, or was the system date or
time changed while running it?
(probably the System.currentTimeMillis() needs to be replaced with
System.nanoTime())
Regards,
Thomas
On Tue, Mar 27, 2012 at 2:14 PM, Noel Grandin <noelgran...@gmail.com> wrote:
> Wow, that is a seriously long running query :-)
>
> Thanks, that is a bug, fix committed to SVN.
>
>
> On 2012-03-27 14:05, WHänsch wrote:
>>
>> Hello
>>
>> C:\Program Files (x86)\H2\bin>java -cp h2.jar
>> org.h2.tools.ConvertTraceFile -traceFile "c:\h2\aura.trace.db" -script
>> "c:\h2\trace.sql"
>> Exception in thread "main" java.lang.NumberFormatException: For input
>> string: "1332846741070"
>> at java.lang.NumberFormatException.forInputString(Unknown Source)
>> at java.lang.Integer.parseInt(Unknown Source)
>> at java.lang.Integer.parseInt(Unknown Source)
>> at
>> org.h2.tools.ConvertTraceFile.convertFile(ConvertTraceFile.java:159)
>> at org.h2.tools.ConvertTraceFile.runTool(ConvertTraceFile.java:99)
>> at org.h2.tools.ConvertTraceFile.main(ConvertTraceFile.java:76)
>>
>> This are the first 3 lines from the trace file:
>> 03-27 13:45:13 jdbc[2]:
>> /*SQL t:1332848713975*/SET TRACE_LEVEL_FILE 2;
>> 03-27 13:45:13 command: slow query: 1,332,848,713,975 ms
>>
>> Version: H2 1.3.159 (2011-08-13)
>>
>>
>> Any idea?
>> Thanks in advance.
>>
>> Regards
>> Wolfgang
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "H2 Database" group.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msg/h2-database/-/0gczm0wmZisJ.
>> To post to this group, send email to h2-database@googlegroups.com.
>> To unsubscribe from this group, send email to
>> h2-database+unsubscr...@googlegroups.com.
>> For more options, visit this group at
>> http://groups.google.com/group/h2-database?hl=en.
>
>
> --
> You received this message because you are subscribed to the Google Groups
> "H2 Database" group.
> To post to this group, send email to h2-database@googlegroups.com.
> To unsubscribe from this group, send email to
> h2-database+unsubscr...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/h2-database?hl=en.
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to h2-database@googlegroups.com.
To unsubscribe from this group, send email to
h2-database+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to h2-database@googlegroups.com.
To unsubscribe from this group, send email to
h2-database+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
