Re: [firebird-support] What is the Newest Firebird Release

> At http://www.firebirdsql.org/en/downloads the available release of > Firebird to download is 2.5.2. 2.5.2 Update 1 is the latest official/production-ready release. > Somebody mentioned a 2.5.3 release. Is there a 2.5.3 release? I exist, > where can I download it? Only as a snapshot build. htt

Re: [firebird-support] TempCacheLimit in Super Classic

> I would like to know if the TempCacheLimit parameter in SuperClassic is > like Classic or like SuperServer? So if it's per client connection or > it's for server process? As in Classic, thus per connection. -- With regards, Thomas Steinmaurer http://www.upscene.com/ Professional Tools and S

Re: [firebird-support] Very long transaction start after deleting a big number of records.

> On 25/07/2014 06:46, brucedickin...@wp.pl [firebird-support] wrote: >> >> Hi, >> >> 1. I've deleted 50 records from TABLE A. I've commited transaction. >> 2. I made SELECT * FROM TABLE A. Transaction was starting for a very >> long time. >> >> I just wanted to make sure that there is no way t

Re: [firebird-support] using FSQL with embedded DB

> Can FSQL http://mujweb.cz/iprenosil/interbase/fsql.htm connect to > embedded db on client machine where firebird is not installed. Yes. You simply have to make sure that FSQL is loading the embedded library and do not use a remote connect string, even not via 'localhost' on the same mach

Re: [firebird-support] unwanted triggers present

Hi, > in my db some tables have strange triggers: 'CHECK_X' ACTIVE POSITION 1 > AFTER UPDATE or AFTER DELETE where the 'X' is a number. All these > triggers are empty (seeing them with flamerobin). > > I tried to delete them but after this i have had to restore a backup > because the db was malfun

Re: [firebird-support] Insert ot update statements locks a table and all other instances that try to run same statement are lcoked to

Hi, > Hi guys, > > I'm looking for some ideas how to find what is causing this lock. > > I have 2 production databases that process multiple insert/update > statements. There is one background process that does all these > modifications 24h/day. > > The problem is that with one of these databases

Re: [firebird-support] BLOB

> I recorded the process of backup , if anybody would be so kind to help > me, please take a look at : > FireBirdBackup > > image > > > FireBirdBackup > This feature is not available rig

Re: [firebird-support] BLOB

> > I run the backup automatically each night (Windows scheduled tasks), for > a few of my customers, via the Internet. Ok, even worse. > And yes, I need the backup file locally, on my system. > > As I mentioned before, if the backup lasts for 10 minutes of which > log_tables takes 9 , no prob

Re: [firebird-support] no permission for read-write access to database

> I have one customer having this error message very often when he > starts software after he boots up his computer which is as server as > well > > "no permission for read-write accesstodatabase > C:\DATA\CUSTOMERS.FDB" > > He runs the software on Windows 8.1 Profes

Re: [firebird-support] Should autosweep be happening on that database?

> I did some reconfiguration on a database yesterday, so I`m monitoring > the logs for any issues and I noticed something strange : > >Mon Oct 27 16:54:25 2014 > Sweep is started by SYSDBA > Database "orbis-aton" > OIT 21080, OAT 21081, OST 20456, Next 44177 > > (

Re: [firebird-support] Should autosweep be happening on that database?

> I`m not sure if running a 24/7 trace is a good idea (database is under > relatively heavy load). Anything else I could do to help? It might be ok with a proper include filter at service level from a Trace API POV. The following trace configuration should be fully dedicated to sweeping only:

Re: [firebird-support] Should autosweep be happening on that database?

