Subject Re: [firebird-support] Error While Executing Simple Inner Join SQL With Big database
Author Vishal Tiwari
Post date 2015-06-08T05:09:36Z
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::Fetch
Message: isc_dsql_fetch failed

SQL Message : -901
Unsuccessful execution caused by system error that does not
preclude successful execution of subsequent statements

Engine Code : 335544675
Enginne Message : 
sort error
No free space found in temporary directories
operating system directive WriteFile failed
There is not enough space on the disk.





On Monday, 8 June 2015 10:28 AM, "Robert martin rob@... [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 vishualsoft@...
[firebird-support] wrote:
> There is enough free disk space (2.75 GB) available.
>
>
>
> On Monday, 8 June 2015 10:08 AM, "Vishal Tiwari vishualsoft@...
> [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

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/firebird-support/join
    (Yahoo! ID required)

<*> To change settings via email:
    firebird-support-digest@yahoogroups.com
    firebird-support-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
    firebird-support-unsubscribe@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
    https://info.yahoo.com/legal/us/yahoo/utos/terms/