[firebird-support] RE: very slow inserts with blob-fields

2014-03-05 Thread ma_golyo
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?

2013-07-11 Thread ma_golyo
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

[firebird-support] Re: Question about Temp Directory

2013-07-11 Thread ma_golyo
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

[firebird-support] XE4, Interbase Express, 32/64bit, Firebird 2.5.2

2013-06-24 Thread ma_golyo
Hi! Are there any known incompability issues? Thank you!

[firebird-support] Re: XE4, Interbase Express, 32/64bit, Firebird 2.5.2

2013-06-24 Thread ma_golyo
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

[firebird-support] Re: Is windows better than Linux for Firebird 2.5 64 bit?

2012-11-06 Thread ma_golyo
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

[firebird-support] Re: Cannot connect to server under heavy load

2012-10-27 Thread ma_golyo
--- 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

[firebird-support] Re: Cannot connect to server under heavy load

2012-10-26 Thread ma_golyo
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

[firebird-support] Re: Cannot connect to server under heavy load

2012-10-25 Thread ma_golyo
--- 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

[firebird-support] Re: Cannot connect to server under heavy load

2012-10-25 Thread ma_golyo
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

[firebird-support] Re: Cannot connect to server under heavy load

2012-10-25 Thread ma_golyo
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

[firebird-support] Cannot connect to server under heavy load

2012-10-24 Thread ma_golyo
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

[firebird-support] Re: Cannot connect to server under heavy load

2012-10-24 Thread ma_golyo
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

[firebird-support] Re: Cannot connect to server under heavy load

2012-10-24 Thread ma_golyo
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

[firebird-support] Re: Cannot connect to server under heavy load

2012-10-24 Thread ma_golyo
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

[firebird-support] Re: Cannot connect to server under heavy load

2012-10-24 Thread ma_golyo
@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

[firebird-support] Keep alive connection (Delpih, IBX)

2012-08-29 Thread ma_golyo
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

[firebird-support] Re: gbak to a non existing directory - Email found in subject

2012-06-08 Thread ma_golyo
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

[firebird-support] Re: gbak to a non existing directory - Email found in subject

2012-06-08 Thread ma_golyo
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

[firebird-support] Re: gbak to a non existing directory - Email found in subject

2012-06-07 Thread ma_golyo
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

[firebird-support] Re: gbak to a non existing directory - Email found in subject

2012-06-07 Thread ma_golyo
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

[firebird-support] Re: gbak to a non existing directory - Email found in subject

2012-06-07 Thread ma_golyo
. 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

[firebird-support] Re: gbak to a non existing directory - Email found in subject

2012-06-07 Thread ma_golyo
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

[firebird-support] gbak to a non existing directory

2012-06-06 Thread ma_golyo
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

2012-06-06 Thread ma_golyo
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

[firebird-support] Re: Execute Block SQL error 901 ISC error 335544569

2012-06-06 Thread ma_golyo
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

[firebird-support] Re: firebird.log fb_lock_mgr: segfault

2012-06-01 Thread ma_golyo
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

[firebird-support] Re: UDF ISC_QUAD typedef compiled with gcc (64 bit )

2012-06-01 Thread ma_golyo
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

[firebird-support] firebird.log fb_lock_mgr: segfault

2012-05-31 Thread ma_golyo
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

[firebird-support] Re: Inno Setup SuperClassic

2012-05-24 Thread ma_golyo
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 :

[firebird-support] Inno Setup SuperClassic

2012-05-23 Thread ma_golyo
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

2012-05-04 Thread ma_golyo
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

[firebird-support] Re: varchar size off by 1

2012-04-23 Thread ma_golyo
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

[firebird-support] UDF memory allocation for result string in Linux

2012-04-17 Thread ma_golyo
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:

[firebird-support] Re: UDF memory allocation for result string in Linux

2012-04-17 Thread ma_golyo
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

[firebird-support] Re: rdb$procedure_parameters non index read

2012-01-10 Thread ma_golyo
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

[firebird-support] Re: rdb$procedure_parameters non index read

2012-01-10 Thread ma_golyo
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

[firebird-support] rdb$procedure_parameters non index read

2012-01-09 Thread ma_golyo
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

[firebird-support] Re: rdb$procedure_parameters non index read

2012-01-09 Thread ma_golyo
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

[firebird-support] Re: rdb$procedure_parameters non index read

2012-01-09 Thread ma_golyo
| +--+---+---+-+--\ ---+-+-+ --- 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

[firebird-support] Re: CPU selection for Firebird Database

2011-12-17 Thread ma_golyo
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

[firebird-support] Re: Problem with compound index

2011-09-07 Thread ma_golyo
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