Bugs item #2779702, was opened at 2009-04-23 19:09
Message generated for change (Comment added) made by stmane
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2779702&group_id=56967
Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: SQL/Core
Group: SQL CVS Head
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Roberto Cornacchia (cornuz)
Assigned to: Niels Nes (nielsnes)
Summary: SQL COPY INTO, data corrupted after shutdown
Initial Comment:
I'm loading a table from disk. The data seems OK until I shut down the db.
If I do that, then the data is corrupted.
It shouldn't be related to the bug about parallel bulk load, because I'm using
gdk_threads=1
# create a clean database
$ monetdb create test
successfully created database 'test'
$ monetdb start test
starting database 'test'... done
# Load a table from file 'ne_doc' (140377 tuples)
# This table is too large to be an attachment to this bug report.
# It can be found here: /ufs/roberto/ne_doc
$ echo "CREATE TABLE ne_doc (neID int, predicate VARCHAR(30), docID int);" |
mclient -lsql -d test
$ echo "COPY 140377 RECORDS INTO ne_doc FROM '/ufs/roberto/ne_doc';" | mclient
-lsql -d test
[ 140377 ]
# Ask for the unique 'predicates'
$ echo "select predicate from ne_doc group by predicate;" | mclient -lsql -d
test
% sys.ne_doc # table_name
% predicate # name
% varchar # type
% 21 # length
[ "ep-contracting-states" ]
[ "inventor_of" ]
[ "assignee_of" ]
# Stop and start the database
$ monetdb stop test
stopping database 'test'... done
$ monetdb start test
starting database 'test'... done
# Ask for the unique 'predicates'
$ echo "select predicate from ne_doc group by predicate;" | mclient -lsql -d
test
% sys.ne_doc # table_name
% predicate # name
% varchar # type
% 21 # length
[ "ep-contracting-states" ]
[ "inventor_of" ]
[ "" ]
It seems corrupted after the sutdown
----------------------------------------------------------------------
>Comment By: Stefan Manegold (stmane)
Date: 2009-04-26 10:38
Message:
Just to be sure:
I suppose you are using
--set gdk_nr_threads=1
^^^^
not
--set gdk_threads=1
^
right?
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2779702&group_id=56967
------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensign option that enables unlimited
royalty-free distribution of the report engine for externally facing
server and web deployment.
http://p.sf.net/sfu/businessobjects
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
