$GITHUB_OUTPUT not available between jobs

[kristophercrawford]

Description

I copied the workflow file from #24230 and ran this on my Gitea instance. The result of the jobs is captured below in screenshots.

Gitea Version

1.21.0+rc2-55

Can you reproduce the bug on the Gitea demo site?

Yes

Log Gist

No response

Screenshots

No response

Git Version

2.30.2

Operating System

Ubuntu 22.04

How are you running Gitea?

Pre-compiled binary for arm64 on an Orange Pi 5, running through systemd (gitea and act_runner).

Database

MySQL/MariaDB

[lng2020]

That workflow file doesn't work for me either.

[ednxzu]

Same thing,
I opened an issue here because I'm not sure whether it is a gitea or act runner problem.

[yp05327]

I know the reason.
I think this was fixed by #28149

The output results will be saved in DB, but before this fix, the target table does not exsit.
So try the latest version, or add this table by yourself, can fix this issue.

↑ Your hello world, timestamp and so on should be here, but this table is missing, so you can not get them in job2.

[ednxzu]

Yup, moving to 1.21.1 worked for me. Thanks for looking into it. @kristophercrawford are you still having the issue ?

[kristophercrawford]

No change after updating to Gitea version 1.21.1. Where is the gitea.db file located? I am using the compiled binary installation file on a physical machine running MySQL as the backend database.

[yp05327]

I use sqlite for testing and it saves data into gitea.db file.
But it should have no difference between different databases.

If you can access your database, you can check whether there‘s a table named action_task_output and any data in this table.
Or if you can get your Gitea instance's logs, you can check whether there are some logs like Table gitea.action_task_output doesn't exist.

If the table is existing, but output still don't work. Maybe there are some other issues.

[kristophercrawford]

Here is what I am seeing on the db side:

MariaDB [gitea]> describe action_task_output;
+--------------+--------------+------+-----+---------+----------------+
| Field        | Type         | Null | Key | Default | Extra          |
+--------------+--------------+------+-----+---------+----------------+
| id           | bigint(20)   | NO   | PRI | NULL    | auto_increment |
| task_id      | bigint(20)   | YES  | MUL | NULL    |                |
| output_key   | varchar(255) | YES  |     | NULL    |                |
| output_value | mediumtext   | YES  |     | NULL    |                |
+--------------+--------------+------+-----+---------+----------------+
4 rows in set (0.002 sec)

MariaDB [gitea]> select * from action_task_output\G
*************************** 1. row ***************************
          id: 1
     task_id: 822
  output_key: output2
output_value: 8c8c7b6b-ef4b-45bb-a87c-5613a3e9c224
*************************** 2. row ***************************
          id: 2
     task_id: 822
  output_key: output1
output_value: 2023-11-29T12:17:08+00:00
2 rows in set (0.001 sec)

MariaDB [gitea]>

No errors in the gitea.log after upgrading to 1.21.1. The log message here is from before the upgrade.

root@dev-pi:/var/lib/gitea/log# grep '\[E\]' gitea.log
2023/11/29 12:08:05 ...ions/runner/utils.go:45:pickTask() [E] Cannot find needs for task 821: FindTaskOutputByTaskID: Error 1146 (42S02): Table 'gitea.action_task_output' doesn't exist

[yp05327]

It seems that we have another issue here. 😕

[kristophercrawford]

Fresh install of 1.21.1 works on bare metal, upgrading from 1.21.0+rc2-55 to 1.21.1 is what didn't work for me.

[yp05327]

Fresh install 1.21.0+rc2, run the workflow, it don't work. Then upgrade it to 1.21.1, rerun the workflow, it worked.
Tried both Mysql 8.0.28 and Sqlite3. 😕

ps: I can only get 1.21.0+rc2 from dl.gitea.com, where did you get 1.21.0+rc2-55?