Error using MySQL

[Chris Haus]

Hi there,

not sure whether this is a DB problem or a constellio one.
I configured a new server, everything the same way as the old one,
using MySQL.
Starting Constellion works find, all tables are created.
Setup a collection and connector works fine as well.

But then it happens: Constellion throws errors in logs/
Constellio.log:
ERROR http-8080-3 org.hibernate.util.JDBCExceptionReporter -
Incorrect arguments to mysqld_stmt_execute
WARN http-8080-3 org.hibernate.util.JDBCExceptionReporter -
SQL Error: 1210, SQLState: HY000
ERROR http-8080-3 org.hibernate.util.JDBCExceptionReporter -
Incorrect arguments to mysqld_stmt_execute
WARN http-8080-3 org.hibernate.util.JDBCExceptionReporter -
SQL Error: 1210, SQLState: HY000
ERROR http-8080-3 org.hibernate.util.JDBCExceptionReporter -
Incorrect arguments to mysqld_stmt_execute
instead of traversing or indexing anything.

Is it a right and/or write problem in MySQL?
All tables are created just fine - but they are not getting filled up
after starting to index.
Derby works fine though - if I switch to derby and use the same
setting within the connector, it just works fine.

What the problem here?

Thank you in advance
Chris

[Chris Haus]

A bit more information:


http://dev.mysql.com/doc/refman/5.1/en/error-messages-server.html#error_er_wrong_arguments

Error: 1210 SQLSTATE: HY000 (ER_WRONG_ARGUMENTS)
Message: Incorrect arguments to %s

--

And a really stange thing:
Now I switched on logging in my.cnf:
general_log_file = /var/log/mysql/mysql.log
general_log = 1
restarted Constellio and it works.

[Vincent Dussault]

Hi Chris,

Do you have a stack trace in Tomcat's logs that could help identifying the issue?

Thanks,

Vincent Dussault

--
Vous recevez ce message, car vous êtes abonné au groupe Google Groupes Constellio.
Pour envoyer un message à ce groupe, adressez un e-mail à const...@googlegroups.com.
Pour vous désabonner de ce groupe, envoyez un e-mail à l'adresse constellio+...@googlegroups.com.
Pour plus d'options, consultez la page de ce groupe : http://groups.google.com/group/constellio?hl=fr

[Chris Haus]

Sure ..

15.03.2011 07:51:42
com.doculibre.constellio.connector.http.HttpConnectorDocumentList
nextDocument
INFO: Serving document to connector :
http://cities.eurip.com/yp/entry/de-blumenlaeden/mammelzen/blumenshop-id-120885.html
WARN [http-8080-1] (JDBCExceptionReporter.java:100) - SQL Error:
1210, SQLState: HY000
ERROR [http-8080-1] (JDBCExceptionReporter.java:101) - Incorrect
arguments to mysqld_stmt_execute
15.03.2011 07:51:43
com.doculibre.constellio.feedprotocol.FeedProcessor addRecord
SCHWERWIEGEND: Exception while trying to make record persistent
javax.persistence.PersistenceException:
org.hibernate.exception.GenericJDBCException: could not insert:
[com.doculibre.constellio.entities.ParsedContent]
at
org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:
1179)
at
org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:
1112)
at
org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:
1118)
at
org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:
618)
at
com.doculibre.constellio.services.BaseCRUDServicesImpl.makePersistent(Unknown
Source)
at
com.doculibre.constellio.feedprotocol.FeedProcessor.addRecord(Unknown
Source)
at
com.doculibre.constellio.feedprotocol.FeedProcessor.processRecord(Unknown
Source)
at
com.doculibre.constellio.feedprotocol.FeedProcessor.processFeed(Unknown
Source)
at
com.doculibre.constellio.feedprotocol.FeedServlet.doPost(Unknown
Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:
637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:
717)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
290)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:
206)
at
com.doculibre.constellio.filters.LocalRequestFilter.doFilter(Unknown
Source)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:
206)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:
233)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:
191)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:
127)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:
102)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:
109)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:
298)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:
852)
at org.apache.coyote.http11.Http11Protocol
$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint
$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:636)
Caused by: org.hibernate.exception.GenericJDBCException: could not
insert: [com.doculibre.constellio.entities.ParsedContent]
at
org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:
140)
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:
128)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:
66)
at
org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:
64)
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:
2329)
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:
2836)
at
org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:
71)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:
268)
at
org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:
321)
at
org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:
204)
at
org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:
130)
at
org.hibernate.ejb.event.EJB3PersistEventListener.saveWithGeneratedId(EJB3PersistEventListener.java:
69)
at
org.hibernate.event.def.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:
179)
at
org.hibernate.event.def.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:
135)
at org.hibernate.impl.SessionImpl.firePersist(SessionImpl.java:
791)
at org.hibernate.impl.SessionImpl.persist(SessionImpl.java:
783)
at org.hibernate.engine.EJB3CascadingAction
$1.cascade(EJB3CascadingAction.java:48)
at org.hibernate.engine.Cascade.cascadeToOne(Cascade.java:392)
at
org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:335)
at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:
204)
at org.hibernate.engine.Cascade.cascade(Cascade.java:161)
at
org.hibernate.event.def.AbstractSaveEventListener.cascadeBeforeSave(AbstractSaveEventListener.java:
451)
at
org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:
288)
at
org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:
204)
at
org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:
130)
at
org.hibernate.ejb.event.EJB3PersistEventListener.saveWithGeneratedId(EJB3PersistEventListener.java:
69)
at
org.hibernate.event.def.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:
179)
at
org.hibernate.event.def.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:
135)
at
org.hibernate.event.def.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:
61)
at org.hibernate.impl.SessionImpl.firePersist(SessionImpl.java:
800)
at org.hibernate.impl.SessionImpl.persist(SessionImpl.java:
774)
at org.hibernate.impl.SessionImpl.persist(SessionImpl.java:
778)
at
org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:
612)
... 22 more
Caused by: java.sql.SQLException: Incorrect arguments to
mysqld_stmt_execute
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:
946)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
at
com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:
1169)
at
com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:
693)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:
1404)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:
1318)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:
1303)
at org.hibernate.id.IdentityGenerator
$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:94)
at
org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:
57)
... 51 more
WARN [http-8080-1] (JDBCExceptionReporter.java:100) - SQL Error:
1210, SQLState: HY000
ERROR [http-8080-1] (JDBCExceptionReporter.java:101) - Incorrect
arguments to mysqld_stmt_execute

And now it restarts from the beginning.