[MonetDB-users] monetdb crashed when using copy into .... locked
Hi: does anybody know what's the problem with the copy into of locked?
we want to use concurrent copy into to a table, seems montdb not good at this. some body says add locked, we try, but the database crached.
we just test like this
copy 200 OFFSET 1 RECORDS into f_activity from 'd:\bcp.txt' USING DELIMITERS '|','\n' NULL AS '' LOCKED
seems need single user mode, but how to set single user mode?
Lixiaohua
Shanghai,China
On 8/24/12 6:53 AM, li, xiaohua wrote:
Hi: does anybody know what's the problem with the copy into of locked?
we want to use concurrent copy into to a table, seems montdb not good at this. some body says add locked, we try, but the database crached.
MonetDB COPY INTO uses a parallel algorithm. The LOCKED mode is indeed for single user mode, but can be ignored. Using concurrent COPY INTO into the same table will fail, because the optimistic concurreny control will allow only one transaction to commit
regards, Martin
we just test like this
copy 200 OFFSET 1 RECORDS into f_activity from 'd:\bcp.txt' USING DELIMITERS '|','\n' NULL AS '' LOCKED
seems need single user mode, but how to set single user mode?
Lixiaohua
Shanghai,China
Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
we just test the newest edition of monetdb 20120813, we use 4 copy into commmand at the same time. if we use locked, the first is finished, the others seems will run for ever. if we don't use locked, all of 4 command finished. has this new edition made some progress?
2012/8/24 Martin Kersten Martin.Kersten@cwi.nl
On 8/24/12 6:53 AM, li, xiaohua wrote:
Hi: does anybody know what's the problem with the copy into of locked?
we want to use concurrent copy into to a table, seems montdb not good at this. some body says add locked, we try, but the database crached.
MonetDB COPY INTO uses a parallel algorithm. The LOCKED mode is indeed for single user mode, but can be ignored. Using concurrent COPY INTO into the same table will fail, because the optimistic concurreny control will allow only one transaction to commit
regards, Martin
we just test like this
copy 200 OFFSET 1 RECORDS into f_activity from 'd:\bcp.txt' USING DELIMITERS '|','\n' NULL AS '' LOCKED
seems need single user mode, but how to set single user mode?
Lixiaohua
Shanghai,China
Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
participants (2)
-
li, xiaohua -
Martin Kersten