Re: [firebird-support] Will we move when yahoo Groups close theirs doors?
https://stackoverflow.com/questions/35966337/transition-from-yahoo-groups-to-google-groups On 18.10.2019 ã. 14:45, emb_blas...@hotmail.com [firebird-support] wrote: > > Hi! > > Recently I learned that Yahoo! will close Groups. > > We will lose all the content? > > Will we move to another platform? Where? > > > > -- Doychin Bondzhev dSoft-Bulgaria Ltd. PowerPro - billing & provisioning solution for Service providers http://www.dsoft-bg.com/ Mobile: +359888243116 [Non-text portions of this message have been removed] ++ 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: NVME drive optimize for firebird engine
Hi, You can try by turning Forced writes off on the database. Firebird does very frequent writes to it's transaction pages and that is overkill for SSD. Without good write cache this hurts performance a lot. I suggest you do the above only to test and see is there any difference in the performance. Another option I use is SSD in PCIE with database forced write OFF and replication of that database on regular SSD or HDD where forced write is ON. This is possible because replication does not use many transactions to transfer data between databases. There is a chance that your database can loose some data in case of power failure but that will be limited up to the data that was not replicated on the other database. Replication on every minute is OK for databases that don't process to many transactions. Also if your server is protected by UPS which should be the case for every production system then you probably can do normal shutdown procedure so the chance to loose data is decreased. On 11.4.2018 ã. 8:33, ma_go...@yahoo.com [firebird-support] wrote: > Hi! > > Do not use software RAID, it has no disc cache and IO becomes terribly > slow. You have to use harware RAID with BBU ho have disc cache and good > performance. > > -- Doychin Bondzhev dSoft-Bulgaria Ltd. PowerPro - billing & provisioning solution for Service providers PowerStor - Warehouse & POS http://www.dsoft-bg.com/ Mobile: +359888243116 [Non-text portions of this message have been removed] ++ 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] Ryzen R7 vs Kaby Lake 7700K, which one to choose?
Hi, I just got my last piece (the motherboard) for my new Ryzen system. I'll install all the software during the next few days and will write back here about my experience with FB. I'm moving from FX-8350 to Ryzen 7 1800X with some decent upgrade on the storage (RAID 10 with 6 HDD) so I expect there will be very decent speed up for FB. At least my personal experience shows that for well written code the biggest problem is the database storage. For classic or super classic you will get better results with Ryzen when you have multiple clients accessing your database then with KL. KL is good for super server or for small number of clients where higher IPC will help you to process queries faster. but all this is irrelevant if you have slow storage. Doychin On 23.3.2017 ã. 05:00 ÷., trsk...@yahoo.com [firebird-support] wrote: > > > Hi all, > > I am considering to upgrade my development cpu. > > Between Ryzen & KL, although Ryzen is very good at multi threaded > processing, I guest, for Firebird, KL will be faster. > > For development, mostly I used only single connection to FB, and since > FB distributed workload among cores, for a single connection, total > utilization for all cores is the same as 100% utilisation for 1 core, > and for 1 core operation, KL is more superior than Ryzen. > > Can anyone confirm this? Or has anyone here have a Ryzen and care to > share the experience using Ryzen with FB? > > Thanks & regards, > Anto > > > -- Doychin Bondzhev dSoft-Bulgaria Ltd. PowerPro - billing & provisioning solution for Service providers PowerStor - Warehouse & POS http://www.dsoft-bg.com/ Mobile: +359888243116 [Non-text portions of this message have been removed] ++ 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] Looking for example how to use FBTraceManager api in java.
Hi, I'm looking for some example how to use TraceAPI provided in Jaybird. -- Doychin Bondzhev dSoft-Bulgaria Ltd. PowerPro - billing & provisioning solution for Service providers PowerStor - Warehouse & POS http://www.dsoft-bg.com/ Mobile: +359888243116 [Non-text portions of this message have been removed]
[firebird-support] how to keep history of statements per transaction?
Hi, I'm looking for easy to use solution that can help me trace statements executed inside every transaction and keep them until transaction is active. Once it is closed(commit or rollback) statements are discarded. I need this to be able to run on a production system in order to track which code path leaves open transaction or keeps transaction open for long time. Any ideas how to make this? -- Doychin Bondzhev dSoft-Bulgaria Ltd. PowerPro - billing & provisioning solution for Service providers PowerStor - Warehouse & POS http://www.dsoft-bg.com/ Mobile: +359888243116 [Non-text portions of this message have been removed]
Re: [firebird-support] Firebird Embedded on web hosting
The only protection that I found until now is to use forced writes on the database. this can save you from real troubles. Without this option turned off you might lose some data even when your database is in perfect shape. With forced writes you have the guarantee that at least until the last transaction everything is stored on the disk and only data you might loose is the last transaction that was unable to store it's changes to the disk. If corruption is in the area where index data is stored this is not a problem. You can always backup/restore your database and rebuild the broken indexes. Also another way of protecting your data is to make regular backups. But I'm not sure how you will accomplish this in embedded mode. I always use classic server. Hope this helps. On 21.9.2015 ã. 13:24 ÷., Glenn Thomas Hvidsten g...@vensafe.no [firebird-support] wrote: > If the computer loses power (and is turned off) when Firebird is writing > to the database, the database may become corrupt. > Are there any firebird settings that can make it so that there is a > smaller chance of database corruption? > > Glenn Thomas Hvidsten > > From: firebird-support@yahoogroups.com > [mailto:firebird-support@yahoogroups.com] > Sent: 21. september 2015 11:57 > To: firebird-support@yahoogroups.com > Subject: Re: [firebird-support] Firebird Embedded on web hosting > > > > sorry but i didn't understand your point ... can you explain more please ? > > > anyway, since i cannot control where fbembedded put it's lock and trace > files, my only option now is to build firebird from source and change > the directory by hand . > > > > > Denne epost har blitt kontrollert for virus av Comendo Norge AS > This e-mail has been scanned for viruses by http://www.comendo.no > > > > [Non-text portions of this message have been removed] > > -- Doychin Bondzhev dSoft-Bulgaria Ltd. PowerPro - billing & provisioning solution for Service providers PowerStor - Warehouse & POS http://www.dsoft-bg.com/ Mobile: +359888243116 [Non-text portions of this message have been removed] ++ 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] Install 2.1 on RH 6
You need to install compat-libstdc++-33 package. That package will give you the needed C++ libraries to run firebird on RHEL/CentOS 6 On Sat, Apr 18, 2015 at 10:37 PM, Emil Totev em...@tot-consult.com [firebird-support] firebird-support@yahoogroups.com wrote: I will have to install firebird 2.1 (preferably latest 2.1.7) on 64-bit RHEL/CentOS 6 based linux. (I understand 2.1 is discontinued, but some program vendors don't). The rpm and tar.gz packages from firebird.sql seem to fail [at least] because of libstdc++ - if I understand correctly, they need libstdc++.so.5 while I have libstdc++.so.6 I couldn't find an rpm or pre-compiled 2.1.7 binary for RHEL/CentOS6, but maybe I didn't know how and where to look. Can anyone suggest anything else to try before I start trying to compile from sources? (Never done that and have the impression it may not be that easy). Thanks Emil
[firebird-support] Is it possible to convert binary blob to varchar?
Hi, I tried to convert binary blob field to varchar column in select statement but It did not work. Here is what I did: 1. I created a domain CREATE DOMAIN D_BIGVARCHAR AS VARCHAR(32000) CHARACTER SET OCTETS COLLATE OCTETS; Then when I use this query select cast(JOB_INFO as D_BIGVARCHAR) job_string from JOB_TASKS I expect to receive the value of blob field as varchar in the result set. In my java code I use: rs.getBytes(job_string) to get varchar as byte array. But for some reason where I have non-char values in the byte array I get (dec)46 instead of actual value. My Data source in the java is defined with NONE Encoding. Any ideas what I'm doing wrong? Thanks in advance Doychin Bondzhev
Re: [firebird-support] Re: Simultaneous inserts / selects
On 9.10.2014 ã. 14:32 ÷., brucedickin...@wp.pl [firebird-support] wrote: Thank you guys for your input! I appreciate it! I have some doubts.. isn't TCP/IP a bottleneck here? I mean, I am sending for example 4 times (4 threads) more data to insert via network. @Doychin I do have like 2-3 indexes per table but the speed in single thread was sufficient. Thanks, I hope my quest will give me some nice results:) @Kjell Could you shed some more information about your solution? So you first insert data to external table and then you move all that data at once into the main table? @Dmitri 300 threads? The question is how many of them are hitting the database at the same time? I have one more generall question, do you perform your inserts one by one, I mean: StartTransaction; Insert; Insert; Insert; Commit; or do you generate a batch script? a text file which have in it 1000 records, or 1 or more? Can't you use insert with parameters? This way you will prepare the statement only once and just execute it many times with different parameters. Doing insert with multiple statements without parameters can hurt performance. Statement must be prepared every time and that takes time and round-trip to the server. What language/library you will use to do this job? regarding the size of batch you can do some testing. performance might depend on the number of threads in this case. You need to find the right balance because in case of failure the whole batch will fail. -- Doychin Bondzhev dSoft-Bulgaria Ltd. PowerPro - billing provisioning solution for Service providers PowerStor - Warehouse POS http://www.dsoft-bg.com/ Mobile: +359888243116 [Non-text portions of this message have been removed] ++ 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: R: [firebird-support] How to improve Firebird 2.5.3 Disk I/O on Windows server 2012 R2
Hi Costantino, I did some experimenting before one year and I found that Firebird is much faster when you use page size = cluster size on the file system. So if your file system is with 4K cluster I suggest to use page size of 4K. This is very helpful when you have Forced Write = ON. Performance gain with insert only scenario is more then 10-15% from 16K page on Windows 7 with RAID 10. another thing to look for is to try to minimize the number of transactions you create. Try to put as many as possible statements into single transaction. So for this check do you use autocommit on every statement or you wrap all statements executed while processing single file in one transaction. Also when you process your lines in the input file try to group as many as possible selects into single select. for example: select field1, filed2, filed3, field4 from table1 where field1 = ? and field2 = ? into : select field1, filed2, filed3, field4 from table1 where (field1 = ? and field2 = ?) or (field1 = ? and field2 = ?) or (field1 = ? and field2 = ?) .. this way you will check for multiple values at once and that means less selects to execute on the database. If you do your query on single field then you can use IN instead of = Check also you have proper index setup on the tables. Usually execution that is IO heavy does not get much better performance by just changing the hardware. If you move from HDD to SSD this can speed up much more but HDD performance is not very different in the last 10 years. Also another thing to note is that for DB scenarios I prefer to use Read Caching and no Write caching. This gives me better guarantee that I will not end with broken database in case of power failure. Have a nice day. -- Doychin Bondzhev dSoft-Bulgaria Ltd. PowerPro - billing provisioning solution for Service providers PowerStor - Warehouse POS http://www.dsoft-bg.com/ Mobile: +359888243116 [Non-text portions of this message have been removed]
[firebird-support] Exceptioin when using connection in distributed transaction in Java Application server
Hi, This exception I get when I try to close connection that I get from a Datasource that I lookup from JNDI. I use try { // Some code that uses connection } finally { connection.close(); } 11:58:47,160 ERROR [STDERR] Caused by: org.firebirdsql.jdbc.FBSQLException: Connection enlisted in distributed transacti on 11:58:47,160 ERROR [STDERR] at org.firebirdsql.jdbc.AbstractConnection.setAutoCommit(AbstractConnection.java:436) 11:58:47,160 ERROR [STDERR] at org.firebirdsql.jdbc.AbstractConnection.close(AbstractConnection.java:566) 11:58:47,160 ERROR [STDERR] at com.dsoft.framework.enterprise.session.LoginManagerBean.initializeAdminAccount(LoginM anagerBean.java:164) 11:58:47,160 ERROR [STDERR] ... 162 more Is there anything I can do to avoid this?
[firebird-support] Re: Exceptioin when using connection in distributed transaction in Java Application server
This is with jaybird 2.2.5 JDK 7. I use JBoss App server 4.2.3 on JDK 1.7.0-40 My datasource definition is: ?xml version=1.0 encoding=UTF-8? connection-factories tx-connection-factory jndi-nameDSoftDS/jndi-name xa-transaction/ track-connection-by-tx/ rar-namejaybird-2.2.5.rar/rar-name connection-definitionjavax.sql.DataSource/connection-definition config-property name=Database type=java.lang.Stringlocalhost/3050:powerpro_clean/config-property user-namesysdba/user-name passwordmasterkey/password config-property name=EncodingUNICODE_FSS/config-property min-pool-size5/min-pool-size max-pool-size100/max-pool-size metadata type-mappingPowerPro/type-mapping /metadata /tx-connection-factory /connection-factories this works without problem with Jaybird 2.1.6. I see the only difference in the code path is that there is an extra check in AbstractConnection.setAutoCommit that checks is this connection is part of distributed transaction and triggers this error. If I don't call close I get error message that connection was closed for me when transaction was committed.
Re: Odp: [firebird-support] Re: Insert ot update sta tements locks a table and all other instances th at try to run same statement are lcoked to
In this particular case the heavy load is not in this table. It is another table. This insert is run only once a day when the first client connects to the system. All other clients should be able to see the inserted records and will just load them. The problem might happen only of 2 clients try to login at the same time and they both see that todays records are not here and try top insert them in different transactions. But in that case I expect one of the transactions to fail and to produce error. Not to block the execution of other insert statements. There is no triggers or references to other tables that are inserted in the same transaction.
Re: [firebird-support] Insert ot update statements locks a table and all other instances that try to run same statement are lcoked to
I'm using Firebird 2.1.6. Also I tried to upgrade to latest jaybird before but it does not work properly with JBoss 4.2.3. I remember something has changed and as soon as I try to start apps server and run client, exceptions were starting to popup in the log. This code path uses long running transaction only if for some reason the history for a cash box is lost and has to be rebuild day by day. This is not the case in the moment. usually the execution of this operation have to take not more then just a second or a little more when more then 5-6 cash boxes has to be recalculated.
Re: [firebird-support] Insert ot update statements locks a table and all other instances that try to run same statement are lcoked to
I'm not sure it is locked table. What I'm looking for is idea or advice how to find what the real problem is. My data source definition is this: connection-factories tx-connection-factory jndi-namePowerProDS/jndi-name xa-transaction/ track-connection-by-tx/ rar-namejaybird-2.1.6.rar/rar-name connection-definitionjavax.sql.DataSource/connection-definition config-property name=Database type=java.lang.Stringlocalhost/3050:powerpro/config-property user-namesysdba/user-name passwordmasterkey/password config-property name=EncodingUNICODE_FSS/config-property prepared-statement-cache-size100/prepared-statement-cache-size min-pool-size10/min-pool-size max-pool-size50/max-pool-size metadata type-mappingEuroPro/type-mapping /metadata /tx-connection-factory /connection-factories
[firebird-support] Re: Insert ot update statements locks a table and all other instances that try to run same statement are lcoked to
CASHBOXID is already know. It is a reference to a table that we don't touch in the transaction. This table contains the current total amount of a cash box at the begging of the day. So when I try to load data for a cash box a java code checks is there record for this cash box for current day. If there is no such record it calculates the total current amount and calls the insert that adds a record to this table. Usually inserting record with same value for primary key will create error and probably will not block the execution of the statement. User is sysdba. There is no security restrictions for access to database. End users have no access to database server at all. They all use code that runs in application server to access or modify data. That is why I'm not restricting the access to the database for the moment. I'm not sure it is a lock conflict. But I suspect that something is locked somewhere and that forces the execution of the statement to stop and to lock all other inserts that other connections try to execute. As I said I need ideas or hints what to do in order to find the real problem when this situation happens again. One more thing. When I try to stop application server when this happens all connections that are blocked including the initial one stop the shutdown of the server. When I try to kill firebird process that initially blocked the execution all other processes are unlocked and server is shutdown after that. But in this case I try guess which process is that. When I look in the monitoring tables I can't see the pid of the process of each statement.
[firebird-support] Insert ot update statements locks a table and all other instances that try to run same statement are lcoked to
Hi guys, I'm looking for some ideas how to find what is causing this lock. I have 2 production databases that process multiple insert/update statements. There is one background process that does all these modifications 24h/day. The problem is that with one of these databases almost every morning when client tries to connect it runs series of inserts in one table. And during that process the insert is blocked by something. The other database experiences similar problem but there the lock is on another table that as I said earlier modified trough the whole day. If such a lock happens it locks all similar requests to these tables. I need to shutdown the main process and run Sweep in order to remove the leftover from all transactions executed after initially locked statement transaction. So I'm looking for ideas how to diagnose this problem? what I can do to pinpoint the source of the problem? I'm using Firebird 2.1.6 Classic on Linux. I have same databases on other production setups that does not have this problem. The difference there is that they don't have that background process running on these setups. Thanks in advance
Re: [firebird-support] Insert ot update statements locks a table and all other instances that try to run same statement are lcoked to
They all use READ COMMITTED isolation. It is an application that runs in JBoss App server so I have single datasource defined that uses READ COMMITTED. Blocked statements are insert and update. Selects are not blocked.
RE: [firebird-support] Insert ot update statements locks a table and all other instances that try to run same statement are lcoked to
This is the definition of the table that locks on insert: CREATE TABLE CASH_CASHBOX_DAY_AMMOUNT ( CASHBOXID INTEGER NOT NULL, DATE_TIME NUMERIC( 18, 0) NOT NULL, AMMOUNTNUMERIC( 18, 0), CONSTRAINT PK_CASH_CASHBOX_DAY_AMMOUNT PRIMARY KEY (CASHBOXID, DATE_TIME) ); ALTER TABLE CASH_CASHBOX_DAY_AMMOUNT ADD CONSTRAINT FK_CASH_CASHBOX_DAY_AMMOUNT FOREIGN KEY (CASHBOXID) REFERENCES CASH_CASHBOX (ID); It is simple insert that just inserts single record. There is no triggers or generators. Primary key value is know before insert is executed.
Re: [firebird-support] Insert ot update statements locks a table and all other instances that try to run same statement are lcoked to
Yes background process is running to on same application server and uses same data source. I use EJB 2 and CPM for doing database operations. App server is 4.2.3 and jaybird is 2.1.6