SVI/netbird
1
0
Fork 0
mirror of https://github.com/netbirdio/netbird.git synced 2026-08-04 19:55:09 -04:00
Code Issues 3.0k Packages Projects Releases 10 Wiki Activity

Sqlite to Postgres migration caused issue - failed to encode args[15]: unable to encode true into binary format for numeric (OID 1700) - when changing session expiration days #2172

New Issue
Open
opened 2025-11-20 07:05:11 -05:00 by saavagebueno · 0 comments
saavagebueno commented 2025-11-20 07:05:11 -05:00
Owner
Copy Link

Originally created by @MichaelUray on GitHub (Aug 11, 2025).

After a migration from Sqlite to Postgres I experienced the following error when I tried to change the session expiration days:

management-1  | 2025-08-11T08:50:54Z ERRO [context: HTTP, requestID: 737ca23e-13af-4419-86b4-2a2321ebb35e, accountID: d1ugaajkp1rs739cm0o0, userID: 9310074d-c4ea-4a5f-bf92-9c359af6457a] management/server/store/sql_store.go:2336: failed to save account settings to store: failed to encode args[15]: unable to encode true into binary format for numeric (OID 1700): cannot find encode plan
management-1  | 2025-08-11T08:50:54Z ERRO [context: HTTP, requestID: 737ca23e-13af-4419-86b4-2a2321ebb35e, accountID: d1ugaajkp1rs739cm0o0, userID: 9310074d-c4ea-4a5f-bf92-9c359af6457a] shared/management/http/util/util.go:85: got a handler error: failed to save account settings to store
management-1  | 2025-08-11T08:50:54Z ERRO [context: HTTP, requestID: 737ca23e-13af-4419-86b4-2a2321ebb35e] management/server/telemetry/http_api_metrics.go:189: HTTP response 737ca23e-13af-4419-86b4-2a2321ebb35e: PUT /api/accounts/d1ugaajkp1rs739cm0o0 status 500

That SQL statment fixed it:

BEGIN;

-- 1) alten Default entfernen
ALTER TABLE accounts
  ALTER COLUMN settings_lazy_connection_enabled DROP DEFAULT;

-- 2) Typ konvertieren (0/NULL -> false, ≠0 -> true)
ALTER TABLE accounts
  ALTER COLUMN settings_lazy_connection_enabled
  TYPE boolean
  USING (COALESCE(settings_lazy_connection_enabled, 0) <> 0);

-- 3) Nulls auf false setzen (nur falls vorhanden)
UPDATE accounts
  SET settings_lazy_connection_enabled = false
  WHERE settings_lazy_connection_enabled IS NULL;

-- 4) neuen Default + NOT NULL setzen
ALTER TABLE accounts
  ALTER COLUMN settings_lazy_connection_enabled SET DEFAULT false,
  ALTER COLUMN settings_lazy_connection_enabled SET NOT NULL;

COMMIT;

NetBird version
Docker, selfhosted.
netbird-mgmt version 0.54.0

Originally created by @MichaelUray on GitHub (Aug 11, 2025). After a migration from Sqlite to Postgres I experienced the following error when I tried to change the session expiration days: ``` management-1 | 2025-08-11T08:50:54Z ERRO [context: HTTP, requestID: 737ca23e-13af-4419-86b4-2a2321ebb35e, accountID: d1ugaajkp1rs739cm0o0, userID: 9310074d-c4ea-4a5f-bf92-9c359af6457a] management/server/store/sql_store.go:2336: failed to save account settings to store: failed to encode args[15]: unable to encode true into binary format for numeric (OID 1700): cannot find encode plan management-1 | 2025-08-11T08:50:54Z ERRO [context: HTTP, requestID: 737ca23e-13af-4419-86b4-2a2321ebb35e, accountID: d1ugaajkp1rs739cm0o0, userID: 9310074d-c4ea-4a5f-bf92-9c359af6457a] shared/management/http/util/util.go:85: got a handler error: failed to save account settings to store management-1 | 2025-08-11T08:50:54Z ERRO [context: HTTP, requestID: 737ca23e-13af-4419-86b4-2a2321ebb35e] management/server/telemetry/http_api_metrics.go:189: HTTP response 737ca23e-13af-4419-86b4-2a2321ebb35e: PUT /api/accounts/d1ugaajkp1rs739cm0o0 status 500 ``` That SQL statment fixed it: ``` BEGIN; -- 1) alten Default entfernen ALTER TABLE accounts ALTER COLUMN settings_lazy_connection_enabled DROP DEFAULT; -- 2) Typ konvertieren (0/NULL -> false, ≠0 -> true) ALTER TABLE accounts ALTER COLUMN settings_lazy_connection_enabled TYPE boolean USING (COALESCE(settings_lazy_connection_enabled, 0) <> 0); -- 3) Nulls auf false setzen (nur falls vorhanden) UPDATE accounts SET settings_lazy_connection_enabled = false WHERE settings_lazy_connection_enabled IS NULL; -- 4) neuen Default + NOT NULL setzen ALTER TABLE accounts ALTER COLUMN settings_lazy_connection_enabled SET DEFAULT false, ALTER COLUMN settings_lazy_connection_enabled SET NOT NULL; COMMIT; ``` **NetBird version** Docker, selfhosted. netbird-mgmt version 0.54.0
saavagebueno added the triage-needed label 2025-11-20 07:05:11 -05:00
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
2021 Q4
2022 Q1
2022 Q1
accessibility
acl
agent
agent
Android
Android
api
authentik
automation
azure
battery-usage
bug
cache
client
client-ui
cloud
cloud-only
cloudflare
community
compatibility
config-idp
config-issue
connection
contribution
coturn
cross-vpn
dashboard
data-usage
distribution
dns
docker
documentation
duplicate
enhancement
enhancement
event-stream
feature-request
freebsd
getting-started
go
good first issue
gui
help wanted
home-assistant
idp
inconsistency
integration
integrations
ios
ipv6
jwt
k8s
keycloak
linux
login
macos
management-service
missing-docs
mobile
moved-internal
needs-review
netbird-ui
networking
new-platform
nginx
notification
okta
openwrt
packaging
peer-management
peer-management
peer-management
performance
postgres
posture-checks
psk
pull-request
Mirrored from GitHub Pull Request
 question
refactor
relay
release
rfc
routes
security
security-related
self-hosting
server
signal
sleep-issue
ssh
ssl
status
store
synology
system-compatibility-issue
test-suite
third-party-integration
triage
triage-needed
troubleshooting
UX
waiting-feedback
windows
wontfix
zitadel
No Label triage-needed
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
saavagebueno
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: SVI/netbird#2172
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?