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

1.0.14 SQL error #70

Closed
d0dev opened this issue Dec 4, 2023 · 2 comments
Closed

1.0.14 SQL error #70

d0dev opened this issue Dec 4, 2023 · 2 comments

Comments

@d0dev
Copy link

d0dev commented Dec 4, 2023

Tried to run test.sql to update to 1.0.14 (I'm on 1.0.13) and received this from neon console.

ERROR: could not create unique index "uploads_pk" (SQLSTATE 23505)

If I try to analize or explain in neon console I receive this:

ERROR: syntax error at or near ";" (SQLSTATE 42601)

Edit: I was trying other ways as my almost 0 knowledge about plsql.

Reached this point:

ERROR: Key (upload_id, part_no)=(15e244f3985424e7857fc0fce3a74383, 1) is duplicated.could not create unique index "uploads_pk"

ERROR: could not create unique index "uploads_pk"
SQL state: 23505
Detail: Key (upload_id, part_no)=(15e244f3985424e7857fc0fce3a74383, 1) is duplicated.

I have a bunch of them repeated

imagen

imagen

@d0dev
Copy link
Author

d0dev commented Dec 4, 2023

Used this query at the end to try to clean the table

DELETE FROM teldrive.uploads
WHERE (upload_id, part_no) IN (
SELECT upload_id, part_no
FROM teldrive.uploads
GROUP BY upload_id, part_no
HAVING COUNT(*) > 1
);

But now I'm receiving this

Error #1: callback: send upload RPC: retry middleware skip: rpcDoRequest: rpc error code 400: FILE_PART_EMPTY
[GIN] 2023/12/04 - 21:02:49 | 500 | 275.446196ms | 127.0.0.1 | POST "/api/uploads/795b2366f25fd1649fda180cfe828e80?channelId=0&fileName=2f746f44820f47a08540e29ac8fd86be&partNo=1"
Error #1: callback: send upload RPC: retry middleware skip: rpcDoRequest: rpc error code 400: FILE_PART_EMPTY
[GIN] 2023/12/04 - 21:02:51 | 500 | 271.446816ms | 127.0.0.1 | POST "/api/uploads/1ac1d0351778b2b6c3ff579efae82fbb?channelId=0&fileName=113f2df572354f8ab903c494ddb076a7&partNo=1"
Error #1: callback: send upload RPC: retry middleware skip: rpcDoRequest: rpc error code 400: FILE_PART_EMPTY

And nothing is able to be upload. Download works well

@d0dev
Copy link
Author

d0dev commented Dec 6, 2023

Fixed on the last update

@d0dev d0dev closed this as completed Dec 6, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant