你的位置：首页>programmer>postgresql - Connection lost error in SAS Studio on SQLPrepare with Postgres - Stack Overflow

postgresql - Connection lost error in SAS Studio on SQLPrepare with Postgres - Stack Overflow

programmeradmin2025-03-120浏览0评论

While running Flows in SAS Studio it happens that the next step, which is not using a SAS Work table but one of the library connected postgres tables, fails* due to an disconnection error labeled as:

ERROR: CLI prepare error: SQLPrepare unable due to the connection lost

*: sometimes it keeps on 'running' without failing for several minutes, and a total freeze of that flow and a failing connection to show the a library table indicates that it probably failed...

Platform: SAS® Studio - (Stable) 2024.12 @SAS Viya
Database: PostgreSQL
Connection: SAS defined Library with 'SAS/Access to Postgres' and Authdomain, through a VPN tunnel

It doesn't matter the type of the step (e.g. Query, Filter, ...), but it appears to happen if a flow is running for a longer timespan, or if the last disconnect is more than 15/30 minutes ago. (Which I tried to measure but was inconclusive)

A quick fix is to reconnect the library and repeat the failed step, but sometimes a complete reset of the session is needed, resetting the flows progress and work tables in the progess.

I cannot rule out that the core problem is somewhat related to an occasional I/O error on GET request, which seems not to correlate, but appears also in that same environment.

与本文相关的文章

postgresql - Connection lost error in SAS Studio on SQLPrepare with Postgres - Stack Overflow

评论列表(0)

暂无评论

ok 不同模板 switch ($forum['model']) { /*case '0': include _include(APP_PATH . 'view/htm/read.htm'); break;*/ default: include _include(theme_load('read', $fid)); break; } } break; case '10': // 主题外链 / thread external link http_location(htmlspecialchars_decode(trim($thread['description']))); break; case '11': // 单页 / single page $attachlist = array(); $imagelist = array(); $thread['filelist'] = array(); $threadlist = NULL; $thread['files'] > 0 and list($attachlist, $imagelist, $thread['filelist']) = well_attach_find_by_tid($tid); $data = data_read_cache($tid); empty($data) and message(-1, lang('data_malformation')); $tidlist = $forum['threads'] ? page_find_by_fid($fid, $page, $pagesize) : NULL; if ($tidlist) { $tidarr = arrlist_values($tidlist, 'tid'); $threadlist = well_thread_find($tidarr, $pagesize); // 按之前tidlist排序 $threadlist = array2_sort_key($threadlist, $tidlist, 'tid'); } $allowpost = forum_access_user($fid, $gid, 'allowpost'); $allowupdate = forum_access_mod($fid, $gid, 'allowupdate'); $allowdelete = forum_access_mod($fid, $gid, 'allowdelete'); $access = array('allowpost' => $allowpost, 'allowupdate' => $allowupdate, 'allowdelete' => $allowdelete); $header['title'] = $thread['subject']; $header['mobile_link'] = $thread['url']; $header['keywords'] = $thread['keyword'] ? $thread['keyword'] : $thread['subject']; $header['description'] = $thread['description'] ? $thread['description'] : $thread['brief']; $_SESSION['fid'] = $fid; if ($ajax) { empty($conf['api_on']) and message(0, lang('closed')); $apilist['header'] = $header; $apilist['extra'] = $extra; $apilist['access'] = $access; $apilist['thread'] = well_thread_safe_info($thread); $apilist['thread_data'] = $data; $apilist['forum'] = $forum; $apilist['imagelist'] = $imagelist; $apilist['filelist'] = $thread['filelist']; $apilist['threadlist'] = $threadlist; message(0, $apilist); } else { include _include(theme_load('single_page', $fid)); } break; default: message(-1, lang('data_malformation')); break; } ?>