z-dat-s4-a (sql-s4) crashed

classic Classic list List threaded Threaded
7 messages Options
Reply | Threaded
Open this post in threaded view
|

z-dat-s4-a (sql-s4) crashed

DaB.-2
Hello all,

mysql on z-dat-s4-a (that's the host that serves sql-s4 (aka commons) at the
moment) crashed and does not recover as far as I see. So I switched sql-s4-rr
and sql-s4-user to ther hosts which have also a copy of commons. The problem
is now that the host that now serves sql-s4-user have no user-databases at the
moment. I switched the server read/write so you can create databases there if
you like.

For details see [1].

Sincerly,
DaB.

[1] https://jira.toolserver.org/browse/MNT-1074

--
Userpage: [[:w:de:User:DaB.]] — PGP: 2B255885

_______________________________________________
Toolserver-l mailing list ([hidden email])
https://lists.wikimedia.org/mailman/listinfo/toolserver-l
Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette

signature.asc (205 bytes) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: z-dat-s4-a (sql-s4) crashed

DaB.-2
Hello,
At Tuesday 23 August 2011 22:43:50 DaB. wrote:
> So I switched sql-s4-rr
> and sql-s4-user to ther hosts which have also a copy of commons.

sorry, I forgot to mention: The switching killed every running mysql-query.
Just if you wonder why your query was killed.

Sincerly,
DaB.

--
Userpage: [[:w:de:User:DaB.]] — PGP: 2B255885

_______________________________________________
Toolserver-l mailing list ([hidden email])
https://lists.wikimedia.org/mailman/listinfo/toolserver-l
Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette

signature.asc (205 bytes) Download Attachment
Reply | Threaded
Open this post in threaded view
|

S4-user-databases (was: Re: z-dat-s4-a (sql-s4) crashed)

DaB.-2
In reply to this post by DaB.-2
Hello all,

it took a while, back I finaly managed to extract your user-databases of the
crashed s4-server.
You can find the dumps at /mnt/user-store/s4-user-dbs.backup/. Please take a
look if you still need the data
and
-if yes: import them into the temporary s4-user-server and delete the dump-file
afterwarts.
-if no: just delete the dump-file.

The dump-files will vanish in 2 weeks from now.

Sincerly,
DaB.

--
Userpage: [[:w:de:User:DaB.]] — PGP: 2B255885

_______________________________________________
Toolserver-l mailing list ([hidden email])
https://lists.wikimedia.org/mailman/listinfo/toolserver-l
Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette

signature.asc (205 bytes) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: S4-user-databases (was: Re: z-dat-s4-a (sql-s4) crashed)

Krinkle
I do indeed want to restore these as my s4/commons-related tools are currently error-ing out with "Table 'u_krinkle.foobarcommons' doesn't exist" etc.

How do I restore them ? "$ sql u_krinkle" brings me to the u_krinkle of sql.toolserver.org, not of s4-user

--
Krinkle

2011/8/26 DaB. <[hidden email]>
Hello all,

it took a while, back I finaly managed to extract your user-databases of the
crashed s4-server.
You can find the dumps at /mnt/user-store/s4-user-dbs.backup/. Please take a
look if you still need the data
and
-if yes: import them into the temporary s4-user-server and delete the dump-file
afterwarts.
-if no: just delete the dump-file.

The dump-files will vanish in 2 weeks from now.

Sincerly,
DaB.

--
Userpage: [[:w:de:User:DaB.]] — PGP: 2B255885

_______________________________________________
Toolserver-l mailing list ([hidden email])
https://lists.wikimedia.org/mailman/listinfo/toolserver-l
Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette


_______________________________________________
Toolserver-l mailing list ([hidden email])
https://lists.wikimedia.org/mailman/listinfo/toolserver-l
Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette
Reply | Threaded
Open this post in threaded view
|

Re: S4-user-databases (was: Re: z-dat-s4-a (sql-s4) crashed)

Jan Luca
Hi,

Have you try "mysql -h sql-s4-user" to get a mysql shell?

Best regards,
Jan

Von: [hidden email]
[mailto:[hidden email]] Im Auftrag von Krinkle
Gesendet: Samstag, 27. August 2011 03:43
An: [hidden email]
Betreff: Re: [Toolserver-l] S4-user-databases (was: Re: z-dat-s4-a (sql-s4)
crashed)

I do indeed want to restore these as my s4/commons-related tools are
currently error-ing out with "Table 'u_krinkle.foobarcommons' doesn't exist"
etc.

How do I restore them ? "$ sql u_krinkle" brings me to the u_krinkle of
sql.toolserver.org, not of s4-user

--
Krinkle

2011/8/26 DaB. <[hidden email]>
Hello all,

it took a while, back I finaly managed to extract your user-databases of the
crashed s4-server.
You can find the dumps at /mnt/user-store/s4-user-dbs.backup/. Please take a
look if you still need the data
and
-if yes: import them into the temporary s4-user-server and delete the
dump-file
afterwarts.
-if no: just delete the dump-file.

The dump-files will vanish in 2 weeks from now.

Sincerly,
DaB.

--
Userpage: [[:w:de:User:DaB.]] - PGP: 2B255885

_______________________________________________
Toolserver-l mailing list ([hidden email])
https://lists.wikimedia.org/mailman/listinfo/toolserver-l
Posting guidelines for this list:
https://wiki.toolserver.org/view/Mailing_list_etiquette



_______________________________________________
Toolserver-l mailing list ([hidden email])
https://lists.wikimedia.org/mailman/listinfo/toolserver-l
Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette
Reply | Threaded
Open this post in threaded view
|

Re: S4-user-databases

DaB.-2
In reply to this post by Krinkle
Hello,
At Saturday 27 August 2011 15:16:14 DaB. wrote:
> How do I restore them ?

sorry, I forgot:

mysql -h sql-s4-user -e 'CREATE DATABASE u_krinkle;'
(if you created already a database for you that will fail, but this is no
problem)

gzcat  u_krinkle.gz|mysql -h sql-s4-user  u_krinkle
(that will decompress the file on the fly and import the tables into the
database which was created in step 1).

If you (or any other user) like, I can do the import for you; just send me a
mail or ping me in the IRC.

Sincerly,
DaB.

--
Userpage: [[:w:de:User:DaB.]] — PGP: 2B255885

_______________________________________________
Toolserver-l mailing list ([hidden email])
https://lists.wikimedia.org/mailman/listinfo/toolserver-l
Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette

signature.asc (205 bytes) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: S4-user-databases

Krinkle
2011/8/27 DaB. <[hidden email]>
Hello,
At Saturday 27 August 2011 15:16:14 DaB. wrote:
> How do I restore them ?

sorry, I forgot:

mysql -h sql-s4-user -e 'CREATE DATABASE u_krinkle;'
(if you created already a database for you that will fail, but this is no
problem)

gzcat  u_krinkle.gz|mysql -h sql-s4-user  u_krinkle
(that will decompress the file on the fly and import the tables into the
database which was created in step 1).


Thanks DaB, that worked perfect. Tools are up and running again :)

--
Krinkle


_______________________________________________
Toolserver-l mailing list ([hidden email])
https://lists.wikimedia.org/mailman/listinfo/toolserver-l
Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette