[firebird-support] Digital signing of Firebird executables, installers etc.
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 03 8649 2359 | M 0467 747 382 | E john.frankl...@team.telstra.com | W www.telstra.com/eme This communication may contain confidential or copyright information of Telstra Corporation Limited (ABN 33 051 775 556). If you are not an intended recipient, you must not keep, forward, copy, use, save or rely on this communication, and any such action is unauthorised and prohibited. If you have received this communication in error, please reply to this email to notify the sender of its incorrect delivery, and then delete both it and your reply.
Re: [firebird-support] Re: out-of-memory failure with BLOB
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. -- 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: out-of-memory failure with BLOB
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...
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: { connect = >p_cnct; //is this really some function call? Function with name/address p_cnct? So - the call packet->p_cnct determines all. I hoped to narrow down the call stack to the single socket operation from which I could deduce the result of packet->p_operation (the full list of possible values are in the protocol.h P_OP enumeration) but at present I can not do it. My understanding is that p_cnct is expanded further and the resulting determination of the value of p_operation involves both technical (e.g. connectivity issues) and logical (e.g. some kind of processing of connection data done by Firebird server) factors, so I can not rely that those factors would be logged in some journals of the operating system. I see that xdr_protocol involved DEBUG_XDR_PACKET(xdrs, p); i.e. I could catch the error using the debug relesae of the server/client... But I am not user whether I can put debug release in the production environment...
Re: [firebird-support] Re: out-of-memory failure with BLOB
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 application to release it. -- 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] How to troubleshoot "connection rejected by remote interface" error? Something has got wrong...
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 version can create such errors, but those are deterministic errors that happens always. In my case the error appears and disappers. I checked: - CPU, RAM consumption by the Fireird service is normal - there are no errors in firebird.log - there are no antiviruses or firewalls - telnet server 3050 is OK and ping is also OK - the error happens during connection time only, once the user is connected to the server, the connection remains and there are no problems. This is Firebird 2.1 on Linux machine, but such errors can happen with later version as well, web has many request for help. There is the following code in the Firebird sources: {335544421, "connection rejected by remote interface"}, /* 101, connect_reject */ const ISC_STATUS isc_connect_reject = 335544421L; #define isc_connect_reject 335544421L inet.cpp / xnet.cpp / wnet.cpp rem_port* INET_analyze(Firebird::PathName& file_name,... { ... PACKET* packet = >rdb_packet; ... rem_port* port = inet_try_connect(packet, rdb, file_name, node_name, status_vector, dpb, dpb_length); ... if (packet->p_operation != op_accept) { *status_vector++ = isc_arg_gds; *status_vector++ = isc_connect_reject; *status_vector++ = 0; disconnect(port); return NULL; } ... } OK, the conclusions are that "connection rejected by remote interface" happens when there is no op_accept, i.e. Firebird does not try to analyse or log/journal the real status of p_operation and the cause why the p_operation is not op_accept. Essentially, this is code block that should have never been reached and that is why it is not elaborated. However - such errors happen and what to do in those case? Are there some Linux logs that journals off the cases when p_operation is not op_accept. And essentially - as I can understand, then the cited code occurrs on the client machine, so, there can be network errors as well, but why Firebird code puts all the blame on the rejection of the server? So confused... From "gds32.dll" in your post I understand the client is on windows, right? Windows often reports "connection rejected by remote interface" while in fact the local firewall (on the clients machine) is getting in the way. Just my 2 cents
Re: [firebird-support] How to troubleshoot "connection rejected by remote interface" error? Something has got wrong...
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. ++ 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/
[firebird-support] How to troubleshoot "connection rejected by remote interface" error? Something has got wrong...
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 always. In my case the error appears and disappers. I checked: - CPU, RAM consumption by the Fireird service is normal - there are no errors in firebird.log - there are no antiviruses or firewalls - telnet server 3050 is OK and ping is also OK - the error happens during connection time only, once the user is connected to the server, the connection remains and there are no problems. This is Firebird 2.1 on Linux machine, but such errors can happen with later version as well, web has many request for help. There is the following code in the Firebird sources: {335544421, "connection rejected by remote interface"}, /* 101, connect_reject */ const ISC_STATUS isc_connect_reject = 335544421L; #define isc_connect_reject 335544421L inet.cpp / xnet.cpp / wnet.cpp rem_port* INET_analyze(Firebird::PathName& file_name,... { ... PACKET* packet = >rdb_packet; ... rem_port* port = inet_try_connect(packet, rdb, file_name, node_name, status_vector, dpb, dpb_length); ... if (packet->p_operation != op_accept) { *status_vector++ = isc_arg_gds; *status_vector++ = isc_connect_reject; *status_vector++ = 0; disconnect(port); return NULL; } ... } OK, the conclusions are that "connection rejected by remote interface" happens when there is no op_accept, i.e. Firebird does not try to analyse or log/journal the real status of p_operation and the cause why the p_operation is not op_accept. Essentially, this is code block that should have never been reached and that is why it is not elaborated. However - such errors happen and what to do in those case? Are there some Linux logs that journals off the cases when p_operation is not op_accept. And essentially - as I can understand, then the cited code occurrs on the client machine, so, there can be network errors as well, but why Firebird code puts all the blame on the rejection of the server? So confused...
Re: [firebird-support] out-of-memory failure with BLOB
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. ++ 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/
[firebird-support] out-of-memory failure with BLOB
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 process) My test was made with fbserverser 3.04 32Bit To reproduce the issue, just execute the script below After suspend, allocated memory should be release no ? Thank you Eric SET TERM ^ ; CREATE OR ALTER PROCEDURE BLOB_MEMORY RETURNS ( B BLOB SUB_TYPE 1 SEGMENT SIZE 80) AS begin b = 'Test'; suspend; end^ CREATE OR ALTER PROCEDURE BLOB_MEMORY_TEST RETURNS ( B BLOB SUB_TYPE 1 SEGMENT SIZE 80) AS declare variable i integer; begin i = 0; while (i < 15E6) do begin select b from BLOB_MEMORY into b; i = i+ 1; suspend; end end^ SET TERM ; ^ SELECT * FROM BLOB_MEMORY_TEST;
Re: [firebird-support] "12. Don't forget to enable file cache with big Firebird cache page"
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 provide details about it. Regards, Alexey Kovyazin IBSurgeon On 09.01.2019 10:57, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: 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 again. Then yes, Windows cache can be more than benefit here - but we can turn on linger to achive near the same. 2. Database is bigger than Firebird cache. Than using also system cache can increase performance as there is a chance that Windows will cache some portion of database not cached by FB itself. And Windows can decide then, if it neeed cache other files or some portion of DB. Is there any benefit of enabling system cache if Firebird cache is set to bigger value than database itself? I see oposite performance in such situation. But difference is marginally from 0 to 5% difference - than i do not know if there is any difference or i see some other process involved. Arethere other situations when enabling system cache will benefit also? regards, Karol Bieniaszewski
[firebird-support] "12. Don't forget to enable file cache with big Firebird cache page"
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 again. Then yes, Windows cache can be more than benefit here - but we can turn on linger to achive near the same. 2. Database is bigger than Firebird cache. Than using also system cache can increase performance as there is a chance that Windows will cache some portion of database not cached by FB itself. And Windows can decide then, if it neeed cache other files or some portion of DB. Is there any benefit of enabling system cache if Firebird cache is set to bigger value than database itself? I see oposite performance in such situation. But difference is marginally from 0 to 5% difference - than i do not know if there is any difference or i see some other process involved. Are there other situations when enabling system cache will benefit also? regards, Karol Bieniaszewski