Insertion problem for large number of columns - users-list - monetdb.org

newer
SQL function for getting the last...

Insertion problem for large number of columns

older
Questions

Shajon

11 Mar 2013 11 Mar '13

2:14 p.m.

Dear Monet Team, Today I was trying to insert data in MonetDB using " insert into ." command through jdbc from my application but the server is crashing & no data is inserting. That table has 25 columns and I am passing all values. Thanks Shajon

Attachments:

attachment.html (text/html — 1.9 KB)

Reply

Sign in to reply online Use email software

Show replies by date

Lefteris

11 Mar 11 Mar

2:43 p.m.

You are giving too little of information for us to even make a general suggestion. On Mon, Mar 11, 2013 at 3:14 PM, Shajon wrote:

Dear Monet Team,

Today I was trying to insert data in MonetDB using “ insert into …” command through jdbc from my application but the server is crashing & no data is inserting. That table has 25 columns and I am passing all values.

Thanks

Shajon

_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

Reply

Sign in to reply online Use email software

Shajon

3:02 p.m.

Here some information: monetDB: MonetDB5 OS: Windows 7 64 bit, RAM 4GB Jdbc : monetdb-jdbc-2.4 Can you please tell me specifically what information do you need to give me advice. Thanks Shajon -----Original Message----- From: users-list-bounces+alam=finengine.com@monetdb.org [mailto:users-list-bounces+alam=finengine.com@monetdb.org] On Behalf Of Lefteris Sent: Monday, March 11, 2013 8:44 PM To: Communication channel for MonetDB users Subject: Re: Insertion problem for large number of columns You are giving too little of information for us to even make a general suggestion. On Mon, Mar 11, 2013 at 3:14 PM, Shajon wrote:

Dear Monet Team,

Today I was trying to insert data in MonetDB using " insert into ." command through jdbc from my application but the server is crashing & no data is inserting. That table has 25 columns and I am passing all values.

Thanks

Shajon

_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

Reply

Sign in to reply online Use email software

Stefan Manegold

3:15 p.m.

To start with: - Which version (release) of MonetDB are you using? - Are you using a 32- or 64-bit build of MonetDB? - Did you install the 32-bit or 64-bit or both JDBC drivers? - How does the crash show itself? + Are there any error messages on the server console? + Are there any errors returned from the server via you JDBC connection? + Or does the server process simply stop without any information? - What does you table schema (column types) look like? - Does the server crash with any data/tuple you insert? - What does a single sample tuple look like? - How exactly does your JDBC/Java code look like that performs the insert? - Did you try with fewer than 25 columns, and does that work? (I would not expect that the the number of columns makes any difference, but your email subject suggests so; hence, please elaborate on that!) Stefan ----- Original Message -----

Here some information: monetDB: MonetDB5 OS: Windows 7 64 bit, RAM 4GB Jdbc : monetdb-jdbc-2.4

Can you please tell me specifically what information do you need to give me advice.

Thanks Shajon

-----Original Message----- From: users-list-bounces+alam=finengine.com@monetdb.org [mailto:users-list-bounces+alam=finengine.com@monetdb.org] On Behalf Of Lefteris Sent: Monday, March 11, 2013 8:44 PM To: Communication channel for MonetDB users Subject: Re: Insertion problem for large number of columns

You are giving too little of information for us to even make a general suggestion.

On Mon, Mar 11, 2013 at 3:14 PM, Shajon wrote:

...
Dear Monet Team,

Today I was trying to insert data in MonetDB using " insert into ." command through jdbc from my application but the server is crashing & no data is inserting. That table has 25 columns and I am passing all values.

Thanks

Shajon

_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

-- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |

Reply

Sign in to reply online Use email software

Shajon

4:17 p.m.

