Re: [firebird-support] Ouch!

2015-02-28 Thread Markov Dmitri markovdmi...@yahoo.com [firebird-support]
Hello, Did you try to read this manual http://www.firebirdsql.org/manual/ubusetup.html ? I'm ubuntu user, too. And Unubtu have strong security for the first time. I have two proplems: 1) firebird don't allow connect, it's changed in firebird.conf 2) user f

Re: [firebird-support] Question about a package

2014-12-04 Thread Markov Dmitri markovdmi...@yahoo.com [firebird-support]
Hi! I can't answer on your question, but did you try use zip-install? If I right you can stop FB, replace current files of FB by files from archive and then start FB(I do such things when test one of nightly snapshots of FB). Not .MSI but it may work for you. 04.12.2014 11:41, 'Romain BOUSSY'

Re: [firebird-support] Firebird v2.5 running Classic mode

2014-10-13 Thread Markov Dmitri markovdmi...@yahoo.com [firebird-support]
Taskkill will be ok if no one user worked with yours database and no internal process worked with your database. And it's not OK when you have more than one database on such server, because you interrupt working sessions to another databases. I corrupted databases very well with such method. I

Re: [firebird-support] Firebird v2.5 running Classic mode

2014-10-13 Thread Markov Dmitri markovdmi...@yahoo.com [firebird-support]
If you execute taskkill /IM fb_inet_server.exe /F then you are kill your database(broken indexes, missing data or some else things. if autosweep is on, you may completely kill your database). If your users is not sysdba or owner of database use shutdown mode, this method rollback all transaction

Re: [firebird-support] Re: Simultaneous inserts / selects

2014-10-09 Thread Markov Dmitri markovdmi...@yahoo.com [firebird-support]
At the same time really about 50-70 threads writing data. Some threads reading data and some others writing. One insert in one transaction(it's feature of my task, I can't do it in another way). Today server without 1GB interface - it's not server. But if you will start application local it's al

Re: [firebird-support] Simultaneous inserts / selects

2014-10-09 Thread Markov Dmitri markovdmi...@yahoo.com [firebird-support]
I have such experience. If you understand what you want and how to create table that will be very fast all will be ok. But If you never done something like this as the result you may create more slowly multithreading application. For today I have one application that without any problem in the

Re: [firebird-support] Problem with Firebird 2.5.3 disconnects

2014-10-08 Thread Markov Dmitri markovdmi...@yahoo.com [firebird-support]
Are you install FB from package of distro or by hands use official FB installer? Are you try downgrade to 2.5.2? Are you upgraded client library on Windows side? 09.10.2014 06:39, 'Edward Mendez' emendez...@nc.rr.com [firebird-support] пишет: Hello, In our production environment we have a F

Re: [firebird-support] Firebird SQL on Linux Centos 7 (Kernel 3.10)

2014-09-07 Thread Markov Dmitri markovdmi...@yahoo.com [firebird-support]
Hello, I don't use CentOS 7, but I use Debian and Ubuntu with kernel 3.14 and it's all work. I hope it will be helpful for you. It seems to me that in repos of CentOS not exist rpm package for FB, so you need to manual build and install it use source from FB website. Good luck ) 08.09.2014 05:

Re: [firebird-support] Anyone know what has happened to FIBPlus

2014-07-13 Thread Markov Dmitri markovdmi...@yahoo.com [firebird-support]
Hello, it seems to me that project closed. One of the part of Delphi XE5(there is version for XE4 too, but like additional pack components) and higher is FireDac(ex AnyDAC) it's more powerful set of components for database access than FibPlus. 14.07.2014 10:14, Maya Opperman m...@omniaccounts.

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

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

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

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

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

2014-05-19 Thread Markov Dmitri markovdmi...@yahoo.com [firebird-support]
ovdmi...@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 the database goes to

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 behavio

[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 an

[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. Wha

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

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

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

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

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

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

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

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

[firebird-support] database became broken for any reasons

2014-05-14 Thread markovdmi...@yahoo.com [firebird-support]
Hello. I wrote about databases that became broken for some time ago, for today I do big work for fixing this, but sometimes databases became broken without any reasons. 1. I turn of autosweep 2. I create new firebird user for my application, so that user can't modifi any metadata 3. I beca