Failed to save permit #152

whilefoo · 2024-10-09T13:24:35Z

Failed to create a new location {
  code: '42501',
  details: null,
  hint: null,
  message: 'new row violates row-level security policy for table "locations"'
}
Failed to save permits to the database Error: Failed to retrieve the related location from issue [object Object]
    at PermitGenerationModule._getOrCreateIssueLocation (/home/runner/work/conversation-rewards/conversation-rewards/src/parser/permit-generation-module.ts:248:13)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at PermitGenerationModule._savePermitsToDatabase (/home/runner/work/conversation-rewards/conversation-rewards/src/parser/permit-generation-module.ts:257:28)
    at PermitGenerationModule.transform (/home/runner/work/conversation-rewards/conversation-rewards/src/parser/permit-generation-module.ts:122:9)
    at Processor.run (/home/runner/work/conversation-rewards/conversation-rewards/src/parser/processor.ts:37:24)
    at run (/home/runner/work/conversation-rewards/conversation-rewards/src/run.ts:25:5)

https://github.com/ubiquity-os-marketplace/text-conversation-rewards/actions/runs/11165001249/job/31035657102#step:7:443

The text was updated successfully, but these errors were encountered:

0x4007 · 2024-10-10T11:48:28Z

Locations table is obsolete and was removed

gentlementlegen · 2024-10-10T12:08:59Z

Locations table was still there to support the part where all the permits are fetched. We could eventually make it a plugin now that we can run actions quickly, that would periodically fetch all the data.

imabutahersiddik · 2024-10-28T22:42:50Z

/start

ubiquity-os-beta · 2024-10-28T22:42:57Z

Deadline Mon, Oct 28, 10:57 PM UTC Beneficiary 0x7245F5Cb278ea948Ab6302Bd911db00Ad4889672

Tip

Use /wallet 0x0000...0000 if you want to update your registered payment wallet address.
Be sure to open a draft pull request as soon as possible to communicate updates on your progress.
Be sure to provide timely updates to us when requested, or you will be automatically unassigned from the task.

ishowvel · 2024-10-30T21:17:43Z

i hope this issues gets fixed asap, this issue has become a blocker for me to qa my pull requests

gentlementlegen · 2024-10-31T02:19:31Z

@ishowvel What do you mean? This issue is not a blocker for a proper run of the plug-in it just outputs an error.

ishowvel · 2024-10-31T04:20:39Z

@ishowvel What do you mean? This issue is not a blocker for a proper run of the plug-in it just outputs an error.

I fixed it after disabling rls for all tables 😔

gentlementlegen · 2024-10-31T04:40:39Z

RLS doesn't matter if you use the service key.

ishowvel · 2024-10-31T05:16:06Z

RLS doesn't matter if you use the service key.

Sorry it is my first time using databases in this detail, happy to learn along the way smile 😄

ubiquity-os-beta · 2024-11-01T13:08:44Z

Passed the deadline and no activity is detected, removing assignees: @imabutahersiddik.

gentlementlegen · 2024-11-02T07:57:05Z

Error 42501 indeed means a problem while writing on the table according to postgres. It would mean that there is an RLS issue with the table, probably the key used not having enough privileges. It worked locally fine when I used the service key, maybe the environment value is wrong in this repo? I will check that.

gentlementlegen · 2024-11-02T07:58:49Z

/start

ubiquity-os-beta · 2024-11-02T07:58:55Z

Deadline Sat, Nov 2, 8:13 AM UTC Beneficiary 0x0fC1b909ba9265A846b82CF4CE352fc3e7EeB2ED

Tip

Use /wallet 0x0000...0000 if you want to update your registered payment wallet address.
Be sure to open a draft pull request as soon as possible to communicate updates on your progress.
Be sure to provide timely updates to us when requested, or you will be automatically unassigned from the task.

gentlementlegen · 2024-11-02T08:07:51Z

@whilefoo After updating the Supabase key, everything seems to work fine, the permits got saved to the db:

