Uploaded image for project: 'Content IO'
  1. Content IO
  2. CONTENTIO-215

Error reading from InputStream java.io.IOException when exporting SQL content

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Blocker Blocker
    • 3.6.1, 3.7.0
    • 3.6.0
    • None
    • 4.5 M1

      2021-05-17 14:45:53,659 DEBUG [org.ametys.plugins.contentio.export.sql.FillSqlTableComponent] (AmetysRuntimeScheduler_Worker-3;) Query : com.mysql.cj.jdbc.ClientPreparedStatement: INSERT INTO AmetysExport_Program_OrgUnit VALUES ( 'programContent://0e71b55e-d549-44c3-ae09-95ab7febe5c3', 'orgunitContent://8ee00e54-06f6-430d-b775-8a22f9a43021', 1)
      2021-05-17 14:45:53,659 DEBUG [org.ametys.plugins.contentio.export.sql.FillSqlTableComponent] (AmetysRuntimeScheduler_Worker-3;) Query : com.mysql.cj.jdbc.ClientPreparedStatement: INSERT INTO AmetysExport_Program_Place VALUES ( 'programContent://0e71b55e-d549-44c3-ae09-95ab7febe5c3', 'content://7a046c42-e056-4243-914a-b25ac1f100d2', 1)
      2021-05-17 14:45:53,659 DEBUG [org.ametys.plugins.contentio.export.sql.FillSqlTableComponent] (AmetysRuntimeScheduler_Worker-3;) Query : com.mysql.cj.jdbc.ClientPreparedStatement: INSERT INTO AmetysExport_Program_ProgramWebSite VALUES ( 'programContent://0e71b55e-d549-44c3-ae09-95ab7febe5c3@1', 'programContent://0e71b55e-d549-44c3-ae09-95ab7febe5c3', 1, 'http://www.enac.fr/fr/unmanned-aircraft-systems-services-and-management-advanced-master', null)
      2021-05-17 14:45:53,659 DEBUG [org.ametys.plugins.contentio.export.sql.FillSqlTableComponent] (AmetysRuntimeScheduler_Worker-3;) Query : com.mysql.cj.jdbc.ClientPreparedStatement: INSERT INTO AmetysExport_Program_FormofteachingOrg VALUES ( 'programContent://0e71b55e-d549-44c3-ae09-95ab7febe5c3', 'content://93130b10-858f-4362-ac03-24ac8c1aaa02', 1)
      2021-05-17 14:45:53,659 DEBUG [org.ametys.plugins.contentio.export.sql.FillSqlTableComponent] (AmetysRuntimeScheduler_Worker-3;) Query : com.mysql.cj.jdbc.ClientPreparedStatement: INSERT INTO AmetysExport_Program_PartnerSchools VALUES ( ** NOT SPECIFIED **, ** NOT SPECIFIED **, ** NOT SPECIFIED **, ** NOT SPECIFIED **, ** NOT SPECIFIED **)
      2021-05-17 14:45:53,659 DEBUG [org.ametys.plugins.contentio.export.sql.FillSqlTableComponent] (AmetysRuntimeScheduler_Worker-3;) Query : com.mysql.cj.jdbc.ClientPreparedStatement: INSERT INTO AmetysExport_Program_PartnerLaboratories VALUES ( ** NOT SPECIFIED **, ** NOT SPECIFIED **, ** NOT SPECIFIED **, ** NOT SPECIFIED **, ** NOT SPECIFIED **)
      2021-05-17 14:45:53,659 DEBUG [org.ametys.plugins.contentio.export.sql.FillSqlTableComponent] (AmetysRuntimeScheduler_Worker-3;) Query : com.mysql.cj.jdbc.ClientPreparedStatement: INSERT INTO AmetysExport_Program_Attachments VALUES ( 'programContent://0e71b55e-d549-44c3-ae09-95ab7febe5c3@1', 'programContent://0e71b55e-d549-44c3-ae09-95ab7febe5c3', 1, 'Plaquette-MSDrones.pdf', ** STREAM DATA **, 'application/pdf', 2969611, '2019-07-31 08:03:36', 'More information')
      2021-05-17 14:45:53,664 ERROR [org.ametys.plugins.contentio.export.sql.ContentExportSchedulable] (AmetysRuntimeScheduler_Worker-3;) Une erreur est survenue durant l'export
      java.sql.SQLException: Erreur durant l'exécution des requêtes d'insertion.
      	at org.ametys.plugins.contentio.export.sql.FillSqlTableComponent.executeInsert(FillSqlTableComponent.java:184)
      	at org.ametys.plugins.contentio.export.sql.FillSqlTableComponent.fillTableForContentType(FillSqlTableComponent.java:321)
      	at org.ametys.plugins.contentio.export.sql.FillSqlTableComponent.insertValues(FillSqlTableComponent.java:230)
      	at org.ametys.plugins.contentio.export.sql.FillSqlTableComponent.fillTable(FillSqlTableComponent.java:156)
      	at org.ametys.plugins.contentio.export.sql.ExportManager.export(ExportManager.java:294)
      	at org.ametys.plugins.contentio.export.sql.ContentExportSchedulable.execute(ContentExportSchedulable.java:59)
      	at org.ametys.core.schedule.AmetysJob.execute(AmetysJob.java:151)
      	at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
      	at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
      Caused by: java.sql.BatchUpdateException: Error reading from InputStream java.io.IOException
      	at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      	at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
      	at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
      	at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
      	at com.mysql.cj.util.Util.handleNewInstance(Util.java:192)
      	at com.mysql.cj.util.Util.getInstance(Util.java:167)
      	at com.mysql.cj.util.Util.getInstance(Util.java:174)
      	at com.mysql.cj.jdbc.exceptions.SQLError.createBatchUpdateException(SQLError.java:224)
      	at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchSerially(ClientPreparedStatement.java:853)
      	at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchInternal(ClientPreparedStatement.java:435)
      	at com.mysql.cj.jdbc.StatementImpl.executeBatch(StatementImpl.java:796)
      	at org.apache.commons.dbcp2.DelegatingStatement.executeBatch(DelegatingStatement.java:242)
      	at org.apache.commons.dbcp2.DelegatingStatement.executeBatch(DelegatingStatement.java:242)
      	at org.ametys.plugins.contentio.export.sql.FillSqlTableComponent.executeInsert(FillSqlTableComponent.java:180)
      	... 8 more
      Caused by: java.sql.SQLException: Error reading from InputStream java.io.IOException
      	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
      	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
      	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
      	at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1115)
      	at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchSerially(ClientPreparedStatement.java:832)
      	... 13 more
      
      

            Unassigned Unassigned
            lperier Laurence Perier
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: