홈 탐색 도움말
로그인
PAAD
/
paad
2
0
포크 0
파일 이슈 0 풀 리퀘스트 0 위키
트리: 76fe06b0df
브랜치 태그
paad
/
pgsql-log
/
postgresql-Wed.log

postgresql-Wed.log 20 KB
히스토리 Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187 
  1. 2023-09-13 15:10:48.250 UTC [1314581] ERROR:  syntax error at or near "123" at character 1
    2. 

  2. 2023-09-13 15:10:48.250 UTC [1314581] STATEMENT:  123
    3. 

  3. 2023-09-13 15:16:54.253 UTC [1202] LOG:  checkpoint starting: time
    4. 

  4. 2023-09-13 15:16:58.601 UTC [1202] LOG:  checkpoint complete: wrote 44 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=4.317 s, sync=0.017 s, total=4.349 s; sync files=32, longest=0.007 s, average=0.001 s; distance=156 kB, estimate=367 kB
    5. 

  5. 2023-09-13 15:21:54.696 UTC [1202] LOG:  checkpoint starting: time
    6. 

  6. 2023-09-13 15:21:55.734 UTC [1202] LOG:  checkpoint complete: wrote 11 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.004 s, sync=0.016 s, total=1.038 s; sync files=11, longest=0.008 s, average=0.002 s; distance=49 kB, estimate=335 kB
    7. 

  7. 2023-09-13 15:26:54.749 UTC [1202] LOG:  checkpoint starting: time
    8. 

  8. 2023-09-13 15:26:55.073 UTC [1202] LOG:  checkpoint complete: wrote 4 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.302 s, sync=0.007 s, total=0.324 s; sync files=4, longest=0.005 s, average=0.002 s; distance=19 kB, estimate=304 kB
    9. 

  9. 2023-09-13 15:31:54.105 UTC [1202] LOG:  checkpoint starting: time
    10. 

  10. 2023-09-13 15:31:55.137 UTC [1202] LOG:  checkpoint complete: wrote 11 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.004 s, sync=0.012 s, total=1.033 s; sync files=11, longest=0.008 s, average=0.002 s; distance=51 kB, estimate=278 kB
    11. 

  11. 2023-09-13 15:36:52.177 UTC [1319833] ERROR:  column "id" does not exist at character 111
    12. 

  12. 2023-09-13 15:36:52.177 UTC [1319833] HINT:  Perhaps you meant to reference the column "log_registro.ip".
    13. 

  13. 2023-09-13 15:36:52.177 UTC [1319833] STATEMENT:  INSERT INTO "log_registro" (clave, ip, navegador, informacion, detalle) VALUES ($1, $2, $3, $4, $5) RETURNING id
    14. 

  14. 2023-09-13 15:36:54.167 UTC [1202] LOG:  checkpoint starting: time
    15. 

  15. 2023-09-13 15:36:54.595 UTC [1202] LOG:  checkpoint complete: wrote 5 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.402 s, sync=0.010 s, total=0.428 s; sync files=5, longest=0.008 s, average=0.002 s; distance=27 kB, estimate=253 kB
    16. 

  16. 2023-09-13 15:37:02.062 UTC [1319867] ERROR:  column "id" does not exist at character 111
    17. 

  17. 2023-09-13 15:37:02.062 UTC [1319867] HINT:  Perhaps you meant to reference the column "log_registro.ip".
    18. 

  18. 2023-09-13 15:37:02.062 UTC [1319867] STATEMENT:  INSERT INTO "log_registro" (clave, ip, navegador, informacion, detalle) VALUES ($1, $2, $3, $4, $5) RETURNING id
    19. 

  19. 2023-09-13 15:37:12.285 UTC [1319905] ERROR:  column "id" does not exist at character 111
    20. 

  20. 2023-09-13 15:37:12.285 UTC [1319905] HINT:  Perhaps you meant to reference the column "log_registro.ip".
    21. 

  21. 2023-09-13 15:37:12.285 UTC [1319905] STATEMENT:  INSERT INTO "log_registro" (clave, ip, navegador, informacion, detalle) VALUES ($1, $2, $3, $4, $5) RETURNING id
    22. 

  22. 2023-09-13 15:41:54.688 UTC [1202] LOG:  checkpoint starting: time
    23. 

  23. 2023-09-13 15:41:55.213 UTC [1202] LOG:  checkpoint complete: wrote 6 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.502 s, sync=0.009 s, total=0.525 s; sync files=5, longest=0.005 s, average=0.002 s; distance=1 kB, estimate=228 kB
    24. 

  24. 2023-09-13 15:42:52.137 UTC [1320925] LOG:  could not receive data from client: Connection reset by peer
    25. 

  25. 2023-09-13 15:46:54.296 UTC [1202] LOG:  checkpoint starting: time
    26. 

  26. 2023-09-13 15:46:54.521 UTC [1202] LOG:  checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.201 s, sync=0.008 s, total=0.225 s; sync files=3, longest=0.005 s, average=0.003 s; distance=7 kB, estimate=206 kB
    27. 

  27. 2023-09-13 15:47:26.636 UTC [1321052] LOG:  could not receive data from client: Connection reset by peer
    28. 

  28. 2023-09-13 15:47:26.638 UTC [1321044] LOG:  could not receive data from client: Connection reset by peer
    29. 

  29. 2023-09-13 17:25:10.856 UTC [1315055] LOG:  could not receive data from client: Connection timed out
    30. 

  30. 2023-09-13 17:46:56.136 UTC [1202] LOG:  checkpoint starting: time
    31. 

  31. 2023-09-13 17:46:56.663 UTC [1202] LOG:  checkpoint complete: wrote 6 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.502 s, sync=0.009 s, total=0.528 s; sync files=6, longest=0.006 s, average=0.002 s; distance=23 kB, estimate=188 kB
    32. 

  32. 2023-09-13 17:47:01.576 UTC [1315057] LOG:  could not receive data from client: Connection timed out
    33. 

  33. 2023-09-13 18:43:58.748 UTC [1329584] ERROR:  column "periodo.periodo_id" must appear in the GROUP BY clause or be used in an aggregate function at character 8
    34. 

  34. 2023-09-13 18:43:58.748 UTC [1329584] STATEMENT:  SELECT periodo.* FROM horario_view
    35. 

  35. 	JOIN horario_profesor USING (HORARIO_ID)
    36. 

  36. 	JOIN periodo USING (PERIODO_ID)
    37. 

  37. 	GROUP BY PERIODO_ID LIMIT 100 OFFSET 0
    38. 

  38. 2023-09-13 18:51:57.615 UTC [1202] LOG:  checkpoint starting: time
    39. 

  39. 2023-09-13 18:51:58.149 UTC [1202] LOG:  checkpoint complete: wrote 6 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.502 s, sync=0.010 s, total=0.535 s; sync files=6, longest=0.006 s, average=0.002 s; distance=2 kB, estimate=169 kB
    40. 

  40. 2023-09-13 18:56:57.193 UTC [1202] LOG:  checkpoint starting: time
    41. 

  41. 2023-09-13 18:56:57.721 UTC [1202] LOG:  checkpoint complete: wrote 6 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.502 s, sync=0.011 s, total=0.529 s; sync files=6, longest=0.008 s, average=0.002 s; distance=27 kB, estimate=155 kB
    42. 

  42. 2023-09-13 19:01:57.806 UTC [1202] LOG:  checkpoint starting: time
    43. 

  43. 2023-09-13 19:01:58.135 UTC [1202] LOG:  checkpoint complete: wrote 4 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.302 s, sync=0.010 s, total=0.329 s; sync files=4, longest=0.007 s, average=0.003 s; distance=4 kB, estimate=140 kB
    44. 

  44. 2023-09-13 19:58:05.896 UTC [1325906] LOG:  could not receive data from client: Connection timed out
    45. 

  45. 2023-09-13 19:58:05.896 UTC [1325966] LOG:  could not receive data from client: Connection timed out
    46. 

  46. 2023-09-13 19:58:05.899 UTC [1325908] LOG:  could not receive data from client: Connection timed out
    47. 

  47. 2023-09-13 20:36:58.599 UTC [1202] LOG:  checkpoint starting: time
    48. 

  48. 2023-09-13 20:36:59.033 UTC [1202] LOG:  checkpoint complete: wrote 5 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.402 s, sync=0.012 s, total=0.435 s; sync files=5, longest=0.008 s, average=0.003 s; distance=29 kB, estimate=129 kB
    49. 

  49. 2023-09-13 20:41:58.126 UTC [1202] LOG:  checkpoint starting: time
    50. 

  50. 2023-09-13 20:41:58.960 UTC [1202] LOG:  checkpoint complete: wrote 9 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.803 s, sync=0.010 s, total=0.835 s; sync files=7, longest=0.006 s, average=0.002 s; distance=49 kB, estimate=121 kB
    51. 

  51. 2023-09-13 20:46:59.040 UTC [1202] LOG:  checkpoint starting: time
    52. 

  52. 2023-09-13 20:46:59.368 UTC [1202] LOG:  checkpoint complete: wrote 4 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.302 s, sync=0.012 s, total=0.329 s; sync files=4, longest=0.009 s, average=0.003 s; distance=23 kB, estimate=111 kB
    53. 

  53. 2023-09-13 20:56:59.514 UTC [1202] LOG:  checkpoint starting: time
    54. 

  54. 2023-09-13 20:57:00.247 UTC [1202] LOG:  checkpoint complete: wrote 8 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.703 s, sync=0.013 s, total=0.733 s; sync files=6, longest=0.008 s, average=0.003 s; distance=29 kB, estimate=103 kB
    55. 

  55. 2023-09-13 21:08:36.720 UTC [1334189] ERROR:  column "reposicion_id" does not exist at character 392
    56. 

  56. 2023-09-13 21:08:36.720 UTC [1334189] QUERY:  INSERT INTO reposicion_solicitud (fecha_clase, fecha_nueva, hora_nueva, estado_reposicion_id, profesor_id,
    57. 

  57. 								  descripcion, horario_id, alumnos, es_reposicion, tipoaula_id, duracion_id, usuario_id, bloque, ciclo)
    58. 

  58. 			VALUES(p_fecha_falta, p_fecha_nueva, p_hora_nueva, p_edo, p_prof, p_desc, p_hor, p_alumnos, p_esrepo, p_aula, p_duracion, p_usr_creador, p_bloque, p_ciclo)
    59. 

  59. 			RETURNING reposicion_id
    60. 

  60. 2023-09-13 21:08:36.720 UTC [1334189] CONTEXT:  PL/pgSQL function fi_reposicion_solicitud(date,date,time without time zone,integer,integer,integer,text,integer,boolean,integer,integer,integer,integer,integer) line 6 at SQL statement
    61. 

  61. 2023-09-13 21:08:36.720 UTC [1334189] STATEMENT:  SELECT * from fi_reposicion_solicitud($1, $2, $3, $4, $5, 1, $6, $7, true, $8, $9, $10, $11, $12)
    62. 

  62. 2023-09-13 21:09:36.512 UTC [1334212] ERROR:  record "new" has no field "duracion_total"
    63. 

  63. 2023-09-13 21:09:36.512 UTC [1334212] CONTEXT:  SQL expression "NEW.hora_nueva + (NEW.duracion_total || ' minutes')::interval > '22:00'"
    64. 

  64. 	PL/pgSQL function validate_reposicion_duration() line 5 at IF
    65. 

  65. 	SQL statement "INSERT INTO reposicion_solicitud (fecha_clase, fecha_nueva, hora_nueva, estado_reposicion_id, profesor_id,
    66. 

  66. 								  descripcion, horario_id, alumnos, es_reposicion, tipoaula_id, duracion_id, usuario_id, bloque, ciclo)
    67. 

  67. 			VALUES(p_fecha_falta, p_fecha_nueva, p_hora_nueva, p_edo, p_prof, p_desc, p_hor, p_alumnos, p_esrepo, p_aula, p_duracion, p_usr_creador, p_bloque, p_ciclo)
    68. 

  68. 			RETURNING reposicion_solicitud_id"
    69. 

  69. 	PL/pgSQL function fi_reposicion_solicitud(date,date,time without time zone,integer,integer,integer,text,integer,boolean,integer,integer,integer,integer,integer) line 6 at SQL statement
    70. 

  70. 2023-09-13 21:09:36.512 UTC [1334212] STATEMENT:  SELECT * from fi_reposicion_solicitud($1, $2, $3, $4, $5, 1, $6, $7, true, $8, $9, $10, $11, $12)
    71. 

  71. 2023-09-13 21:11:59.523 UTC [1202] LOG:  checkpoint starting: time
    72. 

  72. 2023-09-13 21:12:00.258 UTC [1202] LOG:  checkpoint complete: wrote 8 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.703 s, sync=0.010 s, total=0.736 s; sync files=6, longest=0.005 s, average=0.002 s; distance=29 kB, estimate=95 kB
    73. 

  73. 2023-09-13 21:12:22.344 UTC [1330587] LOG:  could not receive data from client: Connection timed out
    74. 

  74. 2023-09-13 21:12:22.345 UTC [1330589] LOG:  could not receive data from client: Connection timed out
    75. 

  75. 2023-09-13 21:12:22.347 UTC [1330620] LOG:  could not receive data from client: Connection timed out
    76. 

  76. 2023-09-13 21:16:50.951 UTC [1334211] ERROR:  syntax error at or near "," at character 811
    77. 

  77. 2023-09-13 21:16:50.951 UTC [1334211] STATEMENT:  CREATE OR REPLACE FUNCTION public.fs_reposiciones_solicitud(p_fecha_ini date, p_fecha_fin date, p_usr integer DEFAULT NULL::integer, p_edo integer DEFAULT NULL::integer, p_esrepo boolean DEFAULT NULL::boolean)
    78. 

  78. 	 RETURNS TABLE(reposicion_id integer, horario_id integer, fecha_nueva date, hora_nueva time without time zone, descripcion character varying, profesor_id integer, profesor_clave character varying, profesor_nombre character varying, profesor_correo character varying, estado_reposicion_id integer, fecha_clase date, alumnos integer, tipoaula_id integer, tipoaula_nombre character varying, tipoaula_supervisor boolean, es_reposicion boolean, salon_id integer, duracion_total integer, materia_nombre character varying, horario_grupo character varying, horario_hora time without time zone,usuario_nombre, usuario_nombre character varying)
    79. 

  79. 	 LANGUAGE sql
    80. 

  80. 	AS $function$
    81. 

  81. 		/* Obtiene datos de reposición, se filtra por rango de fechas. Opcional: estado y si es reposicion/cambio */
    82. 

  82. 		SELECT r.reposicion_solicitud_id, r.horario_id, r.fecha_nueva, r.hora_nueva, r.descripcion,
    83. 

  83. 			r.profesor_id, p.profesor_clave, p.profesor_nombre, p.profesor_correo,
    84. 

  84. 			r.estado_reposicion_id, r.fecha_clase, r.alumnos, r.tipoaula_id, ta.tipoaula_nombre, ta.tipoaula_supervisor, r.es_reposicion,
    85. 

  85. 			r.salon_id, d.duracion_interval , m.materia_nombre, h.horario_grupo, h.horario_hora, u.usuario_nombre 
    86. 

  86. 		FROM reposicion_solicitud r
    87. 

  87. 			INNER JOIN profesor p ON r.profesor_id = p.profesor_id
    88. 

  88. 			INNER JOIN horario h ON h.horario_id = r.horario_id
    89. 

  89. 			INNER JOIN materia m ON m.materia_id = h.materia_id
    90. 

  90. 			INNER JOIN tipoaula ta ON ta.tipoaula_id = r.tipoaula_id
    91. 

  91. 			inner join duracion d on d.duracion_id = r.duracion_id
    92. 

  92. 			inner join usuario u on u.usuario_id = r.usuario_id 
    93. 

  93. 		WHERE r.fecha_nueva BETWEEN p_fecha_ini AND p_fecha_fin
    94. 

  94. 			AND r.estado_reposicion_id = COALESCE(p_edo, r.estado_reposicion_id)
    95. 

  95. 			AND r.es_reposicion = COALESCE(p_esrepo, r.es_reposicion)
    96. 

  96. 			and r.usuario_id = coalesce(p_usr,r.usuario_id)
    97. 

  97. 		ORDER BY fecha_nueva DESC, hora_nueva, profesor_nombre
    98. 

  98. 	$function$
    99. 

  99. 	
    100. 

  100. 2023-09-13 21:16:59.336 UTC [1202] LOG:  checkpoint starting: time
    101. 

  101. 2023-09-13 21:17:01.074 UTC [1202] LOG:  checkpoint complete: wrote 18 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.707 s, sync=0.014 s, total=1.738 s; sync files=13, longest=0.007 s, average=0.002 s; distance=61 kB, estimate=92 kB
    102. 

  102. 2023-09-13 21:17:10.919 UTC [1334211] ERROR:  return type mismatch in function declared to return record
    103. 

  103. 2023-09-13 21:17:10.919 UTC [1334211] DETAIL:  Final statement returns interval instead of integer at column 18.
    104. 

  104. 2023-09-13 21:17:10.919 UTC [1334211] CONTEXT:  SQL function "fs_reposiciones_solicitud"
    105. 

  105. 2023-09-13 21:17:10.919 UTC [1334211] STATEMENT:  CREATE OR REPLACE FUNCTION public.fs_reposiciones_solicitud(p_fecha_ini date, p_fecha_fin date, p_usr integer DEFAULT NULL::integer, p_edo integer DEFAULT NULL::integer, p_esrepo boolean DEFAULT NULL::boolean)
    106. 

  106. 	 RETURNS TABLE(reposicion_id integer, horario_id integer, fecha_nueva date, hora_nueva time without time zone, descripcion character varying, profesor_id integer, profesor_clave character varying, profesor_nombre character varying, profesor_correo character varying, estado_reposicion_id integer, fecha_clase date, alumnos integer, tipoaula_id integer, tipoaula_nombre character varying, tipoaula_supervisor boolean, es_reposicion boolean, salon_id integer, duracion_total integer, materia_nombre character varying, horario_grupo character varying, horario_hora time without time zone, usuario_nombre character varying)
    107. 

  107. 	 LANGUAGE sql
    108. 

  108. 	AS $function$
    109. 

  109. 		/* Obtiene datos de reposición, se filtra por rango de fechas. Opcional: estado y si es reposicion/cambio */
    110. 

  110. 		SELECT r.reposicion_solicitud_id, r.horario_id, r.fecha_nueva, r.hora_nueva, r.descripcion,
    111. 

  111. 			r.profesor_id, p.profesor_clave, p.profesor_nombre, p.profesor_correo,
    112. 

  112. 			r.estado_reposicion_id, r.fecha_clase, r.alumnos, r.tipoaula_id, ta.tipoaula_nombre, ta.tipoaula_supervisor, r.es_reposicion,
    113. 

  113. 			r.salon_id, d.duracion_interval , m.materia_nombre, h.horario_grupo, h.horario_hora, u.usuario_nombre 
    114. 

  114. 		FROM reposicion_solicitud r
    115. 

  115. 			INNER JOIN profesor p ON r.profesor_id = p.profesor_id
    116. 

  116. 			INNER JOIN horario h ON h.horario_id = r.horario_id
    117. 

  117. 			INNER JOIN materia m ON m.materia_id = h.materia_id
    118. 

  118. 			INNER JOIN tipoaula ta ON ta.tipoaula_id = r.tipoaula_id
    119. 

  119. 			inner join duracion d on d.duracion_id = r.duracion_id
    120. 

  120. 			inner join usuario u on u.usuario_id = r.usuario_id 
    121. 

  121. 		WHERE r.fecha_nueva BETWEEN p_fecha_ini AND p_fecha_fin
    122. 

  122. 			AND r.estado_reposicion_id = COALESCE(p_edo, r.estado_reposicion_id)
    123. 

  123. 			AND r.es_reposicion = COALESCE(p_esrepo, r.es_reposicion)
    124. 

  124. 			and r.usuario_id = coalesce(p_usr,r.usuario_id)
    125. 

  125. 		ORDER BY fecha_nueva DESC, hora_nueva, profesor_nombre
    126. 

  126. 	$function$
    127. 

  127. 	
    128. 

  128. 	
    129. 

  129. 2023-09-13 21:21:59.104 UTC [1202] LOG:  checkpoint starting: time
    130. 

  130. 2023-09-13 21:21:59.839 UTC [1202] LOG:  checkpoint complete: wrote 8 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.703 s, sync=0.014 s, total=0.735 s; sync files=8, longest=0.008 s, average=0.002 s; distance=38 kB, estimate=87 kB
    131. 

  131. 2023-09-13 21:36:46.968 UTC [1334883] ERROR:  function fs_reposicionesprofesor(unknown, unknown, unknown, unknown, unknown) does not exist at character 15
    132. 

  132. 2023-09-13 21:36:46.968 UTC [1334883] HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
    133. 

  133. 2023-09-13 21:36:46.968 UTC [1334883] STATEMENT:  SELECT * FROM fs_reposicionesprofesor($1, $2, $3 ,NULL, NULL)
    134. 

  134. 2023-09-13 21:47:00.190 UTC [1202] LOG:  checkpoint starting: time
    135. 

  135. 2023-09-13 21:47:01.318 UTC [1202] LOG:  checkpoint complete: wrote 12 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.104 s, sync=0.011 s, total=1.129 s; sync files=7, longest=0.007 s, average=0.002 s; distance=46 kB, estimate=83 kB
    136. 

  136. 2023-09-13 21:50:56.561 UTC [1335273] ERROR:  column r.profesor_id does not exist at character 574
    137. 

  137. 2023-09-13 21:50:56.561 UTC [1335273] HINT:  Perhaps you meant to reference the column "p.profesor_id".
    138. 

  138. 2023-09-13 21:50:56.561 UTC [1335273] QUERY:  
    139. 

  139. 	/* Obtiene datos de reposición */
    140. 

  140. 		SELECT r.reposicion_id, r.horario_id, r.fecha_nueva, r.hora_nueva, r.hora_nueva + (r.duracion_total * INTERVAL '1 minute') AS hora_nueva_fin,
    141. 

  141. 			r.descripcion, r.profesor_id, p.profesor_clave, p.profesor_nombre, p.profesor_correo,
    142. 

  142. 			r.estado_reposicion_id, r.fecha_clase, r.alumnos, r.tipoaula_id, ta.tipoaula_nombre, ta.tipoaula_supervisor, r.es_reposicion,
    143. 

  143. 			r.salon_id, r.duracion_total, m.materia_id, m.materia_nombre, h.horario_grupo, h.horario_hora,
    144. 

  144. 			er.estado_nombre, er.estado_color
    145. 

  145. 		FROM reposicion r
    146. 

  146. 			INNER JOIN profesor p ON r.profesor_id = p.profesor_id
    147. 

  147. 			INNER JOIN horario h ON h.horario_id = r.horario_id
    148. 

  148. 			INNER JOIN materia m ON m.materia_id = h.materia_id
    149. 

  149. 			INNER JOIN estado_reposicion er ON er.estado_reposicion_id = r.estado_reposicion_id  
    150. 

  150. 			INNER JOIN tipoaula ta ON ta.tipoaula_id = r.tipoaula_id
    151. 

  151. 		WHERE r.reposicion_id = COALESCE(p_rep, r.reposicion_id)
    152. 

  152. 			AND r.profesor_id = COALESCE(p_prof, r.profesor_id)
    153. 

  153. 			AND r.fecha_nueva BETWEEN COALESCE(p_fecha_ini, r.fecha_nueva) AND COALESCE(p_fecha_fin,r.fecha_nueva)
    154. 

  154. 			AND r.estado_reposicion_id = COALESCE(p_edo, r.estado_reposicion_id)
    155. 

  155. 			AND (
    156. 

  156. 				(p_jefe_carrera IS NOT NULL AND m.carrera_id IN (SELECT carrera_id FROM fs_usuario_carrera(p_jefe_carrera, NULL))
    157. 

  157. 				) OR
    158. 

  158. 				p_jefe_carrera IS NULL
    159. 

  159. 			)
    160. 

  160. 		ORDER BY fecha_nueva DESC, hora_nueva, profesor_nombre
    161. 

  161. 		LIMIT p_limit OFFSET COALESCE(p_offset, 0);
    162. 

  162. 	
    163. 

  163. 2023-09-13 21:50:56.561 UTC [1335273] CONTEXT:  SQL function "fs_reposicion" during startup
    164. 

  164. 2023-09-13 21:50:56.561 UTC [1335273] STATEMENT:  SELECT * from fs_reposicion($1, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
    165. 

  165. 2023-09-13 21:52:00.410 UTC [1202] LOG:  checkpoint starting: time
    166. 

  166. 2023-09-13 21:52:01.046 UTC [1202] LOG:  checkpoint complete: wrote 7 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.603 s, sync=0.015 s, total=0.637 s; sync files=7, longest=0.010 s, average=0.003 s; distance=42 kB, estimate=79 kB
    167. 

  167. 2023-09-13 21:57:00.144 UTC [1202] LOG:  checkpoint starting: time
    168. 

  168. 2023-09-13 21:57:01.074 UTC [1202] LOG:  checkpoint complete: wrote 10 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.904 s, sync=0.010 s, total=0.931 s; sync files=7, longest=0.005 s, average=0.002 s; distance=54 kB, estimate=76 kB
    169. 

  169. 2023-09-13 22:31:00.936 UTC [1332732] LOG:  could not receive data from client: Connection timed out
    170. 

  170. 2023-09-13 22:31:00.936 UTC [1332733] LOG:  could not receive data from client: Connection timed out
    171. 

  171. 2023-09-13 22:31:00.939 UTC [1332734] LOG:  could not receive data from client: Connection timed out
    172. 

  172. 2023-09-13 22:44:07.368 UTC [1333316] LOG:  could not receive data from client: Connection timed out
    173. 

  173. 2023-09-13 22:44:07.370 UTC [1333318] LOG:  could not receive data from client: Connection timed out
    174. 

  174. 2023-09-13 22:48:29.512 UTC [1333475] LOG:  could not receive data from client: Connection timed out
    175. 

  175. 2023-09-13 23:01:35.944 UTC [1333668] LOG:  could not receive data from client: Connection timed out
    176. 

  176. 2023-09-13 23:01:35.944 UTC [1333669] LOG:  could not receive data from client: Connection timed out
    177. 

  177. 2023-09-13 23:01:35.945 UTC [1333670] LOG:  could not receive data from client: Connection timed out
    178. 

  178. 2023-09-13 23:10:20.232 UTC [1333848] LOG:  could not receive data from client: Connection timed out
    179. 

  179. 2023-09-13 23:10:20.232 UTC [1333849] LOG:  could not receive data from client: Connection timed out
    180. 

  180. 2023-09-13 23:10:20.234 UTC [1333850] LOG:  could not receive data from client: Connection timed out
    181. 

  181. 2023-09-13 23:25:54.120 UTC [1334210] LOG:  could not receive data from client: Connection timed out
    182. 

  182. 2023-09-13 23:26:02.312 UTC [1334209] LOG:  could not receive data from client: Connection timed out
    183. 

  183. 2023-09-13 23:29:59.880 UTC [1334211] LOG:  could not receive data from client: Connection timed out
    184. 

  184. 2023-09-13 23:49:39.528 UTC [1334892] LOG:  could not receive data from client: Connection timed out
    185. 

  185. 2023-09-13 23:49:39.528 UTC [1334893] LOG:  could not receive data from client: Connection timed out
    186. 

  186. 2023-09-13 23:49:39.530 UTC [1334894] LOG:  could not receive data from client: Connection timed out
    187. 

  187. 2023-09-13 23:58:27.912 UTC [1335197] LOG:  could not receive data from client: Connection timed out
    188.