[Bug 1358147] Re: ProgrammingError: You have an error in your SQL syntax 'INSERT INTO meteringlabels'
Fwiw, I agree with enikanorov's assessment. It looks like the first value (tenant_id) is mistakenly a python dict instead of the expected simple string. Having stared at the relevant piece of havana-eol code (neutron.db.metering.metering_db.MeteringDbMixin.create_metering_label()) and traced the value of tenant_id backwards several callers, this value is whatever the user passed in the 'tenant_id' json key in the create_metering_label REST API request. This functions is restricted to admin only, so you're probably looking for either a neutron cli tool or heat bug, or perhaps some local admin (mis)using neutronclient or the API directly. Since it has only happened once, I think this is as far as we're going to go - if you see this recur, then we need more information about who/what made the relevant REST call. ** Changed in: neutron Status: Incomplete = Invalid ** Changed in: neutron (Ubuntu) Status: New = Invalid -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1358147 Title: ProgrammingError: You have an error in your SQL syntax 'INSERT INTO meteringlabels' To manage notifications about this bug go to: https://bugs.launchpad.net/cloud-archive/+bug/1358147/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1358147] Re: ProgrammingError: You have an error in your SQL syntax 'INSERT INTO meteringlabels'
Fwiw, I agree with enikanorov's assessment. It looks like the first value (tenant_id) is mistakenly a python dict instead of the expected simple string. Having stared at the relevant piece of havana-eol code (neutron.db.metering.metering_db.MeteringDbMixin.create_metering_label()) and traced the value of tenant_id backwards several callers, this value is whatever the user passed in the 'tenant_id' json key in the create_metering_label REST API request. This functions is restricted to admin only, so you're probably looking for either a neutron cli tool or heat bug, or perhaps some local admin (mis)using neutronclient or the API directly. Since it has only happened once, I think this is as far as we're going to go - if you see this recur, then we need more information about who/what made the relevant REST call. ** Changed in: neutron Status: Incomplete = Invalid ** Changed in: neutron (Ubuntu) Status: New = Invalid -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to neutron in Ubuntu. https://bugs.launchpad.net/bugs/1358147 Title: ProgrammingError: You have an error in your SQL syntax 'INSERT INTO meteringlabels' To manage notifications about this bug go to: https://bugs.launchpad.net/cloud-archive/+bug/1358147/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 1358147] Re: ProgrammingError: You have an error in your SQL syntax 'INSERT INTO meteringlabels'
2013.2 (havana) is no longer supported by Canonical in the Cloud Archive so marking 'Won't Fix'; leaving main distro task open. ** Changed in: neutron (Ubuntu) Importance: Undecided = Low ** Changed in: cloud-archive Importance: Undecided = Low ** Changed in: cloud-archive Status: New = Won't Fix -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to neutron in Ubuntu. https://bugs.launchpad.net/bugs/1358147 Title: ProgrammingError: You have an error in your SQL syntax 'INSERT INTO meteringlabels' To manage notifications about this bug go to: https://bugs.launchpad.net/cloud-archive/+bug/1358147/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 1358147] Re: ProgrammingError: You have an error in your SQL syntax 'INSERT INTO meteringlabels'
2013.2 (havana) is no longer supported by Canonical in the Cloud Archive so marking 'Won't Fix'; leaving main distro task open. ** Changed in: neutron (Ubuntu) Importance: Undecided = Low ** Changed in: cloud-archive Importance: Undecided = Low ** Changed in: cloud-archive Status: New = Won't Fix -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1358147 Title: ProgrammingError: You have an error in your SQL syntax 'INSERT INTO meteringlabels' To manage notifications about this bug go to: https://bugs.launchpad.net/cloud-archive/+bug/1358147/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1358147] Re: ProgrammingError: You have an error in your SQL syntax 'INSERT INTO meteringlabels'
From the trace it still looks like malformed user request was handled and led to such trace. I think more data needed to investigate this further, hence marking as incomplete for neutron ** Tags added: api metering ** Changed in: neutron Importance: Undecided = Low ** Changed in: neutron Status: New = Incomplete -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to neutron in Ubuntu. https://bugs.launchpad.net/bugs/1358147 Title: ProgrammingError: You have an error in your SQL syntax 'INSERT INTO meteringlabels' To manage notifications about this bug go to: https://bugs.launchpad.net/cloud-archive/+bug/1358147/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 1358147] Re: ProgrammingError: You have an error in your SQL syntax 'INSERT INTO meteringlabels'
What kind of data do you need? That installation is still running, I can gather it. -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to neutron in Ubuntu. https://bugs.launchpad.net/bugs/1358147 Title: ProgrammingError: You have an error in your SQL syntax 'INSERT INTO meteringlabels' To manage notifications about this bug go to: https://bugs.launchpad.net/cloud-archive/+bug/1358147/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 1358147] Re: ProgrammingError: You have an error in your SQL syntax 'INSERT INTO meteringlabels'
From the trace it still looks like malformed user request was handled and led to such trace. I think more data needed to investigate this further, hence marking as incomplete for neutron ** Tags added: api metering ** Changed in: neutron Importance: Undecided = Low ** Changed in: neutron Status: New = Incomplete -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1358147 Title: ProgrammingError: You have an error in your SQL syntax 'INSERT INTO meteringlabels' To manage notifications about this bug go to: https://bugs.launchpad.net/cloud-archive/+bug/1358147/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1358147] Re: ProgrammingError: You have an error in your SQL syntax 'INSERT INTO meteringlabels'
What kind of data do you need? That installation is still running, I can gather it. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1358147 Title: ProgrammingError: You have an error in your SQL syntax 'INSERT INTO meteringlabels' To manage notifications about this bug go to: https://bugs.launchpad.net/cloud-archive/+bug/1358147/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs