Bugs item #2779702, was opened at 2009-04-23 19:09 Message generated for change (Tracker Item Submitted) made by cornuz 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 ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2779702&group_id=56967 ------------------------------------------------------------------------------ Stay on top of everything new and different, both inside and around Java (TM) technology - register by April 22, and save $200 on the JavaOne (SM) conference, June 2-5, 2009, San Francisco. 300 plus technical and hands-on sessions. Register today. Use priority code J9JMT32. http://p.sf.net/sfu/p _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
