Search

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