Table marked as crashed

[Robert Jordan]

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

[Robert Jordan (rjordan-imagemoversdigital)]

Update:

This happens if the insert is greater than 35782820 rows.

[Arjen Lentz (arjen-lentz)]

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

[Robert Jordan (rjordan-imagemoversdigital)]

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

--
Table marked as crashed
https://bugs.launchpad.net/bugs/535225
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:
https://bugs.launchpad.net/oqgraph/+bug/535225/+subscribe

[Arjen Lentz (arjen-lentz)]

v3 should resolve this as it no longer stores its own data but instead shims on a regular engine for its persistent storage.