[firebird-support] fb_lock_print fails
Hi, I'm trying to track down some potential locking issues but I can't get this to work (firebird 2.5.7 on centos) $ fb_lock_print -d /db/xxx.fdb Unable to access lock table. operating system directive shmem_data->sh_mem_length_mapped is 0 failed -Success -- Nick
Re: [firebird-support] Technical IT specialist Firebird corruption
I've had a similar issue when the database code was looking for custom UDF's that had not been installed on the destination, in some ways that can appear as corruption even though it isn't -- Nick On Fri, 17 Apr 2020 at 12:15, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > > > On 18-04-2020 12:19, Shane delphi_ric...@yahoo.co.uk [firebird-support] > wrote: > > The scenario that I've setup is Opensuse is the main OS. I'm running > > Windows XP on a VirtualBox. So within Windows XP I communicate to the > > Linux OS through samba, copying to the folder the database is running. I > > do the systemctl stop to Firebird on the Linux Server then restart after > > it's finished copying . > > What exactly are you copying? How are you moving the database from > Windows to Linux, what are the exact steps and commands used? If you > were using gbak to backup and restore, there would be no need to stop > Firebird on your Linux server. So it sounds like you are copying the > database file itself, instead of using gbak to back it up on Windows and > then - using gbak - restore it on Linux. > > > I did use the gbak on all the backups. I even tried Flamerobin to > > restore resent backups. which it didn't give any errors. > > But it does want to be registered and the Defin support person says it > > corrupted!!! > > Then possibly this might be a problem with the application and not so > much with the database. You would need to contact support of your > application for more help. > > Mark > -- > Mark Rotteveel > >
Re: [firebird-support] index vs page size
Thank you Kind Regards, Nick Nick Upson | Principal Operations Engineer office +44 01799 588800 support hotline +44 1799 399200 DDI +44 01799 588621 telensa.com<http://www.telensa.com/> | @telensa<http://www.twitter.com/telensa> | Linkedin<http://www.linkedin.com/company/telensa> From: firebird-support@yahoogroups.com on behalf of Ann Harrison aharri...@ibphoenix.com [firebird-support] Sent: 21 June 2019 12:31 To: firebird-support@yahoogroups.com Subject: Re: [firebird-support] index vs page size On Jun 20, 2019, at 11:10 AM, Nick Upson n...@telensa.com<mailto:n...@telensa.com> [firebird-support] mailto:firebird-support@yahoogroups.com>> wrote: Hi I have a large 100Gb+ firebird 2.5 database and I'm trying to deal with some performance issues. One indicator I have found is that several large tables have indexes with a depth of 3 (and one of 4). The guidance I have seen says to increase the page size until the depth is below 3 but the pagesize is already maxed out at 16k. Can anyone suggest other actions I could take. The guidance should have been three or less, not less than three. One index with four levels should not be a crisis if you have adequate page cache. Good luck, Ann Kind Regards, Nick Nick Upson | Principal Operations Engineer office +44 01799 588800 support hotline +44 1799 399200 DDI +44 01799 588621 telensa.com<http://www.telensa.com/> | @telensa<http://www.twitter.com/telensa> | Linkedin<http://www.linkedin.com/company/telensa> IMPORTANT NOTICE: This e-mail message is intended to be received only by persons entitled to receive the confidential information it may contain. E-mail messages to clients of Telensa may contain information that is confidential and legally privileged. Please do not read, copy, forward, or store this message unless you are an intended recipient of it. If you have received this message in error, please forward it to the sender and delete it completely from your computer system. CAUTION. This email originated from outside of Telensa. Do not click links or open attachments unless you recognise the sender and know the content is safe. IMPORTANT NOTICE: This e-mail message is intended to be received only by persons entitled to receive the confidential information it may contain. E-mail messages to clients of Telensa may contain information that is confidential and legally privileged. Please do not read, copy, forward, or store this message unless you are an intended recipient of it. If you have received this message in error, please forward it to the sender and delete it completely from your computer system.
[firebird-support] index vs page size
Hi I have a large 100Gb+ firebird 2.5 database and I'm trying to deal with some performance issues. One indicator I have found is that several large tables have indexes with a depth of 3 (and one of 4). The guidance I have seen says to increase the page size until the depth is below 3 but the pagesize is already maxed out at 16k. Can anyone suggest other actions I could take. Kind Regards, Nick Nick Upson | Principal Operations Engineer office +44 01799 588800 support hotline +44 1799 399200 DDI +44 01799 588621 telensa.com<http://www.telensa.com/> | @telensa<http://www.twitter.com/telensa> | Linkedin<http://www.linkedin.com/company/telensa> IMPORTANT NOTICE: This e-mail message is intended to be received only by persons entitled to receive the confidential information it may contain. E-mail messages to clients of Telensa may contain information that is confidential and legally privileged. Please do not read, copy, forward, or store this message unless you are an intended recipient of it. If you have received this message in error, please forward it to the sender and delete it completely from your computer system.
Re: [firebird-support] rw vs ro connections
I should have been more specific, the python code is done as ro_transaction = DB.trans(fdb.ISOLATION_LEVEL_READ_COMMITED_RO) cur = ro_transaction.cursor() else: cur = DB.cursor() I don't see any reason this should perform better but colleagues disagree Kind Regards, Nick Nick Upson | Principal Operations Engineer office +44 01799 588800 support hotline +44 1799 399200 DDI +44 01799 588621 telensa.com<http://www.telensa.com/> | @telensa<http://www.twitter.com/telensa> | Linkedin<http://www.linkedin.com/company/telensa> From: firebird-support@yahoogroups.com on behalf of Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] Sent: 19 June 2019 16:59 To: firebird-support@yahoogroups.com Subject: Re: [firebird-support] rw vs ro connections 19.06.2019 17:51, Nick Upson n...@telensa.com [firebird-support] wrote: > Should I expect any performance gain if I change my rw connections to ro, > given that the > query is always of the form "select * from ..." At first, there is no such things as "ro connection". At second, ro transactions have no performance advantage. -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links CAUTION. This email originated from outside of Telensa. Do not click links or open attachments unless you recognise the sender and know the content is safe. IMPORTANT NOTICE: This e-mail message is intended to be received only by persons entitled to receive the confidential information it may contain. E-mail messages to clients of Telensa may contain information that is confidential and legally privileged. Please do not read, copy, forward, or store this message unless you are an intended recipient of it. If you have received this message in error, please forward it to the sender and delete it completely from your computer system.
[firebird-support] rw vs ro connections
Hi Should I expect any performance gain if I change my rw connections to ro, given that the query is always of the form "select * from ..." Kind Regards, Nick Nick Upson | Principal Operations Engineer office +44 01799 588800 support hotline +44 1799 399200 DDI +44 01799 588621 telensa.com<http://www.telensa.com/> | @telensa<http://www.twitter.com/telensa> | Linkedin<http://www.linkedin.com/company/telensa> IMPORTANT NOTICE: This e-mail message is intended to be received only by persons entitled to receive the confidential information it may contain. E-mail messages to clients of Telensa may contain information that is confidential and legally privileged. Please do not read, copy, forward, or store this message unless you are an intended recipient of it. If you have received this message in error, please forward it to the sender and delete it completely from your computer system.
Re: [firebird-support] permissions nbackup
yes, I can place the call to nbackup in a crontab for firebird or root, that seems to be the only way On 14 August 2017 at 16:51, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 14.08.2017 17:44, Nick Upson n...@telensa.com [firebird-support] wrote: > > because this is from cron, so key-based auth is out and I don't want to > put passwords / > > keys on the server > >According to google you don't need password for cron jobs: > https://stackoverflow.com/questions/8475694/how-to- > specify-in-crontab-by-what-user-to-run-script > > > -- >WBR, SD. > > > > > > > ++ > > Visit http://www.firebirdsql.org and click the Documentation item > on the main (top) menu. Try FAQ and other links from the left-side menu > there. > > Also search the knowledgebases at http://www.ibphoenix.com/ > resources/documents/ > > ++ > > > Yahoo Groups Links > > > >
Re: [firebird-support] permissions nbackup
because this is from cron, so key-based auth is out and I don't want to put passwords / keys on the server I can run from a root cron, with possible su to firebird, but was hoping for something better On 14 August 2017 at 16:41, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 14.08.2017 17:21, Nick Upson n...@telensa.com [firebird-support] wrote: > > if I do nbackup . it fails, telling me I cannot access the > security2.fdb (as a normal > > user) > >Why can't you use su to change current user to root or firebird? > > > -- >WBR, SD. > > > > > > > ++ > > Visit http://www.firebirdsql.org and click the Documentation item > on the main (top) menu. Try FAQ and other links from the left-side menu > there. > > Also search the knowledgebases at http://www.ibphoenix.com/ > resources/documents/ > > ++ > > > Yahoo Groups Links > > > >
Re: [firebird-support] permissions nbackup
its the generic one # ls -l /var/lib/firebird/system/security2.fdb -rw--- 1 firebird firebird 1064960 Aug 14 16:34 /var/lib/firebird/system/security2.fdb # rpm -qa | grep fire firebird-classic-common-2.5.5.26952.0-2.el6.x86_64 firebird-libfbembed-2.5.5.26952.0-2.el6.x86_64 firebird-classic-2.5.5.26952.0-2.el6.x86_64 firebird-libfbclient-2.5.5.26952.0-2.el6.x86_64 firebird-2.5.5.26952.0-2.el6.x86_64 firebird-filesystem-2.5.5.26952.0-2.el6.x86_64 On 14 August 2017 at 16:32, 'Paul Beach' pabe...@waitrose.com [firebird-support] wrote: > > > <<# ls -lart /var/lib/firebird/system/security2.fdb > -rw--- 1 firebird firebird 1171456 Aug 14 14:25 > /var/lib/firebird/system/security2.fdb>> > > Is this a distro specific install or the more generic Firebird one from > SourceForge? > I ask, because on MacOS the default security is the following > -rw-r--r-- 1 pbeach staff 729088 Feb 15 16:54 security2.fdb > And on install I do not make any effort to change it. > > Regards > Paul Beach > Tel (France): +33 (0) 2 47 58 30 43 <+33%202%2047%2058%2030%2043> > Mob (France): +33 (0) 6 79 24 32 32 <+33%206%2079%2024%2032%2032> > >
Re: [firebird-support] permissions nbackup
if I do nbackup . it fails, telling me I cannot access the security2.fdb (as a normal user) I would have expected the file to have group rw enabled so that permitted users can be a member of group firebird to do this On 14 August 2017 at 16:16, Tomasz Tyrakowski t.tyrakow...@sol-system.pl [firebird-support] wrote: > > > On 14.08.2017 at 15:51, Nick Upson n...@telensa.com [firebird-support] > wrote: > > I'm looking at using nbackup but the file permissions on security2.fdb > mean > > only firebird or root can do so, is that the way it is supposed to be? > > Definitely. You wouldn't like any third party to access the password / > security database directly, would you? > On the other hand, in what way does it stop you from using nbackup? I > suppose what you actually need to do is to backup / restore a normal > database, not the system-wide security db. > > regards > Tomasz > >
[firebird-support] permissions nbackup
Hi I'm looking at using nbackup but the file permissions on security2.fdb mean only firebird or root can do so, is that the way it is supposed to be? *# ls -lart /var/lib/firebird/system/security2.fdb* *-rw--- 1 firebird firebird 1171456 Aug 14 14:25 /var/lib/firebird/system/security2.fdb*
[firebird-support] NODELAY
Hi I noticed this (below) on a recent thread * tweaking xinetd (flags = REUSE NODELAY) I have a mainly real-time system with db response problems, does anyone have experience of using NODELAY,
Re: [firebird-support] dropping the connection
I remember killing connection via delete from mon$statements with firebird 2.0 or 2.1. Could the fact that it doesn't work for me now be down to upgrading the client install to 2.5? On 22 February 2017 at 09:44, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > > > On 2017-02-21 17:32, Nick Upson n...@telensa.com [firebird-support] wrote: > > Hi > > > > The problem I'm trying to solve is users leaving inactive db_workbench > > sessions attached to a database while other work is going on by other > > processes, causing a large OIT gap and the consequent problems. The > > solution needs to be automatic and unattended. > > > > db_workbench doesn't have a timeout setting (I asked) > > > > deleting the row from mon$statements doesn't kill the transaction; > > deleting the row from mon$transactions or mon$attachments gives > > "operation not supported" > > > > I could automate a kill of the fb_inetserver process but I would > > rather something with less risk > > > > I figure other people have had this and solved it before, I hope. > > > > currently using firebird 2.1 on centos, shortly moving to 2.5 > > 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!). > > Mark > > >
[firebird-support] dropping the connection
Hi The problem I'm trying to solve is users leaving inactive db_workbench sessions attached to a database while other work is going on by other processes, causing a large OIT gap and the consequent problems. The solution needs to be automatic and unattended. db_workbench doesn't have a timeout setting (I asked) deleting the row from mon$statements doesn't kill the transaction; deleting the row from mon$transactions or mon$attachments gives "operation not supported" I could automate a kill of the fb_inetserver process but I would rather something with less risk I figure other people have had this and solved it before, I hope. currently using firebird 2.1 on centos, shortly moving to 2.5
Re: [firebird-support] gbak error
On 31 August 2016 at 18:16, Steve Wiser st...@specializedbusinesssoftware.com [firebird-support] < firebird-support@yahoogroups.com> wrote: > Can you show us the permissions of the directory that you are trying to > write to? And also of the database file that you are trying to back up? > the directory is 777 and the database is 550 owned by firebird, group unb > > And is there an existing fbk that you are trying to overwrite or is it a > new file? > new file > > And what user and group are you using to perform the gbak along with the > flags. > user and group are called unb, the firebird user is also a member of group unb, gbak -backup -user sysdba -password x filename > > Does anything show up in dmesg that would indicate some kind of I/O error > or hard disk starting to go bad? > no, and its a VM This was all working and then it didn't, no changes detected anywhere Nick Upson, Principal Operations Engineer, Telensa Ltd. Direct +44 (0) 1799 533252, Support Hotline +44 (0) 1799 399200
Re: [firebird-support] gbak error
its possible that the file is created and removed quickly enough that I don't see it Nick Upson, Principal Operations Engineer, Telensa Ltd. Direct +44 (0) 1799 533252, Support Hotline +44 (0) 1799 399200 On 31 August 2016 at 17:38, 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support] wrote: > > > Nick, > > > it either happens on creation or a file is started and then removed very > > quickly > > "then removed very quickly"??? > > Please elaborate. > > > Sean > > >
Re: [firebird-support] gbak error
it either happens on creation or a file is started and then removed very quickly Nick Upson, Principal Operations Engineer, Telensa Ltd. Direct +44 (0) 1799 533252, Support Hotline +44 (0) 1799 399200 On 31 August 2016 at 16:57, Ann Harrison aharri...@ibphoenix.com [firebird-support] wrote: > > > Does the error happen on file creation or after some data has been written? > > > > On Aug 30, 2016, at 4:36 PM, Nick Upson n...@telensa.com [firebird-support] > wrote: > > no, not a file name collision and plenty of disk space > > this just started happening, no change to installed s/w > > Nick Upson, > Principal Operations Engineer, Telensa Ltd. > Direct +44 (0) 1799 533252, Support Hotline +44 (0) 1799 399200 > > On 30 August 2016 at 21:14, Helen Borrie hele...@iinet.net.au > [firebird-support] wrote: > >> >> >> Hello Nick, >> >> > I'm running fb2.1 on centos5, recently a system has started >> > throwing this error when asked to do a backup, the gbak parameters >> > are unchanged, permissions all seem ok, any suggestions what I might >> check >> >> > gbak: ERROR:Unexpected I/O error while writing to backup file >> > gbak:Exiting before completion due to errors >> >> "gbak parameters are unchanged." Could be you already have a file in >> that location with the same name. >> >> HB >> >> > >
Re: [firebird-support] gbak error
no, not a file name collision and plenty of disk space this just started happening, no change to installed s/w Nick Upson, Principal Operations Engineer, Telensa Ltd. Direct +44 (0) 1799 533252, Support Hotline +44 (0) 1799 399200 On 30 August 2016 at 21:14, Helen Borrie hele...@iinet.net.au [firebird-support] wrote: > > > Hello Nick, > > > I'm running fb2.1 on centos5, recently a system has started > > throwing this error when asked to do a backup, the gbak parameters > > are unchanged, permissions all seem ok, any suggestions what I might > check > > > gbak: ERROR:Unexpected I/O error while writing to backup file > > gbak:Exiting before completion due to errors > > "gbak parameters are unchanged." Could be you already have a file in > that location with the same name. > > HB > > >
Re: [firebird-support] gbak error
it all seems ok, files have been created in other ways Nick Upson, Principal Operations Engineer, Telensa Ltd. Direct +44 (0) 1799 533252, Support Hotline +44 (0) 1799 399200 On 30 August 2016 at 19:26, 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support] wrote: > > > > > > I'm running fb2.1 on centos5, recently a system has started throwing > this > > error when asked to do a backup, the gbak parameters are unchanged, > > permissions all seem ok, any suggestions what I might check > > > > gbak: ERROR:Unexpected I/O error while writing to backup file > > gbak:Exiting before completion due to errors > > Check integrity of storage subsystem. > > > Sean > > >
[firebird-support] gbak error
Hi I'm running fb2.1 on centos5, recently a system has started throwing this error when asked to do a backup, the gbak parameters are unchanged, permissions all seem ok, any suggestions what I might check gbak: ERROR:Unexpected I/O error while writing to backup file gbak:Exiting before completion due to errors Nick Upson, Principal Operations Engineer, Telensa Ltd. Direct +44 (0) 1799 533252, Support Hotline +44 (0) 1799 399200
Re: [firebird-support] When do triggers take effect?
you need to commit the trigger creation / modification & then have any other relevant transaction commit Nick Upson, Principal Operations Engineer, Telensa Ltd. Direct +44 (0) 1799 533252, Support Hotline +44 (0) 1799 399200 On 6 June 2016 at 15:59, Tim Ward t...@telensa.com [firebird-support] < 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 DBWB the trigger behaved as expected. > > Do triggers not take effect on existing connections, or something? > > -- > Tim Ward > > >
Re: [firebird-support] Delete global temporary table
your database is corrupt, start here
http://www.firebirdsql.org/manual/gfix-dbverify.html
Nick Upson,
Principle Operations Engineer, Telensa Ltd.
Direct +44 (0) 1799 533252, Support Hotline +44 (0) 1799 399200
On 3 April 2016 at 11:03, michael.vilhelm...@microcom.dk [firebird-support]
wrote:
>
>
> Hi
>
> I have a routine in my program, where I create af user specific global
> temporary table.
> Below you can see, how its created.
>
> At some point last monday, a user had a program breakdown, which har left
> the database in a state, where I cannot make a backup, cannot access one of
> the global temporary tables.
>
> Backup fails with this:
>
> gbak: ERROR:database file appears corrupt (E:\DB\NYFORM\OCCEASYPOS.FDB)
> gbak: ERROR:wrong page type
> gbak: ERROR:page 15344590 is of wrong type (expected 6, found 7)
> gbak: ERROR:gds_$compile_request failed
> gbak:Exiting before completion due to errors
>
>
>
> Accessing the table, results in this:
>
> database file appears corrupt (E:\DATA\NYFORM\OCCEASYPOS.FDB)
> wrong page type
> page 15344590 is of wrong type (expected 6, found 7)
>
> Same error, if I want to drop the table..
>
>
> How do I get around this error?
> I would like to drop the table.
>
>
> Its Firebird 2.5. Classic. But copying the database to my local machine
> results in the same (Firebird 2.5 superserver).
>
> Regards Michael
>
>
> This is how I create the table:
> DMTransaktionSalg.OmsStatTempTabele.Script.Add('create global
> temporary table OmsStat2'+Afdelingsnummer+Underafdelingsnummer+'(');
> DMTransaktionSalg.OmsStatTempTabele.Script.Add(' ID int not null
> primary key,');
> DMTransaktionSalg.OmsStatTempTabele.Script.Add(' Afdeling_ID
> Varchar(30),');
> DMTransaktionSalg.OmsStatTempTabele.Script.Add(' UAfd_Navn
> Varchar(30),');
> DMTransaktionSalg.OmsStatTempTabele.Script.Add(' Felt1 Varchar(30),');
> DMTransaktionSalg.OmsStatTempTabele.Script.Add(' Felt2 Varchar(30),');
> DMTransaktionSalg.OmsStatTempTabele.Script.Add(' Felt3 Varchar(30),');
> DMTransaktionSalg.OmsStatTempTabele.Script.Add(' Felt4 Varchar(30),');
> DMTransaktionSalg.OmsStatTempTabele.Script.Add(' Felt5 Varchar(30),');
> DMTransaktionSalg.OmsStatTempTabele.Script.Add(' Felt6 Varchar(30),');
> DMTransaktionSalg.OmsStatTempTabele.Script.Add(' PeriodeStk1 Float
> Default 0,');
> DMTransaktionSalg.OmsStatTempTabele.Script.Add(' PeriodeDG1 Float
> Default 0,');
> DMTransaktionSalg.OmsStatTempTabele.Script.Add(' PeriodeSpr1 Float
> Default 0,');
> DMTransaktionSalg.OmsStatTempTabele.Script.Add(' PeriodeDB1 Float
> Default 0,');
> DMTransaktionSalg.OmsStatTempTabele.Script.Add(' PeriodeKpr1 Float
> Default 0,');
> DMTransaktionSalg.OmsStatTempTabele.Script.Add(' PeriodeMoms1 Float
> Default 0,');
> DMTransaktionSalg.OmsStatTempTabele.Script.Add(' PeriodeStk2 Float
> Default 0,');
> DMTransaktionSalg.OmsStatTempTabele.Script.Add(' PeriodeDG2 Float
> Default 0,');
> DMTransaktionSalg.OmsStatTempTabele.Script.Add(' PeriodeSpr2 Float
> Default 0,');
> DMTransaktionSalg.OmsStatTempTabele.Script.Add(' PeriodeDB2 Float
> Default 0,');
> DMTransaktionSalg.OmsStatTempTabele.Script.Add(' PeriodeKpr2 Float
> Default 0,');
> DMTransaktionSalg.OmsStatTempTabele.Script.Add(' PeriodeMoms2 Float
> Default 0,');
> DMTransaktionSalg.OmsStatTempTabele.Script.Add(' PeriodeStk3 Float
> Default 0,');
> DMTransaktionSalg.OmsStatTempTabele.Script.Add(' PeriodeDG3 Float
> Default 0,');
> DMTransaktionSalg.OmsStatTempTabele.Script.Add(' PeriodeSpr3 Float
> Default 0,');
> DMTransaktionSalg.OmsStatTempTabele.Script.Add(' PeriodeDB3 Float
> Default 0,');
> DMTransaktionSalg.OmsStatTempTabele.Script.Add(' PeriodeKpr3 Float
> Default 0,');
> DMTransaktionSalg.OmsStatTempTabele.Script.Add(' PeriodeMoms3 Float
> Default 0,');
> DMTransaktionSalg.OmsStatTempTabele.Script.Add(' Oprettet Date
> Default ''NOW'',');
> DMTransaktionSalg.OmsStatTempTabele.Script.Add(' SidsteBruger
> Varchar(40) Default Current_USer Collate None');
> DMTransaktionSalg.OmsStatTempTabele.Script.Add(' )');
> DMTransaktionSalg.OmsStatTempTabele.Script.Add(' On Commit preserve
> rows;');
>
>
>
>
Re: [firebird-support] 2 servers acessing one database
On 16 December 2015 at 15:19, Rudi Feijó rudi.fe...@multidadosti.com.br [firebird-support] wrote: > Thanks for the reply Karol > > What I mean is using 2 servers to connect to the same DB. > This DB is in a shared disk that both servers can access. > So I would have, for example, 100 clients connecting on server 1, another > 100 clients on server 2, but both accessing the same shared database > you can have all those clients accessing the database, but not in that way. The database should NOT be on a shared drive, all access goes through the firebird server process on the machine that owns the disk containing the database. You can force the setup to be as you describe but you will rapidly get a corrupt database Nick Upson, Telensa Ltd, Senior Operations Network Engineer direct +44 (0) 1799 533252, support hotline +44 (0) 1799 399200
Re: [firebird-support] Another ordering question?
without a "where" clause firebird has to read the entire table (to determine if each row is valid for the current transaction) and sort the results Nick Upson, Telensa Ltd, Senior Operations Network Engineer direct +44 (0) 1799 533252, support hotline +44 (0) 1799 399200 On 9 September 2015 at 13:00, Tim Ward t...@telensa.com [firebird-support] < firebird-support@yahoogroups.com> wrote: > > > SELECT FIRST 1 FROM MYTAB ORDER BY MYKEY1, MYKEY2; > > PLAN (MYTAB ORDER PK_MYTAB) > > Current memory = 3437420 > Delta memory = 152 > Max memory = 3586952 > Elapsed time= 0.04 sec > Buffers = 150 > Reads = 232 > Writes 0 > Fetches = 132082 > > There may be several thousand records in the table, but the primary key > is defined as (MYKEY1, MYKEY2) and the plan says it's using it, so why > the 232 disk reads? - one might have guessed 2 would be enough, one for > the index and one for the record. (The key fields are both 32 bit > integers. Yes, I do have plans to replace them by a generator-generated > key, but I can't see why that would make a difference to this particular > performance issue.) > > This table is being used as a FIFO queue. Would the most likely > explanation be lack of garbage collection, so it's having to scan lots > of deleted records before finding the first real one, or are there other > possibilities? I must say that > > Oldest transaction 390433636 > Oldest active 390433637 > Oldest snapshot 390433637 > Next transaction 391092651 > > doesn't look too encouraging, so I'd better investigate that. > > -- > Tim Ward > > >
Re: [firebird-support] 2.5 architecture
On 28 August 2015 at 14:43, Thomas Steinmaurer t...@iblogmanager.com [firebird-support] wrote: > > http://www.firebirdsql.org/file/fb25_architecture_comparison.pdf > > IMHO, this one clearly states that there are 3 architectures in 2.5 > available. superserver & classic not applicable, embedded is sc, and sc itself => 1 Nick Upson, Telensa Ltd, Senior Operations Network Engineer direct +44 (0) 1799 533252, support hotline +44 (0) 1799 399200
[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 http://www.firebirdsql.org/manual/qsg25-classic-or-super.html Nick Upson, Telensa Ltd, Senior Operations Network Engineer direct +44 (0) 1799 533252, support hotline +44 (0) 1799 399200
Re: [firebird-support] Regarding ODBC
you need to install the firebird client on the PC Nick Upson, Telensa Ltd, Senior Operations Network Engineer direct +44 (0) 1799 533252, support hotline +44 (0) 1799 399200 On 21 August 2015 at 15:14, 'Raman, Anitha' anitha.ra...@am.jll.com [firebird-support] wrote: > > > Thank you. > > *Error Message is : * > > ‘Failed to load PowerMart DLL fbclientM.dll to support this database. > Contact Tech Support.’ > > > > *Anitha Raman* > > Global Data Integration Lead > > anitha.ra...@am.jll.com > > > > *From:* firebird-support@yahoogroups.com [mailto: > firebird-support@yahoogroups.com] > *Sent:* Friday, August 21, 2015 12:56 AM > *To:* firebird-support@yahoogroups.com > *Subject:* Re: [firebird-support] Regarding ODBC > > > > > > The mailinglist doesn't support attachments, please post the error message > as text. > > > > Mark > > > > > > - Reply message - > Van: "'Raman, Anitha' anitha.ra...@am.jll.com [firebird-support]" < > firebird-support@yahoogroups.com> > Aan: > Onderwerp: [firebird-support] Regarding ODBC > Datum: do, aug. 20, 2015 23:19 > > > > Hello group - I have installed Firebird and trying to import structures using > an ETL Application called Informatica PowerCenter. ODBC connection seems to > be valid as I am able to connect using EXCEL and select from the tables. But > when I try using my application to import structures I get the following > error. > > > > > > Does anyone have experience configuring Firebird ODBC for Informatica? > > > > > > Thank you! > > > > > > [cid:image001.png@01D0DB64.0D85CEF0] > > > > > > Anitha Raman > > Global Data Integration Lead > > anitha.ra...@am.jll.com<mailto:anitha.ra...@am.jll.com> > > > > > > > > > > > > > > This email is for the use of the intended recipient(s) only. If you have > received this email in error, please notify the sender immediately and then > delete it. If you are not the intended recipient, you must not keep, use, > disclose, copy or distribute this email without the author's prior > permission. We have taken precautions to minimize the risk of transmitting > software viruses, but we advise you to carry out your own virus checks on any > attachment to this message. We cannot accept liability for any loss or damage > caused by software viruses. The information contained in this communication > may be confidential and may be subject to the attorney-client privilege. If > you are the intended recipient and you do not wish to receive similar > electronic messages from us in the future then please respond to the sender > to this effect. > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > Posted by: "Raman, Anitha" > > > > > > ++ > > > > Visit http://www.firebirdsql.org and click the Documentation item > > on the main (top) menu. Try FAQ and other links from the left-side menu > there. > > > > Also search the knowledgebases at > http://www.ibphoenix.com/resources/documents/ > > > > ++ > > > > > > Yahoo Groups Links > > > > http://groups.yahoo.com/group/firebird-support/ > > > > Individual Email | Traditional > > > > http://groups.yahoo.com/group/firebird-support/join > > (Yahoo! ID required) > > > > firebird-support-dig...@yahoogroups.com > > firebird-support-fullfeatu...@yahoogroups.com > > > > firebird-support-unsubscr...@yahoogroups.com > > > > https://info.yahoo.com/legal/us/yahoo/utos/terms/ > > > > >
[firebird-support] firebird & nessus
Hi firebird 2.1 centos, I have systems in a company who are scanning with nessus and this causes the firebird log below. Although they do not have access to the database I'm concerned what is happening. Has anyone seen this before? Can I avoid it? gaxgpap345vuSun Jul 12 17:27:11 2015 INET/inet_error: read errno = 104 gaxgpap345vuSun Jul 12 17:27:14 2015 *** DUMP *** gaxgpap345vuSun Jul 12 17:27:14 2015 Tag=-1 Offset=13 Length=26 Eof=0 gaxgpap345vuSun Jul 12 17:27:14 2015 Clump 1 at offset 0: SCAN CHECK<04> gaxgpap345vuSun Jul 12 17:27:14 2015 Fatal exception during clumplet dump: Invalid clumplet buffer structure: buffer end before end of clumplet - clumplet too long gaxgpap345vuSun Jul 12 17:27:14 2015 Plain dump starting with offset 13: <0a>nessusscan<06><00> Nick Upson, Telensa Ltd, Senior Operations Network Engineer direct +44 (0) 1799 533252, support hotline +44 (0) 1799 399200
Re: [firebird-support] Issues migrating from FB 1.5 to 2.5
Hi I believe its due to tighter syntax checking in 2 over 1.5 Nick Upson, Telensa Ltd, Senior Operations Network Engineer direct +44 (0) 1799 533252, support hotline +44 (0) 1799 399200 On 22 June 2015 at 16:25, srotyli...@gmail.com [firebird-support] < firebird-support@yahoogroups.com> wrote: > > > I have an app that's been working fine for years on an XP box with FB 1.5. > I upgraded to a newer box with Win 7 and installed FB 2.5. The app works > great for about 95% but I get the following error under certain conditions: > > > Application Error > > General SQL Error > > Column XXX.YYY cannot be repeated in INSERT statement. > > At line 6 column 78 > > > Is this due to a change in the way strings or INSERTs are handled ? Are > there any solutions (I do not have access to the application source). > > > Thanks in advance for any advice. > > >
[firebird-support] firebird.log contents
Hi this is from firebird 2.1.5, centos 5. I've never seen these messages before, anyone? myserverSun May 10 20:30:18 2015 INET/inet_error: read errno = 104 myserverSun May 10 20:30:23 2015 SERVER/process_packet: connection rejected for nessus.-1.-1 myserverSun May 10 20:30:23 2015 SERVER/process_packet: connect reject, server exiting myserverSun May 10 20:30:29 2015 INET/inet_error: read errno = 104 myserverSun May 10 20:30:50 2015 *** DUMP *** myserverSun May 10 20:30:50 2015 Tag=-1 Offset=13 Length=26 Eof=0 Nick Upson, Telensa Ltd, Senior Operations Network Engineer direct +44 (0) 1799 533252, support hotline +44 (0) 1799 399200
Re: [firebird-support] large system slows over time
Hi Steve no not AWS We've done tests and the disk does not appear to be under load, maybe we are just not seeing it Nick Upson, Telensa Ltd, Senior Operations Network Engineer direct +44 (0) 1799 533252, support hotline +44 (0) 1799 399200 On 8 May 2015 at 16:25, Steve Wiser st...@specializedbusinesssoftware.com [firebird-support] wrote: > > > Hi Nick, > > Oops, I noticed on my first email that I said "now out of memory" when I > should have said "not out of memory".. > > Are you by chance using Amazon Web Services? If so I would say maybe your > EBS volume was not prewarmed. > > Either way, it does sound to me that your CPU is waiting for the disk to > send data over, usually because the shared disk is under load. > > -steve > > > -- > Steve Wiser > President > Specialized Business Software > 6325 Cochran Road, Unit 1 > Solon, OH 44139 > > www.specializedbusinesssoftware.com > www.docunym.com > (440) 542-9145 - fax (440) 542-9143 > Toll Free: (866) 328-4936 > > > On Fri, May 8, 2015 at 10:26 AM, Nick Upson n...@telensa.com > [firebird-support] wrote: > >> >> >> Hi Steve >> >> there is a significant time in iowait and this is a VM, so a disk >> contention issue at the hyper-visor level ? >> >> Nick Upson, Telensa Ltd, Senior Operations Network Engineer >> direct +44 (0) 1799 533252, support hotline +44 (0) 1799 399200 >> >> On 8 May 2015 at 14:55, Steve Wiser st...@specializedbusinesssoftware.com >> [firebird-support] wrote: >> >>> >>> >>> Hi Nick, >>> >>> My interpretation of those stats is that you are now out of memory as I >>> always look at the Swap Used. You aren't using any. My experience with >>> Linux is that the OS will take as much memory as it can/needs so it can >>> look like you are maxed out on RAM usage or something, but you really need >>> to pay attention to the swap used. >>> >>> What I would be interested in seeing is that when you run your gbak >>> backup go ahead and also run top. Are you seeing a lot of CPU time being >>> spent in IOWait? If so that would mean that the CPU is being starved of >>> data and is waiting around -- usually because the disk isn't fast enough. >>> We normally only see this on virtual hosts though. >>> >>> -steve >>> >>> >>> -- >>> Steve Wiser >>> President >>> Specialized Business Software >>> 6325 Cochran Road, Unit 1 >>> Solon, OH 44139 >>> >>> www.specializedbusinesssoftware.com >>> www.docunym.com >>> (440) 542-9145 - fax (440) 542-9143 >>> Toll Free: (866) 328-4936 >>> >>> >>> On Fri, May 8, 2015 at 6:32 AM, Nick Upson n...@telensa.com >>> [firebird-support] wrote: >>> >>>> >>>> >>>> Your mention of memory & paging got me thinking. I expected the output >>>> below to show the memory was fully used such that more RAM would help >>>> but unless I'm reading this wrong only 5.3Gb is being used and 2.4 GB >>>> is unused so more RAM will be no help, can anyone confirm or put me right >>>> >>>> $ cat /proc/meminfo >>>> MemTotal: 8309036 kB >>>> MemFree:307408 kB >>>> Buffers: 59296 kB >>>> Cached:7433812 kB >>>> SwapCached: 32 kB >>>> Active:5365212 kB >>>> Inactive: 2470416 kB >>>> HighTotal: 7471040 kB >>>> HighFree:18724 kB >>>> LowTotal: 837996 kB >>>> LowFree:288684 kB >>>> SwapTotal: 4095992 kB >>>> SwapFree: 4095788 kB >>>> Dirty: 186968 kB >>>> Writeback: 0 kB >>>> AnonPages: 342384 kB >>>> Mapped: 140812 kB >>>> Slab: 148064 kB >>>> PageTables: 6824 kB >>>> NFS_Unstable:0 kB >>>> Bounce: 0 kB >>>> CommitLimit: 8250508 kB >>>> Committed_AS: 2795520 kB >>>> VmallocTotal: 116728 kB >>>> VmallocUsed: 5788 kB >>>> VmallocChunk: 110588 kB >>>> HugePages_Total: 0 >>>> HugePages_Free: 0 >>>> HugePages_Rsvd: 0 >>>> Hugepagesize: 2048 kB >>>> >>>> >>>> Nick Upson, Telensa Ltd, Senior Operations Network Engineer >>>> direct +44 (0) 1799 533252, suppo
Re: [firebird-support] large system slows over time
Hi Steve there is a significant time in iowait and this is a VM, so a disk contention issue at the hyper-visor level ? Nick Upson, Telensa Ltd, Senior Operations Network Engineer direct +44 (0) 1799 533252, support hotline +44 (0) 1799 399200 On 8 May 2015 at 14:55, Steve Wiser st...@specializedbusinesssoftware.com [firebird-support] wrote: > > > Hi Nick, > > My interpretation of those stats is that you are now out of memory as I > always look at the Swap Used. You aren't using any. My experience with > Linux is that the OS will take as much memory as it can/needs so it can > look like you are maxed out on RAM usage or something, but you really need > to pay attention to the swap used. > > What I would be interested in seeing is that when you run your gbak backup > go ahead and also run top. Are you seeing a lot of CPU time being spent in > IOWait? If so that would mean that the CPU is being starved of data and is > waiting around -- usually because the disk isn't fast enough. We normally > only see this on virtual hosts though. > > -steve > > > -- > Steve Wiser > President > Specialized Business Software > 6325 Cochran Road, Unit 1 > Solon, OH 44139 > > www.specializedbusinesssoftware.com > www.docunym.com > (440) 542-9145 - fax (440) 542-9143 > Toll Free: (866) 328-4936 > > > On Fri, May 8, 2015 at 6:32 AM, Nick Upson n...@telensa.com > [firebird-support] wrote: > >> >> >> Your mention of memory & paging got me thinking. I expected the output >> below to show the memory was fully used such that more RAM would help >> but unless I'm reading this wrong only 5.3Gb is being used and 2.4 GB is >> unused so more RAM will be no help, can anyone confirm or put me right >> >> $ cat /proc/meminfo >> MemTotal: 8309036 kB >> MemFree:307408 kB >> Buffers: 59296 kB >> Cached:7433812 kB >> SwapCached: 32 kB >> Active:5365212 kB >> Inactive: 2470416 kB >> HighTotal: 7471040 kB >> HighFree:18724 kB >> LowTotal: 837996 kB >> LowFree:288684 kB >> SwapTotal: 4095992 kB >> SwapFree: 4095788 kB >> Dirty: 186968 kB >> Writeback: 0 kB >> AnonPages: 342384 kB >> Mapped: 140812 kB >> Slab: 148064 kB >> PageTables: 6824 kB >> NFS_Unstable:0 kB >> Bounce: 0 kB >> CommitLimit: 8250508 kB >> Committed_AS: 2795520 kB >> VmallocTotal: 116728 kB >> VmallocUsed: 5788 kB >> VmallocChunk: 110588 kB >> HugePages_Total: 0 >> HugePages_Free: 0 >> HugePages_Rsvd: 0 >> Hugepagesize: 2048 kB >> >> >> Nick Upson, Telensa Ltd, Senior Operations Network Engineer >> direct +44 (0) 1799 533252, support hotline +44 (0) 1799 399200 >> >> On 5 May 2015 at 15:21, Ann Harrison aharri...@ibphoenix.com >> [firebird-support] wrote: >> >>> >>> >>> Hi Nick, >>> >>> >>> I have a system that is slowing down the longer it stays running and I'd >>> like to know why. >>> >>> ... >>> >>> >>> Is there any evidence I can gather before I reboot the system which I >>> expect (from past experience) will return the system to the better >>> performance >>> >>> >>> Hmmm If rebooting will solve the problem and you don't have a very >>> long running transaction, then I doubt that garbage accumulation or >>> collection is the source of the problem. >>> Nor is there anything else wrong with your physical database - >>> fragmentation or whatever. >>> I'd look at memory usage - using both Firebird and OS tools. Look for >>> paging before you reboot. >>> After you reboot, track memory usage daily or more often. It doesn't >>> take much of a leak - or unfortunate caching - to built up over month of 27 >>> tps. >>> >>> Accelerating the move to 2.5.4 would also be a good idea, both because >>> it may correct the problem and because it probably offers better diagnostic >>> tools for this sort of problem. >>> >>> Good luck, >>> >>> Ann >>> >>> >> > >
Re: [firebird-support] large system slows over time
Your mention of memory & paging got me thinking. I expected the output below to show the memory was fully used such that more RAM would help but unless I'm reading this wrong only 5.3Gb is being used and 2.4 GB is unused so more RAM will be no help, can anyone confirm or put me right $ cat /proc/meminfo MemTotal: 8309036 kB MemFree:307408 kB Buffers: 59296 kB Cached:7433812 kB SwapCached: 32 kB Active:5365212 kB Inactive: 2470416 kB HighTotal: 7471040 kB HighFree:18724 kB LowTotal: 837996 kB LowFree:288684 kB SwapTotal: 4095992 kB SwapFree: 4095788 kB Dirty: 186968 kB Writeback: 0 kB AnonPages: 342384 kB Mapped: 140812 kB Slab: 148064 kB PageTables: 6824 kB NFS_Unstable:0 kB Bounce: 0 kB CommitLimit: 8250508 kB Committed_AS: 2795520 kB VmallocTotal: 116728 kB VmallocUsed: 5788 kB VmallocChunk: 110588 kB HugePages_Total: 0 HugePages_Free: 0 HugePages_Rsvd: 0 Hugepagesize: 2048 kB Nick Upson, Telensa Ltd, Senior Operations Network Engineer direct +44 (0) 1799 533252, support hotline +44 (0) 1799 399200 On 5 May 2015 at 15:21, Ann Harrison aharri...@ibphoenix.com [firebird-support] wrote: > > > Hi Nick, > > > I have a system that is slowing down the longer it stays running and I'd > like to know why. > > ... > > > Is there any evidence I can gather before I reboot the system which I > expect (from past experience) will return the system to the better > performance > > > Hmmm If rebooting will solve the problem and you don't have a very > long running transaction, then I doubt that garbage accumulation or > collection is the source of the problem. > Nor is there anything else wrong with your physical database - > fragmentation or whatever. > I'd look at memory usage - using both Firebird and OS tools. Look for > paging before you reboot. > After you reboot, track memory usage daily or more often. It doesn't > take much of a leak - or unfortunate caching - to built up over month of 27 > tps. > > Accelerating the move to 2.5.4 would also be a good idea, both because it > may correct the problem and because it probably offers better diagnostic > tools for this sort of problem. > > Good luck, > > Ann > > >
Re: [firebird-support] large system slows over time
On 5 May 2015 at 12:23, Fabiano Kureck - Desenvolvimento SCI fabi...@sci10.com.br [firebird-support] wrote: > In my experience, GC collected by the gbak is different from sweep. > I also have a problem with only my big customer (35Gb database) when the > system become slow and slow over time. The solution was do a gbak with > Garbage collect and then a sweep after. > > First time you do this it will take probably a couple of hours. Sweep > moves the transaction counter, gbak no (at least no in every situation). > For testing purpose you can run a sweep now and the backup will take a lot > less time this night. Give a try. > I already do a sweep weekly, I also tried gbak -gc followed by a sweep the total time was even longer Nick Upson, Telensa Ltd, Senior Operations Network Engineer direct +44 (0) 1799 533252, support hotline +44 (0) 1799 399200
Re: [firebird-support] large system slows over time
On 5 May 2015 at 12:12, 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support] wrote: > How does your backup call look like? gbak, -user sysdba -pass x -backup hostname:/opt/pathtodb /pathto/backuparea Nick Upson, Telensa Ltd, Senior Operations Network Engineer direct +44 (0) 1799 533252, support hotline +44 (0) 1799 399200
Re: [firebird-support] large system slows over time
On 5 May 2015 at 12:09, Fabiano Kureck - Desenvolvimento SCI fabi...@sci10.com.br [firebird-support] wrote: > Did you run a Sweep before backup? no but then the backup does gc, I'm interested in why the suggestion, I can try it Nick Upson, Telensa Ltd, Senior Operations Network Engineer direct +44 (0) 1799 533252, support hotline +44 (0) 1799 399200
Re: [firebird-support] large system slows over time
yes, large transaction gap was the first thing I checked Nick Upson, Telensa Ltd, Senior Operations Network Engineer direct +44 (0) 1799 533252, support hotline +44 (0) 1799 399200 On 5 May 2015 at 12:01, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > > > On 5-5-2015 12:15, Nick Upson n...@telensa.com [firebird-support] wrote: > > 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 from the db as fast as its > > added so the database remains roughly the same size at 130Gb. > > > > for example: on 1st Feb the backup took 4 hr 35 min, last night took > > 9hrs 30 min > > > > Is this a known 2.1 issue (move to 2.5 is in the planning stages)? > > > > Is there anything I can do to prevent or improve this situation? > > > > Is there any evidence I can gather before I reboot the system which I > > expect (from past experience) will return the system to the better > > performance > > Have you checked for the existence of long running transactions (a high > transaction gap)? > > Mark > -- > Mark Rotteveel > >
[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 from the db as fast as its added so the database remains roughly the same size at 130Gb. for example: on 1st Feb the backup took 4hr 35 min, last night took 9hrs 30 min Is this a known 2.1 issue (move to 2.5 is in the planning stages)? Is there anything I can do to prevent or improve this situation? Is there any evidence I can gather before I reboot the system which I expect (from past experience) will return the system to the better performance Nick Upson, Telensa Ltd, Senior Operations Network Engineer direct +44 (0) 1799 533252, support hotline +44 (0) 1799 399200
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 garbage. As well as handling it better I'm trying to see if we can cause less of it Nick Upson, Telensa Ltd, Senior Operations Network Engineer direct +44 (0) 1799 533252, support hotline +44 (0) 1799 399200 On 5 April 2015 at 18:07, Ann Harrison aharri...@ibphoenix.com [firebird-support] wrote: > > > > On Apr 5, 2015, at 11:23 AM, Nick Upson n...@telensa.com [firebird-support] > wrote: > > > is there any effective difference between doing "gbak with gc" and > "gbak without gc" and then "gfix -sweep" > > > The only differences (that I can think of) are caused by concurrent > actions. If you garbage collect during backup, the sweep can remove new > garbage created while the backup ran. > > Imagine that garbage collection takes enough time for fine thousand > transactions to complete and each of those transactions makes three record > versions obsolete. Neither gbak nor sweep can remove record versions made > obsolete by the completion of a concurrent transaction. > > So if you backup without garbage collection, your backup is quicker, sweep > starts sooner and takes longer so those 15,000 old record versions continue > moldering in your database. > > If you backup with garbage collection and then sweep, the backup is > slower, but the sweep starts later and can remove those unlovable record > versions. Sort of a wash, rinse, repeat thing - if that phrase means > anything to those who aren't elderly > Americans. > > Cheers, > > > Ann > From sunny Sint Maarten. > > >
[firebird-support] garbage collect
Hi I'd like to do my backup without gc and then do the gc separately - is there any effective difference between doing "gbak with gc" and "gbak without gc" and then "gfix -sweep" Nick Upson, Telensa Ltd, Senior Operations Network Engineer direct +44 (0) 1799 533252, support hotline +44 (0) 1799 399200
Re: [firebird-support] Re: Is there still a difference between sweep and gabage collection?
so if I run gbak -g every night I should also run gfix, but if I run gbak without -g I don't need gfix (but it helps a little) ? Nick Upson, Telensa Ltd, Senior Operations Network Engineer direct +44 (0) 1799 533252, support hotline +44 (0) 1799 399200 On 20 February 2015 at 18:36, Ann Harrison aharri...@ibphoenix.com [firebird-support] wrote: > > > > Thomas, > > Gbak backup removes all unnecessary back versions and all rolled back > changes, unless it is run with the -g switch. That switch is provided for > those cases where a database cleanup is not needed. Examples include the > case when the database will immediately be replaced by a restored version, > upgrading the ODS, for example, or when a sweep has just been run. > > What gbak does not do that sweep does it change the identity of the oldest > interesting transaction. Unlike the oldest active transaction, the oldest > interesting transaction is not critical for performance, but having it > correct does make things slightly better. The oldest interesting > transaction is the first transaction, still visible in the database, that > did not commit. Any data created by older transactions is known to have > been created by committed transactions. A transaction reading it doesn't > have the check the state of the creating transaction. When accessing data > created by a more recent transaction, the reader must test a bit in a bit > vector to determine the state of the creating transaction. Pretty cheap. > > During a sweep, gfix notes the oldest transaction whose work it could not > clean up. At the end of the sweep, that becomes the oldest interesting > transaction. > > In the absence of the -g switch or the attachment parameter that > implements that switch, any process that reads all the data in a database > removes all unnecessary old or rolled back record versions, either itself > or through the proxy of the garbage collect thread. Only gfix changes the > recorded oldest interesting transaction. > > Cheers, > > Ann > > >
Re: [firebird-support] Three trailing spaces?
if you use isql or dbworkbench to do the same query, that will tell you if the problem is php or firebird Nick Upson, Telensa Ltd, Senior Operations Network Engineer direct +44 (0) 1799 533252, support hotline +44 (0) 1799 399200 On 12 December 2014 at 13:55, Tim Ward t...@telensa.com [firebird-support] < firebird-support@yahoogroups.com> wrote: > > > > I've got a column defined as > > MODACTION D_MODACTION , > > where the domain is defined as > > CREATE DOMAIN D_MODACTION AS > CHAR(1) CHARACTER SET ASCII > NOT NULL > CHECK (VALUE IN ( 'A', 'U', 'D', 'M', 'S' )) > COLLATE ASCII; > > I've got a record which appears to have 'A' in this field. > > But when I do a "SELECT * FROM ..." (from PHP using ibase_fetch_assoc) I > don't get the string > > 'A' > > I get the string > > 'A ' > > (three spaces after the A). Yes this may be a PHP question, but just in > case it isn't, any ideas? > > -- > Tim Ward > > >
Re: [firebird-support] Export data to CSV file from stored procedure?
you could define an external table with 1 field, construct a csv within the SP and write to the table Nick Upson, Telensa Ltd, Senior Operations Network Engineer direct +44 (0) 1799 533252, support hotline +44 (0) 1799 399200 On 20 August 2014 17:19, conver...@gmail.com [firebird-support] < firebird-support@yahoogroups.com> wrote: > > > Hi there, > > As subject, is it possible to export a query result set to an external csv > file from a Firebird stored procedure? I know this can be done with > IBExpert but we are looking for a pure firebird sql solution. We are using > Firebrd 2.5. > > > Any pointers on how to do this will be much appreciated. > > > Regards, > > > -Ed > > > >
Re: [firebird-support] Database Forensics
you will need to copy the database to your hard disk, you can't operate with a database on a read-only media unless the database is prepared for this (seems unlikely) Nick Upson, Telensa Ltd, Operations Network Engineer direct +44 (0) 1799 533252, support +44 (0) 1799 399200 On 10 July 2014 18:34, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > > > On 9-7-2014 21:34, 'Edward Mendez' emendez...@nc.rr.com > [firebird-support] wrote: > > I have a situation where I might have to open up a FIREBIRD Database > > file that I didn’t create or maintain. I probably will not know the > > exact version of FIREBIRD this file was used with. It can be anything > > from FIREBIRD 2.1.4 up to 2.5.2 > > > > The database file will be given to me on a read only external HD. It > > will be accessed from a windows 7 PC. Everything I will need must > > already be preinstalled on this PC before taking possession of this > > Database File. (i.e. this PC will not be connected to the internet in > > order to install new software.) I can have an installer reside on a > > folder for install if I need it. > > > One question I have was that if I install a FB 2.5.2 Server on this > > windows PC would I be able to open a Database that has been created > > using a 2.1.4 server? > > Yes, a Firebird 2.5 can open database from Firebird 2.1. Upgrading the > database by backup and restore is a best practice (it upgrades the ODS > so new features are available), but it is not strictly necessary. With > Firebird 3 this is going to change! > > > Are there any programs out there that can open up a Firebird DB locally > > without a server/embedded installed? > > At a minimum you will need a program that uses Firebird embedded. > > > My plan was to… > > > > 1)Keep a copy of the msi installers for Firebird server 2.1.4/5 & 2.52 > > somewhere on the Disk of this PC. > > That sounds like the wisest course of action. > > > 2)Install a copy of IBEXPERT free edition on the PC to view the > data/schema > > > > 3)Install FBExport & FBCopy in case I need to export the data into > > another format. > > > > Is there something I might have missed or something that will work > > better than what I plan to use. > > Can't think of anything else right now. > > However, the big question is: what is it you need to do with the > database? If the database is damaged and the needs to be repaired, then > Firebird will not be able to (correctly) read the file, and you'd sooner > need something like IBSurgeon FirstAID (assuming simple fixes with gfix > won't work). > > Mark > > -- > Mark Rotteveel > >
[firebird-support] Re: operating system directive semctl failed
oh, i forgot, firebird 2.1.5 on centos Nick Upson, Telensa Ltd, Operations Network Engineer +44 (0) 1799 533252 On 31 March 2014 12:09, Nick Upson wrote: > Hi, > > I'm getting this in the firebird log along with "Permission denied" but > the database I'm restoring is running ok (so > http://www.firebirdfaq.org/faq102/ doesn't apply ) > > any ideas? (this is a 120Gb database) so it takes a while > > > > > > Nick Upson, Telensa Ltd, Operations Network Engineer > +44 (0) 1799 533252 >
[firebird-support] operating system directive semctl failed
Hi, I'm getting this in the firebird log along with "Permission denied" but the database I'm restoring is running ok (so http://www.firebirdfaq.org/faq102/ doesn't apply ) any ideas? (this is a 120Gb database) so it takes a while Nick Upson, Telensa Ltd, Operations Network Engineer +44 (0) 1799 533252
Re: [firebird-support] Advice on the following problem
> ALL the windows 2000 machines can read and write etc to the database on the "master" terminal (This has been set to replace the back office PC for now so the client can at least use his system) this should be removed the firebird client on these machine will talk to the firebird server process running on the back office PC (you do have this installed and running?) On 3 September 2013 10:20, Andrew Gable wrote: > ** > > > HI all, > > I have a problem that I cannot figure out. > > I have 3 Windows 2000 machines and 1 Windows XP Pro machine > The XP Pro machine is in the back office and its job is to hold the > databases > > My Windows 2000 machines are front of house BUT they cannot access the XP > Database > > my Connection string is "backofficepc:c:/System Database/SysDatabase.FBD" > > And I keep getting the following error message > > open database "backofficepc:c:/System Database/SysDatabase.FBD" failed > > so does anyone have any advice as to how I can get the windows 2000 > machines > to see and Access the XP Databases > > I have the following set-up > > Same User name & Passwords on all machines (posuser) > > ALL the windows 2000 machines can read and write etc to the database on > the "master" terminal (This has been set to replace the back office PC for > now so the client can at least use his system) > > I look forward to the advice from all you experts > > [Non-text portions of this message have been removed] > > > -- Nick Upson, Telensa Ltd [Non-text portions of this message have been removed] ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[firebird-support] Fatal lock manager error: semaphores are exhausted, errno: 1
firebird 2.1.5 classic, yesterday, one of my systems suddenly produced this message 17 times in the same second. a) there seems very little about this online, can anyone shed some light on it b) should I do anything to avoid this in future c) current output below, is there anything I need to do # ipcs -s -- Semaphore Arrays keysemid owner perms nsems 0x 163840 apache6001 0x 294913 apache6001 0x 327682 apache6001 0x0f008084 98307 firebird 60032 0x0f008088 131076 firebird 6001 0x0f008089 262149 firebird 6001 -- Nick Upson, Telensa Ltd [Non-text portions of this message have been removed]
Re: [firebird-support] Re: Digest Number 8245
Hi,
becuase you cannot do xx=NULL, you would need xx is null
select count(*) from customer where ascii_val(substring(upper(fname) from 1
for 1 )) is NULL
I expect would work, or
select count(*) from customer where fname is NULL ;
On 1 August 2013 15:30, ASOrg wrote:
> **
>
>
> Hi Nick
>
> Thank you very much for your reply.
> It seems NULL is the answer, it has 9516 records.
>
> But why is
>
> select count(*) from customer where ascii_val(substring(upper(fname) from
> 1 for 1 ))=NULL ( returns 0 ) ?
>
> Best regards
> Andy
>
>
> --- In firebird-support@yahoogroups.com, Nick Upson wrote:
> >
> > how about
> >
> > select ascii_val(substring(upper(fname) from 1 for 1 )), count(*) from
> > customer group by 1
> >
> > to get a list of the first ascii value and the number of records that
> have
> > that value
> >
> >
> > On 1 August 2013 11:41, Andy Samuel wrote:
> >
> > > **
>
> > >
> > >
> > >
> > > Dear All
> > > select count(*) from customer ( returns 235384 )
> > >
> > > select count(*) from customer where substring(upper(fname) from 1 for
> 1 )
> > > in ('A','B','C',
> > >
> 'D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z')
> > > ( returns 187671 )
> > >
> > > so there are 47.713 records whose fname started with letter A-Z.
> > >
> > > select distinct ascii_val(substring(upper(fname) from 1 for 1 )) from
> > > customer where substring(upper(fname) from 1 for 1 ) not in
> > >
> ('A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z')
> > > ( returns 0, 13, 46 )
> > >
> > > select count(*) from customer where ascii_val(substring(upper(fname)
> from
> > > 1 for 1 )) in (0,13,46) ( returns 38197 )
> > >
> > > I don't know how to find the other 9516 records.
> > > Help please ?
> > >
> > > Thank you in advance
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > >
> > >
> >
> >
> >
> > --
> > Nick Upson, Telensa Ltd
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
--
Nick Upson, Telensa Ltd
[Non-text portions of this message have been removed]
++
Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !
Also search the knowledgebases at http://www.ibphoenix.com
++
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)
<*> To change settings via email:
firebird-support-dig...@yahoogroups.com
firebird-support-fullfeatu...@yahoogroups.com
<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
Re: [firebird-support] Digest Number 8245
how about
select ascii_val(substring(upper(fname) from 1 for 1 )), count(*) from
customer group by 1
to get a list of the first ascii value and the number of records that have
that value
On 1 August 2013 11:41, Andy Samuel wrote:
> **
>
>
>
> Dear All
> select count(*) from customer ( returns 235384 )
>
> select count(*) from customer where substring(upper(fname) from 1 for 1 )
> in ('A','B','C',
> 'D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z')
> ( returns 187671 )
>
> so there are 47.713 records whose fname started with letter A-Z.
>
> select distinct ascii_val(substring(upper(fname) from 1 for 1 )) from
> customer where substring(upper(fname) from 1 for 1 ) not in
> ('A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z')
> ( returns 0, 13, 46 )
>
> select count(*) from customer where ascii_val(substring(upper(fname) from
> 1 for 1 )) in (0,13,46) ( returns 38197 )
>
> I don't know how to find the other 9516 records.
> Help please ?
>
> Thank you in advance
>
> [Non-text portions of this message have been removed]
>
>
>
--
Nick Upson, Telensa Ltd
[Non-text portions of this message have been removed]
++
Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !
Also search the knowledgebases at http://www.ibphoenix.com
++
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)
<*> To change settings via email:
firebird-support-dig...@yahoogroups.com
firebird-support-fullfeatu...@yahoogroups.com
<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
Re: [firebird-support] Unable to complete network request to host "192.168.3.25"
This looks like a network issue to me, perhaps a failing NIC at one end or the other On 26 July 2013 10:26, Michael Vilhelmsen wrote: > ** > > > Hi > > We have a setup with two terminal servers and 1 database server running > Firebird 2.1.5.18497 (both server and klient). > > This has been up and running for years. > Just a few days ago, this error starts coming on variuos machines, and I > was woundering what you would look after, check and whatever to find the > cause. > > The error is: > > Unable to complete network request to host "192.168.3.25" > Error reading data from the connection. > > Last nigth I updated firebird from 2.1.4 to current version and I made a > backup restore cycle. > > This morning the error was present again. > > Mivi > > > -- Nick Upson, Telensa Ltd [Non-text portions of this message have been removed]
Re: Re[2]: [firebird-support] big change after restore
# post backup & restore # time isql < q.count.sql COUNT 129599 real0m0.382s user0m0.014s sys 0m0.049s # pre backup & restore # time isql < q.count.sql COUNT 129599 real0m4.932s user0m0.014s sys 0m0.042s the query is "select count(*) from mytable" as all the records were added in a script together I expect they would all be on close pages It is worth noting that the performance deteriorated to 4.8 sec, initially it was around the 0.3, I need to understand why in order to keep it at 0.3 On 30 July 2013 10:50, Dmitry Kuzmenko wrote: > ** > > > Hello, Nick! > > Tuesday, July 30, 2013, 1:41:21 PM, you wrote: > > NU> gstat -r output: > > NU> pre backup/restore > > you again checked select * from table at that moment? > and it is 4.8 sec? > > NU> post backup/restore > and here - 0.3 sec? > > NU> I obviously expect some improvement from backup/restore but 15x seems > more > NU> than can be accounted for > > I doubt that your measures are correct. > Since I see 130k records, I think that > 4.8 seconds of select * from table > takes FetchAll, i.e. transferring all records to client application. > > And, 0.3 seconds for the same query on 130k records > means that FetchAll is not in effect, ony some parts of records > are being read. > > Or, (which is a bit suspicious), your hard drive is very slow > at random reads, if at first case this table pages were fragmented > in the DB. > > -- > Dmitry Kuzmenko, www.ib-aid.com > > > -- Nick Upson, Telensa Ltd [Non-text portions of this message have been removed] ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: [firebird-support] big change after restore
gstat -r output: pre backup/restore Primary pointer page: 636, Index root page: 637 Average record length: 125.93, total records: 129599 Average version length: 0.00, total versions: 0, max versions: 0 Data pages: 1441, data page slots: 1849, average fill: 98% Fill distribution: 0 - 19% = 1 20 - 39% = 4 40 - 59% = 0 60 - 79% = 2 80 - 99% = 1434 post backup/restore Primary pointer page: 635, Index root page: 636 Average record length: 133.93, total records: 129599 Average version length: 0.00, total versions: 0, max versions: 0 Data pages: 1211, data page slots: 1211, average fill: 99% Fill distribution: 0 - 19% = 0 20 - 39% = 0 40 - 59% = 0 60 - 79% = 1 80 - 99% = 1210 I obviously expect some improvement from backup/restore but 15x seems more than can be accounted for On 30 July 2013 10:15, Nick Upson wrote: > Hi Mark, > > I believe I've eliminated fragmentation as the gstat output for the tables > is almost identical, no other connections to the database exist, so its not > an OIT issue > > > On 30 July 2013 10:07, Mark Rotteveel wrote: > >> ** >> >> >> On Tue, 30 Jul 2013 09:37:09 +0100, Nick Upson wrote: >> > Hi Thomas, >> > >> > I am running classic firebird 2.1, but I don't think its GC as I ran >> both a >> > sweep and a backup and still got the same, longer, time >> >> It can be a different number of issues: less fragmentation, no (or >> shorter) record version chains, large difference between OIT and the >> current transaction number in the database before backup causing >> continuous >> sweeps or something like that. >> >> Mark >> >> >> > > > > -- > Nick Upson, Telensa Ltd > -- Nick Upson, Telensa Ltd [Non-text portions of this message have been removed] ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: [firebird-support] big change after restore
Hi Mark, I believe I've eliminated fragmentation as the gstat output for the tables is almost identical, no other connections to the database exist, so its not an OIT issue On 30 July 2013 10:07, Mark Rotteveel wrote: > ** > > > On Tue, 30 Jul 2013 09:37:09 +0100, Nick Upson wrote: > > Hi Thomas, > > > > I am running classic firebird 2.1, but I don't think its GC as I ran > both a > > sweep and a backup and still got the same, longer, time > > It can be a different number of issues: less fragmentation, no (or > shorter) record version chains, large difference between OIT and the > current transaction number in the database before backup causing continuous > sweeps or something like that. > > Mark > > > -- Nick Upson, Telensa Ltd [Non-text portions of this message have been removed] ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: [firebird-support] big change after restore
Hi Thomas, I am running classic firebird 2.1, but I don't think its GC as I ran both a sweep and a backup and still got the same, longer, time On 29 July 2013 16:44, Thomas Steinmaurer wrote: > ** > > > > I'm trying to understand why there is such a large difference in runtime > > between these 2 situations. > > firebird 2.1.5 > > > > run a script to create 13 records in a table, then use it for a > while. > > Which means > > updates to some fields within that table. > > > > run "select * from table", takes around 4.8 seconds > > > > do a backup & restore of the database > > > > run "select * from table", takes around 0.3 seconds > > > > t > > he plan shows a natural scan in both cases, no other database usage > > If you are using an Firebird architecture with cooperative garbage > collection, e.g. Classic in Firebird 2.1 or Classic/SuperClassic in > Firebird 2.5, then the difference in execution time might be garbage > collecting out-dated record versions. > > MON$RECORD_STATS might give you a clue if a statement is actively > involved in garbage collection with Classic/SuperClassic. Due to the > nature of the MON$ tables being an activity snapshot for a certain > point-in-time, you may miss the statement. > > The Trace API will give you this information for continuous statement > execution, but as you might know, the Trace API has been added in > Firebird 2.5, which aren't using. > > -- > With regards, > Thomas Steinmaurer > http://www.upscene.com/ > > Professional Tools and Services for Firebird > FB TraceManager, IB LogManager, Database Health Check, Tuning etc. > > > -- Nick Upson, Telensa Ltd [Non-text portions of this message have been removed] ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[firebird-support] big change after restore
I'm trying to understand why there is such a large difference in runtime between these 2 situations. firebird 2.1.5 run a script to create 13 records in a table, then use it for a while. Which means updates to some fields within that table. run "select * from table", takes around 4.8 seconds do a backup & restore of the database run "select * from table", takes around 0.3 seconds t he plan shows a natural scan in both cases, no other database usage -- Nick Upson, Telensa Ltd [Non-text portions of this message have been removed]
Re: [firebird-support] Fwd: query refuses to die
Does anyone else have any ideas? On 22 July 2013 13:44, Nick Upson wrote: > Hi, > > Deleting the attachment from MON$ATTACHMENTS is not permitted in 2.1.5 > > SQL> delete from MON$ATTACHMENTS where MON$ATTACHMENT_ID = 6184945; > Statement failed, SQLCODE = -817 > operation not supported > > > > On 18 July 2013 15:00, Mark Rotteveel wrote: > >> ** >> >> >> On Thu, 18 Jul 2013 14:47:40 +0100, Nick Upson wrote: >> > Hi Steve, that's what I did in the end but I would really like to know >> why >> > removing the row didn't work >> >> It looks like http://tracker.firebirdsql.org/browse/CORE-3977 which will >> be fixed in 2.5.3 >> >> Deleting the attachment from MON$ATTACHMENTS should work according to that >> issue. >> >> Mark >> >> >> > > > > -- > Nick Upson, Telensa Ltd > -- Nick Upson, Telensa Ltd [Non-text portions of this message have been removed] ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: [firebird-support] Fwd: query refuses to die
Hi, Deleting the attachment from MON$ATTACHMENTS is not permitted in 2.1.5 SQL> delete from MON$ATTACHMENTS where MON$ATTACHMENT_ID = 6184945; Statement failed, SQLCODE = -817 operation not supported On 18 July 2013 15:00, Mark Rotteveel wrote: > ** > > > On Thu, 18 Jul 2013 14:47:40 +0100, Nick Upson wrote: > > Hi Steve, that's what I did in the end but I would really like to know > why > > removing the row didn't work > > It looks like http://tracker.firebirdsql.org/browse/CORE-3977 which will > be fixed in 2.5.3 > > Deleting the attachment from MON$ATTACHMENTS should work according to that > issue. > > Mark > > > -- Nick Upson, Telensa Ltd [Non-text portions of this message have been removed] ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: [firebird-support] Fwd: query refuses to die
Thank you, didn't see it there myself, unfortunately I'm stuck with 2.1.x for the foreseeable future On 18 July 2013 15:00, Mark Rotteveel wrote: > ** > > > On Thu, 18 Jul 2013 14:47:40 +0100, Nick Upson wrote: > > Hi Steve, that's what I did in the end but I would really like to know > why > > removing the row didn't work > > It looks like http://tracker.firebirdsql.org/browse/CORE-3977 which will > be fixed in 2.5.3 > > Deleting the attachment from MON$ATTACHMENTS should work according to that > issue. > > Mark > > > -- Nick Upson, Telensa Ltd [Non-text portions of this message have been removed] ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: [firebird-support] Fwd: query refuses to die
Hi Steve, that's what I did in the end but I would really like to know why removing the row didn't work On 18 July 2013 14:43, Steve Wiser wrote: > If it is classic server you can you find the PID and kill the process? > > -steve > > > -- > Steve Wiser > President > Specialized Business Software > 6325 Cochran Road, Unit 1 > Solon, OH 44139 > > www.specializedbusinesssoftware.com > www.docunym.com > (440) 542-9145 - fax (440) 542-9143 > Toll Free: (866) 328-4936 > > > > On Thu, Jul 18, 2013 at 8:54 AM, Nick Upson wrote: > > > ** > > > > > > A > > nyone? > > > > > > -- Forwarded message -- > > > > Hi, > > > > (running 2.1.5 on centos) I tried to kill a exceptionally long-running > > query (several hours) by deleting the row from MON$STATEMENT, no errors > but > > it didn't delete. I was connected via isql as sysdba, the query wasn't > > using sysdba > > > > select * from > > MON$STATEMENTS where MON$STATEMENT_ID = 30; > > > > showed the query, then I did > > > > SQL> delete from > > MON$STATEMENTS where MON$STATEMENT_ID = 30; > > SQL> commit; > > > > select * from > > MON$STATEMENTS where MON$STATEMENT_ID = 30; > > > > and it was still there, disconnected and connected again, still there. > > > > Should I have done something different, how can I ensure this works in > > future? > > > > -- > > Nick Upson, Telensa Ltd > > > > -- > > Nick Upson, Telensa Ltd > > > > [Non-text portions of this message have been removed] > > > > > > > > This message and any files transmitted with it may contain information > > that is privileged, confidential, and exempt from disclosure under > > applicable law. They are intended solely for the use of the intended > > recipient. If you are not the intended recipient, distributing, copying, > > disclosing, or reliance on the contents of this communication is strictly > > prohibited. If this has reached you in error, kindly destroy this > message > > and notify the sender immediately. Thank you for your assistance. > > > > We attempt to sweep harmful content (e.g. viruses) from e-mail and > > attachments, however we cannot guarantee their safety and can accept no > > liability for any resulting damage. The recipient is responsible to > verify > > the safety of this message and any attachments before accepting them. > > > > > [Non-text portions of this message have been removed] > > > > > > ++ > > Visit http://www.firebirdsql.org and click the Resources item > on the main (top) menu. Try Knowledgebase and FAQ links ! > > Also search the knowledgebases at http://www.ibphoenix.com > > ++ > Yahoo! Groups Links > > > > -- Nick Upson, Telensa Ltd [Non-text portions of this message have been removed]
[firebird-support] Fwd: query refuses to die
A nyone? -- Forwarded message -- Hi, (running 2.1.5 on centos) I tried to kill a exceptionally long-running query (several hours) by deleting the row from MON$STATEMENT, no errors but it didn't delete. I was connected via isql as sysdba, the query wasn't using sysdba select * from MON$STATEMENTS where MON$STATEMENT_ID = 30; showed the query, then I did SQL> delete from MON$STATEMENTS where MON$STATEMENT_ID = 30; SQL> commit; select * from MON$STATEMENTS where MON$STATEMENT_ID = 30; and it was still there, disconnected and connected again, still there. Should I have done something different, how can I ensure this works in future? -- Nick Upson, Telensa Ltd -- Nick Upson, Telensa Ltd [Non-text portions of this message have been removed]
[firebird-support] query refuses to die
Hi, (running 2.1.5 on centos) I tried to kill a exceptionally long-running query (several hours) by deleting the row from MON$STATEMENT, no errors but it didn't delete. I was connected via isql as sysdba, the query wasn't using sysdba select * from MON$STATEMENTS where MON$STATEMENT_ID = 30; showed the query, then I did SQL> delete from MON$STATEMENTS where MON$STATEMENT_ID = 30; SQL> commit; select * from MON$STATEMENTS where MON$STATEMENT_ID = 30; and it was still there, disconnected and connected again, still there. Should I have done something different, how can I ensure this works in future? -- Nick Upson, Telensa Ltd [Non-text portions of this message have been removed]
Re: [firebird-support] creating an odbc connection to a remote windows xp that is running fb 2.0
Do you have firebird client installed on the reception machine, the database should NOT be shared (it should work by the reception machine talking to the firebird server software on hantsco machine, that software then accesses the actual database) On 20 June 2013 21:40, macdem_t wrote: > ** > > > I know this question has been asked before but I can't get it to work with > the solutions provided. > here is the scenario. > I have a windows xp box running firebird 2.0 > it is called "hantscho" and its ip is 168.9.100.24 > the path the database is located in is: > \\168.9.100.24\c$\Documents and Settings\All Users\Application > Data\EFI\Dmi\AC3000\DB\EfiDmi.fdb > > I am trying to get an odbc connection to hantscho from another windows xp > computer called "reception" that is on the same subnet of 168.9.100 . both > are in a windows domain. > > I have used the the following string in when trying to create the odbc > connection: > 168.9.100.24:c:\Documents and Settings\All Users\Application > Data\EFI\Dmi\AC3000\DB\EfiDmi.fdb > > I get an open database failure > > I thought perhaps it was because it wasn't shared out so I tried to > connect to the administrative share: > 168.9.100.24:c$:\Documents and Settings\All Users\Application > Data\EFI\Dmi\AC3000\DB\EfiDmi.fdb > > This does not work either. > > now I know it is supposed to be the specific path from the c: to the > database that is entered, but if that drive is not shared how can a remote > computer connect to it? In windows don't you have to share out a folder or > a drive to have another computer access it? > I know you are not supposed to map a drive either... I am at a loss. > > I have been able to telnet into the hantscho computer through 168.9.100.24 > 3050 > so I have confirmed it is listening. > but for the life of me I don't understand how I am to make the odbc > connection. Please help me, I swear I will save a puppy from the pound if > someone does. > Thanks, > Macdem. > > > -- Nick Upson, Telensa Ltd [Non-text portions of this message have been removed]
Re: [firebird-support] sizing cache
Thanks for that, I had previously just read the first line about requiring 2.5 and eliminated it, now I see it has some capability with 2.1 On 14 May 2013 20:57, Thomas Steinmaurer wrote: > ** > > > > I'm looking at increasing the cache size of my system to improve > > performance but running into contradictory advice. (firebird 2.1.5 on > > centos) > > > > http://www.firebirdfaq.org/faq333/ says "... You should not set the > cache > > size to consume large part of your RAM" > > > > The new firebird book (p231) says " ...The first broad-brush optimization > > you can try is to increase the default cache to a size that will occupy > > approximately two-thirds of available free RAM. If there isn't enough RAM > > installed, install more. ..." > > > > This is a VM with 8GB RAM, 4vCPU, with maybe 10 connections, running > > classic, > > > > > > T > > he book also (p231) says "use a monitoring tool to observe and record how > > reads > > and writes are satisfied from the cache" I've looked at several tools and > > n > > one seem to show this data, any suggestions what tool(s) to use here? > > FB TraceManager gives you the Cache Hit Ratio via monitoring tables and > via the Trace API. > > -- > With regards, > Thomas Steinmaurer > http://www.upscene.com/ > > Professional Tools and Services for Firebird > FB TraceManager, IB LogManager, Database Health Check, Tuning etc. > > > -- Nick Upson, Telensa Ltd [Non-text portions of this message have been removed] ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: [firebird-support] sizing cache
I looked at sinatica, I can only see a point where it says "cache" - nothing about read & write figures and actual numbers would be more useful On 14 May 2013 10:23, wrote: > You can use Sinatica monitor. It will show in a graphical way. > Em 14/05/2013 06:00, "Nick Upson" escreveu: > > > ** > > > > > > Hi, > > > > I'm looking at increasing the cache size of my system to improve > > performance but running into contradictory advice. (firebird 2.1.5 on > > centos) > > > > http://www.firebirdfaq.org/faq333/ says "... You should not set the > cache > > size to consume large part of your RAM" > > > > The new firebird book (p231) says " ...The first broad-brush optimization > > you can try is to increase the default cache to a size that will occupy > > approximately two-thirds of available free RAM. If there isn't enough RAM > > installed, install more. ..." > > > > This is a VM with 8GB RAM, 4vCPU, with maybe 10 connections, running > > classic, > > > > T > > he book also (p231) says "use a monitoring tool to observe and record how > > reads > > and writes are satisfied from the cache" I've looked at several tools and > > n > > one seem to show this data, any suggestions what tool(s) to use here? > > > > -- > > Nick Upson, Telensa Ltd > > > > [Non-text portions of this message have been removed] > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > ++ > > Visit http://www.firebirdsql.org and click the Resources item > on the main (top) menu. Try Knowledgebase and FAQ links ! > > Also search the knowledgebases at http://www.ibphoenix.com > > ++ > Yahoo! Groups Links > > > > -- Nick Upson, Telensa Ltd [Non-text portions of this message have been removed]
[firebird-support] sizing cache
Hi, I'm looking at increasing the cache size of my system to improve performance but running into contradictory advice. (firebird 2.1.5 on centos) http://www.firebirdfaq.org/faq333/ says "... You should not set the cache size to consume large part of your RAM" The new firebird book (p231) says " ...The first broad-brush optimization you can try is to increase the default cache to a size that will occupy approximately two-thirds of available free RAM. If there isn't enough RAM installed, install more. ..." This is a VM with 8GB RAM, 4vCPU, with maybe 10 connections, running classic, T he book also (p231) says "use a monitoring tool to observe and record how reads and writes are satisfied from the cache" I've looked at several tools and n one seem to show this data, any suggestions what tool(s) to use here? -- Nick Upson, Telensa Ltd [Non-text portions of this message have been removed]
Re: [firebird-support] Re: use of -USE_ALL_SPACE
As I understand this now, restoring the database with use_all_space will store the data as compactly as possible, then I do "gfix -use reserve" and all subsequent changes will use the 80/20 rules for where the data goes On 4 May 2013 17:43, Dmitry Kuzmenko wrote: > ** > > > Hello, Nick! > > Thursday, May 2, 2013, 6:33:15 PM, you wrote: > > NU> as I now understand it, if I restore the database with -USE_ALL_SPACE & > NU> then do gfix -use reserve I will have a database which has all the > static > NU> data on full pages and the data that does change will quickly go back > to > NU> the 80/20 page usage. Something like 90% is static so I'm hoping this > will > > No. I wonder where these rumours or false guesses comes from. > No_reserve is a global switch, and after it is set, FB will not > reserve space anymore at data pages. > > Gbak, as Ann said (and I says it constantly), is an ordinal > application that inserts data to DB as any other application do. > No magic, at all. > > For example, InterBase XE have new behavior and options to > 1. change no_reserve option as ALTER DATABASE at runtime > 2. change no_reserve option for selected tables. > > In Firebird, to set this option off, you may only use gfix, once, > for all the database. And you can't do it during gbak. > > So, currently, this option in FB is only useful for read-only > databases. That's it. Because option cannot be set for selected > tables, only for the whole database. > > -- > Dmitry Kuzmenko, www.ib-aid.com > > > -- Nick Upson, Telensa Ltd [Non-text portions of this message have been removed] ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[firebird-support] Re: use of -USE_ALL_SPACE
as I now understand it, if I restore the database with -USE_ALL_SPACE & then do gfix -use reserve I will have a database which has all the static data on full pages and the data that does change will quickly go back to the 80/20 page usage. Something like 90% is static so I'm hoping this will give me some improved performance on queries against the static data. On 1 May 2013 15:25, Nick Upson wrote: > > H > i, > > firebird 2.1.5 on centos, > > does this option just restore the data using 100% of each page and then > the database works as normal, with 80% usage or does it restore the data to > 100% and then force all subsequent use of the database to work at 100% > usage as well. I can read the extract below either way. > > >- > >*-USE_[ALL_SPACE]* > >This switch forces the restore to use 100% of each database page and >thus not leave room for changes. By default, 80% of a page is used and 20% >kept for changes. This switch is likely to be only of practical use where > the database is created and used in read-only mode. > > -- > Nick Upson, Telensa Ltd > -- Nick Upson, Telensa Ltd [Non-text portions of this message have been removed]
[firebird-support] use of -USE_ALL_SPACE
H i, firebird 2.1.5 on centos, does this option just restore the data using 100% of each page and then the database works as normal, with 80% usage or does it restore the data to 100% and then force all subsequent use of the database to work at 100% usage as well. I can read the extract below either way. - *-USE_[ALL_SPACE]* This switch forces the restore to use 100% of each database page and thus not leave room for changes. By default, 80% of a page is used and 20% kept for changes. This switch is likely to be only of practical use where the database is created and used in read-only mode. -- Nick Upson, Telensa Ltd [Non-text portions of this message have been removed]
Re: [firebird-support] multiple connection strings
Hi, I've run some tests, using firebird 2.1.5 on centos 5.9, a database of 36Gb: 22 mins $ gbak -user sysdba -pass xxx -backup localhost:/opt/db/mydb.fdb /opt/archive/db/nu3.fbk 28 mins $ gbak -user sysdba -pass xxx -backup -se localhost:service_mgr /opt/db/mydb.fdb /opt/archive/db/nu2.fbk 29 mins $ gbak -user sysdba -pass xxx -backup /opt/db/mydb.fdb /opt/archive/db/nu1.fbk 22 mins $ gbak -user sysdba -pass xxx -backup localhost:/opt/db/mydb.fdb stdout > /opt/archive/db/nu0.fbk my original 6 hours for 76Gb included (I didn't realise at the time) compression of the backup 'on the fly' (piped stdout from gbak into gzip), removing this and doing the gzip separately saved 50% of the time compared to piping it e.g. 37GB database was taking 120 mins, now gbak backup is 30 mins & gzip is 30 mins, so total time is halved and the period gbak is running (holding a transaction open) is a quarter On 11 April 2013 13:16, Dmitry Kuzmenko wrote: > ** > > > Hello, Nick! > > Thursday, April 11, 2013, 4:06:22 PM, you wrote: > > NU> all programs that access the database use the same path component as > either > NU> "localhost:/db/mydb.fdb" - if running on the server and > NU> "myhost:/db/mydb.fdb" - if accessing it from elsewhere > > no difference. > > NU> possible new setup: > > NU> all programs that access the database use the same path component as > either > NU> "/db/mydb.fdb" - if running on the server and "myhost:/db/mydb.fdb" - > if > NU> accessing it from elsewhere > > mmm, why ? why to use local protocol? Yes, you can mix connection > strings, but here is another point - what if you will need to move > your applications from server? Will reconfigure connection string for > all of them? > > NU> Dmitry has suggested that I should get significant performance > improvement > NU> by avoiding the tcp stack but I recall (perhaps wrongly) there being > issues > NU> with this approach. > > you missed the point that I said about different gbak behavior. > > 1. gbak -b -g localhost:c:\db\db.fdb localfile.fbk > here backup transfers data from server to localfile via tcp > > 2. gbak -b -g -se localhost:service_mgr c:\db\db.fdb localfile.fbk > here gbak sends COMMAND to the server (via tcp) to make backup by > itself. > And localfile.fbk - is local to the server, not to gbak. > > For better understanding I can add that if you kill gbak > with the first command line, the backup will stop, because gbak did it. > > With the second command line backup will still continue, because > after gbak sent command via -se, it only waits for output from the > server, not for the data of the database. And the server does backup, > not gbak. > > And, switching protocol for your local > server apps will not give you any visible performance improvement. > Gbak is another thing, it reads (without -se) the whole database. > So, for gbak speed protocol matters. > > -- > Dmitry Kuzmenko, www.ib-aid.com > > > -- Nick Upson, Telensa Ltd [Non-text portions of this message have been removed] ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: [firebird-support] gbak speed
incremental backup is not recommended in firebird 2.1.5 under significant load, I wish I could On 11 April 2013 14:27, Ricardo Uzcategui wrote: > ** > > > Hi. > > My experience is using SSD sata III 6BG IO speed with best results (in a > mac bookpro with 16 gb ram). and, are you considering to use incremental > backup? > > On Thu, Apr 11, 2013 at 8:14 AM, Norman Dunbar >wrote: > > > > Ahem ... > > > > On 11/04/13 13:26, Norman Dunbar wrote: > > > > > I've updated the gbak manual to reflect the use of -g[arbage_collect] > > > and -se[rvice] to speed up backups and restores, by adding a couple of > > > sections explaing their use. > > > > Obviously, I didn't include -g[arbage_collect] in the restore section! > > > > > > Cheers, > > Norm. > > > > -- > > Norman Dunbar > > Dunbar IT Consultants Ltd > > > > Registered address: > > Thorpe House > > 61 Richardshaw Lane > > Pudsey > > West Yorkshire > > United Kingdom > > LS28 7EL > > > > Company Number: 05132767 > > > > > > > > > > ++ > > > > Visit http://www.firebirdsql.org and click the Resources item > > on the main (top) menu. Try Knowledgebase and FAQ links ! > > > > Also search the knowledgebases at http://www.ibphoenix.com > > > > ++ > > Yahoo! Groups Links > > > > > > > > > > -- > Ricardo... > > > [Non-text portions of this message have been removed] > > > -- Nick Upson, Telensa Ltd [Non-text portions of this message have been removed] ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[firebird-support] multiple connection strings
Hi, Can anyone confirm that I can have the following system running without potential for problems (firebird 2.1.5 on centos). currently: all programs that access the database use the same path component as either "localhost:/db/mydb.fdb" - if running on the server and "myhost:/db/mydb.fdb" - if accessing it from elsewhere possible new setup: all programs that access the database use the same path component as either "/db/mydb.fdb" - if running on the server and "myhost:/db/mydb.fdb" - if accessing it from elsewhere D mitry has suggested that I should get significant performance improvement by avoiding the tcp stack but I recall (perhaps wrongly) there being issues with this approach. -- Nick Upson, Telensa Ltd [Non-text portions of this message have been removed]
Re: Re[2]: [firebird-support] gbak speed
Hi Dmitry, are you saying that I should remove localhost from the database connection string to get faster performance? and that will work ok with other processes running that do connect via localhost continuing to run at the same time (this is a 24/7 system)? On 11 April 2013 11:53, Dmitry Kuzmenko wrote: > Hello, André! > > Thursday, April 11, 2013, 2:42:01 PM, you wrote: > > >> How does this compare with the experience of others? > > AK> Hmmm. A quick calculation shows: > AK> My biggest database is 1/74 of the size of yours. > AK> I need ~5 Minutes to backup a freshly restored database, backup takes > AK> longer if the restore is longer ago (up to 6.5 minutes). > > too slow. at my old desktop with Athlon 64 x2 5200 and 3 SATA II drives > backup of 2.7GB database from one drive to another took from 3.5 to 5 > minutes, depending on protocol used. > The fastest way to do backup is to use Services API, > i.e. -se option of gbak. And, to use -g option of course. > > So, with worst 5 minutes result, 74/2.7 = 2 hours and 17 minutes. > > And, with the a bit modern hardware (but still desktop with several > drives) > restore of another database, 1.5GB backup size and 3.9gb > resulting database also takes not more than 5 minutes, > via -se. > But, via localhost - around 1 hour. > > -- > Dmitry Kuzmenko, www.ib-aid.com > > > > > > ++ > > Visit http://www.firebirdsql.org and click the Resources item > on the main (top) menu. Try Knowledgebase and FAQ links ! > > Also search the knowledgebases at http://www.ibphoenix.com > > ++ > Yahoo! Groups Links > > > > -- Nick Upson, Telensa Ltd [Non-text portions of this message have been removed]
Re: [firebird-support] gbak speed
the database & backup are already seperate devices On 11 April 2013 10:25, Marcus Bajohr wrote: > ** > > > Hej, > > from my little knowledge i have: are the db and the backup on different > devices? Or are they both on the raid? > I've reduced the backup time from 1,5 mours to 40 minutes for a ~55 GB > db by simply writing the backup to another physical dev > > cheers, Marcus > > > Nick Upson <mailto:n...@telensa.com> > > Donnerstag, 11. April 2013 11:19 > > > Hi, > > > > I'm need to speedup my database backup, its currently taking 6 hours to > > backup a 74Gb database. Using firebird 2.1.5 on centos, database is on > > fast > > drives with raid 10. > > > > How does this compare with the experience of others? > > > > the command line used is: (and I do need the garbage collect) > > > > gbak -user sysdba -pass XXX -backup localhost:/opt/db/mydb.fdb stdout > > > /var/archive/db/mydb.fbk > > > > [Non-text portions of this message have been removed] > > > -- Nick Upson, Telensa Ltd [Non-text portions of this message have been removed] ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[firebird-support] gbak speed
Hi, I'm need to speedup my database backup, its currently taking 6 hours to backup a 74Gb database. Using firebird 2.1.5 on centos, database is on fast drives with raid 10. How does this compare with the experience of others? the command line used is: (and I do need the garbage collect) gbak -user sysdba -pass XXX -backup localhost:/opt/db/mydb.fdb stdout > /var/archive/db/mydb.fbk -- Nick Upson, Telensa Ltd [Non-text portions of this message have been removed]
Re: [firebird-support] sweep running details
Hi Leonardo, thats the symptom I'm seeing, intermittently a process will almost stop and will stay that way for several hours how did you prove that was the cause? On 15 January 2013 15:59, Leonardo Carneiro wrote: > ** > > > Hi Nick. I've found that my applications ALMOST hang when sweep is running > in big databases (100GB+). > > I say almost because once in a while the application give a sign of life. > To "solve" the problem, i disabled the autosweep and run in a scheduled > task every dawn. > > Best regards. > > > On Tue, Jan 15, 2013 at 12:29 PM, Nick Upson n...@telensa.com> wrote: > > > Hi, > > > > (firebird 2.1.5 on centos) 50Gb database > > > > Is there any reason why a process, upon noticing the transaction gap is > > > 2 & hence a sweep is required, should 'hang' (for hours), as if > waiting > > for the sweep to complete. > > > > Is there any way I can tell (logging or process monitoring perhaps) when > an > > automatic sweep is initiated, running or completed? > > > > -- > > Nick Upson, Telensa Ltd > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > ++ > > > > Visit http://www.firebirdsql.org and click the Resources item > > on the main (top) menu. Try Knowledgebase and FAQ links ! > > > > Also search the knowledgebases at http://www.ibphoenix.com > > > > ++ > > Yahoo! Groups Links > > > > > > > > > > [Non-text portions of this message have been removed] > > > -- Nick Upson, Telensa Ltd [Non-text portions of this message have been removed] ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[firebird-support] sweep running details
Hi, (firebird 2.1.5 on centos) 50Gb database Is there any reason why a process, upon noticing the transaction gap is > 2 & hence a sweep is required, should 'hang' (for hours), as if waiting for the sweep to complete. Is there any way I can tell (logging or process monitoring perhaps) when an automatic sweep is initiated, running or completed? -- Nick Upson, Telensa Ltd [Non-text portions of this message have been removed]
Re: Re[4]: [firebird-support] sweep start & running
HI Dmitry, thanks, I thought that there should not be a second sweep run but needed to make sure And, transactions does not "holding the transaction counter". maybe I said it badly, I meant that: If I start a transaction, until I commit or rollback that stops the OAT moving forward (holding the active transaction counter I intended to say) can you help with this? : gbak can cause a gap > 2, can that cause a sweep to be started when another process 'notices' the gap? On 14 January 2013 14:55, Dmitry Kuzmenko wrote: > ** > > > Hello, Nick! > > Monday, January 14, 2013, 6:39:33 PM, you wrote: > > NU> I'm think of something like this: > NU> process A starts a transaction & holds it open, holding the transaction > NU> counter > NU> (time & transactions pass) > NU> process B starts a transaction, sees gap > 2 & initiates sweep > ... > No, completely. > > Process A starts a transaction, engine checks Next, OAT, OST, etc, > and if there is a sweep gap greater than sweep interval, starts sweep. > This happens at the start of transaction, and this operation > is not parallel. > > So, when next transaction will start, auto-sweep already will be active, > and will not start second time. > > And, transactions does not "holding the transaction counter". > > Have you heard about windows function InterLockedIncrement? > Transaction start is like this. > > NU> On 14 January 2013 14:30, Dmitry Kuzmenko k...@ibase.ru> wrote: > > >> ** > > >> > >> > >> Hello, Nick! > >> > >> Monday, January 14, 2013, 5:52:49 PM, you wrote: > >> > >> NU> if 2 processes both see a gap > 2 will that result in 2 sweeps > >> running > >> NU> at the same time? > >> > >> transaction start is serialized, i.e. no 2 transactions can start at > >> the same time. So, auto-sweep can not run 2 times at once. > >> Only first transaction start, that will discover "sweep interval", > >> will initiate auto-sweep (if it is not turned off by sweep interval = > >> 0). > >> > >> -- > >> Dmitry Kuzmenko, www.ib-aid.com > >> > >> > >> > > -- > Dmitry Kuzmenko, www.ib-aid.com > > > -- Nick Upson, Telensa Ltd [Non-text portions of this message have been removed] ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: Re[2]: [firebird-support] sweep start & running
I'm think of something like this: process A starts a transaction & holds it open, holding the transaction counter (time & transactions pass) process B starts a transaction, sees gap > 2 & initiates sweep process C starts a transaction, sees gap > 2 & (sweep or why not)? On 14 January 2013 14:30, Dmitry Kuzmenko wrote: > ** > > > Hello, Nick! > > Monday, January 14, 2013, 5:52:49 PM, you wrote: > > NU> if 2 processes both see a gap > 2 will that result in 2 sweeps > running > NU> at the same time? > > transaction start is serialized, i.e. no 2 transactions can start at > the same time. So, auto-sweep can not run 2 times at once. > Only first transaction start, that will discover "sweep interval", > will initiate auto-sweep (if it is not turned off by sweep interval = > 0). > > -- > Dmitry Kuzmenko, www.ib-aid.com > > > -- Nick Upson, Telensa Ltd [Non-text portions of this message have been removed] ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: [firebird-support] sweep start & running
if 2 processes both see a gap > 2 will that result in 2 sweeps running at the same time? On 13 January 2013 10:12, Thomas Steinmaurer wrote: > ** > > > > I'm trying to track down an intermittent performance issue, and I find I > > don't have sufficient grasp of sweep behavior. > > > > firebird 2.1.5 classic on centos > > > > I understand that a sweep is started (new thread is created) when > OST-OIT > > > 2 (by default). What I can't find documented is when this check is > > made. Is it made when a client starts a connection, starts a transaction, > > queries a table or something else? > > Dmitry, Vlad, Alex, Ann etc. have more insights here, but AFAIK with > each transaction start, TIP related stuff is processed/evaluated, thus I > guess the check happens upon a new transaction start, but I might be wrong. > > Regards, > Thomas > > > -- Nick Upson, Telensa Ltd [Non-text portions of this message have been removed] ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[firebird-support] Re: sweep start & running
and (sorry) gbak can cause a gap > 2, can that cause a sweep to be started when another process 'notices' the gap? On 11 January 2013 12:06, Nick Upson wrote: > Hi, > > I'm trying to track down an intermittent performance issue, and I find I > don't have sufficient grasp of sweep behavior. > > firebird 2.1.5 classic on centos > > I understand that a sweep is started (new thread is created) when OST-OIT > > 2 (by default). What I can't find documented is when this check is > made. Is it made when a client starts a connection, starts a transaction, > queries a table or something else? > > > > > -- > Nick Upson, Telensa Ltd > -- Nick Upson, Telensa Ltd [Non-text portions of this message have been removed]
[firebird-support] sweep start & running
Hi, I'm trying to track down an intermittent performance issue, and I find I don't have sufficient grasp of sweep behavior. firebird 2.1.5 classic on centos I understand that a sweep is started (new thread is created) when OST-OIT > 2 (by default). What I can't find documented is when this check is made. Is it made when a client starts a connection, starts a transaction, queries a table or something else? -- Nick Upson, Telensa Ltd [Non-text portions of this message have been removed]
Re: [firebird-support] Re: epel firebird 2.1.5
Hi, it looks like this one was missed after upgrading from 2.1.4 2.1.5.0-2 to I had to manually do this: ln -s /usr/lib/firebird/lib/libfbclient.so.2.1.5 /usr/lib/libgds.so rpm -qa | grep firebird* firebird-classic-2.1.5.18496.0-2.el5 firebird-libfbclient-2.1.5.18496.0-2.el5 firebird-libfbembed-2.1.5.18496.0-2.el5 firebird-2.1.5.18496.0-2.el5 firebird-filesystem-2.1.5.18496.0-2.el5 On 9 August 2012 09:38, Nick Upson wrote: > > > On 8 August 2012 23:07, philippe makowski wrote: > >> ** >> >> >> philippe makowski [2012-08-08 20:38] : >> >> > Nick Upson [2012-08-08 14:21] : >> >> Hi, >> >> >> >> please does anyone know if there is going to be an epel 2.1.5 rpm >> build and >> >> if so when it might happen. >> >> >> > for EPEL5, I will try to find time for it before next week >> >> In progress : >> https://admin.fedoraproject.org/updates/firebird-2.1.5.18496.0-1.el5 >> >> > > great, thanks > > > Nick Upson > > > -- Nick Upson, Telensa Ltd [Non-text portions of this message have been removed]
Re: [firebird-support] page 2226658, page type 5 lock denied (216)
On 27 September 2012 16:08, Ann Harrison wrote: > ** > > > On Thu, Sep 27, 2012 at 5:04 AM, Nick Upson wrote: > > > > > (firebird 2.1.5, centos) I got this message in the firebird log and the > > client (running locally) got error code - 335544336 > > and subsequent retry of the same operation on the same data had no > > problems.This system runs 24/7 so I don't have a > > simple way to run gfix, backups are taken ok and they restore. > > > > Should I be concerned about db corruption or anything else? > > > > Page type 5 is a data page. What you ran into was an internal deadlock > that was recognized and your process lost. The problem was entirely in > memory, so no, I wouldn't worry about datbase corruption. In theory, > Firebird should never have an internal deadlock. You've just seen a > difference between theory and practice. As processors get faster and loads > get heavier, more cases that were overlooked previously turn out to be > possible in fact. Without a repeatable test or a core dump, these problems > are very hard to diagnose. So if it happens once, chalk it up to bad luck. > If it happens repeatedly, be prepared to work with the core developers. > > Good luck, > > Ann > thanks very much Nick Upson [Non-text portions of this message have been removed]
[firebird-support] page 2226658, page type 5 lock denied (216)
Hi, (firebird 2.1.5, centos) I got this message in the firebird log and the client (running locally) got error code - 335544336 and subsequent retry of the same operation on the same data had no problems.This system runs 24/7 so I don't have a simple way to run gfix, backups are taken ok and they restore. Should I be concerned about db corruption or anything else? Nick Upson [Non-text portions of this message have been removed]
Re: [firebird-support] Re: Problem IBStoredProc
are you doing "execute procedure SP" or "select * from SP"? , you want the
"select ..." form
Nick Upson
On 24 August 2012 15:15, Farshid Dehghan wrote:
> **
>
>
> Thanks for the answer
> But I had forgotten the "For" the Mail wrote.
> Add This word does not solve the problem
>
> --- In firebird-support@yahoogroups.com, "Ismael L. Donis Garcia"
> wrote:
> >
> > add FOR to SELECT
> >
> >
> > SET TERM ^ ;
> > CREATE PROCEDURE SP(
> > TLek VARCHAR(15) CHARACTER SET NONE COLLATE NONE)
> > RETURNS(
> > PNAME VARCHAR(100) CHARACTER SET NONE COLLATE NONE)
> > AS
> > BEGIN
> > for Select Name FROM TBL1 Where (TLekName = :TLek) ORDER BY ID
> > Into :PName DO
> > SUSPEND;
> > END ^
> > SET TERM ^ ;
> >
> >
> > =
> > || ISMAEL ||
> > =
> > - Original Message -
> > From: Farshid Dehghan
> > To: firebird-support@yahoogroups.com
> > Sent: Thursday, August 23, 2012 1:16 PM
> > Subject: [firebird-support] Problem IBStoredProc
> >
> >
> >
> > Hi
> > I've used Delphi IBStoredProc, But not run.
> > No error.
> > Please get help
> >
> > //--in firebird
> > SET TERM ^ ;
> > CREATE PROCEDURE SP(
> > TLek VARCHAR(15) CHARACTER SET NONE COLLATE NONE)
> > RETURNS(
> > PNAME VARCHAR(100) CHARACTER SET NONE COLLATE NONE)
> > AS
> > BEGIN
> > Select Name FROM TBL1 Where (TLekName = :TLek) ORDER BY ID
> > Into :PName DO
> > SUSPEND;
> > END ^
> > SET TERM ^ ;
> >
> > //--in delphi
> > IBStoredProc1.StoredProcName := 'SP';
> > IBStoredProc1.ParamByName('TLek').AsString := 'mb';
> > IBStoredProc1.ExecProc;
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
[Non-text portions of this message have been removed]
++
Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !
Also search the knowledgebases at http://www.ibphoenix.com
++
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)
<*> To change settings via email:
firebird-support-dig...@yahoogroups.com
firebird-support-fullfeatu...@yahoogroups.com
<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
Re: [firebird-support] Re: epel firebird 2.1.5
On 8 August 2012 23:07, philippe makowski wrote: > ** > > > philippe makowski [2012-08-08 20:38] : > > > Nick Upson [2012-08-08 14:21] : > >> Hi, > >> > >> please does anyone know if there is going to be an epel 2.1.5 rpm build > and > >> if so when it might happen. > >> > > for EPEL5, I will try to find time for it before next week > > In progress : > https://admin.fedoraproject.org/updates/firebird-2.1.5.18496.0-1.el5 > > great, thanks Nick Upson [Non-text portions of this message have been removed]
[firebird-support] epel firebird 2.1.5
Hi, please does anyone know if there is going to be an epel 2.1.5 rpm build and if so when it might happen. Nick Upson [Non-text portions of this message have been removed]
Re: [firebird-support] Perl, Firebird, and empty Where clause
On 19 July 2012 23:23, Paul Vinkenoog wrote: > ** > > > Hello Daniel, > > > > > I'm trying to have an existing perl program, that is using the DBI > > system for theoretical database interoperability, to use Firebird. I've > > discovered that, as a standard, this program executes statements such as, > > > > select * from table where pkey='' > > > > > Without changing the perl script, is there a way I can have Firebird > > actually return the table using the above SQL? > > No. You would have to intercept the SQL at some point and change it. If > you want the whole table, leave out the WHERE clause and if that isn't > possible, use a tautology, e.g. "...where 1=1" (or append " or 1=1" to the > existing clause). > > Good luck, > Paul Vinkenoog > > > you could replace the table with a selectable stored proc that has pkey as an input param, then have the proc return whatever you want [Non-text portions of this message have been removed]
Re: [firebird-support] lock conversion denied
On 29 May 2012 10:31, Thomas Steinmaurer wrote: > ** > > > >> ** > > >> > >> > This morning I got the following message on one of our systems in the > firebird logfile. > > page 52620, page type 5 lock conversion denied (215) > > (firebird 2.1.4, centos) > > The only reference I found is > http://tracker.firebirdsql.org/browse/CORE-1970 which indicates this > >> was > fixed in 2.1.2 > > it seems to relate to having multiple isql connections (which we did > at > >> the > right time but also have many other times as well) > >>> > >>> Or: > >>> http://tracker.firebirdsql.org/browse/CORE-3464 > >>> > >>> Which is marked as fixed in the forthcoming 2.1.5 release (RC is > already > >>> available as download!). > >> > >> Ah, and I would also check some lock manager/table information with > >> fb_lock_print to see the lock table size, possibly too high hash slot > >> values etc. > >> > > > > all such values are default > > > > LOCK_HEADER BLOCK > > Version: 16, Active owner: 0, Length: 1048576, Used: 277328 > > Lock manager pid: 3647 > > Semmask: 0x4948, Flags: 0x0001 > > Enqs: 6734541938, Converts: 49020909, Rejects: 6676277, Blocks: > > 8296620 > > Deadlock scans: 1, Deadlocks: 1, Scan interval: 10 > > Acquires: 7176561824, Acquire blocks: 6714981, Spin count: 0 > > Mutex wait: 0.1% > > Hash slots: 1009, Hash lengths (min/avg/max): 0/ 0/ 5 > > Remove node: 0, Insert queue: 0, Insert prior: 0 > > Owners (5): forward: 19596, backward: 151960 > > Free owners (6): forward: 19412, backward: 195892 > > Free locks (1316): forward: 19240, backward: 273608 > > Free requests (1397): forward: 82716, backward: 231092 > > Lock Ordering: Enabled > > I don't know your workload, but these figures only make sense when > generating under load. Was this under load? Just keep an eye on that, if > you have a (high) loaded system with Classic or SuperClassic (2.5). > > well the system is running, so there is some load, but there are times of much higher load every day this is 2.1.4 at present, are you suggesting changes to the firebird config parameters [Non-text portions of this message have been removed]
Re: [firebird-support] lock conversion denied
On 29 May 2012 10:21, Thomas Steinmaurer wrote: > ** > > > >> This morning I got the following message on one of our systems in the > >> firebird logfile. > >> > >> page 52620, page type 5 lock conversion denied (215) > >> > >> (firebird 2.1.4, centos) > >> > >> The only reference I found is > >> http://tracker.firebirdsql.org/browse/CORE-1970 which indicates this > was > >> fixed in 2.1.2 > >> > >> it seems to relate to having multiple isql connections (which we did at > the > >> right time but also have many other times as well) > > > > Or: > > http://tracker.firebirdsql.org/browse/CORE-3464 > > > > Which is marked as fixed in the forthcoming 2.1.5 release (RC is already > > available as download!). > > Ah, and I would also check some lock manager/table information with > fb_lock_print to see the lock table size, possibly too high hash slot > values etc. > all such values are default LOCK_HEADER BLOCK Version: 16, Active owner: 0, Length: 1048576, Used: 277328 Lock manager pid: 3647 Semmask: 0x4948, Flags: 0x0001 Enqs: 6734541938, Converts: 49020909, Rejects: 6676277, Blocks: 8296620 Deadlock scans: 1, Deadlocks: 1, Scan interval: 10 Acquires: 7176561824, Acquire blocks: 6714981, Spin count: 0 Mutex wait: 0.1% Hash slots: 1009, Hash lengths (min/avg/max):0/ 0/ 5 Remove node: 0, Insert queue: 0, Insert prior: 0 Owners (5): forward: 19596, backward: 151960 Free owners (6):forward: 19412, backward: 195892 Free locks (1316): forward: 19240, backward: 273608 Free requests (1397): forward: 82716, backward: 231092 Lock Ordering: Enabled [Non-text portions of this message have been removed]
[firebird-support] lock conversion denied
This morning I got the following message on one of our systems in the firebird logfile. page 52620, page type 5 lock conversion denied (215) (firebird 2.1.4, centos) The only reference I found is http://tracker.firebirdsql.org/browse/CORE-1970 which indicates this was fixed in 2.1.2 it seems to relate to having multiple isql connections (which we did at the right time but also have many other times as well) Nick Upson [Non-text portions of this message have been removed]
Re: [firebird-support] Re: connection paths
Nick Upson On 14 May 2012 11:05, Dmitry Kuzmenko wrote: > ** > > > Hello, Nick! > > > NU> On 11 May 2012 13:00, Nick Upson wrote: > > >> Hi, > >> > >> On Centos am I ok having all of the following paths in use at the same > >> time? > >> > >> myserver:/opt/dbs/mydb.fdb (from external client) > >> localhost:/opt/dbs/mydb.fdb (from internal client) > >> /opt/dbs/mydb.fdb (from internal client) > >> > >> fb2.1.4 at present, obviously I would like to avoid the possibility of > >> corruption > > why you expect corruption? accessing same db by different connection > strings can't corrupt db. > But, IMHO, I prefer to use same connection string for all types > of clients, because I do not see any reason to use different > connection strings here. My choice is > myserver:/opt/dbs/mydb.fdb > for all your cases :-) > > moreover, myserver:... or localhost:... is the same tcp connection. > Hi, there is/was an issue with connecting to a firebird database with multiple paths, hence my concern in particular, my concern was with using the tcp path (with leading server) and the direct path (without leading server) [Non-text portions of this message have been removed]
[firebird-support] Re: connection paths
anyone? Nick Upson On 11 May 2012 13:00, Nick Upson wrote: > Hi, > > On Centos am I ok having all of the following paths in use at the same > time? > > myserver:/opt/dbs/mydb.fdb (from external client) > localhost:/opt/dbs/mydb.fdb (from internal client) > /opt/dbs/mydb.fdb (from internal client) > > fb2.1.4 at present, obviously I would like to avoid the possibility of > corruption > > Nick Upson > > [Non-text portions of this message have been removed]
[firebird-support] connection paths
Hi, On Centos am I ok having all of the following paths in use at the same time? myserver:/opt/dbs/mydb.fdb (from external client) localhost:/opt/dbs/mydb.fdb (from internal client) /opt/dbs/mydb.fdb (from internal client) fb2.1.4 at present, obviously I would like to avoid the possibility of corruption Nick Upson [Non-text portions of this message have been removed]
Re: Re: [firebird-support] alter SP failure
On 24 April 2012 12:01, wrote: > ** > > > El , Nick Upson escribió: > > any idea how I can identify the blocking connection? (is this case there > > should be none) > > Try > > select MON$ATTACHMENT_ID > from mon$statements > where mon$sql_text containing ... > > Jesus > I would only expect that to work if the SP was called directly by a process, if SP_a is the one called which then calls SP-b (the one I want) it would not be visible, or am I wrong? Nick Upson [Non-text portions of this message have been removed]
Re: [firebird-support] alter SP failure
Nick Upson On 24 April 2012 11:52, wrote: > ** > > > El , Nick Upson escribió: > > > Hi, > > from the docs I have read I should be able to alter an SP, even though > > another process is running it (using firebird 2.1 I know this was an > issue > > in 2.0) > > yet doing so from db workbench I get the following output, > > lock conflict on no wait transaction > > unsuccessful metadata update > > object PR_XX is in use > > while executing: > > ALTER PROCEDURE PR_XX .. > > You can do it in superserver, classic/superclassic blocks metadata changes > while there is one connection using it. > > Jesus > Thanks, I hadn't considered it might vary by classic/SS, any idea how I can identify the blocking connection? (is this case there should be none) [Non-text portions of this message have been removed]
[firebird-support] alter SP failure
Hi, from the docs I have read I should be able to alter an SP, even though another process is running it (using firebird 2.1 I know this was an issue in 2.0) yet doing so from db workbench I get the following output, lock conflict on no wait transaction unsuccessful metadata update object PR_XX is in use while executing: ALTER PROCEDURE PR_XX .. Nick Upson [Non-text portions of this message have been removed]
Re: Re[2]: [firebird-support] SP query plan
Nick Upson On 20 April 2012 19:10, Dmitry Kuzmenko wrote: > ** > > > Hello, Nick! > > Friday, April 20, 2012, 7:55:09 PM, you wrote: > > NU> so the plan is not stored anywhere in the database that I can access? > > it is stored only in server memory when procedure being prepared first > time. > > NU> what happens is this regard when some clients reconnect and others > don't, > NU> different processes could have different plans? > > in InterBase, you can watch tmp$procedures, that are loaded into > memory. > When all users, that called that procedure, disconnects, it's > being freed and new user who called it again will result > procedure load and new plan for it. > > Why do you ask about this? you have lot of indices that being updated > much for a short time? Btw, you can check how much index statistics > is being changed by using IBAnalyst. > > (you asked) I have a process (in C) which suddenly went from around 5 mins for a specific SP call to an hour and has continued to get worse everytime its run (daily) The data is substantially the same so I'm trying to understand the cause. This is on a live system where there are restrictions on what I can do. restoring a backup onto elsewhere and it runs in 5 mins again but I can't justify a backup/restore of the live system with the several hours downtime without an explaination of what has happened and how we can avoid it happening again. This is firebird 2.1.4, 32 bit, centos 5.5 with a database almost 20Gb in size [Non-text portions of this message have been removed]
Re: [firebird-support] SP query plan
On 20 April 2012 16:50, Ann Harrison wrote: > ** > > > 2012/4/20 Jesús García > > > > > > > > I think is defined when the SP is loaded and compiled for the first use. > > To force a new plan, may be 2 ways, depending on the server architecture. > > > > 1. Superserver, recompile > > 2. Classic/superclassic. Disconnect and connect. > > > > That's right - of course, restarting Superserver also works, but that's > overkill. > so the plan is not stored anywhere in the database that I can access? what happens is this regard when some clients reconnect and others don't, different processes could have different plans? Nick Upson [Non-text portions of this message have been removed]
