[firebird-support] RE: very slow inserts with blob-fields
Hi! Firebird do not like ext4 FS. You must chane some settings. http://www.firebirdnews.org/?p=6421 http://www.firebirdnews.org/?p=6421
[firebird-support] Re: Hyper Threading, should it turn on or off?
Hi! HT is not good for databases beacuse of the shared cache, so it should be turned OFF. http://blogs.msdn.com/b/slavao/archive/2005/11/12/492119.aspx --- In firebird-support@yahoogroups.com, trskopo trskopo@... wrote: Hi all, I have windows 7 64bit pro with intel I7 and firebird 2.5.1 Super Classic. Should I turn HT on or off to boost firebird's performance? On some app, when HT is on, performance decrease, what about for firebird? Thanks and regards, Anto
[firebird-support] Re: Question about Temp Directory
Hi! Temp dir is used only when there is not enough free memory for dataset ordering (ORDER BY or GROUP BY). --- In firebird-support@yahoogroups.com, trskopo trskopo@... wrote: Hi all, I set temp directory for firebird 2.5.1 Super Server in firbird.conf like this : TempDirectories =e:\;d:\temp On Win 7 64, also set environment like these : - FIREBIRD_TMP = e:\;d:\temp - TEMP = e:\ - TMP = e:\ How do I know, firebird using that temporary directory? Running a few query via flamerobin, seems that firebird not using that directory. Thanks and regards, Anto
[firebird-support] XE4, Interbase Express, 32/64bit, Firebird 2.5.2
Hi! Are there any known incompability issues? Thank you!
[firebird-support] Re: XE4, Interbase Express, 32/64bit, Firebird 2.5.2
I'm aware of that. We're using Firebird (since 1.5.0 up to the latest 2.5.2) + IBX (Delphi 7) without problems. Currenty I'm testing XE4 with the latest IBX. My first tests are working with no problem both on x32 and x64. So maybe its officially not supported. I'm interested in unofficial experiences, opinions. ;) --- In firebird-support@yahoogroups.com, Alexey Kovyazin ak@... wrote: Hi! Firebird and InterBase are different databases. Regards, Alexey Kovyazin IBSurgeon Hi! Are there any known incompability issues? Thank you! [Non-text portions of this message have been removed]
[firebird-support] Re: Is windows better than Linux for Firebird 2.5 64 bit?
FB has VERY poor performance with EXT4 http://www.firebirdnews.org/?p=6421 --- In firebird-support@yahoogroups.com, Lester Caine lester@... wrote: trskopo wrote: Thanks for your reply. So the question should perhaps be ... what are you using with Firebird? I am using firebird in client-server environment for accounting application and mostly only in a LAN. About file system, (if I didn't mistaken) someone here mentions not to use specific file system, because it will decrease firebird's performance. To be honest I'd like a definitive answer here. Since I'm storing a large tree of folders with other content on the same disk it's a different case to dedicating a single disk to store just the database. All of my machines are idle for a large part of the day. Just need speed to get a fast response when several enquiries come in at once, so I've not had to worry. If I start getting to a point where database access is a problem I'd probably simply move the database to it's own Linux box and run the database on it's own disk, at which point I'll be asking the same question :) -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop - http://medw.co.uk Rainbow Digital Media - http://rainbowdigitalmedia.co.uk
[firebird-support] Re: Cannot connect to server under heavy load
--- In firebird-support@yahoogroups.com, Leyne, Sean Sean@... wrote: Looks like this is an OS/settings problem. :S Tried on an other server and it works fine. Cannot connect to server under heavy load. I get connection rejected by remote interface (335544421). What OS did you test with? Sean Hi! Win XP x32 - Error Win 2008 Server x64 - OK Linux, Debian x64 - OK Linux, CentOS x64 - Error OK Still in investigation to find out the real cause...
[firebird-support] Re: Cannot connect to server under heavy load
Looks like this is an OS/settings problem. :S Tried on an other server and it works fine. --- In firebird-support@yahoogroups.com, ma_golyo ma_golyo@... wrote: Hi! Cannot connect to server under heavy load. I get connection rejected by remote interface (335544421). Is this a bug, ot there is an option in firebird.conft to avoid this? Firebird.log (FB20 Classic Server) L3S-4 Wed Oct 24 14:04:28 2012 I/O error for file C:\PROGRAM FILES\FIREBIRD\FIREBIRD_2_0\SECURITY2.FDB L3S-4 Wed Oct 24 14:04:28 2012 lock conflict on no wait transaction L3S-4 Wed Oct 24 14:04:32 2012 Error while trying to access file L3S-4 Wed Oct 24 14:04:32 2012 no permission for read-write access to database C:\PROGRAM FILES\FIREBIRD\FIREBIRD_2_0\SECURITY2.FDB L3S-4 Wed Oct 24 14:04:36 2012 The process cannot access the file because it is being used by another process
[firebird-support] Re: Cannot connect to server under heavy load
--- In firebird-support@yahoogroups.com, Leyne, Sean Sean@... wrote: Cannot connect to server under heavy load. I get connection rejected by remote interface (335544421). Is this a bug, ot there is an option in firebird.conft to avoid this? Firebird.log (FB20 Classic Server) L3S-4 Wed Oct 24 14:04:28 2012 I/O error for file C:\PROGRAM FILES\FIREBIRD\FIREBIRD_2_0\SECURITY2.FDB L3S-4 Wed Oct 24 14:04:28 2012 lock conflict on no wait transaction L3S-4 Wed Oct 24 14:04:32 2012 Error while trying to access file L3S-4 Wed Oct 24 14:04:32 2012 no permission for read-write access to database C:\PROGRAM FILES\FIREBIRD\FIREBIRD_2_0\SECURITY2.FDB L3S-4 Wed Oct 24 14:04:36 2012 The process cannot access the file because it is being used by another process These errors suggest that there is some other process which is accessing the files... You need to find that other process, the problem may not exist in Firebird at all. Sean ProcessMonitor log contaions only fb_inet_server.exe accessing to security2.fdb. BTW : QueryAllInformationFile (IRP_MJ_QUERY_INFORMATION) always results in BUFFER OVERFLOW. Is that normal?
[firebird-support] Re: Cannot connect to server under heavy load
Heavy load does not required. Just connecting to a database with many connection in short period of time throws errors. --- In firebird-support@yahoogroups.com, ma_golyo ma_golyo@... wrote: Hi! Cannot connect to server under heavy load. I get connection rejected by remote interface (335544421). Is this a bug, ot there is an option in firebird.conft to avoid this? Firebird.log (FB20 Classic Server) L3S-4 Wed Oct 24 14:04:28 2012 I/O error for file C:\PROGRAM FILES\FIREBIRD\FIREBIRD_2_0\SECURITY2.FDB L3S-4 Wed Oct 24 14:04:28 2012 lock conflict on no wait transaction L3S-4 Wed Oct 24 14:04:32 2012 Error while trying to access file L3S-4 Wed Oct 24 14:04:32 2012 no permission for read-write access to database C:\PROGRAM FILES\FIREBIRD\FIREBIRD_2_0\SECURITY2.FDB L3S-4 Wed Oct 24 14:04:36 2012 The process cannot access the file because it is being used by another process
[firebird-support] Re: Cannot connect to server under heavy load
Same issue on 2.5.1.26351 Classic Server. A slight difference is that it waits a long time before the connection reject error message. --- In firebird-support@yahoogroups.com, Mark Rotteveel mark@... wrote: On Wed, 24 Oct 2012 12:18:01 -, ma_golyo ma_golyo@... wrote: Hi! Cannot connect to server under heavy load. I get connection rejected by remote interface (335544421). Is this a bug, ot there is an option in firebird.conft to avoid this? Firebird.log (FB20 Classic Server) What is the exact version of your Firebird? Mark
[firebird-support] Cannot connect to server under heavy load
Hi! Cannot connect to server under heavy load. I get connection rejected by remote interface (335544421). Is this a bug, ot there is an option in firebird.conft to avoid this? Firebird.log (FB20 Classic Server) L3S-4 Wed Oct 24 14:04:28 2012 I/O error for file C:\PROGRAM FILES\FIREBIRD\FIREBIRD_2_0\SECURITY2.FDB L3S-4 Wed Oct 24 14:04:28 2012 lock conflict on no wait transaction L3S-4 Wed Oct 24 14:04:32 2012 Error while trying to access file L3S-4 Wed Oct 24 14:04:32 2012 no permission for read-write access to database C:\PROGRAM FILES\FIREBIRD\FIREBIRD_2_0\SECURITY2.FDB L3S-4 Wed Oct 24 14:04:36 2012 The process cannot access the file because it is being used by another process
[firebird-support] Re: Cannot connect to server under heavy load
Hi! 2.0.7.13318 --- In firebird-support@yahoogroups.com, Mark Rotteveel mark@... wrote: On Wed, 24 Oct 2012 12:18:01 -, ma_golyo ma_golyo@... wrote: Hi! Cannot connect to server under heavy load. I get connection rejected by remote interface (335544421). Is this a bug, ot there is an option in firebird.conft to avoid this? Firebird.log (FB20 Classic Server) What is the exact version of your Firebird? Mark
[firebird-support] Re: Cannot connect to server under heavy load
Sometimes I get Unable to complete network request to host l3s-4 (335544721) error not 335544421. In this case nothing apperars in firebird.log. --- In firebird-support@yahoogroups.com, ma_golyo ma_golyo@... wrote: Hi! Cannot connect to server under heavy load. I get connection rejected by remote interface (335544421). Is this a bug, ot there is an option in firebird.conft to avoid this? Firebird.log (FB20 Classic Server) L3S-4 Wed Oct 24 14:04:28 2012 I/O error for file C:\PROGRAM FILES\FIREBIRD\FIREBIRD_2_0\SECURITY2.FDB L3S-4 Wed Oct 24 14:04:28 2012 lock conflict on no wait transaction L3S-4 Wed Oct 24 14:04:32 2012 Error while trying to access file L3S-4 Wed Oct 24 14:04:32 2012 no permission for read-write access to database C:\PROGRAM FILES\FIREBIRD\FIREBIRD_2_0\SECURITY2.FDB L3S-4 Wed Oct 24 14:04:36 2012 The process cannot access the file because it is being used by another process
[firebird-support] Re: Cannot connect to server under heavy load
Now I get cannot attach to password database (335544653) error. Same log as first time. --- In firebird-support@yahoogroups.com, ma_golyo ma_golyo@... wrote: Hi! Cannot connect to server under heavy load. I get connection rejected by remote interface (335544421). Is this a bug, ot there is an option in firebird.conft to avoid this? Firebird.log (FB20 Classic Server) L3S-4 Wed Oct 24 14:04:28 2012 I/O error for file C:\PROGRAM FILES\FIREBIRD\FIREBIRD_2_0\SECURITY2.FDB L3S-4 Wed Oct 24 14:04:28 2012 lock conflict on no wait transaction L3S-4 Wed Oct 24 14:04:32 2012 Error while trying to access file L3S-4 Wed Oct 24 14:04:32 2012 no permission for read-write access to database C:\PROGRAM FILES\FIREBIRD\FIREBIRD_2_0\SECURITY2.FDB L3S-4 Wed Oct 24 14:04:36 2012 The process cannot access the file because it is being used by another process
[firebird-support] Re: Cannot connect to server under heavy load
Another strange fact : Running 1 application with 250 thread where each thread connects to 2 database and runs 2 select works perfectly, BUT Running 50 application with 5 thread where each thread connects to 2 database and runs 2 select throw errors mentioned eralier. --- In firebird-support@yahoogroups.com, ma_golyo ma_golyo@... wrote: Hi! Cannot connect to server under heavy load. I get connection rejected by remote interface (335544421). Is this a bug, ot there is an option in firebird.conft to avoid this? Firebird.log (FB20 Classic Server) L3S-4 Wed Oct 24 14:04:28 2012 I/O error for file C:\PROGRAM FILES\FIREBIRD\FIREBIRD_2_0\SECURITY2.FDB L3S-4 Wed Oct 24 14:04:28 2012 lock conflict on no wait transaction L3S-4 Wed Oct 24 14:04:32 2012 Error while trying to access file L3S-4 Wed Oct 24 14:04:32 2012 no permission for read-write access to database C:\PROGRAM FILES\FIREBIRD\FIREBIRD_2_0\SECURITY2.FDB L3S-4 Wed Oct 24 14:04:36 2012 The process cannot access the file because it is being used by another process
[firebird-support] Keep alive connection (Delpih, IBX)
Hi! When a user leave the machine for a while (not closeing the program) then after returning he cannot continue working. He gets error reading from the connection error. I know the cause. It's TCP timeout. To avoid I have to run dummy select to keep alive. I use IBX to connect FB. My question is : Do I need to run dummy select per active connection or per active transaction? Thank you!
[firebird-support] Re: gbak to a non existing directory - Email found in subject
After installation access right can be set up for Firebird. But directories needed not after the installation but in the future. --- In firebird-support@yahoogroups.com, Milan Babuskov milanb@... wrote: ma_golyo wrote: what if Firebird on Linux is run under special account (as it usually made by linux administrators)? That is why I want/expect to create missing directory with Firebird/gbak. It can create file but not a directory? Actually, you cannot create any file by default. The only directory where firebird has write access after installation is the directory where Firebird is installed (/opt/firebird or different, depends on distrubution and package you use). Creating directories for databases should really be done right after Firebird is installed. -- Milan Babuskov == The easiest way to import XML, CSV and textual files into Firebird: http://www.guacosoft.com/xmlwizard ==
[firebird-support] Re: gbak to a non existing directory - Email found in subject
You created that schema, don't want to change it, and want Firebird be changed for your needs? Yep, that is the case. ;) Really, as it was said, creating db anywhere at the filesystem is dangerous, and violates lot of administrative and security rules. I cannot create DB anywhere, because OS controls the access. If Firebird has no right to create file/directory then I expect to get error. --- In firebird-support@yahoogroups.com, Dmitry Kuzmenko kdv@... wrote: Hello, ma_golyo! Thursday, June 7, 2012, 5:32:10 PM, you wrote: m That is why I want/expect to create missing directory with m Firebird/gbak. It can create file but not a directory? It's strange to me. because directories for databases, etc, must be created by administator. It is not strange. Your wish - is strange. m why to separate customer's DBs by folders? Why not to place all of m them into one folder? m Namespace separation. Each customer has a fix named DB and any m number of (at least 1) custom named DB. you created that schema, don't want to change it, and want Firebird be changed for your needs? Really, as it was said, creating db anywhere at the filesystem is dangerous, and violates lot of administrative and security rules. m --- In firebird-support@yahoogroups.com, Dmitry Kuzmenko kdv@ wrote: Hello, ma_golyo! Thursday, June 7, 2012, 2:25:05 PM, you wrote: m To stat a new customer we have to m #1 : copy the app to new folder (win) m #2 : copy the initial DB to new folder (linux) m #3 : update inital DB metadata to current app version m I'm writing (Delphi) app which does the steps above. App runs on the terminal (win) server. what if Firebird on Linux is run under special account (as it usually made by linux administrators)? why to separate customer's DBs by folders? Why not to place all of them into one folder? Do you use aliases.conf? If not, and db and folder name somehow related to the customer (name, id, etc), some customer can think of hacking some other client's DB. So, I understand that you are trying to make process automatic, but the result looks insecure. m --- In firebird-support@yahoogroups.com, Michael Ludwig milu71@ wrote: ma_golyo schrieb am 07.06.2012 um 06:07 (-): Why do you not want something like that? What is te purpose of this restriction? Or it's not a restriction, just not implemeted? Guess most people back up their databases to known locations, be it locally or on the server. Willy-nilly creation of folders simply isn't necessary. I'd say it is even undesirable because it could create a folder by accident because you mistyped the path and then your important backup might end up in a folder that you don't have on your radar and so it would be effectively lost when you need it. Why would you want to create a new folder from another machine instead of just backing up to C:\Backups ? Explain your use case if you have a good one. Michael m m ++ m Visit http://www.firebirdsql.org and click the Resources item m on the main (top) menu. Try Knowledgebase and FAQ links ! m Also search the knowledgebases at http://www.ibphoenix.com m ++ m Yahoo! Groups Links -- Dmitry Kuzmenko, www.ib-aid.com m m ++ m Visit http://www.firebirdsql.org and click the Resources item m on the main (top) menu. Try Knowledgebase and FAQ links ! m Also search the knowledgebases at http://www.ibphoenix.com m ++ m Yahoo! Groups Links -- Dmitry Kuzmenko, www.ib-aid.com
[firebird-support] Re: gbak to a non existing directory - Email found in subject
Why do you not want something like that? What is te purpose of this restriction? Or it's not a restriction, just not implemeted? --- In firebird-support@yahoogroups.com, Leyne, Sean Sean@... wrote: Running gbak -c does not create directories when not exists. How can I force to create directories? I cannot find any gbak swith which can help. There is no switch to do that. Nor would I want one. Performing file system folder operations is not something that gbak should be doing. Sean
[firebird-support] Re: gbak to a non existing directory - Email found in subject
We have - a terminal (win) server where our customers runs our installed client (Delphi) apps, each has it's own version of app in separate folders. - a DB (linux) server where each customer have his databases in separate folders To stat a new customer we have to #1 : copy the app to new folder (win) #2 : copy the initial DB to new folder (linux) #3 : update inital DB metadata to current app version I'm writing (Delphi) app which does the steps above. App runs on the terminal (win) server. #1 : OK #2 : not OK. I cannot create new DB with FB, and I cannot restore a DB with GBAK to a non existing directory. #3 : OK (if #2 done manually) --- In firebird-support@yahoogroups.com, Michael Ludwig milu71@... wrote: ma_golyo schrieb am 07.06.2012 um 06:07 (-): Why do you not want something like that? What is te purpose of this restriction? Or it's not a restriction, just not implemeted? Guess most people back up their databases to known locations, be it locally or on the server. Willy-nilly creation of folders simply isn't necessary. I'd say it is even undesirable because it could create a folder by accident because you mistyped the path and then your important backup might end up in a folder that you don't have on your radar and so it would be effectively lost when you need it. Why would you want to create a new folder from another machine instead of just backing up to C:\Backups ? Explain your use case if you have a good one. Michael
[firebird-support] Re: gbak to a non existing directory - Email found in subject
what if Firebird on Linux is run under special account (as it usually made by linux administrators)? That is why I want/expect to create missing directory with Firebird/gbak. It can create file but not a directory? It's strange to me. why to separate customer's DBs by folders? Why not to place all of them into one folder? Namespace separation. Each customer has a fix named DB and any number of (at least 1) custom named DB. Do you use aliases.conf? If not, and db and folder name somehow related to the customer (name, id, etc), some customer can think of hacking some other client's DB. No aliases.conf. On the terminal (win) the customer has restricted access to apps, can access to DB only through our app. --- In firebird-support@yahoogroups.com, Dmitry Kuzmenko kdv@... wrote: Hello, ma_golyo! Thursday, June 7, 2012, 2:25:05 PM, you wrote: m To stat a new customer we have to m #1 : copy the app to new folder (win) m #2 : copy the initial DB to new folder (linux) m #3 : update inital DB metadata to current app version m I'm writing (Delphi) app which does the steps above. App runs on the terminal (win) server. what if Firebird on Linux is run under special account (as it usually made by linux administrators)? why to separate customer's DBs by folders? Why not to place all of them into one folder? Do you use aliases.conf? If not, and db and folder name somehow related to the customer (name, id, etc), some customer can think of hacking some other client's DB. So, I understand that you are trying to make process automatic, but the result looks insecure. m --- In firebird-support@yahoogroups.com, Michael Ludwig milu71@ wrote: ma_golyo schrieb am 07.06.2012 um 06:07 (-): Why do you not want something like that? What is te purpose of this restriction? Or it's not a restriction, just not implemeted? Guess most people back up their databases to known locations, be it locally or on the server. Willy-nilly creation of folders simply isn't necessary. I'd say it is even undesirable because it could create a folder by accident because you mistyped the path and then your important backup might end up in a folder that you don't have on your radar and so it would be effectively lost when you need it. Why would you want to create a new folder from another machine instead of just backing up to C:\Backups ? Explain your use case if you have a good one. Michael m m ++ m Visit http://www.firebirdsql.org and click the Resources item m on the main (top) menu. Try Knowledgebase and FAQ links ! m Also search the knowledgebases at http://www.ibphoenix.com m ++ m Yahoo! Groups Links -- Dmitry Kuzmenko, www.ib-aid.com
[firebird-support] Re: gbak to a non existing directory - Email found in subject
a. This is plan B. b. It's very creative, but ugly... :) --- In firebird-support@yahoogroups.com, Milan Babuskov milanb@... wrote: ma_golyo wrote: To stat a new customer we have to #1 : copy the app to new folder (win) #2 : copy the initial DB to new folder (linux) #3 : update inital DB metadata to current app version I'm writing (Delphi) app which does the steps above. App runs on the terminal (win) server. #1 : OK #2 : not OK. I cannot create new DB with FB, and I cannot restore a DB with GBAK to a non existing directory. I'm not sure about Delphi's capabilities here, but I see two possible solutions: a) log into Linux using SSH protocol and create directory using the system mkdir command with --parents switch. Then set up privileges with chown and chmod. b) write small Linux UDF that creates directories, register it in some database (employee.fdb for example) and call it from code: db.Query(select createDir(/path/on/linux) from rdb$database); HTH -- Milan Babuskov == The easiest way to import XML, CSV and textual files into Firebird: http://www.guacosoft.com/xmlwizard ==
[firebird-support] gbak to a non existing directory
Hi! Running gbak -c does not create directories when not exists. How can I force to create directories? I cannot find any gbak swith which can help.
[firebird-support] Re: gbak to a non existing directory
I want to restor to a remote server so batch is not good for me :( --- In firebird-support@yahoogroups.com, Michael Ludwig milu71@... wrote: ma_golyo schrieb am 06.06.2012 um 11:45 (-): Running gbak -c does not create directories when not exists. How can I force to create directories? I cannot find any gbak swith which can help. Forcing won't help - GBAK is not an eierlegende Wollmilchsau. https://www.google.com/search?q=eierlegende+Wollmilchsautbm=isch Use the command-line processor: D:\MiLu\RepoHgSvn\comp\win\http :: more restore.bat @ECHO OFF IF /I %~x1 NEQ .bak GOTO:USAGE IF /I %~x2 NEQ .gdb GOTO:USAGE IF%3 NEQ GOTO:USAGE IF NOT EXIST %~dp2 md %~dp2 gbak -c %1 %~f2 echo %~f2 dir %~f2 GOTO:EOF :USAGE ECHO Usage: %0 path\to\my.bak path\to\my\restored.gdb 2 REM -- Michael
[firebird-support] Re: Execute Block SQL error 901 ISC error 335544569
If you use IBX to connect then ParamCheck of TIBQuery should be FALSE. --- In firebird-support@yahoogroups.com, Jack Mills millsjack14@... wrote: I have a query that show the above error, yet runs OK when run from IBExpert. EXECUTE BLOCK AS declare variable D bigint; declare variable A bigint; declare variable V integer; declare variable I bigint; declare variable J bigint; declare variable X integer; declare variable W integer; declare variable U integer; begin select first 1 (cast(DXS_NO as integer)) from IMPORT_DXS where Used = 'T' into i; select max(cast(DXS_NO as integer)) from IMPORT_DXS where Used = 'T' into j; while (i = j) do begin select cast(dxs_no as integer), cast(abs_no as integer), cast(Value1 as integer), cast(uop as integer), cast(DB as integer), cast(DW as integer) from IMPORT_DXS where :i = cast(dxs_no as integer) into d, a, v, u, x, w; update DXS set ABS_NO = :a, Value1 = :v, USED = 'T', UOP = :u where DX = :x and DW = :w; i= i+1; end end Prior to this query are 2 others. the 1st uses an execute block statement to delete IMPORT_DXS if it exists the 2nd creates the IMPORT_DXS table from an external file, both of these run without errors. Can anyone see where I'm going wrong? Jack
[firebird-support] Re: firebird.log fb_lock_mgr: segfault
Looks like this : http://firebird.1100200.n4.nabble.com/FB-2-0-3-classic-is-blocking-on-4xCPU-64bit-opteron-system-under-heavy-load-td1121449.html --- In firebird-support@yahoogroups.com, ma_golyo ma_golyo@... wrote: Hi! Config : FB 2.0.6 ClassicServer on Linux firebird.log contains the followings : kernel: fb_lock_mgr: segfault at 2e9e eip 0804dabc esp bfe43840 error 4 kernel: fb_lock_mgr: segfault at 20ca eip 0804dabc esp bfa722c0 error 4 What is the meaning of this, what cause it, and how can I avoid it?
[firebird-support] Re: UDF ISC_QUAD typedef compiled with gcc (64 bit )
I have found the solution in ibase.h. :) #if defined(_LP64) || defined(__LP64__) || defined(__arch64__) typedef int ISC_LONG; typedef unsigned intISC_ULONG; #else typedef signed long ISC_LONG; typedef unsigned long ISC_ULONG; #endif struct GDS_QUAD_t { ISC_LONG gds_quad_high; ISC_ULONG gds_quad_low; }; typedef struct GDS_QUAD_t GDS_QUAD; typedef struct GDS_QUAD_t ISC_QUAD; --- In firebird-support@yahoogroups.com, ma_golyo ma_golyo@... wrote: Hi! Current c code : typedef struct { #ifdef __LP64__ signed long slong; unsigned long ulong; #else signed int slong; unsigned int ulong; #endif } ISC_QUAD; It's OK on win32, win64, linux32. It's not ON linux64, time fraction is incorrect. What do I need to change to get good result on linux64? PS: It's also strange that win64 is OK, but linux64 not.
[firebird-support] firebird.log fb_lock_mgr: segfault
Hi! Config : FB 2.0.6 ClassicServer on Linux firebird.log contains the followings : kernel: fb_lock_mgr: segfault at 2e9e eip 0804dabc esp bfe43840 error 4 kernel: fb_lock_mgr: segfault at 20ca eip 0804dabc esp bfa722c0 error 4 What is the meaning of this, what cause it, and how can I avoid it?
[firebird-support] Re: Inno Setup SuperClassic
Yep, /TASKS=SuperClassicTask was the answer, it works. :) Thank You! --- In firebird-support@yahoogroups.com, Thomas Steinmaurer ts@... wrote: I'm updating an installer made with Inno Setup. Current version is installing CS : /COMPONENTS=ServerComponent,ServerComponent\ClassicServerComponent,DevAdminComponent,ClientComponent'; I want to change it to SC. What sould I change in the firebird install parameters? The executable file (fb_inet_server.exe) is the same for both, Classic and SuperClassic. The visual installer offers a checkbox to run SuperClassic, which is according to the inno setup project file implemented as a task called SuperClassicTask. So you could try to add the following part to your inno setup call: /TASKS=SuperClassicTask or if you are already using /TASKS with other entries, simply add SuperClassicTask to the comma separated list. I'm not sure if this works, but it's worth for a test. -- With regards, Thomas Steinmaurer (^TS^) Firebird Technology Evangelist http://www.upscene.com/ Do you care about the future of Firebird? Join the Firebird Foundation: http://www.firebirdsql.org/en/firebird-foundation/
[firebird-support] Inno Setup SuperClassic
Hi! I'm updating an installer made with Inno Setup. Current version is installing CS : /COMPONENTS=ServerComponent,ServerComponent\ClassicServerComponent,DevAdminComponent,ClientComponent'; I want to change it to SC. What sould I change in the firebird install parameters? Thank you!
[firebird-support] Re: Slow Commit
Hi! Maybe this is your case : Forced Writes Performance impact on #Ubuntu with ext4 no barrier http://www.firebirdnews.org/?p=6421 --- In firebird-support@yahoogroups.com, aalliana aalliana@... wrote: Hello, I'm trying to upgrade a box running ubuntu + firebird that has been running for a while. The old box has Ubuntu 8.04 + firebird 2.1.1 SS running on dual core hardware. The new box has Ubuntu 10.04 + firebird 2.1.4 SS running on a 8 core hareware. I undestand that there are too many variables involved, but is hard to maintain all systems the same to perform the tests. After performing many tests using a profiler, I arrived to the conclusion that the commits take a lot longer on the new hardware configuration. Everything is running faster but commiting takes longer. The hard disk hardware is better, a 7200 RMP SATA drive. Does anybody have any suggestions? PS: On the new hardware, I first installed firebird 2.1.4 Classic, because of lousy performance I changed it to SS. Thanks in advance.
[firebird-support] Re: varchar size off by 1
Hi! http://tracker.firebirdsql.org/browse/CORE-3373 http://tracker.firebirdsql.org/browse/CORE-3669 --- In firebird-support@yahoogroups.com, Joerg Fischer jf505@... wrote: hi, i have a firebird superserver v2.5.1 on win32, and a table with several varchar columns of different sizes. for instance, insert into INTERES (ianrede, itelefon) values ('1234567890', '123456789012345678901234567890') where ianrede is a varchar(10) and itelefon is a varchar(30) works as expected. The database is utf-8, don't know if this is related. Now the problem: insert into INTERES (ianrede, itelefon) values ('12345678901', '123456789012345678901234567890') gives a 'arithmetic overflow...' error, again just like expected. BUT insert into INTERES (ianrede, itelefon) values ('1234567890', '1234567890123456789012345678901') works! The entry ist created, and contains 31 characters in a varchar(30) row. (This results in an exception later on in a delphi component). Only insert into INTERES (ianrede, itelefon) values ('1234567890', '12345678901234567890123456789012') gives a 'arithmetic overflow...' error just like the sql statement with the 31 chars should do already. Is this a known problem/bug? Best regards Jörg -- NEU: FreePhone 3-fach-Flat mit kostenlosem Smartphone! Jetzt informieren: http://mobile.1und1.de/?ac=OM.PW.PW003K20328T7073a
[firebird-support] UDF memory allocation for result string in Linux
Hi! When I run my UDF (udf_op), I get an error : Bad written UDF detected: pointer returned in FREE_IT function was not allocated by ib_util_malloc I use ib_util_malloc in my Win version, no problem there. What should I use in Linux version? Currently memory allocated with malloc. SQL: DECLARE EXTERNAL FUNCTION UDF_OP RETURNS CSTRING(10) FREE_IT ENTRY_POINT 'udf_op' MODULE_NAME 'UDF3s'; C: char * udf_op(); char * udf_op() { char *buffer = (char *)malloc(10); strncpy(buffer, Linux, 6); return buffer; } C compiled with : gcc -c -O -fpic UDF3s.c ld -G UDF3s.o -lm -lc -o UDF3s.so Thank You!
[firebird-support] Re: UDF memory allocation for result string in Linux
I've already have an x86 (LI-V2.5.1.26351 Firebird 2.5 Firebird/linux Intel on port 52), and an x86_64 (LI-V2.5.2.26415 Firebird 2.5 Firebird/linux AMD64 on port 50) Firebird already running paralell. Tried as you said, but no luck (see my prev. reply). :( Guess I have to install an x32 Linux on a VM. Thank You! --- In firebird-support@yahoogroups.com, Tomasz Tyrakowski t.tyrakowski@... wrote: On 2012-04-17 09:37, ma_golyo wrote: I compiled it under x64 and the output is also x64, and used under x64 FB25. How I compile to get x32? -m32 option gives me a bunch of errors : You need i686 version of Firebird (to get 32-bit libfb_util.so) and 32-bit compatibility development libraries in your Linux distribution (so-called ia32-libs). The simpliest way is probably a parallel 32-bit Linux distribution (maybe in a virtual machine?) with 32-bit Firebird installed. Otherwise, it would be better to have some experience (or someone experienced ;) ) with cross-compiling from x86_64 to x86. A general hint: install 32-bit Firebird in a different location, use -L/firebird-32-location/lib and -m32 when compiling for x86, and -L/firebird-64-location/lib when compiling for x86_64. regards Tomasz -- __--==--__ __--== Tomasz Tyrakowski==--__ __--==SOL-SYSTEM==--__ __--== http://www.sol-system.pl ==--__ __--==--__
[firebird-support] Re: rdb$procedure_parameters non index read
Tryed with ACS and DESC index. No change, still the same non index reads. Do I upload my test database? --- In firebird-support@yahoogroups.com, Dmitry Yemanov dimitr@... wrote: 10.01.2012 13:36, ma_golyo wrote: The question is, the non index read is a firebird engine bug or not? Maybe not really a bug but something sub-optimal. (I think standard DDL command shoud ALWAYS read via indicies in the background.) Try creating an index on RDB$PROCEDURE_PARAMETERS.RDB$FIELD_SOURCE and see whether it helps. If it does then it's a known issue that has already been fixed in the latest v2.5.2 snapshot builds. Dmitry
[firebird-support] Re: rdb$procedure_parameters non index read
Tryed with the latest FB2.5 snapshot. It works! (It has 2 new index in rdb$procedure_parameters) Now I has only 92 index read. :) (Execute time = 7s 422ms) Thank you! --- In firebird-support@yahoogroups.com, ma_golyo ma_golyo@... wrote: Tryed with ACS and DESC index. No change, still the same non index reads. Do I upload my test database? --- In firebird-support@yahoogroups.com, Dmitry Yemanov dimitr@ wrote: 10.01.2012 13:36, ma_golyo wrote: The question is, the non index read is a firebird engine bug or not? Maybe not really a bug but something sub-optimal. (I think standard DDL command shoud ALWAYS read via indicies in the background.) Try creating an index on RDB$PROCEDURE_PARAMETERS.RDB$FIELD_SOURCE and see whether it helps. If it does then it's a known issue that has already been fixed in the latest v2.5.2 snapshot builds. Dmitry
[firebird-support] rdb$procedure_parameters non index read
Hi! I'm analysing my stored procedure run with IBExpert, and I can't figure out what can cause rdb$procedure_parameters non index reads. facts : - procedure do not read rdb$procedure_parameters directly - procedure creates and alters procedures, view, triggers (via execute statement in autonomous transaction) It looks like, that firebird inner engine does something wrong, and do not user index (missing index or wrong select?). Any idea? Thank You!
[firebird-support] Re: rdb$procedure_parameters non index read
LI-V6.3.1.26319 Firebird 2.5 ODS 11.2 --- In firebird-support@yahoogroups.com, Leyne, Sean Sean@... wrote: I'm analysing my stored procedure run with IBExpert, and I can't figure out what can cause rdb$procedure_parameters non index reads. Please confirm which version of Firebird you are running? Sean
[firebird-support] Re: rdb$procedure_parameters non index read
|90 | 0 | 12 | 0 | 4 | | RDB$PROCEDURE_PARAMETERS| 0 |98 | 32571 | 9 | 1 | 9 | | RDB$REF_CONSTRAINTS| 0 | 0 | 0 | 0 | 0 | 10 | | RDB$RELATIONS| 0 | 4656 | 0 | 359 | 0 | 37 | | RDB$RELATION_CONSTRAINTS| 0 | 773 |3870 | 0 | 0 | 31 | | RDB$RELATION_FIELDS| 0 | 5395 | 0 | 835 | 0 | 373 | | RDB$SECURITY_CLASSES| 0 |47 | 0 | 0 | 0 | 78 | | RDB$TRIGGERS| 0 | 1148 | 0 | 88 | 0 | 60 | | RDB$USER_PRIVILEGES| 0 | 374 | 0 | 0 | 0 | 189 | |RDB$VIEW_RELATIONS| 0 | 599 | 0 | 0 | 21 | 48 | +--+---+---+-+--\ ---+-+-+ --- In firebird-support@yahoogroups.com, Dmitry Yemanov dimitr@... wrote: 09.01.2012 20:53, ma_golyo wrote: I'm analysing my stored procedure run with IBExpert, and I can't figure out what can cause rdb$procedure_parameters non index reads. facts : - procedure do not read rdb$procedure_parameters directly - procedure creates and alters procedures, view, triggers (via execute statement in autonomous transaction) It looks like, that firebird inner engine does something wrong, and do not user index (missing index or wrong select?). Does it cause you any real issues? Dmitry [Non-text portions of this message have been removed]
[firebird-support] Re: CPU selection for Firebird Database
I can confirm the ext-4 problem (real experience) Also see : http://www.firebirdnews.org/?p=6421 Forget XP32, can only use max 2 CPU core. --- In firebird-support@yahoogroups.com, trskopo trskopo@... wrote: --- In firebird-support@yahoogroups.com, yanto_asnawi@ wrote: Hi, I use intel core i7 and centos 6 64bit Harddisk raid level 0, SATA wetern digital raptor performance : excellent. Thanks for your reply. Could you be more specific about your specs for I7 and wd raptor? Also, do you use ext4 and forced write on on CentOS? I heard, there is problem when using ext4 file system and forced write on. best regards, Sugiarto
[firebird-support] Re: Problem with compound index
Hi! I found this also and reported it. This is a known bug : http://tracker.firebirdsql.org/browse/CORE-3052 Unfortunatley still not fixed and no sign of doing it... :( --- In firebird-support@yahoogroups.com, tomkrej respektive@... wrote: Hi all, I have interesting problem with compound index. I have records in one table divided in a groups by field TYP and each record has its name field TRIDNAZ TRIDNAZ is varchar(40) character set WIN1250 collation PXW_CSY TYP is smallint I had 2 indexes - on TRIDNAZ only, and on TYP, TRIDNAZ And I have query select * from FOND where TYP = :typ and TRIDNAZ starting with :text order by TRIDNAZ; when I set text = 'C' the result set was empty when I set text = 'CA' the result set was filled with records starting with 'CA' I can't found the reason why was 'C' empty. I saw the plan and the server use compound index - TYP, TRIDNAZ When I dropped it, server us TRIDNAZ only index and - wow - 'C' records exists. I think there is some foult in compound index smallint + varchar(WIN1250) and characte C It could be the reason that in Czech languague is 'Ch' one character not two. When I change it to two separate indexes - TYP and TRIDNAZ Server use both of them and works correctly. Please correct this error - it is tested on 2.1 and 2.5 on windows Tom