> Well, I`ve done two things since the last post > > 1 I set the sweep interval to 10 (I assume I`m far from reaching > that on a normal day) > No change - Yesterday, another unexpected sweep at 5:08:03 pm > > 2 I started a trace session with the suggested config (changing only DB > alias, as i

Re: [firebird-support] Migration from Firebird 32 1.5.6 to Firebird 64 2.5.3

> I want to replace my Firebird 32 1.5.6 with the last Firebird 64 2.5.3, > on 64b > > All my databases was created with 32b, 1.5.6 Firebird. > > After installed Firebird 64, if a try to connect to database.FDB a > received an error > > "database./fdb is not a valid database/". Beside the other r

Re: [firebird-support] Configuring Firebird for high transaction through put

> Run stadistic for database > - Look for index in de big tables. Look for Depth > 2. In this case > up Page size one step, and run database statistical. >2 is quite conservative these days with the available hardware resources and even with a 16K page size you may reach that threshold with ind

Re: [firebird-support] Should autosweep be happening on that database?

> Trace config : > > > enabled true > print_perf true > log_sweep true > exclude_filter %RDB$% > time_threshold 0 > > > enabled true > log_services true > include_filter "Repair Database" > The database filter expects a regular expression and orbis-aton can't be parsed as a regular expression

Re: [firebird-support] Performance of Firebird (Superserver vs Superclassic, etc.)

Hi Todd, > Thought I would share some experience we have gained recently. > > We have an application consisting of a C++ Builder front end and > Firebird 2.5 as the backend. Running on Windows. The database includes > a ton of stored procedures with some fairly intricate calculations. > > A typi

Re: [firebird-support] Should autosweep be happening on that database?

> Thanks. I`ve fixed the config and started a new trace session. Now we > wait again :) To shorten the time to wait to see if that works in general, you could simply play with a test database using a similar alias thus database filter. -- With regards, Thomas Steinmaurer http://www.upscene.com

Re: Odp: [firebird-support] Performance of Firebird (Superserver vs Superclassic, etc.)

Hi Todd, > There are 46,527 records in the main table, but the calculation touches > many other tables. Here is a copy of the analysis of the main procedure > from IB Expert: > > Query > > > > Plan >

Re: [firebird-support] Performance of Firebird (Superserver vs Superclassic, etc.)

Hi Geoff, > Helen Borrie hele...@iinet.net.au [firebird-support] wrote: >> At 02:36 p.m. 30/10/2014, Geoff Worboys >> ge...@telesiscomputing.com.au [firebird-support] wrote: > >>>Doesn't that depend on how they implemented the separate threads? >>>SS does/can use different threads for separate co

Re: [firebird-support] What is wrong with transactions here?

Hello, >>> Hi! >>> >>> I have some lines in firebird.log like this: >>> === >>> cxv.servers.netTue Nov 4 11:37:38 2014 >>> Sweep is started by SWEEPER >>> Database "SkyNetInt" >>> OIT 1221095, OAT 1231335, OST 1231313, Next 139981575359934 >>> >>> >>> cxv.server

Re: [firebird-support] Change Write Mode

> *UPDATE* > I have changed batch, switch -online before change write mode. > Actually the batch is: > "%FB_PATH%\GSTAT.EXE" -h %DB1% >> %LOG_FILE% > "%FB_PATH%\GFIX.EXE" -shut full -force 0 -user SYSDBA -password > masterkey %DB1% >> %LOG_FILE% > "%FB_PATH%\GFIX.EXE" -online normal -user SYSDBA -p

Re: [firebird-support] Change Write Mode

er http://www.upscene.com Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc. > Il Giovedì 13 Novembre 2014 17:48, "Thomas Steinmaurer > t...@iblogmanager.com > [firebird-support]" ha scritto: > > > >

Re: [firebird-support] Backup/Restore Required ???

> Wondering if a Backup/Restore is requird for moving from 2.5.2 to 2.5.3? Usually this is not needed when the ODS version hasn't been changed (between maintenance releases), but there is a special situation when coming from 2.5.1: http://www.firebirdsql.org/file/documentation/release_notes/html

Re: [firebird-support] Cross database update

Hello Christian, > I am having problems regarding an update skript I want to write that > fetsches data from table1 in db1 and writes the result into exisiting > records in table2 in db2. > To mange this task I am using firebird 2.1.5 and a tool called IBExpert > with a script extension called ibe

Re: [firebird-support] Gbak Restore - SuperServer vs. SuperClassic

Michael, > Does GBak behave different on a Classic Server than on a SuperServer regarding > restore speed? > > > I ask this, because around 1 year ago I installed Firebird 2.5 SS on a Windows > environment. > Here I did a restore of a 90 Gb DB. > This took around 8 hours. > > > Since then we

Re: [firebird-support] Re: Gbak Restore - SuperServer vs. SuperClassic

Hello Michael, > * What is the page buffers value at database level? (gstat -h) > E:\DB\Kaufmann>"c:\Program Files\Firebird\Firebird_2_5\bin\gstat.exe" > localhost: > e:\db\Kaufmann\OCCEasyPos.FDB -h > > > Database "e:\db\Kaufmann\OCCEasyPos.FDB" > Database header page information: > Fla

Re: [firebird-support] Re: Gbak Restore - SuperServer vs. SuperClassic

> Isnt the transaction per second wrongly calculated? Oops, sorry!!! I have been one year off by using 2014 instead of 2013. -- With regards, Thomas Steinmaurer http://www.upscene.com Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc

Re: [firebird-support] Re: Gbak Restore - SuperServer vs. SuperClassic

Hello Michael, > Beside your gbak restore issue, your counters here show some interesting > throughput numbers, when taking the creation date of the database into > account: > > ~ 170 transactions / sec > ~ 9 connections / sec > > > > > We have a external connection from a WEBStore. > Whate

Re: [firebird-support] Trace cause of performance drop

Hello Michael, > I have a performance problem at a customer site. > > At this point I suspect one specific external user connection to cause > the problems, but I can't pinpoint it so exactly just yet. > > > But there is one table, where there is inserted records almost all the > time. > > When th

Re: [firebird-support] Cannot transliterate character between character sets for Firebird 2.1 database with WIN1257

Hi, > I am trying to migrate Firebird 1.5 dialect 1 charset NONE database to > Firebird > 2.1 dialect 1 charset WIN1257 database, that still will be used by BDE. > > > All is working. The only problem is that metadata (code of procedures or > triggers) can not contain WIN1257 specific character

Re: [firebird-support] Function - what is it called

Hello Michael, > I am looking for a function which are able to add values from a table as > records are fetched. Cumulative sum? > Something like this: > > > ValueCalculated value > > 11 > > 23 > > 36 > > 410 > > 515 > > The calculated value is just the sum of all previous values of VALUE. > > >

Re: [firebird-support] 64-bit server/32-bit application

> Is is possible to use the 64-bit Firebird server with a 32-bit application? Sure. > If so, is it recommended? What are the pitfalls? The only one is that a 32-bit application needs to use the 32-bit Firebird client library and not the one from a 64-bit Firebird server installation -- Wit

Re: [firebird-support] 64-bit server/32-bit application

> The 64 bit installer also installs the 32 but library iirc. So there > should be no problem at all. Yes, but people more and more use the ZIP distribution and AFAIK the 32-bit libraries aren't included in the 64-bit package, thus the additional "reminder" ;-). At least not in 2.5.2. Haven't ch

Re: [firebird-support] Re: 64-bit server/32-bit application

> Thank you for the responses. > The application and stored procedures utilize a UDF.dll. Does this need > to change? Does it need to be compiled as a 64-bit .dll for the server, > but remain 32-bit on the clients? The client application doesn't use the UDF library directly. The UDF library must

Re: [firebird-support] Index Memory Usage

> Hi All, can anyone tell me (or point me in the direction of manuals) how > i can calculate the amount of memory used by the indexes of a particular > table? > I have a table in which I store sha1 hashes (currently about 2 million > records) as char(40) and its indexed, I'm wondering if the table

Re: [firebird-support] Awaiting Garbage Collector

> Hello, > I'll try explain the situation in which we are in the shortest way > possible... > > We're using a software in our company made by some people in Spain, the > software supports 70 simultaneous users and we are experiencing slowness > using the software so I started the investigation, and

Re: [firebird-support] Awaiting Garbage Collector

> At 08:09 a.m. 19/03/2015, Thomas Steinmaurer t...@iblogmanager.com > [firebird-support] wrote: > >>Ask your software vendor to fix their client transaction management. >>Using auto commit as default transaction management mechanism is >>Firebird's enemy n

Re: [firebird-support] Firebird 2.5 multi-core support

Dave, > I'm just trying to clarify the status of multiprocessor/multicore > support in Firebird 2.5. I have found the architecture comparison page > which starts to explain this. > > > http://www.firebirdsql.org/manual/qsg25-appx-architectures.html > > > 1. For Windows, we just need to update the

Re: [firebird-support] garbage collect

> great thanks > > to make sure I've got this right > > starting with the same database I can do either > > a) gbak with gc > > b) gbak without gc and gfix -sweep > > and I will have the same final result > > > Extending this further, how can identify which tables contain (or did > contain) the gar

Re: [firebird-support] HP 200LX .gdb files?

Larry, > I am searching for a Macintosh OS X solution which supports .gdb > database files from the Hewlett Packard HP 200LX Palmtop. > > I understand that Firebird can be installed on OS X, but need to know if > there might still be support for the .gdb files produced by the 200LX. > > (I belong

Re: [firebird-support] Firebird Roadmap: v3.0 - what's next?

> …many thanks; that’s what I was looking for! So there’s a great many work > under way, but it looks to me that v3 and v4 are currently more or less > optimizations / enhancements and no major changes coming up, right? What are major changes from your perspective? Fine-grained SMP with a share

Re: [firebird-support] Need Speed Optimization for SQL

Hi SET, >> I tried as below way by adding Group By clause: >> >> with TMP(PK_JOB_ITEMS) as >> (select distinct PK_JOB_ITEMS >>from CRM_JOB_ITEMS where FK_JOB = '{8BDDED49-8509-48C1-A169-B7E68A74C230}') >> >> select >> Sum(cdi.QUANTITY) AS Delivered, >> cdi.FK_JOB_ITEM >>from tmp t >> join CRM_DOCU

Re: [firebird-support] large system slows over time

> Hi > > I have a system that is slowing down the longer it stays running and I'd > like to know why. > > The system is running firebird 2.1.5 on centos 5 with an average of 27 > transactions per second and has now been running for 112 days. The data > throughput is unchanged, data is removed fro

Re: [firebird-support] Can I run GSTAT over a local network?

> Hi, > > I am trying such command: > > gstat.exe 10.10.3.2:/Base/2534/2534.FDB -p password -u user -d > > But I am getting an error that specified patch could not be find. I am > guessing > that I can not run gstat over a network? Right. gstat is operating at physical file level and not throu

Re: [firebird-support] FB 1.5 server sluggish after been up for awhile

Hello, > we are still on FB 1.5 release, our live Database is about 50 GB. While > using the freshly restored database, things are very fast in the > beginning but they get slower and slower as weeks go by. We are always > forced to do a backup/restore after 4 weeks or so. > > In the beginning we

Re: [firebird-support] How to determine Role of attached user?

Hello Stefan, > Hallo all, > > when I call SELECT * FROM MON$ATTACHMENTS (logged in as the database > owner), the MON$ROLE field always shows 'NONE', even when the user is > logged in with a specific role. > > Is there a way to find out the role another user (with a specifid > attachment_id) is

Re: [firebird-support] Backup & Restore NOT NULL Columns

Hugo, > Hello. > > 1 - I created a column NOT NUL in a table (ALTER TABLE MYTABLE ADD > NEW_COLUMN INTEGER NOT NULL). There were already some records in the > table. FB didn´t raise any warning or exception. > 2 - I created a backup file from MYDB.FDB using gbak. FB didn´t raise > any warning

Re: [firebird-support] Database restore speed with IBExpert and Gbak

> Hello all, > I came across something really strange as far as restoring a Firebird > database. > if I use IBExpert(a tool from HK Software) it takes about 3 hours but if I use > regular gbak using command line it takes 9 to 10 hours. > I'm using Firebird 1.5. IBExpert vesion 2008.08.08 > I think

Re: [firebird-support] Database restore speed with IBExpert and Gbak

Halim, > Thank you for your reply. > I just tested a GBAK restore using -se(rvice) switch on a 1 GB DB. It > took about 8 minutes. Restoring the same database using IBExpert took > about 3 minutes. > I'm looking for a faster restore time because I want to automate the > process using a batch file.

Re: [firebird-support] Database restore speed with IBExpert and Gbak

Hello Walter, > Hello Thomas > > That seems an interesting idea. Can you explain it with more details? For the restore process, gbak supports a -BU(FFERS) switch to override the database page buffer value. While page buffers tends to be rather small for Classic/SuperClassic hosted databases, yo

Re: Odp: [firebird-support] Database restore speed with IBExpert and Gbak

nishing low numbers in 2015, for all three. -- With regards, Thomas Steinmaurer http://www.upscene.com Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc. > Regards, > Karol Bieniaszewski > > > - Reply mes

Re: Odp: [firebird-support] Database restore speed with IBExpert and Gbak

> ---In firebird-support@yahoogroups.com, wrote : > >> From a throughput perspective, this would mean: > > >> IB XE3 => 0,918 MB/s >> IB XE7 => 1,896 MB/s >> FB 3 => 3,282 MB/s > > >> To be honest, astonishing low numbers in 2015, for all three. > > To be even more honest, measure time of res

Re: [firebird-support] Memory usage excess in FBServer 2.5.4

> I'm facing a problem where the firebird server v2.5.4 on win 2012 server in > superserver mode is leaking memory. Currently I'm at ~5GB usage. > > > Don't have any idea how to track down the problem. > Thanks for any advice. When you open the Windows Task Manager, what's the name of the Firebird

Re: [firebird-support] Use ISQL to insert special german characters

Niko, 'Parzival' parzival1...@gmx.at [firebird-support] schrieb am 02.06.2015 22:12: > Hello all, > > > > for updating some tables at customers I create SQL scripts and execute them > with ISQL –i parameter. This works perfect unless I have to insert german > special characters like äöüß. > >

Re: AW: AW: [firebird-support] Re: Memory usage excess / leak in FBServer 2.5.4

Vlad, > ---In firebird-support@yahoogroups.com, wrote : > > Could you register it a tracker, please ? > >Done: http://tracker.firebirdsql.org/browse/CORE-4830 Is this SuperServer only or also SuperClassic? Thanks! -- With regards, Thomas Steinmaurer http://www.upscene.com/ Professional

Re: AW: AW: [firebird-support] Re: Memory usage excess / leak in FBServer 2.5.4

> ---In firebird-support@yahoogroups.com, wrote : > > > Is this SuperServer only or also SuperClassic? > > SuperServer only. Thank you! Thomas

Re: [firebird-support] Error While Executing Simple Inner Join SQL With Big database

> I think the image posting is not allowed here to display. > Below is the error message I see: > Note I have 2.75 GB free disk space. > *** IBPP::SQLException ***Context: Statement::FetchMessage: isc_dsql_fetch > failed > SQL Message : -901Unsuccessful execution caused by system error that does >

Re: [firebird-support] Error While Executing Simple Inner Join SQL With Big database

regards, Thomas Steinmaurer http://www.upscene.com Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc. > So I could give a try. > Thanks.   > > > On Monday, 8 June 2015 11:44 AM, "'Thomas Steinmaurer'

Re: [firebird-support] Error While Executing Simple Inner Join SQL With Big database

ools and Services for Firebird > FB TraceManager, IB LogManager, Database Health Check, Tuning etc. > >> So I could give a try. >> Thanks.   >> >> >> On Monday, 8 June 2015 11:44 AM, "'Thomas Steinmaurer' t...@iblogmanager.com >> [

Re: AW: AW: AW: AW: [firebird-support] Re: Memory usage excess / leak in FBServer 2.5.4

>> >> >> Thank you ! >> >> Vlad >> >> >> Vlad, does this issue affect classic and superclassic? According to one of Vlad's previous message, only SuperServer. -- With regards, Thomas Steinmaurer http://www.upscene.com Professional Tools and Services for Firebird FB TraceManager, IB LogManag

Re: [firebird-support] Re: Firebird 2.5.4 - CentOS - mon$remote_address 0.0.0.0

> Hello , > > So Dmitry suggested it , we have disabled IPV6 on our server CentOS 7 > (Firebird > 2.5.4 Classic server (I forgot to mention it in my first mail)). > By following the centos FAQ : > http://wiki.centos.org/FAQ/CentOS7#head-8984faf811faccca74c7bcdd74de7467f2fcd8ee > Rebooting the se

Re: [firebird-support] Re: Inssuficient rights for operation....

> Hello. I used Firebird 1.5.6 on server on WIN7, a database with a role with > full rights, and a user defined in ROLE, USER. > I have a problem. In the network with a application, on different client > station, login with the USER, all functions work OK. > > From server or another WIN7 stat

Re: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)

Hello, > We have backed up our databases daily for two years using Firebird 2.52 > Superserver and its associated gbak. We now need to restore one of the > databases and gbak fails to do the restore, giving the following error: > [snip gbak output] > gbak: ERROR:action cancelled by trigger (3)

Re: [firebird-support] Re: Firebird 2.5.4 - CentOS - mon$remote_address 0.0.0.0

> Thanks Steve for the information. I think we’ll try on a virtual machine > the centOS versions with the different mode of firebird (classic, > superserver, superclassic). > > To Thomas, yes that’s real remote connections from different remote > servers (there is no local connections). Ok, do the

Re: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)

on by accident, e.g. due to a set PATH environment variable etc.? Regards, Thomas > Jack > > On 6/11/2015 3:02 AM, Thomas Steinmaurer t...@iblogmanager.com > [firebird-support] wrote: >> >> Hello, >> >> > We have backed up our databases daily for two years

Re: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)

the result of gstat -h on the production database? Thomas > Jack > > > > On 6/11/2015 9:01 AM, 'Thomas Steinmaurer' t...@iblogmanager.com > [firebird-support] wrote: >> >> >> > The databases reside on a Linux Mint server, but we back them up to a &

Re: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)

take me a while to locate > it which I will start now. Don't know, but I guess fbstat as mentioned in your > 2 years old thread ;-): http://comments.gmane.org/gmane.comp.db.firebird.user/7145 Regards, Thomas > Thanks, > Jack > > > C:\Firebird> > > On 6/11/20

Re: [firebird-support] Issues migrating from FB 1.5 to 2.5

srotyli...@gmail.com [firebird-support] schrieb am 23.06.2015 14:31: > Hi Karol, I think you are right on, I found this which is what I suspect is > throwing the error in 2.5 (but not so in 1.5). I might have to go back to my > old box running 1.5. Do you know if it is possible to convert and do

Re: [firebird-support] FB_INET_SERVER.EXE using all the memory

> Hello! > > > I have two databases in my Firebird 2.5.3 > > > The first is of 7.5GB and second is of 2.0GB > > > My server has 4GB of Memory, and sometimes the service FB_INET_SERVER.EXE > starts eating my memory from 1.5GB to 2.5GB-3GB of memory and my system slows > down.. > > > Same co

Re: [firebird-support] Problem with FB database that freezes

Hi Eduardo, [snip] > Firebird.conf: > > - > > DefaultDbCachePages = 1024 > > #FileSystemCacheThreshold = 65536 (commented out) > > #FileSystemCacheSize = 0 (commented out) > > > Server environment: > > -- > > CPU utilization: 11% > > Memory utilization:

Re: [firebird-support] Problem with FB database that freezes

Hi again, > Hi Eduardo, > > [snip] > >> Firebird.conf: >> >> - >> >> DefaultDbCachePages = 1024 >> >> #FileSystemCacheThreshold = 65536 (commented out) >> >> #FileSystemCacheSize = 0 (commented out) >> >> >> Server environment: >> >> -- >> >> CPU utiliza

Re: [firebird-support] Problem with FB database that freezes

Hi Eduardo, > > > >As you are using > >FB TraceManager, it is a simple mouse-click via the context-menu in the > >parsed gstat output to locate the OAT in the monitoring tables. > > > Thanks Thomas. I've located the OAT in the monitoring tables as you > mention. Can you please elaborate a bit

Re: [firebird-support] Multiple instances of firebird not working

> I have an 3rd party application running firebird 1.5. > > > I want to install firebird 2.5 instance, with my application, without > affecting > the other app. I did a video on that topic quite some time ago. http://www.iblogmanager.com/download/demos/firebird/firebird_multiple_instances_wi

Re: [firebird-support] Connected users from MON$ATTACHMENT

> Hello! > > > May I use the system table "MON$ATTACHMENT" in order to get the connected > users in moment? > > > I already try to do it, but when a connection from a client (another > machine) is ended abnormally (for example, turn off the machine or > disconnect the cable of network), this c

Re: [firebird-support] 2.5 architecture

> Hi > > We are moving to 64bit firebird 2.5 shortly and I'm looking at the > architectures > > the first of these links seems to say that superserver is the only > option, the second say otherwise > > can someone clarify please > > http://www.firebirdsql.org/file/fb25_architecture_comparison.pdf

Re: [firebird-support] FB 2.5 Lock conflict on no wait transaction

> Hi Alexey, > > Thank you for posting. The full error text is : > > lock conflict on no wait transaction. deadlock. update conflicts with > concurrent update. concurrent transaction number is 36094733 > > lock conflict on no wait transaction. deadlock. update conflicts with > concurrent update. co

Re: [firebird-support] MS SQL Server - Linked Server setup for Firebird

> Hello Group - Has anyone documented steps of how to create a Linked Server to > Firebird in MS SQL Server? > I'm running into issues and need help ASAP please. Much appreciated! What issues? > I'm not sure if screen shots work, but here's the setup. > > [cid:image003.jpg@01D0DF20.F6F9FBF0] (

Re: [firebird-support] 2.5 architecture

> Hi, > > At August 28, 2015, 10:59 AM, Nick Upson n...@telensa.com > [firebird-support] wrote: > > > > > > > On 28 August 2015 at 14:43, Thomas Steinmaurer t...@iblogmanager.com > [firebird-support] >

Re: [firebird-support] Using variables in ESQL select statement

Hi, > I had a look at IB LogManager. It doesn't quite do what I want. > > The requirement we have is to log only fields that change, not all > fields (which is what IB LogManager does). If I change fields 1, 4, and > 7 then those are the only fields I want logged (and not fields 1, 2, 3, > 4, 5, 6

Re: [firebird-support] Using variables in ESQL select statement

, Database Health Check, Tuning etc. > John > > ------------ > *From:* "Thomas Steinmaurer t...@iblogmanager.com [firebird-support]" > > *To:* firebird-support@yahoogroups.com > *Sent:* Wednesday, September 23, 2015 11:36 AM > *Subject:* Re: [firebird-support] Using varia

Re: [firebird-support] Error while attempting to add a Primary key to a table that has no records

> Hmmm, > > > > I tried again this evening and it would allow me to add the primary key. Very > strange. Since we moved to a new windows server 2012 R2 and upgraded to > v2.5.4 > firebird running Classic Super Server from v1.5.4 running Classic Server, > could > any of that have anything to

Re: [firebird-support] Data Type for Primary Key

Kevin Meyers kevinjmey...@gmail.com [firebird-support] schrieb am 06.10.2015 22:36: > I am wondering if any of you have every noticed any significant performance > difference between using BIGINT versus INTEGER as an autoincremented > primary key in Firebird. My idea is to use BIGINT and have vir

Re: [firebird-support] Optimize query for date ranges

Niko, > Hello all, > > i am running a simple query where the result contains 3 records. The > query should provide all records in a specific week. > > SELECT * FROM ARBEITSEINTEILUNG AS a where a.baustelle = '12345' AND > WOCHE = '2015-41'; > > Some times I dont have a week but two dates: > > In t

Re: [firebird-support] invalid request BLR at offset 63 - functions (LTRIM,RTRIM,LRTRIM) not defined - module name/entrypoint not found

> Hello Team, > > A few days back, I posted a message regarding 'Firebird BLR 623 invalid > request - LRTRIM is not defined - > module name or entrypoint could not be found' when I ran some stored > procedures that used either LTRIM > or LRTRIM functions (occasionally,though not always). > >

Re: AW: [firebird-support] Optimize query for date ranges

Niko, > the execution is currently not the problem, because the number of records is > too small. > > I have the impression that the first query looks for DATUM >= x and the > second one for DATUM <= y and finally delivers the number of records that is > included in both result sets. > > My main i

Re: [firebird-support] How can I see which query within a stored procedure execution takes the longest time?

'Louis van Alphen' lo...@nucleo.co.za [firebird-support] schrieb am 14.10.2015 10:09: > I think a tool like FBTraceManager from Thomas (Upscene) can do that for you Unfortunately not. The Trace API does not provide that level of granularity for PSQL code modules. This has been a long discussio

Re: [firebird-support] Re: Holding a connection open forever

> In response to your questions: > > What are the implications of holding a connection to the database open > forever (and running millions and millions of tiny transactions flat out > through that connection)? > > What difference would it make if we dropped the connection periodically? > > We had

Re: ODP: [firebird-support] Re: Holding a connection open forever

> you should identity this long running transaction. if you use fb2.5 than > this is simple by mon$TRANSACTIONS table MON$ tables are even in Firebird 2.1. -- With regards, Thomas Steinmaurer http://www.upscene.com/ Professional Tools and Services for Firebird FB TraceManager, IB LogManager, D

Re: [firebird-support] How much percentage of a database space is a table contents taking.

> Hi Robert, you can do this easily with a tool such as IBExpert. Just run > Services / Database Statistics and this is the result: > > TableName SizeUsage% > CUSTOMER 11,960,320 0.295 > PARAMFIL 16,384 1 0.000 > POSTC

Re: [firebird-support] How much percentage of a database space is a table contents taking.

rgilland1...@gmail.com [firebird-support] schrieb am 27.11.2015 00:24: > Hi, > > > this is an output from ibexpert, no usage% column here either: > > > Kind Regards, > > > Robert. > > > Database "OP.FDB" > Database header page information: > Flags 0 > Chec

Re: [firebird-support] Re: How much percentage of a database space is a table contents taking.

rgilland1...@gmail.com [firebird-support] schrieb am 30.11.2015 05:10: > Thanks Helen, > > I finally taught myself how to use isql.exe in order to access this > information. > What a strange tool. > > > Then I found that both IBOConsole.exe and Upscene's Database Workbench show > this informat

Re: [firebird-support] Re: How much percentage of a database space is a table contents taking.

> Monday, November 30, 2015, 7:40:50 PM, Thomas Steinmaurer wrote: > >> That information is also available on the database header page, >> which can be extracted by gstat -h > > Unfortunately, that information is absent from gstat -h, hence my > advice to use isql SHOW DATABASE. I can't think why

[firebird-support] Dialect 1 vs. 3: DATE to VARCHAR CAST results in different date/time format

Hello, Executing the following in both, dialect 1 and 3: select cast(current_timestamp as varchar(30))from rdb$database results in a string with a different date/time format. At least on Windows with Firebird 2.5 64-bit. Dialect 1: 7-DEC-2015 20:29:12.3820 Dialect 3: 2015-12-07 20:31:07.2280

Re: [firebird-support] Dialect 1 vs. 3: DATE to VARCHAR CAST results in different date/time format

> On 8-12-2015 09:52, Thomas Steinmaurer t...@iblogmanager.com > [firebird-support] wrote: >> Hello, >> >> Executing the following in both, dialect 1 and 3: >> >> select cast(current_timestamp as varchar(30))from rdb$database >> >> >> results i

Re: [firebird-support] Firebird Download Malware

>> I downloaded FB 2.5.5 from firebirdsql and my Microsoft Essentials >> detected it as a malware. > > I am facing the same problem. > The following file is affected: > http://sourceforge.net/projects/firebird/files/firebird-win64/2.5.5-Release/Firebird-2.5.5.26952_0_x64.exe/download > > This seems

Re: [firebird-support] Small Database with very very bad performance on LAN

Hello, > Hallo, > I have a small database (less 100MB) that works on Firebird 2.5.5 > SS64bit over a machine with Win7 64bit with 4GB Ram, CPU Pentium G620. > > I seems to work very well in local but with the 3 clients on LAN works > very bad. It is very very slow to open and navigate a simpl

Re: [firebird-support] Architecture

Hello Olaf, > Hello, > > I plan an update of firebird 2.1 cs 32 Bit with 32 Bit Server OS to > Firebird 2.5. Is there a 64 Bit OS recommend and a 64 Bit installation > of Firebird too? From an operational POV, a main factor with moving from 32-bit to 64-bit is if you are using (third-party) UDF

Re: AW: [firebird-support] Architecture

> Thanks. For some Years, we have had in use the superserver, but since we > have a quadcore CPU, we are using cs. > > UDFs can I replace with build in functions I guess you can imagine that you first need to do that before backing up and restoring? > Now, I have restored the database with 2.5,

Re: AW: AW: [firebird-support] Architecture

> now, the switches works fine, I had forget the Charset -fix_fss_d ISO8859_1 > > It works fine, but there is another problem to fix. Now I get the error, > that value exceeds the range for valid timestamps. How can I fix this issue? * When does that happen during the restore? * Does a backup *AND

Re: AW: AW: [firebird-support] Architecture

Olaf, > now, the switches works fine, I had forget the Charset -fix_fss_d ISO8859_1 > > It works fine, but there is another problem to fix. Now I get the error, > that value exceeds the range for valid timestamps. How can I fix this issue? Funny, you have been using 2.5 in 2013 already: https://w

  1   2   >