i cannot make a reproducible test if i dont know what i have to do to
reproduce it.
i tried to do reproduce it with a script like that (run this script on
1.3.176):
CREATE TABLE IF NOT EXISTS ALARM_HISTORY(
ID INTEGER AUTO_INCREMENT,
ACCOUNT INTEGER,
ALARMDATE TIMESTAMP,
ALARMDATETEMP TIMESTAMP,
CONSTRAINT PK_ALARM_HISTORY PRIMARY KEY(ID)
);
CREATE INDEX IF NOT EXISTS IDX_ALARM_HISTORY_ALARMDATE ON
ALARM_HISTORY(ALARMDATE);
CREATE INDEX IF NOT EXISTS IDX_ALARM_HISTORY_ACCOUNTALARMDATE ON
ALARM_HISTORY(ACCOUNT,ALARMDATE);
@LOOP 3000000 INSERT INTO ALARM_HISTORY (ACCOUNT, ALARMDATE, ALARMDATETEMP)
VALUES(1, NOW(), NOW());
but if i try the select / update statement with 1.4 on this table i get
"timeout by trying to lock the table". even if i just use this statement:
UPDATE ALARM_HISTORY SET ALARMDATE=ALARMDATETEMP;
i get a timeout error. I* don't *get any error with 1.3.176.
But i dont get this problem with my existing database. its just insane slow
(the size of the database is growing from 400mb to 2.3GB and the process is
using 2gb+ ram). I just use h2 as server without any changes (default
connection (tcp) url).
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
