[firebird-support] Re: AV in fbembed.dll_unloaded

You must call fb_shutdown before unload fbembed.dll Regards, Vlad

[firebird-support] Re: nbackup database made database inaccessible

Hugo, Switch -U[SER] set user name for autentification, i'm doubt it could address the problem. If .delta file was really lost, nbackup can't help. Therefore i don't think it was lost. Regards, Vlad PS Sometimes it is risky even to cross the road... especially if you know no rules and see

[firebird-support] Re: lock conversion denied/lock denied bug still exists in FB 2.5.3

Ideally, i would like to have reproducible test at my hands to analyze it. It is possible for you to provide me with it ? As for debug dumps you have - they can't help as produced *after* deadlock condition was found and cleaned by Lock Manager. Thanks, Vlad

[firebird-support] Re: lock conversion denied/lock denied bug still exists in FB 2.5.3

No ths is not related to subject, this is another issue. I have few such reports from customers but without test case to reproduce it. I suspect this is related to garbage collection of a very long versions chain (ten's backversions for the same record). gstat -r could confirm it. Regards,

[firebird-support] Re: INET / inet_error: fork / CreateProcess errno = 193

Win32 error 193 is: ERROR_BAD_EXE_FORMAT 193 (0xC1) %1 is not a valid Win32 application. Very strange... probably issues with antivirus\firewall ? Regards, Vlad ---In firebird-support@yahoogroups.com, henkcats@... wrote : Hi, From a certain moment the message 'Connection rejected

[firebird-support] Re: FB 2.5 and lock

John, Upgrade to 2.5.3, and read Release Notes carefully Regards, Vlad PS there is no such version as 2.5, there are five releases in 2.5.x series

[firebird-support] Re: FB 2.5.3 32bit and Db size limits test

Alex, what is limit of 2.083.888 kb ? Is it size of database file on disk ? Is it memory usage by Firebird process (what exact memory counter) ? Something else ? How do you insert blobs into database ? Regards, Vlad ---In firebird-support@yahoogroups.com, af_123xy@... wrote : Hi all i

[firebird-support] Re: FB 2.5.3 32bit and Db size limits test

No Regards, Vlad ---In firebird-support@yahoogroups.com, af_123xy@... wrote : out of memory inserting the Blob is there any difference betwern 32 and 64 FB engine about db size limit (supposing that i am on a NTFs (5) filesystem) ?

Re: [firebird-support] Deadlock exception occurs but it shouldn't?

Update, internally, consists of following steps (simplified) : 1. read record 2. evaluate new record 3. write new record into data page really, it is a more complex, but for now we interesting only in steps above. At step 1, read-committed (RC) transaction waits for commit or rollback of

[firebird-support] Re: Deadlock exception occurs but it shouldn't?

Walter, there are few reasons: a) MVCC engine never block records - it just can't :) b) the only way to disable concurrent updates of the same record is... update :) More exactly: engine must mark primary record version by current transaction and it will make concurrent writes wait or

[firebird-support] Re: Bad surprise on performance

Hi, André ! [Old] Server 2003 x86 no service packs Xeon with 4 GB RAM Classic 1.5.4 (x86, of course) Raid 0 on 2 * 500 GB SAS (though this is from memory, I should look it up...) [new] Server 2008 R2 x64 SP1 Xeon with 8 GB RAM (I will shortly add +8) Classic 2.5.3 x64 Raid 0 on 3 *

Re: [firebird-support] Re: ON EXTERNAL DATA SOURCE

Tim, your question: (iii) I can't find any documentation of when the connection on database B get closed, and when and under what circumstances the transaction on database B gets committed and when and under what circumstances it gets rolled back documentation

[firebird-support] Re: ON EXTERNAL DATA SOURCE

Read the documentation first http://www.firebirdsql.org/file/documentation/reference_manuals/reference_material/html/langrefupd25-psql-execstat.html http://www.firebirdsql.org/file/documentation/reference_manuals/reference_material/html/langrefupd25-psql-execstat.html Regards, Vlad

[firebird-support] Re: Incorrect behaviour of isc_start_multiple() ?

With CS, when you stop listener process all working processes are still works. Clients connections are not lost and alive. Regards, Vlad

