> I think the image posting is not allowed here to display. > Below is the error message I see: > Note I have 2.75 GB free disk space. > *** IBPP::SQLException ***Context: Statement::FetchMessage: isc_dsql_fetch > failed > SQL Message : -901Unsuccessful execution caused by system error that does > notpreclude successful execution of subsequent statements > Engine Code : 335544675Enginne Message : sort errorNo free space found in > temporary directoriesoperating system directive WriteFile failedThere is not > enough space on the disk.
The error message makes it pretty clear. Right? The Firebird server needs disk based temporary storage to process your statement and runs out of space. You may point temporary location configured in firebird.conf to a different destination. Depending on the available RAM, you may also want to increase RAM usage for temp storage used by sorts, group by etc. -- With regards, Thomas Steinmaurer http://www.upscene.com Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc. > On Monday, 8 June 2015 10:28 AM, "Robert martin r...@chreos.com > [firebird-support]" <firebird-support@yahoogroups.com> wrote: > > > > Hi > > I don't know what the error message is, you didn't include it! but it is > likely your join is wrong and returning one of every detail record for > every header (i.e. 78000 * 3000 records !) > > Check your query and make sure the detail records are linked to the > master correctly (i.e. JOIN detail d ON d.ForeignkeyField = > m.primarykeyfield) > > Post your SQL if you cant see the cause :) > > Cheers > Rob > > > > On 8/06/2015 4:49 p.m., Vishal Tiwari vishuals...@yahoo.co.in > [firebird-support] wrote: >> There is enough free disk space (2.75 GB) available. >> >> >> >> On Monday, 8 June 2015 10:08 AM, "Vishal Tiwari vishuals...@yahoo.co.in >> [firebird-support]" <firebird-support@yahoogroups.com> wrote: >> >> >> Hi All, >> I am running one SQL in that Master table has 78 thousand plus records >> and detail table has 4 Laks and 3 thousand plus records. I have used >> Inner Join on the primary key of Master table with the column in the >> Detail Table. >> When I execute with small size database, but with this database when I >> run SQL using Flamerobin, I get below error. >> Please help. >> >> With Best Regards. >> Vishal >> >> [Non-text portions of this message have been removed] >> >> > > > > ------------------------------------ > > ------------------------------------ > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > Visit http://www.firebirdsql.org and click the Documentation item > on the main (top) menu. Try FAQ and other links from the left-side menu > there. > > Also search the knowledgebases at > http://www.ibphoenix.com/resources/documents/ > > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > ------------------------------------ > > Yahoo Groups Links > > > > > >
