Commit log issue with load generated by pgbench
От | Gavin Sherry |
---|---|
Тема | Commit log issue with load generated by pgbench |
Дата | |
Msg-id | Pine.LNX.4.58.0409011622001.31854@linuxworld.com.au обсуждение исходный текст |
Список | pgsql-hackers-win32 |
Hi all, I didn't see this mentioned in the archives and I've recreated it a few times (could it be a configuration issue?). I ran up the win32 beta 1 and ran pgbench against it as follows: ./pgbench -h windows.box -U postgres -P postgres bench -c 10 -t 10000 I encountered the following errors: Client 0 aborted in state 3: ERROR: could not access status of transaction 24538 DETAIL: could not open file "C:/Program Files/PostgreSQL/8.0-beta1-2/data/pg_subtrans/0000": Invalid argument Client 6 aborted in state 3: ERROR: could not access status of transaction 12277 DETAIL: could not open file "C:/Program Files/PostgreSQL/8.0-beta1-2/data/pg_subtrans/0000": Invalid argument I ran pgbench a few times and continued to get errors. I then ran vacuum to see if I'd have issues access each tuple. Again, the same error: bench=# vacuum verbose accounts; INFO: vacuuming "public.accounts" ERROR: could not access status of transaction 98865 DETAIL: could not open file "C:/Program Files/PostgreSQL/8.0-beta1-2/data/pg_subtrans/0001": Invalid argument I've confirmed that both files 0000 and 0001 exist. They are being used (we wouldn't be able to process any queries without it, right?). Is it possible that I am hitting some file limits in windows? Or is it possibly a hardware issue? (I don't have another machine to test on) Thanks, Gavin
В списке pgsql-hackers-win32 по дате отправления: