Re: [firebird-support] FB 2.5.8 - Next transaction value growing too much.

Helen thank you very much for your answer. It clarifies my concepts about gfix and gstat. Best regards, Hernando.

[firebird-support] FB 2.5.8 - Next transaction value growing too much.

Hi group. I've working around tuning up a database speed and found that gstat -h shows valuable information about transactions. Also that gfix -sweep removes garbage from the database. I understood that when Next transaction grows too much from Oldest active transaction, "sweeping" the

[firebird-support] Firebird 2.5 - Data committed to database is not found after a while

Hi, I have a legacy application written in Delphi XE6 using Firebird 2.5. Since several months ago have noticed that some times table records are not commited to database. I thougt that it was user mistakes with the application but not. They show me evidences that data was typed correctly:

[firebird-support] Re: Firebird 2.5: Nested querys help

Hi Set. Your query is working just as I needed. Good querys are the best querys as they are simpler. Thank you very much. Best regards. Hernando.

[firebird-support] Re: Firebird 2.5: Nested querys help

Set, thank you for your help. I'll like to explain my self better. If having these records: table_id date_time customer_id other_fields --- 001 08/30/2017 08:00 0015 whatever 002 08/30/2017 08:10

[firebird-support] Firebird 2.5: Nested querys help

Hi to all. I have a table with these columns: table_id, date_time, customer, other_fields One customer could have several records in the same date and I have to make a SELECT only to the first table_id for a given date for each customer_id. I have worked around the query with

[firebird-support] Re: Firebird 2.5 Linux Red Hat 7 - Permission denied

Dimitry Thank you for posting. > Make sure than yo use TCP/IP connection string (localhost:/whatever) I'm using this command: ./isql -user sysdba -pass masterkey localhost:/data/med6/fdb/mydatabase.fdb and get the "Permission denied" but if I move the mydatabase.fdb file to

[firebird-support] Firebird 2.5 Linux Red Hat 7 - Permission denied

Hi to all I'm having an "Permission denied" issue with Firebird 2.5 super-server in a Linux Red Hat 7 box. I can only read databases located on /var/lib/firebird/data. If I locate the same database in any different directory, when I try to access it using isql I get a "Permision

[firebird-support] Re: How to fill detail table with record secuence into master table

Thank you very much for your posts. Both examples are very valuable. Anyway what I need is to start from 1 for each master. Best regards. Hernando.

[firebird-support] How to fill detail table with record secuence into master table

Hi to all, I have two tables with a master detail relation. The detail table has the fields "id", "master_id" and "detail_id". I need to fill the "detail_id" field with a sequence from 1 to n for each record in the master table. I can't figure out how to do this. Any help will

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

Alexey, Thank you for your help. I'll write and get ready some querys for mon$xxx tables for solving the issue if it comes back again. Best regards, Hernando.

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.

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

Hi to all, From several days ago we are having trouble with Lock conflict on no wait transaction on a Firebird 2.5 server thas was working fine since several months ago on a Windows 2008 Server. We use gfix with -list option but it seems not to be any transaction pending. The gfix

Re: [firebird-support] Re: How to populate a new table column with a INTEGER sequence?

Yes Martijn you are quite rigth, exactly what I wanted to do ... Thank you, Hernando.

[firebird-support] Re: How to populate a new table column with a INTEGER sequence?

Hi to all, This is one approach (Maybe could be done one more efficient): /** * Firebird 2.5 */ -- 1.Create new fields ALTER TABLE some_table ADD id INTEGER DEFAULT 0 NOT NULL, ADD foo_dummy CHAR(1); -- 2.Create generador CREATE GENERATOR some_table_id_gen; --

[firebird-support] How to populate a new table column with a INTEGER sequence?

Hi, I'm asking for some help for changing the primary key of a table that has more than 100 records. The idea is to create a new INTEGER column that will contain a generated sequence by combining a generator and a trigger that is going to be the primary key. So I have to get

[firebird-support] Re: Can't connect to CentOS 7 service port 3050 from network

Thank you both for helping. Effectively I missed some steps your posts remind me. Hernando.

[firebird-support] Can't connect to CentOS 7 service port 3050 from network

Hi to all I've just installed Firebird 2.5 SuperClassic on a new Linux CentOS 7 box. I tested local connections and are working fine. SELinux is disabled and firewall service is down. But when I try to connect from a workstation using telnet my-server 3050, is not responding. Neither I

[firebird-support] Re: Firebird SQL on Linux Centos 7 (Kernel 3.10)

Thank you all of you. Your contributions are invaluable in migrating my CentOS box to 7. Best regards, Hernando.

[firebird-support] Firebird SQL on Linux Centos 7 (Kernel 3.10)

Hi, I will like to know how to install Firebird SQL in Linux CentOS 7. Is it compatible with the new Kernel 3.10? Has it been plenty tested? Best regards. Hernando