Open Source Document Management System | OpenKM

Because information matters
https://forum.openkm.com/

Extracción de texto, conexión a base de datos

https://forum.openkm.com/viewtopic.php?t=12528

Page 1 of 1

Extracción de texto, conexión a base de datos

PostPosted:Mon Sep 15, 2014 2:30 pm
by ingsebastian
Buenos dias. Tengo un inconveniente con la extracción de texto (Tesseract) de un documento pdf escaneado. Entiendo que cuando el extractor intenta acceder a la base de datos, la conexión se encuentra cerrrada. La versión de Openkm instalada es la 6.3.0 build 8150, al final adjunto el log.
Investigando en los foros, leí algo sobre el archivo repository.xml y la opción autoReconnect=true, sin embargo, no encuentro este archivo de configuración en mi instalación. Lo debo crear?

Saludos

Code: Select all
2014-09-14 02:50:12,669 [Thread-9964] WARN  org.hibernate.util.JDBCExceptionReporter- SQL Error: 0, SQLState: 08S01
2014-09-14 02:50:12,669 [Thread-9964] ERROR org.hibernate.util.JDBCExceptionReporter- The last packet successfully received from the server was 46,512,385 milliseconds ago.  The last packet sent successfully to the server was 46,512,385 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
2014-09-14 02:50:12,669 [Thread-9964] ERROR org.hibernate.transaction.JDBCTransaction- Could not toggle autocommit
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 46,512,385 milliseconds ago.  The last packet sent successfully to the server was 46,512,385 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
	at sun.reflect.GeneratedConstructorAccessor465.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
	at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1122)
	at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3317)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1941)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2114)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2690)
	at com.mysql.jdbc.ConnectionImpl.setAutoCommit(ConnectionImpl.java:5093)
	at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnection.java:371)
	at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setAutoCommit(PoolingDataSource.java:328)
	at org.hibernate.transaction.JDBCTransaction.toggleAutoCommit(JDBCTransaction.java:224)
	at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTransaction.java:216)
	at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:192)
	at com.openkm.dao.HibernateUtil.rollback(HibernateUtil.java:312)
	at com.openkm.dao.NodeDocumentDAO.textExtractorHelper(NodeDocumentDAO.java:1383)
	at com.openkm.extractor.TextExtractorWorker.processSerial(TextExtractorWorker.java:164)
	at com.openkm.extractor.TextExtractorWorker.processQueue(TextExtractorWorker.java:149)
	at com.openkm.extractor.TextExtractorWorker.run(TextExtractorWorker.java:100)
	at sun.reflect.GeneratedMethodAccessor686.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at bsh.Reflect.invokeMethod(Reflect.java:134)
	at bsh.Reflect.invokeObjectMethod(Reflect.java:80)
	at bsh.BSHPrimarySuffix.doName(BSHPrimarySuffix.java:176)
	at bsh.BSHPrimarySuffix.doSuffix(BSHPrimarySuffix.java:120)
	at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:80)
	at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:47)
	at bsh.Interpreter.eval(Interpreter.java:645)
	at bsh.Interpreter.eval(Interpreter.java:739)
	at bsh.Interpreter.eval(Interpreter.java:728)
	at com.openkm.util.ExecutionUtils.runScript(ExecutionUtils.java:112)
	at com.openkm.core.Cron$RunnerBsh.run(Cron.java:103)
	at java.lang.Thread.run(Thread.java:745)
Caused by: java.net.SocketException: Broken pipe
	at java.net.SocketOutputStream.socketWrite0(Native Method)
	at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:113)
	at java.net.SocketOutputStream.write(SocketOutputStream.java:159)
	at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82)
	at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140)
	at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3298)
	... 29 more
2014-09-14 02:50:12,670 [Thread-9964] WARN  com.openkm.extractor.TextExtractorWorker- could not update: [com.openkm.dao.bean.NodeDocument#72133187-31a6-41e8-b109-994551ab93c1]
com.openkm.core.DatabaseException: could not update: [com.openkm.dao.bean.NodeDocument#72133187-31a6-41e8-b109-994551ab93c1]
	at com.openkm.dao.NodeDocumentDAO.textExtractorHelper(NodeDocumentDAO.java:1384)
	at com.openkm.extractor.TextExtractorWorker.processSerial(TextExtractorWorker.java:164)
	at com.openkm.extractor.TextExtractorWorker.processQueue(TextExtractorWorker.java:149)
	at com.openkm.extractor.TextExtractorWorker.run(TextExtractorWorker.java:100)
	at sun.reflect.GeneratedMethodAccessor686.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at bsh.Reflect.invokeMethod(Reflect.java:134)
	at bsh.Reflect.invokeObjectMethod(Reflect.java:80)
	at bsh.BSHPrimarySuffix.doName(BSHPrimarySuffix.java:176)
	at bsh.BSHPrimarySuffix.doSuffix(BSHPrimarySuffix.java:120)
	at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:80)
	at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:47)
	at bsh.Interpreter.eval(Interpreter.java:645)
	at bsh.Interpreter.eval(Interpreter.java:739)
	at bsh.Interpreter.eval(Interpreter.java:728)
	at com.openkm.util.ExecutionUtils.runScript(ExecutionUtils.java:112)
	at com.openkm.core.Cron$RunnerBsh.run(Cron.java:103)
	at java.lang.Thread.run(Thread.java:745)
