notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)

Why was the website so slow for so long?

The cause of the slowdown was a change to the ZFS dataset. In conjunction with the database server, very little caching was being done. This combination resulted in increased disk I/O as the system churned through the database. Details in the blog post which outlines the various things which changed. Many graphs.

Sanity Test Failure
Fri, 25 Feb 2011
[ 00:12 miwi ] Original commit 
p5-DBICx-MapMaker 0.03 databases files touched by this commit Perl 5 module to automatically create a DBIx::Class mapping table
pgloader 2.3.1_2 databases files touched by this commit Import CSV data and Large Object to PostgreSQL
py-MySQLdb-devel 1.2.3.c1 databases  Deleted Deprecated Expired files touched by this commit Access a MySQL database through Python
py-mssql 1.0.1_1 databases  Deleted Broken Deprecated Expired Ignore files touched by this commit Python database interface for simple MS-SQL access
py-odbc 2.1.5_1 databases  Deleted files touched by this commit ODBC connections for python
py-pg_pqueue 1.0.2_1 databases files touched by this commit PostgreSQL PQ Protocol Modules
py-psycopg2 2.3.2_1 databases files touched by this commit High performance Python adapter for PostgreSQL
py-pysqlite20 2.0.7_2 databases  Deleted Deprecated Expired files touched by this commit A DB-API v2 Python library for the SQLite 3 embedded SQL engine
py-pysqlite21 2.1.3_2 databases  Deleted Deprecated Expired files touched by this commit A DB-API v2 Python library for the SQLite 3 embedded SQL engine
py-pysqlite22 2.2.2_1 databases  Deleted Deprecated Expired files touched by this commit A DB-API v2 Python library for the SQLite 3 embedded SQL engine

(Only the first 10 of 25 ports in this commit are shown above. View all ports for this commit)
- Move over to py25+ or above
- While here kick md5 support

Sanity Test Results

databases/py-odbc:

This command (FreshPorts code 1):

make -V PORTNAME -V PKGNAME -V DESCR -V CATEGORIES -V PORTVERSION -V
PORTREVISION  -V COMMENT -V COMMENTFILE -V MAINTAINER -V EXTRACT_SUFX  -V
BUILD_DEPENDS -V RUN_DEPENDS -V LIB_DEPENDS -V FORBIDDEN -V BROKEN -V
DEPRECATED -V IGNORE  -V MASTER_PORT -V LATEST_LINK -V NO_LATEST_LINK -V
NO_PACKAGE -V PKGNAMEPREFIX -V PKGNAMESUFFIX -V PORTEPOCH  -V RESTRICTED -V
NO_CDROM -V EXPIRATION_DATE -V IS_INTERACTIVE  -V ONLY_FOR_ARCHS -V
NOT_FOR_ARCHS -V LICENSE -f /usr/home/dan/ports/databases/py-odbc/Makefile 
DISTDIR=/usr/ports/distfiles  PORTSDIR=/usr/home/dan/ports
LOCALBASE=/nonexistentlocal
2>/tmp/FreshPorts.databases.py-odbc.make-error.2011.2.25.0.15.25.22152

produced this error:

Error message is: "/usr/home/dan/ports/databases/py-odbc/Makefile", line
22: Need an operator
make: fatal errors encountered -- cannot continue

Login
User Login
Create account

Servers and bandwidth provided by
New York Internet, iXsystems, and RootBSD

This site
What is FreshPorts?
About the authors
Issues
FAQ
How big is it?
The latest upgrade!
Privacy
Blog
Contact

Search
Enter Keywords:
 
more...

Latest Vulnerabilities
chromiumMay 24
piwigoMay 23
drupal7May 22
tomcat-develMay 22
tomcat7May 22
tomcat85May 22
tomcat9May 22
unboundMay 22
zabbix3-proxyMay 20
zabbix3-serverMay 20
rubygem-actionpack52May 19
rubygem-actionpack60May 19
rubygem-actionview52May 19
rubygem-actionview60May 19
rubygem-activestorage52May 19

14 vulnerabilities affecting 165 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities

Last updated:
2020-05-25 19:05:09


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)
Traffic

Calculated hourly:
Port count 39452
Broken 80
Deprecated 625
Ignore 370
Forbidden 5
Restricted 147
No CDROM 76
Vulnerable 24
Expired 19
Set to expire 580
Interactive 0
new 24 hours 5
new 48 hours7
new 7 days40
new fortnight83
new month247



Servers and bandwidth provided by
New York Internet, iXsystems, and RootBSD
Valid HTML, CSS, and RSS.
Copyright © 2000-2020 Dan Langille. All rights reserved.