[firebird-support] FB3 stability ...

2019-02-25 Thread Lester Caine les...@lsces.co.uk [firebird-support]
OK ... Have development system upgraded and currently running SUSE Leap 15.0 out of the box so ... Firebird 3.0.2 PHP 7.2.5 Nginx 1.14.0 ( Apache is locked out ) Getting the following randomly ... Warning: fbird_connect(): Your user name and password are not defined. Ask your database administ

Re: [firebird-support] FB3 stability ...

2019-02-25 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 25-2-2019 12:22, Lester Caine les...@lsces.co.uk [firebird-support] wrote: > OK ... Have development system upgraded and currently running SUSE Leap > 15.0 out of the box so ... > > Firebird 3.0.2 > PHP 7.2.5 > Nginx 1.14.0 ( Apache is locked out ) 3.0.3 fixed 87 issues, 3.0.4 fixed 74 issues

Re: [firebird-support] FB3 stability ...

2019-02-25 Thread Lester Caine les...@lsces.co.uk [firebird-support]
On 25/02/2019 11:34, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > On 25-2-2019 12:22, Lester Caine les...@lsces.co.uk [firebird-support] > wrote: >> OK ... Have development system upgraded and currently running SUSE Leap >> 15.0 out of the box so ... >> >> Firebird 3.0.2 >> PHP

Re: [firebird-support] FB3 stability ...

2019-02-25 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
25.02.2019 12:34, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > No clue why you'd get that error randomly Because it is not a real error. CORE-4964 hides errors caused by failing connection to security database. Some of them were fixed in post releases. -- WBR, SD. -

Re: [firebird-support] FB3 stability ...

2019-02-25 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 25-2-2019 12:51, Lester Caine les...@lsces.co.uk [firebird-support] wrote: > ALL I have enabled in the config file is Legacy ... srp is not listed at > all, so why should creating an srp user be necessary? I've not looked to > that side at all yet ... just more reading for something I don't see

[firebird-support] optimal free disk space

2019-02-25 Thread shg_siste...@yahoo.com.ar [firebird-support]
Hello! I use FB 2.5, The server has a 150 GB HD and it has 20 GB free. My database is about 800MB in size. Do you think having 20GB of free disk space may be a problem? I'm experiencing a very bad performance lately and I can't figure out what can it be. Database header page information

Re: [firebird-support] optimal free disk space

2019-02-25 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
25.02.2019 13:57, shg_siste...@yahoo.com.ar [firebird-support] wrote: > Do you think having 20GB of free disk space may be a problem? No.Problem is drive's speed and badly designed application that you use. First problem you can solve with SSD and Firebird 4, second problem requires a program

Re: [firebird-support] FB3 stability ...

2019-02-25 Thread Lester Caine les...@lsces.co.uk [firebird-support]
On 25/02/2019 12:21, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > Or you could just try it to see if it helps. You have repeatedly posted > similar problems over the last few months, and I don't get the > impression you made any progress on it. I have been making progress, but

Re: [firebird-support] FB3 stability ...

2019-02-25 Thread Lester Caine les...@lsces.co.uk [firebird-support]
On 25/02/2019 14:06, Lester Caine les...@lsces.co.uk [firebird-support] wrote: > A search for firebird on Leap 15.1 packages does not even give a result > and across all versions only returns the PHP clients. But I know I've > seen a repo for databases with 3.0.4 in ... so now to find where it is

Re: [firebird-support] optimal free disk space

2019-02-25 Thread liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
Hi. To extend this answer i can only say that you have long running transaction. Look at your last active and next. Go to mon$transaction and look which transaction is so old Regards,Karol Bieniaszewski null

[firebird-support] Re: optimal free disk space

2019-02-25 Thread shg_siste...@yahoo.com.ar [firebird-support]
Thanks! Now I see why Dimitry said it was a problem of badly designed program. I always try to be very carefull with transactions, but clearly I'm missing something here. The problem are the read/writte transactions, right? No problem with the read only ones? Is it possible to know which

[firebird-support] Select on view using isql return nothing.

2019-02-25 Thread Marcelo Guimaraes mfguimar...@gmail.com [firebird-support]
Hello everyone! I'm executing a query on IBexpert on a view and I'm getting the result as expected but when I try on the isql, with the same user and the same query, it return 0. Does any one know why and how to solve this? Regards, Marcelo GuimarĂ£es

Re: [firebird-support] Re: optimal free disk space

2019-02-25 Thread Omacht AndrĂ¡s aoma...@mve.hu [firebird-support]
with the read only ones? Is it possible to know which tables where updated inside a particular transaction? thanks a million!! __ Information from ESET Mail Security, version of virus signature database 18933 (20190225) __ The message was checked by ESET Mail Security.

Re: [firebird-support] Re: optimal free disk space

2019-02-25 Thread 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support]