Mysql issue at actor start
Incorrect datetime value: '2024-08-16T15:33:38.215823+02:00' for column `test`.`DataCollection`.`startTime` at row 1
@sfisher could you please take a look at that?
Do you think the +02:00
have to be dropped? Or that's something else?
Traceback (most recent call last):
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1967, in _exec_single_context
self.dialect.do_execute(
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 924, in do_execute
cursor.execute(statement, parameters)
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/mysql/connector/cursor.py", line 572, in execute
self._handle_result(self._connection.cmd_query(stmt))
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/mysql/connector/cursor.py", line 480, in _handle_result
self._handle_resultset()
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/mysql/connector/cursor.py", line 987, in _handle_resultset
(self._rows, eof) = self._connection.get_rows()
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/mysql/connector/connection.py", line 793, in get_rows
raise err
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/mysql/connector/connection.py", line 788, in get_rows
rows = self._protocol.read_text_result(self._socket,
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/mysql/connector/protocol.py", line 395, in read_text_result
raise get_exception(packet)
mysql.connector.errors.DataError: 1292 (22007): Incorrect datetime value: '2024-08-16T15:33:38.215823+02:00' for column `test`.`DataCollection`.`startTime` at row 1
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/nobackup/lvalls1/valls/workspace/daiquiri-tomo.git/daiquiri.git/daiquiri/core/hardware/abstract/scansource.py", line 155, in _emit_new_scan_event
cb(scanid, type, type, metadata=metadata)
File "/nobackup/lvalls1/valls/workspace/daiquiri-tomo.git/daiquiri.git/daiquiri/core/components/tomo/scan_listener.py", line 70, in new_scan
scan.on_scan_started(metadata)
File "/nobackup/lvalls1/valls/workspace/daiquiri-tomo.git/daiquiri.git/daiquiri/core/components/tomo/scans/sequence_tomo_scan.py", line 165, in on_scan_started
dc = self.component._metadata.add_datacollection(
File "/nobackup/lvalls1/valls/workspace/daiquiri-tomo.git/daiquiri.git/daiquiri/core/metadata/__init__.py", line 1131, in wrapper
ret = fn(*args, **kwargs)
File "/nobackup/lvalls1/valls/workspace/daiquiri-tomo.git/daiquiri.git/daiquiri/core/metadata/ispyalchemy/dc.py", line 220, in add_datacollection
ses.commit()
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2017, in commit
trans.commit(_to_root=True)
File "<string>", line 2, in commit
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/sqlalchemy/orm/state_changes.py", line 139, in _go
ret_value = fn(self, *arg, **kw)
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1302, in commit
self._prepare_impl()
File "<string>", line 2, in _prepare_impl
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/sqlalchemy/orm/state_changes.py", line 139, in _go
ret_value = fn(self, *arg, **kw)
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1277, in _prepare_impl
self.session.flush()
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 4341, in flush
self._flush(objects)
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 4477, in _flush
transaction.rollback(_capture_exception=True)
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 146, in __exit__
raise exc_value.with_traceback(exc_tb)
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 4437, in _flush
flush_context.execute()
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 466, in execute
rec.execute(self)
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 642, in execute
util.preloaded.orm_persistence.save_obj(
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 93, in save_obj
_emit_insert_statements(
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1233, in _emit_insert_statements
result = connection.execute(
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1418, in execute
return meth(
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 515, in _execute_on_connection
return connection._execute_clauseelement(
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1640, in _execute_clauseelement
ret = self._execute_context(
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1846, in _execute_context
return self._exec_single_context(
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1986, in _exec_single_context
self._handle_dbapi_exception(
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2353, in _handle_dbapi_exception
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1967, in _exec_single_context
self.dialect.do_execute(
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 924, in do_execute
cursor.execute(statement, parameters)
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/mysql/connector/cursor.py", line 572, in execute
self._handle_result(self._connection.cmd_query(stmt))
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/mysql/connector/cursor.py", line 480, in _handle_result
self._handle_resultset()
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/mysql/connector/cursor.py", line 987, in _handle_resultset
(self._rows, eof) = self._connection.get_rows()
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/mysql/connector/connection.py", line 793, in get_rows
raise err
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/mysql/connector/connection.py", line 788, in get_rows
rows = self._protocol.read_text_result(self._socket,
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/mysql/connector/protocol.py", line 395, in read_text_result
raise get_exception(packet)
sqlalchemy.exc.DataError: (mysql.connector.errors.DataError) 1292 (22007): Incorrect datetime value: '2024-08-16T15:33:38.215823+02:00' for column `test`.`DataCollection`.`startTime` at row 1
[SQL: INSERT INTO `DataCollection` (`BLSAMPLEID`, experimenttype, `dataCollectionNumber`, `startTime`, `endTime`, `runStatus`, `axisStart`, `axisEnd`, `axisRange`, `numberOfImages`, `numberOfPasses`, `exposureTime`, `imageDirectory`, `imagePrefix`, `imageSuffix`, `imageContainerSubPath`, `fileTemplate`, wavelength, resolution, `detectorDistance`, `xBeam`, `yBeam`, comments, transmission, `xtalSnapshotFullPath1`, `xtalSnapshotFullPath2`, `xtalSnapshotFullPath3`, `xtalSnapshotFullPath4`, `rotationAxis`, `beamSizeAtSampleX`, `beamSizeAtSampleY`, `dataCollectionGroupId`, `detectorId`, flux, `blSubSampleId`, `dataCollectionPlanId`) VALUES (%(blsampleid)s, %(experimenttype)s, %(datacollectionnumber)s, %(starttime)s, %(endtime)s, %(runstatus)s, %(axisstart)s, %(axisend)s, %(axisrange)s, %(numberofimages)s, %(numberofpasses)s, %(exposuretime)s, %(imagedirectory)s, %(imageprefix)s, %(imagesuffix)s, %(imagecontainersubpath)s, %(filetemplate)s, %(wavelength)s, %(resolution)s, %(detectordistance)s, %(xbeam)s, %(ybeam)s, %(comments)s, %(transmission)s, %(xtalsnapshotfullpath1)s, %(xtalsnapshotfullpath2)s, %(xtalsnapshotfullpath3)s, %(xtalsnapshotfullpath4)s, %(rotationaxis)s, %(beamsizeatsamplex)s, %(beamsizeatsampley)s, %(datacollectiongroupid)s, %(detectorid)s, %(flux)s, %(blsubsampleid)s, %(datacollectionplanid)s) RETURNING `DataCollection`.`dataCollectionId`, `DataCollection`.`SESSIONID`]
[parameters: {'blsampleid': 1, 'experimenttype': None, 'datacollectionnumber': 3860824344, 'starttime': '2024-08-16T15:33:38.215823+02:00', 'endtime': None, 'runstatus': None, 'axisstart': None, 'axisend': None, 'axisrange': None, 'numberofimages': None, 'numberofpasses': None, 'exposuretime': None, 'imagedirectory': '/tmp/scans/visitor/blc00001/id00/20240801/RAW_DATA/sample1/sample1_foo15_0003_002', 'imageprefix': None, 'imagesuffix': None, 'imagecontainersubpath': None, 'filetemplate': 'sample1_foo15_0003_002.h5', 'wavelength': None, 'resolution': None, 'detectordistance': None, 'xbeam': None, 'ybeam': None, 'comments': None, 'transmission': None, 'xtalsnapshotfullpath1': None, 'xtalsnapshotfullpath2': None, 'xtalsnapshotfullpath3': None, 'xtalsnapshotfullpath4': None, 'rotationaxis': None, 'beamsizeatsamplex': None, 'beamsizeatsampley': None, 'datacollectiongroupid': 7, 'detectorid': None, 'flux': None, 'blsubsampleid': None, 'datacollectionplanid': None}]
(Background on this error at: https://sqlalche.me/e/20/9h9h)
2024-08-16 15:33:38,716 daiquiri.core.hardware.abstract.scansource ERROR Error during scan start callback
Traceback (most recent call last):
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1967, in _exec_single_context
self.dialect.do_execute(
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 924, in do_execute
cursor.execute(statement, parameters)
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/mysql/connector/cursor.py", line 572, in execute
self._handle_result(self._connection.cmd_query(stmt))
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/mysql/connector/cursor.py", line 480, in _handle_result
self._handle_resultset()
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/mysql/connector/cursor.py", line 987, in _handle_resultset
(self._rows, eof) = self._connection.get_rows()
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/mysql/connector/connection.py", line 793, in get_rows
raise err
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/mysql/connector/connection.py", line 788, in get_rows
rows = self._protocol.read_text_result(self._socket,
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/mysql/connector/protocol.py", line 395, in read_text_result
raise get_exception(packet)
mysql.connector.errors.DataError: 1292 (22007): Incorrect datetime value: '2024-08-16T15:33:38.215823+02:00' for column `test`.`DataCollection`.`startTime` at row 1
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/nobackup/lvalls1/valls/workspace/daiquiri-tomo.git/daiquiri.git/daiquiri/core/hardware/abstract/scansource.py", line 155, in _emit_new_scan_event
cb(scanid, type, type, metadata=metadata)
File "/nobackup/lvalls1/valls/workspace/daiquiri-tomo.git/daiquiri.git/daiquiri/core/components/tomo/scan_listener.py", line 70, in new_scan
scan.on_scan_started(metadata)
File "/nobackup/lvalls1/valls/workspace/daiquiri-tomo.git/daiquiri.git/daiquiri/core/components/tomo/scans/sequence_tomo_scan.py", line 165, in on_scan_started
dc = self.component._metadata.add_datacollection(
File "/nobackup/lvalls1/valls/workspace/daiquiri-tomo.git/daiquiri.git/daiquiri/core/metadata/__init__.py", line 1131, in wrapper
ret = fn(*args, **kwargs)
File "/nobackup/lvalls1/valls/workspace/daiquiri-tomo.git/daiquiri.git/daiquiri/core/metadata/ispyalchemy/dc.py", line 220, in add_datacollection
ses.commit()
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2017, in commit
trans.commit(_to_root=True)
File "<string>", line 2, in commit
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/sqlalchemy/orm/state_changes.py", line 139, in _go
ret_value = fn(self, *arg, **kw)
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1302, in commit
self._prepare_impl()
File "<string>", line 2, in _prepare_impl
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/sqlalchemy/orm/state_changes.py", line 139, in _go
ret_value = fn(self, *arg, **kw)
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1277, in _prepare_impl
self.session.flush()
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 4341, in flush
self._flush(objects)
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 4477, in _flush
transaction.rollback(_capture_exception=True)
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 146, in __exit__
raise exc_value.with_traceback(exc_tb)
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 4437, in _flush
flush_context.execute()
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 466, in execute
rec.execute(self)
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 642, in execute
util.preloaded.orm_persistence.save_obj(
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 93, in save_obj
_emit_insert_statements(
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1233, in _emit_insert_statements
result = connection.execute(
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1418, in execute
return meth(
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 515, in _execute_on_connection
return connection._execute_clauseelement(
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1640, in _execute_clauseelement
ret = self._execute_context(
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1846, in _execute_context
return self._exec_single_context(
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1986, in _exec_single_context
self._handle_dbapi_exception(
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2353, in _handle_dbapi_exception
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1967, in _exec_single_context
self.dialect.do_execute(
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 924, in do_execute
cursor.execute(statement, parameters)
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/mysql/connector/cursor.py", line 572, in execute
self._handle_result(self._connection.cmd_query(stmt))
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/mysql/connector/cursor.py", line 480, in _handle_result
self._handle_resultset()
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/mysql/connector/cursor.py", line 987, in _handle_resultset
(self._rows, eof) = self._connection.get_rows()
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/mysql/connector/connection.py", line 793, in get_rows
raise err
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/mysql/connector/connection.py", line 788, in get_rows
rows = self._protocol.read_text_result(self._socket,
File "/nobackup/lvalls1/valls/Software/miniconda3/envs/tomodemo-daiquiri-env/lib/python3.9/site-packages/mysql/connector/protocol.py", line 395, in read_text_result
raise get_exception(packet)
sqlalchemy.exc.DataError: (mysql.connector.errors.DataError) 1292 (22007): Incorrect datetime value: '2024-08-16T15:33:38.215823+02:00' for column `test`.`DataCollection`.`startTime` at row 1
[SQL: INSERT INTO `DataCollection` (`BLSAMPLEID`, experimenttype, `dataCollectionNumber`, `startTime`, `endTime`, `runStatus`, `axisStart`, `axisEnd`, `axisRange`, `numberOfImages`, `numberOfPasses`, `exposureTime`, `imageDirectory`, `imagePrefix`, `imageSuffix`, `imageContainerSubPath`, `fileTemplate`, wavelength, resolution, `detectorDistance`, `xBeam`, `yBeam`, comments, transmission, `xtalSnapshotFullPath1`, `xtalSnapshotFullPath2`, `xtalSnapshotFullPath3`, `xtalSnapshotFullPath4`, `rotationAxis`, `beamSizeAtSampleX`, `beamSizeAtSampleY`, `dataCollectionGroupId`, `detectorId`, flux, `blSubSampleId`, `dataCollectionPlanId`) VALUES (%(blsampleid)s, %(experimenttype)s, %(datacollectionnumber)s, %(starttime)s, %(endtime)s, %(runstatus)s, %(axisstart)s, %(axisend)s, %(axisrange)s, %(numberofimages)s, %(numberofpasses)s, %(exposuretime)s, %(imagedirectory)s, %(imageprefix)s, %(imagesuffix)s, %(imagecontainersubpath)s, %(filetemplate)s, %(wavelength)s, %(resolution)s, %(detectordistance)s, %(xbeam)s, %(ybeam)s, %(comments)s, %(transmission)s, %(xtalsnapshotfullpath1)s, %(xtalsnapshotfullpath2)s, %(xtalsnapshotfullpath3)s, %(xtalsnapshotfullpath4)s, %(rotationaxis)s, %(beamsizeatsamplex)s, %(beamsizeatsampley)s, %(datacollectiongroupid)s, %(detectorid)s, %(flux)s, %(blsubsampleid)s, %(datacollectionplanid)s) RETURNING `DataCollection`.`dataCollectionId`, `DataCollection`.`SESSIONID`]
[parameters: {'blsampleid': 1, 'experimenttype': None, 'datacollectionnumber': 3860824344, 'starttime': '2024-08-16T15:33:38.215823+02:00', 'endtime': None, 'runstatus': None, 'axisstart': None, 'axisend': None, 'axisrange': None, 'numberofimages': None, 'numberofpasses': None, 'exposuretime': None, 'imagedirectory': '/tmp/scans/visitor/blc00001/id00/20240801/RAW_DATA/sample1/sample1_foo15_0003_002', 'imageprefix': None, 'imagesuffix': None, 'imagecontainersubpath': None, 'filetemplate': 'sample1_foo15_0003_002.h5', 'wavelength': None, 'resolution': None, 'detectordistance': None, 'xbeam': None, 'ybeam': None, 'comments': None, 'transmission': None, 'xtalsnapshotfullpath1': None, 'xtalsnapshotfullpath2': None, 'xtalsnapshotfullpath3': None, 'xtalsnapshotfullpath4': None, 'rotationaxis': None, 'beamsizeatsamplex': None, 'beamsizeatsampley': None, 'datacollectiongroupid': 7, 'detectorid': None, 'flux': None, 'blsubsampleid': None, 'datacollectionplanid': None}]
(Background on this error at: https://sqlalche.me/e/20/9h9h)
Edited by Valentin Valls