Toad World® Forums

Spooling problem


#1

When it happened, I did not run any query but before I was playing with query giving ap. 400-600 rows - I ran it many times.

Error was repeated many times, first occurrences had only information ‘There is not enough space on the disk’

Quest.FastData.FastDataException
Encountered problem with spooling data to disk.
Closing result spool file.
125523968 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.Oracle.OracleToadConnection.ReadRow(IDataReader reader, FastTable datatable, FastReadOptions options, PrePostProcessHandler prePostProcessHandler)
at Quest.Toad.Db.ToadDataAdapter.InternalFill(List1 ret) at Quest.Toad.Db.ToadDataAdapter.Fill(CommandResult commandResult) at Quest.Toad.Trl.DataTabShowTrl.FetchObjectdata(ITrl objectTrl, Int32 fetchRows) at Quest.Toad.CodeInsight.LanguageDialect.FetchObjectData(ITrl objectTrl, ITrl columnTrl, Int32 fetchRows) at Quest.Toad.CodeInsight.LanguageDialect.GenerateColumnData(ITrl objectTrl, ITrl columnTrl) at Quest.Toad.CodeInsight.LanguageDialect.ReadVirtualList(IConnection connection, Insight insight, IncludeInsight include, Boolean filtering, String defaultSchema, Boolean refresh) at Quest.Toad.CodeInsight.BaseDialect.GenerateInsight(IConnection connection, String defaultSchema, Boolean filtering, Boolean refresh, Insight insight, Boolean secondary, Boolean& hasSecondary, List1 ownerList, Int32 pad, IInsightLookupRequest request)
at Quest.Toad.CodeInsight.LanguageDialect.GenerateInsight(IConnection connection, String defaultSchema, Boolean filtering, Boolean refresh, Insight insight, Boolean secondary, Boolean& hasSecondary, List`1 ownerList, Int32 pad, IInsightLookupRequest request)
at Quest.Toad.CodeInsight.BaseDialect.GenerateInsightThread(Object obj)

System.IO.IOException
There is not enough space on the disk.

Stack Trace:
   at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
   at System.IO.FileStream.WriteCore(Byte[] buffer, Int32 offset, Int32 count)
   at System.IO.FileStream.Write(Byte[] array, Int32 offset, Int32 count)
   at System.IO.BinaryWriter.Write(Byte[] buffer, Int32 index, Int32 count)
   at Quest.Toad.Oracle.OracleNumberSerialize.Serialize(BinaryWriter outStream, Object obj)
   at Quest.FastData.FastTable.SerializeRow(Object[] data, BinaryWriter writer)
   at Quest.FastData.FastTable.RowCollection.SerializeRowData(Object[] data)
   at Quest.FastData.FastTable.RowCollection.Add(Object[] item)


Butter

disk2.png


#2

And again:
[I’m 166 164 480 % sure, none of my queries could gave such big result]

Quest.FastData.FastDataException
Encountered problem with spooling data to disk.
Closing result spool file.
166164480 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.Oracle.OracleToadConnection.ReadRow(IDataReader reader, FastTable datatable, FastReadOptions options, PrePostProcessHandler prePostProcessHandler)
at Quest.Toad.Db.ToadDataAdapter.InternalFill(List1 ret) at Quest.Toad.Db.ToadDataAdapter.Fill(CommandResult commandResult) at Quest.Toad.Trl.DataTabShowTrl.FetchObjectdata(ITrl objectTrl, Int32 fetchRows) at Quest.Toad.CodeInsight.LanguageDialect.FetchObjectData(ITrl objectTrl, ITrl columnTrl, Int32 fetchRows) at Quest.Toad.CodeInsight.LanguageDialect.GenerateColumnData(ITrl objectTrl, ITrl columnTrl) at Quest.Toad.CodeInsight.LanguageDialect.ReadVirtualList(IConnection connection, Insight insight, IncludeInsight include, Boolean filtering, String defaultSchema, Boolean refresh) at Quest.Toad.CodeInsight.BaseDialect.GenerateInsight(IConnection connection, String defaultSchema, Boolean filtering, Boolean refresh, Insight insight, Boolean secondary, Boolean& hasSecondary, List1 ownerList, Int32 pad, IInsightLookupRequest request)
at Quest.Toad.CodeInsight.LanguageDialect.GenerateInsight(IConnection connection, String defaultSchema, Boolean filtering, Boolean refresh, Insight insight, Boolean secondary, Boolean& hasSecondary, List`1 ownerList, Int32 pad, IInsightLookupRequest request)
at Quest.Toad.CodeInsight.BaseDialect.GenerateInsightThread(Object obj)

System.IO.IOException
There is not enough space on the disk.

Stack Trace:
   at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
   at System.IO.FileStream.WriteCore(Byte[] buffer, Int32 offset, Int32 count)
   at System.IO.FileStream.Write(Byte[] array, Int32 offset, Int32 count)
   at System.IO.BinaryWriter.Write(Byte[] buffer, Int32 index, Int32 count)
   at Quest.Toad.Oracle.OracleNumberSerialize.Serialize(BinaryWriter outStream, Object obj)
   at Quest.FastData.FastTable.SerializeRow(Object[] data, BinaryWriter writer)
   at Quest.FastData.FastTable.RowCollection.SerializeRowData(Object[] data)
   at Quest.FastData.FastTable.RowCollection.Add(Object[] item)

#3

Thank you for reporting the issue.
I created the CR 106767 to track it.