[firebird-support] Re: Plan question, what is a stream and what isn't?

---In firebird-support@yahoogroups.com, tdw@... wrote : If SET STATISTICS is done on one connection, when does it take effect? As any DDL statement it actually runs at transaction commit. What about a transaction that was already running at the time someone else did SET STATISTICS,

Re: [firebird-support] Re: Plan question, what is a stream and what isn't?

---In firebird-support@yahoogroups.com, listas@... wrote : Re: [firebird-support] Re: Plan question, what is a stream and what isn't? Note, stored procedures and triggers are prepared\optimized once when loaded into metadata cache. Regards, Vlad Just by curiosity, when are

Re: [firebird-support] Re: Plan question, what is a stream and what isn't?

---In firebird-support@yahoogroups.com, tdw@... wrote : On 15/04/2015 18:50, hvlad@... mailto:hvlad@... [firebird-support] wrote: ---In firebird-support@yahoogroups.com mailto:firebird-support@yahoogroups.com, listas@... mailto:listas@... wrote : Re: [firebird-support] Re: Plan

[firebird-support] Re: Moving from FB 1.5x to 2.5x

---In firebird-support@yahoogroups.com, dressel@... wrote : We are considering moving from 1.5x to 2.5x. 95% of our user base is using FB embedded (using Delphi and IBO) . We have a few thousand installs on Windows and it could be quite painful if this doesn't go smoothly--like sinking

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

---In firebird-support@yahoogroups.com, joja.lists@... wrote : Reproducible test case would be ideal Hello Vlad, hello Alexey, and other interested people! I have prepared a test case now showing the memory leak with a simple fresh database and many many connect / select / disconnect

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

---In firebird-support@yahoogroups.com, hvlad@... wrote : Could you register it a tracker, please ? Done: http://tracker.firebirdsql.org/browse/CORE-4830 http://tracker.firebirdsql.org/browse/CORE-4830 Regards, Vlad

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

---In firebird-support@yahoogroups.com, joja.lists@... wrote : Any hints how to investigate this problem? Reproducible test case would be ideal Regards, Vlad

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

---In firebird-support@yahoogroups.com, joja.lists@... wrote : Sorry, I didn’t check my mail till now. Thank you for creating the ticket. And of course for fixing the bug. Please, verify it using recent snapshot build Regards, Vlad

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

---In firebird-support@yahoogroups.com, ts@... wrote : Is this SuperServer only or also SuperClassic? SuperServer only. Regards, Vlad

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

---In firebird-support@yahoogroups.com, jackmason@... wrote : Thanks. We do have both Interbase and Firebird running on our Win7 machine because we have to access both types of databases. I will try your suggestion. Any news on this issue ? Regards, Vlad

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

---In firebird-support@yahoogroups.com, jackmason@... wrote : Is this what you needed? Hmm... i'd say it is impossible to obtain such results using FIrebird. See below C:\Program Files\Firebird\Firebird_2_5\binisql -user sysdba -pass masterkey Use CONNECT or CREATE DATABASE to

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

---In firebird-support@yahoogroups.com, hvlad@... wrote : ---In firebird-support@yahoogroups.com, jackmason@... wrote : Hmm... i'd say it is impossible to obtain such results using FIrebird. See below C:\Program Files\Firebird\Firebird_2_5\binisql -user sysdba -pass masterkey Use

[firebird-support] Re: losing connection with server on a local PC

---In firebird-support@yahoogroups.com, shg_sistemas@... wrote : BARO (Client) Tue May 12 12:20:20 2015 C:\Program Files\Firebird\Firebird_2_5\bin\fbserver.exe: terminated abnormally (4294967295) It means that Firebird crashes, unfortunately. Could you provide me with full memory

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

---In firebird-support@yahoogroups.com, joja.lists@... wrote : 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. 1. Show us results of select count(*) form mon$attachments select count(*) form

[firebird-support] Re: Fwd: Nbackup restore failure

---In firebird-support@yahoogroups.com, vncastanheira@... wrote : It should be a nbackup file since it has .nbk extension Strong proof :-) and created by a tool that uses nbackup. What tool ? How it is uses nbackup ? Is it possible to recover it, if corrupted? I don't know.

