[Bug 1366104] Re: OperationError when large object greater than 2gb

[Scott Kitterman]

On Monday, September 29, 2014 14:43:44 you wrote:
> Because it uses a new libpq api. Specifically the new api is only
> available from libpq 9.3: If the package is built against libpq 9.3 and
> is used on a client that has an older libpq version it will fail import.
> More details at
> <https://github.com/psycopg/psycopg2/pull/259#issuecomment-55209844>.
> Probably your "large MAAS cluster" has verified it with its own setup
> but not with older libpq versions.
> 
> From the psycopg PoV the LO64 support is a new feature that will only be
> introduced in psycopg 2.6. IMO MAAS should install psycopg from pip or
> from upstream instead of using the Ubuntu one, which is painfully out of
> date.

The one we're talking about is 2.5.3, so it's not too horribly out of date, 
but since MAAS has to be updated for older releases which are still on 2.4.5, 
that's a relevant point.  It doesn't solve MAAS' problem just to patch this in 
Utopic.  12.04 only has libpq 9.1, so unless 12.04 is no longer a deployment 
target for MAAS, using the LO64 doesn't solve your problem anyway.

-- 
You received this bug notification because you are a member of Ubuntu
Foundations Bugs, which is subscribed to psycopg2 in Ubuntu.
https://bugs.launchpad.net/bugs/1366104

Title:
  OperationError when large object greater than 2gb

Status in MAAS:
  Fix Committed
Status in “psycopg2” package in Ubuntu:
  Incomplete

Bug description:
  If a large object is greater than 2gb then calls to seek and tell will
  fail with an OperationError. This is because of the use of lseek and
  ltell instead of the lseek64 and ltell64.

  Attached is the upstream issue and pull request.

  https://github.com/psycopg/psycopg2/pull/259

To manage notifications about this bug go to:
https://bugs.launchpad.net/maas/+bug/1366104/+subscriptions