{"action":"closed","issue":{"url":"https://api.github.com/repos/pughlab/tracker/issues/96","labels_url":"https://api.github.com/repos/pughlab/tracker/issues/96/labels{/name}","comments_url":"https://api.github.com/repos/pughlab/tracker/issues/96/comments","events_url":"https://api.github.com/repos/pughlab/tracker/issues/96/events","html_url":"https://github.com/pughlab/tracker/issues/96","id":111674679,"number":96,"title":"Serialization failures when pasting multiple cells","user":{"login":"morungos","id":442090,"avatar_url":"https://avatars.githubusercontent.com/u/442090?v=3","gravatar_id":"","url":"https://api.github.com/users/morungos","html_url":"https://github.com/morungos","followers_url":"https://api.github.com/users/morungos/followers","following_url":"https://api.github.com/users/morungos/following{/other_user}","gists_url":"https://api.github.com/users/morungos/gists{/gist_id}","starred_url":"https://api.github.com/users/morungos/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/morungos/subscriptions","organizations_url":"https://api.github.com/users/morungos/orgs","repos_url":"https://api.github.com/users/morungos/repos","events_url":"https://api.github.com/users/morungos/events{/privacy}","received_events_url":"https://api.github.com/users/morungos/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/pughlab/tracker/labels/bug","name":"bug","color":"fc2929"},{"url":"https://api.github.com/repos/pughlab/tracker/labels/critical","name":"critical","color":"5319e7"}],"state":"closed","locked":false,"assignee":{"login":"morungos","id":442090,"avatar_url":"https://avatars.githubusercontent.com/u/442090?v=3","gravatar_id":"","url":"https://api.github.com/users/morungos","html_url":"https://github.com/morungos","followers_url":"https://api.github.com/users/morungos/followers","following_url":"https://api.github.com/users/morungos/following{/other_user}","gists_url":"https://api.github.com/users/morungos/gists{/gist_id}","starred_url":"https://api.github.com/users/morungos/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/morungos/subscriptions","organizations_url":"https://api.github.com/users/morungos/orgs","repos_url":"https://api.github.com/users/morungos/repos","events_url":"https://api.github.com/users/morungos/events{/privacy}","received_events_url":"https://api.github.com/users/morungos/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/pughlab/tracker/milestones/1","html_url":"https://github.com/pughlab/tracker/milestones/2.1","labels_url":"https://api.github.com/repos/pughlab/tracker/milestones/1/labels","id":1309213,"number":1,"title":"2.1","description":"","creator":{"login":"morungos","id":442090,"avatar_url":"https://avatars.githubusercontent.com/u/442090?v=3","gravatar_id":"","url":"https://api.github.com/users/morungos","html_url":"https://github.com/morungos","followers_url":"https://api.github.com/users/morungos/followers","following_url":"https://api.github.com/users/morungos/following{/other_user}","gists_url":"https://api.github.com/users/morungos/gists{/gist_id}","starred_url":"https://api.github.com/users/morungos/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/morungos/subscriptions","organizations_url":"https://api.github.com/users/morungos/orgs","repos_url":"https://api.github.com/users/morungos/repos","events_url":"https://api.github.com/users/morungos/events{/privacy}","received_events_url":"https://api.github.com/users/morungos/received_events","type":"User","site_admin":false},"open_issues":5,"closed_issues":28,"state":"open","created_at":"2015-09-16T20:25:38Z","updated_at":"2015-10-16T19:09:30Z","due_on":"2015-10-07T04:00:00Z","closed_at":null},"comments":1,"created_at":"2015-10-15T18:07:55Z","updated_at":"2015-10-16T19:09:30Z","closed_at":"2015-10-16T19:09:30Z","body":"Although not, seemingly, when pasting each individually. And it looks like it's mixing types of cells that's the issue. Stack backtrace:\r\n\r\n```\r\nwhere view_attributes.VIEW_ID = ?]; transaction rollback: serialization failure; nested exception is java.sql.SQLTransactionRollbackException: transac\r\ntion rollback: serialization failure\r\n\tat org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:71)\r\n\tat org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)\r\n\tat org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)\r\n\tat org.springframework.data.jdbc.query.QueryDslJdbcTemplate.translateQueryException(QueryDslJdbcTemplate.java:326)\r\n\tat org.springframework.data.jdbc.query.QueryDslJdbcTemplate.access$000(QueryDslJdbcTemplate.java:74)\r\n\tat org.springframework.data.jdbc.query.QueryDslJdbcTemplate$7.doInConnection(QueryDslJdbcTemplate.java:251)\r\n\tat org.springframework.data.jdbc.query.QueryDslJdbcTemplate$7.doInConnection(QueryDslJdbcTemplate.java:244)\r\n\tat org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:350)\r\n\tat org.springframework.data.jdbc.query.QueryDslJdbcTemplate.query(QueryDslJdbcTemplate.java:244)\r\n\tat ca.uhnresearch.pughlab.tracker.dao.impl.CaseAttributePersistence.addCaseTuples(CaseAttributePersistence.java:90)\r\n\tat ca.uhnresearch.pughlab.tracker.dao.impl.CaseAttributePersistence.getJsonData(CaseAttributePersistence.java:108)\r\n\tat ca.uhnresearch.pughlab.tracker.dao.impl.StudyRepositoryImpl.getCaseData(StudyRepositoryImpl.java:569)\r\n\tat ca.uhnresearch.pughlab.tracker.dao.impl.StudyRepositoryImpl.getCaseAttributeValue(StudyRepositoryImpl.java:649)\r\n\tat ca.uhnresearch.pughlab.tracker.resource.EntityFieldResource.buildResponseDTO(EntityFieldResource.java:108)\r\n\tat ca.uhnresearch.pughlab.tracker.resource.EntityFieldResource.getResource(EntityFieldResource.java:86)\r\n\tat ca.uhnresearch.pughlab.tracker.resource.EntityFieldResource.putResource(EntityFieldResource.java:79)\r\n\tat sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n\tat sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n\tat java.lang.reflect.Method.invoke(Method.java:483)\r\n\tat org.restlet.resource.ServerResource.doHandle(ServerResource.java:521)\r\n\t... 125 more\r\nCaused by: java.sql.SQLTransactionRollbackException: transaction rollback: serialization failure\r\n\tat org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)\r\n\tat org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)\r\n\tat org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult(Unknown Source)\r\n\tat org.hsqldb.jdbc.JDBCPreparedStatement.executeQuery(Unknown Source)\r\n\tat org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)\r\n\tat org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)\r\n\tat com.mysema.query.sql.AbstractSQLQuery.list(AbstractSQLQuery.java:315)\r\n\tat org.springframework.data.jdbc.query.QueryDslJdbcTemplate$7.doInConnection(QueryDslJdbcTemplate.java:249)\r\n\t... 140 more\r\nCaused by: org.hsqldb.HsqlException: transaction rollback: serialization failure\r\n\tat org.hsqldb.error.Error.error(Unknown Source)\r\n\tat org.hsqldb.error.Error.error(Unknown Source)\r\n\tat org.hsqldb.Session.executeCompiledStatement(Unknown Source)\r\n\tat org.hsqldb.Session.execute(Unknown Source)\r\n\t... 146 more\r\n\r\n\r\n```"}}