Dear Stefan, Thank you for your help. Bellow I have provided my answer s Which version (release) of MonetDB are you using? MonetDB5 MonetDB5-SQL-Installer-x86_64-20120917 MonetDB SQL server and client, 64 bit, 32 bit oid MonetDB5-Geom-Module-x86_64-20121010 MonetDB SQL Geometry Module, 64 bit, 32 bit oid Are you using a 32- or 64-bit build of MonetDB? 64 bit Did you install the 32-bit or 64-bit or both JDBC drivers? 64 bit. i just used ( monetdb-jdbc-2.8.jar) MonetDB JDBC v4 driver for the Java 2 Platform 1.6 and 1.7. How does the crash show itself? the server process simply stop without any information What does you table schema (column types) look like? the table has columns with data type varchar , int , double, time Does the server crash with any data/tuple you insert? When I try to insert data using my java app/moned DB Sql client/ DBvisualizer it crash What does a single sample tuple look like? insert into .. (column list)values(..) How exactly does your JDBC/Java code look like that perform the insert? it just connects to database and inserts data using "insert into" command as batch. I have also disabled Auto commit. i did not use PrepareStatement strategy. Did you try with fewer than 25 columns, and does that work? Yes. I have other two tables where i load ~18 million records each day using copy command and using java app through this JDBC Shajon -----Original Message----- From: users-list-bounces+alam=finengine.com@monetdb.org [mailto:users-list-bounces+alam=finengine.com@monetdb.org] On Behalf Of Stefan Manegold Sent: Monday, March 11, 2013 9:16 PM To: Communication channel for MonetDB users Subject: Re: Insertion problem for large number of columns To start with: - Which version (release) of MonetDB are you using? - Are you using a 32- or 64-bit build of MonetDB? - Did you install the 32-bit or 64-bit or both JDBC drivers? - How does the crash show itself? + Are there any error messages on the server console? + Are there any errors returned from the server via you JDBC connection? + Or does the server process simply stop without any information? - What does you table schema (column types) look like? - Does the server crash with any data/tuple you insert? - What does a single sample tuple look like? - How exactly does your JDBC/Java code look like that performs the insert? - Did you try with fewer than 25 columns, and does that work? (I would not expect that the the number of columns makes any difference, but your email subject suggests so; hence, please elaborate on that!) Stefan ----- Original Message -----

Here some information: monetDB: MonetDB5 OS: Windows 7 64 bit, RAM 4GB Jdbc : monetdb-jdbc-2.4

Can you please tell me specifically what information do you need to give me advice.

Thanks Shajon

-----Original Message----- From: users-list-bounces+alam=finengine.com@monetdb.org [mailto:users-list-bounces+alam=finengine.com@monetdb.org] On Behalf Of Lefteris Sent: Monday, March 11, 2013 8:44 PM To: Communication channel for MonetDB users Subject: Re: Insertion problem for large number of columns

You are giving too little of information for us to even make a general suggestion.

On Mon, Mar 11, 2013 at 3:14 PM, Shajon wrote:

...
Dear Monet Team,

Today I was trying to insert data in MonetDB using " insert into ." command through jdbc from my application but the server is crashing & no data is inserting. That table has 25 columns and I am passing all values.

Thanks

Shajon

_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

-- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) | _______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

Reply

Sign in to reply online Use email software

Martin Kersten

12 Mar 12 Mar

8:22 a.m.

Dear Shajon, Most likely a bug in your code base. regards, Martin On 3/11/13 3:14 PM, Shajon wrote:

Dear Monet Team,

Today I was trying to insert data in MonetDB using “ insert into …” command through jdbc from my application but the server is crashing & no data is inserting. That table has 25 columns and I am passing all values.

Thanks

Shajon

_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

Reply

Sign in to reply online Use email software

Ying Zhang

9:36 a.m.

Hello Shajon, Please provide us some more background information so that we can look further into your problem: - which monetdb version are you using, i.e., the output of 'mserver5 --version'? - which OS? - Did you get any error message when the server crashed? - What data types are your columns? - Did you execute the INSERT statement in AUTO COMMIT mode? - Did the server crash at the first INSERT INTO or did it crash after several INSERT INTO statements, then how many? - Is this problem reproduceable, i.e., restart the mserver and do the INSERT again and the same error occurs? Best regards, Jennie On Mon, Mar 11, 2013 at 08:14:01PM +0600, Shajon wrote:

Dear Monet Team,

Today I was trying to insert data in MonetDB using “ insert into …” command through jdbc from my application but the server is crashing & no data is inserting. That table has 25 columns and I am passing all values.

Thanks

Shajon

_______________________________________________ Info mailing list Info@monetdb.org http://mail.monetdb.org/mailman/listinfo/info

Reply

Sign in to reply online Use email software

4309

Age (days ago)

4310

Last active (days ago)

Download

6 comments

5 participants

tags

participants (5)

Lefteris
Martin Kersten
Shajon
Stefan Manegold
Ying Zhang