nt connection
After that you are only logged user
Regards,
Karol Bieniaszewski
- Reply message -
Od: "Markov Dmitri markovdmi...@yahoo.com
[firebird-support]"
Do:
Temat: [firebird-support] Re: database became broken for
any reasons
Data: wt., maj 20, 2014 20:22
] пишет:
>>
>>
>> Hi,
>>
>> Delete from mon$attachments excluding current connection
>> After that you are only logged user
>>
>> Regards,
>> Karol Bieniaszewski
>>
>> - Reply message -
>> Od: "Markov Dmitri marko
] пишет:
>>
>>
>> Hi,
>>
>> Delete from mon$attachments excluding current connection
>> After that you are only logged user
>>
>> Regards,
>> Karol Bieniaszewski
>>
>> - Reply message -
>> Od: "Markov Dmitri marko
d user
Regards,
Karol Bieniaszewski
- Reply message -
Od: "Markov Dmitri markovdmi...@yahoo.com [firebird-support]"
Do:
Temat: [firebird-support] Re: database became broken for any reasons
Data: wt., maj 20, 2014 20:22
I turn off automatic sweep - only manual sweep.
For today
Hi,
Delete from mon$attachments excluding current connection
After that you are only logged user
Regards,
Karol Bieniaszewski
- Reply message -
Od: "Markov Dmitri markovdmi...@yahoo.com [firebird-support]"
Do:
Temat: [firebird-support] Re: database became broken for any re
I turn off automatic sweep - only manual sweep.
For today I try to change keepalive parameters - it's look like all ok.
All processes named fb_inet_server.exe closed, but it's work if
connection was lost. It's not work when the connection established and
not closed for any reasons(for example t
I like very much the way Ann explains, almost impossible to be more clear.
Greetings.
Walter.
On Tue, May 20, 2014 at 10:47 AM, Ann Harrison
aharri...@ibphoenix.com[firebird-support]
wrote:
>
>
> On Mon, May 19, 2014 at 1:31 PM, markovdmi...@yahoo.com[firebird-support]
> wrote:
>
>>
>>
>> F
On Mon, May 19, 2014 at 1:31 PM, markovdmi...@yahoo.com [firebird-support] <
firebird-support@yahoogroups.com> wrote:
>
>
> For preventing orphan pages or backversions I turn off autosweep. So for
> the last month I don't see any orphan pages or orphan backversions.
>
Probably you were shutting t
No, FBGuardian not installed on this servers. I don't know how it may be
possible to install FBGuardian with standard installer of FB
2.5.2.26540, when you check classic server.
19.05.2014 22:47, Helen Borrie hele...@iinet.net.au [firebird-support]
?:
At 06:01 a.m. 20/05/2014, markovdmi.
Hi,
If you have problem with shotdown database then unplug lan cable to have sure ;)
Regards,
Karol Bieniaszewski
- Reply message -
Od: "markovdmi...@yahoo.com [firebird-support]"
Do:
Temat: [firebird-support] Re: database became broken for any reasons
Data: pon., maj 19,
At 06:01 a.m. 20/05/2014, markovdmi...@yahoo.com [firebird-support] wrote:
>I kill fb_inet_server.exe because sometimes database not go into shutdown
>state or not go into on-line mode, I don't know what, but something hold
>database so no one can work with database. If I kill fb_inet_server.ex
I kill fb_inet_server.exe because sometimes database not go into shutdown state
or not go into on-line mode, I don't know what, but something hold database so
no one can work with database. If I kill fb_inet_server.exe the database goes
to shutdown mode or in on-line mode. I may see this behavio
-support@yahoogroups.com]
Enviada em: segunda-feira, 19 de maio de 2014 14:31
Para: firebird-support@yahoogroups.com
Assunto: [firebird-support] Re: database became broken for any reasons
During of my database service procedure I check that I can do backup and can
restore that backup, so I
During of my database service procedure I check that I can do backup and can
restore that backup, so I also know about problems of corrupted bacups and
possible reasons of metadata corruption. For preventing orphan pages or
backversions I turn off autosweep. So for the last month I don't see an
On Fri, May 16, 2014 at 1:46 AM, markovdmi...@yahoo.com [firebird-support] <
firebird-support@yahoogroups.com> wrote:
>
>
> I use gfix for define broken DB or not, and I try to do backup and restore.
> I may see a lot of diffrent errors, for example orphan pages, corrupted
> indexes, also orphan b
I use gfix for define broken DB or not, and I try to do backup and restore. I
may see a lot of diffrent errors, for example orphan pages, corrupted indexes,
also orphan backversions, but the last is not a error for database.
It seems to me I mistake, because Sinática Monitor shows a lot of "Stuck
Transactions" I don't understand what I must doing with this transactions?
Ok, I understand you.
I found that there are some transaction that waiting commit or rollback on the
real server for some hours, it seems to me it's a big problem.
Thank you for your help
Well, Dimitri,
I don't know whether it's ok for the people at the other end of the
killed connection, because their operation is cancled and rolled back,
but at least, you don't get database corruptions, if you close all
connections and shut down database regularly...
Best regards, Thomas
Am 15.
So if I kill all connections(clear table MON$ATTACHMENT) and then I'll try to
kill processes all will be ok(or myabe I don't need it)?
I'll try to do such example:
1) I connect from remote computer to test server using SYSDBA, not my user
2) I start big select (it's take about 2-3 minutes, re
20 matches
Mail list logo