Hi, It looks like a bug, I need to investigate. As a workaround, it seems you could remove this line from the .trace.db file and run the ConvertTraceFile tool again.
Regards, Thomas 2012/3/29 Hänsch, Wolfgang <[email protected]>: > 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: [email protected] [mailto:[email protected]] On > Behalf Of Thomas Mueller > Sent: Wednesday, March 28, 2012 7:17 PM > To: [email protected] > 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 <[email protected]> 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 [email protected]. >>> To unsubscribe from this group, send email to >>> [email protected]. >>> 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 [email protected]. >> To unsubscribe from this group, send email to >> [email protected]. >> 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 [email protected]. > To unsubscribe from this group, send email to > [email protected]. > 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 [email protected]. > To unsubscribe from this group, send email to > [email protected]. > 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 [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
