ERROR: relation "scheduler_task" does not exist

Moderator: crythias

Post Reply
hermawan
Znuny newbie
Posts: 30
Joined: 12 Apr 2017, 12:10
Znuny Version: 6.4.5
Real Name: Hermawan Al-Faruq

ERROR: relation "scheduler_task" does not exist

Post by hermawan »

Hi wong, im just deleted a big 40GB of log from postgree transaction. and when i was check is seems like thousand error like this, its actually from OTRS (my db is only OTRS table exist)

Code: Select all

{"log":"2022-06-20 03:44:30.761 UTC [33] ERROR:  relation \"scheduler_task\" does not exist at character 16\n","stream":"stderr","time":"2022-06-20T03:44:30.761953942Z"}
{"log":"2022-06-20 03:44:30.761 UTC [33] STATEMENT:  SELECT id FROM scheduler_task WHERE lock_key = 0 ORDER BY id ASC\n","stream":"stderr","time":"2022-06-20T03:44:30.76198607Z"}
{"log":"2022-06-20 03:44:31.042 UTC [33] ERROR:  relation \"scheduler_task\" does not exist at character 16\n","stream":"stderr","time":"2022-06-20T03:44:31.042504789Z"}
{"log":"2022-06-20 03:44:31.042 UTC [33] STATEMENT:  SELECT id FROM scheduler_task WHERE lock_key = 0 ORDER BY id ASC\n","stream":"stderr","time":"2022-06-20T03:44:31.042547233Z"}
{"log":"2022-06-20 03:44:31.308 UTC [33] ERROR:  relation \"scheduler_task\" does not exist at character 16\n","stream":"stderr","time":"2022-06-20T03:44:31.308853502Z"}
{"log":"2022-06-20 03:44:31.308 UTC [33] STATEMENT:  SELECT id FROM scheduler_task WHERE lock_key = 0 ORDER BY id ASC\n","stream":"stderr","time":"2022-06-20T03:44:31.308910058Z"}
{"log":"2022-06-20 03:44:31.575 UTC [33] ERROR:  relation \"scheduler_task\" does not exist at character 16\n","stream":"stderr","time":"2022-06-20T03:44:31.575381497Z"}
{"log":"2022-06-20 03:44:31.575 UTC [33] STATEMENT:  SELECT id FROM scheduler_task WHERE lock_key = 0 ORDER BY id ASC\n","stream":"stderr","time":"2022-06-20T03:44:31.575428155Z"}
{"log":"2022-06-20 03:44:31.665 UTC [48] ERROR:  relation \"scheduler_recurrent_task\" does not exist at character 70\n","stream":"stderr","time":"2022-06-20T03:44:31.665215064Z"}
{"log":"2022-06-20 03:44:31.665 UTC [48] STATEMENT:  \n","stream":"stderr","time":"2022-06-20T03:44:31.665246276Z"}
{"log":"\u0009                SELECT id, last_execution_time\n","stream":"stderr","time":"2022-06-20T03:44:31.665250478Z"}
{"log":"\u0009                FROM scheduler_recurrent_task\n","stream":"stderr","time":"2022-06-20T03:44:31.665254069Z"}
{"log":"\u0009                WHERE task_type = $1 AND name = $2\n","stream":"stderr","time":"2022-06-20T03:44:31.665257309Z"}
{"log":"2022-06-20 03:44:31.700 UTC [48] ERROR:  relation \"scheduler_recurrent_task\" does not exist at character 34\n","stream":"stderr","time":"2022-06-20T03:44:31.700582294Z"}
{"log":"2022-06-20 03:44:31.700 UTC [48] STATEMENT:  \n","stream":"stderr","time":"2022-06-20T03:44:31.700642773Z"}
{"log":"\u0009                    INSERT INTO scheduler_recurrent_task\n","stream":"stderr","time":"2022-06-20T03:44:31.70064728Z"}
{"log":"\u0009                        (name, task_type, last_execution_time, lock_key, create_time, change_time)\n","stream":"stderr","time":"2022-06-20T03:44:31.700650695Z"}
{"log":"\u0009                    VALUES\n","stream":"stderr","time":"2022-06-20T03:44:31.700653713Z"}
{"log":"\u0009                        ($1, $2, $3, 0, '2022-06-20 03:44:31', '2022-06-20 03:44:31')\n","stream":"stderr","time":"2022-06-20T03:44:31.70065649Z"}
{"log":"2022-06-20 03:44:31.718 UTC [48] ERROR:  relation \"scheduler_recurrent_task\" does not exist at character 70\n","stream":"stderr","time":"2022-06-20T03:44:31.718804092Z"}
{"log":"2022-06-20 03:44:31.718 UTC [48] STATEMENT:  \n","stream":"stderr","time":"2022-06-20T03:44:31.718837972Z"}
{"log":"\u0009                SELECT id, last_execution_time\n","stream":"stderr","time":"2022-06-20T03:44:31.718841735Z"}
What actually happen, and how to stop this errors?

Many thanks wong.
---
ati ati kepatil memiaw :D
Post Reply