Hi, I found out this is a bug. It will be fixed in the next release.
Regards, Thomas On Thursday, March 29, 2012, Thomas Mueller wrote: > 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]. > -- 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.
