C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe, Version: 8.0.43 (MySQL Community Server - GPL). started with: TCP Port: 0, Named Pipe: MySQL Time Id Command Argument C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe, Version: 8.0.43 (MySQL Community Server - GPL). started with: TCP Port: 3306, Named Pipe: MySQL Time Id Command Argument # Time: 2025-09-07T17:19:06.699668Z # User@Host: root[root] @ localhost [127.0.0.1] Id: 7322 # Query_time: 12.580980 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 use kisheva; SET timestamp=1757265534; commit; # Time: 2025-09-07T17:29:51.495072Z # User@Host: root[root] @ localhost [127.0.0.1] Id: 7621 # Query_time: 14.215394 Lock_time: 0.000020 Rows_sent: 0 Rows_examined: 0 SET timestamp=1757266177; CREATE TABLE kisheva.calculation_registration (calculation_registration_id INT AUTO_INCREMENT NOT NULL, token VARCHAR(255) NOT NULL, provider_class_name VARCHAR(512) NOT NULL, calculation_name VARCHAR(512) NOT NULL, configuration TEXT NULL, uuid CHAR(38) NOT NULL, CONSTRAINT PK_CALCULATION_REGISTRATION PRIMARY KEY (calculation_registration_id), UNIQUE (token), UNIQUE (uuid)); # Time: 2025-09-07T17:35:18.367768Z # User@Host: root[root] @ localhost [127.0.0.1] Id: 7754 # Query_time: 18.117647 Lock_time: 0.000054 Rows_sent: 0 Rows_examined: 0 SET timestamp=1757266500; CREATE TABLE kisheva.idgen_identifier_source (id INT AUTO_INCREMENT NOT NULL, uuid CHAR(38) NOT NULL, name VARCHAR(255) NOT NULL, `description` VARCHAR(1000) NULL, identifier_type INT NOT NULL, creator INT NOT NULL, date_created datetime NOT NULL, changed_by INT NULL, date_changed datetime NULL, retired TINYINT(1) DEFAULT 0 NOT NULL, retired_by INT NULL, date_retired datetime NULL, retire_reason VARCHAR(255) NULL, CONSTRAINT PK_IDGEN_IDENTIFIER_SOURCE PRIMARY KEY (id), CONSTRAINT `creator for idgen_identifier_source` FOREIGN KEY (creator) REFERENCES kisheva.users(user_id), CONSTRAINT `identifier_type for idgen_identifier_source` FOREIGN KEY (identifier_type) REFERENCES kisheva.patient_identifier_type(patient_identifier_type_id), CONSTRAINT `changed_by for idgen_identifier_source` FOREIGN KEY (changed_by) REFERENCES kisheva.users(user_id), CONSTRAINT `retired_by for idgen_identifier_source` FOREIGN KEY (retired_by) REFERENCES kisheva.users(user_id), UNIQUE (id), UNIQUE (uuid)); # Time: 2025-09-07T18:33:45.619480Z # User@Host: root[root] @ localhost [127.0.0.1] Id: 9225 # Query_time: 10.362677 Lock_time: 0.000001 Rows_sent: 0 Rows_examined: 0 SET timestamp=1757270015; insert into openconceptlab_item (import_id, error_message, hashed_url, state, type, updated_on, url, uuid, version_url) values (3, 'Cannot save mapping /orgs/CIEL/sources/CIEL/mappings/3677/ [CAUSE]: Cannot create mapping from concept with URL /orgs/CIEL/sources/CIEL/concepts/1038/, because the concept has not been imported', x'a25eb9f8f8cdc8d77fd14eb17f8daf7f', 4, 'MAPPING', '2023-01-27 16:08:43', '/orgs/CIEL/sources/CIEL/mappings/3677/', '996CCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCC', '/orgs/CIEL/sources/CIEL/mappings/3677/'); # Time: 2025-09-07T18:33:45.620226Z # User@Host: root[root] @ localhost [127.0.0.1] Id: 9185 # Query_time: 11.689131 Lock_time: 0.000001 Rows_sent: 0 Rows_examined: 0 SET timestamp=1757270013; insert into openconceptlab_item (import_id, error_message, hashed_url, state, type, updated_on, url, uuid, version_url) values (3, 'Cannot save mapping /orgs/CIEL/sources/CIEL/mappings/8218737/ [CAUSE]: Cannot create mapping from concept with URL /orgs/CIEL/sources/CIEL/concepts/169214/, because the concept has not been imported', x'970285077ce599404dc32480f0caeb8b', 4, 'MAPPING', '2025-01-24 23:50:34', '/orgs/CIEL/sources/CIEL/mappings/8218737/', '7c81924a-b7fc-4495-a2b8-88616beab183', '/orgs/CIEL/sources/CIEL/mappings/8218737/'); # Time: 2025-09-07T18:33:51.242313Z # User@Host: root[root] @ localhost [127.0.0.1] Id: 9187 # Query_time: 15.986090 Lock_time: 0.000003 Rows_sent: 0 Rows_examined: 0 SET timestamp=1757270015; insert into openconceptlab_item (import_id, error_message, hashed_url, state, type, updated_on, url, uuid, version_url) values (3, 'Cannot save mapping /orgs/CIEL/sources/CIEL/mappings/312015/ [CAUSE]: Cannot create mapping from concept with URL /orgs/CIEL/sources/CIEL/concepts/161474/, because the concept has not been imported', x'ca0ee4f3e3baea7e43142887ba1007b9', 4, 'MAPPING', '2025-05-12 07:32:04', '/orgs/CIEL/sources/CIEL/mappings/312015/', '1021AEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE', '/orgs/CIEL/sources/CIEL/mappings/312015/'); # Time: 2025-09-07T18:33:51.243714Z # User@Host: root[root] @ localhost [127.0.0.1] Id: 9226 # Query_time: 15.987060 Lock_time: 0.000001 Rows_sent: 0 Rows_examined: 0 SET timestamp=1757270015; insert into openconceptlab_item (import_id, error_message, hashed_url, state, type, updated_on, url, uuid, version_url) values (3, 'Cannot save mapping /orgs/CIEL/sources/CIEL/mappings/152/ [CAUSE]: Cannot create mapping from concept with URL /orgs/CIEL/sources/CIEL/concepts/45/, because the concept has not been imported', x'ab52a8e01386efb24e33ce2a7e8bab13', 4, 'MAPPING', '2023-01-27 16:00:30', '/orgs/CIEL/sources/CIEL/mappings/152/', '13CCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCC', '/orgs/CIEL/sources/CIEL/mappings/152/'); # Time: 2025-09-07T18:35:26.212424Z # User@Host: root[root] @ localhost [127.0.0.1] Id: 9208 # Query_time: 12.195286 Lock_time: 0.000001 Rows_sent: 0 Rows_examined: 0 SET timestamp=1757270114; insert into concept (uuid, retired, date_created, version, date_changed, is_set, retire_reason, date_retired, retired_by, datatype_id, class_id, changed_by, creator) values ('137504AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA', 0, '2025-09-07 21:35:14', null, '2025-09-07 21:35:14', 0, null, null, null, 4, 4, 2, 2); # Time: 2025-09-07T19:23:23.331501Z # User@Host: root[root] @ localhost [127.0.0.1] Id: 10501 # Query_time: 12.485585 Lock_time: 0.000002 Rows_sent: 0 Rows_examined: 0 SET timestamp=1757272990; insert into concept_reference_term (uuid, concept_source_id, code, name, version, description, creator, date_created, changed_by, date_changed, retired, retired_by, date_retired, retire_reason) values ('a40e4eb3-95d2-4cd0-8519-407fb501427e', 13, '360336', null, null, null, 2, '2025-09-07 22:23:10', null, null, 0, null, null, null); # Time: 2025-09-07T19:42:57.888387Z # User@Host: root[root] @ localhost [127.0.0.1] Id: 10904 # Query_time: 11.297912 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 SET timestamp=1757274166; commit; # Time: 2025-09-07T19:42:57.888408Z # User@Host: root[root] @ localhost [127.0.0.1] Id: 10903 # Query_time: 11.093609 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 SET timestamp=1757274166; commit; # Time: 2025-09-07T20:50:57.837845Z # User@Host: root[root] @ localhost [127.0.0.1] Id: 12589 # Query_time: 12.024036 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 SET timestamp=1757278245; commit; # Time: 2025-09-07T21:10:25.689052Z # User@Host: root[root] @ localhost [127.0.0.1] Id: 12590 # Query_time: 11.731846 Lock_time: 0.000003 Rows_sent: 0 Rows_examined: 0 SET timestamp=1757279413; insert into obs (uuid, obs_datetime, value_group_id, value_datetime, value_numeric, value_modifier, value_text, value_complex, comments, accession_number, date_created, voided, date_voided, void_reason, form_namespace_and_path, status, interpretation, person_id, concept_id, value_coded, value_coded_name_id, value_drug, order_id, location_id, encounter_id, creator, voided_by, obs_group_id, previous_version) values ('c23ecab6-475a-46ed-898c-621f666d1e9e', '2023-08-01 07:29:48', null, null, 171.0, null, null, null, null, null, '2025-09-08 00:10:13', 0, null, null, null, 'FINAL', null, 16, 2021, null, null, null, null, 5, 241, 2, null, null, null); # Time: 2025-09-08T08:33:24.645038Z # User@Host: root[root] @ localhost [::1] Id: 28986 # Query_time: 69.690411 Lock_time: 0.013993 Rows_sent: 0 Rows_examined: 0 SET timestamp=1757320334; DROP DATABASE `kisheva`; # Time: 2025-09-09T09:18:48.563801Z # User@Host: root[root] @ localhost [127.0.0.1] Id: 36002 # Query_time: 22.350226 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 SET timestamp=1757409506; commit; # Time: 2025-09-09T09:18:48.755401Z # User@Host: root[root] @ localhost [127.0.0.1] Id: 35931 # Query_time: 22.280808 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 SET timestamp=1757409506; commit; # Time: 2025-09-09T09:18:48.755621Z # User@Host: root[root] @ localhost [127.0.0.1] Id: 36000 # Query_time: 22.275903 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 SET timestamp=1757409506; commit; # Time: 2025-09-09T09:18:48.755740Z # User@Host: root[root] @ localhost [127.0.0.1] Id: 35973 # Query_time: 22.268577 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 SET timestamp=1757409506; commit; # Time: 2025-09-09T09:18:48.756039Z # User@Host: root[root] @ localhost [127.0.0.1] Id: 35886 # Query_time: 22.266515 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 SET timestamp=1757409506; commit; # Time: 2025-09-09T13:00:33.408191Z # User@Host: root[root] @ localhost [127.0.0.1] Id: 37145 # Query_time: 15.867779 Lock_time: 0.000002 Rows_sent: 1 Rows_examined: 226978 SET timestamp=1757422817; select count(*) as y0_ from openconceptlab_item this_ where this_.import_id=21 and this_.state in (4); # Time: 2025-09-09T13:00:46.311347Z # User@Host: root[root] @ localhost [127.0.0.1] Id: 37115 # Query_time: 12.901663 Lock_time: 0.000002 Rows_sent: 1 Rows_examined: 227106 SET timestamp=1757422833; select count(*) as y0_ from openconceptlab_item this_ where this_.import_id=21 and this_.state in (5); # Time: 2025-09-09T13:01:53.797971Z # User@Host: root[root] @ localhost [127.0.0.1] Id: 37129 # Query_time: 12.925626 Lock_time: 0.000002 Rows_sent: 227106 Rows_examined: 681318 SET timestamp=1757422900; select this_.item_id as item_id1_108_1_, this_.import_id as import_10_108_1_, this_.error_message as error_me2_108_1_, this_.hashed_url as hashed_u3_108_1_, this_.state as state4_108_1_, this_.type as type5_108_1_, this_.updated_on as updated_6_108_1_, this_.url as url7_108_1_, this_.uuid as uuid8_108_1_, this_.version_url as version_9_108_1_, import2_.import_id as import_i1_107_0_, import2_.error_message as error_me2_107_0_, import2_.local_date_started as local_da3_107_0_, import2_.local_date_stopped as local_da4_107_0_, import2_.ocl_date_started as ocl_date5_107_0_, import2_.release_version as release_6_107_0_, import2_.subscription_url as subscrip7_107_0_, import2_.uuid as uuid8_107_0_ from openconceptlab_item this_ left outer join openconceptlab_import import2_ on this_.import_id=import2_.import_id where this_.import_id=21 order by this_.state desc limit 227106; # Time: 2025-09-09T13:04:23.186744Z # User@Host: root[root] @ localhost [127.0.0.1] Id: 37129 # Query_time: 75.653300 Lock_time: 0.000003 Rows_sent: 143938 Rows_examined: 514982 SET timestamp=1757422987; select this_.item_id as item_id1_108_1_, this_.import_id as import_10_108_1_, this_.error_message as error_me2_108_1_, this_.hashed_url as hashed_u3_108_1_, this_.state as state4_108_1_, this_.type as type5_108_1_, this_.updated_on as updated_6_108_1_, this_.url as url7_108_1_, this_.uuid as uuid8_108_1_, this_.version_url as version_9_108_1_, import2_.import_id as import_i1_107_0_, import2_.error_message as error_me2_107_0_, import2_.local_date_started as local_da3_107_0_, import2_.local_date_stopped as local_da4_107_0_, import2_.ocl_date_started as ocl_date5_107_0_, import2_.release_version as release_6_107_0_, import2_.subscription_url as subscrip7_107_0_, import2_.uuid as uuid8_107_0_ from openconceptlab_item this_ left outer join openconceptlab_import import2_ on this_.import_id=import2_.import_id where this_.import_id=21 order by this_.state desc limit 227106; # Time: 2025-09-09T13:04:24.277915Z # User@Host: root[root] @ localhost [127.0.0.1] Id: 37067 # Query_time: 76.727934 Lock_time: 0.000003 Rows_sent: 91512 Rows_examined: 410130 SET timestamp=1757422987; select this_.item_id as item_id1_108_1_, this_.import_id as import_10_108_1_, this_.error_message as error_me2_108_1_, this_.hashed_url as hashed_u3_108_1_, this_.state as state4_108_1_, this_.type as type5_108_1_, this_.updated_on as updated_6_108_1_, this_.url as url7_108_1_, this_.uuid as uuid8_108_1_, this_.version_url as version_9_108_1_, import2_.import_id as import_i1_107_0_, import2_.error_message as error_me2_107_0_, import2_.local_date_started as local_da3_107_0_, import2_.local_date_stopped as local_da4_107_0_, import2_.ocl_date_started as ocl_date5_107_0_, import2_.release_version as release_6_107_0_, import2_.subscription_url as subscrip7_107_0_, import2_.uuid as uuid8_107_0_ from openconceptlab_item this_ left outer join openconceptlab_import import2_ on this_.import_id=import2_.import_id where this_.import_id=21 order by this_.state desc limit 227106; # Time: 2025-09-09T13:06:45.135096Z # User@Host: root[root] @ localhost [127.0.0.1] Id: 37189 # Query_time: 31.810582 Lock_time: 0.000003 Rows_sent: 227106 Rows_examined: 681318 SET timestamp=1757423173; select this_.item_id as item_id1_108_1_, this_.import_id as import_10_108_1_, this_.error_message as error_me2_108_1_, this_.hashed_url as hashed_u3_108_1_, this_.state as state4_108_1_, this_.type as type5_108_1_, this_.updated_on as updated_6_108_1_, this_.url as url7_108_1_, this_.uuid as uuid8_108_1_, this_.version_url as version_9_108_1_, import2_.import_id as import_i1_107_0_, import2_.error_message as error_me2_107_0_, import2_.local_date_started as local_da3_107_0_, import2_.local_date_stopped as local_da4_107_0_, import2_.ocl_date_started as ocl_date5_107_0_, import2_.release_version as release_6_107_0_, import2_.subscription_url as subscrip7_107_0_, import2_.uuid as uuid8_107_0_ from openconceptlab_item this_ left outer join openconceptlab_import import2_ on this_.import_id=import2_.import_id where this_.import_id=21 order by this_.state desc limit 227106; # Time: 2025-09-09T13:06:49.257399Z # User@Host: root[root] @ localhost [127.0.0.1] Id: 37190 # Query_time: 35.895871 Lock_time: 0.000002 Rows_sent: 227106 Rows_examined: 681318 SET timestamp=1757423173; select this_.item_id as item_id1_108_1_, this_.import_id as import_10_108_1_, this_.error_message as error_me2_108_1_, this_.hashed_url as hashed_u3_108_1_, this_.state as state4_108_1_, this_.type as type5_108_1_, this_.updated_on as updated_6_108_1_, this_.url as url7_108_1_, this_.uuid as uuid8_108_1_, this_.version_url as version_9_108_1_, import2_.import_id as import_i1_107_0_, import2_.error_message as error_me2_107_0_, import2_.local_date_started as local_da3_107_0_, import2_.local_date_stopped as local_da4_107_0_, import2_.ocl_date_started as ocl_date5_107_0_, import2_.release_version as release_6_107_0_, import2_.subscription_url as subscrip7_107_0_, import2_.uuid as uuid8_107_0_ from openconceptlab_item this_ left outer join openconceptlab_import import2_ on this_.import_id=import2_.import_id where this_.import_id=21 order by this_.state desc limit 227106; # Time: 2025-09-09T13:16:23.889373Z # User@Host: root[root] @ localhost [127.0.0.1] Id: 37073 # Query_time: 23.330012 Lock_time: 0.000003 Rows_sent: 227106 Rows_examined: 681318 SET timestamp=1757423760; select this_.item_id as item_id1_108_1_, this_.import_id as import_10_108_1_, this_.error_message as error_me2_108_1_, this_.hashed_url as hashed_u3_108_1_, this_.state as state4_108_1_, this_.type as type5_108_1_, this_.updated_on as updated_6_108_1_, this_.url as url7_108_1_, this_.uuid as uuid8_108_1_, this_.version_url as version_9_108_1_, import2_.import_id as import_i1_107_0_, import2_.error_message as error_me2_107_0_, import2_.local_date_started as local_da3_107_0_, import2_.local_date_stopped as local_da4_107_0_, import2_.ocl_date_started as ocl_date5_107_0_, import2_.release_version as release_6_107_0_, import2_.subscription_url as subscrip7_107_0_, import2_.uuid as uuid8_107_0_ from openconceptlab_item this_ left outer join openconceptlab_import import2_ on this_.import_id=import2_.import_id where this_.import_id=21 order by this_.state desc limit 227106; C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe, Version: 8.0.43 (MySQL Community Server - GPL). started with: TCP Port: 3306, Named Pipe: MySQL Time Id Command Argument C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe, Version: 8.0.43 (MySQL Community Server - GPL). started with: TCP Port: 3306, Named Pipe: MySQL Time Id Command Argument C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe, Version: 8.0.43 (MySQL Community Server - GPL). started with: TCP Port: 3306, Named Pipe: MySQL Time Id Command Argument C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe, Version: 8.0.43 (MySQL Community Server - GPL). started with: TCP Port: 3306, Named Pipe: MySQL Time Id Command Argument C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe, Version: 8.0.43 (MySQL Community Server - GPL). started with: TCP Port: 3306, Named Pipe: MySQL Time Id Command Argument C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe, Version: 8.0.43 (MySQL Community Server - GPL). started with: TCP Port: 3306, Named Pipe: MySQL Time Id Command Argument C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe, Version: 8.0.43 (MySQL Community Server - GPL). started with: TCP Port: 3306, Named Pipe: MySQL Time Id Command Argument C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe, Version: 8.0.43 (MySQL Community Server - GPL). started with: TCP Port: 3306, Named Pipe: MySQL Time Id Command Argument C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe, Version: 8.0.43 (MySQL Community Server - GPL). started with: TCP Port: 3306, Named Pipe: MySQL Time Id Command Argument C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe, Version: 8.0.43 (MySQL Community Server - GPL). started with: TCP Port: 3306, Named Pipe: MySQL Time Id Command Argument C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe, Version: 8.0.43 (MySQL Community Server - GPL). started with: TCP Port: 3306, Named Pipe: MySQL Time Id Command Argument C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe, Version: 8.0.43 (MySQL Community Server - GPL). started with: TCP Port: 3306, Named Pipe: MySQL Time Id Command Argument C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe, Version: 8.0.43 (MySQL Community Server - GPL). started with: TCP Port: 3306, Named Pipe: MySQL Time Id Command Argument C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe, Version: 8.0.43 (MySQL Community Server - GPL). started with: TCP Port: 3306, Named Pipe: MySQL Time Id Command Argument C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe, Version: 8.0.43 (MySQL Community Server - GPL). started with: TCP Port: 3306, Named Pipe: MySQL Time Id Command Argument