[firebird-support] Re: Fwd: Nbackup restore failure

---In firebird-support@yahoogroups.com, vncastanheira@... wrote : I'm trying to restore a backup lvl 0, but encountering the following error: Failure: Cannot get backup guid clumplet from I.O backup There's no place where this error gets reported and I'm unable to figure out the

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

---In firebird-support@yahoogroups.com, ts@... 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 restore without

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

---In firebird-support@yahoogroups.com, jackmason@... wrote : The databases reside on a Linux Mint server, but we back them up to a Windows 7 system. Both are running the same release of Firebird. Are you sure you run Firebird 2.5 on Win7 (not 2.1) ? Please, run following in command

[firebird-support] Re: Restoring from Firebird-2.5.4.26856_0_Win32 to Firebird-3.0.0.32136_0_Win32_RC1

Rajiv, there is already a field named SEC$NAME_PART in ODS12 system tables. You should rename your field\domain in source database in order to restore it in FB3. Regards, Vlad

Re: [firebird-support] Re: How to make Sphinx work with Firebird on Linux?

> ---In firebird-support@yahoogroups.com, wrote : > > On 13/11/15 14:22, hvlad@... mailto:hvlad@... [firebird-support] wrote: > > Patch was updated but not announced: > > > > http://web.firebirdsql.org/download/sphinx/ > > http://web.firebirdsql.org/download/sphinx/ > > > > You

Re: [firebird-support] Re: How to make Sphinx work with Firebird on Linux?

> ---In firebird-support@yahoogroups.com, wrote : > > Seems that patch with a little tweaks in configure scripts can be applied to > 2.2 branch > > https://github.com/sphinxsearch/sphinx/pull/10 > https://github.com/sphinxsearch/sphinx/pull/10 > > configure part works i

Re: [firebird-support] Re: How to make Sphinx work with Firebird on Linux?

---In firebird-support@yahoogroups.com, wrote : On 13/11/15 14:22, hvlad@... mailto:hvlad@... [firebird-support] wrote: > Patch was updated but not announced: > > http://web.firebirdsql.org/download/sphinx/ > http://web.firebirdsql.org/download/sphinx/ > > You should get

[firebird-support] Re: Problem occuers while trying to generate trace file

---In firebird-support@yahoogroups.com, babak_bsn@... wrote : I would like to trace data base activity in fire bird using Audit/Trace Services. I run this command in my command prompt: C:\Program Files\Firebird\Firebird_2_5\binfbtracemgr -se localhost/3050:service_mgr -user SYSDBA

[firebird-support] Re: How to make Sphinx work with Firebird on Linux?

Patch was updated but not announced: http://web.firebirdsql.org/download/sphinx/ http://web.firebirdsql.org/download/sphinx/ You should get Sphinx sources, apply patch and make by yourself on CentOS Good luck, Vlad

Re: [firebird-support] About firebird performance

> ---In firebird-support@yahoogroups.com, wrote : > > I discovered something else quite interesting: > > I realized both IB and FB dbs have pagebuffers set to 100.000. I changed FB > to 0 and now it works like I > expected!!..Same query now completes on FB on 50 sec. It seems

[firebird-support] Re: What is better: UPDATE or DELETE + INSERT?

> ---In firebird-support@yahoogroups.com, wrote : > > Hello, > > I need to rebuild some records in my database. I have to choices: > > 1. Firstly I delete set of records and then insert new ones. > 2. I update the existing ones. > > What solution is preferable? Will

[firebird-support] Re: Error on Gfix

> ---In firebird-support@yahoogroups.com, wrote : > > I'm using Firebird 2.5.x and the command gfix -v -full returned: > > Summary of validation errors > > Number of record level errors : 3 > Number of database page errors : 1993 > > What I have to do in order to fix it,

Re: [firebird-support] Re: Error on Gfix

> ---In firebird-support@yahoogroups.com, wrote : > > Hi Vlad, thank for your e-mail! > > I understood what you said, however, in the link > http://www.firebirdsql.org/manual/gfix-dbverify.html > http://www.firebirdsql.org/manual/gfix-dbverify.html I got the following >

Re: [firebird-support] Firebird Embedded on web hosting

