[firebird-support] Digital signing of Firebird executables, installers etc.

2019-01-09 Thread 'Frankland, John' john.frankl...@team.telstra.com [firebird-support]
Hello Firebird support, Are there any plans on the horizon to digitally sign Firebird executables, installers etc.? If not can I raise this as an issue? Regards,  John Frankland  EME Systems Developer EME Management Education & Compliance | Wireless Network Engineering | Telstra Operations P  

Re: [firebird-support] Re: out-of-memory failure with BLOB

2019-01-09 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
09.01.2019 21:41, sdnetw...@gmail.com [firebird-support] wrote: > maybe could be release when it's read by the client May be. But what is read once can be read twice. Because of that you must be very careful with temporary blobs and don't keep transactions opened more than necessary. --

Re: [firebird-support] Re: out-of-memory failure with BLOB

2019-01-09 Thread sdnetw...@gmail.com [firebird-support]
maybe could be release when it's read by the client

[firebird-support] Re: How to troubleshoot "connection rejected by remote interface" error? Something has got wrong...

2019-01-09 Thread jonatan.laurit...@yahoo.dk [firebird-support]
It is superserver. I tried to skim the source code - tha call stack is: INET_analyze INET_connect send_full(port, packet) xdr_protocol(>port_send, packet) / bool_t xdr_protocol(XDR* xdrs, PACKET* p) case op_connect: {

Re: [firebird-support] Re: out-of-memory failure with BLOB

2019-01-09 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
09.01.2019 15:04, eric.gueguin...@gmail.com [firebird-support] wrote: > Why blob are not released in this case, why keep blob id ? If you learn Firebird API, you'll see that BLOB's content is requested to client separately. Server cannot predict that this BLOB won't be requested by client

Re: [firebird-support] How to troubleshoot "connection rejected by remote interface" error? Something has got wrong...

2019-01-09 Thread John vdW j...@jvdw.nl [firebird-support]
Op 09-01-2019 om 14:14 schreef jonatan.laurit...@yahoo.dk [firebird-support]: My client occassionally receives "connection rejected by remote interface" error while trying to connect to the remote server. I know that incompatibility of versions between gds32.dll/fbclient32.dll and server

Re: [firebird-support] How to troubleshoot "connection rejected by remote interface" error? Something has got wrong...

2019-01-09 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
09.01.2019 14:14, jonatan.laurit...@yahoo.dk [firebird-support] wrote: > This is Firebird 2.1 on Linux machine Classic or superserver? -- WBR, SD.

[firebird-support] How to troubleshoot "connection rejected by remote interface" error? Something has got wrong...

2019-01-09 Thread jonatan.laurit...@yahoo.dk [firebird-support]
My client occassionally receives "connection rejected by remote interface" error while trying to connect to the remote server. I know that incompatibility of versions between gds32.dll/fbclient32.dll and server version can create such errors, but those are deterministic errors that happens

Re: [firebird-support] out-of-memory failure with BLOB

2019-01-09 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
09.01.2019 11:51, eric.gueguin...@gmail.com [firebird-support] wrote: > After suspend, allocated memory should be release no ? No. Blobs whos ID was sent to client cannot be released until transaction end. -- WBR, SD.

[firebird-support] out-of-memory failure with BLOB

2019-01-09 Thread eric.gueguin...@gmail.com [firebird-support]
Hello, I have a issue with blob in a stored procedure with BLOB variable. Blob variable is returned by a suspend in a "while do", but the memory allocated to the blob is not released, so memory takes by fbserver increase until a out of memory failure (up to 2Go, the max size of a 32bit

Re: [firebird-support] "12. Don't forget to enable file cache with big Firebird cache page"

2019-01-09 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
Hi Karol, This advice is based on our experience - disabling file cache for big databases (definitely larger than RAM size) leads to slowness. I don't have explanation for this on the theoretical level. If you have real-world example when Firebird works faster without file cache, please

[firebird-support] "12. Don't forget to enable file cache with big Firebird cache page"

2019-01-09 Thread liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
Hi,   i have read on http://firebirdsql.org/ article "23 More Ways To Speed Up Firebird".   Can you explain me point "12. Don't forget to enable file cache with big Firebird cache page".   I can imagine difference only in 2 situations.   1. When all attachments are disconnected and connected