Hello everyone,
From time to time I get this error when processing my own query in
from_statement:
ProgrammingError: (ProgrammingError) current transaction is aborted,
commands ignored until end of transaction block
"\nSELECT h.id AS hosts_id, h.ip AS hosts_ip, h.hostname AS
hosts_hostname, h.location AS hosts_location, h.architecture_id AS
hosts_architecture_id, h.os_kind_id AS hosts_os_kind_id, h.os_version_id
AS hosts_os_version_id, h.additional_info AS hosts_additional_info,
h.column_12 AS hosts_column_12, h.column_13 AS hosts_column_13,
h.username AS hosts_username, h.password AS hosts_password, h.alias AS
hosts_alias, h.virtualization_id AS hosts_virtualization_id, h.shareable
AS hosts_shareable, h.shareable_between_projects AS
hosts_shareable_between_projects, h.notes AS hosts_notes, h.cpu AS
hosts_cpu, h.ram AS hosts_ram, h.column_24 AS hosts_column_24, h.batch
AS hosts_batch, h.asset AS hosts_asset, h.owner AS hosts_owner,
h.ssh_key_present AS hosts_ssh_key_present, h.machine_type_model AS
hosts_machine_type_model, h.mac_address_eth_0 AS
hosts_mac_address_eth_0, h.physical_box AS hosts_physical_box,
h.up_n_running AS hosts_up_n_running, h.available AS hosts_available,
h.project_id AS hosts_project_id, architecture.id AS architecture_id,
architecture.architecture AS architecture_architecture, os_kind.id AS
os_kind_id, os_kind.os_kind AS os_kind_os_kind, os_version.id AS
os_version_id, os_version.os_version AS os_version_os_version,
virtualization.id AS virtualization_id, virtualization.virtualization AS
virtualization_virtualization, virtualization.color AS
virtualization_color, project.id AS project_id, project.project AS
project_project, email.id AS email_id, email.email AS email_email,
rh.reservation_id AS reservation_id, r.start_date AS
reservation_start_date, r.end_date AS reservation_end_date, r.status AS
reservation_status, r.businessneed AS reservation_businessneed,
r.notetohwrep AS reservation_notetohwrep, r.email_id AS
reservation_email_id, r.project_id AS reservation_project_id\n\nFROM
hosts h\nLEFT OUTER JOIN reservation_hosts rh ON h.id = rh.host_id\nLEFT
OUTER JOIN reservation r ON r.id = rh.reservation_id\nINNER JOIN
\n\n(SELECT h.id, MIN(r.start_date) FROM hosts h \nLEFT OUTER JOIN
reservation_hosts rh ON rh.host_id = h.id \nLEFT OUTER JOIN reservation
r ON rh.reservation_id = r.id GROUP BY h.id ORDER BY h.id) AS
min_date(m_host_id, m_start_date)\nON h.id = min_date.m_host_id AND
(r.start_date = min_date.m_start_date AND (r.start_date,r.end_date)
OVERLAPS ('2009-04-10'::date, '2010-04-10'::date) OR
min_date.m_start_date IS NULL)\n\nINNER JOIN architecture ON
architecture.id = h.architecture_id \nINNER JOIN os_kind ON h.os_kind_id
= os_kind.id \nINNER JOIN os_version ON h.os_version_id = os_version.id
\nINNER JOIN virtualization ON h.virtualization_id = virtualization.id
\nINNER JOIN project ON h.project_id = project.id AND project.project =
'LMT' \n LEFT OUTER JOIN email ON r.email_id = email.id \n\nWHERE h.id
NOT IN (\n\tSELECT m.host_id\n\tFROM reservation r, reservation_hosts
m\n\tWHERE r.id = m.reservation_id\n\tAND m.host_id IS NOT NULL\n\tAND
(r.start_date <= '2009-04-10'::date AND r.end_date >
'2019-04-08'::date)\n\tORDER BY h.id, r.start_date) \n\n \nAND
h.up_n_running = True AND h.shareable = True ORDER BY virtualization
DESC, ip ASC\n" {}
What could be causing this?
Regards,
mk
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