---In firebird-support@yahoogroups.com, wrote : > On 18-9-2015 19:50, amigoface@... mailto:amigoface@... [firebird-support] > wrote: > > i have problems on using firebird embedded on my asp.net web host . > > > > everything work fine locally but on the web i have an exception >

[firebird-support] Re: Firebird Embedded on web hosting

> ---In firebird-support@yahoogroups.com, wrote : > anyway, since i cannot control where fbembedded put it's lock and trace > files, Does you read what Mark wrote about FIREBIRD_LOCK environment variable ? > my only option now is to build firebird from source and change

[firebird-support] Re: Event name size?

Quick look at sources show that 1. isc_event_block\gds__event_block and isc_event_counts\gds__event_counts make assumption that event name length is 1-byte wide, i.e. it encode\decode event into\from event blocks using 1-byte length for names. This give us up to 255 bytes for name string. 2.

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

> ---In firebird-support@yahoogroups.com, wrote : > > 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

[firebird-support] Re: Simply bad, new is not always better. FB3 and ODBC

> ---In firebird-support@yahoogroups.com, wrote : > > Using Database Workbench I added a trigger to a table, but it didn't > seen to do anything (in particular didn't throw an exception which it > should have done when I deliberately created an invalid record). > > After restarting

[firebird-support] Re: Simply bad, new is not always better. FB3 and ODBC

---In firebird-support@yahoogroups.com, wrote : http://tracker.firebirdsql.org/browse/CORE-5210 http://tracker.firebirdsql.org/browse/CORE-5210 http://tracker.firebirdsql.org/browse/CORE-5210 [#CORE-5210] Firebird 3.0 + fbclient 3.0 - POST_EVEN...

Re: [firebird-support] Re: Issue with Database Cache Size on FB 3.0

> ---In firebird-support@yahoogroups.com, wrote : > > Something funny is going on regarding the memory consumption, I have > > attached screenshots showing the memory counters. > If you look at the process itself (file > TaskManager_Process_Firebird_Only_Consumed_2GB.jpg), it

[firebird-support] Re: Max RAM for Database Cache in SS FB 3.0 64bit is to small?

> ---In firebird-support@yahoogroups.com, wrote : >> Setting DefaultDbCachePages more than allowed caused a crashed. > Try a v3.0.1 snapshot build, IIRC it was fixed recently. If you mean CORE-5240 - it was a bug in v 2.5 only, i.e. v3 is not affected Regards, Vlad

[firebird-support] Re: Max RAM for Database Cache in SS FB 3.0 64bit is to small?

> ---In firebird-support@yahoogroups.com, wrote : > > Hi guys, > > Am I correct that maximum allowed RAM for database cache on SS FB 3.0 in > Win64 is only 2 GB? > Calculated from max DefaultDbCachePages (131072) x max Page Size (16384) = 2 > GB. No. This is limit for

[firebird-support] Re: Searching for FB3 backup suggestions

---In firebird-support@yahoogroups.com, wrote : > "C:\Program Files\Firebird\Firebird_3_0\gbak.exe" -b -v -t -se service_mgr > employee e:\xxx.bak -user SYSDBA > works if no one is connected else i > always get error "file is used by another process". Specify remote

[firebird-support] Re: Issue with Database Cache Size on FB 3.0

---In firebird-support@yahoogroups.com, wrote : ... > The setting we are playing with are: > > On firebird.conf > > FileSystemCacheThreshold = 0 > FileSystemCacheSize = 17179869184 (this is 16 GB - the server has 32 GB > ram.) Does you ever read comments describing this

RE: [firebird-support] performance issue with firebird 3.0 embedded on linux

---In firebird-support@yahoogroups.com, wrote : > yes, one connection per database, any thread needs to access this database > would > create its own transaction. Then you have serialization at connection level. Both engine and remote layer doesn't allow to run more than

[firebird-support] Re: Borland InterBase Buffer Overflow Vulnerability and Firebird

---In firebird-support@yahoogroups.com, wrote : > Hi, > In which version of Firebird (if in any) was fixed Borland Interbase 2007 > Integer Overflow bug. > Links: > http://www.securityfocus.com/bid/29302/discuss > http://www.securityfocus.com/bid/29302/discuss It is easy to

