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 h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
