Multiple insert into error
Hi! I am trying to convert Lucene index into MonetDB with my app ( https://github.com/hjortron/LuceneToMonetDBConverter). App iterates through all Lucene docs and creates "insert into" query for each. First time problem appears on 80k row(and then dramatically falls down to 250 row), app throws error: INSERT INTO sys."EventTracking"(datetime,Hash,UserIP,EventType,SearchResultState,ViewType,PageNumber,ResultsCount,ElapsedTime) VALUES('2014-12-10 13:22:41','hod','127.0.0.1','Search','>No',0,0,2368195,85) Unhandled Exception: System.Data.Odbc.OdbcException: ERROR [HY000] [MonetDB][ODBC Driver 11.19.7]General error In merovingian.log I have only: "2015-01-26 00:43:03 ERR discovery[846]: cannot retrieve name info: Temporary failure in name resolution", that repeats each 30 minutes. On another instance of MonetDB my app works fine. Please help.
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Does you app make new connections for every insert? If so, then don't do that but reuse the connection for all queries. The error you get looks like it has to do with the failure to create a new connection. On 27/01/15 17:32, Art Apl wrote:
Hi! I am trying to convert Lucene index into MonetDB with my app (https://github.com/hjortron/LuceneToMonetDBConverter). App iterates through all Lucene docs and creates "insert into" query for each. First time problem appears on 80k row(and then dramatically falls down to 250 row), app throws error: INSERT INTO sys."EventTracking"(datetime,Hash,UserIP,EventType,SearchResultState,ViewType,PageNumber,ResultsCount,ElapsedTime)
VALUES('2014-12-10
13:22:41','hod','127.0.0.1','Search','>No',0,0,2368195,85) Unhandled Exception: System.Data.Odbc.OdbcException: ERROR [HY000] [MonetDB][ODBC Driver 11.19.7]General error In merovingian.log I have only: "2015-01-26 00:43:03 ERR discovery[846]: cannot retrieve name info: Temporary failure in name resolution", that repeats each 30 minutes. On another instance of MonetDB my app works fine. Please help.
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
- -- Sjoerd Mullender -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQCVAwUBVMfEdz7g04AjvIQpAQL5NwQAlW2kRNtPdFHoaWPEATJfOxvvM218MAx9 IfUVHuCxlSytxezR7wPv9e3ktxSMZuYbN2EJGIDlRJUnRnx7q/jCBy3b6BaVKEnE eXZ2VuMFysKoPkzdLlHFRfq6g5RWBOcJckOxUXyGeRbL0X5W7Es6+OaENbGEKzcn Ic1P2G7G+6I= =bLqa -----END PGP SIGNATURE-----
Thank you, Sjoerd!
No, I am using only one connection.
2015-01-27 20:01 GMT+03:00 Sjoerd Mullender
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Does you app make new connections for every insert? If so, then don't do that but reuse the connection for all queries. The error you get looks like it has to do with the failure to create a new connection.
On 27/01/15 17:32, Art Apl wrote:
Hi! I am trying to convert Lucene index into MonetDB with my app (https://github.com/hjortron/LuceneToMonetDBConverter). App iterates through all Lucene docs and creates "insert into" query for each. First time problem appears on 80k row(and then dramatically falls down to 250 row), app throws error: INSERT INTO
sys."EventTracking"(datetime,Hash,UserIP,EventType,SearchResultState,ViewType,PageNumber,ResultsCount,ElapsedTime)
VALUES('2014-12-10
13:22:41','hod','127.0.0.1','Search','>No',0,0,2368195,85) Unhandled Exception: System.Data.Odbc.OdbcException: ERROR [HY000] [MonetDB][ODBC Driver 11.19.7]General error In merovingian.log I have only: "2015-01-26 00:43:03 ERR discovery[846]: cannot retrieve name info: Temporary failure in name resolution", that repeats each 30 minutes. On another instance of MonetDB my app works fine. Please help.
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
- -- Sjoerd Mullender -----BEGIN PGP SIGNATURE----- Version: GnuPG v1
iQCVAwUBVMfEdz7g04AjvIQpAQL5NwQAlW2kRNtPdFHoaWPEATJfOxvvM218MAx9 IfUVHuCxlSytxezR7wPv9e3ktxSMZuYbN2EJGIDlRJUnRnx7q/jCBy3b6BaVKEnE eXZ2VuMFysKoPkzdLlHFRfq6g5RWBOcJckOxUXyGeRbL0X5W7Es6+OaENbGEKzcn Ic1P2G7G+6I= =bLqa -----END PGP SIGNATURE----- _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
participants (2)
-
Art Apl -
Sjoerd Mullender