which corresponds to entries in
ubiquity-os-marketplace/daemon-pricing#32 (comment)

So believe this is resolved.

whilefoo · 2024-11-02T18:48:15Z

I guess we can make a new issue for removing location data because it's obsolete like @0x4007 stated

ubiquity-os-beta · 2024-11-03T00:57:03Z

Passed the deadline and no activity is detected, removing assignees: @gentlementlegen.

gentlementlegen · 2024-11-03T04:26:29Z

@0x4007 I guess this can be closed, not sure if it should be done or not planned.

0x4007 · 2024-11-03T04:48:26Z

Maybe link the correct pull that fixed this and if it's not double dipping rewards then it's valid.

gentlementlegen · 2024-11-03T04:50:23Z

There was no pull fixing it, just investigated and updated the secrets which is why I ask.

ubiquity-os-beta · 2024-11-03T06:27:14Z

@gentlementlegen the deadline is at Sun, Nov 3, 6:42 AM UTC

ubiquity-os-beta · 2024-11-03T06:27:29Z

A new workroom has been created for this task. Join chat

ubiquity-os-beta · 2024-11-03T06:27:31Z

[ 30 WXDAI ]
@gentlementlegen

Contributions Overview

View	Contribution	Count	Reward
Issue	Task	1	30
Issue	Comment	7	0

Conversation Incentives

Comment	Formatting	Relevance
`Locations` table was still there to support the part wh…	0 content: content: p: score: 0 elementCount: 1 result: 0 regex: wordCount: 35 wordValue: 0 result: 0	0.8
@ishowvel What do you mean? This issue is not a blocker for a pr…	0 content: content: p: score: 0 elementCount: 1 result: 0 regex: wordCount: 24 wordValue: 0 result: 0	0.7
RLS doesn't matter if you use the service key.	0 content: content: p: score: 0 elementCount: 1 result: 0 regex: wordCount: 10 wordValue: 0 result: 0	0.9
Error `42501` indeed means a problem while writing on th…	5 content: content: p: score: 0 elementCount: 1 a: score: 5 elementCount: 1 result: 5 regex: wordCount: 56 wordValue: 0 result: 0	0.95
@whilefoo After updating the Supabase key, everything seems to w…	5 content: content: p: score: 0 elementCount: 5 img: score: 5 elementCount: 1 result: 5 regex: wordCount: 40 wordValue: 0 result: 0	0.9
@0x4007 I guess this can be closed, not sure if it should be don…	0 content: content: p: score: 0 elementCount: 1 result: 0 regex: wordCount: 17 wordValue: 0 result: 0	0.6
There was no pull fixing it, just investigated and updated the s…	0 content: content: p: score: 0 elementCount: 1 result: 0 regex: wordCount: 17 wordValue: 0 result: 0	0.85

[ 1.184 WXDAI ]
@0x4007

Contributions Overview

View	Contribution	Count	Reward
Issue	Comment	2	1.184

Conversation Incentives

Comment

Formatting

Relevance

Reward

Locations table is obsolete and was removed

0.52

content:
  content:
    p:
      score: 0
      elementCount: 1
  result: 0
regex:
  wordCount: 7
  wordValue: 0.1
  result: 0.52

0.8

0.416

Maybe link the correct pull that fixed this and if it's not doub…

1.28

content:
  content:
    p:
      score: 0
      elementCount: 1
  result: 0
regex:
  wordCount: 20
  wordValue: 0.1
  result: 1.28

0.6

0.768

[ 0.54075 WXDAI ]
@ishowvel

Contributions Overview

View	Contribution	Count	Reward
Issue	Comment	3	0.54075

Conversation Incentives

Comment

Formatting

Relevance

Reward

i hope this issues gets fixed asap, this issue has become a bloc…

1.28

content:
  content:
    p:
      score: 0
      elementCount: 1
  result: 0
regex:
  wordCount: 20
  wordValue: 0.1
  result: 1.28

