I have 8 GB RAM, how much else does it need ?
>> You may point temporary location configured in firebird.conf to a different
>>destination.
Could you help in, how do I configure to a different location using
firebird.conf file ?
So I could give a try.
Thanks.
On Monday, 8 June 2015 11:44 AM, "'Thomas Steinmaurer'
t...@iblogmanager.com [firebird-support]" <firebird-support@yahoogroups.com>
wrote:
> 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
>
>
>
>
>
>
#yiv8470420125 #yiv8470420125 -- #yiv8470420125ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8470420125
#yiv8470420125ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8470420125
#yiv8470420125ygrp-mkp #yiv8470420125hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv8470420125 #yiv8470420125ygrp-mkp #yiv8470420125ads
{margin-bottom:10px;}#yiv8470420125 #yiv8470420125ygrp-mkp .yiv8470420125ad
{padding:0 0;}#yiv8470420125 #yiv8470420125ygrp-mkp .yiv8470420125ad p
{margin:0;}#yiv8470420125 #yiv8470420125ygrp-mkp .yiv8470420125ad a
{color:#0000ff;text-decoration:none;}#yiv8470420125 #yiv8470420125ygrp-sponsor
#yiv8470420125ygrp-lc {font-family:Arial;}#yiv8470420125
#yiv8470420125ygrp-sponsor #yiv8470420125ygrp-lc #yiv8470420125hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8470420125
#yiv8470420125ygrp-sponsor #yiv8470420125ygrp-lc .yiv8470420125ad
{margin-bottom:10px;padding:0 0;}#yiv8470420125 #yiv8470420125actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8470420125
#yiv8470420125activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8470420125
#yiv8470420125activity span {font-weight:700;}#yiv8470420125
#yiv8470420125activity span:first-child
{text-transform:uppercase;}#yiv8470420125 #yiv8470420125activity span a
{color:#5085b6;text-decoration:none;}#yiv8470420125 #yiv8470420125activity span
span {color:#ff7900;}#yiv8470420125 #yiv8470420125activity span
.yiv8470420125underline {text-decoration:underline;}#yiv8470420125
.yiv8470420125attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv8470420125 .yiv8470420125attach div a
{text-decoration:none;}#yiv8470420125 .yiv8470420125attach img
{border:none;padding-right:5px;}#yiv8470420125 .yiv8470420125attach label
{display:block;margin-bottom:5px;}#yiv8470420125 .yiv8470420125attach label a
{text-decoration:none;}#yiv8470420125 blockquote {margin:0 0 0
4px;}#yiv8470420125 .yiv8470420125bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv8470420125
.yiv8470420125bold a {text-decoration:none;}#yiv8470420125 dd.yiv8470420125last
p a {font-family:Verdana;font-weight:700;}#yiv8470420125 dd.yiv8470420125last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8470420125
dd.yiv8470420125last p span.yiv8470420125yshortcuts
{margin-right:0;}#yiv8470420125 div.yiv8470420125attach-table div div a
{text-decoration:none;}#yiv8470420125 div.yiv8470420125attach-table
{width:400px;}#yiv8470420125 div.yiv8470420125file-title a, #yiv8470420125
div.yiv8470420125file-title a:active, #yiv8470420125
div.yiv8470420125file-title a:hover, #yiv8470420125 div.yiv8470420125file-title
a:visited {text-decoration:none;}#yiv8470420125 div.yiv8470420125photo-title a,
#yiv8470420125 div.yiv8470420125photo-title a:active, #yiv8470420125
div.yiv8470420125photo-title a:hover, #yiv8470420125
div.yiv8470420125photo-title a:visited {text-decoration:none;}#yiv8470420125
div#yiv8470420125ygrp-mlmsg #yiv8470420125ygrp-msg p a
span.yiv8470420125yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8470420125
.yiv8470420125green {color:#628c2a;}#yiv8470420125 .yiv8470420125MsoNormal
{margin:0 0 0 0;}#yiv8470420125 o {font-size:0;}#yiv8470420125
#yiv8470420125photos div {float:left;width:72px;}#yiv8470420125
#yiv8470420125photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv8470420125
#yiv8470420125photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8470420125
#yiv8470420125reco-category {font-size:77%;}#yiv8470420125
#yiv8470420125reco-desc {font-size:77%;}#yiv8470420125 .yiv8470420125replbq
{margin:4px;}#yiv8470420125 #yiv8470420125ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv8470420125 #yiv8470420125ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8470420125
#yiv8470420125ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8470420125
#yiv8470420125ygrp-mlmsg select, #yiv8470420125 input, #yiv8470420125 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv8470420125
#yiv8470420125ygrp-mlmsg pre, #yiv8470420125 code {font:115%
monospace;}#yiv8470420125 #yiv8470420125ygrp-mlmsg *
{line-height:1.22em;}#yiv8470420125 #yiv8470420125ygrp-mlmsg #yiv8470420125logo
{padding-bottom:10px;}#yiv8470420125 #yiv8470420125ygrp-msg p a
{font-family:Verdana;}#yiv8470420125 #yiv8470420125ygrp-msg
p#yiv8470420125attach-count span {color:#1E66AE;font-weight:700;}#yiv8470420125
#yiv8470420125ygrp-reco #yiv8470420125reco-head
{color:#ff7900;font-weight:700;}#yiv8470420125 #yiv8470420125ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv8470420125 #yiv8470420125ygrp-sponsor
#yiv8470420125ov li a {font-size:130%;text-decoration:none;}#yiv8470420125
#yiv8470420125ygrp-sponsor #yiv8470420125ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv8470420125
#yiv8470420125ygrp-sponsor #yiv8470420125ov ul {margin:0;padding:0 0 0
8px;}#yiv8470420125 #yiv8470420125ygrp-text
{font-family:Georgia;}#yiv8470420125 #yiv8470420125ygrp-text p {margin:0 0 1em
0;}#yiv8470420125 #yiv8470420125ygrp-text tt {font-size:120%;}#yiv8470420125
#yiv8470420125ygrp-vital ul li:last-child {border-right:none
!important;}#yiv8470420125
