Insertion problem for large number of columns
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
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 alam@finengine.com 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
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 alam@finengine.com 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
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 alam@finengine.com 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
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 alam@finengine.com 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
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
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
participants (5)
-
Lefteris -
Martin Kersten -
Shajon -
Stefan Manegold -
Ying Zhang