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 the
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]
firebird-support@yahoogroups.com wrote:
On Mon, May 19, 2014 at 1:31 PM,
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
: [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 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
,
Karol Bieniaszewski
- Reply message -
Od: Markov Dmitri markovdmi...@yahoo.com [firebird-support]
firebird-support@yahoogroups.com
Do: firebird-support@yahoogroups.com
Temat: [firebird-support] Re: database became broken for any reasons
Data: wt., maj 20, 2014 20:22
I turn off automatic
excluding current connection
After that you are only logged user
Regards,
Karol Bieniaszewski
- Reply message -
Od: Markov Dmitri markovdmi...@yahoo.com [firebird-support]
firebird-support@yahoogroups.com
Do: firebird-support@yahoogroups.com
Temat: [firebird-support] Re: database
excluding current connection
After that you are only logged user
Regards,
Karol Bieniaszewski
- Reply message -
Od: Markov Dmitri markovdmi...@yahoo.com [firebird-support]
firebird-support@yahoogroups.com
Do: firebird-support@yahoogroups.com
Temat: [firebird-support] Re: database
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
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
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
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.exe
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]
firebird-support@yahoogroups.com
Do: firebird-support@yahoogroups.com
Temat: [firebird-support] Re: database
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,
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,
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
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
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?
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.
18 matches
Mail list logo
