[firebird-support] Can't shutdown database

2014-05-19 Thread markovdmi...@yahoo.com [firebird-support]
Hello. I have one big trouble. Classic server or superclassic sometimes can't shutdown database without killing of all processes fb_inet_server.exe I try to force shutdown without waiting time, I have mechanism that guarantees that all user logout and close program, but something wrong.

Re: [firebird-support] Re: database became broken for any reasons

2014-05-19 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
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

[firebird-support] Re: database became broken for any reasons

2014-05-19 Thread markovdmi...@yahoo.com [firebird-support]
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

Re: RES: [firebird-support] Re: database became broken for any reasons

2014-05-19 Thread markovdmi...@yahoo.com [firebird-support]
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

[firebird-support] Re: Performance of Stored Procedures versus execute blocks

2014-05-19 Thread Lafras Henning laf...@xietel.com [firebird-support]
Thanks Thomas, You make a good point about compile time SP optimisation becoming stale as the data changes, but this can simply become a maintenance task, along with monitoring of index efficiency, doing backups, and sweeping. This should be a proviso to the assumptions. But I stepped

Re: RES: [firebird-support] Re: database became broken for any reasons

2014-05-19 Thread Helen Borrie hele...@iinet.net.au [firebird-support]
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

Re: [firebird-support] Re: Performance of Stored Procedures versus execute blocks

2014-05-19 Thread Thomas Beckmann thomas.beckm...@assfinet.de [firebird-support]
Hi Lafras, I'm sorry to not dig in that deep again, but your assumptions are starting to get a bit complex. Few thoughts: - Not only sorting, but narrowing procedure result sets (where, join, on) is not performed by indexed search. - The main software architectural argument to write a stored

Odp: [firebird-support] Re: database became broken for any reasons

2014-05-19 Thread 'liviusliv...@poczta.onet.pl' liviusliv...@poczta.onet.pl [firebird-support]
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

Re: RES: [firebird-support] Re: database became broken for any reasons

2014-05-19 Thread Markov Dmitri markovdmi...@yahoo.com [firebird-support]
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,