Graal Forums - SQL Explorer

Graal Forums (https://forums.graalonline.com/forums/index.php)

- Code Gallery (https://forums.graalonline.com/forums/forumdisplay.php?f=179)

- - SQL Explorer (https://forums.graalonline.com/forums/showthread.php?t=134256319)

The link that states the new versions of SQL can always be found at the specified link, is broken and gives me an error when trying to connect.

HTML Code:

Not Found



The requested URL /sqlexplorer/ was not found on this server.



Apache/2.2.19 (Ubuntu) Server at code.graalcenter.org Port 80

If you could fix this, it would be great!

Quote:

Originally Posted by Emera (Post 1661046)

The link that states the new versions of SQL can always be found at the specified link, is broken and gives me an error when trying to connect.

HTML Code:

Not Found



The requested URL /sqlexplorer/ was not found on this server.



Apache/2.2.19 (Ubuntu) Server at code.graalcenter.org Port 80

If you could fix this, it would be great!

My server's down at the moment. You can use this direct link for now.

edit: code.graalcenter.org is back up

the database info is off-center
but i still love you

The raw file link on this no longer works

Quote:

Originally Posted by Cubical (Post 1707701)

The raw file link on this no longer works

Sorry, should be fixed now. Bug in my pastebin site.

So after the server shutdown on Christmas, i logged in and used the SQL explorer, which is an awesome tool btw =]. However i got an error " SQL Explorer Error: database disk image is malformed
Query: SELECT name FROM 'sqlite_master' WHERE type = 'table' ORDER BY name"

In my knowledge my server does not call this query. Also everything now says "loading" and i cannot even get to the schema for anything.

Quote:

Originally Posted by JohnnyChimpo (Post 1724567)

Sounds like the database is corrupted. You may want to contact Stefan. You can also try downloading it and recovering data yourself (there is information on trying to recover data from damaged SQLite databases online).

Is there any way to avoid these situations? How could it have been made corrupt?

Quote:

Originally Posted by JohnnyChimpo (Post 1724574)

Is there any way to avoid these situations? How could it have been made corrupt?

I don't really know what happened but if there was a sudden failure (power outage, server crash, etc.) there is potential for corruption. It's also possible there was disk or memory corruption but that sounds unlikely since it coincided with some kind of server crash.

Given that the recommended mode for running your databases in Graal is with SYNCHRONOUS set to OFF, it's kind of surprising it took this long for a database to become corrupted. From the SQLite docs (emphasis mine):

Quote:

When synchronous is FULL (2), the SQLite database engine will use the xSync method of the VFS to ensure that all content is safely written to the disk surface prior to continuing. This ensures that an operating system crash or power failure will not corrupt the database. FULL synchronous is very safe, but it is also slower. When synchronous is NORMAL (1), the SQLite database engine will still sync at the most critical moments, but less often than in FULL mode. There is a very small (though non-zero) chance that a power failure at just the wrong time could corrupt the database in NORMAL mode. But in practice, you are more likely to suffer a catastrophic disk failure or some other unrecoverable hardware fault. With synchronous OFF (0), SQLite continues without syncing as soon as it has handed data off to the operating system. If the application running SQLite crashes, the data will be safe, but the database might become corrupted if the operating system crashes or the computer loses power before that data has been written to the disk surface. On the other hand, some operations are as much as 50 or more times faster with synchronous OFF.

This is mostly speculation and maybe Stefan or someone else can provide more information as I don't really know what happened.

Assuming that my database did go to complete ****, like i think it did. How do i get it to reset so i can add back the stuff i lost. Ive tried deleting the DB in the databases folder, that did nothing. I also tried erasing the contents and uploading it back into the folder, which did nothing.

Quote:

Originally Posted by JohnnyChimpo (Post 1724581)

If deleting it from the databases directory doesn't work, you might want to contact Stefan. You might also try deleting it while the NPC-server is offline.

In the meantime you could also just create another database and switch everything to use your new database (in case it takes Stefan a while to respond).

Could you give me the steps to do that because im pretty sure i did it right and it didnt work. (create another db)

Quote:

Originally Posted by JohnnyChimpo (Post 1724584)

Could you give me the steps to do that because im pretty sure i did it right and it didnt work. (create another db)

Just add another databases= line to server options. You'll probably need to give it a new name and change your scripts to reflect that (or maybe you can remap "default", idk).

Just out of curiosity, do the newer versions support importing .db files yet? I know they can be exported and viewed in other programs for backup purposes, but an option to import it all back in would be sweet.

Quote:

Originally Posted by Draenin (Post 1727683)

Pretty sure you can over-write the file in databases folder
(rw databases/*)

Ah, okay. I'll be sure to test that out.

Really wanna try the new version, but I wanted to be sure I wouldn't be losing the stuff I've already entered.