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
Favorite Filters
You must be logged in to view favorite filters.
Export - CSV (All fields)
Export - CSV (Current fields)
Search
1 of 1
Error reading from InputStream java.io.IOException when exporting SQL content
-
Unassigned
-
Laurence Perier
- Votes:
-
0 Vote for this issue
- Watchers:
-
2 Start watching this issue
- Created:
- Updated:
- Resolved:
{"errorMessages":["jqlTooComplex"],"errors":{}}
[{"id":-1,"name":"My open issues","jql":"assignee = currentUser() AND resolution = Unresolved order by updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":true},{"id":-2,"name":"Reported by me","jql":"reporter = currentUser() order by created DESC","isSystem":true,"sharePermissions":[],"requiresLogin":true},{"id":-4,"name":"All issues","jql":"order by created DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-5,"name":"Open issues","jql":"resolution = Unresolved order by priority DESC,updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-9,"name":"Done issues","jql":"statusCategory = Done order by updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-3,"name":"Viewed recently","jql":"issuekey in issueHistory() order by lastViewed DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-6,"name":"Created recently","jql":"created >= -1w order by created DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-7,"name":"Resolved recently","jql":"resolutiondate >= -1w order by updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-8,"name":"Updated recently","jql":"updated >= -1w order by updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false}]
0.3
0