grafana-sqlite-to-postgres icon indicating copy to clipboard operation
grafana-sqlite-to-postgres copied to clipboard

Published 20 hours ago • verified publisher icon wbh1

Invalid input syntax for type bigint

Open MikhailKricki opened this issue 7 months ago • 1 comments

Hello! When I try to migrate, I get the error: INFO[2024-07-25T14:48:29+03:00] 📁 SQLlite file: grafana.db INFO[2024-07-25T14:48:29+03:00] 📁 Dump directory: /tmp INFO[2024-07-25T14:48:29+03:00] ✅ sqlite3 command exists INFO[2024-07-25T14:48:30+03:00] ✅ sqlite3 database dumped to /tmp/grafana.sql INFO[2024-07-25T14:48:33+03:00] ✅ CREATE statements removed from dump file INFO[2024-07-25T14:48:43+03:00] ✅ sqlite3 dump sanitized INFO[2024-07-25T14:48:48+03:00] ✅ migration_log statements removed INFO[2024-07-25T14:48:49+03:00] ✅ char keyword transformed INFO[2024-07-25T14:48:50+03:00] ✅ hex-encoded data values wrapped for insertion FATAL[2024-07-25T14:48:51+03:00] ❌ pq: invalid input syntax for type bigint: "AbiGL-yVz" INSERT INTO "playlist" VALUES(3,'Live Managment','5m',5,'AbiGL-yVz',0,0) - failed to import dump file to Postgres.

We have playlist with name "Live Managment"

MikhailKricki avatar Jul 25 '24 12:07 MikhailKricki