From: | Harry Ambrose <harry(dot)ambrose(at)gmail(dot)com> |
---|---|
To: | Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100 |
Date: | 2017-06-12 12:57:05 |
Message-ID: | CAK4Knu9Kv=xDVF9UyJTuQ6k3Ef4OjSEdFk3P5Qh_qb6EAg_xzA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
pls tell me, I am currently running 2nd run in my box, (New attempt 2), and
> its in the "Attempting vacuum" phase.
> What is it supposed to do next?
> I got no errors , it has gotten my machine to its knees.
>
The jar has an endless while loop. Thus please kill the PID when you are
done testing. It loosely follows the following:
BEGIN;
CREATE TABLE x (id BIGSERIAL PRIMARY KEY, payload1 VARCHAR, payload2
VARCHAR, payload3 VARCHAR, payload4 BIGINT, payload5 BIGINT);
/* Repeat until 2,000,000 rows are inserted */
INSERT INTO x (id, payload1, payload2, payload3, payload4, payload5) VALUES
(random values of varying length/size to force random toast usage);
COMMIT;
VACUUM (ANALYZE, FULL);
BEGIN;
/* Repeat until all 2,000,000 rows are updated */
UPDATE x SET payload1 = , payload2 = , payload3 = , payload4 = , payload5 =
... again random values of varying length/size to force random toast usage
COMMIT;
VACCUM (ANALYZE, FULL);
If the error is going to occur it will happen during the second "Attempting
vacuum" phase.
1st vacuum:
c.setAutoCommit(true);
System.out.println("Attempting vacuum");
c.prepareCall("VACUUM (FULL, ANALYZE, VERBOSE) x").execute();
System.out.println("Vacuum end. 30 sec sleep");
Thread.sleep(60000);
2nd vacuum:
System.out.println("Attempting vacuum");
c.prepareCall("VACUUM (FULL, ANALYZE, VERBOSE) x").execute();
System.out.println("Vacuum completed");
Thread.sleep(30000);
System.out.println("Dropping the table");
c.createStatement().execute("drop table if exists x");
Thread.sleep(30000);
Hope this helps!
Best wishes,
Harry
From | Date | Subject | |
---|---|---|---|
Next Message | Harry Ambrose | 2017-06-12 13:01:10 | Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100 |
Previous Message | Achilleas Mantzios | 2017-06-12 12:56:26 | Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100 |