Hi all,
I have a firebird server (FB 2.1, Superserver) on windows OS with database
file store on an external harddisk. There are about 5 users accessing this
database.
I never try or have NAS, is it possible just to move firebird db file from
external hardisk to NAS?
If this is possible
Doesn´t work.
The only way I found to alter a stored procedure in FB 2.5.2 , windows
64, SuperClassic is closing all conections and restarting the FB service.
Hugo
Em 18/08/2014 16:55, 'Carlos H. Cantu' lis...@warmboot.com.br
[firebird-support] escreveu:
Try to set the DDL transaction mode
By the way, greetings everyone!
This was my first post. I was composing it when by accident I sent it instead
of saving it, so my greetings did not make it into my post. Forgive me, I did
not meant to read ignorant.
Also, FB 2.5.0 has problems with this. If you use this version upgrade to
2.5.1 or above.
De: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Enviada em: segunda-feira, 18 de agosto de 2014 16:47
Para: firebird-support@yahoogroups.com
Assunto: Re: [firebird-support]
FB
De: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Enviada em: segunda-feira, 18 de agosto de 2014 16:47
Para: firebird-support@yahoogroups.com
Assunto: Re: [firebird-support] object is in use
Hello Carlos.
Thanks.
I am using IBExpert to run an 'CREATE
Hello Carlos.
Thanks.
I am using IBExpert to run an 'CREATE OR ALTER PROCEDURE MY_PROCEDURE."
That´s why I am not understending what can avoid to execute this.
This PROCEDURE just returns a value from a table.
I should be able to drop and insert a PROCEDURE at anytime into the DB.
Should
I agree
Em 18/08/2014 16:29, 'Leyne, Sean' s...@broadviewsoftware.com
[firebird-support] escreveu:
> To avoid such error, try to change the DDL transaction parameter to WAIT
> instead of NO WAIT.
While this would avoid the error, you will not know when/if your
change will be applied.
A c
LSSBcfs> While this would avoid the error, you will not know when/if your
change will be applied.
LSSBcfs> A connection can hold an object in use for an indeterminant period of
time.
Dmitry said to me sometime ago that procedures changes will be
executed immediately and not get held. I tested an
> To avoid such error, try to change the DDL transaction parameter to WAIT
> instead of NO WAIT.
While this would avoid the error, you will not know when/if your change will be
applied.
A connection can hold an object in use for an indeterminant period of time.
For me, I want to know that the
Usually, if you turn FW = ON on Linux, and your filesystem has barrier
enabled, it will affect performance of batch updates really badly.
You would either accept the performance degradation, or disable one of
them (FW or barrier).
Carlos
Firebird Performance in Detail - http://videos.firebirddeve
Hi Carlos.
Where do I chage it?
Hugo
Em 18/08/2014 15:06, 'Carlos H. Cantu' lis...@warmboot.com.br
[firebird-support] escreveu:
To avoid such error, try to change the DDL transaction parameter to
WAIT instead of NO WAIT.
Carlos
Firebird Performance in Detail - http://videos.firebirddevelope
On 2014-08-18 14:51, Aldo Caruso aldo.car...@argencasas.com
[firebird-support] wrote:
>After that I noticed that some massive updates ( 100K records ) took
> nearly 5 minutes, whereas with async writes it used to take 10 seconds.
Of course, we don't know how much work actually took place duri
>Given this scenario my questions are the following:
>
> 1) Does it makes sense to activate forced writes on Linux ?
Different versions of Linux file systems provide better protection than others.
Personally, I believe that forced write = ON is necessary for all OS -- but I
suspect that I
Hello,
For reliability reasons, I decided to turn on forced writes on a
database running on Linux.
After that I noticed that some massive updates ( 100K records ) took
nearly 5 minutes, whereas with async writes it used to take 10 seconds.
One solution is, of course, disabling sync wr
To avoid such error, try to change the DDL transaction parameter to
WAIT instead of NO WAIT.
Carlos
Firebird Performance in Detail - http://videos.firebirddevelopersday.com
www.firebirdnews.org - www.FireBase.com.br
HEhmcfs> Hello.
HEhmcfs> IBExpert shows the message:
HEhmcfs> lock conflict on
Maybe this can help:
SELECT st.mon$statement_id as "Statement ID",
st.mon$attachment_id as "Attachment ID",
st.mon$transaction_id "Transaction ID",
case
when st.mon$state = 0 then 'IDLE'
when st.mon$state = 1 then 'ACTIVE'
end as "State",
Hello.
IBExpert shows the message:
lock conflict on no wait transaction
unsuccessful metada update
object MY_PROCEDURE is in use
How can I see 'who' is using the procedure?
--
Atenciosamente,
Hugo Eyng
Migration might be too strong a term - I don't want my Firebird database to
bear too much resemblance to an old Paradox database. The database might serve
similar logical purposes, though. The domain advice is good in general -
char(16) character set octets, for example, would probably be a go
The case-insensitive collation option sounds the most seemless. I might have
to choose character sets more carefully - the DB I tested with was ISO8859_1
for a default, and I couldn't find a CI collation for it (maybe I needed to
look harder). The second is basically a simpler version of what
Sorry - it's been a long time since I last posted. My OP was verbose, lengthy
on preamble. I've gotten too accustomed to emailing users. Thanks.-MB
I can now tell all you guys, that my current antivirus program F-Secure is
causing all this to happen.
If I disable, the problem goes away.
So I have no problem anymore.
Michael
Hello
I have a strange problem, which I have no idea at the moment how to solve.
Let me see if I can describe the problem.
1.
I start my program.
When this happens, I connect to a licens DB (using user OCCLICENS), check some
records, disconnects and continue.
Now the program connect
On 17 Aug 2014 12:05:08 -0700, "vogonjeltzprostet...@yahoo.com
[firebird-support]" wrote:
> This was something I would resort to years ago in Paradox. Suppose I
had
> a table CORPORATION with columns S_KEY INTEGER, SUBSIDIARY_NAME CHAR(50)
> and a table EMPLOYEE with columns CORPORATION_S_KEY INT
>The problem comes with the second. (1, 'Bob Jacobs'), (2, 'Bob Jacobs'), (3,
>'BOB JACOBS'), and (4, 'bob jacobs') constitute an acceptable set of rows;
>(2, 'Bill Hafner') and (2, 'BILL HAFNER') do not. That is, given a value for
>CORPORATION_S_KEY, there shouldn't be case-variants for the N
26 matches
Mail list logo