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

[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
>>> one of them is waiting on a mutex or futex, ie it's dead locked. I've
>>> attached the trace.
>> You need to download the debug symbols (Firebird-debuginfo-* package)
>> and copy them into your FB installation directory. Then take the
>> backtrace again.
>>
> It locked again. 2.5.8 super server on 32-bit linux.
>

Note that we are using the event listener mechanism, and we think our 
deadlock issues may have started when we started using events, about 12 
months ago.

I see this issue in the tracker which looks familiar: 
http://tracker.firebirdsql.org/browse/CORE-4680 . However it's meant to 
be fixed in 2.5.5.



Hamish








++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

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

[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:
> >
> > 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. If you move it
> too, in-place credentials will be used.
>
> > In case of a server running in /classic /mode and case 2 (credentials in
>
> > a separate database), shall FB start a different process for each and
> > every connection just to verify user credentials?
>
> Nope, authentication uses the embedded connection, so new processes are
> not launched.
>
> Dmitry
>
> 
>

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

[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 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 this exception!
>
> I "recompile" the trigger or procedure that are affected and the error
> disappear!.
> It could be a bug in my relase of Firebird?
>
>
>
>
>
> Firebird Ver: WI-V6.3.7.27050 Firebird 2.5
> 
>

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

[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 engine is running. Do you have better ideas
> than /storage/emulated/legacy/firebird ?
> __._,_.__
>
I'm totally lost with Android folder structure,
each version have a different hierarchy, folder links, and permission
rules...

On my devices (one Android 4.4 and two 6.0) only the 4.4 have the folder
/storage/emulated/legacy .
The 6.0 have /storage/emulated/0

So, I don't have no idea of a place that works among several versions.

I will try to find more information about this.


ps:

Worse... I have the embedded running on Android 6 but on 4.4 I'm getting
the error :
SQL Message : -904
Unsuccessful execution caused by an unavailable resource.

Engine Code: 335544375
Engine Message :
unavailable database

both for local and remote connections and everything is in the same place


Regards
jGoncalves
_,_._,___



Virus-free.
www.avast.com

<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

[firebird-support] Performance regarding hard drive

['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 writing to the database is very slow, especially if the database is in 
backup mode and firebird is writing to a .delta file.

What in firebird.sql is important and what could I change (without risking 
data) to improve performance?


Regards,
  Steffen

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

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

450G free space.


> > I am sure there was no power outage and the system did not reboot.
> > There are no indications about hard drive errors in the logs.
> >
> > What could I do to find the source of this problem?
> 
>   Is it reproducible ?
> What is the current state of the database (gstat -h) ?
> Any messages at firebird.log around that time ?

I cannot test at the moment. The machine is at a remote location.
We are having it shipped here and I can inspect it then (if the problem stays).
I will report the result of gstat -h.

However I wasn't able to find a firebird.log file at all.
(This is a gentoo installation.)


Regards,
   Steffen

Re: [firebird-support] SecurityDatabase in FB3

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

   No.

> In case of a server running in /classic /mode and case 2 (credentials in a 
> separate 
> database), shall FB start a different process for each and every connection 
> just to verify 
> user credentials?

   No.

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

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

[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 is 
strange, but it works!


Thank you very much to everyone!!!

Another strange thing. I received some of your mails many hours later. 
For example, the mail from "Marsupilami79 marsupilam...@gmx.de" has date 
and time 20/02/2018 11:27 (am) but I received it this morning. The same 
thing happened with other mails.



 Mensaje original 
*Asunto: *Re: [firebird-support] Re: Cannot open database file in local 
hard disk

*De: *Eduardo 
*A: *firebird-support@yahoogroups.com
*Fecha: *20/02/2018 19:11


Good news!!!
With the tip of Neil I found a strange solution. I did the following:

Try to open a database file with IB_SQL. I couldn't.
Restart Firebird service.
Try to open a database file with IB_SQL. I couldn't.
Make a copy of the original Firebird.conf, which has the commented 
line #DatabaseAccess = Full.

In Firebird.conf, uncomment the line DatabaseAccess = Full.
Restart Firebird service.
Try to open a database file with IB_SQL. I could!
Delete the modified Firebird.conf and restore the original one, which 
has the commented line #DatabaseAccess = Full.

Restart Firebird service.
Try to open a database file with IB_SQL. I could!

Conclusion: Now I have the same Firebird.conf as an hour ago, but 
everything is working fine.



 Mensaje original 
*Asunto: *Re: [firebird-support] Re: Cannot open database file in 
local hard disk

*De: *Eduardo 
*A: *firebird-support@yahoogroups.com
*Fecha: *20/02/2018 16:35


As you say, that sounds to be related, but unfortunately I found that 
line commented as it is by default. Every line related with 
DatabaseAccess is commented. I even compared the whole file 
firebird.conf with the one in another computer with the same Windows 
(in which one I don't have the problem), and they are identical.


I thought of restarting Firebird anyway, but I can´t do it now 
because there are people working. I will do it later.



 Mensaje original 
*Asunto: *Re: [firebird-support] Re: Cannot open database file in 
local hard disk
*De: *'Neil Pickles' neil.pick...@csy.co.uk [firebird-support] 


*A: *
*Fecha: *20/02/2018 14:49


In your firebird.conf file, is the following line uncommented (# removed
from the start), if it is add the hash, restart Firebird and try again.

# DatabaseAccess = None

According to the notes in the default firebird.conf file having that
line enabled would mean only files referenced in aliases.conf could be
opened which sounds a lot like your problem.

# Database Paths/Directories

#

# DatabaseAccess may be None, Full or Restrict. If you choose Restrict,

# provide ';'-separated trees list, where database files are stored.

# Relative paths are treated relative to RootDirectory entry

# (see above). Default value 'Full' gives full access to all files

# on your site. To specify access to specific trees, enum all required

# paths (for Win32 this may be something like 'C:\DataBase;D:\Mirror',

# for unix - '/db;/mnt/mirrordb'). If you choose 'None', then only

# databases listed in aliases.conf can be attached.

Regards,

Neil Pickles

Technical Director

CSY House, 9-10 Chase Park, Daleside Road, Nottingham, NG2 4GT

T: 0115 911 1677 M: 07801 316711 F: 0115 959 0959

--
--

@csyretail 
www.csy.co.uk  n...@csy.co.uk


Registered in England No. 2391386, Vat No GB 520 7385 59, Registered
Address: CSY House, 9-10 Chase Park, Daleside Road, Nottingham, NG2 4GT.
Tel 0115 948 4848, Fax 0115 959 0959.

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Sent: 20 February 2018 17:36
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Re: Cannot open database file in local
hard disk

In every computers I tried there is exactly the same version of Firebird
installed: 2.1.4.18393 32 bits.

The databases where generated with the same version of Firebird. And
remember that if I use an alias, I can open the database. The problem is
when I try to open it using the path of the database file C:\Test\...
..FDB.

I can even generate the database in the same computer (using an alias)
and then I cannot open it using the path of the database file.

 Mensaje original 
Asunto: Re: [firebird-support] Re: Cannot open database file in local
hard disk
De: 'Neil Pickles' neil.pick...@csy.co.uk [firebird-support]


A: 

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

[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 this exception!

I "recompile" the trigger or procedure that are affected and the error
disappear!.
It could be a bug in my relase of Firebird?





Firebird Ver: WI-V6.3.7.27050 Firebird 2.5

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

[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. 335544382. Can't allocate difference page
 > 
 > 
> Can someone tell me what is going on?

  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.

> I am sure there was no power outage and the system did not reboot.
> There are no indications about hard drive errors in the logs.
 > 
> What could I do to find the source of this problem?

  Is it reproducible ? 
What is the current state of the database (gstat -h) ?
Any messages at firebird.log around that time ?

Regards,
Vlad

[firebird-support] Re: SecurityDatabase in FB3

[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. If you move it 
too, in-place credentials will be used.

> In case of a server running in /classic /mode and case 2 (credentials in 
> a separate database), shall FB start a different process for each and 
> every connection just to verify user credentials?

Nope, authentication uses the embedded connection, so new processes are 
not launched.


Dmitry

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

['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 is going on?
I am sure there was no power outage and the system did not reboot.
There are no indications about hard drive errors in the logs.

What could I do to find the source of this problem?


Best regards,
   Steffen

[firebird-support] SecurityDatabase in FB3

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

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?

In case of a server running in *classic *mode and case 2 (credentials in a
separate database), shall FB start a different process for each and every
connection just to verify user credentials?

Thanks in advance
Alex