Helen,

I can reproduce the problem inserting 1.000.000 of records with a program in
Java.

DDL:

---

SET SQL DIALECT 3;

SET NAMES ISO8859_1;

CREATE DATABASE 'c:\temp\webmarc.fdb'
USER 'SYSDBA' PASSWORD 'masterkey'
PAGE_SIZE 8192
DEFAULT CHARACTER SET ISO8859_1;

CREATE TABLE BSMST (
MFN INTEGER NOT NULL,
TAG INTEGER NOT NULL,
OCC INTEGER NOT NULL,
SUB CHAR(1) NOT NULL,
VAL BLOB SUB_TYPE 1 NOT NULL);

---

Java program:

---

import java.io.*;
import java.util.*;
import java.sql.*;

public class Teste {

public static void main(String[] args) throws ClassNotFoundException,
SQLException, IOException {

java.util.Properties propsConexao = new java.util.Properties();
propsConexao.put("user", "SYSDBA");
propsConexao.put("password", "masterkey");
propsConexao.put("lc_ctype", "ISO8859_1");

Class.forName("org.firebirdsql.jdbc.FBDriver");

String dbURL = "jdbc:firebirdsql:localhost:c:\\temp\\webmarc.fdb";
Connection conn = DriverManager.getConnection(dbURL, propsConexao);

String sql = "INSERT INTO BSMST (MFN,OCC,SUB,TAG,VAL) VALUES " +
"(1,1,'*',1,'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA" +
"AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA')";
PreparedStatement pstmt = conn.prepareStatement(sql);
for (int k = 0; k <= 999999; k++) {
pstmt.execute();
System.out.println(k);
}
}

}

---

After this, I get the following error with gbak -backup -v webmarc.fdb
webmarc.fbk

...
gbak: 140000 records written
gbak: error accessing BLOB column VAL -- continuing
gbak: ERROR: BLOB not found
gbak: 160000 records written
...

I think that this is a bug. What do you think ?

Thanks,

Rafael Santini

----- Original Message -----
From: "Santini" <santini.lista@...>
To: <firebird-support@yahoogroups.com>
Sent: Wednesday, February 18, 2004 12:48 PM
Subject: Re: [firebird-support] BLOB not found


Helen,

The problem does not occurs on Firebird 1.0.3 for Windows :-) So, I guess
that the problem is with engine 1.5 RC 9.

I will try to build a test case.

See:

---