Caused by: org.hibernate.exception.JDBCConnectionException: could not update: [com.openkm.dao.bean.NodeDocument#72133187-31a6-41e8-b109-994551ab93c1]
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:99)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
	at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2613)
	at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2495)
	at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2822)
	at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:113)
	at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:273)
	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:265)
	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:185)
	at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
	at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)
	at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)
	at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:383)
	at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:133)
	at com.openkm.dao.HibernateUtil.commit(HibernateUtil.java:303)
	at com.openkm.dao.NodeDocumentDAO.textExtractorHelper(NodeDocumentDAO.java:1379)
	... 18 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 46,512,385 milliseconds ago.  The last packet sent successfully to the server was 46,512,385 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
	at sun.reflect.GeneratedConstructorAccessor465.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
	at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1122)
	at com.mysql.jdbc.MysqlIO.sendSplitPackets(MysqlIO.java:3739)
	at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3254)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1941)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2114)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2696)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2105)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2398)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2316)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2301)
	at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
	at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
	at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2595)
	... 31 more
Caused by: java.net.SocketException: Broken pipe
	at java.net.SocketOutputStream.socketWrite0(Native Method)
	at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:113)
	at java.net.SocketOutputStream.write(SocketOutputStream.java:159)
	at java.io.BufferedOutputStream.write(BufferedOutputStream.java:122)
	at com.mysql.jdbc.MysqlIO.sendSplitPackets(MysqlIO.java:3683)
	... 42 more

Re: Extracción de texto, conexión a base de datos

PostPosted:Tue Sep 16, 2014 6:55 pm
by jllort
Que base de datos estas utilizando ? El tema esta en el fichero con/server.xml

Re: Extracción de texto, conexión a base de datos

PostPosted:Tue Sep 16, 2014 8:22 pm
by ingsebastian
jllort, gracias por tu respuesta. Estoy utilizando mysql. Observo en server.xml: autoReconnect=true
Code: Select all
<Resource name="jdbc/OpenKMDS" auth="Container" type="javax.sql.DataSource"
            maxActive="100" maxIdle="30" maxWait="10000" validationQuery="select 1"
            username="openkm" password="xxxx" driverClassName="com.mysql.jdbc.Driver"
            url="jdbc:mysql://localhost:3306/okmdb?autoReconnect=true&useUnicode=true&characterEncoding=UTF8"/>
Saludos

Re: Extracción de texto, conexión a base de datos

PostPosted:Wed Sep 17, 2014 8:36 am
by jllort
Anyway take a look about 46,512,385 seconds are 46512 seconds -> a lot of minutes ( quite strange last transaction was passed that time ). What mysql version do you got, OS, java version etc...

Re: Extracción de texto, conexión a base de datos

PostPosted:Wed Sep 17, 2014 1:55 pm
by ingsebastian
jllort, gracias por tu colaboración, al final dejo las versiones instaladas en el sistema. Con respecto al tiempo, efectivamente es largo. Esta situación se produce generalmente durante la noche. Cuando el servidor hace la extracción de texto de un pdf sin esta capa, (lo cual le lleva bastante tiempo) y luego intenta actualizar durante la noche, cuando ningún usuario ha accedido al repositorio por un tiempo prolongado, se produce el error.
Tal vez debería probar la jvm de Oracle?

Saludos
Code: Select all
openkm@kb:~$ uname -a
Linux kb 3.13.0-35-generic #62-Ubuntu SMP Fri Aug 15 01:58:42 UTC 2014 x86_64 x86_64 x86_64 GNU/Linux

openkm@kb:~$ mysql --version
mysql  Ver 14.14 Distrib 5.5.38, for debian-linux-gnu (x86_64) using readline 6.3

