Re: [firebird-support] BLOB field null without update on that field

20.11.2019 09:19, Oliver Garbe oliver.ga...@ttc-informatik.de [firebird-support] wrote: > Any idea why this happens? http://tracker.firebirdsql.org/browse/CORE-6090 https://github.com/FirebirdSQL/firebird/commit/27ae5889208eb93cdf090d79ee02fe22b96e6530 -- WBR, SD.

[firebird-support] BLOB field null without update on that field

Hi, I encountered the problem that several fields of type BLOB in a table (which were not null before) were suddenly null without an update on that field . Steps to reproduce the problem: 1) convert database from Firebird 2 to Firebird 3 (via backup/restore with Firebird 3.0.4) 2) add a new

Re: [firebird-support] BLOB Not Found error

> 16.03.2018 14:47, shg_siste...@yahoo.com.ar [firebird-support] wrote: >> Since some days ago I'm getting (it seems very occasionally and randomly) a >> "blob not >> found" error. >> As far as I remember the problem happens during read operations: with >> "locate" commands or >> inside a

Re: [firebird-support] BLOB Not Found error

16.03.2018 15:26, shg_siste...@yahoo.com.ar [firebird-support] wrote: > The same applies if the record wasn't deleted but changed by another > transaction? Yes. From technical POV there is no difference between update and delete in Firebird. -- WBR, SD.

Re: [firebird-support] BLOB Not Found error

Thanks Dimitry! The same applies if the record wasn't deleted but changed by another transaction? Because in this particular table there are no record deletion. But a lot of blob fields editions all the time. Sergio

Re: [firebird-support] BLOB Not Found error

16.03.2018 14:47, shg_siste...@yahoo.com.ar [firebird-support] wrote: > Since some days ago I'm getting (it seems very occasionally and randomly) a > "blob not > found" error. > As far as I remember the problem happens during read operations: with > "locate" commands or > inside a "while not

[firebird-support] BLOB Not Found error

Hello! I use Delphi XE2 / Firebird 2.5 / IBDAC 6.0.2 Since some days ago I'm getting (it seems very occasionally and randomly) a "blob not found" error. As far as I remember the problem happens during read operations: with "locate" commands or inside a "while not eof" loop... I don't

Re: [firebird-support] Blob concat not working in FB 2.5.2

On 31-1-2018 16:07, Chuck Belanger phytot...@lanset.com [firebird-support] wrote: > Hello: > > In a stored procedure I am trying to concat two blob TEXT fields. One > typically is text with RTF formating code about 1-30k long and the other > may be simple text about 1-4 k long. > > According to

[firebird-support] Blob concat not working in FB 2.5.2

Hello: In a stored procedure I am trying to concat two blob TEXT fields. One typically is text with RTF formating code about 1-30k long and the other may be simple text about 1-4 k long. According to the FB reference manual || should output a , but for the larger text blobs it will simply

Re: [firebird-support] Blob field to Array

: Thursday, May 11, 2017 1:03 PM To: firebird-support@yahoogroups.com Subject: [firebird-support] Blob field to Array Hi, I've got a blobfield which contains an array of boolean. I would like to get a value from a certain position from this array to use in a stored procedure. Does someone know how

[firebird-support] Blob field to Array

Hi, I've got a blobfield which contains an array of boolean. I would like to get a value from a certain position from this array to use in a stored procedure. Does someone know how this is done? I've searched the internet for it, but can't get it to work. Thanks in advance, Maarten

Re: [firebird-support] Blob Sub Type 1 and character limits with UTF8

Thanks, didn't find any reference to requiring varchar in docs, although all examples are varchar's. regards Si On 24 November 2016 at 17:49, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 24.11.2016 15:35, Si Carter s1car...@gmail.com

Re: [firebird-support] Blob Sub Type 1 and character limits with UTF8

Thanks Mark, Originally noticed this as used in a SP, with parameters, the parameter being a blob which internally calls EXECUTE STATEMENT SET TERM ^ ; ALTER PROCEDURE REMOTEUPDATES ( IPSQL Blob sub_type 1 ) AS begin EXECUTE STATEMENT ipSQL; end^ SET TERM ; ^ So wondering now if Execute

Re: [firebird-support] Blob Sub Type 1 and character limits with UTF8

