properties - Truncating takes too much time hsqldb -

-

i use hsqldb 2.3.2 , i've got following issues:

  1. my database has cached table 10 000 000 records without constraints , indexes. size ~900mb. turn off autocommit mode , when try execute "truncate table tablename", execution hangs dbname.backup growing. , here's why:

trace engine:? - copyshadow [size, time] 2246252 9721
trace engine:? - setfilemodified flag set
trace engine:? - cache save rows [count,time] totals 24801,9921 operation 24801,9921 txts 96
trace engine:? - copyshadow [size, time] 4426920 7732
trace engine:? - cache save rows [count,time] totals 49609,17775 operation 24808,7854 txts 96
trace engine:? - copyshadow [size, time] 6574796 9024

it takes 1500-2000 seconds , can either empty table or exception this:

tests run: 0, failures: 0, errors: 0, skipped: 0, time elapsed: 1,525.509 sec org.apache.maven.surefire.util.surefirereflectionexception: java.lang.reflect.invocationtargetexception; nested exception java.lang.reflect.invocationtargetexception: null java.lang.reflect.invocationtargetexception     @ sun.reflect.nativemethodaccessorimpl.invoke0(native method)     @ sun.reflect.nativemethodaccessorimpl.invoke(nativemethodaccessorimpl.java:62)     @ sun.reflect.delegatingmethodaccessorimpl.invoke(delegatingmethodaccessorimpl.java:43)     @ java.lang.reflect.method.invoke(method.java:497)     @ org.apache.maven.surefire.util.reflectionutils.invokemethodwitharray(reflectionutils.java:164)     @ org.apache.maven.surefire.booter.providerfactory$providerproxy.invoke(providerfactory.java:110)     @ org.apache.maven.surefire.booter.surefirestarter.invokeprovider(surefirestarter.java:175)     @ org.apache.maven.surefire.booter.surefirestarter.runsuitesinprocesswhenforked(surefirestarter.java:107)     @ org.apache.maven.surefire.booter.forkedbooter.main(forkedbooter.java:68) caused by: java.lang.outofmemoryerror: java heap space

after truncating dbname.backup removed. don't have use backups in application, how can avoid copying?

  1. dbname.properties doesn't work. contains following text:

    #hsql database engine 2.3.2

    #thu mar 19 08:42:10 eat 2015

    version=2.3.2
    modified=no

tried append hsqldb.applog=1 nothing happened.
dbname.app.log appears in case change line set database event log level 1 in dbname.script
after working database application dbname.properties overwrited: 'modified' changes on 'yes' , lines below deleted. do wrong?

my database has cached table 10 000 000 records without constraints , indexes.

it wrong have large table without constraints , indexes. select, update or delete on table affects few rows has search rows in table.

i try execute "truncate table tablename"

the above statement allows roll action before commit. information rolling stored in memory , memory run out when table large. want commit change, use statement instead:

truncate table tablename , commit

this mentioned in guide: http://hsqldb.org/doc/2.0/guide/dataaccess-chapt.html#dac_truncate_statement

the addition can make .properties file set database files readonly. other change ignored , deleted.

the .backup file internal use of database engine , cannot stop use.


Comments

Post a Comment

Popular posts from this blog

c++ - Delete matches in OpenCV (Keypoints and descriptors) -

-
i want check scene image against 2 train images. that, detect features , compute descriptors of both training images. before detecting, computing , matching scene image, delete matches of train1 , train2. because these matches won't facilitate matching of scene image train1 , train2. so, match train1 train2 , vector of matches trainidx , queryidx. how can delete these matches in keypoints-vector , descriptor matrix of train1 , train2? best regards, dwi i have done below: std::vector<cv::keypoint> keypoints[2]; cv::mat descriptor[2]; std::vector< cv::dmatch > matches; /* write code generate keypoints, descriptors , matches here... keypoint[0] -> train image 1 keypoints keypoint[1] -> train image 2 keypoints descriptor[0] -> train image 1 descriptors descriptor[1] -> train image 2 descriptors matches -> matched between train image 1 , 2 */ // logic keep unmatched keypoints , corresponding descriptor
Read more

java - Could not locate OpenAL library -

-
i writing game using slick2d library, uses lwjgl. lwjgl version 2.9.3. using netbeans 8. i tried adding sounds game, example music track on main menu. problem is, exception when run game, despite game still compiling , running except sound of course: sat mar 21 01:23:57 edt 2015 error:could not locate openal library. org.lwjgl.lwjglexception: not locate openal library. @ org.lwjgl.openal.al.create(al.java:156) @ org.lwjgl.openal.al.create(al.java:156) @ org.lwjgl.openal.al.create(al.java:102) @ org.lwjgl.openal.al.create(al.java:206) @ org.newdawn.slick.openal.soundstore$1.run(soundstore.java:295) @ java.security.accesscontroller.doprivileged(native method) @ org.newdawn.slick.openal.soundstore.init(soundstore.java:292) @ org.newdawn.slick.music.<init>(music.java:156) @ org.newdawn.slick.music.<init>(music.java:75) @ view.mainmenu.init(mainmenu.java:58) i didn't include rest of error states error happens in game code. the
Read more

sorting - opencl Bitonic sort with 64 bits keys -

-
i used nvidia sdk bitonic sort , works great me. 32 bits (uint) need ulong keys. have typically 2^14 keys @ time , power of 2. searched on not find kernel designed ulong. i tried modified nvidia sdk bitonic sort using ulong keys not work. kernel not crash after de call clenqueuendrangekernel got error : cl_invalid_command_queue can tell me how modify bitonic sort or radixsort, or can sort ulong keys? i running nvidia quadro 4000 opencl 1.1 cuda 6.5.20 full_profile used original nvidia sdk bitonicsort.cl i used"ulong" keys , value input , ouput instead of "uint" thanks helping i made work-around suit need. used 30 bits of key , 18 high bits of value sorting. changed comparators (2 lines): '#define mask 0xffffc000 // suit need from this: if( (*keya > *keyb) == dir ) this: if(((*keya > *keyb)||((*keya == *keyb)&&((*vala & mask)> (*valb & mask)))) == dir ) it works fine. but, still, it's work-a
Read more