Bugs item #1921884, was opened at 2008-03-21 03:34 Message generated for change (Comment added) made by nielsnes 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> ---------------------------------------------------------------------- >Comment By: Niels Nes (nielsnes) Date: 2008-03-21 08:09 Message: Logged In: YES user_id=43556 Originator: NO Thanks for the bug report. Could you indeed upload the 11MB file please. We could like to fix also the other problems you report but with out bug report and/or test script this is hard. Thanks again and hope to see you return to MonetDB/SQL soon. ---------------------------------------------------------------------- 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
