Hi everyone,
Is there a way to check forced writes state (active or inactive) and alter
this via a SQL command?
Tks in advance.
[Non-text portions of this message have been removed]
On Thu, Nov 24, 2011 at 11:26 AM, Leonardo Carneiro
wrote:
> Hi everyone,
>
> Is there a way to check forced writes state (active or inactive) and alter
> this via a SQL command?
>
> Tks in advance.
>
Forgot to mention, i also want to check and alter the sweep interval, and
run manual sweep to. I
Hi everyone,
I'm having a quite bad time with one database. The firebird version is
2.1.4, running on a windows server 2003 r2 enterprise. For some weird
reason, the previous administrator thought that would be fun to disable
forced writes while in production, so the database was running this way
That's why I always insist to do not use -r switch.
I'll create ticket to exclude it completely from gbak, even if we will loose
some money from such unlucky guys :)
Regards,
Alexey Kovyazin
IBSurgeon Ltd (www.ib-aid.com)
- Reply message -
From: "Leonardo Carneiro"
To:
Subject: [firebi
Yep. When i first saw the mess, i deeply regreted the use of the -r switch
=(
Tried a -mend again:
C:\Arquivos de programas\Firebird\Firebird_2_1\bin>gfix -mend -full -user
SYSDBA -pas masterkey "c:\Arquivos de
programas\DDD_SYSTEM\Servidor\BD_COPY.FDB"
unable to allocate memory from operating sy
Wow, last error crashed the firebird process =P. Could not connect to
others database in the same server. Had to kill the process =(
On Thu, Nov 24, 2011 at 4:19 PM, Leonardo Carneiro
wrote:
> Yep. When i first saw the mess, i deeply regreted the use of the -r switch
> =(
>
> Tried a -mend again:
At 12:18 PM 24/11/2011, you wrote:
>I've a little problem with a sql statement:
>
>s_stmmain = 'insert into ' || :s_stmtable || '(kd_id, fnr, fbeginn, fende)
>values ('
>
> || :t_timestamp || ',' || cast(:i_fnr as varchar(4)) || ','
>
> || '' || ',' || '' || ')';
>
> execute
Tried IB-FirstAid+ trial, but gives me this messagem:
18:08:33 INFO: Open database files: C:\Arquivos de
programas\DDD_SYSTEM\Servidor\BD_COPY.FDB
18:08:33 Unrecognized database found.
On Thu, Nov 24, 2011 at 4:44 PM, Leonardo Carneiro
wrote:
> Wow, last error crashed the firebird process =P.
I think FBFirstAId will not help in this case. If you still have backup, you
can try to save data from it with IBBackupSurgeon - look with trial first.
Regards,
Alexey Kovyazin
- Reply message -
From: "Leonardo Carneiro"
To:
Subject: [firebird-support] gfix mend full deadlock
Date: Th
Hi,
Can I recognize locked records from PSQL in FB 1.5.6 ?
Best regards,
Jacek Borowski
++
Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledg
At 12:38 PM 25/11/2011, you wrote:
>Hi,
>
>Can I recognize locked records from PSQL in FB 1.5.6 ?
Perhaps explain what you mean by "locked records" ?
./heLen
Hello Helen,
Thank you very much.
Best regards.
Olaf
>I've a little problem with a sql statement:
>
>s_stmmain = 'insert into ' || :s_stmtable || '(kd_id, fnr, fbeginn, fende)
>values ('
>
> || :t_timestamp || ',' || cast(:i_fnr as varchar(4)) || ','
>
> || '' || ',' || '' ||
12 matches
Mail list logo