[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: [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

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

[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

[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] Re: Firebird embedded on ISAPI

> ---In firebird-support@yahoogroups.com, wrote : > > Seems like I cannot use Firebird embedded on an IIS webserver via ISAPI. > > > I am using Delphi REST server. > > Please help if it is possible. Seems you forgot to describe exact problem Regards, Vlad

Re: [firebird-support] Re: UDF install in FB3.0 RC2

> ---In firebird-support@yahoogroups.com, wrote : > > I believe you mentioned earlier that you were testing FB3 RC2 on a fresh > install. Maybe the old UDFs require the presence of the Microsoft Visual > Studio 2005 C runtime (msvcr8), while Firebird only provides the > Microsoft

[firebird-support] Re: Update big table and nbackup benefit or not?

Karol, if you worry about database size after update, i could suggest to split huge update by few smaller, each in own transaction and garbage collect between passes. I.e. something like update t set ... where id between 0 and N; commit; select count(*) from t where id between 0 and N; commit;

[firebird-support] Re: Database Corrupt ?

---In firebird-support@yahoogroups.com, wrote : Your glibc seems ok (a bit outdated, but not critical) > 4. MemTotal: 7911216 kB (8 GB) I mean - could you run memory test to ensure your RAM is ok ? Random corruptions of different databases could be sign of

[firebird-support] Re: Another Error When Backup

> ---In firebird-support@yahoogroups.com, wrote : Christine > > Did anyone ever face this error when gbak ? > > gbak: ERROR:internal Firebird consistency check (decompression overran > buffer (179), file: sqz.cpp line: 239) > gbak: ERROR:gds_$receive failed >

[firebird-support] Re: Error using a transaction parameter block with the OO API.

---In firebird-support@yahoogroups.com, wrote : > I'm using the Firebird 3.0 release version. Delphi 10.1 Berlin with the > firebird.pas release file and fbclient3. I can connect to the database > and can run queries, but I can't seem to get a custom transaction parameter

[firebird-support] Re: Database Corrupt ?

Christine, few questions: - am i correctly understand that you have few different DB's and all of them corrupted ? - does you use 32-bit or 64 bit build of Firebird and CentOS (i686 or x64)? - what is glibc version ? - could you check memory on server machine ? Regards, Vlad

[firebird-support] Re: Firebird 3 performance

Could you try latest snapshot build of 3.0.1 ? Regards, Vlad

Re: [firebird-support] Firebird - explanation of errors

---In firebird-support@yahoogroups.com, wrote : Mark, your answer as usual very detailed and very good, i just want to correct it a bit. >> /1. //POS003 (Server) Fri Jul 15 11:56:32 2016/ >> >> / Database: C:\GASTRO.FDB/ >> >> / Index 6 is corrupt (missing entries) in table

[firebird-support] Re: gfix -shut ? server-klient

---In firebird-support@yahoogroups.com, wrote : ... > Before making repair the database checked the database are logged 2 users > SYSDBA (server and client). In this case, > the command gfix not block access to the database - not disconnect the user > SYSDBA client. ... >

[firebird-support] Re: Triggers on table MON$ATTACHMENTS

> ---In firebird-support@yahoogroups.com, wrote : > > I can create triggers in the MON$ATTACHMENTS table? No > I use Firebird 2.5.6 with flamerobin > > I want to do something like "After Delete" > delete from table1 where con = old.MON$ATTACHMENT_ID RTFM: Database triggers

Re: AW: WG: [firebird-support] Firebird 3 encryption in the background

---In firebird-support@yahoogroups.com, wrote : > Need to come back to this. I can reproduce the behavior with flamerobin as > client. > Connect via the embedded client to a database start encryption, disconnect. I > can see that a handle to the database > is still opened by

[firebird-support] Re: Server crashes sometimes

---In firebird-support@yahoogroups.com, wrote : > my Database isn’t reachable for short times. This happens once in a few > days. The firebird.log shows following messages: > linux-j4zt Wed Aug > 17 10:59:58 2016 > /usr/sbin/fbguard: /usr/sbin/firebird

[firebird-support] Re: Is there an easy way for input rows from a script file?

---In firebird-support@yahoogroups.com, wrote : Hello everybody If I connect to a database "Database1" using ISQL, I can write something like: OUTPUT MyFile.DAT; SELECT * FROM MyTable; OUTPUT; And all the rows of "MyTable" will go to the text file

[firebird-support] Re: Starting auditing session

---In firebird-support@yahoogroups.com, wrote : > I've started looking into Firebird tracing capabilities and there seems to > be very little documentation on the topic besides the official manual and > a few commercial applications that are well known. Does you read

[firebird-support] Re: Fwd: Firebird database corrupt issue. Due to I/O error

---In firebird-support@yahoogroups.com, wrote : > I am facing a DB corruption issue on firebird database. Everytime my > application tries to open connection or perform any DML activities, > randomly i get the following error. So, everytime or randomly ? > ERR::I/O error

Re: [firebird-support] Re: Delegating SYSDBA and enumerating users

---In firebird-support@yahoogroups.com, wrote : ... > Now I have a couple of questions for you: > > 1. Do you know if it is possible in gsec to log in under a custom ROLE? Sure, it is possible > Further to this, is there a way of GRANTing the custom ROLE the

[firebird-support] Re: Delegating SYSDBA and enumerating users

A little sample with Firebird 2.5 I added ordinary users 'user1' and 'user2' and admin user 'adm1'. Now try to display list of users 1. Use sysdba account: firebird\bin>gsec -user sysdba -pass masterkey -display user nameuid gid admin full name

Re: [firebird-support] dropping the connection

---In firebird-support@yahoogroups.com, wrote : > Killing connections by deleting from MON$STATEMENTS requires Firebird > 2.5 and an ODS 11.2 database (so you will also need to backup and > restore the database when migrating to Firebird 2.5!). MON$ATTACHMENTS ;) Regards, Vlad

[firebird-support] Re: Delegating SYSDBA and enumerating users

---In firebird-support@yahoogroups.com, wrote : > In a production environment using Firebird v2.5, we need to delegate > authority of USER CRUD operations to more than one person without these > admins sharing the SYSDBA user and password. Does you read this chapter

Re: [firebird-support] Re: Starting auditing session

> In which DLL are the isc_action_svc_trace_* functions located? I am > planning to call it from a Lazarus project As i already wrote, you should work with Services API. If you never works with it before i suggest to read IB6 "API Guide" https://www.firebirdsql.org/en/reference-manuals/

Re: [firebird-support] Gbak performance issues on FB3

Fabian, run gbak using services (with -se switch) Vlad PS overquoting is BAD

[firebird-support] Re: "nbackup needs local access to database file"

---In firebird-support@yahoogroups.com, wrote : > I am getting this error while running nbackup: > > "nbackup needs local access to database file" > > The nbackup sentence is: > > Nbackup.exe -user SYSDBA -pas HereMyPass -B 0 localhost:MyDB_FB3.fdb >

[firebird-support] Re: Connecting to Firebird 3.01 with JDBC

> ---In firebird-support@yahoogroups.com, wrote : > > Hi guys, > > Anyone here able to connect to FB 3.01 with JDBC 2.x? > > I have tried with jaybird-full-2.2.11 & have adding these lines to > firebird.conf > 1) UserManager = Srp, Legacy_UserManager > 2) AuthClient = Srp,

