Bugs item #1921884, was opened at 2008-03-20 22:34 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1921884&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 2.22 Status: Open Resolution: None Priority: 5 Private: No Submitted By: Andrey Tovchigrechko (andreyto) Assigned to: Niels Nes (nielsnes) Summary: COPY INTO silently corrupts database even on small loads Initial Comment: This happens on both SuSe 10 x86_64 12GB RAM and Ubuntu Gutsy x86_32 3GB RAM: after COPY INTO is used against the same table several times, and the database is restarted, the majority of records get filled with zeros. Same results is when loading chunks from one file, or splitting this file into many small ones. MonetDB was built with monetdb-install.sh --nightly=stable on Ubuntu, and both --nightly=stable and --nightly=current on SuSe This bug has been reported before for extremely large batches, but here it appears on small ones (total records are 500000 in 50000 batches). The mclient session is shown below. I can send or upload the file with test data (11M gzipped). I spend several days fighting with MonetDB SQL (mostly under SuSe 10 x86_64). It exhibits various other odd behaviors: 'select * from ...' stops printing any records in mclient (although 'select field_name from ... does', mclient suddenly starts to refuse logins with valid user, trivial 'union' selects zero number of records with non-zero number of records coming from each individual select. Although the query performance is spectacular, I am giving up and going back to MySQL. It looks that at least the SQL interface of MonetDB is in some early beta stage at best. Andrey ./monetdb-install.sh --enable-sql --prefix=/home/andrey/monetdb --nightly=stable export PATH=$PATH:/home/andrey/monetdb/bin merovingian monetdb create test monetdb start test mclient -l sql -d test < ../sql/bulk_test.sql [ 50000 ] [ 50000 ] [ 50000 ] [ 50000 ] [ 50000 ] [ 50000 ] [ 50000 ] [ 50000 ] [ 50000 ] [ 50000 ] [EMAIL PROTECTED]:~/work/mgtaxa/test_data$ mclient -l sql -d test sql>select count(*) from test_bulk; +--------+ | count_ | +========+ | 500000 | +--------+ sql>select count(*) from test_bulk where taxid = 0; +--------+ | count_ | +========+ | 3673 | +--------+ sql>\q [EMAIL PROTECTED]:~/work/mgtaxa/test_data$ monetdb stop test [EMAIL PROTECTED]:~/work/mgtaxa/test_data$ monetdb start test [EMAIL PROTECTED]:~/work/mgtaxa/test_data$ mclient -l sql -d test sql>select count(*) from test_bulk where taxid = 0; +--------+ | count_ | +========+ | 450003 | +--------+ sql> ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1921884&group_id=56967 ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
