search

hezean / sustc

Template for project 2 of SUSTech Principles of Database Systems (CS307 / CS213), 23 fall semester.
http://172.18.34.154
MIT License
22 stars 9 forks source link

[Database Service] The video data of small data #46

Closed Cerulime closed 9 months ago

Cerulime commented 9 months ago

Describe your question

The reviewer's mid of BV1Kb411L79v is 0, which is not exist in UserRecord. Should all reviewers are in UserRecord?

sses7757 commented 9 months ago

@Cerulime I downloaded the latest small data and cannot find the record you described in the small dataset. The closest one has a proper reviewer. Have you download the latest data? image

Cerulime commented 9 months ago

@sses7757 SHA1: b4b7f8a06fb0a1db30a0ed1f33687e44ea730c99 That is the data I got.

@Cerulime I downloaded the latest small data and cannot find the record you described in the small dataset. The closest one has a proper reviewer. Have you download the latest data? image

sses7757 commented 9 months ago

@Cerulime The downloaded data.zip has SHA1 of 6B6C7D86C315243DC139ACBC31A951C3A8A99921.

Cerulime commented 9 months ago

@Cerulime The downloaded data.zip has SHA1 of 6B6C7D86C315243DC139ACBC31A951C3A8A99921.

@sses7757 I refer to the videorecord.ser. Sorry.

sses7757 commented 9 months ago

@Cerulime It is B4B7F8A06FB0A1DB30A0ED1F33687E44EA730C99, the same as yours. You can print the given VideoRecord with BV1Kb411L79v and see its reviewer mid. Mine is 271585 rather than 0.

Cerulime commented 9 months ago

@Cerulime It is B4B7F8A06FB0A1DB30A0ED1F33687E44EA730C99, the same as yours. You can print the given VideoRecord with BV1Kb411L79v and see its reviewer mid. Mine is 271585 rather than 0.

屏幕截图 2023-12-17 213427

I don't know what happened on the data.

sses7757 commented 9 months ago

@Cerulime My output is empty, meaning that I cannot find any video record with reviewer mid of 0. Maybe your problem is caused by the fury deserialization? However, I am not in charge of that part. Maybe other collaborators like @hezean or @XiaoMingZHM can resolve this issue with some additional information you provide.

hezean commented 9 months ago

cannot reproduce the error (with java 17). @XiaoMingZHM what's the java version when you generating the .ser files? does fury rely on serialVersionUID?

https://github.com/hezean/sustc/blob/5dd4439540b7916c00704a5c5f093dd824cda9e5/sustc-api/src/main/java/io/sustc/dto/VideoRecord.java#L13

fyi: https://www.baeldung.com/java-serial-version-uid