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.
