temp table problem due to thread concurrency ( ERROR: could not open file "base/ ) ?

Поиск
Список
Период
Сортировка
От Jan-Peter Seifert
Тема temp table problem due to thread concurrency ( ERROR: could not open file "base/ ) ?
Дата
Msg-id trinity-7399eb94-5d8b-4135-9b99-8fcb8e85a6ee-1399477521298@3capp-gmx-bs08
обсуждение исходный текст
Ответы Re: temp table problem due to thread concurrency ( ERROR: could not open file "base/ ) ?  (David G Johnston <david.g.johnston@gmail.com>)
Список pgsql-jdbc
<div style="font-family: Verdana;font-size: 12.0px;"><div class="signature">Hello,</div><div
class="signature"> </div><divclass="signature">a 'bulk loading' routine using temporary tables suddenly failed during
testsfor no obvious reasons. At some point one of the updates on the temporary table fails with the error message
"ERROR: could not open file "base/...".</div><div class="signature"> </div><div class="signature">-Execute is used for
executingthe statements.</div><div class="signature">-Autocommit mode is used because of possible large load
size.</div><divclass="signature">-At the beginning of a load script another script drops all temporary tables - using a
selecton pg_tables for getting the table names.</div><div class="signature">-Then 'normal' temporary tables (with no
'ONCOMMIT DROP') with a fixed name are created and filled via insert first - followed by several updates. One of those
updatesfails.</div><div class="signature"> </div><div class="signature">An strace revealed that another process dropped
thetemporary table in question before the failing update - most likely the drop script. This also happens when in the
sametransaction. Additionally we used ON COMMIT DROP and DISCARD TEMP and DISCARD PLANS instead of dropping all
temporarytables. However, DISCARD TEMP obviously blocks the INSERT when within a transaction.</div><div
class="signature"> </div><divclass="signature">Removing the drop script and dropping the temporary tables created at
thebeginning of the load at the end seems to help or am I mistaken?</div><div class="signature"> </div><div
class="signature">Sois every 'JDBC' execute using its own thread/process? If so is there a way to force them to execute
insuccession and not in parallel/concurrently?</div><div class="signature"> </div><div class="signature">Could you tell
me,please?</div><div class="signature"> </div><div class="signature">Thank you very much!</div><div
class="signature"> </div><divclass="signature">Best wishes,</div><div class="signature"> </div><div
class="signature">Peter</div><divclass="signature"> </div><div class="signature"> </div><div
class="signature"> </div><divclass="signature"> </div><div class="signature"> </div></div> 

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Kevin Grittner
Дата:
Сообщение: Re: TR: [BUGS] BUG #8842: lo_open/fastpath transaction inconsistency
Следующее
От: David G Johnston
Дата:
Сообщение: Re: temp table problem due to thread concurrency ( ERROR: could not open file "base/ ) ?