openkm@kb:~$ java -version
java version "1.7.0_65"
OpenJDK Runtime Environment (IcedTea 2.5.1) (7u65-2.5.1-4ubuntu1~0.14.04.2)
OpenJDK 64-Bit Server VM (build 24.65-b04, mixed mode)

Re: Extracción de texto, conexión a base de datos

PostPosted:Fri Sep 19, 2014 5:22 pm
by jllort
No estaras haciendo algún backup o algo, que pare la base de datos o algo similar ?

Re: Extracción de texto, conexión a base de datos

PostPosted:Tue Sep 23, 2014 3:58 pm
by ingsebastian
jllort, agradezco nuevamente tu colaboración. Cuando se produce la falla, no se ejecuta ninguna acción adicional en el servidor.
Realicé otra prueba, tratando de salvar este error. Cargué el archivo pdf al repositorio de tal manera que el intento de acceso a la base de datos se produjera en horario de trabajo, pensando que en esa situación la conexión estaría viva y no habría inconvenientes, pero se produjo el mismo error.
Code: Select all
2014-09-23 11:40:00,051 [Thread-9919] WARN  com.openkm.extractor.TextExtractorWorker- *** Text extraction already running ***
2014-09-23 11:45:00,126 [Thread-9957] WARN  com.openkm.extractor.TextExtractorWorker- *** Text extraction already running ***
2014-09-23 11:47:35,706 [Thread-4998] WARN  org.hibernate.util.JDBCExceptionReporter- SQL Error: 0, SQLState: 08S01
2014-09-23 11:47:35,707 [Thread-4998] ERROR org.hibernate.util.JDBCExceptionReporter- The last packet successfully received from the server was 46,953,627 milliseconds ago.  The last packet sent successfully to the server was 46,953,627 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
2014-09-23 11:47:35,707 [Thread-4998] ERROR org.hibernate.transaction.JDBCTransaction- Could not toggle autocommit
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 46,953,639 milliseconds ago.  The last packet sent successfully to the server was 46,953,639 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
        at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1122)
        at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3317)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1941)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2114)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2690)
        at com.mysql.jdbc.ConnectionImpl.setAutoCommit(ConnectionImpl.java:5093)
        at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnection.java:371)
        at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setAutoCommit(PoolingDataSource.java:328)
        at org.hibernate.transaction.JDBCTransaction.toggleAutoCommit(JDBCTransaction.java:224)
        at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTransaction.java:216)
        at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:192)
        at com.openkm.dao.HibernateUtil.rollback(HibernateUtil.java:312)
        at com.openkm.dao.NodeDocumentDAO.textExtractorHelper(NodeDocumentDAO.java:1383)
        at com.openkm.extractor.TextExtractorWorker.processSerial(TextExtractorWorker.java:164)
        at com.openkm.extractor.TextExtractorWorker.processQueue(TextExtractorWorker.java:149)
        at com.openkm.extractor.TextExtractorWorker.run(TextExtractorWorker.java:100)
        at sun.reflect.GeneratedMethodAccessor193.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        at bsh.Reflect.invokeMethod(Reflect.java:134)
        at bsh.Reflect.invokeObjectMethod(Reflect.java:80)
        at bsh.BSHPrimarySuffix.doName(BSHPrimarySuffix.java:176)
        at bsh.BSHPrimarySuffix.doSuffix(BSHPrimarySuffix.java:120)
        at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:80)
        at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:47)
        at bsh.Interpreter.eval(Interpreter.java:645)
        at bsh.Interpreter.eval(Interpreter.java:739)
        at bsh.Interpreter.eval(Interpreter.java:728)
        at com.openkm.util.ExecutionUtils.runScript(ExecutionUtils.java:112)
        at com.openkm.core.Cron$RunnerBsh.run(Cron.java:103)
        at java.lang.Thread.run(Thread.java:745)
Caused by: java.net.SocketException: Broken pipe
        at java.net.SocketOutputStream.socketWrite0(Native Method)
        at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:113)
        at java.net.SocketOutputStream.write(SocketOutputStream.java:159)
        at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82)
        at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140)
        at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3298)
        ... 29 more
