Re: [firebird-support] FB lock files

2015-12-08 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
Hi Rudi, You did not provide all required information to give you a reasonable answer. At least, post fb_lock_print -d output. Regards, Alexey Kovyazin Try HQbird now! www.hqbird.com

Re: [firebird-support] Replication SW experience

2015-11-26 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
Hi, Try IBReplicator. Regards, Alexey Kovyazin IBSurgeon Hi all, we are preparing new project with bidirectional replication. Customer idea is to have master database in head quoter and slave databases on production plant (to solve network performance and availability issues). Witch

Re: [firebird-support] Firebird for a web application

2015-11-18 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
, including delta files in case of nbackup lock and some others. Regards, Alexey Kovyazin IBSurgeon www.ib-aid.com Hi Mirco, We have written multiple java EE web applications with Firebird on linux as the database. Usually we will use Glassfish (or Payara) as the app server and run Firebird

Re: [firebird-support] Interbase 5.6 (Windows 98) not available on network

2015-11-11 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
Hi Virgo, You should be able to connect to this database with your Firebird (except 3.0). There could be incompatibilities, of course, like reserved words (YEAR, TYPE), but in general it should work for simple SELECT * FROM table. Regards, Alexey Kovyazin IBSurgeon www.ib-aid.com

[firebird-support] Firebird Language Reference - Call For Reviewers

2015-11-11 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
(send any email to firebird-docs-requ...@lists.sourceforge.net) and make yourself and your preferred topics known. Regards, Alexey Kovyazin IBSurgeon www.ib-aid.com

Re: [Firebird-docs] Let's move Firebird Langref to public beta

2015-11-11 Thread Alexey Kovyazin
Hi, >We need reviewers who are fluent in English AND SQL. I am more than happy to coordinate so we can avoid covering territory that has already been covered. Please write news item to distribute at firebirdsql.org and through other channels - kind of Call for reviewers. I am sure there

Re: [firebird-support] Running gfix and gbak from windows service

2015-11-09 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
, Alexey Kovyazin IBSurgeon www.ib-aid.com We using both gfix and gbak from windows service to perform routine maintenance operations such as moving db to shutdown mode performing check and then backup then online mode This works fine on Firebird 2.5.2 however it does not work on 2.5.3 & 2

Re: [firebird-support] Re: Firebird replication help needed

2015-10-09 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
Hi, Try IBReplicator (commercial) instead. Regards, Alexey Kovyazin IBSurgeon I've downloaded the FB Replicator and tryed it on my database. When I want to add it as a souce database I enter path to the DB user pass and click save, but it gives me the following error: ISC ERROR CODE

Re: [firebird-support] Securing database against corruption on systems that suddenly get turned off