0.7

0.224

I fixed it after disabling rls for all tables 😔

0.65

content:
  content:
    p:
      score: 0
      elementCount: 1
  result: 0
regex:
  wordCount: 9
  wordValue: 0.1
  result: 0.65

0.9

0.14375

Sorry it is my first time using databases in this detail, happy …

1.17

content:
  content:
    p:
      score: 0
      elementCount: 1
  result: 0
regex:
  wordCount: 18
  wordValue: 0.1
  result: 1.17

0.6

0.173

[ 4.367 WXDAI ]
@whilefoo

Contributions Overview

View	Contribution	Count	Reward
Issue	Specification	1	3.33
Issue	Comment	1	1.037

Conversation Incentives

Comment

Formatting

Relevance

Reward

```Failed to create a new location {code: '425…

1.11

content:
  content:
    p:
      score: 0
      elementCount: 1
  result: 0
regex:
  wordCount: 17
  wordValue: 0.1
  result: 1.11

1

3.33

I guess we can make a new issue for removing location data becau…

1.22

content:
  content:
    p:
      score: 0
      elementCount: 1
  result: 0
regex:
  wordCount: 19
  wordValue: 0.1
  result: 1.22

0.85

1.037

0x4007 added Priority: 4 (Urgent) Time: <15 Minutes labels Oct 10, 2024

ubiquity-os bot added the Price: 24 USD label Oct 10, 2024

devpool-directory-superintendent bot mentioned this issue Oct 18, 2024

Failed to save permit ubiquity/devpool-directory#1702

Closed

gentlementlegen mentioned this issue Oct 21, 2024

leaderboard init ubiquity/leaderboard.ubq.fi#1

Closed

0x4007 added Priority: 5 (Emergency) and removed Priority: 4 (Urgent) labels Oct 21, 2024

ubiquity-os-beta bot added Price: 30 USD and removed Price: 24 USD labels Oct 21, 2024

This comment has been minimized.

Sign in to view

ubiquity-os-beta bot assigned imabutahersiddik Oct 28, 2024

ubiquity-os-beta bot unassigned imabutahersiddik Nov 1, 2024

ubiquity-os-beta bot assigned gentlementlegen Nov 2, 2024

ubiquity-os-beta bot unassigned gentlementlegen Nov 3, 2024

0x4007 assigned gentlementlegen Nov 3, 2024

0x4007 closed this as completed Nov 3, 2024

Failed to save permit #152

Failed to save permit #152

Comments

whilefoo commented Oct 9, 2024

0x4007 commented Oct 10, 2024

gentlementlegen commented Oct 10, 2024

imabutahersiddik commented Oct 28, 2024

This comment has been minimized.

ubiquity-os-beta bot commented Oct 28, 2024

ishowvel commented Oct 30, 2024

gentlementlegen commented Oct 31, 2024

ishowvel commented Oct 31, 2024

gentlementlegen commented Oct 31, 2024

ishowvel commented Oct 31, 2024

ubiquity-os-beta bot commented Nov 1, 2024

gentlementlegen commented Nov 2, 2024

gentlementlegen commented Nov 2, 2024

ubiquity-os-beta bot commented Nov 2, 2024

gentlementlegen commented Nov 2, 2024

whilefoo commented Nov 2, 2024

ubiquity-os-beta bot commented Nov 3, 2024

gentlementlegen commented Nov 3, 2024

0x4007 commented Nov 3, 2024

gentlementlegen commented Nov 3, 2024

ubiquity-os-beta bot commented Nov 3, 2024

ubiquity-os-beta bot commented Nov 3, 2024

ubiquity-os-beta bot commented Nov 3, 2024 • edited Loading

Contributions Overview

Conversation Incentives

Contributions Overview

Conversation Incentives

Contributions Overview

Conversation Incentives

Contributions Overview

Conversation Incentives

ubiquity-os-beta bot commented Nov 3, 2024 •

edited

Loading