Error: Could not locate unexpired trusted ticket

When I try to access a site that uses trusted authentication, the following error might occur:

​

An error occurred on the server. The details of the error are:

Could not locate unexpired trusted ticket

​

Recently activity:

Two days ago, we upgrade Tableau Server from 2022.1 to 2023.1.6​

Before ​this morning, it is working normally.

​

​access.*.log

<Tableau Server Host Name> <Client IP> - 2023-10-25T10:53:21.399 "+0800" 80 "POST /trusted/ HTTP/1.1" "-" 200 2 "15" 189012 ZTiDIVwKriBYcdOysJ6s2wAAA9g - - - - "-"

bump-ap-vm-06 10.16.163.148 - 2023-10-25T10:53:21.612 "+0800" 80 "GET /trusted/-1/views/Q_Time_Control/A1?...&:showShareOptions=false HTTP/1.1" "-" 403 1280 "-" 17999 ZTiDIVwKriBYcdOysJ6s3AAAA9g NeedsClassification 2 0x0 vizqlserver "-"

<Tableau Server Host Name> <Tableau Server IP> - 2023-10-25T10:53:21.687 "+0800" 80 "GET /vizql/v_202312309091155/javascripts/vizqlserver/hide-load-indicators.js HTTP/1.1" "-" 404 523 "-" 18996 ZTiDIVwKriBYcdOysJ6s3QAAA9g - - - - "-"

​

vizqlserver_node1-1.log

​2023-10-25 11:41:07.528 +0800 (,,-,ZTiOU1wKriBYcdOysJ7EfgAAA9o) catalina-exec-120 : DEBUG wgsessionId= com.tableausoftware.domain.user.auth.jpa.TrustedTicketDaoJpa - Ticket creation query is: INSERT INTO trusted_tickets (created_at, expires_at, client_ip, guid, hashed_ticket, salt,originating_session_id, site_id, ticket, user_id, username) VALUES (now(), now()+cast('180 seconds' as interval), , TqCZd5G5QfG01DMj_w4hzg==, 'NA', 'NA', null, 1, null, 26, XXXXXX);

2023-10-25 11:41:07.531 +0800 (,,-,ZTiOU1wKriBYcdOysJ7EfgAAA9o) catalina-exec-120 : WARN wgsessionId= org.hibernate.engine.jdbc.spi.SqlExceptionHelper - SQL Error: 0, SQLState: XX001

2023-10-25 11:41:07.531 +0800 (,,-,ZTiOU1wKriBYcdOysJ7EfgAAA9o) catalina-exec-120 : ERROR wgsessionId= org.hibernate.engine.jdbc.spi.SqlExceptionHelper - ERROR: could not read block 0 in file "base/16393/19245": read only 0 of 8192 bytes

2023-10-25 11:41:07.532 +0800 (,,-,ZTiOU1wKriBYcdOysJ7EfgAAA9o) catalina-exec-120 : ERROR wgsessionId= com.tableausoftware.domain.user.auth.TrustedTicketServiceImpl - Error creating TrustedTicket

javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not execute statement

​

​

How do I resolve it?

thanks.

​