2015-09-21 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
, and if corruption happens, this repository will be used to recover database with our recovery tool (FirstAID). In our experience such approach increases chances to recover up to 99%. Regards, Alexey Kovyazin IBSurgeon Hi, We have FirebirdSQL (2.1) running on a client computer (Windows

Re: [firebird-support] Firebird 2.5 Language Reference

2015-09-16 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
Hi, Translation was completed several weeks ago, now Helen Borrie performs proof-reading and editing of the text. Recent preview version of LR looks very promising. Regards, Alexey Kovyazin IBSurgeon Hello everybody Do you know what has happened with the translation of the document

Re: [firebird-support] Firebird 2.5 Language Reference

2015-09-16 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
Hi, Translation was completed several weeks ago, now Helen Borrie performs proof-reading and editing of the text. Recent preview version of LR looks very promising. Regards, Alexey Kovyazin IBSurgeon Hello everybody Do you know what has happened with the translation of the document

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

2015-09-16 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
Hi, See page 20-21 here http://ru.scribd.com/doc/20128182/The-InterBase-and-Firebird-Developer-Magazine-Issue-2-2005 Regards, Alexey Kovyazin IBSurgeon Hello Sean, and everybody That's a very interesting and very important theme: "the new record version will only include the updated f

Re: [firebird-support] HUGE Log File

2015-09-15 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
Hi, Usually such huge log is related with a database corruption. Can you please send here small excerpt from the most recent records of firebird.log (10-15 lines)? Regards, Alexey Kovyazin IBSurgeon

Re: [firebird-support] Growing security2.fdb

2015-09-11 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
Hi Neil, Run DBInfo from IBSurgeon Free tools and check what pages are there. I suppose there are many TIPS, which indicate transactions. Verify it with gstat -h transaction markers values. Regards, Alexey Kovyazin IBSurgeon Hello Something I have noticed with Firebird v2.1 with Windows 32

Re: ODP: Re: [firebird-support] About firebird performance

2015-09-06 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
, and 100k is normal value (but still requires cache heating). Regards, Alexey Kovyazin IBSurgeon Hi, For superserver this should be as high as possible. Why you recommended 1 value? I always set it to highest possible value in current environment compared to size of database. And i

Re: [firebird-support] About firebird performance

2015-09-05 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
is too high for Firebird SuperServer, it should be set to 1. You can use optimized Firebird configuration files http://ib-aid.com/en/optimized-firebird-configuration/ Regards, Alexey Kovyazin IBSurgeon Nevertheless, I'll try on a physical machine as you and Carlos suggest and see how

Re: [firebird-support] Firebird backup on virtual machine

2015-08-28 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
nbackup to lock database before VM snapshot, in this case only delta will be at risk. However, nbackup-only solution is not smart, since it does check an integrity of database, as gbak does. We recommend to use combination of nbackup and gbak. Regards, Alexey Kovyazin IBSurgeon

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

2015-08-26 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
Hi Hernado, You are the third person during several days with this question. Can you please post the full error text? Otherwise it is not possible to provide any help. Regards, Alexey Hi to all, From several days ago we are having trouble with Lock conflict on no wait transaction on a

Re: [firebird-support] Re: DeadLock Conflict

2015-08-24 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
Hi, Please provide full error text and detailed description of the problem. Regards, Alexey Kovyazin IBSurgeon Hi all I experience the same problem. Is there a tutorial to track theese kind of problems? tks Razvan

Re: [firebird-support] DeadLock Conflict

2015-08-24 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
Hi, Probably you mean Lock conflict, not a true deadlock (full error text will help). If you see transaction number in the message, you can track it using MON$ tables, and then find out which connection has started it. Regards, Alexey Kovyazin IBSurgeon Hi All If possible at all, how

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

2015-07-24 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
to forced rollback, and as a result, OIT could stuck, and it will lead to increased gap OIT-OST, which is also not good. For more details about OIT, OST and OAT read this ppt http://www.slideshare.net/ibsurgeon/3-how-transactionswork Regards, Alexey Kovyazin IBSurgeon Hi there, Can

Re: [firebird-support] Corrupted database

2015-06-16 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
Hi, It is a typical corruption usually caused by Firebird abnormal termination due to power outage. You can fix it with IBSurgeon FirstAID more details at www.ib-aid.com Regards, Alexey Kovyazin IBSurgeon 16 июня 2015 г. 6:50 пользователь Nagy Szilveszter nagy_szilvesz...@yahoo.com [firebird

Re: [firebird-support] How do i access firbird database to manipulate the databases

2015-06-01 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
Hi, You can use IBDataPump free tool. It allows data pumping between exact databases or using custom Select queries. Regards, Alexey Kovyazin IBSurgeon Hi there, I am new to firebird and need to manipulate or merge two firebird databases. The tables should be the same format but I need

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

2015-05-28 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
folder at the first step). Then please zip it and send to supp...@ib-aid.com for the investigation. Regards, Alexey Kovyazin IBSurgeon Hello, 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

Re: [firebird-support] GBAK - validation error for column X, value *** null ***

2015-05-15 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
for it. If problems continue, you can export data using our proprietary IBBackupSurgeon tool (http://ib-aid.com/en/ibbackupsurgeon/), which can export data on low-level. Regards, Alexey Kovyazin IBSurgeon Hi! What would be a proper way of dealing with GBAK restore error 'validation error for column X

Re: [firebird-support] Re: How to determine size of database structures?

2015-05-15 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
Hi Bruce, To view size of tables and indices you need to use our IBAnalyst tool (http://ib-aid.com/en/ibanalyst/). Regards, Alexey Kovyazin IBSurgeon Thank you Alexey. This is nice tool, however it does not show how much space is taken by given table and its indices... I am sure

Re: [firebird-support] How to determine size of database structures?

2015-05-14 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
Hi Bruce, DBInfo from IBSurgeon Free Tools (http://ib-aid.com/en/ibsurgeon-free-tools/) will give you database pages statistics. Regards, Alexey Kovyazin IBSurgeon Hi guys. I know that I need to use gstat, and I know that I have detailed description about it here: Gstat Examples

Re: [firebird-support] Profiler for 2.1?

2015-04-12 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
Hi Tim, 2.1 series was discontinued, so nobody will invest in tools for it. Instead of this, consider migration - 2.1 is pretty close to 2.5, where TraceAPI is available. Regards, Alexey Kovyazin IBSurgeon I've just discovered MON$CALL_STACK, and it seems possible that one could use

Re: [firebird-support] nbackup problem : Database is already in the physical backup mode

2015-03-27 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
do you suggest I should do with JayBird when the exception is thrown? Execute alter database end backup? Yes, it should merge delta file back to the main database and unlock it. Regards, Alexey Kovyazin IBSurgeon

Re: [firebird-support] Re: Awaiting Garbage Collector

2015-03-25 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
Hi Walter, I have just one doubt, and it is with page 46. Do you mean Record versions visibility? Regards, Alexey

Re: [firebird-support] Re: Awaiting Garbage Collector

2015-03-25 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
Tx 25, which, obviously was created after Tx 14 was committed. But, again, for Tx 20 these both record versions are invisible. Tx20, as a snapshot, thinks that Tx is active, but in reality it was committed. Regards, Alexey Kovyazin IBSurgeon Hi Alexey Yes, that's right, I can

Re: [firebird-support] Re: Awaiting Garbage Collector

2015-03-23 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
, and run queries to your tables and MON$ tables there. Also, look into this presentation http://www.slideshare.net/ibsurgeon/3-how-transactionswork Regards, Alexey Kovyazin IBSurgeon Regarding the Awaiting GC issue I've done another test: 1- Connect to the database in a test environment

[firebird-support] ANN Firebird 2015 Tour: SQL optimization

2015-03-18 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
://secure.shareit.com/shareit/checkout.html?productid=300604678 Для получения российского счета на оплату напишите sa...@ibase.ru Questions? Feel free to ask any questions at firebird2...@ib-aid.com Regards, Alexey Kovyazin IBSurgeon www.ib-aid.com

[Firebird-docs] Fwd: Another translation

2015-03-12 Thread Alexey Kovyazin
It's a copy. Please confirm - do you see it? Regards, Alexey : Another translation : Mon, 09 Mar 2015 15:34:06 +0300 : Alexey Kovyazin a...@ib-aid.com : firebird-docs@lists.sourceforge.net Hi All, I've got another translation sample from another

Re: [firebird-support] Import - slower and slower commits

2015-02-24 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
Hi, There is a fix in 254 snapshot for similar problem. Download fresh 2.5.4 Firebird snapshot and try it. Regards, Alexey Kovyazin IBSurgeon Firebird Recovery service: http://ib-aid.com/en/firebird-interbase-recovery-service/ Database Performance optimization: http://ib-aid.com/en/firebird

Re: [firebird-support] 2.07 SS 32bit, OS 64bit, mem4GB work bad ?

2015-01-07 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
-system-caching.html In essence, Windows will try to cache whole database in memory, due to file access flag. Regards, Alexey Kovyazin IBSurgeon Hi to All ! In http://www.slideshare.net/ibsurgeon/resolving-firebird-performance-problems http://www.slideshare.net/ibsurgeon

Re: [firebird-support] Bad surprise on performance

2015-01-03 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
Hi Andre, - get some sleep This is the key to find a solution, never optimize anything in a bad mood :) WinSrv2008R2 is a perfect Windows Server, when properly configured. Regards, Alexey

Re: [firebird-support] DRBD

2014-12-10 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
will be distributed in such configuration? How such device will handle careful writes and work of Firebird and OS cache? So, did you make experiments with sudden reboot of one of the nodes with simultaneous high load (inserting or updating a lot of records)? Regards, Alexey Kovyazin IBSurgeon

Re: [firebird-support] DRBD

2014-12-10 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
provide an exact version of your Firebird, and I will try to find a script to kill it or at least freeze. Please contact me: ak at ib-aid.com Regards, Alexey Kovyazin IBSurgeon So, did you make experiments with sudden reboot of one of the nodes with simultaneous high load

Re: [firebird-support] Firebird database seems to influence multi user ability

2014-12-08 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
Hi Benny, Look here http://ib-aid.com/en/articles/cannot-commit-index-or-how-to-pump-data-from-partially-restored-inconsistent-database/ I suggest to insert fake record with ORDERID = 4127, and then try to activate index. Regards, Alexey Kovyazin IBSurgeon Hi, I have been an interbase guy

Re: [Firebird-docs] Choosing the translation service

2014-11-20 Thread Alexey Kovyazin
be ready next week. Regards, Alexey Kovyazin -- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native

Re: [Firebird-docs] Choosing the translation service

2014-11-11 Thread Alexey Kovyazin
Hi Martin, I think so. However, translation requires docx or odp formats. Regards, Alexey Kovyazin IBSurgeon Hi Alexey, will we get the final documentation in DocBook format? Kind regards, Martin it synergy GmbH -Ursprüngliche Nachricht- Von: Alexey Kovyazin [mailto:a...@ib

[Firebird-docs] Choosing the translation service

2014-11-10 Thread Alexey Kovyazin
, Alexey Kovyazin IBSurgeon -- ___ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs

Re: [Firebird-docs] Choosing the translation service

2014-11-10 Thread Alexey Kovyazin
Hi Helen, thank you for feedback. I'll submit more texts for translations and present them here. Certainly we will need to provide some vocabulary for any translator - SQL is pretty narrow topic... Regards, Alexey At 09:37 p.m. 10/11/2014, Alexey Kovyazin wrote: Hi All, As you know, we

[firebird-support] Firebird Language Reference - Firebird needs your help

2014-11-07 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
Operations Guide etc. Regards, Alexey Kovyazin IBSurgeon

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

2014-10-29 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
Hi, I want to replace my Firebird 32 1.5.6 with the last Firebird 64 2.5.3, http://www.slideshare.net/ibsurgeon/firebird-migration-from-firebird-15-to-firebird-25 Regards, Alexey Kovyazin IBSurgeon

Re: [firebird-support] Firebird performance question

2014-10-02 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
-aid.com/required-information-for-firebird-database-performance-optimization Regards, Alexey Kovyazin IBSurgeon Hi, We have been using Firebird Super Server version 1.5.6 on both Windows 7 (64 Bit) and Server 2008 (64 Bit). Both systems are the same except for the OS and they have 2 CPUs

Re: [firebird-support] Firebird Embedded corruptions

2014-09-23 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
license every time you are running recovery (not diagnose). So you can (from license and technical points of view) include FirstAID executables into your application, so user will be able to use on demand. Don't hesitate to contact our supp...@ib-aid.com for more details. Regards, Alexey

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

2014-09-21 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
a nbackup? If you are using nbackup, you need to understand that you need to watch delta file size and lifetime, and also be aware that nbackup does not detect any errors on page or record level. Regards, Alexey Kovyazin IBSurgeon Hello, I have encountered a serious problem with nbackup. During

Re: [firebird-support] Firebird Embedded corruptions

2014-09-13 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
Hi Jan, You did not tell what kind of corruption you had (please provide full text of error). There are plenty of them, as well as reasons. You also could use our tool FirstAID (Direct) to analyze database on low level and see where are the problems. Regards, Alexey Kovyazin IBSurgeon

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

2014-09-12 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
Hi Russel, Good starting point could be our optimized configuration files: http://ib-aid.com/en/optimized-firebird-configuration/ Regards, Alexey Kovyazin IBSurgeon What type of access (read vs. write mix) are you expecting? Mainly write What mix of small vs. large queries are you expecting

Re: [firebird-support] Re: TempCacheLimit in Super Classic

2014-07-08 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
- the more clients connected the more memory will be consumed. SuperServer has single cache (per database), it will be shared between connected users. Regards, Alexey Kovyazin IBSurgeon Thank you very much. 2 vs 1, but in this case I asume that Dmitry wins. I'll check the optimized configuration

Re: [firebird-support] Unable to repair a corrupt database

2014-07-03 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
Hi, Try to open database with FirstAID Extractor (it's free) and check is there data you are looking inside. Regards, Alexey Kovyazin IBSurgeon I have a Firebird 2.5.2 database (ODS 11.2). The database has corrupted. When I open the database, I receive a message page 1577

Re: [firebird-support] Database Too Large.

2014-06-27 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
masterkey database_path that's all. Regards, Alexey Kovyazin IBSurgeon

Re: [firebird-support] Why different Firebird instances have different read/fetches statistics

2014-06-11 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
Hi Jonathan, Most likely you have different firebird.conf. Align them and check again. Regards, Alexey Kovyazin Hi! I have different Firebird instances/databases, one is running on Windows, another on Linux (the servers have different RAM amount as well). The execution of the same SQL code

Re: [firebird-support] Firebird 1.5 on 64bit OS. Newer Hardware but bad performance

2014-05-30 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
Halim, Ok, thank you. 1.5 is really old, upgrade asap. Regards, Alexey Kovyazin Hi Alexey, Here is where I read it. Page 7. PPT Presentation during FDD 2012, Brazil. http://www.slideshare.net/ibsurgeon/resolving-firebird-performance-problems# Keep in mind, we are still using 1.5 FB. Thank

Re: [firebird-support] Restore DB with Firebird 1.5 Super Server vs Classic Server

2014-05-28 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
Hi Halim, Try to use optimized configuration file for Firebird 1.5 Classic: http://ib-aid.com/optimized-firebird-configuration Regards, Alexey Kovyazin IBSurgeon Here is the link to the zip file: http://ge.tt/1raCY2i1/v/0?c Thank you, -Halim To: firebird-support@yahoogroups.com From

Re: [firebird-support] Restore DB with Firebird 1.5 Super Server vs Classic Server

2014-05-27 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
Hi Halim, firebird-support does not allow attachments. Please put zip with info to some sharing service like ge.tt, and post link here. Regards, Alexey Kovyazin IBSurgeon Please see attached zip file with questionnaire response regarding our server performance.Also, I have attached restore

Re: [firebird-support] Restore DB with Firebird 1.5 Super Server vs Classic Server

2014-05-24 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
Hi, In order to give you a good optimization advice, please answer the following questions: http://ib-aid.com/en/articles/required-information-for-firebird-database-performance-optimization/ Regards, Alexey Kovyazin IBSurgeon Thank you for your reply. I used default restore settings and I

Re: [firebird-support] port requirements for Firebird Services API - IBAnalyst

2014-05-22 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
, and IBAnalyst loads some old version. The easiest way to fix it is to copy fbclient.dll (it should be 32bit) to its folder C:\Program Files (x86)\IBAnalyst27 Regards, Alexey Kovyazin IBSurgeon PS Our main support email is supp...@ib-aid.com, please feel free to contact us. Hi Firebird users

Re: [firebird-support] Strange behaviour error writing data to connection - but after some time connection is back.

2014-04-08 Thread Alexey Kovyazin
Hi, Most likely you did not change default configuration of xinted, which has restriction in number of connections/second. Set it to unlimited or some bigger value. Regards, Alexey Kovyazin IBSurgeon Hi guys, I have problems which I can not explain, nor do I know how to solve it. We have

Re: [firebird-support] Invalid BLOB ID

2014-03-07 Thread Alexey Kovyazin
Hi, It's missed BLOBs, good that you have this, not critical errors. Perform backup and restore. Regards, Alexey Kovyazin www.ibsurgeon.com Hi all, i have this error repeated about 20 times when backing up my database: gbak:error accessing BLOB column EXPLICATIE -- continuing gbak

Re: [firebird-support] Invalid BLOB ID

2014-03-07 Thread Alexey Kovyazin
Hi Alan, Missed, orphaned, slightly corrupted - the is no strict term. There will be error while trying to fetch such BLOB field, but gbak [sometimes] can workaround it. Regards, Alexey Kovyazin www.ibsurgeon.com Hi, It's missed BLOBs, good that you have this, not critical errors

Re: [firebird-support] Wrong page type, how to examine/fix?

2014-02-24 Thread Alexey Kovyazin
are active, you are on the way to corruption. The simple workaround is to pump all data to the empty database with the same structure, except bad table. It could take several days, but it's free. Regards, Alexey Kovyazin www.ibsurgeon.com

Re: [firebird-support] For those who think they have performance problems

2014-02-21 Thread Alexey Kovyazin
): forward: 17197144, backward: 3648808 Regards, Alexey Kovyazin IBSurgeon

[firebird-support] For those who think they have performance problems

2014-02-20 Thread Alexey Kovyazin
Free owners (160): forward: 186465696, backward: 25763912 Free locks (78217): forward: 5469536, backward: 1074360 Free requests (386094): forward: 206130320, backward: 103961080 Lock Ordering: Enabled Regards, Alexey Kovyazin www.IBSurgeon.com

Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2

2014-02-18 Thread Alexey Kovyazin
support for free in this support list, sorry. Try other Firebird service providers: http://www.firebirdsql.org/en/professional-support/ may be they have free time. Regards, Alexey Kovyazin IBSurgeon

Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2

2014-02-18 Thread Alexey Kovyazin
would sit with InterBase 6.0, as it was released by Borland in 2000. Regards, Alexey Kovyazin IBSurgeon Hi, I suppose we all have our opinions. This is not an opinion, this is statement, confirmed by our 12 years experience with Firebird and 5 years with Win 2008. Your problem

[firebird-support] Required information for Firebird database performance optimization

2014-02-18 Thread Alexey Kovyazin
and send answers to the list, in order to facilitate performance problems resolution. Regards, Alexey Kovyazin IBSurgeon

Re: [firebird-support] Required information for Firebird database performance optimization

2014-02-18 Thread Alexey Kovyazin
Hi Hannes, Good point, thank you - I added it. Regards, Alexey Kovyazin Guten Tag Alexey Kovyazin, nice Questionaire , i would suggest to add 1 more point if it has a Raid then the size of the Stripe Set The Stripe Set ist the amount of data a raid moves to / from the diskarray for every

Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2

2014-02-17 Thread Alexey Kovyazin
a problem with configuration (incl. version) of Firebird and OS (incl. drivers and domain controllers), or performance problems in your own code (in 80% it's long-running transactions). Regards, Alexey Kovyazin IBSurgeon PS Btw, guys who started the topic already fixed the problem. I hope

Re: [firebird-support] Firebird slowdowns while resources are available

2014-02-11 Thread Alexey Kovyazin
/professional-support/ Regards, Alexey Kovyazin IBSurgeon PS If somebody here wants to go through steps described above, please don't hesitate to do this. Hi, I have a strange slowdown problem with a Firebird database. During the daily use of the database the clients experience significant

Re: [firebird-support] OT: Vote for Firebird as Database of the Year 2013 at LinuxQuestions

2014-02-05 Thread Alexey Kovyazin
in the end of the page - in any language). Regards, Alexey Kovyazin Vote for Firebird as Database of the Year 2013 at LinuxQuestions (*must be registered user with at least one Linux related post*) http://www.linuxquestions.org/questions/2013-linuxquestions-org-members-choice-awards-109/database

Re: [firebird-support] OT: Vote for Firebird as Database of the Year 2013 at LinuxQuestions

2014-02-05 Thread Alexey Kovyazin
Thank you, Maya! Your testimonial is visible now. Regards, Alexey Kovyazin We chose Firebird ourselves, and love Firebird. We use Windows though, not Linux, but we do have a few sites that have chosen to use a Linux server. Haven't voted on the poll, as we really have no Linux related

Re: [firebird-support] Internal Firebird consistency check (cannot find record back version (291) - how to fix and prevent?

2014-01-29 Thread Alexey Kovyazin
due to hardware problem in RAM or disk. I am trying to fix this error by using gfix: gfix.exe -v -f -user SYSDBA -password masterkey MYDB.FDB try gfix -mend ... gbak -b -g -v -ig ... And, IBSurgeon FirstAID should be able to export data from this database for sure. Regards, Alexey Kovyazin

Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2

2014-01-22 Thread Alexey Kovyazin
in professional optimization (http://ib-aid.com/services/optimization), contact our support. Regards, Alexey Kovyazin www.IBSurgeon.com AFAIK, the parameter DefaultDbCachePages is intended for newly created databases as default size of cache pages. It doesn't have effect on existing databases

Re: [firebird-support] RE: Firebird configuration for better performance

2014-01-09 Thread Alexey Kovyazin
Hi Steve, Value from database header overrides default value from conf file. So I believe this is Ok. Regards, Alexey Kovyazin IBSurgeon Hi Alexey, For the database (Using GBAK restore with options): Page Size = 8192 Buffers = 1 In the firebird.conf file: DefaultDBCachePages = 32768

Re: [firebird-support] Firebird configuration for better performance

2014-01-08 Thread Alexey Kovyazin
. Regards, Alexey Kovyazin www.ibsurgeon.com Hi, I'm running Firebird 2.5.2 SuperServer on a Windows 7 Professional 64-bit PC. The PC currently has 4 GB of RAM, but we plan to upgrade to 8 GB soon. The database is a small database used for inventory and stock control with about 30 tables

Re: [firebird-support] Garbage collection / sweep not happening on super classic

2014-01-07 Thread Alexey Kovyazin
Hi, Oldest transaction 15230691 Oldest active 15230692 Oldest snapshot 15230692 Next transaction16644907 You have long-running active transaction. Use MON$ tables to identify who is holding it and stop. Regards, Alexey Kovyazin

Re: [firebird-support] RE: Garbage collection / sweep not happening on super classic

2014-01-07 Thread Alexey Kovyazin
say more without detailed investigation. Regards, Alexey Kovyazin www.ibsurgeon.com This is Classic, so yes, automatic sweep is disabled. My understanding is that gbak does a sweep while doing a backup, which happens nightly, so sweep should be happening then (if I understand it correctly

Re: [firebird-support] Can a Firebird database be hosted on a hosting site?

2014-01-04 Thread Alexey Kovyazin
Hi, Rent VPS or dedicated server and install there all you need (including Firebird). Regards, Alexey Kovyazin IBSurgeon Hello to all, I would like to host my firebird database on a provider, but don't have an idea on where to start. We currently have a firebird database in which

Re: [firebird-support] What happens when nbackup fails

2013-12-21 Thread Alexey Kovyazin
situation, more often you can notice that database is corrupted, while nbackup is working normally - it's working on page level and record-level corruptions are out of nbackup scope. To avoid such situation, make usual backup (with gbak) and test restore regularly. Regards, Alexey Kovyazin

Re: [firebird-support] RE: Why is this setup not working?

2013-12-11 Thread Alexey Kovyazin
support, with database statistics investigation, ongoing transaction's markers monitoring, queries audit, locks analysis, etc. Regards, Alexey Kovyazin Hey Mark. Thanks for your reply. The firebird DB is running SuperClassic. The config kan be found on pastebin http://pastebin.com

Re: [firebird-support] Single Row Table Becomes Unresponsive

2013-12-10 Thread Alexey Kovyazin
Hi Greg, Run gstat -r or IBAnalyst and check number of record versions in this table. I suppose there could be millions of versions. Regards, Alexey Kovyazin IBSurgeon Hi, We're using Firebird 2.1.2.1818 on Centos 5.9. We have a third party replication product SymmetricDS, that accesses

Re: [firebird-support] Why is this setup not working?

2013-12-09 Thread Alexey Kovyazin
management have problems. Can it be fixed? Sure - with more details. Regards, Alexey Kovyazin www.IBSurgeon.com Hey guys. We have a webcluster consisting of 8 webservers running a PHP application with a firebird DB. The application have a rather hard peak one time a day and firebird are not able

[firebird-support] Firebird seminar in Prague, November 25, 2013

2013-10-10 Thread Alexey Kovyazin
-aid.com Regards, Alexey Kovyazin IBSurgeon

[firebird-support] ANN: Firebird 2013 Tour - seminar in Siegburg, Germany, November 22, 2013

2013-09-24 Thread Alexey Kovyazin
, and, of course, performance analysis of transactions and related areas. More details: http://www.firebirdsql.org/en/firebird-conference-tour-2013/ Regards, Alexey Kovyazin IBSurgeon (www.ib-aid.com)

Re: [firebird-support] IBLite iOS and Android

2013-09-16 Thread Alexey Kovyazin
cannot afford it - all 4 core developers are working at Firebird 3.0 and bug fixing of previous versions. Regards, Alexey Kovyazin IBSurgeon www.ib-aid.com We hear a lot of complaints about EMB and the Delphi product and it all boils down to the notion of not enough resources being applied

Re: [firebird-support] XE4, Interbase Express, 32/64bit, Firebird 2.5.2

2013-06-24 Thread Alexey Kovyazin
Hi! Firebird and InterBase are different databases. Regards, Alexey Kovyazin IBSurgeon Hi! Are there any known incompability issues? Thank you! [Non-text portions of this message have been removed]

Re: [firebird-support] Why a database grows after a cycle backup/restore?

2013-06-21 Thread Alexey Kovyazin
grows: -FIX_FSS_D ISO8859_1 -FIX_FSS_MISO8859_1 You should apply this option only once, when upgrading from 2.1. If you apply it every time, you do transliteration every time and database size will grow. Regards, Alexey Kovyazin IBSurgeon [Non-text portions of this message have been removed]

Re: [firebird-support] Firebird database

2013-05-28 Thread Alexey Kovyazin
Hi, So you found 640Gb of information. Is it related with recent leaks of account form BVI offshore companies? :) Regarding your questions - see gbak manual here http://www.firebirdsql.org/en/reference-manuals/ Regards, Alexey Kovyazin IBSurgeon I found a database that weighs 640G

Re: [firebird-support] RDB$PAGES

2013-05-23 Thread Alexey Kovyazin
Hi, You can use our free product DBInfo http://ib-aid.com/products/firebird_interbase/monitoring/dbinfo Also, you can divide size of your database in bytes to the page size of your database. Regards, Alexey Kovyazin IBSurgeon Hi, I'd like to get the count of all types of db pages. If I

Re: [firebird-support] Best Firebird Platform for our Environment

2013-04-02 Thread Alexey Kovyazin
Hello, You need to install 64Gb RAM. If you effective drivers for HDD, OS is not very important. Regards, Alexey Kovyazin IBSurgeon We are trying to determine the best platform for Firebird SQL 2.5.2. Our firebird databases are 40-60gb in size and are being accessed by dbase plus 2.6.2

Re: [firebird-support] gbak restore error

2013-03-14 Thread Alexey Kovyazin
Rick, No space left on the disk. Regards, Alexey Kovyazin IBSurgeon Does anyone know what this error from gbak is? Done with volume #1, /mnt/usb/firebird/clone.fbk Press return to reopen that file, or type a new name followed by return to open a different file. [Non-text portions

Re: [firebird-support] Re: Internal GDS errors that cause corruption and unrecoverable databases

2013-03-05 Thread Alexey Kovyazin
implementation of check restore. Regards, Alexey Kovyazin IBSurgeon [Non-text portions of this message have been removed]

Re: [firebird-support] Re: SuperClassic 2.52 on Linux Mint 24 Cinnamon Failed

2013-02-24 Thread Alexey Kovyazin
. Regards, Alexey Kovyazin IBSurgeon Sorry, that should have been Mint 14. --- In firebird-support@yahoogroups.com mailto:firebird-support%40yahoogroups.com, jackmason17@... wrote: We converted from Windows 7 Interbase 6.02 last Monday by backing up the databases then restoring them

Re: [firebird-support] Hosting Firebird in cloud

2013-02-17 Thread Alexey Kovyazin
Hello, You can use any VPS with reasonable IO bandwidth. Regards, Alexey Kovyazin IBSurgeon What are possible hosting providers that support Firebird? I have searched older blog posts about Azure and Amazon but have found that it has not been very smooth in the past. What is current

Re: [firebird-support] Database corruption with FB 1.5 on Linux... Please help

2013-02-09 Thread Alexey Kovyazin
Hello Myles, Do backup with the following switches: gbak -b -g -v -ig ... Regards, Alexey Kovyazin IBSurgeon We have a Firebird 1.5 Super Server database on Linux running that decided last week to stop successfully completing a backup with GBAK. After running for about an hour, it fails

Re: [firebird-support] URGENT : Corrupt Firebird dabase

2013-01-23 Thread Alexey Kovyazin
to the less potential problems. Regards, Alexey Kovyazin IBSurgeon This works for me: gfix.exe -user SYSDBA -password masterkey -m -f -ignore c:\data\yourdb.gdb gbak.exe -user SYSDBA -password masterkey -b -v -limbo -ignore -garbage c:\data\yourdb.gdb c:\data\yourdb.bak ren c:\data\yourdb.gdb c

Re: [firebird-support] Is windows better than Linux for Firebird 2.5 64 bit?

2012-11-05 Thread Alexey Kovyazin
Hello, In essence, if you don't know answers for the questions you asked, you should not move to Linux. There are more pitfalls, which cannot be explained by short hints. Regards, Alexey Kovyazin IBSurgeon Hi all, I am considering moving from windows to linux, but not sure if it is a good

<    1   2   3   4   5   >