1
2
3
4
5
6
7
8
9
10
11
12
|
❯ curl -kiL \
-H "Authorization: token <API_KEY>" \
https://<gitbucket domain>/api/v3/repos/pollo-lab/sql-console/issues\?labels\=bug\&state\=open
HTTP/1.1 200
Server: nginx
Date: Tue, 19 May 2026 13:13:15 GMT
Content-Type: application/json;charset=UTF-8
Transfer-Encoding: chunked
Connection: keep-alive
Set-Cookie: JSESSIONID=24605AC372FB1D449A1700FD402FF536; Path=/gitbucket; Secure; HttpOnly
[{"number":1,"title":"select from oracle error","user":{"login":"pollochang","email":"[email protected]","type":"User","site_admin":false,"created_at":"2025-07-26T13:22:44Z","id":0,"url":"https://<gitbucket domain>/api/v3/users/pollochang","html_url":"https://<gitbucket domain>/pollochang","avatar_url":"https://<gitbucket domain>/pollochang/_avatar"},"assignees":[],"labels":[{"name":"bug","color":"fc2929","url":"https://<gitbucket domain>/api/v3/repos/pollo-lab/sql-console/labels/bug"},{"name":"v0.1.0","color":"888888","url":"https://<gitbucket domain>/api/v3/repos/pollo-lab/sql-console/labels/v0.1.0"},{"name":"db-type: oracle","color":"394a96","url":"https://<gitbucket domain>/api/v3/repos/pollo-lab/sql-console/labels/db-type: oracle"}],"state":"open","created_at":"2026-05-19T03:20:10Z","updated_at":"2026-05-19T03:22:12Z","body":"###### `oracle` , `v0.1.0`\n\n## sql\n\n```sql\nSELECT run_id, \n name AS run_name, \n check_name, \n status, \n error_number, \n start_time, \n end_time\nFROM v$hm_run\nWHERE name = 'my_run';\n```\n\n## Result\n\n```sql\nlab-vm151-oracle19c-sys> SELECT run_id,\n -> name AS run_name,\n -> check_name,\n -> status,\n -> error_number,\n -> start_time,\n -> end_time\n -> FROM v$hm_run\n -> WHERE name = 'my_run';\nsql_id: 3231c47e , transaction: auto-commit\nresult fetch size: 20\npage: 1/1, total rows: 1\n┌────────┬──────────┬────────────┬────────┬──────────────┬────────────┬──────────┐\n│ RUN ID │ RUN NAME │ CHECK NAME │ STATUS │ ERROR NUMBER │ START TIME │ END TIME │\n└────────┴──────────┴────────────┴────────┴──────────────┴────────────┴──────────┘\n```\n\n## Log\n\n```log\n{\"@timestamp\":\"2026-05-19T11:14:34.620093669+08:00\",\"@version\":\"1\",\"message\":\"Received request: Request[version=1.0, requestId=req-auth, action=connect, osUser=pollochang, payload={password=***, url=jdbc:oracle:thin:@//127.0.0.1:1521/db, profile=lab-vm151-oracle19c-sys, username=sys as sysdba}]\",\"logger_name\":\"work.pollochang.app.sqlconsole.protocol.ProtocolHandler\",\"thread_name\":\"pool-1-thread-3\",\"level\":\"INFO\",\"level_value\":20000}\n{\"@timestamp\":\"2026-05-19T11:14:34.627891378+08:00\",\"@version\":\"1\",\"message\":\"Received request: Request[version=1.0, requestId=req-query, action=query, osUser=pollochang, payload={pageSize=20, sql=SELECT run_id, \\n name AS run_name, \\n check_name, \\n status, \\n error_number, \\n start_time, \\n end_time\\nFROM v$hm_run\\nWHERE name = 'my_run'}]\",\"logger_name\":\"work.pollochang.app.sqlconsole.protocol.ProtocolHandler\",\"thread_name\":\"pool-1-thread-3\",\"level\":\"INFO\",\"level_value\":20000}\n{\"@timestamp\":\"2026-05-19T11:14:34.628663475+08:00\",\"@version\":\"1\",\"message\":\"Executing batch of 1 statements for session 8921a1c8-a3d5-4dd3-807b-b9384579fcc9\",\"logger_name\":\"work.pollochang.app.sqlconsole.engine.SqlEngine\",\"thread_name\":\"pool-1-thread-3\",\"level\":\"INFO\",\"level_value\":20000}\n{\"@timestamp\":\"2026-05-19T11:14:34.628860283+08:00\",\"@version\":\"1\",\"message\":\"Executing SQL: [SELECT run_id, \\n name AS run_name, \\n check_name, \\n status, \\n error_number, \\n start_time, \\n end_time\\nFROM v$hm_run\\nWHERE name = 'my_run']\",\"logger_name\":\"work.pollochang.app.sqlconsole.engine.QueryExecutor\",\"thread_name\":\"pool-1-thread-3\",\"level\":\"INFO\",\"level_value\":20000}\n{\"@timestamp\":\"2026-05-19T11:14:34.670257642+08:00\",\"@version\":\"1\",\"message\":\"Failed to send row\",\"logger_name\":\"work.pollochang.app.sqlconsole.protocol.SocketNdjsonStreamer\",\"thread_name\":\"pool-1-thread-3\",\"level\":\"ERROR\",\"level_value\":40000,\"stack_trace\":\"com.fasterxml.jackson.databind.exc.InvalidDefinitionException: No serializer found for class java.io.ByteArrayInputStream and no properties discovered to create BeanSerializer (to avoid exception, disable SerializationFeature.FAIL_ON_EMPTY_BEANS) (through reference chain: work.pollochang.app.sqlconsole.protocol.Message[\\\"payload\\\"]->java.util.LinkedHashMap[\\\"START_TIME\\\"]->oracle.sql.TIMESTAMP[\\\"stream\\\"])\\n\\tat com.fasterxml.jackson.databind.exc.InvalidDefinitionException.from(InvalidDefinitionException.java:77)\\n\\tat com.fasterxml.jackson.databind.SerializerProvider.reportBadDefinition(SerializerProvider.java:1330)\\n\\tat com.fasterxml.jackson.databind.DatabindContext.reportBadDefinition(DatabindContext.java:414)\\n\\tat com.fasterxml.jackson.databind.ser.impl.UnknownSerializer.failForEmpty(UnknownSerializer.java:53)\\n\\tat com.fasterxml.jackson.databind.ser.impl.UnknownSerializer.serialize(UnknownSerializer.java:30)\\n\\tat com.fasterxml.jackson.databind.ser.BeanPropertyWriter.serializeAsField(BeanPropertyWriter.java:732)\\n\\tat com.fasterxml.jackson.databind.ser.std.BeanSerializerBase.serializeFields(BeanSerializerBase.java:770)\\n\\tat com.fasterxml.jackson.databind.ser.BeanSerializer.serialize(BeanSerializer.java:183)\\n\\tat com.fasterxml.jackson.databind.ser.std.MapSerializer.serializeFields(MapSerializer.java:808)\\n\\tat com.fasterxml.jackson.databind.ser.std.MapSerializer.serializeWithoutTypeInfo(MapSerializer.java:764)\\n\\tat com.fasterxml.jackson.databind.ser.std.MapSerializer.serialize(MapSerializer.java:720)\\n\\tat com.fasterxml.jackson.databind.ser.std.MapSerializer.serialize(MapSerializer.java:35)\\n\\tat com.fasterxml.jackson.databind.ser.BeanPropertyWriter.serializeAsField(BeanPropertyWriter.java:732)\\n\\tat com.fasterxml.jackson.databind.ser.std.BeanSerializerBase.serializeFields(BeanSerializerBase.java:770)\\n\\tat com.fasterxml.jackson.databind.ser.BeanSerializer.serialize(BeanSerializer.java:183)\\n\\tat com.fasterxml.jackson.databind.ser.DefaultSerializerProvider._serialize(DefaultSerializerProvider.java:502)\\n\\tat com.fasterxml.jackson.databind.ser.DefaultSerializerProvider.serializeValue(DefaultSerializerProvider.java:341)\\n\\tat com.fasterxml.jackson.databind.ObjectMapper._writeValueAndClose(ObjectMapper.java:4799)\\n\\tat com.fasterxml.jackson.databind.ObjectMapper.writeValueAsBytes(ObjectMapper.java:4065)\\n\\tat work.pollochang.app.sqlconsole.protocol.SocketNdjsonStreamer.writeMessage(SocketNdjsonStreamer.java:33)\\n\\tat work.pollochang.app.sqlconsole.protocol.SocketNdjsonStreamer.onRow(SocketNdjsonStreamer.java:60)\\n\\tat work.pollochang.app.sqlconsole.protocol.AuditingNdjsonStreamer.onRow(AuditingNdjsonStreamer.java:48)\\n\\tat work.pollochang.app.sqlconsole.engine.CachingResultHandler.onRow(CachingResultHandler.java:45)\\n\\tat work.pollochang.app.sqlconsole.engine.QueryExecutor.execute(QueryExecutor.java:48)\\n\\tat work.pollochang.app.sqlconsole.engine.SqlEngine.executeBatch(SqlEngine.java:51)\\n\\tat work.pollochang.app.sqlconsole.protocol.handler.QueryHandler.handle(QueryHandler.java:36)\\n\\tat work.pollochang.app.sqlconsole.protocol.handler.AuditedQueryHandler.handle(AuditedQueryHandler.java:39)\\n\\tat work.pollochang.app.sqlconsole.protocol.ProtocolHandler.handleRequest(ProtocolHandler.java:91)\\n\\tat work.pollochang.app.sqlconsole.protocol.ProtocolHandler.processInput(ProtocolHandler.java:67)\\n\\tat work.pollochang.app.sqlconsole.protocol.ProtocolHandler.handleSession(ProtocolHandler.java:51)\\n\\tat work.pollochang.app.sqlconsole.server.UdsServer.handleClient(UdsServer.java:92)\\n\\tat work.pollochang.app.sqlconsole.server.UdsServer.lambda$start$0(UdsServer.java:78)\\n\\tat java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:572)\\n\\tat java.base/java.util.concurrent.FutureTask.run(FutureTask.java:317)\\n\\tat java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)\\n\\tat java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)\\n\\tat java.base/java.lang.Thread.run(Thread.java:1583)\\n\"}\n```","id":0,"comments_url":"https://<gitbucket domain>/api/v3/repos/pollo-lab/sql-console/issues/1/comments","html_url":"https://<gitbucket domain>/pollo-lab/sql-console/issues/1"}]
|
