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-27 11:21
Message:
On my 64-bit Fedora 10 desktop, I cannot reproduce the problem, neither
with the Feb2009 SP2 code base, nor with this mornings CVS HEAD code base
...
What I see, though, with the Feb2009 SP2 code base, when starting
`mserver5 --dbinit='include sql;'` by hand and then bulk-loading the data
with `COPY INTO ...` is the following error on the mserver5 console:
>!ERROR: GDKsave: failed name=10/1073, ext=tail, mode 0
I don't see this when loading single threaded nor with the CVS HEAD code
base.
----------------------------------------------------------------------
Comment By: Roberto Cornacchia (cornuz)
Date: 2009-04-27 10:56
Message:
Indeed, I do use the correct keyword,in monetdb5.conf:
gdk_nr_threads=1
----------------------------------------------------------------------
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
