- Qlustar General - Qlustar Mailing Lists

[Qlustar-General] Missing swap after qlustar installation
by rolnas＠gmail.com 03 May '19

03 May '19

Hi, I just installed from qlustar-installer-10.1.1-2.iso and installed head node is missing swap. By looking into FaiConfig.py inside of installer it doesn't define swap for FAI to create. swapSize is defined and calculated, but not used anywhere. Best regards, Rolandas

3 2

[Qlustar-General] node-configuration
by Tobias Moehle 02 May '19

02 May '19

Dear all, I'd like to report some trouble I had with the node configuration (qlustar v. 10.1.1-2): I tried to add some nfs-mount as described here: https://docs.qlustar.com/en-US/Qlustar_Cluster_OS/10.1/html-single/Administ… However, the script was not executed. It took me quite a while to figure out that these scripts are run with 'run-parts' (see /lib/qlustar/nfs-rc for those who are interested) and this does not accepct stripts with '.sh' (see e.g. the first answer here: https://superuser.com/questions/719424/how-do-you-use-the-run-parts-command for some explanation). Probably it would be great to either use the '--regex'-option to circumvent this behaviour or at least to tell users about it? Moreover, I wondered if there is way to adjust the scripts in '/lib/qlustar/'? Unfortunately, I didn't find their place on the headnode. Best regards, Tobias Moehle

2 1

[Qlustar-General] Renaming slurm gres gpu type
by Bryan Hill 24 Apr '19

24 Apr '19

Hi All: Is there a preferred way to change the name of a GPU gres type in Qluman? For example, we have to use --gres=gpu:geforce-rtx-2080-ti:2 to request that specific model of GPU. I would like to simplify that to something like: --gres=gpu:2080ti:2 When I attempt to change the names from what the GPU Wizard had originally set up, it makes things go badly, in that the the gres resource is no longer recognized. Is there a clean way to do this? Thanks, Bryan

3 11

[Qlustar-General] QluMan containerization
by Hernán Morales Durand 01 Apr '19

01 Apr '19

Hello, I have a node where I've installed QluMan 10.1.1 so I can configure the Cluster using the GUI. Now this node is NOT added to the cluster (i.e. not currently booting any OS image) so it's somewhat "wasted". As far as I understood the OS images are executed in the nodes in RAM memory. So theoretically I could boot this node with an OS image and later mount the fs to try qluman-10.1.1.19-singularity.sqsh however I don't see how that could work because of lib compatibility. Is that correct/feasible? And I wonder if there is a container image already built specifically to run the qluman.sqsh application. I couldn't find none so far and I wanted to ask before starting to explore this path. What do you recommend? Cheers, Hernán

2 1

[Qlustar-General] HP Proliant DL360 G5 issues
by bscook999＠gmail.com 21 Mar '19

21 Mar '19

Hello. I'm having a lot of trouble getting the Qlustar 10.0 installer to recognize the the hard drives. During the installation process an error message comes up that there are no available hard drives and the FAI stops. HP Proliant DL360 G5 Smart Array P400i is working. I did a standard Ubuntu 18.04.2 Server LTS installation and the hard drives were recognized just fine. I'm not sure how to get the Qlustar to recognize it. Is it possible to install Qlustar from within ubuntu? I would prefer the automated installation process if possible to avoid errors, but if I can't get it to work. Please advise, thanks.

4 15

[Qlustar-General] Nodes won't boot
by Ansgar Esztermann-Kirchner 15 Mar '19

15 Mar '19

Hello List, recently, I've moved /apps to its own device. This invalidates NFS handles on the nodes, of course, so I started to reboot them. To my surprise, they don't come up again. The nodes complain about a time-out, "Failed to request QluMan node config in time", and ask me to check qlumand and qluman-route on the head. These two processes are indeed running. I've checked the logs, but couldn't fine anything helpful (to me) in there. qlumand seems to see the node briefly: 2019-03-05 11:45:06,615 [29219] INFO server.admin - Identifying node from '00-25-90-d9-08-86' 2019-03-05 11:45:06,617 [29219] INFO server.admin - Registering Execd 'node31-35' 2019-03-05 11:45:39,645 [29219] INFO server.admin - Execd '00-25-90-d9-08-86' disconnected I've attached the router log. There's one thing that's conspicuous, but it doesn't seem to be correlated with the nodes booting: a stack trace when accessing the database. I'll be grateful for any pointers. Thanks, A. -- Ansgar Esztermann Sysadmin Dep. Theoretical and Computational Biophysics http://www.mpibpc.mpg.de/grubmueller/esztermann

