Re: AW: AW: [firebird-support] Re: Memory usage excess / leak in FBServer 2.5.4

2015-06-07 Thread Thomas Steinmaurer t...@iblogmanager.com [firebird-support]
---In firebird-support@yahoogroups.com, ts@... wrote : Is this SuperServer only or also SuperClassic? SuperServer only. Thank you! Thomas

Re: [firebird-support] Error While Executing Simple Inner Join SQL With Big database

2015-06-07 Thread Robert martin r...@chreos.com [firebird-support]
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

Re: [firebird-support] Error While Executing Simple Inner Join SQL With Big database

2015-06-07 Thread Vishal Tiwari vishuals...@yahoo.co.in [firebird-support]
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

Re: [firebird-support] Error While Executing Simple Inner Join SQL With Big database

2015-06-07 Thread Vishal Tiwari vishuals...@yahoo.co.in [firebird-support]
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

[firebird-support] Error While Executing Simple Inner Join SQL With Big database

2015-06-07 Thread Vishal Tiwari vishuals...@yahoo.co.in [firebird-support]
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

Re: AW: AW: AW: [firebird-support] Re: Memory usage excess / leak in FBServer 2.5.4

2015-06-07 Thread hv...@users.sourceforge.net [firebird-support]
---In firebird-support@yahoogroups.com, joja.lists@... wrote : Sorry, I didn’t check my mail till now. Thank you for creating the ticket. And of course for fixing the bug. Please, verify it using recent snapshot build Regards, Vlad

Re: AW: AW: [firebird-support] Re: Memory usage excess / leak in FBServer 2.5.4

2015-06-07 Thread hv...@users.sourceforge.net [firebird-support]
---In firebird-support@yahoogroups.com, ts@... wrote : Is this SuperServer only or also SuperClassic? SuperServer only. Regards, Vlad