[firebird-support] FB Win -> Linux - Character Set not installed
Hello Friends. I am migrating a FB DB from Windows 10 64 to Linux 64 (CentOS 7.8). When restoring FBK (generated in Windows) to the Linux FB DB the Error: CHARACTER SET WIN1252 is not installed is showed. I already tried to replace DEFAULT CHARACTER SET to UTF8 in the Windows FB DB before backuping, but did not work. Any suggestion? Thank you. Atenciosamente, + + Hugo Eyng + +
RE: [firebird-support] Firebird x CentOS 7
Thank you Mr. Makowski Atenciosamente, + + Hugo Eyng + + De: firebird-support@yahoogroups.com em nome de Philippe Makowski pmakow...@ibphoenix.fr [firebird-support] Enviado: quarta-feira, 13 de maio de 2020 06:40 Para: firebird-support@yahoogroups.com Assunto: Re: [firebird-support] Firebird x CentOS 7 Le 11/05/2020 à 21:26, Hugo Eyng hugoe...@msn.com [firebird-support] a écrit : > Hello Mr. Makowski, > > About: > > "According to Fedora packaging rules, firebird service is not started > automatically. You need to start it, as root : > systemctl start firebird-superserver.service > If you want to have firebird started at each boot, as root : > for SuperServer : > systemctl enable firebird-superserver.service" > > How to start "classic" or "superclassic"? Is it possible? And would you use > one of those instead "superserver"? > Read the Firebird documentation for that https://firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-engine.html#rnfb30-engine-modes ++ 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] Firebird x CentOS 7
Hello Mr. Makowski, About: "According to Fedora packaging rules, firebird service is not started automatically. You need to start it, as root : systemctl start firebird-superserver.service If you want to have firebird started at each boot, as root : for SuperServer : systemctl enable firebird-superserver.service" How to start "classic" or "superclassic"? Is it possible? And would you use one of those instead "superserver"? Atenciosamente, + + Hugo Eyng + + De: firebird-support@yahoogroups.com em nome de Philippe Makowski pmakow...@ibphoenix.fr [firebird-support] Enviado: sábado, 9 de maio de 2020 12:18 Para: firebird-support@yahoogroups.com Assunto: Re: [firebird-support] Firebird x CentOS 7 Hugo Eyng hugoe...@msn.com [firebird-support] a écrit le 08/05/2020 à 21:07 : > Dear Friends, > > Where can I find a good tutorial to learn how to install FB 2.5.9 ( or > higher) in CentOS 7? > > If anyone already installed and used FB in this SO: what the best option: > 1-superserver, 2-classic, 3-superclassic? > you can install Firebird 3 from this repository : https://copr.fedorainfracloud.org/coprs/makowski/firebird/ Differences between upstream and the Fedora package === * In /usr/bin you have isql-fb for Firebird isql. We can't name it isql to avoid conflict with isql from UNIX-ODBC. In /usr/bin you have also gstat-fb for Firebird gstat. We can't name it gstat to avoid conflict with gstat from Ganglia-gmond. * By default, Firebird is set as superserver mode. Please read the Firebird doc if you want to change the mode. To help you, you have systemd units in /usr/share/firebird/misc. * According to Fedora packaging rules, firebird service is not started automatically. You need to start it, as root : for SuperServer : systemctl start firebird-superserver.service If you want to have firebird started at each boot, as root : for SuperServer : systemctl enable firebird-superserver.service -- Philippe Makowski http://www.ibphoenix.com Supporting users of Firebird ++ 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
[firebird-support] Firebird x CentOS 7
Dear Friends, Where can I find a good tutorial to learn how to install FB 2.5.9 ( or higher) in CentOS 7? If anyone already installed and used FB in this SO: what the best option: 1-superserver, 2-classic, 3-superclassic? Thank you. Atenciosamente, + + Hugo Eyng + +
RE: [firebird-support] Bad performance with select first(1) + order by
Hello. Try using a "WHERE" clause if possible. Ex: WHERE "some_date_column_of_the_table" > (current_date - n) Atenciosamente, + + Hugo Eyng + + De: firebird-support@yahoogroups.com em nome de Matthias Winkler spmm...@gmail.com [firebird-support] Enviado: terça-feira, 4 de fevereiro de 2020 11:36 Para: firebird-support@yahoogroups.com Assunto: [firebird-support] Bad performance with select first(1) + order by Hello, I am struggling with my DB performance once more: SELECT FIRST(1) PRIMKEY FROM TABLE_X ORDER BY PRIMKEY DESC The statement is slow once more because of the sorting. I just want to find the entry with the highest primary key. The PRIMKEY is ASC and unique. Is the another way to achieve the same? Thanks Matthias
RE: [firebird-support] Database server Clock Incorrect
Thank you Dimitry. It was very usefull. Atenciosamente, + + Hugo Eyng + + De: firebird-support@yahoogroups.com em nome de Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] Enviado: sexta-feira, 10 de janeiro de 2020 14:13 Para: firebird-support@yahoogroups.com Assunto: Re: [firebird-support] Database server Clock Incorrect 10.01.2020 14:07, Hugo Eyng hugoe...@msn.com [firebird-support] wrote: > Restarting FB server worked. Some users in others foruns reported the same > bug and the > same "solution", but do you know if this bug is restricted to what FB version > and if there > is something we can do to avoid this happen again? http://tracker.firebirdsql.org/browse/CORE-5959 -- 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] Database server Clock Incorrect
Thank you Mark. Restarting FB server worked. Some users in others foruns reported the same bug and the same "solution", but do you know if this bug is restricted to what FB version and if there is something we can do to avoid this happen again? Atenciosamente, + + Hugo Eyng + + De: firebird-support@yahoogroups.com em nome de Mark Rotteveel m...@lawinegevaar.nl [firebird-support] Enviado: sexta-feira, 10 de janeiro de 2020 08:19 Para: firebird-support@yahoogroups.com Assunto: Re: [firebird-support] Database server Clock Incorrect On 2020-01-09 23:42, Hugo Eyng hugoe...@msn.com [firebird-support] wrote: > Hello. > > Win10 64 and Win7 32 > > FB 2.5 32bits > > When I execute "select current_time from RDB$Database" FB returns 1 > (one) hour more then the current time. > > Did somebody faced this troble? Sounds like the Firebird server is in a different time zone than the client. Or possibly, this is that bug where a DST change isn't noticed by the server, and it continues to use the old time zone. In that case a restart of the Firebird server process should fix it. Mark
[firebird-support] Database server Clock Incorrect
Hello. Win10 64 and Win7 32 FB 2.5 32bits When I execute "select current_time from RDB$Database" FB returns 1 (one) hour more then the current time. Did somebody faced this troble? Atenciosamente, + + Hugo Eyng + + De: firebird-support@yahoogroups.com em nome de Elmar Haneke el...@haneke.de [firebird-support] Enviado: quarta-feira, 8 de janeiro de 2020 16:43 Para: firebird-support@yahoogroups.com Assunto: Re: [firebird-support] Running Firebird as Application on Linux > we wrote an cross-platform application framework that should > be relocatible including the database engine and the database file. > For Windows systems there is a command line option "-a" to start > Firebird as application. I did not find any similar for the Linux > version. Is there any way to run the Firebird server on Linux > without installation into the system? The fbserver executable can be run in any user context that has access to database files. On linux most servers are just processes started by other processes (e.g. by sysctrl or initd). You can have fbserver started on boot or you can start it on your own once needed. Elmar
RE: [firebird-support] Database/Table Corruption
Hi Mark. I decided to "pump" all tables, except the one that was inconsistent, from the old to a new database. After this, I extracted all records I could from the incosistent table and inserted into the new database. Possibly I lost some records from this table, I realy don´t know, because "select count(id) from mytable" results in the same " ERROR:internal Firebird consistency check (decompression overran buffer (179), file: sqz.cpp line: 239)" Atenciosamente, + + Hugo Eyng + + De: firebird-support@yahoogroups.com em nome de Mark Rotteveel m...@lawinegevaar.nl [firebird-support] Enviado: quarta-feira, 1 de janeiro de 2020 08:25 Para: firebird-support@yahoogroups.com Assunto: Re: [firebird-support] Database/Table Corruption On 31/12/2019 18:27, Hugo Eyng hugoe...@msn.com [firebird-support] wrote: > Gfix didn´t work even using it as you explained. Please be more specific than "didn't work". What happened, did you get an error, did gfix find nothing wrong? What was the gfix output? Mark -- Mark Rotteveel
RE: [firebird-support] Database/Table Corruption
Hello Alexey. IBPump was a good idea. IBPump doesn´t recover the corrupted table but at least it is possible to restore all others. Atenciosamente, + + Hugo Eyng + + De: firebird-support@yahoogroups.com em nome de Alexey Kovyazin a...@ib-aid.com [firebird-support] Enviado: sábado, 28 de dezembro de 2019 07:33 Para: firebird-support@yahoogroups.com Assunto: Re: [firebird-support] Database/Table Corruption Hello, before you try FirstAID, download IBPump and try to pump all data to the new database with the same structure. Regards, Alexey Kovyazin IBSurgeon On 27.12.2019 22:49, Hugo Eyng hugoe...@msn.com<mailto:hugoe...@msn.com> [firebird-support] wrote: Hello. FB 2.5.7 Windows 10 64 bits Page size 4096 I am facing some dificulties to backup and restore a corrupted DB. I searched the Internet to find some help and tried everthing I read. I already tried "gfix -full - mend" and did not work. gbak -B -V -user SYSDBA -password masterkey MYDB.FDB MYDB.FBK . .. .. . gbak:46 records written gbak: ERROR:internal Firebird consistency check (decompression overran buffer (179), file: sqz.cpp line: 239) gbak: ERROR:gds_$receive failed gbak:Exiting before completion due to errors gbak: ERROR:internal Firebird consistency check (can't continue after bugcheck) I already dropped the table that causes this message but than the error occurs ahead. . .. .. gbak:writing table constraints gbak:writing constraint INTEG_1 gbak:writing constraint INTEG_2 gbak:writing constraint INTEG_3 gbak:writing constraint INTEG_4 gbak:writing constraint INTEG_5 gbak:writing constraint INTEG_6 gbak:writing constraint INTEG_7 gbak:writing constraint INTEG_8 gbak:writing constraint INTEG_9 gbak:writing constraint INTEG_10 gbak:writing constraint INTEG_11 gbak:writing constraint INTEG_12 gbak:writing constraint INTEG_13 gbak:writing constraint INTEG_14 gbak:writing constraint INTEG_15 gbak:writing constraint INTEG_16 gbak:writing constraint INTEG_17 gbak: ERROR:internal Firebird consistency check (decompression overran buffer (179), file: sqz.cpp line: 239) gbak:Exiting before completion due to errors gbak: ERROR:internal Firebird consistency check (can't continue after bugcheck) Any help will be apreciated. Atenciosamente, + + Hugo Eyng + +
RE: [firebird-support] Database/Table Corruption
Hello Mark. Gfix didn´t work even using it as you explained. Atenciosamente, + + Hugo Eyng + + De: firebird-support@yahoogroups.com em nome de Mark Rotteveel m...@lawinegevaar.nl [firebird-support] Enviado: sábado, 28 de dezembro de 2019 07:02 Para: firebird-support@yahoogroups.com Assunto: Re: [firebird-support] Database/Table Corruption On 27/12/2019 20:49, Hugo Eyng hugoe...@msn.com [firebird-support] wrote: > FB 2.5.7 > Windows 10 64 bits > Page size 4096 I'd suggest upgrading to 2.5.9 and see if that fixes the problem. Both in 2.5.8 and 2.5.9, bugs with gbak were fixed. Those bug fixes don't match the description of this problem, but it never hurts to try with a newer version. > I am facing some dificulties to backup and restore a corrupted DB. I > searched the Internet to find some help and tried everthing I read. > > I already tried "gfix -full - mend" and did not work. It should be -mend, not - mend. However, did you read all the caveats about using -mend in the gfix documentation[1] as it can cause loss of data? However, did gfix output any information about problems? Preferably start with gfix -validate -full -no_update then move to gfix -validate -full and only use gfix -mend as a last resort (and make a copy of the database before running it!). [1]: https://firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/gfix-dbverify.html -- Mark Rotteveel
[firebird-support] Database/Table Corruption
Hello. FB 2.5.7 Windows 10 64 bits Page size 4096 I am facing some dificulties to backup and restore a corrupted DB. I searched the Internet to find some help and tried everthing I read. I already tried "gfix -full - mend" and did not work. gbak -B -V -user SYSDBA -password masterkey MYDB.FDB MYDB.FBK . .. .. . gbak:46 records written gbak: ERROR:internal Firebird consistency check (decompression overran buffer (179), file: sqz.cpp line: 239) gbak: ERROR:gds_$receive failed gbak:Exiting before completion due to errors gbak: ERROR:internal Firebird consistency check (can't continue after bugcheck) I already dropped the table that causes this message but than the error occurs ahead. . .. .. gbak:writing table constraints gbak:writing constraint INTEG_1 gbak:writing constraint INTEG_2 gbak:writing constraint INTEG_3 gbak:writing constraint INTEG_4 gbak:writing constraint INTEG_5 gbak:writing constraint INTEG_6 gbak:writing constraint INTEG_7 gbak:writing constraint INTEG_8 gbak:writing constraint INTEG_9 gbak:writing constraint INTEG_10 gbak:writing constraint INTEG_11 gbak:writing constraint INTEG_12 gbak:writing constraint INTEG_13 gbak:writing constraint INTEG_14 gbak:writing constraint INTEG_15 gbak:writing constraint INTEG_16 gbak:writing constraint INTEG_17 gbak: ERROR:internal Firebird consistency check (decompression overran buffer (179), file: sqz.cpp line: 239) gbak:Exiting before completion due to errors gbak: ERROR:internal Firebird consistency check (can't continue after bugcheck) Any help will be apreciated. Atenciosamente, + + Hugo Eyng + +
[firebird-support] Upgrade to FB 3 or Wait for FB 4
Dear Friends. Now a days we are running FB 2.5.8, but we know that we will upgrade FB. So I would like listening your opinion about what is the better choice: Upgrading to FB 3 and after to FB 4 or wait and upgrading directly finto FB 4? Off course this is a question that can be answered more than one way, but I would like to know what should I consider to decide. Atenciosamente, + + Hugo Eyng + +
[firebird-support] Very slow select Index with null date
Hello. I created an index on a table where de column is datetime type. The problem seems to be related to the NULL value. This SQL is very SLOW (about 7 seconds for a table containing 360.000 records). Returns around 400 records SELECT A.cd_xxx, A.dt_1, A.dt_2, A.dt_3, A.dt_4, A.dt_5, A.dt_index FROM DM251 A WHEREA.DT_INDEX IS NULL This SQL is very FAST (less than 0.5 seconds for a table containing 360.000 records). Returns around 359.600 records SELECT A.cd_xxx, A.dt_1, A.dt_2, A.dt_3, A.dt_4, A.dt_5, A.dt_index FROM DM251 A WHEREA.DT_INDEX IS NOT NULL Atenciosamente, + + Hugo Eyng + +
RE: [firebird-support] INET/inet_error: read errno = 10054
Thank You Mark. Atenciosamente, + + Hugo Eyng + + De: firebird-support@yahoogroups.com em nome de Mark Rotteveel m...@lawinegevaar.nl [firebird-support] Enviado: quarta-feira, 19 de setembro de 2018 07:39 Para: firebird-support@yahoogroups.com Assunto: Re: [firebird-support] INET/inet_error: read errno = 10054 On 2018-09-19 00:54, Hugo Eyng hugoe...@msn.com [firebird-support] wrote: > Hello. > > Does anybody know what causes this message in firebird.log? Error 10054 is connection reset by peer, and that usually means that the connection was abruptly closed, eg by a process crash, or by a client otherwise abruptly terminating a socket without properly sending a disconnect to the Firebird server. Common causes are applications quitting without closing connections, or driver bugs which don't properly send a disconnect. PS. For readability it is better to not rely on the subject to ask your question: repeat the pertinent information in the body.
RE: [firebird-support] INET/inet_error: read errno = 10054
Thank you. Atenciosamente, + + Hugo Eyng + + De: firebird-support@yahoogroups.com em nome de 'Paul Beach' pbe...@mail.ibphoenix.com [firebird-support] Enviado: quarta-feira, 19 de setembro de 2018 06:12 Para: firebird-support@yahoogroups.com Assunto: RE: [firebird-support] INET/inet_error: read errno = 10054 > Does anybody know what causes this message in firebird.log? INET/inet_error: read errno = 10054 Winsock.h WSAECONNRESET 10054 Connection reset by peer. An existing connection was forcibly closed by the remote host. This normally results if the peer application on the remote host is suddenly stopped, the host is rebooted, the host or remote network interface is disabled, or the remote host uses a hard close (see setsockopt for more information on the SO_LINGER option on the remote socket). This error may also result if a connection was broken due to keep-alive activity detecting a failure while one or more operations are in progress. Operations that were in progress fail with WSAENETRESET. Subsequent operations fail with WSAECONNRESET. This happens if a sockets client is actively sending or receiving data to or from a Firebird Server, and the network connection is lost. If a client crashes or a network error occurs (for example, an intermediate router goes down), the server has no way of knowing this, unless it tries to use send(). In this case send fails with the WSAECONNRESET error. How does an application know that the remote end has terminated the connection? The answer depends on whether the remote end terminated the connection gracefully or abortively. If the termination was abortive, then send() and recv() calls will fail with the error WSAECONNRESET. So, in simpler terms the socket that is the end point of the other connection has gone. Either the Firebird server has crashed, or the application using the Firebird client has disconnected abnormally (the application may also have crashed). You need to make a new connection, as the existing connection(s) can no longer be used. If these are infrequent, there is probably nothing to worry about, a client may have rebooted their system, or has been turned off without disconnecting from the database server. However if they are frequent, then you need to look at what may be causing the disconnections, either in the application or on the network. Regards Paul
[firebird-support] INET/inet_error: read errno = 10054
Hello. Does anybody know what causes this message in firebird.log? Atenciosamente, + + Hugo Eyng + +
[firebird-support] How to find out Firebird mode in use
Hello. How can I find out what mode of FB is runnig? SuperServer or SuperClassic? Atenciosamente, + + Hugo Eyng + +
RE: [firebird-support] how to resolve this deadlock
Hi Hamish. I don't intend to be obvious, but would it be possible to check record existence before inserting? Atenciosamente, + + Hugo Eyng + + De: firebird-support@yahoogroups.com em nome de 'Hamish Moffatt' ham...@risingsoftware.com [firebird-support] Enviado: quarta-feira, 12 de setembro de 2018 00:50 Para: firebird-support@yahoogroups.com Assunto: Re: [firebird-support] how to resolve this deadlock On 10/09/18 22:52, Hugo Eyng hugoe...@msn.com<mailto:hugoe...@msn.com> [firebird-support] wrote: Hi Hamish. I am not sure if I understood clearly your problem. If I did, you probably should use "WITH LOCK" clause. Thanks Hugo, that might work. But as the row might not exist yet, I would have to lock the whole table, else the two inserts could still run simultaneously and conflict. Hamish
RE: [firebird-support] how to resolve this deadlock
Hi Hamish. I am not sure if I understood clearly your problem. If I did, you probably should use "WITH LOCK" clause. Atenciosamente, + + Hugo Eyng + + De: firebird-support@yahoogroups.com em nome de 'Hamish Moffatt' ham...@risingsoftware.com [firebird-support] Enviado: segunda-feira, 10 de setembro de 2018 08:46 Para: firebird-support@yahoogroups.com Assunto: [firebird-support] how to resolve this deadlock I have a bunch of users logging in to my system at the same time, which causes a simple query like this to run: UPDATE OR INSERT INTO G_CLASS (CLASS_NUM, CLASS_NAME, USER_NUM, SYLLABUS_NUM) VALUES (1, 'Foo', 1001, 43) The field values are identical for each - it's exactly the same query. There's multiple threads running. I'm getting a deadlock. The transaction mode is read committed with wait; when one transaction finishes the next one unblocks, but fails with a deadlock error. The real query during login is actually a MERGE INTO which achieves the same thing except it doesn't update all the fields. This might be another level of complexity again. Where do I start on resolving this? The queries kind of don't actually conflict... Is there a different isolation mode that makes it work, or do I need a different approach, or to retry? Hamish
RE: [firebird-support] Name longer than database column size
Thank you Karol. I will check it. I think you are right. Atenciosamente, + + Hugo Eyng + + De: firebird-support@yahoogroups.com em nome de liviuslivius liviusliv...@poczta.onet.pl [firebird-support] Enviado: quinta-feira, 9 de agosto de 2018 03:58 Para: firebird-support@yahoogroups.com Assunto: Re: [firebird-support] Name longer than database column size Hi, i suppose you have name longer in your particular select statement. This can be e.g. in aliasing a field Select a.x as veryLongAliasedNameLongerThen31 from ... But only you can tell in what exact place you got this error Regards, Karol Bieniaszewski
[firebird-support] Name longer than database column size
Hello. The subject was already discussed before, but I am facing a trouble. I was using FB 2.5 and than I migrated DB to FB 3.0.3. Now when I open my application it shows the message "Name longer than database column size". I searched all the metadata and did not find any object longer than 31 characters. What is wrong? Atenciosamente, + + Hugo Eyng + +
Re: [firebird-support] GBAk - Restoring only data
Thanks. Em 21/09/2016 11:06, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] escreveu: > 21.09.2016 15:51, Hugo Eyng hugoe...@msn.com [firebird-support] wrote: >> Using gbak, Is it possible restoring only data into an existing >> database. > No, not with gbak. IBBackupSurgeon can do that: > http://ib-aid.com/en/ibbackupsurgeon/ > > -- Atenciosamente, Hugo Eyng ++ 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 <*> 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: https://info.yahoo.com/legal/us/yahoo/utos/terms/
[firebird-support] GBAk - Restoring only data
Hello. Using gbak, Is it possible restoring only data into an existing database. Not triggers, not SP. Only data. The existing DB does not have data. FirbirdSQL 2.5 Windows Server 2008 -- Atenciosamente, Hugo Eyng
Re: [firebird-support] gfix full or reserve required
Hi Helen. Thank you. I should pay more attention to the command usage. Hugo Eyng Em 06/07/2016 19:49, Helen Borrie hele...@iinet.net.au [firebird-support] escreveu: Thursday, July 7, 2016, 10:20:50 AM, Hugo Eyng wrote: > I tried to use gfix -w async -u USER -p PASSWAORD MYDB.FDB and gfix > displayed "full or reserve required". > What does it mean? That "full" or "reserve" is required? :)) The -u switch in gfix is NOT an abbreviated form for the username but for page-fill capacity, i.e., -u[se] with the argument reserve (for reserve space) or full (for use the full page). It's not what you want, I know, but don't set this to full unless the database is also read-only. Your password abbreviation is wrong for gfix, too. It is -pa[ssword]. The -p abbreviation in gfix is for something else, used in recovery of transactions from broken multi-database connections. You want: gfix -w async -user USER -password PASSWAORD MYDB.FDB Helen -- Atenciosamente, Hugo Eyng
[firebird-support] gfix full or reserve required
Hello. I tried to use gfix -w async -u USER -p PASSWAORD MYDB.FDB and gfix displayed "full or reserve required". What does it mean? That "full" or "reserve" is required? :)) -- Atenciosamente, Hugo Eyng
[firebird-support] gfix -write
Hello Friends. I intend to set my DB to asynchronous mode. Should I close all conections before do it? -- Atenciosamente, Hugo Eyng
Re: [firebird-support] Re: Column Name Size
Thank you (all) for the answer. Em 17/06/2016 10:31, Dmitry Yemanov dim...@users.sourceforge.net [firebird-support] escreveu: > 17.06.2016 10:56, Dimitry Sibiryakov s...@ibphoenix.com wrote: >>>> Is there the limitation of 31 bytes for column names in the new FB 3? >>> 31 CHARACTERS - as before >> No, it is 31 byte. > Correct, the limit is 31 *bytes*. The legacy UNICODE_FSS charset is > multi-byte (up to three bytes per character) in user-defined tables, but > it's treated specially for system tables, limiting the length to 31 > bytes, not characters (like it was a single-byte charset). The reasons > are mainly historical (thanks to Borland) and related to backward > compatibility of API and GPRE-generated code. > > v3 preserves this legacy behaviour. v4 resolves this issue from multiple > angles: > > - switching to UTF8 instead of UNICODE_FSS > - counting the length in characters instead of bytes > - increasing the limit to 63 characters (at the moment, may change > before the final release) > > > Dmitry > > > > > > > > > ++ > > 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 > > > > > -- Atenciosamente, Hugo Eyng ++ 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 <*> 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: https://info.yahoo.com/legal/us/yahoo/utos/terms/
[firebird-support] Column Name Size
Hello friends. Is there the limitation of 31 bytes for column names in the new FB 3? -- Atenciosamente, Hugo Eyng
Re: [firebird-support] FB on LAN
Hello Mark. I changed the firebird.conf by another one and restarted the server. Now my string connection 192.168.0.158:C:\DIR1\BASEDIR\MYDATABASE.FDB is working. I compared both firebird.conf and found two differences: 1) In the line near # Remove protection against opening databases on NFS mounted volumes on # Linux/Unix and SMB/CIFS volumes on Windows. that appears in original # ***WARNING*** ***WARNING*** ***WARNING*** ***WARNING*** in my firebird.conf the line was brioked, like # ***WARNING*** ***WARNING** * ***WARNING*** ***WARNING*** 2) There was difference in this line too, but the lines are commented. #CpuAffinityMask = 1 #CpuAffinityMask = 192 I am sure this could not cause problems, but the item 1 could? I think it is not pr Em 08/04/2016 04:12, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] escreveu: On 7-4-2016 20:54, Hugo Eyng hugoe...@msn.com [firebird-support] wrote: > Hello Mark. > > I was like you showed 192.168.0.158:C:\DIR1\BASEDIR\MYDATABASE.FDB > > Than I changed from FB 32 to FB 64 and it stopped working. After that, > after that even turnning to FB 32 it doesn´t work using this structure. > I only works > using \\192.168.0.158\C:\DIR1\BASEDIR\MYDATABASE.FDB or > C:\DIR1\BASEDIR\MYDATABASE.FDB In your first question your connection string was: 192.168.0.158:\DIR1\BASEDIR\MYDATABASE.FDB Note the absence of _C:_ This means you are connecting with a relative path. And the root of this path depends on the configuration (and maybe on the user running Firebird). > I open the 3050 port in FW. But it keep not connecting. I just realised that you never specified the exact error you received. Can't you connect to Firebird at all? What error do you get? In that case it might be that it is 1) configured to use a different port (setting RemoteServicePort), 2) is blocked by the (Windows) firewall (make sure there is an exclusion for the process), 3) another process is running on port 3050, or 4) the firebird process is only listening on 127.0.0.1 (setting RemoteBindAddress). Mark -- Mark Rotteveel -- Atenciosamente, Hugo Eyng
Re: [firebird-support] FB on LAN
Hello Mark. I changed the firebird.conf by another one and restarted the server. Now my string connection 192.168.0.158:C:\DIR1\BASEDIR\MYDATABASE.FDB is working. I compared both firebird.conf and found two differences: 1) In the line near # Remove protection against opening databases on NFS mounted volumes on # Linux/Unix and SMB/CIFS volumes on Windows. that appears in original # ***WARNING*** ***WARNING*** ***WARNING*** ***WARNING*** in my firebird.conf the line was wraped, like # ***WARNING*** ***WARNING** * ***WARNING*** ***WARNING*** Em 08/04/2016 04:12, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] escreveu: On 7-4-2016 20:54, Hugo Eyng hugoe...@msn.com [firebird-support] wrote: > Hello Mark. > > I was like you showed 192.168.0.158:C:\DIR1\BASEDIR\MYDATABASE.FDB > > Than I changed from FB 32 to FB 64 and it stopped working. After that, > after that even turnning to FB 32 it doesn´t work using this structure. > I only works > using \\192.168.0.158\C:\DIR1\BASEDIR\MYDATABASE.FDB or > C:\DIR1\BASEDIR\MYDATABASE.FDB In your first question your connection string was: 192.168.0.158:\DIR1\BASEDIR\MYDATABASE.FDB Note the absence of _C:_ This means you are connecting with a relative path. And the root of this path depends on the configuration (and maybe on the user running Firebird). > I open the 3050 port in FW. But it keep not connecting. I just realised that you never specified the exact error you received. Can't you connect to Firebird at all? What error do you get? In that case it might be that it is 1) configured to use a different port (setting RemoteServicePort), 2) is blocked by the (Windows) firewall (make sure there is an exclusion for the process), 3) another process is running on port 3050, or 4) the firebird process is only listening on 127.0.0.1 (setting RemoteBindAddress). Mark -- Mark Rotteveel -- Atenciosamente, Hugo Eyng
Re: [firebird-support] FB on LAN
Thank you Dimitry. I have this book. I will search. Bye Em 08/04/2016 10:29, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] escreveu: > 08.04.2016 15:17, Hugo Eyng hugoe...@msn.com [firebird-support] wrote: >> Do you know where could I find information about string connections and >> protocols? > In "The Firebird Book: a Reference for Database Developers", for example. > -- Atenciosamente, Hugo Eyng ++ 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 <*> 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: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] FB on LAN
Hello Mark. I changed the firebird.conf by another one and restarted the server. Now my string connection 192.168.0.158:C:\DIR1\BASEDIR\MYDATABASE.FDB is working. I compared both firebird.conf and found two differences: 1) In the line near # Remove protection against opening databases on NFS mounted volumes on # Linux/Unix and SMB/CIFS volumes on Windows. that appears in original # ***WARNING*** ***WARNING*** ***WARNING*** ***WARNING*** in my firebird.conf the line was brioked, like # ***WARNING*** ***WARNING** * ***WARNING*** ***WARNING*** 2) There was difference in this line too, but the lines are commented. #CpuAffinityMask = 1 #CpuAffinityMask = 192 I am sure this could not cause problems, but the item 1 could? I don´t think so. --- You told me something about using WNET protocol. Do you know where could I find information about string connections and protocols? Thank you for answering. Em 08/04/2016 04:12, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] escreveu: On 7-4-2016 20:54, Hugo Eyng hugoe...@msn.com [firebird-support] wrote: > Hello Mark. > > I was like you showed 192.168.0.158:C:\DIR1\BASEDIR\MYDATABASE.FDB > > Than I changed from FB 32 to FB 64 and it stopped working. After that, > after that even turnning to FB 32 it doesn´t work using this structure. > I only works > using \\192.168.0.158\C:\DIR1\BASEDIR\MYDATABASE.FDB or > C:\DIR1\BASEDIR\MYDATABASE.FDB In your first question your connection string was: 192.168.0.158:\DIR1\BASEDIR\MYDATABASE.FDB Note the absence of _C:_ This means you are connecting with a relative path. And the root of this path depends on the configuration (and maybe on the user running Firebird). > I open the 3050 port in FW. But it keep not connecting. I just realised that you never specified the exact error you received. Can't you connect to Firebird at all? What error do you get? In that case it might be that it is 1) configured to use a different port (setting RemoteServicePort), 2) is blocked by the (Windows) firewall (make sure there is an exclusion for the process), 3) another process is running on port 3050, or 4) the firebird process is only listening on 127.0.0.1 (setting RemoteBindAddress). Mark -- Mark Rotteveel -- Atenciosamente, Hugo Eyng
Re: [firebird-support] FB on LAN
Hello Mark. I was like you showed 192.168.0.158:C:\DIR1\BASEDIR\MYDATABASE.FDB Than I changed from FB 32 to FB 64 and it stopped working. After that, after that even turnning to FB 32 it doesn´t work using this structure. I only works using \\192.168.0.158\C:\DIR1\BASEDIR\MYDATABASE.FDB or C:\DIR1\BASEDIR\MYDATABASE.FDB I open the 3050 port in FW. But it keep not connecting. Hugo Em 07/04/2016 11:45, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] escreveu: On 2016-04-07 14:41, Hugo Eyng hugoe...@msn.com [firebird-support] wrote: > Hello. > > Thanks for answer my question. > > I changed the connection (Deplhi XE10 / DBX) to > \\192.168.0.158\C:\DIR1\BASEDIR\MYDATABASE.FDB and it works. With this change you are using a different protocol than you were using earlier. With this change you changed from the TCP/IP protocol to the WNET protocol, to continue to use the TCP/IP protocol, you should switch to: 192.168.0.158:C:\DIR1\BASEDIR\MYDATABASE.FDB Mark -- Atenciosamente, Hugo Eyng
Re: [firebird-support] test
Checked :) Em 07/04/2016 13:33, Z T Minhas ztmin...@yahoo.com [firebird-support] escreveu: Just checking -- Atenciosamente, Hugo Eyng
Re: [firebird-support] help to repair a corrupted database
Hi. Are you able to backup and restore the database instead of "gfixing"? Em 07/04/2016 12:28, korkl...@yahoo.it [firebird-support] escreveu: hi, i'm trying to repair a corrupted db for firebird 2.5.2, the database file is of about 30 gb. i have disconnected all the user, i did a copy of the file and then i executed the command gfix -validate 'dbname' with the credentials of the user that created the db (not the sysdba) now the gfix process is 90 minutes that is on 0 cpu usage and 1 mb of ram but the firebird process sometime works, is the gfix process freezed or it's normal? can i terminate it and retry or maybe this can add other problems to my database file? thanks -- Atenciosamente, Hugo Eyng
Re: [firebird-support] FB on LAN
Hello. Thanks for answer my question. I changed the connection (Deplhi XE10 / DBX) to \\192.168.0.158\C:\DIR1\BASEDIR\MYDATABASE.FDB and it works. Em 06/04/2016 18:21, 'Mark Rotteveel' m...@lawinegevaar.nl [firebird-support] escreveu: Have you checked the difference between the two Firebird.conf? You seem to be using relative paths to connect the database; I believe that depends on the RootDirectory setting. Mark - Bericht beantwoorden - Van: "Hugo Eyng hugoe...@msn.com [firebird-support]" <firebird-support@yahoogroups.com> Aan: <firebird-support@yahoogroups.com> Onderwerp: [firebird-support] FB on LAN Datum: wo, apr. 6, 2016 22:59 Hello. FB 2.5.5 32 bits SuperClassic installed on windows server 2008 Standard 64 bits Database: 192.168.0.158:\DIR1\BASEDIR\MYDATABASE.FDB working fine Then I changed to FB 2.5.5 64 bits SuperServer in the same server Database: 192.168.0.158:\DIR1\BASEDIR\MYDATABASE.FDB My connection to database stopped working. but Database: C:\DIR1\BASEDIR\MYDATABASE.FDB turned working Any hint? -- Atenciosamente, Hugo Eyng ++ Visithttp://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 athttp://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links -- Atenciosamente, Hugo Eyng
[firebird-support] FB on LAN
Hello. FB 2.5.5 32 bits SuperClassic installed on windows server 2008 Standard 64 bits Database: 192.168.0.158:\DIR1\BASEDIR\MYDATABASE.FDB working fine Then I changed to FB 2.5.5 64 bits SuperServer in the same server Database: 192.168.0.158:\DIR1\BASEDIR\MYDATABASE.FDB My connection to database stopped working. but Database: C:\DIR1\BASEDIR\MYDATABASE.FDB turned working Any hint? -- Atenciosamente, Hugo Eyng ++ 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 <*> 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: https://info.yahoo.com/legal/us/yahoo/utos/terms/
[firebird-support] Ascending and Descending Index
Hi. Is it possible to create an index like CREATE INDEX MYINDEX_IDX1 ON MYTABLE (COLUMN1 ASCENDING, COLUMN2 DESCENDING ) ? -- Atenciosamente, Hugo Eyng ++ 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 <*> 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: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] Gbak and indexes
Hello Ann. Very good. Thank you. Hugo Em 25/02/2016 13:47, Ann Harrison aharri...@ibphoenix.com [firebird-support] escreveu: Someone on a different forum asked whether gbak restores wouldn't be faster if gbak backed up indexes so it didn't have to rebuild them. The writer wanted the clean-up and compaction that a gbak backup and restore provides, but not the time spent retrieving records, sorting, and rebuilding indexes. There's a problem with that. An old index is of absolutely no use in a restored database exactly because records are in different places. The index contains the physical location of records. Change the location, invalidate the index. That's the short answer. The longer answer: An index contains a key value and a "record id" also called a db-key. When an index search finds an acceptable approximation of the value desired, it uses the db-key to find the corresponding record. (It's actually more complicated than that, and depends on whether the index is being used to optimize a sort, but in the end, an index search finds a db-key and uses it to find a record.) What's in a db-key? Three things: a pointer page sequence number, and offset into the pointer page, and an index offset on the data page. A pointer page is a part of the structure of a table that's not visible outside the database. It's simply a page that contains a vector of page numbers. Those page numbers belong to the data pages in the table. The RDB$PAGES table contains the sequence number and page number of pointer pages for all tables, among other things. After a table has been referenced, the pointer page information is kept in memory. The pointer page may be in cache or Firebird may need to read it from disk. With the pointer page in its virtual hand, Firebird reads the page number at the offset indicated by the db-key to get the page number of the appropriate data page and finds the data page in cache or on disk. The offset on the data page in the db-key is an indirect pointer to the record. Each data page has an index to the records on it containing the actual offset and length of the record, so a page can be reorganized without changing the db-keys of the records on it. A gbak restore creates a new database and populates it with the data it backed up from the old database. Records will be stored on different pages and at different offsets. Pages that were part of one table in the old database may be part of a different table or some other structure in the new database. Gbak restore could be made faster if Firebird recognized at a commit that the transaction created several indexes on the same table and built all the indexes in parallel rather than reading the table for each index, but using an old index in a new database is not a good idea. Good luck, Ann -- Atenciosamente, Hugo Eyng
Re: [firebird-support] Restoring Backup
Hello Ann. Thank you very much. The two hundred pages are not intended to be used for backup or restore purposes. In fact, I use the switche '-BU 20', in gbak -REP -c, to set the database cache pages option. This way I don´t need change the DefaultDbCachePages switche in the firebird.conf file. I am not sure that is the best way, but I did some tests and it worked fine. Hugo Em 24/02/2016 16:37, Ann Harrison aharri...@ibphoenix.com [firebird-support] escreveu: On Wed, Feb 24, 2016 at 12:01 PM, Hugo Eyng hugoe...@msn.com <mailto:hugoe...@msn.com> [firebird-support] <firebird-support@yahoogroups.com <mailto:firebird-support@yahoogroups.com>> wrote: Referring to the buffers requested for gbak: Why 12? Why not? :) There's a cost to managing a large buffer cache. Firebird will use the entire cache even if there's no particular reason to do so. A gbak backup needs a few dozen pages for system table stuff that's referenced frequently and for each table backed up another few pages that help locate data. The data pages are read once and then are of no more interest. So the default cache size is fine for a backup. Two hundred pages is probably enough to backup almost any database. If you use a huge cache, it will be filled with useless data pages. A gbak restore needs the same few dozen pages of system tables and some pages for internal table management. When it is restoring data, it fills a data page and goes on to the next one. A large cache will fill with pages that will not be referenced again until the indexes are built. To build indexes, Firebird reads records and sorts by keys. That might suggest that keeping millions of pages in cache would improve performance by eliminating disk reads. However, unless you've got a huge amount of memory, those data pages will reduce the amount of memory available for the sort. The sort algorithm produces chunks of sorted key/record id pairs which are subsequently merged. The more chunks that can be kept in memory, the faster the sort. If you've used all your machine's memory for the cache, the sort will be slow and may start paging. Good luck, Ann -- Atenciosamente, Hugo Eyng
Re: [firebird-support] Restoring Backup
Hello HB. It happens with 2.5.5 32 bit. I believe that the limitation is beacuse 20 x 16384 (page size) = 3GB greater than the avaliable amount of memory or greater than the 32bit engine is capable to manage. I am not sure. Why 12? Why not? :) Hugo Em 24/02/2016 00:09, Helen Borrie hele...@iinet.net.au [firebird-support] escreveu: Wednesday, February 24, 2016, 12:22:31 PM, Hugo Eyng wrote: > Hello. > I tried to restore a backup using the -BU 20 switch and gbak > returned an error message: invalid parameter. That is not a gbak message. If you are using a third-party tool, it is likely to be some limit imposed by that - or a bug? > Then I change the value 20 by 12 and gbak worked. > Is it a limitation? With Firebird 2.5.5 64-bit, I am able to execute this with no error: gbak -c -bu 80 h:\data\backups\backup20160131.fbk h:\data\restores\restored20160224.fdb -user sysdba -password xyxyxyxy (Although I cannot think why I would want such a huge number of pages in the cache, not even 12!!) HB -- Atenciosamente, Hugo Eyng
[firebird-support] Restoring Backup
Hello. I tried to restore a backup using the -BU 20 switch and gbak returned an error message: invalid parameter. Then I change the value 20 by 12 and gbak worked. Is it a limitation? switches -- Atenciosamente, Hugo Eyng ++ 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 <*> 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: https://info.yahoo.com/legal/us/yahoo/utos/terms/
[firebird-support] FirebridSQL and Log´s
Hello Friends. I am thinking about the better/faster/easier way to log changes made in records on the tables of my DB. Could someone share experience (good or bad)? Any suggestion? -- Atenciosamente, Hugo Eyng ++ 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 <*> 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: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] CPU Affinity
Hi Mark. Thanks for your answer. My reasoning was that more cores to process , more performance . However , in the light of your explanation I changed my way of thinking. Do you see any difference between using Classic Server and SuperClassic , except number of processes? Em 19/01/2016 19:14, 'Mark Rotteveel' m...@lawinegevaar.nl [firebird-support] escreveu: Setting the cpu affinity to target more than one cpu will usually be worse for performance, as SuperServer is essentially single threaded and allowing it to run on multiple cores will cause expensive rescheduling. SuperServer may perform better than Classic because CS has a smaller page buffer by default, and the synchronisation between processes is more expensive than in-process. The scale however will usually tip in favor of classic when using a large number of connections, as SuperServer will eventually be limited by how much it can do in its single thread. Mark - Reply message - Van: "Hugo Eyng hugoe...@msn.com [firebird-support]" <firebird-support@yahoogroups.com> Aan: <firebird-support@yahoogroups.com> Onderwerp: [firebird-support] CPU Affinity Datum: di, jan. 19, 2016 21:01 Hi Thomas. Thanks for your answer. I use SuperServer. Why? Performance. It seems to run faster. Hugo Em 19/01/2016 12:21, 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support] escreveu: Hi! > Dear Friends. > > FirebirdSQL : 2.5.5 64bits > Operating System: Windows 2008 R2 Enterprise 64bits > Server : Dell Poweredge R620 > 32GB > 2 processors E5-2609 2.40 GHz > 8 Cores > > To define CPU Affinity in firebird.conf I set CPUAffinity to 255, in a > way to use all the 8 cores. Which Firebird server architecture are you using? CPU affinity is only for SuperServer and the question is why do you bother with SuperServer on a multi-core machine when there is Classic or SuperClassic available? -- With regards, Thomas Steinmaurer http://www.upscene.com Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc. > Does it make sense or could be better to use less cores, like core > 5,6,7,8 or 3,4,5,6? > > -- > > > Atenciosamente, > > Hugo Eyng > > > > > > > > ++ > > 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 > > > -- Atenciosamente, Hugo Eyng -- Atenciosamente, Hugo Eyng
Re: [firebird-support] CPU Affinity
Hi Thomas. Thanks for your answer. I use SuperServer. Why? Performance. It seems to run faster. Hugo Em 19/01/2016 12:21, 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support] escreveu: Hi! > Dear Friends. > > FirebirdSQL : 2.5.5 64bits > Operating System: Windows 2008 R2 Enterprise 64bits > Server : Dell Poweredge R620 > 32GB > 2 processors E5-2609 2.40 GHz > 8 Cores > > To define CPU Affinity in firebird.conf I set CPUAffinity to 255, in a > way to use all the 8 cores. Which Firebird server architecture are you using? CPU affinity is only for SuperServer and the question is why do you bother with SuperServer on a multi-core machine when there is Classic or SuperClassic available? -- With regards, Thomas Steinmaurer http://www.upscene.com Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc. > Does it make sense or could be better to use less cores, like core > 5,6,7,8 or 3,4,5,6? > > -- > > > Atenciosamente, > > Hugo Eyng > > > > > > > > ++ > > 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 > > > -- Atenciosamente, Hugo Eyng
[firebird-support] CPU Affinity
Dear Friends. FirebirdSQL: 2.5.5 64bits Operating System: Windows 2008 R2 Enterprise 64bits Server: Dell Poweredge R620 32GB 2 processors E5-2609 2.40 GHz 8 Cores To define CPU Affinity in firebird.conf I set CPUAffinity to 255, in a way to use all the 8 cores. Does it make sense or could be better to use less cores, like core 5,6,7,8 or 3,4,5,6? -- Atenciosamente, Hugo Eyng ++ 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 <*> 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: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] Firebird Download Malware
Hello. I reported it to Microsoft team, hoping they can help. Em 05/01/2016 10:57, Alexey Kovyazin a...@ib-aid.com [firebird-support] escreveu: Hi, >The following file is affected: >http://sourceforge.net/projects/firebird/files/firebird-win64/2.5.5-Release/Firebird-2.5.5.26952_0_x64.exe/download I can confirm that Security Essential also reported this exe as Trojan.Win32/Varpes.J!plock Regards, Alexey Kovyazin IBSurgeon HQbird www.ib-aid.com The following file is affected: http://sourceforge.net/projects/firebird/files/firebird-win64/2.5.5-Release/Firebird-2.5.5.26952_0_x64.exe/download This seems to be a false alarm though. According to Virustotal, 54 different scan engines say the file is clean: https://www.virustotal.com/de/file/e4ce70fd1be17b07fd26554ef322ee14f65fef8d398aaa707df115530aa0f410/analysis/ Funnily, the Microsoft scan engine at Virustotal also considers it as clean. Cheers, Christian -- Atenciosamente, Hugo Eyng
Re: [firebird-support] Firebird Download Malware
Hello. I tried Firebird 2.5.4 download and the problem does not happen. The 32 bits version download of FB 2.5.5 is "clean" too. Em 04/01/2016 06:04, Thomas Steinmaurer t...@iblogmanager.com [firebird-support] escreveu: >>> I downloaded FB 2.5.5 from firebirdsql and my Microsoft Essentials >>> detected it as a malware. >> I am facing the same problem. >> The following file is affected: >> http://sourceforge.net/projects/firebird/files/firebird-win64/2.5.5-Release/Firebird-2.5.5.26952_0_x64.exe/download >> >> This seems to be a false alarm though. >> According to Virustotal, 54 different scan engines say the file is >> clean: >> https://www.virustotal.com/de/file/e4ce70fd1be17b07fd26554ef322ee14f65fef8d398aaa707df115530aa0f410/analysis/ >> >> Funnily, the Microsoft scan engine at Virustotal also considers it as >> clean. > Avira Antivir locally does not report anything suspicious. > > > -- Atenciosamente, Hugo Eyng ++ 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 <*> 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: https://info.yahoo.com/legal/us/yahoo/utos/terms/
[firebird-support] Firebird Download Malware
Hello. I downloaded FB 2.5.5 from firebirdsql and my Microsoft Essentials detected it as a malware. Did anybody face the same problem? -- Atenciosamente, Hugo Eyng ++ 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 <*> 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: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] FB lock files
Hi Rudi. Look at this http://www.janus-software.com/fbmanual/manual.php?book=admin=23 Consider to change DefaultDbCachePages in firebird.conf. You should read about this, because it depends if you use super server, classic or super classic. DatabaseGrowthIncrement is a parameter that can affect the database performance too. Hugo Eyng Em 07/12/2015 16:52, Rudi Feijó rudi.fe...@multidadosti.com.br [firebird-support] escreveu: I noticed our biggest data server have a lot of hard disk activity creating fb_lock files. Firebird 2.5.4, superclassic My changed lock configurations are : #LockMemSize = 1048576 LockMemSize = 10097152 #LockHashSlots = 1009 LockHashSlots = 60589 Should I try to set them higher? If so, whats a good parameter to know by how much I should increase it? -- Atenciosamente, Hugo Eyng
[firebird-support] Firebird 3 and Gbak
Hello. I am trying to use my application while gbak makes backup, but a message is raised 'File alredy in use by another'. Running on Vista. -- Atenciosamente, Hugo Eyng ++ 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 * 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: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] Firebird 3 and Gbak
Hello. The message is 'File already in use by another process' Em 16/07/2015 14:49, Hugo Eyng hugoe...@msn.com [firebird-support] escreveu: Hello. I am trying to use my application while gbak makes backup, but a message is raised 'File alredy in use by another'. Running on Vista. -- Atenciosamente, Hugo Eyng ++ 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 * 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: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] Memory usage excess / leak in FBServer 2.5.4
Hello. Did you look de settings in firebird.conf? DefaultDbCachePages for example... On 28/05/2015 10:24, 'Jojakim Stahl' joja.li...@jojakim.de [firebird-support] wrote: Hello, I'm facing a problem where the firebird server v2.5.4 on win 2012 server in superserver mode is leaking memory. Currently I'm at ~5GB usage. Don't have any idea how to track down the problem. Thanks for any advice. -- joja select * from mon$memory_usage where mon$stat_group=0; MON$STAT_ID 1 MON$STAT_GROUP 0 MON$MEMORY_USED 4570256632 MON$MEMORY_ALLOCATED 5314478080 MON$MAX_MEMORY_USED 4570448304 MON$MAX_MEMORY_ALLOCATED 5314678784 select * from mon$database; MON$DATABASE_NAME D:\P2_DB\FIREBIRD\DBA9627.FDB MON$PAGE_SIZE 8192 MON$ODS_MAJOR 11 MON$ODS_MINOR 2 MON$OLDEST_TRANSACTION 35186254 MON$OLDEST_ACTIVE 35186255 MON$OLDEST_SNAPSHOT 35186255 MON$NEXT_TRANSACTION 35187662 MON$PAGE_BUFFERS 16384 MON$SQL_DIALECT 3 MON$SHUTDOWN_MODE 0 MON$SWEEP_INTERVAL 2 MON$READ_ONLY 0 MON$FORCED_WRITES 1 MON$RESERVE_SPACE 1 MON$CREATION_DATE 2015-04-15 08:58:37.1050 MON$PAGES 250031 MON$STAT_ID 1 MON$BACKUP_STATE 0 show version; ISQL Version: WI-V2.5.4.26856 Firebird 2.5 Server version: Firebird/x86-64/Windows NT (access method), version WI-V2.5.4.26856 Firebird 2.5 Firebird/x86-64/Windows NT (remote server), version WI-V2.5.4.26856 Firebird 2.5/tcp (SV-W12-L900)/P12 Firebird/x86-64/Windows NT (remote interface), version WI-V2.5.4.26856 Firebird 2.5/tcp (SV-W12-L900)/P12 on disk structure version 11.2 -- Atenciosamente, Hugo Eyng
Re: [firebird-support] Re: Backup Restore NOT NULL Columns
Hello Dimitry. I thought I was testing in FB 3.0, but I wasn´t. I am sorry. I tried FB 3.0 now and _*it really raises*_ and error at step 1. Then I use DEFAULT clause and it works like I expected. Thanks for your answer. Hugo On 26/05/2015 03:08, Dmitry Yemanov dim...@users.sourceforge.net [firebird-support] wrote: 25.05.2015 17:43, Hugo Eyng hugoe...@msn.com wrote: 1 - I created a column NOT NUL in a table (ALTER TABLE MYTABLE ADD NEW_COLUMN INTEGER NOT NULL). There were already some records in the table. FB didn´t raise any warning or exception. 2 - I created a backup file from MYDB.FDB using gbak. FB didn´t raise any warning or exception. 3- I tried to restore the backup file to a new MYDB.FDB and FB raises and error: gbak: ERROR:validation error for column NAME, value *** null *** Let´s accept than the step 3 is coherent. So, why can I execute step 1 without troubles? I am using FB 2.5 and I tried using FB 3.0 too. Did you really try FB 3.0? It should raise an error at step 1. Dmitry ++ 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 -- Atenciosamente, Hugo Eyng
Re: [firebird-support] Backup Restore NOT NULL Columns
Hello Thomas. Please see my answer to Dimitry. Thanks for your answer. Hugo On 26/05/2015 02:53, 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support] wrote: Hugo, Hello. 1 - I created a column NOT NUL in a table (ALTER TABLE MYTABLE ADD NEW_COLUMN INTEGER NOT NULL). There were already some records in the table. FB didn´t raise any warning or exception. 2 - I created a backup file from MYDB.FDB using gbak. FB didn´t raise any warning or exception. 3- I tried to restore the backup file to a new MYDB.FDB and FB raises and error: gbak: ERROR:validation error for column NAME, value *** null *** Let´s accept than the step 3 is coherent. So, why can I execute step 1 without troubles? Well, someone can tell me to use -no_validity to restore the database. Ok, it works. But, the column that should be NOT NULL will change, without warning, and I have to check my tables after restoring DB. I am using FB 2.5 and I tried using FB 3.0 too. Is it as I described or there is another way to treat this? http://tracker.firebirdsql.org/browse/CORE-1748 See Dmitry's InterBase legacy comment. I for one would simply reject adding new NOT NULL fields on a table with data if there is no DEFAULT clause provided. -- With regards, Thomas Steinmaurer http://www.upscene.com Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc. -- Atenciosamente, Hugo Eyng
Re: [firebird-support] Backup Restore NOT NULL Columns
Hello Thomas. I saw Dimtry´s comment. About the DEFAULT CLAUSE, even provided, it acts only on new rows and not on preexisting rows. Is this true? Hugo On 26/05/2015 02:53, 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support] wrote: Hugo, Hello. 1 - I created a column NOT NUL in a table (ALTER TABLE MYTABLE ADD NEW_COLUMN INTEGER NOT NULL). There were already some records in the table. FB didn´t raise any warning or exception. 2 - I created a backup file from MYDB.FDB using gbak. FB didn´t raise any warning or exception. 3- I tried to restore the backup file to a new MYDB.FDB and FB raises and error: gbak: ERROR:validation error for column NAME, value *** null *** Let´s accept than the step 3 is coherent. So, why can I execute step 1 without troubles? Well, someone can tell me to use -no_validity to restore the database. Ok, it works. But, the column that should be NOT NULL will change, without warning, and I have to check my tables after restoring DB. I am using FB 2.5 and I tried using FB 3.0 too. Is it as I described or there is another way to treat this? http://tracker.firebirdsql.org/browse/CORE-1748 See Dmitry's InterBase legacy comment. I for one would simply reject adding new NOT NULL fields on a table with data if there is no DEFAULT clause provided. -- With regards, Thomas Steinmaurer http://www.upscene.com Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc. -- Atenciosamente, Hugo Eyng
[firebird-support] Backup Restore NOT NULL Columns
Hello. 1 - I created a column NOT NUL in a table (ALTER TABLE MYTABLE ADD NEW_COLUMN INTEGER NOT NULL). There were already some records in the table. FB didn´t raise any warning or exception. 2 - I created a backup file from MYDB.FDB using gbak. FB didn´t raise any warning or exception. 3- I tried to restore the backup file to a new MYDB.FDB and FB raises and error: gbak: ERROR:validation error for column NAME, value *** null *** Let´s accept than the step 3 is coherent. So, why can I execute step 1 without troubles? Well, someone can tell me to use -no_validity to restore the database. Ok, it works. But, the column that should be NOT NULL will change, without warning, and I have to check my tables after restoring DB. I am using FB 2.5 and I tried using FB 3.0 too. Is it as I described or there is another way to treat this? -- Atenciosamente, Hugo Eyng ++ 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 * 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: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] Re: Firebird Android
Hello. On the options I saw, Web service seems to me the best choice. Hugo On 16/01/2015 12:09, craig_...@coxcolvin.com [firebird-support] wrote: I am facing the exact same issue with an app I want to develop. Is there a place you can point me to to learn more about the options and how to implement them? I recognize the issues presented, just not sure what the best approach is to solving them . -- Atenciosamente, Hugo Eyng
[firebird-support] Firebird Android
Hello. I will develop an App for Android and I want to conect FB running on windows. Did somebody tried doing this? Some hint, article or information about how can I implement that? Driver? -- Atenciosamente, Hugo Eyng ++ 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 * 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: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] Firebird 3.0 Development Admin Tools
Hello. IBExpert. Hugo On 15/01/2015 12:01, christoph.gas...@stranto.com [firebird-support] wrote: Hi, I've to develop a new application which will be launched not before end of year. So I thought it's best to go for the 3.0 release (still in Beta, I know). But till the end of the year I assume 3.0 will be launched. Nevertheless: I need a tool to maintain / develop the database. In the past I used sql manager for interbase firebird. But it's not supporting 3.0 yet. Any advice, which tools are able to handle 3.0 databases? BR Christoph -- Atenciosamente, Hugo Eyng
Re: [firebird-support] Bad surprise on performance
++ 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 ++ 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 -- Atenciosamente, Hugo Eyng ++ 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 * 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: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] Deadlock exception occurs but it shouldn't?
Hi.
You should 'lock' the record you are working with.
Did you read about 'with lock'?
I am not sure this will help you in this case, but
Hugo
On 24/12/2014 06:22, brucedickin...@wp.pl [firebird-support] wrote:
Hi,
I have a very simple table:
CREATE TABLE PARAMS
(
ID INTEGER NOT NULL,
NAME VARCHAR(32) NOT NULL,
CONSTRAINT PK_PARAMS PRIMARY KEY (ID),
CONSTRAINT UNQ_PARAMS UNIQUE (NAME)
);
I have two threads which constantly and at the same time are writing
to this table:
UPDATE OR INSERT INTO PARAMS (NAME) VALUES(:P_NAME) MATCHING (NAME)
RETURNING ID;
I've set my transaction parameters like this:
FtraMain.TRParams.Add('isc_tpb_write');
FtraMain.TRParams.Add('isc_tpb_read_committed');
FtraMain.TRParams.Add('isc_tpb_wait');
FtraMain.TRParams.Add('isc_tpb_no_rec_version');
As far as I understand, such configuration should prevent deadlock
exception to occur. However, deadlock still occurs from time to time:
Deadlock.
Deadlock.
Update conflicts with concurrent update.
Concurrent transaction number is 57258.
What am I doing wrong?
Thans for your assistance :)
--
Atenciosamente,
Hugo Eyng
Re: [firebird-support] Re: FB 3.0 Multiuser Environment
Thank you Dmitry. I will try better tests. Hugo Eyng Em 22/12/2014 16:53, Dmitry Yemanov dim...@users.sourceforge.net [firebird-support] escreveu: 22.12.2014 21:18, Hugo Eyng wrote: I added the settings SharedDatabase = true and SharedCache = false like you told and everything worked fine. Shouldn´t those settings be present in firebird.conf? I had to add them manually. They do exist in v3 firebird.conf, be it official Beta or snapshot builds. Currently I am using FB 2.5.3 and 60 simultaneous connections. Than I ask: should I use SuperServer? This is up to you. SuperServer in v3 is expected to perform better under concurrent load, single-user tests will never show that. I'd say it's worth testing in more realistic environment. Dmitry ++ 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 -- Atenciosamente, Hugo Eyng ++ 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 * 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: https://info.yahoo.com/legal/us/yahoo/utos/terms/
[firebird-support] FB 3.0 SQL Error.
Hello Friends. In FB 3.0.0 I received the error message: Name longer than database column size. SELECT I.CD_TIPO_MOVIMENTO_ESTOQUE *AS* CD_TIPO_MOVIMENTO_ESTOQUE_COMPRA FROM MyTable CD_TIPO_MOVIMENTO_ESTOQUE_COMPRA (31 characters large) Ok. I Understood the message. My column has more than 30 characters. But, in FB 2.5 , a column larger than 30 characters was truncated or replaced by a number at the end of the column name. CD_TIPO_MOVIMENTO_ESTOQUE_COMPRA -CD_TIPO_MOVIMENTO_ESTOQUE_COMPR or CD_TIPO_MOVIMENTO_ESTOQUE_COMPRA - CD_TIPO_MOVIMENTO_ESTOQUE_COMP1 to avoid duplication field. Is there some kind of setting that cause FB 3.0.0 acting like FB 2.5 in this situation? -- Atenciosamente, Hugo Eyng
Re: [firebird-support] FB 3.0 SQL Error.
Hi Helen. I am testing FB 3.0.0 but I use FB 2.5.3, that is why some question are about 2.5.3. Thanks. On 23/12/2014 16:36, Helen Borrie hele...@iinet.net.au [firebird-support] wrote: Hugo, At 06:25 a.m. 24/12/2014, Hugo Eyng hugoe...@msn.com [firebird-support] wrote: Hello Friends. In FB 3.0.0 I received the error message: Name longer than database column size. Would you please use the firebird-devel or firebird-test list for questions about Fb 3? This support list is for released versions only. Thanks, ^heLen^ -- Atenciosamente, Hugo Eyng
Re: [firebird-support] Re: FB 3.0 Multiuser Environment
Hello Dmitry Thank you for your answer. I added the settings SharedDatabase = true and SharedCache = false like you told and everything worked fine. Shouldn´t those settings be present in firebird.conf? I had to add them manually. About your question 'why not superserver', I performed two simple tests to measure FB performance, running in the environment that I described. Just one user (me) was connected to the server and no other significant process was running. With these tests, of course, I don´t intended to give the 'final solution' about FB performace. They are simple tests only. I believe better tests could be more illustrative, like processes running at the same time and concurrently, but ... The test: I performed the tests in FB 2.5.3 and FB 3.0.0 First test:I restored the DB from a 'fbk' file. Second test: I runned a very hard SQL sentence using IBExpert. This is what I saw: +--+---++--+ Firebird 2.5.3 :DEFAULT DBCACHEPAGES : Restoring : SQL: +--+---++--+ SuperClassic4500 21:30 minutes:02:43 minutes: +--+--+-+--+ Classic 4500 30:02 minutes: 02:45 minutes : +--+--+-+--+ SuperServer122880 32:01 minutes: after 07:50 minutes crashed out of resources: +--+--+-+--+ +--+---++--+ Firebird 3.0.0 :DEFAULT DBCACHEPAGES : Restoring : SQL : +--+---++--+ Classic : 4500: 15:20 minutes: 03:05 minutes : +--+--+-+--+ SuperServer:32768 : 15:48 minutes :02:49 minutes : +--+--+-+--+ Currently I am using FB 2.5.3 and 60 simultaneous connections. Than I ask: should I use SuperServer? Hugo Em 20/12/2014 07:29, Dmitry Yemanov dim...@users.sourceforge.net [firebird-support] escreveu: 19.12.2014 23:30, Hugo Eyng hugoe...@msn.com [firebird-support] wrote: I am testing FB 3.0.0.31374 BETA. Instalation Classic Out of curiosity, why not SuperServer? When I try to open the database in a second session I get the error message: Servidor de banco de dados não foi encontrado! *(Database server not found)* I/O error during CreateFile (open) operation for file C:\TEXTIL\DADOS\DM\SGBT\DADOS\DATAMAIS.FDB *(Entire path for my database)* Error while trying to open file O arquivo já está sendo usado por outro processo. *(File is in use by another process) * Check your firebird.conf, for Classic it should have settings SharedDatabase = true and SharedCache = false. Dmitry ++ 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 -- Atenciosamente, Hugo Eyng ++ 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 * 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
[firebird-support] FB 3.0 Multiuser Environment
Hello. I am testing FB 3.0.0.31374 BETA. Instalation Classic Database size 4 gigabytes Delphi 2007 Windows 2008 Server Enterprise Edition 32 bits 16 gigabytes RAM 800 gigabytes HD Raid 10 When I try to open the database in a second session I get the error message: Servidor de banco de dados não foi encontrado! *(Database server not found)* I/O error during CreateFile (open) operation for file C:\TEXTIL\DADOS\DM\SGBT\DADOS\DATAMAIS.FDB *(Entire path for my database)* Error while trying to open file O arquivo já está sendo usado por outro processo. *(File is in use by another process) * So my application cannot be opened by two or more users. Even using IBExpert, I cannot open the same database more than one time. Did anybody faced this situation? -- Atenciosamente, Hugo Eyng
Re: [firebird-support] Re: object is in use
Hello. Sorry, but I didn´t, yet, understand why I can´t exceute an ALTER PROCEDURE without _*closing all conections and restarting the FB service.*__* *_ I guess that the problem could be related to my application leaving some transaction, that uses the SP, without commit/rollback or something so. But I am not sure. Win 2008 R2 enterprise 64bits Dell PowerEdge R620 32gb RAM FB 2.5.2 SuperClassic I notice that i am not the only one facing this trouble: http://tracker.firebirdsql.org/browse/CORE-3108 Using and WAIT or NO WAIT Transaction, in my opinion, is not the answer, or at least no the best answer. I tried to find 'who' or 'what' is using the STORED PROCEDURE while I am trying to excecute the ALTER, but I was not able to do it. Hugo Em 19/08/2014 06:03, Dmitry Yemanov dim...@users.sourceforge.net [firebird-support] escreveu: 18.08.2014 23:39, 'Carlos H. Cantu' wrote: LSSBcfs While this would avoid the error, you will not know when/if your change will be applied. LSSBcfs A connection can hold an object in use for an indeterminant period of time. Dmitry said to me sometime ago that procedures changes will be executed immediately and not get held. I tested and seems to be true (ie: wait behavior is different for such case). It's not about when your DDL is applied but about the cached procedure BLR that is used by others. The changed (new) procedure BLR will be used by newly compiled statements immediately after your DDL has been executed. However, all already compiled statements will keep using the old procedure BLR until these statements are released. So Sean is correct except that holding an object applies to particular statements, not a connection as a whole. Dmitry ++ 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 -- Atenciosamente, Hugo Eyng
[firebird-support] object is in use
Hello. IBExpert shows the message: lock conflict on no wait transaction unsuccessful metada update object MY_PROCEDURE is in use How can I see 'who' is using the procedure? -- Atenciosamente, Hugo Eyng
Re: [firebird-support] object is in use
Hi Carlos. Where do I chage it? Hugo Em 18/08/2014 15:06, 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support] escreveu: To avoid such error, try to change the DDL transaction parameter to WAIT instead of NO WAIT. Carlos Firebird Performance in Detail - http://videos.firebirddevelopersday.com www.firebirdnews.org - www.FireBase.com.br HEhmcfs Hello. HEhmcfs IBExpert shows the message: HEhmcfs lock conflict on no wait transaction HEhmcfs unsuccessful metada update HEhmcfs object MY_PROCEDURE is in use HEhmcfs How can I see 'who' is using the procedure? -- Atenciosamente, Hugo Eyng
Re: [firebird-support] object is in use
I agree Em 18/08/2014 16:29, 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support] escreveu: To avoid such error, try to change the DDL transaction parameter to WAIT instead of NO WAIT. While this would avoid the error, you will not know when/if your change will be applied. A connection can hold an object in use for an indeterminant period of time. For me, I want to know that the change will apply/has been made, if not, I will track down the source of the problem... and then re-run. Sean -- Atenciosamente, Hugo Eyng
Re: [firebird-support] object is in use
Hello Carlos. Thanks. I am using IBExpert to run an 'CREATE OR ALTER PROCEDURE MY_PROCEDURE. That´s why I am not understending what can avoid to execute this. This PROCEDURE just returns a value from a table. I should be able to drop and insert a PROCEDURE at anytime into the DB. Should not I? Em 18/08/2014 16:40, 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support] escreveu: When you start a transaction you determine the wait mode. Where you set this depends on the component/access technology you are using. Carlos Firebird Performance in Detail - http://videos.firebirddevelopersday.com www.firebirdnews.org http://www.firebirdnews.org- www.FireBase.com.br http://www.FireBase.com.br Hi Carlos. Where do I chage it? Hugo Em 18/08/2014 15:06, 'Carlos H. Cantu' lis...@warmboot.com.br mailto:lis...@warmboot.com.br[firebird-support] escreveu: To avoid such error, try to change the DDL transaction parameter to WAIT instead of NO WAIT. Carlos Firebird Performance in Detail - http://videos.firebirddevelopersday.com www.firebirdnews.org http://www.firebirdnews.org- www.FireBase.com.br http://www.FireBase.com.br HEhmcfs Hello. HEhmcfs IBExpert shows the message: HEhmcfs lock conflict on no wait transaction HEhmcfs unsuccessful metada update HEhmcfs object MY_PROCEDURE is in use HEhmcfs How can I see 'who' is using the procedure? -- Atenciosamente, Hugo Eyng -- Atenciosamente, Hugo Eyng
Re: [firebird-support] object is in use
Doesn´t work. The only way I found to alter a stored procedure in FB 2.5.2 , windows 64, SuperClassic is closing all conections and restarting the FB service. Hugo Em 18/08/2014 16:55, 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support] escreveu: Try to set the DDL transaction mode in Expert to WAIT instead of NO WAIT and see what happens. Carlos Firebird Performance in Detail - http://videos.firebirddevelopersday.com www.firebirdnews.org http://www.firebirdnews.org- www.FireBase.com.br http://www.FireBase.com.br Hello Carlos. Thanks. I am using IBExpert to run an 'CREATE OR ALTER PROCEDURE MY_PROCEDURE. That´s why I am not understending what can avoid to execute this. This PROCEDURE just returns a value from a table. I should be able to drop and insert a PROCEDURE at anytime into the DB. Should not I? Em 18/08/2014 16:40, 'Carlos H. Cantu' lis...@warmboot.com.br mailto:lis...@warmboot.com.br[firebird-support] escreveu: When you start a transaction you determine the wait mode. Where you set this depends on the component/access technology you are using. Carlos Firebird Performance in Detail - http://videos.firebirddevelopersday.com www.firebirdnews.org http://www.firebirdnews.org- www.FireBase.com.br http://www.FireBase.com.br Hi Carlos. Where do I chage it? Hugo Em 18/08/2014 15:06, 'Carlos H. Cantu' lis...@warmboot.com.br mailto:lis...@warmboot.com.br[firebird-support] escreveu: To avoid such error, try to change the DDL transaction parameter to WAIT instead of NO WAIT. Carlos Firebird Performance in Detail - http://videos.firebirddevelopersday.com www.firebirdnews.org http://www.firebirdnews.org- www.FireBase.com.br http://www.FireBase.com.br HEhmcfs Hello. HEhmcfs IBExpert shows the message: HEhmcfs lock conflict on no wait transaction HEhmcfs unsuccessful metada update HEhmcfs object MY_PROCEDURE is in use HEhmcfs How can I see 'who' is using the procedure? -- Atenciosamente, Hugo Eyng -- Atenciosamente, Hugo Eyng -- Atenciosamente, Hugo Eyng
[firebird-support] Triggers
Hello. Is it possible to change/delete a trigger while it´s in use? -- Atenciosamente, Hugo Eyng
Re: [firebird-support] Updating Firebird
Thank you. Em 20/05/2014 15:32, 'H. S.' hassansha...@yahoo.com [firebird-support] escreveu: Hi 1 backup your database 2 uninstall old version 3 install last version 4 restor your database Sent from Yahoo! Mail on Android *From: * Hugo Eyng hugoe...@msn.com [firebird-support] firebird-support@yahoogroups.com; *To: * firebird-support@yahoogroups.com; *Subject: * [firebird-support] Updating Firebird *Sent: * Tue, May 20, 2014 6:26:55 PM Hello. I want to update Firebird from 2.5.2.26539 to 2.5.2.26540. Should I close all databases and stop de Firebird server? -- Atenciosamente, Hugo Eyng -- Atenciosamente, Hugo Eyng
Re: [firebird-support] Updating Firebird
Thank you for the answers. What libraries should I update? Hugo Em 20/05/2014 16:45, Helen Borrie hele...@iinet.net.au [firebird-support] escreveu: At 06:26 a.m. 21/05/2014, Hugo Eyng hugoe...@msn.com [firebird-support] wrote: Hello. I want to update Firebird from 2.5.2.26539 to 2.5.2.26540. Should I close all databases and stop de Firebird server? Yes, of course. You will be changing the code that is running for the server. and for the client applications Although this update does not change the on-disk structure (ODS) of databases it creates, it would be a desirable precaution to back up the databases before you install the update. Check that the backups are good before proceeding. Don't forget to update the client libraries. Helen Borrie, Support Consultant, IBPhoenix (Pacific) Author of The Firebird Book and The Firebird Book Second Edition http://www.firebird-books.net __ -- Atenciosamente, Hugo Eyng
[firebird-support] Updating Firebird
Hello. I want to update Firebird from 2.5.2.26539 to 2.5.2.26540. Should I close all databases and stop de Firebird server? -- Atenciosamente, Hugo Eyng
[firebird-support] What is the Newest Firebird Release
Hello. At http://www.firebirdsql.org/en/downloads the available release of Firebird to download is 2.5.2. Somebody mentioned a 2.5.3 release. Is there a 2.5.3 release? I exist, where can I download it? -- Atenciosamente, Hugo Eyng
Re: [firebird-support] Table information
Hi. It will be usefull. Thanks. Hugo Eyng Em 11/03/2014 19:38, liviusliv...@poczta.onet.pl escreveu: Hi, look at my FAQ about last table modification time there is described another solution for this problem it work on generators - use it if you like it http://itstop.pl/en-en/Porady/Firebird/FAQ1/TABLE-MODIFICATION-TIMESTAMP regards, Karol Bieniaszewski From: Hugo Eyng Sent: Tuesday, March 11, 2014 1:10 AM To: firebird-support@yahoogroups.com Subject: [firebird-support] Table information Hello. Is there a way to get information like last time the table was updated/changed, the size in bytes of the table, how much records are save in the table? -- Atenciosamente, Hugo Eyng --- Ta wiadomość e-mail jest wolna od wirusów i złośliwego oprogramowania, ponieważ ochrona avast! Antivirus jest aktywna. http://www.avast.com [Non-text portions of this message have been removed] -- Atenciosamente, Hugo Eyng
[firebird-support] Table information
Hello. Is there a way to get information like last time the table was updated/changed, the size in bytes of the table, how much records are save in the table? -- Atenciosamente, Hugo Eyng
Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2
Hello. You are not the only one having these problems. I am facing exactly the same problem and nobody could help me in an efective way. Hugo Em 16/02/2014 09:15, Roland Turcan escreveu: Hello all again, I have met more computers with Windows 2008 R2 64bit where the performance is very bad. I was importing into database about 80 GB files into tables with blob fields I had to use for server casual Windows 7 32bit computer to get it done on time. How can it be, that Intel i3 with 4GB RAM 32bit is 6 times faster that multi CPU Xeon server. Every core was 100% busy when executing SQL statements. Of course I set all recommendation in database and firebird.conf but the server is still relaxing. Actually I am working with database about 35GB and again the same problem with bad performance. I am using Classic server 2.5.2 with DBCachePages = 1024 (in DV and firebird.conf) and FileSystemCacheSize = 20, but the CPU is having holiday. I don't believe that I am the only one having these problems. Help me please to force the performance. Best regards, Roland Turcan 23.01.2014 19:23 - Hugo Eyng hugoe...@msn.com I use SuperClassic and seted the DefaultDbCachePages = 2250 The Default value is 75 Than I used a multiple of 75 The amount of memory used by FB service increases a lot and the performance increases too Em 23/01/2014 02:52, Alexey Kovyazin escreveu: Hi Roland, I have tried to change this parameter (actually =20), but I don't see any change. 20? It is below all meaningful values. If you are using SuperServer, set 1, if Classic or SuperClassic, set 1024, and _restart_ Firebird. What else can I test? If you are interested in professional optimization (http://ib-aid.com/services/optimization), contact our support. Regards, Alexey Kovyazin www.IBSurgeon.com http://www.IBSurgeon.com AFAIK, the parameter DefaultDbCachePages is intended for newly created databases as default size of cache pages. It doesn't have effect on existing databases where its own setting is used. Every database can have own setting about count of cache pages. It seems to be still not solving this problem using by FileSystemCacheSize. What else can I test? Thanks. 22.01.2014 15:05 - Hugo Eyng hugoe...@msn.com mailto:hugoe...@msn.com Try changing values for DefaultDbCachePages Em 21/01/2014 18:40, Roland Turcan escreveu: I have tried to change this parameter (actually =20), but I don't see any change. My server box is: Hewlett Packard server Intel Xeon CPU E31220 @ 3.10GHx 10GB RAM (8 GB RAM is usable) Firebird 2.5.2 64bit SuperServer single database is being used where its size is about 80GB When I copy any big file to test the performance of disk field then I can see that it can force disk performance, but Firebird is still relaxing. When I try to backup database using gbak no change. CPU core is on 3-6% and disk load is about 1MB/s What can I check else? Thanks in advance. TRoland; 21.01.2014 15:17 - Hugo Eyng hugoe...@msn.com mailto:hugoe...@msn.com I changed the paramter FileSystemCacheSize = 0 to FileSystemCacheSize = 20 in the firebird.conf as suggested in: http://dyemanov.blogspot.com.br/2012/03/firebird-vs-windows-file-system-caching.html Hugo Em 21/01/2014 12:06, Roland Turcan escreveu: Yes, I am interested too. What was the key to get rid of this problem? Thanks in advance. 21.01.2014 15:29 - Fabiano - Desenvolvimento SCI fabi...@sci10.com.br mailto:fabi...@sci10.com.br How you solved your problem? *De: *firebird-support@yahoogroups.com mailto:firebird-support@yahoogroups.com[mailto:firebird-support@yahoogroups.com] *Em nome de *Hugo Eyng *Enviada em:* terça-feira, 21 de janeiro de 2014 10:24 *Para: *firebird-support@yahoogroups.com mailto:firebird-support@yahoogroups.com *Assunto:* Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2 Hi Helen. Thanks for your answer. You are right. But the Windows 64 file cache performance was a problem, as said Sean. Só 'reserving' 10GB as a RAM DRIVE grant that I would have always available RAM. But now I solved the 'cache performance' and I will not need RAM DRIVE anymore. Even so, the FB performance is not compatible to the hardware used to run it. Em 20/01/2014 23:12, Helen Borrie escreveu: At 02:01 p.m. 21/01/2014, Hugo Eyng wrote: As Firebird do not use available RAM I created a RAM DRIVE with 10GB and pointed parameter 'TempDirectories' (firebird.conf) to this RAM DRIVE, but FB just uses it rarely in very big 'SELECT'. OK, when FB uses the RAM DRIVE it increases a SELECT speed in more than 80%. I expected FB could use this for every SELECTS and so improve the application. Fb uses RAM directly for sorts, if enough is available. It only takes the sort sets to disk if available RAM is insufficient. Helen Borrie, Support Consultant, IBPhoenix (Pacific) Author of The Firebird Book
Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2
I use SuperClassic and seted the DefaultDbCachePages = 2250 The Default value is 75 Than I used a multiple of 75 The amount of memory used by FB service increases a lot and the performance increases too Em 23/01/2014 02:52, Alexey Kovyazin escreveu: Hi Roland, I have tried to change this parameter (actually =20), but I don't see any change. 20? It is below all meaningful values. If you are using SuperServer, set 1, if Classic or SuperClassic, set 1024, and _restart_ Firebird. What else can I test? If you are interested in professional optimization (http://ib-aid.com/services/optimization), contact our support. Regards, Alexey Kovyazin www.IBSurgeon.com AFAIK, the parameter DefaultDbCachePages is intended for newly created databases as default size of cache pages. It doesn't have effect on existing databases where its own setting is used. Every database can have own setting about count of cache pages. It seems to be still not solving this problem using by FileSystemCacheSize. What else can I test? Thanks. 22.01.2014 15:05 - Hugo Eyng hugoe...@msn.com Try changing values for DefaultDbCachePages Em 21/01/2014 18:40, Roland Turcan escreveu: I have tried to change this parameter (actually =20), but I don't see any change. My server box is: Hewlett Packard server Intel Xeon CPU E31220 @ 3.10GHx 10GB RAM (8 GB RAM is usable) Firebird 2.5.2 64bit SuperServer single database is being used where its size is about 80GB When I copy any big file to test the performance of disk field then I can see that it can force disk performance, but Firebird is still relaxing. When I try to backup database using gbak no change. CPU core is on 3-6% and disk load is about 1MB/s What can I check else? Thanks in advance. TRoland; 21.01.2014 15:17 - Hugo Eyng hugoe...@msn.com mailto:hugoe...@msn.com I changed the paramter FileSystemCacheSize = 0 to FileSystemCacheSize = 20 in the firebird.conf as suggested in: http://dyemanov.blogspot.com.br/2012/03/firebird-vs-windows-file-system-caching.html Hugo Em 21/01/2014 12:06, Roland Turcan escreveu: Yes, I am interested too. What was the key to get rid of this problem? Thanks in advance. 21.01.2014 15:29 - Fabiano - Desenvolvimento SCI fabi...@sci10.com.br mailto:fabi...@sci10.com.br How you solved your problem? *De: *firebird-support@yahoogroups.com mailto:firebird-support@yahoogroups.com[mailto:firebird-support@yahoogroups.com] *Em nome de *Hugo Eyng *Enviada em:* terça-feira, 21 de janeiro de 2014 10:24 *Para: *firebird-support@yahoogroups.com mailto:firebird-support@yahoogroups.com *Assunto:* Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2 Hi Helen. Thanks for your answer. You are right. But the Windows 64 file cache performance was a problem, as said Sean. Só 'reserving' 10GB as a RAM DRIVE grant that I would have always available RAM. But now I solved the 'cache performance' and I will not need RAM DRIVE anymore. Even so, the FB performance is not compatible to the hardware used to run it. Em 20/01/2014 23:12, Helen Borrie escreveu: At 02:01 p.m. 21/01/2014, Hugo Eyng wrote: As Firebird do not use available RAM I created a RAM DRIVE with 10GB and pointed parameter 'TempDirectories' (firebird.conf) to this RAM DRIVE, but FB just uses it rarely in very big 'SELECT'. OK, when FB uses the RAM DRIVE it increases a SELECT speed in more than 80%. I expected FB could use this for every SELECTS and so improve the application. Fb uses RAM directly for sorts, if enough is available. It only takes the sort sets to disk if available RAM is insufficient. Helen Borrie, Support Consultant, IBPhoenix (Pacific) Author of The Firebird Book and The Firebird Book Second Edition http://www.firebird-books.net __ -- Atenciosamente, Hugo Eyng How you solved your problem? *De: *firebird-support@yahoogroups.com mailto:firebird-support@yahoogroups.com[mailto:firebird-support@yahoogroups.com] *Em nome de *Hugo Eyng *Enviada em:* terça-feira, 21 de janeiro de 2014 10:24 *Para: *firebird-support@yahoogroups.com mailto:firebird-support@yahoogroups.com *Assunto:* Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2 Hi Helen. Thanks for your answer. You are right. But the Windows 64 file cache performance was a problem, as said Sean. Só 'reserving' 10GB as a RAM DRIVE grant that I would have always available RAM. But now I solved the 'cache performance' and I will not need RAM DRIVE anymore. Even so, the FB performance is not compatible to the hardware used to run it. Em 20/01/2014 23:12, Helen Borrie escreveu: At 02:01 p.m. 21/01/2014, Hugo Eyng wrote: As Firebird do not use available RAM I created a RAM DRIVE with 10GB and pointed parameter 'TempDirectories' (firebird.conf) to this RAM DRIVE, but FB just uses it rarely
Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2
Hi Helen. Thanks for your answer. You are right. But the Windows 64 file cache performance was a problem, as said Sean. Só 'reserving' 10GB as a RAM DRIVE grant that I would have always available RAM. But now I solved the 'cache performance' and I will not need RAM DRIVE anymore. Even so, the FB performance is not compatible to the hardware used to run it. Em 20/01/2014 23:12, Helen Borrie escreveu: At 02:01 p.m. 21/01/2014, Hugo Eyng wrote: As Firebird do not use available RAM I created a RAM DRIVE with 10GB and pointed parameter 'TempDirectories' (firebird.conf) to this RAM DRIVE, but FB just uses it rarely in very big 'SELECT'. OK, when FB uses the RAM DRIVE it increases a SELECT speed in more than 80%. I expected FB could use this for every SELECTS and so improve the application. Fb uses RAM directly for sorts, if enough is available. It only takes the sort sets to disk if available RAM is insufficient. Helen Borrie, Support Consultant, IBPhoenix (Pacific) Author of The Firebird Book and The Firebird Book Second Edition http://www.firebird-books.net __ -- Atenciosamente, Hugo Eyng
Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2
Hi Fabiano. My server: * Intel® Xeon® E5-2609 v2 2.50GHz,10M Cache, 6.4GT/s QPI, No Turbo, 4C, 80W, Max Mem 1333MHz * 8GB RDIMM, 1600MT/s, Low Volt, Dual Rank, x4 Data Width * HD 6 x 300GB SAS, 10K RPM, 6GBPS Hot-Plug de 2.5 * PowerEdgeR620,Intel®Xeon®E-26XXv2Processors CristalDiskMark: Seq 468 MB/s Read161 MB/s Write(Ten times faster than a notebook vostro 1510 intel core 2 duo 1.8ghz) Em 21/01/2014 07:52, fabianoas...@gmail.com escreveu: Maybe your problem is that you buy a internet server from dell, not a database server! What is the diference? Internet servers from Dell does not have a disk controller WITH physical cache. Run CrystalDiskMark or other disk benckmark on this computer and in another desktop computer. If it is slow you need to replace your disk controller. Also read from Helen sayd. You are loosing the point when using a gente ram disk. Em 20/01/2014 23:01, Hugo Eyng hugoe...@msn.com mailto:hugoe...@msn.com escreveu: Hi. I am facing a similar situation. 32GB RAM Dell PowerEdge R420 Intel Xeon CPU E5-2609 two processors 2.40ghz 8 cores RAID Firebird 2.5.2 do not use the available resources of the server even I try to login to the server just one user. I am using SuperClassic I felt a little diference by modifying parameters in firebird.conf like DefaultDbCachePages = 2250 and some others This increases performance in about 30% in my case But I expected more. As Firebird do not use available RAM I created a RAM DRIVE with 10GB and pointed parameter 'TempDirectories' (firebird.conf) to this RAM DRIVE, but FB just uses it rarely in very big 'SELECT'. OK, when FB uses the RAM DRIVE it increases a SELECT speed in more than 80%. I expected FB could use this for every SELECTS and so improve the application. Hugo Eyng Em 20/01/2014 20:51, Roland Turcan escreveu: Hello guys, I found some info about problems with performance when FB is running on Win2008R2 which is domain controller. But in my case is it not DC, but the performance is the worst I met. It is new server running 10GB of RAM, RAID, ... it is quite new server box. It cannot be, that basically dummy update on table with about 700 000 records is executing over one hour. CPU is relaxing, HDD is relaxing too and I cannot force server to fun faster. What can I check? Thanks in advance. -- Best regards, TRoland http://www.rotursoft.sk http://exekutor.rotursoft.sk -- Atenciosamente, Hugo Eyng -- Atenciosamente, Hugo Eyng
Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2
Hi Fabiano. The numbers of CristalDiskMarkSx64 are better: 662 MB/s read and 169 MB/s write I don´t know de difference between CristalDiskMarkX64 and DiskMarkSx64 But DiskMarkSx64 gave me better numbers. Hugo Em 21/01/2014 07:52, fabianoas...@gmail.com escreveu: Maybe your problem is that you buy a internet server from dell, not a database server! What is the diference? Internet servers from Dell does not have a disk controller WITH physical cache. Run CrystalDiskMark or other disk benckmark on this computer and in another desktop computer. If it is slow you need to replace your disk controller. Also read from Helen sayd. You are loosing the point when using a gente ram disk. Em 20/01/2014 23:01, Hugo Eyng hugoe...@msn.com mailto:hugoe...@msn.com escreveu: Hi. I am facing a similar situation. 32GB RAM Dell PowerEdge R420 Intel Xeon CPU E5-2609 two processors 2.40ghz 8 cores RAID Firebird 2.5.2 do not use the available resources of the server even I try to login to the server just one user. I am using SuperClassic I felt a little diference by modifying parameters in firebird.conf like DefaultDbCachePages = 2250 and some others This increases performance in about 30% in my case But I expected more. As Firebird do not use available RAM I created a RAM DRIVE with 10GB and pointed parameter 'TempDirectories' (firebird.conf) to this RAM DRIVE, but FB just uses it rarely in very big 'SELECT'. OK, when FB uses the RAM DRIVE it increases a SELECT speed in more than 80%. I expected FB could use this for every SELECTS and so improve the application. Hugo Eyng Em 20/01/2014 20:51, Roland Turcan escreveu: Hello guys, I found some info about problems with performance when FB is running on Win2008R2 which is domain controller. But in my case is it not DC, but the performance is the worst I met. It is new server running 10GB of RAM, RAID, ... it is quite new server box. It cannot be, that basically dummy update on table with about 700 000 records is executing over one hour. CPU is relaxing, HDD is relaxing too and I cannot force server to fun faster. What can I check? Thanks in advance. -- Best regards, TRoland http://www.rotursoft.sk http://exekutor.rotursoft.sk -- Atenciosamente, Hugo Eyng -- Atenciosamente, Hugo Eyng
Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2
Hi. I am facing a similar situation. 32GB RAM Dell PowerEdge R420 Intel Xeon CPU E5-2609 two processors 2.40ghz 8 cores RAID Firebird 2.5.2 do not use the available resources of the server even I try to login to the server just one user. I am using SuperClassic I felt a little diference by modifying parameters in firebird.conf like DefaultDbCachePages = 2250 and some others This increases performance in about 30% in my case But I expected more. As Firebird do not use available RAM I created a RAM DRIVE with 10GB and pointed parameter 'TempDirectories' (firebird.conf) to this RAM DRIVE, but FB just uses it rarely in very big 'SELECT'. OK, when FB uses the RAM DRIVE it increases a SELECT speed in more than 80%. I expected FB could use this for every SELECTS and so improve the application. Hugo Eyng Em 20/01/2014 20:51, Roland Turcan escreveu: Hello guys, I found some info about problems with performance when FB is running on Win2008R2 which is domain controller. But in my case is it not DC, but the performance is the worst I met. It is new server running 10GB of RAM, RAID, ... it is quite new server box. It cannot be, that basically dummy update on table with about 700 000 records is executing over one hour. CPU is relaxing, HDD is relaxing too and I cannot force server to fun faster. What can I check? Thanks in advance. -- Best regards, TRoland http://www.rotursoft.sk http://exekutor.rotursoft.sk -- Atenciosamente, Hugo Eyng
Re: [firebird-support] nbackup questions
Hi. I am not sure if i understood your question. You want to move the fdb file to another computer? Hugo Eyng Em 15/01/2014 12:52, Maury Markowitz escreveu: I am a admin of the Fishbowl Inventory (FBI) system for our company, which is a Java app on top of Firebird. I need to move the system off an unstable machine. FBI does not allow me to simply replace the .FDB files, for reasons that have not been explained (error codes that make no sense). I experimented with using the system's automated nbackups to replace the information in an existing .FDB, and that works. *phew* The problem is that the system's Scheduler function, without any warning or errors, stopped making these nbackups last May. So I need to make an nbackup manually. So I tried... nbackup -U gone -P fishing -B 0 ../data/EXAMPLE.FDB ../data/ex.bak However, this results in the error, You must be either SYSDBA or owner of the database. The thing is, the user gone is the only one that appears in SHOW USER in isql, so how could it be the case that they are not the owner? Can one assign ownership to a non-existant user? Might it be assigned to SYSDBA? Moving on I tried the same command, but this time with SYSDBA and masterkey. This results in another error, Your user name and password are not defined. I assume this is because masterkey is no longer used, but the installer process does not ask for a password. The dox suggest that the password might be randomly assigned in this case, and then stored in a file, but I cannot find the file it refers to. Can anyone offer suggestions on how to solve this? -- Atenciosamente, Hugo Eyng
Re: [firebird-support] nbackup questions
There are some things you should observe: 1 - Use the same version of FB server in the computer you move the 'fdb' to that you use in the 'source' computer; 2 - Before copying the 'fdb' stop the FB server service; Another thing I would tell you is that you should use 'gbak' to backup your source 'fdb' and then, in the destination computer, use 'gbak' to restore and recreate the 'fdb'. Em 15/01/2014 17:30, Maury Markowitz escreveu: On 2014-01-15, at 2:02 PM, Hugo Eyng wrote: I am not sure if i understood your question. You want to move the fdb file to another computer? That is correct. For reasons that I do not understand, the simple method of simply copying the FDB from one machine to another does not work. When I try to attach to that database, it reports file not found, which I assume is a spurious error code. But there already is a small (example) database file on that machine that I *can* attach to. I can also restore into it. So if I can get nbackup to work, that provides a way to move the data over. -- Atenciosamente, Hugo Eyng
Re: [firebird-support] RE: Insert into Large Table is slowly!
GTT? Em 05/09/2013 13:35, jym...@gmail.com escreveu: Maybe I've missed something about temporary tables, but it looks to me as if you're doing two inserts and a delete per record.  Why not just put the records into the real table to start with? Ann Harrison is right. I just use GTT resolve a question at last week. ≧▽≦ jimmy --- In firebird-support@yahoogroups.com, aharrison@... wrote: On Thu, Sep 5, 2013 at 3:50 AM, jym013@... wrote: I insert data use follow: 1. start a transaction 2. Insert a batch records into temp table TableTemp, It's structure like table1 3. Insert into Table1 select * from TableTemp   Delete Data From TableTemp   (about 30,000 record every tiime) 4. commit transaction but now, insert data become very slowly. Maybe I've missed something about temporary tables, but it looks to me as if you're doing two inserts and a delete per record.  Why not just put the records into the real table to start with? Good luck, Ann -- Atenciosamente, Hugo Eyng
Re: [firebird-support] DefaultDbCachePages
Hi Sean. SuperClassic maybe? Hugo Em 22/08/2013 18:03, Leyne, Sean escreveu: I am using SuperServer. No, you are not! If you are seeing FB_inet_server.exe in your Task Manager -- that is the Classic server. SuperServer process name is FBServer.exe. Sean -- Atenciosamente, Hugo Eyng [Non-text portions of this message have been removed]
Re: [firebird-support] DefaultDbCachePages
Hi. I am using SuperServer. Em 22/08/2013 17:56, Leyne, Sean escreveu: Hugo, Is it a good idea setting DefaultDbCachePages to high value like 15000 on a DB with page size 16k? No. With Classic you want to actually use a cache of 150-300 pages to reduce lock manager contention. The speed of my queries increases. This is due to the huge page cache setting. Remember to run queries a couple of time in order to exclude the cost/time of cache load when comparing results My question is about security. The environment is secure, nobreak, good server, hourly backup, etc. Could I have problems like data corruption? In all other respects Classic engine functions the same as SuperServer -- Atenciosamente, Hugo Eyng [Non-text portions of this message have been removed]
[firebird-support] Temporary directories
Hello. I am trying to increase the speed of my queries. Firebird 2.5 Windows Server 2008 32 GB RAM I use 10GB of ram as a ram disk drive. I wrote query that takes 2:45 minutes running _*without*_ the TempDirectories=R:\TEMP (ram disk drive) and the same query takes 1:13 minutes running _*with*_ the TempDirectories=R:\TEMP (ram disk drive). I tried to set the FIREBIRD_TMP environment variable instead of the TempDirectories and it doesn't work as I expected. I guess that I could use TempDirectories _*OR*_ FIREBIRD_TMP. Another question is that using a ram disk drive increases only queries that uses ORDER BY or GROUP BY. Does somebody has comments, suggestions? How to really increase the speed of my queries using RAM, a lot of RAM? -- Atenciosamente, Hugo Eyng [Non-text portions of this message have been removed]
Re: [firebird-support] Temporary directories
Sean, I understand what you are saying. But, my question is, or should be, more generic. Something like: If I have a lot of RAM available, how could I use it in a way to increase the database speed (specially queries). I found out that chaging DefaultDbCachePages from 75 to 750 the queries really run faster. Using a ram disk drive increases a query that uses ORDER BY or GROUP BY. I hope it is a bit more understandable now. Hugo Em 20/08/2013 19:22, Leyne, Sean escreveu: Hugo, Hello. I am trying to increase the speed of my queries. Firebird 2.5 Windows Server 2008 32 GB RAM I use 10GB of ram as a ram disk drive. I wrote query that takes 2:45 minutes running _*without*_ the TempDirectories=R:\TEMP (ram disk drive) and the same query takes 1:13 minutes running _*with*_ the TempDirectories=R:\TEMP (ram disk drive). Actually, depending on how you performed your performance testing, it may be possible that the RAM disk is having a minimal impact. If the first query had to load a lot of pages into engine and/or OS cache, it would be slower than the second. Another question is that using a ram disk drive increases only queries that uses ORDER BY or GROUP BY. Temporarily files can also be used for large query sets. How to really increase the speed of my queries using RAM, a lot of RAM? Without some details regarding the database size, the page cache settings, the PLAN for the query and the Statistics for the same, it is very difficult to provide meaningful suggestions. Sean -- Atenciosamente, Hugo Eyng [Non-text portions of this message have been removed]
[firebird-support] Primary Key x Unique Key
Hello. When should I use a Unique Key instead of a Index? I know that a Unique Key does not allow duplicated values like a Primary Key, but what more? Is there some advantage using a Unique Key? A Unique Key is the same that Alternate Key? -- Atenciosamente, Hugo Eyng
Re: [firebird-support] Incremental Backup
Hello, Dmitry. You are right. Now a days gbak indeed takes arounda five 5 minutes. I was thinking about use nbackup for additional log. I would make incremental backup every 5 minutes (for example) and so I could restore the db situation in any 5 minutes I need. Is it a good idea? Em 26/06/2013 18:52, Dmitry Kuzmenko escreveu: Hello, Hugo! Thursday, June 27, 2013, 1:28:18 AM, you wrote: HE My database size: 4 GB I doubt to use nbackup for that size of database. because usual gbak -b -g must take around 5 minutes, not more. Restore of that db also must take around 15 minutes. And, the timing I mention is for cheap SATA II drives (1 for db and 1 for backup), not for cool RAID storage, or even for SSD - there usual backup and restore speed will be like lightning. You may start to think about nbackup when your db will reach ~20gb size. HE Could you help me with the nbackup? HE What the best use? Keys, frequency, etc... HE How to restore? read http://www.firebirdsql.org/manual//nbackup.html as many times, until you will understand it. nbackup -b 0 is kinda file copy, with the near same speed nbackup with higher levels will read whole db, but write only changes, so, it is faster. But, if you use Classic, consider not to use nbackup with Firebird less than 2.5.2 (or even 2.5.3). -- Dmitry Kuzmenko, www.ib-aid.com -- Atenciosamente, Hugo Eyng [Non-text portions of this message have been removed]
Re: [firebird-support] Incremental Backup
This a good manner of thinking: a combination of two. My database size: 4 GB Could you help me with the nbackup? What the best use? Keys, frequency, etc... How to restore? Em 26/06/2013 15:13, Nagy Szilveszter escreveu: Is your database so big that you need the speed nbackup gives you? Compare the speed with the integrity...which is more important in your scenario? Think about a failure of your database...how will you proceed at restoring? If it is a mission critical database you won't have too much time for restore. A combination of two might be better...like full backup once a week, and incremental backup as many times you need. From: Hugo Eyng hugoe...@msn.com mailto:hugoeyng%40msn.com To: firebird-support@yahoogroups.com mailto:firebird-support%40yahoogroups.com Sent: Wednesday, June 26, 2013 8:38 PM Subject: [firebird-support] Incremental Backup Hi. I am considering to use incremental backup (nbackup.exe) instead of using full backup (gbak.exe). Is it a good idea? Where could I see a good example of use of nbackup? Did someone already use it? I would apreciate any consideration. -- Atenciosamente, Hugo Eyng [Non-text portions of this message have been removed] -- Atenciosamente, Hugo Eyng [Non-text portions of this message have been removed]
