Hi, I've a large database that has links to other databases.
When I try to load it it takes ages, more than 5 minutes, so in a effort to reduce the initialization overhead I tried the KeepMirror feature.
The db seems to load and build the KeepMirror folder, tough when I try to run the application again I get a ugly crash. Here's the error message:
mmmm... anyway it runs faster than the italian soccer team....
It looks like hsqldb(mirror db) cannot execute its own script.
In ms access, has the CODAGENDA column of table TAGENDA a index unique definition even if it's already primary key?
If so, I can prevent this issue.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
can't reproduce this issue. It would be great if you send to me a minimal database(without real data) and with only a copy of table TAGENDA (as ticket attachment or by email at amadei.mar@gmail.com). I only need the complete table definition.
Please, if you agree, before sending, verify you can reproduce the issue with that copied db.
Cheers Marco
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Here is the complete table definition, if you still need a copy of table TAGENDA ask again and I'll try to provide you with the data. Thank you
CREATE TABLE TAgenda ( CodAgenda Long NOT NULL IDENTITY(2429,1) PRIMARY KEY, Data DateTime, Hora VarChar(5) WITH COMP, CodAccao Long DEFAULT 0, CodCondominio VarChar(4) WITH COMP, CodGestor VarChar(2), Obs LongText WITH COMP, TarefaConcluida Bit NOT NULL DEFAULT False, DataConclusao DateTime, Recursiva Bit NOT NULL, Ciclo VarChar(20)
)
GO
CREATE UNIQUE INDEX NAgenda
ON TAgenda (CodAgenda)
GO
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
So sorry, I can't reproduce the issue with a simple ddl.
I have to understand why Hsqldb tries to execute:
CREATE CACHED TABLE PUBLIC.TAGENDA(CODAGENDA INTEGER PRIMARY KEY,DATA TIMESTAMP,HORA VARCHAR_IGNORECASE(5),CODACCAO INTEGER,CODCONDOMINIO VARCHAR_IGNORECASE(4),CODGESTOR VARCHAR_IGNORECASE(2),OBS VARCHAR_IGNORECASE(16777216),TAREFACONCLUIDA BOOLEAN,DATACONCLUSAO TIMESTAMP,RECURSIVA BOOLEAN,CICLO VARCHAR_IGNORECASE(20),CONSTRAINT TAGENDA_NAGENDA UNIQUE(CODAGENDA)
and so why it saved a wrong script(further index unique on CODAGENDA which is already primary key).
I need an accdb or mdb with a copy of the table and without data: you can get it with a simple copy and paste on a void mdb/accdb
Please send it at amadei.mar@gmail.com or as new ticket attachment.
Cheers marco
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
No, no, I've already reproduced and fixed the issue.
Please, use keepMirror mode with the 2.0.7, which I'm going to release in the next few days(maybe tomorrow).
Last edit: Marco Amadei 2014-06-26
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi, I've a large database that has links to other databases.
When I try to load it it takes ages, more than 5 minutes, so in a effort to reduce the initialization overhead I tried the KeepMirror feature.
The db seems to load and build the KeepMirror folder, tough when I try to run the application again I get a ugly crash. Here's the error message:
http://pastebin.com/SXZWkNVn
Any help appreciated.
mmmm... anyway it runs faster than the italian soccer team....
It looks like hsqldb(mirror db) cannot execute its own script.
In ms access, has the CODAGENDA column of table TAGENDA a index unique definition even if it's already primary key?
If so, I can prevent this issue.
can't reproduce this issue. It would be great if you send to me a minimal database(without real data) and with only a copy of table TAGENDA (as ticket attachment or by email at amadei.mar@gmail.com). I only need the complete table definition.
Please, if you agree, before sending, verify you can reproduce the issue with that copied db.
Cheers Marco
Sorry for the late response.
Here is the complete table definition, if you still need a copy of table TAGENDA ask again and I'll try to provide you with the data. Thank you
CREATE TABLE
TAgenda(CodAgendaLong NOT NULL IDENTITY(2429,1) PRIMARY KEY,DataDateTime,HoraVarChar(5) WITH COMP,CodAccaoLong DEFAULT 0,CodCondominioVarChar(4) WITH COMP,CodGestorVarChar(2),ObsLongText WITH COMP,TarefaConcluidaBit NOT NULL DEFAULT False,DataConclusaoDateTime,RecursivaBit NOT NULL,CicloVarChar(20))
GO
CREATE UNIQUE INDEX
NAgendaON
TAgenda(CodAgenda)GO
So sorry, I can't reproduce the issue with a simple ddl.
I have to understand why Hsqldb tries to execute:
CREATE CACHED TABLE PUBLIC.TAGENDA(CODAGENDA INTEGER PRIMARY KEY,DATA TIMESTAMP,HORA VARCHAR_IGNORECASE(5),CODACCAO INTEGER,CODCONDOMINIO VARCHAR_IGNORECASE(4),CODGESTOR VARCHAR_IGNORECASE(2),OBS VARCHAR_IGNORECASE(16777216),TAREFACONCLUIDA BOOLEAN,DATACONCLUSAO TIMESTAMP,RECURSIVA BOOLEAN,CICLO VARCHAR_IGNORECASE(20),CONSTRAINT TAGENDA_NAGENDA UNIQUE(CODAGENDA)
and so why it saved a wrong script(further index unique on CODAGENDA which is already primary key).
I need an accdb or mdb with a copy of the table and without data: you can get it with a simple copy and paste on a void mdb/accdb
Please send it at amadei.mar@gmail.com or as new ticket attachment.
Cheers marco
Email sent, sadly, the error doesn't seem to be reproducible with a mere subset of the data.
No, no, I've already reproduced and fixed the issue.
Please, use keepMirror mode with the 2.0.7, which I'm going to release in the next few days(maybe tomorrow).
Last edit: Marco Amadei 2014-06-26
Thanks a bunch, it really seams to be working after the last release!!
The db opens within 3 seconds, which is also great, thank you!