Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

can't scan into dest[3]: cannot scan timestamp (OID 1114) in binary format into **time.Time #2235

Open
maxsupermanhd opened this issue Jan 20, 2025 · 0 comments
Labels

Comments

@maxsupermanhd
Copy link

maxsupermanhd commented Jan 20, 2025

Describe the bug
After upgrading to v5 sometimes it fails to scan timestamps from database, randomly, most of the time it does it but if it is running long enough it starts to fail.

To Reproduce
Unable in non-production environment (so far)

Expected behavior
In v4 timestamps were scanning perfectly fine.

Actual behavior
In v5, after some time of process/server running it starts to fail to scan timestamps.

Version

  • Go: go version go1.22.4 linux/amd64
  • PostgreSQL: PostgreSQL 16.6 (Ubuntu 16.6-0ubuntu0.24.04.1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 13.2.0-23ubuntu4) 13.2.0, 64-bit
  • pgx: github.com/jackc/pgx/v5 v5.7.2

Additional context
It seems to only fail if destination/field is nullable, never seen it fail to scan *time.Time

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

1 participant