[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
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
On 8/24/12 6:53 AM, li, xiaohua wrote: 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
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
On 8/24/12 6:53 AM, li, xiaohua wrote: 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
-- 上海云数信息科技有限公司 http://www.cloudybi.com 联系人：李晓华 职务：总经理 手机：18616507502
participants (2)
-
li, xiaohua -
Martin Kersten