2014-09-23 11:47:35,719 [Thread-4998] WARN  com.openkm.extractor.TextExtractorWorker- could not update: [com.openkm.dao.bean.NodeDocument#032e6ee3-9ea2-4f36-bb81-41b195064d5d]
com.openkm.core.DatabaseException: could not update: [com.openkm.dao.bean.NodeDocument#032e6ee3-9ea2-4f36-bb81-41b195064d5d]
        at com.openkm.dao.NodeDocumentDAO.textExtractorHelper(NodeDocumentDAO.java:1384)
        at com.openkm.extractor.TextExtractorWorker.processSerial(TextExtractorWorker.java:164)
        at com.openkm.extractor.TextExtractorWorker.processQueue(TextExtractorWorker.java:149)
        at com.openkm.extractor.TextExtractorWorker.run(TextExtractorWorker.java:100)
        at sun.reflect.GeneratedMethodAccessor193.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        at bsh.Reflect.invokeMethod(Reflect.java:134)
        at bsh.Reflect.invokeObjectMethod(Reflect.java:80)
        at bsh.BSHPrimarySuffix.doName(BSHPrimarySuffix.java:176)
        at bsh.BSHPrimarySuffix.doSuffix(BSHPrimarySuffix.java:120)
        at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:80)
        at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:47)
        at bsh.Interpreter.eval(Interpreter.java:645)
        at bsh.Interpreter.eval(Interpreter.java:739)
        at bsh.Interpreter.eval(Interpreter.java:728)
        at com.openkm.util.ExecutionUtils.runScript(ExecutionUtils.java:112)
        at com.openkm.core.Cron$RunnerBsh.run(Cron.java:103)
        at java.lang.Thread.run(Thread.java:745)
Caused by: org.hibernate.exception.JDBCConnectionException: could not update: [com.openkm.dao.bean.NodeDocument#032e6ee3-9ea2-4f36-bb81-41b195064d5d]
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:99)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
        at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2613)
        at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2495)
        at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2822)
        at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:113)
        at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:273)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:265)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:185)
        at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
        at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)
        at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)
        at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:383)
        at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:133)
        at com.openkm.dao.HibernateUtil.commit(HibernateUtil.java:303)
        at com.openkm.dao.NodeDocumentDAO.textExtractorHelper(NodeDocumentDAO.java:1379)
        ... 18 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 46,953,627 milliseconds ago.  The last packet sent successfully to the server was 46,953,627 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
        at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1122)
        at com.mysql.jdbc.MysqlIO.sendSplitPackets(MysqlIO.java:3739)
        at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3254)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1941)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2114)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2696)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2105)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2398)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2316)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2301)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
        at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2595)
        ... 31 more
Caused by: java.net.SocketException: Broken pipe
        at java.net.SocketOutputStream.socketWrite0(Native Method)
        at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:113)
        at java.net.SocketOutputStream.write(SocketOutputStream.java:159)
        at java.io.BufferedOutputStream.write(BufferedOutputStream.java:122)
        at com.mysql.jdbc.MysqlIO.sendSplitPackets(MysqlIO.java:3683)
        ... 42 more
2014-09-23 11:50:02,271 [Thread-9974] INFO  com.openkm.extractor.TextExtractorWorker- processSerial.Working on {docUuid=032e6ee3-9ea2-4f36-bb81-41b195064d5d, docPath=/okm:root/AUT - SES/03_Bibliografía/NFPA/8502-1995.pdf, docVerUuid=2af12246-646d-4a61-a22c-f529b6dbec5e, date=Mon Sep 22 09:38:37 ART 2014}
2014-09-23 11:50:02,633 [Thread-9974] WARN  com.openkm.extractor.PdfTextExtractor- PDF does not contains text layer
2014-09-23 11:55:00,224 [Thread-10009] WARN  com.openkm.extractor.TextExtractorWorker- *** Text extraction already running ***
2014-09-23 12:00:00,059 [Thread-10040] INFO  com.openkm.core.UserMailImporter- *** User mail importer activated ***
2014-09-23 12:00:00,124 [Thread-10041] WARN  com.openkm.extractor.TextExtractorWorker- *** Text extraction already running ***

Re: Extracción de texto, conexión a base de datos

PostPosted:Thu Sep 25, 2014 9:03 am
by jllort
Esto te pasa con todos los documentos o solo con este ?

Re: Extracción de texto, conexión a base de datos

PostPosted:Fri Oct 03, 2014 2:44 pm
by ingsebastian
Solo he tenido inconvenientes con este documento, ya que es bastante largo (96 páginas).

Saludos

Re: Extracción de texto, conexión a base de datos

PostPosted:Sat Oct 04, 2014 9:45 am
by jllort
Es posible que pruebes con este documento en nuestra demo online o que nos lo pases para poder hacer pruebas. Esto igual es un problema de los tiempos de indexación o que por alguna razón el invento se queda clavado, sin poder reproducir el problema, siendo esto un caso totalmente aislado relacionado con un documento no estamops en condicion de saber que es lo que pasa.
All times are UTC
Page 1 of 1
Powered by phpBB® Forum Software © phpBB Limited