[firebird-support] Re: request synchronisation error
If your application not see such error - don't worry. Sooner of all it is related with prefetch logic by network server and handled by it internally. Regards, Vlad
[firebird-support] request synchronisation error
Hello, we traced to find performance problems and we saw some messages output for example the following: 2016-03-17T09:01:52.5030 (2544:0C661670) ERROR AT JRequest::receive D:\INTERBASE\IFLS.GDB (ATT_21976, SYSDBA:NONE, NONE, TCPv4:192.168.0.70/50182) C:\WINDOWS\system32\gbak.exe:2340 335544364 : request synchronization error 2016-03-17T09:02:06.5480 (2544:0C663060) ERROR AT JResultSet::fetchNext D:\INTERBASE\IFLS.GDB (ATT_21539, SYSDBA:NONE, ISO88591, TCPv4:192.168.0.165/52623) \\fls\AP\FAP.exe:4296 335544364 : request synchronization error Is this only the trace or a general problem with the database? Thanks
[firebird-support] Re: Error with > 10 columns in SQL SELECT query using python firebirdsql
Thanks for this, I think you are right. A near identical installation on the production system didn't show this problem, and when I updated the firebirdsql python package on the test system the problem resolved. The database is primarily used as the backend for a niche commercial radiation measurement application which is rarely updated, so upgrading the database isn't really an option. My access to the database was just to hack the data and redirect it to a preferred data repository.But I appreciate the suggestion Gary
ODP: [firebird-support] Compiling stored procedure while database in production
hi, you use very old version of Firebird with many bugs. First update Firebird to 2.5.5 or snapshot 2.5.6 regards,Karol Bieniaszewski Oryginalna wiadomość Od: "mailgro...@murdochfl.com [firebird-support]" Data: 17.03.2016 03:43 (GMT+01:00) Do: firebird-support@yahoogroups.com Temat: [firebird-support] Compiling stored procedure while database in production I had a strange coincidence today, but I'm wondering if it actually may have been cause/effect instead. I'm running fb_inet_server.exe 2.5.2.26539 on Windows 2008 Server. Earlier today I created a simple "for select do update" stored procedure against a database that may have had 20-25 open connections from applicaiton servers/web servers. Compiling the stored proc seemed to take a very long time - I would have expected about 5 seconds, but it still hadn't finished after a couple of minutes. In the meantime I jumped on a couple of other tasks, and then started getting support calls from users that the applications were non-responsive. I saw that the DB usage had grown from the typical 1.5GB to 3.5GB, and was running at a steady 12% CPU. It stayed that way for a while, so I opened another copy of my DB management app and connected. I immediately tried to take a look at MON$STATEMENTS to see What was running, bu t the query never returned results. I could not connect to the DB after that, as even ISQL just hung when trying to start. After 30 minutes I had to reboot the server to bring the system back up, with hopefully no damage to the DB. There are no entries in Firebird.log that indicate what the original issue was, and sweeps that have occurred since seem normal. I'm now wondering whether compiling that simple stored proc could have been the cause of all of this? I don't do major development during normal production hours, but I have certainly created or altered stored procedures many many times while this database was online without issue. Thanks, Bob M..
Re: [firebird-support] RECREATE Procedure issue.
I am using firebird 2.5.5 version. As my application is .net application I am using Firebirdclient.dll to interact with firebird database. Also I am executing the query inside my .net application. There are many queries in my .net application, only this 'RECREATE' query fails to execute while others get executed successfully. Later when I ran this query in my third party SQL Manager it failed to execute in it. The error shown in SQL manager was "Invalid token. Dynamic SQL Error. SQL error code = -104. Unexpected end of command - line 30, column 36." at declaration statement _"DECLARE VARIABLE COUNT INTEGER;"_ NOTE: When same query executed with 'ALTER', it got executed successfully. On 17-03-2016 23:48, Helen Borrie hele...@iinet.net.au [firebird-support] wrote: 1) You are using a very old version of Firebird that does not support RECREATE PROCEDURE
[firebird-support] Re: UDF install in FB3.0 RC2
> ---In firebird-support@yahoogroups.com, wrote : > > If we dismiss rfunc.dll because it has bugs then I mention ib_udf.dll (the > > one with FB2.x) and freeUDFLib.dll (that works under FB2.x). > Both dlls install into fb3rc2. Both fail in the manner I described. So what > is the problem? Better yet what are solutions? Just tried ib_udf.dll from v2.5.6 and old FreeUDFLib.dll with FB3 - no problem found. Regards, Vlad
Re: [firebird-support] Re: [OffTopic] Sphinx for Firebird on Windows 2003
> ---In firebird-support@yahoogroups.com, wrote : > > Hi Vald, > > That was what I tried first, but unfortunately this build will not run on > Windows Server 2003. Got it. It doesn't run on W2K3 because VS 2013 doesn't support XP\W2K3 by default. I'll re-build it a bit later with support for XP. Regards, Vlad
Re: [firebird-support] RECREATE Procedure issue.
Re: [firebird-support] RECREATE Procedure issue.
Hello j...@codework-solutions.com, Saturday, March 19, 2016, 11:51:23 PM, you wrote: > Regarding thus issue could someone raise a ticket & update the documentation > of firebird. Not necessary. The documentation is under review at this stage. I have added warnings to both RECREATE PROCEDURE and RECREATE TRIGGER which will show up in the next build of the docs, due this weekend. Just as an additional comment for you: RECREATE is useful during development but it is not sensible to use it for "blind" updates to your PSQL modules from end-user applications. It is not arbitrary that the isql tool defaults DDL to autocommit. You should follow this practice in your own work, not least to enable you to catch the error immediately. Even if you write a script that resolves the dependencies before a RECREATE operation, it will still fail if you do not commit the resolution steps before the RECREATE request. Helen
Re: [firebird-support] Compiling stored procedure while database in production
On 2016-03-17 3:43, mailgro...@murdochfl.com [firebird-support] wrote: > I had a strange coincidence today, but Im wondering if it actually > may have been cause/effect instead. > > Im running fb_inet_server.exe 2.5.2.26539 on Windows 2008 Server. You are running an old Firebird version that has a security bug in it that can allow unauthenticated users to crash the server. I don't think it has to do with the problem described below, but you should really upgrade. Note that when upgrading you will need to backup and restore your database to address a problem with indexes. > Earlier today I created a simple "for select do update" stored > procedure against a database that may have had 20-25 open connections > from applicaiton servers/web servers. Compiling the stored proc > seemed > to take a very long time - I would have expected about 5 seconds, but > it still hadnt finished after a couple of minutes. > > In the meantime I jumped on a couple of other tasks, and then started > getting support calls from users that the applications were > non-responsive. I saw that the DB usage had grown from the typical > 1.5GB to 3.5GB, and was running at a steady 12% CPU. It stayed that > way for a while, so I opened another copy of my DB management app and > connected. I immediately tried to take a look at MON$STATEMENTS to > see > What was running, but the query never returned results. I could not > connect to the DB after that, as even ISQL just hung when trying to > start. > > After 30 minutes I had to reboot the server to bring the system back > up, with hopefully no damage to the DB. There are no entries in > Firebird.log that indicate what the original issue was, and sweeps > that have occurred since seem normal. > > Im now wondering whether compiling that simple stored proc could have > been the cause of all of this? I dont do major development during > normal production hours, but I have certainly created or altered > stored procedures many many times while this database was online > without issue. Is there anything in the firebird.log? It is hard to tell if it is a known issue without a reproducible example. However a large number of hangs and crashes were fixed since version 2.5.2, check the release notes: http://www.firebirdsql.org/file/documentation/release_notes/html/rlsnotes255.html. Mark
Re: [firebird-support] RECREATE Procedure issue.
I am executing this query using my .net application and it is not throwing any error. If there was a error then it would log that error and will display it to the user. I executed this query in my third party SQL Manager and it throws an error /Invalid token.// //Dynamic SQL Error.// //SQL error code = -104.// //Unexpected end of command - line 30, column 36.// // /line number 30 has this statement "DECLARE VARIABLE URL_COUNT INTEGER;" But the thing to note is that executing same query with ALTER will work. As this query was big and important in order to avoid any mistake i thought it was better to use RECREATE rather than ALTER. As recreate drops previous procedure and creates a new one. If there is an dependency then firebird should have sent an error to application. Here there was no error as such. Regarding documentation On 17-03-2016 23:59, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: On 2016-03-17 15:49, Joje j...@codework-solutions.com [firebird-support] wrote: > Hi All, > I am facing a issue with 'RECREATE' procedure. > > Problem: > I have a stored procedure that uses 'RECREATE Procedure', this > procedure does not execute properly when executed in EMS SQL manager > for IB and Firebird. > Dont know why... :( every time i execute it. Procedure execution > stuck as declaration variable whenever using 'RECREATE', Could you explain what happens: do you get an error, does it hang, or does it do nothing? > however when > I use 'ALTER' procedure gets executed without any error. There is no > documentation provided in firebird site about 'RECREATE' But there is: http://www.firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-ddl-procedure.html#fblangref25-ddl-proc-recreate > Could some tell me whether they have faced issues with 'RECREATE' or > have fixed this kind of issue. > > Thanks in Advance would appreciate your help in this matter. You might want to use CREATE OR ALTER PROCEDURE instead http://www.firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-ddl-procedure.html#fblangref25-ddl-proc-crtoralter The difference is that recreate drops and then creates the procedure, while CREATE OR ALTER creates a procedure if it doesn't exist or otherwise alters the procedure. Mark
Re: [firebird-support] RECREATE Procedure issue.
On 2016-03-18 9:10, Joje j...@codework-solutions.com [firebird-support] wrote: > I am executing this query using my .net application and it is not > throwing any error. If there was a error then it would log that error > and will display it to the user. If it is not throwing an error, then I would expect that it just executed fine. I am a little confused about the nature of your problem: Is the problem with executing from your .NET application, or is it with executing as shown below? Or do you think it isn't working in .NET, because it doesn't work below? If the problem is with executing from .NET, how did you verify that it didn't have the intended effect? > I executed this query in my third party SQL Manager and it throws an > error > _Invalid token._ > _Dynamic SQL Error._ > _SQL error code = -104._ > _Unexpected end of command - line 30, column 36._ > > line number 30 has this statement "DECLARE VARIABLE URL_COUNT > INTEGER;" This problem is not with Firebird itself, but with the tool you use to execute the statement. Firebird executes queries one at a time (trying to execute multiple statements would result in syntax errors), while a lot of query tools allow you to execute multiple statements. They usually do this by splitting on semicolons (;) and sending the individual statements to Firebird one by one. This works fine for normal statements, but doesn't work for PSQL, as inside PSQL the semicolons are statement terminators. Splitting on the semicolon here would lead to an incomplete statement (hence the "Unexepcted end of command" error). In a lot of tools (like ISQL and Flamerobin), you need to explicitly switch the statement terminator to something else (using SET TERM), but it looks like your tool has some heuristics to recognize statements with PSQL blocks. It seems to work for ALTER PROCEDURE, but apparently it doesn't know RECREATE PROCEDURE, and therefor it just splits on the semicolon and sends an incomplete statement. Check the documentation if it supports explicitly switching the statement terminator (eg using SET TERM). > But the thing to note is that executing same query with ALTER will > work. As this query was big and important in order to avoid any > mistake i thought it was better to use RECREATE rather than ALTER. As > recreate drops previous procedure and creates a new one. > > If there is an dependency then firebird should have sent an error to > application. Here there was no error as such. Dropping is not possible if there is a dependency, as far as I know altering is possible when there are dependencies (I might be wrong on this point though). Mark
Re: [firebird-support] Re: [OffTopic] Sphinx for Firebird on Windows 2003
Hi Vlad, My mistake about -id64. The *win32-xp *build is running just fine on W2K3, so once again thank you. Regards Alex On Sat, Mar 19, 2016 at 2:26 PM hv...@users.sourceforge.net [firebird-support] wrote: > > > > ---In firebird-support@yahoogroups.com, wrote : > > > > > Hi Vlad, > > > > Thanks a lot. Can you by chance rebuild it with -id64 support or it > will be too much of a hassle? > > -id64 is already ON by default, see > > > https://github.com/sphinxsearch/sphinx/commit/39f7f010e06b121a90f27b6325bf52e0d22e41f0 > > > Download page is updated, let me know if it is ok > > > Regards, > > Vlad > > >
[firebird-support] Re: [OffTopic] Sphinx for Firebird on Windows 2003
> ---In firebird-support@yahoogroups.com, wrote : > > Hi Vlad, > > Thanks a lot. Can you by chance rebuild it with -id64 support or it will be > too much of a hassle? -id64 is already ON by default, see https://github.com/sphinxsearch/sphinx/commit/39f7f010e06b121a90f27b6325bf52e0d22e41f0 https://github.com/sphinxsearch/sphinx/commit/39f7f010e06b121a90f27b6325bf52e0d22e41f0 Download page is updated, let me know if it is ok Regards, Vlad
Re: [firebird-support] Error with > 10 columns in SQL SELECT query using python firebirdsql
On 2016-03-17 5:54, ggoo...@yahoo.com [firebird-support] wrote: > I am querying a Firebird 1.5.3 database with python code using the > python firebirdsql module. All works well (query returns values as > expected) with up to 10 columns from two tables, but when I add an > 11th column I get the error: > > “NameError: global name ‘INFO_SQL_SELECT_DESCRIBE_VARS’ is not > defined” from the SQL execute statement. If I remove any one of the > 11 columns from the query it works so it doesn’t appear related to a > bad column name. > > The database is not one I created, so I don’t know if the creator > did something to lock it down in some way, or if Firebird is even > able > to do this. > > My SQL query is as follows … > > strquery="SELECT t.measured_datetime , t.results_dose, > t.results_axsym, t.results_trsym, \ > t.results_qaflat, t.signature, t.set_key, d.beam_on_time, \ > d.d24_counts, d.d34_counts, d.d44_counts \ > FROM dqa3_trend t \ > JOIN tomo_data d ON (t.data_key = d.data_key) \ > WHERE extract (month from t.measured_datetime) = extract (month from > CURRENT_DATE) \ > AND extract (year from t.measured_datetime) = extract (year from > CURRENT_DATE) \ > AND (t.set_key=25 OR t.set_key=26)" > > Any suggestions as to what might be causing this observed behaviour? Sounds like a problem in the driver, it can't find a constant by the looks of it. Make sure you are using the latest version, and otherwise report a bug. As a side note: 1.5.3 is rather old (even for the 1.5.x series itself), you really should consider upgrading (preferably to 2.5, but otherwise at least to 1.5.6). Mark
Re: [firebird-support] RECREATE Procedure issue.
On 19-3-2016 11:51, j...@codework-solutions.com [firebird-support] wrote: > Regarding thus issue could someone raise a ticket & update the > documentation of firebird. You can create tickets at http://tracker.firebirdsql.org/browse/DOC Mark -- Mark Rotteveel
Re: [firebird-support] RECREATE Procedure issue.
Regarding thus issue could someone raise a ticket & update the documentation of firebird. Sent from Outlook Mobile On Sat, Mar 19, 2016 at 12:15 AM -0700, "Mark Rotteveel m...@lawinegevaar.nl [firebird-support]" wrote: On 19-3-2016 04:44, j...@codework-solutions.com [firebird-support] wrote: > If it's not executing then it should send a message. Also I referred the > site documentation of recreate procedure. But there was no specific info > about dependency in stored procedure. > > But later when I referred the document mentation in link(flamerobin) > provided by you. It said that if dependency is there then it would not > execute. > > At least it should send out a message that it has not executed. I just tried and it does give an error, but unfortunately not on execute, but on commit. Just like drop procedure does. This might be something that needs to be improved in the documentation. Mark -- Mark Rotteveel
[firebird-support] COALESCE
So I'm getting errors when there's a call to COALESCE with only a single parameter. (Why would we write code like that? - because nobody thought to spot it as a special case in our query generation code, perhaps.) So what does the Firebird book say? - well, my copy appears to say COALESCE (value 1> { , value 2 [, ...value n }) where {} indicates "mandatory", so it looks like there must be at least two parameters, so our query generation code is wrong. Jolly good. So why am I pointing this out? (Other than that if the designer of the syntax for COALESCE had considered the possibility of machine-generated code they might have reached a different decision about the second parameter, or even the first, being mandatory?) I'm just pointing out the typo in the book - there's no closing square bracket in that definition. -- Tim Ward ++ 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: UDF install in FB3.0 RC2
18.03.2016 3:55, russ...@belding.co.nz [firebird-support] wrote: > So there is some requirement for UDF dlls in FB3RC2 which the dlls in FB2.x, > at least the > ones I have used, do not meet and they fail to work with FB3RC2. RFunc is known by bugs inside and dependency on gds32.dll. You must either fix it or use built-in Firebird function EXTRACT() instead. -- 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] RECREATE Procedure issue.
On 19-3-2016 04:44, j...@codework-solutions.com [firebird-support] wrote: > If it's not executing then it should send a message. Also I referred the > site documentation of recreate procedure. But there was no specific info > about dependency in stored procedure. > > But later when I referred the document mentation in link(flamerobin) > provided by you. It said that if dependency is there then it would not > execute. > > At least it should send out a message that it has not executed. I just tried and it does give an error, but unfortunately not on execute, but on commit. Just like drop procedure does. This might be something that needs to be improved in the documentation. Mark -- Mark Rotteveel
[firebird-support] Events, any changing in fb 3 RC2?
Hello, since FB 3 RC2 our C++ Application gets only the first post_event, some following there are not notice. Now we have insert a timer (sleep(500) after initevent) and it works (at the moment). Many Thanks
[firebird-support] Re: [OffTopic] Sphinx for Firebird on Windows 2003
Hi Alex, try http://web.firebirdsql.org/download/sphinx/2.2.10/ http://web.firebirdsql.org/download/sphinx/2.2.10/ Regards, Vlad PS I was sure official site is updated with links to this build...
[firebird-support] Re: UDF install in FB3.0 RC2
By experiments mentioned in this thread, UDF dlls that worked in FB 1 and 2 and not able to be used in FB 3 RC2.I am using 32 bit files. DLLs working in FB2.x can be placed in the FB3RC3 UDF folder and installed. "extractyear" is in rfunc.dll, used OK in FB2.x. When used in a FB3RC2 test, such as "select extractyear(current_date) from rdb$database" the call fails. ib_idf.dl comes with fb3rc2 and its "rtrim" works in fb3rc2. If I replace the ib_udf.dll (with FB3) with ib_udf.dll (from FB2.x) then rtrim fails. So there is some requirement for UDF dlls in FB3RC2 which the dlls in FB2.x, at least the ones I have used, do not meet and they fail to work with FB3RC2. Can someone who understands this suggest solutions?