Re: ODP: [firebird-support] Re: Issue with large table in FB 1.5 and 2.5
I resend my email - it do not reaach the yahoo group :-( Hi, you can try modify your logic by adding IMPORT_ID to that table and then you can import data without need to delete in the same time. Then you can delete data in some portions during a day. and successively run SELECT COUNT(*) FROM THAT_TABLE to clear old record versions. This changed logic require changes in your current selects where you must include most recent IMPORT_ID. regards, Karol Bieniaszewski
[firebird-support] Re: Random operating system directive MapViewOfFile failed messages
With a Dot Net Provider based application, that is the only messages that surfaces at the application level: FirebirdSql.Data.FirebirdClient.FbException Message : operating system directive MapViewOfFile failed StackTrace : at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.Connect() at FirebirdSql.Data.FirebirdClient.FbConnectionPool.Create() at FirebirdSql.Data.FirebirdClient.FbConnectionPool.CheckOut() at FirebirdSql.Data.FirebirdClient.FbConnection.Open() Any ideas on how to detect the ISC API involved? Thanks, -Eduardo Alvarez
Re: [firebird-support] How to query all variable names from a database?
On 2019-06-06 21:37, Gabor Boros mlngl...@bgss.hu [firebird-support] wrote: > Hi All, > > I need to know all stored procedure variable names from a (2.5) > database. I not see these in system tables like parameters or fields. > But I see these with a text editor. For example... > > Create a new database and a procedure in it: > > CREATE PROCEDURE MY_PROC AS DECLARE VARIABLE MY_VAR INTEGER; BEGIN END > > Set RDB$PROCEDURES.RDB$PROCEDURE_SOURCE to NULL. > > Backup the database with gbak. I see MY_VAR text in the resulting > backup > file (and in the restored database) with a text editor. > > So, where is the variable names stored and how to query these? Firebird has no need for the variable name as queryable information, so it isn't stored in the metadata tables contrary to parameters or columns. The variable name is available in the source column (RDB$PROCEDURE_SOURCE), but as far as I can tell from small experiments it isn't even in the compiled BLR, eg use CAST(RDB$PROCEDURE_BLR AS BLOB SUB_TYPE TEXT) to show the BLR in 'readable' form. This is actually pretty logical, because the name is only relevant for the human reading and writing the code. For the runtime it is just a 'slot' with a numerical id where a value is stored. So there is no other mechanism to get variable names than to parse the RDB$PROCEDURE_SOURCE yourself. Mark
[firebird-support] How to query all variable names from a database?
Hi All, I need to know all stored procedure variable names from a (2.5) database. I not see these in system tables like parameters or fields. But I see these with a text editor. For example... Create a new database and a procedure in it: CREATE PROCEDURE MY_PROC AS DECLARE VARIABLE MY_VAR INTEGER; BEGIN END Set RDB$PROCEDURES.RDB$PROCEDURE_SOURCE to NULL. Backup the database with gbak. I see MY_VAR text in the resulting backup file (and in the restored database) with a text editor. So, where is the variable names stored and how to query these? Gabor ++ 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] Re: Random operating system directive MapViewOfFile failed messages
---In firebird-support@yahoogroups.com, wrote : > We started seeing this error from client applications two days ago. They > appear randomly during the day. > > "operating system directive MapViewOfFile failed" This is a one part of the error message, there should be Windows error code also. Do you know which ISC API call returns such error ? Regards, Vlad
[firebird-support] Random operating system directive MapViewOfFile failed messages
Hi there, We started seeing this error from client applications two days ago. They appear randomly during the day. "operating system directive MapViewOfFile failed" We have to close the client application with Windows task manager and restart it, most of the time this silences the error for a while. In firebird.log in the server, there is no mention of MapViewOfFile, however, the log is full of messages like this: MYHOSTNAME Thu Jun 06 12:57:32 2019 INET/inet_error: read errno = 10054 MYHOSTNAME Thu Jun 06 12:57:32 2019 Unable to complete network request to host "MYHOSTNAME". Error reading data from the connection. Environment details: Windows Server 2012 Standard 64 GB of RAM Firebird 2.5.8 64-bit Classic 290 Firebird SQL Server processes running during the day 22 GB database size nbackup runs every hour (incremental backups) Below I am posting firebird.conf file from the server. Thanks for any insight on how to solve this, please. -Eduardo Alvarez # # Firebird configuration file for Firebird 2.5 64-bit Classic # Optimized by IBSurgeon (www.ibsurgeon.com). # # This is an optimized configuration for Firebird 2.5 Classic 64-bit, it can be used # instead of standard firebird.conf from 2.5 distribution - copy it to Firebird folder, # rename it to firebird.conf, then restart Firebird # (all users should be disconnected before restart!). Keep old config as a backup! # # If you need configuration file, optimized for your specific environment # to get the best possible performance, or if your performance problem # still persists after configuration changes, contact us: # http://www.ibsurgeon.com/en/firebird-interbase-performance-optimization-service/ # or via email supp...@ib-aid.com #RootDirectory = #DatabaseAccess = Full #ExternalFileAccess = None #UdfAccess = Restrict UDF #TempDirectories = #LegacyHash = 1 #Authentication = native #AuditTraceConfigFile = #MaxUserTraceLogSize = 10 DefaultDbCachePages = 384 #DatabaseGrowthIncrement = 134217728 #FileSystemCacheThreshold = 65536 #FileSystemCacheSize = 0 #RemoteFileOpenAbility = 0 TempBlockSize = 2048576 TempCacheLimit = 77108864 #CompleteBooleanEvaluation = 0 #DeadlockTimeout = 10 #MaxUnflushedWrites = 100 #MaxUnflushedWriteTime = 5 #BugcheckAbort = 0 #OldColumnNaming = 0 #OldSetClauseSemantics = 0 #RelaxedAliasChecking = 0 #ConnectionTimeout = 180 #DummyPacketInterval = 0 #RemoteServiceName = gds_db #RemoteServicePort = 3050 #RemoteAuxPort = 0 #TcpRemoteBufferSize = 8192 #TcpNoNagle = 1 #RemoteBindAddress = LockMemSize = 7048576 #LockGrantOrder = 1 #LockAcquireSpins = 0 LockHashSlots = 30011 #EventMemSize = 65536 #CpuAffinityMask = 1 #UsePriorityScheduler = 1 #PrioritySwitchDelay = 100 #PriorityBoost = 5 #GCPolicy = combined #GuardianOption = 1 #ProcessPriorityLevel = 0 #IpcName = FIREBIRD #RemotePipeName = interbas #Redirection = 0