|
Replies:
1
-
Pages:
1
-
Last Post:
Dec 8, 2010 2:19 AM
by: Tanhys
|
|
|
Posts:
3
Registered:
10/12/10
|
|
|
|
Executing an Import template makes Toad crash at the end
Posted:
Oct 12, 2010 10:39 PM
|
|
|
Hello "Toad for MySQL" users!
I am having an annoying issue with Toad for MySQL. Every morning, I need to import a CSV file of 82Mb into one single table. The loading seems to work well since I always get all the data inside my table (even though the error says that I loose 8000 rows) after that import. However, this is really tiring me to see Toad crash systematically at the end of the import execution.
The status bar says "2 tasks", the first one being the actual import and the second one... well, don't really get what this is but apparently nothing really significant.
My Questions then:
- has anyone of you already had the same issue?
- Am I doing something wrong?
- Is there any limitation I am not aware of which would make my import crash?
Thank you very much for your feedbacks and assistance on this.
Kind regards,
Tanhys
---------------------------------------------------------------------
ERROR I get:
---------------------------------------------------------------------
**********************************************************************
Exception Information
**********************************************************************
Exception: Quest.FastData.FastDataException Message : Encountered problem with spooling data to disk.
Closing result spool file.
8192 rows lost from the current result.
Stack Trace:
at Quest.FastData.FastTable.RowCollection.Add(Object[] item)
at Quest.FastData.FastTable.AddRowAccepted(Object[] data)
at Quest.Toad.ScriptResults.OutputStorageHandler.AddEntry(OutputEventArgs args)
at Quest.Toad.ScriptResults.OutputStorageHandler.NotificationManager_OutputEvent(Object sender, OutputEventArgs args)
at Quest.Toad.Notification.NotificationManager.SendOutput(Object sender, Image image, OutputCategory category, String text, String linkLocation, OutputLinkHandler linkDelegate, Object tag)
at Quest.Toad.Util.Global.DisplayStatusMessage(Image image, String message, String linkText, OutputLinkHandler callback, Object stateObject)
at Quest.Toad.ImportExport.ImportEngine.ImportThread()
at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()
Inner Exception: System.IO.EndOfStreamException
Message : Unable to read beyond the end of the stream.
Stack Trace:
at System.IO.__Error.EndOfFile()
at System.IO.BinaryReader.ReadByte()
at Quest.Toad.ScriptResults.OutputStorageHandler.FastImageSerialize.Deserialize(BinaryReader inStream)
at Quest.FastData.FastTable.DeserializeRow(BinaryReader reader)
at Quest.FastData.FastTable.RowCollection.DeserializeChunk(FastTable table, BinaryReader reader, Chunk chunk, Int64 length)
at Quest.FastData.FastTable.RowCollection.Add(Object[] item)
|
Tanhys
|
|
Posts:
3
Registered:
10/12/10
|
|
|
|
Re: Executing an Import template makes Toad crash at the end
Posted:
Dec 8, 2010 2:19 AM
in response to: Tanhys
|
|
|
Hello there,
Apparently noone had the time to answer or found a solution to my issue. But it looks like Quest Software Dev Team has, in the end.
This morning, I have installed the latest version of Toad for MySQL and did the same import as usual and guess what? It did not crash at all!
I then encourage all the people who could have had the same issue to upgrade their Toad for MySQL software to the latest.
|
Tanhys
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
