wbh1 / grafana-sqlite-to-postgres

Grafana SQLite to Postgres Database Migrator
MIT License
99 stars 26 forks source link

Invalid input syntax for type bigint #53

Open MikhailKricki opened 1 month ago

MikhailKricki commented 1 month ago

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 commented 1 month ago

If delete playlist, we get error: ❌ pq: syntax error at or near ")" INSERT INTO "kv_store" VALUES(16,0,'plugin.publickeys','key-7e4d0c6a708866e7',replace(replace('-----BEGIN PGP PUBLIC KEY BLOCK-----\r\nVersion: OpenPGP.js v4.10.1\r\nComment: https://openpgpjs.org\r\n\r\nxpMEXpTXXxMFK4EEACMEIwQBiOUQhvGbDLvndE0fEXaR0908wXzPGFpf0P0Z\r\nHJ06tsq+0higIYHp7WTNJVEZtcwoYLcPRGaa9OQqbUU63BEyZdgAkPTz3RFd\r\n5+TkDWZizDcaVFhzbDd500yTwexrpIrdInwC/jrgs7Zy/15h8KA59XXUkdmT\r\nYB6TR+OA9RKME+dCJozNGUdyYWZhbmEgPGVuZ0BncmFmYW5hLmNvbT7CvAQQ\r\nEwoAIAUCXpTXXwYLCQcIAwIEFQgKAgQWAgEAAhkBAhsDAh4BAAoJEH5NDGpw\r\niGbnaWoCCQGQ3SQnCkRWrG6XrMkXOKfDTX2ow9fuoErN46BeKmLM4f1EkDZQ\r\nTpq3SE8+My8B5BIH3SOcBeKzi3S57JHGBdFA+wIJAYWMrJNIvw8GeXne+oUo\r\nNzzACdvfqXAZEp/HFMQhCKfEoWGJE8d2YmwY2+3GufVRTI5lQnZOHLE8L/Vc\r\n1S5MXESjzpcEXpTXXxIFK4EEACMEIwQBtHX/SD5Qm3v4V92qpaIZQgtTX0sT\r\ncFPjYWAHqsQ1iENrYN/vg1wU3ADlYATvydOQYvkTyT/tbDvx2Fse8PL84MQA\r\nYKKQ6AJ3gLVvmeouZdU03YoV4MYaT8KbnJUkZQZkqdz2riOlySNI9CG3oYmv\r\nomjUAtzgAgnCcurfGLZkkMxlmY8DAQoJwqQEGBMKAAkFAl6U118CGwwACgkQ\r\nfk0ManCIZuc0jAIJAVw2xdLr4ZQqPUhubrUyFcqlWoW8dQoQagwO8s8ubmby\r\nKuLA9FWJkfuuRQr+O9gHkDVCez3aism7zmJBqIOi38aNAgjJ3bo6leSS2jR/\r\nx5NqiKVi83tiXDPncDQYPymOnMhW0l7CVA7wj75HrFvvlRI/4MArlbsZ2tBn\r\nN1c5v9v/4h6qeA==\r\n=DNbR\r\n-----END PGP PUBLIC KEY BLOCK-----\r\n','\r',char(13)),'\n',chr(10)),'2023-10-04 20:08:43','2023-10-04 23:08:52.239061793+03:00') - failed to import dump file to Postgres.