Franklin Anderson de O. Souza franklinbr
franklinbr
/ gist:c6bdce760592b9aae858
Created
July 30, 2015 15:55
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Olá Amigos ! | |
| Aqui no trabalho temos uma aplicação feita em java que as vezes se torna irresponsivo | |
| sendo necessário reiniciar a aplicação. Algumas vezes apenas reiniciar não basta, a aplicação | |
| para em algum estágio da inicialização. Quando isso acontece eu verifico no banco se existe | |
| algum locks ou ainda alguma transação pendente com: | |
| # select * from pg_prepared_xacts | |
| Geralmente nada encontro, mas quando reinicio o servidor do postgresql a aplicação java inicializa e volta funcionar normalmente. |
franklinbr
/ postgresql log
Created
August 24, 2015 19:08
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| < 2015-08-24 11:26:55.137 AMT >ERROR: base backup could not send data, aborting backup | |
| < 2015-08-24 11:26:55.137 AMT >FATAL: connection to client lost | |
| < 2015-08-24 11:36:23.262 AMT >LOG: database system was interrupted; last known up at 2015-08-24 11:26:55 AMT | |
| < 2015-08-24 11:36:23.263 AMT >LOG: creating missing WAL directory "pg_xlog/archive_status" | |
| < 2015-08-24 11:36:23.263 AMT >LOG: starting archive recovery | |
| < 2015-08-24 11:36:23.348 AMT >LOG: restored log file "000000010000000000000007" from archive | |
| < 2015-08-24 11:36:23.353 AMT >LOG: redo starts at 0/70000C8 | |
| < 2015-08-24 11:36:23.354 AMT >LOG: consistent recovery state reached at 0/7000230 | |
| < 2015-08-24 11:36:23.442 AMT >LOG: restored log file "000000010000000000000008" from archive | |
| < 2015-08-24 11:36:23.732 AMT >LOG: restored log file "000000010000000000000009" from archive |
franklinbr
/ log pg
Created
August 24, 2015 22:44
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| < 2015-08-24 18:16:05.454 AMT >LOG: MultiXact member wraparound protections are now enabled | |
| < 2015-08-24 18:16:05.455 AMT >LOG: autovacuum launcher started | |
| < 2015-08-24 18:16:05.455 AMT >LOG: database system is ready to accept connections | |
| < 2015-08-24 18:41:02.413 AMT >LOG: database system was interrupted; last known up at 2015-08-24 18:22:55 AMT | |
| < 2015-08-24 18:41:02.431 AMT >LOG: starting archive recovery | |
| < 2015-08-24 18:41:02.455 AMT >LOG: restored log file "000000010000000000000007" from archive | |
| < 2015-08-24 18:41:02.457 AMT >LOG: redo starts at 0/7000028 | |
| < 2015-08-24 18:41:02.458 AMT >LOG: consistent recovery state reached at 0/70088B8 | |
| < 2015-08-24 18:41:02.477 AMT >LOG: restored log file "000000010000000000000008" from archive | |
| < 2015-08-24 18:41:02.687 AMT >LOG: restored log file "000000010000000000000009" from archive |
franklinbr
/ postgresql log
Created
August 24, 2015 23:01
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| < 2015-08-24 18:41:02.431 AMT >LOG: starting archive recovery | |
| < 2015-08-24 18:41:02.455 AMT >LOG: restored log file "000000010000000000000007" from archive | |
| < 2015-08-24 18:41:02.457 AMT >LOG: redo starts at 0/7000028 | |
| < 2015-08-24 18:41:02.458 AMT >LOG: consistent recovery state reached at 0/70088B8 | |
| < 2015-08-24 18:41:02.477 AMT >LOG: restored log file "000000010000000000000008" from archive | |
| < 2015-08-24 18:41:02.687 AMT >LOG: restored log file "000000010000000000000009" from archive | |
| < 2015-08-24 18:41:02.907 AMT >LOG: restored log file "00000001000000000000000A" from archive | |
| < 2015-08-24 18:41:03.124 AMT >LOG: restored log file "00000001000000000000000B" from archive | |
| < 2015-08-24 18:41:03.341 AMT >LOG: restored log file "00000001000000000000000C" from archive | |
| cp: cannot stat `/backup/postgresql/archive/00000001000000000000000D': No such file or directory |
franklinbr
/ convert2html.sh
Created
August 26, 2015 19:12
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/bash | |
| if [ $# -gt 0 ] | |
| then | |
| arquivo="$1.html" | |
| cat /dev/null > ${arquivo} | |
| echo "<html>" >> ${arquivo} | |
| echo "<head>" >> ${arquivo} | |
| echo "<meta charset=\"UTF-8\">" >> ${arquivo} |
franklinbr
/ postgresql log II
Created
August 27, 2015 18:28
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| < 2015-08-25 11:28:51.667 AMT >LOG: MultiXact member wraparound protections are now enabled | |
| < 2015-08-25 11:28:51.671 AMT >LOG: database system is ready to accept connections | |
| < 2015-08-25 11:28:51.671 AMT >LOG: autovacuum launcher started | |
| < 2015-08-25 12:04:13.951 AMT >LOG: database system was interrupted; last known up at 2015-08-25 11:40:52 AMT | |
| < 2015-08-25 12:04:13.966 AMT >LOG: starting archive recovery | |
| < 2015-08-25 12:04:13.986 AMT >LOG: restored log file "000000010000000000000007" from archive | |
| < 2015-08-25 12:04:13.988 AMT >LOG: redo starts at 0/7000100 | |
| < 2015-08-25 12:04:13.989 AMT >LOG: consistent recovery state reached at 0/70001C8 | |
| < 2015-08-25 12:04:14.007 AMT >LOG: restored log file "000000010000000000000008" from archive | |
| < 2015-08-25 12:04:14.217 AMT >LOG: restored log file "000000010000000000000009" from archive |
franklinbr
/ saida log
Created
September 10, 2015 14:34
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Verificacoes Iniciais... | |
| Thu Sep 10 01:00:17 AMT 2015 - Iniciando backup - Precatorio... | |
| Thu Sep 10 01:01:26 AMT 2015 - Backup completo! | |
| Thu Sep 10 01:01:26 AMT 2015 - Iniciando compactacao - Precatorio... | |
| Precatorios.sql | |
| /root/scripts/rotina | |
| Thu Sep 10 01:07:26 AMT 2015 - Compactacao Concluida! | |
| Thu Sep 10 01:07:26 AMT 2015 - Conectando servidor sbd-backup... | |
| Thu Sep 10 01:07:26 AMT 2015 - Conexao efetuada! | |
| Thu Sep 10 01:07:26 AMT 2015 - Enviando compactacao para servidor de sbd-backup... |
franklinbr
/ blocked pg
Created
September 15, 2015 16:14
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT kl.pid AS blocking_pid, | |
| ka.usename AS blocking_user, | |
| ka.query AS blocking_query, | |
| bl.pid AS blocked_pid, | |
| a.usename AS blocked_user, | |
| a.query AS blocked_query, | |
| To_char(Age(Now(), a.query_start),'HH24h:MIm:SSs') AS age | |
| FROM pg_catalog.pg_locks bl | |
| JOIN pg_catalog.pg_stat_activity a | |
| ON bl.pid = a.pid |
franklinbr
/ sql server
Created
September 17, 2015 19:38
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT DISTINCT | |
| ' a '+SUBSTRING(CAST(run_date AS VARCHAR(10)), 7,2) + '/' + SUBSTRING(CAST(run_date AS VARCHAR(10)), 5,2)+ '/' + SUBSTRING(CAST(run_date AS VARCHAR(10)), 1,4), | |
| +' aa '+CASE run_status WHEN 1 THEN '<span class="sucesso">Sucesso</span>' WHEN 0 THEN '<span class="falhou">Falhou</span>' WHEN 3 THEN '<span class="cancelado">Cancelado</span>' END, | |
| +' bb '+sj.name 'Job', | |
| +' cc '+(SELECT Min(message) FROM msdb.dbo.sysjobhistory A WHERE A.job_id = sj.job_id AND A.run_status IN (0,3)) | |
| FROM msdb.dbo.sysjobs sj | |
| INNER JOIN msdb.dbo.sysjobsteps sjs ON sjs.job_id = sj.job_id | |
| INNER JOIN msdb.dbo.sysjobhistory sjh ON sj.job_id = sjh.job_id | |
| AND CONVERT(VARCHAR(10), sjh.run_date, 112) >= CONVERT(VARCHAR(10), GETDATE()-1, 112) | |
| --order by run_date desc; |
franklinbr
/ foobar
Created
September 25, 2015 23:16
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Backups (J:) | |
| New Volume (K:) | |
| Backup AMS 01 (L:) | |
| ProjudiPJE_Antigo (M:) | |
| Maia_antigo(N:) | |
| Helios_Antigo(O:) | |
| Backup AMS 02(P:) | |
| BkpDiversos_Antigo(Q:) | |
| Local Disk (R:) | |
| Geral (T:) |