[firebird-support] Re: Nbackup restored database size is 50 Mega shorter than original DB

> ---In firebird-support@yahoogroups.com, wrote : > > We noticed the results of restoring with NBackup a 7 Gb database is 50 > megabytes shorter in size than the original DB. Is this a problem? Or it > does not matter? Both Db are equal? Engine expands database file by

Re: [firebird-support] deploy Windows Application to access Firebird database

> ---In firebird-support@yahoogroups.com, wrote : > > Hi > What;s requred for the Windows app to access a remote Firebird database ? > The minimal installation ... > 3. The icu* libraries, the same bitness as your application Client not used ICU. It is required for embedded,

[firebird-support] Re: Which connection causes object in use - is there a way to find that out?

---In firebird-support@yahoogroups.com, wrote : > From time to time, when I try to alter a stored procedure in a > production database, I get "object in use" error. Run DDL statement in wait transaction. Better to set some timeout to not wait too much, but not no-wait

[firebird-support] Re: Best way to delete millions of rows

---In firebird-support@yahoogroups.com, wrote : > Pagesize is 16384 It is OK > and pagebuffers is 256. It is *terrible* ! Set it to 1024 and look what happens > Servermode is superclassic. Not matters in this test > If I drop the primary key/index everything

[firebird-support] Re: Best way to delete millions of rows