On 24-11-2016 11:02, Si Carter s1car...@gmail.com [firebird-support] wrote: > Using FB3 on windows I get the error message: > > String literal with 30465 characters exceeds the maximum length of 16383 > characters for the UTF8 character set > > As a test I created a new db (UTF8) with the

[firebird-support] Blob Sub Type 1 and character limits with UTF8

Hi, Using FB3 on windows I get the error message: String literal with 30465 characters exceeds the maximum length of 16383 characters for the UTF8 character set As a test I created a new db (UTF8) with the following table CREATE TABLE WS_CUSTOM_PAGES ( ID Bigint NOT NULL, PAGE_DATA Blob

[firebird-support] Blob concat consume memory - why?

Hi,   why concating blob consume memory and not leave it until transaction end?   simple sample   SET TERM ^ ;   CREATE PROCEDURE TEST_BLOB_CONCAT   ( A BLOB SUB_TYPE TEXT, ILE INTEGER )  RETURNS   ( B BLOB SUB_TYPE TEXT ) AS  DECLARE VARIABLE VAR_I INTEGER;  BEGIN   VAR_I = 0;   B = 'ABC';  

Re: [firebird-support] Blob concat consume memory - why?

At 07:27 p.m. 24/06/2015, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: why concating blob consume memory and not leave it until transaction end? It looks like some temp buffers are created and not freed until transaction end Is this bug reported or i should report it to

Re: Re: [firebird-support] Blob concat consume memory - why?

    W dniu 2015-06-24 09:51:58 użytkownik Helen Borrie hele...@iinet.net.au [firebird-support] firebird-support@yahoogroups.com napisał:   At 07:27 p.m. 24/06/2015, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: why concating blob consume memory and not leave it until

Re: Re: Re: [firebird-support] Blob concat consume memory - why?

    W dniu 2015-06-24 11:56:28 użytkownik Helen Borrie hele...@iinet.net.au [firebird-support] firebird-support@yahoogroups.com napisał:   At 08:03 p.m. 24/06/2015, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: Hi Hellen, it looks like bug is not fixed only minimized? I

Re: Re: [firebird-support] Blob concat consume memory - why?

At 08:03 p.m. 24/06/2015, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: Hi Hellen, it looks like bug is not fixed only minimized? I test this with current FB3 snapshot. I see that this fix - not fix reason of the bug - only minimize it? Should i post this as new bug into

FWD: [firebird-support] Blob concat consume memory - why?

    Hi,   why concating blob consume memory and not leave it until transaction end?   simple sample   SET TERM ^ ;   CREATE PROCEDURE TEST_BLOB_CONCAT   ( A BLOB SUB_TYPE TEXT, ILE INTEGER )  RETURNS   ( B BLOB SUB_TYPE TEXT ) AS  DECLARE VARIABLE VAR_I INTEGER;  BEGIN   VAR_I = 0;   B = 'ABC';  

Re: Re: FWD: [firebird-support] Blob concat consume memory - why?

  You forwarded it to firebird-support, not to firebird-devel. Mark Fixed ;-)   regards, Karol Bieniaszewski

Re: FWD: [firebird-support] Blob concat consume memory - why?

You forwarded it to firebird-support, not to firebird-devel. Mark On 24-6-2015 12:12, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: Hi, why concating blob consume memory and not leave it until transaction end? simple sample SET TERM ^ ;

RE: [firebird-support] BLOB

