-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256

On 14/03/16 11:14, Lefteris wrote:
> Hi Souri,
>
> I checked the issue and I can confirm that something is happening
> with the copied data, and monetdb does not like it. This error
> occurs during the first copy into.
>
> The error I get is server5:
> /ufs/lsidir/monetdb/MonetDB/gdk/gdk_atoms.c:1306: strPut: Assertion
> `(v[i] & 0x80) == 0' failed.
>
> while trying to load the data. And the trace reads
>
> #4  0x00007ffff72d4c8f in strPut (h=0x7fffbc14d640,
> dst=0x7fffd4aa3c80, v=0x7fffd4aa3dd0 "Leftover data '*data i am not
> sure i should share...(?)* "...) at
> /ufs/lsidir/monetdb/MonetDB/gdk/gdk_atoms.c:1306
>
> So I suspect to be a parse error that is not treated as it is
> supposed to.

This indicates that there is a non-UTF-8 character in the input.  Of
course, there should not be an assertion error if wrong input is
given, so that problem has been fixed in changeset c5460cc0b66b.
What then remains is the bad input.

> Can we use the main_schema, data, and queries you send me to open a
> bug report? or is it sensitive data? If we can use them, then I
> suggest you open a bug report for the correct person to see it and
> fix it.
>
> Lefteris
>
>
>
>
>
>
>
> On Mon, Mar 14, 2016 at 9:21 AM, Souri Ratnaparkhi
> <souri.ratnaparkhi@usain.com <mailto:souri.ratnaparkhi@usain.com>>
> wrote:
>
> Hello Team,
>
> I had shared all the data with Lefteris. When database crashes we
> restore it from the backup.
>
> Thank you
>
>
> Souri Ratnaparkhi United Software Associates Pvt. Ltd. Pune, India
> Mob: 8975677255 Phone (India Lines): (91) 020-25445550
> www.usain.com <http://www.usain.com>
>
> -----Original Message----- From: users-list
> [mailto:users-list-bounces+souri.ratnaparkhi
> <mailto:users-list-bounces%2Bsouri.ratnaparkhi>=usain.com@monetdb.org
> <mailto:usain.com@monetdb.org>] On Behalf Of Stefan Manegold Sent:
> Monday, March 14, 2016 2:10 PM To: Communication channel for
> MonetDB users Subject: Re: Monetdb crashes.
>
> Dear Souri,
>
> as both Hannes and Lefteris already mentioned with their replies to
> your earlier messages, we need detailed instructions (and data) how
> to reproduce the problem, otherwise, we have no means to debug it.
>
> We easily operate tables with thousands of columns and millions of
> rows in MonetDB; hence, neither is expected to be a problem in
> general.
>
> If your server crashes, and then fails to restart, this should be
> reflected in the merovingian.log . Please re-consult the log and
> feel free to share the relevant snippets.
>
> If the server fails to restart and you fail to reconnect, how
> could you test with inserting fewer records into the very same
> table or inserting all records into a new empty table?
>
> Best, Stefan
>
> ----- On Mar 14, 2016, at 5:10 AM, Souri Ratnaparkhi
> souri.ratnaparkhi@usain.com <mailto:souri.ratnaparkhi@usain.com>
> wrote:
>
>> Hello, We have a  main table with 126 columns and approx. 94000
>> rows. We are trying to load approx 2500 records from temporary
>> table into main table using query “insert into select” query. The
>> database crashes upon query execution. We get error “ monetdbd:
>> internal error while starting mserver, please refer to the logs ”
>> when to try to connect again.
>>
>>
>> No specific error is created in log file. 1500 records
>> successfully loads from temp table to main table. We also created
>> another main table with same DDL, that table is empty & inserted
>> all the records from temp successfully without any issue.
>>
>> What could be the reason? Is 126 cols an issue? Please help. We
> are stuck.
>>
>> (btw: We have machine about 200GB of hard disk & 16 GB RAM (14
>> GB free))
>>
>> OS - Ubuntu 14.04.2 LTS (GNU/Linux 3.13.0-55-generic x86_64)
>>
>> Monetdb version - MonetDB v11.21.13 (Jul2015-SP2)
>>
>>
>> Thank you
>>
>>
>>
>>
>> Souri Ratnaparkhi United Software Associates Pvt. Ltd. Pune,
>> India Mob: 8975677255 Phone (India Lines): (91) 020-25445550
>> www.usain.com
> <http://www.usain.com>
>>
>>
>>
>> _______________________________________________ users-list
>> mailing list users-list@monetdb.org
>> <mailto:users-list@monetdb.org>
>> https://www.monetdb.org/mailman/listinfo/users-list
>
> -- | Stefan.Manegold@CWI.nl | DB Architectures   (DA) | |
> www.CWI.nl/~manegold/ <http://www.CWI.nl/~manegold/>  | Science
> Park 123 (L321) | | +31 (0)20 592-4212
> <tel:%2B31%20%280%2920%20592-4212>     | 1098 XG Amsterdam  (NL) |
> _______________________________________________ users-list mailing
> list users-list@monetdb.org <mailto:users-list@monetdb.org>
> https://www.monetdb.org/mailman/listinfo/users-list
>
>
>
>
> _______________________________________________ users-list mailing
> list users-list@monetdb.org
> https://www.monetdb.org/mailman/listinfo/users-list
>


- --
Sjoerd Mullender
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2

iQEcBAEBCAAGBQJW5p85AAoJEISMxT6LrWYgd0MIAKe8euGNGKLHRJhMoQgIZyIN
tia/LGef1qlMtcobbzzCE4HW3jF+bwgdYWWJa/BgObpXpxmkpLeV1o0NiFuO0Ru9
wObPBp2m2UNTe1tpRYbLCZyxub52uZbux0DYCUMtSRDhrzvxpRkVMRJ/SMf48TW9
0YU9nW+SCtTtorq71oGG98oZVElHB80zuzydrKoa2mk/3bdQt+ZCepfmy7odmzEK
mAxmBVSKh8RoXWCero6lbbd6RE9OVMMrrECw1P7rbPpvfzbCjEF1hTv+THAsEBP9
SfZBbk93P+aYJMN/SPDEtf5K2MeVW0C/AuXI8UOHqbiEn7p/1NNsm98R/qRWDBs=
=6DB/
-----END PGP SIGNATURE-----

_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list