---In firebird-support@yahoogroups.com, wrote : > I have finally had some more time to look into the problem I have been > having, and have isolated and > reproduced the problem. The cause of the problem seams to be a Varchar(36) ID > column containing a > guid/uuid.

Re: [firebird-support] New auto-increment column, existing data

---In firebird-support@yahoogroups.com, wrote : As said I was a little unclear in my first post, my problem is not to create the autoincrementing field which most of your replies is about but to handle existing table entries. (Neither will I use the rdb$db_key for

Re: [firebird-support] Re: Best way to delete millions of rows

---In firebird-support@yahoogroups.com, wrote : >> Here you delete some records, but then count whole table. >>Add same "where" condition as in "count" query > > I think the execution of select count is for garbage collection. Sure > If count of records that does not exists is

[firebird-support] Re: Best way to delete millions of rows

> ---In firebird-support@yahoogroups.com, wrote : > > Hey Vlad > If i only count the deleted rows, the problem is the same, and > > the server hangs while performing garbage collection. Sad. Probably, table have a lot of indices ? IO subsystem, amount of RAM, page size

[firebird-support] Re: Best way to delete millions of rows

---In firebird-support@yahoogroups.com, wrote : Hey I have a database that needs some cleanup, in some tables i need to delete millions of rows. I performed the cleanup on a copy of the production database in a development environment, using: delete from table where

[firebird-support] Re: Data pages and data page slots

---In firebird-support@yahoogroups.com, wrote : > When I run GSTAT with the switch -data it shows me numbers after "data > pages" and "data page slots". > > Usually these numbers are the same, but ... what happen when they are > different? Physical numbers

[firebird-support] Re: Why this procedure crashes server

---In firebird-support@yahoogroups.com, wrote : > > I am trying to create or modify the following procedure: > > create or alter procedure test_procedure(id integer, p_from_date date) > as > > declare variable from_date date; > declare variable to_date date; > >

[firebird-support] Re: firebird 3.0 ten times slower than 2.5 ?

---In firebird-support@yahoogroups.com, wrote : > In my box in isql mode ( win7_x64, dedicated ssd drive for databases) > default db configuration > > is still difference between 2.5 and 3.0:for select first 100 * > (now over 100% of time fb 2.5) > > > //2.5 > SQL>

Re: [firebird-support] Re: firebird 3.0 ten times slower than 2.5 ?

---In firebird-support@yahoogroups.com, wrote : > In my box in isql mode ( win7_x64, dedicated ssd drive for databases) > default db configuration > > is still difference between 2.5 and 3.0:for select first 100 * > (now over 100% of time fb 2.5) Try Firebird 3.0.2

[firebird-support] Re: FB 3 embedded on Windows 7 64 bit

---In firebird-support@yahoogroups.com, wrote : > Are ther other possibilities to set the Firebird path than setting > %FIREBIRD%? A parameter to attachDatabase() maybe? SetEnvironmentVariable.

Re: [firebird-support] Re: FB 3 embedded on Windows 7 64 bit

---In firebird-support@yahoogroups.com, wrote : On 10.03.2017 15:35, hvlad@... mailto:hvlad@... [firebird-support] wrote: > So setting FIREBIRD environment variable is the correct and only way to > define the Firebird/plugin path at runtime? Correct - yes, only - no

[firebird-support] Re: firebird 3.0 ten times slower than 2.5 ?

---In firebird-support@yahoogroups.com, wrote : Hi, > fb 2.5.7.27050_0_x64 > fb 3.0.1.32609_0_x64 > > same table and data: > ... > > select count(*) from t1 > > //FB 2.5 time 4 sec. > //FB 3.0 time 6 sec > > //now select first 1 mln recs order by id desc > > select

  1   2   >