Text, binary, it's all the same to gbak.   Try the -g suggestion - if gbak is cleaning out garbage, it's slow. But, surely, the garbage has to be cleaned out sooner or later, and doing it in a backup run is the cheapest way to do it, as every record is being visited anyway? (Compared to, say,

Re: [firebird-support] BLOB

I recorded the process of backup , if anybody would be so kind to help me, please take a look at : FireBirdBackup http://youtu.be/txUruy35qHE image http://youtu.be/txUruy35qHE FireBirdBackup http://youtu.be/txUruy35qHE This feature is not available right now. Please

Re: [firebird-support] BLOB

Better yet, use fbsvcmgr remotehost:service_mgr -user sysdba -password XXX action_backup -dbname some.fdb -bkp_file stdout some.fbk 2014-10-13 16:18 GMT+03:00 Thomas Steinmaurer t...@iblogmanager.com [firebird-support] firebird-support@yahoogroups.com: Are you running gbak from your local

Re: [firebird-support] BLOB

my BLOB records are plain text phrases, somewhere between 1 and 400 char-s , containing setup information (in Delphi I save a TStringList to file and I backup that file in my database). My question was about saving these tables with gbak -v (verbose) where I can see the time spent to backup

RE: [firebird-support] BLOB

Carlos, LSSBcfs Our application uses BLOB fairly extensively and can report LSSBcfs that the GBAK disk write rate increases very significantly when LSSBcfs tables with Blobs are being backed-up, orders of magnitude LSSBcfs faster than tables with small rows (YMMV), so this suggests LSSBcfs

Re: [firebird-support] BLOB

On Fri, Oct 10, 2014 at 9:58 AM, tiberiu_horv...@yahoo.com [firebird-support] firebird-support@yahoogroups.com wrote: my BLOB records are plain text phrases, somewhere between 1 and 400 char-s , containing setup information (in Delphi I save a TStringList to file and I backup that file in my

Re: [firebird-support] BLOB

On 9-10-2014 10:22, 'Tiberiu Horvath' tiberiu_horv...@yahoo.com [firebird-support] wrote: Hi all, I have the following table : CREATE TABLE LOG_TABLE ( ID_LOG_TABLE INTEGER NOT NULL, SESSION_ID INTEGER, LOG_DATA DATE, LOG_TIME TIME, LOG_TEXT VARCHAR(100),

RE: [firebird-support] BLOB

Mark, I am not sure how gbak reads blobs, but if it honours the defined segment size, IIRC, Ann has mentioned that SEGMENT SIZE is a legacy issue that hasn't really been used in some time. Our application uses BLOB fairly extensively and can report that the GBAK disk write rate increases

Re: [firebird-support] BLOB

LSSBcfs Our application uses BLOB fairly extensively and can report LSSBcfs that the GBAK disk write rate increases very significantly LSSBcfs when tables with Blobs are being backed-up, orders of LSSBcfs magnitude faster than tables with small rows (YMMV), so this LSSBcfs suggests that SEGMENT

Re: [firebird-support] Blob write to Embedded on Linux performance

Le 6 juin 2014 à 15:11, Mike Ro miker...@gmail.com [firebird-support] firebird-support@yahoogroups.com a écrit : I am seeing 45 seconds for a 13Mb file using C++ / IBPP and 48 seconds using PHP. Exactly the same code, database structure and hardware on Windows inserts a 13Mb BLOB in just

Re: [firebird-support] Blob write to Embedded on Linux performance

On 09/06/14 09:25, Olivier Mascia o...@tipgroup.com [firebird-support] wrote: I am seeing 45 seconds for a 13Mb file using C++ / IBPP and 48 seconds using PHP. Exactly the same code, database structure and hardware on Windows inserts a 13Mb BLOB in just 2.4 seconds! That just means the

Re: [firebird-support] Blob write to Embedded on Linux performance

On 09.06.2014 15:51, Mike Ro miker...@gmail.com [firebird-support] wrote: So the only mystery (for me!) remaining is why the UDF is so much faster when it is writing 4096 bytes at time with forced writes on? Usually it is faster to let the server do the dirty work, but I'm not sure that it is

Re: [firebird-support] Blob write to Embedded on Linux performance

Le 9 juin 2014 à 15:51, Mike Ro miker...@gmail.com [firebird-support] firebird-support@yahoogroups.com a écrit : 3. Set the database mode to be asynchronous with: gfix -write async test.fdb -user sysdba -password secret It, of course, has a tremendous impact on such tests. Though,

Re: [firebird-support] Blob write to Embedded on Linux performance

On 09/06/14 19:11, Frank Schlottmann-Gödde fr...@schlottmann-goedde.de [firebird-support] wrote: So the only mystery (for me!) remaining is why the UDF is so much faster when it is writing 4096 bytes at time with forced writes on? Usually it is faster to let the server do the dirty work, but

Re: [firebird-support] Blob write to Embedded on Linux performance

On 09/06/14 17:42, Olivier Mascia o...@integral.be [firebird-support] wrote: gfix -write async test.fdb -user sysdba -password secret It, of course, has a tremendous impact on such tests. Though, everybody should carefully consider wether the risks of data corruption are acceptable (or

Re: [firebird-support] Blob write to Embedded on Linux performance

On 06.06.2014 15:11, Mike Ro miker...@gmail.com [firebird-support] wrote: Frank, thank you for taking the time to do this. It confirms that there is definitely something wrong with my setup (are you using Firebird version 2.5.2?). No, its LI-T3.0.0.31151 Firebird 3.0 Alpha 2, but that

Re: [firebird-support] Blob write to Embedded on Linux performance

On 07/06/14 14:42, Frank Schlottmann-Gödde fr...@schlottmann-goedde.de [firebird-support] wrote: This is probably the cause of the exception: declare external function f_insertblob cstring (20), blob returns int by value entry_point 'insertblob' module_name 'test_udf.so'; should be

Re: [firebird-support] Blob write to Embedded on Linux performance

On 04.06.2014 00:08, Mike Ro miker...@gmail.com [firebird-support] wrote: Unfortunately I haven't had any success in trying this because blob_put_segment() is causing Firebird embedded to throw an instance of Firebird::status_exception followed by a core dump that I really can't get to the

Re: [firebird-support] Blob write to Embedded on Linux performance

On 06/06/14 11:04, Frank Schlottmann-Gödde fr...@schlottmann-goedde.de [firebird-support] wrote: Ok, this is what I get for a 13MB file on an Intel NUC (Celeron), database and home are on an USB Drive, so no real good hardware. SQL set stat; SQL set time; SQL select

Re: [firebird-support] Blob write to Embedded on Linux performance

Yes, of course, but I never felt the need to time the operations, we are using a udf s.th. like: void EXPORT fn_b_load ( char* s , BLOB b ) { unsigned char *buffer; if ( b-blob_handle ) { int buffsize = 4096; FILE *file; unsigned char *fname = intern_recode(s); file= fopen ( fname, rb ); if (

Re: [firebird-support] Blob write to Embedded on Linux performance

Am 28.05.2014 11:38, schrieb Mike Ro miker...@gmail.com [firebird-support]: I am sorry to bump this, but has anyone else got experience of using blobs on Linux? Yes, of course, but I never felt the need to time the operations, we are using a udf s.th. like: void EXPORT fn_b_load ( char*

Re: [firebird-support] Blob write to Embedded on Linux performance

On 02/06/2014 12:06, Frank Schlottmann-Gödde fr...@schlottmann-goedde.de [firebird-support] wrote: I am sorry to bump this, but has anyone else got experience of using blobs on Linux? Yes, of course, but I never felt the need to time the operations, we are using a udf ... to load documents

Re: [firebird-support] Blob write to Embedded on Linux performance

I am sorry to bump this, but has anyone else got experience of using blobs on Linux? I am using Firebird embedded (2.5.2) on Linux (Ubuntu 14.04) via IBPP with a completely default firebird.conf. My hardware is a Dell Optiplex 755, Intel Core 2 Duo @ 2.33GHz with 4Gb RAM and a 2Tb Western

[firebird-support] Blob write to Embedded on Linux performance

I am using Firebird embedded (2.5.2) on Linux (Ubuntu 14.04) via IBPP with a completely default firebird.conf. My hardware is a Dell Optiplex 755, Intel Core 2 Duo @ 2.33GHz with 4Gb RAM and a 2Tb Western Digital WD20EARX-32P hard disk. When I use IBPP to write a blob (actually a music

Re: [firebird-support] Blob storage mechnism

At 06:14 PM 27/03/2012, b0bik2000 wrote: I've read this: http://ibexpert.net/ibe/index.php?n=Doc.DefinitionBlob and I'd like to ask: If I have large blob data in my BLOB field in DB - it is stored in blob 2 level manner. But what about changing data size (by updating this column) to something

[firebird-support] BLOB SEGMENT SIZE ... is it really used somewhere ?

hello, where is it used the SEGMENT SIZE we declare when we create a blob ? ex: MyBlobField BLOB SUB_TYPE 1 SEGMENT SIZE 4096

[firebird-support] Blob is null performance question

Hi, Is it possible to indicate in a SQL statement whether a blob contains data or not, without retrieving the entire blob, and thereby making the query very slow? Eg. If I did: select S.StockCode, (case S.StockImageBlob when null then 'No' else 'Yes') as HasImage, (case S.StockMemoBlob