IB Error Number: 335544721 when i execute a insert statement
------------------------------------------------------------
Key: CORE-4660
URL: http://tracker.firebirdsql.org/browse/CORE-4660
Project: Firebird Core
Issue Type: Bug
Components: API / Client Library
Affects Versions: 2.5.3 Update 1
Environment: I have a win7 with firebird 2.5.3 update 1.
Reporter: Vicente Tejero Trueba
I dont know if is a bug or is my problem.
One month ago I install firebird 2.5, Before i have a firebird 2.1 and i dont
have any problem.
When i execute a insert statement firebird response with
"Unable to complete network request to host "localhost".
Error reading data from the connection.
SQL Code: -902
IB Error Number: 335544721
(2,434 sec)".
And the conection crash.
When i reopen the connection i dont have any problem with others tables. I can
insert, read or update but
when i wont insert into this table the connection crash.
I have made a full backup/restore and a database validation and the problem
persist.
The insert statement is:
insert into licencia (
identificador,cod_delegacion,codigo,dni,tipo,fecha,fecha_emision,
cod_control,n_cuota,baja,fecha_baja,remesa,anio,
remesa_baja,anio_baja,cod_sociedad,id_poliza
) values (
2444401,11,1,'31854794',3,'12/19/2014','12/19/2014',
5329,0,'N',null,0,2014,
0,0,'11000',''
);
The table licencia have 1672627 records.
The last value for identificador i 2444400
could be a problem with the limits of numbers, records, ....?
The table definition is
/* Definition for the `DCAD20` domain : */
CREATE DOMAIN DCAD20 AS
VARCHAR(20) CHARACTER SET ISO8859_1
DEFAULT ''
COLLATE ES_ES;
/* Definition for the `DENTEROCORTO` domain : */
CREATE DOMAIN DENTEROCORTO AS
SMALLINT
DEFAULT 0;
/* Definition for the `DCAD30` domain : */
CREATE DOMAIN DCAD30 AS
VARCHAR(30) CHARACTER SET ISO8859_1
DEFAULT ''
COLLATE ES_ES;
/* Definition for the `DCAD5` domain : */
CREATE DOMAIN DCAD5 AS
CHAR(5) CHARACTER SET ISO8859_1
DEFAULT ''
COLLATE ES_ES;
/* Definition for the `DCADSI` domain : */
CREATE DOMAIN DCADSI AS
CHAR(1) CHARACTER SET ISO8859_1
DEFAULT 'N'
CHECK (VALUE='S' OR VALUE='N')
COLLATE ES_ES;
/* Definition for the `DENTERO` domain : */
CREATE DOMAIN DENTERO AS
INTEGER
DEFAULT 0;
/* Definition for the `DCAD10` domain : */
CREATE DOMAIN DCAD10 AS
CHAR(10) CHARACTER SET ISO8859_1
DEFAULT ''
COLLATE ES_ES;
/* Definition for the `DCAD40` domain : */
CREATE DOMAIN DCAD40 AS
VARCHAR(40) CHARACTER SET ISO8859_1
DEFAULT ''
COLLATE ES_ES;
/* Definition for the `DDNI` domain : */
CREATE DOMAIN DDNI AS
CHAR(8) CHARACTER SET ISO8859_1
COLLATE ES_ES;
/* Definition for the `DFECHA` domain : */
CREATE DOMAIN DFECHA AS
DATE;
/* Definition for the `DIDPAIS` domain : */
CREATE DOMAIN DIDPAIS AS
INTEGER;
/* Definition for the `DIMAGEN` domain : */
CREATE DOMAIN DIMAGEN AS
BLOB SEGMENT SIZE 1024;
/* Definition for the `DMEMO` domain : */
CREATE DOMAIN DMEMO AS
BLOB SUB_TYPE 1 SEGMENT SIZE 256 CHARACTER SET ISO8859_1;
/* Definition for the `DSEXO` domain : */
CREATE DOMAIN DSEXO AS
CHAR(1) CHARACTER SET ISO8859_1
DEFAULT 'H'
CHECK (value in ('H','M'))
COLLATE ES_ES;
/* Definition for the `DTELEFONO` domain : */
CREATE DOMAIN DTELEFONO AS
CHAR(15) CHARACTER SET ISO8859_1
DEFAULT ''
COLLATE ES_ES;
CREATE DOMAIN DCADBAJA AS
CHAR(1) CHARACTER SET ISO8859_1
DEFAULT 'N'
CHECK (VALUE='S' OR VALUE='N' OR VALUE='F')
COLLATE ES_ES;
/* Definition for the `DIDPOLIZA` domain : */
CREATE DOMAIN DIDPOLIZA AS
VARCHAR(21) CHARACTER SET ISO8859_1
COLLATE ISO8859_1;
/* Structure for the `LICENCIA` table : */
CREATE TABLE LICENCIA (
IDENTIFICADOR DIDENTIFICADOR NOT NULL,
COD_DELEGACION DCODDELEGACION,
CODIGO DLICENCIA,
DNI DDNI,
TIPO DTIPOLIC,
FECHA DFECHA,
FECHA_EMISION DFECHA,
COD_CONTROL INTEGER,
N_CUOTA DN_CUOTA,
BAJA DCADBAJA,
FECHA_BAJA DFECHA,
REMESA DN_REMESA,
ANIO DANIO,
REMESA_BAJA DN_REMESA,
ANIO_BAJA DANIO,
COD_SOCIEDAD DSOCIEDAD,
MARCADO DCADSI,
ID_POLIZA DIDPOLIZA);
ALTER TABLE LICENCIA ADD CONSTRAINT PK_LICENCIA PRIMARY KEY (IDENTIFICADOR);
CREATE INDEX IDX_LICENCIA ON LICENCIA(CODIGO,TIPO,FECHA_EMISION);
CREATE INDEX IDX_LICENCIA1 ON LICENCIA(CODIGO,TIPO,FECHA);
CREATE INDEX IDX_LICENCIA2 ON LICENCIA(CODIGO);
CREATE INDEX IDX_LICENCIA3 ON LICENCIA(COD_DELEGACION,ANIO,TIPO,REMESA);
CREATE INDEX IDX_LICENCIA4 ON
LICENCIA(COD_DELEGACION,ANIO_BAJA,TIPO,REMESA_BAJA);
CREATE INDEX IDX_LICENCIA5 ON LICENCIA(FECHA_EMISION);
CREATE INDEX IDX_LICENCIA6 ON LICENCIA(ID_POLIZA);
CREATE INDEX IDX_LICENCIA7 ON LICENCIA(ID_POLIZA);
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Dive into the World of Parallel Programming! The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