3 5

[Qlustar-General] NVidia driver
by Bryan Hill 13 Mar '19

13 Mar '19

Hello All! Is there a way to get a newer nvidia driver working with the current Qlustar 10.1.1? The nvidia module in the Qlustar repo is 390, and we just received some nodes with RTX2080 Ti cards, which require >= 410 I've tried installing inside of a chroot, but it doesn't want to work. Thanks, Bryan

3 9

[Qlustar-General] IPMI Power
by Ansgar Esztermann-Kirchner 01 Mar '19

01 Mar '19

Hello List, what is the preferred way to power control nodes? IPMI setup is done by qluman, but there does not seem to be a way to control nodes from the GUI. I've found ql-remote-control, but it complains about a missing config file, and I did not find an example file to explain its syntax. Thanks, A. -- Ansgar Esztermann Sysadmin http://www.mpibpc.mpg.de/grubmueller/esztermann

2 5

[Qlustar-General] Qlustar installation on HP Gen6 servers
by jorma.ojala＠iki.fi 15 Feb '19

15 Feb '19

Hi, Qlustar 10.1 installation failed on HP DL320 G6 server. The server has got 4 x 1TB disks, but the installer reported 'no unused disks'. I recall that the server has got the P410 RAID-controller on-board. I tried with different RAID configurations but with no luck. Maybe this is 'too old' hardware for Qlustar ? Cheers, Jorma

3 16

[Qlustar-General] Failed to run qluman-cli -bootstrap during second phase installation
by clavila＠gmail.com 25 Jan '19

25 Jan '19

