RT Design question

RT Users
1

Hi,

Anyone knows why RT uses both a SQL database and the File System to do
its thing.
I’m worrying that since Transactions are saved on the File System and
per file, my
File System will run out of Inode before Space. Why not place such
transactions in
a Table within the database. Also, since File Systems don’t have any
integrity checks,
if some files gets removed from the File Ssytem, the database would not
learn about it
until it is too late.

Thanks

Medi Montaseri, medi@prepass.com, 408-450-7114
Prepass Inc, IT/Operations, Software Eng.

2

It’s historical. the SQL database we used to use had no support for blobs.
the thing we’re discovering as RT2 gets ported to more modern databases is
that the support that’s there in, for example, postgresql still
isn’t really that reasonable.

But yes, RT2 moves things into the database.On Mon, Mar 12, 2001 at 08:48:37AM -0800, Medi Montaseri wrote:

Hi,

Anyone knows why RT uses both a SQL database and the File System to do
its thing.
I’m worrying that since Transactions are saved on the File System and
per file, my
File System will run out of Inode before Space. Why not place such
transactions in
a Table within the database. Also, since File Systems don’t have any
integrity checks,
if some files gets removed from the File Ssytem, the database would not
learn about it
until it is too late.

Thanks

–

Medi Montaseri, medi@prepass.com, 408-450-7114
Prepass Inc, IT/Operations, Software Eng.

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

jesse reed vincent – root@eruditorum.org – jesse@fsck.com
70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90

A REAL sysadmin challenge is “resurrect five dead mailserver while so ripped
to the gills on mdma that you can’t focus on any given line of text for more
than 10 seconds continuously.”
-Nathan Mehl

3

Anyone knows why RT uses both a SQL database and the File System to do
its thing.

This was recently answered on the list.

From Jesse:

Actually, RT1 was hampered by the fact that at the time it was
written, the only free SQL database was Hughs miniSQL which didn’t
support any sort of field longer than ~256 bytes iirc.

RT2 stores things in blobs…which works fine with modern mysql
revs. The fact that postgres 7.1 doesn’t yet support 8bit-safe blobs
is rather a bummer.

— Eric