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
-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
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:
Thank you Alexey,
I will instruct my Client to execute another backup. Im 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
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
>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
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
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
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
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
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
[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
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
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
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
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'
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
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
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
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
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
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
: 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
23 matches
Mail list logo