Dear all, I am trying to install the latest version of Qlustar (10.1) in a server. During the first phase everything runs smoothly. During this stage I opted to run the front end on a VM. I have also setup manual network configurations for both cl-head and cl-fe. When I start the second phase after reboot by running qlustar-initial-config I get an error during qluman setup. To try to isolate the error, i ran the qlustar-initial-config -i -d (interactive and debug flags enabled). The output that I get is attached below. Any ideas on how to fix this? Cheers, Cesar run "qluman-cli --bootstrap" [n] Yes -- Starting Qluman bootstrap ... Base MAC for VMs: 02:00:99:99:99:00 -- Registering VM for frontend node ... Assigning MAC 02:00:99:99:99:fd to internal FrontEnd Node interface. Assigning MAC 02:01:99:99:9c:52 to external FrontEnd Node interface. -- Registering VMs for demo cluster ... Adding VM node beo-201: IP = 192.168.52.201, MAC = 02:00:99:99:99:c9 ###### Create some Enclosures ###### Create all Host/EnclosureSlots ###### Create some SpecPropNames ###### Create some spec Host Props ###### Create some GenPropNames ###### Create some GenProps ###### Create some GenPropSetNames ###### Create some GenPropSets ###### Create some HwPropNames ###### Create some HwProps Traceback (most recent call last): File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context context) File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute cursor.execute(statement, parameters) File "/usr/lib/python3/dist-packages/mysql/connector/cursor.py", line 507, in execute self._handle_result(self._connection.cmd_query(stmt)) File "/usr/lib/python3/dist-packages/mysql/connector/connection.py", line 722, in cmd_query result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query)) File "/usr/lib/python3/dist-packages/mysql/connector/connection.py", line 640, in _handle_result raise errors.get_exception(packet) mysql.connector.errors.IntegrityError: 1062 (23000): Duplicate entry '5-2' for key 'name_id' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/usr/lib/python3/dist-packages/qluman-10/server/db/DBData.py", line 92, in insert self.sess.commit() File "/usr/lib/python3/dist-packages/sqlalchemy/orm/session.py", line 813, in commit self.transaction.commit() File "/usr/lib/python3/dist-packages/sqlalchemy/orm/session.py", line 392, in commit self._prepare_impl() File "/usr/lib/python3/dist-packages/sqlalchemy/orm/session.py", line 372, in _prepare_impl self.session.flush() File "/usr/lib/python3/dist-packages/sqlalchemy/orm/session.py", line 2027, in flush self._flush(objects) File "/usr/lib/python3/dist-packages/sqlalchemy/orm/session.py", line 2145, in _flush transaction.rollback(_capture_exception=True) File "/usr/lib/python3/dist-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__ compat.reraise(exc_type, exc_value, exc_tb) File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 183, in reraise raise value File "/usr/lib/python3/dist-packages/sqlalchemy/orm/session.py", line 2109, in _flush flush_context.execute() File "/usr/lib/python3/dist-packages/sqlalchemy/orm/unitofwork.py", line 373, in execute rec.execute(self) File "/usr/lib/python3/dist-packages/sqlalchemy/orm/unitofwork.py", line 532, in execute uow File "/usr/lib/python3/dist-packages/sqlalchemy/orm/persistence.py", line 174, in save_obj mapper, table, insert) File "/usr/lib/python3/dist-packages/sqlalchemy/orm/persistence.py", line 800, in _emit_insert_statements execute(statement, params) File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 914, in execute return meth(self, multiparams, params) File "/usr/lib/python3/dist-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement compiled_sql, distilled_params File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context context) File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception exc_info File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 189, in raise_from_cause reraise(type(exception), exception, tb=exc_tb, cause=exc_value) File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 182, in reraise raise value.with_traceback(tb) File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context context) File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute cursor.execute(statement, parameters) File "/usr/lib/python3/dist-packages/mysql/connector/cursor.py", line 507, in execute self._handle_result(self._connection.cmd_query(stmt)) File "/usr/lib/python3/dist-packages/mysql/connector/connection.py", line 722, in cmd_query result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query)) File "/usr/lib/python3/dist-packages/mysql/connector/connection.py", line 640, in _handle_result raise errors.get_exception(packet) sqlalchemy.exc.IntegrityError: (mysql.connector.errors.IntegrityError) 1062 (23000): Duplicate entry '5-2' for key 'name_id' [SQL: 'INSERT INTO `HwProps` (val, mutable, name_id) VALUES (%(val)s, %(mutable)s, %(name_id)s)'] [parameters: {'val': '2', 'mutable': 1, 'name_id': 5}] During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context context) File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute cursor.execute(statement, parameters) File "/usr/lib/python3/dist-packages/mysql/connector/cursor.py", line 507, in execute self._handle_result(self._connection.cmd_query(stmt)) File "/usr/lib/python3/dist-packages/mysql/connector/connection.py", line 722, in cmd_query result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query)) File "/usr/lib/python3/dist-packages/mysql/connector/connection.py", line 640, in _handle_result raise errors.get_exception(packet) mysql.connector.errors.IntegrityError: 1062 (23000): Duplicate entry '5-2' for key 'name_id' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/usr/lib/python3/dist-packages/qluman-10/server/db/DBData.py", line 92, in insert self.sess.commit() File "/usr/lib/python3/dist-packages/sqlalchemy/orm/session.py", line 813, in commit self.transaction.commit() File "/usr/lib/python3/dist-packages/sqlalchemy/orm/session.py", line 392, in commit self._prepare_impl() File "/usr/lib/python3/dist-packages/sqlalchemy/orm/session.py", line 372, in _prepare_impl self.session.flush() File "/usr/lib/python3/dist-packages/sqlalchemy/orm/session.py", line 2027, in flush self._flush(objects) File "/usr/lib/python3/dist-packages/sqlalchemy/orm/session.py", line 2145, in _flush transaction.rollback(_capture_exception=True) File "/usr/lib/python3/dist-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__ compat.reraise(exc_type, exc_value, exc_tb) File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 183, in reraise raise value File "/usr/lib/python3/dist-packages/sqlalchemy/orm/session.py", line 2109, in _flush flush_context.execute() File "/usr/lib/python3/dist-packages/sqlalchemy/orm/unitofwork.py", line 373, in execute rec.execute(self) File "/usr/lib/python3/dist-packages/sqlalchemy/orm/unitofwork.py", line 532, in execute uow File "/usr/lib/python3/dist-packages/sqlalchemy/orm/persistence.py", line 174, in save_obj mapper, table, insert) File "/usr/lib/python3/dist-packages/sqlalchemy/orm/persistence.py", line 800, in _emit_insert_statements execute(statement, params) File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 914, in execute return meth(self, multiparams, params) File "/usr/lib/python3/dist-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement compiled_sql, distilled_params File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context context) File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception exc_info File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 189, in raise_from_cause reraise(type(exception), exception, tb=exc_tb, cause=exc_value) File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 182, in reraise raise value.with_traceback(tb) File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context context) File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute cursor.execute(statement, parameters) File "/usr/lib/python3/dist-packages/mysql/connector/cursor.py", line 507, in execute self._handle_result(self._connection.cmd_query(stmt)) File "/usr/lib/python3/dist-packages/mysql/connector/connection.py", line 722, in cmd_query result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query)) File "/usr/lib/python3/dist-packages/mysql/connector/connection.py", line 640, in _handle_result raise errors.get_exception(packet) sqlalchemy.exc.IntegrityError: (mysql.connector.errors.IntegrityError) 1062 (23000): Duplicate entry '5-2' for key 'name_id' [SQL: 'INSERT INTO `HwProps` (val, mutable, name_id) VALUES (%(val)s, %(mutable)s, %(name_id)s)'] [parameters: {'val': '2', 'mutable': 1, 'name_id': 5}] During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context context) File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute cursor.execute(statement, parameters) File "/usr/lib/python3/dist-packages/mysql/connector/cursor.py", line 507, in execute self._handle_result(self._connection.cmd_query(stmt)) File "/usr/lib/python3/dist-packages/mysql/connector/connection.py", line 722, in cmd_query result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query)) File "/usr/lib/python3/dist-packages/mysql/connector/connection.py", line 640, in _handle_result raise errors.get_exception(packet) mysql.connector.errors.IntegrityError: 1062 (23000): Duplicate entry '5-2' for key 'name_id' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/usr/lib/python3/dist-packages/qluman-10/server/db/DBData.py", line 92, in insert self.sess.commit() File "/usr/lib/python3/dist-packages/sqlalchemy/orm/session.py", line 813, in commit self.transaction.commit() File "/usr/lib/python3/dist-packages/sqlalchemy/orm/session.py", line 392, in commit self._prepare_impl() File "/usr/lib/python3/dist-packages/sqlalchemy/orm/session.py", line 372, in _prepare_impl self.session.flush() File "/usr/lib/python3/dist-packages/sqlalchemy/orm/session.py", line 2027, in flush self._flush(objects) File "/usr/lib/python3/dist-packages/sqlalchemy/orm/session.py", line 2145, in _flush transaction.rollback(_capture_exception=True) File "/usr/lib/python3/dist-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__ compat.reraise(exc_type, exc_value, exc_tb) File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 183, in reraise raise value File "/usr/lib/python3/dist-packages/sqlalchemy/orm/session.py", line 2109, in _flush flush_context.execute() File "/usr/lib/python3/dist-packages/sqlalchemy/orm/unitofwork.py", line 373, in execute rec.execute(self) File "/usr/lib/python3/dist-packages/sqlalchemy/orm/unitofwork.py", line 532, in execute uow File "/usr/lib/python3/dist-packages/sqlalchemy/orm/persistence.py", line 174, in save_obj mapper, table, insert) File "/usr/lib/python3/dist-packages/sqlalchemy/orm/persistence.py", line 800, in _emit_insert_statements execute(statement, params) File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 914, in execute return meth(self, multiparams, params) File "/usr/lib/python3/dist-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement compiled_sql, distilled_params File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context context) File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception exc_info File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 189, in raise_from_cause reraise(type(exception), exception, tb=exc_tb, cause=exc_value) File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 182, in reraise raise value.with_traceback(tb) File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context context) File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute cursor.execute(statement, parameters) File "/usr/lib/python3/dist-packages/mysql/connector/cursor.py", line 507, in execute self._handle_result(self._connection.cmd_query(stmt)) File "/usr/lib/python3/dist-packages/mysql/connector/connection.py", line 722, in cmd_query result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query)) File "/usr/lib/python3/dist-packages/mysql/connector/connection.py", line 640, in _handle_result raise errors.get_exception(packet) sqlalchemy.exc.IntegrityError: (mysql.connector.errors.IntegrityError) 1062 (23000): Duplicate entry '5-2' for key 'name_id' [SQL: 'INSERT INTO `HwProps` (val, mutable, name_id) VALUES (%(val)s, %(mutable)s, %(name_id)s)'] [parameters: {'val': '2', 'mutable': 1, 'name_id': 5}] During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context context) File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute cursor.execute(statement, parameters) File "/usr/lib/python3/dist-packages/mysql/connector/cursor.py", line 507, in execute self._handle_result(self._connection.cmd_query(stmt)) File "/usr/lib/python3/dist-packages/mysql/connector/connection.py", line 722, in cmd_query result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query)) File "/usr/lib/python3/dist-packages/mysql/connector/connection.py", line 640, in _handle_result raise errors.get_exception(packet) mysql.connector.errors.IntegrityError: 1062 (23000): Duplicate entry '5-2' for key 'name_id' The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/usr/lib/python3/dist-packages/qluman-10/qluman-cli.py", line 1470, in <module> main() File "/usr/lib/python3/dist-packages/qluman-10/qluman-cli.py", line 1461, in main bootstrap(config, db_data, cfg_gen) File "/usr/lib/python3/dist-packages/qluman-10/qluman-cli.py", line 1154, in bootstrap create_hw_props(d, ini_vals) File "/usr/lib/python3/dist-packages/qluman-10/qluman-cli.py", line 222, in create_hw_props db_data.insert(CT.TABLES.HwProp, prop_list) File "/usr/lib/python3/dist-packages/qluman-10/common/types.py", line 1760, in insert return table.insert(entries) File "/usr/lib/python3/dist-packages/qluman-10/server/db/DBData.py", line 96, in insert return self.insert(orig_entries, count = count + 1) File "/usr/lib/python3/dist-packages/qluman-10/server/db/DBData.py", line 96, in insert return self.insert(orig_entries, count = count + 1) File "/usr/lib/python3/dist-packages/qluman-10/server/db/DBData.py", line 96, in insert return self.insert(orig_entries, count = count + 1) File "/usr/lib/python3/dist-packages/qluman-10/server/db/DBData.py", line 98, in insert raise exn File "/usr/lib/python3/dist-packages/qluman-10/server/db/DBData.py", line 92, in insert self.sess.commit() File "/usr/lib/python3/dist-packages/sqlalchemy/orm/session.py", line 813, in commit self.transaction.commit() File "/usr/lib/python3/dist-packages/sqlalchemy/orm/session.py", line 392, in commit self._prepare_impl() File "/usr/lib/python3/dist-packages/sqlalchemy/orm/session.py", line 372, in _prepare_impl self.session.flush() File "/usr/lib/python3/dist-packages/sqlalchemy/orm/session.py", line 2027, in flush self._flush(objects) File "/usr/lib/python3/dist-packages/sqlalchemy/orm/session.py", line 2145, in _flush transaction.rollback(_capture_exception=True) File "/usr/lib/python3/dist-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__ compat.reraise(exc_type, exc_value, exc_tb) File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 183, in reraise raise value File "/usr/lib/python3/dist-packages/sqlalchemy/orm/session.py", line 2109, in _flush flush_context.execute() File "/usr/lib/python3/dist-packages/sqlalchemy/orm/unitofwork.py", line 373, in execute rec.execute(self) File "/usr/lib/python3/dist-packages/sqlalchemy/orm/unitofwork.py", line 532, in execute uow File "/usr/lib/python3/dist-packages/sqlalchemy/orm/persistence.py", line 174, in save_obj mapper, table, insert) File "/usr/lib/python3/dist-packages/sqlalchemy/orm/persistence.py", line 800, in _emit_insert_statements execute(statement, params) File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 914, in execute return meth(self, multiparams, params) File "/usr/lib/python3/dist-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement compiled_sql, distilled_params File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context context) File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception exc_info File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 189, in raise_from_cause reraise(type(exception), exception, tb=exc_tb, cause=exc_value) File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 182, in reraise raise value.with_traceback(tb) File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context context) File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute cursor.execute(statement, parameters) File "/usr/lib/python3/dist-packages/mysql/connector/cursor.py", line 507, in execute self._handle_result(self._connection.cmd_query(stmt)) File "/usr/lib/python3/dist-packages/mysql/connector/connection.py", line 722, in cmd_query result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query)) File "/usr/lib/python3/dist-packages/mysql/connector/connection.py", line 640, in _handle_result raise errors.get_exception(packet) sqlalchemy.exc.IntegrityError: (mysql.connector.errors.IntegrityError) 1062 (23000): Duplicate entry '5-2' for key 'name_id' [SQL: 'INSERT INTO `HwProps` (val, mutable, name_id) VALUES (%(val)s, %(mutable)s, %(name_id)s)'] [parameters: {'val': '2', 'mutable': 1, 'name_id': 5}]

5 4

2024

2023

2022

2021

2020

2019

2018

Qlustar General