API tools faq
paste
Advertisement
NMamaev

Untitled

NMamaev
Jul 31st, 2023
72
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 28.81 KB | None | 0 0
raw download clone embed print report
  1. 2023-07-31 10:29:46.936 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26] request method: POST url: /host version: HTTP/1.0
  2. 2023-07-31 10:29:46.936 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26] Handler 'host' choosen
  3. 2023-07-31 10:29:46.936 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26] Got header: [connection]close
  4. 2023-07-31 10:29:46.936 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26] Got header: [content-length]313
  5. 2023-07-31 10:29:46.936 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26] Got header: [host]instance-1
  6. 2023-07-31 10:29:46.936 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26] Got header: [instance-id]1
  7. 2023-07-31 10:29:46.936 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26] Got header: [internal-auth]eyJlbWFpbF9jb25maXJtZWQiOnRydWUsImV4cGlyZXNfYXQiOiIiLCJpbnN0YW5jZV9vd25lciI6ZmFsc2UsImxhbmciOiJydSIsImxhc3Rfbm90aWZ5IjoyNzM3LCJvd25lcl9lbWFpbCI6Im4ubWFtYWV2QGlzcHN5c3RlbS5jb20iLCJvd25lcl9pZCI6NSwicm9sZXMiOlsiQGFkbWluIl0sInNlc19pZCI6NzMsInNlc3Npb24iOiIxMDAwMDAyNi02ZjgzZThmOS1kODM5LTQ3MGQtOGM2Ni0xYmRmZTA1ZjQwM2MiLCJzdV9pbnN0YW5jZSI6ZmFsc2UsInRydXN0ZWVfZW1haWwiOiJuLm1hbWFldkBpc3BzeXN0ZW0uY29tIiwidHJ1c3RlZV9pZCI6NSwieHNyZl90b2tlbiI6IjEwMDAwMDI2LTZmODNlOGY5LWQ4MzktNDcwZC04YzY2LTFiZGZlMDVmNDAzYyJ9
  8. 2023-07-31 10:29:46.936 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26] Got header: [x-forwarded-for]172.18.0.26
  9. 2023-07-31 10:29:46.936 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26] Got header: [x-remote-ip]172.18.0.26
  10. 2023-07-31 10:29:46.936 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26] Got header: [x-request-id]a7ba4ba64d5f1bb0ecaf32e2822805a4
  11. 2023-07-31 10:29:46.936 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26] Got header: [x-xsrf-token]10000026-6f83e8f9-d839-470d-8c66-1bdfe05f403c
  12. 2023-07-31 10:29:46.936 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] RequestBody: {"account":5,"cluster":1,"custom_interfaces":[{"ip_count":1,"ippool":1,"mac":null}],"disks":[{"boot_order":1,"size_mib":10240,"tags":[]}],"domain":"red-purple-rogueite.example.com","ignore_recipe_filters":false,"name":"red-purple_rogueite","os":22,"password":"*","preset":7,"send_email_mode":"default"}
  13. 2023-07-31 10:29:46.936 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] End of POST request
  14. 2023-07-31 10:29:46.936 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] Invoke POST request callback
  15. 2023-07-31 10:29:46.940 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] db: id=0x77bdb0034260 query='SELECT "vm5_data","spice_enabled","node_os_family","vxlan_mode","node_network_gateway","node_network_timeout","ha_error","ha_cluster_id","ha_agent_version","ha_checking_host","ha_enabled","net_bandwidth_mbitps","dns_servers","host_per_node_limit","proxy_enabled","domain_change_allowed","manage_disk_enabled","iso_enabled","cpu_overselling","overselling","qemu_version","domain_template","image_storage_path","os_storage_path","interface_count","imported_from","host_filter","host_distribution_policy","datacenter_type","virtualization_type","time_zone","comment","name","id" FROM vm_cluster WHERE "id"='1'' duration=286
  16. 2023-07-31 10:29:46.940 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] db: id=0x77bdb0034260 query='SELECT "snapshot_ram","snapshot_limit","spice_additional_enabled","spice_enabled","firewall_rules","process_number","tcp_connections_out","tcp_connections_in","anti_spoofing_settings","anti_spoofing","io_write_iops","io_read_iops","io_write_mbitps","io_read_mbitps","io_weight","nesting","cpu_weight","cpu_custom_model","cpu_mode","net_weight","net_out_mbitps","net_in_mbitps","hdd_mib","ram_mib","cpu_number","comment","name","virtualization_type","id" FROM vm_preset WHERE "id"='7'' duration=136
  17. 2023-07-31 10:29:46.940 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] db: id=0x77bdb0034260 query='SELECT id, size_mib, boot_order FROM vm_preset_disk WHERE preset='7'' duration=67
  18. 2023-07-31 10:29:46.940 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] db: id=0x77bdb0034260 query='SELECT "hdd_overselling","ha_params","params","pool_name","enabled","is_main","cluster","storage","id" FROM vm_storage2cluster WHERE cluster='1' AND is_main=TRUE' duration=96
  19. 2023-07-31 10:29:46.940 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] db: id=0x77bdb0034260 query='SELECT "vm5_data","auth_source","state","roles","email","id" FROM vm_account WHERE "id"='5'' duration=69
  20. 2023-07-31 10:29:46.940 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] db: id=0x77bdb0034260 query='SELECT "iso_data","vm5_data","efi_boot","kms_supported","is_lxd_image","is_dummy","state","image_size_mib","archive_size_mib","min_size_mib","ip_automation","network_device","expand_part","tags","adminonly","install_script_updated_at","install_script_checksum","install_script_name","updated_at","repository","checksum","image_name","file_name","os_group","name","id" FROM vm_os WHERE "id"='22'' duration=94
  21. 2023-07-31 10:29:46.940 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] WriterAsyncProcess
  22. 2023-07-31 10:29:46.940 [pid=279] [**NO INFO**] WriterAsyncProcess post
  23. 2023-07-31 10:29:46.941 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] db: id=0x77bdb0034260 query='SELECT "value","name","id" FROM vm_bill_options WHERE "name"='license'' duration=79
  24. 2023-07-31 10:29:46.943 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] db: id=0x77bdb0034260 query='SELECT vm_node.id AS id, vm_node.cluster AS cluster, vm_cluster.name AS cluster_name, vm_cluster.virtualization_type AS virtualization_type, vm_cluster.host_distribution_policy AS host_distribution_policy, vm_cluster.node_os_family AS node_os_family, vm_node.name AS name, vm_node.cpu_number AS cpu_number, vm_node.vcpu_limit AS vcpu_limit, vm_node.ram_mib AS ram_mib, vm_node.overselling AS overselling, vm_node.state AS state, vm_node.libvirt_error AS libvirt_error, vm_node.lxd_error AS lxd_error, vm_node.ha_state AS ha_state, vm_node.host_creation_blocked AS host_creation_blocked, vm_node.host_limit AS host_limit, vm_node.host_filter AS host_filter, vm_node.libvirt_version AS libvirt_version, COALESCE(hosts.vcpu, 0) + COALESCE(moving_hosts.vcpu, 0) AS cpu_number_allocated, COALESCE(hosts.ram, 0) + COALESCE(moving_hosts.ram, 0) AS ram_mib_allocated, COALESCE(hosts.number, 0) + COALESCE(moving_hosts.number, 0) AS host_count, node_ipv4.total_ipv4 AS ipv4_total, node_ipv4.used_ipv4 AS ipv4_allocated, COALESCE(JSONB_AGG(DISTINCT CASE WHEN storage2node.id IS NOT NULL THEN JSONB_BUILD_OBJECT('id', storage2node.id, 'name', storage2node.name, 'type', storage2node.type, 'state', storage2node.state, 'local_state', storage2node.local_state, 'is_main', COALESCE(TO_JSONB(storage2node.is_main), JSONB('false')), 'enabled', COALESCE(TO_JSONB(storage2node.enabled), JSONB('false')), 'size_mib', storage2node.size_mib, 'available_mib', storage2node.available_mib, 'hdd_overselling', storage2node.hdd_overselling, 'virt_pool', storage2node.virt_pool, 'tags', st2tags.tags, 'hdd_mib_allocated', storage2node.hdd_mib_allocated) END ) FILTER (WHERE storage2node.id IS NOT NULL), CAST('[]' AS JSONB)) AS storages, JSONB_AGG(vm_node_bridge.name) AS bridge_names FROM vm_node LEFT JOIN vm_cluster ON vm_node.cluster=vm_cluster.id LEFT JOIN (SELECT node, COUNT(*) as number, COALESCE(SUM(ram_mib), 1) AS ram, COALESCE(SUM(cpu_number), 1) AS vcpu FROM vm_host host GROUP BY node) AS hosts ON hosts.node=vm_node.id LEFT JOIN (SELECT reserved_node, COUNT(*) as number, COALESCE(SUM(ram_mib), 1) AS ram, COALESCE(SUM(cpu_number), 1) AS vcpu FROM vm_host host GROUP BY reserved_node) AS moving_hosts ON moving_hosts.reserved_node=vm_node.id LEFT JOIN (SELECT node, COALESCE(SUM(CASE WHEN state='active' THEN 1 ELSE 0 END), 0) AS used_ipv4, COALESCE(COUNT(state), 0) AS total_ipv4 FROM vm_hetzner_ip hetzner_ip WHERE family=2 GROUP BY node) AS node_ipv4 ON node_ipv4.node=vm_node.id LEFT JOIN (SELECT s2n.node AS node, s2n.size_mib AS size_mib, s2n.available_mib AS available_mib, s2n.hdd_overselling AS hdd_overselling, s.id AS id, s.name AS name, s.type AS type, s.state AS state, s2n.state AS local_state, s2c.enabled AS enabled, s2c.params AS virt_pool, s2c.is_main as is_main, COALESCE(disks.hdd_mib, 0) AS hdd_mib_allocated FROM vm_storage2node s2n INNER JOIN vm_storage s ON s.id=s2n.storage LEFT JOIN (SELECT storage2node, SUM(size_mib) AS hdd_mib FROM vm_disk GROUP by storage2node) AS disks ON disks.storage2node=s2n.id INNER JOIN vm_node n ON s2n.node=n.id INNER JOIN vm_storage2cluster s2c ON s2c.storage=s.id AND s2c.cluster=n.cluster) AS storage2node ON storage2node.node=vm_node.id LEFT JOIN (SELECT st.id AS storage, COALESCE(JSONB_AGG(DISTINCT storage2tag.tag) FILTER (WHERE storage2tag.tag IS NOT NULL), CAST('[]' AS JSONB)) AS tags FROM vm_storage st LEFT JOIN vm_storage2tag storage2tag ON st.id=storage2tag.storage GROUP BY st.id) AS st2tags ON st2tags.storage=storage2node.id INNER JOIN vm_node_bridge ON vm_node_bridge.node=vm_node.id WHERE (vm_node.cluster='1') GROUP BY vm_node.id, vm_cluster.id, hosts.vcpu, moving_hosts.vcpu, hosts.ram, moving_hosts.ram, hosts.number, moving_hosts.number, node_ipv4.total_ipv4, node_ipv4.used_ipv4' duration=1738
  25. 2023-07-31 10:29:46.943 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] Constructing Storage from params '{"available_mib":42600,"enabled":true,"hdd_mib_allocated":10240,"hdd_overselling":1,"id":1,"is_main":true,"local_state":"active","name":"Storage1","size_mib":60406,"state":"active","tags":[],"type":"file","virt_pool":{"vm_storage_path":"/vm"}}'
  26. 2023-07-31 10:29:46.943 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] db: id=0x77bdb0034260 query='SELECT "nm_ruled","additional_data","vm5_data","update_dc_networks_failed","network_error","network_settings_lock","ha_error","ha_disable_failed","ha_state","host_filter","host_limit","selinux_enforcing","hostname","overselling","lxd_version","qemu_version","libvirt_version","uptime","kernel_version","os_version","metrics_timestamp","mon_install_date","mon_installed","host_creation_blocked","property","disk_params","gray_ips","problems","spice_error","bird_error","lxd_error","libvirt_error","frr_error","connection_error","state","ssh_user","ssh_port","vnc_addr","ip_addr_v6","ip_addr","socket_number","vcpu_limit","cpu_number","max_vcpu_number","ram_mib","cluster","comment","name","id" FROM vm_node WHERE "id"='2'' duration=208
  27. 2023-07-31 10:29:46.943 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] Constructing Storage from params '{"available_mib":42600,"enabled":true,"hdd_mib_allocated":10240,"hdd_overselling":1,"id":1,"is_main":true,"local_state":"active","name":"Storage1","size_mib":60406,"state":"active","tags":[],"type":"file","virt_pool":{"vm_storage_path":"/vm"}}'
  28. 2023-07-31 10:29:46.943 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] Constructing Storage from params '{"available_mib":45341,"enabled":true,"hdd_mib_allocated":12288,"hdd_overselling":1,"id":1,"is_main":true,"local_state":"active","name":"Storage1","size_mib":60406,"state":"active","tags":[],"type":"file","virt_pool":{"vm_storage_path":"/vm"}}'
  29. 2023-07-31 10:29:46.944 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] db: id=0x77bdb0034260 query='SELECT "nm_ruled","additional_data","vm5_data","update_dc_networks_failed","network_error","network_settings_lock","ha_error","ha_disable_failed","ha_state","host_filter","host_limit","selinux_enforcing","hostname","overselling","lxd_version","qemu_version","libvirt_version","uptime","kernel_version","os_version","metrics_timestamp","mon_install_date","mon_installed","host_creation_blocked","property","disk_params","gray_ips","problems","spice_error","bird_error","lxd_error","libvirt_error","frr_error","connection_error","state","ssh_user","ssh_port","vnc_addr","ip_addr_v6","ip_addr","socket_number","vcpu_limit","cpu_number","max_vcpu_number","ram_mib","cluster","comment","name","id" FROM vm_node WHERE "id"='4'' duration=212
  30. 2023-07-31 10:29:46.944 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] Constructing Storage from params '{"available_mib":45341,"enabled":true,"hdd_mib_allocated":12288,"hdd_overselling":1,"id":1,"is_main":true,"local_state":"active","name":"Storage1","size_mib":60406,"state":"active","tags":[],"type":"file","virt_pool":{"vm_storage_path":"/vm"}}'
  31. 2023-07-31 10:29:46.944 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] InternalRead service: resowatch path: watcher/2
  32. 2023-07-31 10:29:46.945 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] db: id=0x77bdb0034260 query='SELECT "imported_from","vm5_data","is_network","storage_params","state","type","comment","name","id" FROM vm_storage WHERE "id"='1'' duration=127
  33. 2023-07-31 10:29:46.946 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] db: id=0x77bdb0034260 query='SELECT COUNT(*) FROM vm_os2cluster os2c JOIN vm_os os ON os2c.os=os.id WHERE os2c.os='22' AND os2c.cluster='1' AND os.state='active'' duration=168
  34. 2023-07-31 10:29:46.946 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] db: id=0x77bdb0034260 query='SELECT "group_key","name","id" FROM vm_os_group WHERE "id"='12'' duration=91
  35. 2023-07-31 10:29:46.946 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] db: id=0x77bdb0034260 query='SELECT "immortal","hidden","url","type","name","id" FROM vm_repository WHERE "id"='2'' duration=131
  36. 2023-07-31 10:29:46.950 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] db: id=0x77bdb0034260 query='INSERT INTO vm_host ("id","name","internal_name","os","state","xml_version","vnc_password","spice_password","ram_mib","cpu_number","node","account","preset","domain","start_date","anti_spoofing_settings","firewall_rules","network_device","ip_automation","ha_maintenance") VALUES(10,'red-purple_rogueite','10_red-purple_rogueite',22,'creating',1,'hFAz1nk4Iy38sSXl6YwPavjYivYnnQzkreodXc7F4usYUuOxSL322N+CXSDSAPEi85rdW+oIcB9N4ufUnkSBVI1TPRLvpkJcgF+Ei1CbCuWgRq8sGpaz4j4wnUfwCIUY7Vwy8aXYGW3XUlWbKquBkrIDfsbbdEP06PhoDMAN3OSJy1csAUVBozm7b5bSUDShOlgsvSt9QsjjovNAvsEsQv59P/Cn+o51ZuBku5qiY1JeaZmq2emsQPfMr4XwI7ceIR8FOAifFrj0LzAcZ3wUfySpwISCgdA9aOWSxmGrDz/Wf1BWHEbc2rwK1OWBb0gEmidoBJsF8ysxHYj7wVGRKA==','phGX2PaU5coeKBMSqUzAnR3Mqj28Ua4Rn+yjsHyG+VxuXFixYrmn8CFjaHC5Eo9poDK9QOSC/zoN5KQ8qzYGhBL6bVWFdlhCOXW4srI5VRVzuDMwEqyaRW/ZtrWBKqw0HIsTF3L81PaVmEAs+IU+ZE6z3Wt7ey4FjfcOEHKHF6URi/24FKQL7/4N1I2cF0oojZtIK3dLR2orJSfl31MFOmjDBAbH6/y2S/vhuIk6P2hznzbxJwHShcl1FwPsBcKI3VpWrAl8WMvYLiVCz+c6RAprCONTbr7kUWerFccbTjlwIO7j1vKFbNaRkQggGcAZ5bksm9XbvgJBJCbGdGoCPg==',512,1,2,5,7,'red-purple-rogueite.example.com',1690799386,'{"vlan":false}','null','eth0','redhat_based','1')' duration=4009
  37. 2023-07-31 10:29:46.950 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] db: id=0x77bdb0034260 query='SELECT MAX(create_time) FROM vm_host_history WHERE event_type='field:state' AND ref='10'' duration=209
  38. 2023-07-31 10:29:46.951 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] db: id=0x77bdb0034260 query='INSERT INTO vm_host_history (id,event_type,event_info,request_user,request_owner,request_ip,request_id,ref) VALUES (167,'field:state','{"new_value":"creating","old_value":null}','n.mamaev@ispsystem.com','---','172.18.0.26','a7ba4ba64d5f1bb0ecaf32e2822805a4',10)' duration=227
  39. 2023-07-31 10:29:46.951 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] db: id=0x77bdb0034260 query='SELECT "hdd_overselling","available_mib","size_mib","state","node","storage","id" FROM vm_storage2node WHERE "storage"='1' AND "node"='2'' duration=118
  40. 2023-07-31 10:29:46.951 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] db: id=0x77bdb0034260 query='SELECT COALESCE(JSONB_AGG(target_dev), CAST('[]' AS JSONB)) FROM vm_disk WHERE (host = '10')' duration=97
  41. 2023-07-31 10:29:46.954 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] db: id=0x77bdb0034260 query='INSERT INTO vm_disk ("id","name","internal_name","is_main","expand_part","size_mib","boot_order","target_dev","bus","storage2node","account","host","tags") VALUES(11,'red-purple_rogueite','11_red-purple_rogueite','1','sda2',10240,1,'vda','virtio',2,5,10,'[]')' duration=3281
  42. 2023-07-31 10:29:46.954 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] db: id=0x77bdb0034260 query='SELECT MAX(create_time) FROM vm_disk_history WHERE event_type='field:size_mib' AND ref='11'' duration=149
  43. 2023-07-31 10:29:46.955 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] db: id=0x77bdb0034260 query='INSERT INTO vm_disk_history (id,event_type,event_info,request_user,request_owner,request_ip,request_id,ref) VALUES (11,'field:size_mib','{"new_value":"10240","old_value":null}','n.mamaev@ispsystem.com','---','172.18.0.26','a7ba4ba64d5f1bb0ecaf32e2822805a4',11)' duration=127
  44. 2023-07-31 10:29:46.955 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] db: id=0x77bdb0034260 query='SELECT "interface","cluster","ippool","id" FROM vm_ippool2cluster WHERE "ippool"='1' AND "cluster"='1'' duration=85
  45. 2023-07-31 10:29:46.955 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] db: id=0x77bdb0034260 query='SELECT "nm_ruled","date_create","old_values","take_slave_ip","vlan","is_main_network","is_default","state","gateway_v6","gateway_v4","ipv6","ipv4","node","name","id" FROM vm_node_bridge WHERE vm_node_bridge.is_default AND vm_node_bridge.is_main_network='1' AND vm_node_bridge.node='2'' duration=477
  46. 2023-07-31 10:29:46.955 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] db: id=0x77bdb0034260 query='SELECT "model","vxlan","mac_address","host","node_bridge","name","id" FROM vm_host_interfaces WHERE "node_bridge"='2' AND "host"='10'' duration=130
  47. 2023-07-31 10:29:46.956 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] db: id=0x77bdb0034260 query='SELECT "value","name","id" FROM vm_settings WHERE "name"='qemu_reserve_mac_bytes'' duration=87
  48. 2023-07-31 10:29:46.956 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] db: id=0x77bdb0034260 query='SELECT "value","name","id" FROM vm_settings WHERE "name"='mgr_reserve_mac_bytes'' duration=253
  49. 2023-07-31 10:29:46.956 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] db: id=0x77bdb0034260 query='SELECT "model","vxlan","mac_address","host","node_bridge","name","id" FROM vm_host_interfaces WHERE "mac_address"='52:54:00:7F:03:98'' duration=91
  50. 2023-07-31 10:29:46.959 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] db: id=0x77bdb0034260 query='INSERT INTO vm_host_interfaces ("id","name","node_bridge","host","mac_address") VALUES(10,'eth0',2,10,'52:54:00:7F:03:98')' duration=3027
  51. 2023-07-31 10:29:46.959 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] db: id=0x77bdb0034260 query='SELECT "tag","ippool","account","comment","name","id" FROM vm_vxlan WHERE "ippool"='1'' duration=107
  52. 2023-07-31 10:29:46.959 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] db: id=0x77bdb0034260 query='SELECT ipp2cl.ippool FROM vm_ippool2cluster ipp2cl WHERE ipp2cl.cluster = '1' AND ipp2cl.interface = '0' GROUP BY ipp2cl.ippool' duration=86
  53. 2023-07-31 10:29:46.959 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] InternalCall service: ip path: ippool/1/ip
  54. 2023-07-31 10:29:46.965 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] InternalRead service: ip path: ip/25
  55. 2023-07-31 10:29:46.968 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] db: id=0x77bdb0034260 query='SELECT "ippool","network","remote_id","host_interface","host","bin","account","property","state","family","domain","net_prefix","first_addr","netmask","gateway","ip_addr","comment","id" FROM vm_ip WHERE ip_addr='172.31.50.125'' duration=1107
  56. 2023-07-31 10:29:46.968 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] InternalRead service: ip path: ipnet/1
  57. 2023-07-31 10:29:46.970 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] db: id=0x77bdb0034260 query='SELECT "cluster","bgp_community_v6","bgp_as_v6","bgp_community","bgp_as","mac","gateway","bgp_routing_type","id" FROM vm_ip_fabric_settings WHERE "cluster"='1'' duration=172
  58. 2023-07-31 10:29:46.973 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] db: id=0x77bdb0034260 query='INSERT INTO vm_ip ("id","ip_addr","gateway","netmask","net_prefix","domain","family","state","account","bin","host","host_interface","remote_id","network","ippool") VALUES(14,'172.31.50.125','10.0.0.75','255.255.255.255',32,'red-purple-rogueite.example.com',2,'prepare to allocate',5,1000000000000000000000000000002887725693,10,10,25,1,1)' duration=3256
  59. 2023-07-31 10:29:46.977 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] db: id=0x77bdb0034260 query='UPDATE vm_host SET "proxy_port"=22 WHERE "id"=10' duration=4165
  60. 2023-07-31 10:29:46.977 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] Create notify 'instance/1/notify/update' with content '{"notifies":["cluster/1","node/2"]}'
  61. 2023-07-31 10:29:46.978 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] db: id=0x77bdb0034260 query='SELECT vm_host_interfaces.node_bridge AS node_bridge, vm_host_interfaces.mac_address AS mac_address, model, vm_host_interfaces.vxlan AS vxlan, vm_node_bridge.name AS name, vm_node_bridge.is_main_network AS is_main_network FROM vm_host_interfaces LEFT JOIN vm_node_bridge ON vm_host_interfaces.node_bridge=vm_node_bridge.id WHERE (vm_host_interfaces.host='10') ORDER BY vm_node_bridge.is_main_network DESC, vm_host_interfaces.id' duration=480
  62. 2023-07-31 10:29:46.979 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] db: id=0x77bdb0034260 query='SELECT JSONB_BUILD_OBJECT('ip_ids', COALESCE(ip2iface.list, CAST('[]' AS JSONB)), 'mac_address', vm_host_interfaces.mac_address, 'name', vm_host_interfaces.name, 'network_switch', vm_node_bridge.name, 'node_interface_name', vm_node_bridge.name) AS json FROM vm_host_interfaces LEFT JOIN (SELECT vm_ip.host_interface AS host_interface, COALESCE(JSONB_AGG(vm_ip.id), CAST('[]' AS JSONB)) AS list FROM vm_ip WHERE (vm_ip.state NOT IN ('deleting','crashed') ) AND (vm_ip.host = '10') GROUP BY vm_ip.host_interface) ip2iface ON vm_host_interfaces.id=ip2iface.host_interface JOIN vm_node_bridge ON vm_node_bridge.id=vm_host_interfaces.node_bridge WHERE (vm_host_interfaces.host='10')' duration=317
  63. 2023-07-31 10:29:46.979 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] db: id=0x77bdb0034260 query='SELECT ip_addr FROM vm_ip WHERE host='10' ORDER BY id LIMIT 1' duration=116
  64. 2023-07-31 10:29:46.981 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] ssh keys from auth {"last_notify":2737,"list":[],"size":0}
  65. 2023-07-31 10:29:46.981 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] db: id=0x77bdb0034260 query='SELECT vm_ssh_key.ssh_key FROM vm_ssh_key2cluster JOIN vm_ssh_key ON vm_ssh_key.id=vm_ssh_key2cluster.ssh_key WHERE vm_ssh_key2cluster.cluster='1'' duration=190
  66. 2023-07-31 10:29:46.981 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] db: id=0x77bdb0034260 query='SELECT "value","name","id" FROM vm_settings WHERE "name"='task_timeout'' duration=83
  67. 2023-07-31 10:29:46.981 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] db: id=0x77bdb0034260 query='SELECT "value","os","name","id" FROM vm_os_options WHERE "name"='product_key' AND "os"='22'' duration=109
  68. 2023-07-31 10:29:46.981 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] db: id=0x77bdb0034260 query='SELECT "value","os","name","id" FROM vm_os_options WHERE "name"='kms_ip' AND "os"='22'' duration=81
  69. 2023-07-31 10:29:46.983 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] /v3/whoami/vm result {"email_confirmed":true,"expires_at":"","instance_owner":false,"lang":"ru","last_notify":2737,"owner_email":"n.mamaev@ispsystem.com","owner_id":5,"roles":["@admin"],"ses_id":73,"session":"10000026-6f83e8f9-d839-470d-8c66-1bdfe05f403c","su_instance":false,"trustee_email":"n.mamaev@ispsystem.com","trustee_id":5,"xsrf_token":"10000026-6f83e8f9-d839-470d-8c66-1bdfe05f403c"}
  70. 2023-07-31 10:29:46.983 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] whoami result {"error":{"code":3007,"msg":"Session header was not set"}}
  71. 2023-07-31 10:29:46.984 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] db: id=0x77bdb0034260 query='SELECT os.id AS id, os.name AS name, os.tags AS tags, os_group.group_key AS "group" FROM vm_os os LEFT JOIN vm_os_group os_group ON os.os_group=os_group.id WHERE os.id='22'' duration=208
  72. 2023-07-31 10:29:46.984 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] db: id=0x77bdb0034260 query='SELECT disk.id AS id, disk.name AS name, disk.size_mib AS size_mib, disk.boot_order AS boot_order, disk.expand_part AS expand_part, vm_storage2node.id AS pool_id, vm_storage2cluster.pool_name AS pool_name, vm_storage2node.storage AS storage_id FROM vm_disk disk LEFT JOIN vm_storage2node ON vm_storage2node.id=disk.storage2node LEFT JOIN vm_node ON vm_node.id=vm_storage2node.node LEFT JOIN vm_storage2cluster ON vm_storage2cluster.storage=vm_storage2node.storage AND vm_storage2cluster.cluster=vm_node.cluster WHERE disk.host='10'' duration=274
  73. 2023-07-31 10:29:46.984 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] db: id=0x77bdb0034260 query='SELECT i.id AS id, i.name AS name, i.mac_address AS mac_address, i.vxlan IS NOT NULL AS is_vxlan, i.model AS model, x.id AS vxlan_id, b.id AS node_bridge, b.name AS node_bridge_name, b.is_main_network AS is_main_network FROM vm_host_interfaces AS i LEFT JOIN vm_node_bridge b ON i.node_bridge = b.id LEFT JOIN vm_vxlan x ON x.id = i.vxlan WHERE (i.host = '10') ORDER BY i.id, b.is_main_network DESC' duration=184
  74. 2023-07-31 10:29:46.984 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] db: id=0x77bdb0034260 query='SELECT "nm_ruled","date_create","old_values","take_slave_ip","vlan","is_main_network","is_default","state","gateway_v6","gateway_v4","ipv6","ipv4","node","name","id" FROM vm_node_bridge WHERE id = '2'' duration=86
  75. 2023-07-31 10:29:46.985 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] db: id=0x77bdb0034260 query='SELECT id AS local_id, ip_addr, gateway, net_prefix, domain, host_interface AS interface_id, remote_id, network AS network_id, ippool AS ippool_id, state FROM vm_ip WHERE host='10' AND family='2'' duration=79
  76. 2023-07-31 10:29:46.985 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] db: id=0x77bdb0034260 query='SELECT id AS local_id, ip_addr, gateway, net_prefix, domain, host_interface AS interface_id, remote_id, network AS network_id, ippool AS ippool_id, state FROM vm_ip WHERE host='10' AND family='10'' duration=87
  77. 2023-07-31 10:29:46.985 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] db: id=0x77bdb0034260 query='SELECT ip_addr FROM vm_ip WHERE host='10' ORDER BY id LIMIT 1' duration=64
  78. 2023-07-31 10:29:46.985 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] db: id=0x77bdb0034260 query='SELECT "state","install_script_updated_at","node","os","id" FROM vm_os2node WHERE "os"='22' AND "node"='2'' duration=74
  79. 2023-07-31 10:29:46.985 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] db: id=0x77bdb0034260 query='SELECT "value","name","id" FROM vm_settings WHERE "name"='gray_ips'' duration=59
  80. 2023-07-31 10:29:46.985 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] db: id=0x77bdb0034260 query='SELECT "value","name","id" FROM vm_settings WHERE "name"='task_timeout'' duration=49
  81. 2023-07-31 10:30:16.985 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] Task registration error: Operation canceled
  82. 2023-07-31 10:30:16.986 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] InternalDelete service: ip path: ip/25
  83. 2023-07-31 10:30:16.989 [pid=279] [#a7ba4ba64d5f1bb0ecaf32e2822805a4/172.18.0.26/@n.mamaev@ispsystem.com] Response body '{"error":{"code":5233,"msg":"Task registration error"}}'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!