Re: [firebird-support] Re: server 2.5.8 deadlocked

2018-02-21 Thread Hamish Moffatt ham...@risingsoftware.com [firebird-support]
On 22/02/18 10:10, Hamish Moffatt ham...@risingsoftware.com [firebird-support] wrote: > On 13/02/18 17:55, Dmitry Yemanov dim...@users.sourceforge.net > [firebird-support] wrote: >> 13.02.2018 05:07, Hamish Moffatt wrote: >> >>> I attached gdb and dumped the state of all threads, which shows every

Re: [firebird-support] Re: SecurityDatabase in FB3

2018-02-21 Thread Alexander Tabakov a.taba...@eklektica.com [firebird-support]
Thanks Dmitry, So, generally speaking are there any benefits of embedding the credentials into the database - performance, security, other ? On Wed, 21 Feb 2018, 16:48 Dmitry Yemanov dim...@users.sourceforge.net [firebird-support], wrote: > 21.02.2018 15:46, Alexander Tabakov wrote: > > > > Wha

Re: [firebird-support] Fake error "arithmetic exception, numeric overflow..." on stored procedure or trigger

2018-02-21 Thread Anto Edin Charley antoedinchar...@gmail.com [firebird-support]
Check the size of trigger. Sometimes it show like this if the size reaches 64k. On Feb 21, 2018 21:11, "marco andreolli dra...@gmail.com [firebird-support]" wrote: > > > Hi, > Recently I have found the error *arithmetic exception, numeric overflow, > or string truncation* > > > *string right tru

Re: [firebird-support] Re: FB3 Embedded on Android

2018-02-21 Thread Jorge Gonçalves projo...@gmail.com [firebird-support]
On Mon, Feb 19, 2018 at 10:21 AM, peshk...@mail.ru [firebird-support] < firebird-support@yahoogroups.com> wrote: > > > The problem is where should we place tmp files (including lock files and > other shared files) now. Application cache may be at any moment cleaned > which will cause problems if fb

[firebird-support] Performance regarding hard drive

2018-02-21 Thread 'Steffen Heil (Mailinglisten)' li...@steffen-heil.de [firebird-support]
Hi I am trying to figure out, how to configure my system to get good performance. I am using - Linux (kernel 4.12/4.14) - Firebird 3.0.2 (3.0.3 soon) - database files on ex4 volumes For safety reasons I have - mounted the filesystem with data=journal - enabled forced writes in firebird Now writ

Re: [firebird-support] Re: server 2.5.8 deadlocked

2018-02-21 Thread Hamish Moffatt ham...@risingsoftware.com [firebird-support]
On 13/02/18 17:55, Dmitry Yemanov dim...@users.sourceforge.net [firebird-support] wrote: > 13.02.2018 05:07, Hamish Moffatt wrote: > >> I attached gdb and dumped the state of all threads, which shows every >> one of them is waiting on a mutex or futex, ie it's dead locked. I've >> attached the tra

AW: [firebird-support] Re: 335544382. Can't allocate difference page

2018-02-21 Thread 'Steffen Heil (Mailinglisten)' li...@steffen-heil.de [firebird-support]
Hi > In short: write to the difference file was not successfull. > > Common reason could be out of disk space or some other error at > filesystem\disk level. > Of course, there is always exists possiblilty of some kind of bug at the > engine itself... > but i never saw such errors before.

Re: [firebird-support] SecurityDatabase in FB3

2018-02-21 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
21.02.2018 13:46, Alexander Tabakov a.taba...@eklektica.com [firebird-support] wrote: > > What happens in case 3 (stored in the same database) when we move the > database on a > different server. Shall credentials stored in place take precedence over the > other > server's configuration?

Re: [firebird-support] Re: Cannot open database file in local hard disk

2018-02-21 Thread Eduardo guse...@gmail.com [firebird-support]
Hello everybody: Evidently, as many of you said, the problem was related to the parameter DatabaseAccess in firebird.conf. The strange thing is that this parameter was commented. So it should be the predetermined value, which I think is "Full". Now it is again commented and it is working. It i

[firebird-support] Fake error "arithmetic exception, numeric overflow..." on stored procedure or trigger

2018-02-21 Thread marco andreolli dra...@gmail.com [firebird-support]
Hi, Recently I have found the error *arithmetic exception, numeric overflow, or string truncation* *string right truncationAt trigger 'X'* on different trigger or stored procedure. The strange thing is that are not true, in the trigger or procedure there isn't any operation that coud produce

[firebird-support] Re: 335544382. Can't allocate difference page

2018-02-21 Thread hv...@users.sourceforge.net [firebird-support]
> ---In firebird-support@yahoogroups.com, wrote : > > > I am using firebird 3.0.2 and I access it using java (jaybird). > The system is running on linux 4.12. > > I am trying to execute the following statement: > ALTER DATABASE END BACKUP; > > Then I get the following error: > GDS Exception

[firebird-support] Re: SecurityDatabase in FB3

2018-02-21 Thread Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
21.02.2018 15:46, Alexander Tabakov wrote: > > What happens in case 3 (stored in the same database) when we move the > database on a different server. Shall credentials stored in place take > precedence over the other server's configuration? It depends on the databases.conf on the other server.

[firebird-support] 335544382. Can't allocate difference page

2018-02-21 Thread 'Steffen Heil (Mailinglisten)' li...@steffen-heil.de [firebird-support]
Hi I am using firebird 3.0.2 and I access it using java (jaybird). The system is running on linux 4.12. I am trying to execute the following statement: ALTER DATABASE END BACKUP; Then I get the following error: GDS Exception. 335544382. Can't allocate difference page Can someone tell me what

[firebird-support] SecurityDatabase in FB3

2018-02-21 Thread Alexander Tabakov a.taba...@eklektica.com [firebird-support]
Hi All, As I understand, using *SecurityDatabase *parameter we can essentially store user's credentials in three different places: 1. Server wide in security3.fdb 2. Per database in a separate database, e.g. c:\users\secret.fdb 3. Per database in the same database. I have the following questions