I suspect you are correct. I have about 15M rows in the graph table now and memory is at 99%.
Thanks,
Robert
-----Original Message-----
From: <email address hidden> [mailto:<email address hidden>] On Behalf Of Arjen Lentz
Sent: Wednesday, April 14, 2010 9:27 AM
To: Robert Jordan
Subject: [Bug 535225] Re: Table marked as crashed
Robert, assigning this to Antony to check out - but this *may* be just a case of "out of memory".
There are some limitations of the storage engine API, sometimes the consequence is a "not quite appropriate" error code getting returned.
Perhaps you can help checking this also, but for instance running "free"
in "watch" in another window while running the insert-select. thanks
Hi Arjen,
I suspect you are correct. I have about 15M rows in the graph table now and memory is at 99%.
Thanks,
Robert
-----Original Message-----
From: <email address hidden> [mailto:<email address hidden>] On Behalf Of Arjen Lentz
Sent: Wednesday, April 14, 2010 9:27 AM
To: Robert Jordan
Subject: [Bug 535225] Re: Table marked as crashed
Robert, assigning this to Antony to check out - but this *may* be just a case of "out of memory".
There are some limitations of the storage engine API, sometimes the consequence is a "not quite appropriate" error code getting returned.
Perhaps you can help checking this also, but for instance running "free"
in "watch" in another window while running the insert-select. thanks
-- /bugs.launchpad .net/bugs/ 535225
Table marked as crashed
https:/
You received this bug notification because you are a direct subscriber of the bug.
Status in Graph Engine for MySQL, MariaDB and Drizzle: New
Bug description:
When loading data into OQGRAPH MySQL is reporting:
ERROR 1194 (HY000): Table 'edges' is marked as crashed and should be repaired
Here is the query used to load data:
INSERT INTO edges (origid,destid) SELECT p_ino,st_ino FROM imd;
and here is a sample of the data being inserted:
+------ -----+- ------- ----+ -----+- ------- ----+ -----+- ------- ----+
| p_ino | st_ino |
+------
| 113639424 | 113639425 |
| 113639424 | 111525270 |
| 113639424 | 381625582 |
| 113639424 | 3917221644 |
| 113639424 | 87451732 |
| 113639424 | 123690665 |
| 113639425 | 113639426 |
| 113639425 | 113704960 |
| 113639425 | 113836068 |
| 113639425 | 94051877 |
+------
System info:
MySQL = MariaDB 5.1.42
To unsubscribe from this bug, go to: /bugs.launchpad .net/oqgraph/ +bug/535225/ +subscribe
https:/