[firebird-support] Firebird Server Crashing - Please help

Hi, We are trying to restore a database of one of my Clients on there new server, but during the restore process it seems that Firebird "breaks". The platform is as follows: Windows 7 Professional 64-bit Firebird 2.50.26074 64-bit, downloaded from www.firebirdsql.org 8GB of RAM Firebird.conf is s

RE: [firebird-support] Firebird Server Crashing - Please help

-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Marius Labuschagne Sent: 25 August 2011 01:59 PM To: firebird-support@yahoogroups.com Subject: [firebird-support] Firebird Server Crashing - Please help Hi, We are trying to restore a database of one of my

[firebird-support] GBAK Restore Crash

Hi, I am trying to restore a backup database of one of my Clients. The restore runs up until a point in both EasyIP Firebird Database Manager and also when making using of GBAK command line directly. EasyIp breaks with the following message: SQL Code: -901 IB Error Code: 336330798 Error Message:

RE: [firebird-support] GBAK Restore Crash

Thank you Alexey, I will instruct my Client to execute another backup. I’m making the assumption then that this is not a Firebird issue but rather just the luck of the draw when backing up the database? Regards Marius   Hello Marius, > Can anyone advise what I should be trying, or why this is

[firebird-support] lock conflict on no wait transaction - finding the user

Hi, Is there something I can do to find out which user is locking a particular record in a database? If I can use the transaction number to lookup the user, then I may be able to simply ask that user to re-start his machine? The server is running Firebird Superserver 2.1.4 on Windows. I am tryin

RE: [firebird-support] lock conflict on no wait transaction - finding the user

>If your database has an ODS of at least 11.1, then you can do: > >select >a.* >, t.* >from >mon$transactions t join mon$attachments a on (t.mon$attachment_id = >a.mon$attachment_id) >where >mon$transaction_id = 7850179 > >This will give the transaction and attachment information for this >partic

[firebird-support] Indexes being used in UPDATE OR INSERT Matching clause

Hi, Can someone tell me if when making use of a update or insert statement, if indexes on the MATCHING fields will be used when performing the update portion? As an example, the following statement: UPDATE OR INSERT INTO CONTROLSALES (SALE_DATE, INTRECNO_CUSTOMER, CASHCREDIT, SALESTOTALEX, SALE

[firebird-support] Finding when a Database Object was created

Hello, Is it possible to perform a query against the system tables that will tell me when (Date) a certain trigger or stored procedure was created? Or is there another way to get that information? Regards Marius J. Labuschagne

[firebird-support] Recording Error Trapped in Stored Procedure

Hi, I am making using of the WHEN clause to trap any exceptions that are produced during the execution of my stored procedure (non selectable). ... WHEN ANY DO BEGIN INSERT INTO SP_ERRORS (ROWNO, EXCEPT_MESSAGE) VALUES (:vIRN, ); END ... How can I store the value (text) of the e

RE: [firebird-support] Recording Error Trapped in Stored Procedure

Hi, I have used SQLSTATE to record the error state. I will then just go find the message for the SQLState on the internet. Regards Marius

[firebird-support] Recording Update statements and User that executed

Hi, Is it possible to record any UPDATE statement that is executed against a database, from the database level? Something very strange happened to one of my Clients databases, where one field in a table was set to another field in the same table (both double precision fields). I suspect that thi

RE: [firebird-support] Recording Update statements and User that executed

[Marius Labuschagne] "Hi, Is it possible to record any UPDATE statement that is executed against a database, from the database level? Something very strange happened to one of my Clients databases, where one field in a table was set to another field in the same table (both double prec

RE: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2

the patch in 2.5.2 versión and verify that the problems was gone. I thin you have to look up in other direction. [Marius Labuschagne] We have sites running Windows 2008 R2 64bits (Xeon Quad Core E31220 @ 3.1 Ghz) , with much smaller databases (2-4GB Range), and on Firebird Super Server

RE: [firebird-support] Re: Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2

17.02.2014 21:36, Marius Labuschagne wrote: > > Example: Executing the Month-End in our application, exact same > database: > > - On a Win 2008 R2 64-bit Xeon Machine with 8GB RAM: 55 Minutes > > - On a Win 7 Pro 64-bit I3 machine with 8GB RAM: 9 Minutes Isn't a Win

RE: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2

t not be working. We are using Windows 2008 R2 64 bits, with databases around 35 Gb, and we solved the performance problems with FB 2.5.2. We tested it before and after apply the patch in 2.5.2 versión and verify that the problems was gone. I thin you have to look up in other direction

RE: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2

they will provide more details who they achieved it. [Marius Labuschagne] Hi Alexey, I suppose we all have our opinions. I do not agree with yours though, as out of the "box" installs of Firebird, no tweaked configurations for Firebird, performs well on all configurations and OS'

RE: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2

nical support for free in this support list, sorry. Try other Firebird service providers: http://www.firebirdsql.org/en/professional-support/ may be they have free time. Regards, Alexey Kovyazin IBSurgeon [Marius Labuschagne] What you doing in this forum Alexey? As far as I am aware this is a

[firebird-support] Optimizing this select Query

Hi, Is it possible to optimize the following select query? I make use of Firebird 2.5.2.26540 in Super Server mode. The query looks like this: SELECT Sum(SALEITEMS.QUANTITY), Sum(SALEITEMS.QUANTITY * SALEITEMS.COSTPRICEEX) FROM SALES SALES INNER JOIN SALEITEMS SALEITEMS

RE: [firebird-support] Optimizing this select Query

SALES.POSTSTATUS = 'Posted' AND SALES.SALE_DATE BETWEEN :vStartDate AND :vEndDate AND SALEITEMS.SKU+0 = :vSKU AND SALES.CASHCREDIT = 'Cash' and see if it uses the Date index. see you ! __,_._,__ [Marius Labuschagne] Hello Alexandre, Thanks for taking the time to ha

[firebird-support] Create Date of Database Object

Hi, Is it possible to see from the systems tables when a database object was created? For instance I want to try and find out when a specific trigger was created on the database, is this possible? Thanks Regards Marius J. Labuschagne N Dip CDP, B Com (Strategy and IT), IMM Mar

RE: [firebird-support] Firebird performance question

eceived this electronic transmission in error, please notify the sender and properly dispose of the information immediately. [Marius Labuschagne] Hi Bill, I don’t have the answer, but will also keep an eye on this question. What I can tell you as that I am running my Client sites on 2.5.3 Su

[firebird-support] unsupported on-disk structure

Hi, Can someone please comment on this scenario. I have been working on my machine for months, and suddenly this morning whenever I try to connect to any of my database stored on this machine I get the following error: unsupported on-disk structure for file C:\..\TD3.FDB; found 3277

RE: [firebird-support] unsupported on-disk structure

: firebird-support@yahoogroups.com Subject: Re: [firebird-support] unsupported on-disk structure At 06:25 p.m. 27/02/2015, 'Marius Labuschagne' mjlabuscha...@turnkey-is.co.za [firebird-s wrote: >Hi, > >Can someone please comment on this scenario. > >I have been working