ERROR org.linqs.psl.database.rdbms.RDBMSInserter - [SQLITE_CONSTRAINT_UNIQUE] A UNIQUE constraint failed (UNIQUE constraint failed:

Tan Xue Wen

unread,

Mar 31, 2023, 12:38:33 AM3/31/23

to PSL Users

Hello PSL Team,

Can I check with you what did i do wrong?

I keep getting this error:

737 [main] ERROR org.linqs.psl.database.rdbms.RDBMSInserter - [SQLITE_CONSTRAINT_UNIQUE] A UNIQUE constraint failed (UNIQUE constraint failed: FATHER_PREDICATE.UniqueStringID_0, FATHER_PREDICATE.UniqueStringID_1, FATHER_PREDICATE.partition_id)
Unexpected exception!

my json is as shown below:

{
    "rules": [
        "1.0: Fathernn(A,B) >> Father(A,B) ^2"
    ],
    "predicates": {
        "fathernn/2": {
            "observations": {
                "learn": [
                    "./data/redocred/learn/fathernn_obs.txt"
                ],
                "infer": [
                    "./data/redocred/eval/fathernn_obs.txt"
                ]
            }
        },
        "father/2": {
            "evaluations": [
                "DiscreteEvaluator"
            ],
            "targets": {
                "learn": [
                    "./data/redocred/learn/target.txt"
                ],
                "infer": [
                    "./data/redocred/eval/target.txt"
                ]
            },
            "truth": {
                "learn": [
                    "./data/redocred/learn/father_truth.txt"
                ],
                "infer": [
                    "./data/redocred/eval/father_truth.txt"
                ]
            }
        }
    }
}

Thank you :) 

Best Regards,
Xue Wen

Eriq Augustine

unread,

Mar 31, 2023, 12:50:23 AM3/31/23

to Tan Xue Wen, PSL Users

Hey Xue Wen,

It looks like you may have duplicate data in your father predicate.

I can't tell which file from the error, but it looks like there is a duplicate row in one of those four files.

-eriq

--
You received this message because you are subscribed to the Google Groups "PSL Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to psl-users+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/psl-users/f577ce76-adab-4692-9a4e-305fd8c5a6c0n%40googlegroups.com.

Reply all

Reply to author

Forward

Message has been deleted