C:\software\webmarc\db>gbak -backup -v webmarc.fdb webmarc.fbk
gbak: readied database webmarc.fdb for backup
gbak: creating file webmarc.fbk
gbak: starting transaction
gbak: database webmarc.fdb has a page size of 8192 bytes.
gbak: writing domains
gbak: writing domain RDB$1
gbak: writing domain RDB$2
gbak: writing domain RDB$3
gbak: writing domain RDB$4
gbak: writing domain RDB$5
gbak: writing domain RDB$6
gbak: writing domain RDB$7
gbak: writing domain RDB$8
gbak: writing domain RDB$9
gbak: writing domain RDB$10
gbak: writing shadow files
gbak: writing tables
gbak: writing table BSIDX
gbak: writing column TAG
gbak: writing column MFN
gbak: writing column CODTRM
gbak: writing table BSMST
gbak: writing column VAL
gbak: writing column OCC
gbak: writing column TAG
gbak: writing column MFN
gbak: writing column SUB
gbak: writing table BSTRM
gbak: writing column COD
gbak: writing column TRM
gbak: writing functions
gbak: writing types
gbak: writing filters
gbak: writing id generators
gbak: writing stored procedures
gbak: writing exceptions
gbak: writing Character Sets
gbak: writing Collations
gbak: writing data for table BSTRM
gbak: 0 records written
gbak: writing data for table BSMST
gbak: 20000 records written
gbak: 40000 records written
gbak: 60000 records written
gbak: 80000 records written
gbak: 100000 records written
gbak: 120000 records written
gbak: 140000 records written
gbak: 160000 records written
gbak: 180000 records written
gbak: 200000 records written
gbak: 220000 records written
gbak: 240000 records written
gbak: 260000 records written
gbak: 280000 records written
gbak: 300000 records written
gbak: 320000 records written
gbak: 340000 records written
gbak: 360000 records written
gbak: 380000 records written
gbak: 400000 records written
gbak: 420000 records written
gbak: 440000 records written
gbak: 460000 records written
gbak: 480000 records written
gbak: 500000 records written
gbak: 520000 records written
gbak: 540000 records written
gbak: 560000 records written
gbak: 580000 records written
gbak: 600000 records written
gbak: 620000 records written
gbak: 640000 records written
gbak: 660000 records written
gbak: 680000 records written
gbak: 700000 records written
gbak: 720000 records written
gbak: 732255 records written
gbak: writing data for table BSIDX
gbak: 0 records written
gbak: writing triggers
gbak: writing trigger messages
gbak: writing privilege for user SYSDBA
gbak: writing privilege for user SYSDBA
gbak: writing privilege for user SYSDBA
gbak: writing privilege for user SYSDBA
gbak: writing privilege for user SYSDBA
gbak: writing privilege for user PUBLIC
gbak: writing privilege for user SYSDBA
gbak: writing privilege for user SYSDBA
gbak: writing privilege for user SYSDBA
gbak: writing privilege for user SYSDBA
gbak: writing privilege for user SYSDBA
gbak: writing privilege for user SYSDBA
gbak: writing privilege for user SYSDBA
gbak: writing privilege for user SYSDBA
gbak: writing privilege for user SYSDBA
gbak: writing privilege for user SYSDBA
gbak: writing privilege for user SYSDBA
gbak: writing privilege for user SYSDBA
gbak: writing privilege for user SYSDBA
gbak: writing privilege for user SYSDBA
gbak: writing privilege for user SYSDBA
gbak: writing table constraints
gbak: writing constraint INTEG_1
gbak: writing constraint INTEG_2
gbak: writing constraint INTEG_3
gbak: writing constraint INTEG_4
gbak: writing constraint INTEG_5
gbak: writing constraint INTEG_6
gbak: writing constraint INTEG_7
gbak: writing constraint INTEG_8
gbak: writing constraint INTEG_9
gbak: writing constraint INTEG_10
gbak: writing referential constraints
gbak: writing check constraints
gbak: writing SQL roles
gbak: closing file, committing, and finishing. 53853 bytes written

---

Thanks,

Rafael Santini

----- Original Message -----
From: "Helen Borrie" <helebor@...>
To: <firebird-support@yahoogroups.com>
Sent: Tuesday, February 17, 2004 10:59 PM
Subject: Re: [firebird-support] BLOB not found


> At 10:36 PM 17/02/2004 -0300, you wrote:
>
> > > It would make sense for you to post your problem in the Firebird-Java
> >forum
> > > if you find it persists.
> >
> >This not make sense for me. I belive that the problem is with database
> >engine.
>
> Belief transcends the empirical.
>
> >My Java application is the following:
>
> [snipped a listing in Java]
>
> /hb
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
>
>
>
> --------------------------------------------------------------------------
------
> Yahoo! Groups Links
>
> a.. To visit your group on the web, go to:
> http://groups.yahoo.com/group/firebird-support/
>
> b.. To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
> c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
>
>
>
> --------------------------------------------------------------------------
------
> Esta mensagem foi verificada pelo E-mail Protegido Terra.
> Scan engine: VirusScan / Atualizado em 17/02/2004 / Versão: 1.4.1
> Proteja o seu e-mail Terra: http://www.emailprotegido.terra.com.br/
>
>
> --------------------------------------------------------------------------
------
> E-mail classificado pelo Identificador de Spam Inteligente.
> Para alterar a categoria classificada, visite
http://www.terra.com.br/centralunificada/emailprotegido/imail/imail.cgi?+_u=santini.lista&_l=1077069575.538603.5182.pasto.terra.com.br



----------------------------------------------------------------------------
----
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

b.. To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.




----------------------------------------------------------------------------
----
Esta mensagem foi verificada pelo E-mail Protegido Terra.
Scan engine: VirusScan / Atualizado em 17/02/2004 / Versão: 1.4.1
Proteja o seu e-mail Terra: http://www.emailprotegido.terra.com.br/


----------------------------------------------------------------------------
----
E-mail classificado pelo Identificador de Spam Inteligente.
Para alterar a categoria classificada, visite
http://www.terra.com.br/centralunificada/emailprotegido/imail/imail.cgi?+_u=santini.lista&_l=1077119301.621071.11706.arequipa.terra.com.br